DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GME_PROCESS_PARAMETERS

Line 109: FROM gme_process_parameters_mig

105:
106: -- Bug 13706812 - Use old batch id to make use of index.
107: CURSOR Cur_get_process_params(v_batchstep_resource_id NUMBER, v_old_batch_id NUMBER) IS
108: SELECT *
109: FROM gme_process_parameters_mig
110: WHERE batchstep_resource_id = v_batchstep_resource_id
111: AND batch_id = v_old_batch_id;
112:
113: -- Bug 13706812 - Use old batch id to make use of index.

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

397: IF (g_debug <= gme_debug.g_log_statement) THEN
398: gme_debug.put_line('No. of process params = '||l_proc_param_mig_tbl.count);
399: END IF;
400: FOR m IN (l_pprm_count + 1)..l_proc_param_tbl.count LOOP
401: SELECT gme_process_parameters_id_s.NEXTVAL INTO l_proc_param_tbl(m).process_param_id FROM DUAL;
402: l_proc_param_tbl(m).batch_id := l_batch_header.batch_id;
403: l_proc_param_tbl(m).batchstep_id := l_steps_tbl(i).batchstep_id;
404: l_proc_param_tbl(m).batchstep_activity_id := l_activities_tbl(j).batchstep_activity_id;
405: l_proc_param_tbl(m).batchstep_resource_id := l_resources_tbl(k).batchstep_resource_id;

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

445: IF (g_debug <= gme_debug.g_log_statement) THEN
446: gme_debug.put_line('After insert resources');
447: END IF;
448: FORALL a IN 1..l_proc_param_tbl.count
449: INSERT INTO gme_process_parameters VALUES l_proc_param_tbl(a);
450: IF (g_debug <= gme_debug.g_log_statement) THEN
451: gme_debug.put_line('After insert process params');
452: END IF;
453: FORALL a IN 1..l_rsrc_txns_tbl.count