DBA Data[Home] [Help]

APPS.ASO_QUOTE_LINES_PVT dependencies on FND_API

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

60: -- Pre-Req :
61: -- Parameters:
62: -- IN
63: -- p_api_version_number IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
67: -- P_quote_header_id IN NUMBER Required
68: -- P_header_last_update_date IN DATE Required

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

61: -- Parameters:
62: -- IN
63: -- p_api_version_number IN NUMBER Required
64: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
65: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
66: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
67: -- P_quote_header_id IN NUMBER Required
68: -- P_header_last_update_date IN DATE Required
69: -- P_Payment_Tbl IN Payment_Tbl_Type

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

74: -- P_Freight_Charges_Tbl IN Freight_Charges_Tbl_Type
75: -- P_Line_Relationship_Tbl IN Line_Relationship_Tbl_Type
76: -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
77: -- P_Price_Adj_Relationship_Tbl IN Price_Adj_Relationship_Tbl_Type
78: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
79:
80: -- OUT:
81: -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
82: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

89: -- End of Comments
90: --
91: PROCEDURE Create_Quote_Lines(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
97: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,

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

90: --
91: PROCEDURE Create_Quote_Lines(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
97: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
98: P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,

Line 95: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

91: PROCEDURE Create_Quote_Lines(
92: P_Api_Version_Number IN NUMBER,
93: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
94: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
95: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
96: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
97: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
98: P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
99: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,

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

137: -- Pre-Req :
138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
144: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
145: -- P_quote_header_id IN NUMBER Required

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

138: -- Parameters:
139: -- IN
140: -- p_api_version_number IN NUMBER Required
141: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
142: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
143: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
144: -- P_qte_lines_Rec IN qte_line_Rec_Type Required
145: -- P_quote_header_id IN NUMBER Required
146: -- P_header_last_update_date IN DATE Required

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

152: -- P_Freight_Charges_Tbl IN Freight_Charges_Tbl_Type
153: -- P_Line_Relationship_Tbl IN Line_Relationship_Tbl_Type
154: -- P_Price_Attributes_Tbl IN Price_Attributes_Tbl_Type
155: -- P_Price_Adj_Relationship_Tbl IN Price_Adj_Relationship_Tbl_Type
156: -- P_Update_Header_Flag IN VARCHAR2 Optional Default = FND_API.G_TRUE
157: -- OUT:
158: -- X_quote_line_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
159: -- x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
160: -- x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

168: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
169:
170: PROCEDURE Update_Quote_Line(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
176: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,

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

169:
170: PROCEDURE Update_Quote_Line(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
176: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
177: P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,

Line 174: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

170: PROCEDURE Update_Quote_Line(
171: P_Api_Version_Number IN NUMBER,
172: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
173: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
174: P_Validation_Level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
175: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
176: P_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC,
177: P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
178: P_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Payment_TBL,

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

216: -- Pre-Req :
217: -- Parameters:
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
223: -- P_qte_line_Rec IN qte_line_Rec_Type Required
224: -- P_quote_header_id IN NUMBER Required

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

217: -- Parameters:
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
223: -- P_qte_line_Rec IN qte_line_Rec_Type Required
224: -- P_quote_header_id IN NUMBER Required
225: -- P_header_last_update_date IN DATE Required

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

238: -- The Master delete procedure may not be needed depends on different business requirements.
239:
240: PROCEDURE Delete_Quote_Line(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
245: P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
246: P_Update_Header_Flag IN VARCHAR2 := 'Y',

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

239:
240: PROCEDURE Delete_Quote_Line(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: P_qte_line_Rec IN ASO_QUOTE_PUB.qte_line_Rec_Type,
245: P_Control_REC IN ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
246: P_Update_Header_Flag IN VARCHAR2 := 'Y',
247: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

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

260: -- Pre-Req :
261: -- Parameters:
262: -- IN
263: -- p_api_version_number IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
266: -- P_quote_id IN NUMBER Required
267: -- p_rec_requested IN NUMBER Optional Default = 30
268: -- p_start_rec_ptr IN NUMBER Optional Default = 1

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

269: --
270: -- Return Total Records Count Flag. This flag controls whether the total record count
271: -- and total record amount is returned.
272: --
273: -- p_return_tot_count IN VARCHAR2 Optional Default = FND_API.G_FALSE
274: -- Hint: User defined record type
275: -- p_order_by_tbl IN AS_UTILITY_PUB.UTIL_ORDER_BY_TBL_TYPE;
276: --
277: -- OUT NOCOPY /* file.sql.39 change */ :

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

301: -- End of Comments
302: --
303: PROCEDURE Get_Quote_Line(
304: P_Api_Version_Number IN NUMBER,
305: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
307: p_start_rec_prt IN NUMBER := 1,
308: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
309: -- Hint: user defined record type

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

304: P_Api_Version_Number IN NUMBER,
305: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
306: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
307: p_start_rec_prt IN NUMBER := 1,
308: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
309: -- Hint: user defined record type
310: p_order_by_rec IN ASO_QUOTE_PUB.qte_line_sort_rec_type,
311: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
312: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,