APPS.INV_MIGRATE_PROCESS_ORG dependencies on IC_LOCT_MST

Line 160: UPDATE IC_LOCT_MST

156: IF (Cur_check_subinventory%ISOPEN) THEN
157: CLOSE Cur_check_subinventory;
158: END IF;
159:
160: UPDATE IC_LOCT_MST
161: SET locator_id = inventory_location_id
162: WHERE whse_code = P_whse_code;
163:
164: -- Bug 5727749 T.Cataldo 5-April-2007 Remove calls to the central

Line 567: p_table_name => 'IC_LOCT_MST',

563: GMA_COMMON_LOGGING.gma_migration_central_log (
564: p_run_id => l_migration_id,
565: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
566: p_message_token => 'GMA_MIGRATION_DB_ERROR',
567: p_table_name => 'IC_LOCT_MST',
568: p_context => 'LOCATION',
569: p_db_error => SQLERRM,
570: p_app_short_name => 'GMA');
571:

Line 576: p_table_name => 'IC_LOCT_MST',

572: GMA_COMMON_LOGGING.gma_migration_central_log (
573: p_run_id => l_migration_id,
574: p_log_level => FND_LOG.LEVEL_PROCEDURE,
575: p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
576: p_table_name => 'IC_LOCT_MST',
577: p_context => 'LOCATION',
578: p_app_short_name => 'GMA');
579:
580: END create_location;

Line 624: FROM mtl_item_locations il, ic_loct_mst l

620: /* Bug 5529682 - Removed reference to mtl_item_locations_kfv */
621: /* duplicate checking is now being done using segment1 */
622: CURSOR Cur_get_location (V_location VARCHAR2) IS
623: SELECT il.*, l.delete_mark
624: FROM mtl_item_locations il, ic_loct_mst l
625: WHERE l.location <> V_location
626: AND l.whse_code = P_subinventory_code
627: AND l.inventory_location_id = il.inventory_location_id;
628:

Line 651: -- p_table_name => 'IC_LOCT_MST',

647: -- GMA_COMMON_LOGGING.gma_migration_central_log (
648: -- p_run_id => l_migration_id,
649: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
650: -- p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
651: -- p_table_name => 'IC_LOCT_MST',
652: -- p_context => 'LOCATION',
653: -- p_app_short_name => 'GMA');
654:
655: l_location := FND_PROFILE.VALUE('IC$DEFAULT_LOCT');

Line 699: UPDATE ic_loct_mst

695: X_failure_count => l_failure_count);
696: IF (l_failure_count > 0) THEN
697: RAISE LOCATION_FAILED;
698: ELSE
699: UPDATE ic_loct_mst
700: SET locator_id = l_location_id
701: WHERE location = l_rec.segment1
702: AND whse_code = p_subinventory_code;
703: END IF;

Line 712: -- p_table_name => 'IC_LOCT_MST',

708: -- GMA_COMMON_LOGGING.gma_migration_central_log (
709: -- p_run_id => l_migration_id,
710: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
711: -- p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
712: -- p_table_name => 'IC_LOCT_MST',
713: -- p_context => 'LOCATION',
714: -- p_app_short_name => 'GMA');
715:
716: EXCEPTION

Line 726: p_table_name => 'IC_LOCT_MST',

722: GMA_COMMON_LOGGING.gma_migration_central_log (
723: p_run_id => l_migration_id,
724: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
725: p_message_token => 'GMA_MIGRATION_DB_ERROR',
726: p_table_name => 'IC_LOCT_MST',
727: p_context => 'LOCATION',
728: p_db_error => SQLERRM,
729: p_app_short_name => 'GMA');
730:

Line 737: -- p_table_name => 'IC_LOCT_MST',

733: -- GMA_COMMON_LOGGING.gma_migration_central_log (
734: -- p_run_id => l_migration_id,
735: -- p_log_level => FND_LOG.LEVEL_PROCEDURE,
736: -- p_message_token => 'GMA_MIGRATION_TABLE_FAIL',
737: -- p_table_name => 'IC_LOCT_MST',
738: -- p_context => 'LOCATION',
739: -- p_app_short_name => 'GMA');
740:
741: END migrate_location;

Line 882: UPDATE ic_loct_mst

878: p_token1 => 'WAREHOUSE',
879: p_param1 => l_rec.whse_code,
880: p_app_short_name => 'GMA');
881:
882: UPDATE ic_loct_mst
883: SET locator_id = inventory_location_id
884: WHERE whse_code = l_rec.whse_code;
885: ELSE
886: --Now insert the warehouse into mtl_secondary_inventories table