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