APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_PS_VER

Line 335: v_crv_version_number IGS_PS_VER.version_number%TYPE;

331: v_late_ind VARCHAR2(1) ;
332: v_staff_member_ind IGS_PE_PERSON.staff_member_ind%TYPE;
333: v_p_inserting_ind VARCHAR2(1) ;
334: v_offer_ind VARCHAR2(1) ;
335: v_crv_version_number IGS_PS_VER.version_number%TYPE;
336: v_admission_cat IGS_AD_APPL.admission_cat%TYPE;
337: v_s_admission_process_type IGS_AD_APPL.s_admission_process_type%TYPE;
338: v_acad_cal_type IGS_AD_APPL.acad_cal_type%TYPE;
339: v_aa_acad_ci_sequence_number IGS_AD_APPL.acad_ci_sequence_number%TYPE;

Line 2976: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (

2972: ((new_references.course_cd IS NULL) OR
2973: (new_references.crv_version_number IS NULL))) THEN
2974: NULL;
2975: ELSE
2976: IF NOT IGS_PS_VER_PKG.Get_PK_For_Validation (
2977: new_references.course_cd,
2978: new_references.crv_version_number
2979: )THEN
2980: FND_MESSAGE.SET_NAME('IGS','IGS_GE_PK_UK_NOT_FOUND');

Line 3867: PROCEDURE GET_FK_IGS_PS_VER (

3863: END IF;
3864: Close cur_rowid;
3865: END GET_FK_IGS_PS_COURSE;
3866:
3867: PROCEDURE GET_FK_IGS_PS_VER (
3868: x_course_cd IN VARCHAR2,
3869: x_version_number IN NUMBER
3870: ) IS
3871: CURSOR cur_rowid IS

Line 3888: END GET_FK_IGS_PS_VER;

3884: App_Exception.Raise_Exception;
3885: Return;
3886: END IF;
3887: Close cur_rowid;
3888: END GET_FK_IGS_PS_VER;
3889:
3890: PROCEDURE GET_FK_IGS_EN_ENROLMENT_CAT (
3891: x_enrolment_cat IN VARCHAR2
3892: ) IS