eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2018: FROM eng_engineering_changes

2014:
2015:
2016: SELECT count(*)
2017: into temp_count
2018: FROM eng_engineering_changes
2019: WHERE change_notice = p_change_notice
2020: AND organization_id = l_org_id;
2021:
2022: -- Fetch ECO Masters

Line 3298: FROM eng_engineering_changes

3294: if (l_return_status = 'S') THEN
3295: /*bug #7496156 to Copy attached Document*/
3296: BEGIN
3297: SELECT change_id INTO l_new_change_id
3298: FROM eng_engineering_changes
3299: WHERE change_notice = p_change_notice
3300: AND organization_id = l_org_id;
3301: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org '||l_org_id );
3302: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org Code '||l_org_Code );

Line 3305: X_from_entity_name => 'ENG_ENGINEERING_CHANGES',

3301: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org '||l_org_id );
3302: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Org Code '||l_org_Code );
3303: FND_File.put_line(FND_FILE.log, 'Copy ECO attachment Start for Change_id '||l_new_change_id );
3304: fnd_attached_documents2_pkg.copy_attachments(
3305: X_from_entity_name => 'ENG_ENGINEERING_CHANGES',
3306: X_from_pk1_value => ECO_rec.change_id,
3307: X_from_pk2_value => '',
3308: X_from_pk3_value => '',
3309: X_from_pk4_value => '',

Line 3311: X_to_entity_name => 'ENG_ENGINEERING_CHANGES',

3307: X_from_pk2_value => '',
3308: X_from_pk3_value => '',
3309: X_from_pk4_value => '',
3310: X_from_pk5_value => '',
3311: X_to_entity_name => 'ENG_ENGINEERING_CHANGES',
3312: X_to_pk1_value => l_new_change_id,
3313: X_to_pk2_value => '',
3314: X_to_pk3_value => '',
3315: X_to_pk4_value => '',

Line 4028: FROM eng_engineering_changes

4024: ) IS
4025:
4026: CURSOR c_change_notice IS
4027: SELECT G_VAL_EXISTS
4028: FROM eng_engineering_changes
4029: WHERE change_notice = p_change_notice
4030: AND organization_id = p_organization_id;
4031:
4032: l_change_exists NUMBER;

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

4075: l_schedule_immediately ENG_ORG_HIERARCHY_POLICIES.SCHEDULE_IMMEDIATELY_FLAG%TYPE;
4076: l_new_status_type NUMBER;
4077: CURSOR c_get_schedule_enabled IS
4078: SELECT eohp.SCHEDULE_IMMEDIATELY_FLAG
4079: FROM ENG_ORG_HIERARCHY_POLICIES eohp, ENG_TYPE_ORG_HIERARCHIES etoh, eng_engineering_changes eec
4080: WHERE eec.change_id = p_local_change_id
4081: AND eohp.organization_id = eec.organization_id
4082: AND eohp.SCHEDULE_IMMEDIATELY_FLAG = 'Y'
4083: AND eohp.change_type_org_hierarchy_id = etoh.change_type_org_hierarchy_id

Line 4110: FROM eng_engineering_changes

4106: AND els1.status_code = ecs1.status_code
4107: AND ((ecs1.status_type = 4 AND l_schedule_immediately = 'Y')
4108: OR nvl(l_schedule_immediately, 'N') = 'N'))
4109: AND EXISTS (SELECT 1
4110: FROM eng_engineering_changes
4111: WHERE change_id = els.entity_id1
4112: AND status_type = 0);
4113: BEGIN
4114: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4224: FROM eng_engineering_changes

4220: -- Cursor to Pick all ECO header for the Top Organization for the given
4221: -- Change Notice
4222: CURSOR c_eco_rec IS
4223: SELECT *
4224: FROM eng_engineering_changes
4225: WHERE change_notice = p_change_notice
4226: AND organization_id = p_organization_id;
4227:
4228: -- Cursor to Pick all Revised Items for the Top Organization for the given

Line 5711: FROM eng_engineering_changes

5707: WHERE organization_id = cp_organization_id;
5708:
5709: CURSOR c_change_header IS
5710: SELECT change_id
5711: FROM eng_engineering_changes
5712: WHERE change_notice = p_change_notice
5713: AND organization_id = p_organization_id;
5714: ---added Bug no 4327321 only revised items will get propagate.No transfer and copy items
5715: CURSOR c_prp_revised_item IS

Line 6211: FROM eng_engineering_changes eec

6207: ) IS
6208:
6209: CURSOR c_local_orgs IS
6210: SELECT eclo.local_organization_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

Line 6427: l_change_notice eng_engineering_changes.change_notice%TYPE;

6423: , x_msg_data OUT NOCOPY VARCHAR2 --
6424: ) IS
6425:
6426: l_org_hierarchy_level_id NUMBER;
6427: l_change_notice eng_engineering_changes.change_notice%TYPE;
6428: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
6429:
6430: CURSOR c_change_details IS
6431: SELECT change_notice, organization_id

Line 6432: FROM eng_engineering_changes

6428: l_org_code_list INV_OrgHierarchy_PVT.OrgID_tbl_type;
6429:
6430: CURSOR c_change_details IS
6431: SELECT change_notice, organization_id
6432: FROM eng_engineering_changes
6433: WHERE change_id = p_change_id;
6434:
6435: l_api_name CONSTANT VARCHAR2(30) := 'PreProcess_Propagate_Request';
6436: l_api_version CONSTANT NUMBER := 1.0;