DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_ITEMS_MIG

Line 1340: FROM gme_batch_step_items_mig

1336: PROCEDURE create_item_step_assoc(p_old_batch_id IN NUMBER,
1337: p_new_batch_id IN NUMBER) IS
1338: CURSOR Cur_item_assocs IS
1339: SELECT *
1340: FROM gme_batch_step_items_mig
1341: WHERE batch_id = p_old_batch_id;
1342: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1343: l_item_step_mig_tbl item_step_mig_tab;
1344: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1342: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;

1338: CURSOR Cur_item_assocs IS
1339: SELECT *
1340: FROM gme_batch_step_items_mig
1341: WHERE batch_id = p_old_batch_id;
1342: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1343: l_item_step_mig_tbl item_step_mig_tab;
1344: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;
1345: l_item_step_tbl item_step_tab;
1346: l_api_name VARCHAR2(30) := 'create_item_step_assoc';