APPS.BIS_CUSTOMIZATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 4

procedure insert_custom_registry is

 cursor c_custom_registry is
 select property_name from ak_custom_registry
 where property_name in ('ATTRIBUTE_LABEL_LONG','NODE_DISPLAY_FLAG','DISPLAY_SEQUENCE','ORDER_DIRECTION','INITIAL_SORT_SEQUENCE');

Line: 29

     insert into ak_custom_registry(customization_level_id,custom_level,property_name
           ,translatable,created_by,creation_date,last_updated_by ,last_update_date
           ,last_update_login)
     values(60,'REGION_ITEM', 'ATTRIBUTE_LABEL_LONG','Y',1,SYSDATE,1,SYSDATE,1);

Line: 35

     insert into ak_custom_registry(customization_level_id,custom_level,property_name
           ,translatable,created_by,creation_date,last_updated_by ,last_update_date
           ,last_update_login)
     values(60,'REGION_ITEM','NODE_DISPLAY_FLAG','N',1,SYSDATE,1,SYSDATE,1);

Line: 41

     insert into ak_custom_registry(customization_level_id,custom_level,property_name
           ,translatable,created_by,creation_date,last_updated_by ,last_update_date
           ,last_update_login)
     values(60,'REGION_ITEM','DISPLAY_SEQUENCE','N',1,SYSDATE,1,SYSDATE,1);

Line: 47

     insert into ak_custom_registry(customization_level_id,custom_level,property_name
           ,translatable,created_by,creation_date,last_updated_by ,last_update_date
           ,last_update_login)
     values(60,'REGION_ITEM','ORDER_DIRECTION','N',1,SYSDATE,1,SYSDATE,1);

Line: 53

     insert into ak_custom_registry(customization_level_id,custom_level,property_name
           ,translatable,created_by,creation_date,last_updated_by ,last_update_date
           ,last_update_login)
     values(60,'REGION_ITEM','INITIAL_SORT_SEQUENCE','N',1,SYSDATE,1,SYSDATE,1);

Line: 58

end insert_custom_registry;

Line: 60

procedure delete_region_item is
begin

  delete from ak_region_items
  where attribute_code='ICX_STANDARD_FOOTER'
  and region_code='BISPRINTPAGE';

Line: 67

  delete from ak_region_items_tl
  where attribute_code='ICX_STANDARD_FOOTER'
  and region_code='BISPRINTPAGE';

Line: 71

end delete_region_item;