[Home] [Help]
24: -- either plain or non-plain with 0 qty. Here, for 0 qty completed, the
25: -- transaction can be flipped to pending. For non-zero completed plain, a
26: -- 0 qty pending transaction is inserted. insert_batch_step_dtls performs
27: -- batch by batch processing in order to normalize pm_oprn_dtl
28: -- into gme_batch_step_activities and gme_batch_step_resources.
29: --
30: -- The main package to call is migrate_batch.run. If it is called with no parameters,
31: -- or as migrate_batch.run(p_commit => FALSE) a rollback is performed at the end of the
32: -- migration. This is for purposes of validation, so that the user can find all data
353:
354: FUNCTION get_actual_activity_factor (
355: p_batchstep_id IN gme_batch_steps.batchstep_id%TYPE
356: )
357: RETURN gme_batch_step_activities.actual_activity_factor%TYPE IS
358: l_step_status gme_batch_steps.step_status%TYPE;
359: l_pos NUMBER := 0;
360: BEGIN
361: l_pos := 1;
637: batchstep_no = p_batchstep_no;
638: l_pos := 2;
639: SELECT batchstep_activity_id
640: INTO v_activity_id
641: FROM gme_batch_step_activities
642: WHERE batch_id = p_batch_id AND
643: batchstep_id = v_step_id AND
644: activity = p_activity;
645: l_pos := 3;
646: RETURN v_activity_id;
647: EXCEPTION
648: WHEN OTHERS THEN
649: insert_message (
650: p_table_name => 'gme_batch_steps, gme_batch_step_activities',
651: p_procedure_name => 'get_activity_id',
652: p_parameters => 'batch_id = '
653: || p_batch_id
654: || ' batchstep_no = '
673: BEGIN
674: l_pos := 1;
675: SELECT offset_interval
676: INTO l_act_offset
677: FROM gme_batch_step_activities
678: WHERE activity = p_activity AND
679: batch_id = p_batch_id AND
680: batchstep_id = (SELECT batchstep_id
681: FROM gme_batch_steps
685: RETURN p_offset - l_act_offset;
686: EXCEPTION
687: WHEN OTHERS THEN
688: insert_message (
689: p_table_name => 'gme_batch_step_activities',
690: p_procedure_name => 'get_rsrc_offset',
691: p_parameters => 'batch_id = '
692: || p_batch_id
693: || ' batchstep_no = '
3082: );
3083: -- Take the first one that comes back if there are more than 1 resulting from this CURSOR.
3084: FETCH get_oprn_dtl INTO v_oprn_dtl;
3085:
3086: INSERT INTO gme_batch_step_activities
3087: (batch_id,
3088: activity,
3089: batchstep_id,
3090: batchstep_activity_id,
3141: END LOOP;
3142:
3143: CLOSE get_activities;
3144: insert_message (
3145: p_table_name => 'gme_batch_step_activities',
3146: p_procedure_name => 'insert_batch_step_dtls',
3147: p_parameters => 'none',
3148: p_message => 'number of records inserted = ' || l_act_cnt,
3149: p_error_type => 'P'