APPS.IGS_AD_UNIT_SETS_PKG dependencies on IGS_AD_PS_APPL_INST_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 405: ,p_nominated_course_cd igs_ad_ps_appl_inst_all.nominated_course_cd%TYPE

401: -- end oxford unit set code bug 5194658
402:
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

Line 406: ,p_crv_version_number igs_ad_ps_appl_inst_all.crv_version_number%TYPE

402:
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

Line 409: ,p_location_cd igs_ad_ps_appl_inst_all.location_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
413: IS

Line 410: ,p_attendance_mode igs_ad_ps_appl_inst_all.attendance_mode%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
413: IS
414: CURSOR cur_unit_sets IS

Line 411: ,p_attendance_type igs_ad_ps_appl_inst_all.attendance_type%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
413: IS
414: CURSOR cur_unit_sets IS
415: SELECT '1'

Line 527: ,igs_ad_ps_appl_inst_all appinsti

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
531: AND appinsti.sequence_number = x_sequence_number