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_ELGBL_OVERRIDE dependencies on IGS_EN_ELGB_OVR_STEP

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 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 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 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 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,