1: PACKAGE CN_ROLE_PAY_GROUPS_PVT AUTHID CURRENT_USER AS
2: /* $Header: cnvrpgps.pls 120.3 2005/08/25 03:17:44 sjustina noship $ */
3:
4: --
5: -- User defined Record Type
7: -- Note: form bug 725654 for G_MISS
8:
9: TYPE role_pay_groups_rec_type IS RECORD
10: (
11: role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE := cn_api.G_MISS_ID,
12: role_name cn_roles.name%TYPE ,
13: pay_groups_name cn_pay_groups.name%TYPE ,
14: start_date cn_role_pay_groups.start_date%TYPE ,
15: end_date cn_role_pay_groups.end_date%TYPE ,
10: (
11: role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE := cn_api.G_MISS_ID,
12: role_name cn_roles.name%TYPE ,
13: pay_groups_name cn_pay_groups.name%TYPE ,
14: start_date cn_role_pay_groups.start_date%TYPE ,
15: end_date cn_role_pay_groups.end_date%TYPE ,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
11: role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE := cn_api.G_MISS_ID,
12: role_name cn_roles.name%TYPE ,
13: pay_groups_name cn_pay_groups.name%TYPE ,
14: start_date cn_role_pay_groups.start_date%TYPE ,
15: end_date cn_role_pay_groups.end_date%TYPE ,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
12: role_name cn_roles.name%TYPE ,
13: pay_groups_name cn_pay_groups.name%TYPE ,
14: start_date cn_role_pay_groups.start_date%TYPE ,
15: end_date cn_role_pay_groups.end_date%TYPE ,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
13: pay_groups_name cn_pay_groups.name%TYPE ,
14: start_date cn_role_pay_groups.start_date%TYPE ,
15: end_date cn_role_pay_groups.end_date%TYPE ,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
14: start_date cn_role_pay_groups.start_date%TYPE ,
15: end_date cn_role_pay_groups.end_date%TYPE ,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
15: end_date cn_role_pay_groups.end_date%TYPE ,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
16: attribute_category cn_role_pay_groups.attribute_category%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
17: attribute1 cn_role_pay_groups.attribute1%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
18: attribute2 cn_role_pay_groups.attribute2%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
19: attribute3 cn_role_pay_groups.attribute3%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
20: attribute4 cn_role_pay_groups.attribute4%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
21: attribute5 cn_role_pay_groups.attribute5%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
22: attribute6 cn_role_pay_groups.attribute6%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
23: attribute7 cn_role_pay_groups.attribute7%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
31: attribute15 cn_role_pay_groups.attribute15%TYPE := NULL,
24: attribute8 cn_role_pay_groups.attribute8%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
31: attribute15 cn_role_pay_groups.attribute15%TYPE := NULL,
32: org_id cn_role_pay_groups.org_Id%TYPE := NULL,
25: attribute9 cn_role_pay_groups.attribute9%TYPE := NULL,
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
31: attribute15 cn_role_pay_groups.attribute15%TYPE := NULL,
32: org_id cn_role_pay_groups.org_Id%TYPE := NULL,
33: object_version_number cn_role_pay_groups.object_version_number%TYPE := NULL
26: attribute10 cn_role_pay_groups.attribute10%TYPE := NULL,
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
31: attribute15 cn_role_pay_groups.attribute15%TYPE := NULL,
32: org_id cn_role_pay_groups.org_Id%TYPE := NULL,
33: object_version_number cn_role_pay_groups.object_version_number%TYPE := NULL
34: );
27: attribute11 cn_role_pay_groups.attribute11%TYPE := NULL,
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
31: attribute15 cn_role_pay_groups.attribute15%TYPE := NULL,
32: org_id cn_role_pay_groups.org_Id%TYPE := NULL,
33: object_version_number cn_role_pay_groups.object_version_number%TYPE := NULL
34: );
35:
28: attribute12 cn_role_pay_groups.attribute12%TYPE := NULL,
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
31: attribute15 cn_role_pay_groups.attribute15%TYPE := NULL,
32: org_id cn_role_pay_groups.org_Id%TYPE := NULL,
33: object_version_number cn_role_pay_groups.object_version_number%TYPE := NULL
34: );
35:
36: --
29: attribute13 cn_role_pay_groups.attribute13%TYPE := NULL,
30: attribute14 cn_role_pay_groups.attribute14%TYPE := NULL,
31: attribute15 cn_role_pay_groups.attribute15%TYPE := NULL,
32: org_id cn_role_pay_groups.org_Id%TYPE := NULL,
33: object_version_number cn_role_pay_groups.object_version_number%TYPE := NULL
34: );
35:
36: --
37: -- User defined Record Table Type
145: x_msg_data OUT NOCOPY VARCHAR2 ,
146: p_role_pay_groups_rec IN OUT NOCOPY role_pay_groups_rec_type
147: );
148:
149: END CN_ROLE_PAY_GROUPS_PVT;