APPS.IEX_PAY_OKL_XREF_PKG dependencies on IEX_PAY_OKL_XREF

Line 1: PACKAGE BODY IEX_PAY_OKL_XREF_PKG AS

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

Line 25: CURSOR C IS SELECT ROWID FROM IEX_PAY_OKL_XREF

21: ,p_REQUEST_ID NUMBER DEFAULT NULL
22: ,p_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
23: ,p_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
24: ) IS
25: CURSOR C IS SELECT ROWID FROM IEX_PAY_OKL_XREF
26: WHERE PAY_OKL_XREF_ID = p_PAY_OKL_XREF_ID;
27:
28: BEGIN
29: INSERT INTO IEX_PAY_OKL_XREF

Line 29: INSERT INTO IEX_PAY_OKL_XREF

25: CURSOR C IS SELECT ROWID FROM IEX_PAY_OKL_XREF
26: WHERE PAY_OKL_XREF_ID = p_PAY_OKL_XREF_ID;
27:
28: BEGIN
29: INSERT INTO IEX_PAY_OKL_XREF
30: (
31: PAY_OKL_XREF_ID
32: ,OKL_PAYMENT_ID
33: ,CNSLD_INVOICE_ID

Line 95: UPDATE IEX_PAY_OKL_XREF SET

91: ,p_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
92: ,p_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
93: ) IS
94: BEGIN
95: UPDATE IEX_PAY_OKL_XREF SET
96: PAY_OKL_XREF_ID = p_PAY_OKL_XREF_ID
97: ,OKL_PAYMENT_ID = p_OKL_PAYMENT_ID
98: ,CNSLD_INVOICE_ID = p_CNSLD_INVOICE_ID
99: ,CONTRACT_ID = p_CONTRACT_ID

Line 122: DELETE FROM IEX_PAY_OKL_XREF

118:
119: /* Delete_Row procedure */
120: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
121: BEGIN
122: DELETE FROM IEX_PAY_OKL_XREF
123: WHERE rowid = x_rowid;
124:
125: if (sql%notfound) then
126: raise no_data_found;

Line 149: CURSOR C IS SELECT * FROM IEX_PAY_OKL_XREF

145: ,p_REQUEST_ID NUMBER DEFAULT NULL
146: ,p_PROGRAM_APPLICATION_ID NUMBER DEFAULT NULL
147: ,p_PROGRAM_UPDATE_DATE DATE DEFAULT NULL
148: ) IS
149: CURSOR C IS SELECT * FROM IEX_PAY_OKL_XREF
150: WHERE rowid = x_rowid
151: FOR UPDATE of PAY_OKL_XREF_ID NOWAIT;
152: Recinfo C%ROWTYPE;
153: BEGIN