DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_BATCH_STEP_CHARGES

Line 1248: FROM gme_batch_step_charges_mig

1244: PROCEDURE create_batch_step_charges(p_old_batch_id IN NUMBER,
1245: p_new_batch_id IN NUMBER) IS
1246: CURSOR Cur_step_charges IS
1247: SELECT *
1248: FROM gme_batch_step_charges_mig
1249: WHERE batch_id = p_old_batch_id;
1250: TYPE step_chrg_mig_tab IS TABLE OF gme_batch_step_charges_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1251: l_step_chrg_mig_tbl step_chrg_mig_tab;
1252: TYPE step_chrg_tab IS TABLE OF gme_batch_step_charges%ROWTYPE INDEX BY BINARY_INTEGER;

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

1246: CURSOR Cur_step_charges IS
1247: SELECT *
1248: FROM gme_batch_step_charges_mig
1249: WHERE batch_id = p_old_batch_id;
1250: TYPE step_chrg_mig_tab IS TABLE OF gme_batch_step_charges_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1251: l_step_chrg_mig_tbl step_chrg_mig_tab;
1252: TYPE step_chrg_tab IS TABLE OF gme_batch_step_charges%ROWTYPE INDEX BY BINARY_INTEGER;
1253: l_step_chrg_tbl step_chrg_tab;
1254: l_api_name VARCHAR2(30) := 'create_batch_step_charges';

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

1248: FROM gme_batch_step_charges_mig
1249: WHERE batch_id = p_old_batch_id;
1250: TYPE step_chrg_mig_tab IS TABLE OF gme_batch_step_charges_mig%ROWTYPE INDEX BY BINARY_INTEGER;
1251: l_step_chrg_mig_tbl step_chrg_mig_tab;
1252: TYPE step_chrg_tab IS TABLE OF gme_batch_step_charges%ROWTYPE INDEX BY BINARY_INTEGER;
1253: l_step_chrg_tbl step_chrg_tab;
1254: l_api_name VARCHAR2(30) := 'create_batch_step_charges';
1255: BEGIN
1256: IF (g_debug <= gme_debug.g_log_procedure) THEN

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

1274: l_step_chrg_tbl(i).last_update_login := l_step_chrg_mig_tbl(i).last_update_login;
1275: l_step_chrg_tbl(i).last_update_date := l_step_chrg_mig_tbl(i).last_update_date;
1276: END LOOP;
1277: FORALL a IN 1..l_step_chrg_tbl.count
1278: INSERT INTO gme_batch_step_charges VALUES l_step_chrg_tbl(a);
1279: IF (g_debug <= gme_debug.g_log_procedure) THEN
1280: gme_debug.put_line('End procedure '||l_api_name);
1281: END IF;
1282: END create_batch_step_charges;