DBA Data[Home] [Help]

APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_ROLE_PAY_GROUPS

Line 1: PACKAGE CN_ROLE_PAY_GROUPS_PVT AUTHID CURRENT_USER AS

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

Line 11: role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE := cn_api.G_MISS_ID,

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 ,

Line 14: start_date cn_role_pay_groups.start_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,

Line 15: end_date cn_role_pay_groups.end_date%TYPE ,

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,

Line 16: attribute_category cn_role_pay_groups.attribute_category%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,

Line 17: attribute1 cn_role_pay_groups.attribute1%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,

Line 18: attribute2 cn_role_pay_groups.attribute2%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,

Line 19: attribute3 cn_role_pay_groups.attribute3%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,

Line 20: attribute4 cn_role_pay_groups.attribute4%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,

Line 21: attribute5 cn_role_pay_groups.attribute5%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,

Line 22: attribute6 cn_role_pay_groups.attribute6%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,

Line 23: attribute7 cn_role_pay_groups.attribute7%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,

Line 24: attribute8 cn_role_pay_groups.attribute8%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,

Line 25: attribute9 cn_role_pay_groups.attribute9%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,

Line 26: attribute10 cn_role_pay_groups.attribute10%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,

Line 27: attribute11 cn_role_pay_groups.attribute11%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,

Line 28: attribute12 cn_role_pay_groups.attribute12%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,

Line 29: attribute13 cn_role_pay_groups.attribute13%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

Line 30: attribute14 cn_role_pay_groups.attribute14%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: );

Line 31: attribute15 cn_role_pay_groups.attribute15%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: );
35:

Line 32: org_id cn_role_pay_groups.org_Id%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:
36: --

Line 33: object_version_number cn_role_pay_groups.object_version_number%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: --
37: -- User defined Record Table Type

Line 149: END CN_ROLE_PAY_GROUPS_PVT;

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;