9: -- Who When What
10: ---------------------------------------------------------------------------------------------------
11:
12: PROCEDURE adm_offer_response_changed (
13: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
14: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
15: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
16: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
17: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
10: ---------------------------------------------------------------------------------------------------
11:
12: PROCEDURE adm_offer_response_changed (
13: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
14: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
15: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
16: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
17: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
18: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
11:
12: PROCEDURE adm_offer_response_changed (
13: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
14: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
15: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
16: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
17: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
18: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
19: );
12: PROCEDURE adm_offer_response_changed (
13: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
14: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
15: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
16: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
17: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
18: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
19: );
20:
13: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,
14: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
15: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
16: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
17: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
18: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
19: );
20:
21: PROCEDURE wf_get_person_attributes(
14: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%TYPE,
15: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE,
16: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,
17: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,
18: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE
19: );
20:
21: PROCEDURE wf_get_person_attributes(
22: itemtype IN VARCHAR2 ,