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 284: UPDATE eng_engineering_changes

280: UPDATE eng_revised_items
281: SET implementation_req_id = x_request_id
282: WHERE revised_item_sequence_id = p_rev_item_seq_id;
283: ELSE
284: UPDATE eng_engineering_changes
285: SET implementation_req_id = x_request_id
286: WHERE change_notice = p_change_notice
287: AND organization_id = p_org_id;
288: END IF ;

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

985: -- R12 Changes for common BOM
986: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
987: -- Cursor to Fetch all source bill's component changes that are being updated
988: -- by reschedule
989: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS
990: SELECT bcb.component_sequence_id
991: FROM bom_components_b bcb
992: WHERE bcb.CHANGE_NOTICE = cp_change_notice
993: AND exists

Line 1072: FROM eng_engineering_changes

1068: END IF;
1069:
1070: SELECT change_notice, organization_id
1071: INTO x_change_notice, x_organization_id
1072: FROM eng_engineering_changes
1073: WHERE change_id = p_change_id;
1074:
1075: Update Eng_Revised_Items eri
1076: Set eri.scheduled_date = p_effectivity_date,

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

1396: -- R12 Changes for common BOM
1397: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1398: -- Cursor to Fetch all source bill's component changes that are being updated
1399: -- by reschedule
1400: CURSOR c_source_components( cp_change_notice eng_engineering_changes.change_notice%TYPE) IS
1401: SELECT bcb.component_sequence_id
1402: FROM bom_components_b bcb
1403: WHERE bcb.CHANGE_NOTICE = cp_change_notice
1404: AND exists

Line 1469: FROM eng_engineering_changes

1465: END IF;
1466:
1467: SELECT change_notice, organization_id
1468: INTO x_change_notice, x_organization_id
1469: FROM eng_engineering_changes
1470: WHERE change_id = p_change_id;
1471:
1472: Update Eng_Revised_Items eri
1473: Set eri.scheduled_date = p_effectivity_date,

Line 2338: UPDATE eng_engineering_changes

2334: l_change_name := p_eco_rec.change_name;
2335: END IF;
2336:
2337:
2338: UPDATE eng_engineering_changes
2339: SET attribute7 = p_eco_rec.attribute7,
2340: attribute8 = p_eco_rec.attribute8,
2341: attribute9 = p_eco_rec.attribute9,
2342: attribute10 = p_eco_rec.attribute10,

Line 2690: INSERT INTO ENG_ENGINEERING_CHANGES

2686: Then
2687: Error_Handler.write_debug('Start to insert');
2688: END IF;
2689:
2690: INSERT INTO ENG_ENGINEERING_CHANGES
2691: ( ATTRIBUTE7
2692: , ATTRIBUTE8
2693: , ATTRIBUTE9
2694: , ATTRIBUTE10

Line 2902: DELETE FROM ENG_ENGINEERING_CHANGES

2898:
2899: x_return_status := FND_API.G_RET_STS_SUCCESS;
2900:
2901: BEGIN
2902: DELETE FROM ENG_ENGINEERING_CHANGES
2903: WHERE CHANGE_NOTICE = p_change_notice
2904: AND ORGANIZATION_ID = p_organization_id;
2905:
2906: EXCEPTION

Line 3233: FROM ENG_ENGINEERING_CHANGES

3229: , l_ECO_rec.internal_use_only -- Eng Chagne
3230: , l_ECO_Unexp_rec.source_type_code -- Eng Chagne
3231: , l_ECO_Unexp_rec.source_id -- Eng Chagne
3232: , l_ECO_rec.effort -- Eng Chagne
3233: FROM ENG_ENGINEERING_CHANGES
3234: WHERE CHANGE_NOTICE = p_change_notice
3235: AND ORGANIZATION_ID = p_organization_id
3236: ;
3237:

Line 3297: UPDATE eng_engineering_changes

3293: -- Approve Change
3294: IF p_approval_status_type = 5 THEN
3295:
3296: -- Approve ECO/Change Object
3297: UPDATE eng_engineering_changes
3298: SET approval_status_type = p_approval_status_type ,
3299: approval_date = sysdate ,
3300: request_id = l_request_id ,
3301: last_update_date = SYSDATE ,

Line 3317: UPDATE eng_engineering_changes

3313: WHERE change_id = p_change_id
3314: AND status_type = 1; -- Rev Item Status: Open
3315:
3316: -- If ECO is Open, Set Status to Scheduled (bug 2307416)
3317: UPDATE eng_engineering_changes
3318: SET status_type = 4 , -- Scheduled
3319: request_id = l_request_id ,
3320: last_update_date = SYSDATE ,
3321: last_updated_by = l_user_id ,

Line 3332: UPDATE eng_engineering_changes

3328: ELSIF p_approval_status_type IN (4, 7, 8) THEN
3329:
3330:
3331: -- Reject ECO/Change Object or set Processing Error
3332: UPDATE eng_engineering_changes
3333: SET approval_status_type = p_approval_status_type ,
3334: approval_date = NULL ,
3335: request_id = l_request_id ,
3336: last_update_date = SYSDATE ,

Line 3346: UPDATE eng_engineering_changes

3342: -- Others
3343: ELSE
3344:
3345: -- Update Approval Status
3346: UPDATE eng_engineering_changes
3347: SET approval_status_type = p_approval_status_type ,
3348: approval_date = NULL ,
3349: request_id = l_request_id ,
3350: last_update_date = SYSDATE ,

Line 3395: update eng_engineering_changes

3391: then commit;
3392: end if;
3393:
3394: /*
3395: update eng_engineering_changes
3396: set STATUS_TYPE = 1
3397: where CHANGE_ID = p_change_id;
3398: */
3399:

Line 3507: FROM ENG_ENGINEERING_CHANGES

3503: , l_ECO_rec.attribute3
3504: , l_ECO_rec.attribute4
3505: , l_ECO_rec.attribute5
3506: , l_ECO_rec.attribute6
3507: FROM ENG_ENGINEERING_CHANGES
3508: WHERE CHANGE_NOTICE = p_ECO_rec.change_notice
3509: AND ORGANIZATION_ID = p_ECO_rec.organization_id
3510: FOR UPDATE NOWAIT;
3511:

Line 4427: delete from eng_engineering_changes

4423: delete from eng_revised_items
4424: where change_id = p_change_id ;
4425:
4426:
4427: delete from eng_engineering_changes
4428: where change_id = p_change_id ;
4429:
4430: IF FND_API.To_Boolean ( p_commit ) THEN
4431: COMMIT WORK;