APPS.IEX_DISPUTES_PKG dependencies on IEX_DISPUTES

Line 1: PACKAGE BODY IEX_DISPUTES_PKG AS

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

Line 39: CURSOR C IS SELECT ROWID FROM IEX_DISPUTES

35: ,p_ATTRIBUTE14 VARCHAR2
36: ,p_ATTRIBUTE15 VARCHAR2
37: ,p_DELINQUENCY_ID NUMBER
38: ) IS
39: CURSOR C IS SELECT ROWID FROM IEX_DISPUTES
40: WHERE DISPUTE_ID = p_DISPUTE_ID;
41:
42: BEGIN
43: INSERT INTO IEX_DISPUTES

Line 43: INSERT INTO IEX_DISPUTES

39: CURSOR C IS SELECT ROWID FROM IEX_DISPUTES
40: WHERE DISPUTE_ID = p_DISPUTE_ID;
41:
42: BEGIN
43: INSERT INTO IEX_DISPUTES
44: (
45: DISPUTE_ID
46: ,LAST_UPDATE_DATE
47: ,LAST_UPDATED_BY

Line 151: UPDATE IEX_DISPUTES SET

147: ,p_ATTRIBUTE15 VARCHAR2
148: ,p_DELINQUENCY_ID NUMBER
149: ) IS
150: BEGIN
151: UPDATE IEX_DISPUTES SET
152: DISPUTE_ID = p_DISPUTE_ID
153: ,LAST_UPDATE_DATE = p_LAST_UPDATE_DATE
154: ,LAST_UPDATED_BY = p_LAST_UPDATED_BY
155: ,CREATION_DATE = p_CREATION_DATE

Line 192: DELETE FROM IEX_DISPUTES

188:
189: /* Delete_Row procedure */
190: PROCEDURE Delete_Row(x_rowid VARCHAR2) IS
191: BEGIN
192: DELETE FROM IEX_DISPUTES
193: WHERE rowid = x_rowid;
194:
195: if (sql%notfound) then
196: raise no_data_found;

Line 233: CURSOR C IS SELECT * FROM IEX_DISPUTES

229: ,p_ATTRIBUTE14 VARCHAR2
230: ,p_ATTRIBUTE15 VARCHAR2
231: ,p_DELINQUENCY_ID NUMBER
232: ) IS
233: CURSOR C IS SELECT * FROM IEX_DISPUTES
234: WHERE rowid = x_rowid
235: FOR UPDATE of DISPUTE_ID NOWAIT;
236: Recinfo C%ROWTYPE;
237: BEGIN