DBA Data[Home] [Help]

APPS.RCV_CHARGES_GRP dependencies on PO_CHARGES_GRP

Line 345: , p_charge_table IN OUT NOCOPY PO_CHARGES_GRP.charge_table_type

341: END Update_Interface_Charges;
342:
343: Procedure Add_Charge_From_Interface
344: ( p_charge_interface IN rcv_charges_interface%ROWTYPE
345: , p_charge_table IN OUT NOCOPY PO_CHARGES_GRP.charge_table_type
346: , p_shipment_header_id IN rcv_shipment_headers.shipment_header_id%TYPE
347: , p_shipment_line_id IN rcv_shipment_lines.shipment_line_id%TYPE
348: ) IS
349: l_charge po_rcv_charges%ROWTYPE;

Line 388: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

384: END Add_Charge_From_Interface;
385:
386: PROCEDURE Add_Allocation_From_Charge
387: ( p_charge IN po_rcv_charges%ROWTYPE
388: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
389: ) IS
390: l_charge_allocation po_rcv_charge_allocations%ROWTYPE;
391: BEGIN
392: SELECT po_rcv_charge_allocations_s.NEXTVAL

Line 417: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

413: END Add_Allocation_From_Charge;
414:
415: PROCEDURE Allocate_Line_Level_Charge
416: ( p_charge IN po_rcv_charges%ROWTYPE
417: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
418: ) IS
419: BEGIN
420: -- all we need to do is instantiate a new allocation based on the charge
421: Add_Allocation_From_Charge

Line 429: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

425: END Allocate_Line_Level_Charge;
426:
427: PROCEDURE Prorate_Charge
428: ( p_charge IN po_rcv_charges%ROWTYPE
429: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
430: , p_id_table IN dbms_utility.number_array
431: , p_prorate_table IN dbms_utility.number_array
432: ) IS
433: l_total NUMBER := 0;

Line 502: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

498: END Prorate_Charge;
499:
500: PROCEDURE Allocate_Charge_By_Volume
501: ( p_charge IN po_rcv_charges%ROWTYPE
502: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
503: ) IS
504: TYPE uom_table_type IS TABLE OF mtl_units_of_measure.unit_of_measure%TYPE;
505: TYPE uom_class_table_type IS TABLE OF mtl_uom_classes.uom_class%TYPE;
506:

Line 616: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

612: END Allocate_Charge_By_Volume;
613:
614: PROCEDURE Allocate_Charge_By_Weight
615: ( p_charge IN po_rcv_charges%ROWTYPE
616: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
617: ) IS
618: TYPE uom_table_type IS TABLE OF mtl_units_of_measure.unit_of_measure%TYPE;
619: TYPE uom_class_table_type IS TABLE OF mtl_uom_classes.uom_class%TYPE;
620:

Line 730: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

726: END Allocate_Charge_By_Weight;
727:
728: PROCEDURE Allocate_Charge_By_Quantity
729: ( p_charge IN po_rcv_charges%ROWTYPE
730: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
731: ) IS
732: l_shipment_line_ids dbms_utility.number_array;
733: l_shipment_line_quantities dbms_utility.number_array;
734: BEGIN

Line 753: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

749: END Allocate_Charge_By_Quantity;
750:
751: PROCEDURE Allocate_Charge_By_Value
752: ( p_charge IN po_rcv_charges%ROWTYPE
753: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
754: ) IS
755: l_shipment_line_ids dbms_utility.number_array;
756: l_shipment_line_amounts dbms_utility.number_array;
757: BEGIN

Line 782: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

778: END Allocate_Charge_By_Value;
779:
780: PROCEDURE Allocate_Header_Level_Charge
781: ( p_charge IN OUT NOCOPY po_rcv_charges%ROWTYPE
782: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
783: ) IS
784: BEGIN
785: IF p_charge.allocation_method IS NULL THEN
786: p_charge.allocation_method := 'VALUE';

Line 819: ( p_charge_table IN OUT NOCOPY PO_CHARGES_GRP.charge_table_type

815: END CASE;
816: END Allocate_Header_Level_Charge;
817:
818: PROCEDURE Allocate_Charges
819: ( p_charge_table IN OUT NOCOPY PO_CHARGES_GRP.charge_table_type
820: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
821: , p_charge_interface_table IN OUT NOCOPY charge_interface_table_type
822: ) IS
823: l_rci_idx BINARY_INTEGER := 1;

Line 820: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type

816: END Allocate_Header_Level_Charge;
817:
818: PROCEDURE Allocate_Charges
819: ( p_charge_table IN OUT NOCOPY PO_CHARGES_GRP.charge_table_type
820: , p_charge_allocation_table IN OUT NOCOPY PO_CHARGES_GRP.charge_allocation_table_type
821: , p_charge_interface_table IN OUT NOCOPY charge_interface_table_type
822: ) IS
823: l_rci_idx BINARY_INTEGER := 1;
824: BEGIN

Line 962: l_charge_table PO_CHARGES_GRP.charge_table_type;

958: , p_shipment_header_id IN RCV_SHIPMENT_HEADERS.shipment_header_id%TYPE
959: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
960: ) IS
961: l_charge_interface_table charge_interface_table_type;
962: l_charge_table PO_CHARGES_GRP.charge_table_type;
963: l_charge_allocation_table PO_CHARGES_GRP.charge_allocation_table_type;
964: l_fail_all_charges EXCEPTION;
965: l_rti_t_status varchar2(50);
966: l_rti_p_status varchar2(50);

Line 963: l_charge_allocation_table PO_CHARGES_GRP.charge_allocation_table_type;

959: , p_shipment_line_id IN RCV_SHIPMENT_LINES.shipment_line_id%TYPE
960: ) IS
961: l_charge_interface_table charge_interface_table_type;
962: l_charge_table PO_CHARGES_GRP.charge_table_type;
963: l_charge_allocation_table PO_CHARGES_GRP.charge_allocation_table_type;
964: l_fail_all_charges EXCEPTION;
965: l_rti_t_status varchar2(50);
966: l_rti_p_status varchar2(50);
967: BEGIN