APPS.PJI_EXTRACTION_UTIL dependencies on FND_PROFILE

Line 512: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');

508: l_sqlerrm varchar2(240);
509:
510: begin
511:
512: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
513:
514: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
515:
516: if (upper(nvl(l_profile_check, 'N')) <> 'Y') then

Line 530: update FND_PROFILE_OPTION_VALUES

526: retcode := 1;
527: return;
528: end if;
529:
530: update FND_PROFILE_OPTION_VALUES
531: set PROFILE_OPTION_VALUE = 'N'
532: where APPLICATION_ID = 1292 and
533: -- LEVEL_ID = 10001 and
534: PROFILE_OPTION_ID in

Line 536: from FND_PROFILE_OPTIONS

532: where APPLICATION_ID = 1292 and
533: -- LEVEL_ID = 10001 and
534: PROFILE_OPTION_ID in
535: (select PROFILE_OPTION_ID
536: from FND_PROFILE_OPTIONS
537: where APPLICATION_ID = 1292 and
538: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
539:
540: commit;

Line 619: update FND_PROFILE_OPTION_VALUES

615: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(l_pji_schema, 'PJI_FM_AGGR_ACT4', 'NORMAL', null);
616:
617: if (p_truncate_pji_tables = 'Y') then
618:
619: update FND_PROFILE_OPTION_VALUES
620: set PROFILE_OPTION_VALUE = 'Y'
621: where APPLICATION_ID = 1292 and
622: -- LEVEL_ID = 10001 and
623: PROFILE_OPTION_ID in

Line 625: from FND_PROFILE_OPTIONS

621: where APPLICATION_ID = 1292 and
622: -- LEVEL_ID = 10001 and
623: PROFILE_OPTION_ID in
624: (select PROFILE_OPTION_ID
625: from FND_PROFILE_OPTIONS
626: where APPLICATION_ID = 1292 and
627: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
628:
629: commit;

Line 646: update FND_PROFILE_OPTION_VALUES

642: end if;
643:
644: if (p_truncate_pjp_tables = 'Y') then
645:
646: update FND_PROFILE_OPTION_VALUES
647: set PROFILE_OPTION_VALUE = 'Y'
648: where APPLICATION_ID = 1292 and
649: -- LEVEL_ID = 10001 and
650: PROFILE_OPTION_ID in

Line 652: from FND_PROFILE_OPTIONS

648: where APPLICATION_ID = 1292 and
649: -- LEVEL_ID = 10001 and
650: PROFILE_OPTION_ID in
651: (select PROFILE_OPTION_ID
652: from FND_PROFILE_OPTIONS
653: where APPLICATION_ID = 1292 and
654: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
655:
656: commit;

Line 709: trunc(to_number(FND_PROFILE.VALUE('PJI_EXTRACTION_PARALLELISM')), 0);

705:
706: begin
707:
708: l_parallel_processes :=
709: trunc(to_number(FND_PROFILE.VALUE('PJI_EXTRACTION_PARALLELISM')), 0);
710:
711: l_parallel_processes:= nvl(l_parallel_processes, 4);
712:
713: l_parallel_processes:= greatest(l_parallel_processes, 2);

Line 736: l_batch_size := TRUNC(to_number(FND_PROFILE.VALUE('PJI_EXTRACTION_BATCH_SIZE')),0);

732:
733: l_batch_size number;
734:
735: begin
736: l_batch_size := TRUNC(to_number(FND_PROFILE.VALUE('PJI_EXTRACTION_BATCH_SIZE')),0);
737: l_batch_size:= GREATEST(l_batch_size,1000000);
738: l_batch_size:= NVL(l_batch_size,5000000);
739:
740: return l_batch_size;