110: -- the sequence.
111: -- 4. If a flag column is passed in, check if it is 'Y' or 'N'.
112: -- Raise exception for invalid flag.
113: -- 5. If a flag column is not passed in, default it to 'Y' or 'N'.
114: -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
115: ---------------------------------------------------------------------
116:
117: PROCEDURE create_deliverable
118: (
116:
117: PROCEDURE create_deliverable
118: (
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
121: p_commit IN VARCHAR2 := FND_API.g_false,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123:
124: x_return_status OUT NOCOPY VARCHAR2,
117: PROCEDURE create_deliverable
118: (
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
121: p_commit IN VARCHAR2 := FND_API.g_false,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123:
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
118: (
119: p_api_version IN NUMBER,
120: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
121: p_commit IN VARCHAR2 := FND_API.g_false,
122: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
123:
124: x_return_status OUT NOCOPY VARCHAR2,
125: x_msg_count OUT NOCOPY NUMBER,
126: x_msg_data OUT NOCOPY VARCHAR2,
147:
148: PROCEDURE delete_deliverable
149: (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153:
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
148: PROCEDURE delete_deliverable
149: (
150: p_api_version IN NUMBER,
151: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
152: p_commit IN VARCHAR2 := FND_API.g_false,
153:
154: x_return_status OUT NOCOPY VARCHAR2,
155: x_msg_count OUT NOCOPY NUMBER,
156: x_msg_data OUT NOCOPY VARCHAR2,
176:
177: PROCEDURE lock_deliverable
178: (
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,
199: -- p_deliv_rec: the record with new items
200: --
201: -- NOTES
202: -- 1. Raise exception if the object_version_number doesn't match.
203: -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
204: -- that column won't be updated.
205: ----------------------------------------------------------------------
206:
207: PROCEDURE update_deliverable
206:
207: PROCEDURE update_deliverable
208: (
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
211: p_commit IN VARCHAR2 := FND_API.g_false,
212: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
213:
214: x_return_status OUT NOCOPY VARCHAR2,
207: PROCEDURE update_deliverable
208: (
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
211: p_commit IN VARCHAR2 := FND_API.g_false,
212: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
213:
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
208: (
209: p_api_version IN NUMBER,
210: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
211: p_commit IN VARCHAR2 := FND_API.g_false,
212: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
213:
214: x_return_status OUT NOCOPY VARCHAR2,
215: x_msg_count OUT NOCOPY NUMBER,
216: x_msg_data OUT NOCOPY VARCHAR2,
229: -- p_deliv_rec: the deliverable record to be validated
230: --
231: -- NOTES
232: -- 1. p_deliv_rec should be the complete deliverable record. There
233: -- should not be any FND_API.g_miss_char/num/date in it.
234: ----------------------------------------------------------------------
235:
236: PROCEDURE validate_deliverable
237: (
235:
236: PROCEDURE validate_deliverable
237: (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
240: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
241: p_validation_mode IN VARCHAR2 ,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
236: PROCEDURE validate_deliverable
237: (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
240: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
241: p_validation_mode IN VARCHAR2 ,
242: x_return_status OUT NOCOPY VARCHAR2,
243: x_msg_count OUT NOCOPY NUMBER,
244: x_msg_data OUT NOCOPY VARCHAR2,
274: -- Check the record level business rules.
275: --
276: -- PARAMETERS
277: -- p_deliv_rec: the record to be validated; may contain attributes
278: -- as FND_API.g_miss_char/num/date
279: -- p_complete_rec: the complete record after all "g_miss" items
280: -- have been replaced by current database values
281: ---------------------------------------------------------------------
282:
291: -- PROCEDURE
292: -- init_deliv_rec
293: --
294: -- PURPOSE
295: -- Initialize all attributes to be FND_API.g_miss_char/num/date.
296: ---------------------------------------------------------------------
297:
298: PROCEDURE init_deliv_rec
299: (
306: -- complete_deliv_rec
307: --
308: -- PURPOSE
309: -- For update_deliverable, some attributes may be passed in as
310: -- FND_API.g_miss_char/num/date if the user doesn't want to
311: -- update those attributes. This procedure will replace the
312: -- "g_miss" attributes with current database values.
313: --
314: -- PARAMETERS
312: -- "g_miss" attributes with current database values.
313: --
314: -- PARAMETERS
315: -- p_deliv_rec: the record which may contain attributes as
316: -- FND_API.g_miss_char/num/date
317: -- x_complete_rec: the complete record after all "g_miss" items
318: -- have been replaced by current database values
319: ---------------------------------------------------------------------
320: PROCEDURE complete_deliv_rec