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_COMP_PLANS

Line 10: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS

6: * @rep:product CN
7: * @rep:displayname Create Compensation Plan
8: * @rep:lifecycle active
9: * @rep:compatibility S
10: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
11: */
12:
13: -- Comp Plan Data type for single plan element
14: TYPE comp_plan_rec_type IS RECORD

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: sum_trx cn_comp_plans.sum_trx_flag%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: 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,

Line 21: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE

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,
25: attribute_category cn_comp_plans.attribute_category%TYPE

Line 23: sum_trx cn_comp_plans.sum_trx_flag%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: 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,

Line 25: attribute_category cn_comp_plans.attribute_category%TYPE

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,
29: attribute3 cn_comp_plans.attribute3%TYPE := CN_API.G_MISS_CHAR,

Line 27: attribute1 cn_comp_plans.attribute1%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,

Line 28: attribute2 cn_comp_plans.attribute2%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,

Line 29: attribute3 cn_comp_plans.attribute3%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,

Line 30: attribute4 cn_comp_plans.attribute4%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,

Line 31: attribute5 cn_comp_plans.attribute5%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,

Line 32: attribute6 cn_comp_plans.attribute6%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,

Line 33: attribute7 cn_comp_plans.attribute7%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,

Line 34: attribute8 cn_comp_plans.attribute8%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,

Line 35: attribute9 cn_comp_plans.attribute9%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,

Line 36: attribute10 cn_comp_plans.attribute10%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,

Line 37: attribute11 cn_comp_plans.attribute11%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,

Line 38: attribute12 cn_comp_plans.attribute12%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 */

Line 39: attribute13 cn_comp_plans.attribute13%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 */
43: );

Line 40: attribute14 cn_comp_plans.attribute14%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: );
44:

Line 41: attribute15 cn_comp_plans.attribute15%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:
45: -- Global variable that represent missing values.

Line 42: ORG_ID CN_COMP_PLANS.ORG_ID%TYPE := NULL /* ADDED OAFWK */

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.
46: G_MISS_COMP_PLAN_REC comp_plan_rec_type;

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

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,

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

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

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,

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

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,

Line 61: status cn_comp_plans.status_code%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,

Line 62: rc_overlap cn_comp_plans.ALLOW_REV_CLASS_OVERLAP%TYPE

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,
66: attribute_category cn_comp_plans.attribute_category%TYPE := CN_API.G_MISS_CHAR,

Line 64: sum_trx cn_comp_plans.sum_trx_flag%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,

Line 66: attribute_category cn_comp_plans.attribute_category%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,

Line 67: attribute1 cn_comp_plans.attribute1%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,

Line 68: attribute2 cn_comp_plans.attribute2%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,

Line 69: attribute3 cn_comp_plans.attribute3%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,

Line 70: attribute4 cn_comp_plans.attribute4%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,

Line 71: attribute5 cn_comp_plans.attribute5%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,

Line 72: attribute6 cn_comp_plans.attribute6%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,

Line 73: attribute7 cn_comp_plans.attribute7%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,

Line 74: attribute8 cn_comp_plans.attribute8%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,

Line 75: attribute9 cn_comp_plans.attribute9%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,

Line 76: attribute10 cn_comp_plans.attribute10%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,

Line 77: attribute11 cn_comp_plans.attribute11%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

Line 78: attribute12 cn_comp_plans.attribute12%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: );

Line 79: attribute13 cn_comp_plans.attribute13%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: );
83:

Line 80: attribute14 cn_comp_plans.attribute14%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:
84: -- Global variable that represent missing values.

Line 81: attribute15 cn_comp_plans.attribute15%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.
85: G_MISS_COMP_PLAN_LIST_REC comp_plan_list_rec_type;