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 MTL_ITEM_CAT_GRPS_INTERFACE

Line 146: FROM MTL_ITEM_CAT_GRPS_INTERFACE MICGI

142: ,G_CONC_REQUEST_ID
143: ,G_PROG_APPL_ID
144: ,G_PROGRAM_ID
145: ,l_sysdate
146: FROM MTL_ITEM_CAT_GRPS_INTERFACE MICGI
147: WHERE ( (MICGI.transaction_type IS NULL )
148: OR
149: (MICGI.transaction_type NOT IN ( G_TTYPE_CREATE , G_TTYPE_UPDATE
150: ,G_TTYPE_SYNC)

Line 166: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE MICGI

162:
163: ---
164: --- mark the respective records as errors
165: ---
166: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE MICGI
167: SET micgi.process_status = G_PROCESS_STATUS_ERROR
168: WHERE ( micgi.transaction_type IS NULL OR
169: micgi.transaction_type NOT IN ( G_TTYPE_CREATE , G_TTYPE_UPDATE
170: ,G_TTYPE_SYNC)

Line 494: FROM MTL_ITEM_CAT_GRPS_INTERFACE MICGI

490: ,G_CONC_REQUEST_ID
491: ,G_PROG_APPL_ID
492: ,G_PROGRAM_ID
493: ,l_sysdate
494: FROM MTL_ITEM_CAT_GRPS_INTERFACE MICGI
495: WHERE
496: ( micgi.item_catalog_name is NULL AND
497: micgi.item_catalog_group_id is NULL AND
498: micgi.segment1 is NULL AND micgi.segment14 is NULL AND

Line 524: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE micgi

520:
521: ---
522: --- mark the respective records as errors
523: ---
524: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE micgi
525: SET micgi.process_status = G_PROCESS_STATUS_ERROR
526: WHERE ( micgi.item_catalog_name is NULL AND
527: micgi.item_catalog_group_id is NULL AND
528: micgi.segment1 is NULL AND micgi.segment14 is NULL AND

Line 997: UPDATE mtl_item_cat_grps_interface micgi

993:
994: IF p_entity = G_ENTITY_ICC_HEADER THEN
995: --- ICC table , ICC Name
996:
997: UPDATE mtl_item_cat_grps_interface micgi
998: SET item_catalog_name = ( select icc_kfv.concatenated_segments
999: from mtl_item_catalog_groups_kfv icc_kfv
1000: where icc_kfv.item_catalog_group_id = micgi.item_catalog_group_id
1001: )

Line 1015: UPDATE mtl_item_cat_grps_interface micgi

1011: write_debug (l_proc_name, '1');
1012:
1013:
1014:
1015: UPDATE mtl_item_cat_grps_interface micgi
1016: SET micgi.item_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1017: from mtl_item_catalog_groups_kfv icc_kfv
1018: where icc_kfv.concatenated_segments = micgi.item_catalog_name
1019: )

Line 1082: FROM mtl_item_cat_grps_interface micgi

1078: ,G_CONC_REQUEST_ID
1079: ,G_PROG_APPL_ID
1080: ,G_PROGRAM_ID
1081: ,l_sysdate
1082: FROM mtl_item_cat_grps_interface micgi
1083: WHERE micgi.item_catalog_name IS NULL
1084: AND micgi.item_catalog_group_id IS NOT NULL
1085: AND micgi.transaction_id IS NOT NULL
1086: AND micgi.process_status = G_PROCESS_STATUS_INITIAL

Line 1096: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE micgi

1092:
1093: write_debug (l_proc_name, '4');
1094: --- update status flag in ICC interface table
1095:
1096: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE micgi
1097: set process_status = G_PROCESS_STATUS_ERROR
1098: WHERE micgi.item_catalog_group_id is NOT NULL
1099: AND micgi.item_catalog_name IS NULL
1100: and micgi.transaction_id IS NOT NULL

Line 1115: UPDATE mtl_item_cat_grps_interface micgi

1111: --- ICC Parent id , ICC Parent Name
1112: ---
1113: /*****************************************/
1114:
1115: UPDATE mtl_item_cat_grps_interface micgi
1116: SET parent_catalog_group_name = ( select icc_kfv.concatenated_segments
1117: from mtl_item_catalog_groups_kfv icc_kfv
1118: where icc_kfv.item_catalog_group_id = micgi.parent_catalog_group_id
1119: )

Line 1131: UPDATE mtl_item_cat_grps_interface micgi

1127: ;
1128:
1129: write_debug (l_proc_name, '6');
1130:
1131: UPDATE mtl_item_cat_grps_interface micgi
1132: SET micgi.parent_catalog_group_id = ( select icc_kfv.item_catalog_group_id
1133: from mtl_item_catalog_groups_kfv icc_kfv
1134: where icc_kfv.concatenated_segments = micgi.parent_catalog_group_name
1135: )

Line 1197: FROM mtl_item_cat_grps_interface micgi

1193: ,G_CONC_REQUEST_ID
1194: ,G_PROG_APPL_ID
1195: ,G_PROGRAM_ID
1196: ,l_sysdate
1197: FROM mtl_item_cat_grps_interface micgi
1198: WHERE micgi.parent_catalog_group_name IS NULL
1199: AND micgi.parent_catalog_group_id IS NOT NULL
1200: AND micgi.transaction_id IS NOT NULL
1201: AND micgi.process_status = G_PROCESS_STATUS_INITIAL

Line 1211: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE micgi

1207:
1208: write_debug (l_proc_name, '9');
1209: --- update status flag in ICC interface table for invalid parent ICC names
1210:
1211: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE micgi
1212: set process_status = G_PROCESS_STATUS_ERROR
1213: WHERE micgi.parent_catalog_group_name IS NULL
1214: AND micgi.parent_catalog_group_id is NOT NULL
1215: and micgi.transaction_id IS NOT NULL

Line 8359: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE

8355: l_transaction_id_tbl(i) := p_icc_tbl(i).transaction_id;
8356: END LOOP;
8357:
8358: FORALL i IN 1..p_icc_tbl.count
8359: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE
8360: SET
8361: ROW = p_icc_tbl(i) -- bug 9701271
8362: WHERE transaction_id = l_transaction_id_tbl(i) -- bug 9701271
8363: AND process_status = G_PROCESS_STATUS_INITIAL

Line 8978: from MTL_ITEM_CAT_GRPS_INTERFACE micgi

8974:
8975: CURSOR cur_select_recs
8976: is
8977: select micgi.* , 0 icc_level
8978: from MTL_ITEM_CAT_GRPS_INTERFACE micgi
8979: where (PARENT_CATALOG_GROUP_NAME IS NULL
8980: OR PARENT_CATALOG_GROUP_ID IS NOT NULL
8981: )
8982: AND ( ( G_SET_PROCESS_ID IS NULL )

Line 8992: from MTL_ITEM_CAT_GRPS_INTERFACE micgi

8988:
8989: CURSOR cur_select_orph_recs
8990: is
8991: select micgi.*
8992: from MTL_ITEM_CAT_GRPS_INTERFACE micgi
8993: where (PARENT_CATALOG_GROUP_NAME IS NOT NULL
8994: AND PARENT_CATALOG_GROUP_ID IS NULL
8995: )
8996: AND ( ( G_SET_PROCESS_ID IS NULL )

Line 9008: from MTL_ITEM_CAT_GRPS_INTERFACE MICGI

9004:
9005: CURSOR cur_select_child_recs ( p_level number)
9006: is
9007: select MICGI.* , p_level+1 icc_level
9008: from MTL_ITEM_CAT_GRPS_INTERFACE MICGI
9009: where parent_catalog_group_name
9010: in (
9011: select item_catalog_name
9012: from table ( cast (l_icc_hier_tbl as ego_ICC_Hier_Tbl_Type) ) a

Line 9128: from MTL_ITEM_CAT_GRPS_INTERFACE micgi

9124: ---
9125: CURSOR cur_update_name_frm_segs
9126: IS
9127: select micgi.*
9128: from MTL_ITEM_CAT_GRPS_INTERFACE micgi
9129: where item_catalog_name IS NULL
9130: AND item_catalog_group_id IS NULL
9131: AND ( ( G_SET_PROCESS_ID IS NULL )
9132: OR

Line 9207: update MTL_ITEM_CAT_GRPS_INTERFACE

9203: l_segment_array,
9204: l_structure_type.segment_separator);
9205:
9206:
9207: update MTL_ITEM_CAT_GRPS_INTERFACE
9208: set item_catalog_name = l_concat
9209: WHERE CURRENT OF cur_update_name_frm_segs
9210: ;
9211:

Line 9263: FROM MTL_ITEM_CAT_GRPS_INTERFACE

9259: ---
9260: CURSOR cur_icc ( p_level NUMBER)
9261: is
9262: SELECT *
9263: FROM MTL_ITEM_CAT_GRPS_INTERFACE
9264: WHERE (
9265: ( G_SET_PROCESS_ID IS NULL )
9266: OR
9267: ( set_process_id = G_SET_PROCESS_ID)

Line 9280: FROM MTL_ITEM_CAT_GRPS_INTERFACE

9276:
9277: CURSOR cur_icc_no_hier
9278: is
9279: SELECT *
9280: FROM MTL_ITEM_CAT_GRPS_INTERFACE
9281: WHERE (
9282: ( G_SET_PROCESS_ID IS NULL )
9283: OR
9284: ( set_process_id = G_SET_PROCESS_ID)

Line 9722: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE

9718:
9719: IF p_entity = G_ENTITY_ICC_HEADER THEN
9720: write_debug(l_proc_name,'Inside header update ');
9721:
9722: UPDATE MTL_ITEM_CAT_GRPS_INTERFACE
9723: SET transaction_id = mtl_system_items_interface_s.nextval
9724: ,transaction_type = upper(transaction_type)
9725: ,creation_date = nvl(creation_date, l_sysdate)
9726: ,created_by = NVL(created_by , G_USER_ID)

Line 9847: FROM MTL_ITEM_CAT_GRPS_INTERFACE

9843:
9844: CURSOR cur_icc_count
9845: IS
9846: SELECT count(1) count
9847: FROM MTL_ITEM_CAT_GRPS_INTERFACE
9848: WHERE (
9849: ( G_SET_PROCESS_ID IS NULL )
9850: OR
9851: ( set_process_id = G_SET_PROCESS_ID)

Line 10167: DELETE FROM MTL_ITEM_CAT_GRPS_INTERFACE

10163: l_proc_name VARCHAR2(30) := 'Delete_Processed_ICC';
10164: BEGIN
10165: x_return_status := G_RET_STS_SUCCESS;
10166:
10167: DELETE FROM MTL_ITEM_CAT_GRPS_INTERFACE
10168: WHERE transaction_id IS NOT NULL
10169: AND process_status = G_PROCESS_STATUS_SUCCESS
10170: AND (
10171: ( G_SET_PROCESS_ID IS NULL )