[Home] [Help]
10: IS
11:
12: l_batch_id number;
13: NO_BATCH_FOUND_ERR exception;
14: cursor is_enhanced_pi is select count(*) from gme_batch_header where enhanced_pi_ind = 'Y' and batch_id = l_batch_id;
15: l_count number;
16: l_return_status varchar2(100);
17: l_msg_count number;
18: l_msg_data varchar2(4000);
294: l_msg_count number;
295: l_msg_data varchar2(4000);
296: k number;
297:
298: cursor c_get_batch_details is select a.batch_id, a.organization_id from gme_batch_header a, gme_batch_steps b where a.batch_id = b.batch_id and b.batchstep_id = p_batchstep_id;
299: cursor c_is_material_reqd_for_step is select count(*) from gme_batch_step_items where material_detail_id = l_material_detail_id and batchstep_id = p_batchstep_id;
300: BEGIN
301:
302: open c_get_batch_details;
1187: INVALID_ATTRIBUTE_ASSOC_ERR exception;
1188:
1189: cursor c_get_recipe is
1190: select grv.recipe_id
1191: from gme_batch_header gbh,
1192: gmd_recipe_validity_rules grv
1193: where gbh.recipe_validity_rule_id = grv.recipe_validity_rule_id and gbh.batch_id = p_entity_key;
1194:
1195: cursor c_get_steps is
1610: cursor get_material_detail is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where formulaline_id = l_formula_line_id and batch_id = l_batch_id;
1611: cursor get_material_detail_from_id is select batch_id, material_detail_id, inventory_item_id, line_no, line_type from gme_material_details where material_detail_id = l_material_detail_id;
1612: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_id;
1613:
1614: cursor get_org_detail is select a.organization_id, a.organization_code from mtl_parameters a, gme_batch_header b where a.organization_id = b.organization_id and b.batch_id = l_batch_id;
1615:
1616: GMO_INVALID_TASK_ERR exception;
1617: GMO_INSTR_TASK_PARAM_ERR exception;
1618: NO_BATCH_FOUND_ERR exception;