APPS.PA_ASSIGNMENT_APPROVAL_PUB dependencies on PA_RESOURCE_UTILS

Line 186: PA_RESOURCE_UTILS.Check_ResourceName_OR_ID ( p_resource_id => l_approver_person_id

182: IF PA_STARTUP.G_Calling_Application = 'SELF_SERVICE' THEN
183: PA_STARTUP.G_Check_ID_Flag := 'N';
184: END IF;
185:
186: PA_RESOURCE_UTILS.Check_ResourceName_OR_ID ( p_resource_id => l_approver_person_id
187: ,p_resource_name => p_apr_person_name
188: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
189: ,p_date => l_start_date
190: --,x_resource_id => l_approver_person_id * Bug: 4537865

Line 1443: pa_resource_utils.get_person_name (p_person_id => l_updated_asmt_rec.staffing_owner_person_id,

1439: -- value. Because p_staffing_owner_person_id=null, we can get the latest value from p_staffing_owner_name
1440: IF p_staffing_owner_name IS NOT NULL THEN
1441: l_new_value := p_staffing_owner_name;
1442: ELSE
1443: pa_resource_utils.get_person_name (p_person_id => l_updated_asmt_rec.staffing_owner_person_id,
1444: x_person_name => l_new_value,
1445: x_return_status => l_return_Status);
1446: END IF;
1447:

Line 1448: pa_resource_utils.get_person_name (p_person_id => l_asmt_history_rec.staffing_owner_person_id,

1444: x_person_name => l_new_value,
1445: x_return_status => l_return_Status);
1446: END IF;
1447:
1448: pa_resource_utils.get_person_name (p_person_id => l_asmt_history_rec.staffing_owner_person_id,
1449: x_person_name => l_old_value,
1450: x_return_status => l_return_Status);
1451:
1452: INSERT INTO pa_asgmt_changed_items (assignment_id, changed_item_name, new_value, old_value)

Line 3144: pa_resource_utils.check_user_has_res_auth (l_submitter_person_id, l_resource_id) = 'Y' THEN

3140:
3141: END IF;
3142:
3143: IF l_resource_super_user = 'Y' OR
3144: pa_resource_utils.check_user_has_res_auth (l_submitter_person_id, l_resource_id) = 'Y' THEN
3145: l_assignment_status := PA_ASSIGNMENT_APPROVAL_PUB.g_approve_action;
3146: ELSE --submitter does not have resource authority
3147:
3148: ----------------------------------------------------------------------

Line 3218: l_apr1_res_auth := pa_resource_utils.check_user_has_res_auth (l_approver1_id_tbl(i), l_resource_id);

3214: log_message('Approver 1: ' || l_approver1_id_tbl(i));
3215: log_message('Approver 2: ' || l_approver2_id_tbl(i));
3216: log_message('Resource : ' || l_resource_id);
3217:
3218: l_apr1_res_auth := pa_resource_utils.check_user_has_res_auth (l_approver1_id_tbl(i), l_resource_id);
3219:
3220: IF l_approver2_id_tbl(i) is not null THEN
3221: l_apr2_res_auth := pa_resource_utils.check_user_has_res_auth (l_approver2_id_tbl(i), l_resource_id);
3222: END IF;

Line 3221: l_apr2_res_auth := pa_resource_utils.check_user_has_res_auth (l_approver2_id_tbl(i), l_resource_id);

3217:
3218: l_apr1_res_auth := pa_resource_utils.check_user_has_res_auth (l_approver1_id_tbl(i), l_resource_id);
3219:
3220: IF l_approver2_id_tbl(i) is not null THEN
3221: l_apr2_res_auth := pa_resource_utils.check_user_has_res_auth (l_approver2_id_tbl(i), l_resource_id);
3222: END IF;
3223:
3224: IF l_apr1_res_auth = 'N' OR l_apr2_res_auth = 'N' THEN
3225:

Line 4252: PA_RESOURCE_UTILS.Check_ResourceName_OR_ID (

4248: THEN
4249:
4250: log_message('Before calling check_resourcename_or_id for Approver1 Loop:' || i);
4251:
4252: PA_RESOURCE_UTILS.Check_ResourceName_OR_ID (
4253: p_resource_id => l_approver1_person_id
4254: ,p_resource_name => l_approver1_person_name
4255: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
4256: ,p_date => l_assignment_start_date

Line 4283: PA_RESOURCE_UTILS.Check_ResourceName_OR_ID (

4279:
4280: log_message('Before calling check_resourcename_or_id for Approver2 Loop:' || i);
4281: log_message('Check Id flag: ' || PA_STARTUP.G_Check_ID_Flag);
4282:
4283: PA_RESOURCE_UTILS.Check_ResourceName_OR_ID (
4284: p_resource_id => l_approver2_person_id
4285: ,p_resource_name => l_approver2_person_name
4286: ,p_check_id_flag => PA_STARTUP.G_Check_ID_Flag
4287: ,p_date => l_assignment_start_date