APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_COMMON_VAL

Line 740: l_charge_tbl GMD_COMMON_VAL.charge_tbl;

736: FROM gmd_recipes_b
737: WHERE recipe_id = p_recipe_id;
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);

Line 889: GMD_COMMON_VAL.Calculate_Charges(batch_id => 0,

885: Update_Step_Qty (l_routingstep_id, i);
886:
887: END LOOP;
888:
889: GMD_COMMON_VAL.Calculate_Charges(batch_id => 0,
890: recipe_id => p_recipe_id,
891: routing_id => l_routing_id,
892: VR_qty => 0,
893: Tolerance => 0,

Line 1067: l_charge_tbl GMD_COMMON_VAL.charge_tbl;

1063: x_charges_info OUT NOCOPY VARCHAR2,
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;

Line 1082: GMD_COMMON_VAL.Calculate_Step_Charges (p_recipe_id => p_recipe_id

1078: l_step_tbl(1).step_id := p_routingstep_id;
1079: l_step_tbl(1).step_qty := p_step_qty;
1080: l_step_tbl(1).step_qty_uom := p_step_um;
1081:
1082: GMD_COMMON_VAL.Calculate_Step_Charges (p_recipe_id => p_recipe_id
1083: ,p_tolerance => 0
1084: ,p_orgn_id => NULL
1085: ,p_step_tbl => l_step_tbl
1086: ,x_charge_tbl => l_charge_tbl

Line 1157: IF GMD_COMMON_VAL.Update_Allowed(entity => 'RECIPE',

1153: x_return_code := 'S';
1154: x_error_msg := '';
1155: x_recipe_mode := 'Q';
1156:
1157: IF GMD_COMMON_VAL.Update_Allowed(entity => 'RECIPE',
1158: entity_id => p_recipe_id) AND
1159: GMD_API_GRP.check_Orgn_Access(entity => 'RECIPE',
1160: entity_id => p_recipe_id) THEN
1161: x_recipe_mode := 'U';

Line 1202: l_charge_tbl GMD_COMMON_VAL.charge_tbl;

1198: gmd_recipes
1199: WHERE
1200: recipe_id = p_recipe_id;
1201:
1202: l_charge_tbl GMD_COMMON_VAL.charge_tbl;
1203: l_return_code VARCHAR2(1);
1204: l_routing_id NUMBER(10) := 0;
1205:
1206: BEGIN

Line 1216: GMD_COMMON_VAL.Calculate_Charges(batch_id => 0,

1212: OPEN Get_RoutingId;
1213: FETCH Get_RoutingId INTO l_routing_id;
1214: CLOSE Get_RoutingId;
1215:
1216: GMD_COMMON_VAL.Calculate_Charges(batch_id => 0,
1217: recipe_id => p_recipe_id,
1218: routing_id => l_routing_id,
1219: VR_qty => 0,
1220: Tolerance => 0,

Line 1536: l_charge_tbl GMD_COMMON_VAL.charge_tbl;

1532: WHERE
1533: recipe_id = p_recipe_id;
1534:
1535: l_routing_id NUMBER(10) := 0;
1536: l_charge_tbl GMD_COMMON_VAL.charge_tbl;
1537:
1538: l_msg_count NUMBER(10);
1539: l_return_status VARCHAR2(10);
1540: l_msg_stack VARCHAR2(1000);

Line 1572: GMD_COMMON_VAL.Calculate_Charges(batch_id => 0,

1568: x_return_code => l_ret_code,
1569: x_recipe_step_out => l_table);
1570:
1571:
1572: GMD_COMMON_VAL.Calculate_Charges(batch_id => 0,
1573: recipe_id => p_recipe_id,
1574: routing_id => l_routing_id,
1575: VR_qty => 0,
1576: Tolerance => 0,

Line 3046: l_process_loss_rec GMD_COMMON_VAL.process_loss_rec;

3042: l_msg_cnt NUMBER;
3043: l_msg_dat VARCHAR2(30);
3044: l_message VARCHAR2(1000);
3045: l_dummy NUMBER;
3046: l_process_loss_rec GMD_COMMON_VAL.process_loss_rec;
3047: l_recipe_theo_loss GMD_PROCESS_LOSS.process_loss%TYPE;
3048: PR_LOSS_EXCEPTION EXCEPTION;
3049:
3050: BEGIN

Line 3059: GMD_COMMON_VAL.Calculate_Process_Loss(process_loss => l_process_loss_rec,

3055:
3056: l_process_loss_rec.formula_id := p_formula_id;
3057: l_process_loss_rec.routing_id := p_routing_Id;
3058:
3059: GMD_COMMON_VAL.Calculate_Process_Loss(process_loss => l_process_loss_rec,
3060: Entity_type => 'RECIPE',
3061: x_recipe_theo_loss => l_recipe_theo_loss,
3062: x_process_loss => x_theoretical_loss,
3063: x_return_status => l_return_status,

Line 3947: l_routing_update_allowed := GMD_COMMON_VAL.UPDATE_ALLOWED(

3943: l_new_routing := TRUE;
3944: l_routing_update_allowed := TRUE;
3945: ELSE
3946: l_new_routing := FALSE;
3947: l_routing_update_allowed := GMD_COMMON_VAL.UPDATE_ALLOWED(
3948: Entity => 'ROUTING',
3949: Entity_id => l_rcp_hdr_rec.routing_id);
3950: END IF;
3951: