APPS.IGS_SS_EN_WRAPPERS dependencies on IGS_EN_PLAN_UNITS

Line 3485: FROM igs_en_plan_units pl

3481: ) AS
3482:
3483: CURSOR cur_plan_unit IS
3484: SELECT pl.rowid, pl.term_cal_type, pl.term_ci_sequence_number,pl.uoo_id
3485: FROM igs_en_plan_units pl
3486: WHERE pl.person_id = p_person_id
3487: AND pl.course_cd = p_course_cd
3488: AND EXISTS ( SELECT 'X'
3489: FROM IGS_PS_UNIT_OFR_OPT UOO

Line 3514: igs_en_plan_units_pkg.delete_row (x_rowid => cur_plan_unit_rec.rowid);

3510: BEGIN
3511: FOR cur_plan_unit_rec IN cur_plan_unit LOOP
3512: --call the TBH for the planning sheet to delete the unit
3513: --by passing the rowid
3514: igs_en_plan_units_pkg.delete_row (x_rowid => cur_plan_unit_rec.rowid);
3515:
3516: --call drop_permission_unit to drop the permission unit
3517:
3518: FOR cur_permission_unit_rec IN cur_permission_unit(cur_plan_unit_rec.uoo_id) LOOP