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_PLAN_ELEMENT_PVT dependencies on CN_QUOTAS

Line 58: FROM cn_quotas_v pe

54: pe.indirect_credit,
55: pe.quota_status,
56: pe.salesreps_enddated_flag,
57: NULL
58: FROM cn_quotas_v pe
59: WHERE pe.quota_id = p_quota_id;
60:
61: l_plan_element plan_element_rec_type;
62: BEGIN

Line 111: FROM cn_quotas_v

107: SELECT 1
108: INTO l_dummy
109: FROM DUAL
110: WHERE EXISTS (SELECT 1
111: FROM cn_quotas_v
112: WHERE quota_id = p_quota_id AND org_id = p_org_id);
113: EXCEPTION
114: WHEN NO_DATA_FOUND
115: THEN

Line 172: l_temp_new := 'CN_QUOTAS';

168: IF (p_operation = 'create') THEN
169: fnd_message.set_name('CN','CNR12_NOTE_PE_NAME_CREATE');
170: fnd_message.set_token('PE_NAME', p_plan_element_new.NAME);
171: l_plan_element_id := p_plan_element_new.quota_id;
172: l_temp_new := 'CN_QUOTAS';
173: END IF;
174: IF (p_operation = 'delete') THEN
175: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_NAME_DELETE');
176: fnd_message.set_token('PE_NAME', p_plan_element_old.NAME);

Line 209: p_source_object_code => 'CN_QUOTAS',

205: x_return_status => x_return_status,
206: x_msg_count => x_msg_count,
207: x_msg_data => x_msg_data,
208: p_source_object_id => l_plan_element_id,
209: p_source_object_code => 'CN_QUOTAS',
210: p_notes => l_note_msg,
211: p_notes_detail => l_note_msg,
212: p_note_type => 'CN_SYSGEN', -- for system generated
213: x_jtf_note_id => l_note_id -- returned

Line 230: p_source_object_code => 'CN_QUOTAS',

226: x_return_status => x_return_status,
227: x_msg_count => x_msg_count,
228: x_msg_data => x_msg_data,
229: p_source_object_id => l_plan_element_id,
230: p_source_object_code => 'CN_QUOTAS',
231: p_notes => l_note_msg,
232: p_notes_detail => l_note_msg,
233: p_note_type => 'CN_SYSGEN', -- for system generated
234: x_jtf_note_id => l_note_id -- returned

Line 260: p_source_object_code => 'CN_QUOTAS',

256: x_return_status => x_return_status,
257: x_msg_count => x_msg_count,
258: x_msg_data => x_msg_data,
259: p_source_object_id => l_plan_element_id,
260: p_source_object_code => 'CN_QUOTAS',
261: p_notes => l_note_msg,
262: p_notes_detail => l_note_msg,
263: p_note_type => 'CN_SYSGEN', -- for system generated
264: x_jtf_note_id => l_note_id -- returned

Line 279: p_source_object_code => 'CN_QUOTAS',

275: x_return_status => x_return_status,
276: x_msg_count => x_msg_count,
277: x_msg_data => x_msg_data,
278: p_source_object_id => l_plan_element_id,
279: p_source_object_code => 'CN_QUOTAS',
280: p_notes => l_note_msg,
281: p_notes_detail => l_note_msg,
282: p_note_type => 'CN_SYSGEN', -- for system generated
283: x_jtf_note_id => l_note_id -- returned

Line 307: p_source_object_code => 'CN_QUOTAS',

303: x_return_status => x_return_status,
304: x_msg_count => x_msg_count,
305: x_msg_data => x_msg_data,
306: p_source_object_id => l_plan_element_id,
307: p_source_object_code => 'CN_QUOTAS',
308: p_notes => l_note_msg,
309: p_notes_detail => l_note_msg,
310: p_note_type => 'CN_SYSGEN', -- for system generated
311: x_jtf_note_id => l_note_id -- returned

Line 331: p_source_object_code => 'CN_QUOTAS',

327: x_return_status => x_return_status,
328: x_msg_count => x_msg_count,
329: x_msg_data => x_msg_data,
330: p_source_object_id => l_plan_element_id,
331: p_source_object_code => 'CN_QUOTAS',
332: p_notes => l_note_msg,
333: p_notes_detail => l_note_msg,
334: p_note_type => 'CN_SYSGEN', -- for system generated
335: x_jtf_note_id => l_note_id -- returned

Line 375: p_source_object_code => 'CN_QUOTAS',

371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,
374: p_source_object_id => l_plan_element_id,
375: p_source_object_code => 'CN_QUOTAS',
376: p_notes => l_note_msg,
377: p_notes_detail => l_note_msg,
378: p_note_type => 'CN_SYSGEN', -- for system generated
379: x_jtf_note_id => l_note_id -- returned

Line 397: p_source_object_code => 'CN_QUOTAS',

393: x_return_status => x_return_status,
394: x_msg_count => x_msg_count,
395: x_msg_data => x_msg_data,
396: p_source_object_id => l_plan_element_id,
397: p_source_object_code => 'CN_QUOTAS',
398: p_notes => l_note_msg,
399: p_notes_detail => l_note_msg,
400: p_note_type => 'CN_SYSGEN', -- for system generated
401: x_jtf_note_id => l_note_id -- returned

Line 425: p_source_object_code => 'CN_QUOTAS',

421: x_return_status => x_return_status,
422: x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data,
424: p_source_object_id => l_plan_element_id,
425: p_source_object_code => 'CN_QUOTAS',
426: p_notes => l_note_msg,
427: p_notes_detail => l_note_msg,
428: p_note_type => 'CN_SYSGEN', -- for system generated
429: x_jtf_note_id => l_note_id -- returned

Line 453: p_source_object_code => 'CN_QUOTAS',

449: x_return_status => x_return_status,
450: x_msg_count => x_msg_count,
451: x_msg_data => x_msg_data,
452: p_source_object_id => l_plan_element_id,
453: p_source_object_code => 'CN_QUOTAS',
454: p_notes => l_note_msg,
455: p_notes_detail => l_note_msg,
456: p_note_type => 'CN_SYSGEN', -- for system generated
457: x_jtf_note_id => l_note_id -- returned

Line 483: p_source_object_code => 'CN_QUOTAS',

479: x_return_status => x_return_status,
480: x_msg_count => x_msg_count,
481: x_msg_data => x_msg_data,
482: p_source_object_id => l_plan_element_id,
483: p_source_object_code => 'CN_QUOTAS',
484: p_notes => l_note_msg,
485: p_notes_detail => l_note_msg,
486: p_note_type => 'CN_SYSGEN', -- for system generated
487: x_jtf_note_id => l_note_id -- returned

Line 513: p_source_object_code => 'CN_QUOTAS',

509: x_return_status => x_return_status,
510: x_msg_count => x_msg_count,
511: x_msg_data => x_msg_data,
512: p_source_object_id => l_plan_element_id,
513: p_source_object_code => 'CN_QUOTAS',
514: p_notes => l_note_msg,
515: p_notes_detail => l_note_msg,
516: p_note_type => 'CN_SYSGEN', -- for system generated
517: x_jtf_note_id => l_note_id -- returned

Line 537: p_source_object_code => 'CN_QUOTAS',

533: x_return_status => x_return_status,
534: x_msg_count => x_msg_count,
535: x_msg_data => x_msg_data,
536: p_source_object_id => l_plan_element_id,
537: p_source_object_code => 'CN_QUOTAS',
538: p_notes => l_note_msg,
539: p_notes_detail => l_note_msg,
540: p_note_type => 'CN_SYSGEN', -- for system generated
541: x_jtf_note_id => l_note_id -- returned

Line 558: p_source_object_code => 'CN_QUOTAS',

554: x_return_status => x_return_status,
555: x_msg_count => x_msg_count,
556: x_msg_data => x_msg_data,
557: p_source_object_id => l_plan_element_id,
558: p_source_object_code => 'CN_QUOTAS',
559: p_notes => l_note_msg,
560: p_notes_detail => l_note_msg,
561: p_note_type => 'CN_SYSGEN', -- for system generated
562: x_jtf_note_id => l_note_id -- returned

Line 579: p_source_object_code => 'CN_QUOTAS',

575: x_return_status => x_return_status,
576: x_msg_count => x_msg_count,
577: x_msg_data => x_msg_data,
578: p_source_object_id => l_plan_element_id,
579: p_source_object_code => 'CN_QUOTAS',
580: p_notes => l_note_msg,
581: p_notes_detail => l_note_msg,
582: p_note_type => 'CN_SYSGEN', -- for system generated
583: x_jtf_note_id => l_note_id -- returned

Line 600: p_source_object_code => 'CN_QUOTAS',

596: x_return_status => x_return_status,
597: x_msg_count => x_msg_count,
598: x_msg_data => x_msg_data,
599: p_source_object_id => l_plan_element_id,
600: p_source_object_code => 'CN_QUOTAS',
601: p_notes => l_note_msg,
602: p_notes_detail => l_note_msg,
603: p_note_type => 'CN_SYSGEN', -- for system generated
604: x_jtf_note_id => l_note_id -- returned

Line 614: p_source_object_code => 'CN_QUOTAS',

610: x_return_status => x_return_status,
611: x_msg_count => x_msg_count,
612: x_msg_data => x_msg_data,
613: p_source_object_id => l_plan_element_id,
614: p_source_object_code => 'CN_QUOTAS',
615: p_notes => l_consolidated_note,
616: p_notes_detail => l_consolidated_note,
617: p_note_type => 'CN_SYSGEN', -- for system generated
618: x_jtf_note_id => l_note_id -- returned

Line 1410: SELECT cn_quotas_s.NEXTVAL

1406:
1407: -- API body
1408: IF p_plan_element.quota_id IS NULL
1409: THEN
1410: SELECT cn_quotas_s.NEXTVAL
1411: INTO p_plan_element.quota_id
1412: FROM DUAL;
1413: END IF;
1414:

Line 1433: cn_quotas_pkg.begin_record (x_operation => 'INSERT',

1429:
1430: -- update the account ids the UIs give a concatenated code
1431: validate_and_update_ccids (p_plan_element);
1432: -- update the table
1433: cn_quotas_pkg.begin_record (x_operation => 'INSERT',
1434: x_rowid => g_remove_this,
1435: x_quota_id => p_plan_element.quota_id,
1436: x_object_version_number => p_plan_element.object_version_number,
1437: x_name => p_plan_element.NAME,

Line 1635: FROM cn_quotas_v pe

1631: pe.indirect_credit,
1632: pe.quota_status,
1633: pe.salesreps_enddated_flag,
1634: NULL
1635: FROM cn_quotas_v pe
1636: WHERE pe.quota_id = qid;
1637:
1638: CURSOR get_number_dim (
1639: l_quota_id NUMBER

Line 1643: FROM cn_quotas_v cq,

1639: l_quota_id NUMBER
1640: )
1641: IS
1642: SELECT ccf.number_dim
1643: FROM cn_quotas_v cq,
1644: cn_calc_formulas ccf
1645: WHERE cq.quota_id = l_quota_id AND cq.calc_formula_id = ccf.calc_formula_id;
1646:
1647: CURSOR c_srp_period_quota_csr (

Line 1648: pe_quota_id cn_quotas.quota_id%TYPE

1644: cn_calc_formulas ccf
1645: WHERE cq.quota_id = l_quota_id AND cq.calc_formula_id = ccf.calc_formula_id;
1646:
1647: CURSOR c_srp_period_quota_csr (
1648: pe_quota_id cn_quotas.quota_id%TYPE
1649: )
1650: IS
1651: SELECT srp_period_quota_id
1652: FROM cn_srp_period_quotas

Line 1762: cn_quotas_pkg.begin_record (x_operation => 'UPDATE',

1758: -- update the accounts data
1759: validate_and_update_ccids (p_plan_element);
1760:
1761: -- call the table handler
1762: cn_quotas_pkg.begin_record (x_operation => 'UPDATE',
1763: x_rowid => g_row_id,
1764: x_quota_id => p_plan_element.quota_id,
1765: x_object_version_number => p_plan_element.object_version_number,
1766: x_name => p_plan_element.NAME,

Line 2014: l_quota_name cn_quotas.NAME%TYPE;

2010: )
2011: IS
2012: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Plan_Element';
2013: l_api_version CONSTANT NUMBER := 1.0;
2014: l_quota_name cn_quotas.NAME%TYPE;
2015: BEGIN
2016: -- Standard Start of API savepoint
2017: SAVEPOINT delete_plan_element;
2018:

Line 2050: FROM cn_quotas_v

2046:
2047: -- API body
2048: SELECT NAME
2049: INTO l_quota_name
2050: FROM cn_quotas_v
2051: WHERE quota_id = p_plan_element.quota_id;
2052:
2053: -- Call the Delete Record Table Handler
2054: cn_quotas_pkg.DELETE_RECORD (x_quota_id => p_plan_element.quota_id, x_name => l_quota_name);

Line 2054: cn_quotas_pkg.DELETE_RECORD (x_quota_id => p_plan_element.quota_id, x_name => l_quota_name);

2050: FROM cn_quotas_v
2051: WHERE quota_id = p_plan_element.quota_id;
2052:
2053: -- Call the Delete Record Table Handler
2054: cn_quotas_pkg.DELETE_RECORD (x_quota_id => p_plan_element.quota_id, x_name => l_quota_name);
2055:
2056: -- Calling proc to add system note for delete
2057: add_system_note(
2058: p_plan_element,

Line 2139: CURSOR uplift_curs(p_quota_id cn_quotas.quota_id%TYPE, p_start_date cn_quotas.start_date%TYPE, p_end_date cn_quotas.end_date%TYPE)

2135: )
2136: IS
2137:
2138: --Added by hanaraya for bug 6505174
2139: CURSOR uplift_curs(p_quota_id cn_quotas.quota_id%TYPE, p_start_date cn_quotas.start_date%TYPE, p_end_date cn_quotas.end_date%TYPE)
2140: IS
2141: SELECT COUNT (1)
2142: FROM cn_quota_rule_uplifts qru,
2143: cn_quota_rules qr

Line 2182: FROM cn_quotas_v

2178: IF (p_action = 'DELETE')
2179: THEN
2180: SELECT COUNT (*)
2181: INTO l_temp_count
2182: FROM cn_quotas_v
2183: WHERE quota_id = p_plan_element.quota_id;
2184:
2185: IF l_temp_count = 0
2186: THEN

Line 2239: FROM cn_quotas_all pe

2235:
2236: -- 2. plan element name must be unique
2237: SELECT COUNT (1)
2238: INTO l_temp_count
2239: FROM cn_quotas_all pe
2240: WHERE NAME = p_plan_element.NAME AND p_plan_element.quota_id <> pe.quota_id AND p_plan_element.org_id = pe.org_id AND delete_flag = 'N';
2241:
2242: IF l_temp_count <> 0
2243: THEN

Line 2285: FROM cn_quotas_all pe

2281:
2282: -- 2. plan element name must be unique
2283: SELECT COUNT (1)
2284: INTO l_temp_count
2285: FROM cn_quotas_all pe
2286: WHERE NAME = p_plan_element.NAME AND org_id = p_plan_element.org_id AND delete_flag = 'N';
2287:
2288: IF l_temp_count <> 0
2289: THEN

Line 2474: p_quota_id IN cn_quotas.quota_id%TYPE := NULL,

2470: p_api_version IN NUMBER := cn_api.g_miss_num,
2471: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
2472: p_commit IN VARCHAR2 := cn_api.g_false,
2473: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
2474: p_quota_id IN cn_quotas.quota_id%TYPE := NULL,
2475: x_plan_element OUT NOCOPY plan_element_rec_type,
2476: x_return_status OUT NOCOPY VARCHAR2,
2477: x_msg_count OUT NOCOPY NUMBER,
2478: x_msg_data OUT NOCOPY VARCHAR2,

Line 2494: pe_quota_id cn_quotas.quota_id%TYPE

2490: l_api_name CONSTANT VARCHAR2 (30) := 'check_rate_dim';
2491: l_same_pe NUMBER;
2492:
2493: CURSOR c_rate_schedule_csr (
2494: pe_quota_id cn_quotas.quota_id%TYPE
2495: )
2496: IS
2497: SELECT qa.rate_schedule_id
2498: FROM cn_rt_quota_asgns qa

Line 2502: pe_quota_id cn_quotas.quota_id%TYPE,

2498: FROM cn_rt_quota_asgns qa
2499: WHERE qa.quota_id = pe_quota_id;
2500:
2501: CURSOR c_rt_formula_csr (
2502: pe_quota_id cn_quotas.quota_id%TYPE,
2503: pe_rate_schedule_id cn_rt_quota_asgns.rate_schedule_id%TYPE
2504: )
2505: IS
2506: SELECT rtq.calc_formula_id

Line 2522: l_quota_name cn_quotas.NAME%TYPE;

2518: l_cumulative_flag cn_formula_inputs.cumulative_flag%TYPE;
2519: l_split_flag cn_formula_inputs.split_flag%TYPE;
2520: l_rate_dim_sequence cn_formula_inputs.rate_dim_sequence%TYPE;
2521: l_dim_unit_code cn_rate_dimensions.dim_unit_code%TYPE;
2522: l_quota_name cn_quotas.NAME%TYPE;
2523: BEGIN
2524: -- Initialize API return status to success
2525: FOR l_rate_schedule_id IN c_rate_schedule_csr (p_quota_id)
2526: LOOP

Line 2555: FROM cn_quotas

2551: IF (l_dim_unit_code <> 'PERCENT') AND (l_dim_unit_code <> 'AMOUNT') AND (l_dim_unit_code <> 'EXPRESSION')
2552: THEN
2553: SELECT NAME
2554: INTO l_quota_name
2555: FROM cn_quotas
2556: WHERE quota_id = p_quota_id;
2557:
2558: cn_message_pkg.set_message (appl_short_name => 'CN',
2559: message_name => 'CN_RATE_DIM_MUST_NUMERIC',

Line 2606: FROM cn_quotas q,

2602: SELECT qr.quota_rule_id,
2603: qr.revenue_class_id,
2604: rc.NAME rev_class_name,
2605: q.quota_type_code
2606: FROM cn_quotas q,
2607: cn_quota_rules_all qr,
2608: cn_revenue_classes_all rc
2609: WHERE qr.quota_id = p_quota_id
2610: AND qr.revenue_class_id = rc.revenue_class_id

Line 2686: FROM cn_quotas q,

2682: SELECT cf.NAME,
2683: q.calc_formula_id
2684: INTO x_formula_name,
2685: x_calc_formula_id
2686: FROM cn_quotas q,
2687: cn_calc_formulas cf
2688: WHERE q.quota_id = p_quota_id AND q.calc_formula_id = cf.calc_formula_id(+) AND q.quota_type_code IN ('EXTERNAL', 'FORMULA');
2689:
2690: IF l_plan_element.quota_type_code IN ('FORMULA', 'EXTERNAL')