[Home] [Help]
288: AND eac.revised_item_sequence_id = cp_revised_item_sequence_id
289: AND eac.attachment_id = fad.attached_document_id(+)
290: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'
291: OR (eac.entity_name = 'MTL_SYSTEM_ITEMS'
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
784: AND eac.revised_item_sequence_id = p_rev_item_sequence_id
785: AND eac.attachment_id = fad.attached_document_id(+)
786: AND (eac.entity_name = 'MTL_ITEM_REVISIONS'
787: OR (eac.entity_name = 'MTL_SYSTEM_ITEMS'
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
801: FROM eng_attachment_changes eac
802: WHERE eac.change_id = p_change_id
803: AND eac.revised_item_sequence_id = p_rev_item_sequence_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
1926: SELECT MP.organization_id
1927: INTO l_org_hierarchy_level_id
1928: FROM HR_ORGANIZATION_UNITS HOU
1929: , HR_ORGANIZATION_INFORMATION HOI1
1930: , MTL_PARAMETERS MP
1931: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
1932: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
1933: AND HOI1.ORG_INFORMATION1 = 'INV'
1934: AND HOI1.ORG_INFORMATION2 = 'Y'
1979: BEGIN
1980:
1981: SELECT organization_code
1982: INTO l_org_code
1983: FROM mtl_parameters
1984: WHERE organization_id = l_org_id;
1985: EXCEPTION
1986: WHEN NO_DATA_FOUND THEN
1987: NULL;
5549:
5550: l_api_name CONSTANT VARCHAR2(30) := 'PROPAGATE_ECO_PLM';
5551: l_api_version CONSTANT NUMBER := 1.0;
5552:
5553: l_org_code mtl_parameters.organization_code%TYPE;
5554: l_global_org_code mtl_parameters.organization_code%TYPE;
5555: l_global_change_id NUMBER;
5556: l_local_change_id NUMBER;
5557: -- this corresponds to the processing status that will have to be updated to the change
5550: l_api_name CONSTANT VARCHAR2(30) := 'PROPAGATE_ECO_PLM';
5551: l_api_version CONSTANT NUMBER := 1.0;
5552:
5553: l_org_code mtl_parameters.organization_code%TYPE;
5554: l_global_org_code mtl_parameters.organization_code%TYPE;
5555: l_global_change_id NUMBER;
5556: l_local_change_id NUMBER;
5557: -- this corresponds to the processing status that will have to be updated to the change
5558: l_top_entity_process_status NUMBER;
5561: l_return_status VARCHAR2(1);
5562:
5563: CURSOR c_fetch_org_code(cp_organization_id NUMBER) IS
5564: SELECT organization_code
5565: FROM mtl_parameters
5566: WHERE organization_id = cp_organization_id;
5567:
5568: CURSOR c_change_header IS
5569: SELECT change_id
5738: FROM eng_engineering_changes eec
5739: , eng_change_local_orgs eclo
5740: , hr_all_organization_units org
5741: , hr_organization_information hoi
5742: , mtl_parameters mp
5743: WHERE eec.change_notice = p_change_notice
5744: AND eec.organization_id = p_organization_id
5745: AND eclo.change_id = eec.change_id
5746: AND org.organization_id = hoi.organization_id
5838: CURSOR c_organization_details IS
5839: SELECT MP.organization_id
5840: FROM HR_ORGANIZATION_UNITS HOU
5841: , HR_ORGANIZATION_INFORMATION HOI1
5842: , MTL_PARAMETERS MP
5843: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
5844: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
5845: AND HOI1.ORG_INFORMATION1 = 'INV'
5846: AND HOI1.ORG_INFORMATION2 = 'Y'