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,
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
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,
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
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,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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.
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