APPS.IEX_WRITEOFF_OBJECTS_PKG dependencies on IEX_WRITEOFF_OBJECTS

Line 1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PKG AS

1: PACKAGE BODY IEX_WRITEOFF_OBJECTS_PKG AS
2: /* $Header: iextwobb.pls 120.1 2007/10/31 12:24:31 ehuh ship $ */
3:
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 49: CURSOR C IS SELECT ROWID FROM IEX_WRITEOFF_OBJECTS

45: X_WRITEOFF_TYPE in VARCHAR2,
46: x_customer_trx_id in number,
47: x_customer_trx_line_id in number) IS
48:
49: CURSOR C IS SELECT ROWID FROM IEX_WRITEOFF_OBJECTS
50: WHERE WRITEOFF_OBJECT_ID = x_WRITEOFF_OBJECT_ID;
51:
52: BEGIN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 55: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW ** ');

51:
52: BEGIN
53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
55: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW ** ');
56: END IF;
57: INSERT INTO IEX_WRITEOFF_OBJECTS
58: (
59: WRITEOFF_OBJECT_ID

Line 57: INSERT INTO IEX_WRITEOFF_OBJECTS

53: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
54: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
55: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW ** ');
56: END IF;
57: INSERT INTO IEX_WRITEOFF_OBJECTS
58: (
59: WRITEOFF_OBJECT_ID
60: ,WRITEOFF_ID
61: ,OBJECT_VERSION_NUMBER

Line 151: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW *** ');

147: END IF;
148: CLOSE C;
149: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
150: IEX_DEBUG_PUB.LogMessage ('** End of Procedure =>'||
151: 'IEX_WRITEOFF_OBJECTS_PKG.INSERT_ROW *** ');
152: END IF;
153: END Insert_Row;
154:
155: /* Update_Row procedure */

Line 197: UPDATE IEX_WRITEOFF_OBJECTS SET

193: x_customer_trx_id in number,
194: x_customer_trx_line_id in number)
195: IS
196: BEGIN
197: UPDATE IEX_WRITEOFF_OBJECTS SET
198: WRITEOFF_ID = decode( x_WRITEOFF_ID, FND_API.G_MISS_NUM, NULL,
199: NULL, WRITEOFF_ID, x_WRITEOFF_ID)
200: ,OBJECT_VERSION_NUMBER = decode( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM,NULL,
201: NULL,OBJECT_VERSION_NUMBER, x_OBJECT_VERSION_NUMBER)

Line 297: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.DELETE_ROW *** ');

293: PROCEDURE Delete_Row(x_object_writeoff_id IN NUMBER)
294: IS
295: BEGIN
296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
297: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.DELETE_ROW *** ');
298: END IF;
299: delete from IEX_WRITEOFF_OBJECTS
300: where writeoff_object_id = x_object_writeoff_id;
301:

Line 299: delete from IEX_WRITEOFF_OBJECTS

295: BEGIN
296: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
297: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.DELETE_ROW *** ');
298: END IF;
299: delete from IEX_WRITEOFF_OBJECTS
300: where writeoff_object_id = x_object_writeoff_id;
301:
302: if (sql%notfound) then
303: raise no_data_found;

Line 313: from IEX_WRITEOFF_OBJECTS

309: X_WRITEOFF_OBJECT_ID in NUMBER,
310: X_OBJECT_VERSION_NUMBER in NUMBER
311: ) is
312: cursor c is select OBJECT_VERSION_NUMBER
313: from IEX_WRITEOFF_OBJECTS
314: where WRITEOFF_OBJECT_ID = X_WRITEOFF_OBJECT_ID
315: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
316: for update of WRITEOFF_OBJECT_ID nowait;
317: recinfo c%rowtype;

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

318:
319:
320: begin
321: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
322: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ** ');
323: END IF;
324: open c;
325: fetch c into recinfo;
326: if (c%notfound) then

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

337: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
338: app_exception.raise_exception;
339: end if;
340: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
341: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ******** ');
342: END IF;
343: end LOCK_ROW;
344:
345: END IEX_WRITEOFF_OBJECTS_PKG;

Line 345: END IEX_WRITEOFF_OBJECTS_PKG;

341: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_WRITEOFF_OBJECTS_PKG.LOCK_ROW ******** ');
342: END IF;
343: end LOCK_ROW;
344:
345: END IEX_WRITEOFF_OBJECTS_PKG;
346: