eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_HV_TXN_PURGE dependencies on DBMS_SQL

Line 289: cursor_name := dbms_sql.open_cursor;

285: ELSE
286: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
287: END IF;
288:
289: cursor_name := dbms_sql.open_cursor;
290: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
291: rows_processed := dbms_sql.execute(cursor_name);
292: DBMS_SQL.close_cursor(cursor_name);
293:

Line 290: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

286: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
287: END IF;
288:
289: cursor_name := dbms_sql.open_cursor;
290: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
291: rows_processed := dbms_sql.execute(cursor_name);
292: DBMS_SQL.close_cursor(cursor_name);
293:
294: IF (l_debug = 1) THEN

Line 291: rows_processed := dbms_sql.execute(cursor_name);

287: END IF;
288:
289: cursor_name := dbms_sql.open_cursor;
290: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
291: rows_processed := dbms_sql.execute(cursor_name);
292: DBMS_SQL.close_cursor(cursor_name);
293:
294: IF (l_debug = 1) THEN
295: inv_trx_util_pub.TRACE(' Temp Table mtl_material_txn_alloc_bu created.' );

Line 292: DBMS_SQL.close_cursor(cursor_name);

288:
289: cursor_name := dbms_sql.open_cursor;
290: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
291: rows_processed := dbms_sql.execute(cursor_name);
292: DBMS_SQL.close_cursor(cursor_name);
293:
294: IF (l_debug = 1) THEN
295: inv_trx_util_pub.TRACE(' Temp Table mtl_material_txn_alloc_bu created.' );
296: END IF;

Line 300: cursor_name := dbms_sql.open_cursor;

296: END IF;
297:
298: --Truncate the original table
299: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TXN_ALLOCATIONS';
300: cursor_name := dbms_sql.open_cursor;
301: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
302: rows_processed := dbms_sql.execute(cursor_name);
303: DBMS_SQL.close_cursor(cursor_name);
304:

Line 301: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

297:
298: --Truncate the original table
299: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TXN_ALLOCATIONS';
300: cursor_name := dbms_sql.open_cursor;
301: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
302: rows_processed := dbms_sql.execute(cursor_name);
303: DBMS_SQL.close_cursor(cursor_name);
304:
305: IF (l_debug = 1) THEN

Line 302: rows_processed := dbms_sql.execute(cursor_name);

298: --Truncate the original table
299: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TXN_ALLOCATIONS';
300: cursor_name := dbms_sql.open_cursor;
301: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
302: rows_processed := dbms_sql.execute(cursor_name);
303: DBMS_SQL.close_cursor(cursor_name);
304:
305: IF (l_debug = 1) THEN
306: inv_trx_util_pub.TRACE(' Truncated the table MTL_MATERIAL_TXN_ALLOCATIONS');

Line 303: DBMS_SQL.close_cursor(cursor_name);

299: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TXN_ALLOCATIONS';
300: cursor_name := dbms_sql.open_cursor;
301: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
302: rows_processed := dbms_sql.execute(cursor_name);
303: DBMS_SQL.close_cursor(cursor_name);
304:
305: IF (l_debug = 1) THEN
306: inv_trx_util_pub.TRACE(' Truncated the table MTL_MATERIAL_TXN_ALLOCATIONS');
307: END IF;

Line 311: cursor_name := dbms_sql.open_cursor;

307: END IF;
308:
309: -- Insert required rows back to original table
310: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TXN_ALLOCATIONS SELECT * FROM mtl_material_txn_alloc_bu';
311: cursor_name := dbms_sql.open_cursor;
312: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
313: rows_processed := dbms_sql.execute(cursor_name);
314: DBMS_SQL.close_cursor(cursor_name);
315:

Line 312: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

308:
309: -- Insert required rows back to original table
310: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TXN_ALLOCATIONS SELECT * FROM mtl_material_txn_alloc_bu';
311: cursor_name := dbms_sql.open_cursor;
312: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
313: rows_processed := dbms_sql.execute(cursor_name);
314: DBMS_SQL.close_cursor(cursor_name);
315:
316: IF (l_debug = 1) THEN

Line 313: rows_processed := dbms_sql.execute(cursor_name);

309: -- Insert required rows back to original table
310: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TXN_ALLOCATIONS SELECT * FROM mtl_material_txn_alloc_bu';
311: cursor_name := dbms_sql.open_cursor;
312: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
313: rows_processed := dbms_sql.execute(cursor_name);
314: DBMS_SQL.close_cursor(cursor_name);
315:
316: IF (l_debug = 1) THEN
317: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_MATERIAL_TXN_ALLOCATIONS');

Line 314: DBMS_SQL.close_cursor(cursor_name);

310: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TXN_ALLOCATIONS SELECT * FROM mtl_material_txn_alloc_bu';
311: cursor_name := dbms_sql.open_cursor;
312: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
313: rows_processed := dbms_sql.execute(cursor_name);
314: DBMS_SQL.close_cursor(cursor_name);
315:
316: IF (l_debug = 1) THEN
317: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_MATERIAL_TXN_ALLOCATIONS');
318: END IF;

Line 328: cursor_name := dbms_sql.open_cursor;

324: END IF;
325:
326: --Drop the temporary table
327: s_sql_stmt := 'DROP TABLE mtl_material_txn_alloc_bu';
328: cursor_name := dbms_sql.open_cursor;
329: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
330: rows_processed := dbms_sql.execute(cursor_name);
331: DBMS_SQL.close_cursor(cursor_name);
332:

Line 329: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

325:
326: --Drop the temporary table
327: s_sql_stmt := 'DROP TABLE mtl_material_txn_alloc_bu';
328: cursor_name := dbms_sql.open_cursor;
329: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
330: rows_processed := dbms_sql.execute(cursor_name);
331: DBMS_SQL.close_cursor(cursor_name);
332:
333: IF (l_debug = 1) THEN

Line 330: rows_processed := dbms_sql.execute(cursor_name);

326: --Drop the temporary table
327: s_sql_stmt := 'DROP TABLE mtl_material_txn_alloc_bu';
328: cursor_name := dbms_sql.open_cursor;
329: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
330: rows_processed := dbms_sql.execute(cursor_name);
331: DBMS_SQL.close_cursor(cursor_name);
332:
333: IF (l_debug = 1) THEN
334: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_material_txn_alloc_bu');

Line 331: DBMS_SQL.close_cursor(cursor_name);

327: s_sql_stmt := 'DROP TABLE mtl_material_txn_alloc_bu';
328: cursor_name := dbms_sql.open_cursor;
329: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
330: rows_processed := dbms_sql.execute(cursor_name);
331: DBMS_SQL.close_cursor(cursor_name);
332:
333: IF (l_debug = 1) THEN
334: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_material_txn_alloc_bu');
335: END IF;

Line 345: IF DBMS_SQL.IS_OPEN(cursor_name) THEN

341: IF (l_debug = 1) THEN
342: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
343: END IF;
344:
345: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
346: DBMS_SQL.CLOSE_CURSOR(cursor_name);
347: END IF;
348:
349: RAISE fnd_api.g_exc_error;

Line 346: DBMS_SQL.CLOSE_CURSOR(cursor_name);

342: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
343: END IF;
344:
345: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
346: DBMS_SQL.CLOSE_CURSOR(cursor_name);
347: END IF;
348:
349: RAISE fnd_api.g_exc_error;
350: END;

Line 436: cursor_name := dbms_sql.open_cursor;

432: ELSE
433: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
434: END IF;
435:
436: cursor_name := dbms_sql.open_cursor;
437: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
438: rows_processed := dbms_sql.execute(cursor_name);
439: DBMS_SQL.close_cursor(cursor_name);
440:

Line 437: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

433: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
434: END IF;
435:
436: cursor_name := dbms_sql.open_cursor;
437: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
438: rows_processed := dbms_sql.execute(cursor_name);
439: DBMS_SQL.close_cursor(cursor_name);
440:
441: IF (l_debug = 1) THEN

Line 438: rows_processed := dbms_sql.execute(cursor_name);

434: END IF;
435:
436: cursor_name := dbms_sql.open_cursor;
437: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
438: rows_processed := dbms_sql.execute(cursor_name);
439: DBMS_SQL.close_cursor(cursor_name);
440:
441: IF (l_debug = 1) THEN
442: inv_trx_util_pub.TRACE(' Temp Table mtl_material_transactions_bu created.' );

Line 439: DBMS_SQL.close_cursor(cursor_name);

435:
436: cursor_name := dbms_sql.open_cursor;
437: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
438: rows_processed := dbms_sql.execute(cursor_name);
439: DBMS_SQL.close_cursor(cursor_name);
440:
441: IF (l_debug = 1) THEN
442: inv_trx_util_pub.TRACE(' Temp Table mtl_material_transactions_bu created.' );
443: END IF;

Line 447: cursor_name := dbms_sql.open_cursor;

443: END IF;
444:
445: --Truncate the original table
446: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TRANSACTIONS';
447: cursor_name := dbms_sql.open_cursor;
448: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
449: rows_processed := dbms_sql.execute(cursor_name);
450: DBMS_SQL.close_cursor(cursor_name);
451:

Line 448: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

444:
445: --Truncate the original table
446: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TRANSACTIONS';
447: cursor_name := dbms_sql.open_cursor;
448: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
449: rows_processed := dbms_sql.execute(cursor_name);
450: DBMS_SQL.close_cursor(cursor_name);
451:
452: IF (l_debug = 1) THEN

Line 449: rows_processed := dbms_sql.execute(cursor_name);

445: --Truncate the original table
446: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TRANSACTIONS';
447: cursor_name := dbms_sql.open_cursor;
448: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
449: rows_processed := dbms_sql.execute(cursor_name);
450: DBMS_SQL.close_cursor(cursor_name);
451:
452: IF (l_debug = 1) THEN
453: inv_trx_util_pub.TRACE(' Truncated the table MTL_MATERIAL_TRANSACTIONS');

Line 450: DBMS_SQL.close_cursor(cursor_name);

446: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_MATERIAL_TRANSACTIONS';
447: cursor_name := dbms_sql.open_cursor;
448: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
449: rows_processed := dbms_sql.execute(cursor_name);
450: DBMS_SQL.close_cursor(cursor_name);
451:
452: IF (l_debug = 1) THEN
453: inv_trx_util_pub.TRACE(' Truncated the table MTL_MATERIAL_TRANSACTIONS');
454: END IF;

Line 458: cursor_name := dbms_sql.open_cursor;

454: END IF;
455:
456: -- Insert required rows back to original table
457: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TRANSACTIONS SELECT * FROM mtl_material_transactions_bu';
458: cursor_name := dbms_sql.open_cursor;
459: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
460: rows_processed := dbms_sql.execute(cursor_name);
461: DBMS_SQL.close_cursor(cursor_name);
462:

Line 459: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

455:
456: -- Insert required rows back to original table
457: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TRANSACTIONS SELECT * FROM mtl_material_transactions_bu';
458: cursor_name := dbms_sql.open_cursor;
459: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
460: rows_processed := dbms_sql.execute(cursor_name);
461: DBMS_SQL.close_cursor(cursor_name);
462:
463: IF (l_debug = 1) THEN

Line 460: rows_processed := dbms_sql.execute(cursor_name);

456: -- Insert required rows back to original table
457: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TRANSACTIONS SELECT * FROM mtl_material_transactions_bu';
458: cursor_name := dbms_sql.open_cursor;
459: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
460: rows_processed := dbms_sql.execute(cursor_name);
461: DBMS_SQL.close_cursor(cursor_name);
462:
463: IF (l_debug = 1) THEN
464: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_MATERIAL_TRANSACTIONS');

Line 461: DBMS_SQL.close_cursor(cursor_name);

457: s_sql_stmt := 'INSERT INTO MTL_MATERIAL_TRANSACTIONS SELECT * FROM mtl_material_transactions_bu';
458: cursor_name := dbms_sql.open_cursor;
459: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
460: rows_processed := dbms_sql.execute(cursor_name);
461: DBMS_SQL.close_cursor(cursor_name);
462:
463: IF (l_debug = 1) THEN
464: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_MATERIAL_TRANSACTIONS');
465: END IF;

Line 475: cursor_name := dbms_sql.open_cursor;

471: END IF;
472:
473: --Drop the temporary table
474: s_sql_stmt := 'DROP TABLE mtl_material_transactions_bu';
475: cursor_name := dbms_sql.open_cursor;
476: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
477: rows_processed := dbms_sql.execute(cursor_name);
478: DBMS_SQL.close_cursor(cursor_name);
479:

Line 476: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

472:
473: --Drop the temporary table
474: s_sql_stmt := 'DROP TABLE mtl_material_transactions_bu';
475: cursor_name := dbms_sql.open_cursor;
476: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
477: rows_processed := dbms_sql.execute(cursor_name);
478: DBMS_SQL.close_cursor(cursor_name);
479:
480: IF (l_debug = 1) THEN

Line 477: rows_processed := dbms_sql.execute(cursor_name);

473: --Drop the temporary table
474: s_sql_stmt := 'DROP TABLE mtl_material_transactions_bu';
475: cursor_name := dbms_sql.open_cursor;
476: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
477: rows_processed := dbms_sql.execute(cursor_name);
478: DBMS_SQL.close_cursor(cursor_name);
479:
480: IF (l_debug = 1) THEN
481: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_material_transactions_bu');

Line 478: DBMS_SQL.close_cursor(cursor_name);

474: s_sql_stmt := 'DROP TABLE mtl_material_transactions_bu';
475: cursor_name := dbms_sql.open_cursor;
476: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
477: rows_processed := dbms_sql.execute(cursor_name);
478: DBMS_SQL.close_cursor(cursor_name);
479:
480: IF (l_debug = 1) THEN
481: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_material_transactions_bu');
482: END IF;

Line 492: IF DBMS_SQL.IS_OPEN(cursor_name) THEN

488: IF (l_debug = 1) THEN
489: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
490: END IF;
491:
492: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
493: DBMS_SQL.CLOSE_CURSOR(cursor_name);
494: END IF;
495:
496: RAISE fnd_api.g_exc_error;

Line 493: DBMS_SQL.CLOSE_CURSOR(cursor_name);

489: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
490: END IF;
491:
492: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
493: DBMS_SQL.CLOSE_CURSOR(cursor_name);
494: END IF;
495:
496: RAISE fnd_api.g_exc_error;
497: END;

Line 583: cursor_name := dbms_sql.open_cursor;

579: ELSE
580: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
581: END IF;
582:
583: cursor_name := dbms_sql.open_cursor;
584: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
585: rows_processed := dbms_sql.execute(cursor_name);
586: DBMS_SQL.close_cursor(cursor_name);
587:

Line 584: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

580: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
581: END IF;
582:
583: cursor_name := dbms_sql.open_cursor;
584: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
585: rows_processed := dbms_sql.execute(cursor_name);
586: DBMS_SQL.close_cursor(cursor_name);
587:
588: IF (l_debug = 1) THEN

Line 585: rows_processed := dbms_sql.execute(cursor_name);

581: END IF;
582:
583: cursor_name := dbms_sql.open_cursor;
584: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
585: rows_processed := dbms_sql.execute(cursor_name);
586: DBMS_SQL.close_cursor(cursor_name);
587:
588: IF (l_debug = 1) THEN
589: inv_trx_util_pub.TRACE(' Temp Table mtl_transaction_lot_numbers_bu created.' );

Line 586: DBMS_SQL.close_cursor(cursor_name);

582:
583: cursor_name := dbms_sql.open_cursor;
584: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
585: rows_processed := dbms_sql.execute(cursor_name);
586: DBMS_SQL.close_cursor(cursor_name);
587:
588: IF (l_debug = 1) THEN
589: inv_trx_util_pub.TRACE(' Temp Table mtl_transaction_lot_numbers_bu created.' );
590: END IF;

Line 594: cursor_name := dbms_sql.open_cursor;

590: END IF;
591:
592: --Truncate the original table
593: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_LOT_NUMBERS';
594: cursor_name := dbms_sql.open_cursor;
595: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
596: rows_processed := dbms_sql.execute(cursor_name);
597: DBMS_SQL.close_cursor(cursor_name);
598:

Line 595: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

591:
592: --Truncate the original table
593: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_LOT_NUMBERS';
594: cursor_name := dbms_sql.open_cursor;
595: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
596: rows_processed := dbms_sql.execute(cursor_name);
597: DBMS_SQL.close_cursor(cursor_name);
598:
599: IF (l_debug = 1) THEN

Line 596: rows_processed := dbms_sql.execute(cursor_name);

592: --Truncate the original table
593: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_LOT_NUMBERS';
594: cursor_name := dbms_sql.open_cursor;
595: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
596: rows_processed := dbms_sql.execute(cursor_name);
597: DBMS_SQL.close_cursor(cursor_name);
598:
599: IF (l_debug = 1) THEN
600: inv_trx_util_pub.TRACE(' Truncated the table MTL_TRANSACTION_LOT_NUMBERS');

Line 597: DBMS_SQL.close_cursor(cursor_name);

593: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_LOT_NUMBERS';
594: cursor_name := dbms_sql.open_cursor;
595: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
596: rows_processed := dbms_sql.execute(cursor_name);
597: DBMS_SQL.close_cursor(cursor_name);
598:
599: IF (l_debug = 1) THEN
600: inv_trx_util_pub.TRACE(' Truncated the table MTL_TRANSACTION_LOT_NUMBERS');
601: END IF;

Line 605: cursor_name := dbms_sql.open_cursor;

601: END IF;
602:
603: -- Insert required rows back to original table
604: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_LOT_NUMBERS SELECT * FROM mtl_transaction_lot_numbers_bu';
605: cursor_name := dbms_sql.open_cursor;
606: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
607: rows_processed := dbms_sql.execute(cursor_name);
608: DBMS_SQL.close_cursor(cursor_name);
609:

Line 606: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

602:
603: -- Insert required rows back to original table
604: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_LOT_NUMBERS SELECT * FROM mtl_transaction_lot_numbers_bu';
605: cursor_name := dbms_sql.open_cursor;
606: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
607: rows_processed := dbms_sql.execute(cursor_name);
608: DBMS_SQL.close_cursor(cursor_name);
609:
610: IF (l_debug = 1) THEN

Line 607: rows_processed := dbms_sql.execute(cursor_name);

603: -- Insert required rows back to original table
604: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_LOT_NUMBERS SELECT * FROM mtl_transaction_lot_numbers_bu';
605: cursor_name := dbms_sql.open_cursor;
606: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
607: rows_processed := dbms_sql.execute(cursor_name);
608: DBMS_SQL.close_cursor(cursor_name);
609:
610: IF (l_debug = 1) THEN
611: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_TRANSACTION_LOT_NUMBERS');

Line 608: DBMS_SQL.close_cursor(cursor_name);

604: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_LOT_NUMBERS SELECT * FROM mtl_transaction_lot_numbers_bu';
605: cursor_name := dbms_sql.open_cursor;
606: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
607: rows_processed := dbms_sql.execute(cursor_name);
608: DBMS_SQL.close_cursor(cursor_name);
609:
610: IF (l_debug = 1) THEN
611: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_TRANSACTION_LOT_NUMBERS');
612: END IF;

Line 622: cursor_name := dbms_sql.open_cursor;

618: END IF;
619:
620: --Drop the temporary table
621: s_sql_stmt := 'DROP TABLE mtl_transaction_lot_numbers_bu';
622: cursor_name := dbms_sql.open_cursor;
623: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
624: rows_processed := dbms_sql.execute(cursor_name);
625: DBMS_SQL.close_cursor(cursor_name);
626:

Line 623: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

619:
620: --Drop the temporary table
621: s_sql_stmt := 'DROP TABLE mtl_transaction_lot_numbers_bu';
622: cursor_name := dbms_sql.open_cursor;
623: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
624: rows_processed := dbms_sql.execute(cursor_name);
625: DBMS_SQL.close_cursor(cursor_name);
626:
627: IF (l_debug = 1) THEN

Line 624: rows_processed := dbms_sql.execute(cursor_name);

620: --Drop the temporary table
621: s_sql_stmt := 'DROP TABLE mtl_transaction_lot_numbers_bu';
622: cursor_name := dbms_sql.open_cursor;
623: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
624: rows_processed := dbms_sql.execute(cursor_name);
625: DBMS_SQL.close_cursor(cursor_name);
626:
627: IF (l_debug = 1) THEN
628: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_transaction_lot_numbers_bu');

Line 625: DBMS_SQL.close_cursor(cursor_name);

621: s_sql_stmt := 'DROP TABLE mtl_transaction_lot_numbers_bu';
622: cursor_name := dbms_sql.open_cursor;
623: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
624: rows_processed := dbms_sql.execute(cursor_name);
625: DBMS_SQL.close_cursor(cursor_name);
626:
627: IF (l_debug = 1) THEN
628: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_transaction_lot_numbers_bu');
629: END IF;

Line 639: IF DBMS_SQL.IS_OPEN(cursor_name) THEN

635: IF (l_debug = 1) THEN
636: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
637: END IF;
638:
639: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
640: DBMS_SQL.CLOSE_CURSOR(cursor_name);
641: END IF;
642:
643: RAISE fnd_api.g_exc_error;

Line 640: DBMS_SQL.CLOSE_CURSOR(cursor_name);

636: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
637: END IF;
638:
639: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
640: DBMS_SQL.CLOSE_CURSOR(cursor_name);
641: END IF;
642:
643: RAISE fnd_api.g_exc_error;
644: END;

Line 730: cursor_name := dbms_sql.open_cursor;

726: ELSE
727: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
728: END IF;
729:
730: cursor_name := dbms_sql.open_cursor;
731: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
732: rows_processed := dbms_sql.execute(cursor_name);
733: DBMS_SQL.close_cursor(cursor_name);
734:

Line 731: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

727: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
728: END IF;
729:
730: cursor_name := dbms_sql.open_cursor;
731: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
732: rows_processed := dbms_sql.execute(cursor_name);
733: DBMS_SQL.close_cursor(cursor_name);
734:
735: IF (l_debug = 1) THEN

Line 732: rows_processed := dbms_sql.execute(cursor_name);

728: END IF;
729:
730: cursor_name := dbms_sql.open_cursor;
731: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
732: rows_processed := dbms_sql.execute(cursor_name);
733: DBMS_SQL.close_cursor(cursor_name);
734:
735: IF (l_debug = 1) THEN
736: inv_trx_util_pub.TRACE(' Temp Table mtl_unit_transactions_bu created.' );

Line 733: DBMS_SQL.close_cursor(cursor_name);

729:
730: cursor_name := dbms_sql.open_cursor;
731: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
732: rows_processed := dbms_sql.execute(cursor_name);
733: DBMS_SQL.close_cursor(cursor_name);
734:
735: IF (l_debug = 1) THEN
736: inv_trx_util_pub.TRACE(' Temp Table mtl_unit_transactions_bu created.' );
737: END IF;

Line 741: cursor_name := dbms_sql.open_cursor;

737: END IF;
738:
739: --Truncate the original table
740: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_UNIT_TRANSACTIONS';
741: cursor_name := dbms_sql.open_cursor;
742: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
743: rows_processed := dbms_sql.execute(cursor_name);
744: DBMS_SQL.close_cursor(cursor_name);
745:

Line 742: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

738:
739: --Truncate the original table
740: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_UNIT_TRANSACTIONS';
741: cursor_name := dbms_sql.open_cursor;
742: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
743: rows_processed := dbms_sql.execute(cursor_name);
744: DBMS_SQL.close_cursor(cursor_name);
745:
746: IF (l_debug = 1) THEN

Line 743: rows_processed := dbms_sql.execute(cursor_name);

739: --Truncate the original table
740: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_UNIT_TRANSACTIONS';
741: cursor_name := dbms_sql.open_cursor;
742: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
743: rows_processed := dbms_sql.execute(cursor_name);
744: DBMS_SQL.close_cursor(cursor_name);
745:
746: IF (l_debug = 1) THEN
747: inv_trx_util_pub.TRACE(' Truncated the table MTL_UNIT_TRANSACTIONS');

Line 744: DBMS_SQL.close_cursor(cursor_name);

740: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_UNIT_TRANSACTIONS';
741: cursor_name := dbms_sql.open_cursor;
742: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
743: rows_processed := dbms_sql.execute(cursor_name);
744: DBMS_SQL.close_cursor(cursor_name);
745:
746: IF (l_debug = 1) THEN
747: inv_trx_util_pub.TRACE(' Truncated the table MTL_UNIT_TRANSACTIONS');
748: END IF;

Line 752: cursor_name := dbms_sql.open_cursor;

748: END IF;
749:
750: -- Insert required rows back to original table
751: s_sql_stmt := 'INSERT INTO MTL_UNIT_TRANSACTIONS SELECT * FROM mtl_unit_transactions_bu';
752: cursor_name := dbms_sql.open_cursor;
753: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
754: rows_processed := dbms_sql.execute(cursor_name);
755: DBMS_SQL.close_cursor(cursor_name);
756:

Line 753: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

749:
750: -- Insert required rows back to original table
751: s_sql_stmt := 'INSERT INTO MTL_UNIT_TRANSACTIONS SELECT * FROM mtl_unit_transactions_bu';
752: cursor_name := dbms_sql.open_cursor;
753: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
754: rows_processed := dbms_sql.execute(cursor_name);
755: DBMS_SQL.close_cursor(cursor_name);
756:
757: IF (l_debug = 1) THEN

Line 754: rows_processed := dbms_sql.execute(cursor_name);

750: -- Insert required rows back to original table
751: s_sql_stmt := 'INSERT INTO MTL_UNIT_TRANSACTIONS SELECT * FROM mtl_unit_transactions_bu';
752: cursor_name := dbms_sql.open_cursor;
753: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
754: rows_processed := dbms_sql.execute(cursor_name);
755: DBMS_SQL.close_cursor(cursor_name);
756:
757: IF (l_debug = 1) THEN
758: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_UNIT_TRANSACTIONS');

Line 755: DBMS_SQL.close_cursor(cursor_name);

751: s_sql_stmt := 'INSERT INTO MTL_UNIT_TRANSACTIONS SELECT * FROM mtl_unit_transactions_bu';
752: cursor_name := dbms_sql.open_cursor;
753: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
754: rows_processed := dbms_sql.execute(cursor_name);
755: DBMS_SQL.close_cursor(cursor_name);
756:
757: IF (l_debug = 1) THEN
758: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_UNIT_TRANSACTIONS');
759: END IF;

Line 769: cursor_name := dbms_sql.open_cursor;

765: END IF;
766:
767: --Drop the temporary table
768: s_sql_stmt := 'DROP TABLE mtl_unit_transactions_bu';
769: cursor_name := dbms_sql.open_cursor;
770: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
771: rows_processed := dbms_sql.execute(cursor_name);
772: DBMS_SQL.close_cursor(cursor_name);
773:

Line 770: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

766:
767: --Drop the temporary table
768: s_sql_stmt := 'DROP TABLE mtl_unit_transactions_bu';
769: cursor_name := dbms_sql.open_cursor;
770: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
771: rows_processed := dbms_sql.execute(cursor_name);
772: DBMS_SQL.close_cursor(cursor_name);
773:
774: IF (l_debug = 1) THEN

Line 771: rows_processed := dbms_sql.execute(cursor_name);

767: --Drop the temporary table
768: s_sql_stmt := 'DROP TABLE mtl_unit_transactions_bu';
769: cursor_name := dbms_sql.open_cursor;
770: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
771: rows_processed := dbms_sql.execute(cursor_name);
772: DBMS_SQL.close_cursor(cursor_name);
773:
774: IF (l_debug = 1) THEN
775: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_unit_transactions_bu');

Line 772: DBMS_SQL.close_cursor(cursor_name);

768: s_sql_stmt := 'DROP TABLE mtl_unit_transactions_bu';
769: cursor_name := dbms_sql.open_cursor;
770: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
771: rows_processed := dbms_sql.execute(cursor_name);
772: DBMS_SQL.close_cursor(cursor_name);
773:
774: IF (l_debug = 1) THEN
775: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_unit_transactions_bu');
776: END IF;

Line 786: IF DBMS_SQL.IS_OPEN(cursor_name) THEN

782: IF (l_debug = 1) THEN
783: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
784: END IF;
785:
786: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
787: DBMS_SQL.CLOSE_CURSOR(cursor_name);
788: END IF;
789:
790: RAISE fnd_api.g_exc_error;

Line 787: DBMS_SQL.CLOSE_CURSOR(cursor_name);

783: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
784: END IF;
785:
786: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
787: DBMS_SQL.CLOSE_CURSOR(cursor_name);
788: END IF;
789:
790: RAISE fnd_api.g_exc_error;
791: END;

Line 895: cursor_name := dbms_sql.open_cursor;

891: ELSE
892: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
893: END IF;
894:
895: cursor_name := dbms_sql.open_cursor;
896: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
897: rows_processed := dbms_sql.execute(cursor_name);
898: DBMS_SQL.close_cursor(cursor_name);
899:

Line 896: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

892: s_sql_stmt := s_sql_stmt || ' and transaction_date >= to_date( '' ' || s_cut_off_date || ' '' , ''MM-DD-RRRR'' )';
893: END IF;
894:
895: cursor_name := dbms_sql.open_cursor;
896: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
897: rows_processed := dbms_sql.execute(cursor_name);
898: DBMS_SQL.close_cursor(cursor_name);
899:
900: IF (l_debug = 1) THEN

Line 897: rows_processed := dbms_sql.execute(cursor_name);

893: END IF;
894:
895: cursor_name := dbms_sql.open_cursor;
896: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
897: rows_processed := dbms_sql.execute(cursor_name);
898: DBMS_SQL.close_cursor(cursor_name);
899:
900: IF (l_debug = 1) THEN
901: inv_trx_util_pub.TRACE(' Temp Table mtl_transaction_accounts_bu created.' );

Line 898: DBMS_SQL.close_cursor(cursor_name);

894:
895: cursor_name := dbms_sql.open_cursor;
896: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
897: rows_processed := dbms_sql.execute(cursor_name);
898: DBMS_SQL.close_cursor(cursor_name);
899:
900: IF (l_debug = 1) THEN
901: inv_trx_util_pub.TRACE(' Temp Table mtl_transaction_accounts_bu created.' );
902: END IF;

Line 906: cursor_name := dbms_sql.open_cursor;

902: END IF;
903:
904: --Truncate the original table
905: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_ACCOUNTS';
906: cursor_name := dbms_sql.open_cursor;
907: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
908: rows_processed := dbms_sql.execute(cursor_name);
909: DBMS_SQL.close_cursor(cursor_name);
910:

Line 907: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

903:
904: --Truncate the original table
905: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_ACCOUNTS';
906: cursor_name := dbms_sql.open_cursor;
907: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
908: rows_processed := dbms_sql.execute(cursor_name);
909: DBMS_SQL.close_cursor(cursor_name);
910:
911: IF (l_debug = 1) THEN

Line 908: rows_processed := dbms_sql.execute(cursor_name);

904: --Truncate the original table
905: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_ACCOUNTS';
906: cursor_name := dbms_sql.open_cursor;
907: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
908: rows_processed := dbms_sql.execute(cursor_name);
909: DBMS_SQL.close_cursor(cursor_name);
910:
911: IF (l_debug = 1) THEN
912: inv_trx_util_pub.TRACE(' Truncated the table MTL_TRANSACTION_ACCOUNTS');

Line 909: DBMS_SQL.close_cursor(cursor_name);

905: s_sql_stmt := 'TRUNCATE TABLE '|| inv_user_name || '.MTL_TRANSACTION_ACCOUNTS';
906: cursor_name := dbms_sql.open_cursor;
907: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
908: rows_processed := dbms_sql.execute(cursor_name);
909: DBMS_SQL.close_cursor(cursor_name);
910:
911: IF (l_debug = 1) THEN
912: inv_trx_util_pub.TRACE(' Truncated the table MTL_TRANSACTION_ACCOUNTS');
913: END IF;

Line 917: cursor_name := dbms_sql.open_cursor;

913: END IF;
914:
915: -- Insert required rows back to original table
916: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_ACCOUNTS SELECT * FROM mtl_transaction_accounts_bu';
917: cursor_name := dbms_sql.open_cursor;
918: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
919: rows_processed := dbms_sql.execute(cursor_name);
920: DBMS_SQL.close_cursor(cursor_name);
921:

Line 918: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

914:
915: -- Insert required rows back to original table
916: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_ACCOUNTS SELECT * FROM mtl_transaction_accounts_bu';
917: cursor_name := dbms_sql.open_cursor;
918: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
919: rows_processed := dbms_sql.execute(cursor_name);
920: DBMS_SQL.close_cursor(cursor_name);
921:
922: IF (l_debug = 1) THEN

Line 919: rows_processed := dbms_sql.execute(cursor_name);

915: -- Insert required rows back to original table
916: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_ACCOUNTS SELECT * FROM mtl_transaction_accounts_bu';
917: cursor_name := dbms_sql.open_cursor;
918: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
919: rows_processed := dbms_sql.execute(cursor_name);
920: DBMS_SQL.close_cursor(cursor_name);
921:
922: IF (l_debug = 1) THEN
923: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_TRANSACTION_ACCOUNTS');

Line 920: DBMS_SQL.close_cursor(cursor_name);

916: s_sql_stmt := 'INSERT INTO MTL_TRANSACTION_ACCOUNTS SELECT * FROM mtl_transaction_accounts_bu';
917: cursor_name := dbms_sql.open_cursor;
918: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
919: rows_processed := dbms_sql.execute(cursor_name);
920: DBMS_SQL.close_cursor(cursor_name);
921:
922: IF (l_debug = 1) THEN
923: inv_trx_util_pub.TRACE(' Inserted ' || rows_processed || ' row(s) into the table MTL_TRANSACTION_ACCOUNTS');
924: END IF;

Line 934: cursor_name := dbms_sql.open_cursor;

930: END IF;
931:
932: --Drop the temporary table
933: s_sql_stmt := 'DROP TABLE mtl_transaction_accounts_bu';
934: cursor_name := dbms_sql.open_cursor;
935: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
936: rows_processed := dbms_sql.execute(cursor_name);
937: DBMS_SQL.close_cursor(cursor_name);
938:

Line 935: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);

931:
932: --Drop the temporary table
933: s_sql_stmt := 'DROP TABLE mtl_transaction_accounts_bu';
934: cursor_name := dbms_sql.open_cursor;
935: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
936: rows_processed := dbms_sql.execute(cursor_name);
937: DBMS_SQL.close_cursor(cursor_name);
938:
939: IF (l_debug = 1) THEN

Line 936: rows_processed := dbms_sql.execute(cursor_name);

932: --Drop the temporary table
933: s_sql_stmt := 'DROP TABLE mtl_transaction_accounts_bu';
934: cursor_name := dbms_sql.open_cursor;
935: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
936: rows_processed := dbms_sql.execute(cursor_name);
937: DBMS_SQL.close_cursor(cursor_name);
938:
939: IF (l_debug = 1) THEN
940: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_transaction_accounts_bu');

Line 937: DBMS_SQL.close_cursor(cursor_name);

933: s_sql_stmt := 'DROP TABLE mtl_transaction_accounts_bu';
934: cursor_name := dbms_sql.open_cursor;
935: DBMS_SQL.PARSE(cursor_name, s_sql_stmt, dbms_sql.native);
936: rows_processed := dbms_sql.execute(cursor_name);
937: DBMS_SQL.close_cursor(cursor_name);
938:
939: IF (l_debug = 1) THEN
940: inv_trx_util_pub.TRACE(' Dropped the temporary table mtl_transaction_accounts_bu');
941: END IF;

Line 951: IF DBMS_SQL.IS_OPEN(cursor_name) THEN

947: IF (l_debug = 1) THEN
948: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
949: END IF;
950:
951: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
952: DBMS_SQL.CLOSE_CURSOR(cursor_name);
953: END IF;
954:
955: RAISE fnd_api.g_exc_error;

Line 952: DBMS_SQL.CLOSE_CURSOR(cursor_name);

948: inv_trx_util_pub.TRACE(' Exception: ' || SQLERRM );
949: END IF;
950:
951: IF DBMS_SQL.IS_OPEN(cursor_name) THEN
952: DBMS_SQL.CLOSE_CURSOR(cursor_name);
953: END IF;
954:
955: RAISE fnd_api.g_exc_error;
956: END;