APPS.GR_MIGRATE_TO_12 dependencies on GR_ITEM_CONCENTRATIONS

Line 1293: FROM gr_item_concentrations b

1289: CURSOR c_get_items IS
1290: SELECT a.item_code
1291: FROM gr_item_general a
1292: WHERE EXISTS (SELECT 1
1293: FROM gr_item_concentrations b
1294: WHERE b.item_code = a.item_code) and
1295: a.formula_source_indicator = 'S';
1296:
1297: /* Cursor used to retrieve profile value at site level */

Line 1314: FROM gr_item_concentrations

1310:
1311: /* Cursor used to retrieve concentration records for item */
1312: CURSOR c_get_item_concentrations IS
1313: SELECT *
1314: FROM gr_item_concentrations
1315: WHERE migration_ind is NULL and
1316: item_code = l_item_code;
1317: l_conc_rec c_get_item_concentrations%ROWTYPE;
1318:

Line 1377: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1373: GMA_COMMON_LOGGING.gma_migration_central_log (
1374: p_run_id => P_migration_run_id,
1375: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1376: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1377: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1378: p_context => 'STANDALONE_FORMULAS',
1379: p_param1 => NULL,
1380: p_param2 => NULL,
1381: p_param3 => NULL,

Line 1844: UPDATE gr_item_concentrations

1840: l_prod_item_id
1841: );
1842:
1843:
1844: UPDATE gr_item_concentrations
1845: SET migration_ind = 1
1846: WHERE item_code = l_item_code;
1847:
1848: /* Issue commit if required */

Line 1863: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1859: GMA_COMMON_LOGGING.gma_migration_central_log (
1860: p_run_id => P_migration_run_id,
1861: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1862: p_message_token => l_msg_data,
1863: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1864: p_context => 'STANDALONE_FORMULAS',
1865: p_param1 => NULL,
1866: p_param2 => NULL,
1867: p_param3 => NULL,

Line 1882: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1878: GMA_COMMON_LOGGING.gma_migration_central_log (
1879: p_run_id => P_migration_run_id,
1880: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1881: p_message_token => l_msg_data,
1882: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1883: p_context => 'STANDALONE_FORMULAS',
1884: p_param1 => NULL,
1885: p_param2 => NULL,
1886: p_param3 => NULL,

Line 1921: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1917: GMA_COMMON_LOGGING.gma_migration_central_log (
1918: p_run_id => P_migration_run_id,
1919: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1920: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1921: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1922: p_context => 'STANDALONE_FORMULAS',
1923: p_param1 => l_migration_count,
1924: p_param2 => x_failure_count,
1925: p_param3 => NULL,

Line 1939: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1935: GMA_COMMON_LOGGING.gma_migration_central_log (
1936: p_run_id => P_migration_run_id,
1937: p_log_level => FND_LOG.LEVEL_ERROR,
1938: p_message_token => 'GMA_ORG_NOT_MIGRATED',
1939: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1940: p_context => 'STANDALONE_FORMULAS',
1941: p_token1 => 'ORGANIZATION',
1942: p_param1 => l_owner_org,
1943: p_app_short_name => 'GR');

Line 1952: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1948: GMA_COMMON_LOGGING.gma_migration_central_log (
1949: p_run_id => P_migration_run_id,
1950: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1951: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1952: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1953: p_context => 'STANDALONE_FORMULAS',
1954: p_param1 => NULL,
1955: p_param2 => NULL,
1956: p_param3 => NULL,

Line 1966: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1962: GMA_COMMON_LOGGING.gma_migration_central_log (
1963: p_run_id => P_migration_run_id,
1964: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1965: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1966: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1967: p_context => 'STANDALONE_FORMULAS',
1968: p_param1 => x_failure_count,
1969: p_param2 => NULL,
1970: p_param3 => NULL,