DBA Data[Home] [Help]

APPS.CN_SRP_PERIODS_PVT dependencies on FND_API

Line 170: -- Default = FND_API.G_FALSE

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

Line 172: -- Default = FND_API.G_FALSE

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

Line 174: -- Default = FND_API.G_VALID_LEVEL_FULL

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,

Line 191: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 192: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 193: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 202: p_sync_flag IN VARCHAR2 := FND_API.G_TRUE,

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

Line 209: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 210: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 211: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 221: p_sync_flag IN VARCHAR2 := FND_API.G_TRUE,

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

Line 234: -- Default = FND_API.G_FALSE

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

Line 236: -- Default = FND_API.G_FALSE

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

Line 238: -- Default = FND_API.G_VALID_LEVEL_FULL

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 :

Line 251: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 252: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 253: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 267: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 268: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 269: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,

Line 286: -- Default = FND_API.G_FALSE

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

Line 288: -- Default = FND_API.G_FALSE

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

Line 290: -- Default = FND_API.G_VALID_LEVEL_FULL

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 :

Line 303: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 304: p_commit IN VARCHAR2 := FND_API.G_FALSE,

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,

Line 305: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

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,