DBA Data[Home] [Help]

APPS.OZF_FUND_UTILIZED_PVT dependencies on FND_API

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

128: -- the sequence.
129: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
130: -- Raise exception for invalid flag.
131: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
132: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
133: ---------------------------------------------------------------------
134: PROCEDURE Create_Utilization(
135: p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

132: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
133: ---------------------------------------------------------------------
134: PROCEDURE Create_Utilization(
135: p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
137: ,p_commit IN VARCHAR2 := FND_API.g_false
138: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
139:
140: ,x_return_status OUT NOCOPY VARCHAR2

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

133: ---------------------------------------------------------------------
134: PROCEDURE Create_Utilization(
135: p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
137: ,p_commit IN VARCHAR2 := FND_API.g_false
138: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
139:
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER

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

134: PROCEDURE Create_Utilization(
135: p_api_version IN NUMBER
136: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
137: ,p_commit IN VARCHAR2 := FND_API.g_false
138: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
139:
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER
142: ,x_msg_data OUT NOCOPY VARCHAR2

Line 143: ,p_create_gl_entry IN VARCHAR2 := FND_API.g_false

139:
140: ,x_return_status OUT NOCOPY VARCHAR2
141: ,x_msg_count OUT NOCOPY NUMBER
142: ,x_msg_data OUT NOCOPY VARCHAR2
143: ,p_create_gl_entry IN VARCHAR2 := FND_API.g_false
144: ,p_utilization_rec IN utilization_rec_type
145: ,x_utilization_id OUT NOCOPY NUMBER
146: );
147:

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

165: -- for TPA Parallel Execution ER Bug#9614703.
166: ---------------------------------------------------------------------
167: PROCEDURE Create_Utilization(
168: p_api_version IN NUMBER
169: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
170: ,p_commit IN VARCHAR2 := FND_API.g_false
171: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
172:
173: ,x_return_status OUT NOCOPY VARCHAR2

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

166: ---------------------------------------------------------------------
167: PROCEDURE Create_Utilization(
168: p_api_version IN NUMBER
169: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
170: ,p_commit IN VARCHAR2 := FND_API.g_false
171: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
172:
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER

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

167: PROCEDURE Create_Utilization(
168: p_api_version IN NUMBER
169: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
170: ,p_commit IN VARCHAR2 := FND_API.g_false
171: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
172:
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
175: ,x_msg_data OUT NOCOPY VARCHAR2

Line 176: ,p_create_gl_entry IN VARCHAR2 := FND_API.g_false

172:
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
175: ,x_msg_data OUT NOCOPY VARCHAR2
176: ,p_create_gl_entry IN VARCHAR2 := FND_API.g_false
177: ,p_utilization_rec IN utilization_rec_type
178: ,x_utilization_id OUT NOCOPY NUMBER
179: ,p_batch_type IN VARCHAR2
180: ,p_use_fund_staging_tables IN VARCHAR2 DEFAULT 'F'

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

198: -- 1. Raise exception if the object_version_number doesn't match.
199: --------------------------------------------------------------------
200: PROCEDURE Delete_Utilization(
201: p_api_version IN NUMBER
202: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
203: ,p_commit IN VARCHAR2 := FND_API.g_false
204:
205: ,x_return_status OUT NOCOPY VARCHAR2
206: ,x_msg_count OUT NOCOPY NUMBER

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

199: --------------------------------------------------------------------
200: PROCEDURE Delete_Utilization(
201: p_api_version IN NUMBER
202: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
203: ,p_commit IN VARCHAR2 := FND_API.g_false
204:
205: ,x_return_status OUT NOCOPY VARCHAR2
206: ,x_msg_count OUT NOCOPY NUMBER
207: ,x_msg_data OUT NOCOPY VARCHAR2

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

226: -- 1. Raise exception if the object_version_number doesn't match.
227: --------------------------------------------------------------------
228: PROCEDURE Lock_Utilization(
229: p_api_version IN NUMBER
230: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
231:
232: ,x_return_status OUT NOCOPY VARCHAR2
233: ,x_msg_count OUT NOCOPY NUMBER
234: ,x_msg_data OUT NOCOPY VARCHAR2

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

250: -- p_mode : determines what sort of validation is to be performed during update.
251: --
252: -- NOTES
253: -- 1. Raise exception if the object_version_number doesn't match.
254: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
255: -- that column won't be updated.
256: ----------------------------------------------------------------------
257: PROCEDURE Update_Utilization(
258: p_api_version IN NUMBER

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

255: -- that column won't be updated.
256: ----------------------------------------------------------------------
257: PROCEDURE Update_Utilization(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
260: ,p_commit IN VARCHAR2 := FND_API.g_false
261: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
262:
263: ,x_return_status OUT NOCOPY VARCHAR2

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

256: ----------------------------------------------------------------------
257: PROCEDURE Update_Utilization(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
260: ,p_commit IN VARCHAR2 := FND_API.g_false
261: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
262:
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER

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

257: PROCEDURE Update_Utilization(
258: p_api_version IN NUMBER
259: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
260: ,p_commit IN VARCHAR2 := FND_API.g_false
261: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
262:
263: ,x_return_status OUT NOCOPY VARCHAR2
264: ,x_msg_count OUT NOCOPY NUMBER
265: ,x_msg_data OUT NOCOPY VARCHAR2

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

280: -- p_utilization_rec: the fund utilization record to be validated
281: --
282: -- NOTES
283: -- 1. p_utilization_rec should be the complete fund record. There
284: -- should not be any FND_API.g_miss_char/num/date in it.
285: ----------------------------------------------------------------------
286: PROCEDURE Validate_Utilization(
287: p_api_version IN NUMBER
288: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false

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

284: -- should not be any FND_API.g_miss_char/num/date in it.
285: ----------------------------------------------------------------------
286: PROCEDURE Validate_Utilization(
287: p_api_version IN NUMBER
288: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
289: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
290:
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER

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

285: ----------------------------------------------------------------------
286: PROCEDURE Validate_Utilization(
287: p_api_version IN NUMBER
288: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
289: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
290:
291: ,x_return_status OUT NOCOPY VARCHAR2
292: ,x_msg_count OUT NOCOPY NUMBER
293: ,x_msg_data OUT NOCOPY VARCHAR2

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

323: -- Check the record level business rules.
324: --
325: -- PARAMETERS
326: -- p_utilization_rec: the record to be validated; may contain attributes
327: -- as FND_API.g_miss_char/num/date
328: -- p_complete_rec: the complete record after all "g_miss" items
329: -- have been replaced by current database values
330: ---------------------------------------------------------------------
331: PROCEDURE Check_Utilization_Record(

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

340: -- PROCEDURE
341: -- Init_Utilization_Rec
342: --
343: -- PURPOSE
344: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
345: ---------------------------------------------------------------------
346: PROCEDURE Init_Utilization_Rec(
347: x_utilization_rec OUT NOCOPY utilization_rec_type
348: );

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

353: -- Complete_Utilization_Rec
354: --
355: -- PURPOSE
356: -- For update_fund, some attributes may be passed in as
357: -- FND_API.g_miss_char/num/date if the user doesn't want to
358: -- update those attributes. This procedure will replace the
359: -- "g_miss" attributes with current database values.
360: --
361: -- PARAMETERS

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

359: -- "g_miss" attributes with current database values.
360: --
361: -- PARAMETERS
362: -- p_utilization_rec: the record which may contain attributes as
363: -- FND_API.g_miss_char/num/date
364: -- x_complete_rec: the complete record after all "g_miss" items
365: -- have been replaced by current database values
366: ---------------------------------------------------------------------
367: PROCEDURE Complete_Utilization_Rec(

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

388: ---------------------------------------------------------------------
389:
390: PROCEDURE create_act_utilization(
391: p_api_version IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
393: ,p_commit IN VARCHAR2 := fnd_api.g_false
394: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
395: ,x_return_status OUT NOCOPY VARCHAR2
396: ,x_msg_count OUT NOCOPY NUMBER

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

389:
390: PROCEDURE create_act_utilization(
391: p_api_version IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
393: ,p_commit IN VARCHAR2 := fnd_api.g_false
394: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
395: ,x_return_status OUT NOCOPY VARCHAR2
396: ,x_msg_count OUT NOCOPY NUMBER
397: ,x_msg_data OUT NOCOPY VARCHAR2

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

390: PROCEDURE create_act_utilization(
391: p_api_version IN NUMBER
392: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
393: ,p_commit IN VARCHAR2 := fnd_api.g_false
394: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
395: ,x_return_status OUT NOCOPY VARCHAR2
396: ,x_msg_count OUT NOCOPY NUMBER
397: ,x_msg_data OUT NOCOPY VARCHAR2
398: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type

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

402:
403: --kdass - added for Bug 8726683
404: PROCEDURE create_act_utilization(
405: p_api_version IN NUMBER
406: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
407: ,p_commit IN VARCHAR2 := fnd_api.g_false
408: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
409: ,x_return_status OUT NOCOPY VARCHAR2
410: ,x_msg_count OUT NOCOPY NUMBER

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

403: --kdass - added for Bug 8726683
404: PROCEDURE create_act_utilization(
405: p_api_version IN NUMBER
406: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
407: ,p_commit IN VARCHAR2 := fnd_api.g_false
408: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
409: ,x_return_status OUT NOCOPY VARCHAR2
410: ,x_msg_count OUT NOCOPY NUMBER
411: ,x_msg_data OUT NOCOPY VARCHAR2

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

404: PROCEDURE create_act_utilization(
405: p_api_version IN NUMBER
406: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
407: ,p_commit IN VARCHAR2 := fnd_api.g_false
408: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
409: ,x_return_status OUT NOCOPY VARCHAR2
410: ,x_msg_count OUT NOCOPY NUMBER
411: ,x_msg_data OUT NOCOPY VARCHAR2
412: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type