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_API

Line 13: ( pay_group_name cn_pay_groups.name%TYPE := cn_api.g_miss_char,

9: * @rep:compatibility S
10: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
11: */
12: TYPE PayGroup_assign_rec IS RECORD
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,

Line 14: employee_type VARCHAR2(30) := cn_api.g_miss_char,

10: * @rep:category BUSINESS_ENTITY CN_COMP_PLANS
11: */
12: TYPE PayGroup_assign_rec IS RECORD
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,

Line 15: employee_number cn_salesreps.employee_number%TYPE := cn_api.g_miss_char,

11: */
12: TYPE PayGroup_assign_rec IS RECORD
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,

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 23: := cn_api.g_miss_char,

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
27: := cn_api.g_miss_char,

Line 25: := cn_api.g_miss_char,

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
29: := cn_api.g_miss_char,

Line 27: := cn_api.g_miss_char,

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
31: := cn_api.g_miss_char,

Line 29: := cn_api.g_miss_char,

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
33: := cn_api.g_miss_char,

Line 31: := cn_api.g_miss_char,

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
35: := cn_api.g_miss_char,

Line 33: := cn_api.g_miss_char,

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
37: := cn_api.g_miss_char,

Line 35: := cn_api.g_miss_char,

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
39: := cn_api.g_miss_char,

Line 37: := cn_api.g_miss_char,

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
41: := cn_api.g_miss_char,

Line 39: := cn_api.g_miss_char,

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
43: := cn_api.g_miss_char,

Line 41: := cn_api.g_miss_char,

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
45: := cn_api.g_miss_char,

Line 43: := cn_api.g_miss_char,

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
47: := cn_api.g_miss_char,

Line 45: := cn_api.g_miss_char,

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
49: := cn_api.g_miss_char,

Line 47: := cn_api.g_miss_char,

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
51: := cn_api.g_miss_char,

Line 49: := cn_api.g_miss_char,

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
53: := cn_api.g_miss_char);

Line 51: := cn_api.g_miss_char,

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
55: -- API name : Assign_Salesreps

Line 53: := cn_api.g_miss_char);

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.
57: -- Pre-reqs : None.

Line 107: p_init_msg_list IN VARCHAR2 := cn_api.g_false,

103: * @rep:displayname Assign pay group to salesperson
104: */
105: PROCEDURE Assign_salesreps
106: ( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
108: p_commit IN VARCHAR2 := cn_api.g_false,
109: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,

Line 108: p_commit IN VARCHAR2 := cn_api.g_false,

104: */
105: PROCEDURE Assign_salesreps
106: ( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
108: p_commit IN VARCHAR2 := cn_api.g_false,
109: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,

Line 109: p_validation_level IN NUMBER := cn_api.g_valid_level_full,

105: PROCEDURE Assign_salesreps
106: ( p_api_version IN NUMBER,
107: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
108: p_commit IN VARCHAR2 := cn_api.g_false,
109: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
110: x_return_status OUT NOCOPY VARCHAR2,
111: x_msg_count OUT NOCOPY NUMBER,
112: x_msg_data OUT NOCOPY VARCHAR2,
113: p_paygroup_assign_rec IN PayGroup_assign_rec,

Line 128: -- Default = CN_API.G_FALSE

124: -- Desc : Procedure to create a new mass payment plan assignment to salesrep
125: -- Parameters :
126: -- IN : p_api_version IN NUMBER Require
127: -- p_init_msg_list IN VARCHAR2 Optional
128: -- Default = CN_API.G_FALSE
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = CN_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional
132: -- Default = CN_API.G_VALID_LEVEL_FULL

Line 130: -- Default = CN_API.G_FALSE

126: -- IN : p_api_version IN NUMBER Require
127: -- p_init_msg_list IN VARCHAR2 Optional
128: -- Default = CN_API.G_FALSE
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = CN_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional
132: -- Default = CN_API.G_VALID_LEVEL_FULL
133: -- p_role_pay_pgroup_id IN NUMBER
134: -- p_srp_role_id IN NUMBER

Line 132: -- Default = CN_API.G_VALID_LEVEL_FULL

128: -- Default = CN_API.G_FALSE
129: -- p_commit IN VARCHAR2 Optional
130: -- Default = CN_API.G_FALSE
131: -- p_validation_level IN NUMBER Optional
132: -- Default = CN_API.G_VALID_LEVEL_FULL
133: -- p_role_pay_pgroup_id IN NUMBER
134: -- p_srp_role_id IN NUMBER
135: --
136: -- OUT : x_return_status OUT VARCHAR2(1)

Line 236: p_init_msg_list IN VARCHAR2 := cn_api.g_false,

232: * @rep:displayname Update pay group assignments
233: */
234: PROCEDURE Update_srp_assignment
235: ( p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
237: p_commit IN VARCHAR2 := cn_api.g_false,
238: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,

Line 237: p_commit IN VARCHAR2 := cn_api.g_false,

233: */
234: PROCEDURE Update_srp_assignment
235: ( p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
237: p_commit IN VARCHAR2 := cn_api.g_false,
238: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,

Line 238: p_validation_level IN NUMBER := cn_api.g_valid_level_full,

234: PROCEDURE Update_srp_assignment
235: ( p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := cn_api.g_false,
237: p_commit IN VARCHAR2 := cn_api.g_false,
238: p_validation_level IN NUMBER := cn_api.g_valid_level_full,
239: x_return_status OUT NOCOPY VARCHAR2,
240: x_msg_count OUT NOCOPY NUMBER,
241: x_msg_data OUT NOCOPY VARCHAR2,
242: p_old_paygroup_assign_rec IN PayGroup_assign_rec,