APPS.HR_JP_ID_PKG dependencies on PER_GRADES

Line 1046: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_GRADES%ROWTYPE

1042: --------------------------------------------------------------------------------
1043: FUNCTION grade_rec(
1044: p_concatenated_segments IN VARCHAR2,
1045: p_business_group_id IN NUMBER,
1046: p_error_when_not_exist IN VARCHAR2 DEFAULT 'TRUE') RETURN PER_GRADES%ROWTYPE
1047: --------------------------------------------------------------------------------
1048: IS
1049: l_id_flex_num NUMBER;
1050: l_grade_definition_id NUMBER;

Line 1052: l_rec PER_GRADES%ROWTYPE;

1048: IS
1049: l_id_flex_num NUMBER;
1050: l_grade_definition_id NUMBER;
1051: l_csr RefCsr;
1052: l_rec PER_GRADES%ROWTYPE;
1053: BEGIN
1054: l_id_flex_num := id_flex_num(p_business_group_id,'GRD');
1055: l_grade_definition_id := keyflex_combination_id('PER','GRD',l_id_flex_num,p_concatenated_segments,p_error_when_not_exist);
1056:

Line 1060: l_csr := csr_with_bus('PER_GRADES','GRADE_DEFINITION_ID','N',to_char(l_grade_definition_id),p_business_group_id);

1056:
1057: if l_grade_definition_id is NULL then
1058: l_rec := NULL;
1059: else
1060: l_csr := csr_with_bus('PER_GRADES','GRADE_DEFINITION_ID','N',to_char(l_grade_definition_id),p_business_group_id);
1061: fetch l_csr into l_rec;
1062: if not csr_found_and_close(l_csr,p_error_when_not_exist) then
1063: l_rec := NULL;
1064: end if;