APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_EN_PLAN_UNITS

Line 181: FROM igs_en_plan_units plan

177: -- bmerugu added for 4433428 planning sheet variables
178: TYPE cur_plan_def IS REF CURSOR;
179: cur_plan_def_var cur_sua_def; -- REF cursor variable
180: cursor c_dummy is SELECT plan.rowid, plan.*
181: FROM igs_en_plan_units plan
182: WHERE plan.person_id = plan.person_id;
183: cur_plan_def_var_rec c_dummy%ROWTYPE;
184: l_plan_def_query VARCHAR2(4000);
185:

Line 831: FROM igs_en_plan_units plan

827: -- Override record defined at Unit Section level
828: IF new_references.uoo_id <> -1 THEN
829: -- fetch all plan unit Atempts where plan.uoo_id = new_references.uoo_id
830: l_plan_def_query := 'SELECT plan.rowid, plan.*
831: FROM igs_en_plan_units plan
832: WHERE plan.uoo_id = :1 AND plan.person_id = :2
833: AND plan.no_assessment_ind <> ''Y''
834: AND EXISTS(SELECT ''x'' FROM igs_en_spa_terms spa
835: where spa.person_id=plan.person_id

Line 846: FROM igs_en_plan_units plan , igs_ps_unit_ofr_opt_all b

842: -- Override record defined at Unit level
843: ELSIF new_references.unit_cd IS NOT NULL THEN
844: -- fetch all plan unit attempts for the student with matching unit_cd
845: l_plan_def_query := 'SELECT plan.rowid,plan.*
846: FROM igs_en_plan_units plan , igs_ps_unit_ofr_opt_all b
847: WHERE plan.person_id = :1
848: AND plan.uoo_id = b.uoo_id
849: AND b.unit_cd = :2 AND b.version_number = :3
850: AND plan.no_assessment_ind <> ''Y''

Line 872: FROM igs_en_plan_units plan

868: ELSE
869: -- fetch all plan Unit Atempts where sua teach cal type is equal to or sub ordinate to the Cal Type
870: -- where Override record is defined.
871: l_plan_def_query := 'SELECT DISTINCT plan.rowid, plan.*
872: FROM igs_en_plan_units plan
873: WHERE plan.person_id = :1
874: AND plan.no_assessment_ind <> ''Y''
875: AND ((plan.term_cal_type = :2 AND
876: plan.term_ci_sequence_number = :3 ) OR

Line 895: -- call IGS_EN_PLAN_UNITS_PKG.UPDATE_ROW

891: <> -- loop lable
892: LOOP
893: FETCH cur_plan_def_var INTO cur_plan_def_var_rec;
894: EXIT WHEN cur_plan_def_var%NOTFOUND;
895: -- call IGS_EN_PLAN_UNITS_PKG.UPDATE_ROW
896: igs_en_plan_units_pkg.update_row(
897: x_rowid => cur_plan_def_var_rec.rowid,
898: x_person_id => cur_plan_def_var_rec.person_id,
899: x_course_cd => cur_plan_def_var_rec.course_cd,

Line 896: igs_en_plan_units_pkg.update_row(

892: LOOP
893: FETCH cur_plan_def_var INTO cur_plan_def_var_rec;
894: EXIT WHEN cur_plan_def_var%NOTFOUND;
895: -- call IGS_EN_PLAN_UNITS_PKG.UPDATE_ROW
896: igs_en_plan_units_pkg.update_row(
897: x_rowid => cur_plan_def_var_rec.rowid,
898: x_person_id => cur_plan_def_var_rec.person_id,
899: x_course_cd => cur_plan_def_var_rec.course_cd,
900: x_uoo_id => cur_plan_def_var_rec.uoo_id,