APPS.GR_MIGRATE_TO_12 dependencies on GR_ITEM_CONCENTRATIONS

Line 1269: FROM gr_item_concentrations b

1265: CURSOR c_get_items IS
1266: SELECT a.item_code
1267: FROM gr_item_general a
1268: WHERE EXISTS (SELECT 1
1269: FROM gr_item_concentrations b
1270: WHERE b.item_code = a.item_code) and
1271: a.formula_source_indicator = 'S';
1272:
1273: /* Cursor used to retrieve profile value at site level */

Line 1290: FROM gr_item_concentrations

1286:
1287: /* Cursor used to retrieve concentration records for item */
1288: CURSOR c_get_item_concentrations IS
1289: SELECT *
1290: FROM gr_item_concentrations
1291: WHERE migration_ind is NULL and
1292: item_code = l_item_code;
1293: l_conc_rec c_get_item_concentrations%ROWTYPE;
1294:

Line 1353: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1349: GMA_COMMON_LOGGING.gma_migration_central_log (
1350: p_run_id => P_migration_run_id,
1351: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1352: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
1353: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1354: p_context => 'STANDALONE_FORMULAS',
1355: p_param1 => NULL,
1356: p_param2 => NULL,
1357: p_param3 => NULL,

Line 1820: UPDATE gr_item_concentrations

1816: l_prod_item_id
1817: );
1818:
1819:
1820: UPDATE gr_item_concentrations
1821: SET migration_ind = 1
1822: WHERE item_code = l_item_code;
1823:
1824: /* Issue commit if required */

Line 1839: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1835: GMA_COMMON_LOGGING.gma_migration_central_log (
1836: p_run_id => P_migration_run_id,
1837: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1838: p_message_token => l_msg_data,
1839: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1840: p_context => 'STANDALONE_FORMULAS',
1841: p_param1 => NULL,
1842: p_param2 => NULL,
1843: p_param3 => NULL,

Line 1858: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1854: GMA_COMMON_LOGGING.gma_migration_central_log (
1855: p_run_id => P_migration_run_id,
1856: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1857: p_message_token => l_msg_data,
1858: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1859: p_context => 'STANDALONE_FORMULAS',
1860: p_param1 => NULL,
1861: p_param2 => NULL,
1862: p_param3 => NULL,

Line 1897: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1893: GMA_COMMON_LOGGING.gma_migration_central_log (
1894: p_run_id => P_migration_run_id,
1895: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1896: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1897: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1898: p_context => 'STANDALONE_FORMULAS',
1899: p_param1 => l_migration_count,
1900: p_param2 => x_failure_count,
1901: p_param3 => NULL,

Line 1915: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1911: GMA_COMMON_LOGGING.gma_migration_central_log (
1912: p_run_id => P_migration_run_id,
1913: p_log_level => FND_LOG.LEVEL_ERROR,
1914: p_message_token => 'GMA_ORG_NOT_MIGRATED',
1915: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1916: p_context => 'STANDALONE_FORMULAS',
1917: p_token1 => 'ORGANIZATION',
1918: p_param1 => l_owner_org,
1919: p_app_short_name => 'GR');

Line 1928: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1924: GMA_COMMON_LOGGING.gma_migration_central_log (
1925: p_run_id => P_migration_run_id,
1926: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1927: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1928: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1929: p_context => 'STANDALONE_FORMULAS',
1930: p_param1 => NULL,
1931: p_param2 => NULL,
1932: p_param3 => NULL,

Line 1942: p_table_name => 'GR_ITEM_CONCENTRATIONS',

1938: GMA_COMMON_LOGGING.gma_migration_central_log (
1939: p_run_id => P_migration_run_id,
1940: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1941: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1942: p_table_name => 'GR_ITEM_CONCENTRATIONS',
1943: p_context => 'STANDALONE_FORMULAS',
1944: p_param1 => x_failure_count,
1945: p_param2 => NULL,
1946: p_param3 => NULL,