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_OFFRESP_STATUS_WF dependencies on IGS_AD_PS_APPL_INST_ALL

Line 12: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,

8: -- Who When What
9: --
10: ---------------------------------------------------------------------------------------------------------------------------------------
11: PROCEDURE adm_offer_response_changed (
12: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
13: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
14: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
15: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
16: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

Line 13: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,

9: --
10: ---------------------------------------------------------------------------------------------------------------------------------------
11: PROCEDURE adm_offer_response_changed (
12: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
13: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
14: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
15: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
16: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
17: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE

Line 14: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,

10: ---------------------------------------------------------------------------------------------------------------------------------------
11: PROCEDURE adm_offer_response_changed (
12: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
13: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
14: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
15: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
16: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
17: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
18: ) IS

Line 15: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,

11: PROCEDURE adm_offer_response_changed (
12: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
13: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
14: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
15: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
16: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
17: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
18: ) IS
19:

Line 16: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

12: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
13: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
14: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
15: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
16: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
17: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
18: ) IS
19:
20: -- Get a unique sequence number

Line 17: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE

13: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
14: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
15: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
16: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
17: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
18: ) IS
19:
20: -- Get a unique sequence number
21: CURSOR c_seq_num IS

Line 194: igs_ad_ps_appl_inst_all aplinst

190: p_s_admission_process_type igs_ad_appl_all.s_admission_process_type%TYPE) IS
191: SELECT admprd.single_response_flag
192: FROM igs_ad_prd_ad_prc_ca admprd,
193: igs_ad_appl_all appl,
194: igs_ad_ps_appl_inst_all aplinst
195: WHERE appl.person_id = p_person_id
196: AND appl.admission_appl_number = p_admission_appl_number
197: AND appl.person_id = aplinst.person_id
198: AND appl.admission_appl_number = aplinst.admission_appl_number

Line 215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;

211: l_person_number igs_pe_person_base_v.person_number%TYPE;
212: l_full_name igs_pe_person_base_v.full_name%TYPE;
213:
214: l_person_id igs_pe_person_base_v.person_id%TYPE;
215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
218:
219: v_admission_cat igs_ad_appl.admission_cat%TYPE;

Line 216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;

212: l_full_name igs_pe_person_base_v.full_name%TYPE;
213:
214: l_person_id igs_pe_person_base_v.person_id%TYPE;
215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
218:
219: v_admission_cat igs_ad_appl.admission_cat%TYPE;
220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;

Line 217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;

213:
214: l_person_id igs_pe_person_base_v.person_id%TYPE;
215: l_admission_appl_number igs_ad_ps_appl_inst_all.admission_appl_number%TYPE;
216: l_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE;
217: l_sequence_number igs_ad_ps_appl_inst_all.sequence_number%TYPE;
218:
219: v_admission_cat igs_ad_appl.admission_cat%TYPE;
220: v_s_admission_process_type igs_ad_appl.s_admission_process_type%TYPE;
221: v_acad_cal_type igs_ad_appl.acad_cal_type%TYPE;

Line 233: l_new_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;

229: v_adm_fee_status igs_ad_appl.adm_fee_status%TYPE;
230: l_single_response_flag VARCHAR2(1);
231: l_acad_alt_code igs_ca_inst.alternate_code%TYPE;
232: l_adm_alt_code igs_ca_inst.alternate_code%TYPE;
233: l_new_offer_resp_status igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE;
234:
235: BEGIN
236: IF funcmode='RUN' THEN
237: