APPS.IGS_PE_RELATIONSHIPS_PKG dependencies on FND_PROFILE

Line 23: l_student_age_bar NUMBER := TO_NUMBER(NVL(FND_PROFILE.VALUE('IGS_AD_AUTONUM'),0)) ;

19: -- OSS extension tables,as part of address related changes .
20: -------------------------------------------------------------------
21:
22: -- store the student age restriction
23: l_student_age_bar NUMBER := TO_NUMBER(NVL(FND_PROFILE.VALUE('IGS_AD_AUTONUM'),0)) ;
24:
25: --
26: -- cursor to fetch the address of the student
27: --

Line 139: l_profile_addr_usage := FND_PROFILE.VALUE('IGS_AD_ADR_USG');

135:
136: --
137: -- check whether the value exist for IGS_AD_ADR_USG or not. If no, give warning
138: --
139: l_profile_addr_usage := FND_PROFILE.VALUE('IGS_AD_ADR_USG');
140:
141: IF l_profile_addr_usage IS NULL THEN
142: FND_MESSAGE.SET_NAME ('IGS','IGS_PE_ADR_USG');
143: igs_ge_msg_stack.add;

Line 414: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN

410: prel_rec.content_source_type := 'USER_ENTERED';
411: prel_rec.created_by_module := 'IGS';
412:
413: -- Generating And Passing the party number if the profile value is set to 'No' for generating the party number
414: IF FND_PROFILE.VALUE('HZ_GENERATE_PARTY_NUMBER') = 'N' THEN
415: SELECT hz_party_number_s.nextval INTO p_party_rec.party_number FROM dual;
416: prel_rec.party_rec := p_party_rec;
417: END IF;
418: