2408: x_loss_id OUT NOCOPY NUMBER,
2409: x_return_code OUT NOCOPY VARCHAR2,
2410: x_error_msg OUT NOCOPY VARCHAR2) IS
2411: CURSOR Cur_loss_id IS
2412: SELECT gmd_recipe_process_loss_id_s.NEXTVAL
2413: FROM SYS.DUAL;
2414:
2415: l_loss_tbl GMD_RECIPE_DETAIL.recipe_dtl;
2416: l_status VARCHAR2(30);
3299: SELECT gmd_recipe_id_s.NEXTVAL
3300: FROM FND_DUAL;
3301:
3302: CURSOR Cur_loss_id IS
3303: SELECT gmd_recipe_process_loss_id_s.NEXTVAL
3304: FROM FND_DUAL;
3305:
3306: CURSOR Cur_vr_id IS
3307: SELECT gmd_recipe_validity_id_s.NEXTVAL