APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_EN_PLAN_UNITS

Line 127: FROM igs_en_plan_units

123:
124: -- cursor to get planning sheet error units
125: CURSOR cur_fetch_ps_err_units IS
126: SELECT ROWID,uoo_id
127: FROM igs_en_plan_units
128: WHERE person_id = p_person_id
129: AND course_cd = p_course_cd
130: AND term_cal_type = p_load_cal_type
131: AND term_ci_sequence_number = p_load_sequence_number

Line 161: IGS_EN_PLAN_UNITS_PKG.DELETE_ROW(x_rowid => l_ps_err_rec.ROWID);

157: CLOSE c_sua_exists;
158:
159: IF l_sua_exists IS NOT NULL THEN
160:
161: IGS_EN_PLAN_UNITS_PKG.DELETE_ROW(x_rowid => l_ps_err_rec.ROWID);
162:
163: END IF;
164:
165: END LOOP;

Line 251: FROM igs_en_plan_units

247:
248: -- cursor to check if planning sheet error record exits
249: CURSOR chk_ps_err_rec_exists (cp_uoo_id NUMBER)IS
250: SELECT 'X'
251: FROM igs_en_plan_units
252: WHERE person_id = p_person_id
253: AND course_cd = p_course_cd
254: AND uoo_id = cp_uoo_id
255: AND cart_error_flag = 'Y';

Line 746: FROM igs_en_plan_units

742: l_rec_exists VARCHAR2(1);
743:
744: CURSOR c1 IS
745: SELECT 'x'
746: FROM igs_en_plan_units
747: WHERE person_id = p_person_id
748: AND course_cd = p_course_cd
749: AND uoo_id = p_uoo_id
750: AND cart_error_flag = p_cart_error_flag;

Line 760: IGS_EN_PLAN_UNITS_PKG.insert_row(

756: FETCH c1 INTO l_rec_exists;
757: IF (c1%NOTFOUND) THEN
758: CLOSE c1;
759:
760: IGS_EN_PLAN_UNITS_PKG.insert_row(
761: x_rowid => l_row_id,
762: x_person_id => p_person_id,
763: x_course_cd => p_course_cd,
764: x_uoo_id => p_uoo_id,

Line 868: IGS_EN_PLAN_UNITS_PKG.add_row(

864: BEGIN
865:
866: -- check if record already exists then update else insert
867:
868: IGS_EN_PLAN_UNITS_PKG.add_row(
869: x_rowid => l_row_id,
870: x_person_id => p_person_id,
871: x_course_cd => p_course_cd,
872: x_uoo_id => p_uoo_id,

Line 964: FROM igs_en_plan_units

960:
961: -- cursor to get the rowid of the plannig units table
962: CURSOR c_get_rowid IS
963: SELECT ROWID
964: FROM igs_en_plan_units
965: WHERE person_id = p_person_id
966: AND course_cd = p_course_cd
967: AND uoo_id = p_uoo_id
968: AND cart_error_flag = 'Y';

Line 1024: IGS_EN_PLAN_UNITS_PKG.delete_row(x_rowid => l_rowid);

1020: FETCH c_get_rowid INTO l_rowid;
1021: IF c_get_rowid%FOUND THEN
1022: CLOSE c_get_rowid;
1023:
1024: IGS_EN_PLAN_UNITS_PKG.delete_row(x_rowid => l_rowid);
1025:
1026: ELSE
1027: CLOSE c_get_rowid;
1028: END IF;

Line 1122: FROM igs_en_plan_units

1118:
1119: -- cursor to get the rowid from the plaannig units table
1120: CURSOR c_get_rowid IS
1121: SELECT ROWID
1122: FROM igs_en_plan_units
1123: WHERE person_id = p_person_id
1124: AND course_cd = p_course_cd
1125: AND uoo_id = p_uoo_id
1126: AND cart_error_flag = 'Y';

Line 1187: IGS_EN_PLAN_UNITS_PKG.delete_row(x_rowid => l_rowid);

1183: FETCH c_get_rowid INTO l_rowid;
1184: IF c_get_rowid%FOUND THEN
1185: CLOSE c_get_rowid;
1186:
1187: IGS_EN_PLAN_UNITS_PKG.delete_row(x_rowid => l_rowid);
1188:
1189: ELSE
1190: CLOSE c_get_rowid;
1191: END IF;

Line 2246: FROM igs_en_plan_units

2242: -- cursor to get planning sheet error units or plan units in case of plan
2243: CURSOR cur_fetch_ps_units IS
2244: SELECT uoo_id,no_assessment_ind,grading_schema_code,gs_version_number,
2245: override_enrolled_cp
2246: FROM igs_en_plan_units
2247: WHERE person_id = p_person_id
2248: AND course_cd = p_course_cd
2249: AND term_cal_type = p_load_cal_type
2250: AND term_ci_sequence_number = p_load_sequence_number

Line 5116: FROM igs_en_plan_units

5112:
5113:
5114: CURSOR c_get_rowid IS
5115: SELECT ROWID
5116: FROM igs_en_plan_units
5117: WHERE person_id = p_person_id
5118: AND course_cd = p_course_cd
5119: AND term_cal_type = p_load_cal_type
5120: AND term_ci_sequence_number = p_load_sequence_number

Line 5137: IGS_EN_PLAN_UNITS_PKG.delete_row(x_rowid => c_get_plan_err_rec.ROWID);

5133: BEGIN
5134:
5135: FOR c_get_plan_err_rec IN c_get_rowid LOOP
5136:
5137: IGS_EN_PLAN_UNITS_PKG.delete_row(x_rowid => c_get_plan_err_rec.ROWID);
5138:
5139: END LOOP;
5140:
5141: FOR c_ss_warn_rec IN c_ss_warn LOOP