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_QUOTAS

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

1: PACKAGE CN_CHK_PLAN_ELEMENT_PKG 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 6: quota_id cn_quotas.quota_id%TYPE := NULL,

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,
10: end_period_id NUMBER := NULL,

Line 7: description cn_quotas.description%TYPE := NULL,

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,
10: end_period_id NUMBER := NULL,
11: start_date cn_quotas.start_date%TYPE := fnd_api.g_miss_date,

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 12: end_date cn_quotas.end_date%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,
16: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := 'N',

Line 13: quota_status cn_quotas.quota_status%TYPE := 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,
16: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := 'N',
17: vesting_flag cn_quotas.vesting_flag%TYPE := 'N',

Line 16: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := 'N',

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

Line 17: vesting_flag cn_quotas.vesting_flag%TYPE := 'N',

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

Line 18: -- quota_group_code cn_quotas.quota_group_code%TYPE

14: interval_name cn_interval_types.NAME%TYPE := NULL,
15: interval_type_id cn_interval_types.interval_type_id%TYPE := NULL,
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,

Line 21: -- period_type_code cn_quotas.period_type_code%TYPE

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
25: -- := 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 24: -- disc_option_code cn_quotas.discount_option_code%TYPE

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,
28: -- payment_type_code cn_quotas.payment_type_code%TYPE

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 28: -- payment_type_code cn_quotas.payment_type_code%TYPE

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,
32: quota_rule_id cn_quota_rules.quota_rule_id%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 31: calc_formula_id cn_quotas.calc_formula_id%TYPE := NULL,

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,
35: credit_type cn_credit_types.NAME%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 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 38: performance_goal cn_quotas.performance_goal%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,
42: split_flag cn_quotas.split_flag%TYPE := fnd_api.g_miss_char,

Line 39: -- quota_unspecified cn_quotas.quota_unspecified%TYPE

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

Line 41: package_name cn_quotas.package_name%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,
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,

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

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

Line 58: -- usage_code cn_quotas.usage_code%TYPE

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,
62: attribute1 cn_quotas.attribute1%TYPE := NULL,

Line 60: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%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,
62: attribute1 cn_quotas.attribute1%TYPE := NULL,
63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,

Line 61: attribute_category cn_quotas.attribute_category%TYPE := NULL,

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,
62: attribute1 cn_quotas.attribute1%TYPE := NULL,
63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,

Line 62: attribute1 cn_quotas.attribute1%TYPE := NULL,

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,
62: attribute1 cn_quotas.attribute1%TYPE := NULL,
63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,

Line 63: attribute2 cn_quotas.attribute2%TYPE := NULL,

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,
62: attribute1 cn_quotas.attribute1%TYPE := NULL,
63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,

Line 64: attribute3 cn_quotas.attribute3%TYPE := NULL,

60: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := NULL,
61: attribute_category cn_quotas.attribute_category%TYPE := NULL,
62: attribute1 cn_quotas.attribute1%TYPE := NULL,
63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,

Line 65: attribute4 cn_quotas.attribute4%TYPE := NULL,

61: attribute_category cn_quotas.attribute_category%TYPE := NULL,
62: attribute1 cn_quotas.attribute1%TYPE := NULL,
63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,

Line 66: attribute5 cn_quotas.attribute5%TYPE := NULL,

62: attribute1 cn_quotas.attribute1%TYPE := NULL,
63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,

Line 67: attribute6 cn_quotas.attribute6%TYPE := NULL,

63: attribute2 cn_quotas.attribute2%TYPE := NULL,
64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,

Line 68: attribute7 cn_quotas.attribute7%TYPE := NULL,

64: attribute3 cn_quotas.attribute3%TYPE := NULL,
65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,

Line 69: attribute8 cn_quotas.attribute8%TYPE := NULL,

65: attribute4 cn_quotas.attribute4%TYPE := NULL,
66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,

Line 70: attribute9 cn_quotas.attribute9%TYPE := NULL,

66: attribute5 cn_quotas.attribute5%TYPE := NULL,
67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,

Line 71: attribute10 cn_quotas.attribute10%TYPE := NULL,

67: attribute6 cn_quotas.attribute6%TYPE := NULL,
68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,

Line 72: attribute11 cn_quotas.attribute11%TYPE := NULL,

68: attribute7 cn_quotas.attribute7%TYPE := NULL,
69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,

Line 73: attribute12 cn_quotas.attribute12%TYPE := NULL,

69: attribute8 cn_quotas.attribute8%TYPE := NULL,
70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,
77: org_id cn_quotas.org_id%TYPE := NULL,

Line 74: attribute13 cn_quotas.attribute13%TYPE := NULL,

70: attribute9 cn_quotas.attribute9%TYPE := NULL,
71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,
77: org_id cn_quotas.org_id%TYPE := NULL,
78: object_version_number cn_quotas.object_version_number%type,

Line 75: attribute14 cn_quotas.attribute14%TYPE := NULL,

71: attribute10 cn_quotas.attribute10%TYPE := NULL,
72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,
77: org_id cn_quotas.org_id%TYPE := NULL,
78: object_version_number cn_quotas.object_version_number%type,
79: indirect_credit cn_quotas.indirect_credit%type

Line 76: attribute15 cn_quotas.attribute15%TYPE := NULL,

72: attribute11 cn_quotas.attribute11%TYPE := NULL,
73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,
77: org_id cn_quotas.org_id%TYPE := NULL,
78: object_version_number cn_quotas.object_version_number%type,
79: indirect_credit cn_quotas.indirect_credit%type
80: );

Line 77: org_id cn_quotas.org_id%TYPE := NULL,

73: attribute12 cn_quotas.attribute12%TYPE := NULL,
74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,
77: org_id cn_quotas.org_id%TYPE := NULL,
78: object_version_number cn_quotas.object_version_number%type,
79: indirect_credit cn_quotas.indirect_credit%type
80: );
81:

Line 78: object_version_number cn_quotas.object_version_number%type,

74: attribute13 cn_quotas.attribute13%TYPE := NULL,
75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,
77: org_id cn_quotas.org_id%TYPE := NULL,
78: object_version_number cn_quotas.object_version_number%type,
79: indirect_credit cn_quotas.indirect_credit%type
80: );
81:
82: g_miss_pe_rec pe_rec_type;

Line 79: indirect_credit cn_quotas.indirect_credit%type

75: attribute14 cn_quotas.attribute14%TYPE := NULL,
76: attribute15 cn_quotas.attribute15%TYPE := NULL,
77: org_id cn_quotas.org_id%TYPE := NULL,
78: object_version_number cn_quotas.object_version_number%type,
79: indirect_credit cn_quotas.indirect_credit%type
80: );
81:
82: g_miss_pe_rec pe_rec_type;
83:

Line 261: RETURN cn_quotas.quota_id%TYPE;

257: FUNCTION get_quota_id (
258: p_quota_name VARCHAR2,
259: p_org_id NUMBER
260: )
261: RETURN cn_quotas.quota_id%TYPE;
262:
263: PRAGMA RESTRICT_REFERENCES (get_quota_id, WNDS, WNPS);
264:
265: --| -----------------------------------------------------------------------+

Line 479: RETURN cn_quotas.quota_type_code%TYPE;

475: --| -------------------------------------------------------------------------+
476: FUNCTION get_quota_type (
477: p_quota_id IN NUMBER
478: )
479: RETURN cn_quotas.quota_type_code%TYPE;
480:
481: --| --------------------------------------------------------------------------+
482: --| Procedure Name : chk_formula_rate_date
483: --| Desc : get_quota_type