27: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Header_Rec
28: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
29: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
30: /* Code change for Quoting Usability Sun ER Start */
31: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec
32: , P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
33: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
34: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
35: /* Code change for Quoting Usability Sun ER End */
28: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
29: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
30: /* Code change for Quoting Usability Sun ER Start */
31: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec
32: , P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
33: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
34: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
35: /* Code change for Quoting Usability Sun ER End */
36: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
29: := ASO_COPY_QUOTE_PUB.G_MISS_Copy_Quote_Control_Rec
30: /* Code change for Quoting Usability Sun ER Start */
31: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec
32: , P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
33: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
34: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
35: /* Code change for Quoting Usability Sun ER End */
36: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
37: , X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER
30: /* Code change for Quoting Usability Sun ER Start */
31: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_Miss_Qte_Header_Rec
32: , P_Hd_Shipment_Rec IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
33: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
34: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
35: /* Code change for Quoting Usability Sun ER End */
36: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
37: , X_Qte_Number OUT NOCOPY /* file.sql.39 change */ NUMBER
38: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
95: l_api_version_number CONSTANT NUMBER := 1.0;
96: l_return_status VARCHAR2 ( 1 );
97: l_val VARCHAR2 ( 1 );
98: l_enabled_flag VARCHAR2 ( 1 );
99: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
100: l_HEADER_RELATIONSHIP_ID NUMBER;
101: l_qte_num NUMBER;
102: l_qte_header_id NUMBER;
103: l_qte_status_id NUMBER;
107: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
108: X_New_Qte_Line_Id NUMBER;
109: -- hyang: for bug 2692785
110: lx_status VARCHAR2(1);
111: l_copy_line_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
112:
113: -- ER 3177722
114: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
115: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');
110: lx_status VARCHAR2(1);
111: l_copy_line_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
112:
113: -- ER 3177722
114: lx_config_tbl ASO_QUOTE_PUB.Config_Vaild_Tbl_Type;
115: l_copy_config_profile varchar2(1):=nvl(fnd_profile.value('ASO_COPY_CONFIG_EFF_DATE'),'Y');
116:
117: -- vtariker Price/Tax enh
118: CURSOR C_Get_Last_Upd_Date (
167: and trunc(nvl(pri.end_date_active, sysdate)) >= trunc(sysdate);
168:
169: /* End : Code change done for Bug 12674665 */
170:
171: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
172: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
173: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
168:
169: /* End : Code change done for Bug 12674665 */
170:
171: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
172: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
173: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
169: /* End : Code change done for Bug 12674665 */
170:
171: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
172: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
173: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
170:
171: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
172: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
173: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
171: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
172: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
173: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
172: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
173: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
173: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
174: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
175: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
176: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
177: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
178: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
179: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
180: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
188: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
181: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
188: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
189: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
182: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
188: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
189: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
190: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
183: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
188: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
189: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
190: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
191: -- vtariker Price/Tax enh
184: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
188: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
189: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
190: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
191: -- vtariker Price/Tax enh
192:
185: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
188: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
189: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
190: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
191: -- vtariker Price/Tax enh
192:
193: -- hyang new okc
186: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
187: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
188: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
189: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
190: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
191: -- vtariker Price/Tax enh
192:
193: -- hyang new okc
194: l_terms_template_name VARCHAR2(240);
715: , P_Qte_Line_Id => FND_API.G_MISS_NUM
716: , P_Price_Index_Link_Tbl => lx_Price_Index_Link_Tbl
717: , P_Copy_Quote_Control_Rec => P_Copy_Quote_Control_Rec
718: , P_Qte_Header_Rec => l_copy_line_qte_header_rec
719: , P_Control_Rec => ASO_QUOTE_PUB.G_MISS_Control_Rec
720: , X_Qte_Line_Id => X_New_Qte_Line_Id
721: , X_Return_Status => l_return_status
722: , X_Msg_Count => x_msg_count
723: , X_Msg_Data => x_msg_data
730: /* if (l_return_status =FND_API.G_RET_STS_SUCCESS) then
731:
732:
733: if l_copy_config_profile='N' then
734: aso_debug_pub.add('Copy Quote -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');
735:
736: ASO_QUOTE_PUB.validate_model_configuration
737: (
738: P_Api_Version_Number => 1.0,
732:
733: if l_copy_config_profile='N' then
734: aso_debug_pub.add('Copy Quote -before ASO_QUOTE_PUB.validate_model_configuration return status: ', 1, 'N');
735:
736: ASO_QUOTE_PUB.validate_model_configuration
737: (
738: P_Api_Version_Number => 1.0,
739: P_Init_Msg_List => FND_API.G_FALSE,
740: P_Commit => FND_API.G_FALSE,
749: );
750:
751: if l_Return_Status=FND_API.G_RET_STS_SUCCESS then
752: commit work;
753: aso_debug_pub.add('rassharm Copy Quote -after ASO_QUOTE_PUB.validate_model_configuration committing data return status: ', 1, 'N');
754:
755: end if;
756:
757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
754:
755: end if;
756:
757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
758: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
759: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
760: END IF;
761:
762:
755: end if;
756:
757: IF aso_debug_pub.g_debug_flag = 'Y' THEN
758: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
759: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
760: END IF;
761:
762:
763:
905:
906: IF aso_debug_pub.g_debug_flag = 'Y' THEN
907: aso_debug_pub.ADD ( 'Copy_Quote - Before Update_Qte: x_qte_header_id '||x_qte_header_id , 1 , 'N' );
908: END IF;
909: aso_quote_pub.update_quote (
910: p_api_version_number => 1.0,
911: p_init_msg_list => fnd_api.g_false,
912: p_commit => fnd_api.g_false,
913: p_control_rec => l_control_rec,
911: p_init_msg_list => fnd_api.g_false,
912: p_commit => fnd_api.g_false,
913: p_control_rec => l_control_rec,
914: p_qte_header_rec => l_upd_qte_header_rec,
915: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
916: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
917: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
912: p_commit => fnd_api.g_false,
913: p_control_rec => l_control_rec,
914: p_qte_header_rec => l_upd_qte_header_rec,
915: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
916: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
917: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
913: p_control_rec => l_control_rec,
914: p_qte_header_rec => l_upd_qte_header_rec,
915: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
916: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
917: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
914: p_qte_header_rec => l_upd_qte_header_rec,
915: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
916: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
917: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
915: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
916: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
917: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
916: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
917: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
917: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
918: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
919: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
920: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
921: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
929: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
922: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
929: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
930: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
923: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
929: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
930: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
931: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
924: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
929: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
930: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
931: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
932: x_qte_header_rec => x_qte_header_rec,
925: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
929: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
930: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
931: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
932: x_qte_header_rec => x_qte_header_rec,
933: x_qte_line_tbl => x_qte_line_tbl,
926: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
929: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
930: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
931: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
932: x_qte_header_rec => x_qte_header_rec,
933: x_qte_line_tbl => x_qte_line_tbl,
934: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
927: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
928: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
929: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
930: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
931: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
932: x_qte_header_rec => x_qte_header_rec,
933: x_qte_line_tbl => x_qte_line_tbl,
934: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
935: x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,
1115:
1116: -- ER 3177722
1117: if l_copy_config_profile='N' then
1118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1119: aso_debug_pub.add('Copy Quote -before ASO_QUOTE_PUB.validate_model_configuration x_qte_header_id: '||x_qte_header_id, 1, 'N');
1120: end if;
1121:
1122: ASO_QUOTE_PUB.validate_model_configuration
1123: (
1118: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1119: aso_debug_pub.add('Copy Quote -before ASO_QUOTE_PUB.validate_model_configuration x_qte_header_id: '||x_qte_header_id, 1, 'N');
1120: end if;
1121:
1122: ASO_QUOTE_PUB.validate_model_configuration
1123: (
1124: P_Api_Version_Number => 1.0,
1125: P_Init_Msg_List => FND_API.G_FALSE,
1126: P_Commit => FND_API.G_FALSE,
1134: X_Msg_Data => x_msg_data
1135: );
1136:
1137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1138: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
1139: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
1140: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
1141: END IF;
1142: /* if (l_Return_Status=FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
1135: );
1136:
1137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1138: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
1139: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
1140: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
1141: END IF;
1142: /* if (l_Return_Status=FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
1143: commit work;
1136:
1137: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1138: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration return status: '||l_Return_Status, 1, 'N');
1139: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration lx_config_tbl: '||lx_config_tbl.count, 1, 'N');
1140: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
1141: END IF;
1142: /* if (l_Return_Status=FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
1143: commit work;
1144: aso_debug_pub.add('rassharm Copy Quote -after ASO_QUOTE_PUB.validate_model_configuration committing data return status: ', 1, 'N');
1140: aso_debug_pub.add('Copy Quote -After ASO_QUOTE_PUB.validate_model_configuration x_msg_count: '||x_msg_count, 1, 'N');
1141: END IF;
1142: /* if (l_Return_Status=FND_API.G_RET_STS_SUCCESS) and (lx_config_tbl.count>0) then
1143: commit work;
1144: aso_debug_pub.add('rassharm Copy Quote -after ASO_QUOTE_PUB.validate_model_configuration committing data return status: ', 1, 'N');
1145:
1146: end if;
1147: */
1148:
1222: PROCEDURE Copy_Header_Rows (
1223: P_Api_Version_Number IN NUMBER
1224: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1225: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1226: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
1227: /* Code change for Quoting Usability Sun ER Start */
1228: , P_Hd_Shipment_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
1229: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
1230: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
1224: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
1225: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1226: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
1227: /* Code change for Quoting Usability Sun ER Start */
1228: , P_Hd_Shipment_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
1229: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
1230: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
1231: /* Code change for Quoting Usability Sun ER End */
1232: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
1225: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
1226: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
1227: /* Code change for Quoting Usability Sun ER Start */
1228: , P_Hd_Shipment_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
1229: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
1230: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
1231: /* Code change for Quoting Usability Sun ER End */
1232: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
1233: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
1226: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
1227: /* Code change for Quoting Usability Sun ER Start */
1228: , P_Hd_Shipment_REC IN ASO_QUOTE_PUB.Shipment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Shipment_Rec
1229: , P_hd_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type := ASO_QUOTE_PUB.G_MISS_PAYMENT_TBL
1230: , P_hd_Tax_Detail_Tbl IN ASO_QUOTE_PUB.Tax_Detail_Tbl_Type := ASO_QUOTE_PUB.G_Miss_Tax_Detail_Tbl
1231: /* Code change for Quoting Usability Sun ER End */
1232: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
1233: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
1234: , X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1238: ) IS
1239:
1240: l_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
1241: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
1242: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
1243: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1244: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1239:
1240: l_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
1241: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
1242: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
1243: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1244: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1240: l_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
1241: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
1242: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
1243: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1244: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1241: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
1242: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
1243: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1244: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1242: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
1243: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1244: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1243: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1244: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1244: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1245: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1246: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1247: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1248: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1249: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1250: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1251: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1259: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1252: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1259: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1260: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1253: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1259: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1260: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1261: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1254: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1259: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1260: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1261: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1262: l_api_version CONSTANT NUMBER := 1.0;
1255: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1259: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1260: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1261: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1262: l_api_version CONSTANT NUMBER := 1.0;
1263: l_return_status VARCHAR2 ( 1 );
1256: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1259: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1260: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1261: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1262: l_api_version CONSTANT NUMBER := 1.0;
1263: l_return_status VARCHAR2 ( 1 );
1264: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Header_Rows';
1257: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1258: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1259: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1260: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1261: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1262: l_api_version CONSTANT NUMBER := 1.0;
1263: l_return_status VARCHAR2 ( 1 );
1264: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Header_Rows';
1265: l_api_version_number CONSTANT NUMBER := 1.0;
1264: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Header_Rows';
1265: l_api_version_number CONSTANT NUMBER := 1.0;
1266:
1267:
1268: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1269: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1272: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1265: l_api_version_number CONSTANT NUMBER := 1.0;
1266:
1267:
1268: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1269: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1272: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1273: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1266:
1267:
1268: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1269: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1272: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1273: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1274:
1267:
1268: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1269: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1272: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1273: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1274:
1275: l_old_qte_num NUMBER;
1268: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
1269: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1272: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1273: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1274:
1275: l_old_qte_num NUMBER;
1276: l_sequence NUMBER := null;
1269: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1270: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1271: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1272: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1273: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1274:
1275: l_old_qte_num NUMBER;
1276: l_sequence NUMBER := null;
1277: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
1276: l_sequence NUMBER := null;
1277: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
1278:
1279: --BC4J Fix
1280: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1281:
1282: CURSOR C_Get_Sales_Team (l_qte_num NUMBER) IS
1283: SELECT RESOURCE_ID,
1284: RESOURCE_GRP_ID,
1321: SELECT Quote_Number
1322: FROM ASO_QUOTE_HEADERS_ALL
1323: WHERE QUote_Header_Id = l_hdr_id;
1324:
1325: l_qte_access_tbl aso_quote_pub.qte_access_tbl_type := aso_quote_pub.g_miss_qte_access_tbl;
1326: x_qte_access_tbl aso_quote_pub.qte_access_tbl_type;
1327: BEGIN
1328:
1329: -- Standard Start of API savepoint
1322: FROM ASO_QUOTE_HEADERS_ALL
1323: WHERE QUote_Header_Id = l_hdr_id;
1324:
1325: l_qte_access_tbl aso_quote_pub.qte_access_tbl_type := aso_quote_pub.g_miss_qte_access_tbl;
1326: x_qte_access_tbl aso_quote_pub.qte_access_tbl_type;
1327: BEGIN
1328:
1329: -- Standard Start of API savepoint
1330: SAVEPOINT COPY_HEADER_ROWS_PVT;
1376:
1377: l_tax_detail_tbl := ASO_UTILITY_PVT.Query_Tax_Detail_Rows (
1378: p_qte_header_id => l_qte_header_id,
1379: p_qte_line_id => NULL,
1380: p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl );
1381:
1382: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1383: aso_debug_pub.ADD ( 'Copy_Header_Rows - l_tax_detail_tbl.count: ' || TO_CHAR ( l_tax_detail_tbl.COUNT ) , 1 , 'N' );
1384: END IF;
1537: l_tax_detail_tbl(j).TAX_EXEMPT_REASON_CODE := P_hd_Tax_Detail_Tbl(j).TAX_EXEMPT_REASON_CODE;
1538: End If;
1539: END LOOP;
1540:
1541: l_price_adj_tbl := aso_quote_pub.g_miss_price_adj_tbl;
1542:
1543: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
1544:
1545: l_price_adj_attr_tbl := aso_quote_pub.g_miss_price_adj_attr_tbl;
1541: l_price_adj_tbl := aso_quote_pub.g_miss_price_adj_tbl;
1542:
1543: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
1544:
1545: l_price_adj_attr_tbl := aso_quote_pub.g_miss_price_adj_attr_tbl;
1546:
1547: l_price_attr_tbl := aso_quote_pub.g_miss_price_attributes_tbl;
1548:
1549: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
1543: l_dup_Price_Adj_Tbl := l_price_adj_tbl;
1544:
1545: l_price_adj_attr_tbl := aso_quote_pub.g_miss_price_adj_attr_tbl;
1546:
1547: l_price_attr_tbl := aso_quote_pub.g_miss_price_attributes_tbl;
1548:
1549: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row (
1550: P_qte_header_Id => l_qte_header_id ,
1551: P_qte_line_id => NULL );
2291: , P_New_Qte_Header_Id IN NUMBER
2292: , P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2293: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2294: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
2295: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2296: , P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
2297: , X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
2298: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2299: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
2292: , P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
2293: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2294: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
2295: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
2296: , P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
2297: , X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
2298: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2299: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
2300: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2347: SELECT shipment_id
2348: FROM ASO_SHIPMENTS
2349: WHERE quote_line_id = lc_line_id;
2350:
2351: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2352: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2353: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2348: FROM ASO_SHIPMENTS
2349: WHERE quote_line_id = lc_line_id;
2350:
2351: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2352: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2353: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2349: WHERE quote_line_id = lc_line_id;
2350:
2351: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2352: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2353: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2350:
2351: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2352: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2353: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2351: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2352: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2353: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2352: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
2353: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2353: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2354: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2355: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2356: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2357: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2365: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec; -- Code change for Quoting Usability Sun ER
2358: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2365: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec; -- Code change for Quoting Usability Sun ER
2366: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2359: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2365: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec; -- Code change for Quoting Usability Sun ER
2366: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2367: := P_Price_Index_Link_Tbl;
2360: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2365: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec; -- Code change for Quoting Usability Sun ER
2366: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2367: := P_Price_Index_Link_Tbl;
2368: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
2361: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2362: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2363: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2364: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2365: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := p_control_rec; -- Code change for Quoting Usability Sun ER
2366: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
2367: := P_Price_Index_Link_Tbl;
2368: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
2369: l_qte_line_id NUMBER;
2377: l_config_hdr_id NUMBER;
2378: l_config_rev_nbr NUMBER;
2379: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2380: LX_LINE_RELATIONSHIP_ID NUMBER;
2381: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2382: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2383: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2378: l_config_rev_nbr NUMBER;
2379: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2380: LX_LINE_RELATIONSHIP_ID NUMBER;
2381: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2382: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2383: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2386: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2379: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2380: LX_LINE_RELATIONSHIP_ID NUMBER;
2381: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2382: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2383: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2386: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2387: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2380: LX_LINE_RELATIONSHIP_ID NUMBER;
2381: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2382: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2383: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2386: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2387: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2388: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2381: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2382: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2383: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2386: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2387: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2388: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2389: l_api_version CONSTANT NUMBER := 1.0;
2382: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2383: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2386: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2387: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2388: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2389: l_api_version CONSTANT NUMBER := 1.0;
2390: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';
2383: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2386: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2387: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2388: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2389: l_api_version CONSTANT NUMBER := 1.0;
2390: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';
2391: l_service_item_flag VARCHAR2 ( 1 );
2384: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2385: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2386: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2387: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2388: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2389: l_api_version CONSTANT NUMBER := 1.0;
2390: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';
2391: l_service_item_flag VARCHAR2 ( 1 );
2392: l_serviceable_product_flag VARCHAR2 ( 1 );
2399: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
2400: -- hyang: for bug 2692785
2401: lx_status VARCHAR2(1);
2402:
2403: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2404:
2405: --- New Code added for Copy Quote Line Functionality
2406:
2407: CURSOR C_Validate_Quote_Line (
2459: Select Max(Line_number)
2460: From ASO_QUOTE_LINES_ALL
2461: WHERE quote_header_id = c_QUOTE_HEADER_ID;
2462:
2463: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
2464: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
2465: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2460: From ASO_QUOTE_LINES_ALL
2461: WHERE quote_header_id = c_QUOTE_HEADER_ID;
2462:
2463: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
2464: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
2465: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2461: WHERE quote_header_id = c_QUOTE_HEADER_ID;
2462:
2463: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
2464: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
2465: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2462:
2463: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
2464: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
2465: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2463: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
2464: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
2465: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2464: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
2465: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2465: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2466: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2467: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2468: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2469: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2470: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2471: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2472: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2473: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2474: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2482:
2475: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2482:
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2476: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2482:
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2477: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
2478: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2482:
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2479: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2482:
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2480: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2482:
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2481: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
2482:
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2482:
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2490: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2483: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2490: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2491: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2484: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2490: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2491: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2492: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2485: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2490: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2491: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2492: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2493: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
2486: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2490: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2491: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2492: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2493: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
2494:
2487: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2490: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2491: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2492: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2493: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
2494:
2495: /* Code change for Quoting Usability Sun ER Start */
2488: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
2489: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2490: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2491: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2492: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2493: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
2494:
2495: /* Code change for Quoting Usability Sun ER Start */
2496: CURSOR c_header_org IS
2501:
2502: l_copy_flag VARCHAR2(1) := 'T';
2503: l_def_control_rec ASO_DEFAULTING_INT.Control_Rec_Type := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC;
2504: l_db_object_name VARCHAR2(30);
2505: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;
2506: lx_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2507: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2508: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2509: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
2502: l_copy_flag VARCHAR2(1) := 'T';
2503: l_def_control_rec ASO_DEFAULTING_INT.Control_Rec_Type := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC;
2504: l_db_object_name VARCHAR2(30);
2505: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;
2506: lx_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2507: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2508: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2509: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
2510: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
2503: l_def_control_rec ASO_DEFAULTING_INT.Control_Rec_Type := ASO_DEFAULTING_INT.G_MISS_CONTROL_REC;
2504: l_db_object_name VARCHAR2(30);
2505: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;
2506: lx_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2507: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2508: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2509: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
2510: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
2511: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2504: l_db_object_name VARCHAR2(30);
2505: l_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type := ASO_QUOTE_PUB.G_MISS_Payment_REC;
2506: lx_hd_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2507: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2508: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2509: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
2510: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
2511: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2512: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2507: lx_hd_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2508: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2509: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
2510: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
2511: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2512: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2513: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2514: lx_changed_flag VARCHAR2(1);
2515: l_def_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC;
2508: lx_hd_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2509: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
2510: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
2511: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2512: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2513: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2514: lx_changed_flag VARCHAR2(1);
2515: l_def_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC;
2516:
2509: lx_hd_misc_rec ASO_DEFAULTING_INT.Header_Misc_Rec_Type;
2510: lx_ln_misc_rec ASO_DEFAULTING_INT.Line_Misc_Rec_Type;
2511: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2512: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2513: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2514: lx_changed_flag VARCHAR2(1);
2515: l_def_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC;
2516:
2517: l_check_service_rec ASO_SERVICE_CONTRACTS_INT.CHECK_SERVICE_REC_TYPE;
2511: lx_ln_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2512: lx_ln_payment_rec ASO_QUOTE_PUB.Payment_Rec_Type;
2513: lx_ln_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
2514: lx_changed_flag VARCHAR2(1);
2515: l_def_Qte_Line_Rec ASO_QUOTE_PUB.Qte_Line_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_line_REC;
2516:
2517: l_check_service_rec ASO_SERVICE_CONTRACTS_INT.CHECK_SERVICE_REC_TYPE;
2518:
2519: x_available_yn Varchar2(1);
2843: -- end validation for last update data
2844:
2845:
2846:
2847: l_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL ;
2848: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( P_Qte_Line_Id );
2849: l_qte_line_tbl(1) := l_qte_line_rec;
2850:
2851:
3250: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, l_qte_line_id);
3251:
3252: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);
3253:
3254: -- l_payment_tbl := ASO_QUOTE_PUB.g_miss_payment_tbl;
3255:
3256: -- l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);
3257:
3258: /* Code change for Quoting Usability Sun ER Start */
3459: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
3460: , P_price_attributes_tbl => l_price_attr_tbl
3461: , P_Price_Adj_Tbl => l_price_adj_tbl
3462: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
3463: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
3464: , P_Shipment_Tbl => l_shipment_tbl
3465: , P_Freight_Charge_Tbl => l_freight_charge_tbl
3466: , P_Tax_Detail_Tbl => l_tax_detail_tbl
3467: , P_Sales_Credit_Tbl => l_sales_credit_tbl
3976: l_Qte_Header_Rec.tax_status_indicator := P_Qte_Header_Rec.tax_status_indicator;
3977: l_Qte_Header_Rec.price_updated_date := P_Qte_Header_Rec.price_updated_date;
3978: l_Qte_Header_Rec.tax_updated_date := P_Qte_Header_Rec.tax_updated_date;
3979:
3980: aso_quote_pub.update_quote (
3981: p_api_version_number => 1.0,
3982: p_init_msg_list => fnd_api.g_false,
3983: p_commit => fnd_api.g_false,
3984: p_control_rec => p_control_rec,
3982: p_init_msg_list => fnd_api.g_false,
3983: p_commit => fnd_api.g_false,
3984: p_control_rec => p_control_rec,
3985: p_qte_header_rec => l_Qte_Header_Rec,
3986: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3987: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
3988: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3983: p_commit => fnd_api.g_false,
3984: p_control_rec => p_control_rec,
3985: p_qte_header_rec => l_Qte_Header_Rec,
3986: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3987: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
3988: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3984: p_control_rec => p_control_rec,
3985: p_qte_header_rec => l_Qte_Header_Rec,
3986: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3987: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
3988: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3985: p_qte_header_rec => l_Qte_Header_Rec,
3986: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3987: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
3988: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3986: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3987: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
3988: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3987: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
3988: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3988: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3989: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3990: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3991: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
3992: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4000: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
3993: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4000: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4001: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
3994: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4000: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4001: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4002: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
3995: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4000: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4001: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4002: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4003: x_qte_header_rec => x_qte_header_rec,
3996: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4000: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4001: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4002: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4003: x_qte_header_rec => x_qte_header_rec,
4004: x_qte_line_tbl => x_qte_line_tbl,
3997: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4000: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4001: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4002: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4003: x_qte_header_rec => x_qte_header_rec,
4004: x_qte_line_tbl => x_qte_line_tbl,
4005: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
3998: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
3999: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4000: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4001: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4002: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4003: x_qte_header_rec => x_qte_header_rec,
4004: x_qte_line_tbl => x_qte_line_tbl,
4005: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
4006: x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,
4077: l_Qte_Header_Rec.tax_status_indicator := P_Qte_Header_Rec.tax_status_indicator;
4078: l_Qte_Header_Rec.price_updated_date := P_Qte_Header_Rec.price_updated_date;
4079: l_Qte_Header_Rec.tax_updated_date := P_Qte_Header_Rec.tax_updated_date;
4080:
4081: aso_quote_pub.update_quote (
4082: p_api_version_number => 1.0,
4083: p_init_msg_list => fnd_api.g_false,
4084: p_commit => fnd_api.g_false,
4085: p_control_rec => p_control_rec,
4083: p_init_msg_list => fnd_api.g_false,
4084: p_commit => fnd_api.g_false,
4085: p_control_rec => p_control_rec,
4086: p_qte_header_rec => l_Qte_Header_Rec,
4087: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4088: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4089: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4090: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4091: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4084: p_commit => fnd_api.g_false,
4085: p_control_rec => p_control_rec,
4086: p_qte_header_rec => l_Qte_Header_Rec,
4087: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4088: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4089: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4090: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4091: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4092: p_qte_line_tbl => l_qte_line_tbl,
4085: p_control_rec => p_control_rec,
4086: p_qte_header_rec => l_Qte_Header_Rec,
4087: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4088: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4089: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4090: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4091: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4092: p_qte_line_tbl => l_qte_line_tbl,
4093: p_qte_line_dtl_tbl => l_qte_line_dtl_tbl,
4086: p_qte_header_rec => l_Qte_Header_Rec,
4087: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4088: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4089: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4090: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4091: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4092: p_qte_line_tbl => l_qte_line_tbl,
4093: p_qte_line_dtl_tbl => l_qte_line_dtl_tbl,
4094: p_line_attr_ext_tbl => l_line_attr_Ext_Tbl,
4087: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4088: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
4089: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
4090: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
4091: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4092: p_qte_line_tbl => l_qte_line_tbl,
4093: p_qte_line_dtl_tbl => l_qte_line_dtl_tbl,
4094: p_line_attr_ext_tbl => l_line_attr_Ext_Tbl,
4095: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
4091: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
4092: p_qte_line_tbl => l_qte_line_tbl,
4093: p_qte_line_dtl_tbl => l_qte_line_dtl_tbl,
4094: p_line_attr_ext_tbl => l_line_attr_Ext_Tbl,
4095: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
4096: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
4097: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
4098: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
4099: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4092: p_qte_line_tbl => l_qte_line_tbl,
4093: p_qte_line_dtl_tbl => l_qte_line_dtl_tbl,
4094: p_line_attr_ext_tbl => l_line_attr_Ext_Tbl,
4095: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
4096: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
4097: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
4098: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
4099: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4100: p_ln_payment_tbl => l_payment_tbl,
4093: p_qte_line_dtl_tbl => l_qte_line_dtl_tbl,
4094: p_line_attr_ext_tbl => l_line_attr_Ext_Tbl,
4095: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
4096: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
4097: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
4098: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
4099: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4100: p_ln_payment_tbl => l_payment_tbl,
4101: p_ln_shipment_tbl => l_shipment_tbl,
4094: p_line_attr_ext_tbl => l_line_attr_Ext_Tbl,
4095: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
4096: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
4097: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
4098: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
4099: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4100: p_ln_payment_tbl => l_payment_tbl,
4101: p_ln_shipment_tbl => l_shipment_tbl,
4102: p_ln_freight_charge_tbl => l_freight_charge_tbl,
4095: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
4096: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
4097: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
4098: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
4099: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
4100: p_ln_payment_tbl => l_payment_tbl,
4101: p_ln_shipment_tbl => l_shipment_tbl,
4102: p_ln_freight_charge_tbl => l_freight_charge_tbl,
4103: p_ln_tax_detail_tbl => l_tax_detail_tbl,
4249: FROM MTL_SYSTEM_ITEMS_VL
4250: WHERE inventory_item_id = l_inv_item_id
4251: AND organization_id = l_organization_id;
4252:
4253: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4254: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4255: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4250: WHERE inventory_item_id = l_inv_item_id
4251: AND organization_id = l_organization_id;
4252:
4253: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4254: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4255: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4251: AND organization_id = l_organization_id;
4252:
4253: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4254: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4255: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4252:
4253: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4254: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4255: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4253: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4254: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4255: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4254: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4255: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4255: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4256: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4264: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4257: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4264: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4265: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4258: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4264: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4265: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4266: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4259: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4264: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4265: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4266: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4267: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4260: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4264: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4265: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4266: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4267: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4268: LX_LINE_RELATIONSHIP_ID NUMBER;
4261: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4264: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4265: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4266: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4267: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4268: LX_LINE_RELATIONSHIP_ID NUMBER;
4269: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4262: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4263: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4264: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4265: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4266: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4267: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4268: LX_LINE_RELATIONSHIP_ID NUMBER;
4269: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4270: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4265: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4266: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4267: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4268: LX_LINE_RELATIONSHIP_ID NUMBER;
4269: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4270: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4271: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4266: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4267: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4268: LX_LINE_RELATIONSHIP_ID NUMBER;
4269: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4270: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4271: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4274: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4267: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4268: LX_LINE_RELATIONSHIP_ID NUMBER;
4269: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4270: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4271: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4274: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4275: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4268: LX_LINE_RELATIONSHIP_ID NUMBER;
4269: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4270: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4271: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4274: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4275: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4276: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4269: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4270: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4271: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4274: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4275: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4276: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4277: l_return_status VARCHAR2 ( 1 );
4270: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4271: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4274: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4275: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4276: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4277: l_return_status VARCHAR2 ( 1 );
4278: qte_line_id NUMBER;
4271: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4274: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4275: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4276: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4277: l_return_status VARCHAR2 ( 1 );
4278: qte_line_id NUMBER;
4279: i NUMBER;
4272: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4273: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4274: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4275: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4276: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4277: l_return_status VARCHAR2 ( 1 );
4278: qte_line_id NUMBER;
4279: i NUMBER;
4280: j NUMBER;
4308: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
4309: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
4310: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
4311:
4312: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4309: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
4310: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
4311:
4312: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4310: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
4311:
4312: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4311:
4312: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4312: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4320: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4313: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4320: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4321: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4314: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4320: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4321: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4322:
4315: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4320: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4321: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4322:
4323: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4316: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4320: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4321: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4322:
4323: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4324:
4317: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4320: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4321: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4322:
4323: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4324:
4325:
4319: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4320: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4321: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4322:
4323: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4324:
4325:
4326: BEGIN
4327:
4523: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
4524: , P_price_attributes_tbl => l_price_attr_tbl
4525: , P_Price_Adj_Tbl => l_price_adj_tbl
4526: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
4527: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
4528: , P_Shipment_Tbl => l_shipment_tbl
4529: , P_Freight_Charge_Tbl => l_freight_charge_tbl
4530: , P_Tax_Detail_Tbl => l_tax_detail_tbl
4531: , P_Sales_Credit_Tbl => l_sales_credit_tbl
4754: FROM aso_line_relationships
4755: WHERE quote_line_id = qte_ln_id
4756: AND relationship_type_code = 'SERVICE';
4757:
4758: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4759: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4760: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4755: WHERE quote_line_id = qte_ln_id
4756: AND relationship_type_code = 'SERVICE';
4757:
4758: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4759: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4760: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4756: AND relationship_type_code = 'SERVICE';
4757:
4758: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4759: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4760: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4757:
4758: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4759: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4760: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4758: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4759: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4760: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4759: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4760: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4760: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4761: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4769: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4762: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4769: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4770: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4763: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4769: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4770: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4771: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4764: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4769: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4770: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4771: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4772: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4765: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4769: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4770: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4771: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4772: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4773: LX_LINE_RELATIONSHIP_ID NUMBER;
4766: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4769: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4770: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4771: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4772: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4773: LX_LINE_RELATIONSHIP_ID NUMBER;
4774: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4767: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4768: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4769: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4770: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4771: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4772: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4773: LX_LINE_RELATIONSHIP_ID NUMBER;
4774: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4775: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4770: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4771: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4772: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4773: LX_LINE_RELATIONSHIP_ID NUMBER;
4774: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4775: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4776: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4771: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4772: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4773: LX_LINE_RELATIONSHIP_ID NUMBER;
4774: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4775: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4776: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4779: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4772: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
4773: LX_LINE_RELATIONSHIP_ID NUMBER;
4774: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4775: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4776: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4779: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4780: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4773: LX_LINE_RELATIONSHIP_ID NUMBER;
4774: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4775: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4776: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4779: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4780: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4781: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4774: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4775: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4776: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4779: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4780: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4781: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4782: l_service_ref_line_id NUMBER;
4775: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4776: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4779: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4780: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4781: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4782: l_service_ref_line_id NUMBER;
4783: l_return_status VARCHAR2 ( 1 );
4776: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4779: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4780: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4781: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4782: l_service_ref_line_id NUMBER;
4783: l_return_status VARCHAR2 ( 1 );
4784: qte_line_id NUMBER;
4777: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4778: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4779: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
4780: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4781: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
4782: l_service_ref_line_id NUMBER;
4783: l_return_status VARCHAR2 ( 1 );
4784: qte_line_id NUMBER;
4785: i NUMBER;
4793: WHERE quote_line_id = x_qte_line_id ;
4794:
4795: l_line_number NUMBER;
4796:
4797: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4798: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4799: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4794:
4795: l_line_number NUMBER;
4796:
4797: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4798: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4799: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4795: l_line_number NUMBER;
4796:
4797: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4798: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4799: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4796:
4797: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4798: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4799: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4797: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4798: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4799: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4805: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4798: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4799: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4805: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4806: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4799: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4805: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4806: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4807:
4800: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4805: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4806: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4807:
4808: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4801: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4805: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4806: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4807:
4808: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4809:
4802: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4803: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4805: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4806: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4807:
4808: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4809:
4810:
4804: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4805: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4806: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4807:
4808: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4809:
4810:
4811: BEGIN
4812:
4981: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
4982: , P_price_attributes_tbl => l_price_attr_tbl
4983: , P_Price_Adj_Tbl => l_price_adj_tbl
4984: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
4985: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
4986: , P_Shipment_Tbl => l_shipment_tbl
4987: , P_Freight_Charge_Tbl => l_freight_charge_tbl
4988: , P_Tax_Detail_Tbl => l_tax_detail_tbl
4989: , P_Sales_Credit_Tbl => l_sales_credit_tbl
5430: FROM ASO_QUOTE_RELATED_OBJECTS
5431: WHERE relationship_type_code = 'OPP_QUOTE'
5432: AND quote_object_id = qte_hdr;
5433:
5434: l_related_obj_rec ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC;
5435: l_related_obj_id NUMBER;
5436:
5437: BEGIN
5438:
5490: PROCEDURE Split_Model_Line (
5491: P_Api_Version_Number IN NUMBER,
5492: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5493: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5494: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
5495: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5496: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5497: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5498: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5491: P_Api_Version_Number IN NUMBER,
5492: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5493: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5494: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
5495: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5496: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5497: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5498: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5499: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5492: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
5493: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5494: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
5495: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5496: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5497: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5498: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5499: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5500: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5493: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
5494: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
5495: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5496: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5497: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5498: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5499: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5500: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5501: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
5494: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
5495: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
5496: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
5497: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5498: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
5499: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5500: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
5501: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
5502:
5580: Select Max(Line_number)
5581: From ASO_QUOTE_LINES_ALL
5582: WHERE quote_header_id = c_QUOTE_HEADER_ID;
5583:
5584: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
5585: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5586: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5581: From ASO_QUOTE_LINES_ALL
5582: WHERE quote_header_id = c_QUOTE_HEADER_ID;
5583:
5584: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
5585: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5586: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5582: WHERE quote_header_id = c_QUOTE_HEADER_ID;
5583:
5584: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
5585: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5586: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5583:
5584: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
5585: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5586: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5584: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
5585: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5586: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5585: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
5586: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5586: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5587: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5588: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5589: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5590: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5591: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5592: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5600: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5593: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5600: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5601: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5594: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5600: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5601: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5602: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
5595: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5600: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5601: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5602: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
5603: l_line_number NUMBER;
5596: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5600: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5601: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5602: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
5603: l_line_number NUMBER;
5604:
5597: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5600: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5601: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5602: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
5603: l_line_number NUMBER;
5604:
5605: l_val VARCHAR2 ( 1 );
5598: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
5599: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
5600: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
5601: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
5602: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
5603: l_line_number NUMBER;
5604:
5605: l_val VARCHAR2 ( 1 );
5606: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
5602: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
5603: l_line_number NUMBER;
5604:
5605: l_val VARCHAR2 ( 1 );
5606: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
5607: l_qte_line_detail_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5608: l_qte_shipment_dtl_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5609: l_quantity NUMBER := 0;
5610: l_remaining_quantity NUMBER := 0;
5603: l_line_number NUMBER;
5604:
5605: l_val VARCHAR2 ( 1 );
5606: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
5607: l_qte_line_detail_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5608: l_qte_shipment_dtl_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5609: l_quantity NUMBER := 0;
5610: l_remaining_quantity NUMBER := 0;
5611: l_return_value Varchar2(1);
5604:
5605: l_val VARCHAR2 ( 1 );
5606: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
5607: l_qte_line_detail_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5608: l_qte_shipment_dtl_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5609: l_quantity NUMBER := 0;
5610: l_remaining_quantity NUMBER := 0;
5611: l_return_value Varchar2(1);
5612:
5619: l_api_version_number CONSTANT NUMBER := 1.0;
5620: l_api_version CONSTANT NUMBER := 1.0;
5621: l_service_item_flag VARCHAR2 ( 1 );
5622: l_serviceable_product_flag VARCHAR2 ( 1 );
5623: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5624: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5625: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5620: l_api_version CONSTANT NUMBER := 1.0;
5621: l_service_item_flag VARCHAR2 ( 1 );
5622: l_serviceable_product_flag VARCHAR2 ( 1 );
5623: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5624: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5625: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5621: l_service_item_flag VARCHAR2 ( 1 );
5622: l_serviceable_product_flag VARCHAR2 ( 1 );
5623: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5624: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5625: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5622: l_serviceable_product_flag VARCHAR2 ( 1 );
5623: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5624: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5625: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5623: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5624: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5625: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5624: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5625: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5625: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5633: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5626: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5633: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5634: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
5627: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5633: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5634: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
5635: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
5628: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5633: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5634: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
5635: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
5636: l_config_control_rec ASO_CFG_INT.Control_Rec_Type
5629: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5633: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5634: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
5635: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
5636: l_config_control_rec ASO_CFG_INT.Control_Rec_Type
5637: := ASO_CFG_INT.G_MISS_Control_Rec;
5630: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5633: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5634: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
5635: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
5636: l_config_control_rec ASO_CFG_INT.Control_Rec_Type
5637: := ASO_CFG_INT.G_MISS_Control_Rec;
5638: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
5631: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5632: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5633: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5634: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
5635: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
5636: l_config_control_rec ASO_CFG_INT.Control_Rec_Type
5637: := ASO_CFG_INT.G_MISS_Control_Rec;
5638: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
5639: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
5643: l_ship_id NUMBER;
5644: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
5645: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
5646:
5647: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
5648: l_api_name varchar2(50) := 'Split_Model_Line';
5649: TYPE inserted_qte_line_Rec_Type IS RECORD
5650: (
5651: quote_line_id NUMBER:= FND_API.G_MISS_NUM,
5659: l_inserted_qte_line_tbl inserted_qte_line_Tbl_Type := G_MISS_inserted_qte_line_tbl;
5660:
5661: l_total_lines NUMBER := 0;
5662:
5663: l_qty_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
5664: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
5665: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
5666: -- hyang: for bug 2692785
5667: lx_status VARCHAR2(1);
5665: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
5666: -- hyang: for bug 2692785
5667: lx_status VARCHAR2(1);
5668:
5669: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5670: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5671: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5666: -- hyang: for bug 2692785
5667: lx_status VARCHAR2(1);
5668:
5669: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5670: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5671: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5667: lx_status VARCHAR2(1);
5668:
5669: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5670: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5671: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5668:
5669: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5670: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5671: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5669: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
5670: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5671: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5677: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5670: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
5671: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5677: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5678: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5671: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5677: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5678: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5679:
5672: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5677: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5678: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5679:
5680: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5673: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5677: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5678: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5679:
5680: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5681: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
5674: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
5675: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5677: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5678: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5679:
5680: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5681: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
5682:
5676: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
5677: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
5678: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
5679:
5680: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
5681: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
5682:
5683:
5684: BEGIN
6178: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
6179: , P_price_attributes_tbl => l_price_attr_tbl
6180: , P_Price_Adj_Tbl => l_price_adj_tbl
6181: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
6182: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
6183: , P_Shipment_Tbl => l_shipment_tbl
6184: , P_Freight_Charge_Tbl => l_freight_charge_tbl
6185: , P_Tax_Detail_Tbl => l_tax_detail_tbl
6186: , P_Sales_Credit_Tbl => l_sales_credit_tbl
6597: l_control_rec.calculate_freight_charge_flag := 'Y';
6598: */
6599:
6600:
6601: l_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
6602:
6603: IF aso_debug_pub.g_debug_flag = 'Y' THEN
6604: aso_debug_pub.ADD ( 'No Of Qte Lines 1 = '|| to_char(l_qte_line_tbl.count), 1 , 'N' );
6605: aso_debug_pub.ADD ( ' Setting the qty and op code for new line created ', 1 , 'N' );
6636: aso_debug_pub.ADD ( 'No Of Qte Lines before update qty = '|| to_char(l_qte_line_tbl.count), 1 , 'N' );
6637: aso_debug_pub.ADD ( ' Calling Update Quote to update all lines ', 1 , 'N' );
6638: END IF;
6639:
6640: aso_quote_pub.update_quote (
6641: p_api_version_number => 1.0,
6642: p_init_msg_list => fnd_api.g_false,
6643: p_commit => fnd_api.g_false,
6644: p_control_rec => p_control_rec,
6642: p_init_msg_list => fnd_api.g_false,
6643: p_commit => fnd_api.g_false,
6644: p_control_rec => p_control_rec,
6645: p_qte_header_rec => l_quote_header_rec,
6646: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6647: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6648: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6649: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6643: p_commit => fnd_api.g_false,
6644: p_control_rec => p_control_rec,
6645: p_qte_header_rec => l_quote_header_rec,
6646: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6647: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6648: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6649: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6644: p_control_rec => p_control_rec,
6645: p_qte_header_rec => l_quote_header_rec,
6646: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6647: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6648: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6649: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6645: p_qte_header_rec => l_quote_header_rec,
6646: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6647: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6648: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6649: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6646: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6647: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6648: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6649: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6648: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6649: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6649: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6650: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6651: p_qte_line_tbl => l_qte_line_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6652: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6660: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6653: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6660: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6661: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6654: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6660: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6661: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6662: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6655: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6660: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6661: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6662: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6663: x_qte_header_rec => x_qte_header_rec,
6656: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6660: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6661: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6662: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6663: x_qte_header_rec => x_qte_header_rec,
6664: x_qte_line_tbl => x_qte_line_tbl,
6657: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6660: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6661: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6662: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6663: x_qte_header_rec => x_qte_header_rec,
6664: x_qte_line_tbl => x_qte_line_tbl,
6665: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
6658: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
6659: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
6660: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
6661: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
6662: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
6663: x_qte_header_rec => x_qte_header_rec,
6664: x_qte_line_tbl => x_qte_line_tbl,
6665: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
6666: x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,
6955:
6956:
6957: END INSERT_SALES_SUPP_DATA;
6958:
6959: PROCEDURE copy_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
6960: x_return_status OUT NOCOPY varchar2,
6961: x_msg_count OUT NOCOPY number,
6962: x_msg_data OUT NOCOPY varchar2) is
6963:
6961: x_msg_count OUT NOCOPY number,
6962: x_msg_data OUT NOCOPY varchar2) is
6963:
6964: l_api_name varchar2(1000) := 'copy_payment_row';
6965: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
6966: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
6967: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
6968: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
6969: lx_assign_id number;
6962: x_msg_data OUT NOCOPY varchar2) is
6963:
6964: l_api_name varchar2(1000) := 'copy_payment_row';
6965: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
6966: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
6967: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
6968: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
6969: lx_assign_id number;
6970: lx_entity_id number;
6968: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
6969: lx_assign_id number;
6970: lx_entity_id number;
6971: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
6972: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
6973: l_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
6974: l_payment_ref_number varchar2(240);
6975: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
6976: