115: -- the sequence.
116: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
117: -- Raise exception for invalid flag.
118: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
119: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
120: ---------------------------------------------------------------------
121: PROCEDURE Create_Utilization(
122: p_api_version IN NUMBER
123: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
119: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
120: ---------------------------------------------------------------------
121: PROCEDURE Create_Utilization(
122: p_api_version IN NUMBER
123: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
124: ,p_commit IN VARCHAR2 := FND_API.g_false
125: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
126:
127: ,x_return_status OUT NOCOPY VARCHAR2
120: ---------------------------------------------------------------------
121: PROCEDURE Create_Utilization(
122: p_api_version IN NUMBER
123: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
124: ,p_commit IN VARCHAR2 := FND_API.g_false
125: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
126:
127: ,x_return_status OUT NOCOPY VARCHAR2
128: ,x_msg_count OUT NOCOPY NUMBER
121: PROCEDURE Create_Utilization(
122: p_api_version IN NUMBER
123: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
124: ,p_commit IN VARCHAR2 := FND_API.g_false
125: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
126:
127: ,x_return_status OUT NOCOPY VARCHAR2
128: ,x_msg_count OUT NOCOPY NUMBER
129: ,x_msg_data OUT NOCOPY VARCHAR2
126:
127: ,x_return_status OUT NOCOPY VARCHAR2
128: ,x_msg_count OUT NOCOPY NUMBER
129: ,x_msg_data OUT NOCOPY VARCHAR2
130: ,p_create_gl_entry IN VARCHAR2 := FND_API.g_false
131: ,p_utilization_rec IN utilization_rec_type
132: ,x_utilization_id OUT NOCOPY NUMBER
133: );
134:
148: -- 1. Raise exception if the object_version_number doesn't match.
149: --------------------------------------------------------------------
150: PROCEDURE Delete_Utilization(
151: p_api_version IN NUMBER
152: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
153: ,p_commit IN VARCHAR2 := FND_API.g_false
154:
155: ,x_return_status OUT NOCOPY VARCHAR2
156: ,x_msg_count OUT NOCOPY NUMBER
149: --------------------------------------------------------------------
150: PROCEDURE Delete_Utilization(
151: p_api_version IN NUMBER
152: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
153: ,p_commit IN VARCHAR2 := FND_API.g_false
154:
155: ,x_return_status OUT NOCOPY VARCHAR2
156: ,x_msg_count OUT NOCOPY NUMBER
157: ,x_msg_data OUT NOCOPY VARCHAR2
176: -- 1. Raise exception if the object_version_number doesn't match.
177: --------------------------------------------------------------------
178: PROCEDURE Lock_Utilization(
179: p_api_version IN NUMBER
180: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
181:
182: ,x_return_status OUT NOCOPY VARCHAR2
183: ,x_msg_count OUT NOCOPY NUMBER
184: ,x_msg_data OUT NOCOPY VARCHAR2
200: -- p_mode : determines what sort of validation is to be performed during update.
201: --
202: -- NOTES
203: -- 1. Raise exception if the object_version_number doesn't match.
204: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
205: -- that column won't be updated.
206: ----------------------------------------------------------------------
207: PROCEDURE Update_Utilization(
208: p_api_version IN NUMBER
205: -- that column won't be updated.
206: ----------------------------------------------------------------------
207: PROCEDURE Update_Utilization(
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:
213: ,x_return_status OUT NOCOPY VARCHAR2
206: ----------------------------------------------------------------------
207: PROCEDURE Update_Utilization(
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:
213: ,x_return_status OUT NOCOPY VARCHAR2
214: ,x_msg_count OUT NOCOPY NUMBER
207: PROCEDURE Update_Utilization(
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:
213: ,x_return_status OUT NOCOPY VARCHAR2
214: ,x_msg_count OUT NOCOPY NUMBER
215: ,x_msg_data OUT NOCOPY VARCHAR2
230: -- p_utilization_rec: the fund utilization record to be validated
231: --
232: -- NOTES
233: -- 1. p_utilization_rec should be the complete fund record. There
234: -- should not be any FND_API.g_miss_char/num/date in it.
235: ----------------------------------------------------------------------
236: PROCEDURE Validate_Utilization(
237: p_api_version IN NUMBER
238: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
234: -- should not be any FND_API.g_miss_char/num/date in it.
235: ----------------------------------------------------------------------
236: PROCEDURE Validate_Utilization(
237: p_api_version IN NUMBER
238: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
239: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
240:
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_msg_count OUT NOCOPY NUMBER
235: ----------------------------------------------------------------------
236: PROCEDURE Validate_Utilization(
237: p_api_version IN NUMBER
238: ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
239: ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
240:
241: ,x_return_status OUT NOCOPY VARCHAR2
242: ,x_msg_count OUT NOCOPY NUMBER
243: ,x_msg_data OUT NOCOPY VARCHAR2
273: -- Check the record level business rules.
274: --
275: -- PARAMETERS
276: -- p_utilization_rec: the record to be validated; may contain attributes
277: -- as FND_API.g_miss_char/num/date
278: -- p_complete_rec: the complete record after all "g_miss" items
279: -- have been replaced by current database values
280: ---------------------------------------------------------------------
281: PROCEDURE Check_Utilization_Record(
290: -- PROCEDURE
291: -- Init_Utilization_Rec
292: --
293: -- PURPOSE
294: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
295: ---------------------------------------------------------------------
296: PROCEDURE Init_Utilization_Rec(
297: x_utilization_rec OUT NOCOPY utilization_rec_type
298: );
303: -- Complete_Utilization_Rec
304: --
305: -- PURPOSE
306: -- For update_fund, some attributes may be passed in as
307: -- FND_API.g_miss_char/num/date if the user doesn't want to
308: -- update those attributes. This procedure will replace the
309: -- "g_miss" attributes with current database values.
310: --
311: -- PARAMETERS
309: -- "g_miss" attributes with current database values.
310: --
311: -- PARAMETERS
312: -- p_utilization_rec: the record which may contain attributes as
313: -- FND_API.g_miss_char/num/date
314: -- x_complete_rec: the complete record after all "g_miss" items
315: -- have been replaced by current database values
316: ---------------------------------------------------------------------
317: PROCEDURE Complete_Utilization_Rec(
338: ---------------------------------------------------------------------
339:
340: PROCEDURE create_act_utilization(
341: p_api_version IN NUMBER
342: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
343: ,p_commit IN VARCHAR2 := fnd_api.g_false
344: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
345: ,x_return_status OUT NOCOPY VARCHAR2
346: ,x_msg_count OUT NOCOPY NUMBER
339:
340: PROCEDURE create_act_utilization(
341: p_api_version IN NUMBER
342: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
343: ,p_commit IN VARCHAR2 := fnd_api.g_false
344: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
345: ,x_return_status OUT NOCOPY VARCHAR2
346: ,x_msg_count OUT NOCOPY NUMBER
347: ,x_msg_data OUT NOCOPY VARCHAR2
340: PROCEDURE create_act_utilization(
341: p_api_version IN NUMBER
342: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
343: ,p_commit IN VARCHAR2 := fnd_api.g_false
344: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
345: ,x_return_status OUT NOCOPY VARCHAR2
346: ,x_msg_count OUT NOCOPY NUMBER
347: ,x_msg_data OUT NOCOPY VARCHAR2
348: ,p_act_budgets_rec IN ozf_actbudgets_pvt.act_budgets_rec_type