800: l_assignment_rec.resource_id IS NOT NULL THEN
801:
802: IF l_assignment_rec.assignment_type='STAFFED_ADMIN_ASSIGNMENT' THEN
803:
804: pa_security_pvt.check_confirm_asmt(p_project_id => l_assignment_rec.project_id,
805: p_resource_id => l_assignment_rec.resource_id,
806: p_resource_name => null,
807: p_privilege => 'PA_ADM_ASN_CR_AND_DL',
808: p_start_date => l_assignment_rec.start_date,
833: IF l_system_status_code = 'STAFFED_ASGMT_CONF' THEN
834:
835: IF l_assignment_rec.assignment_type='STAFFED_ASSIGNMENT' THEN
836:
837: pa_security_pvt.check_confirm_asmt(p_project_id => l_assignment_rec.project_id,
838: p_resource_id => l_assignment_rec.resource_id,
839: p_resource_name => null,
840: p_privilege => 'PA_ASN_CONFIRM',
841: p_start_date => l_assignment_rec.start_date,
845: x_msg_data => l_msg_data);
846: --dbms_output.put_line('function security check: ret_code is: '||l_ret_code);
847: ELSIF l_assignment_rec.assignment_type='STAFFED_ADMIN_ASSIGNMENT' THEN
848:
849: pa_security_pvt.check_confirm_asmt(p_project_id => l_assignment_rec.project_id,
850: p_resource_id => l_assignment_rec.resource_id,
851: p_resource_name => null,
852: p_privilege => 'PA_ADM_ASN_CONFIRM',
853: p_start_date => l_assignment_rec.start_date,