DBA Data[Home] [Help]

APPS.CN_SRP_PAYGROUP_PVT dependencies on CN_API

Line 5: ( srp_pay_group_id cn_srp_pay_groups.srp_pay_group_id%TYPE := cn_api.g_miss_id,

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,

Line 6: pay_group_id cn_srp_pay_groups.pay_group_id%TYPE := cn_api.g_miss_id,

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,

Line 7: salesrep_id cn_srp_pay_groups.salesrep_id%TYPE := cn_api.g_miss_id,

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,

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

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,

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

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,

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

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

Line 11: role_pay_group_id cn_srp_pay_groups.role_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
15: := cn_api.g_miss_char,

Line 12: org_id cn_srp_pay_groups.org_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,
16: attribute1 cn_srp_pay_groups.attribute1%TYPE

Line 15: := 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
19: := cn_api.g_miss_char,

Line 17: := 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,

Line 19: := 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,

Line 21: := 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,

Line 23: := 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,

Line 25: := 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,

Line 27: := 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,

Line 29: := 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,

Line 31: := 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,

Line 33: := 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,

Line 35: := 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,

Line 37: := 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,

Line 39: := 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,

Line 41: := 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);

Line 43: := 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 ,

Line 45: := cn_api.g_miss_char);

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 ,

Line 101: -- Default = CN_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

Line 103: -- Default = CN_API.G_FALSE

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

Line 105: -- Default = CN_API.G_VALID_LEVEL_FULL

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