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_ACAI dependencies on IGS_EN_STDNT_PS_ATT

Line 364: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;

360: BEGIN --admp_val_acai_update
361: --This module validates update of an IGS_AD_PS_APPL_INST record.
362: DECLARE
363: v_s_appl_inst_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
364: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
365: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
366: CURSOR c_sca (
367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
368: cp_admission_appl_number

Line 367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,

363: v_s_appl_inst_status IGS_AD_APPL_STAT.s_adm_appl_status%TYPE;
364: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
365: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
366: CURSOR c_sca (
367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
368: cp_admission_appl_number
369: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
370: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
371: cp_acai_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS

Line 369: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,

365: cst_withdrawn CONSTANT VARCHAR2(10) := 'WITHDRAWN';
366: CURSOR c_sca (
367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
368: cp_admission_appl_number
369: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
370: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
371: cp_acai_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
372: SELECT sca.person_id
373: FROM IGS_EN_STDNT_PS_ATT sca

Line 370: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,

366: CURSOR c_sca (
367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
368: cp_admission_appl_number
369: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
370: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
371: cp_acai_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
372: SELECT sca.person_id
373: FROM IGS_EN_STDNT_PS_ATT sca
374: WHERE sca.person_id = cp_person_id AND

Line 371: cp_acai_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS

367: cp_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE,
368: cp_admission_appl_number
369: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
370: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
371: cp_acai_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
372: SELECT sca.person_id
373: FROM IGS_EN_STDNT_PS_ATT sca
374: WHERE sca.person_id = cp_person_id AND
375: sca.adm_admission_appl_number IS NOT NULL AND

Line 373: FROM IGS_EN_STDNT_PS_ATT sca

369: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
370: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
371: cp_acai_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
372: SELECT sca.person_id
373: FROM IGS_EN_STDNT_PS_ATT sca
374: WHERE sca.person_id = cp_person_id AND
375: sca.adm_admission_appl_number IS NOT NULL AND
376: sca.adm_admission_appl_number = cp_admission_appl_number AND
377: sca.adm_nominated_course_cd IS NOT NULL AND

Line 824: FROM IGS_EN_STDNT_PS_ATT

820: SELECT course_attempt_status,
821: fee_cat,
822: correspondence_cat,
823: discontinued_dt
824: FROM IGS_EN_STDNT_PS_ATT
825: WHERE person_id = p_person_id AND
826: course_cd = p_course_cd;
827: CURSOR c_fcm (
828: cp_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE) IS

Line 828: cp_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE) IS

824: FROM IGS_EN_STDNT_PS_ATT
825: WHERE person_id = p_person_id AND
826: course_cd = p_course_cd;
827: CURSOR c_fcm (
828: cp_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE) IS
829: SELECT 'x'
830: FROM IGS_FI_FEE_CAT_MAP
831: WHERE admission_cat = p_admission_cat AND
832: fee_cat = cp_fee_cat;

Line 835: cp_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE) IS

831: WHERE admission_cat = p_admission_cat AND
832: fee_cat = cp_fee_cat;
833:
834: CURSOR c_ccm (
835: cp_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE) IS
836: SELECT 'x'
837: FROM IGS_CO_CAT_MAP
838: WHERE admission_cat = p_admission_cat AND
839: correspondence_cat = cp_correspondence_cat;

Line 3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;

3469: IGS_AD_PS_APPL_INST_APLINST_V.basis_for_admission_type%TYPE;
3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;
3476: v_scae_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
3477: v_dummy VARCHAR2(1);

Line 3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;

3470: v_admission_cd IGS_AD_PS_APPL_INST_APLINST_V.admission_cd%TYPE;
3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;
3476: v_scae_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
3477: v_dummy VARCHAR2(1);
3478: v_error_message_research VARCHAR2(30);

Line 3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;

3471: v_course_rank_set IGS_AD_PS_APPL_INST_APLINST_V.course_rank_set%TYPE;
3472: v_course_rank_schedule IGS_AD_PS_APPL_INST_APLINST_V.course_rank_schedule%TYPE;
3473: v_sca_fee_cat IGS_EN_STDNT_PS_ATT.fee_cat%TYPE;
3474: v_sca_funding_source IGS_EN_STDNT_PS_ATT.funding_source%TYPE;
3475: v_sca_correspondence_cat IGS_EN_STDNT_PS_ATT.correspondence_cat%TYPE;
3476: v_scae_enrolment_cat IGS_AS_SC_ATMPT_ENR.enrolment_cat%TYPE;
3477: v_dummy VARCHAR2(1);
3478: v_error_message_research VARCHAR2(30);
3479:

Line 3512: FROM IGS_EN_STDNT_PS_ATT sca

3508: CURSOR c_sca IS
3509: SELECT sca.fee_cat,
3510: sca.correspondence_cat,
3511: sca.funding_source
3512: FROM IGS_EN_STDNT_PS_ATT sca
3513: WHERE sca.person_id = p_person_id AND
3514: sca.course_cd = p_course_cd;
3515: CURSOR c_scae IS
3516: SELECT scae.enrolment_cat