[Home] [Help]
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;
369:
370: IS PRAGMA AUTONOMOUS_TRANSACTION;
371:
372: l_batch_id number;
373: cursor c_get_batch_id is select batch_id from gme_batch_steps where batchstep_id = P_BATCHSTEP_ID;
374: STEP_ALREADY_LOCKED_ERR exception;
375: NO_BATCH_FOUND_ERR exception;
376:
377: BEGIN
448: IS PRAGMA AUTONOMOUS_TRANSACTION;
449:
450: l_batch_id number;
451: l_batchstep_id number;
452: cursor c_get_batch_id is select batch_id from gme_batch_steps where batchstep_id = l_batchstep_id;
453: STEP_ALREADY_LOCKED_ERR exception;
454: NO_BATCH_FOUND_ERR exception;
455:
456: BEGIN
688: IS
689:
690: l_batch_id number;
691:
692: cursor get_batch_id_for_step is select batch_id from gme_batch_steps where batchstep_id = p_entity_key;
693: cursor get_batch_id_for_resource is select batch_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
694: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
695: cursor get_batch_id_for_material is select batch_id from gme_material_details where material_detail_id = p_entity_key;
696:
1152: batchstep_id,
1153: routingstep_id,
1154: a.oprn_id,
1155: batchstep_no || '-' || b.oprn_no
1156: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
1157:
1158: cursor c_get_activities is
1159: select batchstep_activity_id,
1160: routingstep_id,
1160: routingstep_id,
1161: oprn_line_id ,
1162: activity
1163: from gme_batch_step_activities gbsa,
1164: gme_batch_steps gbs
1165: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
1166:
1167: cursor c_get_resources is
1168: select batchstep_resource_id,
1171: resources ,
1172: gbsa.activity || '-' || resources
1173: from gme_batch_step_resources gbsr,
1174: gme_batch_step_Activities gbsa,
1175: gme_batch_steps gbs
1176: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
1177: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
1178:
1179: cursor c_get_materials is
1549: l_invoke_mode varchar2(1);
1550:
1551: l_context_params_rec_type GMO_DATATYPES_GRP.CONTEXT_PARAMS_REC_TYPE;
1552:
1553: cursor get_step_detail is select batch_id, batchstep_id from gme_batch_steps where batchstep_id = l_batchstep_id;
1554:
1555: cursor get_activity_detail is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_id = l_batchstep_id and oprn_line_id = l_oprn_line_id;
1556: cursor get_activity_detail_from_id is select batch_id, batchstep_id, batchstep_activity_id from gme_batch_step_activities where batchstep_activity_id = l_batchstep_activity_id;
1557:
2063: l_msg_data varchar2(4000);
2064: instruction_create_err exception;
2065: instruction_nullify_err exception;
2066:
2067: cursor c_get_steps is select batchstep_id from gme_batch_steps where batch_id = p_entity_key;
2068:
2069: cursor c_get_activities is select batchstep_activity_id from gme_batch_step_activities where batch_id = p_entity_key;
2070:
2071: cursor c_get_resources is select batchstep_resource_id from gme_batch_step_resources where batch_id = p_entity_key;
2701: cursor get_step_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
2702: cursor get_step_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
2703: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
2704:
2705: cursor get_step_detail is select step_status from gme_batch_steps where batchstep_id = l_batchstep_id;
2706:
2707: no_step_found_err exception;
2708:
2709: BEGIN
2862: l_counter number;
2863: l_instr_count number;
2864:
2865: cursor c_get_oprn is select a.batchstep_no || '-' || oprn_no, batchstep_id from
2866: gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and
2867: batchstep_id= P_BATCHSTEP_ID and batch_id = P_BATCH_ID;
2868:
2869: cursor c_get_activity is select activity, batchstep_activity_id from
2870: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =
3055: batchstep_id,
3056: routingstep_id,
3057: a.oprn_id,
3058: batchstep_no || '-' || b.oprn_no
3059: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
3060:
3061: cursor c_get_activities is
3062: select batchstep_activity_id,
3063: routingstep_id,
3063: routingstep_id,
3064: oprn_line_id ,
3065: activity
3066: from gme_batch_step_activities gbsa,
3067: gme_batch_steps gbs
3068: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
3069:
3070: cursor c_get_resources is
3071: select batchstep_resource_id,
3074: resources ,
3075: gbsa.activity || '-' || resources
3076: from gme_batch_step_resources gbsr,
3077: gme_batch_step_Activities gbsa,
3078: gme_batch_steps gbs
3079: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
3080: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
3081:
3082: