DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_DEP_MIG

Line 1264: FROM gme_batch_step_dep_mig

1260: PROCEDURE create_step_dependencies(p_old_batch_id IN NUMBER,
1261: p_new_batch_id IN NUMBER) IS
1262: CURSOR Cur_get_deps(v_batch_id NUMBER) IS
1263: SELECT *
1264: FROM gme_batch_step_dep_mig
1265: WHERE batch_id = v_batch_id;
1266: TYPE step_dep_mig_tab IS TABLE OF gme_batch_step_dep_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1267: l_step_dep_mig_tbl step_dep_mig_tab;
1268: TYPE step_dep_tab IS TABLE OF gme_batch_step_dependencies%ROWTYPE INDEX BY BINARY_INTEGER;

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

1262: CURSOR Cur_get_deps(v_batch_id NUMBER) IS
1263: SELECT *
1264: FROM gme_batch_step_dep_mig
1265: WHERE batch_id = v_batch_id;
1266: TYPE step_dep_mig_tab IS TABLE OF gme_batch_step_dep_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1267: l_step_dep_mig_tbl step_dep_mig_tab;
1268: TYPE step_dep_tab IS TABLE OF gme_batch_step_dependencies%ROWTYPE INDEX BY BINARY_INTEGER;
1269: l_step_dep_tbl step_dep_tab;
1270: l_api_name VARCHAR2(30) := 'create_step_dependencies';