APPS.IEX_PAYMENTS_PKG dependencies on IEX_PAYMENTS

Line 1: PACKAGE BODY IEX_PAYMENTS_PKG AS

1: PACKAGE BODY IEX_PAYMENTS_PKG AS
2: /* $Header: iextpayb.pls 120.0 2004/01/24 03:22:24 appldev noship $ */
3:
4: /* Insert_Row procedure */
5: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

Line 42: CURSOR C IS SELECT ROWID FROM IEX_PAYMENTS

38: ,p_TANGIBLE_ID VARCHAR2 DEFAULT NULL
39: ,p_PAYEE_ID VARCHAR2 DEFAULT NULL
40: ,p_RESOURCE_ID NUMBER DEFAULT NULL
41: ) IS
42: CURSOR C IS SELECT ROWID FROM IEX_PAYMENTS
43: WHERE PAYMENT_ID = p_PAYMENT_ID;
44:
45: BEGIN
46: INSERT INTO IEX_PAYMENTS

Line 46: INSERT INTO IEX_PAYMENTS

42: CURSOR C IS SELECT ROWID FROM IEX_PAYMENTS
43: WHERE PAYMENT_ID = p_PAYMENT_ID;
44:
45: BEGIN
46: INSERT INTO IEX_PAYMENTS
47: (
48: PAYMENT_ID
49: ,OBJECT_VERSION_NUMBER
50: ,PROGRAM_ID

Line 163: UPDATE IEX_PAYMENTS SET

159: ,p_PAYEE_ID VARCHAR2 DEFAULT NULL
160: ,p_RESOURCE_ID NUMBER DEFAULT NULL
161: ) IS
162: BEGIN
163: UPDATE IEX_PAYMENTS SET
164: PAYMENT_ID = p_PAYMENT_ID
165: ,OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
166: ,PROGRAM_ID = p_PROGRAM_ID
167: ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE

Line 207: DELETE FROM IEX_PAYMENTS

203:
204: /* Delete_Row procedure */
205: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
206: BEGIN
207: DELETE FROM IEX_PAYMENTS
208: WHERE rowid = x_rowid;
209:
210: if (sql%notfound) then
211: raise no_data_found;

Line 251: CURSOR C IS SELECT * FROM IEX_PAYMENTS

247: ,p_TANGIBLE_ID VARCHAR2 DEFAULT NULL
248: ,p_PAYEE_ID VARCHAR2 DEFAULT NULL
249: ,p_RESOURCE_ID NUMBER DEFAULT NULL
250: ) IS
251: CURSOR C IS SELECT * FROM IEX_PAYMENTS
252: WHERE rowid = x_rowid
253: FOR UPDATE of PAYMENT_ID NOWAIT;
254: Recinfo C%ROWTYPE;
255: BEGIN