[Home] [Help]
673: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
674: bom_ref_desgs_ifce_key
675: --Bug 3396529: Added New_revised_Item_Revision
676: , New_revised_Item_Revision
677: FROM bom_ref_desgs_interface
678: WHERE eng_changes_ifce_key = g_ECO_ifce_key
679: and process_flag = 1
680: AND (g_all_org = 1
681: OR
685: -- Group reference desgs by ECO Header ifce values
686:
687: CURSOR GetRfdWithSameECOifce IS
688: SELECT DISTINCT(eng_changes_ifce_key) eco_ifce_key
689: FROM bom_ref_desgs_interface
690: WHERE process_flag = 1
691: AND (g_all_org = 1
692: OR
693: (g_all_org = 2 AND organization_id = g_org_id));
710: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
711: bom_ref_desgs_ifce_key
712: --Bug 3396529: Added New_revised_Item_Revision
713: , New_revised_Item_Revision
714: FROM bom_ref_desgs_interface
715: WHERE eng_revised_items_ifce_key = g_revised_item_ifce_key
716: AND interface_entity_type = 'ECO'
717: AND process_flag = 1
718: AND (g_all_org = 1
723: -- Group reference desgs by revised item ifce values
724:
725: CURSOR GetRfdWithSameItemifce IS
726: SELECT DISTINCT(eng_revised_items_ifce_key) item_ifce_key
727: FROM bom_ref_desgs_interface
728: WHERE process_flag = 1
729: AND (g_all_org = 1
730: OR
731: (g_all_org = 2 AND organization_id = g_org_id));
748: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
749: bom_ref_desgs_ifce_key
750: --Bug 3396529: Added New_revised_Item_Revision
751: , New_revised_Item_Revision
752: FROM bom_ref_desgs_interface
753: WHERE bom_inventory_comps_ifce_key = g_revised_comp_ifce_key
754: AND interface_entity_type = 'ECO'
755: AND process_flag = 1
756: AND (g_all_org = 1
761: -- Group reference desgs by revised component ifce values
762:
763: CURSOR GetRfdWithSameCompifce IS
764: SELECT DISTINCT(bom_inventory_comps_ifce_key) comp_ifce_key
765: FROM bom_ref_desgs_interface
766: WHERE process_flag = 1
767: AND (g_all_org = 1
768: OR
769: (g_all_org = 2 AND organization_id = g_org_id));
786: eng_revised_items_ifce_key, bom_inventory_comps_ifce_key,
787: bom_ref_desgs_ifce_key
788: --Bug 3396529: Added New_revised_Item_Revision
789: , New_revised_Item_Revision
790: FROM bom_ref_desgs_interface
791: WHERE process_flag = 1
792: AND (g_all_org = 1
793: OR
794: (g_all_org = 2 AND organization_id = g_org_id));
999: UPDATE bom_sub_comps_interface
1000: SET PROCESS_FLAG = l_process_flag
1001: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1002:
1003: UPDATE bom_ref_desgs_interface
1004: SET PROCESS_FLAG = l_process_flag
1005: WHERE ENG_CHANGES_IFCE_KEY = g_ECO_ifce_key;
1006:
1007: UPDATE bom_op_resources_interface
1339: p_ref_desg_tbl BOM_Bo_PUB.Ref_Designator_Tbl_Type
1340: ) IS
1341: BEGIN
1342: FOR i IN 1..p_ref_desg_tbl.COUNT LOOP
1343: UPDATE bom_ref_desgs_interface SET
1344: -- component_reference_designator = p_ref_desg_tbl(i).ref_designator,
1345: -- last_update_date = p_ref_desg_tbl(i).last_update_date,
1346: -- last_updated_by = p_ref_desg_tbl(i).last_updated_by,
1347: -- creation_date = p_ref_desg_tbl(i).creation_date,
3076: FROM mtl_parameters mp2
3077: WHERE mp2.organization_code = bsci.organization_code);
3078:
3079: stmt_num := 8;
3080: UPDATE bom_ref_desgs_interface brdi
3081: SET organization_id = (SELECT organization_id
3082: FROM mtl_parameters mp1
3083: WHERE mp1.organization_code = brdi.organization_code)
3084: WHERE process_flag = 1
3192: OR
3193: (p_all_org = 2 AND organization_id = p_org_id));
3194:
3195: stmt_num := 10.6;
3196: UPDATE bom_ref_desgs_interface
3197: SET transaction_id = mtl_system_items_interface_s.nextval,
3198: transaction_type = UPPER(transaction_type)
3199: WHERE process_flag = 1
3200: AND (transaction_id is NULL
6147: END LOOP;
6148:
6149: stmt_num := 517;
6150: LOOP
6151: DELETE from bom_ref_desgs_interface
6152: WHERE process_flag = 7
6153: AND rownum < G_ROWS_TO_COMMIT;
6154:
6155: EXIT when SQL%NOTFOUND;