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_UNIT_SETS_PKG dependencies on IGS_AD_APPL_ALL

Line 373: FROM igs_ad_unit_sets aus, igs_ad_appl_all apl, igs_ad_ps_appl_inst_all inst

369: (reverse chronological order - newest change first)
370: ***************************************************************/
371: CURSOR cur_rowid IS
372: SELECT aus.rowid
373: FROM igs_ad_unit_sets aus, igs_ad_appl_all apl, igs_ad_ps_appl_inst_all inst
374: WHERE aus.person_id = apl.person_id
375: AND aus.admission_appl_number = apl.admission_appl_number
376: AND aus.person_id = inst.person_id
377: AND aus.admission_appl_number = inst.admission_appl_number

Line 407: ,p_admission_cat igs_ad_appl_all.admission_cat%TYPE

403: FUNCTION Validate_Unit_Set(p_version_number igs_ad_unit_sets.version_number%TYPE
404: ,p_unit_set_cd igs_ad_unit_sets.unit_set_cd%TYPE
405: ,p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
406: ,p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE
407: ,p_admission_cat igs_ad_appl_all.admission_cat%TYPE
408: ,p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE
409: ,p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE
410: ,p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE
411: ,p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE)

Line 408: ,p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE

404: ,p_unit_set_cd igs_ad_unit_sets.unit_set_cd%TYPE
405: ,p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE
406: ,p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE
407: ,p_admission_cat igs_ad_appl_all.admission_cat%TYPE
408: ,p_acad_cal_type igs_ad_appl_all.acad_cal_type%TYPE
409: ,p_location_cd igs_ad_ps_appl_inst_all.location_cd%TYPE
410: ,p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%TYPE
411: ,p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%TYPE)
412: RETURN BOOLEAN

Line 526: FROM igs_ad_appl_all apli

522: ,apli.acad_cal_type
523: ,appinsti.attendance_type
524: ,appinsti.attendance_mode
525: ,appinsti.location_cd
526: FROM igs_ad_appl_all apli
527: ,igs_ad_ps_appl_inst_all appinsti
528: WHERE appinsti.person_id = x_person_id
529: AND appinsti.nominated_course_cd =x_nominated_course_cd
530: AND appinsti.admission_appl_number= x_admission_appl_number