APPS.MTL_RESERVATIONS_INTERFACE_PKG dependencies on MTL_RESERVATIONS_INTERFACE

Line 1: PACKAGE BODY MTL_RESERVATIONS_INTERFACE_PKG as

1: PACKAGE BODY MTL_RESERVATIONS_INTERFACE_PKG as
2: /* $Header: INVRSVF1B.pls 120.0 2005/05/25 06:35:54 appldev noship $ */
3:
4: PROCEDURE Lock_Row( X_ROWID VARCHAR2,
5: X_RESERVATION_INTERFACE_ID NUMBER,

Line 150: FROM mtl_reservations_interface

146: X_ATTRIBUTE15 VARCHAR2
147: ) IS
148: CURSOR C IS
149: SELECT *
150: FROM mtl_reservations_interface
151: WHERE rowid = X_Rowid
152: FOR UPDATE NOWAIT;
153: Recinfo C%ROWTYPE;
154: RECORD_CHANGED EXCEPTION;

Line 787: UPDATE mtl_reservations_interface

783: X_ATTRIBUTE14 VARCHAR2,
784: X_ATTRIBUTE15 VARCHAR2
785: ) IS
786: BEGIN
787: UPDATE mtl_reservations_interface
788: SET
789: RESERVATION_INTERFACE_ID = X_RESERVATION_INTERFACE_ID,
790: RESERVATION_BATCH_ID = X_RESERVATION_BATCH_ID,
791: REQUIREMENT_DATE = X_REQUIREMENT_DATE,

Line 943: delete from mtl_reservations_interface

939:
940: PROCEDURE Delete_Row( X_ROWID VARCHAR2)
941: IS
942: BEGIN
943: delete from mtl_reservations_interface
944: where rowid = X_ROWID;
945:
946: if (SQL%NOTFOUND) then
947: Raise NO_DATA_FOUND;

Line 951: END MTL_RESERVATIONS_INTERFACE_PKG;

947: Raise NO_DATA_FOUND;
948: end if;
949: END Delete_Row;
950:
951: END MTL_RESERVATIONS_INTERFACE_PKG;