eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_AS_VAL_GSG dependencies on IGS_AS_GRD_SCH_GRADE

Line 86: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,

82: END genp_val_dt_range;
83: --
84: -- Validate upper mark range >= lower mark range and both set if one set
85: FUNCTION assp_val_gsg_mrk_rng(
86: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
87: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
88: p_message_name OUT NOCOPY varchar2 )
89: RETURN BOOLEAN IS
90: gv_other_detail VARCHAR2(255);

Line 87: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,

83: --
84: -- Validate upper mark range >= lower mark range and both set if one set
85: FUNCTION assp_val_gsg_mrk_rng(
86: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
87: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
88: p_message_name OUT NOCOPY varchar2 )
89: RETURN BOOLEAN IS
90: gv_other_detail VARCHAR2(255);
91: BEGIN

Line 129: p_min_percentage IN IGS_AS_GRD_SCH_GRADE.min_percentage%TYPE ,

125: END assp_val_gsg_mrk_rng;
126: --
127: -- Validate max percentage >= min percentage
128: FUNCTION assp_val_gsg_min_max(
129: p_min_percentage IN IGS_AS_GRD_SCH_GRADE.min_percentage%TYPE ,
130: p_max_percentage IN IGS_AS_GRD_SCH_GRADE.max_percentage%TYPE ,
131: p_message_name OUT NOCOPY varchar2 )
132: RETURN BOOLEAN IS
133: gv_other_detail VARCHAR2(255);

Line 130: p_max_percentage IN IGS_AS_GRD_SCH_GRADE.max_percentage%TYPE ,

126: --
127: -- Validate max percentage >= min percentage
128: FUNCTION assp_val_gsg_min_max(
129: p_min_percentage IN IGS_AS_GRD_SCH_GRADE.min_percentage%TYPE ,
130: p_max_percentage IN IGS_AS_GRD_SCH_GRADE.max_percentage%TYPE ,
131: p_message_name OUT NOCOPY varchar2 )
132: RETURN BOOLEAN IS
133: gv_other_detail VARCHAR2(255);
134: BEGIN

Line 157: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,

153: END assp_val_gsg_min_max;
154: --
155: -- Validate mark range does not overlap with other grades in GS version
156: FUNCTION assp_val_gsg_m_ovrlp(
157: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
158: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
159: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
160: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
161: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,

Line 158: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,

154: --
155: -- Validate mark range does not overlap with other grades in GS version
156: FUNCTION assp_val_gsg_m_ovrlp(
157: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
158: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
159: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
160: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
161: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
162: p_message_name OUT NOCOPY varchar2 )

Line 159: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,

155: -- Validate mark range does not overlap with other grades in GS version
156: FUNCTION assp_val_gsg_m_ovrlp(
157: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
158: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
159: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
160: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
161: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
162: p_message_name OUT NOCOPY varchar2 )
163: RETURN BOOLEAN IS

Line 160: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,

156: FUNCTION assp_val_gsg_m_ovrlp(
157: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
158: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
159: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
160: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
161: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
162: p_message_name OUT NOCOPY varchar2 )
163: RETURN BOOLEAN IS
164: gv_other_detail VARCHAR2(255);

Line 161: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,

157: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
158: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
159: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
160: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
161: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
162: p_message_name OUT NOCOPY varchar2 )
163: RETURN BOOLEAN IS
164: gv_other_detail VARCHAR2(255);
165: BEGIN

Line 170: FROM IGS_AS_GRD_SCH_GRADE

166: DECLARE
167: CURSOR c_gsg IS
168: SELECT lower_mark_range,
169: upper_mark_range
170: FROM IGS_AS_GRD_SCH_GRADE
171: WHERE grading_schema_cd = p_grading_schema_cd AND
172: version_number = p_version_number AND
173: grade <> p_grade AND
174: p_lower_mark_range IS NOT NULL AND

Line 216: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,

212: END assp_val_gsg_m_ovrlp;
213: --
214: -- Validate only 1 grade exists in a GS with the dflt outstanding ind set
215: FUNCTION assp_val_gsg_dflt(
216: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
217: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
218: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
219: p_message_name OUT NOCOPY varchar2 )
220: RETURN BOOLEAN IS

Line 217: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,

213: --
214: -- Validate only 1 grade exists in a GS with the dflt outstanding ind set
215: FUNCTION assp_val_gsg_dflt(
216: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
217: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
218: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
219: p_message_name OUT NOCOPY varchar2 )
220: RETURN BOOLEAN IS
221: gv_other_detail VARCHAR2(255);

Line 218: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,

214: -- Validate only 1 grade exists in a GS with the dflt outstanding ind set
215: FUNCTION assp_val_gsg_dflt(
216: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
217: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
218: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
219: p_message_name OUT NOCOPY varchar2 )
220: RETURN BOOLEAN IS
221: gv_other_detail VARCHAR2(255);
222: BEGIN

Line 226: FROM IGS_AS_GRD_SCH_GRADE

222: BEGIN
223: DECLARE
224: CURSOR c_gsg IS
225: SELECT COUNT(*)
226: FROM IGS_AS_GRD_SCH_GRADE
227: WHERE grading_schema_cd = p_grading_schema_cd AND
228: version_number = p_version_number AND
229: grade <> p_grade AND
230: dflt_outstanding_ind = 'Y';

Line 338: IGS_AS_GRD_SCH_GRADE.s_special_grade_type%TYPE := 'CONCEDED-PASS';

334: -- This module validates the special grade type. If the special grade
335: -- type is 'CONCEDED-PASS' then the s_result_type must be 'PASS'.
336: DECLARE
337: cst_conceded_pass CONSTANT
338: IGS_AS_GRD_SCH_GRADE.s_special_grade_type%TYPE := 'CONCEDED-PASS';
339: cst_pass CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'PASS';
340: BEGIN
341: IF p_s_special_grade_type = cst_conceded_pass AND
342: p_s_result_type <> cst_pass THEN

Line 339: cst_pass CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'PASS';

335: -- type is 'CONCEDED-PASS' then the s_result_type must be 'PASS'.
336: DECLARE
337: cst_conceded_pass CONSTANT
338: IGS_AS_GRD_SCH_GRADE.s_special_grade_type%TYPE := 'CONCEDED-PASS';
339: cst_pass CONSTANT IGS_AS_GRD_SCH_GRADE.s_result_type%TYPE := 'PASS';
340: BEGIN
341: IF p_s_special_grade_type = cst_conceded_pass AND
342: p_s_result_type <> cst_pass THEN
343: p_message_name := 'IGS_AS_SPL_GRDTYPE_CONCEDED';