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_BULKRULE dependencies on IGS_CA_INST

Line 58: p_acad_cal_type igs_ca_inst.cal_type%TYPE ;

54: p_org_unit_cd IN VARCHAR2 ,
55: p_rule_to_be_validated IN VARCHAR2 )
56: AS
57: p_course_cd igs_ps_course.course_cd%type;
58: p_acad_cal_type igs_ca_inst.cal_type%TYPE ;
59: p_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
60: --added for enrollment processes dld bug#1832130
61: p_load_cal_type igs_ca_inst.cal_type%TYPE ;
62: p_load_sequence_number igs_ca_inst.sequence_number%TYPE;

Line 59: p_acad_sequence_number igs_ca_inst.sequence_number%TYPE;

55: p_rule_to_be_validated IN VARCHAR2 )
56: AS
57: p_course_cd igs_ps_course.course_cd%type;
58: p_acad_cal_type igs_ca_inst.cal_type%TYPE ;
59: p_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
60: --added for enrollment processes dld bug#1832130
61: p_load_cal_type igs_ca_inst.cal_type%TYPE ;
62: p_load_sequence_number igs_ca_inst.sequence_number%TYPE;
63: BEGIN

Line 61: p_load_cal_type igs_ca_inst.cal_type%TYPE ;

57: p_course_cd igs_ps_course.course_cd%type;
58: p_acad_cal_type igs_ca_inst.cal_type%TYPE ;
59: p_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
60: --added for enrollment processes dld bug#1832130
61: p_load_cal_type igs_ca_inst.cal_type%TYPE ;
62: p_load_sequence_number igs_ca_inst.sequence_number%TYPE;
63: BEGIN
64: retcode:=0;
65:

Line 62: p_load_sequence_number igs_ca_inst.sequence_number%TYPE;

58: p_acad_cal_type igs_ca_inst.cal_type%TYPE ;
59: p_acad_sequence_number igs_ca_inst.sequence_number%TYPE;
60: --added for enrollment processes dld bug#1832130
61: p_load_cal_type igs_ca_inst.cal_type%TYPE ;
62: p_load_sequence_number igs_ca_inst.sequence_number%TYPE;
63: BEGIN
64: retcode:=0;
65:
66: IGS_GE_GEN_003.SET_ORG_ID(p_org_id);

Line 232: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,

228: /* smaddali modified this procedure to add 4 new parameters and their use in code
229: --stutta 08-SEP-2004 Modified c_sua as part of performance tuning bug #3869677*/
230: -------------------------------------
231: PROCEDURE enrpl_enrolled_to_invalid (
232: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
233: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
234: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
235: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
236: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,

Line 233: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,

229: --stutta 08-SEP-2004 Modified c_sua as part of performance tuning bug #3869677*/
230: -------------------------------------
231: PROCEDURE enrpl_enrolled_to_invalid (
232: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
233: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
234: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
235: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
236: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
237: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,

Line 240: p_cal_type IN IGS_CA_INST.cal_type%TYPE,

236: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
237: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
238: p_invalid_rule_cutoff_dt IN IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE,
239: --added for enrollment processes dld by smaddali bug#1832130
240: p_cal_type IN IGS_CA_INST.cal_type%TYPE,
241: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE ,
243: p_rule_to_be_validated IN IGS_EN_SU_ATTEMPT_ALL.failed_unit_rule%TYPE )
244: IS

Line 241: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

237: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
238: p_invalid_rule_cutoff_dt IN IGS_EN_CAL_CONF.invalid_rule_cutoff_dt_alias%TYPE,
239: --added for enrollment processes dld by smaddali bug#1832130
240: p_cal_type IN IGS_CA_INST.cal_type%TYPE,
241: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
242: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE ,
243: p_rule_to_be_validated IN IGS_EN_SU_ATTEMPT_ALL.failed_unit_rule%TYPE )
244: IS
245: BEGIN

Line 248: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';

244: IS
245: BEGIN
246: DECLARE
247: cst_enrolled CONSTANT IGS_EN_SU_ATTEMPT.unit_attempt_status%TYPE := 'ENROLLED';
248: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';
249:
250: v_counter NUMBER; -- keeps record of the number of records in the PL/SQL table
251: v_next_rec BOOLEAN; -- used to determine if the next record should be found
252: v_do_cursor_again_ind BOOLEAN;

Line 289: IGS_CA_INST ci,

285: ci.alternate_code,
286: uoo.uoo_id,
287: sua.sup_unit_cd
288: FROM IGS_EN_SU_ATTEMPT sua,
289: IGS_CA_INST ci,
290: IGS_PS_UNIT_OFR_OPT uoo
291: WHERE
292: sua.person_id = p_person_id
293: AND sua.course_cd = p_course_cd

Line 340: IGS_CA_INST ci

336: CURSOR cur_IGS_EN_SU_ATTEMPT(cp_unit_cd VARCHAR2,
337: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
338: SELECT sua.*
339: FROM IGS_EN_SU_ATTEMPT sua,
340: IGS_CA_INST ci
341: WHERE sua.person_id = p_person_id AND
342: sua.course_cd = p_course_cd AND
343: sua.unit_attempt_status = cst_enrolled AND
344: sua.rule_waived_dt IS NULL AND

Line 749: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,

745: --ckasu 25-APR-2006 Modfied as a part of bug#5191592.
746: */
747: -----------------------------------
748: PROCEDURE enrpl_invalid_to_enrolled (
749: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
750: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
751: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
752: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
753: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,

Line 750: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,

746: */
747: -----------------------------------
748: PROCEDURE enrpl_invalid_to_enrolled (
749: p_acad_cal_type IN IGS_CA_INST.cal_type%TYPE,
750: p_acad_sequence_number IN IGS_CA_INST.sequence_number%TYPE,
751: p_person_id IN IGS_EN_STDNT_PS_ATT.person_id%TYPE,
752: p_course_cd IN IGS_EN_STDNT_PS_ATT.course_cd%TYPE,
753: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
754: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,

Line 757: p_cal_type IN IGS_CA_INST.cal_type%TYPE ,

753: p_s_log_type IN IGS_GE_S_LOG.s_log_type%TYPE,
754: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
755: p_enrolled_rule_cutoff_dt IN IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE,
756: --added for enrollment processes dld by smaddali bug#1832130
757: p_cal_type IN IGS_CA_INST.cal_type%TYPE ,
758: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
759: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE )
760: IS
761: BEGIN

Line 758: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,

754: p_creation_dt IN IGS_GE_S_LOG.creation_dt%TYPE,
755: p_enrolled_rule_cutoff_dt IN IGS_EN_CAL_CONF.enrolled_rule_cutoff_dt_alias%TYPE,
756: --added for enrollment processes dld by smaddali bug#1832130
757: p_cal_type IN IGS_CA_INST.cal_type%TYPE ,
758: p_ci_sequence_number IN IGS_CA_INST.sequence_number%TYPE ,
759: p_org_unit_cd IN IGS_OR_UNIT.org_unit_cd%TYPE )
760: IS
761: BEGIN
762: DECLARE

Line 771: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';

767: v_validation_error BOOLEAN;
768: v_message_text VARCHAR2(2000);
769: v_validation_message_name VARCHAR2(30);
770: v_attendance_types VARCHAR2(100);
771: cst_active CONSTANT IGS_CA_INST.cal_status%TYPE := 'ACTIVE';
772: -- Initialise PL/SQL table to hold UNIT attempt records which
773: -- cannot be set to ENROLLED.
774: TYPE r_unit_attempt_typ IS RECORD (rv_uoo_id IGS_EN_SU_ATTEMPT.uoo_id%TYPE);
775: r_unit_attempt_rec r_unit_attempt_typ;

Line 795: CURSOR c_sua_sca(cp_cal_cat igs_ca_type.s_cal_cat%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS

791: --The two selects are mutually exclusive ie at any time the calendar passed is
792: --either 'LOAD' or 'TEACHING' so this cursor selects the unit attempts
793: -- for that particular calendar passed as parameter
794:
795: CURSOR c_sua_sca(cp_cal_cat igs_ca_type.s_cal_cat%TYPE, cp_cal_type igs_ca_inst.cal_type%TYPE, cp_ci_sequence_number igs_ca_inst.sequence_number%TYPE) IS
796: --selects unit attempts when a teaching calendar is passed
797: SELECT sua.unit_cd,
798: sua.version_number sua_version_number,
799: sua.cal_type,

Line 810: IGS_CA_INST ci ,

806: uoo.uoo_id,
807: sua.sup_unit_cd
808: FROM IGS_EN_SU_ATTEMPT sua,
809: IGS_EN_STDNT_PS_ATT sca,
810: IGS_CA_INST ci ,
811: IGS_PS_UNIT_OFR_OPT uoo
812: WHERE sua.person_id = p_person_id
813: AND sua.course_cd = p_course_cd
814: AND sua.unit_attempt_status = 'INVALID'

Line 832: IGS_CA_INST ci

828: cp_uoo_id igs_en_su_attempt_all.uoo_id%TYPE) IS
829: SELECT sua.*
830: FROM IGS_EN_SU_ATTEMPT sua,
831: IGS_EN_STDNT_PS_ATT sca,
832: IGS_CA_INST ci
833: WHERE sua.person_id = p_person_id AND
834: sua.course_cd = p_course_cd AND
835: sua.unit_attempt_status = 'INVALID' AND
836: sca.person_id = sua.person_id AND