eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_MARK_EVENTS_PKG dependencies on CN_SRP_PERIOD_QUOTAS_ALL

Line 1852: FROM cn_srp_period_quotas_all spq

1848: acc.period_id
1849: , l_end_period_id, NVL(l_end_date, acc.end_date)
1850: , acc.end_date
1851: ) end_date
1852: FROM cn_srp_period_quotas_all spq
1853: , cn_srp_intel_periods_all sip
1854: , cn_period_statuses_all acc
1855: WHERE spq.quota_id = p_object_id
1856: AND spq.period_id BETWEEN l_start_period_id AND l_end_period_id

Line 1874: FROM cn_srp_period_quotas_all

1870:
1871: --clku
1872: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
1873: SELECT quota_id
1874: FROM cn_srp_period_quotas_all
1875: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
1876:
1877: temp_quota_id cn_quotas.quota_id%TYPE;
1878: l_return_status VARCHAR2(50);

Line 2202: FROM cn_srp_period_quotas_all spq

2198: -- modified by rjin 11/10/1999 add distinct
2199: SELECT DISTINCT spq.salesrep_id
2200: , spq.period_id
2201: , spq.quota_id
2202: FROM cn_srp_period_quotas_all spq
2203: , cn_srp_intel_periods_all sip
2204: , cn_period_statuses_all acc
2205: WHERE spq.quota_id = p_object_id
2206: AND spq.period_id BETWEEN l_start_period_id AND l_end_period_id

Line 2223: FROM cn_srp_period_quotas_all

2219: WHERE quota_id = p_object_id;
2220:
2221: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
2222: SELECT quota_id
2223: FROM cn_srp_period_quotas_all
2224: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
2225:
2226: temp_quota_id cn_quotas.quota_id%TYPE;
2227: l_return_status VARCHAR2(50);

Line 2439: FROM cn_srp_period_quotas_all spq

2435: acc.period_id
2436: , l_end_period_id, NVL(l_end_date, acc.end_date)
2437: , acc.end_date
2438: ) end_date
2439: FROM cn_srp_period_quotas_all spq
2440: , cn_srp_intel_periods_all sip
2441: , cn_period_statuses_all acc
2442: WHERE spq.quota_id = p_object_id
2443: AND spq.period_id BETWEEN l_start_period_id AND l_end_period_id

Line 2460: FROM cn_srp_period_quotas_all

2456: WHERE quota_id = p_object_id;
2457:
2458: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
2459: SELECT quota_id
2460: FROM cn_srp_period_quotas_all
2461: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
2462:
2463: temp_quota_id cn_quotas.quota_id%TYPE;
2464: l_return_status VARCHAR2(50);

Line 3018: FROM cn_quotas_all cq, cn_srp_period_quotas_all spq

3014: -- modified by rjin 11/10/1999 add distinct
3015: SELECT DISTINCT spq.salesrep_id
3016: , spq.period_id
3017: , spq.quota_id
3018: FROM cn_quotas_all cq, cn_srp_period_quotas_all spq
3019: , cn_srp_intel_periods_all intel
3020: WHERE cq.calc_formula_id = p_object_id
3021: AND cq.org_id = p_org_id
3022: AND spq.quota_id = cq.quota_id

Line 3031: FROM cn_srp_period_quotas_all

3027: ORDER BY spq.quota_id;
3028:
3029: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
3030: SELECT quota_id
3031: FROM cn_srp_period_quotas_all
3032: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
3033:
3034: temp_quota_id cn_quotas.quota_id%TYPE;
3035: l_return_status VARCHAR2(50);

Line 3170: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel

3166: CURSOR affected_srp_period_quotas IS
3167: SELECT DISTINCT spq.salesrep_id
3168: , spq.period_id
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

Line 3186: FROM cn_srp_period_quotas_all

3182: l_event_log_id NUMBER;
3183:
3184: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
3185: SELECT quota_id
3186: FROM cn_srp_period_quotas_all
3187: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
3188:
3189: temp_quota_id cn_quotas.quota_id%TYPE;
3190: l_return_status VARCHAR2(50);

Line 3469: FROM cn_quotas_all q, cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel

3465: CURSOR affected_srp_period_quotas IS
3466: SELECT DISTINCT spq.salesrep_id
3467: , spq.period_id
3468: , spq.quota_id
3469: FROM cn_quotas_all q, cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel
3470: WHERE q.interval_type_id = p_interval_type_id
3471: AND q.org_id = p_org_id
3472: AND p_end_date >= q.start_date
3473: AND (q.end_date IS NULL OR p_start_date <= q.end_date)

Line 3484: FROM cn_srp_period_quotas_all

3480: ORDER BY spq.quota_id;
3481:
3482: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
3483: SELECT quota_id
3484: FROM cn_srp_period_quotas_all
3485: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
3486:
3487: temp_quota_id cn_quotas.quota_id%TYPE;
3488: l_return_status VARCHAR2(50);

Line 3770: FROM cn_srp_period_quotas_all spq

3766: OR (spa.start_date BETWEEN acc.start_date AND acc.end_date)
3767: )
3768: AND EXISTS(
3769: SELECT 1
3770: FROM cn_srp_period_quotas_all spq
3771: WHERE spa.srp_plan_assign_id = spq.srp_plan_assign_id
3772: AND spq.period_id = acc.period_id)
3773: AND intel.salesrep_id = spa.salesrep_id
3774: AND intel.period_id = acc.period_id

Line 3871: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods intel

3867: CURSOR affected_srp_period_quotas IS
3868: SELECT spq.salesrep_id
3869: , spq.period_id
3870: , spq.quota_id
3871: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods intel
3872: WHERE spq.srp_quota_assign_id = p_srp_object_id -- p_srp_quota_assign_id
3873: AND intel.salesrep_id = spq.salesrep_id
3874: AND intel.period_id = spq.period_id
3875: AND intel.org_id = spq.org_id

Line 3885: FROM cn_srp_period_quotas_all

3881: l_event_log_id NUMBER(15);
3882:
3883: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
3884: SELECT quota_id
3885: FROM cn_srp_period_quotas_all
3886: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
3887:
3888: temp_quota_id cn_quotas.quota_id%TYPE;
3889: l_return_status VARCHAR2(50);

Line 4026: , cn_srp_period_quotas_all spq

4022: , DECODE(acc.period_id, l_start_period_id, l_s_date, acc.start_date) start_date
4023: , DECODE(acc.period_id, l_end_period_id, NVL(l_e_date, acc.end_date), acc.end_date)
4024: end_date
4025: FROM cn_srp_quota_rules_all rule
4026: , cn_srp_period_quotas_all spq
4027: , cn_period_statuses_all acc
4028: , cn_srp_intel_periods_all intel
4029: WHERE rule.srp_quota_rule_id = p_srp_object_id --p_srp_quota_rule_id
4030: AND spq.srp_plan_assign_id = rule.srp_plan_assign_id

Line 4050: FROM cn_srp_period_quotas_all

4046: l_temp_end_period_id NUMBER(15);
4047:
4048: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4049: SELECT quota_id
4050: FROM cn_srp_period_quotas_all
4051: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
4052:
4053: temp_quota_id cn_quotas.quota_id%TYPE;
4054: l_return_status VARCHAR2(50);

Line 4184: FROM cn_srp_period_quotas_all spq

4180: CURSOR affected_srp_period_quotas(l_srp_start_period_id NUMBER, l_srp_end_period_id NUMBER) IS
4181: SELECT spq.salesrep_id
4182: , spq.period_id
4183: , spq.quota_id
4184: FROM cn_srp_period_quotas_all spq
4185: , cn_period_statuses_all acc
4186: , cn_srp_intel_periods_all intel
4187: WHERE spq.srp_quota_assign_id = p_srp_object_id
4188: AND acc.period_id = spq.period_id

Line 4212: FROM cn_srp_period_quotas_all

4208: l_srp_end_period_id NUMBER(15);
4209:
4210: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4211: SELECT quota_id
4212: FROM cn_srp_period_quotas_all
4213: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
4214:
4215: temp_quota_id cn_quotas.quota_id%TYPE;
4216: l_return_status VARCHAR2(50);

Line 4341: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel

4337: CURSOR affected_srp_period_quotas IS
4338: SELECT spq.salesrep_id
4339: , spq.period_id
4340: , spq.quota_id
4341: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel
4342: WHERE spq.srp_period_quota_id = p_srp_object_id -- p_srp_period_quota_id
4343: AND intel.salesrep_id = spq.salesrep_id
4344: AND intel.period_id = spq.period_id
4345: AND intel.org_id = spq.org_id

Line 4355: FROM cn_srp_period_quotas_all

4351: l_event_log_id NUMBER(15);
4352:
4353: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4354: SELECT quota_id
4355: FROM cn_srp_period_quotas_all
4356: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
4357:
4358: temp_quota_id cn_quotas.quota_id%TYPE;
4359: l_return_status VARCHAR2(50);

Line 4535: -- CN_SRP_PERIOD_QUOTAS_ALL. But since this code is executed as part of

4531: -- We have to raise Notification Events even for the Dependent Plan Elements
4532: -- which are affected because of this change and it should be
4533: -- done only if the Dependent PE is valid for the Resource in that Period.
4534: -- In order to do that check, we have to validate against
4535: -- CN_SRP_PERIOD_QUOTAS_ALL. But since this code is executed as part of
4536: -- Trigger on the same table, we will run into ORA 04091 - Mutating Trigger.
4537: --
4538: -- Either we have to change the entire architecture of moving away from
4539: -- trigger and have table handlers and fire the events from there. Though

Line 4626: FROM cn_srp_period_quotas_all spq

4622: , spq.quota_id
4623: , DECODE(acc.period_id, l_start_period_id, l_s_date, acc.start_date) start_date
4624: , DECODE(acc.period_id, l_end_period_id, NVL(l_e_date, acc.end_date), acc.end_date)
4625: end_date
4626: FROM cn_srp_period_quotas_all spq
4627: , cn_period_statuses_all acc
4628: , cn_srp_intel_periods_all intel
4629: WHERE spq.srp_quota_assign_id = p_srp_object_id -- p_srp_quota_assign_id
4630: AND acc.period_id = spq.period_id

Line 4647: FROM cn_srp_period_quotas_all

4643: l_date_range_tbl cn_api.date_range_tbl_type;
4644:
4645: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4646: SELECT quota_id
4647: FROM cn_srp_period_quotas_all
4648: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
4649:
4650: temp_quota_id cn_quotas.quota_id%TYPE;
4651: l_return_status VARCHAR2(50);