[Home] [Help]
2170: -- Version : Current version 1.0
2171: -- Initial version 1.0
2172: --
2173: -- Case 7: whenever there is a change in the start date and end date of
2174: -- CN_RT_QUOTA_ASGNS, it marks the affected period records
2175: -- for that quota.
2176: -- called from trigger
2177: --
2178: -- Case 8: whenever there is insert/delete the cn_rt_quota_asgns
2174: -- CN_RT_QUOTA_ASGNS, it marks the affected period records
2175: -- for that quota.
2176: -- called from trigger
2177: --
2178: -- Case 8: whenever there is insert/delete the cn_rt_quota_asgns
2179: -- it marks the affected salesrep for that quotas.
2180: -- called from trigger
2181: --
2182: PROCEDURE mark_event_rt_quota(
3169: , spq.quota_id
3170: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel
3171: WHERE spq.quota_id IN(
3172: SELECT rt_assign.quota_id
3173: FROM cn_rate_sch_dims_all rt, cn_rt_quota_asgns_all rt_assign
3174: WHERE rt.rate_dimension_id = p_object_id
3175: AND rt_assign.rate_schedule_id = rt.rate_schedule_id)
3176: AND intel.salesrep_id = spq.salesrep_id
3177: AND intel.period_id = spq.period_id
3327: , spq.quota_id
3328: FROM cn_srp_period_quotas spq, cn_srp_intel_periods intel
3329: WHERE spq.quota_id IN(
3330: SELECT rt_assign.quota_id
3331: FROM cn_rt_quota_asgns rt_assign
3332: WHERE rt_assign.rate_schedule_id = p_dep_object_id)
3333: AND intel.salesrep_id = spq.salesrep_id
3334: AND intel.period_id = spq.period_id
3335: AND intel.processing_status_code <> 'CLEAN'
4196: ORDER BY spq.quota_id;
4197:
4198: -- very similiar to the mark_event_srp_rule_uplift when figuring out
4199: -- the affected srp/period/quota
4200: -- only difference is that this time we go to cn_rt_quota_asgns to
4201: -- get the start_date/ end_date
4202: l_event_log_id NUMBER(15);
4203: l_temp_start_date DATE;
4204: l_temp_end_date DATE;