Application Item G_DATE_FORMAT is missing in Public App about apex-blog HOT 5 CLOSED

update blog_settings set attribute_name = 'G_APP_DATE_FORMAT' where attribute_name = 'G_DATE_FORMAT';

delete from blog_init_items;

insert into blog_init_items(is_active, application_id, item_name)
select 1              as is_active
  ,ai.application_id  as application_id
  ,ai.item_name       as item_name
from apex_application_items ai
join blog_settings s
  on ai.item_name = s.attribute_name
where 1 = 1
  and ai.application_id = blog_util.get_attribute_value( 'G_PUB_APP_ID' )
  union all
select 1              as is_active
  ,pi.application_id  as application_id
  ,pi.item_name       as item_namee
from apex_application_page_items pi
join blog_settings s
  on pi.item_name = s.attribute_name
where 1 = 1
  and pi.application_id = blog_util.get_attribute_value( 'G_PUB_APP_ID' )
  union all
select 1              as is_active
  ,ai.application_id  as application_id
  ,ai.item_name       as item_name
from apex_application_items ai
join blog_settings s
  on ai.item_name = s.attribute_name
where 1 = 1
  and ai.application_id = blog_util.get_attribute_value( 'G_ADMIN_APP_ID' )
  union all
select 1              as is_active
  ,pi.application_id  as application_id
  ,pi.item_name       as item_namee
from apex_application_page_items pi
join blog_settings s
  on pi.item_name = s.attribute_name
where 1 = 1
  and pi.application_id = blog_util.get_attribute_value( 'G_ADMIN_APP_ID' )
;

commit;