DBA Data[Home] [Help]

APPS.GR_MIGRATE_TO_12 dependencies on PO_HAZARD_CLASSES

Line 95: -- after the hazard class has been migrated to the po_hazard_classes table.

91: -- get_hazard_class_id
92: --
93: -- DESCRIPTION:
94: -- This PL/SQL procedure is used to retrieve a hazard class id for a given item
95: -- after the hazard class has been migrated to the po_hazard_classes table.
96: --
97: -- RETURNS:
98: -- hazard_class_id - ID of hazard class in po_hazard_classes table
99: --

Line 98: -- hazard_class_id - ID of hazard class in po_hazard_classes table

94: -- This PL/SQL procedure is used to retrieve a hazard class id for a given item
95: -- after the hazard class has been migrated to the po_hazard_classes table.
96: --
97: -- RETURNS:
98: -- hazard_class_id - ID of hazard class in po_hazard_classes table
99: --
100: -- PARAMETERS:
101: -- p_item_code - Item_code to retrieve value for
102: -- x_return_status - Returns the status of the function (success, failure, etc.)

Line 137: FROM po_hazard_classes

133:
134: /* Cursor used retrieve the hazard class_ id */
135: CURSOR c_get_hazard_class_id IS
136: SELECT hazard_class_id
137: FROM po_hazard_classes
138: WHERE hazard_class = l_hazard_class;
139:
140: /* ----------------- EXCEPTIONS -------------------- */
141: INVALID_HAZARD_CLASS EXCEPTION;

Line 1899: p_table_name => 'PO_HAZARD_CLASSES',

1895: GMA_COMMON_LOGGING.gma_migration_central_log (
1896: p_run_id => P_migration_run_id,
1897: p_log_level => FND_LOG.LEVEL_UNEXPECTED,
1898: p_message_token => 'GMA_MIGRATION_DB_ERROR',
1899: p_table_name => 'PO_HAZARD_CLASSES',
1900: p_context => 'HAZARD_CLASSES',
1901: p_param1 => NULL,
1902: p_param2 => NULL,
1903: p_param3 => NULL,