DBA Data[Home] [Help]

APPS.IGS_EN_PLAN_UTILS dependencies on IGS_EN_PLAN_UNITS_PKG

Line 113: IGS_EN_PLAN_UNITS_PKG.INSERT_ROW(

109: FETCH c_get_unitSection INTO l_unitcd;
110: CLOSE c_get_unitSection;
111:
112: BEGIN
113: IGS_EN_PLAN_UNITS_PKG.INSERT_ROW(
114: x_rowid => l_row_id,
115: x_person_id => p_person_id,
116: x_course_cd => p_course_cd,
117: x_uoo_id => l_uooid,

Line 319: igs_en_plan_units_pkg.update_row(

315: p_audit IN VARCHAR2,
316: p_credit IN NUMBER,
317: p_old_refplan select_plan%ROWTYPE) IS
318: BEGIN
319: igs_en_plan_units_pkg.update_row(
320: x_rowid => p_old_refplan.rowid,
321: x_person_id => p_old_refplan.person_id ,
322: x_course_cd => p_old_refplan.course_cd,
323: x_uoo_id => p_old_refplan.uoo_id,

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

586: END IF;
587:
588: --call the TBH for the planning sheet to delete the unit
589: --by passing the rowid
590: igs_en_plan_units_pkg.delete_row (x_rowid => cur_plan_unit_rec.rowid);
591:
592: --call drop_permission_unit to drop the permission unit
593:
594: FOR cur_permission_unit_rec IN cur_permission_unit(cur_plan_unit_rec.uoo_id) LOOP

Line 2128: igs_en_plan_units_pkg.lock_row (

2124: -------------------------------------------------------------------
2125: IS
2126: PRAGMA AUTONOMOUS_TRANSACTION;
2127: BEGIN
2128: igs_en_plan_units_pkg.lock_row (
2129: x_rowid => p_row_id,
2130: x_person_id => p_person_id,
2131: x_course_cd => p_course_cd,
2132: x_uoo_id => p_uoo_id,