DBA Data[Home] [Help]

APPS.RCV_CHARGES_GRP dependencies on PO_RCV_CHARGES

Line 349: l_charge po_rcv_charges%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;
350: l_cost_factor_details pon_price_element_types_vl%ROWTYPE;
351: BEGIN
352: SELECT po_rcv_charges_s.NEXTVAL
353: INTO l_charge.charge_id

Line 352: SELECT po_rcv_charges_s.NEXTVAL

348: ) IS
349: l_charge po_rcv_charges%ROWTYPE;
350: l_cost_factor_details pon_price_element_types_vl%ROWTYPE;
351: BEGIN
352: SELECT po_rcv_charges_s.NEXTVAL
353: INTO l_charge.charge_id
354: FROM dual;
355:
356: l_charge.creation_date := SYSDATE;

Line 387: ( p_charge IN po_rcv_charges%ROWTYPE

383: p_charge_table(p_charge_table.COUNT+1) := l_charge;
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

Line 416: ( p_charge IN po_rcv_charges%ROWTYPE

412: p_charge_allocation_table(p_charge_allocation_table.COUNT+1) := l_charge_allocation;
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

Line 428: ( p_charge IN po_rcv_charges%ROWTYPE

424: );
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

Line 501: ( p_charge IN po_rcv_charges%ROWTYPE

497: p_charge_allocation_table(p_charge_allocation_table.COUNT).actual_amount + l_remaining_actual_amount;
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;

Line 615: ( p_charge IN po_rcv_charges%ROWTYPE

611: );
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;

Line 729: ( p_charge IN po_rcv_charges%ROWTYPE

725: );
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;

Line 752: ( p_charge IN po_rcv_charges%ROWTYPE

748: );
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;

Line 781: ( p_charge IN OUT NOCOPY po_rcv_charges%ROWTYPE

777: );
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

Line 1041: -- populate po_rcv_charges

1037:
1038: -- populate po_rcv_charge_allocations
1039: Allocate_Charges( l_charge_table, l_charge_allocation_table , l_charge_interface_table );
1040:
1041: -- populate po_rcv_charges
1042: FORALL i IN 1..l_charge_table.COUNT
1043: INSERT INTO po_rcv_charges
1044: VALUES l_charge_table(i);
1045:

Line 1043: INSERT INTO po_rcv_charges

1039: Allocate_Charges( l_charge_table, l_charge_allocation_table , l_charge_interface_table );
1040:
1041: -- populate po_rcv_charges
1042: FORALL i IN 1..l_charge_table.COUNT
1043: INSERT INTO po_rcv_charges
1044: VALUES l_charge_table(i);
1045:
1046: asn_debug.put_line('Inserted ' || SQL%ROWCOUNT || ' rows into PO_RCV_CHARGES');
1047:

Line 1046: asn_debug.put_line('Inserted ' || SQL%ROWCOUNT || ' rows into PO_RCV_CHARGES');

1042: FORALL i IN 1..l_charge_table.COUNT
1043: INSERT INTO po_rcv_charges
1044: VALUES l_charge_table(i);
1045:
1046: asn_debug.put_line('Inserted ' || SQL%ROWCOUNT || ' rows into PO_RCV_CHARGES');
1047:
1048: FORALL i IN 1..l_charge_allocation_table.COUNT
1049: INSERT INTO po_rcv_charge_allocations
1050: VALUES l_charge_allocation_table(i);