APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on FND_PROFILE

Line 141: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'*') = 'GB'

137: l_education_rec.created_by_module := 'IGS';
138: l_education_rec.application_id := NULL;
139:
140: --For UK Degree Earned and Degree Attempted should be null
141: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'*') = 'GB'
142: AND (x_degree_attempted IS NOT NULL
143: OR x_degree_earned IS NOT NULL
144: OR x_program_code IS NOT NULL) THEN
145: Fnd_Message.Set_Name ('IGS', 'IGS_AD_GB_ACAD_HIST');

Line 501: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'*') = 'GB'

497: OPEN c_old_references;
498: FETCH c_old_references INTO old_degree_attempted,old_degree_earned,old_program_code;
499: CLOSE c_old_references;
500:
501: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'*') = 'GB'
502: AND ( nvl(old_degree_attempted,'NulL') <> nvl(x_degree_attempted,'NulL') or
503: nvl(old_degree_earned,'NulL') <> nvl(x_degree_earned,'NulL') or
504: nvl(old_program_code,'NulL') <> nvl(x_program_code,'NulL')
505: )