[Home] [Help]
292: AND NOT EXISTS (SELECT 1 FROM MTL_PARAMETERS MP
293: WHERE MP.organization_id = g_global_org_id
294: AND MP.master_organization_id = MP.organization_id)
295: ))
296: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
297: WHERE ecpm.change_id = p_change_id
298: AND ecpm.local_organization_id = p_local_organization_id
299: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
300: AND ecpm.revised_line_id1 = eac.change_document_id
788: AND NOT EXISTS (SELECT 1 FROM MTL_PARAMETERS MP
789: WHERE MP.organization_id = p_global_organization_id
790: AND MP.master_organization_id = MP.organization_id)
791: ))
792: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
793: WHERE ecpm.change_id = p_change_id
794: AND ecpm.local_organization_id = p_local_organization_id
795: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
796: AND ecpm.revised_line_id1 = eac.change_document_id
804: AND eac.entity_name = 'MTL_SYSTEM_ITEMS'
805: AND EXISTS(SELECT 1 FROM MTL_PARAMETERS MP
806: WHERE MP.organization_id = p_global_organization_id
807: AND MP.master_organization_id = MP.organization_id)
808: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
809: WHERE ecpm.change_id = p_change_id
810: AND ecpm.local_organization_id = p_local_organization_id
811: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_ATCH_CHG
812: AND ecpm.revised_line_id1 = eac.change_document_id
4960: FROM eng_revised_components erc
4961: WHERE erc.change_notice = p_change_notice
4962: AND erc.ACD_TYPE = 3
4963: AND erc.revised_item_sequence_id = cp_revised_item_sequence_id
4964: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4965: WHERE ecpm.change_id = p_change_id
4966: AND ecpm.local_organization_id = p_local_organization_id
4967: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4968: AND ecpm.revised_line_id1 = erc.component_sequence_id
4979: SELECT *
4980: FROM bom_components_b bcb
4981: WHERE change_notice = p_change_notice
4982: AND revised_item_sequence_id = cp_revised_item_sequence_id
4983: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4984: WHERE ecpm.change_id = p_change_id
4985: AND ecpm.local_organization_id = p_local_organization_id
4986: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4987: AND ecpm.revised_line_id1 = bcb.component_sequence_id
5718: WHERE eri.change_id = l_global_change_id
5719: AND transfer_or_copy is NULL
5720: AND NOT EXISTS
5721: (SELECT 1
5722: FROM eng_change_propagation_maps ecpm
5723: WHERE ecpm.change_id = eri.change_id
5724: AND ecpm.local_organization_id = p_local_organization_id
5725: AND ecpm.revised_item_sequence_id = eri.revised_item_sequence_id
5726: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
6493: --
6494: -- If it deoes not exist, INSERT
6495: IF l_change_map_id IS NULL
6496: THEN
6497: SELECT eng_change_propagation_maps_s.nextval
6498: INTO l_change_map_id
6499: FROM DUAL;
6500:
6501: INSERT INTO eng_change_propagation_maps(
6497: SELECT eng_change_propagation_maps_s.nextval
6498: INTO l_change_map_id
6499: FROM DUAL;
6500:
6501: INSERT INTO eng_change_propagation_maps(
6502: change_propagation_map_id
6503: , change_id
6504: , request_id
6505: , local_organization_id
6526: );
6527: --
6528: -- Else UPDATE
6529: ELSE
6530: UPDATE eng_change_propagation_maps
6531: SET request_id = p_request_id
6532: , creation_date = SYSDATE
6533: , created_by = FND_GLOBAL.USER_ID
6534: , last_update_date = SYSDATE