APPS.WIP_INTERFACE_TH dependencies on WIP_JOB_SCHEDULE_INTERFACE

Line 78: UPDATE WIP_JOB_SCHEDULE_INTERFACE SET

74: X_Attribute14 VARCHAR2,
75: X_Attribute15 VARCHAR2
76: ) IS
77: BEGIN
78: UPDATE WIP_JOB_SCHEDULE_INTERFACE SET
79: GROUP_ID = X_Group_Id,
80: PROCESS_PHASE = X_Process_Phase,
81: PROCESS_STATUS = X_Process_Status,
82: REQUEST_ID = X_Request_Id,

Line 168: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI

164:
165: DELETE WIP_JOB_DTLS_INTERFACE WJDI
166: WHERE WJDI.PARENT_HEADER_ID IN
167: (SELECT WJSI.HEADER_ID
168: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI
169: WHERE WJSI.rowid = X_Rowid
170: ) ;
171:
172: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE

Line 172: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE

168: FROM WIP_JOB_SCHEDULE_INTERFACE WJSI
169: WHERE WJSI.rowid = X_Rowid
170: ) ;
171:
172: DELETE FROM WIP_JOB_SCHEDULE_INTERFACE
173: WHERE rowid = X_Rowid;
174:
175: IF (SQL%NOTFOUND) THEN
176: RAISE NO_DATA_FOUND;

Line 195: FROM WIP_JOB_SCHEDULE_INTERFACE

191: BEGIN
192: DELETE FROM WIP_INTERFACE_ERRORS
193: WHERE INTERFACE_ID IN
194: (SELECT INTERFACE_ID
195: FROM WIP_JOB_SCHEDULE_INTERFACE
196: WHERE ROWID = X_Rowid);
197:
198: END Delete_Children;
199:

Line 345: FROM WIP_JOB_SCHEDULE_INTERFACE

341: , ATTRIBUTE12
342: , ATTRIBUTE13
343: , ATTRIBUTE14
344: , ATTRIBUTE15
345: FROM WIP_JOB_SCHEDULE_INTERFACE
346: WHERE rowid = X_rowid
347: FOR UPDATE of Interface_Id NOWAIT;
348: Recinfo C%ROWTYPE;
349: BEGIN