DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_LOOKUPS_VIEW_PKG

Line 1190: IF NOT igs_lookups_view_pkg.get_pk_for_validation('WKLD_VAL_TYPE',p_unit_ver_rec.workload_val_code) THEN

1186: p_unit_ver_rec.status :='E';
1187: END;
1188:
1189: IF p_unit_ver_rec.workload_val_code IS NOT NULL THEN
1190: IF NOT igs_lookups_view_pkg.get_pk_for_validation('WKLD_VAL_TYPE',p_unit_ver_rec.workload_val_code) THEN
1191: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'WKLD_VAL_TYPE','LEGACY_TOKENS', FALSE);
1192: p_unit_ver_rec.status := 'E';
1193: END IF;
1194: END IF;

Line 3199: IF NOT igs_lookups_view_pkg.get_pk_for_validation('UNIT_SECTION_STATUS',p_usec_rec.unit_section_status) THEN

3195: END IF;
3196: END IF;
3197:
3198: -- Check the Unit Section Status
3199: IF NOT igs_lookups_view_pkg.get_pk_for_validation('UNIT_SECTION_STATUS',p_usec_rec.unit_section_status) THEN
3200: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV', 'USEC_STATUS', 'LEGACY_TOKENS', FALSE);
3201: p_usec_rec.status := 'E';
3202: END IF;
3203:

Line 6442: IF NOT igs_lookups_view_pkg.get_pk_for_validation ('IGS_OR_LOC_REGION',p_uso_rec.preferred_region_code) THEN

6438:
6439: -- Following validation added as part of bug#2972950 for the PSP Scheduling Enhancements TD
6440: -- If preferred region code is not NULL check it has a valid value
6441: IF p_uso_rec.preferred_region_code IS NOT NULL THEN
6442: IF NOT igs_lookups_view_pkg.get_pk_for_validation ('IGS_OR_LOC_REGION',p_uso_rec.preferred_region_code) THEN
6443: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','PREFERRED_REGION_CODE','LEGACY_TOKENS',FALSE);
6444: p_uso_rec.status := 'E';
6445: ELSIF NOT igs_or_loc_region_pkg.get_pk_for_validation(p_uso_rec.location_cd,p_uso_rec.preferred_region_code) THEN
6446: igs_ps_validate_lgcy_pkg.set_msg('IGS_EN_INV','PREFERRED_REGION_CODE','LEGACY_TOKENS',FALSE);