APPS.RCV_WSH_INTERFACE_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 12: l_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;

8: ===========================================================================*/
9: FUNCTION get_uom_from_code
10: ( p_uom_code IN VARCHAR2 )
11: RETURN VARCHAR2 IS
12: l_unit_of_measure mtl_units_of_measure.unit_of_measure%TYPE;
13: BEGIN
14:
15: IF (p_uom_code IS NULL) THEN
16: RETURN NULL;

Line 21: FROM mtl_units_of_measure

17: END IF;
18:
19: SELECT unit_of_measure
20: INTO l_unit_of_measure
21: FROM mtl_units_of_measure
22: WHERE uom_code = p_uom_code;
23:
24: RETURN l_unit_of_measure;
25: EXCEPTION

Line 1820: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;

1816: p_wdd_rec IN wsh_delivery_details%rowtype,
1817: p_group_id IN NUMBER) IS
1818:
1819: l_rti_id NUMBER; -- Bug 11831232
1820: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;
1821: l_shipped_uom2 mtl_units_of_measure.unit_of_measure%TYPE := NULL;
1822: l_primary_qty NUMBER;
1823: l_marker_flag BOOLEAN := FALSE;
1824: rti_rec rcv_transactions_interface%ROWTYPE;

Line 1821: l_shipped_uom2 mtl_units_of_measure.unit_of_measure%TYPE := NULL;

1817: p_group_id IN NUMBER) IS
1818:
1819: l_rti_id NUMBER; -- Bug 11831232
1820: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;
1821: l_shipped_uom2 mtl_units_of_measure.unit_of_measure%TYPE := NULL;
1822: l_primary_qty NUMBER;
1823: l_marker_flag BOOLEAN := FALSE;
1824: rti_rec rcv_transactions_interface%ROWTYPE;
1825: l_rev_control NUMBER;

Line 2736: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;

2732: p_bkup_rti_suom IN VARCHAR2 ,
2733: p_bkup_rti_src_uom IN VARCHAR2 ) IS
2734:
2735:
2736: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;
2737: l_shipped_sec_uom mtl_units_of_measure.unit_of_measure%TYPE;
2738: l_txn_qty NUMBER;
2739: l_shipped_qty NUMBER;
2740: l_shipped_qty2 NUMBER := 0;

Line 2737: l_shipped_sec_uom mtl_units_of_measure.unit_of_measure%TYPE;

2733: p_bkup_rti_src_uom IN VARCHAR2 ) IS
2734:
2735:
2736: l_shipped_uom mtl_units_of_measure.unit_of_measure%TYPE;
2737: l_shipped_sec_uom mtl_units_of_measure.unit_of_measure%TYPE;
2738: l_txn_qty NUMBER;
2739: l_shipped_qty NUMBER;
2740: l_shipped_qty2 NUMBER := 0;
2741: l_primary_qty NUMBER;