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 22: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,

18:
19: --
20: -- Validate upper mark range >= lower mark range and both set if one set
21: FUNCTION assp_val_gsg_mrk_rng(
22: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
23: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
24: p_message_name OUT NOCOPY VARCHAR2 )
25: RETURN BOOLEAN;
26:

Line 23: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,

19: --
20: -- Validate upper mark range >= lower mark range and both set if one set
21: FUNCTION assp_val_gsg_mrk_rng(
22: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
23: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
24: p_message_name OUT NOCOPY VARCHAR2 )
25: RETURN BOOLEAN;
26:
27: --

Line 30: p_min_percentage IN IGS_AS_GRD_SCH_GRADE.min_percentage%TYPE ,

26:
27: --
28: -- Validate max percentage >= min percentage
29: FUNCTION assp_val_gsg_min_max(
30: p_min_percentage IN IGS_AS_GRD_SCH_GRADE.min_percentage%TYPE ,
31: p_max_percentage IN IGS_AS_GRD_SCH_GRADE.max_percentage%TYPE ,
32: p_message_name OUT NOCOPY VARCHAR2 )
33: RETURN BOOLEAN;
34:

Line 31: p_max_percentage IN IGS_AS_GRD_SCH_GRADE.max_percentage%TYPE ,

27: --
28: -- Validate max percentage >= min percentage
29: FUNCTION assp_val_gsg_min_max(
30: p_min_percentage IN IGS_AS_GRD_SCH_GRADE.min_percentage%TYPE ,
31: p_max_percentage IN IGS_AS_GRD_SCH_GRADE.max_percentage%TYPE ,
32: p_message_name OUT NOCOPY VARCHAR2 )
33: RETURN BOOLEAN;
34:
35: --

Line 38: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,

34:
35: --
36: -- Validate mark range does not overlap with other grades in GS version
37: FUNCTION assp_val_gsg_m_ovrlp(
38: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
39: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
40: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
41: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
42: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,

Line 39: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,

35: --
36: -- Validate mark range does not overlap with other grades in GS version
37: FUNCTION assp_val_gsg_m_ovrlp(
38: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
39: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
40: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
41: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
42: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
43: p_message_name OUT NOCOPY VARCHAR2 )

Line 40: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,

36: -- Validate mark range does not overlap with other grades in GS version
37: FUNCTION assp_val_gsg_m_ovrlp(
38: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
39: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
40: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
41: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
42: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
43: p_message_name OUT NOCOPY VARCHAR2 )
44: RETURN BOOLEAN;

Line 41: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,

37: FUNCTION assp_val_gsg_m_ovrlp(
38: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
39: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
40: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
41: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
42: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
43: p_message_name OUT NOCOPY VARCHAR2 )
44: RETURN BOOLEAN;
45:

Line 42: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,

38: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
39: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
40: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
41: p_lower_mark_range IN IGS_AS_GRD_SCH_GRADE.lower_mark_range%TYPE ,
42: p_upper_mark_range IN IGS_AS_GRD_SCH_GRADE.upper_mark_range%TYPE ,
43: p_message_name OUT NOCOPY VARCHAR2 )
44: RETURN BOOLEAN;
45:
46: --

Line 49: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,

45:
46: --
47: -- Validate only 1 grade exists in a GS with the dflt outstanding ind set
48: FUNCTION assp_val_gsg_dflt(
49: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
50: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
51: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
52: p_message_name OUT NOCOPY VARCHAR2 )
53: RETURN BOOLEAN;

Line 50: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,

46: --
47: -- Validate only 1 grade exists in a GS with the dflt outstanding ind set
48: FUNCTION assp_val_gsg_dflt(
49: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
50: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
51: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
52: p_message_name OUT NOCOPY VARCHAR2 )
53: RETURN BOOLEAN;
54:

Line 51: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,

47: -- Validate only 1 grade exists in a GS with the dflt outstanding ind set
48: FUNCTION assp_val_gsg_dflt(
49: p_grading_schema_cd IN IGS_AS_GRD_SCH_GRADE.grading_schema_cd%TYPE ,
50: p_version_number IN IGS_AS_GRD_SCH_GRADE.version_number%TYPE ,
51: p_grade IN IGS_AS_GRD_SCH_GRADE.grade%TYPE ,
52: p_message_name OUT NOCOPY VARCHAR2 )
53: RETURN BOOLEAN;
54:
55: --