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.

[Home] [Help]

APPS.IGF_AP_OSS_INTR_DTLS dependencies on IGS_AD_PS_APPL_INST

Line 61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST

57:
58: -- These set of variables are returned from igf_ap_oss_integr.get_adm_appl_details()
59: -- [
60: lv_ad_appl_row_id ROWID; -- Retains RowId for IGS_AD_APPL
61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;

Line 63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;

59: -- [
60: lv_ad_appl_row_id ROWID; -- Retains RowId for IGS_AD_APPL
61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;

Line 64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;

60: lv_ad_appl_row_id ROWID; -- Retains RowId for IGS_AD_APPL
61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
68: lv_multiple VARCHAR2(10); -- Hold 'Y' / 'N'

Line 65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;

61: lv_ad_prog_row_id ROWID; -- Retains RowId for IGS_AD_PS_APPL_INST
62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
68: lv_multiple VARCHAR2(10); -- Hold 'Y' / 'N'
69: -- ]

Line 66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;

62: lv_adm_appl_number igs_ad_appl_all.admission_appl_number%TYPE;
63: lv_course_cd igs_ad_ps_appl_inst_all.course_cd%TYPE;
64: lv_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE;
65: lv_adm_offer_resp_stat igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
66: lv_adm_outcome_stat igs_ad_ps_appl_inst_all.adm_outcome_status%TYPE;
67: lv_adm_appl_status igs_ad_appl_all.adm_appl_status%TYPE;
68: lv_multiple VARCHAR2(10); -- Hold 'Y' / 'N'
69: -- ]
70:

Line 87: lv_expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE;

83:
84: -- variables to get anticipated completion date
85: -- [
86: lv_course_start_dt DATE;
87: lv_expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE;
88: lv_expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE;
89: lv_completion_dt DATE;
90: -- ]
91:

Line 88: lv_expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE;

84: -- variables to get anticipated completion date
85: -- [
86: lv_course_start_dt DATE;
87: lv_expected_completion_yr igs_ad_ps_appl_inst_all.expected_completion_yr%TYPE;
88: lv_expected_completion_perd igs_ad_ps_appl_inst_all.expected_completion_perd%TYPE;
89: lv_completion_dt DATE;
90: -- ]
91:
92: -- variables to get Cummulative and Current GPA

Line 135: SELECT COUNT(*) cnt FROM igs_ad_ps_appl_inst

131:
132: --Added the cursor to resolve bug 2296776
133:
134: CURSOR get_adm_cnt(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
135: SELECT COUNT(*) cnt FROM igs_ad_ps_appl_inst
136: WHERE person_id=p_person_id AND
137: course_cd = cp_course_cd;
138:
139: l_adm_cnt_rec get_adm_cnt%ROWTYPE;

Line 145: FROM igs_ad_ps_appl_inst adps,igs_en_stdnt_ps_att enps,

141:
142: CURSOR get_adm_dtls(cp_course_cd igs_ps_ver.course_cd%TYPE) IS
143: SELECT adm.course_type adm_course_type,adps.course_cd adm_course_cd,
144: adps.admission_appl_number adm_appl_number
145: FROM igs_ad_ps_appl_inst adps,igs_en_stdnt_ps_att enps,
146: igs_ps_ver adm,igs_ps_ver enrl
147: WHERE adps.person_id=p_person_id AND adps.person_id= enps.person_id
148: AND enps.course_cd=cp_course_cd AND enps.course_cd=enrl.course_cd
149: AND adps.course_cd = adm.course_cd AND adm.course_type=enrl.course_type;

Line 260: FROM igs_ad_ps_appl_inst prg,

256: IS
257: SELECT prg.attendance_type, prg.attendance_mode, prg.course_cd , prg.crv_version_number, prg.adm_outcome_status, prg.decision_date, prg.adm_offer_resp_status,
258: prg.actual_response_dt,prg.entry_level,prg.academic_index, prg.unit_set_cd, prg.us_version_number, prg_ou.s_adm_outcome_status ou_status,
259: prg_of.s_adm_offer_resp_status offer_status, prg.location_cd
260: FROM igs_ad_ps_appl_inst prg,
261: igs_ad_ou_stat prg_ou,
262: igs_ad_ofr_resp_stat prg_of
263: WHERE prg.rowid = lv_ad_prg_row_id
264: AND prg.adm_outcome_status = prg_ou.adm_outcome_status

Line 385: -- and the Selected Admission Program detail record [IGS_AD_PS_APPL_INST]

381: --
382: -- Call igf_ap_oss_integr.gbefore call to IGFAP20B.pls admissions
383: -- set_adm_appl_details to retreive
384: -- the Selected Admission Application record [IGS_AD_APPL]
385: -- and the Selected Admission Program detail record [IGS_AD_PS_APPL_INST]
386: --
387:
388: BEGIN
389:

Line 432: -- Get Program related fields (IGS_AD_PS_APPL_INST)

428: OPEN adm_appl_cur(lv_ad_appl_row_id);
429: FETCH adm_appl_cur INTO adm_appl_rec;
430: CLOSE adm_appl_cur;
431:
432: -- Get Program related fields (IGS_AD_PS_APPL_INST)
433:
434: OPEN appl_prog_cur(lv_ad_prog_row_id);
435: FETCH appl_prog_cur INTO appl_prog_rec;
436: CLOSE appl_prog_cur;