eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBE_QUOTE_MISC_PVT dependencies on FND_API

Line 147: -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

143:
144:
145: PROCEDURE getQuoteOwner(
146: p_api_version_number IN NUMBER
147: -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: -- ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_quote_header_Id IN NUMBER
150:
151: ,x_party_id OUT NOCOPY NUMBER

Line 148: -- ,p_commit IN VARCHAR2 := FND_API.G_FALSE

144:
145: PROCEDURE getQuoteOwner(
146: p_api_version_number IN NUMBER
147: -- ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
148: -- ,p_commit IN VARCHAR2 := FND_API.G_FALSE
149: ,p_quote_header_Id IN NUMBER
150:
151: ,x_party_id OUT NOCOPY NUMBER
152: ,x_cust_account_id OUT NOCOPY NUMBER

Line 160: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,

156: );
157:
158: PROCEDURE Get_Shared_Quote(
159: p_api_version_number IN NUMBER ,
160: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_quote_number IN NUMBER ,
162: p_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
163: x_quote_header_id OUT NOCOPY NUMBER ,
164: x_last_update_date OUT NOCOPY DATE ,

Line 162: p_quote_version IN NUMBER := FND_API.G_MISS_NUM ,

158: PROCEDURE Get_Shared_Quote(
159: p_api_version_number IN NUMBER ,
160: p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
161: p_quote_number IN NUMBER ,
162: p_quote_version IN NUMBER := FND_API.G_MISS_NUM ,
163: x_quote_header_id OUT NOCOPY NUMBER ,
164: x_last_update_date OUT NOCOPY DATE ,
165: x_return_status OUT NOCOPY VARCHAR2 ,
166: x_msg_count OUT NOCOPY NUMBER ,

Line 173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

169:
170: --- direct entry
171: PROCEDURE Load_Item_IDs(
172: p_api_version IN NUMBER := 1 ,
173: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
174: p_cust_id IN NUMBER ,
175: p_cust_item_number_tbl IN jtf_varchar2_table_100 ,
176: p_organization_id IN NUMBER ,
177: p_minisite_id IN NUMBER ,

Line 187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

183:
184: ---converting ShoppingList, saved cart, Quote to Active shopping cart
185: PROCEDURE Check_Item_IDs(
186: p_api_version IN NUMBER := 1 ,
187: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
188: p_cust_id IN NUMBER ,
189: p_organization_id IN NUMBER ,
190: p_minisite_id IN NUMBER ,
191: x_inventory_item_id_tbl IN OUT NOCOPY jtf_number_table ,

Line 201: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

197:
198: procedure get_load_errors(
199: X_reason_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
200: p_api_version IN NUMBER := 1.0 ,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
203: x_return_status OUT NOCOPY VARCHAR2 ,
204: x_msg_count OUT NOCOPY NUMBER ,
205: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 202: p_commit IN VARCHAR2 := FND_API.G_FALSE ,

198: procedure get_load_errors(
199: X_reason_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
200: p_api_version IN NUMBER := 1.0 ,
201: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
202: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
203: x_return_status OUT NOCOPY VARCHAR2 ,
204: x_msg_count OUT NOCOPY NUMBER ,
205: x_msg_data OUT NOCOPY VARCHAR2 ,
206: P_quote_header_id IN number := FND_API.G_MISS_NUM,

Line 206: P_quote_header_id IN number := FND_API.G_MISS_NUM,

202: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
203: x_return_status OUT NOCOPY VARCHAR2 ,
204: x_msg_count OUT NOCOPY NUMBER ,
205: x_msg_data OUT NOCOPY VARCHAR2 ,
206: P_quote_header_id IN number := FND_API.G_MISS_NUM,
207: P_Load_type IN number := FND_API.G_MISS_NUM,
208: P_quote_number IN number := FND_API.G_MISS_NUM,
209: P_quote_version IN number := FND_API.G_MISS_NUM,
210: P_party_id IN number := FND_API.G_MISS_NUM,

Line 207: P_Load_type IN number := FND_API.G_MISS_NUM,

203: x_return_status OUT NOCOPY VARCHAR2 ,
204: x_msg_count OUT NOCOPY NUMBER ,
205: x_msg_data OUT NOCOPY VARCHAR2 ,
206: P_quote_header_id IN number := FND_API.G_MISS_NUM,
207: P_Load_type IN number := FND_API.G_MISS_NUM,
208: P_quote_number IN number := FND_API.G_MISS_NUM,
209: P_quote_version IN number := FND_API.G_MISS_NUM,
210: P_party_id IN number := FND_API.G_MISS_NUM,
211: P_cust_account_id IN number := FND_API.G_MISS_NUM,

Line 208: P_quote_number IN number := FND_API.G_MISS_NUM,

204: x_msg_count OUT NOCOPY NUMBER ,
205: x_msg_data OUT NOCOPY VARCHAR2 ,
206: P_quote_header_id IN number := FND_API.G_MISS_NUM,
207: P_Load_type IN number := FND_API.G_MISS_NUM,
208: P_quote_number IN number := FND_API.G_MISS_NUM,
209: P_quote_version IN number := FND_API.G_MISS_NUM,
210: P_party_id IN number := FND_API.G_MISS_NUM,
211: P_cust_account_id IN number := FND_API.G_MISS_NUM,
212: P_retrieval_number IN number := FND_API.G_MISS_NUM,

Line 209: P_quote_version IN number := FND_API.G_MISS_NUM,

205: x_msg_data OUT NOCOPY VARCHAR2 ,
206: P_quote_header_id IN number := FND_API.G_MISS_NUM,
207: P_Load_type IN number := FND_API.G_MISS_NUM,
208: P_quote_number IN number := FND_API.G_MISS_NUM,
209: P_quote_version IN number := FND_API.G_MISS_NUM,
210: P_party_id IN number := FND_API.G_MISS_NUM,
211: P_cust_account_id IN number := FND_API.G_MISS_NUM,
212: P_retrieval_number IN number := FND_API.G_MISS_NUM,
213: P_share_type IN number := -1,

Line 210: P_party_id IN number := FND_API.G_MISS_NUM,

206: P_quote_header_id IN number := FND_API.G_MISS_NUM,
207: P_Load_type IN number := FND_API.G_MISS_NUM,
208: P_quote_number IN number := FND_API.G_MISS_NUM,
209: P_quote_version IN number := FND_API.G_MISS_NUM,
210: P_party_id IN number := FND_API.G_MISS_NUM,
211: P_cust_account_id IN number := FND_API.G_MISS_NUM,
212: P_retrieval_number IN number := FND_API.G_MISS_NUM,
213: P_share_type IN number := -1,
214: p_access_level IN number := 0

Line 211: P_cust_account_id IN number := FND_API.G_MISS_NUM,

207: P_Load_type IN number := FND_API.G_MISS_NUM,
208: P_quote_number IN number := FND_API.G_MISS_NUM,
209: P_quote_version IN number := FND_API.G_MISS_NUM,
210: P_party_id IN number := FND_API.G_MISS_NUM,
211: P_cust_account_id IN number := FND_API.G_MISS_NUM,
212: P_retrieval_number IN number := FND_API.G_MISS_NUM,
213: P_share_type IN number := -1,
214: p_access_level IN number := 0
215: );

Line 212: P_retrieval_number IN number := FND_API.G_MISS_NUM,

208: P_quote_number IN number := FND_API.G_MISS_NUM,
209: P_quote_version IN number := FND_API.G_MISS_NUM,
210: P_party_id IN number := FND_API.G_MISS_NUM,
211: P_cust_account_id IN number := FND_API.G_MISS_NUM,
212: P_retrieval_number IN number := FND_API.G_MISS_NUM,
213: P_share_type IN number := -1,
214: p_access_level IN number := 0
215: );
216:

Line 235: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

231: );
232:
233: PROCEDURE Get_Included_Warranties(
234: p_api_version_number IN NUMBER := 1,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,

Line 236: p_commit IN VARCHAR2 := FND_API.G_FALSE,

232:
233: PROCEDURE Get_Included_Warranties(
234: p_api_version_number IN NUMBER := 1,
235: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
236: p_commit IN VARCHAR2 := FND_API.G_FALSE,
237: x_return_status OUT NOCOPY VARCHAR2,
238: x_msg_count OUT NOCOPY NUMBER,
239: x_msg_data OUT NOCOPY VARCHAR2,
240: p_organization_id IN NUMBER := NULL,

Line 247: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

243: );
244:
245: PROCEDURE Get_Available_Services(
246: p_api_version_number IN NUMBER := 1,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,

Line 248: p_commit IN VARCHAR2 := FND_API.G_FALSE,

244:
245: PROCEDURE Get_Available_Services(
246: p_api_version_number IN NUMBER := 1,
247: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
248: p_commit IN VARCHAR2 := FND_API.G_FALSE,
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,
252: p_product_item_id IN NUMBER,

Line 261: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

257: );
258:
259: Procedure Duplicate_Line(
260: p_api_version_number IN NUMBER
261: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
262: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
263: ,X_Return_Status OUT NOCOPY VARCHAR2
264: ,X_Msg_Count OUT NOCOPY NUMBER
265: ,X_Msg_Data OUT NOCOPY VARCHAR2

Line 262: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

258:
259: Procedure Duplicate_Line(
260: p_api_version_number IN NUMBER
261: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
262: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
263: ,X_Return_Status OUT NOCOPY VARCHAR2
264: ,X_Msg_Count OUT NOCOPY NUMBER
265: ,X_Msg_Data OUT NOCOPY VARCHAR2
266: ,p_quote_header_id IN NUMBER

Line 277: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,

273: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
274: );
275:
276: FUNCTION getHdrPrcAdjNonPRGTbl (
277: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
278: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
279: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
280:
281: Procedure Split_Line(

Line 278: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

274: );
275:
276: FUNCTION getHdrPrcAdjNonPRGTbl (
277: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
278: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
279: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
280:
281: Procedure Split_Line(
282: p_api_version_number IN NUMBER

Line 283: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

279: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
280:
281: Procedure Split_Line(
282: p_api_version_number IN NUMBER
283: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
284: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
285: ,X_Return_Status OUT NOCOPY VARCHAR2
286: ,X_Msg_Count OUT NOCOPY NUMBER
287: ,X_Msg_Data OUT NOCOPY VARCHAR2

Line 284: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

280:
281: Procedure Split_Line(
282: p_api_version_number IN NUMBER
283: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
284: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
285: ,X_Return_Status OUT NOCOPY VARCHAR2
286: ,X_Msg_Count OUT NOCOPY NUMBER
287: ,X_Msg_Data OUT NOCOPY VARCHAR2
288: ,p_quote_header_id IN NUMBER

Line 292: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

288: ,p_quote_header_id IN NUMBER
289: ,p_qte_line_id IN NUMBER
290: ,p_quantities IN jtf_number_table
291: ,p_last_update_date IN OUT NOCOPY DATE
292: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
293: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
294: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
295: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
296: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE

Line 293: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

289: ,p_qte_line_id IN NUMBER
290: ,p_quantities IN jtf_number_table
291: ,p_last_update_date IN OUT NOCOPY DATE
292: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
293: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
294: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
295: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
296: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
297: );

Line 294: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

290: ,p_quantities IN jtf_number_table
291: ,p_last_update_date IN OUT NOCOPY DATE
292: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
293: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
294: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
295: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
296: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
297: );
298:

Line 295: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM

291: ,p_last_update_date IN OUT NOCOPY DATE
292: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
293: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
294: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
295: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
296: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
297: );
298:
299: PROCEDURE validate_quote(

Line 296: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE

292: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
293: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
294: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
295: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
296: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
297: );
298:
299: PROCEDURE validate_quote(
300: p_quote_header_id IN NUMBER

Line 301: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

297: );
298:
299: PROCEDURE validate_quote(
300: p_quote_header_id IN NUMBER
301: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
302: ,x_return_status OUT NOCOPY VARCHAR2
303: ,x_msg_count OUT NOCOPY NUMBER
304: ,x_msg_data OUT NOCOPY VARCHAR2);
305:

Line 308: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

304: ,x_msg_data OUT NOCOPY VARCHAR2);
305:
306: PROCEDURE Validate_User_Update(
307: p_api_version_number IN NUMBER := 1.0
308: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
309: ,p_quote_header_id IN NUMBER
310: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

Line 310: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

306: PROCEDURE Validate_User_Update(
307: p_api_version_number IN NUMBER := 1.0
308: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
309: ,p_quote_header_id IN NUMBER
310: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
313: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
314: ,p_privilege_type_code IN VARCHAR2 := 'F'

Line 311: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

307: p_api_version_number IN NUMBER := 1.0
308: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
309: ,p_quote_header_id IN NUMBER
310: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
313: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
314: ,p_privilege_type_code IN VARCHAR2 := 'F'
315: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

Line 312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

308: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
309: ,p_quote_header_id IN NUMBER
310: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
313: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
314: ,p_privilege_type_code IN VARCHAR2 := 'F'
315: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
316: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

Line 313: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE

309: ,p_quote_header_id IN NUMBER
310: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
311: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
313: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
314: ,p_privilege_type_code IN VARCHAR2 := 'F'
315: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
316: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
317: ,x_return_status OUT NOCOPY VARCHAR2

Line 315: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

311: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
313: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
314: ,p_privilege_type_code IN VARCHAR2 := 'F'
315: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
316: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
317: ,x_return_status OUT NOCOPY VARCHAR2
318: ,x_msg_count OUT NOCOPY NUMBER
319: ,x_msg_data OUT NOCOPY VARCHAR2);

Line 316: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

312: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
313: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
314: ,p_privilege_type_code IN VARCHAR2 := 'F'
315: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
316: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
317: ,x_return_status OUT NOCOPY VARCHAR2
318: ,x_msg_count OUT NOCOPY NUMBER
319: ,x_msg_data OUT NOCOPY VARCHAR2);
320:

Line 341: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

337: RETURN VARCHAR2;
338:
339: PROCEDURE Add_Attachment(
340: p_api_version_number IN NUMBER
341: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
342: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
343: ,p_category_id IN VARCHAR2
344: ,p_document_description IN VARCHAR2
345: ,p_datatype_id IN VARCHAR2

Line 342: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

338:
339: PROCEDURE Add_Attachment(
340: p_api_version_number IN NUMBER
341: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
342: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
343: ,p_category_id IN VARCHAR2
344: ,p_document_description IN VARCHAR2
345: ,p_datatype_id IN VARCHAR2
346: ,p_text IN LONG

Line 352: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

348: ,p_url IN VARCHAR2
349: ,p_function_name IN VARCHAR2 := null
350: ,p_quote_header_id IN NUMBER
351: ,p_media_id IN NUMBER
352: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
353: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
355: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
356: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

Line 353: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

349: ,p_function_name IN VARCHAR2 := null
350: ,p_quote_header_id IN NUMBER
351: ,p_media_id IN NUMBER
352: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
353: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
355: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
356: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
357: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

Line 354: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

350: ,p_quote_header_id IN NUMBER
351: ,p_media_id IN NUMBER
352: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
353: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
355: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
356: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
357: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
358: ,x_last_update_date OUT NOCOPY DATE

Line 355: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE

351: ,p_media_id IN NUMBER
352: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
353: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
355: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
356: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
357: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
358: ,x_last_update_date OUT NOCOPY DATE
359: ,x_return_status OUT NOCOPY VARCHAR2

Line 356: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

352: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
353: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
355: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
356: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
357: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
358: ,x_last_update_date OUT NOCOPY DATE
359: ,x_return_status OUT NOCOPY VARCHAR2
360: ,x_msg_count OUT NOCOPY NUMBER

Line 357: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

353: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
354: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
355: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
356: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
357: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
358: ,x_last_update_date OUT NOCOPY DATE
359: ,x_return_status OUT NOCOPY VARCHAR2
360: ,x_msg_count OUT NOCOPY NUMBER
361: ,x_msg_data OUT NOCOPY VARCHAR2

Line 366: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE

362: );
363:
364: PROCEDURE Delete_Attachment(
365: p_api_version_number IN NUMBER := 1.0
366: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368: ,p_quote_header_id IN NUMBER
369: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
370: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

Line 367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

363:
364: PROCEDURE Delete_Attachment(
365: p_api_version_number IN NUMBER := 1.0
366: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368: ,p_quote_header_id IN NUMBER
369: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
370: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
371: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

Line 370: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

366: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368: ,p_quote_header_id IN NUMBER
369: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
370: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
371: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
372: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
374: ,x_last_update_date OUT NOCOPY DATE

Line 371: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

367: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368: ,p_quote_header_id IN NUMBER
369: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
370: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
371: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
372: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
374: ,x_last_update_date OUT NOCOPY DATE
375: ,x_return_status OUT NOCOPY VARCHAR2

Line 372: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM

368: ,p_quote_header_id IN NUMBER
369: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
370: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
371: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
372: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
374: ,x_last_update_date OUT NOCOPY DATE
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER

Line 373: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

369: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
370: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
371: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
372: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
373: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
374: ,x_last_update_date OUT NOCOPY DATE
375: ,x_return_status OUT NOCOPY VARCHAR2
376: ,x_msg_count OUT NOCOPY NUMBER
377: ,x_msg_data OUT NOCOPY VARCHAR2