[Home] [Help]
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;
414:
415: IS PRAGMA AUTONOMOUS_TRANSACTION;
416:
417: l_batch_id number;
418: cursor c_get_batch_id is select batch_id from gme_batch_steps where batchstep_id = P_BATCHSTEP_ID;
419: STEP_ALREADY_LOCKED_ERR exception;
420: NO_BATCH_FOUND_ERR exception;
421:
422: BEGIN
493: IS PRAGMA AUTONOMOUS_TRANSACTION;
494:
495: l_batch_id number;
496: l_batchstep_id number;
497: cursor c_get_batch_id is select batch_id from gme_batch_steps where batchstep_id = l_batchstep_id;
498: STEP_ALREADY_LOCKED_ERR exception;
499: NO_BATCH_FOUND_ERR exception;
500:
501: BEGIN
733: IS
734:
735: l_batch_id number;
736:
737: cursor get_batch_id_for_step is select batch_id from gme_batch_steps where batchstep_id = p_entity_key;
738: cursor get_batch_id_for_resource is select batch_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
739: cursor get_batch_id_for_activity is select batch_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
740: cursor get_batch_id_for_material is select batch_id from gme_material_details where material_detail_id = p_entity_key;
741:
1197: batchstep_id,
1198: routingstep_id,
1199: a.oprn_id,
1200: batchstep_no || '-' || b.oprn_no
1201: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
1202:
1203: cursor c_get_activities is
1204: select batchstep_activity_id,
1205: routingstep_id,
1205: routingstep_id,
1206: oprn_line_id ,
1207: activity
1208: from gme_batch_step_activities gbsa,
1209: gme_batch_steps gbs
1210: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
1211:
1212: cursor c_get_resources is
1213: select batchstep_resource_id,
1216: resources ,
1217: gbsa.activity || '-' || resources
1218: from gme_batch_step_resources gbsr,
1219: gme_batch_step_Activities gbsa,
1220: gme_batch_steps gbs
1221: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
1222: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
1223:
1224: cursor c_get_materials is
1594: l_invoke_mode varchar2(1);
1595:
1596: l_context_params_rec_type GMO_DATATYPES_GRP.CONTEXT_PARAMS_REC_TYPE;
1597:
1598: cursor get_step_detail is select batch_id, batchstep_id from gme_batch_steps where batchstep_id = l_batchstep_id;
1599:
1600: 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;
1601: 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;
1602:
2108: l_msg_data varchar2(4000);
2109: instruction_create_err exception;
2110: instruction_nullify_err exception;
2111:
2112: cursor c_get_steps is select batchstep_id from gme_batch_steps where batch_id = p_entity_key;
2113:
2114: cursor c_get_activities is select batchstep_activity_id from gme_batch_step_activities where batch_id = p_entity_key;
2115:
2116: cursor c_get_resources is select batchstep_resource_id from gme_batch_step_resources where batch_id = p_entity_key;
2746: cursor get_step_id_for_resource is select batchstep_id from gme_batch_step_resources where batchstep_resource_id = p_entity_key;
2747: cursor get_step_id_for_activity is select batchstep_id from gme_batch_step_activities where batchstep_activity_id = p_entity_key;
2748: cursor get_step_id_for_material is select batchstep_id from gme_batch_step_items where material_detail_id = p_entity_key;
2749:
2750: cursor get_step_detail is select step_status from gme_batch_steps where batchstep_id = l_batchstep_id;
2751:
2752: no_step_found_err exception;
2753:
2754: BEGIN
2907: l_counter number;
2908: l_instr_count number;
2909:
2910: cursor c_get_oprn is select a.batchstep_no || '-' || oprn_no, batchstep_id from
2911: gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and
2912: batchstep_id= P_BATCHSTEP_ID and batch_id = P_BATCH_ID;
2913:
2914: cursor c_get_activity is select activity, batchstep_activity_id from
2915: gme_batch_step_activities where batchstep_id=P_BATCHSTEP_ID and batch_id =
3100: batchstep_id,
3101: routingstep_id,
3102: a.oprn_id,
3103: batchstep_no || '-' || b.oprn_no
3104: from gme_batch_steps a, gmd_operations_b b where a.oprn_id = b.oprn_id and batch_id = p_entity_key;
3105:
3106: cursor c_get_activities is
3107: select batchstep_activity_id,
3108: routingstep_id,
3108: routingstep_id,
3109: oprn_line_id ,
3110: activity
3111: from gme_batch_step_activities gbsa,
3112: gme_batch_steps gbs
3113: where gbsa.batchstep_id = gbs.batchstep_id and gbsa.batch_id = p_entity_key;
3114:
3115: cursor c_get_resources is
3116: select batchstep_resource_id,
3119: resources ,
3120: gbsa.activity || '-' || resources
3121: from gme_batch_step_resources gbsr,
3122: gme_batch_step_Activities gbsa,
3123: gme_batch_steps gbs
3124: where gbsa.batchstep_activity_id = gbsr.batchstep_activity_id
3125: and gbsa.batchstep_id = gbs.batchstep_id and gbsr.batch_id = p_entity_key;
3126:
3127: