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_PUB 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_PUB AUTHID CURRENT_USER as
2: -- $Header: cnppgrps.pls 120.8 2005/11/02 22:50:00 sjustina ship $ --+
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 20: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,

16: l_status VARCHAR2(1);
17: /**End of MOAC Org Validation change */
18:
19: TYPE PayGroup_rec_type IS RECORD
20: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
21: name cn_pay_groups.name%TYPE,
22: period_set_name cn_pay_groups.period_set_name%TYPE,
23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,

Line 21: name cn_pay_groups.name%TYPE,

17: /**End of MOAC Org Validation change */
18:
19: TYPE PayGroup_rec_type IS RECORD
20: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
21: name cn_pay_groups.name%TYPE,
22: period_set_name cn_pay_groups.period_set_name%TYPE,
23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,

Line 22: period_set_name cn_pay_groups.period_set_name%TYPE,

18:
19: TYPE PayGroup_rec_type IS RECORD
20: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
21: name cn_pay_groups.name%TYPE,
22: period_set_name cn_pay_groups.period_set_name%TYPE,
23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,

Line 23: period_type cn_pay_groups.period_type%TYPE,

19: TYPE PayGroup_rec_type IS RECORD
20: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
21: name cn_pay_groups.name%TYPE,
22: period_set_name cn_pay_groups.period_set_name%TYPE,
23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,

Line 24: start_date cn_pay_groups.start_date%TYPE,

20: ( pay_group_id cn_pay_groups.pay_group_id%TYPE := CN_API.G_MISS_ID,
21: name cn_pay_groups.name%TYPE,
22: period_set_name cn_pay_groups.period_set_name%TYPE,
23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,

Line 25: end_date cn_pay_groups.end_date%TYPE,

21: name cn_pay_groups.name%TYPE,
22: period_set_name cn_pay_groups.period_set_name%TYPE,
23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,

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

22: period_set_name cn_pay_groups.period_set_name%TYPE,
23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,

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

23: period_type cn_pay_groups.period_type%TYPE,
24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,

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

24: start_date cn_pay_groups.start_date%TYPE,
25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,

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

25: end_date cn_pay_groups.end_date%TYPE,
26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,

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

26: pay_group_description cn_pay_groups.pay_group_description%TYPE := NULL,
27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,

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

27: attribute_category cn_pay_groups.attribute_category%TYPE := NULL,
28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,

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

28: attribute1 cn_pay_groups.attribute1%TYPE := NULL,
29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,

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

29: attribute2 cn_pay_groups.attribute2%TYPE := NULL,
30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,

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

30: attribute3 cn_pay_groups.attribute3%TYPE := NULL,
31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,

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

31: attribute4 cn_pay_groups.attribute4%TYPE := NULL,
32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,

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

32: attribute5 cn_pay_groups.attribute5%TYPE := NULL,
33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,

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

33: attribute6 cn_pay_groups.attribute6%TYPE := NULL,
34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,

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

34: attribute7 cn_pay_groups.attribute7%TYPE := NULL,
35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
42: attribute15 cn_pay_groups.attribute15%TYPE := NULL,

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

35: attribute8 cn_pay_groups.attribute8%TYPE := NULL,
36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
42: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
43: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,

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

36: attribute9 cn_pay_groups.attribute9%TYPE := NULL,
37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
42: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
43: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
44: org_id cn_pay_groups.org_id%TYPE := NULL

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

37: attribute10 cn_pay_groups.attribute10%TYPE := NULL,
38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
42: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
43: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
44: org_id cn_pay_groups.org_id%TYPE := NULL
45: );

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

38: attribute11 cn_pay_groups.attribute11%TYPE := NULL,
39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
42: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
43: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
44: org_id cn_pay_groups.org_id%TYPE := NULL
45: );
46:

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

39: attribute12 cn_pay_groups.attribute12%TYPE := NULL,
40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
42: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
43: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
44: org_id cn_pay_groups.org_id%TYPE := NULL
45: );
46:
47:

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

40: attribute13 cn_pay_groups.attribute13%TYPE := NULL,
41: attribute14 cn_pay_groups.attribute14%TYPE := NULL,
42: attribute15 cn_pay_groups.attribute15%TYPE := NULL,
43: object_version_number cn_pay_groups.object_version_number%TYPE := NULL,
44: org_id cn_pay_groups.org_id%TYPE := NULL
45: );
46:
47:
48: TYPE PayGroup_tbl_type IS