DBA Data[Home] [Help]

APPS.CN_QUOTA_ASSIGNS_PKG dependencies on CN_SRP_QUOTA_ASSIGNS_PKG

Line 129: cn_srp_quota_assigns_pkg.insert_record

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

Line 259: cn_srp_quota_assigns_pkg.delete_record(

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(

Line 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

Line 389: cn_srp_quota_assigns_pkg.delete_record

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: