92: /* Declare externally callable subprograms */
93:
94: PROCEDURE list_deliverable (
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_item_type IN VARCHAR2,
118: x_file_id_tbl OUT NOCOPY NUMBER_TABLE);
119:
120: PROCEDURE list_deliverable (
121: p_api_version IN NUMBER,
122: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
123: x_return_status OUT NOCOPY VARCHAR2,
124: x_msg_count OUT NOCOPY NUMBER,
125: x_msg_data OUT NOCOPY VARCHAR2,
126: p_category_id IN NUMBER,
152: -- Parameters:
153: -- IN:
154: -- p_api_version IN NUMBER Required
155: -- p_init_msg_list IN VARCHAR2 Optional
156: -- Default = FND_API.g_false
157: -- p_commit IN VARCHAR2 Optional
158: -- Default = FND_API.g_false
159: -- x_return_status OUT NOCOPY VARCHAR2
160: -- x_msg_count OUT NOCOPY NUMBER
154: -- p_api_version IN NUMBER Required
155: -- p_init_msg_list IN VARCHAR2 Optional
156: -- Default = FND_API.g_false
157: -- p_commit IN VARCHAR2 Optional
158: -- Default = FND_API.g_false
159: -- x_return_status OUT NOCOPY VARCHAR2
160: -- x_msg_count OUT NOCOPY NUMBER
161: -- x_msg_data OUT NOCOPY VARCHAR2
162: -- p_deliverable_rec IN OUT NOCOPY DELIVERABLE_REC_TYPE
167: -- End of comments
168:
169: PROCEDURE save_deliverable (
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
172: p_commit IN VARCHAR2 := FND_API.g_false,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
168:
169: PROCEDURE save_deliverable (
170: p_api_version IN NUMBER,
171: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
172: p_commit IN VARCHAR2 := FND_API.g_false,
173: x_return_status OUT NOCOPY VARCHAR2,
174: x_msg_count OUT NOCOPY NUMBER,
175: x_msg_data OUT NOCOPY VARCHAR2,
176: p_deliverable_rec IN OUT NOCOPY DELIVERABLE_REC_TYPE );
184: -- Parameters:
185: -- IN:
186: -- p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional
188: -- Default = FND_API.g_false
189: -- p_commit IN VARCHAR2 Optional
190: -- Default = FND_API.g_false
191: -- x_return_status OUT NOCOPY VARCHAR2
192: -- x_msg_count OUT NOCOPY NUMBER
186: -- p_api_version IN NUMBER Required
187: -- p_init_msg_list IN VARCHAR2 Optional
188: -- Default = FND_API.g_false
189: -- p_commit IN VARCHAR2 Optional
190: -- Default = FND_API.g_false
191: -- x_return_status OUT NOCOPY VARCHAR2
192: -- x_msg_count OUT NOCOPY NUMBER
193: -- x_msg_data OUT NOCOPY VARCHAR2
194: -- p_deliverable_tbl IN OUT NOCOPY DELIVERABLE_TBL_TYPE
199: -- End of comments
200:
201: PROCEDURE save_deliverable (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
200:
201: PROCEDURE save_deliverable (
202: p_api_version IN NUMBER,
203: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
204: p_commit IN VARCHAR2 := FND_API.g_false,
205: x_return_status OUT NOCOPY VARCHAR2,
206: x_msg_count OUT NOCOPY NUMBER,
207: x_msg_data OUT NOCOPY VARCHAR2,
208: p_deliverable_tbl IN OUT NOCOPY DELIVERABLE_TBL_TYPE );
217: -- Parameters:
218: -- IN:
219: -- p_api_version IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional
221: -- Default = FND_API.g_false
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = FND_API.g_false
224: -- x_return_status OUT NOCOPY VARCHAR2
225: -- x_msg_count OUT NOCOPY NUMBER
219: -- p_api_version IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional
221: -- Default = FND_API.g_false
222: -- p_commit IN VARCHAR2 Optional
223: -- Default = FND_API.g_false
224: -- x_return_status OUT NOCOPY VARCHAR2
225: -- x_msg_count OUT NOCOPY NUMBER
226: -- x_msg_data OUT NOCOPY VARCHAR2
227: -- p_dlv_ath_rec IN OUT NOCOPY DLV_ATH_REC_TYPE
232: -- End of comments
233:
234: PROCEDURE save_deliverable (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
237: p_commit IN VARCHAR2 := FND_API.g_false,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
233:
234: PROCEDURE save_deliverable (
235: p_api_version IN NUMBER,
236: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
237: p_commit IN VARCHAR2 := FND_API.g_false,
238: x_return_status OUT NOCOPY VARCHAR2,
239: x_msg_count OUT NOCOPY NUMBER,
240: x_msg_data OUT NOCOPY VARCHAR2,
241: p_dlv_ath_rec IN OUT NOCOPY DLV_ATH_REC_TYPE );
250: -- Parameters:
251: -- IN:
252: -- p_api_version IN NUMBER Required
253: -- p_init_msg_list IN VARCHAR2 Optional
254: -- Default = FND_API.g_false
255: -- p_commit IN VARCHAR2 Optional
256: -- Default = FND_API.g_false
257: -- x_return_status OUT NOCOPY VARCHAR2
258: -- x_msg_count OUT NOCOPY NUMBER
252: -- p_api_version IN NUMBER Required
253: -- p_init_msg_list IN VARCHAR2 Optional
254: -- Default = FND_API.g_false
255: -- p_commit IN VARCHAR2 Optional
256: -- Default = FND_API.g_false
257: -- x_return_status OUT NOCOPY VARCHAR2
258: -- x_msg_count OUT NOCOPY NUMBER
259: -- x_msg_data OUT NOCOPY VARCHAR2
260: -- p_dlv_ath_tbl IN OUT NOCOPY DLV_ATH_TBL_TYPE
265: -- End of comments
266:
267: PROCEDURE save_deliverable (
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
270: p_commit IN VARCHAR2 := FND_API.g_false,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
266:
267: PROCEDURE save_deliverable (
268: p_api_version IN NUMBER,
269: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
270: p_commit IN VARCHAR2 := FND_API.g_false,
271: x_return_status OUT NOCOPY VARCHAR2,
272: x_msg_count OUT NOCOPY NUMBER,
273: x_msg_data OUT NOCOPY VARCHAR2,
274: p_dlv_ath_tbl IN OUT NOCOPY DLV_ATH_TBL_TYPE );
283: -- Parameters:
284: -- IN:
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Optional
287: -- Default = FND_API.g_false
288: -- p_commit IN VARCHAR2 Optional
289: -- Default = FND_API.g_false
290: -- x_return_status OUT NOCOPY VARCHAR2
291: -- x_msg_count OUT NOCOPY NUMBER
285: -- p_api_version IN NUMBER Required
286: -- p_init_msg_list IN VARCHAR2 Optional
287: -- Default = FND_API.g_false
288: -- p_commit IN VARCHAR2 Optional
289: -- Default = FND_API.g_false
290: -- x_return_status OUT NOCOPY VARCHAR2
291: -- x_msg_count OUT NOCOPY NUMBER
292: -- x_msg_data OUT NOCOPY VARCHAR2
293: -- p_dlv_id_ver_tbl IN OUT NOCOPY DLV_ID_VER_TBL_TYPE
298: -- End of comments
299:
300: PROCEDURE delete_deliverable(
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
299:
300: PROCEDURE delete_deliverable(
301: p_api_version IN NUMBER,
302: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
303: p_commit IN VARCHAR2 := FND_API.g_false,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_dlv_id_ver_tbl IN OUT NOCOPY DLV_ID_VER_TBL_TYPE );