APPS.GR_MIGRATE_TO_12 dependencies on GR_ITEM_GENERAL_MIG

Line 46: FROM gr_item_general_mig

42: /* ------------------ CURSORS ---------------------- */
43: /* Cursor used retrieve the inventory_item_ id */
44: CURSOR c_get_inventory_item_id IS
45: SELECT inventory_item_id
46: FROM gr_item_general_mig
47: WHERE item_code = p_item_code
48: AND organization_id = p_organization_id;
49:
50: /* ----------------- EXCEPTIONS -------------------- */

Line 290: -- This PL/SQL procedure is used to insert records into the gr_item_general_mig table.

286: -- PROCEDURE:
287: -- create_item_mig_records
288: --
289: -- DESCRIPTION:
290: -- This PL/SQL procedure is used to insert records into the gr_item_general_mig table.
291: -- This table will be used to drive the migration of Regulatory items to the specified
292: -- organizations.
293: --
294: -- PARAMETERS:

Line 357: p_table_name => 'GR_ITEM_GENERAL_MIG',

353: GMA_COMMON_LOGGING.gma_migration_central_log (
354: p_run_id => P_migration_run_id,
355: p_log_level => FND_LOG.LEVEL_PROCEDURE,
356: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
357: p_table_name => 'GR_ITEM_GENERAL_MIG',
358: p_context => 'GR_ITEM_MIGRATION_TABLE',
359: p_param1 => NULL,
360: p_param2 => NULL,
361: p_param3 => NULL,

Line 376: INSERT INTO gr_item_general_mig

372: WHILE c_get_master_orgs%FOUND LOOP
373:
374: l_reg_orgs_found := 1;
375:
376: INSERT INTO gr_item_general_mig
377: (
378: item_code,
379: organization_id,
380: inventory_item_id,

Line 389: WHERE NOT EXISTS (SELECT 1 from gr_item_general_mig b

385: l_organization_id,
386: NULL,
387: NULL
388: FROM gr_item_general a
389: WHERE NOT EXISTS (SELECT 1 from gr_item_general_mig b
390: WHERE b.item_code = a.item_code and
391: b.organization_id = l_organization_id);
392:
393: /* Issue commit if required */

Line 414: INSERT INTO gr_item_general_mig

410: WHILE c_get_child_orgs%FOUND LOOP
411:
412: l_reg_orgs_found := 1;
413:
414: INSERT INTO gr_item_general_mig
415: (
416: item_code,
417: organization_id,
418: inventory_item_id,

Line 427: WHERE NOT EXISTS (SELECT 1 from gr_item_general_mig b

423: l_organization_id,
424: NULL,
425: NULL
426: FROM gr_item_general a
427: WHERE NOT EXISTS (SELECT 1 from gr_item_general_mig b
428: WHERE b.item_code = a.item_code and
429: b.organization_id = l_organization_id);
430:
431: /* Issue commit if required */

Line 454: p_table_name => 'GR_ITEM_GENERAL_MIG',

450: GMA_COMMON_LOGGING.gma_migration_central_log (
451: p_run_id => P_migration_run_id,
452: p_log_level => FND_LOG.LEVEL_PROCEDURE,
453: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
454: p_table_name => 'GR_ITEM_GENERAL_MIG',
455: p_context => 'GR_ITEM_MIGRATION_TABLE',
456: p_param1 => l_migration_count,
457: p_param2 => x_failure_count,
458: p_param3 => NULL,

Line 473: p_table_name => 'GR_ITEM_GENERAL_MIG',

469: GMA_COMMON_LOGGING.gma_migration_central_log (
470: p_run_id => P_migration_run_id,
471: p_log_level => FND_LOG.LEVEL_ERROR,
472: p_message_token => 'GR_NO_REG_ORG',
473: p_table_name => 'GR_ITEM_GENERAL_MIG',
474: p_context => 'GR_ITEM_MIGRATION_TABLE',
475: p_app_short_name => 'GMA');
476:
477: WHEN OTHERS THEN

Line 485: p_table_name => 'GR_ITEM_GENERAL_MIG',

481: GMA_COMMON_LOGGING.gma_migration_central_log (
482: p_run_id => P_migration_run_id,
483: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
484: p_message_token => 'GMA_MIGRATION_DB_ERROR',
485: p_table_name => 'GR_ITEM_GENERAL_MIG',
486: p_context => 'GR_ITEM_MIGRATION_TABLE',
487: p_param1 => NULL,
488: p_param2 => NULL,
489: p_param3 => NULL,

Line 499: p_table_name => 'GR_ITEM_GENERAL_MIG',

495: GMA_COMMON_LOGGING.gma_migration_central_log (
496: p_run_id => P_migration_run_id,
497: p_log_level => FND_LOG.LEVEL_PROCEDURE,
498: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
499: p_table_name => 'GR_ITEM_GENERAL_MIG',
500: p_context => 'GR_ITEM_MIGRATION_TABLE',
501: p_param1 => x_failure_count,
502: p_param2 => NULL,
503: p_param3 => NULL,

Line 567: FROM gr_item_general_mig

563: /* ------------------ CURSORS ---------------------- */
564: /* Cursor used to retrieve record from migration table */
565: CURSOR c_get_mig_rec IS
566: SELECT item_code, organization_id
567: FROM gr_item_general_mig
568: WHERE migration_ind is NULL;
569: l_mig_rec c_get_mig_rec%ROWTYPE;
570:
571: /* Cursor used to retrieve document category ids */

Line 1037: UPDATE gr_item_general_mig

1033: FETCH c_get_related INTO l_related_rec;
1034: END LOOP; -- Related Items
1035: CLOSE c_get_related;
1036:
1037: UPDATE gr_item_general_mig
1038: SET migration_ind = 1,
1039: inventory_item_id = l_inventory_item_id
1040: WHERE item_code = l_mig_rec.item_code and
1041: organization_id = l_mig_rec. organization_id;