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_QUOTA_RULE_UPLIFTS

Line 15: p_old_quota_rule_uplift IN cn_quota_rule_uplifts%ROWTYPE,

11: -- -------------------------------------------------------------------------+-+
12: PROCEDURE add_system_note(
13: p_quota_rule_uplift IN OUT NOCOPY quota_rule_uplift_rec_type,
14: p_quota_id IN NUMBER,
15: p_old_quota_rule_uplift IN cn_quota_rule_uplifts%ROWTYPE,
16: p_operation IN VARCHAR2,
17: x_return_status OUT NOCOPY VARCHAR2,
18: x_msg_count OUT NOCOPY NUMBER,
19: x_msg_data OUT NOCOPY VARCHAR2

Line 445: cn_quota_rule_uplifts_grp.create_quota_rule_uplift (p_api_version => 1.0,

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,
446: p_init_msg_list => 'T',
447: p_commit => 'F',
448: p_validation_level => 100,
449: x_return_status => x_return_status,

Line 561: FROM cn_quota_rule_uplifts

557:
558: CURSOR l_old_quota_rule_uplift_cr
559: IS
560: SELECT *
561: FROM cn_quota_rule_uplifts
562: WHERE quota_rule_uplift_id = p_quota_rule_uplift.quota_rule_uplift_id;
563:
564: l_old_quota_rule_uplift l_old_quota_rule_uplift_cr%ROWTYPE;
565: l_quota_rule_uplift quota_rule_uplift_rec_type;

Line 612: FROM cn_quota_rule_uplifts

608:
609: -- 2. trx type must be unique
610: SELECT COUNT (1)
611: INTO l_temp_count
612: FROM cn_quota_rule_uplifts
613: WHERE quota_rule_id = p_quota_rule_uplift.quota_rule_id
614: AND TRUNC (start_date) = TRUNC (p_quota_rule_uplift.start_date)
615: AND quota_rule_uplift_id <> p_quota_rule_uplift.quota_rule_uplift_id
616: AND ROWNUM = 1;

Line 705: cn_quota_rule_uplifts_grp.update_quota_rule_uplift (p_api_version => p_api_version,

701: FROM cn_revenue_classes r,
702: cn_quota_rules qr
703: WHERE qr.quota_rule_id = l_old_quota_rule_uplift.quota_rule_id AND r.revenue_class_id = qr.revenue_class_id;
704:
705: cn_quota_rule_uplifts_grp.update_quota_rule_uplift (p_api_version => p_api_version,
706: p_init_msg_list => p_init_msg_list,
707: p_commit => p_commit,
708: p_validation_level => p_validation_level,
709: x_return_status => x_return_status,

Line 859: cn_quota_rule_uplifts qru

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
862: AND q.quota_id = qr.quota_id
863: AND qru.quota_rule_uplift_id = p_quota_rule_uplift.quota_rule_uplift_id;

Line 865: cn_quota_rule_uplifts_grp.delete_quota_rule_uplift (p_api_version => 1.0,

861: AND r.revenue_class_id = qr.revenue_class_id
862: AND q.quota_id = qr.quota_id
863: AND qru.quota_rule_uplift_id = p_quota_rule_uplift.quota_rule_uplift_id;
864:
865: cn_quota_rule_uplifts_grp.delete_quota_rule_uplift (p_api_version => 1.0,
866: p_init_msg_list => 'T',
867: p_commit => 'F',
868: p_validation_level => 100,
869: x_return_status => x_return_status,