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 2200: FROM cn_srp_period_quotas_all spq

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

Line 2221: FROM cn_srp_period_quotas_all

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

Line 2437: FROM cn_srp_period_quotas_all spq

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

Line 2458: FROM cn_srp_period_quotas_all

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

Line 3016: FROM cn_quotas_all cq, cn_srp_period_quotas_all spq

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

Line 3029: FROM cn_srp_period_quotas_all

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

Line 3168: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel

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

Line 3184: FROM cn_srp_period_quotas_all

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

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

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

Line 3482: FROM cn_srp_period_quotas_all

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

Line 3768: FROM cn_srp_period_quotas_all spq

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

Line 3868: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods intel

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

Line 3881: FROM cn_srp_period_quotas_all

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

Line 4022: , cn_srp_period_quotas_all spq

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

Line 4046: FROM cn_srp_period_quotas_all

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

Line 4180: FROM cn_srp_period_quotas_all spq

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

Line 4208: FROM cn_srp_period_quotas_all

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

Line 4337: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel

4333: CURSOR affected_srp_period_quotas IS
4334: SELECT spq.salesrep_id
4335: , spq.period_id
4336: , spq.quota_id
4337: FROM cn_srp_period_quotas_all spq, cn_srp_intel_periods_all intel
4338: WHERE spq.srp_period_quota_id = p_srp_object_id -- p_srp_period_quota_id
4339: AND intel.salesrep_id = spq.salesrep_id
4340: AND intel.period_id = spq.period_id
4341: AND intel.org_id = spq.org_id

Line 4350: FROM cn_srp_period_quotas_all

4346: l_event_log_id NUMBER(15);
4347:
4348: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4349: SELECT quota_id
4350: FROM cn_srp_period_quotas_all
4351: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
4352:
4353: temp_quota_id cn_quotas.quota_id%TYPE;
4354: l_return_status VARCHAR2(50);

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

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

Line 4621: FROM cn_srp_period_quotas_all spq

4617: , spq.quota_id
4618: , DECODE(acc.period_id, l_start_period_id, l_s_date, acc.start_date) start_date
4619: , DECODE(acc.period_id, l_end_period_id, NVL(l_e_date, acc.end_date), acc.end_date)
4620: end_date
4621: FROM cn_srp_period_quotas_all spq
4622: , cn_period_statuses_all acc
4623: , cn_srp_intel_periods_all intel
4624: WHERE spq.srp_quota_assign_id = p_srp_object_id -- p_srp_quota_assign_id
4625: AND acc.period_id = spq.period_id

Line 4642: FROM cn_srp_period_quotas_all

4638: l_date_range_tbl cn_api.date_range_tbl_type;
4639:
4640: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS
4641: SELECT quota_id
4642: FROM cn_srp_period_quotas_all
4643: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
4644:
4645: temp_quota_id cn_quotas.quota_id%TYPE;
4646: l_return_status VARCHAR2(50);