DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PUB dependencies on ASO_QUOTE_PUB

Line 24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,

20: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec,
21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
23: /* Code change for Quoting Usability Sun ER Start */
24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
25: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
26: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
27: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
28: /* Code change for Quoting Usability Sun ER End */

Line 25: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,

21: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
23: /* Code change for Quoting Usability Sun ER Start */
24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
25: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
26: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
27: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
28: /* Code change for Quoting Usability Sun ER End */
29: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 26: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,

22: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec,
23: /* Code change for Quoting Usability Sun ER Start */
24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
25: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
26: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
27: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
28: /* Code change for Quoting Usability Sun ER End */
29: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
30: X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 27: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,

23: /* Code change for Quoting Usability Sun ER Start */
24: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec,
25: P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec,
26: P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL,
27: P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl,
28: /* Code change for Quoting Usability Sun ER End */
29: X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
30: X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER,
31: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 155: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

151: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
152: P_Qte_Header_Id IN NUMBER,
153: P_Qte_Line_Id IN NUMBER := NULL,
154: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
155: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
156: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
157: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
158: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
159: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 156: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,

152: P_Qte_Header_Id IN NUMBER,
153: P_Qte_Line_Id IN NUMBER := NULL,
154: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
155: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
156: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
157: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
158: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
159: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
160: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 167: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

163:
164:
165: l_api_version NUMBER := 1.0;
166: l_api_name VARCHAR2(50) := 'Copy_Line';
167: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
168: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
169:
170: -- ER 3177722
171: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;

Line 171: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;

167: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
168: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
169:
170: -- ER 3177722
171: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
172: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');
173: l_item_type_code varchar2(30);
174:
175:

Line 255: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_quote_header_rec: '||P_Qte_Header_Id, 1, 'N');

251: if (x_return_status =FND_API.G_RET_STS_SUCCESS) then
252:
253: if l_copy_config_profile='N' then
254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
255: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_quote_header_rec: '||P_Qte_Header_Id, 1, 'N');
256: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration X_Qte_Line_Id: '||X_Qte_Line_Id, 1, 'N');
257: end if;
258: select item_type_code into l_item_type_code
259: from aso_Quote_lines_all

Line 256: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration X_Qte_Line_Id: '||X_Qte_Line_Id, 1, 'N');

252:
253: if l_copy_config_profile='N' then
254: IF aso_debug_pub.g_debug_flag = 'Y' THEN
255: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_quote_header_rec: '||P_Qte_Header_Id, 1, 'N');
256: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration X_Qte_Line_Id: '||X_Qte_Line_Id, 1, 'N');
257: end if;
258: select item_type_code into l_item_type_code
259: from aso_Quote_lines_all
260: where quote_line_id=X_Qte_Line_Id;

Line 262: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_item_type_code: '||l_item_type_code, 1, 'N');

258: select item_type_code into l_item_type_code
259: from aso_Quote_lines_all
260: where quote_line_id=X_Qte_Line_Id;
261: IF aso_debug_pub.g_debug_flag = 'Y' THEN
262: aso_debug_pub.add('Copy_Line -before ASO_QUOTE_PUB.validate_model_configuration l_item_type_code: '||l_item_type_code, 1, 'N');
263: end if;
264:
265: if l_item_type_code='MDL' then
266:

Line 267: ASO_QUOTE_PUB.validate_model_configuration

263: end if;
264:
265: if l_item_type_code='MDL' then
266:
267: ASO_QUOTE_PUB.validate_model_configuration
268: (
269: P_Api_Version_Number => 1.0,
270: P_Init_Msg_List => FND_API.G_FALSE,
271: P_Commit => FND_API.G_FALSE,

Line 289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');

285: end if;
286: */
287:
288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');
290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
292: END IF;
293: END IF; -- MDL

Line 290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');

286: */
287:
288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');
290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
292: END IF;
293: END IF; -- MDL
294: end if; -- profile

Line 291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');

287:
288: IF aso_debug_pub.g_debug_flag = 'Y' THEN
289: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration return status: '||x_Return_Status, 1, 'N');
290: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
291: aso_debug_pub.add('Copy_Line -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
292: END IF;
293: END IF; -- MDL
294: end if; -- profile
295: end if; -- in case success

Line 364: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

360: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
361: P_Qte_Header_Id IN NUMBER,
362: P_Qte_Line_Id IN NUMBER := NULL,
363: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
364: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
365: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
366: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
367: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
368: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 365: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,

361: P_Qte_Header_Id IN NUMBER,
362: P_Qte_Line_Id IN NUMBER := NULL,
363: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
364: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
365: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
366: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
367: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
368: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
369: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 367: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,

363: P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type,
364: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
365: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
366: X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
367: X_Qte_Header_Rec OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Header_Rec_Type,
368: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
369: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
370: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
371: