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_EN_VAL_SCA dependencies on IGS_PS_OFR_PAT

Line 2580: -- Validate the IGS_PS_OFR_PAT for a IGS_EN_STDNT_PS_ATT

2576: IGS_GE_MSG_STACK.ADD;
2577: App_Exception.Raise_Exception;
2578: END ENRP_VAL_SCA_FS;
2579: --
2580: -- Validate the IGS_PS_OFR_PAT for a IGS_EN_STDNT_PS_ATT
2581: FUNCTION enrp_val_sca_cop(
2582: p_course_cd IN VARCHAR2 ,
2583: p_version_number IN NUMBER ,
2584: p_location_cd IN VARCHAR2 ,

Line 2595: v_cop_rec IGS_PS_OFR_PAT%ROWTYPE;

2591: BEGIN
2592: BEGIN
2593: DECLARE
2594: v_other_detail VARCHAR2(255);
2595: v_cop_rec IGS_PS_OFR_PAT%ROWTYPE;
2596: v_ci_rec IGS_CA_INST%ROWTYPE;
2597: v_cs_scs IGS_CA_STAT.s_cal_status%TYPE;
2598: cst_active CONSTANT VARCHAR2(8):= 'ACTIVE';
2599: CURSOR c_cop_rec IS

Line 2601: FROM IGS_PS_OFR_PAT

2597: v_cs_scs IGS_CA_STAT.s_cal_status%TYPE;
2598: cst_active CONSTANT VARCHAR2(8):= 'ACTIVE';
2599: CURSOR c_cop_rec IS
2600: SELECT *
2601: FROM IGS_PS_OFR_PAT
2602: WHERE course_cd = p_course_cd AND
2603: version_number = p_version_number AND
2604: location_cd = p_location_cd AND
2605: attendance_mode = p_attendance_mode AND

Line 2621: -- This module validates the IGS_PS_OFR_PAT

2617: IGS_CA_INST
2618: WHERE IGS_CA_STAT.cal_status = v_ci_rec.cal_status;
2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN
2621: -- This module validates the IGS_PS_OFR_PAT
2622: -- for the curent IGS_EN_STDNT_PS_ATT.
2623: -- checking if the IGS_PS_OFR_PAT
2624: -- offered_ind is set to 'N'
2625: OPEN c_cop_rec;

Line 2623: -- checking if the IGS_PS_OFR_PAT

2619: -- WHERE IGS_CA_STAT.cal_status = IGS_CA_INST.cal_status;
2620: BEGIN
2621: -- This module validates the IGS_PS_OFR_PAT
2622: -- for the curent IGS_EN_STDNT_PS_ATT.
2623: -- checking if the IGS_PS_OFR_PAT
2624: -- offered_ind is set to 'N'
2625: OPEN c_cop_rec;
2626: FETCH c_cop_rec INTO v_cop_rec;
2627: -- a record has been found

Line 2629: -- if the IGS_PS_OFR_PAT offered_ind

2625: OPEN c_cop_rec;
2626: FETCH c_cop_rec INTO v_cop_rec;
2627: -- a record has been found
2628: IF (c_cop_rec%FOUND) THEN
2629: -- if the IGS_PS_OFR_PAT offered_ind
2630: -- is set to 'N'
2631: IF (v_cop_rec.offered_ind = 'N') THEN
2632: CLOSE c_cop_rec;
2633: p_message_name := 'IGS_EN_INVALID_STUD_CRS_OFFER';

Line 2635: -- if the IGS_PS_OFR_PAT offered_ind

2631: IF (v_cop_rec.offered_ind = 'N') THEN
2632: CLOSE c_cop_rec;
2633: p_message_name := 'IGS_EN_INVALID_STUD_CRS_OFFER';
2634: RETURN FALSE;
2635: -- if the IGS_PS_OFR_PAT offered_ind
2636: -- is set to 'Y'
2637: ELSE
2638: IF (v_cop_rec.offered_ind = 'Y') THEN
2639: OPEN c_ci_rec;

Line 2643: -- the offered_ind for IGS_PS_OFR_PAT was

2639: OPEN c_ci_rec;
2640: FETCH c_ci_rec INTO v_ci_rec;
2641: OPEN c_cs_scs;
2642: FETCH c_cs_scs INTO v_cs_scs;
2643: -- the offered_ind for IGS_PS_OFR_PAT was
2644: -- set to 'Y' and the s_cal_status is not set to 'ACTIVE'
2645: IF (v_cs_scs <> 'ACTIVE') THEN
2646: CLOSE c_cs_scs;
2647: CLOSE c_ci_rec;

Line 2653: -- the offered_ind for IGS_PS_OFR_PAT was

2649: p_message_name := 'IGS_EN_CAL_INST_NOT_ACTIVE';
2650: RETURN FALSE;
2651: ELSE
2652: IF (v_cs_scs = 'ACTIVE') THEN
2653: -- the offered_ind for IGS_PS_OFR_PAT was
2654: -- set to 'Y' and the s_cal_status is set to 'ACTIVE'
2655: CLOSE c_cs_scs;
2656: CLOSE c_ci_rec;
2657: CLOSE c_cop_rec;