DBA Data[Home] [Help]

APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_LOOKUPS_VIEW_PKG

Line 857: IF NOT igs_lookups_view_pkg.get_pk_for_validation(

853: x_return_status := FALSE;
854: mydebug('validate_std_unt_db_cons p_auth_pers_id ');
855: END IF;
856: -- Valid s_adv_granting_status exists
857: IF NOT igs_lookups_view_pkg.get_pk_for_validation(
858: x_lookup_type => 'ADV_STND_GRANTING_STATUS',
859: x_lookup_code => p_lgcy_adstunt_rec.s_adv_stnd_granting_status) THEN
860: FND_MESSAGE.SET_NAME('IGS','IGS_AV_CANNOT_DTR_GRNT_STAT');
861: FND_MSG_PUB.ADD;

Line 863: mydebug('validate_std_unt_db_cons IGS_LOOKUPS_VIEW_PKG.GET_PK_FOR_VALIDATION ');

859: x_lookup_code => p_lgcy_adstunt_rec.s_adv_stnd_granting_status) THEN
860: FND_MESSAGE.SET_NAME('IGS','IGS_AV_CANNOT_DTR_GRNT_STAT');
861: FND_MSG_PUB.ADD;
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 (