APPS.RCV_PARAMETERS_PKG dependencies on RCV_PARAMETERS

Line 1: PACKAGE BODY RCV_PARAMETERS_PKG as

1: PACKAGE BODY RCV_PARAMETERS_PKG as
2: /* $Header: RCVTIRPB.pls 120.0 2005/06/01 15:50:17 appldev noship $ */
3:
4:
5: PROCEDURE Insert_Row( X_Rowid IN OUT NOCOPY VARCHAR2,

Line 40: CURSOR C IS SELECT rowid FROM RCV_PARAMETERS

36: X_Enforce_RMA_Serial_Num VARCHAR2 DEFAULT NULL,
37: X_Enforce_RMA_Lot_Num VARCHAR2 DEFAULT NULL --INVCONV
38:
39: ) IS
40: CURSOR C IS SELECT rowid FROM RCV_PARAMETERS
41: WHERE organization_id = X_Organization_Id;
42:
43:
44:

Line 49: INSERT INTO RCV_PARAMETERS(

45:
46: BEGIN
47:
48:
49: INSERT INTO RCV_PARAMETERS(
50: organization_id,
51: last_update_date,
52: last_updated_by,
53: creation_date,

Line 165: FROM RCV_PARAMETERS

161:
162: ) IS
163: CURSOR C IS
164: SELECT *
165: FROM RCV_PARAMETERS
166: WHERE rowid = X_Rowid
167: FOR UPDATE of Organization_Id NOWAIT;
168: Recinfo C%ROWTYPE;
169: BEGIN

Line 294: UPDATE RCV_PARAMETERS

290: X_Enforce_RMA_Lot_Num VARCHAR2 DEFAULT NULL --INVCONV
291:
292: ) IS
293: BEGIN
294: UPDATE RCV_PARAMETERS
295: SET
296: organization_id = X_Organization_Id,
297: last_update_date = X_Last_Update_Date,
298: last_updated_by = X_Last_Updated_By,

Line 336: DELETE FROM RCV_PARAMETERS

332: END Update_Row;
333:
334: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
335: BEGIN
336: DELETE FROM RCV_PARAMETERS
337: WHERE rowid = X_Rowid;
338:
339: if (SQL%NOTFOUND) then
340: Raise NO_DATA_FOUND;

Line 344: END RCV_PARAMETERS_PKG;

340: Raise NO_DATA_FOUND;
341: end if;
342: END Delete_Row;
343:
344: END RCV_PARAMETERS_PKG;