1: PACKAGE CN_Srp_PayGroup_PVT as
2: -- $Header: cnvsdpgs.pls 120.1 2005/08/25 02:16:40 sjustina noship $
3:
4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
2: -- $Header: cnvsdpgs.pls 120.1 2005/08/25 02:16:40 sjustina noship $
3:
4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
3:
4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
4: TYPE PayGroup_assign_rec IS RECORD
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
8: assignment_start_date cn_srp_pay_groups.start_date%TYPE := cn_api.g_miss_date,
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
9: assignment_end_date cn_srp_pay_groups.end_date%TYPE := cn_api.g_miss_date,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
10: lock_flag cn_srp_pay_groups.lock_flag%TYPE := cn_api.g_miss_char,
11: role_pay_group_id cn_srp_pay_groups.role_pay_group_id%TYPE:= cn_api.g_miss_id,
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
12: org_id cn_srp_pay_groups.org_id%TYPE := cn_api.g_miss_id,
13: object_version_number cn_srp_pay_groups.object_version_number%TYPE,
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
14: attribute_category cn_srp_pay_groups.attribute_category%TYPE
15: := cn_api.g_miss_char,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
16: attribute1 cn_srp_pay_groups.attribute1%TYPE
17: := cn_api.g_miss_char,
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
18: attribute2 cn_srp_pay_groups.attribute2%TYPE
19: := cn_api.g_miss_char,
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
20: attribute3 cn_srp_pay_groups.attribute3%TYPE
21: := cn_api.g_miss_char,
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
22: attribute4 cn_srp_pay_groups.attribute4%TYPE
23: := cn_api.g_miss_char,
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
24: attribute5 cn_srp_pay_groups.attribute5%TYPE
25: := cn_api.g_miss_char,
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
26: attribute6 cn_srp_pay_groups.attribute6%TYPE
27: := cn_api.g_miss_char,
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
28: attribute7 cn_srp_pay_groups.attribute7%TYPE
29: := cn_api.g_miss_char,
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
30: attribute8 cn_srp_pay_groups.attribute8%TYPE
31: := cn_api.g_miss_char,
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
32: attribute9 cn_srp_pay_groups.attribute9%TYPE
33: := cn_api.g_miss_char,
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
34: attribute10 cn_srp_pay_groups.attribute10%TYPE
35: := cn_api.g_miss_char,
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE
36: attribute11 cn_srp_pay_groups.attribute11%TYPE
37: := cn_api.g_miss_char,
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE
43: := cn_api.g_miss_char,
44: attribute15 cn_srp_pay_groups.attribute15%TYPE
38: attribute12 cn_srp_pay_groups.attribute12%TYPE
39: := cn_api.g_miss_char,
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE
43: := cn_api.g_miss_char,
44: attribute15 cn_srp_pay_groups.attribute15%TYPE
45: := cn_api.g_miss_char);
46: PROCEDURE Create_Srp_Pay_Group
40: attribute13 cn_srp_pay_groups.attribute13%TYPE
41: := cn_api.g_miss_char,
42: attribute14 cn_srp_pay_groups.attribute14%TYPE
43: := cn_api.g_miss_char,
44: attribute15 cn_srp_pay_groups.attribute15%TYPE
45: := cn_api.g_miss_char);
46: PROCEDURE Create_Srp_Pay_Group
47: ( p_api_version IN NUMBER ,
48: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,