APPS.OE_DBI_UTIL dependencies on ONT_DBI_CHANGE_LOG

Line 327: oe_debug_pub.add(' Trying to lock the ONT_DBI_CHANGE_LOG');

323: FOR i IN l_dbi_rec.line_id.FIRST..l_dbi_rec.line_id.LAST LOOP
324:
325: BEGIN
326: IF l_debug_level > 0 THEN
327: oe_debug_pub.add(' Trying to lock the ONT_DBI_CHANGE_LOG');
328: END IF;
329:
330: -- Check if the record exists in ONT_DBI_CHANGE_LOG.
331: -- If yes then first take a lock on that record.

Line 330: -- Check if the record exists in ONT_DBI_CHANGE_LOG.

326: IF l_debug_level > 0 THEN
327: oe_debug_pub.add(' Trying to lock the ONT_DBI_CHANGE_LOG');
328: END IF;
329:
330: -- Check if the record exists in ONT_DBI_CHANGE_LOG.
331: -- If yes then first take a lock on that record.
332:
333: SELECT 'Y'
334: INTO l_dbi_rec.rec_exists_flag(i)

Line 335: FROM ONT_DBI_CHANGE_LOG

331: -- If yes then first take a lock on that record.
332:
333: SELECT 'Y'
334: INTO l_dbi_rec.rec_exists_flag(i)
335: FROM ONT_DBI_CHANGE_LOG
336: --- WHERE header_id = l_header_id bug 7319732 ,7347663
337: WHERE header_id=l_dbi_rec.header_id(i) ---bug 7319732 ,7347663
338: AND line_id = l_dbi_rec.line_id(i)
339: AND set_of_books_id = l_set_of_books_id

Line 376: -- Create records in ONT_DBI_CHANGE_LOG

372:
373: END IF; -- Bug # 5022517
374:
375: IF l_dbi_create_rec.line_id.EXISTS(1) THEN
376: -- Create records in ONT_DBI_CHANGE_LOG
377: ---changed l_header_id to l_dbi_create_rec.header_id(j) --bug 7319732,7347663
378: IF l_debug_level > 0 THEN
379: oe_debug_pub.add('Inserting new records ' || l_dbi_create_rec.line_id.COUNT );
380: END IF;

Line 382: INSERT INTO ONT_DBI_CHANGE_LOG

378: IF l_debug_level > 0 THEN
379: oe_debug_pub.add('Inserting new records ' || l_dbi_create_rec.line_id.COUNT );
380: END IF;
381: FORALL i IN 1..l_dbi_create_rec.line_id.COUNT
382: INSERT INTO ONT_DBI_CHANGE_LOG
383: (HEADER_ID
384: ,LINE_ID
385: ,SET_OF_BOOKS_ID
386: ,CURRENCY_CODE

Line 405: UPDATE ONT_DBI_CHANGE_LOG

401: oe_debug_pub.add('Updating existing records '|| l_dbi_rec.line_id.COUNT );
402: END IF;
403:
404: FORALL i in 1..l_dbi_rec.line_id.COUNT
405: UPDATE ONT_DBI_CHANGE_LOG
406: SET LAST_UPDATE_DATE = SYSDATE
407: --WHERE HEADER_ID = l_header_id
408: WHERE HEADER_ID = l_dbi_rec.header_id(i) --bug 7319732,7347663
409: AND LINE_ID = l_dbi_rec.line_id(i)