APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_PS_UNIT_VER

Line 375: FROM igs_ps_unit_ver

371: AND c.test_segment_name = cp_test_segment_name
372: AND a.person_id = cp_person_id;
373: CURSOR c_credit_points ( cp_unit_cd p_lgcy_adstunt_rec.UNIT_CD%TYPE , cp_version_number igs_en_stdnt_ps_att.version_number%TYPE) IS
374: SELECT nvl(achievable_credit_points ,enrolled_credit_points) credit_points
375: FROM igs_ps_unit_ver
376: WHERE unit_cd=cp_unit_cd and version_number = cp_version_number ;
377:
378: CURSOR c_ref_id (p_reference_cd_type igs_ge_ref_cd.reference_cd_type%TYPE , p_reference_cd igs_ge_ref_cd.reference_cd%TYPE) IS
379: SELECT reference_code_id

Line 866: -- Foreign Key with Table IGS_PS_UNIT_VER

862: x_return_status := FALSE;
863: mydebug('validate_std_unt_db_cons IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION ');
864: END IF;
865:
866: -- Foreign Key with Table IGS_PS_UNIT_VER
867: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
868: x_unit_cd => p_lgcy_adstunt_rec.unit_cd,
869: x_version_number => p_lgcy_adstunt_rec.version_number
870: ) THEN

Line 867: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (

863: mydebug('validate_std_unt_db_cons IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION ');
864: END IF;
865:
866: -- Foreign Key with Table IGS_PS_UNIT_VER
867: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
868: x_unit_cd => p_lgcy_adstunt_rec.unit_cd,
869: x_version_number => p_lgcy_adstunt_rec.version_number
870: ) THEN
871: FND_MESSAGE.SET_NAME('IGS','IGS_AV_ADV_STUNT_UNIT_EXISTS');

Line 874: mydebug('validate_std_unt_db_cons IGS_PS_UNIT_VER_PKG.GET_PK_FOR_VALIDATION ');

870: ) THEN
871: FND_MESSAGE.SET_NAME('IGS','IGS_AV_ADV_STUNT_UNIT_EXISTS');
872: FND_MSG_PUB.ADD;
873: x_return_status := FALSE;
874: mydebug('validate_std_unt_db_cons IGS_PS_UNIT_VER_PKG.GET_PK_FOR_VALIDATION ');
875: END IF;
876:
877: -- Foreign Key with Table IGS_AS_GRD_SCH_GRADE
878:

Line 1348: IF NOT IGS_PS_UNIT_VER_PKG.GET_PK_FOR_VALIDATION(

1344: p_av_stnd_unit_lvl_id := l_av_stnd_unit_lvl_id;
1345: END IF;
1346: CLOSE cur_get_adv_stnd_id;
1347:
1348: IF NOT IGS_PS_UNIT_VER_PKG.GET_PK_FOR_VALIDATION(
1349: x_unit_cd =>p_lgcy_adstunt_rec.unit_cd ,
1350: x_version_number => p_lgcy_adstunt_rec.version_number
1351: )THEN
1352: FND_MESSAGE.SET_NAME('IGS','IGS_AV_UNT_ALT_UID_FK_EXISTS');