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_EN_VAL_SCA dependencies on IGS_RE_CANDIDATURE

Line 76: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

72: cst_research CONSTANT VARCHAR2(10) := 'RESEARCH';
73: cst_offer CONSTANT VARCHAR2(10) := 'OFFER';
74: cst_cond_offer CONSTANT VARCHAR2(10) := 'COND-OFFER';
75: v_message_name varchar2(30) ;
76: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
77: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE;
78: v_s_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;
79: CURSOR c_ca IS
80: SELECT ca.sequence_number,

Line 77: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE;

73: cst_offer CONSTANT VARCHAR2(10) := 'OFFER';
74: cst_cond_offer CONSTANT VARCHAR2(10) := 'COND-OFFER';
75: v_message_name varchar2(30) ;
76: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
77: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE;
78: v_s_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;
79: CURSOR c_ca IS
80: SELECT ca.sequence_number,
81: ca.min_submission_dt

Line 82: FROM IGS_RE_CANDIDATURE ca

78: v_s_adm_outcome_status IGS_AD_PS_APPL_INST.adm_outcome_status%TYPE;
79: CURSOR c_ca IS
80: SELECT ca.sequence_number,
81: ca.min_submission_dt
82: FROM IGS_RE_CANDIDATURE ca
83: WHERE ca.person_id = p_person_id AND (
84: (p_parent = cst_SCA AND
85: ca.sca_course_cd = p_course_cd) OR
86: (p_parent = cst_ACAI and

Line 376: -- This module validates IGS_RE_CANDIDATURE.attendance_percentage and

372: p_candidature_ind IN VARCHAR2,
373: p_message_name OUT NOCOPY VARCHAR2)
374: RETURN BOOLEAN AS
375: BEGIN -- resp_val_ca_att_perc
376: -- This module validates IGS_RE_CANDIDATURE.attendance_percentage and
377: -- IGS_EN_STDNT_PS_ATT.attendance_type.
378: -- Validations are:
379: -- * The load of the research at the nominated attendance percentage must be
380: -- within the upper and lower load ranges for the attendance type in the

Line 388: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;

384: -- point in time. The calendar instance of the unit attempt is only linked
385: -- to one load calendar instance.
386: DECLARE
387: cst_academic CONSTANT VARCHAR2(10) := 'ACADEMIC';
388: v_attendance_percentage IGS_RE_CANDIDATURE.attendance_percentage%TYPE;
389: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
390: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
391: v_load_cal_type IGS_CA_INST_REL.sup_cal_type%TYPE;
392: v_load_ci_sequence_number

Line 409: FROM IGS_RE_CANDIDATURE ca

405: WHERE sca.person_id = p_person_id AND
406: sca.course_cd = p_course_cd;
407: CURSOR c_ca IS
408: SELECT ca.attendance_percentage
409: FROM IGS_RE_CANDIDATURE ca
410: WHERE ca.person_id = p_person_id AND
411: ca.sca_course_cd = p_course_cd;
412: CURSOR c_cir_ci_cat_sua_uv IS
413: SELECT cir.sup_cal_type,

Line 754: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE := NULL;

750: RETURN BOOLEAN AS
751: BEGIN -- resp_val_ca_dtl_comp
752: DECLARE
753: cst_acai CONSTANT VARCHAR2(4) := 'ACAI';
754: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE := NULL;
755: v_max_submission_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE := NULL;
756: v_supervision_start_dt DATE;
757: -- Check for the existence of research details.
758: CURSOR c_ca IS

Line 755: v_max_submission_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE := NULL;

751: BEGIN -- resp_val_ca_dtl_comp
752: DECLARE
753: cst_acai CONSTANT VARCHAR2(4) := 'ACAI';
754: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE := NULL;
755: v_max_submission_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE := NULL;
756: v_supervision_start_dt DATE;
757: -- Check for the existence of research details.
758: CURSOR c_ca IS
759: SELECT ca.sequence_number,

Line 764: FROM IGS_RE_CANDIDATURE ca

760: ca.attendance_percentage,
761: ca.max_submission_dt,
762: ca.min_submission_dt,
763: ca.research_topic
764: FROM IGS_RE_CANDIDATURE ca
765: WHERE ca.person_id = p_person_id AND
766: ((ca.acai_admission_appl_number = p_acai_admission_appl_number AND
767: ca.acai_nominated_course_cd =p_acai_nominated_course_cd AND
768: ca.acai_sequence_number = p_acai_sequence_number) OR

Line 2141: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;

2137: v_commencement_dt IGS_EN_STDNT_PS_ATT.commencement_dt%TYPE;
2138: v_course_start_dt IGS_CA_DA_INST_V.alias_val%TYPE;
2139: v_birth_dt IGS_PE_PERSON.birth_dt%TYPE;
2140: v_candidature_exists_ind VARCHAR2(1);
2141: v_ca_sequence_number IGS_RE_CANDIDATURE.sequence_number%TYPE;
2142: v_message_name varchar2(30);
2143: -- Temporary variables
2144: v_dt_diff NUMBER;
2145: v_alias_val IGS_CA_DA_INST_V.alias_val%TYPE;

Line 2225: IGS_RE_CANDIDATURE ca,

2221: v_sua_ci_exists VARCHAR2(1);
2222: CURSOR c_sct_ca_sca IS
2223: SELECT sca.commencement_dt
2224: FROM IGS_PS_STDNT_TRN sct,
2225: IGS_RE_CANDIDATURE ca,
2226: IGS_EN_STDNT_PS_ATT sca
2227: WHERE sct.person_id = p_person_id AND
2228: sct.course_cd = p_course_cd AND
2229: sct.person_id = ca.person_id AND