[Home] [Help]
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..
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:
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:
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
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'
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'
834: BEGIN
835:
836: print_time('CREATE_SECONDARY_PVT: begin.. ');
837:
838: l_pji_schema := pji_utils.get_pji_schema_name; /* Added for bug 13897252 */
839:
840: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SEC_PROJ');
841: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SECRBS_PROJ');
842: print_time(' Identified plan versions to be extracted. ');
841: Pji_Fm_Plan_Maint_Pvt.EXTRACT_FIN_PLAN_VERS_BULK(p_slice_type => 'SECRBS_PROJ');
842: print_time(' Identified plan versions to be extracted. ');
843:
844: /* Added for bug 13897252 starts */
845: IF PJI_UTILS.GET_PARAMETER('PJP_SIN_PRG') = 'Y' then
846: PJI_PJP_PRG_PERF_ALL.GATHER_TEMP_STATS(p_ownname => l_pji_schema
847: ,p_tabname => 'PJI_FM_EXTR_PLNVER4'
848: ,p_partname => 'P'||g_worker_id
849: ,p_percent => 10);
879: Pji_Fm_Plan_Maint_Pvt.DELETE_GLOBAL_EXCHANGE_RATES;
880: print_time(' Deleted global exchange rates. ');
881:
882: /* Added for bug 8708651 */
883: l_time_phase_flag := PJI_UTILS.GET_SETUP_PARAMETER('TIME_PHASE_FLAG');
884:
885: -- Bug 15881881
886: fnd_stats.gather_table_stats('PJI','PJI_FP_AGGR_PJP1',PERCENT=>40);
887: -- End Bug 15881881
1298: -- 2. PA cal and Non time phased entries into GL cal.
1299: -- 3. PA, GL cals and Non time phased entries into Ent cal.
1300: --
1301: /* Added for bug 8708651 */
1302: l_time_phase_flag := PJI_UTILS.GET_SETUP_PARAMETER('TIME_PHASE_FLAG');
1303:
1304: if l_time_phase_flag = 'Y' then
1305: null;
1306: else
1681: (p_pull_dangling_flag => 'N');
1682: print_time('Extracted finplan data for Secondary RBS for secondary currencies as well.');
1683:
1684: /* Added for bug 8708651 */
1685: l_time_phase_flag := PJI_UTILS.GET_SETUP_PARAMETER('TIME_PHASE_FLAG');
1686:
1687: if l_time_phase_flag = 'Y' then
1688: null;
1689: else