APPS.PQP_RIW_GRADE_WRAPPER dependencies on PER_GRADES

Line 780: from per_grades

776: ,p_concat_segments_out => l_name
777: );
778:
779: select grade_id into p_grade_id
780: from per_grades
781: where business_group_id = p_business_group_id
782: and name = l_name;
783:
784: Exception

Line 894: l_grade_id per_grades.grade_id%TYPE;

890:
891: l_grade_rec grade_record;
892: l_proc varchar2(72) := g_package ||'.insupd_grade';
893: l_validate boolean := false;
894: l_grade_id per_grades.grade_id%TYPE;
895: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
896: l_name per_grades.name%TYPE;
897: l_object_version_number per_grades.object_version_number%TYPE;
898: l_concat_segments varchar2(2000);

Line 895: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;

891: l_grade_rec grade_record;
892: l_proc varchar2(72) := g_package ||'.insupd_grade';
893: l_validate boolean := false;
894: l_grade_id per_grades.grade_id%TYPE;
895: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
896: l_name per_grades.name%TYPE;
897: l_object_version_number per_grades.object_version_number%TYPE;
898: l_concat_segments varchar2(2000);
899: l_error_msg varchar2(4000);

Line 896: l_name per_grades.name%TYPE;

892: l_proc varchar2(72) := g_package ||'.insupd_grade';
893: l_validate boolean := false;
894: l_grade_id per_grades.grade_id%TYPE;
895: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
896: l_name per_grades.name%TYPE;
897: l_object_version_number per_grades.object_version_number%TYPE;
898: l_concat_segments varchar2(2000);
899: l_error_msg varchar2(4000);
900: l_create_flag number(2) := 1;

Line 897: l_object_version_number per_grades.object_version_number%TYPE;

893: l_validate boolean := false;
894: l_grade_id per_grades.grade_id%TYPE;
895: l_grade_definition_id per_grades.grade_definition_id%TYPE := p_grade_definition_id;
896: l_name per_grades.name%TYPE;
897: l_object_version_number per_grades.object_version_number%TYPE;
898: l_concat_segments varchar2(2000);
899: l_error_msg varchar2(4000);
900: l_create_flag number(2) := 1;
901: e_upl_not_allowed exception; -- when mode is 'View Only'

Line 1165: select object_version_number into l_obj_ver_num from per_grades

1161: if l_create_flag = 2 then
1162: l_grade_rec := Get_grade_Record_Values(p_interface_code);
1163:
1164: l_grade_definition_id := null;
1165: select object_version_number into l_obj_ver_num from per_grades
1166: where GRADE_ID=l_grade_rec.grade_id;
1167: l_concat_segments := l_grade_rec.concat_segments;
1168: HR_GRADE_API.UPDATE_GRADE
1169: (p_validate => l_validate