APPS.IGS_AS_SU_SETATMPT_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 141: IGS_EN_STDNT_PS_ATT spa

137: -- check whether the unit set is a valid one for the prorgam offering option
138: CURSOR c_us_valid IS
139: SELECT 'x'
140: FROM IGS_PS_OFR_OPT_UNIT_SET_V usoo,
141: IGS_EN_STDNT_PS_ATT spa
142: WHERE spa.person_id = new_references.person_id
143: AND spa.course_cd = new_references.course_cd
144: AND usoo.unit_set_cd = new_references.unit_set_cd
145: AND usoo.us_version_number = new_references.us_version_number

Line 809: IGS_EN_STDNT_PS_ATT spa

805:
806: SELECT 'x'
807: FROM IGS_PS_OF_UNT_SET_RL cousr,
808: IGS_AS_SU_SETATMPT susa,
809: IGS_EN_STDNT_PS_ATT spa
810: WHERE spa.person_id = susa.person_id AND
811: spa.course_cd = susa.course_cd AND
812: susa.person_id = new_references.person_id AND
813: susa.course_cd = new_references.course_cd AND

Line 847: IF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (

843: (new_references.person_id IS NULL) OR
844: (new_references.course_cd IS NULL)) THEN
845: NULL;
846: ELSE
847: IF NOT IGS_EN_STDNT_PS_ATT_PKG.Get_PK_For_Validation (
848: new_references.person_id,
849: new_references.course_cd
850: ) THEN
851: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 1057: PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (

1053: CLOSE cur_rowid;
1054: RETURN (FALSE);
1055: END IF;
1056: END Get_PK_For_Validation;
1057: PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
1058: x_person_id IN NUMBER,
1059: x_course_cd IN VARCHAR2
1060: ) AS
1061: CURSOR cur_rowid IS

Line 1079: END GET_FK_IGS_EN_STDNT_PS_ATT;

1075:
1076: RETURN;
1077: END IF;
1078: CLOSE cur_rowid;
1079: END GET_FK_IGS_EN_STDNT_PS_ATT;
1080: PROCEDURE GET_FK_IGS_AS_SU_SETATMPT (
1081: x_person_id IN NUMBER,
1082: x_course_cd IN VARCHAR2,
1083: x_unit_set_cd IN VARCHAR2,

Line 1178: FROM igs_as_su_setatmpt a, igs_en_stdnt_ps_att b

1174: (reverse chronological order - newest change first)
1175: ***************************************************************/
1176: CURSOR cur_rowid IS
1177: SELECT a.rowid
1178: FROM igs_as_su_setatmpt a, igs_en_stdnt_ps_att b
1179: WHERE a.course_cd=b.course_cd
1180: AND a.person_id=b.person_id
1181: AND b.course_cd=x_course_cd
1182: AND b.version_number=x_version_number