APPS.CN_PLAN_ELEMENT_PUB dependencies on CN_API

Line 17: NAME cn_quotas.NAME%TYPE := cn_api.g_miss_char,

13: --
14: -- Record Type for Plan Elements ( CN_QUOTAS )
15: --
16: TYPE plan_element_rec_type IS RECORD (
17: NAME cn_quotas.NAME%TYPE := cn_api.g_miss_char,
18: description cn_quotas.description%TYPE := cn_api.g_miss_char,
19: period_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
21: target cn_quotas.target%TYPE := 0,

Line 18: description cn_quotas.description%TYPE := cn_api.g_miss_char,

14: -- Record Type for Plan Elements ( CN_QUOTAS )
15: --
16: TYPE plan_element_rec_type IS RECORD (
17: NAME cn_quotas.NAME%TYPE := cn_api.g_miss_char,
18: description cn_quotas.description%TYPE := cn_api.g_miss_char,
19: period_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
21: target cn_quotas.target%TYPE := 0,
22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,

Line 19: period_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,

15: --
16: TYPE plan_element_rec_type IS RECORD (
17: NAME cn_quotas.NAME%TYPE := cn_api.g_miss_char,
18: description cn_quotas.description%TYPE := cn_api.g_miss_char,
19: period_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
21: target cn_quotas.target%TYPE := 0,
22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,

Line 20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,

16: TYPE plan_element_rec_type IS RECORD (
17: NAME cn_quotas.NAME%TYPE := cn_api.g_miss_char,
18: description cn_quotas.description%TYPE := cn_api.g_miss_char,
19: period_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
21: target cn_quotas.target%TYPE := 0,
22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,
24: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,

Line 22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,

18: description cn_quotas.description%TYPE := cn_api.g_miss_char,
19: period_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
21: target cn_quotas.target%TYPE := 0,
22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,
24: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,
26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,

Line 23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,

19: period_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
21: target cn_quotas.target%TYPE := 0,
22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,
24: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,
26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,
27: performance_goal cn_quotas.performance_goal%TYPE := 0,

Line 24: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,

20: element_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
21: target cn_quotas.target%TYPE := 0,
22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,
24: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,
26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,
27: performance_goal cn_quotas.performance_goal%TYPE := 0,
28: payment_amount cn_quotas.payment_amount%TYPE := 0,

Line 25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,

21: target cn_quotas.target%TYPE := 0,
22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,
24: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,
26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,
27: performance_goal cn_quotas.performance_goal%TYPE := 0,
28: payment_amount cn_quotas.payment_amount%TYPE := 0,
29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,

Line 26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,

22: incentive_type cn_lookups.meaning%TYPE := cn_api.g_miss_char,
23: credit_type cn_credit_types.NAME%TYPE := cn_api.g_miss_char,
24: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,
26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,
27: performance_goal cn_quotas.performance_goal%TYPE := 0,
28: payment_amount cn_quotas.payment_amount%TYPE := 0,
29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,
30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,

Line 29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,

25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,
26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,
27: performance_goal cn_quotas.performance_goal%TYPE := 0,
28: payment_amount cn_quotas.payment_amount%TYPE := 0,
29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,
30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,
31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,
32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,
33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,

Line 30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,

26: package_name cn_quotas.package_name%TYPE := cn_api.g_miss_char,
27: performance_goal cn_quotas.performance_goal%TYPE := 0,
28: payment_amount cn_quotas.payment_amount%TYPE := 0,
29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,
30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,
31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,
32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,
33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,
34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,

Line 31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,

27: performance_goal cn_quotas.performance_goal%TYPE := 0,
28: payment_amount cn_quotas.payment_amount%TYPE := 0,
29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,
30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,
31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,
32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,
33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,
34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,
35: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := cn_api.g_miss_char,

Line 32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,

28: payment_amount cn_quotas.payment_amount%TYPE := 0,
29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,
30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,
31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,
32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,
33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,
34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,
35: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := cn_api.g_miss_char,
36: expense_account_id cn_quotas_all.expense_account_id%TYPE := 0,

Line 33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,

29: start_date cn_quotas.start_date%TYPE := cn_api.g_miss_date,
30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,
31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,
32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,
33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,
34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,
35: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := cn_api.g_miss_char,
36: expense_account_id cn_quotas_all.expense_account_id%TYPE := 0,
37: liability_account_id cn_quotas_all.liability_account_id%TYPE := 0,

Line 34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,

30: end_date cn_quotas.end_date%TYPE := cn_api.g_miss_date,
31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,
32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,
33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,
34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,
35: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := cn_api.g_miss_char,
36: expense_account_id cn_quotas_all.expense_account_id%TYPE := 0,
37: liability_account_id cn_quotas_all.liability_account_id%TYPE := 0,
38: quota_group_code cn_quotas.quota_group_code%TYPE := cn_api.g_miss_char,

Line 35: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := cn_api.g_miss_char,

31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,
32: interval_name cn_interval_types.NAME%TYPE := cn_api.g_miss_char,
33: payee_assign_flag cn_quotas.payee_assign_flag%TYPE := cn_api.g_miss_char,
34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,
35: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := cn_api.g_miss_char,
36: expense_account_id cn_quotas_all.expense_account_id%TYPE := 0,
37: liability_account_id cn_quotas_all.liability_account_id%TYPE := 0,
38: quota_group_code cn_quotas.quota_group_code%TYPE := cn_api.g_miss_char,
39: -- clku, PAYMENT ENHANCEMENT

Line 38: quota_group_code cn_quotas.quota_group_code%TYPE := cn_api.g_miss_char,

34: vesting_flag cn_quotas.vesting_flag%TYPE := cn_api.g_miss_char,
35: addup_from_rev_class_flag cn_quotas.addup_from_rev_class_flag%TYPE := cn_api.g_miss_char,
36: expense_account_id cn_quotas_all.expense_account_id%TYPE := 0,
37: liability_account_id cn_quotas_all.liability_account_id%TYPE := 0,
38: quota_group_code cn_quotas.quota_group_code%TYPE := cn_api.g_miss_char,
39: -- clku, PAYMENT ENHANCEMENT
40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,
41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,

Line 40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,

36: expense_account_id cn_quotas_all.expense_account_id%TYPE := 0,
37: liability_account_id cn_quotas_all.liability_account_id%TYPE := 0,
38: quota_group_code cn_quotas.quota_group_code%TYPE := cn_api.g_miss_char,
39: -- clku, PAYMENT ENHANCEMENT
40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,
41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,

Line 41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,

37: liability_account_id cn_quotas_all.liability_account_id%TYPE := 0,
38: quota_group_code cn_quotas.quota_group_code%TYPE := cn_api.g_miss_char,
39: -- clku, PAYMENT ENHANCEMENT
40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,
41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,

Line 42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,

38: quota_group_code cn_quotas.quota_group_code%TYPE := cn_api.g_miss_char,
39: -- clku, PAYMENT ENHANCEMENT
40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,
41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,

Line 43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,

39: -- clku, PAYMENT ENHANCEMENT
40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,
41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,

Line 44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,

40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,
41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,

Line 45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,

41: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,

Line 46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,

42: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,

Line 47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,

43: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,

Line 48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,

44: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,

Line 49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,

45: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,

Line 50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,

46: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,

Line 51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,

47: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,

Line 52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,

48: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
56: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,

Line 53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,

49: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
56: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
57: org_id cn_quotas.org_id%TYPE := 0, -- Will be necessary when User has multiple OU access and will be validated

Line 54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,

50: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
56: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
57: org_id cn_quotas.org_id%TYPE := 0, -- Will be necessary when User has multiple OU access and will be validated
58: quota_id cn_quotas.quota_id%TYPE := 0, -- Will be ignored even it is set

Line 55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,

51: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
56: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
57: org_id cn_quotas.org_id%TYPE := 0, -- Will be necessary when User has multiple OU access and will be validated
58: quota_id cn_quotas.quota_id%TYPE := 0, -- Will be ignored even it is set
59: indirect_credit cn_quotas.indirect_credit%TYPE := cn_api.g_miss_char,

Line 56: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,

52: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
53: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
54: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
56: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
57: org_id cn_quotas.org_id%TYPE := 0, -- Will be necessary when User has multiple OU access and will be validated
58: quota_id cn_quotas.quota_id%TYPE := 0, -- Will be ignored even it is set
59: indirect_credit cn_quotas.indirect_credit%TYPE := cn_api.g_miss_char,
60: sreps_enddated_flag cn_quotas.salesreps_enddated_flag%TYPE := NULL

Line 59: indirect_credit cn_quotas.indirect_credit%TYPE := cn_api.g_miss_char,

55: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
56: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
57: org_id cn_quotas.org_id%TYPE := 0, -- Will be necessary when User has multiple OU access and will be validated
58: quota_id cn_quotas.quota_id%TYPE := 0, -- Will be ignored even it is set
59: indirect_credit cn_quotas.indirect_credit%TYPE := cn_api.g_miss_char,
60: sreps_enddated_flag cn_quotas.salesreps_enddated_flag%TYPE := NULL
61: );
62:
63: --

Line 84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,

80: --
81: -- Period quotas rec ( CN_PERIOD_QUOTAS )
82: --
83: TYPE period_quotas_rec_type IS RECORD (
84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,

Line 88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,

84: period_name cn_periods.period_name%TYPE := cn_api.g_miss_char,
85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,

Line 89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,

85: period_target cn_period_quotas.period_target%TYPE := 0,
86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,

Line 90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,

86: period_payment cn_period_quotas.period_payment%TYPE := 0,
87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,

Line 91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,

87: performance_goal cn_period_quotas.performance_goal%TYPE := 0,
88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,

Line 92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,

88: attribute1 cn_period_quotas.attribute1%TYPE := cn_api.g_miss_char,
89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,

Line 93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,

89: attribute2 cn_period_quotas.attribute2%TYPE := cn_api.g_miss_char,
90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,

Line 94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,

90: attribute3 cn_period_quotas.attribute3%TYPE := cn_api.g_miss_char,
91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,

Line 95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,

91: attribute4 cn_period_quotas.attribute4%TYPE := cn_api.g_miss_char,
92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,

Line 96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,

92: attribute5 cn_period_quotas.attribute5%TYPE := cn_api.g_miss_char,
93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,

Line 97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,

93: attribute6 cn_period_quotas.attribute6%TYPE := cn_api.g_miss_char,
94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,

Line 98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,

94: attribute7 cn_period_quotas.attribute7%TYPE := cn_api.g_miss_char,
95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,

Line 99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,

95: attribute8 cn_period_quotas.attribute8%TYPE := cn_api.g_miss_char,
96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,

Line 100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,

96: attribute9 cn_period_quotas.attribute9%TYPE := cn_api.g_miss_char,
97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0

Line 101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,

97: attribute10 cn_period_quotas.attribute10%TYPE := cn_api.g_miss_char,
98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0
105: );

Line 102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,

98: attribute11 cn_period_quotas.attribute11%TYPE := cn_api.g_miss_char,
99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0
105: );
106:

Line 103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,

99: attribute12 cn_period_quotas.attribute12%TYPE := cn_api.g_miss_char,
100: attribute13 cn_period_quotas.attribute13%TYPE := cn_api.g_miss_char,
101: attribute14 cn_period_quotas.attribute14%TYPE := cn_api.g_miss_char,
102: attribute15 cn_period_quotas.attribute15%TYPE := cn_api.g_miss_char,
103: period_name_old cn_periods.period_name%TYPE := cn_api.g_miss_char,
104: org_id cn_period_quotas.org_id%TYPE := 0
105: );
106:
107: --

Line 122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

118: --
119: -- Record Type for Revenue Classes ( CN_Quota_Rules )
120: --
121: TYPE revenue_class_rec_type IS RECORD (
122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,

Line 126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,

122: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,

Line 127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,

123: rev_class_target cn_quota_rules.target%TYPE := 0,
124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,

Line 128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,

124: rev_class_payment_amount cn_quota_rules.payment_amount%TYPE := 0,
125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,

Line 129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,

125: rev_class_performance_goal cn_quota_rules.performance_goal%TYPE := 0,
126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,

Line 130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,

126: description cn_quota_rules.description%TYPE := cn_api.g_miss_char,
127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,

Line 131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,

127: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,

Line 132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,

128: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,

Line 133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,

129: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,

Line 134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,

130: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,

Line 135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,

131: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,

Line 136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,

132: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,

Line 137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,

133: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,

Line 138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,

134: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,

Line 139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,

135: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

Line 140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,

136: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
144: org_id cn_quota_rules.org_id%TYPE := 0

Line 141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,

137: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
144: org_id cn_quota_rules.org_id%TYPE := 0
145:

Line 142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,

138: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
144: org_id cn_quota_rules.org_id%TYPE := 0
145:
146: );

Line 143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

139: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
140: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
141: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
142: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
143: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
144: org_id cn_quota_rules.org_id%TYPE := 0
145:
146: );
147:

Line 160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

156: --
157: -- User Defined Record For Uplift Factors ( CN_QUOTA_RULE_UPLIFTS )
158: --
159: TYPE rev_uplift_rec_type IS RECORD (
160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,

Line 161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,

157: -- User Defined Record For Uplift Factors ( CN_QUOTA_RULE_UPLIFTS )
158: --
159: TYPE rev_uplift_rec_type IS RECORD (
160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,

Line 162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,

158: --
159: TYPE rev_uplift_rec_type IS RECORD (
160: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,

Line 165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,

161: start_date cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,

Line 166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,

162: end_date cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,

Line 167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,

163: rev_class_payment_uplift NUMBER := 0,
164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,

Line 168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,

164: rev_class_quota_uplift NUMBER := 0,
165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,

Line 169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,

165: attribute_category cn_quota_rule_uplifts.attribute_category%TYPE := cn_api.g_miss_char,
166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,

Line 170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,

166: attribute1 cn_quota_rule_uplifts.attribute1%TYPE := cn_api.g_miss_char,
167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,

Line 171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,

167: attribute2 cn_quota_rule_uplifts.attribute2%TYPE := cn_api.g_miss_char,
168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,

Line 172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,

168: attribute3 cn_quota_rule_uplifts.attribute3%TYPE := cn_api.g_miss_char,
169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,

Line 173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,

169: attribute4 cn_quota_rule_uplifts.attribute4%TYPE := cn_api.g_miss_char,
170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,

Line 174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,

170: attribute5 cn_quota_rule_uplifts.attribute5%TYPE := cn_api.g_miss_char,
171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,

Line 175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,

171: attribute6 cn_quota_rule_uplifts.attribute6%TYPE := cn_api.g_miss_char,
172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,

Line 176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,

172: attribute7 cn_quota_rule_uplifts.attribute7%TYPE := cn_api.g_miss_char,
173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,

Line 177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,

173: attribute8 cn_quota_rule_uplifts.attribute8%TYPE := cn_api.g_miss_char,
174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

Line 178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,

174: attribute9 cn_quota_rule_uplifts.attribute9%TYPE := cn_api.g_miss_char,
175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,

Line 179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,

175: attribute10 cn_quota_rule_uplifts.attribute10%TYPE := cn_api.g_miss_char,
176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,

Line 180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,

176: attribute11 cn_quota_rule_uplifts.attribute11%TYPE := cn_api.g_miss_char,
177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,

Line 181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

177: attribute12 cn_quota_rule_uplifts.attribute12%TYPE := cn_api.g_miss_char,
178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type

Line 182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,

178: attribute13 cn_quota_rule_uplifts.attribute13%TYPE := cn_api.g_miss_char,
179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type
186: );

Line 183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,

179: attribute14 cn_quota_rule_uplifts.attribute14%TYPE := cn_api.g_miss_char,
180: attribute15 cn_quota_rule_uplifts.attribute15%TYPE := cn_api.g_miss_char,
181: rev_class_name_old cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
182: start_date_old cn_quota_rule_uplifts.start_date%TYPE := cn_api.g_miss_date,
183: end_date_old cn_quota_rule_uplifts.end_date%TYPE := cn_api.g_miss_date,
184: org_id cn_quota_rule_uplifts.org_id%TYPE := 0,
185: object_version_number cn_quota_rule_uplifts.object_version_number%type
186: );
187:

Line 200: trx_type cn_trx_factors.trx_type%TYPE := cn_api.g_miss_char,

196: --
197: -- User Defined Trx Factors Record Type ( CN_TRX_TYPES )
198: --
199: TYPE trx_factor_rec_type IS RECORD (
200: trx_type cn_trx_factors.trx_type%TYPE := cn_api.g_miss_char,
201: event_factor cn_trx_factors.event_factor%TYPE := 0,
202: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
203: org_id cn_trx_factors.org_id%TYPE := 0
204: );

Line 202: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,

198: --
199: TYPE trx_factor_rec_type IS RECORD (
200: trx_type cn_trx_factors.trx_type%TYPE := cn_api.g_miss_char,
201: event_factor cn_trx_factors.event_factor%TYPE := 0,
202: rev_class_name cn_quota_rules.NAME%TYPE := cn_api.g_miss_char,
203: org_id cn_trx_factors.org_id%TYPE := 0
204: );
205:
206: --

Line 218: rate_schedule_name cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,

214: --
215: -- user defined Rt_quota_asgns Record Type.( CN_RT_QUOTA_ASGNS )
216: --
217: TYPE rt_quota_asgns_rec_type IS RECORD (
218: rate_schedule_name cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
219: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,

Line 219: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,

215: -- user defined Rt_quota_asgns Record Type.( CN_RT_QUOTA_ASGNS )
216: --
217: TYPE rt_quota_asgns_rec_type IS RECORD (
218: rate_schedule_name cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
219: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,

Line 220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,

216: --
217: TYPE rt_quota_asgns_rec_type IS RECORD (
218: rate_schedule_name cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
219: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,

Line 221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,

217: TYPE rt_quota_asgns_rec_type IS RECORD (
218: rate_schedule_name cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
219: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,

Line 222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,

218: rate_schedule_name cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
219: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,

Line 223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,

219: calc_formula_name cn_calc_formulas.NAME%TYPE := cn_api.g_miss_char,
220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,

Line 224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,

220: start_date cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,

Line 225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,

221: end_date cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,

Line 226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,

222: attribute_category cn_quotas.attribute_category%TYPE := cn_api.g_miss_char,
223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,

Line 227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,

223: attribute1 cn_quotas.attribute1%TYPE := cn_api.g_miss_char,
224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,

Line 228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,

224: attribute2 cn_quotas.attribute2%TYPE := cn_api.g_miss_char,
225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,

Line 229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,

225: attribute3 cn_quotas.attribute3%TYPE := cn_api.g_miss_char,
226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,

Line 230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,

226: attribute4 cn_quotas.attribute4%TYPE := cn_api.g_miss_char,
227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,

Line 231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,

227: attribute5 cn_quotas.attribute5%TYPE := cn_api.g_miss_char,
228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,

Line 232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,

228: attribute6 cn_quotas.attribute6%TYPE := cn_api.g_miss_char,
229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,

Line 233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,

229: attribute7 cn_quotas.attribute7%TYPE := cn_api.g_miss_char,
230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,

Line 234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,

230: attribute8 cn_quotas.attribute8%TYPE := cn_api.g_miss_char,
231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,

Line 235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,

231: attribute9 cn_quotas.attribute9%TYPE := cn_api.g_miss_char,
232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
239: start_date_old cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,

Line 236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,

232: attribute10 cn_quotas.attribute10%TYPE := cn_api.g_miss_char,
233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
239: start_date_old cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
240: end_date_old cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,

Line 237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,

233: attribute11 cn_quotas.attribute11%TYPE := cn_api.g_miss_char,
234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
239: start_date_old cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
240: end_date_old cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
241: org_id cn_rt_quota_asgns.org_id%TYPE := 0

Line 238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,

234: attribute12 cn_quotas.attribute12%TYPE := cn_api.g_miss_char,
235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
239: start_date_old cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
240: end_date_old cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
241: org_id cn_rt_quota_asgns.org_id%TYPE := 0
242: );

Line 239: start_date_old cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,

235: attribute13 cn_quotas.attribute13%TYPE := cn_api.g_miss_char,
236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
239: start_date_old cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
240: end_date_old cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
241: org_id cn_rt_quota_asgns.org_id%TYPE := 0
242: );
243:

Line 240: end_date_old cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,

236: attribute14 cn_quotas.attribute14%TYPE := cn_api.g_miss_char,
237: attribute15 cn_quotas.attribute15%TYPE := cn_api.g_miss_char,
238: rate_schedule_name_old cn_rate_schedules.NAME%TYPE := cn_api.g_miss_char,
239: start_date_old cn_rt_quota_asgns.start_date%TYPE := cn_api.g_miss_date,
240: end_date_old cn_rt_quota_asgns.end_date%TYPE := cn_api.g_miss_date,
241: org_id cn_rt_quota_asgns.org_id%TYPE := 0
242: );
243:
244: g_miss_rt_quota_asgns_rec rt_quota_asgns_rec_type;

Line 581: p_init_msg_list IN VARCHAR2 := cn_api.g_false,

577: * @rep:displayname Create Plan Element
578: */
579: PROCEDURE create_plan_element (
580: p_api_version IN NUMBER := 0,
581: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
582: p_commit IN VARCHAR2 := cn_api.g_false,
583: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,

Line 582: p_commit IN VARCHAR2 := cn_api.g_false,

578: */
579: PROCEDURE create_plan_element (
580: p_api_version IN NUMBER := 0,
581: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
582: p_commit IN VARCHAR2 := cn_api.g_false,
583: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,

Line 583: p_validation_level IN NUMBER := cn_api.g_valid_level_full,

579: PROCEDURE create_plan_element (
580: p_api_version IN NUMBER := 0,
581: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
582: p_commit IN VARCHAR2 := cn_api.g_false,
583: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
584: x_return_status OUT NOCOPY VARCHAR2,
585: x_msg_count OUT NOCOPY NUMBER,
586: x_msg_data OUT NOCOPY VARCHAR2,
587: p_plan_element_rec IN plan_element_rec_type := g_miss_plan_element_rec,

Line 681: p_init_msg_list IN VARCHAR2 := cn_api.g_false,

677: * @rep:displayname Update Plan Element
678: */
679: PROCEDURE update_plan_element (
680: p_api_version IN NUMBER := 0,
681: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
682: p_commit IN VARCHAR2 := cn_api.g_false,
683: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,

Line 682: p_commit IN VARCHAR2 := cn_api.g_false,

678: */
679: PROCEDURE update_plan_element (
680: p_api_version IN NUMBER := 0,
681: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
682: p_commit IN VARCHAR2 := cn_api.g_false,
683: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,

Line 683: p_validation_level IN NUMBER := cn_api.g_valid_level_full,

679: PROCEDURE update_plan_element (
680: p_api_version IN NUMBER := 0,
681: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
682: p_commit IN VARCHAR2 := cn_api.g_false,
683: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,
687: p_new_plan_element_rec IN plan_element_rec_type := g_miss_plan_element_rec,

Line 688: p_quota_name_old IN VARCHAR2 := cn_api.g_miss_char,

684: x_return_status OUT NOCOPY VARCHAR2,
685: x_msg_count OUT NOCOPY NUMBER,
686: x_msg_data OUT NOCOPY VARCHAR2,
687: p_new_plan_element_rec IN plan_element_rec_type := g_miss_plan_element_rec,
688: p_quota_name_old IN VARCHAR2 := cn_api.g_miss_char,
689: p_revenue_class_rec_tbl IN revenue_class_rec_tbl_type := g_miss_revenue_class_rec_tbl,
690: p_rev_uplift_rec_tbl IN rev_uplift_rec_tbl_type := g_miss_rev_uplift_rec_tbl,
691: p_trx_factor_rec_tbl IN trx_factor_rec_tbl_type := g_miss_trx_factor_rec_tbl,
692: p_period_quotas_rec_tbl IN period_quotas_rec_tbl_type := g_miss_period_quotas_rec_tbl,

Line 766: p_init_msg_list IN VARCHAR2 := cn_api.g_false,

762: * @rep:displayname Delete Plan Element
763: */
764: PROCEDURE delete_plan_element (
765: p_api_version IN NUMBER := 0,
766: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
767: p_commit IN VARCHAR2 := cn_api.g_false,
768: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,

Line 767: p_commit IN VARCHAR2 := cn_api.g_false,

763: */
764: PROCEDURE delete_plan_element (
765: p_api_version IN NUMBER := 0,
766: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
767: p_commit IN VARCHAR2 := cn_api.g_false,
768: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,

Line 768: p_validation_level IN NUMBER := cn_api.g_valid_level_full,

764: PROCEDURE delete_plan_element (
765: p_api_version IN NUMBER := 0,
766: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
767: p_commit IN VARCHAR2 := cn_api.g_false,
768: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
769: x_return_status OUT NOCOPY VARCHAR2,
770: x_msg_count OUT NOCOPY NUMBER,
771: x_msg_data OUT NOCOPY VARCHAR2,
772: p_quota_rec IN plan_element_rec_type := g_miss_plan_element_rec,

Line 835: p_init_msg_list IN VARCHAR2 := cn_api.g_false,

831: * @rep:displayname Duplicate Plan Element
832: */
833: PROCEDURE duplicate_plan_element (
834: p_api_version IN NUMBER := 0,
835: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
836: p_commit IN VARCHAR2 := cn_api.g_false,
837: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
838: x_return_status OUT NOCOPY VARCHAR2,
839: x_msg_count OUT NOCOPY NUMBER,

Line 836: p_commit IN VARCHAR2 := cn_api.g_false,

832: */
833: PROCEDURE duplicate_plan_element (
834: p_api_version IN NUMBER := 0,
835: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
836: p_commit IN VARCHAR2 := cn_api.g_false,
837: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
838: x_return_status OUT NOCOPY VARCHAR2,
839: x_msg_count OUT NOCOPY NUMBER,
840: x_msg_data OUT NOCOPY VARCHAR2,

Line 837: p_validation_level IN NUMBER := cn_api.g_valid_level_full,

833: PROCEDURE duplicate_plan_element (
834: p_api_version IN NUMBER := 0,
835: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
836: p_commit IN VARCHAR2 := cn_api.g_false,
837: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
838: x_return_status OUT NOCOPY VARCHAR2,
839: x_msg_count OUT NOCOPY NUMBER,
840: x_msg_data OUT NOCOPY VARCHAR2,
841: p_plan_element_name IN cn_quotas.NAME%TYPE := cn_api.g_miss_char,

Line 841: p_plan_element_name IN cn_quotas.NAME%TYPE := cn_api.g_miss_char,

837: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
838: x_return_status OUT NOCOPY VARCHAR2,
839: x_msg_count OUT NOCOPY NUMBER,
840: x_msg_data OUT NOCOPY VARCHAR2,
841: p_plan_element_name IN cn_quotas.NAME%TYPE := cn_api.g_miss_char,
842: p_org_id IN NUMBER,
843: x_plan_element_name OUT NOCOPY cn_quotas.NAME%TYPE,
844: x_loading_status OUT NOCOPY VARCHAR2
845: );