APPS.CN_CHK_PLAN_ELEMENT_PKG dependencies on CN_QUOTA_RULE_UPLIFTS

Line 54: rev_class_payment_uplift cn_quota_rule_uplifts.payment_factor%TYPE := NULL,

50: rev_class_name cn_quota_rules.NAME%TYPE := fnd_api.g_miss_char,
51: rev_class_target cn_quota_rules.target%TYPE := fnd_api.g_miss_num,
52: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := fnd_api.g_miss_num,
53: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := fnd_api.g_miss_num,
54: rev_class_payment_uplift cn_quota_rule_uplifts.payment_factor%TYPE := NULL,
55: rev_class_quota_uplift cn_quota_rule_uplifts.quota_factor%TYPE := NULL,
56: rev_uplift_start_date cn_quota_rule_uplifts.start_date%TYPE := fnd_api.g_miss_date,
57: rev_uplift_end_date cn_quota_rule_uplifts.end_date%TYPE := fnd_api.g_miss_date,
58: -- usage_code cn_quotas.usage_code%TYPE

Line 55: rev_class_quota_uplift cn_quota_rule_uplifts.quota_factor%TYPE := NULL,

51: rev_class_target cn_quota_rules.target%TYPE := fnd_api.g_miss_num,
52: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := fnd_api.g_miss_num,
53: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := fnd_api.g_miss_num,
54: rev_class_payment_uplift cn_quota_rule_uplifts.payment_factor%TYPE := NULL,
55: rev_class_quota_uplift cn_quota_rule_uplifts.quota_factor%TYPE := NULL,
56: rev_uplift_start_date cn_quota_rule_uplifts.start_date%TYPE := fnd_api.g_miss_date,
57: rev_uplift_end_date cn_quota_rule_uplifts.end_date%TYPE := fnd_api.g_miss_date,
58: -- usage_code cn_quotas.usage_code%TYPE
59: -- := 'ABSOLUTE',

Line 56: rev_uplift_start_date cn_quota_rule_uplifts.start_date%TYPE := fnd_api.g_miss_date,

52: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := fnd_api.g_miss_num,
53: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := fnd_api.g_miss_num,
54: rev_class_payment_uplift cn_quota_rule_uplifts.payment_factor%TYPE := NULL,
55: rev_class_quota_uplift cn_quota_rule_uplifts.quota_factor%TYPE := NULL,
56: rev_uplift_start_date cn_quota_rule_uplifts.start_date%TYPE := fnd_api.g_miss_date,
57: rev_uplift_end_date cn_quota_rule_uplifts.end_date%TYPE := fnd_api.g_miss_date,
58: -- usage_code cn_quotas.usage_code%TYPE
59: -- := 'ABSOLUTE',
60: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := NULL,

Line 57: rev_uplift_end_date cn_quota_rule_uplifts.end_date%TYPE := fnd_api.g_miss_date,

53: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := fnd_api.g_miss_num,
54: rev_class_payment_uplift cn_quota_rule_uplifts.payment_factor%TYPE := NULL,
55: rev_class_quota_uplift cn_quota_rule_uplifts.quota_factor%TYPE := NULL,
56: rev_uplift_start_date cn_quota_rule_uplifts.start_date%TYPE := fnd_api.g_miss_date,
57: rev_uplift_end_date cn_quota_rule_uplifts.end_date%TYPE := fnd_api.g_miss_date,
58: -- usage_code cn_quotas.usage_code%TYPE
59: -- := 'ABSOLUTE',
60: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := NULL,
61: attribute_category cn_quotas.attribute_category%TYPE := NULL,

Line 330: RETURN cn_quota_rule_uplifts.start_date%TYPE;

326: --| --------------------------------------------------------------------+
327: FUNCTION get_uplift_start_date (
328: p_quota_rule_id NUMBER
329: )
330: RETURN cn_quota_rule_uplifts.start_date%TYPE;
331:
332: --| -----------------------------------------------------------------------+
333: --| Function Name : get_quota_rule_uplift_id
334: --| Desc : Get the Quota Rule UPLIFT ID using the quota_rule_id,

Line 342: RETURN cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE;

338: p_quota_rule_id NUMBER,
339: p_start_date DATE,
340: p_end_date DATE
341: )
342: RETURN cn_quota_rule_uplifts.quota_rule_uplift_id%TYPE;
343:
344: PRAGMA RESTRICT_REFERENCES (get_quota_rule_uplift_id, WNDS, WNPS);
345:
346: --| -----------------------------------------------------------------------+