APPS.IGS_PS_STDNT_TRN_PKG dependencies on IGS_EN_STDNT_PS_ATT

Line 156: IF NOT Igs_En_Stdnt_Ps_Att_Pkg.Get_PK_For_Validation (

152: ((new_references.person_id IS NULL) OR
153: (new_references.course_cd IS NULL))) THEN
154: NULL;
155: ELSE
156: IF NOT Igs_En_Stdnt_Ps_Att_Pkg.Get_PK_For_Validation (
157: new_references.person_id,
158: new_references.transfer_course_cd
159: ) THEN
160: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 175: IF NOT Igs_En_Stdnt_Ps_Att_Pkg.Get_PK_For_Validation (

171: ((new_references.person_id IS NULL) OR
172: (new_references.transfer_course_cd IS NULL))) THEN
173: NULL;
174: ELSE
175: IF NOT Igs_En_Stdnt_Ps_Att_Pkg.Get_PK_For_Validation (
176: new_references.person_id,
177: new_references.transfer_course_cd
178: ) THEN
179: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');

Line 247: PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (

243: RETURN (FALSE);
244: END IF;
245: END Get_PK_For_Validation;
246:
247: PROCEDURE GET_FK_IGS_EN_STDNT_PS_ATT (
248: x_person_id IN NUMBER,
249: x_course_cd IN VARCHAR2
250: ) AS
251:

Line 275: END GET_FK_IGS_EN_STDNT_PS_ATT;

271: RETURN;
272: END IF;
273: CLOSE cur_rowid;
274:
275: END GET_FK_IGS_EN_STDNT_PS_ATT;
276:
277: PROCEDURE Before_DML (
278: p_action IN VARCHAR2,
279: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 395: CURSOR cur_prog_atmpt(cp_transfer_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,

391: p_updating IN BOOLEAN ,
392: p_deleting IN BOOLEAN
393: ) AS
394:
395: CURSOR cur_prog_atmpt(cp_transfer_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
396: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
397: SELECT person_id,course_cd,version_number,cal_type ,commencement_dt,course_attempt_status ,
398: location_cd,attendance_mode,attendance_type
399: FROM igs_en_stdnt_ps_att

Line 396: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS

392: p_deleting IN BOOLEAN
393: ) AS
394:
395: CURSOR cur_prog_atmpt(cp_transfer_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
396: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
397: SELECT person_id,course_cd,version_number,cal_type ,commencement_dt,course_attempt_status ,
398: location_cd,attendance_mode,attendance_type
399: FROM igs_en_stdnt_ps_att
400: WHERE course_cd = cp_transfer_course_cd

Line 399: FROM igs_en_stdnt_ps_att

395: CURSOR cur_prog_atmpt(cp_transfer_course_cd igs_en_stdnt_ps_att.course_cd%TYPE,
396: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE) IS
397: SELECT person_id,course_cd,version_number,cal_type ,commencement_dt,course_attempt_status ,
398: location_cd,attendance_mode,attendance_type
399: FROM igs_en_stdnt_ps_att
400: WHERE course_cd = cp_transfer_course_cd
401: AND person_id = cp_person_id;
402:
403: l_cur_prog_atmpt cur_prog_atmpt%ROWTYPE;