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.INVPOPIF dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 73: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

69: IF p_xset_id IS NULL THEN
70:
71: IF p_run_mode = 1 THEN
72:
73: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
74: SET SET_PROCESS_ID = -999
75: WHERE PROCESS_FLAG = 1
76: AND TRANSACTION_TYPE in ('CREATE','Create','create');
77:

Line 85: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

81: AND TRANSACTION_TYPE in ('CREATE','Create','create');
82:
83: ELSIF p_run_mode = 2 THEN
84:
85: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
86: SET SET_PROCESS_ID = -999
87: WHERE PROCESS_FLAG = 1
88: AND TRANSACTION_TYPE in ('UPDATE','Update','update');
89:

Line 97: UPDATE MTL_SYSTEM_ITEMS_INTERFACE

93: AND TRANSACTION_TYPE in ('UPDATE','Update','update');
94:
95: ELSIF p_run_mode = 3 THEN
96:
97: UPDATE MTL_SYSTEM_ITEMS_INTERFACE
98: SET SET_PROCESS_ID = -999
99: WHERE PROCESS_FLAG = 1
100: AND TRANSACTION_TYPE in ('SYNC','Sync','sync');
101:

Line 130: FROM mtl_system_items_interface

126: source_org_id => source_org_id,
127: gather_stats => p_gather_stats);
128:
129: SELECT count(*) INTO l_pro_flag_3
130: FROM mtl_system_items_interface
131: WHERE process_flag = 3
132: AND request_id = FND_GLOBAL.conc_request_id
133: AND rownum = 1;
134:

Line 198: from mtl_system_items_interface

194: l_msg_count NUMBER;
195:
196: CURSOR lock_rows IS
197: select rowid
198: from mtl_system_items_interface
199: where set_process_id = xset_id
200: for update;
201:
202: CURSOR lock_revs IS

Line 210: from mtl_system_items_interface

206: for update;
207:
208: CURSOR update_org_id IS
209: select rowid, transaction_id
210: from mtl_system_items_interface
211: where organization_id is NULL
212: and set_process_id = xset_id
213: and process_flag = 1;
214:

Line 224: FROM mtl_system_items_interface msii

220: and process_flag = 1;
221:
222: CURSOR c_master_items(cp_transaction_type VARCHAR2) IS
223: SELECT COUNT(*)
224: FROM mtl_system_items_interface msii
225: ,mtl_parameters mp1
226: WHERE set_process_id = xset_id
227: AND transaction_type = cp_transaction_type
228: AND process_flag in (1,2,4)

Line 246: FROM mtl_system_items_interface

242: --: Bug 6158936
243: --: Child counts
244: CURSOR c_child_items(cp_transaction_type VARCHAR2) IS
245: SELECT count(*)
246: FROM mtl_system_items_interface
247: WHERE set_process_id = xset_id
248: AND transaction_type = cp_transaction_type
249: AND process_flag in (1,2,4)
250: AND organization_id

Line 268: FROM mtl_system_items_interface

264: AND ROWNUM = 1;
265:
266: CURSOR c_interface_items(cp_transaction_type VARCHAR2) IS
267: SELECT count(*)
268: FROM mtl_system_items_interface
269: WHERE set_process_id = xset_id
270: AND transaction_type = cp_transaction_type
271: AND process_flag in (1,4);
272:

Line 285: from mtl_system_items_interface

281:
282: -- added for bug 13430047
283: CURSOR wrong_trans_type_msii IS
284: select rowid, transaction_id
285: from mtl_system_items_interface
286: where (transaction_type NOT IN ('CREATE', 'UPDATE','SYNC','ADD','DELETE') --bug13585063,13595665
287: OR transaction_type IS NULL OR set_process_id >= 900000000000)
288: AND set_process_id = xset_id
289: and process_flag = 1;

Line 347: --FROM mtl_system_items_interface

343:
344: -- Fix for bug#9336604
345: --3515652: Collect stats only if no. records > 50
346: --SELECT count(*) INTO l_records
347: --FROM mtl_system_items_interface
348: --WHERE set_process_id = xset_id
349: --AND process_flag = 1;
350:
351: -- Fix for bug#9336604

Line 366: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');

362: As mentioned in the note 1208945.1 and suggested by performance team,
363: for any performance issues we need to gather stats manualy so no need to gather stats in the code.
364: */
365: /*
366: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_SYSTEM_ITEMS_INTERFACE');
367: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_ITEM_REVISIONS_INTERFACE');
368: */
369: -- Bug 12669091 : End
370: FND_STATS.GATHER_TABLE_STATS(l_schema, 'MTL_DESC_ELEM_VAL_INTERFACE');

Line 386: UPDATE mtl_system_items_interface

382: -- validation fails while Creating or Updating an Item.
383:
384: -- Bug 3975408 :Changed the where clause to (1,4) of the following update.
385:
386: UPDATE mtl_system_items_interface
387: SET transaction_type = UPPER(transaction_type)
388: ,request_id = req_id
389: ,transaction_id = NVL(transaction_id, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)
390: WHERE set_process_id = xset_id

Line 389: ,transaction_id = NVL(transaction_id, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)

385:
386: UPDATE mtl_system_items_interface
387: SET transaction_type = UPPER(transaction_type)
388: ,request_id = req_id
389: ,transaction_id = NVL(transaction_id, MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL)
390: WHERE set_process_id = xset_id
391: AND process_flag IN (1,4);
392:
393: UPDATE mtl_item_revisions_interface

Line 400: UPDATE + first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) (need add hint if added) -- Bug 10404086

396: WHERE set_process_id = xset_id
397: AND process_flag IN (1,4);
398: /*Bug 13430047
399: --SYNC: IOI to support SYNC operation.
400: UPDATE + first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) (need add hint if added) -- Bug 10404086
401: mtl_system_items_interface msii
402: SET process_flag = -888
403: WHERE ( transaction_type NOT IN ('CREATE', 'UPDATE','SYNC')
404: OR transaction_type IS NULL OR set_process_id >= 900000000000)

Line 401: mtl_system_items_interface msii

397: AND process_flag IN (1,4);
398: /*Bug 13430047
399: --SYNC: IOI to support SYNC operation.
400: UPDATE + first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) (need add hint if added) -- Bug 10404086
401: mtl_system_items_interface msii
402: SET process_flag = -888
403: WHERE ( transaction_type NOT IN ('CREATE', 'UPDATE','SYNC')
404: OR transaction_type IS NULL OR set_process_id >= 900000000000)
405: AND set_process_id = xset_id;

Line 430: 'MTL_SYSTEM_ITEMS_INTERFACE',

426: request_id,
427: cr.transaction_id,
428: 'INVPOPIF: Invalid transaction type',
429: 'TRANSACTION_TYPE',
430: 'MTL_SYSTEM_ITEMS_INTERFACE',
431: 'INV_INT_TRXTYPCODE',
432: err_text);
433: if dumm_status < 0 then
434: raise LOGGING_ERR;

Line 437: update mtl_system_items_interface

433: if dumm_status < 0 then
434: raise LOGGING_ERR;
435: end if;
436:
437: update mtl_system_items_interface
438: set process_flag = 3
439: where rowid = cr.rowid ;
440:
441: END LOOP;

Line 468: update MTL_SYSTEM_ITEMS_INTERFACE MSII

464: where rowid = cr.rowid ;
465: END LOOP;
466: -- Assign missing organization_id from organization_code
467:
468: update MTL_SYSTEM_ITEMS_INTERFACE MSII
469: set MSII.organization_id =
470: ( select MP.organization_id
471: from MTL_PARAMETERS MP
472: where MP.organization_code = MSII.organization_code

Line 518: 'MTL_SYSTEM_ITEMS_INTERFACE',

514: request_id,
515: cr.transaction_id,
516: 'INVPOPIF: Invalid Organization ID',
517: 'ORGANIZATION_ID',
518: 'MTL_SYSTEM_ITEMS_INTERFACE',
519: 'INV_IOI_ORG_NO_EXIST',
520: err_text);
521: if dumm_status < 0 then
522: raise LOGGING_ERR;

Line 525: update mtl_system_items_interface

521: if dumm_status < 0 then
522: raise LOGGING_ERR;
523: end if;
524:
525: update mtl_system_items_interface
526: set process_flag = 3
527: where rowid = cr.rowid ;
528:
529: END LOOP;

Line 559: FROM MTL_SYSTEM_ITEMS_INTERFACE

555: -- Bug 9092888 - changes
556: IF ( INV_EGO_REVISION_VALIDATE.Get_Process_Control_HTML_API = 'API') THEN
557: SELECT style_item_id, style_item_flag , Upper(transaction_type)
558: INTO l_style_item_id, l_style_item_flag, l_transaction_type
559: FROM MTL_SYSTEM_ITEMS_INTERFACE
560: WHERE set_process_id = xset_id
561: AND process_flag=1;
562:
563: IF(l_transaction_type = 'CREATE' AND l_style_item_flag = 'N' AND l_style_item_id IS NOT NULL)

Line 568: FROM mtl_system_items_interface msii

564: THEN
565: UPDATE ego_itm_usr_attr_intrfc uai
566: SET (transaction_type, transaction_id,organization_code , organization_id)
567: = (SELECT Upper(transaction_type), transaction_id, organization_code, organization_id
568: FROM mtl_system_items_interface msii
569: WHERE msii.set_process_id = xset_id)
570: WHERE DATA_SET_ID = xset_id
571: AND PROCESS_STATUS = 1;
572:

Line 573: UPDATE mtl_system_items_interface

569: WHERE msii.set_process_id = xset_id)
570: WHERE DATA_SET_ID = xset_id
571: AND PROCESS_STATUS = 1;
572:
573: UPDATE mtl_system_items_interface
574: SET inventory_item_id = MTL_SYSTEM_ITEMS_S.NEXTVAL
575: WHERE inventory_item_id IS NULL
576: AND set_process_id = xset_id
577: AND process_flag = 1;

Line 605: UPDATE mtl_system_items_interface

601: );
602: END IF;
603:
604: IF ( l_ret_code <> 0) THEN
605: UPDATE mtl_system_items_interface
606: SET process_flag = 3
607: WHERE set_process_id = xset_id;
608:
609: RETURN l_ret_code;

Line 622: UPDATE mtl_system_items_interface msii

618: ** to be defaulted and subsequently applied.
619:
620: R12C : Changing the New Item Req Reqd = 'Y' sub-query for hierarchy enabled Catalogs */
621: --6521101 - Pending status updation for master recs only
622: UPDATE mtl_system_items_interface msii
623: SET msii.INVENTORY_ITEM_STATUS_CODE = 'Pending'
624: WHERE (msii.organization_id = org_id OR all_Org = 1)
625: AND msii.INVENTORY_ITEM_STATUS_CODE IS NULL
626: AND msii.ITEM_CATALOG_GROUP_ID IS NOT NULL

Line 648: UPDATE mtl_system_items_interface msii

644: /* Bug 9660959 Need to disable this since EGO Import Catalog Item program is calling INVPOPIF more than once
645: the SYNC rows in pervious round will become create/update rows which shouldn't be disabled
646: IF run_mode = 3 THEN
647: --3018673: Start of bug fix.
648: UPDATE mtl_system_items_interface msii
649: SET process_flag = process_flag + 20000
650: WHERE transaction_type IN ('CREATE','UPDATE')
651: AND process_flag < 20000
652: AND set_process_id = xset_id;

Line 671: UPDATE /+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) / -- Bug 10404086

667: IF (run_mode IN (1,3,0)) THEN --{ /* transaction_type IN 'CREATE' 'SYNC' */
668:
669: l_processed_flag := TRUE;
670:
671: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
672: mtl_system_items_interface msii
673: SET process_flag = process_flag + 30000
674: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
675: AND process_flag < 30000

Line 672: mtl_system_items_interface msii

668:
669: l_processed_flag := TRUE;
670:
671: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
672: mtl_system_items_interface msii
673: SET process_flag = process_flag + 30000
674: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
675: AND process_flag < 30000
676: AND set_process_id = xset_id;

Line 700: UPDATE /+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) / -- Bug 10404086

696: inopinp_OI_process_create for the master org */
697:
698: IF (mtl_count <> 0 or mtli_count <> 0) THEN
699:
700: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
701: mtl_system_items_interface msii
702: SET process_flag = process_flag + 60000
703: WHERE transaction_type = 'CREATE'
704: AND process_flag < 60000

Line 701: mtl_system_items_interface msii

697:
698: IF (mtl_count <> 0 or mtli_count <> 0) THEN
699:
700: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
701: mtl_system_items_interface msii
702: SET process_flag = process_flag + 60000
703: WHERE transaction_type = 'CREATE'
704: AND process_flag < 60000
705: AND set_process_id = xset_id

Line 739: UPDATE mtl_system_items_interface msii

735: ,xset_id
736: ,commit_flag
737: ,default_flag);
738:
739: UPDATE mtl_system_items_interface msii
740: SET process_flag = process_flag - 60000
741: WHERE transaction_type = 'CREATE'
742: AND process_flag >= 60000
743: AND set_process_id = xset_id;

Line 772: UPDATE /+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) / -- Bug 10404086

768: IF (mtl_count <> 0 or mtli_count <> 0) THEN
769:
770: /* R12C Bug 6158936 - All Master Items and revs will be isolated during child procesing */
771:
772: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
773: mtl_system_items_interface msii
774: SET process_flag = process_flag + 60000
775: WHERE transaction_type = 'CREATE'
776: AND process_flag < 60000

Line 773: mtl_system_items_interface msii

769:
770: /* R12C Bug 6158936 - All Master Items and revs will be isolated during child procesing */
771:
772: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
773: mtl_system_items_interface msii
774: SET process_flag = process_flag + 60000
775: WHERE transaction_type = 'CREATE'
776: AND process_flag < 60000
777: AND set_process_id = xset_id

Line 813: UPDATE mtl_system_items_interface msii

809: default_flag);
810:
811: /* R12C Bug 6158936 : Moving Master Items and revs back to batch */
812:
813: UPDATE mtl_system_items_interface msii
814: SET process_flag = process_flag - 60000
815: WHERE transaction_type = 'CREATE'
816: AND process_flag >= 60000
817: AND set_process_id = xset_id;

Line 860: UPDATE mtl_system_items_interface msii

856: default_flag);
857: END IF;
858: END IF; --}
859:
860: UPDATE mtl_system_items_interface msii
861: SET process_flag = process_flag - 30000
862: WHERE transaction_type IN ('UPDATE','SYNC') --3018673
863: AND process_flag >= 30000
864: AND set_process_id = xset_id;

Line 878: UPDATE /+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) / -- Bug 10404086

874: IF (run_mode IN (2,3,0)) THEN /* transaction_type IN 'UPDATE' 'SYNC' */
875:
876: l_processed_flag := TRUE;
877:
878: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
879: mtl_system_items_interface msii
880: SET process_flag = process_flag + 30000
881: WHERE transaction_type IN ('CREATE','SYNC') --3018673
882: AND process_flag < 30000

Line 879: mtl_system_items_interface msii

875:
876: l_processed_flag := TRUE;
877:
878: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
879: mtl_system_items_interface msii
880: SET process_flag = process_flag + 30000
881: WHERE transaction_type IN ('CREATE','SYNC') --3018673
882: AND process_flag < 30000
883: AND set_process_id = xset_id;

Line 903: UPDATE /+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) / -- Bug 10404086

899: CLOSE c_master_revs;
900:
901: IF (mtl_count <> 0 or mtli_count <> 0) THEN
902:
903: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
904: mtl_system_items_interface msii
905: SET process_flag = process_flag + 60000
906: WHERE transaction_type = 'UPDATE'
907: AND process_flag < 60000

Line 904: mtl_system_items_interface msii

900:
901: IF (mtl_count <> 0 or mtli_count <> 0) THEN
902:
903: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
904: mtl_system_items_interface msii
905: SET process_flag = process_flag + 60000
906: WHERE transaction_type = 'UPDATE'
907: AND process_flag < 60000
908: AND set_process_id = xset_id

Line 939: UPDATE mtl_system_items_interface msii

935: xset_id,
936: commit_flag,
937: default_flag);
938:
939: UPDATE mtl_system_items_interface msii
940: SET process_flag = process_flag - 60000
941: WHERE transaction_type = 'UPDATE'
942: AND process_flag >= 60000
943: AND set_process_id = xset_id;

Line 969: UPDATE /+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) / -- Bug 10404086

965: IF (mtl_count <> 0 or mtli_count <> 0) THEN
966:
967: /* R12C Bug 6158936 - All Master Items and revs will be isolated during child procesing */
968:
969: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
970: mtl_system_items_interface msii
971: SET process_flag = process_flag + 60000
972: WHERE transaction_type = 'UPDATE'
973: AND process_flag < 60000

Line 970: mtl_system_items_interface msii

966:
967: /* R12C Bug 6158936 - All Master Items and revs will be isolated during child procesing */
968:
969: UPDATE /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
970: mtl_system_items_interface msii
971: SET process_flag = process_flag + 60000
972: WHERE transaction_type = 'UPDATE'
973: AND process_flag < 60000
974: AND set_process_id = xset_id

Line 1007: UPDATE mtl_system_items_interface msii

1003: default_flag);
1004:
1005: /* R12C Bug 6158936 : Moving Master Items and revs back to batch */
1006:
1007: UPDATE mtl_system_items_interface msii
1008: SET process_flag = process_flag - 60000
1009: WHERE transaction_type = 'UPDATE'
1010: AND process_flag >= 60000
1011: AND set_process_id = xset_id;

Line 1051: UPDATE mtl_system_items_interface msii

1047: END IF;
1048:
1049: END IF; --}
1050:
1051: UPDATE mtl_system_items_interface msii
1052: SET process_flag = process_flag - 30000
1053: WHERE transaction_type IN ('CREATE','SYNC') --3018673
1054: AND process_flag >= 30000
1055: AND set_process_id = xset_id;

Line 1068: UPDATE mtl_system_items_interface msii

1064:
1065: --3018673: Start of bug fix.
1066: IF run_mode = 3 THEN
1067:
1068: UPDATE mtl_system_items_interface msii
1069: SET process_flag = process_flag - 20000
1070: WHERE transaction_type IN ('CREATE','UPDATE')
1071: AND process_flag >= 20000
1072: AND set_process_id = xset_id;

Line 1236: (SELECT /+ first_rows index(msi, MTL_SYSTEM_ITEMS_INTERFACE_N3) / -- Bug 10404086

1232: ,CREATED_BY
1233: ,LAST_UPDATE_DATE
1234: ,LAST_UPDATED_BY
1235: ,LAST_UPDATE_LOGIN)
1236: (SELECT /*+ first_rows index(msi, MTL_SYSTEM_ITEMS_INTERFACE_N3) */ -- Bug 10404086
1237: msi.REQUEST_ID
1238: ,'ITEM'
1239: ,msi.INVENTORY_ITEM_ID
1240: ,msi.ORGANIZATION_ID

Line 1247: FROM mtl_system_items_interface msi

1243: ,NVL(msi.CREATED_BY, -1)
1244: ,NVL(msi.LAST_UPDATE_DATE, SYSDATE)
1245: ,NVL(msi.LAST_UPDATED_BY, -1)
1246: ,msi.LAST_UPDATE_LOGIN
1247: FROM mtl_system_items_interface msi
1248: WHERE msi.request_id = request_id
1249: and msi.set_process_id = xset_id
1250: and msi.process_flag = 7
1251: /* Bug 6139403 Do not raise BE for fake rows*/

Line 1399: FROM mtl_system_items_interface msii

1395: if the record was created for CM support, and a similar row with
1396: process flag 5 exists in the interface table.
1397: ***/
1398: DELETE
1399: FROM mtl_system_items_interface msii
1400: WHERE process_flag = 7
1401: AND (inventory_item_id, organization_id, set_process_id) IN
1402: (SELECT inventory_item_id, organization_id, set_process_id
1403: FROM mtl_system_items_interface intf

Line 1403: FROM mtl_system_items_interface intf

1399: FROM mtl_system_items_interface msii
1400: WHERE process_flag = 7
1401: AND (inventory_item_id, organization_id, set_process_id) IN
1402: (SELECT inventory_item_id, organization_id, set_process_id
1403: FROM mtl_system_items_interface intf
1404: WHERE set_process_id = xset_id
1405: AND process_flag = 5);
1406: END IF; -- del_rec_flag = 1
1407:

Line 1769: FROM mtl_system_items_interface

1765: RETURN INTEGER IS
1766:
1767: CURSOR Error_Items IS
1768: SELECT transaction_id, organization_id
1769: FROM mtl_system_items_interface
1770: WHERE process_flag = 4
1771: AND set_process_id = xset_id
1772: AND transaction_type = 'CREATE';
1773:

Line 1943: 'MTL_SYSTEM_ITEMS_INTERFACE',

1939: request_id,
1940: ee.transaction_id,
1941: err_msg,
1942: 'INVENTORY_ITEM_ID',
1943: 'MTL_SYSTEM_ITEMS_INTERFACE',
1944: 'INV_IOI_ERR_IN_PROCESS_ITEM',--added by bug 11894684, replace INV_IOI_ERR with specific message name so we can identify error easily
1945: err_msg);
1946: END LOOP;
1947:

Line 1948: UPDATE mtl_system_items_interface

1944: 'INV_IOI_ERR_IN_PROCESS_ITEM',--added by bug 11894684, replace INV_IOI_ERR with specific message name so we can identify error easily
1945: err_msg);
1946: END LOOP;
1947:
1948: UPDATE mtl_system_items_interface
1949: SET process_flag = 3
1950: WHERE process_flag = 4
1951: AND set_process_id = xset_id
1952: AND transaction_type = 'CREATE';

Line 1974: FROM mtl_system_items_interface msii,

1970: BEGIN
1971: SELECT 'Y' INTO l_child_records
1972: FROM DUAL
1973: WHERE EXISTS (SELECT NULL
1974: FROM mtl_system_items_interface msii,
1975: mtl_parameters mp
1976: WHERE transaction_type = 'CREATE'
1977: AND process_flag = 7
1978: AND set_process_id = xset_id

Line 2048: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE

2044:
2045: stmt_num := 1;
2046:
2047: LOOP
2048: DELETE FROM MTL_SYSTEM_ITEMS_INTERFACE
2049: WHERE process_flag = l_process_flag_7
2050: AND set_process_id in (xset_id, xset_id + 1000000000000)
2051: AND rownum < l_rownum;
2052:

Line 2121: FROM mtl_system_items_interface

2117: ,segment20
2118: ,item_number
2119: ,transaction_id
2120: ,transaction_type
2121: FROM mtl_system_items_interface
2122: WHERE set_process_id = p_set_id
2123: AND process_flag = 1
2124: AND (transaction_type = 'SYNC' OR
2125: (transaction_type = 'UPDATE' AND inventory_item_id IS NOT NULL AND

Line 2268: 'MTL_SYSTEM_ITEMS_INTERFACE',

2264: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2265: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2266: 'INVPOPIF: Update to Item number not allowed',
2267: 'ITEM NUMBER',
2268: 'MTL_SYSTEM_ITEMS_INTERFACE',
2269: 'INV_ITEM_NUMBER_NO_UDPATE',
2270: l_err_text);
2271: IF dumm_status < 0 THEN
2272: raise LOGGING_ERR;

Line 2275: update mtl_system_items_interface

2271: IF dumm_status < 0 THEN
2272: raise LOGGING_ERR;
2273: END IF;
2274:
2275: update mtl_system_items_interface
2276: set process_flag = 3
2277: where rowid = item_record.rowid ;
2278:
2279: END IF;

Line 2286: 'MTL_SYSTEM_ITEMS_INTERFACE',

2282: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2283: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2284: 'INVPOPIF: Update to Item number not allowed in child organization',
2285: 'ITEM NUMBER',
2286: 'MTL_SYSTEM_ITEMS_INTERFACE',
2287: 'INV_ITEM_NUMBER_ORG_NO_UDPATE',
2288: l_err_text);
2289: IF dumm_status < 0 THEN
2290: raise LOGGING_ERR;

Line 2293: update mtl_system_items_interface

2289: IF dumm_status < 0 THEN
2290: raise LOGGING_ERR;
2291: END IF;
2292:
2293: update mtl_system_items_interface
2294: set process_flag = 3
2295: where rowid = item_record.rowid ;
2296:
2297: END IF;

Line 2313: 'MTL_SYSTEM_ITEMS_INTERFACE',

2309: dumm_status := INVPUOPI.mtl_log_interface_err(-1,fnd_global.user_id,fnd_global.login_id,
2310: fnd_global.prog_appl_id,fnd_global.conc_program_id,fnd_global.conc_request_id,item_record.transaction_id,
2311: 'INVPOPIF: Update to Duplicate Item number',
2312: 'ITEM NUMBER',
2313: 'MTL_SYSTEM_ITEMS_INTERFACE',
2314: 'INV_UPDATE_TO_EXIST_ITEM_NAME',
2315: l_err_text);
2316: IF dumm_status < 0 THEN
2317: raise LOGGING_ERR;

Line 2320: update mtl_system_items_interface

2316: IF dumm_status < 0 THEN
2317: raise LOGGING_ERR;
2318: END IF;
2319:
2320: update mtl_system_items_interface
2321: set process_flag = 3
2322: where rowid = item_record.rowid ;
2323:
2324: END IF;

Line 2329: UPDATE mtl_system_items_interface

2325: END IF;
2326: END IF; --ITEM ID
2327:
2328: IF l_item_exist <> 0 THEN
2329: UPDATE mtl_system_items_interface
2330: SET transaction_type = 'UPDATE'
2331: WHERE rowid = item_record.rowid
2332: AND transaction_type = 'SYNC';
2333: ELSE

Line 2334: UPDATE mtl_system_items_interface

2330: SET transaction_type = 'UPDATE'
2331: WHERE rowid = item_record.rowid
2332: AND transaction_type = 'SYNC';
2333: ELSE
2334: UPDATE mtl_system_items_interface
2335: SET transaction_type = 'CREATE'
2336: WHERE rowid = item_record.rowid
2337: AND transaction_type = 'SYNC';
2338: END IF;

Line 2400: FROM mtl_system_items_interface msii

2396:
2397: LOGGING_ERR EXCEPTION;
2398: CURSOR update_catg_name(p_catg_name IN VARCHAR2) IS
2399: SELECT ROWID, msii.TRANSACTION_ID
2400: FROM mtl_system_items_interface msii
2401: WHERE SET_PROCESS_ID = p_set_id
2402: AND msii.ITEM_CATALOG_GROUP_NAME = p_catg_name;
2403:
2404: --Holds {Item Catalog Group Name: Item Catalog ID}

Line 2413: mtl_system_items_interface.ITEM_CATALOG_GROUP_NAME%TYPE;

2409:
2410: l_Item_Catalog_Group_ID
2411: mtl_item_catalog_groups_b.ITEM_CATALOG_GROUP_ID%TYPE;
2412: l_Item_Catalog_Group_Name
2413: mtl_system_items_interface.ITEM_CATALOG_GROUP_NAME%TYPE;
2414:
2415: l_Item_Catalog VARCHAR2(2000);
2416: l_index INTEGER;
2417: l_dumm_status NUMBER;

Line 2421: SELECT /+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) /

2417: l_dumm_status NUMBER;
2418:
2419: BEGIN
2420: -- Bug 10404086 : Added below query.
2421: SELECT /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */
2422: DISTINCT msii.ITEM_CATALOG_GROUP_NAME ||
2423: ':' || bkfv.ITEM_CATALOG_GROUP_ID
2424: BULK COLLECT INTO Item_Catalogs_Table
2425: FROM mtl_system_items_interface msii,

Line 2425: FROM mtl_system_items_interface msii,

2421: SELECT /*+ first_rows index(msii, MTL_SYSTEM_ITEMS_INTERFACE_N3) */
2422: DISTINCT msii.ITEM_CATALOG_GROUP_NAME ||
2423: ':' || bkfv.ITEM_CATALOG_GROUP_ID
2424: BULK COLLECT INTO Item_Catalogs_Table
2425: FROM mtl_system_items_interface msii,
2426: mtl_item_catalog_groups_b_kfv bkfv
2427: WHERE msii.ITEM_CATALOG_GROUP_ID IS NULL
2428: AND msii.ITEM_CATALOG_GROUP_NAME IS NOT NULL
2429: AND msii.SET_PROCESS_ID = p_set_id

Line 2453: 'MTL_SYSTEM_ITEMS_INTERFACE',

2449: p_request_id,
2450: cr.transaction_id,
2451: 'INVPOPIF: Invalid Item Catalog Group Name',
2452: 'ITEM_CATALOG_GROUP_NAME',
2453: 'MTL_SYSTEM_ITEMS_INTERFACE',
2454: 'INV_IOI_CATG_NAME_INVALID',
2455: x_err_text);
2456: IF l_dumm_status < 0 then
2457: raise LOGGING_ERR;

Line 2460: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII

2456: IF l_dumm_status < 0 then
2457: raise LOGGING_ERR;
2458: END IF;
2459:
2460: UPDATE MTL_SYSTEM_ITEMS_INTERFACE MSII
2461: SET PROCESS_FLAG = 3
2462: WHERE ROWID = cr.ROWID ;
2463: END LOOP; --cr
2464:

Line 2470: UPDATE /+ first_rows index(MSII, MTL_SYSTEM_ITEMS_INTERFACE_N3) /

2466: l_Item_Catalog_Group_ID
2467: := SUBSTR(l_Item_Catalog, INSTR(l_Item_Catalog,':',-1) +1);--bug14083302
2468:
2469: -- Bug 10404086 : Added below query.
2470: UPDATE /*+ first_rows index(MSII, MTL_SYSTEM_ITEMS_INTERFACE_N3) */
2471: MTL_SYSTEM_ITEMS_INTERFACE MSII
2472: SET MSII.ITEM_CATALOG_GROUP_ID = l_Item_Catalog_Group_ID
2473: WHERE SET_PROCESS_ID = p_set_id
2474: AND MSII.ITEM_CATALOG_GROUP_NAME = l_Item_Catalog_Group_Name;

Line 2471: MTL_SYSTEM_ITEMS_INTERFACE MSII

2467: := SUBSTR(l_Item_Catalog, INSTR(l_Item_Catalog,':',-1) +1);--bug14083302
2468:
2469: -- Bug 10404086 : Added below query.
2470: UPDATE /*+ first_rows index(MSII, MTL_SYSTEM_ITEMS_INTERFACE_N3) */
2471: MTL_SYSTEM_ITEMS_INTERFACE MSII
2472: SET MSII.ITEM_CATALOG_GROUP_ID = l_Item_Catalog_Group_ID
2473: WHERE SET_PROCESS_ID = p_set_id
2474: AND MSII.ITEM_CATALOG_GROUP_NAME = l_Item_Catalog_Group_Name;
2475: END IF;

Line 2495: FROM mtl_system_items_interface msii

2491: dumm_status NUMBER;
2492: LOGGING_ERR EXCEPTION;
2493: CURSOR cur_non_released_icc IS
2494: SELECT msii.item_catalog_group_id, msii.ROWID, msii.transaction_id
2495: FROM mtl_system_items_interface msii
2496: WHERE msii.item_catalog_group_id IS NOT NULL
2497: AND msii.set_process_id = p_set_id -- p_set_process_id
2498: AND msii.process_flag = 1
2499: AND NOT EXISTS

Line 2517: 'MTL_SYSTEM_ITEMS_INTERFACE',

2513: p_request_id,
2514: cr.transaction_id,
2515: 'Item Catalog Category should have released version for creating item.',
2516: 'ITEM_CATALOG_GROUP_NAME',
2517: 'MTL_SYSTEM_ITEMS_INTERFACE',
2518: 'INV_IOI_NON_REL_CATG',
2519: x_err_text);
2520: if dumm_status < 0 then
2521: raise LOGGING_ERR;

Line 2524: update mtl_system_items_interface

2520: if dumm_status < 0 then
2521: raise LOGGING_ERR;
2522: end if;
2523:
2524: update mtl_system_items_interface
2525: set process_flag = 3
2526: where rowid = cr.rowid ;
2527: END LOOP;
2528: END VALIDATE_RELEASED_ICC;