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.PO_AP_INVOICE_MATCH_GRP dependencies on PO_SESSION_GT

Line 283: SELECT PO_SESSION_GT_S.nextval

279: END IF;
280:
281: d_position := 20;
282:
283: SELECT PO_SESSION_GT_S.nextval
284: INTO l_gt_key
285: FROM dual;
286:
287: d_position := 30;

Line 296: INSERT INTO PO_SESSION_GT GTT(

292:
293: --Bug 5524978: Modified Logic to fcator in that max_retainage_amount can be NULL
294: --Bug 5549067: Used NVL around PO_LINES_INT.retained_amount
295: FORALL i IN 1 .. p_line_location_id_tbl.COUNT
296: INSERT INTO PO_SESSION_GT GTT(
297: key,
298: num1,
299: num2
300: )

Line 327: FROM PO_SESSION_GT GTT

323:
324: -- Retrieve the results from the GT into the plsql table out param
325: SELECT GTT.num2
326: BULK COLLECT INTO x_amount_to_retain_tbl
327: FROM PO_SESSION_GT GTT
328: WHERE GTT.key = l_gt_key
329: ORDER BY GTT.num1 --input and output tbls have same ordering
330: ;
331:

Line 335: DELETE FROM PO_SESSION_GT GTT WHERE GTT.key = l_gt_key;

331:
332: d_position := 50;
333:
334: -- Clean up the GT by deleting the data
335: DELETE FROM PO_SESSION_GT GTT WHERE GTT.key = l_gt_key;
336:
337: d_position := 60;
338:
339: IF PO_LOG.d_proc THEN