APPS.PJI_PJP_PRG_PERF_ALL dependencies on FND_PROFILE

Line 4529: IF UPPER(FND_PROFILE.VALUE('PJI_SUM_CLEANALL')) = 'Y' THEN

4525: p_tabname => 'PJI_FP_XBS_ACCUM_F',
4526: p_partname=> NULL,
4527: p_percent => 10);
4528:
4529: IF UPPER(FND_PROFILE.VALUE('PJI_SUM_CLEANALL')) = 'Y' THEN
4530: /* Clear temporary table */
4531: PJI_PROCESS_UTIL.TRUNC_INT_TABLE(PJI_UTILS.GET_PJI_SCHEMA_NAME, 'PJI_MERGE_HELPER','NORMAL','P'||g_worker_id);
4532:
4533: /* Disable Indexes PJI_FP_XBS_ACCUM_F*/

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

6319:
6320: begin
6321:
6322: l_process := PJI_PJP_SUM_MAIN.g_process || to_char(p_worker_id);
6323: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
6324:
6325: if (not PJI_PROCESS_UTIL.NEED_TO_RUN_STEP(l_process, 'PJI_PJP_SUM_ROLLUP.ROLLUP_FPR_WBS(p_worker_id);')) then
6326: return;
6327: else

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

6496: l_profile_check varchar2(1);
6497:
6498: begin
6499:
6500: l_profile_check := FND_PROFILE.VALUE('PJI_SUM_CLEANALL');
6501:
6502: if (upper(nvl(l_profile_check, 'N')) = 'Y') then
6503: select decode (PDML_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'DISABLE'),
6504: decode (PQ_STATUS, 'DISABLED', 'DISABLE', 'ENABLED', 'ENABLE', 'FORCED', 'FORCE', 'ENABLE')

Line 6551: update FND_PROFILE_OPTION_VALUES

6547: execute immediate 'alter session ' || l_pdml_state || ' parallel dml';
6548: execute immediate 'alter session ' || l_pq_state || ' parallel query';
6549: commit;
6550:
6551: update FND_PROFILE_OPTION_VALUES
6552: set PROFILE_OPTION_VALUE = 'N'
6553: where APPLICATION_ID = 1292
6554: and PROFILE_OPTION_ID in
6555: (select PROFILE_OPTION_ID

Line 6556: from FND_PROFILE_OPTIONS

6552: set PROFILE_OPTION_VALUE = 'N'
6553: where APPLICATION_ID = 1292
6554: and PROFILE_OPTION_ID in
6555: (select PROFILE_OPTION_ID
6556: from FND_PROFILE_OPTIONS
6557: where APPLICATION_ID = 1292 and
6558: PROFILE_OPTION_NAME = 'PJI_SUM_CLEANALL');
6559:
6560: commit;