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_PAYGROUP_PVT dependencies on CN_PAY_GROUPS

Line 5: * They are also used to create entry into cn_pay_groups and to update salesrep pay group assignment.

1: PACKAGE CN_PAYGROUP_PVT AUTHID CURRENT_USER as
2: -- $Header: cnvpgrps.pls 120.5 2005/07/26 04:31:07 sjustina noship $ --+
3: /*#
4: * The procedures in this package can be used to get pay group information, validate the input, create pay groups, update pay groups, and delete pay groups.
5: * They are also used to create entry into cn_pay_groups and to update salesrep pay group assignment.
6: * @rep:scope public
7: * @rep:product CN
8: * @rep:displayname Pay Group
9: * @rep:lifecycle active

Line 15: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,

11: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
12: */
13:
14: TYPE PayGroup_rec_type IS RECORD
15: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
16: name cn_pay_groups.name%TYPE,
17: period_set_name cn_pay_groups.period_set_name%TYPE,
18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,

Line 16: name cn_pay_groups.name%TYPE,

12: */
13:
14: TYPE PayGroup_rec_type IS RECORD
15: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
16: name cn_pay_groups.name%TYPE,
17: period_set_name cn_pay_groups.period_set_name%TYPE,
18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,

Line 17: period_set_name cn_pay_groups.period_set_name%TYPE,

13:
14: TYPE PayGroup_rec_type IS RECORD
15: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
16: name cn_pay_groups.name%TYPE,
17: period_set_name cn_pay_groups.period_set_name%TYPE,
18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,

Line 18: period_type cn_pay_groups.period_type%TYPE,

14: TYPE PayGroup_rec_type IS RECORD
15: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
16: name cn_pay_groups.name%TYPE,
17: period_set_name cn_pay_groups.period_set_name%TYPE,
18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,

Line 19: start_date cn_pay_groups.start_date%TYPE,

15: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
16: name cn_pay_groups.name%TYPE,
17: period_set_name cn_pay_groups.period_set_name%TYPE,
18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,

Line 20: end_date cn_pay_groups.end_date%TYPE,

16: name cn_pay_groups.name%TYPE,
17: period_set_name cn_pay_groups.period_set_name%TYPE,
18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,

Line 21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,

17: period_set_name cn_pay_groups.period_set_name%TYPE,
18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,

Line 22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,

18: period_type cn_pay_groups.period_type%TYPE,
19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,

Line 23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,

19: start_date cn_pay_groups.start_date%TYPE,
20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,

Line 24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,

20: end_date cn_pay_groups.end_date%TYPE,
21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,

Line 25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,

21: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,

Line 26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,

22: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,

Line 27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,

23: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,

Line 28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,

24: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,

Line 29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,

25: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,

Line 30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,

26: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,

Line 31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,

27: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,

Line 32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,

28: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,

Line 33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,

29: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,

Line 34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,

30: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
38: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,

Line 35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,

31: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
38: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
39: org_id cn_pay_groups.org_id%TYPE := NULL

Line 36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,

32: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
38: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
39: org_id cn_pay_groups.org_id%TYPE := NULL
40: );

Line 37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,

33: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
38: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
39: org_id cn_pay_groups.org_id%TYPE := NULL
40: );
41:

Line 38: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,

34: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
38: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
39: org_id cn_pay_groups.org_id%TYPE := NULL
40: );
41:
42:

Line 39: org_id cn_pay_groups.org_id%TYPE := NULL

35: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
36: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
37: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
38: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
39: org_id cn_pay_groups.org_id%TYPE := NULL
40: );
41:
42:
43: TYPE PayGroup_tbl_type IS