APPS.IGS_AD_PS_APPL_INST_PKG dependencies on FND_PROFILE

Line 4602: IF fnd_profile.value('OSS_COUNTRY_CODE') = 'GB' AND

4598: -- and the new admission outcome status is mapped to system outcome status of OFFER
4599: -- and the old offer response status is mapped to that UCAS decision code which is in turn mapped to system outcome status of COND-OFFER
4600: -- and UCAS reply code of Firm Acceptance then it returns a new offer response status that is mapped to that UCAS decision code which is in turn
4601: -- mapped to system outcome status of OFFER and UCAS reply code of Firm Acceptance.
4602: IF fnd_profile.value('OSS_COUNTRY_CODE') = 'GB' AND
4603: (NVL(igs_ad_gen_008.admp_get_saos(old_references.adm_outcome_status), 'NONE') = 'COND-OFFER') AND
4604: (NVL(igs_ad_gen_008.admp_get_saos(new_references.adm_outcome_status), 'NONE') = 'OFFER') THEN
4605:
4606: OPEN c_get_appl_details (new_references.person_id,new_references.admission_appl_number);

Line 4772: l_most_recent_profile := FND_PROFILE.VALUE('IGS_PE_RECENT_TERM');

4768:
4769: BEGIN
4770:
4771: l_rowid := x_rowid;
4772: l_most_recent_profile := FND_PROFILE.VALUE('IGS_PE_RECENT_TERM');
4773: l_catalog_profile := FND_PROFILE.VALUE('IGS_PE_CATALOG');
4774: IF (p_action = 'INSERT') THEN
4775: -- Call all the procedures related to After Insert.
4776: AfterRowInsertUpdate2 ( p_inserting => TRUE,p_updating => FALSE,p_deleting=> FALSE );

Line 4773: l_catalog_profile := FND_PROFILE.VALUE('IGS_PE_CATALOG');

4769: BEGIN
4770:
4771: l_rowid := x_rowid;
4772: l_most_recent_profile := FND_PROFILE.VALUE('IGS_PE_RECENT_TERM');
4773: l_catalog_profile := FND_PROFILE.VALUE('IGS_PE_CATALOG');
4774: IF (p_action = 'INSERT') THEN
4775: -- Call all the procedures related to After Insert.
4776: AfterRowInsertUpdate2 ( p_inserting => TRUE,p_updating => FALSE,p_deleting=> FALSE );
4777: AfterRowInsert1 ( p_inserting => TRUE,p_updating => FALSE,p_deleting=> FALSE );