DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_TRANSFERS

Line 1288: FROM gme_batch_step_transfers_mig

1284: PROCEDURE create_batch_step_transfers(p_old_batch_id IN NUMBER,
1285: p_new_batch_id IN NUMBER) IS
1286: CURSOR Cur_step_txfrs IS
1287: SELECT *
1288: FROM gme_batch_step_transfers_mig
1289: WHERE batch_id = p_old_batch_id;
1290: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1291: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1292: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;

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

1286: CURSOR Cur_step_txfrs IS
1287: SELECT *
1288: FROM gme_batch_step_transfers_mig
1289: WHERE batch_id = p_old_batch_id;
1290: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1291: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1292: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;
1293: l_step_txfrs_tbl step_txfrs_tab;
1294: l_api_name VARCHAR2(30) := 'create_batch_step_transfers';

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

1288: FROM gme_batch_step_transfers_mig
1289: WHERE batch_id = p_old_batch_id;
1290: TYPE step_txfrs_mig_tab IS TABLE OF gme_batch_step_transfers_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1291: l_step_txfrs_mig_tbl step_txfrs_mig_tab;
1292: TYPE step_txfrs_tab IS TABLE OF gme_batch_step_transfers%ROWTYPE INDEX BY BINARY_INTEGER;
1293: l_step_txfrs_tbl step_txfrs_tab;
1294: l_api_name VARCHAR2(30) := 'create_batch_step_transfers';
1295: BEGIN
1296: IF (g_debug <= gme_debug.g_log_procedure) THEN

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

1348: l_step_txfrs_tbl(i).attribute_category := l_step_txfrs_mig_tbl(i).attribute_category;
1349: l_step_txfrs_tbl(i).trans_qty_um := l_step_txfrs_mig_tbl(i).trans_qty_um;
1350: END LOOP;
1351: FORALL a IN 1..l_step_txfrs_tbl.count
1352: INSERT INTO gme_batch_step_transfers VALUES l_step_txfrs_tbl(a);
1353: IF (g_debug <= gme_debug.g_log_procedure) THEN
1354: gme_debug.put_line('End procedure '||l_api_name);
1355: END IF;
1356: END create_batch_step_transfers;