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_QUOTAS

Line 598: FROM cn_quotas_all q

594: FROM cn_cal_per_int_types_all
595: WHERE cal_period_id = p_period_id
596: AND interval_type_id IN(
597: SELECT DISTINCT q.interval_type_id
598: FROM cn_quotas_all q
599: WHERE q.quota_id IN(
600: SELECT quota_id
601: FROM cn_srp_quota_assigns_all
602: WHERE srp_plan_assign_id IN(

Line 644: FROM cn_quotas_all pe

640: WHERE cpit1.cal_period_id = p_period_id
641: AND cpit1.org_id = p_org_id
642: AND cpit1.interval_type_id =
643: (SELECT interval_type_id
644: FROM cn_quotas_all pe
645: WHERE pe.quota_id = p_quota_id
646: AND (
647: pe.incremental_type = 'N'
648: OR (

Line 1794: -- CASE 1: whenever there IS a change IN the CN_QUOTAS,it marks the

1790: -- Plan Element Has different event Names, all will do the same kind of job
1791: -- except the revent to state and the Event Name.
1792: -- Some cases the event name must be same.
1793:
1794: -- CASE 1: whenever there IS a change IN the CN_QUOTAS,it marks the
1795: -- It marks the all the Salesrep under that quotas.
1796: --
1797: -- CASE 2: whenever there is a change in the start date and the end date
1798: -- of CN_QUOTAS, it marks the specific salesreps in that period

Line 1798: -- of CN_QUOTAS, it marks the specific salesreps in that period

1794: -- CASE 1: whenever there IS a change IN the CN_QUOTAS,it marks the
1795: -- It marks the all the Salesrep under that quotas.
1796: --
1797: -- CASE 2: whenever there is a change in the start date and the end date
1798: -- of CN_QUOTAS, it marks the specific salesreps in that period
1799: -- for that quotas.
1800: -- called from trigger
1801: --
1802: -- Case 3: whenever there is a change in the CN_QUOTA_RULES only on revenue

Line 1868: FROM cn_quotas_all

1864:
1865: CURSOR l_quota_dates_csr IS
1866: SELECT start_date
1867: , end_date
1868: FROM cn_quotas_all
1869: WHERE quota_id = p_object_id;
1870:
1871: --clku
1872: CURSOR l_pe_cursor(l_salesrep_id NUMBER, l_period_id NUMBER, l_quota_id NUMBER) IS

Line 1877: temp_quota_id cn_quotas.quota_id%TYPE;

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);
1879: l_msg_count NUMBER;
1880: l_msg_data VARCHAR2(2000);
1881: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 2218: FROM cn_quotas_all

2214:
2215: CURSOR l_quota_dates_csr IS
2216: SELECT start_date
2217: , end_date
2218: FROM cn_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

Line 2226: temp_quota_id cn_quotas.quota_id%TYPE;

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);
2228: l_msg_count NUMBER;
2229: l_msg_data VARCHAR2(2000);
2230: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 2455: FROM cn_quotas_all

2451:
2452: CURSOR l_quota_dates_csr IS
2453: SELECT start_date
2454: , end_date
2455: FROM cn_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

Line 2463: temp_quota_id cn_quotas.quota_id%TYPE;

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);
2465: l_msg_count NUMBER;
2466: l_msg_data VARCHAR2(2000);
2467: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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 3034: temp_quota_id cn_quotas.quota_id%TYPE;

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);
3036: l_msg_count NUMBER;
3037: l_msg_data VARCHAR2(2000);
3038: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 3189: temp_quota_id cn_quotas.quota_id%TYPE;

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);
3191: l_msg_count NUMBER;
3192: l_msg_data VARCHAR2(2000);
3193: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 3345: temp_quota_id cn_quotas.quota_id%TYPE;

3341: SELECT quota_id
3342: FROM cn_srp_period_quotas
3343: WHERE salesrep_id = l_salesrep_id AND period_id = l_period_id AND quota_id = l_quota_id;
3344:
3345: temp_quota_id cn_quotas.quota_id%TYPE;
3346: l_return_status VARCHAR2(50);
3347: l_msg_count NUMBER;
3348: l_msg_data VARCHAR2(2000);
3349: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

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 3487: temp_quota_id cn_quotas.quota_id%TYPE;

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);
3489: l_msg_count NUMBER;
3490: l_msg_data VARCHAR2(2000);
3491: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 3888: temp_quota_id cn_quotas.quota_id%TYPE;

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);
3890: l_msg_count NUMBER;
3891: l_msg_data VARCHAR2(2000);
3892: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 4053: temp_quota_id cn_quotas.quota_id%TYPE;

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);
4055: l_msg_count NUMBER;
4056: l_msg_data VARCHAR2(2000);
4057: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 4215: temp_quota_id cn_quotas.quota_id%TYPE;

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);
4217: l_msg_count NUMBER;
4218: l_msg_data VARCHAR2(2000);
4219: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 4358: temp_quota_id cn_quotas.quota_id%TYPE;

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);
4360: l_msg_count NUMBER;
4361: l_msg_data VARCHAR2(2000);
4362: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;

Line 4650: temp_quota_id cn_quotas.quota_id%TYPE;

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);
4652: l_msg_count NUMBER;
4653: l_msg_data VARCHAR2(2000);
4654: dependent_pe_tbl cn_calc_sql_exps_pvt.num_tbl_type;