APPS.IGS_AS_VAL_GSG dependencies on IGS_AS_GRD_SCHEMA

Line 7: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,

3:
4: --
5: -- Validate grade's gs date range is current or future
6: FUNCTION assp_val_gs_cur_fut(
7: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
8: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
9: p_message_name OUT NOCOPY varchar2 )
10: RETURN BOOLEAN IS
11: gv_other_detail VARCHAR2(255);

Line 8: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,

4: --
5: -- Validate grade's gs date range is current or future
6: FUNCTION assp_val_gs_cur_fut(
7: p_grading_schema_cd IN IGS_AS_GRD_SCHEMA.grading_schema_cd%TYPE ,
8: p_version_number IN IGS_AS_GRD_SCHEMA.version_number%TYPE ,
9: p_message_name OUT NOCOPY varchar2 )
10: RETURN BOOLEAN IS
11: gv_other_detail VARCHAR2(255);
12: BEGIN

Line 17: FROM IGS_AS_GRD_SCHEMA

13: DECLARE
14: CURSOR c_gsg IS
15: SELECT start_dt,
16: end_dt
17: FROM IGS_AS_GRD_SCHEMA
18: WHERE grading_schema_cd = p_grading_schema_cd AND
19: version_number = p_version_number;
20: v_gsg_rec c_gsg%ROWTYPE;
21: v_fnc_return_value BOOLEAN;

Line 23: -- Validate the IGS_AS_GRD_SCHEMA's date range is current or future

19: version_number = p_version_number;
20: v_gsg_rec c_gsg%ROWTYPE;
21: v_fnc_return_value BOOLEAN;
22: BEGIN
23: -- Validate the IGS_AS_GRD_SCHEMA's date range is current or future
24: -- Set the default message number
25: p_message_name := null;
26: -- Cursor handling
27: OPEN c_gsg;

Line 39: p_message_name := 'IGS_AS_GRD_SCHEMA_OBSLETE';

35: v_fnc_return_value := IGS_AS_VAL_GSG.GENP_VAL_DT_RANGE(v_gsg_rec.start_dt,
36: v_gsg_rec.end_dt,
37: p_message_name);
38: IF (NOT v_fnc_return_value) THEN
39: p_message_name := 'IGS_AS_GRD_SCHEMA_OBSLETE';
40: RETURN FALSE;
41: END IF;
42: -- Return the default value
43: RETURN TRUE;