DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES dependencies on GMD_COMMON_VAL

Line 290: gmd_common_val.calculate_total_qty(formula_id => l_formula_id,

286: CLOSE Cur_get_formula;
287:
288: -- S.Dulyk 1/8/02 added b/c calculate_total_qty wouldn't use p_uom
289: l_uom := p_uom;
290: gmd_common_val.calculate_total_qty(formula_id => l_formula_id,
291: x_product_qty => l_formula_output,
292: x_ingredient_qty => l_formula_input,
293: x_uom => l_uom,
294: x_return_status => l_return_status,

Line 1060: l_process_rec gmd_common_val.process_loss_rec;

1056: l_msg_data Varchar2(240);
1057: X_item_id NUMBER;
1058: X_detail_uom VARCHAR2(4);
1059: X_status VARCHAR2(100);
1060: l_process_rec gmd_common_val.process_loss_rec;
1061: UOM_CONVERSION_ERROR EXCEPTION;
1062: PROCESS_LOSS_ERR EXCEPTION;
1063: BEGIN
1064: x_contributing_qty := 0;

Line 1098: gmd_common_val.calculate_process_loss(process_loss => l_process_rec,

1094: END LOOP;
1095: /* Get process loss for this qty */
1096: l_process_rec.qty := X_contributing_qty;
1097: l_process_rec.recipe_id := p_recipe_id;
1098: gmd_common_val.calculate_process_loss(process_loss => l_process_rec,
1099: Entity_type => 'RECIPE' ,
1100: x_recipe_theo_loss => l_theo_process_loss,
1101: x_process_loss => l_process_loss,
1102: x_return_status => X_status,

Line 1616: GMD_COMMON_VAL.Calculate_total_qty(formula_id => l_form_rec.formula_id,

1612:
1613: IF l_form_rec.total_output_qty IS NULL THEN
1614: /* If the total output qty was not calculated previously let us recalculate it */
1615: l_uom := p_std_um;
1616: GMD_COMMON_VAL.Calculate_total_qty(formula_id => l_form_rec.formula_id,
1617: x_product_qty => l_total_output_qty,
1618: x_ingredient_qty => l_ing_qty,
1619: x_uom => l_uom,
1620: x_return_status => x_return_status,

Line 1629: GMD_COMMON_VAL.Calculate_total_qty(formula_id => l_form_rec.formula_id,

1625: l_uom := l_form_rec.yield_uom;
1626: END IF;
1627:
1628: /* Let us now fetch the total output qty based on the factor derived from std qty */
1629: GMD_COMMON_VAL.Calculate_total_qty(formula_id => l_form_rec.formula_id,
1630: x_product_qty => l_scaled_output_qty,
1631: x_ingredient_qty => l_ing_qty,
1632: x_uom => l_uom,
1633: x_return_status => x_return_status,