APPS.PJI_EXTRACTION_UTIL dependencies on PJI_UTILS

Line 47: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;

43: delete
44: from PA_PJI_PROJ_EVENTS_LOG
45: where EVENT_TYPE = 'Projects';
46:
47: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
48:
49: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
50: trunc(l_extr_start_date, 'J') <>
51: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

Line 49: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and

45: where EVENT_TYPE = 'Projects';
46:
47: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
48:
49: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
50: trunc(l_extr_start_date, 'J') <>
51: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
52: PJI_FM_SUM_MAIN.g_date_mask), 'J')) then
53: pji_utils.write2log('WARNING: Global start date has changed.');

Line 51: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),

47: l_extr_start_date := PJI_UTILS.GET_EXTRACTION_START_DATE;
48:
49: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
50: trunc(l_extr_start_date, 'J') <>
51: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
52: PJI_FM_SUM_MAIN.g_date_mask), 'J')) then
53: pji_utils.write2log('WARNING: Global start date has changed.');
54: end if;
55:

Line 53: pji_utils.write2log('WARNING: Global start date has changed.');

49: if (PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE') is not null and
50: trunc(l_extr_start_date, 'J') <>
51: trunc(to_date(PJI_UTILS.GET_PARAMETER('GLOBAL_START_DATE'),
52: PJI_FM_SUM_MAIN.g_date_mask), 'J')) then
53: pji_utils.write2log('WARNING: Global start date has changed.');
54: end if;
55:
56: -- Delete from PJI_PROJ_EXTR_STATUS those projects deleted from
57: -- PA_PROJECTS_ALL. Note that a project cannot be deleted if it has any

Line 437: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

433: l_med_blocks := 1.25*(l_med_rows*150)/l_db_block_size;
434: l_low_blocks := 1.25*(l_low_rows*75)/l_db_block_size;
435:
436:
437: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
438: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
439:
440: -- non-partitioned tables
441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);

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

434: l_low_blocks := 1.25*(l_low_rows*75)/l_db_block_size;
435:
436:
437: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
438: l_degree := PJI_UTILS.GET_DEGREE_OF_PARALLELISM();
439:
440: -- non-partitioned tables
441: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT1' , l_high_rows, l_high_blocks, 225);
442: FND_STATS.SET_TABLE_STATS(l_schema,'PJI_FM_AGGR_ACT2' , l_high_rows, l_high_blocks, 225);

Line 521: pji_utils.write2out(FND_MESSAGE.GET);

517:
518: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
519:
520: if (upper(nvl(l_profile_check, 'N')) <> 'Y') then
521: pji_utils.write2out(FND_MESSAGE.GET);
522: commit;
523: retcode := 1;
524: return;
525: end if;

Line 528: pji_utils.write2out(FND_MESSAGE.GET);

524: return;
525: end if;
526:
527: if (upper(nvl(p_check, 'N')) <> 'Y') then
528: pji_utils.write2out(FND_MESSAGE.GET);
529: commit;
530: retcode := 1;
531: return;
532: end if;

Line 546: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

542: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
543:
544: commit;
545:
546: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;
547:
548: -- PJI summarization tables with persistent data
549: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_MT_PRC_STEPS', 'NORMAL', null);
550: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_SYSTEM_CONFIG_HIST', 'NORMAL', null);