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 295: CURSOR c_ic_invn_typ IS

291: ( p_migration_run_id IN NUMBER
292: , p_commit IN VARCHAR2
293: , x_failure_count OUT NOCOPY NUMBER) IS
294:
295: CURSOR c_ic_invn_typ IS
296: SELECT *
297: FROM ic_invn_typ
298: WHERE migrated_ind is NULL;
299:

Line 297: FROM ic_invn_typ

293: , x_failure_count OUT NOCOPY NUMBER) IS
294:
295: CURSOR c_ic_invn_typ IS
296: SELECT *
297: FROM ic_invn_typ
298: WHERE migrated_ind is NULL;
299:
300: l_status_id NUMBER;
301: l_count PLS_INTEGER;

Line 316: p_table_name => 'IC_INVN_TYP',

312: GMA_COMMON_LOGGING.gma_migration_central_log (
313: p_run_id => p_migration_run_id,
314: p_log_level => FND_LOG.LEVEL_PROCEDURE,
315: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
316: p_table_name => 'IC_INVN_TYP',
317: p_context => 'INVENTORY TYPES',
318: p_param1 => NULL,
319: p_param2 => NULL,
320: p_param3 => NULL,

Line 326: FOR l_inv_type IN c_ic_invn_typ LOOP

322: p_param5 => NULL,
323: p_db_error => NULL,
324: p_app_short_name => 'GMA');
325:
326: FOR l_inv_type IN c_ic_invn_typ LOOP
327: BEGIN
328: -- Check if the inventory type already exists in the discrete
329: SELECT count(*)
330: INTO l_count

Line 345: p_table_name => 'IC_INVN_TYP',

341: GMA_COMMON_LOGGING.gma_migration_central_log (
342: p_run_id => p_migration_run_id,
343: p_log_level => FND_LOG.LEVEL_PROCEDURE,
344: p_message_token => 'GMI_MIG_TYPE_EXISTS',
345: p_table_name => 'IC_INVN_TYP',
346: p_context => 'INVENTORY TYPES',
347: p_param1 => l_inv_type.inv_type,
348: p_param2 => NULL,
349: p_param3 => NULL,

Line 398: UPDATE ic_invn_typ

394: X_LAST_UPDATED_BY=> l_inv_type.last_updated_by,
395: X_LAST_UPDATE_LOGIN=> NULL
396: );
397:
398: UPDATE ic_invn_typ
399: SET
400: migrated_ind = 1
401: WHERE
402: inv_type = l_inv_type.inv_type;

Line 419: p_table_name => 'IC_INVN_TYP',

415: GMA_COMMON_LOGGING.gma_migration_central_log (
416: p_run_id => p_migration_run_id,
417: p_log_level => FND_LOG.LEVEL_PROCEDURE,
418: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
419: p_table_name => 'IC_INVN_TYP',
420: p_context => 'INVENTORY TYPES',
421: p_param1 => l_migrate_count,
422: p_param2 => x_failure_count,
423: p_param3 => NULL,

Line 436: p_table_name => 'IC_INVN_TYP',

432: GMA_COMMON_LOGGING.gma_migration_central_log (
433: p_run_id => p_migration_run_id,
434: p_log_level => FND_LOG.LEVEL_ERROR,
435: p_message_token => 'GMA_MIGRATION_DB_ERROR',
436: p_table_name => 'IC_INVN_TYP',
437: p_context => 'INVENTORY TYPES',
438: p_param1 => NULL,
439: p_param2 => NULL,
440: p_param3 => NULL,