DBA Data[Home] [Help]

APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_GE_REF_CD_PKG

Line 7657: IF NOT igs_ge_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN

7653: FETCH c_res_flag INTO rec_res_flag;
7654: IF c_res_flag%FOUND THEN
7655: IF rec_res_flag.restricted_flag = 'Y' THEN
7656: -- Foreign Key Validations : Reference Code doesn't exists
7657: IF NOT igs_ge_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7658: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'REFERENCE_CD','LEGACY_TOKENS', FALSE);
7659: p_ref_cd_rec.status := 'E';
7660: END IF;
7661: END IF;

Line 7709: IF NOT igs_ge_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN

7705: FETCH c_res_flag INTO rec_res_flag;
7706: IF c_res_flag%FOUND THEN
7707: IF rec_res_flag.restricted_flag = 'Y' THEN
7708: -- Foreign Key Validations : Reference Code doesn't exists
7709: IF NOT igs_ge_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7710: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'REFERENCE_CD','LEGACY_TOKENS', FALSE);
7711: p_ref_cd_rec.status := 'E';
7712: END IF;
7713: END IF;

Line 7755: IF NOT igs_ge_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN

7751: FETCH c_res_flag INTO rec_res_flag;
7752: IF c_res_flag%FOUND THEN
7753: IF rec_res_flag.restricted_flag = 'Y' THEN
7754: -- Foreign Key Validations : Reference Code doesn't exists
7755: IF NOT igs_ge_ref_cd_pkg.get_uk_for_validation(p_ref_cd_rec.reference_cd_type,p_ref_cd_rec.reference_cd) THEN
7756: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS', 'REFERENCE_CD','LEGACY_TOKENS', FALSE);
7757: p_ref_cd_rec.status := 'E';
7758: END IF;
7759: END IF;