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 188: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,

184:
185: procedure get_load_errors(
186: X_reason_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
187: p_api_version IN NUMBER := 1.0 ,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,

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

185: procedure get_load_errors(
186: X_reason_code OUT NOCOPY JTF_VARCHAR2_TABLE_100,
187: p_api_version IN NUMBER := 1.0 ,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE ,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: P_quote_header_id IN number := FND_API.G_MISS_NUM,

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

189: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: P_quote_header_id IN number := FND_API.G_MISS_NUM,
194: P_Load_type IN number := FND_API.G_MISS_NUM,
195: P_quote_number IN number := FND_API.G_MISS_NUM,
196: P_quote_version IN number := FND_API.G_MISS_NUM,
197: P_party_id IN number := FND_API.G_MISS_NUM,

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

190: x_return_status OUT NOCOPY VARCHAR2 ,
191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: P_quote_header_id IN number := FND_API.G_MISS_NUM,
194: P_Load_type IN number := FND_API.G_MISS_NUM,
195: P_quote_number IN number := FND_API.G_MISS_NUM,
196: P_quote_version IN number := FND_API.G_MISS_NUM,
197: P_party_id IN number := FND_API.G_MISS_NUM,
198: P_cust_account_id IN number := FND_API.G_MISS_NUM,

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

191: x_msg_count OUT NOCOPY NUMBER ,
192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: P_quote_header_id IN number := FND_API.G_MISS_NUM,
194: P_Load_type IN number := FND_API.G_MISS_NUM,
195: P_quote_number IN number := FND_API.G_MISS_NUM,
196: P_quote_version IN number := FND_API.G_MISS_NUM,
197: P_party_id IN number := FND_API.G_MISS_NUM,
198: P_cust_account_id IN number := FND_API.G_MISS_NUM,
199: P_retrieval_number IN number := FND_API.G_MISS_NUM,

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

192: x_msg_data OUT NOCOPY VARCHAR2 ,
193: P_quote_header_id IN number := FND_API.G_MISS_NUM,
194: P_Load_type IN number := FND_API.G_MISS_NUM,
195: P_quote_number IN number := FND_API.G_MISS_NUM,
196: P_quote_version IN number := FND_API.G_MISS_NUM,
197: P_party_id IN number := FND_API.G_MISS_NUM,
198: P_cust_account_id IN number := FND_API.G_MISS_NUM,
199: P_retrieval_number IN number := FND_API.G_MISS_NUM,
200: P_share_type IN number := -1,

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

193: P_quote_header_id IN number := FND_API.G_MISS_NUM,
194: P_Load_type IN number := FND_API.G_MISS_NUM,
195: P_quote_number IN number := FND_API.G_MISS_NUM,
196: P_quote_version IN number := FND_API.G_MISS_NUM,
197: P_party_id IN number := FND_API.G_MISS_NUM,
198: P_cust_account_id IN number := FND_API.G_MISS_NUM,
199: P_retrieval_number IN number := FND_API.G_MISS_NUM,
200: P_share_type IN number := -1,
201: p_access_level IN number := 0

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

194: P_Load_type IN number := FND_API.G_MISS_NUM,
195: P_quote_number IN number := FND_API.G_MISS_NUM,
196: P_quote_version IN number := FND_API.G_MISS_NUM,
197: P_party_id IN number := FND_API.G_MISS_NUM,
198: P_cust_account_id IN number := FND_API.G_MISS_NUM,
199: P_retrieval_number IN number := FND_API.G_MISS_NUM,
200: P_share_type IN number := -1,
201: p_access_level IN number := 0
202: );

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

195: P_quote_number IN number := FND_API.G_MISS_NUM,
196: P_quote_version IN number := FND_API.G_MISS_NUM,
197: P_party_id IN number := FND_API.G_MISS_NUM,
198: P_cust_account_id IN number := FND_API.G_MISS_NUM,
199: P_retrieval_number IN number := FND_API.G_MISS_NUM,
200: P_share_type IN number := -1,
201: p_access_level IN number := 0
202: );
203:

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

218: );
219:
220: PROCEDURE Get_Included_Warranties(
221: p_api_version_number IN NUMBER := 1,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
223: p_commit IN VARCHAR2 := 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,

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

219:
220: PROCEDURE Get_Included_Warranties(
221: p_api_version_number IN NUMBER := 1,
222: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
223: p_commit IN VARCHAR2 := 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_organization_id IN NUMBER := NULL,

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

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

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

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

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

244: );
245:
246: Procedure Duplicate_Line(
247: p_api_version_number IN NUMBER
248: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
249: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
250: ,X_Return_Status OUT NOCOPY VARCHAR2
251: ,X_Msg_Count OUT NOCOPY NUMBER
252: ,X_Msg_Data OUT NOCOPY VARCHAR2

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

245:
246: Procedure Duplicate_Line(
247: p_api_version_number IN NUMBER
248: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
249: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
250: ,X_Return_Status OUT NOCOPY VARCHAR2
251: ,X_Msg_Count OUT NOCOPY NUMBER
252: ,X_Msg_Data OUT NOCOPY VARCHAR2
253: ,p_quote_header_id IN NUMBER

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

260: ,x_ln_price_adj_tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
261: );
262:
263: FUNCTION getHdrPrcAdjNonPRGTbl (
264: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
265: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
266: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
267:
268: Procedure Split_Line(

Line 265: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM

261: );
262:
263: FUNCTION getHdrPrcAdjNonPRGTbl (
264: P_Qte_Header_Id IN NUMBER := FND_API.G_MISS_NUM,
265: P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
266: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
267:
268: Procedure Split_Line(
269: p_api_version_number IN NUMBER

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

266: ) RETURN ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
267:
268: Procedure Split_Line(
269: p_api_version_number IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
272: ,X_Return_Status OUT NOCOPY VARCHAR2
273: ,X_Msg_Count OUT NOCOPY NUMBER
274: ,X_Msg_Data OUT NOCOPY VARCHAR2

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

267:
268: Procedure Split_Line(
269: p_api_version_number IN NUMBER
270: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
271: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
272: ,X_Return_Status OUT NOCOPY VARCHAR2
273: ,X_Msg_Count OUT NOCOPY NUMBER
274: ,X_Msg_Data OUT NOCOPY VARCHAR2
275: ,p_quote_header_id IN NUMBER

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

275: ,p_quote_header_id IN NUMBER
276: ,p_qte_line_id IN NUMBER
277: ,p_quantities IN jtf_number_table
278: ,p_last_update_date IN OUT NOCOPY DATE
279: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
281: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
282: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
283: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE

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

276: ,p_qte_line_id IN NUMBER
277: ,p_quantities IN jtf_number_table
278: ,p_last_update_date IN OUT NOCOPY DATE
279: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
281: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
282: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
283: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
284: );

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

277: ,p_quantities IN jtf_number_table
278: ,p_last_update_date IN OUT NOCOPY DATE
279: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
281: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
282: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
283: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
284: );
285:

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

278: ,p_last_update_date IN OUT NOCOPY DATE
279: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
281: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
282: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
283: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
284: );
285:
286: PROCEDURE validate_quote(

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

279: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
280: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
281: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
282: ,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
283: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
284: );
285:
286: PROCEDURE validate_quote(
287: p_quote_header_id IN NUMBER

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

284: );
285:
286: PROCEDURE validate_quote(
287: p_quote_header_id IN NUMBER
288: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
289: ,x_return_status OUT NOCOPY VARCHAR2
290: ,x_msg_count OUT NOCOPY NUMBER
291: ,x_msg_data OUT NOCOPY VARCHAR2);
292:

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

291: ,x_msg_data OUT NOCOPY VARCHAR2);
292:
293: PROCEDURE Validate_User_Update(
294: p_api_version_number IN NUMBER := 1.0
295: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
296: ,p_quote_header_id IN NUMBER
297: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
299: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM

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

293: PROCEDURE Validate_User_Update(
294: p_api_version_number IN NUMBER := 1.0
295: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
296: ,p_quote_header_id IN NUMBER
297: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
299: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
300: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
301: ,p_privilege_type_code IN VARCHAR2 := 'F'

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

294: p_api_version_number IN NUMBER := 1.0
295: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
296: ,p_quote_header_id IN NUMBER
297: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
299: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
300: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
301: ,p_privilege_type_code IN VARCHAR2 := 'F'
302: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

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

295: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
296: ,p_quote_header_id IN NUMBER
297: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
299: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
300: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
301: ,p_privilege_type_code IN VARCHAR2 := 'F'
302: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
303: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

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

296: ,p_quote_header_id IN NUMBER
297: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
298: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
299: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
300: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
301: ,p_privilege_type_code IN VARCHAR2 := 'F'
302: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
303: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
304: ,x_return_status OUT NOCOPY VARCHAR2

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

298: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
299: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
300: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
301: ,p_privilege_type_code IN VARCHAR2 := 'F'
302: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
303: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
304: ,x_return_status OUT NOCOPY VARCHAR2
305: ,x_msg_count OUT NOCOPY NUMBER
306: ,x_msg_data OUT NOCOPY VARCHAR2);

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

299: ,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
300: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
301: ,p_privilege_type_code IN VARCHAR2 := 'F'
302: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
303: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
304: ,x_return_status OUT NOCOPY VARCHAR2
305: ,x_msg_count OUT NOCOPY NUMBER
306: ,x_msg_data OUT NOCOPY VARCHAR2);
307:

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

324: RETURN VARCHAR2;
325:
326: PROCEDURE Add_Attachment(
327: p_api_version_number IN NUMBER
328: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
329: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
330: ,p_category_id IN VARCHAR2
331: ,p_document_description IN VARCHAR2
332: ,p_datatype_id IN VARCHAR2

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

325:
326: PROCEDURE Add_Attachment(
327: p_api_version_number IN NUMBER
328: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
329: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
330: ,p_category_id IN VARCHAR2
331: ,p_document_description IN VARCHAR2
332: ,p_datatype_id IN VARCHAR2
333: ,p_text IN LONG

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

335: ,p_url IN VARCHAR2
336: ,p_function_name IN VARCHAR2 := null
337: ,p_quote_header_id IN NUMBER
338: ,p_media_id IN NUMBER
339: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
340: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
341: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
342: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
343: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

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

336: ,p_function_name IN VARCHAR2 := null
337: ,p_quote_header_id IN NUMBER
338: ,p_media_id IN NUMBER
339: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
340: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
341: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
342: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
343: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
344: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM

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

337: ,p_quote_header_id IN NUMBER
338: ,p_media_id IN NUMBER
339: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
340: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
341: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
342: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
343: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
344: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
345: ,x_last_update_date OUT NOCOPY DATE

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

338: ,p_media_id IN NUMBER
339: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
340: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
341: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
342: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
343: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
344: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
345: ,x_last_update_date OUT NOCOPY DATE
346: ,x_return_status OUT NOCOPY VARCHAR2

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

339: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
340: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
341: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
342: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
343: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
344: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
345: ,x_last_update_date OUT NOCOPY DATE
346: ,x_return_status OUT NOCOPY VARCHAR2
347: ,x_msg_count OUT NOCOPY NUMBER

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

340: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
341: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
342: ,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
343: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
344: ,p_save_type IN NUMBER := FND_API.G_MISS_NUM
345: ,x_last_update_date OUT NOCOPY DATE
346: ,x_return_status OUT NOCOPY VARCHAR2
347: ,x_msg_count OUT NOCOPY NUMBER
348: ,x_msg_data OUT NOCOPY VARCHAR2

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

349: );
350:
351: PROCEDURE Delete_Attachment(
352: p_api_version_number IN NUMBER := 1.0
353: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
354: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
355: ,p_quote_header_id IN NUMBER
356: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
357: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE

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

350:
351: PROCEDURE Delete_Attachment(
352: p_api_version_number IN NUMBER := 1.0
353: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
354: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
355: ,p_quote_header_id IN NUMBER
356: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
357: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
358: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM

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

353: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
354: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
355: ,p_quote_header_id IN NUMBER
356: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
357: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
358: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
359: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
360: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
361: ,x_last_update_date OUT NOCOPY DATE

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

354: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
355: ,p_quote_header_id IN NUMBER
356: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
357: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
358: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
359: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
360: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
361: ,x_last_update_date OUT NOCOPY DATE
362: ,x_return_status OUT NOCOPY VARCHAR2

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

355: ,p_quote_header_id IN NUMBER
356: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
357: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
358: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
359: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
360: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
361: ,x_last_update_date OUT NOCOPY DATE
362: ,x_return_status OUT NOCOPY VARCHAR2
363: ,x_msg_count OUT NOCOPY NUMBER

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

356: ,p_quote_attachment_ids IN JTF_VARCHAR2_TABLE_100
357: ,p_last_update_date IN DATE := FND_API.G_MISS_DATE
358: ,p_party_id IN NUMBER := FND_API.G_MISS_NUM
359: ,p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM
360: ,p_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
361: ,x_last_update_date OUT NOCOPY DATE
362: ,x_return_status OUT NOCOPY VARCHAR2
363: ,x_msg_count OUT NOCOPY NUMBER
364: ,x_msg_data OUT NOCOPY VARCHAR2