APPS.CHV_SCHEDULE_ITEMS_PKG_S1 dependencies on CHV_SCHEDULE_ITEMS

Line 1: PACKAGE BODY CHV_SCHEDULE_ITEMS_PKG_S1 as

1: PACKAGE BODY CHV_SCHEDULE_ITEMS_PKG_S1 as
2: /* $Header: CHVSITMB.pls 115.0 99/07/17 01:31:37 porting ship $ */
3:
4: /*=============================================================================
5:

Line 45: FROM CHV_SCHEDULE_ITEMS

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

Line 193: UPDATE CHV_SCHEDULE_ITEMS

189: ) IS
190:
191: BEGIN
192:
193: UPDATE CHV_SCHEDULE_ITEMS
194: SET
195: item_confirm_status = X_Item_Confirm_Status,
196: rebuild_flag = X_Rebuild_Flag,
197: last_update_date = X_Last_Update_Date,

Line 249: DELETE FROM chv_schedule_items

245: /* After the data is deleted from the child tables
246: ** delete from the items table.
247: */
248:
249: DELETE FROM chv_schedule_items
250: WHERE rowid = X_Rowid ;
251:
252: if (SQL%NOTFOUND) then
253: Raise NO_DATA_FOUND ;

Line 267: FROM CHV_SCHEDULE_ITEMS

263: PROCEDURE delete_row2(X_Schedule_Id NUMBER
264: ) IS
265:
266: Cursor C1 is SELECT rowid, schedule_item_id
267: FROM CHV_SCHEDULE_ITEMS
268: WHERE schedule_id = X_Schedule_Id ;
269:
270: BEGIN
271:

Line 276: CHV_SCHEDULE_ITEMS_PKG_S1.delete_row1(Itemrec.rowid,

272: for Itemrec in C1 loop
273:
274: /* Execute procedure to actually delete the records */
275:
276: CHV_SCHEDULE_ITEMS_PKG_S1.delete_row1(Itemrec.rowid,
277: Itemrec.Schedule_Item_Id,
278: X_Schedule_Id
279: ) ;
280: end loop ;

Line 284: END CHV_SCHEDULE_ITEMS_PKG_S1;

280: end loop ;
281:
282: END delete_row2 ;
283:
284: END CHV_SCHEDULE_ITEMS_PKG_S1;