[Home] [Help]
386: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
387:
388: UPDATE ego_page_entries_interface epi
389: SET old_attr_group_id = (SELECT attr_group_id
390: FROM ego_fnd_dsc_flx_ctx_ext
391: WHERE application_id = (SELECT application_id
392: FROM fnd_application
393: WHERE application_short_name = 'EGO')
394: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/
408: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
409:
410: UPDATE ego_page_entries_interface epi
411: SET new_attr_group_id = (SELECT attr_group_id
412: FROM ego_fnd_dsc_flx_ctx_ext
413: WHERE application_id = (SELECT application_id
414: FROM fnd_application
415: WHERE application_short_name = 'EGO')
416: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/
1171: /*Sets the old_attr_group_id*/
1172: IF (p_ent_tbl(i).old_attr_group_id IS NULL AND p_ent_tbl(i).old_attr_group_name IS NOT NULL) THEN
1173: BEGIN
1174: SELECT attr_group_id INTO p_ent_tbl(i).old_attr_group_id
1175: FROM ego_fnd_dsc_flx_ctx_ext
1176: WHERE application_id = (SELECT application_id
1177: FROM fnd_application
1178: WHERE application_short_name = 'EGO')
1179: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/
1208: /*Sets the new_attr_group_id*/
1209: IF (p_ent_tbl(i).new_attr_group_id IS NULL AND p_ent_tbl(i).new_attr_group_name IS NOT NULL) THEN
1210: BEGIN
1211: SELECT attr_group_id INTO p_ent_tbl(i).new_attr_group_id
1212: FROM ego_fnd_dsc_flx_ctx_ext
1213: WHERE application_id = (SELECT application_id
1214: FROM fnd_application
1215: WHERE application_short_name = 'EGO')
1216: AND descriptive_flexfield_name IN ('EGO_ITEMMGMT_GROUP','EGO_MASTER_ITEMS') /*Added EGO_MASTER_ITEMS for bug 9950697*/