12:
13: -- Comp Plan Data type for single plan element
14: TYPE comp_plan_rec_type IS RECORD
15: (
16: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
18: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
13: -- Comp Plan Data type for single plan element
14: TYPE comp_plan_rec_type IS RECORD
15: (
16: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
18: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
14: TYPE comp_plan_rec_type IS RECORD
15: (
16: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
18: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
22: := CN_API.G_MISS_CHAR,
15: (
16: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
18: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
22: := CN_API.G_MISS_CHAR,
23: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
16: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
17: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
18: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
22: := CN_API.G_MISS_CHAR,
23: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
24: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
18: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
22: := CN_API.G_MISS_CHAR,
23: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
24: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
25: attribute_category cn_comp_plans.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
22: := CN_API.G_MISS_CHAR,
23: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
24: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
25: attribute_category cn_comp_plans.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
20: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
22: := CN_API.G_MISS_CHAR,
23: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
24: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
25: attribute_category cn_comp_plans.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
22: := CN_API.G_MISS_CHAR,
23: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
24: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
25: attribute_category cn_comp_plans.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
23: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
24: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
25: attribute_category cn_comp_plans.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
24: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
25: attribute_category cn_comp_plans.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
25: attribute_category cn_comp_plans.attribute_category%TYPE
26: := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
26: := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
27: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
28: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
30: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
31: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
39: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
32: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
39: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
40: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
33: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
39: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
40: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
41: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
34: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
39: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
40: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
41: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
42: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
35: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
39: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
40: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
41: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
42: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
43: );
36: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
39: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
40: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
41: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
42: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
43: );
44:
37: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
38: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
39: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
40: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
41: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
42: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
43: );
44:
45: -- Global variable that represent missing values.
53:
54: -- Comp Plan Data type for multiple plan element
55: TYPE comp_plan_list_rec_type IS RECORD
56: (
57: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
58: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
59: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
60: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
61: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
54: -- Comp Plan Data type for multiple plan element
55: TYPE comp_plan_list_rec_type IS RECORD
56: (
57: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
58: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
59: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
60: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
61: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
55: TYPE comp_plan_list_rec_type IS RECORD
56: (
57: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
58: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
59: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
60: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
61: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
63: := CN_API.G_MISS_CHAR,
56: (
57: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
58: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
59: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
60: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
61: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
63: := CN_API.G_MISS_CHAR,
64: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
57: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
58: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
59: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
60: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
61: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
63: := CN_API.G_MISS_CHAR,
64: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
65: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
59: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
60: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
61: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
63: := CN_API.G_MISS_CHAR,
64: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
65: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
60: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
61: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
63: := CN_API.G_MISS_CHAR,
64: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
65: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
63: := CN_API.G_MISS_CHAR,
64: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
65: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
63: := CN_API.G_MISS_CHAR,
64: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
65: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
64: sum_trx cn_comp_plans.sum_trx_flag%TYPE := CN_API.G_MISS_CHAR,
65: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
65: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
67: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
68: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
69: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
70: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
71: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
79: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
72: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
79: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
80: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
73: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
79: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
80: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
81: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
74: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
79: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
80: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
81: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
82: );
75: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
79: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
80: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
81: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
82: );
83:
76: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
79: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
80: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
81: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
82: );
83:
84: -- Global variable that represent missing values.
77: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
78: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
79: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
80: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
81: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
82: );
83:
84: -- Global variable that represent missing values.
85: G_MISS_COMP_PLAN_LIST_REC comp_plan_list_rec_type;
149:
150: PROCEDURE Create_Comp_Plan
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
154: p_commit IN VARCHAR2 := CN_API.G_FALSE,
155: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
150: PROCEDURE Create_Comp_Plan
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
154: p_commit IN VARCHAR2 := CN_API.G_FALSE,
155: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
151: (
152: p_api_version IN NUMBER,
153: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
154: p_commit IN VARCHAR2 := CN_API.G_FALSE,
155: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_comp_plan_rec IN comp_plan_rec_type := G_MISS_COMP_PLAN_REC,