APPS.INV_GMI_MIGRATION dependencies on IC_LOTS_STS

Line 838: CURSOR c_ic_lots_sts IS

834: l_migrate_count PLS_INTEGER;
835:
836: l_rowid ROWID;
837:
838: CURSOR c_ic_lots_sts IS
839: SELECT *
840: FROM ic_lots_sts
841: WHERE status_id is NULL ;
842:

Line 840: FROM ic_lots_sts

836: l_rowid ROWID;
837:
838: CURSOR c_ic_lots_sts IS
839: SELECT *
840: FROM ic_lots_sts
841: WHERE status_id is NULL ;
842:
843: CURSOR c_trans_type IS
844: SELECT transaction_type_id, transaction_type_name, transaction_source_type_id

Line 858: p_table_name => 'IC_LOTS_STS',

854: GMA_COMMON_LOGGING.gma_migration_central_log (
855: p_run_id => p_migration_run_id,
856: p_log_level => FND_LOG.LEVEL_PROCEDURE,
857: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
858: p_table_name => 'IC_LOTS_STS',
859: p_context => 'LOT STATUS',
860: p_param1 => NULL,
861: p_param2 => NULL,
862: p_param3 => NULL,

Line 867: FOR l_lot_status IN c_ic_lots_sts LOOP

863: p_param4 => NULL,
864: p_param5 => NULL,
865: p_db_error => NULL,
866: p_app_short_name => 'GMA');
867: FOR l_lot_status IN c_ic_lots_sts LOOP
868: BEGIN
869: -- Check if the material status already exists in the discrete
870: SELECT count(*)
871: INTO l_count

Line 889: UPDATE ic_lots_sts

885: /* End for fix for Bug#9143261 */
886:
887: /* Start for fix for Bug#10413599 */
888:
889: UPDATE ic_lots_sts
890: SET status_id = (SELECT status_id
891: FROM mtl_material_statuses_tl
892: WHERE status_code = l_lot_status.lot_status
893: AND rownum = 1),

Line 912: p_table_name => 'IC_LOTS_STS',

908: GMA_COMMON_LOGGING.gma_migration_central_log (
909: p_run_id => p_migration_run_id,
910: p_log_level => FND_LOG.LEVEL_ERROR,
911: p_message_token => 'GMI_MIG_STATUS_EXISTS',
912: p_table_name => 'IC_LOTS_STS',
913: p_context => 'LOT STATUS',
914: p_param1 => l_lot_status.lot_status,
915: p_param2 => NULL,
916: p_param3 => NULL,

Line 1034: UPDATE ic_lots_sts

1030: l_lot_status.last_updated_by,
1031: l_lot_status.last_update_date);
1032:
1033: END LOOP;
1034: UPDATE ic_lots_sts
1035: SET
1036: status_id = l_status_id,
1037: migrated_ind = 1
1038: WHERE

Line 1056: p_table_name => 'IC_LOTS_STS',

1052: GMA_COMMON_LOGGING.gma_migration_central_log (
1053: p_run_id => p_migration_run_id,
1054: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1055: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1056: p_table_name => 'IC_LOTS_STS',
1057: p_context => 'LOT STATUS',
1058: p_param1 => l_migrate_count,
1059: p_param2 => x_failure_count,
1060: p_param3 => NULL,

Line 1074: p_table_name => 'IC_LOTS_STS',

1070: GMA_COMMON_LOGGING.gma_migration_central_log (
1071: p_run_id => p_migration_run_id,
1072: p_log_level => FND_LOG.LEVEL_ERROR,
1073: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1074: p_table_name => 'IC_LOTS_STS',
1075: p_context => 'LOT STATUS',
1076: p_param1 => NULL,
1077: p_param2 => NULL,
1078: p_param3 => NULL,