APPS.MTL_RESERVATIONS_PKG dependencies on MTL_RESERVATIONS

Line 1: PACKAGE BODY MTL_RESERVATIONS_PKG AS

1: PACKAGE BODY MTL_RESERVATIONS_PKG AS
2: /* $Header: INVRSV6B.pls 120.2 2006/09/20 11:26:07 bradha ship $ */
3: -- INVCONV
4: -- Add columns to signatures as follows:
5: -- secondary_uom_code

Line 259: CURSOR C IS SELECT ROWID FROM MTL_RESERVATIONS

255: , x_orig_demand_line_id IN NUMBER
256: , x_orig_demand_line_detail IN NUMBER
257: /*** End R12 ***/
258: )IS
259: CURSOR C IS SELECT ROWID FROM MTL_RESERVATIONS
260: WHERE reservation_id = x_reservation_id;
261: BEGIN
262: INSERT INTO MTL_RESERVATIONS (
263: reservation_id

Line 262: INSERT INTO MTL_RESERVATIONS (

258: )IS
259: CURSOR C IS SELECT ROWID FROM MTL_RESERVATIONS
260: WHERE reservation_id = x_reservation_id;
261: BEGIN
262: INSERT INTO MTL_RESERVATIONS (
263: reservation_id
264: ,requirement_date
265: ,organization_id
266: ,inventory_item_id

Line 749: FROM MTL_RESERVATIONS

745: , demand_ship_date
746: , project_id
747: , task_id
748: /*** End R12 ***/
749: FROM MTL_RESERVATIONS
750: WHERE reservation_id = x_reservation_id
751: FOR UPDATE OF reservation_id NOWAIT;
752:
753: recinfo c%ROWTYPE;

Line 1192: UPDATE MTL_RESERVATIONS SET

1188: , x_task_id IN NUMBER
1189: /*** End R12 ***/
1190: )IS
1191: BEGIN
1192: UPDATE MTL_RESERVATIONS SET
1193: reservation_id = x_reservation_id
1194: ,requirement_date = x_requirement_date
1195: ,organization_id = x_organization_id
1196: ,inventory_item_id = x_inventory_item_id

Line 1280: DELETE FROM MTL_RESERVATIONS

1276: ,x_to_reservation_id IN NUMBER
1277: )IS
1278: BEGIN
1279:
1280: DELETE FROM MTL_RESERVATIONS
1281: WHERE reservation_id = x_reservation_id;
1282:
1283: IF (SQL%NOTFOUND) THEN
1284: RAISE NO_DATA_FOUND;

Line 1301: END MTL_RESERVATIONS_PKG;

1297: WHERE reservation_id = x_reservation_id;
1298: END IF;
1299:
1300: END DELETE_ROW;
1301: END MTL_RESERVATIONS_PKG;