APPS.PA_CANDIDATE_PUB dependencies on FND_PROFILE

Line 380: SELECT fnd_profile.value('PA_DEF_START_CAND_STATUS')

376:
377: -- Check if candidate Status is passed. If not, get the value from
378: -- the profile
379: IF p_status_code is null THEN
380: SELECT fnd_profile.value('PA_DEF_START_CAND_STATUS')
381: INTO l_status_code
382: FROM dual;
383: ELSE
384: l_status_code := p_status_code;

Line 3104: l_decline_status_code := FND_PROFILE.value('PA_CNL_REQ_CAND_STATUS');

3100: AND status.project_system_status_code IN ('CANDIDATE_PENDING_REVIEW',
3101: 'CANDIDATE_UNDER_REVIEW', 'CANDIDATE_SYSTEM_NOMINATED', 'CANDIDATE_SUITABLE')
3102: AND status.status_type = 'CANDIDATE';
3103:
3104: l_decline_status_code := FND_PROFILE.value('PA_CNL_REQ_CAND_STATUS');
3105:
3106: --dbms_output.put_line('Log: Candidate Status Code ' || l_decline_status_code);
3107:
3108: -- If the status code from the profile option is null,

Line 3116: l_save := FND_PROFILE.SAVE (X_NAME => 'PA_CNL_REQ_CAND_STATUS'

3112: IF l_decline_status_code IS NULL THEN
3113: l_decline_status_code := '110';
3114:
3115: --dbms_output.put_line('Save profile option');
3116: l_save := FND_PROFILE.SAVE (X_NAME => 'PA_CNL_REQ_CAND_STATUS'
3117: ,X_VALUE => l_decline_status_code
3118: ,X_LEVEL_NAME => 'SITE');
3119: --IF l_save THEN
3120: -- dbms_output.put_line('l_save = ' || ' TRUE');