APPS.PO_CORE_S2 dependencies on PO_SESSION_GT

Line 169: -- PO_SESSION_GT

165: --Name: round_and_convert_currency
166: --Pre-reqs:
167: --
168: --Modifies:
169: -- PO_SESSION_GT
170: --Locks:
171: -- None.
172: --Function:
173: -- Performs bulk currency conversion and/or currency rounding

Line 267: SELECT PO_SESSION_GT_S.nextval

263: END IF;
264:
265: x_return_status := FND_API.g_ret_sts_success;
266:
267: SELECT PO_SESSION_GT_S.nextval
268: INTO l_transaction_id
269: FROM DUAL;
270:
271: IF g_debug_stmt THEN

Line 279: INSERT INTO PO_SESSION_GT TEMP

275:
276: l_progress := '010';
277:
278: FORALL i in 1 .. p_amount_in_tbl.COUNT
279: INSERT INTO PO_SESSION_GT TEMP
280: (
281: key
282: , num1 --sequence number
283: , num2 --input amount

Line 311: UPDATE PO_SESSION_GT TEMP

307: -- First, do a currency conversion if necessary
308: -- bug 3578482: If both 'from currency' precision and MAU are null,
309: -- don't round the 'from currency' value in num2 before doing currency conversion.
310:
311: UPDATE PO_SESSION_GT TEMP
312: SET TEMP.num2 =
313: ( DECODE( TEMP.num5
314:
315: -- if from MAU is null, use precision

Line 339: UPDATE PO_SESSION_GT TEMP

335: -- Next, do the rounding using the new currency settings
336: -- bug 3578482: If both 'to currency' precision and MAU are null,
337: -- don't round the 'to currency' value in num2 to get num8.
338:
339: UPDATE PO_SESSION_GT TEMP
340: SET TEMP.num8 = --output amount
341: ( DECODE( TEMP.num7
342:
343: -- if MAU is null, use precision

Line 361: FROM PO_SESSION_GT WHERE key = l_transaction_id;

357:
358: IF g_debug_stmt THEN
359: l_progress := '040';
360: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
361: FROM PO_SESSION_GT WHERE key = l_transaction_id;
362:
363: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
364: PO_DEBUG.g_rowid_tbl,
365: po_tbl_varchar30('num1','num2','num3',

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

359: l_progress := '040';
360: SELECT rowid BULK COLLECT INTO PO_DEBUG.g_rowid_tbl
361: FROM PO_SESSION_GT WHERE key = l_transaction_id;
362:
363: PO_DEBUG.debug_table(l_log_head,l_progress,'PO_SESSION_GT',
364: PO_DEBUG.g_rowid_tbl,
365: po_tbl_varchar30('num1','num2','num3',
366: 'num4','num5','num6',
367: 'num7')

Line 376: FROM PO_SESSION_GT TEMP

372:
373: -- Retrieve the final amount into the output table
374: SELECT TEMP.num8
375: BULK COLLECT INTO x_amount_out_tbl
376: FROM PO_SESSION_GT TEMP
377: WHERE TEMP.key = l_transaction_id
378: ORDER BY TEMP.num1; --input and output tbls have same ordering
379:
380: l_progress := '050';