APPS.IGS_RE_VAL_CA dependencies on IGS_AD_PS_APPL_INST

Line 54: -- This modules validates IGS_AD_PS_APPL_INST.prpsd_commencement_dt.

50: RETURN BOOLEAN AS
51:
52: BEGIN -- admp_val_acai_comm
53:
54: -- This modules validates IGS_AD_PS_APPL_INST.prpsd_commencement_dt.
55:
56: -- Validations are:
57:
58: -- * IGS_RE_CANDIDATURE must exist for the IGS_AD_PS_APPL_INST.

Line 58: -- * IGS_RE_CANDIDATURE must exist for the IGS_AD_PS_APPL_INST.

54: -- This modules validates IGS_AD_PS_APPL_INST.prpsd_commencement_dt.
55:
56: -- Validations are:
57:
58: -- * IGS_RE_CANDIDATURE must exist for the IGS_AD_PS_APPL_INST.
59:
60: -- * Prpsd_commencement_dt must be greater than the earlier of the IGS_PS_COURSE
61:
62: -- start date or the admission academic period earliest research start date.

Line 373: FROM IGS_AD_PS_APPL_INST acai,

369: WHERE sca.person_id = p_person_id AND
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

Line 468: -- This module validates the IGS_RE_CANDIDATURE link to an IGS_AD_PS_APPL_INST.

464: RETURN BOOLEAN AS
465:
466: BEGIN -- resp_val_ca_acai
467:
468: -- This module validates the IGS_RE_CANDIDATURE link to an IGS_AD_PS_APPL_INST.
469:
470: -- The following is validated.
471:
472: -- * An existing IGS_AD_PS_APPL_INST

Line 472: -- * An existing IGS_AD_PS_APPL_INST

468: -- This module validates the IGS_RE_CANDIDATURE link to an IGS_AD_PS_APPL_INST.
469:
470: -- The following is validated.
471:
472: -- * An existing IGS_AD_PS_APPL_INST
473:
474: -- (person_id/ acai_admission_appl_number/ acai_nominated_course_cd/
475:
476: -- acai_sequence_number) link cannot be removed if the new application is

Line 484: -- IGS_AD_PS_APPL_INST.adm_outcome_status maps to

480: -- a research IGS_PS_COURSE (defined by IGS_PS_VER.course_cd/ version_number
481:
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

Line 488: -- * An existing IGS_AD_PS_APPL_INST

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/
491:
492: -- acai_sequence_number) link cannot be removed if the admission application

Line 500: -- IGS_AD_PS_APPL_INST.adm_outcome_status maps to

496: -- mandatory ie IGS_AD_PRCS_CAT_STEP.mandatory_step_ind 'Y' where for
497:
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/

Line 504: -- * The new IGS_AD_PS_APPL_INST (person_id/ acai_admission_appl_number/

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
507:
508: -- research IGS_RE_CANDIDATURE.

Line 510: -- * The new IGS_AD_PS_APPL_INST (person_id/ acai_admission_appl_number/

506: -- acai_nominated_course_cd/ acai_sequence_number) does not already have a
507:
508: -- research IGS_RE_CANDIDATURE.
509:
510: -- * The new IGS_AD_PS_APPL_INST (person_id/ acai_admission_appl_number/
511:
512: -- acai_nominated_course_cd/ acai_sequence_number) must map to an admission
513:
514: -- application defined by an admission process category where research

Line 787: FROM IGS_AD_PS_APPL_INST acai,

783: WHERE sca.person_id = p_person_id AND
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

Line 941: FROM IGS_AD_PS_APPL_INST acai,

937: WHERE sca.person_id = p_person_id AND
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

Line 1323: -- IGS_AD_PS_APPL_INST link. This may be the result of deletion of

1319: BEGIN -- resp_val_ca_acai_del
1320:
1321: -- This module validates the removal of a IGS_RE_CANDIDATURE/
1322:
1323: -- IGS_AD_PS_APPL_INST link. This may be the result of deletion of
1324:
1325: -- IGS_RE_CANDIDATURE, or removal/change of IGS_RE_CANDIDATURE.acai_admission_appl_number/
1326:
1327: -- acai_nominated_course_cd/ acai_sequence_number which defines an existing

Line 1345: FROM IGS_AD_PS_APPL_INST acai,

1341: SELECT aos.s_adm_outcome_status,
1342:
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,

Line 1706: -- / acai_nominated_course_cd/acai_sequence_number(IGS_AD_PS_APPL_INST)

1702: -- The following is validated:
1703:
1704: -- * One of sca_course_cd(IGS_EN_STDNT_PS_ATT) or acai_admission_appl_number
1705:
1706: -- / acai_nominated_course_cd/acai_sequence_number(IGS_AD_PS_APPL_INST)
1707:
1708: -- must be defined.
1709:
1710: -- * If sca_course_cd exists, then IGS_EN_STDNT_PS_ATT and IGS_RE_CANDIDATURE