DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_PROCESS_PARAMETERS

Line 92: FROM gme_process_parameters_mig

88: FROM gme_batch_step_resources_mig
89: WHERE batchstep_id = v_batchstep_activity_id;
90: CURSOR Cur_get_process_params(v_batchstep_resource_id NUMBER) IS
91: SELECT *
92: FROM gme_process_parameters_mig
93: WHERE batchstep_resource_id = v_batchstep_resource_id;
94: CURSOR Cur_get_rsrc_txns(v_batchstep_rsrc_id NUMBER) IS
95: SELECT *
96: FROM gme_resource_txns_mig

Line 307: SELECT gme_process_parameters_id_s.NEXTVAL INTO l_proc_param_tbl(m).process_param_id FROM DUAL;

303: IF (g_debug <= gme_debug.g_log_statement) THEN
304: gme_debug.put_line('No. of process params = '||l_proc_param_mig_tbl.count);
305: END IF;
306: FOR m IN (l_pprm_count + 1)..l_proc_param_tbl.count LOOP
307: SELECT gme_process_parameters_id_s.NEXTVAL INTO l_proc_param_tbl(m).process_param_id FROM DUAL;
308: l_proc_param_tbl(m).batch_id := l_batch_header.batch_id;
309: l_proc_param_tbl(m).batchstep_id := l_steps_tbl(i).batchstep_id;
310: l_proc_param_tbl(m).batchstep_activity_id := l_activities_tbl(j).batchstep_activity_id;
311: l_proc_param_tbl(m).batchstep_resource_id := l_resources_tbl(k).batchstep_resource_id;

Line 350: INSERT INTO gme_process_parameters VALUES l_proc_param_tbl(a);

346: IF (g_debug <= gme_debug.g_log_statement) THEN
347: gme_debug.put_line('After insert resources');
348: END IF;
349: FORALL a IN 1..l_proc_param_tbl.count
350: INSERT INTO gme_process_parameters VALUES l_proc_param_tbl(a);
351: IF (g_debug <= gme_debug.g_log_statement) THEN
352: gme_debug.put_line('After insert process params');
353: END IF;
354: FORALL a IN 1..l_rsrc_txns_tbl.count