DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_DEPENDENCIES

Line 1137: TYPE step_dep_tab IS TABLE OF gme_batch_step_dependencies%ROWTYPE INDEX BY BINARY_INTEGER;

1133: FROM gme_batch_step_dep_mig
1134: WHERE batch_id = v_batch_id;
1135: TYPE step_dep_mig_tab IS TABLE OF gme_batch_step_dep_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1136: l_step_dep_mig_tbl step_dep_mig_tab;
1137: TYPE step_dep_tab IS TABLE OF gme_batch_step_dependencies%ROWTYPE INDEX BY BINARY_INTEGER;
1138: l_step_dep_tbl step_dep_tab;
1139: l_api_name VARCHAR2(30) := 'create_step_dependencies';
1140: BEGIN
1141: IF (g_debug <= gme_debug.g_log_procedure) THEN

Line 1199: INSERT INTO gme_batch_step_dependencies VALUES l_step_dep_tbl(a);

1195: l_step_dep_tbl(i).attribute_category := l_step_dep_mig_tbl(i).attribute_category;
1196: l_step_dep_tbl(i).chargeable_ind := l_step_dep_mig_tbl(i).chargeable_ind;
1197: END LOOP;
1198: FORALL a IN 1..l_step_dep_tbl.count
1199: INSERT INTO gme_batch_step_dependencies VALUES l_step_dep_tbl(a);
1200: IF (g_debug <= gme_debug.g_log_procedure) THEN
1201: gme_debug.put_line('End procedure '||l_api_name);
1202: END IF;
1203: END create_step_dependencies;