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.GR_MIGRATE_TO_12 dependencies on GR_ITEM_GENERAL

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 345: FROM gr_item_general;

341:
342: /* Cursor used check if there is Regulatory data if no orgs are set as Regualtory orgs */
343: CURSOR c_check_reg_data IS
344: SELECT 1
345: FROM gr_item_general;
346:
347: /* ----------------- EXCEPTIONS -------------------- */
348: NO_REG_ORG EXCEPTION;
349:

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 388: FROM gr_item_general a

384: a.item_code,
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:

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 426: FROM gr_item_general a

422: a.item_code,
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:

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 587: FROM gr_item_general

583:
584: /* Cursor used to retrieve regulatory item record */
585: CURSOR c_get_reg_item IS
586: SELECT *
587: FROM gr_item_general
588: WHERE item_code = l_mig_rec.item_code;
589: l_reg_item_rec c_get_reg_item%ROWTYPE;
590:
591: /* Cursor used to retrieve the Regulatory item description*/

Line 621: WHERE entity_name = 'GR_ITEM_GENERAL' and

617: /* Cursor used to retrieve document attached to Regulatory item */
618: CURSOR c_get_attachments IS
619: SELECT *
620: FROM fnd_attached_documents
621: WHERE entity_name = 'GR_ITEM_GENERAL' and
622: pk1_value = l_mig_rec.item_code;
623: l_attachment_rec c_get_attachments%ROWTYPE;
624:
625:

Line 640: p_table_name => 'GR_ITEM_GENERAL',

636: GMA_COMMON_LOGGING.gma_migration_central_log (
637: p_run_id => P_migration_run_id,
638: p_log_level => FND_LOG.LEVEL_PROCEDURE,
639: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
640: p_table_name => 'GR_ITEM_GENERAL',
641: p_context => 'REGULATORY_ITEMS',
642: p_param1 => NULL,
643: p_param2 => NULL,
644: p_param3 => NULL,

Line 661: p_table_name => 'GR_ITEM_GENERAL',

657: GMA_COMMON_LOGGING.gma_migration_central_log (
658: p_run_id => P_migration_run_id,
659: p_log_level => FND_LOG.LEVEL_PROCEDURE,
660: p_message_token => 'GR_NO_REGITEMS_TO_MIG',
661: p_table_name => 'GR_ITEM_GENERAL',
662: p_context => 'REGULATORY_ITEMS',
663: p_param1 => NULL,
664: p_param2 => NULL,
665: p_param3 => NULL,

Line 739: p_table_name => 'GR_ITEM_GENERAL',

735: GMA_COMMON_LOGGING.gma_migration_central_log (
736: p_run_id => P_migration_run_id,
737: p_log_level => FND_LOG.LEVEL_PROCEDURE,
738: p_message_token => 'GMA_MIGRATION_TABLE_STARTED',
739: p_table_name => 'GR_ITEM_GENERAL',
740: p_context => 'REGULATORY_ITEMS',
741: p_param1 => NULL,
742: p_param2 => NULL,
743: p_param3 => NULL,

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;

Line 1062: p_table_name => 'GR_ITEM_GENERAL',

1058: GMA_COMMON_LOGGING.gma_migration_central_log (
1059: p_run_id => P_migration_run_id,
1060: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1061: p_message_token => 'GR_INVALID_REG_ITEM',
1062: p_table_name => 'GR_ITEM_GENERAL',
1063: p_context => 'REGULATORY_ITEMS',
1064: p_param1 => l_mig_rec.item_code,
1065: p_param2 => NULL,
1066: p_param3 => NULL,

Line 1080: p_table_name => 'GR_ITEM_GENERAL',

1076: GMA_COMMON_LOGGING.gma_migration_central_log (
1077: p_run_id => P_migration_run_id,
1078: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1079: p_message_token => 'GR_NO_CAS_NUMBER',
1080: p_table_name => 'GR_ITEM_GENERAL',
1081: p_context => 'REGULATORY_ITEMS',
1082: p_param1 => l_mig_rec.item_code,
1083: p_param2 => NULL,
1084: p_param3 => NULL,

Line 1099: p_table_name => 'GR_ITEM_GENERAL',

1095: GMA_COMMON_LOGGING.gma_migration_central_log (
1096: p_run_id => P_migration_run_id,
1097: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1098: p_message_token => 'GR_INV_ITEM_ERROR',
1099: p_table_name => 'GR_ITEM_GENERAL',
1100: p_context => 'REGULATORY_ITEMS',
1101: p_param1 => l_mig_rec.item_code,
1102: p_param2 => NULL,
1103: p_param3 => NULL,

Line 1117: p_table_name => 'GR_ITEM_GENERAL',

1113: GMA_COMMON_LOGGING.gma_migration_central_log (
1114: p_run_id => P_migration_run_id,
1115: p_log_level => FND_LOG.LEVEL_EXCEPTION,
1116: p_message_token => l_msg_data,
1117: p_table_name => 'GR_ITEM_GENERAL',
1118: p_context => 'REGULATORY_ITEMS',
1119: p_param1 => NULL,
1120: p_param2 => NULL,
1121: p_param3 => NULL,

Line 1135: p_table_name => 'GR_ITEM_GENERAL',

1131: GMA_COMMON_LOGGING.gma_migration_central_log (
1132: p_run_id => P_migration_run_id,
1133: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1134: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1135: p_table_name => 'GR_ITEM_GENERAL',
1136: p_context => 'REGULATORY_ITEMS',
1137: p_param1 => NULL,
1138: p_param2 => NULL,
1139: p_param3 => NULL,

Line 1160: p_table_name => 'GR_ITEM_GENERAL',

1156: GMA_COMMON_LOGGING.gma_migration_central_log (
1157: p_run_id => P_migration_run_id,
1158: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1159: p_message_token => 'GMA_MIGRATION_TABLE_SUCCESS',
1160: p_table_name => 'GR_ITEM_GENERAL',
1161: p_context => 'REGULATORY_ITEMS',
1162: p_param1 => l_migration_count,
1163: p_param2 => x_failure_count,
1164: p_param3 => NULL,

Line 1177: p_table_name => 'GR_ITEM_GENERAL',

1173: GMA_COMMON_LOGGING.gma_migration_central_log (
1174: p_run_id => P_migration_run_id,
1175: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1176: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1177: p_table_name => 'GR_ITEM_GENERAL',
1178: p_context => 'REGULATORY_ITEMS',
1179: p_param1 => NULL,
1180: p_param2 => NULL,
1181: p_param3 => NULL,

Line 1191: p_table_name => 'GR_ITEM_GENERAL',

1187: GMA_COMMON_LOGGING.gma_migration_central_log (
1188: p_run_id => P_migration_run_id,
1189: p_log_level => FND_LOG.LEVEL_PROCEDURE,
1190: p_message_token => 'GMA_TABLE_MIGRATION_TABLE_FAIL',
1191: p_table_name => 'GR_ITEM_GENERAL',
1192: p_context => 'REGULATORY_ITEMS',
1193: p_param1 => x_failure_count,
1194: p_param2 => NULL,
1195: p_param3 => NULL,

Line 1267: FROM gr_item_general a

1263: /* ------------------ CURSORS ---------------------- */
1264: /* Cursor used to retrieve items with formula type of standalone that have formulas saved */
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';