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

Line 43: l_temp_new := 'CN_QUOTAS';

39: fnd_message.set_token('PROD', p_quota_rule_uplift.rev_class_name);
40: fnd_message.set_token('ST_DATE', p_quota_rule_uplift.start_date);
41: fnd_message.set_token('ED_DATE', p_quota_rule_uplift.end_date);
42: l_plan_element_id := p_quota_id;
43: l_temp_new := 'CN_QUOTAS';
44: END IF;
45: IF (p_operation = 'delete') THEN
46: fnd_message.set_name ('CN', 'CNR12_NOTE_PE_ELIG_EDATE_UPD');
47: fnd_message.set_token('ELIGPROD', p_quota_rule_uplift.rev_class_name);

Line 51: l_temp_new := 'CN_QUOTAS';

47: fnd_message.set_token('ELIGPROD', p_quota_rule_uplift.rev_class_name);
48: fnd_message.set_token('ST_DATE', p_quota_rule_uplift.start_date);
49: fnd_message.set_token('ED_DATE', p_quota_rule_uplift.end_date);
50: l_plan_element_id := p_quota_id;
51: l_temp_new := 'CN_QUOTAS';
52: END IF;
53: l_note_msg := fnd_message.get;
54: jtf_notes_pub.create_note
55: (p_api_version => 1.0,

Line 78: l_temp_new := 'CN_QUOTAS';

74: fnd_message.set_token('OLD_ED_DATE', p_quota_rule_uplift.end_date_old);
75: fnd_message.set_token('NEW_ST_DATE', p_quota_rule_uplift.start_date);
76: fnd_message.set_token('NEW_ED_DATE', p_quota_rule_uplift.end_date);
77: l_plan_element_id := p_quota_id;
78: l_temp_new := 'CN_QUOTAS';
79:
80: l_note_msg := fnd_message.get;
81: l_consolidated_note := l_note_msg || fnd_global.local_chr(10);
82: /* jtf_notes_pub.create_note

Line 104: l_temp_new := 'CN_QUOTAS';

100: fnd_message.set_token('ED_DATE', p_quota_rule_uplift.end_date);
101: fnd_message.set_token('OLD_MULTI',p_old_quota_rule_uplift.quota_factor);
102: fnd_message.set_token('NEW_MULTI',p_quota_rule_uplift.quota_factor );
103: l_plan_element_id := p_quota_id;
104: l_temp_new := 'CN_QUOTAS';
105:
106: l_note_msg := fnd_message.get;
107: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
108: /* jtf_notes_pub.create_note

Line 130: l_temp_new := 'CN_QUOTAS';

126: fnd_message.set_token('ED_DATE', p_quota_rule_uplift.end_date);
127: fnd_message.set_token('OLD_FACTOR', p_old_quota_rule_uplift.payment_factor);
128: fnd_message.set_token('NEW_FACTOR', p_quota_rule_uplift.payment_factor);
129: l_plan_element_id := p_quota_id;
130: l_temp_new := 'CN_QUOTAS';
131:
132: l_note_msg := fnd_message.get;
133: l_consolidated_note := l_consolidated_note || l_note_msg || fnd_global.local_chr(10);
134: /* jtf_notes_pub.create_note

Line 154: p_source_object_code => 'CN_QUOTAS',

150: x_return_status => x_return_status,
151: x_msg_count => x_msg_count,
152: x_msg_data => x_msg_data,
153: p_source_object_id => l_plan_element_id,
154: p_source_object_code => 'CN_QUOTAS',
155: p_notes => l_consolidated_note,
156: p_notes_detail => l_consolidated_note,
157: p_note_type => 'CN_SYSGEN', -- for system generated
158: x_jtf_note_id => l_note_id -- returned

Line 358: l_quota_name cn_quotas.NAME%TYPE;

354: l_temp_count NUMBER;
355: l_loading_status VARCHAR2 (50);
356: l_rev_uplift_rec_tbl quota_rule_uplift_tbl_type;
357: l_quota_rule_id NUMBER;
358: l_quota_name cn_quotas.NAME%TYPE;
359: l_start_date DATE;
360: l_end_date DATE;
361: l_null_date CONSTANT DATE := TO_DATE ('31-12-9999', 'DD-MM-YYYY');
362: l_quota_id NUMBER;

Line 421: FROM cn_quotas q,

417: q.quota_id
418: INTO l_start_date,
419: l_end_date,
420: l_quota_id
421: FROM cn_quotas q,
422: cn_quota_rules qr
423: WHERE qr.quota_rule_id = l_quota_rule_id AND q.quota_id = qr.quota_id;
424:
425: IF (l_rev_uplift_rec_tbl (1).start_date < l_start_date) OR (NVL (l_rev_uplift_rec_tbl (1).end_date, l_null_date) > l_end_date)

Line 441: cn_quotas q,

437: q.NAME
438: INTO l_rev_uplift_rec_tbl (1).rev_class_name,
439: l_quota_name
440: FROM cn_revenue_classes r,
441: cn_quotas q,
442: cn_quota_rules qr
443: WHERE qr.quota_rule_id = l_quota_rule_id AND r.revenue_class_id = qr.revenue_class_id AND q.quota_id = qr.quota_id;
444:
445: cn_quota_rule_uplifts_grp.create_quota_rule_uplift (p_api_version => 1.0,

Line 570: l_quota_name cn_quotas.NAME%TYPE;

566: l_temp_count NUMBER;
567: l_loading_status VARCHAR2 (50);
568: l_rev_uplift_rec_tbl quota_rule_uplift_tbl_type;
569: l_quota_rule_id NUMBER;
570: l_quota_name cn_quotas.NAME%TYPE;
571: l_start_date DATE;
572: l_end_date DATE;
573: l_null_date CONSTANT DATE := TO_DATE ('31-12-9999', 'DD-MM-YYYY');
574: l_quota_id NUMBER;

Line 663: FROM cn_quotas q,

659: q.quota_id
660: INTO l_start_date,
661: l_end_date,
662: l_quota_id
663: FROM cn_quotas q,
664: cn_quota_rules qr
665: WHERE qr.quota_rule_id = l_quota_rule_id AND q.quota_id = qr.quota_id;
666:
667: IF l_old_quota_rule_uplift.object_version_number <> p_quota_rule_uplift.object_version_number

Line 695: cn_quotas q,

691: q.NAME
692: INTO l_rev_uplift_rec_tbl (1).rev_class_name,
693: l_quota_name
694: FROM cn_revenue_classes r,
695: cn_quotas q,
696: cn_quota_rules qr
697: WHERE qr.quota_rule_id = l_quota_rule_id AND r.revenue_class_id = qr.revenue_class_id AND q.quota_id = qr.quota_id;
698:
699: SELECT r.NAME

Line 822: l_quota_name cn_quotas.NAME%TYPE;

818: l_temp_count NUMBER;
819: l_loading_status VARCHAR2 (50);
820: l_rev_uplift_rec_tbl quota_rule_uplift_tbl_type;
821: l_quota_rule_id NUMBER;
822: l_quota_name cn_quotas.NAME%TYPE;
823: l_quota_id NUMBER;
824: BEGIN
825: -- Standard Start of API savepoint
826: SAVEPOINT delete_quota_rule_uplift;

Line 857: cn_quotas q,

853: l_rev_uplift_rec_tbl (1).end_date,
854: l_rev_uplift_rec_tbl (1).org_id,
855: l_quota_id
856: FROM cn_revenue_classes r,
857: cn_quotas q,
858: cn_quota_rules qr,
859: cn_quota_rule_uplifts qru
860: WHERE qr.quota_rule_id = qru.quota_rule_id
861: AND r.revenue_class_id = qr.revenue_class_id