APPS.IGS_EN_PLAN_UTILS dependencies on IGS_EN_PLAN_UNITS

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 298: select plan.rowid,plan.* from igs_en_plan_units plan where

294: COURSE_CD=P_COURSE_CD AND
295: UOO_ID=P_UOOID ;
296:
297: cursor select_plan is
298: select plan.rowid,plan.* from igs_en_plan_units plan where
299: PERSON_ID=P_PERSON_ID AND
300: COURSE_CD=P_COURSE_CD AND
301: UOO_ID=P_UOOID AND
302: CART_ERROR_FLAG=P_CARTFLAG ;

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 503: --Purpose: delete record from igs_en_plan_units .

499: ------------------------------------------------------------------
500: --Created by : ctyagi, Oracle IDC
501: --Date created: 18-JULY-2005
502: --
503: --Purpose: delete record from igs_en_plan_units .
504: --
505: --Known limitations/enhancements and/or remarks:
506: --
507: --Change History:

Line 512: FROM igs_en_plan_units pl

508: --Who When What
509: -------------------------------------------------------------------
510: CURSOR cur_plan_unit IS
511: SELECT pl.rowid, pl.term_cal_type, pl.term_ci_sequence_number,pl.uoo_id, pl.core_indicator_code, pl.sup_uoo_id
512: FROM igs_en_plan_units pl
513: WHERE pl.person_id = p_person_id
514: AND pl.course_cd = p_course_cd
515: AND pl.cart_error_flag = P_CARTFLAG
516: AND (pl.uoo_id = P_UOOID

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 1769: FROM igs_en_plan_units

1765: -- and Calendar Instance
1766: CURSOR cur_no_assessment_ind
1767: IS
1768: SELECT no_assessment_ind
1769: FROM igs_en_plan_units
1770: WHERE person_id = p_person_id
1771: AND course_cd = p_course_cd
1772: AND uoo_id = p_uoo_id
1773: AND cart_error_flag='N';

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,