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.

[Home] [Help]

APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_EN_ELGB_OVR

Line 14: -- of IGS_EN_ELGB_OVR_STEP_PKG.

10: --Change History:
11: --Who When What
12: --amuthu 29-JAN-2003 As part of bug 2744715 change the message logging format for the
13: -- this job and also truncated the date being passed to the insert row
14: -- of IGS_EN_ELGB_OVR_STEP_PKG.
15: --svanukur 16-jun-2003 modified the UI and Validations associated with this job as part of
16: -- Validations ImpactCR , ENCR34, bug #2881385
17: --ptandon 02-Jul-2003 Modified the function enrp_chk_unit_over to allow unit level override
18: for multiple units/unit sections to a student in case of same unit

Line 109: -- | Igs_En_Elgb_Ovr_Pkg.insert_row (** If not exists )

105: -- |
106: -- | Function ENRP_LOG_PARA ( ** log parameters )
107: -- | Function ENRP_VAL_PARA ( ** Validate parameters )
108: -- | LOOP for all students
109: -- | Igs_En_Elgb_Ovr_Pkg.insert_row (** If not exists )
110: -- | Procedure ENRP_INS_STEP_OVER ( ** create override records for all steps passed )
111: -- | Procedure enrp_chk_pers_over/enrp_chk_prg_over/enrp_chk_unit_over ( ** based on the step type different call)
112: -- | Igs_En_Gen_015.validation_step_is_overridden ( ** whether step is overriden )
113: -- | Igs_En_Elgb_Ovr_Step_Pkg.insert_row ( ** create override record for the step )

Line 113: -- | Igs_En_Elgb_Ovr_Step_Pkg.insert_row ( ** create override record for the step )

109: -- | Igs_En_Elgb_Ovr_Pkg.insert_row (** If not exists )
110: -- | Procedure ENRP_INS_STEP_OVER ( ** create override records for all steps passed )
111: -- | Procedure enrp_chk_pers_over/enrp_chk_prg_over/enrp_chk_unit_over ( ** based on the step type different call)
112: -- | Igs_En_Gen_015.validation_step_is_overridden ( ** whether step is overriden )
113: -- | Igs_En_Elgb_Ovr_Step_Pkg.insert_row ( ** create override record for the step )
114: --
115: --
116: --Known limitations/enhancements and/or remarks:
117: --

Line 135: FROM igs_en_elgb_ovr

131: ---------------------------------------------------------------------------------------------------------------------------------------
132:
133: CURSOR cur_elgb_over(p_person_id NUMBER,p_cal_type VARCHAR2,p_ci_seq_number NUMBER)IS
134: SELECT elgb_override_id
135: FROM igs_en_elgb_ovr
136: WHERE person_id = p_person_id AND
137: cal_type = p_cal_type AND
138: ci_sequence_number = p_ci_seq_number;
139:

Line 243: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;

239: l_unit_version igs_ps_unit_ver.version_number%TYPE;
240: l_unit_set_cd igs_en_unit_set.unit_set_cd%TYPE;
241: l_unit_set_version igs_en_unit_set.version_number%TYPE;
242: l_message_name VARCHAR2(30) := NULL;
243: l_elgb_override_id igs_en_elgb_ovr.elgb_override_id%TYPE;
244: l_rowid VARCHAR2(30);
245: l_record_found BOOLEAN :=FALSE;
246: l_org_unit_start_dt igs_or_unit.start_dt%TYPE;
247: l_person_id_grp VARCHAR2(20);

Line 761: -- corresponding to the person override record created in igs_en_elgb_ovr table

757: END enrp_val_para;
758:
759: --
760: -- This Procedure will create(if not exists) the override records for the steps passed as parameters
761: -- corresponding to the person override record created in igs_en_elgb_ovr table
762: --
763: PROCEDURE enrp_ins_step_over(p_person_id NUMBER, p_cal_type VARCHAR2, p_ci_seq_number NUMBER,
764: p_elgb_override_id IN NUMBER, p_unit_cd VARCHAR2, p_unit_version NUMBER,
765: p_is_teach_cal BOOLEAN

Line 769: cp_elgb_override_id IGS_EN_ELGB_OVR_STEP.ELGB_OVERRIDE_ID%TYPE,

765: p_is_teach_cal BOOLEAN
766: )AS
767:
768: CURSOR cur_check_override (
769: cp_elgb_override_id IGS_EN_ELGB_OVR_STEP.ELGB_OVERRIDE_ID%TYPE,
770: cp_eligibility_step_type IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE )IS
771: SELECT step_override_limit,
772: step_override_type
773: FROM igs_en_elgb_ovr_step eos

Line 770: cp_eligibility_step_type IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE )IS

766: )AS
767:
768: CURSOR cur_check_override (
769: cp_elgb_override_id IGS_EN_ELGB_OVR_STEP.ELGB_OVERRIDE_ID%TYPE,
770: cp_eligibility_step_type IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE )IS
771: SELECT step_override_limit,
772: step_override_type
773: FROM igs_en_elgb_ovr_step eos
774: WHERE eos.elgb_override_id = cp_elgb_override_id

Line 773: FROM igs_en_elgb_ovr_step eos

769: cp_elgb_override_id IGS_EN_ELGB_OVR_STEP.ELGB_OVERRIDE_ID%TYPE,
770: cp_eligibility_step_type IGS_EN_ELGB_OVR_STEP.STEP_OVERRIDE_TYPE%TYPE )IS
771: SELECT step_override_limit,
772: step_override_type
773: FROM igs_en_elgb_ovr_step eos
774: WHERE eos.elgb_override_id = cp_elgb_override_id
775: AND eos.step_override_type = cp_eligibility_step_type;
776:
777: lr_cur_check_override cur_check_override%ROWTYPE;

Line 801: l_step_override_limit igs_en_elgb_ovr_step.STEP_OVERRIDE_LIMIT%TYPE;

797: PROCEDURE enrp_chk_pers_over(p_elgb_step IN VARCHAR2, p_is_teach_cal IN BOOLEAN
798: )AS
799:
800: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
801: l_step_override_limit igs_en_elgb_ovr_step.STEP_OVERRIDE_LIMIT%TYPE;
802: l_rowid VARCHAR2(30);
803: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;
804:
805: BEGIN

Line 803: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;

799:
800: l_step_meaning IGS_LOOKUP_VALUES.MEANING%TYPE;
801: l_step_override_limit igs_en_elgb_ovr_step.STEP_OVERRIDE_LIMIT%TYPE;
802: l_rowid VARCHAR2(30);
803: l_elgb_ovr_step_id igs_en_elgb_ovr_step.elgb_ovr_step_id%TYPE;
804:
805: BEGIN
806:
807: l_step_meaning := NULL;

Line 823: Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,

819: FETCH cur_check_override INTO lr_cur_check_override;
820: BEGIN
821: IF cur_check_override%NOTFOUND THEN
822:
823: Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,
824: x_elgb_ovr_step_id => l_elgb_ovr_step_id,
825: x_elgb_override_id => p_elgb_override_id, -- from parameter of container procedure
826:
827: x_step_override_type => p_elgb_step,

Line 875: -- inserting the unit details into igs_en_elgb_ovr_uoo table which was

871: -- for the MIN credit/Force attendance program steps. If not new logic
872: -- tries to insert the authorization code, where authorization code
873: -- passed as a parameter.
874: --svanukur 16-jun-2003 as part of validation consolidtion CR bug #2881385,
875: -- inserting the unit details into igs_en_elgb_ovr_uoo table which was
876: -- created as part of build#2829272.
877: --ckasu 13-JUN-2006 modified as a part of bug 5299024.
878: --amuthu 15-jun-2006 Added logic to show a note to the user if an authorization already
879: -- exists and a new one is not being created.

Line 884: CURSOR cur_elgb_end_dt IS SELECT end_dt,person_id, ci.cal_type, ci.sequence_number FROM igs_en_elgb_ovr elgb,

880: --amuthu 18-Aug-2006 The message IGS_EN_SV_AUTH_ALREADY_EXISTS would be displayed only
881: -- for non-imig student alone. Bug 5435397
882: -------------------------------------------------------------------------------------------- */
883: --Cursor to get the calendar end date,person id for a given eligibility override.
884: CURSOR cur_elgb_end_dt IS SELECT end_dt,person_id, ci.cal_type, ci.sequence_number FROM igs_en_elgb_ovr elgb,
885: igs_ca_inst ci
886: WHERE elgb.elgb_override_id = p_elgb_override_id
887: AND elgb.cal_type = ci.cal_type
888: AND elgb.ci_sequence_number = ci.sequence_number;

Line 896: l_person_id igs_en_elgb_ovr.person_id%TYPE;

892: l_step_override_limit NUMBER := NULL;
893: l_ci_end_dt igs_ca_inst.end_dt%TYPE;
894: l_cal_type igs_ca_inst.cal_type%TYPE;
895: l_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
896: l_person_id igs_en_elgb_ovr.person_id%TYPE;
897: l_message VARCHAR2(5000);
898: l_auth_start_Dt igs_en_svs_auth.START_DT%TYPE;
899: l_auth_end_dt igs_en_svs_auth.END_DT%TYPE;
900: l_sevis_auth_id igs_en_svs_auth.SEVIS_AUTH_ID%TYPE;

Line 954: Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,

950: -- in upfront.
951:
952: l_rowid:=NULL;
953:
954: Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,
955: x_elgb_ovr_step_id => l_elgb_ovr_step_id,
956: x_elgb_override_id => p_elgb_override_id, -- from parameter of container procedure
957: x_step_override_type => p_elgb_step,
958: x_step_override_dt => TRUNC(SYSDATE),

Line 1088: l_step_override_type igs_en_elgb_ovr_step.step_override_type%TYPE;

1084: l_elgb_ovr_step_id NUMBER(15);
1085: l_elgb_ovr_step_uoo_id NUMBER(15);
1086: l_step_override_limit NUMBER(6,3) := NULL;
1087:
1088: l_step_override_type igs_en_elgb_ovr_step.step_override_type%TYPE;
1089: l_message VARCHAR2(5000);
1090:
1091: CURSOR cur_get_elgb_ovr_step_id IS
1092: SELECT elgb_ovr_step_id

Line 1093: FROM igs_en_elgb_ovr_step eos

1089: l_message VARCHAR2(5000);
1090:
1091: CURSOR cur_get_elgb_ovr_step_id IS
1092: SELECT elgb_ovr_step_id
1093: FROM igs_en_elgb_ovr_step eos
1094: WHERE eos.elgb_override_id = p_elgb_override_id
1095: AND eos.step_override_type = p_elgb_step;
1096:
1097: lr_cur_get_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE;

Line 1097: lr_cur_get_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE;

1093: FROM igs_en_elgb_ovr_step eos
1094: WHERE eos.elgb_override_id = p_elgb_override_id
1095: AND eos.step_override_type = p_elgb_step;
1096:
1097: lr_cur_get_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE;
1098:
1099: CURSOR cur_check_override_uooid (
1100: cp_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE)IS
1101: SELECT elgb_ovr_step_uoo_id

Line 1100: cp_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE)IS

1096:
1097: lr_cur_get_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE;
1098:
1099: CURSOR cur_check_override_uooid (
1100: cp_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE)IS
1101: SELECT elgb_ovr_step_uoo_id
1102: FROM igs_en_elgb_ovr_uoo eou
1103: WHERE eou.elgb_ovr_step_id = cp_elgb_ovr_step_id
1104: AND ((eou.uoo_id = NVL(p_uoo_id,-1) AND NVL(p_uoo_id,-1) <> -1)

Line 1102: FROM igs_en_elgb_ovr_uoo eou

1098:
1099: CURSOR cur_check_override_uooid (
1100: cp_elgb_ovr_step_id IGS_EN_ELGB_OVR_UOO.ELGB_OVR_STEP_ID%TYPE)IS
1101: SELECT elgb_ovr_step_uoo_id
1102: FROM igs_en_elgb_ovr_uoo eou
1103: WHERE eou.elgb_ovr_step_id = cp_elgb_ovr_step_id
1104: AND ((eou.uoo_id = NVL(p_uoo_id,-1) AND NVL(p_uoo_id,-1) <> -1)
1105: OR (eou.uoo_id = NVL(p_uoo_id,-1) AND NVL(p_uoo_id,-1) = -1 AND eou.unit_cd = p_unit_cd AND eou.version_number = p_version_number));
1106:

Line 1131: Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,

1127: FETCH cur_check_override INTO lr_cur_check_override;
1128: BEGIN
1129: IF cur_check_override%NOTFOUND THEN
1130:
1131: Igs_En_Elgb_Ovr_Step_Pkg.insert_row(x_rowid => l_rowid,
1132: x_elgb_ovr_step_id => l_elgb_ovr_step_id,
1133: x_elgb_override_id => p_elgb_override_id, -- from parameter of container procedure
1134:
1135: x_step_override_type => p_elgb_step,

Line 1142: Igs_En_Elgb_Ovr_Uoo_Pkg.insert_row(x_rowid => l_rowid,

1138: x_mode => 'R');
1139:
1140: l_rowid :=NULL;
1141:
1142: Igs_En_Elgb_Ovr_Uoo_Pkg.insert_row(x_rowid => l_rowid,
1143: x_elgb_ovr_step_uoo_id => l_elgb_ovr_step_uoo_id,
1144: x_elgb_ovr_step_id => l_elgb_ovr_step_id,
1145: x_unit_cd => p_unit_cd,
1146: x_version_number => p_version_number,

Line 1162: Igs_En_Elgb_Ovr_Uoo_Pkg.insert_row(x_rowid => l_rowid,

1158: OPEN cur_check_override_uooid(lr_cur_get_elgb_ovr_step_id);
1159: FETCH cur_check_override_uooid INTO lr_cur_check_override_uooid;
1160:
1161: IF cur_check_override_uooid%NOTFOUND THEN
1162: Igs_En_Elgb_Ovr_Uoo_Pkg.insert_row(x_rowid => l_rowid,
1163: x_elgb_ovr_step_uoo_id => l_elgb_ovr_step_uoo_id,
1164: x_elgb_ovr_step_id => lr_cur_get_elgb_ovr_step_id,
1165: x_unit_cd => p_unit_cd,
1166: x_version_number => p_version_number,

Line 1409: Igs_En_Elgb_Ovr_Pkg.insert_row(x_rowid => l_rowid,

1405: -- if override record is not exists for the given student in given calendar(Load/Teach)
1406: IF cur_elgb_over%NOTFOUND THEN
1407: -- create override record for the given student in given calendar(Load/Teach)
1408: l_rowid :=NULL;
1409: Igs_En_Elgb_Ovr_Pkg.insert_row(x_rowid => l_rowid,
1410: x_elgb_override_id => l_elgb_override_id,
1411: x_person_id => cur_criteria_satisfied_rec.person_id,
1412: x_cal_type => l_cal_type,
1413: x_ci_sequence_number => l_ci_seq_number,