DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_ITEMS_MIG

Line 1209: FROM gme_batch_step_items_mig

1205: PROCEDURE create_item_step_assoc(p_old_batch_id IN NUMBER,
1206: p_new_batch_id IN NUMBER) IS
1207: CURSOR Cur_item_assocs IS
1208: SELECT *
1209: FROM gme_batch_step_items_mig
1210: WHERE batch_id = p_old_batch_id;
1211: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1212: l_item_step_mig_tbl item_step_mig_tab;
1213: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;

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

1207: CURSOR Cur_item_assocs IS
1208: SELECT *
1209: FROM gme_batch_step_items_mig
1210: WHERE batch_id = p_old_batch_id;
1211: TYPE item_step_mig_tab IS TABLE OF gme_batch_step_items_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1212: l_item_step_mig_tbl item_step_mig_tab;
1213: TYPE item_step_tab IS TABLE OF gme_batch_step_items%ROWTYPE INDEX BY BINARY_INTEGER;
1214: l_item_step_tbl item_step_tab;
1215: l_api_name VARCHAR2(30) := 'create_item_step_assoc';