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_COMP_PLAN_PUB dependencies on CN_API

Line 16: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,

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,

Line 17: description cn_comp_plans.description%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

Line 18: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,

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,

Line 19: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,

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: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,

Line 20: status cn_comp_plans.status_code%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: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
24: attribute_category cn_comp_plans.attribute_category%TYPE

Line 22: := 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: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
24: attribute_category cn_comp_plans.attribute_category%TYPE
25: := CN_API.G_MISS_CHAR,
26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,

Line 23: plan_element_name cn_quotas.name%TYPE := 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: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
24: attribute_category cn_comp_plans.attribute_category%TYPE
25: := CN_API.G_MISS_CHAR,
26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,

Line 25: := CN_API.G_MISS_CHAR,

21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
22: := CN_API.G_MISS_CHAR,
23: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
24: attribute_category cn_comp_plans.attribute_category%TYPE
25: := CN_API.G_MISS_CHAR,
26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,

Line 26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,

22: := CN_API.G_MISS_CHAR,
23: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
24: attribute_category cn_comp_plans.attribute_category%TYPE
25: := CN_API.G_MISS_CHAR,
26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,

Line 27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,

23: plan_element_name cn_quotas.name%TYPE := CN_API.G_MISS_CHAR,
24: attribute_category cn_comp_plans.attribute_category%TYPE
25: := CN_API.G_MISS_CHAR,
26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,

Line 28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,

24: attribute_category cn_comp_plans.attribute_category%TYPE
25: := CN_API.G_MISS_CHAR,
26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,

Line 29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,

25: := CN_API.G_MISS_CHAR,
26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,

Line 30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,

26: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,

Line 31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,

27: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,

Line 32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,

28: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,

Line 33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,

29: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,

Line 34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,

30: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,

Line 35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,

31: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
39: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,

Line 36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,

32: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
39: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
40: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,

Line 37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,

33: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
39: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
40: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
41: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */

Line 38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,

34: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
39: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
40: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
41: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
42: );

Line 39: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,

35: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
39: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
40: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
41: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
42: );
43:

Line 40: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,

36: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
37: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
38: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
39: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
40: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR,
41: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */
42: );
43:
44: -- Global variable that represent missing values.

Line 56: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,

52:
53: -- Comp Plan Data type for multiple plan element
54: TYPE comp_plan_list_rec_type IS RECORD
55: (
56: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
57: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
58: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
59: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,

Line 57: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,

53: -- Comp Plan Data type for multiple plan element
54: TYPE comp_plan_list_rec_type IS RECORD
55: (
56: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
57: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
58: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
59: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
61: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE

Line 58: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,

54: TYPE comp_plan_list_rec_type IS RECORD
55: (
56: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
57: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
58: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
59: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
61: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
62: := CN_API.G_MISS_CHAR,

Line 59: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,

55: (
56: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
57: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
58: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
59: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
61: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
62: := CN_API.G_MISS_CHAR,
63: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,

Line 60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,

56: name cn_comp_plans.name%TYPE := CN_API.G_MISS_CHAR,
57: description cn_comp_plans.description%TYPE := CN_API.G_MISS_CHAR ,
58: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
59: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
61: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
62: := CN_API.G_MISS_CHAR,
63: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,

Line 62: := CN_API.G_MISS_CHAR,

58: start_date cn_comp_plans.start_date%TYPE := CN_API.G_MISS_DATE,
59: end_date cn_comp_plans.end_date%TYPE := CN_API.G_MISS_DATE,
60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
61: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
62: := CN_API.G_MISS_CHAR,
63: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,

Line 64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,

60: status cn_comp_plans.status_code%TYPE := CN_API.G_MISS_CHAR,
61: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
62: := CN_API.G_MISS_CHAR,
63: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,

Line 65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,

61: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE
62: := CN_API.G_MISS_CHAR,
63: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,

Line 66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,

62: := CN_API.G_MISS_CHAR,
63: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,

Line 67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,

63: plan_element_list plan_element_tbl_type := G_MISS_PE_LIST,
64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,

Line 68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,

64: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,
65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,

Line 69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,

65: attribute1 cn_comp_plans.attribute1%TYPE := CN_API.G_MISS_CHAR,
66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,

Line 70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,

66: attribute2 cn_comp_plans.attribute2%TYPE := CN_API.G_MISS_CHAR,
67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,

Line 71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,

67: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,
68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,

Line 72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,

68: attribute4 cn_comp_plans.attribute4%TYPE := CN_API.G_MISS_CHAR,
69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,

Line 73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,

69: attribute5 cn_comp_plans.attribute5%TYPE := CN_API.G_MISS_CHAR,
70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,

Line 74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,

70: attribute6 cn_comp_plans.attribute6%TYPE := CN_API.G_MISS_CHAR,
71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
78: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,

Line 75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,

71: attribute7 cn_comp_plans.attribute7%TYPE := CN_API.G_MISS_CHAR,
72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
78: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
79: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR

Line 76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,

72: attribute8 cn_comp_plans.attribute8%TYPE := CN_API.G_MISS_CHAR,
73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
78: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
79: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
80: );

Line 77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,

73: attribute9 cn_comp_plans.attribute9%TYPE := CN_API.G_MISS_CHAR,
74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
78: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
79: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
80: );
81:

Line 78: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,

74: attribute10 cn_comp_plans.attribute10%TYPE := CN_API.G_MISS_CHAR,
75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
78: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
79: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
80: );
81:
82: -- Global variable that represent missing values.

Line 79: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR

75: attribute11 cn_comp_plans.attribute11%TYPE := CN_API.G_MISS_CHAR,
76: attribute12 cn_comp_plans.attribute12%TYPE := CN_API.G_MISS_CHAR,
77: attribute13 cn_comp_plans.attribute13%TYPE := CN_API.G_MISS_CHAR,
78: attribute14 cn_comp_plans.attribute14%TYPE := CN_API.G_MISS_CHAR,
79: attribute15 cn_comp_plans.attribute15%TYPE := CN_API.G_MISS_CHAR
80: );
81:
82: -- Global variable that represent missing values.
83: G_MISS_COMP_PLAN_LIST_REC comp_plan_list_rec_type;

Line 151: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,

147:
148: PROCEDURE Create_Comp_Plan
149: (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
152: p_commit IN VARCHAR2 := CN_API.G_FALSE,
153: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,

Line 152: p_commit IN VARCHAR2 := CN_API.G_FALSE,

148: PROCEDURE Create_Comp_Plan
149: (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
152: p_commit IN VARCHAR2 := CN_API.G_FALSE,
153: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,

Line 153: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,

149: (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := CN_API.G_FALSE,
152: p_commit IN VARCHAR2 := CN_API.G_FALSE,
153: p_validation_level IN NUMBER := CN_API.G_VALID_LEVEL_FULL,
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
157: p_comp_plan_rec IN comp_plan_rec_type := G_MISS_COMP_PLAN_REC,