APPS.INV_GMI_MIGRATION dependencies on IC_LOTS_STS

Line 780: CURSOR c_ic_lots_sts IS

776: l_migrate_count PLS_INTEGER;
777:
778: l_rowid ROWID;
779:
780: CURSOR c_ic_lots_sts IS
781: SELECT *
782: FROM ic_lots_sts
783: WHERE status_id is NULL ;
784:

Line 782: FROM ic_lots_sts

778: l_rowid ROWID;
779:
780: CURSOR c_ic_lots_sts IS
781: SELECT *
782: FROM ic_lots_sts
783: WHERE status_id is NULL ;
784:
785: CURSOR c_trans_type IS
786: SELECT transaction_type_id, transaction_type_name, transaction_source_type_id

Line 800: p_table_name => 'IC_LOTS_STS',

796: GMA_COMMON_LOGGING.gma_migration_central_log (
797: p_run_id => p_migration_run_id,
798: p_log_level => FND_LOG.LEVEL_PROCEDURE,
799: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
800: p_table_name => 'IC_LOTS_STS',
801: p_context => 'LOT STATUS',
802: p_param1 => NULL,
803: p_param2 => NULL,
804: p_param3 => NULL,

Line 809: FOR l_lot_status IN c_ic_lots_sts LOOP

805: p_param4 => NULL,
806: p_param5 => NULL,
807: p_db_error => NULL,
808: p_app_short_name => 'GMA');
809: FOR l_lot_status IN c_ic_lots_sts LOOP
810: BEGIN
811: -- Check if the material status already exists in the discrete
812: SELECT count(*)
813: INTO l_count

Line 826: p_table_name => 'IC_LOTS_STS',

822: GMA_COMMON_LOGGING.gma_migration_central_log (
823: p_run_id => p_migration_run_id,
824: p_log_level => FND_LOG.LEVEL_ERROR,
825: p_message_token => 'GMI_MIG_STATUS_EXISTS',
826: p_table_name => 'IC_LOTS_STS',
827: p_context => 'LOT STATUS',
828: p_param1 => l_lot_status.lot_status,
829: p_param2 => NULL,
830: p_param3 => NULL,

Line 942: UPDATE ic_lots_sts

938: l_lot_status.last_updated_by,
939: l_lot_status.last_update_date);
940:
941: END LOOP;
942: UPDATE ic_lots_sts
943: SET
944: status_id = l_status_id,
945: migrated_ind = 1
946: WHERE

Line 964: p_table_name => 'IC_LOTS_STS',

960: GMA_COMMON_LOGGING.gma_migration_central_log (
961: p_run_id => p_migration_run_id,
962: p_log_level => FND_LOG.LEVEL_PROCEDURE,
963: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
964: p_table_name => 'IC_LOTS_STS',
965: p_context => 'LOT STATUS',
966: p_param1 => l_migrate_count,
967: p_param2 => x_failure_count,
968: p_param3 => NULL,

Line 982: p_table_name => 'IC_LOTS_STS',

978: GMA_COMMON_LOGGING.gma_migration_central_log (
979: p_run_id => p_migration_run_id,
980: p_log_level => FND_LOG.LEVEL_ERROR,
981: p_message_token => 'GMA_MIGRATION_DB_ERROR',
982: p_table_name => 'IC_LOTS_STS',
983: p_context => 'LOT STATUS',
984: p_param1 => NULL,
985: p_param2 => NULL,
986: p_param3 => NULL,