APPS.GR_MIGRATE_TO_12 dependencies on PO_UN_NUMBERS

Line 192: -- after the un number has been migrated to the po_un_numbers table.

188: -- get_un_number_id
189: --
190: -- DESCRIPTION:
191: -- This PL/SQL procedure is used to retrieve a un number id for a given item
192: -- after the un number has been migrated to the po_un_numbers table.
193: --
194: -- PARAMETERS:
195: -- p_item_code - Item_code to retrieve value for
196: -- x_return_status - Returns the status of the function (success, failure, etc.)

Line 200: -- un_number_id - ID of un_number in po_un_numbers_table

196: -- x_return_status - Returns the status of the function (success, failure, etc.)
197: -- x_msg_data - Returns message data if an error occurred
198: --
199: -- RETURNS:
200: -- un_number_id - ID of un_number in po_un_numbers_table
201: --
202: -- SYNOPSIS:
203: -- l_un_number_id := get_un_number_id(
204: -- p_item_code => l_item_code,

Line 234: FROM po_un_numbers

230:
231: /* Cursor used retrieve the un_number_ id */
232: CURSOR c_get_un_number_id IS
233: SELECT un_number_id
234: FROM po_un_numbers
235: WHERE un_number = l_un_number;
236:
237: /* ----------------- EXCEPTIONS -------------------- */
238: INVALID_UN_NUMBER EXCEPTION;