APPS.IEX_BALI_FILTERS_PKG dependencies on IEX_BALI_FILTERS

Line 1: PACKAGE BODY IEX_BALI_FILTERS_PKG AS

1: PACKAGE BODY IEX_BALI_FILTERS_PKG AS
2: /* $Header: iextbflb.pls 120.2 2004/05/14 15:17:46 jsanju noship $ */
3:
4: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5:

Line 47: CURSOR C IS SELECT ROWID FROM IEX_BALI_FILTERS

43: x_created_by in number,
44: x_last_update_date in date,
45: x_last_updated_by in number,
46: x_last_update_login in number) IS
47: CURSOR C IS SELECT ROWID FROM IEX_BALI_FILTERS
48: WHERE BALI_FILTER_ID = x_BALI_FILTER_ID;
49:
50: BEGIN
51: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 53: 'IEX_BALI_FILTERS_PKG.INSERT_ROW ** ');

49:
50: BEGIN
51: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
52: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
53: 'IEX_BALI_FILTERS_PKG.INSERT_ROW ** ');
54: END IF;
55: INSERT INTO IEX_BALI_FILTERS
56: (bali_filter_id,
57: bali_filter_name,

Line 55: INSERT INTO IEX_BALI_FILTERS

51: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
52: IEX_DEBUG_PUB.LogMessage ('** Start of Procedure =>'||
53: 'IEX_BALI_FILTERS_PKG.INSERT_ROW ** ');
54: END IF;
55: INSERT INTO IEX_BALI_FILTERS
56: (bali_filter_id,
57: bali_filter_name,
58: bali_datasource,
59: bali_user_id,

Line 147: 'IEX_BALI_FILTERS_PKG.INSERT_ROW *** ');

143: END IF;
144: CLOSE C;
145: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
146: IEX_DEBUG_PUB.LogMessage ('** End of Procedure =>'||
147: 'IEX_BALI_FILTERS_PKG.INSERT_ROW *** ');
148: END IF;
149: END Insert_Row;
150:
151: /* Update_Row procedure */

Line 192: UPDATE IEX_BALI_FILTERS SET

188: x_last_updated_by in number,
189: x_last_update_login in number)
190: IS
191: BEGIN
192: UPDATE IEX_BALI_FILTERS SET
193: BALI_FILTER_ID = decode( x_BALI_FILTER_ID, FND_API.G_MISS_NUM, NULL,
194: NULL, BALI_FILTER_ID, x_BALI_FILTER_ID)
195: ,bali_filter_name =decode( x_bali_filter_name, fnd_api.g_miss_char,null,
196: null,bali_filter_name, x_bali_filter_name)

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

283: PROCEDURE Delete_Row(x_bali_filter_id IN NUMBER)
284: IS
285: BEGIN
286: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
287: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_BALI_FILTERS_PKG.DELETE_ROW *** ');
288: END IF;
289: delete from IEX_BALI_FILTERS
290: where bali_filter_id = x_bali_filter_id;
291:

Line 289: delete from IEX_BALI_FILTERS

285: BEGIN
286: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
287: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_BALI_FILTERS_PKG.DELETE_ROW *** ');
288: END IF;
289: delete from IEX_BALI_FILTERS
290: where bali_filter_id = x_bali_filter_id;
291:
292: if (sql%notfound) then
293: raise no_data_found;

Line 303: from IEX_BALI_FILTERS

299: x_bali_filter_id in NUMBER,
300: X_OBJECT_VERSION_NUMBER in NUMBER
301: ) is
302: cursor c is select OBJECT_VERSION_NUMBER
303: from IEX_BALI_FILTERS
304: where bali_filter_id = X_bali_filter_id
305: and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER
306: for update of bali_filter_id nowait;
307: recinfo c%rowtype;

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

308:
309:
310: begin
311: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
312: IEX_DEBUG_PUB.LogMessage ('*** Start of Procedure =>IEX_BALI_FILTERS_PKG.LOCK_ROW ** ');
313: END IF;
314: open c;
315: fetch c into recinfo;
316: if (c%notfound) then

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

327: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
328: app_exception.raise_exception;
329: end if;
330: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
331: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_BALI_FILTERS_PKG.LOCK_ROW ******** ');
332: END IF;
333: end LOCK_ROW;
334:
335: END IEX_BALI_FILTERS_PKG;

Line 335: END IEX_BALI_FILTERS_PKG;

331: IEX_DEBUG_PUB.LogMessage ('********* End of Procedure =>IEX_BALI_FILTERS_PKG.LOCK_ROW ******** ');
332: END IF;
333: end LOCK_ROW;
334:
335: END IEX_BALI_FILTERS_PKG;
336: