[Home] [Help]
PACKAGE: APPS.CN_SRP_PAYGROUP_PVT
Source
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,
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
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,
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
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);
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 ,
50 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
51 x_return_status OUT NOCOPY VARCHAR2 ,
52 x_loading_status OUT NOCOPY VARCHAR2 ,
53 x_msg_count OUT NOCOPY NUMBER ,
54 x_msg_data OUT NOCOPY VARCHAR2 ,
55 p_paygroup_assign_rec IN OUT NOCOPY PayGroup_assign_rec
56 );
57
58
59 PROCEDURE Update_Srp_Pay_Group
60 ( p_api_version IN NUMBER ,
61 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
62 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
63 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64 x_return_status OUT NOCOPY VARCHAR2 ,
65 x_loading_status OUT NOCOPY VARCHAR2 ,
66 x_msg_count OUT NOCOPY NUMBER ,
67 x_msg_data OUT NOCOPY VARCHAR2 ,
68 p_paygroup_assign_rec IN OUT NOCOPY PayGroup_assign_rec
69 );
70
71 PROCEDURE Delete_Srp_Pay_Group
72 ( p_api_version IN NUMBER ,
73 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
74 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
75 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76 x_return_status OUT NOCOPY VARCHAR2 ,
77 x_loading_status OUT NOCOPY VARCHAR2 ,
78 x_msg_count OUT NOCOPY NUMBER ,
79 x_msg_data OUT NOCOPY VARCHAR2 ,
80 p_paygroup_assign_rec IN PayGroup_assign_rec
81 );
82
83 PROCEDURE valid_delete_srp_pay_group
84 ( p_paygroup_assign_rec IN paygroup_assign_rec ,
85 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
86 x_loading_status OUT NOCOPY VARCHAR2 ,
87 x_return_status OUT NOCOPY VARCHAR2 ,
88 x_msg_count OUT NOCOPY NUMBER ,
89 x_msg_data OUT NOCOPY VARCHAR2
90 );
91
92 -- Start of comments
93 -- API name : Delete_Mass_Asgn_Srp_Pay_Groups
94 -- Type : Private
95 -- Pre-reqs : None.
96 -- Usage : Used to delete a payment plan assignment to an salesrep
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
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
110 -- x_msg_data OUT VARCHAR2(2000)
111 -- x_loading_status OUT VARCHAR2(30)
112 -- Version : Current version 1.0
113 -- Initial version 1.0
114
115 PROCEDURE Delete_Mass_Asgn_Srp_Pay
116 (p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_srp_role_id IN NUMBER,
124 p_role_pay_group_id IN NUMBER,
125 x_loading_status OUT NOCOPY VARCHAR2
126 );
127
128
129 END CN_Srp_PayGroup_PVT ;