eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_GMI_MIGRATION dependencies on IC_INVN_TYP

Line 256: CURSOR c_ic_invn_typ IS

252: ( p_migration_run_id IN NUMBER
253: , p_commit IN VARCHAR2
254: , x_failure_count OUT NOCOPY NUMBER) IS
255:
256: CURSOR c_ic_invn_typ IS
257: SELECT *
258: FROM ic_invn_typ
259: WHERE migrated_ind is NULL;
260:

Line 258: FROM ic_invn_typ

254: , x_failure_count OUT NOCOPY NUMBER) IS
255:
256: CURSOR c_ic_invn_typ IS
257: SELECT *
258: FROM ic_invn_typ
259: WHERE migrated_ind is NULL;
260:
261: l_status_id NUMBER;
262: l_count PLS_INTEGER;

Line 277: p_table_name => 'IC_INVN_TYP',

273: GMA_COMMON_LOGGING.gma_migration_central_log (
274: p_run_id => p_migration_run_id,
275: p_log_level => FND_LOG.LEVEL_PROCEDURE,
276: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
277: p_table_name => 'IC_INVN_TYP',
278: p_context => 'INVENTORY TYPES',
279: p_param1 => NULL,
280: p_param2 => NULL,
281: p_param3 => NULL,

Line 287: FOR l_inv_type IN c_ic_invn_typ LOOP

283: p_param5 => NULL,
284: p_db_error => NULL,
285: p_app_short_name => 'GMA');
286:
287: FOR l_inv_type IN c_ic_invn_typ LOOP
288: BEGIN
289: -- Check if the inventory type already exists in the discrete
290: SELECT count(*)
291: INTO l_count

Line 306: p_table_name => 'IC_INVN_TYP',

302: GMA_COMMON_LOGGING.gma_migration_central_log (
303: p_run_id => p_migration_run_id,
304: p_log_level => FND_LOG.LEVEL_PROCEDURE,
305: p_message_token => 'GMI_MIG_TYPE_EXISTS',
306: p_table_name => 'IC_INVN_TYP',
307: p_context => 'INVENTORY TYPES',
308: p_param1 => l_inv_type.inv_type,
309: p_param2 => NULL,
310: p_param3 => NULL,

Line 359: UPDATE ic_invn_typ

355: X_LAST_UPDATED_BY=> l_inv_type.last_updated_by,
356: X_LAST_UPDATE_LOGIN=> NULL
357: );
358:
359: UPDATE ic_invn_typ
360: SET
361: migrated_ind = 1
362: WHERE
363: inv_type = l_inv_type.inv_type;

Line 380: p_table_name => 'IC_INVN_TYP',

376: GMA_COMMON_LOGGING.gma_migration_central_log (
377: p_run_id => p_migration_run_id,
378: p_log_level => FND_LOG.LEVEL_PROCEDURE,
379: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
380: p_table_name => 'IC_INVN_TYP',
381: p_context => 'INVENTORY TYPES',
382: p_param1 => l_migrate_count,
383: p_param2 => x_failure_count,
384: p_param3 => NULL,

Line 397: p_table_name => 'IC_INVN_TYP',

393: GMA_COMMON_LOGGING.gma_migration_central_log (
394: p_run_id => p_migration_run_id,
395: p_log_level => FND_LOG.LEVEL_ERROR,
396: p_message_token => 'GMA_MIGRATION_DB_ERROR',
397: p_table_name => 'IC_INVN_TYP',
398: p_context => 'INVENTORY TYPES',
399: p_param1 => NULL,
400: p_param2 => NULL,
401: p_param3 => NULL,