DBA Data[Home] [Help]

APPS.IGS_AD_OFFRESP_STATUS_WF dependencies on IGS_AD_PS_APPL_INST_ALL

Line 13: p_person_id IN igs_ad_ps_appl_inst_all.person_id%TYPE,

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,

Line 14: p_admission_appl_number IN igs_ad_ps_appl_inst_all.admission_appl_number%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

Line 15: p_nominated_course_cd IN igs_ad_ps_appl_inst_all.nominated_course_cd%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: );

Line 16: p_sequence_number IN igs_ad_ps_appl_inst_all.sequence_number%TYPE,

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:

Line 17: p_old_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%TYPE,

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(

Line 18: p_new_offresp_status IN igs_ad_ps_appl_inst_all.adm_offer_resp_status%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(
22: itemtype IN VARCHAR2 ,