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_CHK_PLAN_ELEMENT_PKG dependencies on CN_QUOTA_RULES

Line 32: quota_rule_id cn_quota_rules.quota_rule_id%TYPE := NULL,

28: -- payment_type_code cn_quotas.payment_type_code%TYPE
29: -- := FND_API.G_MISS_CHAR,
30: payment_amount cn_quotas.payment_amount%TYPE := fnd_api.g_miss_num,
31: calc_formula_id cn_quotas.calc_formula_id%TYPE := NULL,
32: quota_rule_id cn_quota_rules.quota_rule_id%TYPE := NULL,
33: calc_formula_name cn_calc_formulas.NAME%TYPE := NULL,
34: incentive_type_code cn_quotas.incentive_type_code%TYPE := fnd_api.g_miss_char,
35: credit_type cn_credit_types.NAME%TYPE := fnd_api.g_miss_char,
36: credit_type_id cn_credit_types.credit_type_id%TYPE := NULL,

Line 49: rev_class_id cn_quota_rules.revenue_class_id%TYPE := NULL,

45: rate_table_id cn_rate_schedules.rate_schedule_id%TYPE := NULL,
46: rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,
47: disc_rate_table_id cn_rate_schedules.rate_schedule_id%TYPE := NULL,
48: disc_rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,
49: rev_class_id cn_quota_rules.revenue_class_id%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,

Line 50: rev_class_name cn_quota_rules.NAME%TYPE := fnd_api.g_miss_char,

46: rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,
47: disc_rate_table_id cn_rate_schedules.rate_schedule_id%TYPE := NULL,
48: disc_rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,
49: rev_class_id cn_quota_rules.revenue_class_id%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,

Line 51: rev_class_target cn_quota_rules.target%TYPE := fnd_api.g_miss_num,

47: disc_rate_table_id cn_rate_schedules.rate_schedule_id%TYPE := NULL,
48: disc_rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,
49: rev_class_id cn_quota_rules.revenue_class_id%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,

Line 52: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := fnd_api.g_miss_num,

48: disc_rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,
49: rev_class_id cn_quota_rules.revenue_class_id%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,

Line 53: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := fnd_api.g_miss_num,

49: rev_class_id cn_quota_rules.revenue_class_id%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,

Line 319: RETURN cn_quota_rules.quota_rule_id%TYPE;

315: FUNCTION get_quota_rule_id (
316: p_quota_id NUMBER,
317: p_rev_class_id NUMBER
318: )
319: RETURN cn_quota_rules.quota_rule_id%TYPE;
320:
321: PRAGMA RESTRICT_REFERENCES (get_quota_rule_id, WNDS, WNPS);
322:
323: --| -----------------------------------------------------------------------+