DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_CHARGES

Line 1379: FROM gme_batch_step_charges_mig

1375: PROCEDURE create_batch_step_charges(p_old_batch_id IN NUMBER,
1376: p_new_batch_id IN NUMBER) IS
1377: CURSOR Cur_step_charges IS
1378: SELECT *
1379: FROM gme_batch_step_charges_mig
1380: WHERE batch_id = p_old_batch_id;
1381: TYPE step_chrg_mig_tab IS TABLE OF gme_batch_step_charges_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1382: l_step_chrg_mig_tbl step_chrg_mig_tab;
1383: TYPE step_chrg_tab IS TABLE OF gme_batch_step_charges%ROWTYPE INDEX BY BINARY_INTEGER;

Line 1381: TYPE step_chrg_mig_tab IS TABLE OF gme_batch_step_charges_mig%ROWTYPE INDEX BY BINARY_INTEGER;

1377: CURSOR Cur_step_charges IS
1378: SELECT *
1379: FROM gme_batch_step_charges_mig
1380: WHERE batch_id = p_old_batch_id;
1381: TYPE step_chrg_mig_tab IS TABLE OF gme_batch_step_charges_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1382: l_step_chrg_mig_tbl step_chrg_mig_tab;
1383: TYPE step_chrg_tab IS TABLE OF gme_batch_step_charges%ROWTYPE INDEX BY BINARY_INTEGER;
1384: l_step_chrg_tbl step_chrg_tab;
1385: l_api_name VARCHAR2(30) := 'create_batch_step_charges';

Line 1383: TYPE step_chrg_tab IS TABLE OF gme_batch_step_charges%ROWTYPE INDEX BY BINARY_INTEGER;

1379: FROM gme_batch_step_charges_mig
1380: WHERE batch_id = p_old_batch_id;
1381: TYPE step_chrg_mig_tab IS TABLE OF gme_batch_step_charges_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1382: l_step_chrg_mig_tbl step_chrg_mig_tab;
1383: TYPE step_chrg_tab IS TABLE OF gme_batch_step_charges%ROWTYPE INDEX BY BINARY_INTEGER;
1384: l_step_chrg_tbl step_chrg_tab;
1385: l_api_name VARCHAR2(30) := 'create_batch_step_charges';
1386: BEGIN
1387: IF (g_debug <= gme_debug.g_log_procedure) THEN

Line 1409: INSERT INTO gme_batch_step_charges VALUES l_step_chrg_tbl(a);

1405: l_step_chrg_tbl(i).last_update_login := l_step_chrg_mig_tbl(i).last_update_login;
1406: l_step_chrg_tbl(i).last_update_date := l_step_chrg_mig_tbl(i).last_update_date;
1407: END LOOP;
1408: FORALL a IN 1..l_step_chrg_tbl.count
1409: INSERT INTO gme_batch_step_charges VALUES l_step_chrg_tbl(a);
1410: IF (g_debug <= gme_debug.g_log_procedure) THEN
1411: gme_debug.put_line('End procedure '||l_api_name);
1412: END IF;
1413: END create_batch_step_charges;