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_PAGES_INTERFACE

Line 37: UPDATE ego_pages_interface

33:
34: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
35:
36: /*Sets the Transaction_id and upper case the transaction_type for pages interface table*/
37: UPDATE ego_pages_interface
38: SET transaction_id = mtl_system_items_interface_s.nextval,
39: transaction_type = Upper(transaction_type),
40: created_by = G_USER_ID,
41: creation_date = SYSDATE,

Line 55: FROM ego_pages_interface

51: AND ( ( G_SET_PROCESS_ID IS NULL )
52: OR ( set_process_id = G_SET_PROCESS_ID ) );
53:
54: SELECT COUNT(1) INTO G_PAGES_COUNT
55: FROM ego_pages_interface
56: WHERE process_status = G_PROCESS_RECORD
57: AND ( ( G_SET_PROCESS_ID IS NULL )
58: OR ( set_process_id = G_SET_PROCESS_ID ) );
59:

Line 161: FROM ego_pages_interface

157: G_REQUEST_ID,
158: Nvl(program_application_id, G_PROG_APPL_ID),
159: Nvl(program_id, G_PROGRAM_ID),
160: Nvl(program_update_date, SYSDATE)
161: FROM ego_pages_interface
162: WHERE (transaction_type IS NULL
163: OR transaction_type NOT IN ( G_OPR_CREATE, G_OPR_UPDATE, G_OPR_DELETE, G_OPR_SYNC ))
164: AND transaction_id IS NOT NULL
165: AND process_status = G_PROCESS_RECORD

Line 169: UPDATE ego_pages_interface

165: AND process_status = G_PROCESS_RECORD
166: AND ( ( G_SET_PROCESS_ID IS NULL )
167: OR ( set_process_id = G_SET_PROCESS_ID ) );
168:
169: UPDATE ego_pages_interface
170: SET process_status = G_ERROR_RECORD,
171: last_updated_by = G_USER_ID,
172: last_update_date = SYSDATE,
173: last_update_login = G_LOGIN_ID

Line 271: UPDATE ego_pages_interface epi

267: lv_smt := 1;
268:
269: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
270:
271: UPDATE ego_pages_interface epi
272: SET classification_code = EGO_ICC_BULKLOAD_PVT.Get_Catalog_Group_Id(classification_name,'FIND_COMBINATION'),
273: last_updated_by = G_USER_ID,
274: last_update_date = SYSDATE,
275: last_update_login = G_LOGIN_ID

Line 287: UPDATE ego_pages_interface epi

283: lv_smt := 2;
284:
285: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
286:
287: UPDATE ego_pages_interface epi
288: SET page_id = (SELECT page_id
289: FROM ego_pages_b
290: WHERE object_id = G_OBJECT_ID
291: AND internal_name = epi.internal_name

Line 310: UPDATE ego_pages_interface epi

306: lv_smt := 3;
307:
308: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 3');
309:
310: UPDATE ego_pages_interface epi
311: SET transaction_type = decode(page_id,NULL,G_OPR_CREATE,G_OPR_UPDATE),
312: last_updated_by = G_USER_ID,
313: last_update_date = SYSDATE,
314: last_update_login = G_LOGIN_ID

Line 540: UPDATE ego_pages_interface epi

536: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
537:
538: x_return_status := G_RET_STS_SUCCESS;
539:
540: UPDATE ego_pages_interface epi
541: SET (internal_name, classification_code) = (SELECT internal_name, classification_code
542: FROM ego_pages_v
543: WHERE page_id = epi.page_id),
544: last_updated_by = G_USER_ID,

Line 557: UPDATE ego_pages_interface epi

553: lv_smt := 2;
554:
555: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
556:
557: UPDATE ego_pages_interface epi
558: SET classification_name = (SELECT icc_kfv.concatenated_segments
559: FROM mtl_item_catalog_groups_kfv icc_kfv
560: WHERE icc_kfv.item_catalog_group_id = epi.classification_code),
561: last_updated_by = G_USER_ID,

Line 1420: FROM ego_pages_interface epi

1416: G_REQUEST_ID,
1417: Nvl(program_application_id, G_PROG_APPL_ID),
1418: Nvl(program_id, G_PROGRAM_ID),
1419: Nvl(program_update_date, SYSDATE)
1420: FROM ego_pages_interface epi
1421: WHERE (classification_code IS NULL OR classification_name IS NULL)
1422: AND transaction_id IS NOT NULL
1423: AND process_status = G_PROCESS_RECORD
1424: AND ( ( G_SET_PROCESS_ID IS NULL )

Line 1427: UPDATE ego_pages_interface

1423: AND process_status = G_PROCESS_RECORD
1424: AND ( ( G_SET_PROCESS_ID IS NULL )
1425: OR ( set_process_id = G_SET_PROCESS_ID ) );
1426:
1427: UPDATE ego_pages_interface
1428: SET process_status = G_ERROR_RECORD,
1429: last_updated_by = G_USER_ID,
1430: last_update_date = SYSDATE,
1431: last_update_login = G_LOGIN_ID

Line 1487: FROM ego_pages_interface epi

1483: G_REQUEST_ID,
1484: Nvl(program_application_id, G_PROG_APPL_ID),
1485: Nvl(program_id, G_PROGRAM_ID),
1486: Nvl(program_update_date, SYSDATE)
1487: FROM ego_pages_interface epi
1488: WHERE (page_id IS NULL OR internal_name IS NULL)
1489: AND transaction_type <> G_OPR_CREATE
1490: AND transaction_id IS NOT NULL
1491: AND process_status = G_PROCESS_RECORD

Line 1495: UPDATE ego_pages_interface

1491: AND process_status = G_PROCESS_RECORD
1492: AND ( ( G_SET_PROCESS_ID IS NULL )
1493: OR ( set_process_id = G_SET_PROCESS_ID ) );
1494:
1495: UPDATE ego_pages_interface
1496: SET process_status = G_ERROR_RECORD,
1497: last_updated_by = G_USER_ID,
1498: last_update_date = SYSDATE,
1499: last_update_login = G_LOGIN_ID

Line 1556: FROM ego_pages_interface epi

1552: G_REQUEST_ID,
1553: Nvl(program_application_id, G_PROG_APPL_ID),
1554: Nvl(program_id, G_PROGRAM_ID),
1555: Nvl(program_update_date, SYSDATE)
1556: FROM ego_pages_interface epi
1557: WHERE EXISTS (SELECT 1
1558: FROM EGO_PAGES_B
1559: WHERE internal_name = epi.internal_name
1560: AND classification_code = epi.classification_code)

Line 1567: UPDATE ego_pages_interface epi

1563: AND process_status = G_PROCESS_RECORD
1564: AND ( ( G_SET_PROCESS_ID IS NULL )
1565: OR ( set_process_id = G_SET_PROCESS_ID ) );
1566:
1567: UPDATE ego_pages_interface epi
1568: SET process_status = G_ERROR_RECORD,
1569: last_updated_by = G_USER_ID,
1570: last_update_date = SYSDATE,
1571: last_update_login = G_LOGIN_ID

Line 1631: FROM ego_pages_interface epi

1627: G_REQUEST_ID,
1628: Nvl(program_application_id, G_PROG_APPL_ID),
1629: Nvl(program_id, G_PROGRAM_ID),
1630: Nvl(program_update_date, SYSDATE)
1631: FROM ego_pages_interface epi
1632: WHERE EXISTS (SELECT 1
1633: FROM ego_pages_b
1634: WHERE classification_code = epi.classification_code
1635: AND SEQUENCE = epi.SEQUENCE

Line 1642: UPDATE ego_pages_interface epi

1638: AND process_status = G_PROCESS_RECORD
1639: AND ( ( G_SET_PROCESS_ID IS NULL )
1640: OR ( set_process_id = G_SET_PROCESS_ID ) );
1641:
1642: UPDATE ego_pages_interface epi
1643: SET process_status = G_ERROR_RECORD,
1644: last_updated_by = G_USER_ID,
1645: last_update_date = SYSDATE,
1646: last_update_login = G_LOGIN_ID

Line 2333: /Cursor to load plsql table from ego_pages_interface table/

2329: PROCEDURE import_pg_intf ( p_set_process_id IN VARCHAR2,
2330: x_return_status OUT NOCOPY VARCHAR2,
2331: x_return_msg OUT NOCOPY VARCHAR2)
2332: IS
2333: /*Cursor to load plsql table from ego_pages_interface table*/
2334: CURSOR c_pg IS
2335: SELECT *
2336: FROM ego_pages_interface
2337: WHERE process_status = G_PROCESS_RECORD

Line 2336: FROM ego_pages_interface

2332: IS
2333: /*Cursor to load plsql table from ego_pages_interface table*/
2334: CURSOR c_pg IS
2335: SELECT *
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*/

Line 3014: UPDATE ego_pages_interface

3010: trans_id(i) := p_pg_tbl(i).transaction_id;
3011: END LOOP;
3012:
3013: FORALL i IN p_pg_tbl.first..p_pg_tbl.last
3014: UPDATE ego_pages_interface
3015: SET ROW = P_pg_tbl(i)
3016: WHERE transaction_id = trans_id(i);
3017:
3018: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Exit update_intf_pages');

Line 3083: DELETE FROM ego_pages_interface

3079: write_debug('ego_pages_bulkload_pvt.'||lv_proc||' - '||'Entering delete_processed_pages');
3080:
3081: x_return_status := G_RET_STS_SUCCESS;
3082:
3083: DELETE FROM ego_pages_interface
3084: WHERE process_status = G_SUCCESS_RECORD
3085: AND (x_set_process_id IS NULL
3086: OR set_process_id = x_set_process_id);
3087: