APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_PS_UNIT_VER_PKG

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');