DBA Data[Home] [Help]

APPS.EGO_ORCHESTRATION_UTIL_PUB dependencies on MTL_SYSTEM_ITEMS_INTERFACE

Line 34: FROM mtl_system_items_interface

30: x_Gpc_list OUT NOCOPY VARCHAR2
31: )IS
32: CURSOR Get_All_Items(l_b_Id NUMBER) IS
33: SELECT gpc_code, bundle_id, source_system_id, source_system_reference
34: FROM mtl_system_items_interface
35: WHERE bundle_id = l_b_Id ;
36: l_icc_code NUMBER;
37:
38: BEGIN

Line 49: UPDATE mtl_system_items_interface

45: ,X_ICC_CATEGORY_ID => l_icc_code); -- Icc code
46: --l_icc_code := 0;
47: IF l_icc_code IS NOT NULL
48: THEN
49: UPDATE mtl_system_items_interface
50: SET Item_catalog_group_id = l_icc_code
51: WHERE bundle_id = item_data.bundle_id
52: AND source_system_id = item_data.source_system_id
53: AND source_system_reference = item_data.source_system_reference;

Line 81: FROM mtl_system_items_interface

77: x_Gpc_list OUT NOCOPY VARCHAR2
78: )IS
79: CURSOR Get_All_Items(l_b_Id NUMBER)
80: IS SELECT gpc_code ,bundle_id, global_trade_item_number,source_system_reference
81: FROM mtl_system_items_interface
82: WHERE bundle_id = l_b_Id ;
83:
84: l_acc_code NUMBER;
85: l_acc_catalog NUMBER;

Line 146: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

142: IF (l_bundle_collection_id = NULL OR
143: l_bundle_collection_id = 0 OR
144: l_bundle_collection_id = -1)
145: THEN
146: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
147: INTO l_bundle_collection_id
148: FROM dual;
149: END IF;
150:

Line 524: FROM MTL_SYSTEM_ITEMS_INTERFACE

520: l_batch_id NUMBER;
521:
522: CURSOR bundles IS
523: SELECT set_process_id
524: FROM MTL_SYSTEM_ITEMS_INTERFACE
525: WHERE BUNDLE_ID IN
526: (SELECT BUNDLE_ID
527: FROM MTL_ITEM_BULKLOAD_RECS
528: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);

Line 538: UPDATE MTL_SYSTEM_ITEMS_INTERFACE ISTI

534: -- PUTTING THE PARAMS FOR NEW ROWS
535: --------------------------------------------------------------------------------------
536:
537: -- Updating items rows
538: UPDATE MTL_SYSTEM_ITEMS_INTERFACE ISTI
539: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
540: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
541: --CONFIRM_STATUS = 'UN',
542: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID

Line 551: UPDATE MTL_SYSTEM_ITEMS_INTERFACE ISTI

547: FROM MTL_ITEM_BULKLOAD_RECS
548: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID)
549: AND ITEM_NUMBER IS NULL;
550:
551: UPDATE MTL_SYSTEM_ITEMS_INTERFACE ISTI
552: SET TRANSACTION_TYPE = C_TRANSACTION_SYNC,
553: PROCESS_FLAG = C_INIT_PROCESS_FLAG,
554: CONFIRM_STATUS = 'CN',
555: SOURCE_SYSTEM_ID = (SELECT SOURCE_SYSTEM_ID

Line 644: FROM MTL_SYSTEM_ITEMS_INTERFACE

640: END LOOP;
641:
642: UPDATE BOM_BILL_OF_MTLS_INTERFACE BBOMI
643: SET ORGANIZATION_ID = (SELECT ORGANIZATION_ID
644: FROM MTL_SYSTEM_ITEMS_INTERFACE
645: WHERE BUNDLE_ID = BBOMI.BUNDLE_ID
646: AND ROWNUM = 1),
647: ORGANIZATION_CODE = (SELECT mp.organization_code
648: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

Line 648: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

644: FROM MTL_SYSTEM_ITEMS_INTERFACE
645: WHERE BUNDLE_ID = BBOMI.BUNDLE_ID
646: AND ROWNUM = 1),
647: ORGANIZATION_CODE = (SELECT mp.organization_code
648: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
649: MTL_PARAMETERS mp
650: WHERE mp.organization_id = msii.organization_id
651: AND msii.BUNDLE_ID = BBOMI.BUNDLE_ID
652: AND ROWNUM = 1)

Line 660: FROM MTL_SYSTEM_ITEMS_INTERFACE

656: WHERE BUNDLE_COLLECTION_ID = X_BUNDLE_COLLECTION_ID);
657:
658: UPDATE BOM_INVENTORY_COMPS_INTERFACE BICI
659: SET ORGANIZATION_ID = (SELECT ORGANIZATION_ID
660: FROM MTL_SYSTEM_ITEMS_INTERFACE
661: WHERE BUNDLE_ID = BICI.BUNDLE_ID
662: AND ROWNUM = 1),
663: ORGANIZATION_CODE = (SELECT mp.organization_code
664: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

Line 664: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,

660: FROM MTL_SYSTEM_ITEMS_INTERFACE
661: WHERE BUNDLE_ID = BICI.BUNDLE_ID
662: AND ROWNUM = 1),
663: ORGANIZATION_CODE = (SELECT mp.organization_code
664: FROM MTL_SYSTEM_ITEMS_INTERFACE msii,
665: MTL_PARAMETERS mp
666: WHERE mp.organization_id = msii.organization_id
667: AND msii.BUNDLE_ID = BICI.BUNDLE_ID
668: AND ROWNUM = 1)

Line 678: mtl_system_items_interface msii

674: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
675: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
676: FROM ap_supplier_sites_all asa,
677: ap_supplier_sites_all asa2,
678: mtl_system_items_interface msii
679: WHERE asa.party_site_id = asa2.party_site_id
680: AND asa.vendor_id = EIUAI.pk1_value
681: AND asa2.vendor_site_id = EIUAI.pk2_value
682: AND asa.org_id = msii.organization_id

Line 696: mtl_system_items_interface msii

692: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
693: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
694: FROM ap_supplier_sites_all asa,
695: ap_supplier_sites_all asa2,
696: mtl_system_items_interface msii
697: WHERE asa.party_site_id = asa2.party_site_id
698: AND asa.vendor_id = EIAI.pk1_value
699: AND asa2.vendor_site_id = EIAI.pk2_value
700: AND asa.org_id = msii.organization_id

Line 714: mtl_system_items_interface msii

710: UPDATE EGO_ITM_USR_ATTR_INTRFC EIUAI
711: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
712: FROM ap_supplier_sites_all asa,
713: ap_supplier_sites_all asa2,
714: mtl_system_items_interface msii
715: WHERE asa.party_site_id = asa2.party_site_id
716: AND asa.vendor_id = EIUAI.pk1_value
717: AND asa2.vendor_site_id = EIUAI.pk2_value
718: AND asa.org_id = msii.organization_id

Line 732: mtl_system_items_interface msii

728: UPDATE EGO_ITEM_ASSOCIATIONS_INTF EIAI
729: SET pk2_value = (SELECT asa.VENDOR_SITE_ID
730: FROM ap_supplier_sites_all asa,
731: ap_supplier_sites_all asa2,
732: mtl_system_items_interface msii
733: WHERE asa.party_site_id = asa2.party_site_id
734: AND asa.vendor_id = EIAI.pk1_value
735: AND asa2.vendor_site_id = EIAI.pk2_value
736: AND asa.org_id = msii.organization_id

Line 831: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL

827: FUNCTION GET_NEXT_ID RETURN NUMBER
828: IS
829: l_id NUMBER;
830: BEGIN
831: SELECT MTL_SYSTEM_ITEMS_INTERFACE_S.NEXTVAL
832: INTO l_id
833: FROM dual;
834:
835: RETURN l_id;

Line 1288: -- Step 4: Insert Data into MTL_SYSTEM_ITEMS_INTERFACE

1284:
1285: l_source_sys_reference := l_xml_null_chk.getStringVal();
1286: l_transaction_id := GET_NEXT_ID();
1287:
1288: -- Step 4: Insert Data into MTL_SYSTEM_ITEMS_INTERFACE
1289: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE(
1290: message_timestamp,
1291: transaction_id,
1292: top_item_flag,

Line 1289: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE(

1285: l_source_sys_reference := l_xml_null_chk.getStringVal();
1286: l_transaction_id := GET_NEXT_ID();
1287:
1288: -- Step 4: Insert Data into MTL_SYSTEM_ITEMS_INTERFACE
1289: INSERT INTO MTL_SYSTEM_ITEMS_INTERFACE(
1290: message_timestamp,
1291: transaction_id,
1292: top_item_flag,
1293: bundle_id,

Line 1493: -- Step 5: Insert Data for translatable entries for MTL_SYSTEM_ITEMS_INTERFACE

1489: l_last_update_date,
1490: l_last_update_login
1491: );
1492:
1493: -- Step 5: Insert Data for translatable entries for MTL_SYSTEM_ITEMS_INTERFACE
1494:
1495: SELECT XMLELEMENT("TL", l_xml_ItemEBO.items.extract('/Item/ItemIdentification/Name'))
1496: INTO l_xml_trans
1497: FROM DUAL;

Line 1501: PROCESS_TL_ROWS(p_table_name => 'MTL_SYSTEM_ITEMS_INTERFACE',

1497: FROM DUAL;
1498:
1499: IF l_xml_trans IS NOT NULL
1500: THEN
1501: PROCESS_TL_ROWS(p_table_name => 'MTL_SYSTEM_ITEMS_INTERFACE',
1502: p_batch_id => l_batch_id,
1503: p_unique_id => l_transaction_id,
1504: p_bundle_id => l_bundle_id,
1505: p_xml_data => l_xml_trans,

Line 1516: PROCESS_TL_ROWS(p_table_name => 'MTL_SYSTEM_ITEMS_INTERFACE',

1512: FROM DUAL;
1513:
1514: IF l_xml_trans IS NOT NULL
1515: THEN
1516: PROCESS_TL_ROWS(p_table_name => 'MTL_SYSTEM_ITEMS_INTERFACE',
1517: p_batch_id => l_batch_id,
1518: p_unique_id => l_transaction_id,
1519: p_bundle_id => l_bundle_id,
1520: p_xml_data => l_xml_trans,