DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_DEP_MIG

Line 1133: FROM gme_batch_step_dep_mig

1129: PROCEDURE create_step_dependencies(p_old_batch_id IN NUMBER,
1130: p_new_batch_id IN NUMBER) IS
1131: CURSOR Cur_get_deps(v_batch_id NUMBER) IS
1132: SELECT *
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;

Line 1135: TYPE step_dep_mig_tab IS TABLE OF gme_batch_step_dep_mig%ROWTYPE INDEX BY BINARY_INTEGER;

1131: CURSOR Cur_get_deps(v_batch_id NUMBER) IS
1132: SELECT *
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';