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.ENG_ECO_UTIL dependencies on ENG_ENGINEERING_CHANGES

Line 303: SELECT STATUS_TYPE INTO l_status_type FROM ENG_ENGINEERING_CHANGES WHERE CHANGE_NOTICE = p_change_notice AND ORGANIZATION_ID = p_org_id;

299: -- Code added for bug 9243978 Starts here
300: IF (x_status IS NOT NULL AND (x_status = 'Cancelled' OR x_status = 'Terminated' OR x_status = 'Error')) THEN
301: BEGIN
302: IF (p_change_id IS NULL) THEN
303: SELECT STATUS_TYPE INTO l_status_type FROM ENG_ENGINEERING_CHANGES WHERE CHANGE_NOTICE = p_change_notice AND ORGANIZATION_ID = p_org_id;
304: ELSE
305: SELECT STATUS_TYPE INTO l_status_type FROM ENG_ENGINEERING_CHANGES WHERE CHANGE_ID = p_change_id;
306: END IF;
307: EXCEPTION

Line 305: SELECT STATUS_TYPE INTO l_status_type FROM ENG_ENGINEERING_CHANGES WHERE CHANGE_ID = p_change_id;

301: BEGIN
302: IF (p_change_id IS NULL) THEN
303: SELECT STATUS_TYPE INTO l_status_type FROM ENG_ENGINEERING_CHANGES WHERE CHANGE_NOTICE = p_change_notice AND ORGANIZATION_ID = p_org_id;
304: ELSE
305: SELECT STATUS_TYPE INTO l_status_type FROM ENG_ENGINEERING_CHANGES WHERE CHANGE_ID = p_change_id;
306: END IF;
307: EXCEPTION
308: WHEN OTHERS THEN
309: NULL;

Line 341: UPDATE eng_engineering_changes

337: UPDATE eng_revised_items
338: SET implementation_req_id = x_request_id
339: WHERE revised_item_sequence_id = p_rev_item_seq_id;
340: ELSE
341: UPDATE eng_engineering_changes
342: SET implementation_req_id = x_request_id
343: WHERE change_notice = p_change_notice
344: AND organization_id = p_org_id;
345: END IF ;

Line 1376: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS

1372: -- R12 Changes for common BOM
1373: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1374: -- Cursor to Fetch all source bill's component changes that are being updated
1375: -- by reschedule
1376: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS
1377: SELECT bcb.component_sequence_id
1378: FROM bom_components_b bcb
1379: WHERE bcb.CHANGE_NOTICE = cp_change_notice
1380: AND exists

Line 1459: FROM eng_engineering_changes

1455: END IF;
1456:
1457: SELECT change_notice, organization_id
1458: INTO x_change_notice, x_organization_id
1459: FROM eng_engineering_changes
1460: WHERE change_id = p_change_id;
1461:
1462: Update Eng_Revised_Items eri
1463: Set eri.scheduled_date = p_effectivity_date,

Line 1794: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS

1790: -- R12 Changes for common BOM
1791: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1792: -- Cursor to Fetch all source bill's component changes that are being updated
1793: -- by reschedule
1794: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS
1795: SELECT bcb.component_sequence_id
1796: FROM bom_components_b bcb
1797: WHERE bcb.CHANGE_NOTICE = cp_change_notice
1798: AND exists

Line 1896: FROM eng_engineering_changes

1892: END IF;
1893:
1894: SELECT change_notice, organization_id
1895: INTO x_change_notice, x_organization_id
1896: FROM eng_engineering_changes
1897: WHERE change_id = p_change_id;
1898:
1899: Update Eng_Revised_Items eri
1900: Set eri.scheduled_date = p_effectivity_date,

Line 2765: UPDATE eng_engineering_changes

2761: l_change_name := p_eco_rec.change_name;
2762: END IF;
2763:
2764:
2765: UPDATE eng_engineering_changes
2766: SET attribute7 = p_eco_rec.attribute7,
2767: attribute8 = p_eco_rec.attribute8,
2768: attribute9 = p_eco_rec.attribute9,
2769: attribute10 = p_eco_rec.attribute10,

Line 3117: INSERT INTO ENG_ENGINEERING_CHANGES

3113: Then
3114: Error_Handler.write_debug('Start to insert');
3115: END IF;
3116:
3117: INSERT INTO ENG_ENGINEERING_CHANGES
3118: ( ATTRIBUTE7
3119: , ATTRIBUTE8
3120: , ATTRIBUTE9
3121: , ATTRIBUTE10

Line 3329: DELETE FROM ENG_ENGINEERING_CHANGES

3325:
3326: x_return_status := FND_API.G_RET_STS_SUCCESS;
3327:
3328: BEGIN
3329: DELETE FROM ENG_ENGINEERING_CHANGES
3330: WHERE CHANGE_NOTICE = p_change_notice
3331: AND ORGANIZATION_ID = p_organization_id;
3332:
3333: EXCEPTION

Line 3662: FROM ENG_ENGINEERING_CHANGES

3658: , l_ECO_Unexp_rec.source_type_code -- Eng Chagne
3659: , l_ECO_Unexp_rec.source_id -- Eng Chagne
3660: , l_ECO_rec.effort -- Eng Chagne
3661: , l_eco_unexp_rec.hierarchy_id --bug 10108394
3662: FROM ENG_ENGINEERING_CHANGES
3663: WHERE CHANGE_NOTICE = p_change_notice
3664: AND ORGANIZATION_ID = p_organization_id
3665: ;
3666:

Line 3726: UPDATE eng_engineering_changes

3722: -- Approve Change
3723: IF p_approval_status_type = 5 THEN
3724:
3725: -- Approve ECO/Change Object
3726: UPDATE eng_engineering_changes
3727: SET approval_status_type = p_approval_status_type ,
3728: approval_date = sysdate ,
3729: request_id = l_request_id ,
3730: last_update_date = SYSDATE ,

Line 3746: UPDATE eng_engineering_changes

3742: WHERE change_id = p_change_id
3743: AND status_type = 1; -- Rev Item Status: Open
3744:
3745: -- If ECO is Open, Set Status to Scheduled (bug 2307416)
3746: UPDATE eng_engineering_changes
3747: SET status_type = 4 , -- Scheduled
3748: request_id = l_request_id ,
3749: last_update_date = SYSDATE ,
3750: last_updated_by = l_user_id ,

Line 3761: UPDATE eng_engineering_changes

3757: ELSIF p_approval_status_type IN (4, 7, 8) THEN
3758:
3759:
3760: -- Reject ECO/Change Object or set Processing Error
3761: UPDATE eng_engineering_changes
3762: SET approval_status_type = p_approval_status_type ,
3763: approval_date = NULL ,
3764: request_id = l_request_id ,
3765: last_update_date = SYSDATE ,

Line 3775: UPDATE eng_engineering_changes

3771: -- Others
3772: ELSE
3773:
3774: -- Update Approval Status
3775: UPDATE eng_engineering_changes
3776: SET approval_status_type = p_approval_status_type ,
3777: approval_date = NULL ,
3778: request_id = l_request_id ,
3779: last_update_date = SYSDATE ,

Line 3824: update eng_engineering_changes

3820: then commit;
3821: end if;
3822:
3823: /*
3824: update eng_engineering_changes
3825: set STATUS_TYPE = 1
3826: where CHANGE_ID = p_change_id;
3827: */
3828:

Line 3936: FROM ENG_ENGINEERING_CHANGES

3932: , l_ECO_rec.attribute3
3933: , l_ECO_rec.attribute4
3934: , l_ECO_rec.attribute5
3935: , l_ECO_rec.attribute6
3936: FROM ENG_ENGINEERING_CHANGES
3937: WHERE CHANGE_NOTICE = p_ECO_rec.change_notice
3938: AND ORGANIZATION_ID = p_ECO_rec.organization_id
3939: FOR UPDATE NOWAIT;
3940:

Line 4856: delete from eng_engineering_changes

4852: delete from eng_revised_items
4853: where change_id = p_change_id ;
4854:
4855:
4856: delete from eng_engineering_changes
4857: where change_id = p_change_id ;
4858:
4859: IF FND_API.To_Boolean ( p_commit ) THEN
4860: COMMIT WORK;