APPS.PO_CORE_S2 dependencies on PO_SESSION_GT

Line 196: -- PO_SESSION_GT

192: --Name: round_and_convert_currency
193: --Pre-reqs:
194: --
195: --Modifies:
196: -- PO_SESSION_GT
197: --Locks:
198: -- None.
199: --Function:
200: -- Performs bulk currency conversion and/or currency rounding

Line 294: SELECT PO_SESSION_GT_S.nextval

290: END IF;
291:
292: x_return_status := FND_API.g_ret_sts_success;
293:
294: SELECT PO_SESSION_GT_S.nextval
295: INTO l_transaction_id
296: FROM DUAL;
297:
298: IF g_debug_stmt THEN

Line 306: INSERT INTO PO_SESSION_GT TEMP

302:
303: l_progress := '010';
304:
305: FORALL i in 1 .. p_amount_in_tbl.COUNT
306: INSERT INTO PO_SESSION_GT TEMP
307: (
308: key
309: , num1 --sequence number
310: , num2 --input amount

Line 338: UPDATE PO_SESSION_GT TEMP

334: -- First, do a currency conversion if necessary
335: -- bug 3578482: If both 'from currency' precision and MAU are null,
336: -- don't round the 'from currency' value in num2 before doing currency conversion.
337:
338: UPDATE PO_SESSION_GT TEMP
339: SET TEMP.num2 =
340: ( DECODE( TEMP.num5
341:
342: -- if from MAU is null, use precision

Line 366: UPDATE PO_SESSION_GT TEMP

362: -- Next, do the rounding using the new currency settings
363: -- bug 3578482: If both 'to currency' precision and MAU are null,
364: -- don't round the 'to currency' value in num2 to get num8.
365:
366: UPDATE PO_SESSION_GT TEMP
367: SET TEMP.num8 = --output amount
368: ( DECODE( TEMP.num7
369:
370: -- if MAU is null, use precision

Line 388: FROM PO_SESSION_GT WHERE key = l_transaction_id;

384:
385: IF g_debug_stmt THEN
386: l_progress := '040';
387: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
388: FROM PO_SESSION_GT WHERE key = l_transaction_id;
389:
390: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
391: PO_DEBUG.g_rowid_tbl,
392: po_tbl_varchar30('num1','num2','num3',

Line 390: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',

386: l_progress := '040';
387: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
388: FROM PO_SESSION_GT WHERE key = l_transaction_id;
389:
390: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
391: PO_DEBUG.g_rowid_tbl,
392: po_tbl_varchar30('num1','num2','num3',
393: 'num4','num5','num6',
394: 'num7')

Line 403: FROM PO_SESSION_GT TEMP

399:
400: -- Retrieve the final amount into the output table
401: SELECT TEMP.num8
402: BULK COLLECT INTO x_amount_out_tbl
403: FROM PO_SESSION_GT TEMP
404: WHERE TEMP.key = l_transaction_id
405: ORDER BY TEMP.num1; --input and output tbls have same ordering
406:
407: l_progress := '050';