APPS.IEX_DEL_PAY_XREF_PKG dependencies on IEX_DEL_PAY_XREF

Line 1: PACKAGE BODY IEX_DEL_PAY_XREF_PKG AS

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

Line 19: CURSOR C IS SELECT ROWID FROM IEX_DEL_PAY_XREF

15: ,p_PROGRAM_ID NUMBER DEFAULT NULL
16: ,p_DELINQUENCY_ID NUMBER DEFAULT NULL
17: ,p_PAYMENT_ID NUMBER DEFAULT NULL
18: ) IS
19: CURSOR C IS SELECT ROWID FROM IEX_DEL_PAY_XREF
20: WHERE DEL_PAY_ID = p_DEL_PAY_ID;
21:
22: BEGIN
23: INSERT INTO IEX_DEL_PAY_XREF

Line 23: INSERT INTO IEX_DEL_PAY_XREF

19: CURSOR C IS SELECT ROWID FROM IEX_DEL_PAY_XREF
20: WHERE DEL_PAY_ID = p_DEL_PAY_ID;
21:
22: BEGIN
23: INSERT INTO IEX_DEL_PAY_XREF
24: (
25: DEL_PAY_ID
26: ,LAST_UPDATE_DATE
27: ,LAST_UPDATED_BY

Line 71: UPDATE IEX_DEL_PAY_XREF SET

67: ,p_DELINQUENCY_ID NUMBER DEFAULT NULL
68: ,p_PAYMENT_ID NUMBER DEFAULT NULL
69: ) IS
70: BEGIN
71: UPDATE IEX_DEL_PAY_XREF SET
72: DEL_PAY_ID = p_DEL_PAY_ID
73: ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
74: ,LAST_UPDATED_BY = p_LAST_UPDATED_BY
75: ,LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN

Line 92: DELETE FROM IEX_DEL_PAY_XREF

88:
89: /* Delete_Row procedure */
90: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
91: BEGIN
92: DELETE FROM IEX_DEL_PAY_XREF
93: WHERE rowid = x_rowid;
94:
95: if (sql%notfound) then
96: raise no_data_found;

Line 113: CURSOR C IS SELECT * FROM IEX_DEL_PAY_XREF

109: ,p_PROGRAM_ID NUMBER DEFAULT NULL
110: ,p_DELINQUENCY_ID NUMBER DEFAULT NULL
111: ,p_PAYMENT_ID NUMBER DEFAULT NULL
112: ) IS
113: CURSOR C IS SELECT * FROM IEX_DEL_PAY_XREF
114: WHERE rowid = x_rowid
115: FOR UPDATE of DEL_PAY_ID NOWAIT;
116: Recinfo C%ROWTYPE;
117: BEGIN