APPS.CN_RT_QUOTA_ASGNS_PKG dependencies on CN_SRP_RATE_ASSIGNS_PKG

Line 152: cn_srp_rate_assigns_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,

148: x_object_version_number
149: );
150:
151: -- Insert the srp quota assigns, if srp plan plans assgins
152: cn_srp_rate_assigns_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,
153: x_srp_quota_assign_id => NULL,
154: x_srp_rate_assign_id => NULL,
155: x_quota_id => x_quota_id,
156: x_rate_schedule_id => x_rate_schedule_id,

Line 323: cn_srp_rate_assigns_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,

319:
320: -- srp rate assigns
321: IF (x_rate_schedule_id <> recinfo.rate_schedule_id) OR (x_calc_formula_id <> recinfo.calc_formula_id)
322: THEN
323: cn_srp_rate_assigns_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,
324: x_srp_rate_assign_id => NULL,
325: x_quota_id => x_quota_id,
326: x_rate_schedule_id => recinfo.rate_schedule_id,
327: x_rt_quota_asgn_id => x_rt_quota_asgn_id,

Line 331: cn_srp_rate_assigns_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,

327: x_rt_quota_asgn_id => x_rt_quota_asgn_id,
328: x_rate_tier_id => NULL
329: );
330: -- Srp Rate Assigs
331: cn_srp_rate_assigns_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,
332: x_srp_quota_assign_id => NULL,
333: x_srp_rate_assign_id => NULL,
334: x_quota_id => x_quota_id,
335: x_rate_schedule_id => x_rate_schedule_id,

Line 574: cn_srp_rate_assigns_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,

570: INTO recinfo;
571:
572: EXIT WHEN srp_rate_insert_curs%NOTFOUND;
573: -- insert srp rate assigns for each insert int the rt_quota_assigns
574: cn_srp_rate_assigns_pkg.INSERT_RECORD (x_srp_plan_assign_id => NULL,
575: x_srp_quota_assign_id => NULL,
576: x_srp_rate_assign_id => NULL,
577: x_quota_id => recinfo.quota_id,
578: x_rate_schedule_id => recinfo.rate_schedule_id,

Line 642: cn_srp_rate_assigns_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,

638: INTO recinfo;
639:
640: EXIT WHEN srp_rate_assigns_delete%NOTFOUND;
641: -- delete srp rate assigns for each insert int the rt_quota_assigns
642: cn_srp_rate_assigns_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,
643: x_srp_rate_assign_id => NULL,
644: x_quota_id => recinfo.quota_id,
645: x_rate_schedule_id => recinfo.rate_schedule_id,
646: x_rt_quota_asgn_id => x_rt_quota_asgn_id,

Line 672: cn_srp_rate_assigns_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,

668: INTO recinfo;
669:
670: EXIT WHEN srp_rate_assigns_delete1%NOTFOUND;
671: -- delete srp rate assigns for each insert int the rt_quota_assigns
672: cn_srp_rate_assigns_pkg.DELETE_RECORD (x_srp_plan_assign_id => NULL,
673: x_srp_rate_assign_id => NULL,
674: x_quota_id => recinfo.quota_id,
675: x_rate_schedule_id => recinfo.rate_schedule_id,
676: x_rate_tier_id => NULL