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_EN_STDNT_PS_ATT

Line 223: -- IGS_EN_STDNT_PS_ATT.course_attempt_status is 'COMPLETED' with all its awards completed.

219: -- This module validates the update of IGS_RE_CANDIDATURE details. Validations are:
220:
221: -- IGS_RE_CANDIDATURE cannot be updated if
222:
223: -- IGS_EN_STDNT_PS_ATT.course_attempt_status is 'COMPLETED' with all its awards completed.
224:
225: -- If atleast one award is incomplete or no award is associated, update is allowed but a
226:
227: -- message is returned.

Line 234: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

230: DECLARE
231:
232: cst_completed CONSTANT VARCHAR2(10) := 'COMPLETED';
233:
234: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
235: v_dummy VARCHAR2(10);
236: CURSOR c_sca IS
237:
238: SELECT sca.course_attempt_status

Line 240: FROM IGS_EN_STDNT_PS_ATT sca

236: CURSOR c_sca IS
237:
238: SELECT sca.course_attempt_status
239:
240: FROM IGS_EN_STDNT_PS_ATT sca
241:
242: WHERE sca.person_id = p_person_id AND
243:
244: sca.course_cd = p_sca_course_cd;

Line 362: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

358: BEGIN -- resp_val_ca_topic
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

Line 368: FROM IGS_EN_STDNT_PS_ATT sca

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
370: sca.course_cd = p_sca_course_cd;
371: CURSOR c_aos IS
372: SELECT aos.s_adm_outcome_status

Line 777: v_stdnt_confm_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

773: cst_cond_offer CONSTANT VARCHAR2(10) := 'COND-OFFER';
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

Line 782: FROM IGS_EN_STDNT_PS_ATT sca

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
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

Line 932: v_stdnt_confm_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

928: cst_cond_offer CONSTANT VARCHAR2(10) := 'COND-OFFER';
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

Line 936: FROM IGS_EN_STDNT_PS_ATT sca

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
938: sca.course_cd = p_sca_course_cd;
939: CURSOR c_aos_acai IS
940: SELECT aos.s_adm_outcome_status

Line 1088: -- This module validates the IGS_RE_CANDIDATURE link to a IGS_EN_STDNT_PS_ATT.

1084: p_acai_sequence_number IN NUMBER ,
1085: p_message_name OUT NOCOPY VARCHAR2 )
1086: RETURN BOOLEAN AS
1087: BEGIN -- resp_val_ca_sca
1088: -- This module validates the IGS_RE_CANDIDATURE link to a IGS_EN_STDNT_PS_ATT.
1089: DECLARE
1090: v_message_name VARCHAR2(30);
1091:
1092: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

Line 1092: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

1088: -- This module validates the IGS_RE_CANDIDATURE link to a IGS_EN_STDNT_PS_ATT.
1089: DECLARE
1090: v_message_name VARCHAR2(30);
1091:
1092: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1093:
1094: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1095:
1096: v_test VARCHAR2(1);

Line 1094: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

1090: v_message_name VARCHAR2(30);
1091:
1092: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1093:
1094: v_course_attempt_status IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
1095:
1096: v_test VARCHAR2(1);
1097:
1098: cst_discontin CONSTANT

Line 1100: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DISCONTIN';

1096: v_test VARCHAR2(1);
1097:
1098: cst_discontin CONSTANT
1099:
1100: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DISCONTIN';
1101:
1102: cst_lapsed CONSTANT
1103:
1104: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

Line 1104: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';

1100: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'DISCONTIN';
1101:
1102: cst_lapsed CONSTANT
1103:
1104: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
1105:
1106: cst_completed CONSTANT
1107:
1108: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

Line 1108: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';

1104: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'LAPSED';
1105:
1106: cst_completed CONSTANT
1107:
1108: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'COMPLETED';
1109:
1110: CURSOR c_sca (
1111:
1112: cp_course_cd IGS_RE_CANDIDATURE.sca_course_cd%TYPE)

Line 1120: FROM IGS_EN_STDNT_PS_ATT sca

1116: SELECT sca.student_confirmed_ind,
1117:
1118: sca.course_attempt_status
1119:
1120: FROM IGS_EN_STDNT_PS_ATT sca
1121:
1122: WHERE sca.person_id = p_person_id AND
1123:
1124: sca.course_cd = cp_course_cd;

Line 1504: -- This module validates the removal of a IGS_RE_CANDIDATURE/IGS_EN_STDNT_PS_ATT

1500: RETURN BOOLEAN AS
1501:
1502: BEGIN -- resp_val_ca_sca_del
1503:
1504: -- This module validates the removal of a IGS_RE_CANDIDATURE/IGS_EN_STDNT_PS_ATT
1505:
1506: -- link.
1507:
1508: -- This may be the result of deletion of IGS_RE_CANDIDATURE, or removal/change of

Line 1516: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;

1512: -- relationship.
1513:
1514: DECLARE
1515:
1516: v_student_confirmed_ind IGS_EN_STDNT_PS_ATT.student_confirmed_ind%TYPE;
1517:
1518: v_research_type_ind IGS_PS_TYPE.research_type_ind%TYPE;
1519:
1520: CURSOR c_sca IS

Line 1526: FROM IGS_EN_STDNT_PS_ATT sca,

1522: SELECT sca.student_confirmed_ind,
1523:
1524: cty.research_type_ind
1525:
1526: FROM IGS_EN_STDNT_PS_ATT sca,
1527:
1528: IGS_PS_VER crv,
1529:
1530: IGS_PS_TYPE cty

Line 1704: -- * One of sca_course_cd(IGS_EN_STDNT_PS_ATT) or acai_admission_appl_number

1700: -- will only be called from the database trigger.
1701:
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.

Line 1710: -- * If sca_course_cd exists, then IGS_EN_STDNT_PS_ATT and IGS_RE_CANDIDATURE

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
1711:
1712: -- admission details must match.
1713:
1714: DECLARE

Line 1724: FROM IGS_EN_STDNT_PS_ATT sca

1720: sca.adm_nominated_course_cd,
1721:
1722: sca.adm_sequence_number
1723:
1724: FROM IGS_EN_STDNT_PS_ATT sca
1725:
1726: WHERE sca.person_id = p_person_id AND
1727:
1728: sca.course_cd = p_sca_course_cd;