DBA Data[Home] [Help]

APPS.OZF_FUNDS_PVT dependencies on FND_API

Line 156: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.

152: -- the sequence.
153: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
154: -- Raise exception for invalid flag.
155: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
156: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
157: ---------------------------------------------------------------------
158: PROCEDURE Create_Fund(
159: p_api_version IN NUMBER
160: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

Line 160: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

156: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
157: ---------------------------------------------------------------------
158: PROCEDURE Create_Fund(
159: p_api_version IN NUMBER
160: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
161: ,p_commit IN VARCHAR2 := FND_API.g_false
162: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
163:
164: ,x_return_status OUT NOCOPY VARCHAR2

Line 161: ,p_commit IN VARCHAR2 := FND_API.g_false

157: ---------------------------------------------------------------------
158: PROCEDURE Create_Fund(
159: p_api_version IN NUMBER
160: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
161: ,p_commit IN VARCHAR2 := FND_API.g_false
162: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
163:
164: ,x_return_status OUT NOCOPY VARCHAR2
165: ,x_msg_count OUT NOCOPY NUMBER

Line 162: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

158: PROCEDURE Create_Fund(
159: p_api_version IN NUMBER
160: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
161: ,p_commit IN VARCHAR2 := FND_API.g_false
162: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
163:
164: ,x_return_status OUT NOCOPY VARCHAR2
165: ,x_msg_count OUT NOCOPY NUMBER
166: ,x_msg_data OUT NOCOPY VARCHAR2

Line 189: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

185: -- 1. Raise exception if the object_version_number doesn't match.
186: --------------------------------------------------------------------
187: PROCEDURE Delete_Fund(
188: p_api_version IN NUMBER
189: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
190: ,p_commit IN VARCHAR2 := FND_API.g_false
191:
192: ,x_return_status OUT NOCOPY VARCHAR2
193: ,x_msg_count OUT NOCOPY NUMBER

Line 190: ,p_commit IN VARCHAR2 := FND_API.g_false

186: --------------------------------------------------------------------
187: PROCEDURE Delete_Fund(
188: p_api_version IN NUMBER
189: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
190: ,p_commit IN VARCHAR2 := FND_API.g_false
191:
192: ,x_return_status OUT NOCOPY VARCHAR2
193: ,x_msg_count OUT NOCOPY NUMBER
194: ,x_msg_data OUT NOCOPY VARCHAR2

Line 217: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

213: -- 1. Raise exception if the object_version_number doesn't match.
214: --------------------------------------------------------------------
215: PROCEDURE Lock_Fund(
216: p_api_version IN NUMBER
217: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
218:
219: ,x_return_status OUT NOCOPY VARCHAR2
220: ,x_msg_count OUT NOCOPY NUMBER
221: ,x_msg_data OUT NOCOPY VARCHAR2

Line 242: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,

238: -- : The mode should always be 'UPDATE' except when updating the earned or committed amount
239: --
240: -- NOTES
241: -- 1. Raise exception if the object_version_number doesn't match.
242: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
243: -- that column won't be updated.
244: ----------------------------------------------------------------------
245: PROCEDURE Update_Fund(
246: p_api_version IN NUMBER

Line 247: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

243: -- that column won't be updated.
244: ----------------------------------------------------------------------
245: PROCEDURE Update_Fund(
246: p_api_version IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
248: ,p_commit IN VARCHAR2 := FND_API.g_false
249: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
250:
251: ,x_return_status OUT NOCOPY VARCHAR2

Line 248: ,p_commit IN VARCHAR2 := FND_API.g_false

244: ----------------------------------------------------------------------
245: PROCEDURE Update_Fund(
246: p_api_version IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
248: ,p_commit IN VARCHAR2 := FND_API.g_false
249: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
250:
251: ,x_return_status OUT NOCOPY VARCHAR2
252: ,x_msg_count OUT NOCOPY NUMBER

Line 249: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

245: PROCEDURE Update_Fund(
246: p_api_version IN NUMBER
247: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
248: ,p_commit IN VARCHAR2 := FND_API.g_false
249: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
250:
251: ,x_return_status OUT NOCOPY VARCHAR2
252: ,x_msg_count OUT NOCOPY NUMBER
253: ,x_msg_data OUT NOCOPY VARCHAR2

Line 272: -- should not be any FND_API.g_miss_char/num/date in it.

268: -- p_fund_rec: the fund record to be validated
269: --
270: -- NOTES
271: -- 1. p_fund_rec should be the complete fund record. There
272: -- should not be any FND_API.g_miss_char/num/date in it.
273: ----------------------------------------------------------------------
274: PROCEDURE Validate_Fund(
275: p_api_version IN NUMBER
276: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

Line 276: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

272: -- should not be any FND_API.g_miss_char/num/date in it.
273: ----------------------------------------------------------------------
274: PROCEDURE Validate_Fund(
275: p_api_version IN NUMBER
276: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
277: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER

Line 277: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full

273: ----------------------------------------------------------------------
274: PROCEDURE Validate_Fund(
275: p_api_version IN NUMBER
276: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
277: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278:
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER
281: ,x_msg_data OUT NOCOPY VARCHAR2

Line 316: -- as FND_API.g_miss_char/num/date

312: -- Check the record level business rules.
313: --
314: -- PARAMETERS
315: -- p_fund_rec: the record to be validated; may contain attributes
316: -- as FND_API.g_miss_char/num/date
317: -- p_complete_rec: the complete record after all "g_miss" items
318: -- have been replaced by current database values
319: ---------------------------------------------------------------------
320: PROCEDURE Check_Fund_Record(

Line 333: -- Initialize all attributes to be FND_API.g_miss_char/num/date.

329: -- PROCEDURE
330: -- Init_Fund_Rec
331: --
332: -- PURPOSE
333: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
334: ---------------------------------------------------------------------
335: PROCEDURE Init_Fund_Rec(
336: x_fund_rec OUT NOCOPY fund_rec_type
337: );

Line 346: -- FND_API.g_miss_char/num/date if the user doesn't want to

342: -- Complete_Fund_Rec
343: --
344: -- PURPOSE
345: -- For update_fund, some attributes may be passed in as
346: -- FND_API.g_miss_char/num/date if the user doesn't want to
347: -- update those attributes. This procedure will replace the
348: -- "g_miss" attributes with current database values.
349: --
350: -- PARAMETERS

Line 352: -- FND_API.g_miss_char/num/date

348: -- "g_miss" attributes with current database values.
349: --
350: -- PARAMETERS
351: -- p_fund_rec: the record which may contain attributes as
352: -- FND_API.g_miss_char/num/date
353: -- x_complete_rec: the complete record after all "g_miss" items
354: -- have been replaced by current database values
355: ---------------------------------------------------------------------
356: PROCEDURE Complete_Fund_Rec(

Line 390: -- as FND_API.g_miss_char/num/date

386: -- Check the inter-entity level business rules.
387: --
388: -- PARAMETERS
389: -- p_fund_rec: the record to be validated; may contain attributes
390: -- as FND_API.g_miss_char/num/date
391: -- p_complete_rec: the complete record after all "g_miss" items
392: -- have been replaced by current database values
393: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
394: ---------------------------------------------------------------------

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

416: ---------------------------------------------------------------------
417:
418: PROCEDURE copy_fund (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,

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

417:
418: PROCEDURE copy_fund (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,

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

418: PROCEDURE copy_fund (
419: p_api_version IN NUMBER,
420: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
421: p_commit IN VARCHAR2 := FND_API.G_FALSE,
422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
423: x_return_status OUT NOCOPY VARCHAR2,
424: x_msg_count OUT NOCOPY NUMBER,
425: x_msg_data OUT NOCOPY VARCHAR2,
426: p_source_object_id IN NUMBER,

Line 448: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

444: ---------------------------------------------------------------------
445:
446: PROCEDURE update_rollup_amount(
447: p_api_version IN NUMBER
448: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
449: ,p_commit IN VARCHAR2 := fnd_api.g_false
450: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
451: ,x_return_status OUT NOCOPY VARCHAR2
452: ,x_msg_count OUT NOCOPY NUMBER

Line 449: ,p_commit IN VARCHAR2 := fnd_api.g_false

445:
446: PROCEDURE update_rollup_amount(
447: p_api_version IN NUMBER
448: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
449: ,p_commit IN VARCHAR2 := fnd_api.g_false
450: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
451: ,x_return_status OUT NOCOPY VARCHAR2
452: ,x_msg_count OUT NOCOPY NUMBER
453: ,x_msg_data OUT NOCOPY VARCHAR2

Line 450: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

446: PROCEDURE update_rollup_amount(
447: p_api_version IN NUMBER
448: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
449: ,p_commit IN VARCHAR2 := fnd_api.g_false
450: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
451: ,x_return_status OUT NOCOPY VARCHAR2
452: ,x_msg_count OUT NOCOPY NUMBER
453: ,x_msg_data OUT NOCOPY VARCHAR2
454: ,p_fund_rec IN fund_rec_type

Line 471: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false

467: ---------------------------------------------------------------------
468:
469: PROCEDURE update_funds_access(
470: p_api_version IN NUMBER
471: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
472: ,p_commit IN VARCHAR2 := fnd_api.g_false
473: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
474: ,x_return_status OUT NOCOPY VARCHAR2
475: ,x_msg_count OUT NOCOPY NUMBER

Line 472: ,p_commit IN VARCHAR2 := fnd_api.g_false

468:
469: PROCEDURE update_funds_access(
470: p_api_version IN NUMBER
471: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
472: ,p_commit IN VARCHAR2 := fnd_api.g_false
473: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
474: ,x_return_status OUT NOCOPY VARCHAR2
475: ,x_msg_count OUT NOCOPY NUMBER
476: ,x_msg_data OUT NOCOPY VARCHAR2

Line 473: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full

469: PROCEDURE update_funds_access(
470: p_api_version IN NUMBER
471: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
472: ,p_commit IN VARCHAR2 := fnd_api.g_false
473: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
474: ,x_return_status OUT NOCOPY VARCHAR2
475: ,x_msg_count OUT NOCOPY NUMBER
476: ,x_msg_data OUT NOCOPY VARCHAR2
477: ,p_fund_rec IN fund_rec_type