APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_EN_STDNT_PS_ATT

Line 1064: FROM igs_en_stdnt_ps_att

1060:
1061: -- Cursor to get the coo_id of the student.
1062: CURSOR cur_coo_id IS
1063: SELECT coo_id coo_id
1064: FROM igs_en_stdnt_ps_att
1065: WHERE person_id = p_person_id
1066: AND course_cd = p_program_cd ;
1067:
1068: l_attendance_type_reach BOOLEAN := TRUE;

Line 2068: FROM igs_en_stdnt_ps_att

2064:
2065: -- Cursor to get the coo_id of the student.
2066: CURSOR cur_coo_id IS
2067: SELECT coo_id coo_id
2068: FROM igs_en_stdnt_ps_att
2069: WHERE person_id = x_person_id
2070: AND course_cd = x_program_cd;
2071:
2072: -- Cursor to get the Unit Attempt Details .

Line 2719: FROM igs_en_stdnt_ps_att

2715:
2716: -- Cursor to get the coo_id of the student.
2717: CURSOR cur_coo_id IS
2718: SELECT coo_id coo_id
2719: FROM igs_en_stdnt_ps_att
2720: WHERE person_id = p_person_id
2721: AND course_cd = p_program_cd ;
2722:
2723: l_attendance_type_reach BOOLEAN := TRUE;

Line 4132: FROM igs_en_stdnt_ps_att

4128: ORDER BY eru.step_order_num;
4129:
4130: CURSOR c_crs_ver IS
4131: SELECT version_number
4132: FROM igs_en_stdnt_ps_att
4133: WHERE person_id=p_person_id
4134: AND course_cd= p_course_cd;
4135:
4136: CURSOR cur_grading(cp_person_id NUMBER,

Line 4164: l_crs_ver igs_en_stdnt_ps_att.version_number%TYPE;

4160: l_usec_audit_lim igs_ps_usec_lim_wlst.max_auditors_allowed%TYPE;
4161: l_commencement_type igs_en_cpd_ext.s_student_comm_type%TYPE;
4162: l_step_override_limit igs_en_elgb_ovr_step.step_override_limit%TYPE;
4163: l_stud_audit_lim igs_en_cpd_ext.stud_audit_lim%TYPE;
4164: l_crs_ver igs_en_stdnt_ps_att.version_number%TYPE;
4165: l_data cur_grading%ROWTYPE;
4166: l_enrollment_category VARCHAR2(200);
4167: l_audit_sua NUMBER;
4168: l_acad_start_dt DATE;

Line 4703: FROM igs_en_stdnt_ps_att_all spat

4699: AS
4700: --cursor to get the rowid for the program attempt of the student
4701: CURSOR cur_program(p_person_id NUMBER, p_course_cd VARCHAR2) IS
4702: SELECT spat.ROWID
4703: FROM igs_en_stdnt_ps_att_all spat
4704: WHERE spat.person_id = p_person_id
4705: AND spat.course_cd = p_course_cd;
4706:
4707: --cursor to get the rowid for the unit attempt of the student

Line 4727: IF p_table ='IGS_EN_STDNT_PS_ATT_ALL' THEN

4723: p_update_allowed := 'N';
4724: l_program_rowid := NULL;
4725:
4726: -- get the program attempt rowid
4727: IF p_table ='IGS_EN_STDNT_PS_ATT_ALL' THEN
4728: --get the rowid for program attempt
4729: OPEN cur_program(p_person_id,p_course_cd);
4730: FETCH cur_program INTO l_program_rowid;
4731: CLOSE cur_program;

Line 4739: p_tab_name => 'IGS_EN_STDNT_PS_ATT_SV',

4735: IF (l_program_rowid IS NOT NULL) THEN
4736: IF p_mode = 'B' THEN
4737: -- check for query permission on the table
4738: l_sec_out := igs_sc_gen_001.check_sel_upd_del_security (
4739: p_tab_name => 'IGS_EN_STDNT_PS_ATT_SV',
4740: p_rowid => l_program_rowid,
4741: p_action => 'S',
4742: p_msg_data => l_msg_data);
4743:

Line 4747: p_message := 'IGS_SC_PRE_CHECK_EXCEP*'||l_msg_data||'*IGS_EN_STDNT_PS_ATT_SV*S';

4743:
4744: IF NOT l_sec_out THEN
4745: p_message := 'IGS_SC_NO_ACCESS_PRIV';
4746: IF l_msg_data IS NOT NULL THEN
4747: p_message := 'IGS_SC_PRE_CHECK_EXCEP*'||l_msg_data||'*IGS_EN_STDNT_PS_ATT_SV*S';
4748: END IF;
4749: RETURN;
4750: END IF;
4751: