APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_EN_PLAN_UNITS_PKG

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 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 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 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 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