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_SS_APPL_UPD_PAGE dependencies on IGS_AD_PS_APPL_INST

Line 581: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,

577: RETURN;
578: END validate_due_final_dt;
579:
580: PROCEDURE validate_pref_unique(
581: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
582: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
583: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
584: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
585: p_pref_number IN NUMBER,

Line 582: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

578: END validate_due_final_dt;
579:
580: PROCEDURE validate_pref_unique(
581: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
582: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
583: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
584: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
585: p_pref_number IN NUMBER,
586: l_msg_count OUT NOCOPY NUMBER,

Line 583: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

579:
580: PROCEDURE validate_pref_unique(
581: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
582: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
583: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
584: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
585: p_pref_number IN NUMBER,
586: l_msg_count OUT NOCOPY NUMBER,
587: l_msg_data OUT NOCOPY VARCHAR2,

Line 584: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,

580: PROCEDURE validate_pref_unique(
581: p_person_id IN IGS_AD_PS_APPL_INST.person_id%TYPE,
582: p_adm_appl_no IN IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
583: p_course_cd IN IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
584: p_seq_number IN IGS_AD_PS_APPL_INST.sequence_number%TYPE,
585: p_pref_number IN NUMBER,
586: l_msg_count OUT NOCOPY NUMBER,
587: l_msg_data OUT NOCOPY VARCHAR2,
588: l_return_status OUT NOCOPY VARCHAR2) AS

Line 590: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,

586: l_msg_count OUT NOCOPY NUMBER,
587: l_msg_data OUT NOCOPY VARCHAR2,
588: l_return_status OUT NOCOPY VARCHAR2) AS
589: CURSOR c_acai (
590: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
591: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
592: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
593: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
594: SELECT acai.preference_number

Line 591: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,

587: l_msg_data OUT NOCOPY VARCHAR2,
588: l_return_status OUT NOCOPY VARCHAR2) AS
589: CURSOR c_acai (
590: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
591: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
592: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
593: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
594: SELECT acai.preference_number
595: FROM IGS_AD_PS_APPL_INST acai

Line 592: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,

588: l_return_status OUT NOCOPY VARCHAR2) AS
589: CURSOR c_acai (
590: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
591: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
592: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
593: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
594: SELECT acai.preference_number
595: FROM IGS_AD_PS_APPL_INST acai
596: WHERE acai.person_id = cp_person_id AND

Line 593: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS

589: CURSOR c_acai (
590: cp_person_id IGS_AD_PS_APPL_INST.person_id%TYPE,
591: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
592: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
593: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
594: SELECT acai.preference_number
595: FROM IGS_AD_PS_APPL_INST acai
596: WHERE acai.person_id = cp_person_id AND
597: acai.admission_appl_number = cp_admission_appl_number AND

Line 595: FROM IGS_AD_PS_APPL_INST acai

591: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
592: cp_nominated_course_cd IGS_AD_PS_APPL_INST.nominated_course_cd%TYPE,
593: cp_acai_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE) IS
594: SELECT acai.preference_number
595: FROM IGS_AD_PS_APPL_INST acai
596: WHERE acai.person_id = cp_person_id AND
597: acai.admission_appl_number = cp_admission_appl_number AND
598: NOT (acai.nominated_course_cd = cp_nominated_course_cd AND
599: acai.sequence_number = cp_acai_sequence_number)