DBA Data[Home] [Help]

APPS.CHV_SCH_HEADERS_PKG_S1 dependencies on CHV_SCHEDULE_HEADERS

Line 46: FROM CHV_SCHEDULE_HEADERS

42: X_Attribute15 VARCHAR2
43: ) IS
44: CURSOR C IS
45: SELECT *
46: FROM CHV_SCHEDULE_HEADERS
47: WHERE rowid = X_Rowid
48: FOR UPDATE of Schedule_Id NOWAIT;
49: Hdrrec C%ROWTYPE;
50: BEGIN

Line 184: UPDATE CHV_SCHEDULE_HEADERS

180: ) IS
181:
182: BEGIN
183:
184: UPDATE CHV_SCHEDULE_HEADERS
185: SET
186: schedule_num = X_Schedule_num,
187: schedule_status = X_Schedule_status,
188: last_update_date = X_Last_Update_Date,

Line 236: DELETE FROM chv_schedule_headers

232: /* Delete the schedule headers table based on the
233: ** Row_Id
234: */
235:
236: DELETE FROM chv_schedule_headers
237: WHERE rowid = X_Rowid ;
238:
239:
240: if (SQL%NOTFOUND) then