DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on PJI_UTILS

Line 250: -- Pji_utils.set_parameter('PJI_FPM_UPGRADE', NULL);

246: -- TB deleted after testing.
247: --
248: -- fnd_profile.put('PJI_SUM_CLEANALL', 'Y');
249: -- pji_pjp_extraction_utils.truncate_pjp_tables(v1,v2,'Y');
250: -- Pji_utils.set_parameter('PJI_FPM_UPGRADE', NULL);
251:
252:
253: --
254: -- Initialize variables..

Line 265: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;

261: -- Valid values are P (partial), C (complete).
262:
263: l_worker_id := 1;
264: l_process := PJI_PJP_SUM_MAIN.g_process || l_worker_id;
265: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
266: l_fpm_upgr_status := Pji_utils.get_parameter(c_upgr_proc_name);
267: l_count := l_count + 1;
268: print_time('FPM Upgr y ' || l_count || ' l_fpm_upgr_status ' || l_fpm_upgr_status );
269:

Line 266: l_fpm_upgr_status := Pji_utils.get_parameter(c_upgr_proc_name);

262:
263: l_worker_id := 1;
264: l_process := PJI_PJP_SUM_MAIN.g_process || l_worker_id;
265: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
266: l_fpm_upgr_status := Pji_utils.get_parameter(c_upgr_proc_name);
267: l_count := l_count + 1;
268: print_time('FPM Upgr y ' || l_count || ' l_fpm_upgr_status ' || l_fpm_upgr_status );
269:
270:

Line 374: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;

370: , p_prg_group1 => NULL
371: , p_prg_group2 => NULL);
372:
373: --#bug 5356051
374: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
376:
377: FND_STATS.GATHER_TABLE_STATS(
378: ownname => l_pa_schema

Line 375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();

371: , p_prg_group2 => NULL);
372:
373: --#bug 5356051
374: l_pa_schema := PJI_UTILS.GET_PA_SCHEMA_NAME;
375: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
376:
377: FND_STATS.GATHER_TABLE_STATS(
378: ownname => l_pa_schema
379: , tabname => 'PA_XBS_DENORM'

Line 405: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

401: l_count := 31;
402: print_time('FPM Upgr c ' || l_count);
403:
404: --#bug 5356051
405: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
406:
407: FND_STATS.GATHER_TABLE_STATS(
408: ownname => l_pji_schema
409: , tabname => 'PJI_XBS_DENORM'