738:
739: l_routing_id NUMBER(10) := 0;
740: l_charge_tbl GMD_COMMON_VAL.charge_tbl;
741:
742: l_step_tbl GMD_AUTO_STEP_CALC.step_rec_tbl;
743: l_msg_count NUMBER(10);
744: l_return_status VARCHAR2(10);
745: l_msg_stack VARCHAR2(1000);
746: l_message VARCHAR2(2000);
859: CLOSE Get_RoutingId;
860:
861: /* Bug 3609776 - Thomas Daniel */
862: /* Added parameters ignore mass volume conv and process loss to the auto step calc call*/
863: GMD_AUTO_STEP_CALC.calc_step_qty (
864: P_parent_id => p_recipe_id,
865: P_step_tbl => l_step_tbl,
866: P_msg_count => l_msg_count,
867: P_msg_stack => l_msg_stack,
1064: x_return_code OUT NOCOPY VARCHAR2,
1065: x_error_msg OUT NOCOPY VARCHAR2) IS
1066:
1067: l_charge_tbl GMD_COMMON_VAL.charge_tbl;
1068: l_step_tbl GMD_AUTO_STEP_CALC.step_rec_tbl;
1069: l_return_code VARCHAR2(1);
1070: l_message VARCHAR2(2000);
1071: l_temp NUMBER;
1072:
1312: WHERE
1313: routing_id = c_routing_id AND
1314: routingstep_no = c_routingstep_no;
1315:
1316: l_step_tbl GMD_AUTO_STEP_CALC.step_rec_tbl;
1317: l_routingstep_id NUMBER(10);
1318: l_msg_count NUMBER(10);
1319: l_return_status VARCHAR2(10);
1320: l_msg_stack VARCHAR2(1000);
1334:
1335: x_return_code := 'S';
1336: x_error_msg := '';
1337:
1338: GMD_AUTO_STEP_CALC.Check_Step_Qty_Calculatable (
1339: P_parent_id => p_recipe_id,
1340: P_msg_count => l_msg_count,
1341: P_msg_stack => l_msg_stack,
1342: P_return_status => l_return_status);
1344: IF (l_return_status <> 'S') THEN
1345: RAISE STEP_QTY_ERROR;
1346: END IF;
1347:
1348: GMD_AUTO_STEP_CALC.calc_step_qty (
1349: P_parent_id => p_recipe_id,
1350: P_step_tbl => l_step_tbl,
1351: P_msg_count => l_msg_count,
1352: P_msg_stack => l_msg_stack,
3113: l_return_status VARCHAR2(2);
3114: l_msg_cnt NUMBER;
3115: l_msg_dat VARCHAR2(2000);
3116: l_dummy NUMBER;
3117: l_check GMD_AUTO_STEP_CALC.calculatable_rec_type;
3118: l_ignore_mass_cv BOOLEAN;
3119: l_ignore_vol_cv BOOLEAN;
3120: CAL_QTY_EXCEPTION EXCEPTION;
3121:
3125: x_return_code := 'S';
3126:
3127: l_check.parent_id := p_recipe_id;
3128:
3129: GMD_AUTO_STEP_CALC.check_step_qty_calculatable (
3130: p_check => l_check,
3131: p_msg_count => l_msg_cnt,
3132: p_msg_stack => l_msg_dat,
3133: p_return_status => l_return_status,