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
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
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
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
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:
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
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
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
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'
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
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
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
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
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
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
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
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
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
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
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(
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: );
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
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(
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
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
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
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
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
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