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

Line 16: -- Validate IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind

12: p_message_name OUT NOCOPY VARCHAR2 )
13: RETURN BOOLEAN AS
14: gv_other_detail VARCHAR2(255);
15: BEGIN -- prgp_val_susa_cmplt
16: -- Validate IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind
17: -- and the IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind
18: -- * Cannot be set if any IGS_AS_SU_SETATMPT records
19: -- are incomplete or unended for the IGS_PS_COURSE attempt.
20: DECLARE

Line 72: -- Validate IGS_EN_STDNT_PS_ATT.course_attempt_status when setting the

68: p_message_name OUT NOCOPY VARCHAR2 )
69: RETURN BOOLEAN AS
70: gv_other_detail VARCHAR2(255);
71: BEGIN -- prgp_val_sca_status
72: -- Validate IGS_EN_STDNT_PS_ATT.course_attempt_status when setting the
73: --student_course_attepmt.course_rqrmnt_complete_ind or the
74: --IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind.
75: --? Cannot be set if course_attempt_status is 'COMPLETED' or 'UNCONFIRM'.
76: --

Line 80: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';

76: --
77: -- Modified 28/01/99 to only test for UNCONFIRM (Greg White).
78: DECLARE
79: cst_unconfirm CONSTANT
80: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
81: v_sca_course_attempt_status
82: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
83: CURSOR c_sca IS
84: SELECT sca.course_attempt_status

Line 82: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;

78: DECLARE
79: cst_unconfirm CONSTANT
80: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE := 'UNCONFIRM';
81: v_sca_course_attempt_status
82: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
83: CURSOR c_sca IS
84: SELECT sca.course_attempt_status
85: FROM IGS_EN_STDNT_PS_ATT sca
86: WHERE sca.person_id = p_person_id And

Line 85: FROM IGS_EN_STDNT_PS_ATT sca

81: v_sca_course_attempt_status
82: IGS_EN_STDNT_PS_ATT.course_attempt_status%TYPE;
83: CURSOR c_sca IS
84: SELECT sca.course_attempt_status
85: FROM IGS_EN_STDNT_PS_ATT sca
86: WHERE sca.person_id = p_person_id And
87: sca.course_cd = p_course_cd And
88: sca.course_attempt_status = cst_unconfirm;
89: BEGIN

Line 222: -- Validate IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind and the

218: p_message_name OUT NOCOPY VARCHAR2 )
219: RETURN BOOLEAN AS
220: gv_other_detail VARCHAR2(255);
221: BEGIN -- prgp_val_cmplt_ind
222: -- Validate IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind and the
223: -- IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind.
224: --* Both cannot be set for the same IGS_PS_COURSE attempt
225: DECLARE
226: cst_course CONSTANT VARCHAR2(11) := 'COURSE';

Line 229: v_sca_rec IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;

225: DECLARE
226: cst_course CONSTANT VARCHAR2(11) := 'COURSE';
227: cst_exit_course CONSTANT VARCHAR2(11) := 'EXIT_COURSE';
228: v_scaae_rec IGS_PS_STDNT_APV_ALT.rqrmnts_complete_ind%TYPE;
229: v_sca_rec IGS_EN_STDNT_PS_ATT.course_rqrmnt_complete_ind%TYPE;
230: CURSOR c_scaae IS
231: SELECT 'X'
232: FROM IGS_PS_STDNT_APV_ALT scaae
233: WHERE scaae.person_id = p_person_id AND

Line 238: FROM IGS_EN_STDNT_PS_ATT sca

234: scaae.course_cd = p_course_cd AND
235: scaae.rqrmnts_complete_ind = 'Y';
236: CURSOR c_sca IS
237: SELECT 'X'
238: FROM IGS_EN_STDNT_PS_ATT sca
239: WHERE sca.person_id = p_person_id AND
240: sca.course_cd = p_course_cd AND
241: sca.course_rqrmnt_complete_ind = 'Y';
242: BEGIN

Line 331: -- To validate the IGS_EN_STDNT_PS_ATT.course_rqrmnts_complete_dt

327: --IGS_GE_MSG_STACK.ADD;
328:
329: END prgp_val_sca_crcd;
330: --
331: -- To validate the IGS_EN_STDNT_PS_ATT.course_rqrmnts_complete_dt
332: FUNCTION prgp_val_sca_cmpl_dt(
333: p_person_id IN NUMBER,
334: p_course_cd IN VARCHAR2,
335: p_commencement_dt IN DATE,

Line 343: || Purpose : Validate the IGS_EN_STDNT_PS_ATT.course_rqrmnts_complete_dt,

339: RETURN BOOLEAN AS
340: /*----------------------------------------------------------------------------
341: || Created By :
342: || Created On :
343: || Purpose : Validate the IGS_EN_STDNT_PS_ATT.course_rqrmnts_complete_dt,
344: || checking for:
345: || cannot be a future date
346: || cannot be a future date
347: || cannot pre-date the IGS_EN_STDNT_PS_ATT.commencement_dt

Line 347: || cannot pre-date the IGS_EN_STDNT_PS_ATT.commencement_dt

343: || Purpose : Validate the IGS_EN_STDNT_PS_ATT.course_rqrmnts_complete_dt,
344: || checking for:
345: || cannot be a future date
346: || cannot be a future date
347: || cannot pre-date the IGS_EN_STDNT_PS_ATT.commencement_dt
348: || warn if pre-dates the outcome date of the students last enteredn outcome
349: || Known limitations, enhancements or remarks :
350: || Change History :
351: || Who When What