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 287: SELECT PO_SESSION_GT_S.nextval

283: END IF;
284:
285: d_position := 20;
286:
287: SELECT PO_SESSION_GT_S.nextval
288: INTO l_gt_key
289: FROM dual;
290:
291: d_position := 30;

Line 301: INSERT INTO PO_SESSION_GT GTT(

297: --Bug 5524978: Modified Logic to fcator in that max_retainage_amount can be NULL
298: --Bug 5549067: Used NVL around PO_LINES_INT.retained_amount
299: -- Bug 13443523 -start
300: FORALL i IN 1 .. p_line_location_id_tbl.COUNT
301: INSERT INTO PO_SESSION_GT GTT(
302: key,
303: num1, -- Shipment Id on the current Invoice
304: num2, -- Line Id on the current Invoice
305: num3, -- CurrenT Invoice Amount at Shipment Level

Line 322: UPDATE PO_SESSION_GT GTO

318: where pl.po_line_id = pll.po_line_id
319: and pll.line_location_id = p_line_location_id_tbl(i);
320:
321: -- SumAmtInvoiced_Line_Session (SIALS)
322: UPDATE PO_SESSION_GT GTO
323: SET GTO.NUM4 = (SELECT SUM(GTI.NUM3)
324: FROM PO_SESSION_GT GTI
325: WHERE GTI.num2 = GTO.num2);
326:

Line 324: FROM PO_SESSION_GT GTI

320:
321: -- SumAmtInvoiced_Line_Session (SIALS)
322: UPDATE PO_SESSION_GT GTO
323: SET GTO.NUM4 = (SELECT SUM(GTI.NUM3)
324: FROM PO_SESSION_GT GTI
325: WHERE GTI.num2 = GTO.num2);
326:
327:
328: -- Sum of Retained Amount at Line(SRAL)

Line 329: UPDATE PO_SESSION_GT GTO

325: WHERE GTI.num2 = GTO.num2);
326:
327:
328: -- Sum of Retained Amount at Line(SRAL)
329: UPDATE PO_SESSION_GT GTO
330: SET GTO.NUM5 = (SELECT SUM(Nvl(pll.retainage_withheld_amount,0))
331: FROM po_line_locations_all PLL
332: WHERE PLL.po_line_id = GTO.num2);
333:

Line 335: UPDATE PO_SESSION_GT GTO

331: FROM po_line_locations_all PLL
332: WHERE PLL.po_line_id = GTO.num2);
333:
334: -- Calculated Retainable Amount for the Current Session (CRAS)
335: UPDATE PO_SESSION_GT GTO
336: SET GTO.NUM8 = (SELECT GTI.NUM4*GTI.NUM6/100
337: FROM PO_SESSION_GT GTI
338: WHERE GTI.num2 = GTO.num2);
339:

Line 337: FROM PO_SESSION_GT GTI

333:
334: -- Calculated Retainable Amount for the Current Session (CRAS)
335: UPDATE PO_SESSION_GT GTO
336: SET GTO.NUM8 = (SELECT GTI.NUM4*GTI.NUM6/100
337: FROM PO_SESSION_GT GTI
338: WHERE GTI.num2 = GTO.num2);
339:
340: FOR CREC IN (SELECT * FROM PO_SESSION_GT GTT WHERE GTT.key = l_gt_key ORDER BY GTT.num1)
341: LOOP

Line 340: FOR CREC IN (SELECT * FROM PO_SESSION_GT GTT WHERE GTT.key = l_gt_key ORDER BY GTT.num1)

336: SET GTO.NUM8 = (SELECT GTI.NUM4*GTI.NUM6/100
337: FROM PO_SESSION_GT GTI
338: WHERE GTI.num2 = GTO.num2);
339:
340: FOR CREC IN (SELECT * FROM PO_SESSION_GT GTT WHERE GTT.key = l_gt_key ORDER BY GTT.num1)
341: LOOP
342:
343: --#1: Check if the Max retainage Amount is defined and is less than the total retained amount calculated
344: -- In this case we need to retain only the difference betweem Max. Retained Amount and Already Retained Amount

Line 350: UPDATE PO_SESSION_GT GTO

346: IF CREC.NUM7 IS NOT NULL AND
347: CREC.NUM7 >= 0 AND
348: CREC.NUM8 >= 0 AND
349: CREC.NUM5+CREC.NUM8 > CREC.NUM7 THEN
350: UPDATE PO_SESSION_GT GTO
351: SET GTO.NUM9 = CREC.NUM7-CREC.NUM5
352: WHERE GTO.num1 = CREC.num1;
353:
354: --#2: If calculated retainage amount is negative and more than sum of the retained amount at line level,

Line 359: UPDATE PO_SESSION_GT GTO

355: -- then we will just release sum of retained amount.
356:
357: ELSIF CREC.NUM8 < 0 AND
358: CREC.NUM5+CREC.NUM8 < 0 THEN
359: UPDATE PO_SESSION_GT GTO
360: SET GTO.NUM9 = -CREC.NUM5
361: WHERE GTO.num1 = CREC.num1 ;
362: --#3: For any other case, calculated retainage amount can be assigned to the Adjustable Retainable Amount.
363: ELSE

Line 364: UPDATE PO_SESSION_GT GTO

360: SET GTO.NUM9 = -CREC.NUM5
361: WHERE GTO.num1 = CREC.num1 ;
362: --#3: For any other case, calculated retainage amount can be assigned to the Adjustable Retainable Amount.
363: ELSE
364: UPDATE PO_SESSION_GT GTO
365: SET GTO.NUM9 = CREC.NUM8
366: WHERE GTO.num1 = CREC.num1;
367: END IF;
368: END LOOP;

Line 371: UPDATE PO_SESSION_GT GTO

367: END IF;
368: END LOOP;
369:
370: --Prorated Retainable Amount per Record (PRAR)
371: UPDATE PO_SESSION_GT GTO
372: SET GTO.NUM10 = (SELECT (GTI.NUM3/GTI.NUM4)*GTI.NUM9
373: FROM PO_SESSION_GT GTI
374: WHERE GTI.num1 = GTO.num1);
375:

Line 373: FROM PO_SESSION_GT GTI

369:
370: --Prorated Retainable Amount per Record (PRAR)
371: UPDATE PO_SESSION_GT GTO
372: SET GTO.NUM10 = (SELECT (GTI.NUM3/GTI.NUM4)*GTI.NUM9
373: FROM PO_SESSION_GT GTI
374: WHERE GTI.num1 = GTO.num1);
375:
376: -- Bug 13443523 -End
377:

Line 383: FROM PO_SESSION_GT GTT

379:
380: -- Retrieve the results from the GT into the plsql table out param
381: SELECT GTT.NUM10
382: BULK COLLECT INTO x_amount_to_retain_tbl
383: FROM PO_SESSION_GT GTT
384: WHERE GTT.key = l_gt_key
385: ORDER BY GTT.num1 --input and output tbls have same ordering
386: ;
387:

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

387:
388: d_position := 50;
389:
390: -- Clean up the GT by deleting the data
391: DELETE FROM PO_SESSION_GT GTT WHERE GTT.key = l_gt_key;
392:
393: d_position := 60;
394:
395: IF PO_LOG.d_proc THEN