125: ,0
126: ,X_ORG_ID );
127:
128: FOR rep_rec IN reps(x_comp_plan_id) LOOP
129: cn_srp_quota_assigns_pkg.insert_record
130: ( x_srp_plan_assign_id => rep_rec.srp_plan_assign_id
131: ,x_quota_id => x_quota_id);
132:
133: -- create srp periods as necessary
255: END;
256:
257: IF x_quota_id <> x_quota_id_old THEN
258: FOR rep_rec IN reps(x_comp_plan_id) LOOP
259: cn_srp_quota_assigns_pkg.delete_record(
260: x_srp_plan_assign_id => rep_rec.srp_plan_assign_id
261: ,x_quota_id => x_quota_id_old);
262:
263: cn_srp_quota_assigns_pkg.insert_record(
259: cn_srp_quota_assigns_pkg.delete_record(
260: x_srp_plan_assign_id => rep_rec.srp_plan_assign_id
261: ,x_quota_id => x_quota_id_old);
262:
263: cn_srp_quota_assigns_pkg.insert_record(
264: x_srp_plan_assign_id => rep_rec.srp_plan_assign_id
265: ,x_quota_id => x_quota_id);
266:
267: -- create srp periods as necessary
385: ,p_end_date_old => l_end_date,
386: p_org_id => l_org_id);
387:
388: FOR rep_rec IN reps(x_comp_plan_id) LOOP
389: cn_srp_quota_assigns_pkg.delete_record
390: ( x_srp_plan_assign_id => rep_rec.srp_plan_assign_id
391: ,x_quota_id => x_quota_id);
392: END LOOP;
393: