APPS.IGS_AS_TRNCMT_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT

Line 378: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

374: || (reverse chronological order - newest change first)
375: ****************************************************************************/
376: IS
377: CURSOR cur_check_course_type(
378: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
379: cp_course_type IGS_PS_VER_ALL.course_type%TYPE
380: )IS
381: SELECT 'X'
382: FROM IGS_EN_STDNT_PS_ATT spa, IGS_PS_VER_ALL pva

Line 382: FROM IGS_EN_STDNT_PS_ATT spa, IGS_PS_VER_ALL pva

378: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
379: cp_course_type IGS_PS_VER_ALL.course_type%TYPE
380: )IS
381: SELECT 'X'
382: FROM IGS_EN_STDNT_PS_ATT spa, IGS_PS_VER_ALL pva
383: WHERE spa.course_cd = pva.course_cd
384: AND spa.version_number = pva.version_number
385: AND spa.person_id = cp_person_id
386: AND pva.course_type = cp_course_type;

Line 447: -- Foreign key validation with IGS_EN_STDNT_PS_ATT

443: l_return_value := 'E'; -- Error out
444: RETURN l_return_value;
445: END IF;
446:
447: -- Foreign key validation with IGS_EN_STDNT_PS_ATT
448: IF p_lgcy_trncmt_rec.program_cd IS NOT NULL AND
449: NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation(
450: x_person_id => p_person_id ,
451: x_course_cd => p_lgcy_trncmt_rec.program_cd)

Line 449: NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation(

445: END IF;
446:
447: -- Foreign key validation with IGS_EN_STDNT_PS_ATT
448: IF p_lgcy_trncmt_rec.program_cd IS NOT NULL AND
449: NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation(
450: x_person_id => p_person_id ,
451: x_course_cd => p_lgcy_trncmt_rec.program_cd)
452: THEN
453: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GR_STPRATPT_FK_NOT_EXISTS');