80: ,v_activity VARCHAR2
81: ,v_batch_id NUMBER)
82: IS
83: SELECT batchstep_activity_id
84: FROM gme_batch_step_activities
85: WHERE batchstep_id = v_step_id
86: AND batch_id = v_batch_id
87: AND activity = v_activity;
88:
331:
332: CURSOR cur_get_step_dtl_from_act (v_act_id NUMBER)
333: IS
334: SELECT a.step_status, a.batch_id, a.step_qty_um
335: FROM gme_batch_steps a, gme_batch_step_activities b
336: WHERE b.batchstep_activity_id = v_act_id
337: AND a.batch_id = b.batch_id
338: AND a.batchstep_id = b.batchstep_id;
339:
343: ,1, plan_activity_factor
344: ,actual_activity_factor)
345: ,plan_start_date, plan_cmplt_date, actual_start_date
346: ,actual_cmplt_date
347: FROM gme_batch_step_activities
348: WHERE batchstep_activity_id = v_activity_id;
349:
350: CURSOR cur_get_activity_detail (v_activity_id NUMBER)
351: IS
349:
350: CURSOR cur_get_activity_detail (v_activity_id NUMBER)
351: IS
352: SELECT plan_start_date, plan_cmplt_date
353: FROM gme_batch_step_activities
354: WHERE batchstep_activity_id = v_activity_id;
355:
356: CURSOR cur_get_batch_asqc (v_batch_id NUMBER)
357: IS
2067: CURSOR cur_get_act_dates
2068: IS
2069: SELECT plan_start_date, plan_cmplt_date, actual_start_date
2070: ,actual_cmplt_date
2071: FROM gme_batch_step_activities
2072: WHERE batchstep_activity_id = p_batchstep_activity_id;
2073: BEGIN
2074: IF g_debug <= gme_debug.g_log_procedure THEN
2075: gme_debug.put_line ('Entering api ' ||