APPS.GMD_FORMULA_ANALYSIS dependencies on MTL_UNITS_OF_MEASURE

Line 39: FROM mtl_units_of_measure

35:
36: -- NPD Conv.
37: CURSOR Cur_std_um(V_type VARCHAR2) IS
38: SELECT uom_code
39: FROM mtl_units_of_measure
40: WHERE uom_class = V_type
41: AND base_uom_flag = 'Y';
42:
43: -- NPD Conv.

Line 56: X_from_um mtl_units_of_measure.uom_code%TYPE;

52: X_login_id NUMBER := TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID'));
53: X_row NUMBER := 0;
54: X_item VARCHAR2(32);
55: l_orgn_code VARCHAR2(4);
56: X_from_um mtl_units_of_measure.uom_code%TYPE;
57: X_status VARCHAR2(32);
58: l_return_status VARCHAR2(10);
59: X_rec ing_rec;
60: X_scale_factor NUMBER := 0;

Line 440: X_item_um mtl_units_of_measure.uom_code%TYPE;

436: X_found NUMBER := 0;
437: X_prod_qty NUMBER;
438: X_conv_qty NUMBER;
439: X_scale_factor NUMBER;
440: X_item_um mtl_units_of_measure.uom_code%TYPE;
441: X_status VARCHAR2(20);
442: l_orgn_code VARCHAR2(3);
443: X_rec ing_rec;
444: X_ingred_table ing_tab;

Line 965: FROM mtl_units_of_measure

961: p_laboratory_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2) IS
962:
963: CURSOR Cur_get_type(V_um_code VARCHAR2) IS
964: SELECT uom_class
965: FROM mtl_units_of_measure
966: WHERE uom_code = V_um_code;
967:
968: X_conv_qty NUMBER;
969: X_density NUMBER;

Line 972: X_from_um mtl_units_of_measure.uom_code%TYPE;

968: X_conv_qty NUMBER;
969: X_density NUMBER;
970: X_item VARCHAR2(32);
971: X_status VARCHAR2(10);
972: X_from_um mtl_units_of_measure.uom_code%TYPE;
973: X_to_um mtl_units_of_measure.uom_code%TYPE;
974: X_um_type mtl_units_of_measure.uom_class%TYPE;
975: UOM_CONV_ERR EXCEPTION;
976: BAD_UOM_TYPE EXCEPTION;

Line 973: X_to_um mtl_units_of_measure.uom_code%TYPE;

969: X_density NUMBER;
970: X_item VARCHAR2(32);
971: X_status VARCHAR2(10);
972: X_from_um mtl_units_of_measure.uom_code%TYPE;
973: X_to_um mtl_units_of_measure.uom_code%TYPE;
974: X_um_type mtl_units_of_measure.uom_class%TYPE;
975: UOM_CONV_ERR EXCEPTION;
976: BAD_UOM_TYPE EXCEPTION;
977:

Line 974: X_um_type mtl_units_of_measure.uom_class%TYPE;

970: X_item VARCHAR2(32);
971: X_status VARCHAR2(10);
972: X_from_um mtl_units_of_measure.uom_code%TYPE;
973: X_to_um mtl_units_of_measure.uom_code%TYPE;
974: X_um_type mtl_units_of_measure.uom_class%TYPE;
975: UOM_CONV_ERR EXCEPTION;
976: BAD_UOM_TYPE EXCEPTION;
977:
978: BEGIN