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.RCV_CHARGES_GRP dependencies on DBMS_UTILITY

Line 331: l_interface_charge_id_tbl dbms_utility.number_array;

327:
328: Procedure Update_Interface_Charges
329: ( p_charge_interface_table IN charge_interface_table_type
330: ) IS
331: l_interface_charge_id_tbl dbms_utility.number_array;
332: BEGIN
333: FOR i IN 1..p_charge_interface_table.COUNT LOOP
334: l_interface_charge_id_tbl(i) := p_charge_interface_table(i).interface_charge_id;
335: END LOOP;

Line 430: , p_id_table IN dbms_utility.number_array

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;
434: l_ratio NUMBER;

Line 431: , p_prorate_table IN dbms_utility.number_array

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;
434: l_ratio NUMBER;
435: l_remaining_estimated_amount NUMBER;

Line 508: l_shipment_line_ids dbms_utility.number_array;

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:
507: -- tables of values
508: l_shipment_line_ids dbms_utility.number_array;
509: l_organization_ids dbms_utility.number_array;
510: l_item_ids dbms_utility.number_array;
511: l_quantities dbms_utility.number_array;
512: l_units_of_measure uom_table_type;

Line 509: l_organization_ids dbms_utility.number_array;

505: TYPE uom_class_table_type IS TABLE OF mtl_uom_classes.uom_class%TYPE;
506:
507: -- tables of values
508: l_shipment_line_ids dbms_utility.number_array;
509: l_organization_ids dbms_utility.number_array;
510: l_item_ids dbms_utility.number_array;
511: l_quantities dbms_utility.number_array;
512: l_units_of_measure uom_table_type;
513: l_uom_classes uom_class_table_type;

Line 510: l_item_ids dbms_utility.number_array;

506:
507: -- tables of values
508: l_shipment_line_ids dbms_utility.number_array;
509: l_organization_ids dbms_utility.number_array;
510: l_item_ids dbms_utility.number_array;
511: l_quantities dbms_utility.number_array;
512: l_units_of_measure uom_table_type;
513: l_uom_classes uom_class_table_type;
514: l_primary_units_of_measure uom_table_type;

Line 511: l_quantities dbms_utility.number_array;

507: -- tables of values
508: l_shipment_line_ids dbms_utility.number_array;
509: l_organization_ids dbms_utility.number_array;
510: l_item_ids dbms_utility.number_array;
511: l_quantities dbms_utility.number_array;
512: l_units_of_measure uom_table_type;
513: l_uom_classes uom_class_table_type;
514: l_primary_units_of_measure uom_table_type;
515: l_unit_volumes dbms_utility.number_array;

Line 515: l_unit_volumes dbms_utility.number_array;

511: l_quantities dbms_utility.number_array;
512: l_units_of_measure uom_table_type;
513: l_uom_classes uom_class_table_type;
514: l_primary_units_of_measure uom_table_type;
515: l_unit_volumes dbms_utility.number_array;
516: l_volume_uoms uom_table_type;
517: l_volumes dbms_utility.number_array;
518:
519: -- simplifying conditions

Line 517: l_volumes dbms_utility.number_array;

513: l_uom_classes uom_class_table_type;
514: l_primary_units_of_measure uom_table_type;
515: l_unit_volumes dbms_utility.number_array;
516: l_volume_uoms uom_table_type;
517: l_volumes dbms_utility.number_array;
518:
519: -- simplifying conditions
520: l_all_null_items boolean := TRUE;
521: l_all_volume_uoms boolean := TRUE;

Line 622: l_shipment_line_ids dbms_utility.number_array;

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:
621: -- tables of values
622: l_shipment_line_ids dbms_utility.number_array;
623: l_organization_ids dbms_utility.number_array;
624: l_item_ids dbms_utility.number_array;
625: l_quantities dbms_utility.number_array;
626: l_units_of_measure uom_table_type;

Line 623: l_organization_ids dbms_utility.number_array;

619: TYPE uom_class_table_type IS TABLE OF mtl_uom_classes.uom_class%TYPE;
620:
621: -- tables of values
622: l_shipment_line_ids dbms_utility.number_array;
623: l_organization_ids dbms_utility.number_array;
624: l_item_ids dbms_utility.number_array;
625: l_quantities dbms_utility.number_array;
626: l_units_of_measure uom_table_type;
627: l_uom_classes uom_class_table_type;

Line 624: l_item_ids dbms_utility.number_array;

620:
621: -- tables of values
622: l_shipment_line_ids dbms_utility.number_array;
623: l_organization_ids dbms_utility.number_array;
624: l_item_ids dbms_utility.number_array;
625: l_quantities dbms_utility.number_array;
626: l_units_of_measure uom_table_type;
627: l_uom_classes uom_class_table_type;
628: l_primary_units_of_measure uom_table_type;

Line 625: l_quantities dbms_utility.number_array;

621: -- tables of values
622: l_shipment_line_ids dbms_utility.number_array;
623: l_organization_ids dbms_utility.number_array;
624: l_item_ids dbms_utility.number_array;
625: l_quantities dbms_utility.number_array;
626: l_units_of_measure uom_table_type;
627: l_uom_classes uom_class_table_type;
628: l_primary_units_of_measure uom_table_type;
629: l_unit_weights dbms_utility.number_array;

Line 629: l_unit_weights dbms_utility.number_array;

625: l_quantities dbms_utility.number_array;
626: l_units_of_measure uom_table_type;
627: l_uom_classes uom_class_table_type;
628: l_primary_units_of_measure uom_table_type;
629: l_unit_weights dbms_utility.number_array;
630: l_weight_uoms uom_table_type;
631: l_weights dbms_utility.number_array;
632:
633: -- simplifying conditions

Line 631: l_weights dbms_utility.number_array;

627: l_uom_classes uom_class_table_type;
628: l_primary_units_of_measure uom_table_type;
629: l_unit_weights dbms_utility.number_array;
630: l_weight_uoms uom_table_type;
631: l_weights dbms_utility.number_array;
632:
633: -- simplifying conditions
634: l_all_null_items boolean := TRUE;
635: l_all_weight_uoms boolean := TRUE;

Line 732: l_shipment_line_ids dbms_utility.number_array;

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
735: -- get the quantities to allocate across
736: SELECT shipment_line_id

Line 733: l_shipment_line_quantities dbms_utility.number_array;

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
735: -- get the quantities to allocate across
736: SELECT shipment_line_id
737: , decode(quantity_received, 0, quantity_shipped, quantity_received)

Line 755: l_shipment_line_ids dbms_utility.number_array;

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
758: asn_debug.put_line('Allocating header level charge by value for shipment header id ' || p_charge.shipment_header_id);
759:

Line 756: l_shipment_line_amounts dbms_utility.number_array;

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
758: asn_debug.put_line('Allocating header level charge by value for shipment header id ' || p_charge.shipment_header_id);
759:
760: -- get the item values to allocate across