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_CHARGES_GRP dependencies on PO_RCV_CHARGE_ALLOCATIONS

Line 422: -- bulk insert po_rcv_charge_allocations from the charge table

418: IF (g_asn_debug = 'Y') THEN
419: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charges');
420: END IF;
421:
422: -- bulk insert po_rcv_charge_allocations from the charge table
423: FORALL i IN INDICES OF l_charge_alloc_table
424: INSERT INTO po_rcv_charge_allocations
425: VALUES l_charge_alloc_table(i);
426:

Line 424: INSERT INTO po_rcv_charge_allocations

420: END IF;
421:
422: -- bulk insert po_rcv_charge_allocations from the charge table
423: FORALL i IN INDICES OF l_charge_alloc_table
424: INSERT INTO po_rcv_charge_allocations
425: VALUES l_charge_alloc_table(i);
426:
427: IF (g_asn_debug = 'Y') THEN
428: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charge_allocations');

Line 428: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charge_allocations');

424: INSERT INTO po_rcv_charge_allocations
425: VALUES l_charge_alloc_table(i);
426:
427: IF (g_asn_debug = 'Y') THEN
428: asn_debug.put_line(sql%rowcount || ' rows inserted into po_rcv_charge_allocations');
429: END IF;
430:
431: EXCEPTION
432: WHEN OTHERS THEN

Line 569: UPDATE po_rcv_charge_allocations

565: IF (g_asn_debug = 'Y') THEN
566: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charges');
567: END IF;
568:
569: UPDATE po_rcv_charge_allocations
570: SET estimated_amount = ROUND(l_fte_cost_table(j).total_cost, l_precision)
571: WHERE shipment_line_id = j
572: AND estimated_amount <> ROUND(l_fte_cost_table(j).total_cost, l_precision);
573:

Line 575: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charge_allocations');

571: WHERE shipment_line_id = j
572: AND estimated_amount <> ROUND(l_fte_cost_table(j).total_cost, l_precision);
573:
574: IF (g_asn_debug = 'Y') THEN
575: asn_debug.put_line('updated ' || sql%rowcount || ' row in po_rcv_charge_allocations');
576: END IF;
577: ELSE
578: IF (g_asn_debug = 'Y') THEN
579: asn_debug.put_line('Populating charge_table (' || k ||')');

Line 667: -- bulk insert po_rcv_charge_allocations from the charge table

663: IF (g_asn_debug = 'Y') THEN
664: asn_debug.put_line('Done bulk insert into po_rcv_charges');
665: END IF;
666:
667: -- bulk insert po_rcv_charge_allocations from the charge table
668: FORALL i IN INDICES OF l_charge_alloc_table
669: INSERT INTO po_rcv_charge_allocations
670: VALUES l_charge_alloc_table(i);
671:

Line 669: INSERT INTO po_rcv_charge_allocations

665: END IF;
666:
667: -- bulk insert po_rcv_charge_allocations from the charge table
668: FORALL i IN INDICES OF l_charge_alloc_table
669: INSERT INTO po_rcv_charge_allocations
670: VALUES l_charge_alloc_table(i);
671:
672: IF (g_asn_debug = 'Y') THEN
673: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

Line 673: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

669: INSERT INTO po_rcv_charge_allocations
670: VALUES l_charge_alloc_table(i);
671:
672: IF (g_asn_debug = 'Y') THEN
673: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
674: END IF;
675:
676: IF (g_asn_debug = 'Y') THEN
677: asn_debug.put_line('Exit Capture_FTE_Estimated_Charges()');

Line 770: asn_debug.put_line('Updating PO_RCV_CHARGE_ALLOCATIONS with actual amount'||

766: , vendor_site_id = NVL(vendor_site_id, p_fte_actual_charge.vendor_site_id)
767: WHERE shipment_line_id = p_fte_actual_charge.shipment_line_id;
768:
769: IF (g_asn_debug = 'Y') THEN
770: asn_debug.put_line('Updating PO_RCV_CHARGE_ALLOCATIONS with actual amount'||
771: p_fte_actual_charge.actual_amount);
772: END IF;
773:
774: UPDATE po_rcv_charge_allocations

Line 774: UPDATE po_rcv_charge_allocations

770: asn_debug.put_line('Updating PO_RCV_CHARGE_ALLOCATIONS with actual amount'||
771: p_fte_actual_charge.actual_amount);
772: END IF;
773:
774: UPDATE po_rcv_charge_allocations
775: SET actual_amount = p_fte_actual_charge.actual_amount
776: WHERE shipment_line_id = p_fte_actual_charge.shipment_line_id;
777:
778: IF (g_asn_debug = 'Y') THEN

Line 781: -- For new charges, populate new rows in po_rcv_charges and po_rcv_charge_allocations.

777:
778: IF (g_asn_debug = 'Y') THEN
779: asn_debug.put_line('Done updating actual amounts for existing charge');
780: END IF;
781: -- For new charges, populate new rows in po_rcv_charges and po_rcv_charge_allocations.
782: ELSE
783: IF (g_asn_debug = 'Y') THEN
784: asn_debug.put_line('This is a new charge');
785: END IF;

Line 839: -- bulk insert po_rcv_charge_allocations from the charge table

835: IF (g_asn_debug = 'Y') THEN
836: asn_debug.put_line('Done bulk insert into po_rcv_charges');
837: END IF;
838:
839: -- bulk insert po_rcv_charge_allocations from the charge table
840: FORALL i IN 1..l_fte_actual_charge_allocs.COUNT
841: INSERT INTO po_rcv_charge_allocations
842: VALUES l_fte_actual_charge_allocs(i);
843:

Line 841: INSERT INTO po_rcv_charge_allocations

837: END IF;
838:
839: -- bulk insert po_rcv_charge_allocations from the charge table
840: FORALL i IN 1..l_fte_actual_charge_allocs.COUNT
841: INSERT INTO po_rcv_charge_allocations
842: VALUES l_fte_actual_charge_allocs(i);
843:
844: IF (g_asn_debug = 'Y') THEN
845: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

Line 845: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

841: INSERT INTO po_rcv_charge_allocations
842: VALUES l_fte_actual_charge_allocs(i);
843:
844: IF (g_asn_debug = 'Y') THEN
845: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
846: END IF;
847:
848: END IF;
849:

Line 947: -- bulk insert po_rcv_charge_allocations from the charge table

943: IF (g_asn_debug = 'Y') THEN
944: asn_debug.put_line('Done bulk insert into po_rcv_charges');
945: END IF;
946:
947: -- bulk insert po_rcv_charge_allocations from the charge table
948: FORALL i IN 1..l_charge_alloc_table.COUNT
949: INSERT INTO po_rcv_charge_allocations
950: VALUES l_charge_alloc_table(i);
951:

Line 949: INSERT INTO po_rcv_charge_allocations

945: END IF;
946:
947: -- bulk insert po_rcv_charge_allocations from the charge table
948: FORALL i IN 1..l_charge_alloc_table.COUNT
949: INSERT INTO po_rcv_charge_allocations
950: VALUES l_charge_alloc_table(i);
951:
952: IF (g_asn_debug = 'Y') THEN
953: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

Line 953: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');

949: INSERT INTO po_rcv_charge_allocations
950: VALUES l_charge_alloc_table(i);
951:
952: IF (g_asn_debug = 'Y') THEN
953: asn_debug.put_line('Done bulk insert into po_rcv_charge_allocations');
954: END IF;
955:
956: -- generate summary report
957: G_CONC_LOG := G_CONC_LOG || 'Summary information: ' ||

Line 994: l_charge_allocation_id po_rcv_charge_allocations.charge_allocation_id%TYPE;

990:
991: IS
992:
993: l_charge_id po_rcv_charges.charge_id%TYPE;
994: l_charge_allocation_id po_rcv_charge_allocations.charge_allocation_id%TYPE;
995: l_cost_factor_details pon_price_element_types_vl%ROWTYPE;
996: l_new_ap_charge VARCHAR2(1) := 'Y';
997:
998: BEGIN

Line 1065: UPDATE po_rcv_charge_allocations

1061: IF (g_asn_debug = 'Y') THEN
1062: asn_debug.put_line('Updated PRC (charge_id=' || l_charge_id || ') with amount'||l_ap_charge_distribution.amount);
1063: END IF;
1064:
1065: UPDATE po_rcv_charge_allocations
1066: SET actual_amount = nvl(actual_amount,0) + l_ap_charge_distribution.amount
1067: , act_recoverable_tax = l_ap_charge_distribution.rec_tax
1068: , act_non_recoverable_tax = l_ap_charge_distribution.nonrec_tax
1069: WHERE shipment_line_id = l_ap_charge_distribution.shipment_line_id

Line 1127: SELECT po_rcv_charge_allocations_s.NEXTVAL

1123: IF (g_asn_debug = 'Y') THEN
1124: asn_debug.put_line('Done populating charge_table (' || k || ')');
1125: END IF;
1126:
1127: SELECT po_rcv_charge_allocations_s.NEXTVAL
1128: INTO l_charge_alloc_table(k).charge_allocation_id
1129: FROM dual;
1130:
1131: l_charge_alloc_table(k).creation_date := SYSDATE;