DBA Data[Home] [Help]

APPS.PQH_WKS_ERROR_CHK dependencies on HR_GENERAL

Line 1070: FND_MESSAGE.SET_TOKEN('STATUS',HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_availability_status_id));

1066: CLOSE csr_pos_availability;
1067:
1068: IF pqh_wks_budget.get_position_budget_flag(l_availability_status_id) = 'N' THEN
1069: FND_MESSAGE.SET_NAME('PQH','PQH_WKS_WRONG_POSITION');
1070: FND_MESSAGE.SET_TOKEN('STATUS',HR_GENERAL.DECODE_AVAILABILITY_STATUS(l_availability_status_id));
1071:
1072: l_message_text_out := FND_MESSAGE.GET;
1073:
1074: IF l_error_flag = 'Y' THEN

Line 2146: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);

2142: FETCH csr_wks_detail_rec INTO l_worksheet_details_rec;
2143: CLOSE csr_wks_detail_rec;
2144:
2145:
2146: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2147: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2148: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2149: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2150:

Line 2147: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);

2143: CLOSE csr_wks_detail_rec;
2144:
2145:
2146: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2147: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2148: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2149: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2150:
2151: IF NVL(l_worksheet_details_rec.action_cd , 'R') = 'R' THEN

Line 2148: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);

2144:
2145:
2146: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2147: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2148: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2149: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2150:
2151: IF NVL(l_worksheet_details_rec.action_cd , 'R') = 'R' THEN
2152: -- this is the main parent record , display worksheet Name

Line 2149: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);

2145:
2146: l_position_name := HR_GENERAL.DECODE_POSITION (p_position_id => l_worksheet_details_rec.position_id);
2147: l_job_name := HR_GENERAL.DECODE_JOB (p_job_id => l_worksheet_details_rec.job_id);
2148: l_organization_name := HR_GENERAL.DECODE_ORGANIZATION (p_organization_id => l_worksheet_details_rec.organization_id);
2149: l_grade_name := HR_GENERAL.DECODE_GRADE (p_grade_id => l_worksheet_details_rec.grade_id);
2150:
2151: IF NVL(l_worksheet_details_rec.action_cd , 'R') = 'R' THEN
2152: -- this is the main parent record , display worksheet Name
2153: p_log_context := g_worksheet_name;