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_VAL_APCOOD dependencies on IGS_AD_PECRS_OFOP_DT

Line 373: FROM IGS_AD_PECRS_OFOP_DT

369: -- specified admission category and system admission process type.
370: DECLARE
371: CURSOR c_apcood IS
372: SELECT 'x'
373: FROM IGS_AD_PECRS_OFOP_DT
374: WHERE adm_cal_type = p_adm_cal_type AND
375: adm_ci_sequence_number = p_adm_ci_sequence_number AND
376: admission_cat = p_admission_cat AND
377: dt_alias = p_dt_alias AND

Line 382: FROM IGS_AD_PECRS_OFOP_DT

378: (dai_sequence_number <> p_dai_sequence_number OR
379: sequence_number <> p_apcood_sequence_number);
380: CURSOR c_apcood2 IS
381: SELECT 'x'
382: FROM IGS_AD_PECRS_OFOP_DT
383: WHERE adm_cal_type = p_adm_cal_type AND
384: adm_ci_sequence_number = p_adm_ci_sequence_number AND
385: admission_cat = p_admission_cat AND
386: dt_alias = p_dt_alias AND

Line 405: FROM IGS_AD_PECRS_OFOP_DT

401: acad_cal_type,
402: location_cd,
403: attendance_mode,
404: attendance_type
405: FROM IGS_AD_PECRS_OFOP_DT
406: WHERE adm_cal_type = p_adm_cal_type AND
407: adm_ci_sequence_number = p_adm_ci_sequence_number AND
408: admission_cat = p_admission_cat AND
409: dt_alias = p_dt_alias AND

Line 424: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE,

420: v_null_ind BOOLEAN := FALSE;
421: v_message_name varchar2(30);
422: FUNCTION admpl_val_check_conflicts (
423: p_new_s_admission_process_type
424: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE,
425: p_new_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE,
426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,
427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,
428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,

Line 425: p_new_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE,

421: v_message_name varchar2(30);
422: FUNCTION admpl_val_check_conflicts (
423: p_new_s_admission_process_type
424: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE,
425: p_new_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE,
426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,
427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,
428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,
429: p_new_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE,

Line 426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,

422: FUNCTION admpl_val_check_conflicts (
423: p_new_s_admission_process_type
424: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE,
425: p_new_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE,
426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,
427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,
428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,
429: p_new_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE,
430: p_new_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE)

Line 427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,

423: p_new_s_admission_process_type
424: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE,
425: p_new_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE,
426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,
427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,
428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,
429: p_new_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE,
430: p_new_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE)
431: RETURN BOOLEAN

Line 428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,

424: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE,
425: p_new_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE,
426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,
427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,
428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,
429: p_new_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE,
430: p_new_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE)
431: RETURN BOOLEAN
432: IS

Line 429: p_new_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE,

425: p_new_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE,
426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,
427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,
428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,
429: p_new_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE,
430: p_new_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE)
431: RETURN BOOLEAN
432: IS
433: BEGIN

Line 430: p_new_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE)

426: p_new_acad_cal_type IGS_AD_PECRS_OFOP_DT.acad_cal_type%TYPE,
427: p_new_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE,
428: p_new_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode%TYPE,
429: p_new_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE,
430: p_new_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE)
431: RETURN BOOLEAN
432: IS
433: BEGIN
434: -- IF any of the components do not match, THEN everything is OK,

Line 684: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE;

680: -- the record being validated AND the record found with a first level
681: -- conflict, AND checking for the existence of a record with this combination.
682: DECLARE
683: v_s_admission_process_type
684: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE;
685: v_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE;
686: v_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE;
687: v_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE;
688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;

Line 685: v_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE;

681: -- conflict, AND checking for the existence of a record with this combination.
682: DECLARE
683: v_s_admission_process_type
684: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE;
685: v_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE;
686: v_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE;
687: v_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE;
688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;
689: v_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE;

Line 686: v_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE;

682: DECLARE
683: v_s_admission_process_type
684: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE;
685: v_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE;
686: v_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE;
687: v_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE;
688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;
689: v_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE;
690: CURSOR c_apcood IS

Line 687: v_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE;

683: v_s_admission_process_type
684: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE;
685: v_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE;
686: v_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE;
687: v_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE;
688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;
689: v_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE;
690: CURSOR c_apcood IS
691: SELECT 'x'

Line 688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;

684: IGS_AD_PECRS_OFOP_DT.s_admission_process_type%TYPE;
685: v_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE;
686: v_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE;
687: v_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE;
688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;
689: v_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE;
690: CURSOR c_apcood IS
691: SELECT 'x'
692: FROM IGS_AD_PECRS_OFOP_DT

Line 689: v_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE;

685: v_course_cd IGS_AD_PECRS_OFOP_DT.course_cd%TYPE;
686: v_version_number IGS_AD_PECRS_OFOP_DT.version_number%TYPE;
687: v_location_cd IGS_AD_PECRS_OFOP_DT.location_cd%TYPE;
688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;
689: v_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE;
690: CURSOR c_apcood IS
691: SELECT 'x'
692: FROM IGS_AD_PECRS_OFOP_DT
693: WHERE adm_cal_type = p_adm_cal_type AND

Line 692: FROM IGS_AD_PECRS_OFOP_DT

688: v_attendance_mode IGS_AD_PECRS_OFOP_DT.attendance_mode %TYPE;
689: v_attendance_type IGS_AD_PECRS_OFOP_DT.attendance_type%TYPE;
690: CURSOR c_apcood IS
691: SELECT 'x'
692: FROM IGS_AD_PECRS_OFOP_DT
693: WHERE adm_cal_type = p_adm_cal_type AND
694: adm_ci_sequence_number = p_adm_ci_sequence_number AND
695: admission_cat = p_admission_cat AND
696: dt_alias = p_dt_alias AND

Line 783: cp_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE) IS

779: WHERE cal_type = p_adm_cal_type AND
780: ci_sequence_number = p_adm_ci_sequence_number AND
781: dt_alias = p_dt_alias;
782: CURSOR c_apcood (
783: cp_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE) IS
784: SELECT 'x'
785: FROM IGS_AD_PECRS_OFOP_DT
786: WHERE adm_cal_type = p_adm_cal_type AND
787: adm_ci_sequence_number = p_adm_ci_sequence_number AND

Line 785: FROM IGS_AD_PECRS_OFOP_DT

781: dt_alias = p_dt_alias;
782: CURSOR c_apcood (
783: cp_sequence_number IGS_AD_PECRS_OFOP_DT.dai_sequence_number%TYPE) IS
784: SELECT 'x'
785: FROM IGS_AD_PECRS_OFOP_DT
786: WHERE adm_cal_type = p_adm_cal_type AND
787: adm_ci_sequence_number = p_adm_ci_sequence_number AND
788: dt_alias = p_dt_alias AND
789: dai_sequence_number = cp_sequence_number AND