APPS.E_CHANGES_INT_PKG dependencies on ENG_ENG_CHANGES_INTERFACE

Line 120: CURSOR C IS SELECT rowid FROM ENG_ENG_CHANGES_INTERFACE

116: X_Description VARCHAR2,
117: X_Change_Order_Type_Id NUMBER,
118: X_Responsible_Organization_Id NUMBER
119: ) IS
120: CURSOR C IS SELECT rowid FROM ENG_ENG_CHANGES_INTERFACE
121: WHERE organization_id = X_Organization_Id
122: AND change_notice = X_Change_Notice;
123: BEGIN
124:

Line 125: INSERT INTO ENG_ENG_CHANGES_INTERFACE(

121: WHERE organization_id = X_Organization_Id
122: AND change_notice = X_Change_Notice;
123: BEGIN
124:
125: INSERT INTO ENG_ENG_CHANGES_INTERFACE(
126: change_notice,
127: organization_id,
128: last_update_date,
129: last_updated_by,

Line 168: FROM ENG_ENG_CHANGES_INTERFACE

164: X_Responsible_Organization_Id NUMBER
165: ) IS
166: CURSOR C IS
167: SELECT *
168: FROM ENG_ENG_CHANGES_INTERFACE
169: WHERE rowid = X_Rowid
170: FOR UPDATE of Organization_Id NOWAIT;
171: Recinfo C%ROWTYPE;
172:

Line 220: UPDATE ENG_ENG_CHANGES_INTERFACE

216: X_Change_Order_Type_Id NUMBER,
217: X_Responsible_Organization_Id NUMBER
218: ) IS
219: BEGIN
220: UPDATE ENG_ENG_CHANGES_INTERFACE
221: SET
222: change_notice = X_Change_Notice,
223: organization_id = X_Organization_Id,
224: last_update_date = X_Last_Update_Date,

Line 245: FROM ENG_ENG_CHANGES_INTERFACE

241:
242: BEGIN
243: SELECT CHANGE_NOTICE, ORGANIZATION_ID
244: INTO X_Change_Notice, X_Org_Id
245: FROM ENG_ENG_CHANGES_INTERFACE
246: WHERE ROWID = X_Rowid;
247: EXCEPTION
248: WHEN NO_DATA_FOUND THEN
249: NULL;

Line 252: DELETE FROM ENG_ENG_CHANGES_INTERFACE

248: WHEN NO_DATA_FOUND THEN
249: NULL;
250: END;
251:
252: DELETE FROM ENG_ENG_CHANGES_INTERFACE
253: WHERE rowid = X_Rowid;
254:
255: if (SQL%NOTFOUND) then
256: Raise NO_DATA_FOUND;