1 PACKAGE CN_SRP_PMT_PLANS_PVT AUTHID CURRENT_USER AS
2 /* $Header: cnvsppas.pls 120.4 2005/07/25 04:32:29 raramasa noship $ */
3
4 TYPE pmt_plan_assign_rec IS RECORD
5 (srp_pmt_plan_id cn_srp_pmt_plans.srp_pmt_plan_id%TYPE,
6 salesrep_id cn_srp_pmt_plans.salesrep_id%TYPE,
7 org_id cn_srp_pmt_plans.org_id%TYPE,
8 pmt_plan_id cn_srp_pmt_plans.pmt_plan_id%TYPE,
9 start_date cn_srp_pmt_plans.start_date%TYPE,
10 end_date cn_srp_pmt_plans.end_date%TYPE,
11 minimum_amount cn_srp_pmt_plans.minimum_amount%TYPE,
12 maximum_amount cn_srp_pmt_plans.maximum_amount%TYPE,
13 srp_role_id cn_srp_pmt_plans.srp_role_id%TYPE,
14 role_pmt_plan_id cn_srp_pmt_plans.role_pmt_plan_id%TYPE,
15 lock_flag cn_srp_pmt_plans.lock_flag%TYPE,
16 object_version_number cn_srp_pmt_plans.object_version_number%TYPE);
17
18 TYPE payrun_tbl IS TABLE OF cn_payruns.name%TYPE;
19
20 -- --------------------------------------------------------------------------*
21 -- Procedure: Create_Srp_Pmt_Plan
22 -- --------------------------------------------------------------------------*
23 PROCEDURE Create_Srp_Pmt_Plan
24 ( p_api_version IN NUMBER ,
25 p_init_msg_list IN VARCHAR2,
26 p_commit IN VARCHAR2,
27 p_validation_level IN NUMBER,
28 x_return_status OUT NOCOPY VARCHAR2 ,
29 x_loading_status OUT NOCOPY VARCHAR2 ,
30 x_msg_count OUT NOCOPY NUMBER ,
31 x_msg_data OUT NOCOPY VARCHAR2 ,
32 p_pmt_plan_assign_rec IN OUT NOCOPY pmt_plan_assign_rec);
33
34 -- --------------------------------------------------------------------------*
35 -- Procedure: Update_Srp_Pmt_Plan
36 -- --------------------------------------------------------------------------*
37 PROCEDURE Update_Srp_Pmt_Plan
38 ( p_api_version IN NUMBER ,
39 p_init_msg_list IN VARCHAR2,
40 p_commit IN VARCHAR2,
41 p_validation_level IN NUMBER,
42 x_return_status OUT NOCOPY VARCHAR2 ,
43 x_loading_status OUT NOCOPY VARCHAR2 ,
44 x_msg_count OUT NOCOPY NUMBER ,
45 x_msg_data OUT NOCOPY VARCHAR2 ,
46 p_pmt_plan_assign_rec IN OUT NOCOPY pmt_plan_assign_rec );
47
48 -- --------------------------------------------------------------------------*
49 -- Procedure: Valid_Delete_Srp_Pmt_Plan
50 -- --------------------------------------------------------------------------*
51 PROCEDURE valid_delete_srp_pmt_plan
52 ( p_srp_pmt_plan_id IN NUMBER,
53 p_init_msg_list IN VARCHAR2,
54 x_loading_status OUT NOCOPY VARCHAR2 ,
55 x_return_status OUT NOCOPY VARCHAR2 ,
56 x_msg_count OUT NOCOPY NUMBER ,
57 x_msg_data OUT NOCOPY VARCHAR2);
58
59 -- --------------------------------------------------------------------------*
60 -- Procedure: Delete_Srp_Pmt_Plan
61 -- --------------------------------------------------------------------------*
62 PROCEDURE Delete_Srp_Pmt_Plan
63 ( p_api_version IN NUMBER ,
64 p_init_msg_list IN VARCHAR2,
65 p_commit IN VARCHAR2,
66 p_validation_level IN NUMBER,
67 x_return_status OUT NOCOPY VARCHAR2 ,
68 x_loading_status OUT NOCOPY VARCHAR2 ,
69 x_msg_count OUT NOCOPY NUMBER ,
70 x_msg_data OUT NOCOPY VARCHAR2 ,
71 p_srp_pmt_plan_id IN NUMBER);
72
73 -- --------------------------------------------------------------------------*
74 -- Procedure: check_payruns
75 -- --------------------------------------------------------------------------*
76 PROCEDURE check_payruns
77 (p_operation IN VARCHAR2,
78 p_srp_pmt_plan_id IN NUMBER,
79 p_salesrep_id IN NUMBER,
80 p_start_date IN DATE,
81 p_end_date IN DATE,
82 x_payrun_tbl OUT NOCOPY payrun_tbl
83 );
84
85 -- Start of comments
86 -- API name : Create_Mass_Asgn_Srp_Pmt_Plan
87 -- Type : Private
88 -- Pre-reqs : None.
89 -- Usage : Used to create a new mass payment plan assignment to an salesrep
90 -- Desc : Procedure to create a new mass payment plan assignment to salesrep
91 -- Parameters :
92 -- IN : p_api_version IN NUMBER Require
93 -- p_init_msg_list IN VARCHAR2 Optional
94 -- Default = CN_API.G_FALSE
95 -- p_commit IN VARCHAR2 Optional
96 -- Default = CN_API.G_FALSE
97 -- p_validation_level IN NUMBER Optional
98 -- Default = CN_API.G_VALID_LEVEL_FULL
99 -- p_role_pmt_plan_id IN NUMBER
100 -- p_srp_role_id IN NUMBER
101 --
102 -- OUT : x_return_status OUT VARCHAR2(1)
103 -- x_msg_count OUT NUMBER
104 -- x_msg_data OUT VARCHAR2(2000)
105 -- x_loading_status OUT VARCHAR2(30)
106 -- Version : Current version 1.0
107 -- Initial version 1.0
108 PROCEDURE Create_Mass_Asgn_Srp_Pmt_Plan
109 (
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
112 p_commit IN VARCHAR2 := FND_API.G_FALSE,
113 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
114 x_return_status OUT NOCOPY VARCHAR2,
115 x_msg_count OUT NOCOPY NUMBER,
116 x_msg_data OUT NOCOPY VARCHAR2,
117 p_srp_role_id IN NUMBER,
118 p_role_pmt_plan_id IN NUMBER,
119 x_srp_pmt_plan_id OUT NOCOPY NUMBER,
120 x_loading_status OUT NOCOPY VARCHAR2
121 );
122
123
124 -- Start of comments
125 -- API name : Update_Mass_Asgn_Srp_Pmt_Plan
126 -- Type : Public.
127 -- Pre-reqs : None.
128 -- Usage : Used to update mass pmt plan assignment of an salesrep
129 -- Desc : Procedure to update mass pmt plan assignment of an salesrep
130 -- Parameters :
131 -- IN : p_api_version IN NUMBER Require
132 -- p_init_msg_list IN VARCHAR2 Optional
133 -- Default = CN_API.G_FALSE
134 -- p_commit IN VARCHAR2 Optional
135 -- Default = CN_API.G_FALSE
136 -- p_validation_level IN NUMBER Optional
137 -- Default = CN_API.G_VALID_LEVEL_FULL
138 -- p_srp_role_id IN NUMBER
139 -- p_role_pmt_plan_id IN NUMBER
140 -- OUT : x_return_status OUT VARCHAR2(1)
141 -- x_msg_count OUT NUMBER
142 -- x_msg_data OUT VARCHAR2(2000)
143 -- x_loading_status OUT VARCHAR2(30)
144 -- Version : Current version 1.0
145 -- Initial version 1.0
146 PROCEDURE Update_Mass_Asgn_Srp_Pmt_plan
147 (
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
150 p_commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_srp_role_id IN NUMBER,
156 p_role_pmt_plan_id IN NUMBER,
157 x_loading_status OUT NOCOPY VARCHAR2
158 );
159
160 -- Start of comments
161 -- API name : Delete_Mass_Asgn_Srp_Pmt_Plan
162 -- Type : Public.
163 -- Pre-reqs : None.
164 -- Usage : Used to delete a payment plan assignment to an salesrep
165 -- Desc : Procedure to delete a payment plan assignment to salesrep
166 -- Parameters :
167 -- IN : p_api_version IN NUMBER Require
168 -- p_init_msg_list IN VARCHAR2 Optional
169 -- Default = CN_API.G_FALSE
170 -- p_commit IN VARCHAR2 Optional
171 -- Default = CN_API.G_FALSE
172 -- p_validation_level IN NUMBER Optional
173 -- Default = CN_API.G_VALID_LEVEL_FULL
174 -- p_srp_role_id IN NUMBER
175 -- p_role_pmt_plan_id IN NUMBER
176 -- OUT : x_return_status OUT VARCHAR2(1)
177 -- x_msg_count OUT NUMBER
178 -- x_msg_data OUT VARCHAR2(2000)
179 -- x_loading_status OUT VARCHAR2(30)
180 -- Version : Current version 1.0
181 -- Initial version 1.0
182 PROCEDURE Delete_Mass_Asgn_Srp_Pmt_Plan
183 (p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
185 p_commit IN VARCHAR2 := FND_API.G_FALSE,
186 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
187 x_return_status OUT NOCOPY VARCHAR2,
188 x_msg_count OUT NOCOPY NUMBER,
189 x_msg_data OUT NOCOPY VARCHAR2,
190 p_srp_role_id IN NUMBER,
191 p_role_pmt_plan_id IN NUMBER,
192 x_loading_status OUT NOCOPY VARCHAR2
193 );
194
195 END cn_srp_pmt_plans_pvt;