APPS.E_REV_ITEM_INT_PKG dependencies on ENG_REVISED_ITEMS_INTERFACE

Line 89: CURSOR C IS SELECT rowid FROM ENG_REVISED_ITEMS_INTERFACE

85: X_From_End_Item_Unit_Number VARCHAR2,
86: X_req_id IN OUT NOCOPY NUMBER
87: ) IS
88:
89: CURSOR C IS SELECT rowid FROM ENG_REVISED_ITEMS_INTERFACE
90: WHERE revised_item_sequence_id = X_Revised_Item_Sequence_Id;
91:
92: BEGIN
93: INSERT INTO ENG_REVISED_ITEMS_INTERFACE(

Line 93: INSERT INTO ENG_REVISED_ITEMS_INTERFACE(

89: CURSOR C IS SELECT rowid FROM ENG_REVISED_ITEMS_INTERFACE
90: WHERE revised_item_sequence_id = X_Revised_Item_Sequence_Id;
91:
92: BEGIN
93: INSERT INTO ENG_REVISED_ITEMS_INTERFACE(
94: change_notice,
95: organization_id,
96: last_update_date,
97: last_updated_by,

Line 208: FROM ENG_REVISED_ITEMS_INTERFACE

204: X_From_End_Item_Unit_Number VARCHAR2
205: ) IS
206: CURSOR C IS
207: SELECT *
208: FROM ENG_REVISED_ITEMS_INTERFACE
209: WHERE rowid = X_Rowid
210: FOR UPDATE of Revised_Item_Sequence_Id NOWAIT;
211: Recinfo C%ROWTYPE;
212:

Line 330: UPDATE ENG_REVISED_ITEMS_INTERFACE

326: X_From_End_Item_Unit_Number VARCHAR2,
327: X_req_id IN OUT NOCOPY NUMBER
328: ) IS
329: BEGIN
330: UPDATE ENG_REVISED_ITEMS_INTERFACE
331: SET
332: change_notice = X_Change_Notice,
333: organization_id = X_Organization_Id,
334: last_update_date = X_Last_Update_Date,

Line 393: FROM ENG_REVISED_ITEMS_INTERFACE

389:
390: BEGIN
391: SELECT REVISED_ITEM_SEQUENCE_ID
392: INTO X_Rev_Itm_Seq_Id
393: FROM ENG_REVISED_ITEMS_INTERFACE
394: WHERE ROWID = X_Rowid;
395: EXCEPTION
396: WHEN NO_DATA_FOUND THEN
397: NULL;

Line 400: DELETE FROM ENG_REVISED_ITEMS_INTERFACE

396: WHEN NO_DATA_FOUND THEN
397: NULL;
398: END;
399:
400: DELETE FROM ENG_REVISED_ITEMS_INTERFACE
401: WHERE rowid = X_Rowid;
402:
403: if (SQL%NOTFOUND) then
404: Raise NO_DATA_FOUND;