APPS.IGS_EN_ELGBL_OVERRIDE dependencies on IGS_EN_ELGB_OVR_UOO

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