[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
4833: FROM eng_revised_components erc
4834: WHERE erc.change_notice = p_change_notice
4835: AND erc.ACD_TYPE = 3
4836: AND erc.revised_item_sequence_id = cp_revised_item_sequence_id
4837: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4838: WHERE ecpm.change_id = p_change_id
4839: AND ecpm.local_organization_id = p_local_organization_id
4840: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4841: AND ecpm.revised_line_id1 = erc.component_sequence_id
4852: SELECT *
4853: FROM bom_components_b bcb
4854: WHERE change_notice = p_change_notice
4855: AND revised_item_sequence_id = cp_revised_item_sequence_id
4856: AND NOT EXISTS (SELECT 1 FROM eng_change_propagation_maps ecpm
4857: WHERE ecpm.change_id = p_change_id
4858: AND ecpm.local_organization_id = p_local_organization_id
4859: AND ecpm.revised_line_type = Eng_Propagation_Log_Util.G_REV_LINE_CMP_CHG
4860: AND ecpm.revised_line_id1 = bcb.component_sequence_id
5577: WHERE eri.change_id = l_global_change_id
5578: AND transfer_or_copy is NULL
5579: AND NOT EXISTS
5580: (SELECT 1
5581: FROM eng_change_propagation_maps ecpm
5582: WHERE ecpm.change_id = eri.change_id
5583: AND ecpm.local_organization_id = p_local_organization_id
5584: AND ecpm.revised_item_sequence_id = eri.revised_item_sequence_id
5585: AND ecpm.entity_name = Eng_Propagation_Log_Util.G_ENTITY_REVISED_ITEM
6020: --
6021: -- If it deoes not exist, INSERT
6022: IF l_change_map_id IS NULL
6023: THEN
6024: SELECT eng_change_propagation_maps_s.nextval
6025: INTO l_change_map_id
6026: FROM DUAL;
6027:
6028: INSERT INTO eng_change_propagation_maps(
6024: SELECT eng_change_propagation_maps_s.nextval
6025: INTO l_change_map_id
6026: FROM DUAL;
6027:
6028: INSERT INTO eng_change_propagation_maps(
6029: change_propagation_map_id
6030: , change_id
6031: , request_id
6032: , local_organization_id
6053: );
6054: --
6055: -- Else UPDATE
6056: ELSE
6057: UPDATE eng_change_propagation_maps
6058: SET request_id = p_request_id
6059: , creation_date = SYSDATE
6060: , created_by = FND_GLOBAL.USER_ID
6061: , last_update_date = SYSDATE