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_PLAN_ELEMENT_PUB dependencies on CN_QUOTAS

Line 14: -- Record Type for Plan Elements ( CN_QUOTAS )

10: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
11: */
12:
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,

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 21: target cn_quotas.target%TYPE := 0,

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,
25: rt_sched_custom_flag cn_quotas.rt_sched_custom_flag%TYPE := cn_api.g_miss_char,

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 27: performance_goal cn_quotas.performance_goal%TYPE := 0,

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,
31: status cn_quotas.quota_status%TYPE := cn_api.g_miss_char,

Line 28: payment_amount cn_quotas.payment_amount%TYPE := 0,

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

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 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 36: expense_account_id cn_quotas_all.expense_account_id%TYPE := 0,

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
40: payment_group_code cn_quotas.payment_group_code%TYPE := cn_api.g_miss_char,

Line 37: liability_account_id cn_quotas_all.liability_account_id%TYPE := 0,

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

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 57: org_id cn_quotas.org_id%TYPE := 0, -- Will be necessary when User has multiple OU access and will be validated

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
61: );

Line 58: quota_id cn_quotas.quota_id%TYPE := 0, -- Will be ignored even it is set

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
61: );
62:

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 60: sreps_enddated_flag cn_quotas.salesreps_enddated_flag%TYPE := NULL

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: --
64: -- Global variable that represent missing values.

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 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 304: -- Plan Element ( CN_QUOTAS ), for detail see the declaration above .

300: --
301: -- Detail description about each parameters.
302: ------------------------------------------+
303: -- p_plan_element_rec has its own structure. It is an Input Parameter for the
304: -- Plan Element ( CN_QUOTAS ), for detail see the declaration above .
305: -- This structure mainly expects the quota informations. If you pass the plan
306: -- element information in the p_plan_element_rec it will validate and commits
307: -- into the database.
308: -- If you pass any Child it will validate and insert into the record into the

Line 798: -- IN : p_plan_element_name IN cn_quotas.name%TYPE

794: -- Default = FND_API.G_VALID_LEVEL_FULL
795: -- OUT : x_return_status OUT VARCHAR2(1)
796: -- x_msg_count OUT NUMBER
797: -- x_msg_data OUT VARCHAR2(2000)
798: -- IN : p_plan_element_name IN cn_quotas.name%TYPE
799: -- OUT : x_plan_element_name OUT cn_quotas.name%TYPE
800: --
801: -- Version : Current version 1.0
802: -- Initial version 1.0

Line 799: -- OUT : x_plan_element_name OUT cn_quotas.name%TYPE

795: -- OUT : x_return_status OUT VARCHAR2(1)
796: -- x_msg_count OUT NUMBER
797: -- x_msg_data OUT VARCHAR2(2000)
798: -- IN : p_plan_element_name IN cn_quotas.name%TYPE
799: -- OUT : x_plan_element_name OUT cn_quotas.name%TYPE
800: --
801: -- Version : Current version 1.0
802: -- Initial version 1.0
803: --

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: );

Line 843: x_plan_element_name OUT NOCOPY cn_quotas.NAME%TYPE,

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: );
846: END cn_plan_element_pub;