[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
1945: SELECT MP.organization_id
1946: INTO l_org_hierarchy_level_id
1947: FROM HR_ORGANIZATION_UNITS HOU
1948: , HR_ORGANIZATION_INFORMATION HOI1
1949: , MTL_PARAMETERS MP
1950: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
1951: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
1952: AND HOI1.ORG_INFORMATION1 = 'INV'
1953: AND HOI1.ORG_INFORMATION2 = 'Y'
1998: BEGIN
1999:
2000: SELECT organization_code
2001: INTO l_org_code
2002: FROM mtl_parameters
2003: WHERE organization_id = l_org_id;
2004: EXCEPTION
2005: WHEN NO_DATA_FOUND THEN
2006: NULL;
5677:
5678: l_api_name CONSTANT VARCHAR2(30) := 'PROPAGATE_ECO_PLM';
5679: l_api_version CONSTANT NUMBER := 1.0;
5680:
5681: l_org_code mtl_parameters.organization_code%TYPE;
5682: l_global_org_code mtl_parameters.organization_code%TYPE;
5683: l_global_change_id NUMBER;
5684: l_local_change_id NUMBER;
5685: -- this corresponds to the processing status that will have to be updated to the change
5678: l_api_name CONSTANT VARCHAR2(30) := 'PROPAGATE_ECO_PLM';
5679: l_api_version CONSTANT NUMBER := 1.0;
5680:
5681: l_org_code mtl_parameters.organization_code%TYPE;
5682: l_global_org_code mtl_parameters.organization_code%TYPE;
5683: l_global_change_id NUMBER;
5684: l_local_change_id NUMBER;
5685: -- this corresponds to the processing status that will have to be updated to the change
5686: l_top_entity_process_status NUMBER;
5702: -- Bug# 9498305 End
5703:
5704: CURSOR c_fetch_org_code(cp_organization_id NUMBER) IS
5705: SELECT organization_code
5706: FROM mtl_parameters
5707: WHERE organization_id = cp_organization_id;
5708:
5709: CURSOR c_change_header IS
5710: SELECT change_id
6211: FROM eng_engineering_changes eec
6212: , eng_change_local_orgs eclo
6213: , hr_all_organization_units org
6214: , hr_organization_information hoi
6215: , mtl_parameters mp
6216: WHERE eec.change_notice = p_change_notice
6217: AND eec.organization_id = p_organization_id
6218: AND eclo.change_id = eec.change_id
6219: AND org.organization_id = hoi.organization_id
6311: CURSOR c_organization_details IS
6312: SELECT MP.organization_id
6313: FROM HR_ORGANIZATION_UNITS HOU
6314: , HR_ORGANIZATION_INFORMATION HOI1
6315: , MTL_PARAMETERS MP
6316: WHERE HOU.ORGANIZATION_ID = HOI1.ORGANIZATION_ID
6317: AND HOU.ORGANIZATION_ID = MP.ORGANIZATION_ID
6318: AND HOI1.ORG_INFORMATION1 = 'INV'
6319: AND HOI1.ORG_INFORMATION2 = 'Y'