DBA Data[Home] [Help]

APPS.PJI_EXTRACTION_UTIL dependencies on FND_PROFILE_OPTION_VALUES

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 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 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