APPS.IGS_EN_ELGB_OVR_UOO_PKG dependencies on IGS_PS_UNIT_OFR_OPT

Line 118: CURSOR cur_unit_ver(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS

114: igs_en_prc_load.enrp_clc_sua_load towards EN308 Billable credit points build Enh#3782329
115:
116: ******************************************************************/
117:
118: CURSOR cur_unit_ver(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS
119: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)
120: FROM igs_ps_unit_ver uv ,igs_ps_unit_ofr_opt uoo,igs_ps_usec_cps cps
121: WHERE uoo.uoo_id = cps.uoo_id(+) AND
122: uoo.unit_cd = uv.unit_cd AND

Line 120: FROM igs_ps_unit_ver uv ,igs_ps_unit_ofr_opt uoo,igs_ps_usec_cps cps

116: ******************************************************************/
117:
118: CURSOR cur_unit_ver(cp_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE)IS
119: SELECT NVL(cps.enrolled_credit_points,uv.enrolled_credit_points)
120: FROM igs_ps_unit_ver uv ,igs_ps_unit_ofr_opt uoo,igs_ps_usec_cps cps
121: WHERE uoo.uoo_id = cps.uoo_id(+) AND
122: uoo.unit_cd = uv.unit_cd AND
123: uoo.version_number = uv.version_number AND
124: uoo.uoo_id = cp_uoo_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 996: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (

992:
993: IF (old_references.uoo_id = new_references.uoo_id) OR
994: (new_references.uoo_id IS NULL) OR (new_references.uoo_id = -1 ) THEN
995: NULL;
996: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_For_validation (
997: new_references.uoo_id
998: ) THEN
999: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
1000: igs_ge_msg_stack.add;

Line 1057: PROCEDURE get_ufk_igs_ps_unit_ofr_opt (

1053:
1054: END get_fk_igs_en_elgb_ovr_step;
1055:
1056:
1057: PROCEDURE get_ufk_igs_ps_unit_ofr_opt (
1058: x_uoo_id IN NUMBER
1059: ) AS
1060: /*
1061: || Created By : [email protected]

Line 1090: END get_ufk_igs_ps_unit_ofr_opt;

1086: RETURN;
1087: END IF;
1088: CLOSE cur_rowid;
1089:
1090: END get_ufk_igs_ps_unit_ofr_opt;
1091:
1092:
1093: PROCEDURE get_fk_igs_ps_unit_ver (
1094: x_unit_cd IN VARCHAR2,