APPS.IGS_EN_VAL_SUSA dependencies on IGS_AS_SU_SETATMPT

Line 18: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.PARENT_UNIT_SET_CD%TYPE,

14: -------------------------------------------------------------------------------------------
15: TYPE t_susa_rowid_record IS RECORD
16: (
17: v_rowid ROWID,
18: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.PARENT_UNIT_SET_CD%TYPE,
19: v_end_dt IGS_AS_SU_SETATMPT.END_DT%TYPE,
20: v_student_confirmed_ind IGS_AS_SU_SETATMPT.STUDENT_CONFIRMED_IND%TYPE,
21: v_primary_set_ind IGS_AS_SU_SETATMPT.PRIMARY_SET_IND%TYPE);
22: --

Line 19: v_end_dt IGS_AS_SU_SETATMPT.END_DT%TYPE,

15: TYPE t_susa_rowid_record IS RECORD
16: (
17: v_rowid ROWID,
18: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.PARENT_UNIT_SET_CD%TYPE,
19: v_end_dt IGS_AS_SU_SETATMPT.END_DT%TYPE,
20: v_student_confirmed_ind IGS_AS_SU_SETATMPT.STUDENT_CONFIRMED_IND%TYPE,
21: v_primary_set_ind IGS_AS_SU_SETATMPT.PRIMARY_SET_IND%TYPE);
22: --
23: --

Line 20: v_student_confirmed_ind IGS_AS_SU_SETATMPT.STUDENT_CONFIRMED_IND%TYPE,

16: (
17: v_rowid ROWID,
18: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.PARENT_UNIT_SET_CD%TYPE,
19: v_end_dt IGS_AS_SU_SETATMPT.END_DT%TYPE,
20: v_student_confirmed_ind IGS_AS_SU_SETATMPT.STUDENT_CONFIRMED_IND%TYPE,
21: v_primary_set_ind IGS_AS_SU_SETATMPT.PRIMARY_SET_IND%TYPE);
22: --
23: --
24:

Line 21: v_primary_set_ind IGS_AS_SU_SETATMPT.PRIMARY_SET_IND%TYPE);

17: v_rowid ROWID,
18: v_parent_unit_set_cd IGS_AS_SU_SETATMPT.PARENT_UNIT_SET_CD%TYPE,
19: v_end_dt IGS_AS_SU_SETATMPT.END_DT%TYPE,
20: v_student_confirmed_ind IGS_AS_SU_SETATMPT.STUDENT_CONFIRMED_IND%TYPE,
21: v_primary_set_ind IGS_AS_SU_SETATMPT.PRIMARY_SET_IND%TYPE);
22: --
23: --
24:
25:

Line 31: p_end_dt IN IGS_AS_SU_SETATMPT.end_dt%TYPE ,

27: -- Validate the authorisation fields.
28: FUNCTION enrp_val_susa_auth(
29: p_unit_set_cd IN VARCHAR2 ,
30: p_us_version_number IN NUMBER ,
31: p_end_dt IN IGS_AS_SU_SETATMPT.end_dt%TYPE ,
32: p_authorised_person_id IN NUMBER ,
33: p_authorised_on IN DATE ,
34: p_message_name OUT NOCOPY VARCHAR2,
35: p_legacy IN VARCHAR2 DEFAULT 'N')

Line 39: -- Validate the requirement complete fields for IGS_AS_SU_SETATMPT.

35: p_legacy IN VARCHAR2 DEFAULT 'N')
36: RETURN BOOLEAN;
37: --
38: --PRAGMA RESTRICT_REFERENCES(enrp_val_susa_auth , WNDS);
39: -- Validate the requirement complete fields for IGS_AS_SU_SETATMPT.
40: FUNCTION enrp_val_susa_cmplt(
41: p_rqrmnts_complete_dt IN DATE ,
42: p_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
43: p_student_confirmed_ind IN VARCHAR2 DEFAULT 'N',

Line 143: -- Validate the IGS_AS_SU_SETATMPT.primary_set_ind field.

139: p_legacy IN VARCHAR2 DEFAULT 'N')
140: RETURN BOOLEAN;
141: --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_PARENT , WNDS);
142: --
143: -- Validate the IGS_AS_SU_SETATMPT.primary_set_ind field.
144: FUNCTION ENRP_VAL_SUSA_PRMRY(
145: p_person_id IN NUMBER ,
146: p_course_cd IN VARCHAR2 ,
147: p_unit_set_cd IN VARCHAR2 ,

Line 280: -- Validate the requirement complete fields for IGS_AS_SU_SETATMPT.

276: p_message_name OUT NOCOPY VARCHAR2)
277: RETURN BOOLEAN;
278: --PRAGMA RESTRICT_REFERENCES( ENRP_VAL_SUSA_SCI_UP , WNDS);
279: --
280: -- Validate the requirement complete fields for IGS_AS_SU_SETATMPT.
281: FUNCTION enrp_val_susa_scst(
282: p_rqrmnts_complete_dt IN DATE ,
283: p_rqrmnts_complete_ind IN VARCHAR2 DEFAULT 'N',
284: p_s_completed_source_type IN VARCHAR2 DEFAULT 'N',