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_AG_BULKLOAD_PVT dependencies on EGO_ATTR_GROUPS_INTERFACE

Line 33: UPDATE ego_attr_groups_interface

29:
30: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
31:
32: /*Sets the Transaction_id and upper case the transaction_type*/
33: UPDATE ego_attr_groups_interface
34: SET transaction_id = mtl_system_items_interface_s.nextval,
35: transaction_type = Upper(transaction_type),
36: application_id = g_ego_application_id,
37: created_by = G_USER_ID,

Line 52: FROM ego_attr_groups_interface

48: AND ((G_SET_PROCESS_ID IS NULL)
49: OR (set_process_id = G_SET_PROCESS_ID));
50:
51: SELECT COUNT(1) INTO G_AG_COUNT
52: FROM ego_attr_groups_interface
53: WHERE process_status = G_PROCESS_RECORD
54: AND ((G_SET_PROCESS_ID IS NULL)
55: OR (set_process_id = G_SET_PROCESS_ID));
56:

Line 188: FROM ego_attr_groups_interface

184: G_REQUEST_ID,
185: Nvl(program_application_id,G_PROG_APPL_ID),
186: Nvl(program_id,G_PROGRAM_ID),
187: Nvl(program_update_date,SYSDATE)
188: FROM ego_attr_groups_interface
189: WHERE (transaction_type IS NULL
190: OR transaction_type NOT IN (G_OPR_CREATE,G_OPR_UPDATE,G_OPR_DELETE,G_OPR_SYNC))
191: AND transaction_id IS NOT NULL
192: AND process_status = G_PROCESS_RECORD

Line 196: UPDATE ego_attr_groups_interface

192: AND process_status = G_PROCESS_RECORD
193: AND ((G_SET_PROCESS_ID IS NULL)
194: OR (set_process_id = G_SET_PROCESS_ID));
195:
196: UPDATE ego_attr_groups_interface
197: SET process_status = G_ERROR_RECORD,
198: last_updated_by = G_USER_ID,
199: last_update_date = SYSDATE,
200: last_update_login = G_LOGIN_ID

Line 414: FROM ego_attr_groups_interface eagi

410: G_REQUEST_ID,
411: Nvl(program_application_id,G_PROG_APPL_ID),
412: Nvl(program_id,G_PROGRAM_ID),
413: Nvl(program_update_date,SYSDATE)
414: FROM ego_attr_groups_interface eagi
415: WHERE (attr_group_name IS NULL
416: OR attr_group_disp_name IS NULL)
417: AND transaction_id IS NOT NULL
418: AND transaction_type = G_OPR_CREATE

Line 423: UPDATE ego_attr_groups_interface

419: AND process_status = G_PROCESS_RECORD
420: AND ((G_SET_PROCESS_ID IS NULL)
421: OR (set_process_id = G_SET_PROCESS_ID));
422:
423: UPDATE ego_attr_groups_interface
424: SET process_status = G_ERROR_RECORD,
425: last_updated_by = G_USER_ID,
426: last_update_date = SYSDATE,
427: last_update_login = G_LOGIN_ID

Line 485: FROM ego_attr_groups_interface eagi

481: G_REQUEST_ID,
482: Nvl(program_application_id,G_PROG_APPL_ID),
483: Nvl(program_id,G_PROGRAM_ID),
484: Nvl(program_update_date,SYSDATE)
485: FROM ego_attr_groups_interface eagi
486: WHERE attr_group_type <> G_EGO_ITEMMGMT_GROUP
487: AND transaction_id IS NOT NULL
488: AND process_status = G_PROCESS_RECORD
489: AND ((G_SET_PROCESS_ID IS NULL)

Line 492: UPDATE ego_attr_groups_interface

488: AND process_status = G_PROCESS_RECORD
489: AND ((G_SET_PROCESS_ID IS NULL)
490: OR (set_process_id = G_SET_PROCESS_ID));
491:
492: UPDATE ego_attr_groups_interface
493: SET process_status = G_ERROR_RECORD,
494: last_updated_by = G_USER_ID,
495: last_update_date = SYSDATE,
496: last_update_login = G_LOGIN_ID

Line 692: FROM ego_attr_groups_interface eagi

688: G_REQUEST_ID,
689: Nvl(program_application_id,G_PROG_APPL_ID),
690: Nvl(program_id,G_PROGRAM_ID),
691: Nvl(program_update_date,SYSDATE)
692: FROM ego_attr_groups_interface eagi
693: WHERE (attr_group_id IS NULL
694: OR attr_group_name IS NULL)
695: AND transaction_id IS NOT NULL
696: AND transaction_type IN (G_OPR_UPDATE,G_OPR_DELETE)

Line 701: UPDATE ego_attr_groups_interface

697: AND process_status = G_PROCESS_RECORD
698: AND ((G_SET_PROCESS_ID IS NULL)
699: OR (set_process_id = G_SET_PROCESS_ID));
700:
701: UPDATE ego_attr_groups_interface
702: SET process_status = G_ERROR_RECORD,
703: last_updated_by = G_USER_ID,
704: last_update_date = SYSDATE,
705: last_update_login = G_LOGIN_ID

Line 769: FROM ego_attr_groups_interface eagi

765: WHERE (eagdi.attr_group_id IS NULL
766: OR eagdi.attr_group_name IS NULL)
767: AND eagdi.transaction_id IS NOT NULL
768: AND NOT EXISTS (SELECT 1
769: FROM ego_attr_groups_interface eagi
770: WHERE eagi.attr_group_name = eagdi.attr_group_name
771: AND eagi.transaction_type = G_OPR_CREATE
772: AND eagi.process_status = G_PROCESS_RECORD)
773: AND eagdi.process_status = G_PROCESS_RECORD

Line 786: FROM ego_attr_groups_interface eagi

782: WHERE (eagdi.attr_group_id IS NULL
783: OR eagdi.attr_group_name IS NULL)
784: AND eagdi.transaction_id IS NOT NULL
785: AND NOT EXISTS (SELECT 1
786: FROM ego_attr_groups_interface eagi
787: WHERE eagi.attr_group_name = eagdi.attr_group_name
788: AND eagi.transaction_type = G_OPR_CREATE
789: AND eagi.process_status = G_PROCESS_RECORD)
790: AND eagdi.process_status = G_PROCESS_RECORD

Line 845: FROM ego_attr_groups_interface eagi

841: G_REQUEST_ID,
842: Nvl(program_application_id,G_PROG_APPL_ID),
843: Nvl(program_id,G_PROGRAM_ID),
844: Nvl(program_update_date,SYSDATE)
845: FROM ego_attr_groups_interface eagi
846: WHERE EXISTS (SELECT 1
847: FROM EGO_FND_DSC_FLX_CTX_EXT efdfce
848: WHERE efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = eagi.attr_group_name
849: AND efdfce.DESCRIPTIVE_FLEXFIELD_NAME = G_EGO_ITEMMGMT_GROUP

Line 857: UPDATE ego_attr_groups_interface eagi

853: AND eagi.process_status = G_PROCESS_RECORD
854: AND ((G_SET_PROCESS_ID IS NULL)
855: OR (set_process_id = G_SET_PROCESS_ID));
856:
857: UPDATE ego_attr_groups_interface eagi
858: SET eagi.process_status = G_ERROR_RECORD,
859: last_updated_by = G_USER_ID,
860: last_update_date = SYSDATE,
861: last_update_login = G_LOGIN_ID

Line 924: FROM ego_attr_groups_interface eagi

920: G_REQUEST_ID,
921: Nvl(program_application_id,G_PROG_APPL_ID),
922: Nvl(program_id,G_PROGRAM_ID),
923: Nvl(program_update_date,SYSDATE)
924: FROM ego_attr_groups_interface eagi
925: WHERE NOT EXISTS (SELECT 1
926: FROM ego_attr_groups_dl_interface eagdi
927: WHERE eagdi.attr_group_name = eagi.attr_group_name
928: AND eagdi.transaction_type = eagi.transaction_type

Line 938: UPDATE ego_attr_groups_interface eagi

934: AND eagi.process_status = G_PROCESS_RECORD
935: AND ((G_SET_PROCESS_ID IS NULL)
936: OR (set_process_id = G_SET_PROCESS_ID));
937:
938: UPDATE ego_attr_groups_interface eagi
939: SET eagi.process_status = G_ERROR_RECORD,
940: last_updated_by = G_USER_ID,
941: last_update_date = SYSDATE,
942: last_update_login = G_LOGIN_ID

Line 1165: FROM ego_attr_groups_interface

1161: AND eagd.variant = 'Y'
1162: /*Added for bug 9719196*/
1163: UNION ALL
1164: SELECT 1
1165: FROM ego_attr_groups_interface
1166: WHERE attr_group_name = eagdi.attr_group_name
1167: AND transaction_type = G_OPR_CREATE
1168: AND variant = 'Y'
1169: AND process_status = G_PROCESS_RECORD

Line 1192: FROM ego_attr_groups_interface

1188: AND eagd.variant = 'Y'
1189: /*Added for bug 9719196*/
1190: UNION ALL
1191: SELECT 1
1192: FROM ego_attr_groups_interface
1193: WHERE attr_group_name = eagdi.attr_group_name
1194: AND transaction_type = G_OPR_CREATE
1195: AND variant = 'Y'
1196: AND process_status = G_PROCESS_RECORD

Line 1594: FROM ego_attr_groups_interface

1590: AND efdfce.APPLICATION_ID = G_EGO_APPLICATION_ID
1591: AND efdfce.VARIANT = 'Y')
1592: AND NOT EXISTS
1593: (SELECT 1
1594: FROM ego_attr_groups_interface
1595: WHERE ATTR_GROUP_NAME = eagdl.attr_group_name
1596: AND ATTR_GROUP_TYPE = G_EGO_ITEMMGMT_GROUP
1597: AND variant = 'Y');
1598:

Line 1621: FROM ego_attr_groups_interface

1617: AND efdfce.APPLICATION_ID = G_EGO_APPLICATION_ID
1618: AND efdfce.VARIANT = 'Y')
1619: AND NOT EXISTS
1620: (SELECT 1
1621: FROM ego_attr_groups_interface
1622: WHERE ATTR_GROUP_NAME = eagdl.attr_group_name
1623: AND ATTR_GROUP_TYPE = G_EGO_ITEMMGMT_GROUP
1624: AND variant = 'Y');
1625:

Line 1750: FROM ego_attr_groups_interface eagdl

1746: G_REQUEST_ID,
1747: Nvl(program_application_id,G_PROG_APPL_ID),
1748: Nvl(program_id,G_PROGRAM_ID),
1749: Nvl(program_update_date,SYSDATE)
1750: FROM ego_attr_groups_interface eagdl
1751: WHERE transaction_type = G_OPR_DELETE
1752: AND EXISTS (SELECT 1
1753: FROM EGO_OBJ_AG_ASSOCS_B
1754: WHERE ATTR_GROUP_ID = eagdl.attr_group_id

Line 1761: UPDATE ego_attr_groups_interface eagdl

1757: AND process_status = G_PROCESS_RECORD
1758: AND ((G_SET_PROCESS_ID IS NULL)
1759: OR (set_process_id = G_SET_PROCESS_ID));
1760:
1761: UPDATE ego_attr_groups_interface eagdl
1762: SET process_status = G_ERROR_RECORD,
1763: last_updated_by = G_USER_ID,
1764: last_update_date = SYSDATE,
1765: last_update_login = G_LOGIN_ID

Line 2009: FROM ego_attr_groups_interface eagi

2005: WHERE (eagci.attr_group_id IS NULL
2006: OR eagci.attr_group_name IS NULL)
2007: AND eagci.transaction_id IS NOT NULL
2008: AND NOT EXISTS (SELECT 1
2009: FROM ego_attr_groups_interface eagi
2010: WHERE eagi.attr_group_name = eagci.attr_group_name
2011: AND eagi.transaction_type = G_OPR_CREATE
2012: AND eagi.process_status = G_PROCESS_RECORD)
2013: AND eagci.process_status = G_PROCESS_RECORD

Line 2026: FROM ego_attr_groups_interface eagi

2022: WHERE (eagci.attr_group_id IS NULL
2023: OR eagci.attr_group_name IS NULL)
2024: AND eagci.transaction_id IS NOT NULL
2025: AND NOT EXISTS (SELECT 1
2026: FROM ego_attr_groups_interface eagi
2027: WHERE eagi.attr_group_name = eagci.attr_group_name
2028: AND eagi.transaction_type = G_OPR_CREATE
2029: AND eagi.process_status = G_PROCESS_RECORD)
2030: AND eagci.process_status = G_PROCESS_RECORD

Line 2291: UPDATE ego_attr_groups_interface eagi

2287:
2288: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
2289:
2290: /*Sets the Attribute group id when the Internal Attribute group name is given*/
2291: UPDATE ego_attr_groups_interface eagi
2292: SET eagi.attr_group_id = (SELECT attr_group_id
2293: FROM ego_fnd_dsc_flx_ctx_ext
2294: WHERE application_id = g_ego_application_id
2295: AND descriptive_flexfield_name = eagi.attr_group_type

Line 2313: UPDATE ego_attr_groups_interface eagi

2309:
2310: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
2311:
2312: /*Sets the SYNC transaction type to CREATE*/
2313: UPDATE ego_attr_groups_interface eagi
2314: SET eagi.transaction_type = decode(attr_group_id,null,G_OPR_CREATE,G_OPR_UPDATE),
2315: last_updated_by = G_USER_ID,
2316: last_update_date = SYSDATE,
2317: last_update_login = G_LOGIN_ID

Line 2672: UPDATE ego_attr_groups_interface eagi

2668:
2669: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 1');
2670:
2671: /*Sets the Internal Attribute group name when the attribute group id is given*/
2672: UPDATE ego_attr_groups_interface eagi
2673: SET eagi.attr_group_name = (SELECT attr_group_name
2674: FROM ego_fnd_dsc_flx_ctx_ext
2675: WHERE application_id = g_ego_application_id
2676: AND descriptive_flexfield_name = eagi.attr_group_type

Line 2692: UPDATE ego_attr_groups_interface

2688:
2689: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Statement 2');
2690:
2691: /*Set default for MULTIROW as N*/
2692: UPDATE ego_attr_groups_interface
2693: SET multi_row = 'N',
2694: last_updated_by = G_USER_ID,
2695: last_update_date = SYSDATE,
2696: last_update_login = G_LOGIN_ID

Line 3709: /Cursor to load plsql table from ego_attr_groups_interface table/

3705: (p_set_process_id IN VARCHAR2,
3706: x_return_status OUT NOCOPY VARCHAR2,
3707: x_return_msg OUT NOCOPY VARCHAR2)
3708: IS
3709: /*Cursor to load plsql table from ego_attr_groups_interface table*/
3710: CURSOR c_ag IS
3711: SELECT *
3712: FROM ego_attr_groups_interface
3713: WHERE process_status = G_PROCESS_RECORD

Line 3712: FROM ego_attr_groups_interface

3708: IS
3709: /*Cursor to load plsql table from ego_attr_groups_interface table*/
3710: CURSOR c_ag IS
3711: SELECT *
3712: FROM ego_attr_groups_interface
3713: WHERE process_status = G_PROCESS_RECORD
3714: AND (p_set_process_id IS NULL OR set_process_id = p_set_process_id);
3715: /*Cursor to load plsql table from ego_attr_groups_dl_interface table*/
3716: CURSOR c_agdl IS

Line 6130: UPDATE ego_attr_groups_interface

6126: trans_id(i) := p_ag_tbl(i).transaction_id;
6127: END LOOP;
6128:
6129: FORALL i IN p_ag_tbl.FIRST..p_ag_tbl.LAST
6130: UPDATE ego_attr_groups_interface
6131: SET ROW = p_ag_tbl(i)
6132: WHERE transaction_id = trans_id(i);
6133:
6134: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Exit update_intf_attr_groups');

Line 6233: DELETE FROM ego_attr_groups_interface

6229: write_debug('ego_ag_bulkload_pvt.'||lv_proc||' - '||'Entering delete_processed_attr_groups');
6230:
6231: x_return_status := G_RET_STS_SUCCESS;
6232:
6233: DELETE FROM ego_attr_groups_interface
6234: WHERE process_status = G_SUCCESS_RECORD
6235: AND (x_set_process_id IS NULL
6236: OR set_process_id = x_set_process_id);
6237: