APPS.GML_OPM_OM_CONV_MIG_PKG dependencies on IC_TRAN_PND

Line 141: FROM ic_tran_pnd

137: AND wdd.released_status in ('B','R','S', 'X'); -- 5475003 need to include status X for non inv items
138:
139: CURSOR get_allocations_for_line(p_line_id IN NUMBER) IS
140: SELECT *
141: FROM ic_tran_pnd
142: WHERE doc_type = 'OMSO'
143: AND line_id = p_line_id
144: AND delete_mark = 0
145: AND staged_ind = 0

Line 244: l_opm_table_name := 'IC_TRAN_PND';

240:
241:
242: /* Get all the open lines to be processed */
243: l_table_name := 'MTL_RESERVATIONS';
244: l_opm_table_name := 'IC_TRAN_PND';
245: GMI_RESERVATION_UTIL.println('START OF GML_OPM_OM_CONV_MIG_PKG.Migrate_opm_om_open_lines - run_id = ' || p_migration_run_id);
246: GMI_RESERVATION_UTIL.Println('IC DEFAULT_LOCT is ' || l_IC$DEFAULT_LOCT);
247:
248: FOR open_order_line_rec IN get_open_order_lines LOOP

Line 626: p_table_name => 'IC_TRAN_PND',

622: GMA_COMMON_LOGGING.gma_migration_central_log (
623: p_run_id => p_migration_run_id,
624: p_log_level => FND_LOG.LEVEL_ERROR,
625: p_message_token => 'GMI_UNEXPECTED_ERROR',
626: p_table_name => 'IC_TRAN_PND',
627: p_context => 'CREATE RESERVATION',
628: p_token1 => 'ERROR',
629: p_param1 => fnd_msg_pub.get_detail(i, NULL),
630: p_param2 => NULL,

Line 643: p_table_name => 'IC_TRAN_PND',

639: GMA_COMMON_LOGGING.gma_migration_central_log (
640: p_run_id => p_migration_run_id,
641: p_log_level => FND_LOG.LEVEL_ERROR,
642: p_message_token => 'GMI_UNEXPECTED_ERROR',
643: p_table_name => 'IC_TRAN_PND',
644: p_context => 'CREATE RESERVATION',
645: p_param1 => INV_GMI_Migration.item(allocations_for_line_rec.item_id),
646: p_param2 => INV_GMI_Migration.lot(allocations_for_line_rec.lot_id),
647: p_param3 => allocations_for_line_rec.whse_code,

Line 684: , p_table_name => 'IC_TRAN_PND'

680: , p_log_level => FND_LOG.LEVEL_UNEXPECTED
681: , p_app_short_name =>'GML'
682: , p_message_token => 'GML_MIGRATION_DB_ERROR'
683: , p_db_error => sqlerrm
684: , p_table_name => 'IC_TRAN_PND'
685: , p_context => 'TRANSACTIONS');
686:
687: END; /* Begin for allocations loop */
688: