APPS.PJI_EXTRACTION_UTIL dependencies on FND_PROFILE

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

512: l_last_update_login number;
513:
514: begin
515:
516: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
517:
518: FND_MESSAGE.SET_NAME('PJI', 'PJI_SUM_CLEANALL_FAILED');
519:
520: if (upper(nvl(l_profile_check, 'N')) <> 'Y') then

Line 534: update FND_PROFILE_OPTION_VALUES

530: retcode := 1;
531: return;
532: end if;
533:
534: update FND_PROFILE_OPTION_VALUES
535: set PROFILE_OPTION_VALUE = 'N'
536: where APPLICATION_ID = 1292 and
537: -- LEVEL_ID = 10001 and
538: PROFILE_OPTION_ID in

Line 540: from FND_PROFILE_OPTIONS

536: where APPLICATION_ID = 1292 and
537: -- LEVEL_ID = 10001 and
538: PROFILE_OPTION_ID in
539: (select PROFILE_OPTION_ID
540: from FND_PROFILE_OPTIONS
541: where APPLICATION_ID = 1292 and
542: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
543:
544: commit;

Line 644: update FND_PROFILE_OPTION_VALUES

640: -- Added for bug 6603016 ends
641:
642: if (p_truncate_pji_tables = 'Y') then
643:
644: update FND_PROFILE_OPTION_VALUES
645: set PROFILE_OPTION_VALUE = 'Y'
646: where APPLICATION_ID = 1292 and
647: -- LEVEL_ID = 10001 and
648: PROFILE_OPTION_ID in

Line 650: from FND_PROFILE_OPTIONS

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

Line 671: update FND_PROFILE_OPTION_VALUES

667: end if;
668:
669: if (p_truncate_pjp_tables = 'Y') then
670:
671: update FND_PROFILE_OPTION_VALUES
672: set PROFILE_OPTION_VALUE = 'Y'
673: where APPLICATION_ID = 1292 and
674: -- LEVEL_ID = 10001 and
675: PROFILE_OPTION_ID in

Line 677: from FND_PROFILE_OPTIONS

673: where APPLICATION_ID = 1292 and
674: -- LEVEL_ID = 10001 and
675: PROFILE_OPTION_ID in
676: (select PROFILE_OPTION_ID
677: from FND_PROFILE_OPTIONS
678: where APPLICATION_ID = 1292 and
679: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
680:
681: commit;

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

730:
731: begin
732:
733: l_parallel_processes :=
734: trunc(to_number(FND_PROFILE.VALUE('PJI_EXTRACTION_PARALLELISM')), 0);
735:
736: l_parallel_processes:= nvl(l_parallel_processes, 4);
737:
738: l_parallel_processes:= greatest(l_parallel_processes, 2);

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

757:
758: l_batch_size number;
759:
760: begin
761: l_batch_size := TRUNC(to_number(FND_PROFILE.VALUE('PJI_EXTRACTION_BATCH_SIZE')),0);
762: l_batch_size:= GREATEST(l_batch_size,1000000);
763: l_batch_size:= NVL(l_batch_size,5000000);
764:
765: return l_batch_size;