APPS.ENG_ECO_REVISION_UTIL dependencies on ENG_CHANGE_ORDER_REVISIONS

Line 158: UPDATE ENG_CHANGE_ORDER_REVISIONS

154: l_request_id := ENG_GLOBALS.Get_request_id;
155: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
156: l_prog_id := ENG_GLOBALS.Get_prog_id;
157:
158: UPDATE ENG_CHANGE_ORDER_REVISIONS
159: SET REVISION = DECODE
160: ( p_eco_revision_rec.new_revision, NULL,
161: p_eco_revision_rec.revision,
162: FND_API.G_MISS_CHAR,

Line 262: INSERT INTO ENG_CHANGE_ORDER_REVISIONS

258: l_prog_appid := ENG_GLOBALS.Get_prog_appid;
259: l_prog_id := ENG_GLOBALS.Get_prog_id;
260:
261:
262: INSERT INTO ENG_CHANGE_ORDER_REVISIONS
263: ( REVISION_ID
264: , CHANGE_NOTICE
265: , ORGANIZATION_ID
266: , REVISION

Line 419: DELETE FROM ENG_CHANGE_ORDER_REVISIONS

415: IS
416: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
417: BEGIN
418:
419: DELETE FROM ENG_CHANGE_ORDER_REVISIONS
420: WHERE REVISION_ID = p_revision_id;
421:
422: EXCEPTION
423:

Line 529: FROM ENG_CHANGE_ORDER_REVISIONS

525: , x_eco_revision_rec.attribute13
526: , x_eco_revision_rec.attribute14
527: , x_eco_revision_rec.attribute15
528: , x_Eco_Rev_Unexp_Rec.change_id
529: FROM ENG_CHANGE_ORDER_REVISIONS
530: WHERE REVISION = p_revision
531: AND CHANGE_NOTICE = p_Change_Notice
532: AND ORGANIZATION_ID = p_Organization_Id;
533:

Line 676: FROM ENG_CHANGE_ORDER_REVISIONS

672: , l_eco_revision_rec.attribute7
673: , l_eco_revision_rec.attribute8
674: , l_eco_revision_rec.attribute9
675: , l_eco_revision_rec.attribute10
676: FROM ENG_CHANGE_ORDER_REVISIONS
677: WHERE REVISION_ID = p_eco_revision_rec.revision_id
678: FOR UPDATE NOWAIT;
679:
680: -- Row locked. Compare IN attributes to DB attributes.