APPS.AHL_RM_ROUTE_UTIL dependencies on MTL_UNITS_OF_MEASURE_VL

Line 2080: p_uom IN MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE,

2076: PROCEDURE validate_uom
2077: (
2078: x_return_status OUT NOCOPY VARCHAR2,
2079: x_msg_data OUT NOCOPY VARCHAR2,
2080: p_uom IN MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE,
2081: p_x_uom_code IN OUT NOCOPY MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2082: )
2083: IS
2084:

Line 2081: p_x_uom_code IN OUT NOCOPY MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE

2077: (
2078: x_return_status OUT NOCOPY VARCHAR2,
2079: x_msg_data OUT NOCOPY VARCHAR2,
2080: p_uom IN MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE,
2081: p_x_uom_code IN OUT NOCOPY MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2082: )
2083: IS
2084:
2085: l_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

Line 2085: l_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;

2081: p_x_uom_code IN OUT NOCOPY MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2082: )
2083: IS
2084:
2085: l_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
2086:
2087: CURSOR get_rec_from_value ( c_uom MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE )
2088: IS
2089: SELECT DISTINCT uom_code

Line 2087: CURSOR get_rec_from_value ( c_uom MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE )

2083: IS
2084:
2085: l_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE;
2086:
2087: CURSOR get_rec_from_value ( c_uom MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE )
2088: IS
2089: SELECT DISTINCT uom_code
2090: FROM MTL_UNITS_OF_MEASURE_VL
2091: WHERE upper(unit_of_measure) = upper(c_uom);

Line 2090: FROM MTL_UNITS_OF_MEASURE_VL

2086:
2087: CURSOR get_rec_from_value ( c_uom MTL_UNITS_OF_MEASURE_VL.unit_of_measure%TYPE )
2088: IS
2089: SELECT DISTINCT uom_code
2090: FROM MTL_UNITS_OF_MEASURE_VL
2091: WHERE upper(unit_of_measure) = upper(c_uom);
2092:
2093: CURSOR get_rec_from_id ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE )
2094: IS

Line 2093: CURSOR get_rec_from_id ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE )

2089: SELECT DISTINCT uom_code
2090: FROM MTL_UNITS_OF_MEASURE_VL
2091: WHERE upper(unit_of_measure) = upper(c_uom);
2092:
2093: CURSOR get_rec_from_id ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE )
2094: IS
2095: SELECT DISTINCT uom_code
2096: FROM MTL_UNITS_OF_MEASURE_VL
2097: WHERE upper(uom_code) = upper(c_uom_code);

Line 2096: FROM MTL_UNITS_OF_MEASURE_VL

2092:
2093: CURSOR get_rec_from_id ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE )
2094: IS
2095: SELECT DISTINCT uom_code
2096: FROM MTL_UNITS_OF_MEASURE_VL
2097: WHERE upper(uom_code) = upper(c_uom_code);
2098:
2099: BEGIN
2100: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2174: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE

2170: x_msg_data OUT NOCOPY VARCHAR2,
2171: p_item_group_id IN AHL_ITEM_GROUPS_VL.item_group_id%TYPE,
2172: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2173: p_inventory_org_id IN MTL_SYSTEM_ITEMS.organization_id%TYPE,
2174: p_uom_code IN MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE
2175: )
2176: IS
2177:
2178: l_dummy VARCHAR2(1);

Line 2180: CURSOR get_uom_for_item ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,

2176: IS
2177:
2178: l_dummy VARCHAR2(1);
2179:
2180: CURSOR get_uom_for_item ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2181: c_inventory_item_id MTL_SYSTEM_ITEMS.inventory_item_id%TYPE,
2182: c_inventory_org_id MTL_SYSTEM_ITEMS.organization_id%TYPE )
2183: IS
2184: SELECT 'X'

Line 2190: CURSOR get_uom_for_item_group ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,

2186: WHERE uom_code = c_uom_code
2187: AND inventory_item_id = c_inventory_item_id
2188: AND inventory_org_id = c_inventory_org_id;
2189:
2190: CURSOR get_uom_for_item_group ( c_uom_code MTL_UNITS_OF_MEASURE_VL.uom_code%TYPE,
2191: c_item_group_id AHL_ITEM_GROUPS_VL.item_group_id%TYPE )
2192: IS
2193: SELECT 'X'
2194: FROM AHL_ITEM_CLASS_UOM_V UOM, AHL_ITEM_ASSOCIATIONS_B ASSOC