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_SRP_PAYGROUP_PUB dependencies on CN_SRP_PAY_GROUPS

Line 17: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,

13: ( pay_group_name cn_pay_groups.name%TYPE := cn_api.g_miss_char,
14: employee_type VARCHAR2(30) := cn_api.g_miss_char,
15: employee_number cn_salesreps.employee_number%TYPE := cn_api.g_miss_char,
16: source_id cn_salesreps.source_id%TYPE := null,
17: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
18: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
19: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,
21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,

Line 18: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,

14: employee_type VARCHAR2(30) := cn_api.g_miss_char,
15: employee_number cn_salesreps.employee_number%TYPE := cn_api.g_miss_char,
16: source_id cn_salesreps.source_id%TYPE := null,
17: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
18: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
19: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,
21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,
22: attribute_category cn_srp_pay_groups.attribute_category%TYPE

Line 19: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,

15: employee_number cn_salesreps.employee_number%TYPE := cn_api.g_miss_char,
16: source_id cn_salesreps.source_id%TYPE := null,
17: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
18: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
19: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,
21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,
22: attribute_category cn_srp_pay_groups.attribute_category%TYPE
23: := cn_api.g_miss_char,

Line 20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,

16: source_id cn_salesreps.source_id%TYPE := null,
17: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
18: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
19: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,
21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,
22: attribute_category cn_srp_pay_groups.attribute_category%TYPE
23: := cn_api.g_miss_char,
24: attribute1 cn_srp_pay_groups.attribute1%TYPE

Line 21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,

17: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
18: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
19: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,
21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,
22: attribute_category cn_srp_pay_groups.attribute_category%TYPE
23: := cn_api.g_miss_char,
24: attribute1 cn_srp_pay_groups.attribute1%TYPE
25: := cn_api.g_miss_char,

Line 22: attribute_category cn_srp_pay_groups.attribute_category%TYPE

18: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
19: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,
21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,
22: attribute_category cn_srp_pay_groups.attribute_category%TYPE
23: := cn_api.g_miss_char,
24: attribute1 cn_srp_pay_groups.attribute1%TYPE
25: := cn_api.g_miss_char,
26: attribute2 cn_srp_pay_groups.attribute2%TYPE

Line 24: attribute1 cn_srp_pay_groups.attribute1%TYPE

20: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE := cn_api.g_miss_id,
21: org_id cn_srp_pay_groups.org_id%TYPE := NULL,
22: attribute_category cn_srp_pay_groups.attribute_category%TYPE
23: := cn_api.g_miss_char,
24: attribute1 cn_srp_pay_groups.attribute1%TYPE
25: := cn_api.g_miss_char,
26: attribute2 cn_srp_pay_groups.attribute2%TYPE
27: := cn_api.g_miss_char,
28: attribute3 cn_srp_pay_groups.attribute3%TYPE

Line 26: attribute2 cn_srp_pay_groups.attribute2%TYPE

22: attribute_category cn_srp_pay_groups.attribute_category%TYPE
23: := cn_api.g_miss_char,
24: attribute1 cn_srp_pay_groups.attribute1%TYPE
25: := cn_api.g_miss_char,
26: attribute2 cn_srp_pay_groups.attribute2%TYPE
27: := cn_api.g_miss_char,
28: attribute3 cn_srp_pay_groups.attribute3%TYPE
29: := cn_api.g_miss_char,
30: attribute4 cn_srp_pay_groups.attribute4%TYPE

Line 28: attribute3 cn_srp_pay_groups.attribute3%TYPE

24: attribute1 cn_srp_pay_groups.attribute1%TYPE
25: := cn_api.g_miss_char,
26: attribute2 cn_srp_pay_groups.attribute2%TYPE
27: := cn_api.g_miss_char,
28: attribute3 cn_srp_pay_groups.attribute3%TYPE
29: := cn_api.g_miss_char,
30: attribute4 cn_srp_pay_groups.attribute4%TYPE
31: := cn_api.g_miss_char,
32: attribute5 cn_srp_pay_groups.attribute5%TYPE

Line 30: attribute4 cn_srp_pay_groups.attribute4%TYPE

26: attribute2 cn_srp_pay_groups.attribute2%TYPE
27: := cn_api.g_miss_char,
28: attribute3 cn_srp_pay_groups.attribute3%TYPE
29: := cn_api.g_miss_char,
30: attribute4 cn_srp_pay_groups.attribute4%TYPE
31: := cn_api.g_miss_char,
32: attribute5 cn_srp_pay_groups.attribute5%TYPE
33: := cn_api.g_miss_char,
34: attribute6 cn_srp_pay_groups.attribute6%TYPE

Line 32: attribute5 cn_srp_pay_groups.attribute5%TYPE

28: attribute3 cn_srp_pay_groups.attribute3%TYPE
29: := cn_api.g_miss_char,
30: attribute4 cn_srp_pay_groups.attribute4%TYPE
31: := cn_api.g_miss_char,
32: attribute5 cn_srp_pay_groups.attribute5%TYPE
33: := cn_api.g_miss_char,
34: attribute6 cn_srp_pay_groups.attribute6%TYPE
35: := cn_api.g_miss_char,
36: attribute7 cn_srp_pay_groups.attribute7%TYPE

Line 34: attribute6 cn_srp_pay_groups.attribute6%TYPE

30: attribute4 cn_srp_pay_groups.attribute4%TYPE
31: := cn_api.g_miss_char,
32: attribute5 cn_srp_pay_groups.attribute5%TYPE
33: := cn_api.g_miss_char,
34: attribute6 cn_srp_pay_groups.attribute6%TYPE
35: := cn_api.g_miss_char,
36: attribute7 cn_srp_pay_groups.attribute7%TYPE
37: := cn_api.g_miss_char,
38: attribute8 cn_srp_pay_groups.attribute8%TYPE

Line 36: attribute7 cn_srp_pay_groups.attribute7%TYPE

32: attribute5 cn_srp_pay_groups.attribute5%TYPE
33: := cn_api.g_miss_char,
34: attribute6 cn_srp_pay_groups.attribute6%TYPE
35: := cn_api.g_miss_char,
36: attribute7 cn_srp_pay_groups.attribute7%TYPE
37: := cn_api.g_miss_char,
38: attribute8 cn_srp_pay_groups.attribute8%TYPE
39: := cn_api.g_miss_char,
40: attribute9 cn_srp_pay_groups.attribute9%TYPE

Line 38: attribute8 cn_srp_pay_groups.attribute8%TYPE

34: attribute6 cn_srp_pay_groups.attribute6%TYPE
35: := cn_api.g_miss_char,
36: attribute7 cn_srp_pay_groups.attribute7%TYPE
37: := cn_api.g_miss_char,
38: attribute8 cn_srp_pay_groups.attribute8%TYPE
39: := cn_api.g_miss_char,
40: attribute9 cn_srp_pay_groups.attribute9%TYPE
41: := cn_api.g_miss_char,
42: attribute10 cn_srp_pay_groups.attribute10%TYPE

Line 40: attribute9 cn_srp_pay_groups.attribute9%TYPE

36: attribute7 cn_srp_pay_groups.attribute7%TYPE
37: := cn_api.g_miss_char,
38: attribute8 cn_srp_pay_groups.attribute8%TYPE
39: := cn_api.g_miss_char,
40: attribute9 cn_srp_pay_groups.attribute9%TYPE
41: := cn_api.g_miss_char,
42: attribute10 cn_srp_pay_groups.attribute10%TYPE
43: := cn_api.g_miss_char,
44: attribute11 cn_srp_pay_groups.attribute11%TYPE

Line 42: attribute10 cn_srp_pay_groups.attribute10%TYPE

38: attribute8 cn_srp_pay_groups.attribute8%TYPE
39: := cn_api.g_miss_char,
40: attribute9 cn_srp_pay_groups.attribute9%TYPE
41: := cn_api.g_miss_char,
42: attribute10 cn_srp_pay_groups.attribute10%TYPE
43: := cn_api.g_miss_char,
44: attribute11 cn_srp_pay_groups.attribute11%TYPE
45: := cn_api.g_miss_char,
46: attribute12 cn_srp_pay_groups.attribute12%TYPE

Line 44: attribute11 cn_srp_pay_groups.attribute11%TYPE

40: attribute9 cn_srp_pay_groups.attribute9%TYPE
41: := cn_api.g_miss_char,
42: attribute10 cn_srp_pay_groups.attribute10%TYPE
43: := cn_api.g_miss_char,
44: attribute11 cn_srp_pay_groups.attribute11%TYPE
45: := cn_api.g_miss_char,
46: attribute12 cn_srp_pay_groups.attribute12%TYPE
47: := cn_api.g_miss_char,
48: attribute13 cn_srp_pay_groups.attribute13%TYPE

Line 46: attribute12 cn_srp_pay_groups.attribute12%TYPE

42: attribute10 cn_srp_pay_groups.attribute10%TYPE
43: := cn_api.g_miss_char,
44: attribute11 cn_srp_pay_groups.attribute11%TYPE
45: := cn_api.g_miss_char,
46: attribute12 cn_srp_pay_groups.attribute12%TYPE
47: := cn_api.g_miss_char,
48: attribute13 cn_srp_pay_groups.attribute13%TYPE
49: := cn_api.g_miss_char,
50: attribute14 cn_srp_pay_groups.attribute14%TYPE

Line 48: attribute13 cn_srp_pay_groups.attribute13%TYPE

44: attribute11 cn_srp_pay_groups.attribute11%TYPE
45: := cn_api.g_miss_char,
46: attribute12 cn_srp_pay_groups.attribute12%TYPE
47: := cn_api.g_miss_char,
48: attribute13 cn_srp_pay_groups.attribute13%TYPE
49: := cn_api.g_miss_char,
50: attribute14 cn_srp_pay_groups.attribute14%TYPE
51: := cn_api.g_miss_char,
52: attribute15 cn_srp_pay_groups.attribute15%TYPE

Line 50: attribute14 cn_srp_pay_groups.attribute14%TYPE

46: attribute12 cn_srp_pay_groups.attribute12%TYPE
47: := cn_api.g_miss_char,
48: attribute13 cn_srp_pay_groups.attribute13%TYPE
49: := cn_api.g_miss_char,
50: attribute14 cn_srp_pay_groups.attribute14%TYPE
51: := cn_api.g_miss_char,
52: attribute15 cn_srp_pay_groups.attribute15%TYPE
53: := cn_api.g_miss_char);
54: -- Start of comments

Line 52: attribute15 cn_srp_pay_groups.attribute15%TYPE

48: attribute13 cn_srp_pay_groups.attribute13%TYPE
49: := cn_api.g_miss_char,
50: attribute14 cn_srp_pay_groups.attribute14%TYPE
51: := cn_api.g_miss_char,
52: attribute15 cn_srp_pay_groups.attribute15%TYPE
53: := cn_api.g_miss_char);
54: -- Start of comments
55: -- API name : Assign_Salesreps
56: -- Type : Public.

Line 90: * This procedure is used to create entry into cn_srp_pay_groups. The procedure validates the input for a pay group and creates one if all validations are passed.

86: -- - Checks that the assignments do not overlap
87: --
88: -- End of comments
89: /*#
90: * This procedure is used to create entry into cn_srp_pay_groups. The procedure validates the input for a pay group and creates one if all validations are passed.
91: * @param p_api_version API Version
92: * @param p_init_msg_list Initialize Message List
93: * @param p_commit Commit after assignment created
94: * @param p_validation_level Validation Level