[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);
249: l_msg_count number;
250: l_msg_data varchar2(4000);
251: k number;
252:
253: 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;
254: 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;
255: BEGIN
256:
257: open c_get_batch_details;
1142: INVALID_ATTRIBUTE_ASSOC_ERR exception;
1143:
1144: cursor c_get_recipe is
1145: select grv.recipe_id
1146: from gme_batch_header gbh,
1147: gmd_recipe_validity_rules grv
1148: where gbh.recipe_validity_rule_id = grv.recipe_validity_rule_id and gbh.batch_id = p_entity_key;
1149:
1150: cursor c_get_steps is
1565: 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;
1566: 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;
1567: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = l_material_detail_id;
1568:
1569: 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;
1570:
1571: GMO_INVALID_TASK_ERR exception;
1572: GMO_INSTR_TASK_PARAM_ERR exception;
1573: NO_BATCH_FOUND_ERR exception;