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 436: l_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

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

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

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

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

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

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

520: return;
521: end if;
522:
523: if (upper(nvl(p_check, 'N')) <> 'Y') then
524: pji_utils.write2out(FND_MESSAGE.GET);
525: commit;
526: retcode := 1;
527: return;
528: end if;

Line 542: l_pji_schema := PJI_UTILS.GET_PJI_SCHEMA_NAME;

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