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_RE_VAL_CA dependencies on IGS_AD_OU_STAT

Line 363: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

359: DECLARE
360: v_test VARCHAR2(1);
361: v_message_name VARCHAR2(30);
362: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
363: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
364: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
365: cst_condoffer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
366: CURSOR c_sca IS
367: SELECT sca.student_confirmed_ind

Line 364: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';

360: v_test VARCHAR2(1);
361: v_message_name VARCHAR2(30);
362: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
363: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
364: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
365: cst_condoffer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
366: CURSOR c_sca IS
367: SELECT sca.student_confirmed_ind
368: FROM IGS_EN_STDNT_PS_ATT sca

Line 365: cst_condoffer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';

361: v_message_name VARCHAR2(30);
362: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
363: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
364: cst_offer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'OFFER';
365: cst_condoffer CONSTANT IGS_AD_OU_STAT.s_adm_outcome_status%TYPE := 'COND-OFFER';
366: CURSOR c_sca IS
367: SELECT sca.student_confirmed_ind
368: FROM IGS_EN_STDNT_PS_ATT sca
369: WHERE sca.person_id = p_person_id AND

Line 374: IGS_AD_OU_STAT aos

370: sca.course_cd = p_sca_course_cd;
371: CURSOR c_aos IS
372: SELECT aos.s_adm_outcome_status
373: FROM IGS_AD_PS_APPL_INST acai,
374: IGS_AD_OU_STAT aos
375: WHERE acai.person_id = p_person_id AND
376: acai.admission_appl_number = p_acai_admission_appl_number AND
377: acai.nominated_course_cd = p_acai_nominated_course_cd AND
378: acai.sequence_number = p_acai_sequence_number AND

Line 486: -- IGS_AD_OU_STAT.s_adm_outcome_status 'OFFER' or 'COND-OFFER'.

482: -- mapping to IGS_PS_TYPE.research_type_ind set to 'Y') and
483:
484: -- IGS_AD_PS_APPL_INST.adm_outcome_status maps to
485:
486: -- IGS_AD_OU_STAT.s_adm_outcome_status 'OFFER' or 'COND-OFFER'.
487:
488: -- * An existing IGS_AD_PS_APPL_INST
489:
490: -- (person_id/ acai_admission_appl_number/ acai_nominated_course_cd/

Line 502: -- IGS_AD_OU_STAT.s_adm_outcome_status 'OFFER' or 'COND-OFFER'.

498: -- IGS_AD_PRCS_CAT_STEP.s_admission_step_type 'RESEARCH' and
499:
500: -- IGS_AD_PS_APPL_INST.adm_outcome_status maps to
501:
502: -- IGS_AD_OU_STAT.s_adm_outcome_status 'OFFER' or 'COND-OFFER'.
503:
504: -- * The new IGS_AD_PS_APPL_INST (person_id/ acai_admission_appl_number/
505:
506: -- acai_nominated_course_cd/ acai_sequence_number) does not already have a

Line 778: v_s_adm_otcm_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

774: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE;
775: v_max_submission_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE;
776: v_commencement_dt DATE;
777: v_stdnt_confm_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
778: v_s_adm_otcm_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
779:
780: CURSOR c_sca IS
781: SELECT sca.student_confirmed_ind
782: FROM IGS_EN_STDNT_PS_ATT sca

Line 788: IGS_AD_OU_STAT aos

784: sca.course_cd = p_sca_course_cd;
785: CURSOR c_aos_acai IS
786: SELECT aos.s_adm_outcome_status
787: FROM IGS_AD_PS_APPL_INST acai,
788: IGS_AD_OU_STAT aos
789: WHERE acai.person_id = p_person_id AND
790: acai.admission_appl_number = p_acai_admission_appl_number AND
791: acai.nominated_course_cd = p_acai_nominated_course_cd AND
792: acai.sequence_number = p_acai_sequence_number AND

Line 933: v_s_adm_otcm_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

929: v_min_submission_dt IGS_RE_CANDIDATURE.min_submission_dt%TYPE;
930: v_max_submission_dt IGS_RE_CANDIDATURE.max_submission_dt%TYPE;
931: v_commencement_dt DATE;
932: v_stdnt_confm_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
933: v_s_adm_otcm_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
934: CURSOR c_sca IS
935: SELECT sca.student_confirmed_ind
936: FROM IGS_EN_STDNT_PS_ATT sca
937: WHERE sca.person_id = p_person_id AND

Line 942: IGS_AD_OU_STAT aos

938: sca.course_cd = p_sca_course_cd;
939: CURSOR c_aos_acai IS
940: SELECT aos.s_adm_outcome_status
941: FROM IGS_AD_PS_APPL_INST acai,
942: IGS_AD_OU_STAT aos
943: WHERE acai.person_id = p_person_id AND
944: acai.admission_appl_number = p_acai_admission_appl_number AND
945: acai.nominated_course_cd = p_acai_nominated_course_cd AND
946: acai.sequence_number = p_acai_sequence_number AND

Line 1333: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;

1329: -- admission IGS_PS_COURSE application relationship.
1330:
1331: DECLARE
1332:
1333: v_s_adm_outcome_status IGS_AD_OU_STAT.s_adm_outcome_status%TYPE;
1334:
1335: v_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;
1336:
1337: v_mandatory_step_ind IGS_AD_PRCS_CAT_STEP.mandatory_step_ind%TYPE;

Line 1347: IGS_AD_OU_STAT aos,

1343: cty.research_type_ind
1344:
1345: FROM IGS_AD_PS_APPL_INST acai,
1346:
1347: IGS_AD_OU_STAT aos,
1348:
1349: IGS_PS_VER crv,
1350:
1351: IGS_PS_TYPE cty