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.ASO_QUOTE_HEADERS_PVT dependencies on FND_API

Line 26: Price_List_Id NUMBER := FND_API.G_MISS_NUM

22:
23: TYPE Instance_Rec_Type IS RECORD
24: (
25: Instance_id NUMBER,
26: Price_List_Id NUMBER := FND_API.G_MISS_NUM
27: );
28: G_MISS_Instance_Rec Instance_Rec_Type;
29:
30: TYPE Instance_Tbl_Type IS TABLE OF Instance_Rec_Type INDEX BY BINARY_INTEGER;

Line 45: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

41: -- Pre-Req :
42: -- Parameters:
43: -- IN
44: -- p_api_version_number IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
46: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
47: -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
48: --
49: -- OUT:

Line 46: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

42: -- Parameters:
43: -- IN
44: -- p_api_version_number IN NUMBER Required
45: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
46: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
47: -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
48: --
49: -- OUT:
50: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 61: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

57: -- End of Comments
58: --
59: PROCEDURE Create_quote(
60: P_Api_Version_Number IN NUMBER,
61: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
62: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
65: := ASO_QUOTE_PUB.G_Miss_Control_Rec,

Line 62: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

58: --
59: PROCEDURE Create_quote(
60: P_Api_Version_Number IN NUMBER,
61: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
62: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
65: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
66: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

Line 63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

59: PROCEDURE Create_quote(
60: P_Api_Version_Number IN NUMBER,
61: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
62: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
63: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
64: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
65: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
66: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
67: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

Line 155: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

151: -- Pre-Req :
152: -- Parameters:
153: -- IN
154: -- p_api_version_number IN NUMBER Required
155: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
156: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
158: -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
159: --

Line 156: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

152: -- Parameters:
153: -- IN
154: -- p_api_version_number IN NUMBER Required
155: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
156: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
157: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
158: -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
159: --
160: -- OUT:

Line 174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

170: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
171:
172: PROCEDURE Update_quote(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
178: := ASO_QUOTE_PUB.G_Miss_Control_Rec,

Line 175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

171:
172: PROCEDURE Update_quote(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
178: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
179: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

Line 176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

172: PROCEDURE Update_quote(
173: P_Api_Version_Number IN NUMBER,
174: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
175: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
176: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
177: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
178: := ASO_QUOTE_PUB.G_Miss_Control_Rec,
179: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
180: := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

Line 268: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

264: -- Pre-Req :
265: -- Parameters:
266: -- IN
267: -- p_api_version_number IN NUMBER Required
268: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
269: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
270: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
271: -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
272: --

Line 269: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

265: -- Parameters:
266: -- IN
267: -- p_api_version_number IN NUMBER Required
268: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
269: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
270: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
271: -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
272: --
273: -- OUT:

Line 287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

283: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
284: -- The Master delete procedure may not be needed depends on different business requirements.
285: PROCEDURE Delete_quote(
286: P_Api_Version_Number IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
289: P_Qte_Header_Id IN NUMBER,
290: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
291: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 288: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

284: -- The Master delete procedure may not be needed depends on different business requirements.
285: PROCEDURE Delete_quote(
286: P_Api_Version_Number IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
289: P_Qte_Header_Id IN NUMBER,
290: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
291: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
292: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 304: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

300: -- Pre-Req :
301: -- Parameters:
302: -- IN
303: -- p_api_version_number IN NUMBER Required
304: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
305: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
306: --
307: -- OUT NOCOPY /* file.sql.39 change */ :
308: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 305: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

301: -- Parameters:
302: -- IN
303: -- p_api_version_number IN NUMBER Required
304: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
305: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
306: --
307: -- OUT NOCOPY /* file.sql.39 change */ :
308: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
309: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

315: -- End of Comments
316: --
317: PROCEDURE Copy_quote(
318: P_Api_Version_Number IN NUMBER,
319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: P_Qte_Header_Id IN NUMBER,

Line 320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

316: --
317: PROCEDURE Copy_quote(
318: P_Api_Version_Number IN NUMBER,
319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: P_Qte_Header_Id IN NUMBER,
324: P_Last_Update_Date IN DATE,

Line 322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

318: P_Api_Version_Number IN NUMBER,
319: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
320: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
321: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: P_Qte_Header_Id IN NUMBER,
324: P_Last_Update_Date IN DATE,
325: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
326: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,

Line 325: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,

321: P_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: P_Qte_Header_Id IN NUMBER,
324: P_Last_Update_Date IN DATE,
325: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
326: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
327: P_Qte_Status_Id IN NUMBER := NULL,
328: P_Qte_Number IN NUMBER := NULL,
329: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 326: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,

322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: P_Qte_Header_Id IN NUMBER,
324: P_Last_Update_Date IN DATE,
325: P_Copy_Only_Header IN VARCHAR2 := FND_API.G_FALSE,
326: P_New_Version IN VARCHAR2 := FND_API.G_FALSE,
327: P_Qte_Status_Id IN NUMBER := NULL,
328: P_Qte_Number IN NUMBER := NULL,
329: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
330: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 345: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

341: -- Pre-Req :
342: -- Parameters:
343: -- IN
344: -- p_api_version_number IN NUMBER Required
345: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
346: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
347: -- OUT:
348: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
349: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 346: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

342: -- Parameters:
343: -- IN
344: -- p_api_version_number IN NUMBER Required
345: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
346: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
347: -- OUT:
348: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
349: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
350: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 359: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

355: -- End of Comments
356: --
357: PROCEDURE Validate_quote(
358: P_Api_Version_Number IN NUMBER,
359: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
360: P_Qte_Header_Id IN NUMBER,
361: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
362: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
363: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 375: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

371: -- Pre-Req :
372: -- Parameters:
373: -- IN
374: -- p_api_version_number IN NUMBER Required
375: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
376: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
377: -- OUT:
378: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
379: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 376: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

372: -- Parameters:
373: -- IN
374: -- p_api_version_number IN NUMBER Required
375: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
376: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
377: -- OUT:
378: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
379: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
380: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 390: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

386: --
387: PROCEDURE Submit_Quote
388: (
389: P_Api_Version_Number IN NUMBER,
390: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
392: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
393: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
394: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,

Line 391: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

387: PROCEDURE Submit_Quote
388: (
389: P_Api_Version_Number IN NUMBER,
390: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
392: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
393: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
394: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
395: P_Qte_Header_Id IN NUMBER,

Line 392: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

388: (
389: P_Api_Version_Number IN NUMBER,
390: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
391: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
392: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
393: p_control_rec IN ASO_QUOTE_PUB.SUBMIT_CONTROL_REC_TYPE
394: := ASO_QUOTE_PUB.G_MISS_SUBMIT_CONTROL_REC,
395: P_Qte_Header_Id IN NUMBER,
396: X_Order_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Order_Header_Rec_Type,

Line 410: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

406: -- Pre-Req :
407: -- Parameters:
408: -- IN
409: -- p_api_version_number IN NUMBER Required
410: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
411: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
412: -- P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type Required
413: -- Hint: Add List of bind variables here
414: -- p_rec_requested IN NUMBER Optional Default = 30

Line 420: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE

416: --
417: -- Return Total Records Count Flag. This flag controls whether the total record count
418: -- and total record amount is returned.
419: --
420: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
421: -- Hint: User defined record type
422: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
423: --
424: -- OUT:

Line 442: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

438: -- End of Comments
439: --
440: PROCEDURE Get_quote(
441: P_Api_Version_Number IN NUMBER,
442: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
443: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
444: -- Hint: Add list of bind variables here
445: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
446: p_start_rec_prt IN NUMBER := 1,

Line 447: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

443: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
444: -- Hint: Add list of bind variables here
445: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
446: p_start_rec_prt IN NUMBER := 1,
447: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
448: -- Hint: user defined record type
449: p_order_by_rec IN ASO_QUOTE_PUB.QTE_sort_rec_type,
450: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
451: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 467: P_Call_Ar_Api_Flag IN VARCHAR2 := FND_API.G_FALSE,

463: P_Calculate_Tax IN VARCHAR2,
464: P_calculate_Freight_Charge IN VARCHAR2,
465: p_control_rec IN ASO_QUOTE_PUB.CONTROL_REC_TYPE
466: := ASO_QUOTE_PUB.G_MISS_CONTROL_REC,
467: P_Call_Ar_Api_Flag IN VARCHAR2 := FND_API.G_FALSE,
468: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
469: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
470: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
471:

Line 505: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

501: );
502:
503: PROCEDURE Quote_Security_Check(
504: P_Api_Version_Number IN NUMBER,
505: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
506: P_User_Id IN NUMBER,
507: X_Resource_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
508: X_Security_Flag OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
509: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,