DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_TRANSFERS

Line 1419: FROM gme_batch_step_transfers_mig

1415: PROCEDURE create_batch_step_transfers(p_old_batch_id IN NUMBER,
1416: p_new_batch_id IN NUMBER) IS
1417: CURSOR Cur_step_txfrs IS
1418: SELECT *
1419: FROM gme_batch_step_transfers_mig
1420: WHERE batch_id = p_old_batch_id;
1421: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1422: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1423: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1421: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;

1417: CURSOR Cur_step_txfrs IS
1418: SELECT *
1419: FROM gme_batch_step_transfers_mig
1420: WHERE batch_id = p_old_batch_id;
1421: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1422: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1423: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;
1424: l_step_txfrs_tbl step_txfrs_tab;
1425: l_api_name VARCHAR2(30) := 'create_batch_step_transfers';

Line 1423: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;

1419: FROM gme_batch_step_transfers_mig
1420: WHERE batch_id = p_old_batch_id;
1421: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1422: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1423: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;
1424: l_step_txfrs_tbl step_txfrs_tab;
1425: l_api_name VARCHAR2(30) := 'create_batch_step_transfers';
1426: BEGIN
1427: IF (g_debug <= gme_debug.g_log_procedure) THEN

Line 1483: INSERT INTO gme_batch_step_transfers VALUES l_step_txfrs_tbl(a);

1479: l_step_txfrs_tbl(i).attribute_category := l_step_txfrs_mig_tbl(i).attribute_category;
1480: l_step_txfrs_tbl(i).trans_qty_um := l_step_txfrs_mig_tbl(i).trans_qty_um;
1481: END LOOP;
1482: FORALL a IN 1..l_step_txfrs_tbl.count
1483: INSERT INTO gme_batch_step_transfers VALUES l_step_txfrs_tbl(a);
1484: IF (g_debug <= gme_debug.g_log_procedure) THEN
1485: gme_debug.put_line('End procedure '||l_api_name);
1486: END IF;
1487: END create_batch_step_transfers;