eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_PAGES_BULKLOAD_PVT dependencies on EGO_PAGE_ENTRIES_INTERFACE

Line 65: UPDATE ego_page_entries_interface

61:
62: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
63:
64: /*Sets the Transaction_id and upper case the transaction_type for page entries interface table*/
65: UPDATE ego_page_entries_interface
66: SET transaction_id = mtl_system_items_interface_s.nextval,
67: transaction_type = Upper(transaction_type),
68: created_by = G_USER_ID,
69: creation_date = SYSDATE,

Line 83: FROM ego_page_entries_interface

79: AND ( ( G_SET_PROCESS_ID IS NULL )
80: OR ( set_process_id = G_SET_PROCESS_ID ) );
81:
82: SELECT COUNT(1) INTO G_PAGE_ENTRIES_COUNT
83: FROM ego_page_entries_interface
84: WHERE process_status = G_PROCESS_RECORD
85: AND ( ( G_SET_PROCESS_ID IS NULL )
86: OR ( set_process_id = G_SET_PROCESS_ID ) );
87:

Line 222: FROM ego_page_entries_interface

218: G_REQUEST_ID,
219: Nvl(program_application_id, G_PROG_APPL_ID),
220: Nvl(program_id, G_PROGRAM_ID),
221: Nvl(program_update_date, SYSDATE)
222: FROM ego_page_entries_interface
223: WHERE (transaction_type IS NULL
224: OR transaction_type NOT IN ( G_OPR_CREATE, G_OPR_UPDATE, G_OPR_SYNC, G_OPR_DELETE ))
225: AND transaction_id IS NOT NULL
226: AND process_status = G_PROCESS_RECORD

Line 230: UPDATE ego_page_entries_interface

226: AND process_status = G_PROCESS_RECORD
227: AND ( ( G_SET_PROCESS_ID IS NULL )
228: OR ( set_process_id = G_SET_PROCESS_ID ) );
229:
230: UPDATE ego_page_entries_interface
231: SET process_status = G_ERROR_RECORD,
232: last_updated_by = G_USER_ID,
233: last_update_date = SYSDATE,
234: last_update_login = G_LOGIN_ID

Line 350: UPDATE ego_page_entries_interface epi

346: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
347:
348: x_return_status := G_RET_STS_SUCCESS;
349:
350: UPDATE ego_page_entries_interface epi
351: SET classification_code = EGO_ICC_BULKLOAD_PVT.Get_Catalog_Group_Id(classification_name,'FIND_COMBINATION'),
352: last_updated_by = G_USER_ID,
353: last_update_date = SYSDATE,
354: last_update_login = G_LOGIN_ID

Line 366: UPDATE ego_page_entries_interface epi

362: lv_smt := 2;
363:
364: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
365: --pnagasur: Modified for Bug 13022991
366: UPDATE ego_page_entries_interface epi
367: SET page_id = (SELECT page_id
368: FROM ego_pages_b
369: WHERE object_id = G_OBJECT_ID
370: AND internal_name = epi.internal_name

Line 388: UPDATE ego_page_entries_interface epi

384: lv_smt := 3;
385:
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

Line 410: UPDATE ego_page_entries_interface epi

406: lv_smt := 4;
407:
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

Line 432: UPDATE ego_page_entries_interface epi

428:
429: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
430:
431: /*Sets the old_association_id*/
432: UPDATE ego_page_entries_interface epi
433: SET old_association_id = (SELECT association_id
434: FROM EGO_OBJ_AG_ASSOCS_B
435: WHERE classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID
436: FROM EGO_ITEM_CAT_DENORM_HIER

Line 457: UPDATE ego_page_entries_interface epi

453:
454: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 6');
455:
456: /*Sets the new_association_id*/
457: UPDATE ego_page_entries_interface epi
458: SET new_association_id = (SELECT association_id
459: FROM EGO_OBJ_AG_ASSOCS_B
460: WHERE classification_code IN ( SELECT PARENT_CATALOG_GROUP_ID
461: FROM EGO_ITEM_CAT_DENORM_HIER

Line 482: UPDATE ego_page_entries_interface epi

478: lv_smt := 7;
479:
480: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 7');
481:
482: UPDATE ego_page_entries_interface epi
483: SET transaction_type = G_OPR_UPDATE,
484: last_updated_by = G_USER_ID,
485: last_update_date = SYSDATE,
486: last_update_login = G_LOGIN_ID

Line 501: UPDATE ego_page_entries_interface epi

497: lv_smt := 8;
498:
499: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 8');
500:
501: UPDATE ego_page_entries_interface epi
502: SET transaction_type = G_OPR_CREATE,
503: last_updated_by = G_USER_ID,
504: last_update_date = SYSDATE,
505: last_update_login = G_LOGIN_ID

Line 600: UPDATE ego_page_entries_interface epi

596: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
597:
598: x_return_status := G_RET_STS_SUCCESS;
599: --pnagasur : Modified for Bug 13022991
600: UPDATE ego_page_entries_interface epi
601: SET ( internal_name ) = (SELECT internal_name
602: FROM ego_pages_b
603: WHERE page_id = epi.page_id),
604: last_updated_by = G_USER_ID,

Line 617: UPDATE ego_page_entries_interface epi

613: lv_smt := 2;
614:
615: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
616:
617: UPDATE ego_page_entries_interface epi
618: SET classification_name = (SELECT icc_kfv.concatenated_segments
619: FROM mtl_item_catalog_groups_kfv icc_kfv
620: WHERE icc_kfv.item_catalog_group_id = epi.classification_code),
621: last_updated_by = G_USER_ID,

Line 634: UPDATE ego_page_entries_interface epi

630: lv_smt := 3;
631:
632: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
633:
634: UPDATE ego_page_entries_interface epi
635: SET ( old_attr_group_id, old_attr_group_name ) = (SELECT attr_group_id,
636: attr_group_name
637: FROM ego_obj_attr_grp_assocs_v
638: WHERE association_id = epi.old_association_id),

Line 652: UPDATE ego_page_entries_interface epi

648: lv_smt := 4;
649:
650: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 4');
651:
652: UPDATE ego_page_entries_interface epi
653: SET ( new_attr_group_id, new_attr_group_name ) = (SELECT attr_group_id,
654: attr_group_name
655: FROM ego_obj_attr_grp_assocs_v
656: WHERE association_id = epi.new_association_id),

Line 670: UPDATE ego_page_entries_interface epi

666: lv_smt := 5;
667:
668: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
669:
670: UPDATE ego_page_entries_interface epi
671: SET ( old_association_id, old_attr_group_name ) = (SELECT association_id,
672: attr_group_name
673: FROM ego_obj_attr_grp_assocs_v
674: WHERE attr_group_id = epi.old_attr_group_id

Line 691: UPDATE ego_page_entries_interface epi

687: lv_smt := 5;
688:
689: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 5');
690:
691: UPDATE ego_page_entries_interface epi
692: SET ( new_association_id, new_attr_group_name ) = (SELECT association_id,
693: attr_group_name
694: FROM ego_obj_attr_grp_assocs_v
695: WHERE attr_group_id = epi.new_attr_group_id),

Line 1734: FROM ego_page_entries_interface epei

1730: G_REQUEST_ID,
1731: Nvl(program_application_id, G_PROG_APPL_ID),
1732: Nvl(program_id, G_PROGRAM_ID),
1733: Nvl(program_update_date, SYSDATE)
1734: FROM ego_page_entries_interface epei
1735: WHERE NOT EXISTS (SELECT 1
1736: FROM ego_page_entries_b
1737: WHERE page_id = epei.page_id
1738: AND association_id = epei.old_association_id

Line 1746: UPDATE ego_page_entries_interface epi

1742: AND process_status = G_PROCESS_RECORD
1743: AND ( ( G_SET_PROCESS_ID IS NULL )
1744: OR ( set_process_id = G_SET_PROCESS_ID ) );
1745:
1746: UPDATE ego_page_entries_interface epi
1747: SET process_status = G_ERROR_RECORD,
1748: last_updated_by = G_USER_ID,
1749: last_update_date = SYSDATE,
1750: last_update_login = G_LOGIN_ID

Line 1811: FROM ego_page_entries_interface epi

1807: G_REQUEST_ID,
1808: Nvl(program_application_id, G_PROG_APPL_ID),
1809: Nvl(program_id, G_PROGRAM_ID),
1810: Nvl(program_update_date, SYSDATE)
1811: FROM ego_page_entries_interface epi
1812: WHERE EXISTS (SELECT 1
1813: FROM ego_page_entries_b
1814: WHERE page_id = epi.page_id
1815: AND sequence = epi.sequence)

Line 1822: UPDATE ego_page_entries_interface epi

1818: AND process_status = G_PROCESS_RECORD
1819: AND ( ( G_SET_PROCESS_ID IS NULL )
1820: OR ( set_process_id = G_SET_PROCESS_ID ) );
1821:
1822: UPDATE ego_page_entries_interface epi
1823: SET process_status = G_ERROR_RECORD,
1824: last_updated_by = G_USER_ID,
1825: last_update_date = SYSDATE,
1826: last_update_login = G_LOGIN_ID

Line 2340: /Cursor to load plsql table from ego_page_entries_interface table/

2336: FROM ego_pages_interface
2337: WHERE process_status = G_PROCESS_RECORD
2338: AND (p_set_process_id IS NULL
2339: OR set_process_id = p_set_process_id);
2340: /*Cursor to load plsql table from ego_page_entries_interface table*/
2341: CURSOR c_ent IS
2342: SELECT *
2343: FROM ego_page_entries_interface
2344: WHERE process_status = G_PROCESS_RECORD

Line 2343: FROM ego_page_entries_interface

2339: OR set_process_id = p_set_process_id);
2340: /*Cursor to load plsql table from ego_page_entries_interface table*/
2341: CURSOR c_ent IS
2342: SELECT *
2343: FROM ego_page_entries_interface
2344: WHERE process_status = G_PROCESS_RECORD
2345: AND (p_set_process_id IS NULL
2346: OR set_process_id = p_set_process_id);
2347:

Line 3050: UPDATE ego_page_entries_interface

3046: trans_id(i) := p_ent_tbl(i).transaction_id;
3047: END LOOP;
3048:
3049: FORALL i IN p_ent_tbl.first..p_ent_tbl.last
3050: UPDATE ego_page_entries_interface
3051: SET ROW = P_ent_tbl(i)
3052: WHERE transaction_id = trans_id(i);
3053:
3054: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit update_intf_pg_entries');

Line 3115: DELETE FROM ego_page_entries_interface

3111: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering delete_processed_pg_entries');
3112:
3113: x_return_status := G_RET_STS_SUCCESS;
3114:
3115: DELETE FROM ego_page_entries_interface
3116: WHERE process_status = G_SUCCESS_RECORD
3117: AND (x_set_process_id IS NULL
3118: OR set_process_id = x_set_process_id);
3119: