62: /* Declare externally callable subprograms */
63:
64: PROCEDURE list_deliverable (
65: p_api_version IN NUMBER,
66: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
67: x_return_status OUT VARCHAR2,
68: x_msg_count OUT NUMBER,
69: x_msg_data OUT VARCHAR2,
70: p_item_type IN VARCHAR2,
88: x_file_id_tbl OUT NUMBER_TABLE);
89:
90: PROCEDURE list_deliverable (
91: p_api_version IN NUMBER,
92: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
93: x_return_status OUT VARCHAR2,
94: x_msg_count OUT NUMBER,
95: x_msg_data OUT VARCHAR2,
96: p_category_id IN NUMBER,
122: -- Parameters:
123: -- IN:
124: -- p_api_version IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional
126: -- Default = FND_API.g_false
127: -- p_commit IN VARCHAR2 Optional
128: -- Default = FND_API.g_false
129: -- x_return_status OUT VARCHAR2
130: -- x_msg_count OUT NUMBER
124: -- p_api_version IN NUMBER Required
125: -- p_init_msg_list IN VARCHAR2 Optional
126: -- Default = FND_API.g_false
127: -- p_commit IN VARCHAR2 Optional
128: -- Default = FND_API.g_false
129: -- x_return_status OUT VARCHAR2
130: -- x_msg_count OUT NUMBER
131: -- x_msg_data OUT VARCHAR2
132: -- p_deliverable_rec IN OUT DELIVERABLE_REC_TYPE
137: -- End of comments
138:
139: PROCEDURE save_deliverable (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
142: p_commit IN VARCHAR2 := FND_API.g_false,
143: x_return_status OUT VARCHAR2,
144: x_msg_count OUT NUMBER,
145: x_msg_data OUT VARCHAR2,
138:
139: PROCEDURE save_deliverable (
140: p_api_version IN NUMBER,
141: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
142: p_commit IN VARCHAR2 := FND_API.g_false,
143: x_return_status OUT VARCHAR2,
144: x_msg_count OUT NUMBER,
145: x_msg_data OUT VARCHAR2,
146: p_deliverable_rec IN OUT DELIVERABLE_REC_TYPE );
154: -- Parameters:
155: -- IN:
156: -- p_api_version IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional
158: -- Default = FND_API.g_false
159: -- p_commit IN VARCHAR2 Optional
160: -- Default = FND_API.g_false
161: -- x_return_status OUT VARCHAR2
162: -- x_msg_count OUT NUMBER
156: -- p_api_version IN NUMBER Required
157: -- p_init_msg_list IN VARCHAR2 Optional
158: -- Default = FND_API.g_false
159: -- p_commit IN VARCHAR2 Optional
160: -- Default = FND_API.g_false
161: -- x_return_status OUT VARCHAR2
162: -- x_msg_count OUT NUMBER
163: -- x_msg_data OUT VARCHAR2
164: -- p_deliverable_tbl IN OUT DELIVERABLE_TBL_TYPE
169: -- End of comments
170:
171: PROCEDURE save_deliverable (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
174: p_commit IN VARCHAR2 := FND_API.g_false,
175: x_return_status OUT VARCHAR2,
176: x_msg_count OUT NUMBER,
177: x_msg_data OUT VARCHAR2,
170:
171: PROCEDURE save_deliverable (
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
174: p_commit IN VARCHAR2 := FND_API.g_false,
175: x_return_status OUT VARCHAR2,
176: x_msg_count OUT NUMBER,
177: x_msg_data OUT VARCHAR2,
178: p_deliverable_tbl IN OUT DELIVERABLE_TBL_TYPE );
187: -- Parameters:
188: -- IN:
189: -- p_api_version IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default = FND_API.g_false
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.g_false
194: -- x_return_status OUT VARCHAR2
195: -- x_msg_count OUT NUMBER
189: -- p_api_version IN NUMBER Required
190: -- p_init_msg_list IN VARCHAR2 Optional
191: -- Default = FND_API.g_false
192: -- p_commit IN VARCHAR2 Optional
193: -- Default = FND_API.g_false
194: -- x_return_status OUT VARCHAR2
195: -- x_msg_count OUT NUMBER
196: -- x_msg_data OUT VARCHAR2
197: -- p_dlv_ath_rec IN OUT DLV_ATH_REC_TYPE
202: -- End of comments
203:
204: PROCEDURE save_deliverable (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_commit IN VARCHAR2 := FND_API.g_false,
208: x_return_status OUT VARCHAR2,
209: x_msg_count OUT NUMBER,
210: x_msg_data OUT VARCHAR2,
203:
204: PROCEDURE save_deliverable (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
207: p_commit IN VARCHAR2 := FND_API.g_false,
208: x_return_status OUT VARCHAR2,
209: x_msg_count OUT NUMBER,
210: x_msg_data OUT VARCHAR2,
211: p_dlv_ath_rec IN OUT DLV_ATH_REC_TYPE );
220: -- Parameters:
221: -- IN:
222: -- p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional
224: -- Default = FND_API.g_false
225: -- p_commit IN VARCHAR2 Optional
226: -- Default = FND_API.g_false
227: -- x_return_status OUT VARCHAR2
228: -- x_msg_count OUT NUMBER
222: -- p_api_version IN NUMBER Required
223: -- p_init_msg_list IN VARCHAR2 Optional
224: -- Default = FND_API.g_false
225: -- p_commit IN VARCHAR2 Optional
226: -- Default = FND_API.g_false
227: -- x_return_status OUT VARCHAR2
228: -- x_msg_count OUT NUMBER
229: -- x_msg_data OUT VARCHAR2
230: -- p_dlv_ath_tbl IN OUT DLV_ATH_TBL_TYPE
235: -- End of comments
236:
237: PROCEDURE save_deliverable (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
240: p_commit IN VARCHAR2 := FND_API.g_false,
241: x_return_status OUT VARCHAR2,
242: x_msg_count OUT NUMBER,
243: x_msg_data OUT VARCHAR2,
236:
237: PROCEDURE save_deliverable (
238: p_api_version IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
240: p_commit IN VARCHAR2 := FND_API.g_false,
241: x_return_status OUT VARCHAR2,
242: x_msg_count OUT NUMBER,
243: x_msg_data OUT VARCHAR2,
244: p_dlv_ath_tbl IN OUT DLV_ATH_TBL_TYPE );
253: -- Parameters:
254: -- IN:
255: -- p_api_version IN NUMBER Required
256: -- p_init_msg_list IN VARCHAR2 Optional
257: -- Default = FND_API.g_false
258: -- p_commit IN VARCHAR2 Optional
259: -- Default = FND_API.g_false
260: -- x_return_status OUT VARCHAR2
261: -- x_msg_count OUT NUMBER
255: -- p_api_version IN NUMBER Required
256: -- p_init_msg_list IN VARCHAR2 Optional
257: -- Default = FND_API.g_false
258: -- p_commit IN VARCHAR2 Optional
259: -- Default = FND_API.g_false
260: -- x_return_status OUT VARCHAR2
261: -- x_msg_count OUT NUMBER
262: -- x_msg_data OUT VARCHAR2
263: -- p_dlv_id_ver_tbl IN OUT DLV_ID_VER_TBL_TYPE
268: -- End of comments
269:
270: PROCEDURE delete_deliverable(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
273: p_commit IN VARCHAR2 := FND_API.g_false,
274: x_return_status OUT VARCHAR2,
275: x_msg_count OUT NUMBER,
276: x_msg_data OUT VARCHAR2,
269:
270: PROCEDURE delete_deliverable(
271: p_api_version IN NUMBER,
272: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
273: p_commit IN VARCHAR2 := FND_API.g_false,
274: x_return_status OUT VARCHAR2,
275: x_msg_count OUT NUMBER,
276: x_msg_data OUT VARCHAR2,
277: p_dlv_id_ver_tbl IN OUT DLV_ID_VER_TBL_TYPE );