DBA Data[Home] [Help]

APPS.IEX_WRITEOFFS_PKG dependencies on IEX_WRITEOFFS

Line 1: PACKAGE BODY IEX_WRITEOFFS_PKG as

1: PACKAGE BODY IEX_WRITEOFFS_PKG as
2: /* $Header: iextwrob.pls 120.1 2007/10/31 13:00:26 ehuh ship $ */
3: -- Start of Comments
4: -- Package name : IEX_WRITEOFFS_PKG
5: -- Purpose :

Line 4: -- Package name : IEX_WRITEOFFS_PKG

1: PACKAGE BODY IEX_WRITEOFFS_PKG as
2: /* $Header: iextwrob.pls 120.1 2007/10/31 13:00:26 ehuh ship $ */
3: -- Start of Comments
4: -- Package name : IEX_WRITEOFFS_PKG
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_WRITEOFFS_PKG';

7: -- NOTE :
8: -- End of Comments
9:
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):= 'IEX_WRITEOFFS_PKG';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iextwrob.pls';
13:
14: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
15: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line 84: cursor C is select ROWID from IEX_WRITEOFFS

80: )
81:
82: IS
83:
84: cursor C is select ROWID from IEX_WRITEOFFS
85: where writeoff_id = p_writeoff_id ;
86:
87: BEGIN
88: -- IF PG_DEBUG < 10 THEN

Line 90: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');

86:
87: BEGIN
88: -- IF PG_DEBUG < 10 THEN
89: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
90: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');
91: END IF;
92:
93:
94: INSERT INTO IEX_WRITEOFFS(

Line 94: INSERT INTO IEX_WRITEOFFS(

90: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');
91: END IF;
92:
93:
94: INSERT INTO IEX_WRITEOFFS(
95: WRITEOFF_ID,
96: PARTY_ID,
97: DELINQUENCY_ID ,
98: CAS_ID,

Line 233: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');

229: end if;
230: close c;
231: -- IF PG_DEBUG < 10 THEN
232: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
233: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.INSERT_ROW ******** ');
234: END IF;
235:
236: End Insert_Row;
237:

Line 304: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');

300: IS
301: BEGIN
302: -- IF PG_DEBUG < 10 THEN
303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
304: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
305: END IF;
306: Update IEX_WRITEOFFS
307: SET
308: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),

Line 306: Update IEX_WRITEOFFS

302: -- IF PG_DEBUG < 10 THEN
303: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
304: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
305: END IF;
306: Update IEX_WRITEOFFS
307: SET
308: PARTY_ID = decode( p_PARTY_ID, FND_API.G_MISS_NUM, PARTY_ID, p_PARTY_ID),
309: DELINQUENCY_ID = decode( p_DELINQUENCY_ID, FND_API.G_MISS_NUM, DELINQUENCY_ID, p_DELINQUENCY_ID),
310: CAS_ID = decode( p_CAS_ID, FND_API.G_MISS_NUM, CAS_ID, p_CAS_ID),

Line 376: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');

372: RAISE NO_DATA_FOUND;
373: End If;
374: -- IF PG_DEBUG < 10 THEN
375: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
376: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.UPDATE_ROW ******** ');
377: END IF;
378: END Update_Row;
379:
380: PROCEDURE Delete_Row(

Line 384: DELETE FROM IEX_WRITEOFFS

380: PROCEDURE Delete_Row(
381: p_WRITEOFF_ID NUMBER)
382: IS
383: BEGIN
384: DELETE FROM IEX_WRITEOFFS
385: WHERE WRITEOFF_ID = p_WRITEOFF_ID;
386: If (SQL%NOTFOUND) then
387: RAISE NO_DATA_FOUND;
388: End If;

Line 397: from IEX_WRITEOFFS

393: p_writeoff_id in NUMBER,
394: p_OBJECT_VERSION_NUMBER in NUMBER
395: ) is
396: cursor c is select OBJECT_VERSION_NUMBER
397: from IEX_WRITEOFFS
398: where writeoff_id = p_writeoff_id
399: and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER
400: for update of writeoff_id nowait;
401: recinfo c%rowtype;

Line 406: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');

402:
403: begin
404: -- IF PG_DEBUG < 10 THEN
405: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
406: IEX_DEBUG_PUB.LogMessage ('********* Start of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');
407: END IF;
408: open c;
409: fetch c into recinfo;
410: if (c%notfound) then

Line 426: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');

422: app_exception.raise_exception;
423: end if;
424: --IF PG_DEBUG < 10 THEN
425: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
426: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFFS_PKG.LOCK_ROW ******** ');
427: END IF;
428: end LOCK_ROW;
429:
430:

Line 495: FROM IEX_WRITEOFFS

491:
492: IS
493: CURSOR C IS
494: SELECT *
495: FROM IEX_WRITEOFFS
496: WHERE WRITEOFF_ID = p_WRITEOFF_ID
497: FOR UPDATE of WRITEOFF_ID NOWAIT;
498: Recinfo C%ROWTYPE;
499: BEGIN

Line 680: End IEX_WRITEOFFS_PKG;

676: APP_EXCEPTION.RAISE_EXCEPTION;
677: End If;
678: END Lock_Row;
679: */
680: End IEX_WRITEOFFS_PKG;