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
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
19: := cn_api.g_miss_char,
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
21: := cn_api.g_miss_char,
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
23: := cn_api.g_miss_char,
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
25: := cn_api.g_miss_char,
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
27: := cn_api.g_miss_char,
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
29: := cn_api.g_miss_char,
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
31: := cn_api.g_miss_char,
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
33: := cn_api.g_miss_char,
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
35: := cn_api.g_miss_char,
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
37: := cn_api.g_miss_char,
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
39: := cn_api.g_miss_char,
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
41: := cn_api.g_miss_char,
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
43: := cn_api.g_miss_char,
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
45: := cn_api.g_miss_char);
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
47: ( p_api_version IN NUMBER ,
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 ,
49: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
97: -- Desc : Procedure to delete a payment plan assignment to salesrep
98: -- Parameters :
99: -- IN : p_api_version IN NUMBER Require
100: -- p_init_msg_list IN VARCHAR2 Optional
101: -- Default = CN_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = CN_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = CN_API.G_VALID_LEVEL_FULL
99: -- IN : p_api_version IN NUMBER Require
100: -- p_init_msg_list IN VARCHAR2 Optional
101: -- Default = CN_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = CN_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = CN_API.G_VALID_LEVEL_FULL
106: -- p_srp_role_id IN NUMBER
107: -- p_role_pmt_plan_id IN NUMBER
101: -- Default = CN_API.G_FALSE
102: -- p_commit IN VARCHAR2 Optional
103: -- Default = CN_API.G_FALSE
104: -- p_validation_level IN NUMBER Optional
105: -- Default = CN_API.G_VALID_LEVEL_FULL
106: -- p_srp_role_id IN NUMBER
107: -- p_role_pmt_plan_id IN NUMBER
108: -- OUT : x_return_status OUT VARCHAR2(1)
109: -- x_msg_count OUT NUMBER