166: -- Desc : Procedure to create a new record in cn_srp_periods
167: -- Parameters :
168: -- IN : p_api_version IN NUMBER Require
169: -- p_init_msg_list IN VARCHAR2 Optional
170: -- Default = FND_API.G_FALSE
171: -- p_commit IN VARCHAR2 Optional
172: -- Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional
174: -- Default = FND_API.G_VALID_LEVEL_FULL
168: -- IN : p_api_version IN NUMBER Require
169: -- p_init_msg_list IN VARCHAR2 Optional
170: -- Default = FND_API.G_FALSE
171: -- p_commit IN VARCHAR2 Optional
172: -- Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional
174: -- Default = FND_API.G_VALID_LEVEL_FULL
175: -- OUT : x_return_status OUT VARCHAR2(1)
176: -- x_msg_count OUT NUMBER
170: -- Default = FND_API.G_FALSE
171: -- p_commit IN VARCHAR2 Optional
172: -- Default = FND_API.G_FALSE
173: -- p_validation_level IN NUMBER Optional
174: -- Default = FND_API.G_VALID_LEVEL_FULL
175: -- OUT : x_return_status OUT VARCHAR2(1)
176: -- x_msg_count OUT NUMBER
177: -- x_msg_data OUT VARCHAR2(2000)
178: -- IN : p_salesrep_id IN NUMBER,
187: -- End of comments
188:
189: PROCEDURE Create_Srp_Periods
190: (p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
188:
189: PROCEDURE Create_Srp_Periods
190: (p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
189: PROCEDURE Create_Srp_Periods
190: (p_api_version IN NUMBER,
191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
192: p_commit IN VARCHAR2 := FND_API.G_FALSE,
193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
194: x_return_status OUT NOCOPY VARCHAR2,
195: x_msg_count OUT NOCOPY NUMBER,
196: x_msg_data OUT NOCOPY VARCHAR2,
197: p_salesrep_id IN NUMBER,
198: p_role_id IN NUMBER,
199: p_comp_plan_id IN NUMBER,
200: p_start_date IN DATE,
201: p_end_date IN DATE,
202: p_sync_flag IN VARCHAR2 := FND_API.G_TRUE,
203: x_loading_status OUT NOCOPY VARCHAR2
204: );
205:
206: -- same as Create_Srp_Periods but only for one plan element
205:
206: -- same as Create_Srp_Periods but only for one plan element
207: PROCEDURE Create_Srp_Periods_Per_Quota
208: (p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
206: -- same as Create_Srp_Periods but only for one plan element
207: PROCEDURE Create_Srp_Periods_Per_Quota
208: (p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
207: PROCEDURE Create_Srp_Periods_Per_Quota
208: (p_api_version IN NUMBER,
209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
210: p_commit IN VARCHAR2 := FND_API.G_FALSE,
211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_salesrep_id IN NUMBER,
217: p_comp_plan_id IN NUMBER,
218: p_quota_id IN NUMBER,
219: p_start_date IN DATE,
220: p_end_date IN DATE,
221: p_sync_flag IN VARCHAR2 := FND_API.G_TRUE,
222: x_loading_status OUT NOCOPY VARCHAR2
223: );
224:
225: -- Start of comments
230: -- Desc : Procedure to create a new record in cn_srp_periods
231: -- Parameters :
232: -- IN : p_api_version IN NUMBER Require
233: -- p_init_msg_list IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_commit IN VARCHAR2 Optional
236: -- Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional
238: -- Default = FND_API.G_VALID_LEVEL_FULL
232: -- IN : p_api_version IN NUMBER Require
233: -- p_init_msg_list IN VARCHAR2 Optional
234: -- Default = FND_API.G_FALSE
235: -- p_commit IN VARCHAR2 Optional
236: -- Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional
238: -- Default = FND_API.G_VALID_LEVEL_FULL
239: -- OUT : x_return_status OUT VARCHAR2(1)
240: -- x_msg_count OUT NUMBER
234: -- Default = FND_API.G_FALSE
235: -- p_commit IN VARCHAR2 Optional
236: -- Default = FND_API.G_FALSE
237: -- p_validation_level IN NUMBER Optional
238: -- Default = FND_API.G_VALID_LEVEL_FULL
239: -- OUT : x_return_status OUT VARCHAR2(1)
240: -- x_msg_count OUT NUMBER
241: -- x_msg_data OUT VARCHAR2(2000)
242: -- IN :
247: -- End of comments
248:
249: PROCEDURE Update_Delta_Srp_Periods
250: (p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
248:
249: PROCEDURE Update_Delta_Srp_Periods
250: (p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
249: PROCEDURE Update_Delta_Srp_Periods
250: (p_api_version IN NUMBER,
251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252: p_commit IN VARCHAR2 := FND_API.G_FALSE,
253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: p_del_srp_prd_rec IN delta_srp_period_rec_type,
263: -- *** CAUTION *** if you use this, make sure you sync the balances
264: -- afterward, so balances do not mismatch.
265: PROCEDURE Update_Delta_Srp_Pds_No_Sync
266: (p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
264: -- afterward, so balances do not mismatch.
265: PROCEDURE Update_Delta_Srp_Pds_No_Sync
266: (p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
265: PROCEDURE Update_Delta_Srp_Pds_No_Sync
266: (p_api_version IN NUMBER,
267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
268: p_commit IN VARCHAR2 := FND_API.G_FALSE,
269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
270: x_return_status OUT NOCOPY VARCHAR2,
271: x_msg_count OUT NOCOPY NUMBER,
272: x_msg_data OUT NOCOPY VARCHAR2,
273: p_del_srp_prd_rec IN delta_srp_period_rec_type,
282: -- Desc : Procedure to create a new record in cn_srp_periods
283: -- Parameters :
284: -- IN : p_api_version IN NUMBER Require
285: -- p_init_msg_list IN VARCHAR2 Optional
286: -- Default = FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Optional
288: -- Default = FND_API.G_FALSE
289: -- p_validation_level IN NUMBER Optional
290: -- Default = FND_API.G_VALID_LEVEL_FULL
284: -- IN : p_api_version IN NUMBER Require
285: -- p_init_msg_list IN VARCHAR2 Optional
286: -- Default = FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Optional
288: -- Default = FND_API.G_FALSE
289: -- p_validation_level IN NUMBER Optional
290: -- Default = FND_API.G_VALID_LEVEL_FULL
291: -- OUT : x_return_status OUT VARCHAR2(1)
292: -- x_msg_count OUT NUMBER
286: -- Default = FND_API.G_FALSE
287: -- p_commit IN VARCHAR2 Optional
288: -- Default = FND_API.G_FALSE
289: -- p_validation_level IN NUMBER Optional
290: -- Default = FND_API.G_VALID_LEVEL_FULL
291: -- OUT : x_return_status OUT VARCHAR2(1)
292: -- x_msg_count OUT NUMBER
293: -- x_msg_data OUT VARCHAR2(2000)
294: -- IN :
299: -- End of comments
300:
301: PROCEDURE Update_Pmt_Delta_Srp_Periods
302: (p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
300:
301: PROCEDURE Update_Pmt_Delta_Srp_Periods
302: (p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,
301: PROCEDURE Update_Pmt_Delta_Srp_Periods
302: (p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
304: p_commit IN VARCHAR2 := FND_API.G_FALSE,
305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
306: x_return_status OUT NOCOPY VARCHAR2,
307: x_msg_count OUT NOCOPY NUMBER,
308: x_msg_data OUT NOCOPY VARCHAR2,
309: p_del_srp_prd_rec IN delta_srp_period_rec_type,