DBA Data[Home] [Help]

APPS.GMD_VALIDITY_RULES dependencies on GMD_COMMON_VAL

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

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

Line 1038: l_process_rec gmd_common_val.process_loss_rec;

1034: l_msg_data Varchar2(240);
1035: X_item_id NUMBER;
1036: X_detail_uom VARCHAR2(4);
1037: X_status VARCHAR2(100);
1038: l_process_rec gmd_common_val.process_loss_rec;
1039: UOM_CONVERSION_ERROR EXCEPTION;
1040: PROCESS_LOSS_ERR EXCEPTION;
1041: BEGIN
1042: x_contributing_qty := 0;

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

1072: END LOOP;
1073: /* Get process loss for this qty */
1074: l_process_rec.qty := X_contributing_qty;
1075: l_process_rec.recipe_id := p_recipe_id;
1076: gmd_common_val.calculate_process_loss(process_loss => l_process_rec,
1077: Entity_type => 'RECIPE' ,
1078: x_recipe_theo_loss => l_theo_process_loss,
1079: x_process_loss => l_process_loss,
1080: x_return_status => X_status,

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

1590:
1591: IF l_form_rec.total_output_qty IS NULL THEN
1592: /* If the total output qty was not calculated previously let us recalculate it */
1593: l_uom := p_std_um;
1594: GMD_COMMON_VAL.Calculate_total_qty(formula_id => l_form_rec.formula_id,
1595: x_product_qty => l_total_output_qty,
1596: x_ingredient_qty => l_ing_qty,
1597: x_uom => l_uom,
1598: x_return_status => x_return_status,

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

1603: l_uom := l_form_rec.yield_uom;
1604: END IF;
1605:
1606: /* Let us now fetch the total output qty based on the factor derived from std qty */
1607: GMD_COMMON_VAL.Calculate_total_qty(formula_id => l_form_rec.formula_id,
1608: x_product_qty => l_scaled_output_qty,
1609: x_ingredient_qty => l_ing_qty,
1610: x_uom => l_uom,
1611: x_return_status => x_return_status,