845: from AR_BPA_CONTENT_AREAS_TL
846: where CONTENT_AREA_ID = cabrec.CONTENT_AREA_ID;
847: END LOOP;
848:
849: /* insert item_id of original template into ar_bpa_area_items_map table */
850: insert into ar_bpa_area_items
851: ( area_item_id,
852: template_id,
853: parent_area_code,
846: where CONTENT_AREA_ID = cabrec.CONTENT_AREA_ID;
847: END LOOP;
848:
849: /* insert item_id of original template into ar_bpa_area_items_map table */
850: insert into ar_bpa_area_items
851: ( area_item_id,
852: template_id,
853: parent_area_code,
854: display_level,
861: creation_date,
862: last_updated_by,
863: last_update_date,
864: last_update_login)
865: select ar_bpa_area_items_s.nextval,
866: p_dup_template_id,
867: ca.parent_area_code,
868: ca.display_level,
869: decode(item.seeded_application_id,222,-1, item.seeded_application_id),