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 248: l_opm_table_name := 'IC_TRAN_PND';

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

Line 630: p_table_name => 'IC_TRAN_PND',

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

Line 647: p_table_name => 'IC_TRAN_PND',

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

Line 688: , p_table_name => 'IC_TRAN_PND'

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