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 */
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,
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,
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,
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,
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 )
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;
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:
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
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;
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:
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,
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
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
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
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,
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,
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: