APPS.IGS_AD_SS_APPL_UPD_PAGE dependencies on IGS_AD_PS_APPL_INST

Line 40: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,

36: l_msg_data OUT NOCOPY VARCHAR2,
37: l_return_status OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE validate_pref_unique(
40: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
41: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
42: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
43: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
44: p_pref_number IN NUMBER,

Line 41: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

37: l_return_status OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE validate_pref_unique(
40: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
41: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
42: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
43: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
44: p_pref_number IN NUMBER,
45: l_msg_count OUT NOCOPY NUMBER,

Line 42: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

38:
39: PROCEDURE validate_pref_unique(
40: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
41: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
42: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
43: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
44: p_pref_number IN NUMBER,
45: l_msg_count OUT NOCOPY NUMBER,
46: l_msg_data OUT NOCOPY VARCHAR2,

Line 43: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,

39: PROCEDURE validate_pref_unique(
40: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
41: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
42: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
43: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
44: p_pref_number IN NUMBER,
45: l_msg_count OUT NOCOPY NUMBER,
46: l_msg_data OUT NOCOPY VARCHAR2,
47: l_return_status OUT NOCOPY VARCHAR2);