eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUNDS_PVT dependencies on FND_API

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

178: -- the sequence.
179: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
180: -- Raise exception for invalid flag.
181: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
182: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
183: ---------------------------------------------------------------------
184: PROCEDURE Create_Fund(
185: p_api_version IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

182: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
183: ---------------------------------------------------------------------
184: PROCEDURE Create_Fund(
185: p_api_version IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
187: ,p_commit IN VARCHAR2 := FND_API.g_false
188: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
189:
190: ,x_return_status OUT NOCOPY VARCHAR2

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

183: ---------------------------------------------------------------------
184: PROCEDURE Create_Fund(
185: p_api_version IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
187: ,p_commit IN VARCHAR2 := FND_API.g_false
188: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
189:
190: ,x_return_status OUT NOCOPY VARCHAR2
191: ,x_msg_count OUT NOCOPY NUMBER

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

184: PROCEDURE Create_Fund(
185: p_api_version IN NUMBER
186: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
187: ,p_commit IN VARCHAR2 := FND_API.g_false
188: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
189:
190: ,x_return_status OUT NOCOPY VARCHAR2
191: ,x_msg_count OUT NOCOPY NUMBER
192: ,x_msg_data OUT NOCOPY VARCHAR2

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

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

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

212: --------------------------------------------------------------------
213: PROCEDURE Delete_Fund(
214: p_api_version IN NUMBER
215: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
216: ,p_commit IN VARCHAR2 := FND_API.g_false
217:
218: ,x_return_status OUT NOCOPY VARCHAR2
219: ,x_msg_count OUT NOCOPY NUMBER
220: ,x_msg_data OUT NOCOPY VARCHAR2

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

239: -- 1. Raise exception if the object_version_number doesn't match.
240: --------------------------------------------------------------------
241: PROCEDURE Lock_Fund(
242: p_api_version IN NUMBER
243: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
244:
245: ,x_return_status OUT NOCOPY VARCHAR2
246: ,x_msg_count OUT NOCOPY NUMBER
247: ,x_msg_data OUT NOCOPY VARCHAR2

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

264: -- : The mode should always be 'UPDATE' except when updating the earned or committed amount
265: --
266: -- NOTES
267: -- 1. Raise exception if the object_version_number doesn't match.
268: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
269: -- that column won't be updated.
270: ----------------------------------------------------------------------
271: PROCEDURE Update_Fund(
272: p_api_version IN NUMBER

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

269: -- that column won't be updated.
270: ----------------------------------------------------------------------
271: PROCEDURE Update_Fund(
272: p_api_version IN NUMBER
273: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
274: ,p_commit IN VARCHAR2 := FND_API.g_false
275: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
276:
277: ,x_return_status OUT NOCOPY VARCHAR2

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

270: ----------------------------------------------------------------------
271: PROCEDURE Update_Fund(
272: p_api_version IN NUMBER
273: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
274: ,p_commit IN VARCHAR2 := FND_API.g_false
275: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
276:
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER

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

271: PROCEDURE Update_Fund(
272: p_api_version IN NUMBER
273: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
274: ,p_commit IN VARCHAR2 := FND_API.g_false
275: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
276:
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER
279: ,x_msg_data OUT NOCOPY VARCHAR2

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

296: -- : The mode should always be 'UPDATE' except when updating the earned or committed amount
297: --
298: -- NOTES
299: -- 1. Raise exception if the object_version_number doesn't match.
300: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
301: -- that column won't be updated.
302:
303: -- 27/10/2009 muthsubr Added p_resale_batch_id, p_use_fund_staging_tables
304: -- px_ozf_funds_old_rectype, px_ozf_funds_new_rectype

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

307: -- for TPA Parallel Execution ER Bug#9614703.
308: ----------------------------------------------------------------------
309: PROCEDURE Update_Fund(
310: p_api_version IN NUMBER
311: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
312: ,p_commit IN VARCHAR2 := FND_API.g_false
313: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
314:
315: ,x_return_status OUT NOCOPY VARCHAR2

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

308: ----------------------------------------------------------------------
309: PROCEDURE Update_Fund(
310: p_api_version IN NUMBER
311: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
312: ,p_commit IN VARCHAR2 := FND_API.g_false
313: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
314:
315: ,x_return_status OUT NOCOPY VARCHAR2
316: ,x_msg_count OUT NOCOPY NUMBER

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

309: PROCEDURE Update_Fund(
310: p_api_version IN NUMBER
311: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
312: ,p_commit IN VARCHAR2 := FND_API.g_false
313: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
314:
315: ,x_return_status OUT NOCOPY VARCHAR2
316: ,x_msg_count OUT NOCOPY NUMBER
317: ,x_msg_data OUT NOCOPY VARCHAR2

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

336: -- p_fund_rec: the fund record to be validated
337: --
338: -- NOTES
339: -- 1. p_fund_rec should be the complete fund record. There
340: -- should not be any FND_API.g_miss_char/num/date in it.
341: ----------------------------------------------------------------------
342: PROCEDURE Validate_Fund(
343: p_api_version IN NUMBER
344: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

340: -- should not be any FND_API.g_miss_char/num/date in it.
341: ----------------------------------------------------------------------
342: PROCEDURE Validate_Fund(
343: p_api_version IN NUMBER
344: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
345: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
346:
347: ,x_return_status OUT NOCOPY VARCHAR2
348: ,x_msg_count OUT NOCOPY NUMBER

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

341: ----------------------------------------------------------------------
342: PROCEDURE Validate_Fund(
343: p_api_version IN NUMBER
344: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
345: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
346:
347: ,x_return_status OUT NOCOPY VARCHAR2
348: ,x_msg_count OUT NOCOPY NUMBER
349: ,x_msg_data OUT NOCOPY VARCHAR2

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

382: -- Check the record level business rules.
383: --
384: -- PARAMETERS
385: -- p_fund_rec: the record to be validated; may contain attributes
386: -- as FND_API.g_miss_char/num/date
387: -- p_complete_rec: the complete record after all "g_miss" items
388: -- have been replaced by current database values
389: ---------------------------------------------------------------------
390: PROCEDURE Check_Fund_Record(

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

399: -- PROCEDURE
400: -- Init_Fund_Rec
401: --
402: -- PURPOSE
403: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
404: ---------------------------------------------------------------------
405: PROCEDURE Init_Fund_Rec(
406: x_fund_rec OUT NOCOPY fund_rec_type
407: );

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

412: -- Complete_Fund_Rec
413: --
414: -- PURPOSE
415: -- For update_fund, some attributes may be passed in as
416: -- FND_API.g_miss_char/num/date if the user doesn't want to
417: -- update those attributes. This procedure will replace the
418: -- "g_miss" attributes with current database values.
419: --
420: -- PARAMETERS

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

418: -- "g_miss" attributes with current database values.
419: --
420: -- PARAMETERS
421: -- p_fund_rec: the record which may contain attributes as
422: -- FND_API.g_miss_char/num/date
423: -- x_complete_rec: the complete record after all "g_miss" items
424: -- have been replaced by current database values
425: ---------------------------------------------------------------------
426: PROCEDURE Complete_Fund_Rec(

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

456: -- Check the inter-entity level business rules.
457: --
458: -- PARAMETERS
459: -- p_fund_rec: the record to be validated; may contain attributes
460: -- as FND_API.g_miss_char/num/date
461: -- p_complete_rec: the complete record after all "g_miss" items
462: -- have been replaced by current database values
463: -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
464: ---------------------------------------------------------------------

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

486: ---------------------------------------------------------------------
487:
488: PROCEDURE copy_fund (
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
491: p_commit IN VARCHAR2 := FND_API.G_FALSE,
492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: x_return_status OUT NOCOPY VARCHAR2,
494: x_msg_count OUT NOCOPY NUMBER,

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

487:
488: PROCEDURE copy_fund (
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
491: p_commit IN VARCHAR2 := FND_API.G_FALSE,
492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: x_return_status OUT NOCOPY VARCHAR2,
494: x_msg_count OUT NOCOPY NUMBER,
495: x_msg_data OUT NOCOPY VARCHAR2,

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

488: PROCEDURE copy_fund (
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
491: p_commit IN VARCHAR2 := FND_API.G_FALSE,
492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
493: x_return_status OUT NOCOPY VARCHAR2,
494: x_msg_count OUT NOCOPY NUMBER,
495: x_msg_data OUT NOCOPY VARCHAR2,
496: p_source_object_id IN NUMBER,

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

514: ---------------------------------------------------------------------
515:
516: PROCEDURE update_rollup_amount(
517: p_api_version IN NUMBER
518: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
519: ,p_commit IN VARCHAR2 := fnd_api.g_false
520: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
521: ,x_return_status OUT NOCOPY VARCHAR2
522: ,x_msg_count OUT NOCOPY NUMBER

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

515:
516: PROCEDURE update_rollup_amount(
517: p_api_version IN NUMBER
518: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
519: ,p_commit IN VARCHAR2 := fnd_api.g_false
520: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
521: ,x_return_status OUT NOCOPY VARCHAR2
522: ,x_msg_count OUT NOCOPY NUMBER
523: ,x_msg_data OUT NOCOPY VARCHAR2

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

516: PROCEDURE update_rollup_amount(
517: p_api_version IN NUMBER
518: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
519: ,p_commit IN VARCHAR2 := fnd_api.g_false
520: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
521: ,x_return_status OUT NOCOPY VARCHAR2
522: ,x_msg_count OUT NOCOPY NUMBER
523: ,x_msg_data OUT NOCOPY VARCHAR2
524: ,p_fund_rec IN fund_rec_type

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

537: ---------------------------------------------------------------------
538:
539: PROCEDURE update_funds_access(
540: p_api_version IN NUMBER
541: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
542: ,p_commit IN VARCHAR2 := fnd_api.g_false
543: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER

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

538:
539: PROCEDURE update_funds_access(
540: p_api_version IN NUMBER
541: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
542: ,p_commit IN VARCHAR2 := fnd_api.g_false
543: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER
546: ,x_msg_data OUT NOCOPY VARCHAR2

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

539: PROCEDURE update_funds_access(
540: p_api_version IN NUMBER
541: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
542: ,p_commit IN VARCHAR2 := fnd_api.g_false
543: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER
546: ,x_msg_data OUT NOCOPY VARCHAR2
547: ,p_fund_rec IN fund_rec_type