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_ICC_BULKLOAD_PVT dependencies on EGO_ATTR_GRPS_ASSOC_INTERFACE

Line 230: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai

226: ,G_CONC_REQUEST_ID
227: ,G_PROG_APPL_ID
228: ,G_PROGRAM_ID
229: ,l_sysdate
230: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai
231: WHERE ( eagai.transaction_type IS NULL OR
232: eagai.transaction_type NOT IN ( G_TTYPE_CREATE
233: ,G_TTYPE_DELETE)
234: )

Line 244: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE eagai

240: AND process_status = G_PROCESS_STATUS_INITIAL
241: ;
242:
243:
244: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE eagai
245: SET eagai.process_status = G_PROCESS_STATUS_ERROR
246: WHERE ( eagai.transaction_type IS NULL OR
247: eagai.transaction_type NOT IN ( G_TTYPE_CREATE
248: , G_TTYPE_DELETE)

Line 594: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai

590: ,G_CONC_REQUEST_ID
591: ,G_PROG_APPL_ID
592: ,G_PROGRAM_ID
593: ,l_sysdate
594: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai
595: WHERE ( (eagai.item_catalog_group_id IS NULL AND
596: eagai.item_catalog_name IS NULL )
597: OR
598: ( eagai.attr_group_name IS NULL AND

Line 609: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE eagai

605: )
606: AND eagai.process_status = G_PROCESS_STATUS_INITIAL
607: ;
608:
609: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE eagai
610: SET eagai.process_status = G_PROCESS_STATUS_ERROR
611: WHERE ( (eagai.item_catalog_group_id IS NULL AND
612: eagai.item_catalog_name IS NULL )
613: OR

Line 1234: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI

1230: IF p_entity = G_ENTITY_ICC_AG_ASSOC THEN
1231: --- Update the AG Table, attr_group_name
1232: ---
1233:
1234: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1235: SET attr_group_name = ( select eagv.attr_group_name
1236: from ego_attr_groups_v EAGv
1237: where EAGv.attr_group_id = EAGAI.attr_group_id
1238: )

Line 1252: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI

1248:
1249: --- Update the AG Table , attr_group_id
1250: ---
1251:
1252: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1253: SET attr_group_id = ( select eagv.attr_group_id
1254: from ego_attr_groups_v EAGv
1255: where EAGv.attr_group_name = EAGAI.attr_group_name
1256: )

Line 1270: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI

1266:
1267: write_debug (l_proc_name, '12');
1268: --- Update AG table, ICC Name
1269: ---
1270: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1271: SET eagai.item_catalog_name = ( select icc_kfv.concatenated_segments
1272: from mtl_item_catalog_groups_kfv icc_kfv
1273: where icc_kfv.item_catalog_group_id = eagai.item_catalog_group_id
1274: )

Line 1287: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI

1283:
1284: write_debug (l_proc_name, '13');
1285:
1286: ---Update AG table, ICC id
1287: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE EAGAI
1288: SET eagai.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1289: from mtl_item_catalog_groups_kfv icc_kfv
1290: where icc_kfv.concatenated_segments = eagai.item_catalog_name
1291: )

Line 1350: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai

1346: ,G_CONC_REQUEST_ID
1347: ,G_PROG_APPL_ID
1348: ,G_PROGRAM_ID
1349: ,l_sysdate
1350: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai
1351: WHERE eagai.item_catalog_name IS NULL
1352: OR eagai.item_catalog_group_id IS NULL
1353: AND eagai.transaction_id IS NOT NULL
1354: AND eagai.process_status = G_PROCESS_STATUS_INITIAL

Line 1407: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai

1403: ,G_CONC_REQUEST_ID
1404: ,G_PROG_APPL_ID
1405: ,G_PROGRAM_ID
1406: ,l_sysdate
1407: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE eagai
1408: WHERE ( eagai.attr_group_name IS NULL
1409: OR
1410: eagai.attr_group_id IS NULL
1411: )

Line 1424: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE eagai

1420:
1421: write_debug (l_proc_name, '17');
1422: --- update status flag in interface table
1423: ---
1424: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE eagai
1425: set process_status = G_PROCESS_STATUS_ERROR
1426: WHERE eagai.item_catalog_name IS NULL
1427: OR eagai.item_catalog_group_id IS NULL
1428: OR eagai.attr_group_name IS NULL

Line 8376: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE

8372: l_transaction_id_tbl(i) := p_ag_assoc_tbl(i).transaction_id;
8373: END LOOP;
8374:
8375: FORALL i in 1..p_ag_assoc_tbl.COUNT
8376: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE
8377: SET ROW = p_ag_assoc_tbl(i) -- bug 9701271
8378: WHERE transaction_id = l_transaction_id_tbl(i)
8379: AND process_status = G_PROCESS_STATUS_INITIAL
8380: ;

Line 9294: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE

9290:
9291: CURSOR cur_ag_assoc
9292: is
9293: SELECT *
9294: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE
9295: WHERE (
9296: ( G_SET_PROCESS_ID IS NULL )
9297: OR
9298: ( set_process_id = G_SET_PROCESS_ID)

Line 9748: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE

9744: ELSIF p_entity = G_ENTITY_ICC_AG_ASSOC THEN
9745:
9746: write_debug(l_proc_name,'start ag assoc update ');
9747:
9748: UPDATE EGO_ATTR_GRPS_ASSOC_INTERFACE
9749: SET transaction_id = mtl_system_items_interface_s.nextval
9750: ,transaction_type = upper(transaction_type)
9751: ,creation_date = nvl(creation_date, l_sysdate)
9752: ,created_by = NVL(created_by , G_USER_ID)

Line 9861: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE

9857:
9858: CURSOR cur_ag_assoc_count
9859: IS
9860: SELECT count(1) count
9861: FROM EGO_ATTR_GRPS_ASSOC_INTERFACE
9862: WHERE (
9863: ( G_SET_PROCESS_ID IS NULL )
9864: OR
9865: ( set_process_id = G_SET_PROCESS_ID)

Line 10177: DELETE FROM EGO_ATTR_GRPS_ASSOC_INTERFACE

10173: ( set_process_id = G_SET_PROCESS_ID)
10174: );
10175:
10176:
10177: DELETE FROM EGO_ATTR_GRPS_ASSOC_INTERFACE
10178: WHERE transaction_id IS NOT NULL
10179: AND process_status = G_PROCESS_STATUS_SUCCESS
10180: AND (
10181: ( G_SET_PROCESS_ID IS NULL )