APPS.PA_CANDIDATE_PUB dependencies on FND_PROFILE

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

355:
356: -- Check if candidate Status is passed. If not, get the value from
357: -- the profile
358: IF p_status_code is null THEN
359: SELECT fnd_profile.value('PA_DEF_START_CAND_STATUS')
360: INTO l_status_code
361: FROM dual;
362: ELSE
363: l_status_code := p_status_code;

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

2837: AND status.project_system_status_code IN ('CANDIDATE_PENDING_REVIEW',
2838: 'CANDIDATE_UNDER_REVIEW', 'CANDIDATE_SYSTEM_NOMINATED', 'CANDIDATE_SUITABLE')
2839: AND status.status_type = 'CANDIDATE';
2840:
2841: l_decline_status_code := FND_PROFILE.value('PA_CNL_REQ_CAND_STATUS');
2842:
2843: --dbms_output.put_line('Log: Candidate Status Code ' || l_decline_status_code);
2844:
2845: -- If the status code from the profile option is null,

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

2849: IF l_decline_status_code IS NULL THEN
2850: l_decline_status_code := '110';
2851:
2852: --dbms_output.put_line('Save profile option');
2853: l_save := FND_PROFILE.SAVE (X_NAME => 'PA_CNL_REQ_CAND_STATUS'
2854: ,X_VALUE => l_decline_status_code
2855: ,X_LEVEL_NAME => 'SITE');
2856: --IF l_save THEN
2857: -- dbms_output.put_line('l_save = ' || ' TRUE');