DBA Data[Home] [Help]

APPS.ASO_QUOTE_VUHK dependencies on FND_API

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

19: -- Pre-Req :
20: -- Parameters:
21: -- IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
26: --
27: -- OUT:

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

20: -- Parameters:
21: -- IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
26: --
27: -- OUT:
28: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 61: G_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;

57: G_ln_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Quote_Party_Tbl;
58: G_Line_Attribs_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_Tbl ;
59: G_Qte_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
60: G_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
61: G_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
62: G_Last_Update_Date DATE := FND_API.G_MISS_DATE;
63: G_Copy_Only_Header VARCHAR2(1) := FND_API.G_FALSE;
64: G_New_Version VARCHAR2(1) := FND_API.G_FALSE;
65: G_Qte_Status_Id NUMBER := NULL;

Line 62: G_Last_Update_Date DATE := FND_API.G_MISS_DATE;

58: G_Line_Attribs_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Line_Attribs_Ext_Tbl ;
59: G_Qte_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
60: G_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
61: G_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
62: G_Last_Update_Date DATE := FND_API.G_MISS_DATE;
63: G_Copy_Only_Header VARCHAR2(1) := FND_API.G_FALSE;
64: G_New_Version VARCHAR2(1) := FND_API.G_FALSE;
65: G_Qte_Status_Id NUMBER := NULL;
66: G_Qte_Number NUMBER := NULL;

Line 63: G_Copy_Only_Header VARCHAR2(1) := FND_API.G_FALSE;

59: G_Qte_Line_Dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Dtl_Tbl;
60: G_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
61: G_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
62: G_Last_Update_Date DATE := FND_API.G_MISS_DATE;
63: G_Copy_Only_Header VARCHAR2(1) := FND_API.G_FALSE;
64: G_New_Version VARCHAR2(1) := FND_API.G_FALSE;
65: G_Qte_Status_Id NUMBER := NULL;
66: G_Qte_Number NUMBER := NULL;
67: G_NEW_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;

Line 64: G_New_Version VARCHAR2(1) := FND_API.G_FALSE;

60: G_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec;
61: G_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
62: G_Last_Update_Date DATE := FND_API.G_MISS_DATE;
63: G_Copy_Only_Header VARCHAR2(1) := FND_API.G_FALSE;
64: G_New_Version VARCHAR2(1) := FND_API.G_FALSE;
65: G_Qte_Status_Id NUMBER := NULL;
66: G_Qte_Number NUMBER := NULL;
67: G_NEW_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
68: PROCEDURE Create_quote_PRE(

Line 67: G_NEW_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;

63: G_Copy_Only_Header VARCHAR2(1) := FND_API.G_FALSE;
64: G_New_Version VARCHAR2(1) := FND_API.G_FALSE;
65: G_Qte_Status_Id NUMBER := NULL;
66: G_Qte_Number NUMBER := NULL;
67: G_NEW_Qte_Header_Id NUMBER := FND_API.G_MISS_NUM;
68: PROCEDURE Create_quote_PRE(
69: P_Validation_Level IN OUT NOCOPY NUMBER ,
70: P_Control_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Control_Rec_Type ,
71: P_Qte_Header_Rec IN OUT NOCOPY ASO_QUOTE_PUB.Qte_Header_Rec_Type ,

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

140: -- Pre-Req :
141: -- Parameters:
142: -- IN
143: -- p_api_version_number IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
148: --

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

141: -- Parameters:
142: -- IN
143: -- p_api_version_number IN NUMBER Required
144: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
145: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
147: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
148: --
149: -- OUT:

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

233: -- Pre-Req :
234: -- Parameters:
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
240: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
241: --

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

234: -- Parameters:
235: -- IN
236: -- p_api_version_number IN NUMBER Required
237: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
238: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
239: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
240: -- P_Qte_Header_Rec IN Qte_Header_Rec_Type Required
241: --
242: -- OUT:

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

274: -- Pre-Req :
275: -- Parameters:
276: -- IN
277: -- p_api_version_number IN NUMBER Required
278: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
279: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
280: --
281: -- OUT:
282: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

275: -- Parameters:
276: -- IN
277: -- p_api_version_number IN NUMBER Required
278: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
279: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
280: --
281: -- OUT:
282: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
283: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

327: -- Pre-Req :
328: -- Parameters:
329: -- IN
330: -- p_api_version_number IN NUMBER Required
331: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
332: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
333: -- OUT:
334: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
335: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

328: -- Parameters:
329: -- IN
330: -- p_api_version_number IN NUMBER Required
331: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
332: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
333: -- OUT:
334: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
335: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
336: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

367: -- Pre-Req :
368: -- Parameters:
369: -- IN
370: -- p_api_version_number IN NUMBER Required
371: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
372: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
373: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
374: -- P_quote_header_id IN NUMBER Required
375: -- P_header_last_update_date IN DATE Required

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

368: -- Parameters:
369: -- IN
370: -- p_api_version_number IN NUMBER Required
371: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
372: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
373: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
374: -- P_quote_header_id IN NUMBER Required
375: -- P_header_last_update_date IN DATE Required
376: -- P_Payment_Tbl IN Payment_Tbl_Type

Line 385: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE

381: -- P_Freight_Charge_Tbl IN Freight_Charge_Tbl_Type
382: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
383: -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
384: -- P_Price_Adj_Rltship_Tbl IN Price_Adj_Rltship_Tbl_Type
385: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
386:
387: -- OUT:
388: -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
389: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

504: -- Pre-Req :
505: -- Parameters:
506: -- IN
507: -- p_api_version_number IN NUMBER Required
508: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
509: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
510: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
511: -- P_qte_line_Rec IN qte_line_Rec_Type Required
512: -- P_quote_header_id IN NUMBER Required

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

505: -- Parameters:
506: -- IN
507: -- p_api_version_number IN NUMBER Required
508: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
509: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
510: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
511: -- P_qte_line_Rec IN qte_line_Rec_Type Required
512: -- P_quote_header_id IN NUMBER Required
513: -- P_header_last_update_date IN DATE Required