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_RULES_GRP dependencies on CN_PLAN_ELEMENT_PUB

Line 20: p_revenue_class_rec IN cn_plan_element_pub.revenue_class_rec_type,

16: -- Assign defalut value if input is missing
17: -- ----------------------------------------------------------------------------+
18: FUNCTION convert_rev_class_user_input (
19: p_quota_name IN VARCHAR2,
20: p_revenue_class_rec IN cn_plan_element_pub.revenue_class_rec_type,
21: x_return_status OUT NOCOPY VARCHAR2,
22: p_loading_status IN VARCHAR2,
23: x_loading_status OUT NOCOPY VARCHAR2
24: )

Line 397: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,

393: x_return_status OUT NOCOPY VARCHAR2,
394: x_msg_count OUT NOCOPY NUMBER,
395: x_msg_data OUT NOCOPY VARCHAR2,
396: p_quota_name IN VARCHAR2,
397: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
398: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
399: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
400: x_loading_status OUT NOCOPY VARCHAR2
401: )

Line 398: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,

394: x_msg_count OUT NOCOPY NUMBER,
395: x_msg_data OUT NOCOPY VARCHAR2,
396: p_quota_name IN VARCHAR2,
397: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
398: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
399: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
400: x_loading_status OUT NOCOPY VARCHAR2
401: )
402: IS

Line 399: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,

395: x_msg_data OUT NOCOPY VARCHAR2,
396: p_quota_name IN VARCHAR2,
397: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
398: p_rev_uplift_rec_tbl IN cn_plan_element_pub.rev_uplift_rec_tbl_type := cn_plan_element_pub.g_miss_rev_uplift_rec_tbl,
399: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
400: x_loading_status OUT NOCOPY VARCHAR2
401: )
402: IS
403: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Quota_Rules';

Line 406: l_revenue_class_rec cn_plan_element_pub.revenue_class_rec_type;

402: IS
403: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Quota_Rules';
404: l_api_version CONSTANT NUMBER := 1.0;
405: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec;
406: l_revenue_class_rec cn_plan_element_pub.revenue_class_rec_type;
407: l_trx_factor_rec cn_plan_element_pub.trx_factor_rec_type;
408: l_quota_rule_id NUMBER;
409: l_meaning cn_lookups.meaning%TYPE;
410: l_loading_status VARCHAR2 (80);

Line 407: l_trx_factor_rec cn_plan_element_pub.trx_factor_rec_type;

403: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Quota_Rules';
404: l_api_version CONSTANT NUMBER := 1.0;
405: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec;
406: l_revenue_class_rec cn_plan_element_pub.revenue_class_rec_type;
407: l_trx_factor_rec cn_plan_element_pub.trx_factor_rec_type;
408: l_quota_rule_id NUMBER;
409: l_meaning cn_lookups.meaning%TYPE;
410: l_loading_status VARCHAR2 (80);
411: BEGIN

Line 650: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,

646: x_return_status OUT NOCOPY VARCHAR2,
647: x_msg_count OUT NOCOPY NUMBER,
648: x_msg_data OUT NOCOPY VARCHAR2,
649: p_quota_name IN VARCHAR2,
650: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
651: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
652: x_loading_status OUT NOCOPY VARCHAR2
653: )
654: IS

Line 651: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,

647: x_msg_count OUT NOCOPY NUMBER,
648: x_msg_data OUT NOCOPY VARCHAR2,
649: p_quota_name IN VARCHAR2,
650: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
651: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
652: x_loading_status OUT NOCOPY VARCHAR2
653: )
654: IS
655: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Quota_Rules';

Line 658: l_revenue_class_rec cn_plan_element_pub.revenue_class_rec_type;

654: IS
655: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Quota_Rules';
656: l_api_version CONSTANT NUMBER := 1.0;
657: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec;
658: l_revenue_class_rec cn_plan_element_pub.revenue_class_rec_type;
659: l_trx_factor_rec cn_plan_element_pub.trx_factor_rec_type;
660: l_quota_rule_id NUMBER;
661: l_rev_class_id_old NUMBER;
662: l_loading_status VARCHAR2 (80);

Line 659: l_trx_factor_rec cn_plan_element_pub.trx_factor_rec_type;

655: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Quota_Rules';
656: l_api_version CONSTANT NUMBER := 1.0;
657: l_pe_rec cn_chk_plan_element_pkg.pe_rec_type := cn_chk_plan_element_pkg.g_miss_pe_rec;
658: l_revenue_class_rec cn_plan_element_pub.revenue_class_rec_type;
659: l_trx_factor_rec cn_plan_element_pub.trx_factor_rec_type;
660: l_quota_rule_id NUMBER;
661: l_rev_class_id_old NUMBER;
662: l_loading_status VARCHAR2 (80);
663: BEGIN

Line 883: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,

879: x_return_status OUT NOCOPY VARCHAR2,
880: x_msg_count OUT NOCOPY NUMBER,
881: x_msg_data OUT NOCOPY VARCHAR2,
882: p_quota_name IN VARCHAR2,
883: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
884: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
885: x_loading_status OUT NOCOPY VARCHAR2
886: )
887: IS

Line 884: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,

880: x_msg_count OUT NOCOPY NUMBER,
881: x_msg_data OUT NOCOPY VARCHAR2,
882: p_quota_name IN VARCHAR2,
883: p_revenue_class_rec_tbl IN cn_plan_element_pub.revenue_class_rec_tbl_type := cn_plan_element_pub.g_miss_revenue_class_rec_tbl,
884: p_trx_factor_rec_tbl IN cn_plan_element_pub.trx_factor_rec_tbl_type := cn_plan_element_pub.g_miss_trx_factor_rec_tbl,
885: x_loading_status OUT NOCOPY VARCHAR2
886: )
887: IS
888: l_api_name CONSTANT VARCHAR2 (30) := 'Delete_Plan_Element';