DBA Data[Home] [Help]

APPS.IGS_AD_PS_APPL_INST_PKG dependencies on IGS_AD_WF_001

Line 2435: igs_ad_wf_001.APP_PRCOC_STATUS_UPD_EVENT (

2431: UPDATE IGS_AD_APPL
2432: SET adm_appl_status = v_derived_adm_appl_status
2433: WHERE person_id = v_person_id AND
2434: admission_appl_number = v_admission_appl_number;
2435: igs_ad_wf_001.APP_PRCOC_STATUS_UPD_EVENT (
2436: P_PERSON_ID => new_references.person_id,
2437: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
2438: P_ADM_APPL_STATUS_NEW => v_derived_adm_appl_status,
2439: P_ADM_APPL_STATUS_OLD => v_adm_appl_status);

Line 2444: igs_ad_wf_001.wf_adm_academic_index(

2440: END IF;
2441:
2442: -- Raise the Admission Academic Index workflow, whenever the Academic Index value of Application Instance is changed. Financial Aid Integration Build : 3202866
2443: IF NVL(new_references.academic_index,'*****') <> NVL(old_references.academic_index,'*****') THEN
2444: igs_ad_wf_001.wf_adm_academic_index(
2445: new_references.person_id,
2446: new_references.admission_appl_number,
2447: new_references.nominated_course_cd,
2448: new_references.sequence_number,

Line 4788: igs_ad_wf_001.APPCOMP_STATUS_UPD_EVENT

4784: AfterRowUpdate1 ( p_inserting => FALSE,p_updating => TRUE,p_deleting=> FALSE );
4785: --Raise the buisness event if Application competion status has changed
4786: IF new_references.adm_doc_status <> old_references.adm_doc_status THEN
4787:
4788: igs_ad_wf_001.APPCOMP_STATUS_UPD_EVENT
4789: (
4790: -- P_ORG_ID => new_references.org_id,
4791: P_PERSON_ID => new_references.person_id,
4792: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,

Line 4802: igs_ad_wf_001.ENTRY_QUAL_STATUS_UPD_EVENT

4798: END IF;
4799:
4800: IF new_references.adm_entry_qual_status <> old_references.adm_entry_qual_status THEN
4801:
4802: igs_ad_wf_001.ENTRY_QUAL_STATUS_UPD_EVENT
4803: (
4804: P_PERSON_ID => new_references.person_id,
4805: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
4806: P_NOMINATED_COURSE_CD => new_references.nominated_course_cd,

Line 4815: igs_ad_wf_001.LATE_ADM_FEE_STATUS_UPD_EVENT

4811: END IF;
4812:
4813: IF new_references.late_adm_fee_status <> old_references.late_adm_fee_status THEN
4814:
4815: igs_ad_wf_001.LATE_ADM_FEE_STATUS_UPD_EVENT
4816: (
4817: P_PERSON_ID => new_references.person_id,
4818: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
4819: P_NOMINATED_COURSE_CD => new_references.nominated_course_cd,

Line 4827: igs_ad_wf_001.COND_OFFER_STATUS_UPD_EVENT

4823: );
4824: END IF;
4825: IF new_references.adm_cndtnl_offer_status <> old_references.adm_cndtnl_offer_status THEN
4826:
4827: igs_ad_wf_001.COND_OFFER_STATUS_UPD_EVENT
4828: (
4829: P_PERSON_ID => new_references.person_id,
4830: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
4831: P_NOMINATED_COURSE_CD => new_references.nominated_course_cd,

Line 4840: igs_ad_wf_001.OFFER_DEFER_STATUS_UPD_EVENT

4836: END IF;
4837:
4838: IF new_references.adm_offer_dfrmnt_status <> old_references.adm_offer_dfrmnt_status THEN
4839:
4840: igs_ad_wf_001.OFFER_DEFER_STATUS_UPD_EVENT
4841: (
4842: P_PERSON_ID => new_references.person_id,
4843: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
4844: P_NOMINATED_COURSE_CD => new_references.nominated_course_cd,

Line 4855: igs_ad_wf_001.WAITLIST_STATUS_UPD_EVENT

4851: END IF;
4852:
4853: IF new_references.waitlist_status <> old_references.waitlist_status THEN
4854:
4855: igs_ad_wf_001.WAITLIST_STATUS_UPD_EVENT
4856: (
4857: P_PERSON_ID => new_references.person_id,
4858: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
4859: P_NOMINATED_COURSE_CD => new_references.nominated_course_cd,

Line 4881: igs_ad_wf_001.APP_INSTANCE_STATUS_UPD_EVENT

4877:
4878:
4879:
4880: IF NVL(new_references.appl_inst_status,'X!@#$Y%') <> NVL(old_references.appl_inst_status,'X!@#$Y%') THEN
4881: igs_ad_wf_001.APP_INSTANCE_STATUS_UPD_EVENT
4882: (
4883: P_PERSON_ID => new_references.person_id,
4884: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
4885: P_NOMINATED_COURSE_CD => new_references.nominated_course_cd,

Line 4899: igs_ad_wf_001.APP_RECON_FUT_REQ_UPD_EVENT

4895: OR new_references.future_adm_cal_type <> old_references.future_adm_cal_type THEN
4896: OPEN c_recon_flag(new_references.person_id,new_references.admission_appl_number,new_references.nominated_course_cd);
4897: FETCH c_recon_flag INTO l_req_for_reconsideration_ind;
4898: CLOSE c_recon_flag;
4899: igs_ad_wf_001.APP_RECON_FUT_REQ_UPD_EVENT
4900: (
4901: P_PERSON_ID => new_references.person_id,
4902: P_ADMISSION_APPL_NUMBER => new_references.admission_appl_number,
4903: P_NOMINATED_COURSE_CD => new_references.nominated_course_cd,