eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_AD_GEN_008

Line 500: l_s_adm_outcome_status := igs_ad_gen_008.admp_get_saos(new_references.adm_outcome_status);

496: v_offer_ind := 'N';
497: v_update_non_enrol_detail_ind := 'N';
498: v_late_ind := 'N';
499:
500: l_s_adm_outcome_status := igs_ad_gen_008.admp_get_saos(new_references.adm_outcome_status);
501: IF NVL(p_inserting,FALSE) OR NVL(p_updating,FALSE) THEN
502: OPEN c_appl_dt(p_person_id => new_references.person_id,
503: p_admission_appl_number => new_references.admission_appl_number);
504: FETCH c_appl_dt INTO l_appl_dt;

Line 840: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') IN

836: END IF;
837: --
838: -- Determine the offer indicator.
839: --
840: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') IN
841: ('OFFER', 'COND-OFFER') THEN
842: v_offer_ind := 'Y';
843: END IF;
844: --

Line 1188: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'SUSPENDED' AND

1184: NVL(old_references.adm_cal_type, '-1') <> NVL(new_references.adm_cal_type, '-1') OR
1185: NVL(old_references.adm_ci_sequence_number, -1) <>
1186: NVL(new_references.adm_ci_sequence_number, -1) OR
1187: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status AND
1188: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'SUSPENDED' AND
1189: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'WITHDRAWN') --nshee bug 2630217
1190: THEN
1191: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (
1192: new_references.person_id,

Line 1189: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'WITHDRAWN') --nshee bug 2630217

1185: NVL(old_references.adm_ci_sequence_number, -1) <>
1186: NVL(new_references.adm_ci_sequence_number, -1) OR
1187: (NVL(old_references.adm_outcome_status, '-1') <> new_references.adm_outcome_status AND
1188: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'SUSPENDED' AND
1189: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), '-1') <> 'WITHDRAWN') --nshee bug 2630217
1190: THEN
1191: IF IGS_AD_VAL_ACAI_STATUS.admp_val_acai_aos (
1192: new_references.person_id,
1193: new_references.admission_appl_number,

Line 1882: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') = 'CANCELLED' THEN

1878: FETCH c_per_end_type INTO lv_end_method;
1879: CLOSE c_per_end_type;
1880:
1881: IF NVL(p_updating,FALSE) THEN
1882: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') = 'CANCELLED' THEN
1883: FOR c_pti_rec IN c_pti (new_references.person_id,
1884: new_references.admission_appl_number,
1885: new_references.nominated_course_cd,
1886: new_references.sequence_number)

Line 1913: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(old_references.adm_outcome_status), 'NONE') = 'CANCELLED' AND

1909: END IF;
1910:
1911: --begin apadegal adtd001 igs.m
1912: -- added this, to reverse the above process.
1913: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(old_references.adm_outcome_status), 'NONE') = 'CANCELLED' AND
1914: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED'
1915: THEN
1916: FOR c_ptyp_inst_rec IN c_ptyp_inst ( new_references.person_id,
1917: new_references.admission_appl_number,

Line 1914: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED'

1910:
1911: --begin apadegal adtd001 igs.m
1912: -- added this, to reverse the above process.
1913: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(old_references.adm_outcome_status), 'NONE') = 'CANCELLED' AND
1914: NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED'
1915: THEN
1916: FOR c_ptyp_inst_rec IN c_ptyp_inst ( new_references.person_id,
1917: new_references.admission_appl_number,
1918: new_references.nominated_course_cd,

Line 4587: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(old_references.adm_outcome_status), 'NONE') = 'CANCELLED'

4583: FETCH cur_reconsider INTO l_is_inst_reconsidered;
4584: CLOSE cur_reconsider;
4585: --- end apadegal ADTD001 RE-OPEN Build igs.m
4586:
4587: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(old_references.adm_outcome_status), 'NONE') = 'CANCELLED'
4588: AND (NVL(l_is_inst_reconsidered,'N') <> 'Y') -- APADEGAL (IGS.M) - CANCELLED instance can be updated while reconsideration.
4589: THEN
4590: Fnd_Message.Set_name('IGS','IGS_AD_NOT_UPD_CANCEL_APPLINST');
4591: IGS_GE_MSG_STACK.ADD;

Line 4594: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN

4590: Fnd_Message.Set_name('IGS','IGS_AD_NOT_UPD_CANCEL_APPLINST');
4591: IGS_GE_MSG_STACK.ADD;
4592: App_Exception.Raise_Exception;
4593: END IF;
4594: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN
4595:
4596: -- rghosh bug# 2860860 (UCAS Conditional Offer build)
4597: -- if the application is UK one and old admission outcome status is mapped to system outcome status of COND-OFFER
4598: -- and the new admission outcome status is mapped to system outcome status of OFFER

Line 4603: (NVL(igs_ad_gen_008.admp_get_saos(old_references.adm_outcome_status), 'NONE') = 'COND-OFFER') AND

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);
4607: FETCH c_get_appl_details INTO c_get_appl_details_rec;

Line 4604: (NVL(igs_ad_gen_008.admp_get_saos(new_references.adm_outcome_status), 'NONE') = 'OFFER') THEN

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);
4607: FETCH c_get_appl_details INTO c_get_appl_details_rec;
4608: CLOSE c_get_appl_details;

Line 4625: IGS_AD_GEN_008.ADMP_GET_SAORS(l_adm_offer_resp_status) IS NOT NULL THEN -- Bug : 3160184 Removed the check on l_adm_offer_resp_status for ACCEPTED

4621: igs_ge_msg_stack.add;
4622: END IF;
4623:
4624: IF l_message_name IS NULL AND
4625: IGS_AD_GEN_008.ADMP_GET_SAORS(l_adm_offer_resp_status) IS NOT NULL THEN -- Bug : 3160184 Removed the check on l_adm_offer_resp_status for ACCEPTED
4626: new_references.adm_offer_resp_status := l_adm_offer_resp_status;
4627: IF IGS_AD_GEN_008.ADMP_GET_SAORS(new_references.adm_offer_resp_status) NOT IN ('PENDING', 'LAPSED', 'NOT-APPLIC') THEN -- added this code for Bug : 3160184
4628: new_references.actual_response_dt := TRUNC(SYSDATE);
4629: END IF;

Line 4627: IF IGS_AD_GEN_008.ADMP_GET_SAORS(new_references.adm_offer_resp_status) NOT IN ('PENDING', 'LAPSED', 'NOT-APPLIC') THEN -- added this code for Bug : 3160184

4623:
4624: IF l_message_name IS NULL AND
4625: IGS_AD_GEN_008.ADMP_GET_SAORS(l_adm_offer_resp_status) IS NOT NULL THEN -- Bug : 3160184 Removed the check on l_adm_offer_resp_status for ACCEPTED
4626: new_references.adm_offer_resp_status := l_adm_offer_resp_status;
4627: IF IGS_AD_GEN_008.ADMP_GET_SAORS(new_references.adm_offer_resp_status) NOT IN ('PENDING', 'LAPSED', 'NOT-APPLIC') THEN -- added this code for Bug : 3160184
4628: new_references.actual_response_dt := TRUNC(SYSDATE);
4629: END IF;
4630: END IF;
4631:

Line 4657: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN

4653: App_Exception.Raise_Exception;
4654: END IF;
4655: Check_Constraints;
4656: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
4657: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN
4658: Check_Constraints;
4659: END IF;
4660: ELSIF (p_action = 'VALIDATE_DELETE') THEN
4661: Check_Child_Existance;

Line 4706: AND igs_ad_gen_008.admp_get_saors (adm_offer_resp_status) IN ('ACCEPTED', 'DEFERRAL');

4702: SELECT DISTINCT 1
4703: FROM igs_ad_ps_appl_inst
4704: WHERE row_id <> x_rowid
4705: AND person_id = new_references.person_id
4706: AND igs_ad_gen_008.admp_get_saors (adm_offer_resp_status) IN ('ACCEPTED', 'DEFERRAL');
4707:
4708: l_appl_inst_exist_rec NUMBER;
4709:
4710: CURSOR c_adm_ca_seq_acad IS

Line 4780: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN

4776: AfterRowInsertUpdate2 ( p_inserting => TRUE,p_updating => FALSE,p_deleting=> FALSE );
4777: AfterRowInsert1 ( p_inserting => TRUE,p_updating => FALSE,p_deleting=> FALSE );
4778: ELSIF (p_action = 'UPDATE') THEN
4779: -- Call all the procedures related to After Update.
4780: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' THEN
4781: AfterRowInsertUpdate2 ( p_inserting=> FALSE,p_updating => TRUE,p_deleting=> FALSE );
4782: END IF;
4783: AfterRowUpdateDelete3 ( p_inserting=> FALSE,p_updating => TRUE,p_deleting=> FALSE );
4784: AfterRowUpdate1 ( p_inserting => FALSE,p_updating => TRUE,p_deleting=> FALSE );

Line 4929: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' AND

4925: -- Call all the procedures related to After Delete.
4926: AfterRowUpdateDelete3 ( p_inserting=> FALSE,p_updating => FALSE, p_deleting => TRUE );
4927: END IF;
4928:
4929: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' AND
4930: p_action IN ('INSERT','UPDATE') THEN
4931: -- This Funtion Gets the System Value of the Offer Response Status
4932: -- changed for person stats bug 5054301/3958556
4933: IF (igs_ad_gen_008.admp_get_saors (new_references.adm_offer_resp_status) = 'ACCEPTED' AND

Line 4933: IF (igs_ad_gen_008.admp_get_saors (new_references.adm_offer_resp_status) = 'ACCEPTED' AND

4929: IF NVL(IGS_AD_GEN_008.ADMP_GET_SAOS(new_references.adm_outcome_status), 'NONE') <> 'CANCELLED' AND
4930: p_action IN ('INSERT','UPDATE') THEN
4931: -- This Funtion Gets the System Value of the Offer Response Status
4932: -- changed for person stats bug 5054301/3958556
4933: IF (igs_ad_gen_008.admp_get_saors (new_references.adm_offer_resp_status) = 'ACCEPTED' AND
4934: igs_ad_gen_008.admp_get_saors (old_references.adm_offer_resp_status) <> 'ACCEPTED')
4935: THEN
4936:
4937: -- Offer is Accepted

Line 4934: igs_ad_gen_008.admp_get_saors (old_references.adm_offer_resp_status) <> 'ACCEPTED')

4930: p_action IN ('INSERT','UPDATE') THEN
4931: -- This Funtion Gets the System Value of the Offer Response Status
4932: -- changed for person stats bug 5054301/3958556
4933: IF (igs_ad_gen_008.admp_get_saors (new_references.adm_offer_resp_status) = 'ACCEPTED' AND
4934: igs_ad_gen_008.admp_get_saors (old_references.adm_offer_resp_status) <> 'ACCEPTED')
4935: THEN
4936:
4937: -- Offer is Accepted
4938: igs_ad_upd_initialise.update_per_stats( new_references.person_id,

Line 4943: ELSIF (igs_ad_gen_008.admp_get_saors (new_references.adm_offer_resp_status) <> 'ACCEPTED' AND

4939: new_references.admission_appl_number,
4940: 'A'
4941: );
4942:
4943: ELSIF (igs_ad_gen_008.admp_get_saors (new_references.adm_offer_resp_status) <> 'ACCEPTED' AND
4944: igs_ad_gen_008.admp_get_saors (old_references.adm_offer_resp_status) = 'ACCEPTED')
4945: THEN
4946: -- Accepted offer is reopened/ or Accepted application is reconsidered
4947: igs_ad_upd_initialise.update_per_stats( new_references.person_id,

Line 4944: igs_ad_gen_008.admp_get_saors (old_references.adm_offer_resp_status) = 'ACCEPTED')

4940: 'A'
4941: );
4942:
4943: ELSIF (igs_ad_gen_008.admp_get_saors (new_references.adm_offer_resp_status) <> 'ACCEPTED' AND
4944: igs_ad_gen_008.admp_get_saors (old_references.adm_offer_resp_status) = 'ACCEPTED')
4945: THEN
4946: -- Accepted offer is reopened/ or Accepted application is reconsidered
4947: igs_ad_upd_initialise.update_per_stats( new_references.person_id,
4948: new_references.admission_appl_number,