APPS.ENGECOBO dependencies on ENG_ENGINEERING_CHANGES

Line 181: FROM eng_engineering_changes eec

177: ) IS
178:
179: CURSOR c_local_change_order IS
180: SELECT eec.change_id
181: FROM eng_engineering_changes eec
182: , eng_change_obj_relationships ecor
183: WHERE eec.change_id = ecor.object_to_id1
184: AND ecor.relationship_code IN ( 'PROPAGATED_TO', 'TRANSFERRED_TO' )
185: AND ecor.object_to_name ='ENG_CHANGE'

Line 1999: FROM eng_engineering_changes

1995:
1996:
1997: SELECT count(*)
1998: into temp_count
1999: FROM eng_engineering_changes
2000: WHERE change_notice = p_change_notice
2001: AND organization_id = l_org_id;
2002:
2003: -- Fetch ECO Masters

Line 3903: FROM eng_engineering_changes

3899: ) IS
3900:
3901: CURSOR c_change_notice IS
3902: SELECT G_VAL_EXISTS
3903: FROM eng_engineering_changes
3904: WHERE change_notice = p_change_notice
3905: AND organization_id = p_organization_id;
3906:
3907: l_change_exists NUMBER;

Line 3954: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec

3950: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
3951: l_new_status_type NUMBER;
3952: CURSOR c_get_schedule_enabled IS
3953: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
3954: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec
3955: WHERE eec.change_id = p_local_change_id
3956: AND eohp.organization_id = eec.organization_id
3957: AND eohp.SCHEDULE_IMMEDIATELY_FLAG = 'Y'
3958: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id

Line 3985: FROM eng_engineering_changes

3981: AND els1.status_code = ecs1.status_code
3982: AND ((ecs1.status_type = 4 AND l_schedule_immediately = 'Y')
3983: OR nvl(l_schedule_immediately, 'N') = 'N'))
3984: AND EXISTS (SELECT 1
3985: FROM eng_engineering_changes
3986: WHERE change_id = els.entity_id1
3987: AND status_type = 0);
3988: BEGIN
3989: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4099: FROM eng_engineering_changes

4095: -- Cursor to Pick all ECO header for the Top Organization for the given
4096: -- Change Notice
4097: CURSOR c_eco_rec IS
4098: SELECT *
4099: FROM eng_engineering_changes
4100: WHERE change_notice = p_change_notice
4101: AND organization_id = p_organization_id;
4102:
4103: -- Cursor to Pick all Revised Items for the Top Organization for the given

Line 5570: FROM eng_engineering_changes

5566: WHERE organization_id = cp_organization_id;
5567:
5568: CURSOR c_change_header IS
5569: SELECT change_id
5570: FROM eng_engineering_changes
5571: WHERE change_notice = p_change_notice
5572: AND organization_id = p_organization_id;
5573: ---added Bug no 4327321 only revised items will get propagate.No transfer and copy items
5574: CURSOR c_prp_revised_item IS

Line 5738: FROM eng_engineering_changes eec

5734: ) IS
5735:
5736: CURSOR c_local_orgs IS
5737: SELECT eclo.local_organization_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

Line 5954: l_change_notice eng_engineering_changes.change_notice%TYPE;

5950: , x_msg_data OUT NOCOPY VARCHAR2 --
5951: ) IS
5952:
5953: l_org_hierarchy_level_id NUMBER;
5954: l_change_notice eng_engineering_changes.change_notice%TYPE;
5955: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
5956:
5957: CURSOR c_change_details IS
5958: SELECT change_notice, organization_id

Line 5959: FROM eng_engineering_changes

5955: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
5956:
5957: CURSOR c_change_details IS
5958: SELECT change_notice, organization_id
5959: FROM eng_engineering_changes
5960: WHERE change_id = p_change_id;
5961:
5962: l_api_name CONSTANT VARCHAR2(30) := 'PreProcess_Propagate_Request';
5963: l_api_version CONSTANT NUMBER := 1.0;