[Home] [Help]
677: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
678: bom_ref_desgs_ifce_key
679: --Bug 3396529: Added New_revised_Item_Revision
680: , New_revised_Item_Revision
681: FROM bom_ref_desgs_interface
682: WHERE eng_changes_ifce_key = g_ECO_ifce_key
683: and process_flag = 1
684: AND (g_all_org = 1
685: OR
689: -- Group reference desgs by ECO Header ifce values
690:
691: CURSOR GetRfdWithSameECOifce IS
692: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
693: FROM bom_ref_desgs_interface
694: WHERE process_flag = 1
695: AND (g_all_org = 1
696: OR
697: (g_all_org = 2 AND organization_id = g_org_id));
714: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
715: bom_ref_desgs_ifce_key
716: --Bug 3396529: Added New_revised_Item_Revision
717: , New_revised_Item_Revision
718: FROM bom_ref_desgs_interface
719: WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
720: AND interface_entity_type = 'ECO'
721: AND process_flag = 1
722: AND (g_all_org = 1
727: -- Group reference desgs by revised item ifce values
728:
729: CURSOR GetRfdWithSameItemifce IS
730: SELECT DISTINCT(eng_revised_items_ifce_key) item_ifce_key
731: FROM bom_ref_desgs_interface
732: WHERE process_flag = 1
733: AND (g_all_org = 1
734: OR
735: (g_all_org = 2 AND organization_id = g_org_id));
752: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
753: bom_ref_desgs_ifce_key
754: --Bug 3396529: Added New_revised_Item_Revision
755: , New_revised_Item_Revision
756: FROM bom_ref_desgs_interface
757: WHERE bom_inventory_comps_ifce_key = g_revised_comp_ifce_key
758: AND interface_entity_type = 'ECO'
759: AND process_flag = 1
760: AND (g_all_org = 1
765: -- Group reference desgs by revised component ifce values
766:
767: CURSOR GetRfdWithSameCompifce IS
768: SELECT DISTINCT(bom_inventory_comps_ifce_key) comp_ifce_key
769: FROM bom_ref_desgs_interface
770: WHERE process_flag = 1
771: AND (g_all_org = 1
772: OR
773: (g_all_org = 2 AND organization_id = g_org_id));
790: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
791: bom_ref_desgs_ifce_key
792: --Bug 3396529: Added New_revised_Item_Revision
793: , New_revised_Item_Revision
794: FROM bom_ref_desgs_interface
795: WHERE process_flag = 1
796: AND (g_all_org = 1
797: OR
798: (g_all_org = 2 AND organization_id = g_org_id));
1003: UPDATE bom_sub_comps_interface
1004: SET PROCESS_FLAG = l_process_flag
1005: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1006:
1007: UPDATE bom_ref_desgs_interface
1008: SET PROCESS_FLAG = l_process_flag
1009: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1010:
1011: UPDATE bom_op_resources_interface
1343: p_ref_desg_tbl BOM_Bo_PUB.Ref_Designator_Tbl_Type
1344: ) IS
1345: BEGIN
1346: FOR i IN 1..p_ref_desg_tbl.COUNT LOOP
1347: UPDATE bom_ref_desgs_interface SET
1348: -- component_reference_designator = p_ref_desg_tbl(i).ref_designator,
1349: -- last_update_date = p_ref_desg_tbl(i).last_update_date,
1350: -- last_updated_by = p_ref_desg_tbl(i).last_updated_by,
1351: -- creation_date = p_ref_desg_tbl(i).creation_date,
3082: FROM mtl_parameters mp2
3083: WHERE mp2.organization_code = bsci.organization_code);
3084:
3085: stmt_num := 8;
3086: UPDATE bom_ref_desgs_interface brdi
3087: SET organization_id = (SELECT organization_id
3088: FROM mtl_parameters mp1
3089: WHERE mp1.organization_code = brdi.organization_code)
3090: WHERE process_flag = 1
3198: OR
3199: (p_all_org = 2 AND organization_id = p_org_id));
3200:
3201: stmt_num := 10.6;
3202: UPDATE bom_ref_desgs_interface
3203: SET transaction_id = mtl_system_items_interface_s.nextval,
3204: transaction_type = UPPER(transaction_type)
3205: WHERE process_flag = 1
3206: AND (transaction_id is NULL
6177: END LOOP;
6178:
6179: stmt_num := 517;
6180: LOOP
6181: DELETE from bom_ref_desgs_interface
6182: WHERE process_flag = 7
6183: AND rownum < G_ROWS_TO_COMMIT;
6184:
6185: EXIT when SQL%NOTFOUND;