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 FND_API

Line 5: NAME cn_quotas.NAME%TYPE := fnd_api.g_miss_char,

1: PACKAGE CN_CHK_PLAN_ELEMENT_PKG AUTHID CURRENT_USER AS
2: /* $Header: cnchkpes.pls 120.4 2005/09/14 02:41:27 rarajara ship $ */
3: -- Modified on 07/19/99, Added more columns in the pe_rec_type
4: TYPE pe_rec_type IS RECORD (
5: NAME cn_quotas.NAME%TYPE := fnd_api.g_miss_char,
6: quota_id cn_quotas.quota_id%TYPE := NULL,
7: description cn_quotas.description%TYPE := NULL,
8: start_period_id NUMBER := NULL,
9: start_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,

Line 9: start_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,

5: NAME cn_quotas.NAME%TYPE := fnd_api.g_miss_char,
6: quota_id cn_quotas.quota_id%TYPE := NULL,
7: description cn_quotas.description%TYPE := NULL,
8: start_period_id NUMBER := NULL,
9: start_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,
10: end_period_id NUMBER := NULL,
11: start_date cn_quotas.start_date%TYPE := fnd_api.g_miss_date,
12: end_date cn_quotas.end_date%TYPE := NULL,
13: quota_status cn_quotas.quota_status%TYPE := NULL,

Line 11: start_date cn_quotas.start_date%TYPE := fnd_api.g_miss_date,

7: description cn_quotas.description%TYPE := NULL,
8: start_period_id NUMBER := NULL,
9: start_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,
10: end_period_id NUMBER := NULL,
11: start_date cn_quotas.start_date%TYPE := fnd_api.g_miss_date,
12: end_date cn_quotas.end_date%TYPE := NULL,
13: quota_status cn_quotas.quota_status%TYPE := NULL,
14: interval_name cn_interval_types.NAME%TYPE := NULL,
15: interval_type_id cn_interval_types.interval_type_id%TYPE := NULL,

Line 20: end_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,

16: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := 'N',
17: vesting_flag cn_quotas.vesting_flag%TYPE := 'N',
18: -- quota_group_code cn_quotas.quota_group_code%TYPE
19: -- := NULL,
20: end_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,
21: -- period_type_code cn_quotas.period_type_code%TYPE
22: -- := FND_API.G_MISS_CHAR,
23: quota_type_code cn_quotas.quota_type_code%TYPE := fnd_api.g_miss_char,
24: -- disc_option_code cn_quotas.discount_option_code%TYPE

Line 22: -- := FND_API.G_MISS_CHAR,

18: -- quota_group_code cn_quotas.quota_group_code%TYPE
19: -- := NULL,
20: end_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,
21: -- period_type_code cn_quotas.period_type_code%TYPE
22: -- := FND_API.G_MISS_CHAR,
23: quota_type_code cn_quotas.quota_type_code%TYPE := fnd_api.g_miss_char,
24: -- disc_option_code cn_quotas.discount_option_code%TYPE
25: -- := FND_API.G_MISS_CHAR,
26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,

Line 23: quota_type_code cn_quotas.quota_type_code%TYPE := fnd_api.g_miss_char,

19: -- := NULL,
20: end_period_name cn_periods.period_name%TYPE := fnd_api.g_miss_char,
21: -- period_type_code cn_quotas.period_type_code%TYPE
22: -- := FND_API.G_MISS_CHAR,
23: quota_type_code cn_quotas.quota_type_code%TYPE := fnd_api.g_miss_char,
24: -- disc_option_code cn_quotas.discount_option_code%TYPE
25: -- := FND_API.G_MISS_CHAR,
26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,
27: target cn_quotas.target%TYPE := fnd_api.g_miss_num,

Line 25: -- := FND_API.G_MISS_CHAR,

21: -- period_type_code cn_quotas.period_type_code%TYPE
22: -- := FND_API.G_MISS_CHAR,
23: quota_type_code cn_quotas.quota_type_code%TYPE := fnd_api.g_miss_char,
24: -- disc_option_code cn_quotas.discount_option_code%TYPE
25: -- := FND_API.G_MISS_CHAR,
26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,
27: target cn_quotas.target%TYPE := fnd_api.g_miss_num,
28: -- payment_type_code cn_quotas.payment_type_code%TYPE
29: -- := FND_API.G_MISS_CHAR,

Line 26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,

22: -- := FND_API.G_MISS_CHAR,
23: quota_type_code cn_quotas.quota_type_code%TYPE := fnd_api.g_miss_char,
24: -- disc_option_code cn_quotas.discount_option_code%TYPE
25: -- := FND_API.G_MISS_CHAR,
26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,
27: target cn_quotas.target%TYPE := fnd_api.g_miss_num,
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,

Line 27: target cn_quotas.target%TYPE := fnd_api.g_miss_num,

23: quota_type_code cn_quotas.quota_type_code%TYPE := fnd_api.g_miss_char,
24: -- disc_option_code cn_quotas.discount_option_code%TYPE
25: -- := FND_API.G_MISS_CHAR,
26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,
27: target cn_quotas.target%TYPE := fnd_api.g_miss_num,
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,

Line 29: -- := FND_API.G_MISS_CHAR,

25: -- := FND_API.G_MISS_CHAR,
26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,
27: target cn_quotas.target%TYPE := fnd_api.g_miss_num,
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,

Line 30: payment_amount cn_quotas.payment_amount%TYPE := fnd_api.g_miss_num,

26: trx_group_code cn_quotas.trx_group_code%TYPE := fnd_api.g_miss_char,
27: target cn_quotas.target%TYPE := fnd_api.g_miss_num,
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,

Line 34: incentive_type_code cn_quotas.incentive_type_code%TYPE := 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,
37: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := fnd_api.g_miss_char,
38: performance_goal cn_quotas.performance_goal%TYPE := NULL,

Line 35: credit_type cn_credit_types.NAME%TYPE := fnd_api.g_miss_char,

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,
37: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := fnd_api.g_miss_char,
38: performance_goal cn_quotas.performance_goal%TYPE := NULL,
39: -- quota_unspecified cn_quotas.quota_unspecified%TYPE

Line 37: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := fnd_api.g_miss_char,

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,
37: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := fnd_api.g_miss_char,
38: performance_goal cn_quotas.performance_goal%TYPE := NULL,
39: -- quota_unspecified cn_quotas.quota_unspecified%TYPE
40: -- := NULL,
41: package_name cn_quotas.package_name%TYPE := NULL,

Line 42: split_flag cn_quotas.split_flag%TYPE := fnd_api.g_miss_char,

38: performance_goal cn_quotas.performance_goal%TYPE := NULL,
39: -- quota_unspecified cn_quotas.quota_unspecified%TYPE
40: -- := NULL,
41: package_name cn_quotas.package_name%TYPE := NULL,
42: split_flag cn_quotas.split_flag%TYPE := fnd_api.g_miss_char,
43: itd_flag cn_calc_formulas.itd_flag%TYPE := fnd_api.g_miss_char,
44: cumulative_flag cn_quotas.cumulative_flag%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,

Line 43: itd_flag cn_calc_formulas.itd_flag%TYPE := fnd_api.g_miss_char,

39: -- quota_unspecified cn_quotas.quota_unspecified%TYPE
40: -- := NULL,
41: package_name cn_quotas.package_name%TYPE := NULL,
42: split_flag cn_quotas.split_flag%TYPE := fnd_api.g_miss_char,
43: itd_flag cn_calc_formulas.itd_flag%TYPE := fnd_api.g_miss_char,
44: cumulative_flag cn_quotas.cumulative_flag%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,

Line 46: rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,

42: split_flag cn_quotas.split_flag%TYPE := fnd_api.g_miss_char,
43: itd_flag cn_calc_formulas.itd_flag%TYPE := fnd_api.g_miss_char,
44: cumulative_flag cn_quotas.cumulative_flag%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,

Line 48: disc_rate_table_name cn_rate_schedules.NAME%TYPE := fnd_api.g_miss_char,

44: cumulative_flag cn_quotas.cumulative_flag%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,

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 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,