DBA Data[Home] [Help]

APPS.CN_QUOTA_RULE_PVT dependencies on CN_CHK_PLAN_ELEMENT_PKG

Line 40: p_para_name => cn_chk_plan_element_pkg.g_pe_name,

36: -- Standard check of p_commit.
37: --+
38: -- Check if plan element name is missing or null even for Delete the Q Rule
39: IF ((cn_api.chk_miss_char_para (p_char_para => l_quota_rule.plan_element_name,
40: p_para_name => cn_chk_plan_element_pkg.g_pe_name,
41: p_loading_status => l_loading_status,
42: x_loading_status => l_loading_status
43: )
44: ) = fnd_api.g_true

Line 49: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,

45: )
46: THEN
47: RAISE fnd_api.g_exc_error;
48: ELSIF ((cn_api.chk_null_char_para (p_char_para => l_quota_rule.plan_element_name,
49: p_obj_name => cn_chk_plan_element_pkg.g_pe_name,
50: p_loading_status => l_loading_status,
51: x_loading_status => l_loading_status
52: )
53: ) = fnd_api.g_true

Line 61: p_para_name => cn_chk_plan_element_pkg.g_rev_cls_name,

57: END IF;
58:
59: -- Check rev class name is not miss, not null
60: IF ((cn_api.chk_miss_char_para (p_char_para => l_quota_rule.revenue_class_name,
61: p_para_name => cn_chk_plan_element_pkg.g_rev_cls_name,
62: p_loading_status => x_loading_status,
63: x_loading_status => l_loading_status
64: )
65: ) = fnd_api.g_true

Line 70: p_obj_name => cn_chk_plan_element_pkg.g_rev_cls_name,

66: )
67: THEN
68: RAISE fnd_api.g_exc_error;
69: ELSIF ((cn_api.chk_null_char_para (p_char_para => l_quota_rule.revenue_class_name,
70: p_obj_name => cn_chk_plan_element_pkg.g_rev_cls_name,
71: p_loading_status => x_loading_status,
72: x_loading_status => l_loading_status
73: )
74: ) = fnd_api.g_true

Line 81: l_quota_rule.quota_id := cn_chk_plan_element_pkg.get_quota_id (l_quota_rule.plan_element_name, l_quota_rule.org_id);

77: RAISE fnd_api.g_exc_error;
78: END IF;
79:
80: -- Get the Quota ID
81: l_quota_rule.quota_id := cn_chk_plan_element_pkg.get_quota_id (l_quota_rule.plan_element_name, l_quota_rule.org_id);
82:
83: -- Raise an Error If quota id is null but name is not null
84: IF l_quota_rule.quota_id IS NULL AND l_quota_rule.plan_element_name IS NOT NULL
85: THEN

Line 112: l_quota_rule.quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id (l_quota_rule.quota_id, l_quota_rule.revenue_class_id);

108: RAISE fnd_api.g_exc_error;
109: END IF;
110:
111: -- Get the Quota Rule ID
112: l_quota_rule.quota_rule_id := cn_chk_plan_element_pkg.get_quota_rule_id (l_quota_rule.quota_id, l_quota_rule.revenue_class_id);
113:
114: IF l_old_name IS NOT NULL
115: THEN
116: l_old_revenue_class_id := cn_api.get_rev_class_id (l_old_name, l_quota_rule.org_id);

Line 130: cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => l_quota_rule.quota_id,

126: RAISE fnd_api.g_exc_error;
127: END IF;
128:
129: l_old_quota_rule_id :=
130: cn_chk_plan_element_pkg.get_quota_rule_id (p_quota_id => l_quota_rule.quota_id,
131: p_rev_class_id => l_old_revenue_class_id);
132:
133: IF l_old_quota_rule_id IS NULL
134: THEN

Line 575: cn_chk_plan_element_pkg.chk_uplift_iud (x_return_status => x_return_status,

571: THEN
572: EXIT ;
573: END IF;
574:
575: cn_chk_plan_element_pkg.chk_uplift_iud (x_return_status => x_return_status,
576: p_start_date => l_uplift_rec.start_date,
577: p_end_date => l_uplift_rec.end_date,
578: p_iud_flag => 'U',
579: p_quota_rule_id => p_quota_rule.quota_rule_id,

Line 602: cn_chk_plan_element_pkg.chk_trx_factor (x_return_status => x_return_status,

598: END LOOP ;
599: CLOSE c_uplift_csr;
600:
601: -- ensure that the transaction factors add up to 100
602: cn_chk_plan_element_pkg.chk_trx_factor (x_return_status => x_return_status,
603: p_quota_rule_id => p_quota_rule.quota_rule_id,
604: p_rev_class_name => p_quota_rule.revenue_class_name,
605: p_loading_status => l_loading_status,
606: x_loading_status => l_loading_status