DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_RESOURCE_TXNS

Line 20: TYPE rsrc_txns_mig_tab IS TABLE OF gme_resource_txns_mig%ROWTYPE INDEX BY BINARY_INTEGER;

16: TYPE activ_mig_tab IS TABLE OF gme_batch_step_activ_mig%ROWTYPE INDEX BY BINARY_INTEGER;
17: TYPE rsrc_mig_tab IS TABLE OF gme_batch_step_resources_mig%ROWTYPE INDEX BY BINARY_INTEGER;
18: TYPE process_param_mig_tab IS TABLE OF gme_process_parameters_mig%ROWTYPE INDEX BY BINARY_INTEGER;
19: TYPE process_param_tab IS TABLE OF gme_process_parameters%ROWTYPE INDEX BY BINARY_INTEGER;
20: TYPE rsrc_txns_mig_tab IS TABLE OF gme_resource_txns_mig%ROWTYPE INDEX BY BINARY_INTEGER;
21: TYPE rsrc_txns_tab IS TABLE OF gme_resource_txns%ROWTYPE INDEX BY BINARY_INTEGER;
22: /* Bug 5620671 Added param completed ind */
23: CURSOR Cur_get_txns(v_completed_ind NUMBER) IS
24: SELECT p.*, m.new_batch_id, m.organization_id, m.new_batch_no, m.plant_code

Line 21: TYPE rsrc_txns_tab IS TABLE OF gme_resource_txns%ROWTYPE INDEX BY BINARY_INTEGER;

17: TYPE rsrc_mig_tab IS TABLE OF gme_batch_step_resources_mig%ROWTYPE INDEX BY BINARY_INTEGER;
18: TYPE process_param_mig_tab IS TABLE OF gme_process_parameters_mig%ROWTYPE INDEX BY BINARY_INTEGER;
19: TYPE process_param_tab IS TABLE OF gme_process_parameters%ROWTYPE INDEX BY BINARY_INTEGER;
20: TYPE rsrc_txns_mig_tab IS TABLE OF gme_resource_txns_mig%ROWTYPE INDEX BY BINARY_INTEGER;
21: TYPE rsrc_txns_tab IS TABLE OF gme_resource_txns%ROWTYPE INDEX BY BINARY_INTEGER;
22: /* Bug 5620671 Added param completed ind */
23: CURSOR Cur_get_txns(v_completed_ind NUMBER) IS
24: SELECT p.*, m.new_batch_id, m.organization_id, m.new_batch_no, m.plant_code
25: FROM gme_batch_txns_mig t, gme_batch_mapping_mig m, ic_tran_pnd p