eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_QUOTE_PUB

Line 93: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

89: l_api_version_number CONSTANT NUMBER := 1.0;
90: l_return_status VARCHAR2 ( 1 );
91: l_val VARCHAR2 ( 1 );
92: l_enabled_flag VARCHAR2 ( 1 );
93: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
94: l_HEADER_RELATIONSHIP_ID NUMBER;
95: l_qte_num NUMBER;
96: l_qte_header_id NUMBER;
97: l_qte_status_id NUMBER;

Line 105: l_copy_line_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

101: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
102: X_New_Qte_Line_Id NUMBER;
103: -- hyang: for bug 2692785
104: lx_status VARCHAR2(1);
105: l_copy_line_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
106:
107: -- vtariker Price/Tax enh
108: CURSOR C_Get_Last_Upd_Date (
109: qte_hdr_id NUMBER

Line 127: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;

123: FROM jtf_notes_vl
124: WHERE note_type = 'QOT_SALES_ASSIST'
125: AND source_object_id = l_qte_hdr_id;
126:
127: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
128: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

Line 128: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

124: WHERE note_type = 'QOT_SALES_ASSIST'
125: AND source_object_id = l_qte_hdr_id;
126:
127: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
128: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

Line 129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;

125: AND source_object_id = l_qte_hdr_id;
126:
127: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
128: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

Line 130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

126:
127: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
128: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

127: l_upd_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_qte_header_rec;
128: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

128: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

129: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

Line 134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

130: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

Line 135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

131: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

Line 136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

132: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

Line 137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

133: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

Line 138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

134: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

Line 139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

135: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

Line 140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

136: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

137: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
145: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

138: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
145: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
146: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

139: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
145: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
146: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
147: -- vtariker Price/Tax enh

Line 144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

140: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
145: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
146: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
147: -- vtariker Price/Tax enh
148:

Line 145: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

141: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
145: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
146: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
147: -- vtariker Price/Tax enh
148:
149: -- hyang new okc

Line 146: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

142: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
143: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
144: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
145: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
146: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
147: -- vtariker Price/Tax enh
148:
149: -- hyang new okc
150: l_terms_template_name VARCHAR2(240);

Line 494: , P_Control_Rec => ASO_QUOTE_PUB.G_MISS_Control_Rec

490: , P_Qte_Line_Id => FND_API.G_MISS_NUM
491: , P_Price_Index_Link_Tbl => lx_Price_Index_Link_Tbl
492: , P_Copy_Quote_Control_Rec => P_Copy_Quote_Control_Rec
493: , P_Qte_Header_Rec => l_copy_line_qte_header_rec
494: , P_Control_Rec => ASO_QUOTE_PUB.G_MISS_Control_Rec
495: , X_Qte_Line_Id => X_New_Qte_Line_Id
496: , X_Return_Status => l_return_status
497: , X_Msg_Count => x_msg_count
498: , X_Msg_Data => x_msg_data

Line 611: aso_quote_pub.update_quote (

607:
608: IF aso_debug_pub.g_debug_flag = 'Y' THEN
609: aso_debug_pub.ADD ( 'Copy_Quote - Before Update_Qte: x_qte_header_id '||x_qte_header_id , 1 , 'N' );
610: END IF;
611: aso_quote_pub.update_quote (
612: p_api_version_number => 1.0,
613: p_init_msg_list => fnd_api.g_false,
614: p_commit => fnd_api.g_false,
615: p_control_rec => l_control_rec,

Line 617: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

613: p_init_msg_list => fnd_api.g_false,
614: p_commit => fnd_api.g_false,
615: p_control_rec => l_control_rec,
616: p_qte_header_rec => l_upd_qte_header_rec,
617: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
618: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 618: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

614: p_commit => fnd_api.g_false,
615: p_control_rec => l_control_rec,
616: p_qte_header_rec => l_upd_qte_header_rec,
617: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
618: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,

Line 619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

615: p_control_rec => l_control_rec,
616: p_qte_header_rec => l_upd_qte_header_rec,
617: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
618: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

Line 620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

616: p_qte_header_rec => l_upd_qte_header_rec,
617: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
618: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,

Line 621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

617: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
618: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

Line 622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,

618: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,

Line 623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

619: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

Line 624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,

620: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

Line 625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

621: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

Line 626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,

622: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

Line 627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

623: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

Line 628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

624: p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
632: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

Line 629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

625: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
632: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
633: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

626: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
632: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
633: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
634: x_qte_header_rec => x_qte_header_rec,

Line 631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

627: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
632: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
633: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
634: x_qte_header_rec => x_qte_header_rec,
635: x_qte_line_tbl => x_qte_line_tbl,

Line 632: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

628: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
632: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
633: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
634: x_qte_header_rec => x_qte_header_rec,
635: x_qte_line_tbl => x_qte_line_tbl,
636: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,

Line 633: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

629: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
630: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
631: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
632: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
633: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
634: x_qte_header_rec => x_qte_header_rec,
635: x_qte_line_tbl => x_qte_line_tbl,
636: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
637: x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,

Line 877: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type

873: PROCEDURE Copy_Header_Rows (
874: P_Api_Version_Number IN NUMBER
875: , P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE
876: , P_Commit IN VARCHAR2 := FND_API.G_FALSE
877: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.qte_header_rec_Type
878: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
879: , X_Qte_Header_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
880: , X_Price_Index_Link_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
881: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 888: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;

884: ) IS
885:
886: l_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
887: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
888: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
889: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 889: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

885:
886: l_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
887: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
888: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
889: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

886: l_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
887: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
888: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
889: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

887: l_old_qte_header_id NUMBER := P_qte_Header_Rec.quote_header_id;
888: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
889: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

888: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := P_qte_Header_Rec;
889: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

889: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

890: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

891: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

892: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

893: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

894: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

895: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

896: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

Line 901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

897: lx_hd_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

898: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
906: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

899: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
906: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
907: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

900: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
906: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
907: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
908: l_api_version CONSTANT NUMBER := 1.0;

Line 905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

901: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
906: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
907: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
908: l_api_version CONSTANT NUMBER := 1.0;
909: l_return_status VARCHAR2 ( 1 );

Line 906: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

902: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
906: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
907: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
908: l_api_version CONSTANT NUMBER := 1.0;
909: l_return_status VARCHAR2 ( 1 );
910: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Header_Rows';

Line 907: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

903: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
904: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
905: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
906: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
907: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
908: l_api_version CONSTANT NUMBER := 1.0;
909: l_return_status VARCHAR2 ( 1 );
910: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Header_Rows';
911: l_api_version_number CONSTANT NUMBER := 1.0;

Line 914: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;

910: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Header_Rows';
911: l_api_version_number CONSTANT NUMBER := 1.0;
912:
913:
914: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
915: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
916: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
917: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
918: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 915: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

911: l_api_version_number CONSTANT NUMBER := 1.0;
912:
913:
914: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
915: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
916: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
917: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
918: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
919: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 916: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

912:
913:
914: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
915: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
916: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
917: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
918: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
919: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
920:

Line 917: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

913:
914: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
915: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
916: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
917: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
918: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
919: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
920:
921: l_old_qte_num NUMBER;

Line 918: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

914: l_qte_header_rec_out ASO_QUOTE_PUB.Qte_Header_Rec_Type;
915: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
916: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
917: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
918: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
919: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
920:
921: l_old_qte_num NUMBER;
922: l_sequence NUMBER := null;

Line 919: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

915: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
916: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
917: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
918: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
919: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
920:
921: l_old_qte_num NUMBER;
922: l_sequence NUMBER := null;
923: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');

Line 926: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

922: l_sequence NUMBER := null;
923: l_sales_team_prof VARCHAR2(30) := FND_PROFILE.value('ASO_AUTO_TEAM_ASSIGN');
924:
925: --BC4J Fix
926: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
927:
928: CURSOR C_Get_Sales_Team (l_qte_num NUMBER) IS
929: SELECT RESOURCE_ID,
930: RESOURCE_GRP_ID,

Line 971: l_qte_access_tbl aso_quote_pub.qte_access_tbl_type := aso_quote_pub.g_miss_qte_access_tbl;

967: SELECT Quote_Number
968: FROM ASO_QUOTE_HEADERS_ALL
969: WHERE QUote_Header_Id = l_hdr_id;
970:
971: l_qte_access_tbl aso_quote_pub.qte_access_tbl_type := aso_quote_pub.g_miss_qte_access_tbl;
972: x_qte_access_tbl aso_quote_pub.qte_access_tbl_type;
973:
974:
975: BEGIN

Line 972: x_qte_access_tbl aso_quote_pub.qte_access_tbl_type;

968: FROM ASO_QUOTE_HEADERS_ALL
969: WHERE QUote_Header_Id = l_hdr_id;
970:
971: l_qte_access_tbl aso_quote_pub.qte_access_tbl_type := aso_quote_pub.g_miss_qte_access_tbl;
972: x_qte_access_tbl aso_quote_pub.qte_access_tbl_type;
973:
974:
975: BEGIN
976:

Line 1041: , p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl

1037: l_tax_detail_tbl :=
1038: ASO_UTILITY_PVT.Query_Tax_Detail_Rows (
1039: p_qte_header_id => l_qte_header_id
1040: , p_qte_line_id => NULL
1041: , p_shipment_tbl => ASO_QUOTE_PUB.g_miss_shipment_tbl
1042: );
1043: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1044: aso_debug_pub.ADD ( 'Copy_Rows - tax_dtl_tbl.count: ' || TO_CHAR ( l_tax_detail_tbl.COUNT ) , 1 , 'N' );
1045: END IF;

Line 1600: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type

1596: , P_New_Qte_Header_Id IN NUMBER
1597: , P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1598: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1599: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
1600: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1601: , P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
1602: , X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
1603: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1604: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1601: , P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type

1597: , P_Qte_Line_Id IN NUMBER := FND_API.G_MISS_NUM
1598: , P_Price_Index_Link_Tbl IN ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1599: , P_Copy_Quote_Control_Rec IN ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type
1600: , P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
1601: , P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type
1602: , X_Qte_Line_Id OUT NOCOPY /* file.sql.39 change */ NUMBER
1603: , X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1604: , X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER
1605: , X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1656: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1652: SELECT shipment_id
1653: FROM ASO_SHIPMENTS
1654: WHERE quote_line_id = lc_line_id;
1655:
1656: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1657: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

Line 1657: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

1653: FROM ASO_SHIPMENTS
1654: WHERE quote_line_id = lc_line_id;
1655:
1656: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1657: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

1654: WHERE quote_line_id = lc_line_id;
1655:
1656: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1657: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

1655:
1656: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1657: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

1656: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1657: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

1657: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1658: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1659: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1660: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1661: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1662: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1663: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1671: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type

Line 1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1664: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1671: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1672: := P_Price_Index_Link_Tbl;

Line 1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

1665: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1671: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1672: := P_Price_Index_Link_Tbl;
1673: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;

Line 1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

1666: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1667: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1668: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1669: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
1670: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
1671: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type
1672: := P_Price_Index_Link_Tbl;
1673: l_line_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
1674: l_qte_line_id NUMBER;

Line 1686: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1682: l_config_hdr_id NUMBER;
1683: l_config_rev_nbr NUMBER;
1684: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1685: LX_LINE_RELATIONSHIP_ID NUMBER;
1686: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1687: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 1687: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1683: l_config_rev_nbr NUMBER;
1684: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1685: LX_LINE_RELATIONSHIP_ID NUMBER;
1686: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1687: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

Line 1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1684: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
1685: LX_LINE_RELATIONSHIP_ID NUMBER;
1686: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1687: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1692: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1685: LX_LINE_RELATIONSHIP_ID NUMBER;
1686: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1687: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1692: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1693: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1686: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1687: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1692: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1693: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1694: l_api_version CONSTANT NUMBER := 1.0;

Line 1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

1687: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1692: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1693: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1694: l_api_version CONSTANT NUMBER := 1.0;
1695: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';

Line 1692: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1688: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1692: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1693: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1694: l_api_version CONSTANT NUMBER := 1.0;
1695: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';
1696: l_service_item_flag VARCHAR2 ( 1 );

Line 1693: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

1689: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1690: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1691: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
1692: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1693: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
1694: l_api_version CONSTANT NUMBER := 1.0;
1695: l_api_name CONSTANT VARCHAR2 ( 30 ) := 'Copy_Line_Rows';
1696: l_service_item_flag VARCHAR2 ( 1 );
1697: l_serviceable_product_flag VARCHAR2 ( 1 );

Line 1708: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

1704: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
1705: -- hyang: for bug 2692785
1706: lx_status VARCHAR2(1);
1707:
1708: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
1709:
1710: --- New Code added for Copy Quote Line Functionality
1711:
1712: CURSOR C_Validate_Quote_Line (

Line 1768: x_qte_header_rec aso_quote_pub.qte_header_rec_type;

1764: Select Max(Line_number)
1765: From ASO_QUOTE_LINES_ALL
1766: WHERE quote_header_id = c_QUOTE_HEADER_ID;
1767:
1768: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

Line 1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

1765: From ASO_QUOTE_LINES_ALL
1766: WHERE quote_header_id = c_QUOTE_HEADER_ID;
1767:
1768: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

1766: WHERE quote_header_id = c_QUOTE_HEADER_ID;
1767:
1768: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

1767:
1768: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

1768: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

Line 1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

1769: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

Line 1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

1770: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

Line 1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

1771: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

Line 1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

1772: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

Line 1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

1773: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

Line 1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

1774: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

Line 1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

1775: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

1776: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

1777: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

1778: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

Line 1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

1779: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
1787:

Line 1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

1780: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
1787:
1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

1781: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
1787:
1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

1782: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
1783: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
1787:
1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

1784: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
1787:
1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

1785: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
1787:
1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

1786: l_Qte_Header_Rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
1787:
1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

1787:
1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

1788: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1796: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

1789: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1796: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1797: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

1790: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1796: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1797: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1798: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;

Line 1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

1791: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1796: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1797: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1798: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
1799:

Line 1796: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

1792: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1796: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1797: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1798: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
1799:
1800:

Line 1797: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

1793: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
1794: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
1795: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
1796: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
1797: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
1798: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
1799:
1800:
1801:

Line 1929: l_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL ;

1925: -- end validation for last update data
1926:
1927:
1928:
1929: l_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL ;
1930: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row ( P_Qte_Line_Id );
1931: l_qte_line_tbl(1) := l_qte_line_rec;
1932:
1933:

Line 2166: l_payment_tbl := ASO_QUOTE_PUB.g_miss_payment_tbl;

2162: l_price_attr_tbl := ASO_UTILITY_PVT.Query_Price_Attr_Rows(p_qte_header_id, l_qte_line_id);
2163:
2164: --l_payment_tbl := ASO_UTILITY_PVT.Query_Payment_Rows(p_qte_header_id, L_QTE_LINE_ID);
2165:
2166: l_payment_tbl := ASO_QUOTE_PUB.g_miss_payment_tbl;
2167:
2168: l_shipment_tbl := ASO_UTILITY_PVT.Query_Shipment_Rows(p_qte_header_id, L_QTE_LINE_ID);
2169:
2170: l_sales_credit_tbl := ASO_UTILITY_PVT.Query_Sales_Credit_Row(p_qte_header_id, L_QTE_LINE_ID);

Line 2274: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl

2270: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
2271: , P_price_attributes_tbl => l_price_attr_tbl
2272: , P_Price_Adj_Tbl => l_price_adj_tbl
2273: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
2274: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
2275: , P_Shipment_Tbl => l_shipment_tbl
2276: , P_Freight_Charge_Tbl => l_freight_charge_tbl
2277: , P_Tax_Detail_Tbl => l_tax_detail_tbl
2278: , P_Sales_Credit_Tbl => l_sales_credit_tbl

Line 2765: aso_quote_pub.update_quote (

2761: l_Qte_Header_Rec.tax_status_indicator := P_Qte_Header_Rec.tax_status_indicator;
2762: l_Qte_Header_Rec.price_updated_date := P_Qte_Header_Rec.price_updated_date;
2763: l_Qte_Header_Rec.tax_updated_date := P_Qte_Header_Rec.tax_updated_date;
2764:
2765: aso_quote_pub.update_quote (
2766: p_api_version_number => 1.0,
2767: p_init_msg_list => fnd_api.g_false,
2768: p_commit => fnd_api.g_false,
2769: p_control_rec => p_control_rec,

Line 2771: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

2767: p_init_msg_list => fnd_api.g_false,
2768: p_commit => fnd_api.g_false,
2769: p_control_rec => p_control_rec,
2770: p_qte_header_rec => l_Qte_Header_Rec,
2771: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2772: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 2772: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

2768: p_commit => fnd_api.g_false,
2769: p_control_rec => p_control_rec,
2770: p_qte_header_rec => l_Qte_Header_Rec,
2771: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2772: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,

Line 2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

2769: p_control_rec => p_control_rec,
2770: p_qte_header_rec => l_Qte_Header_Rec,
2771: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2772: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

Line 2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

2770: p_qte_header_rec => l_Qte_Header_Rec,
2771: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2772: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,

Line 2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

2771: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2772: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

Line 2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,

2772: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,

Line 2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

2773: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

Line 2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,

2774: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

Line 2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

2775: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

Line 2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,

2776: p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

Line 2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

2777: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

Line 2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

2778: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2786: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

Line 2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

2779: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2786: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2787: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

2780: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2786: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2787: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2788: x_qte_header_rec => x_qte_header_rec,

Line 2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

2781: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2786: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2787: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2788: x_qte_header_rec => x_qte_header_rec,
2789: x_qte_line_tbl => x_qte_line_tbl,

Line 2786: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

2782: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2786: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2787: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2788: x_qte_header_rec => x_qte_header_rec,
2789: x_qte_line_tbl => x_qte_line_tbl,
2790: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,

Line 2787: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

2783: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
2784: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
2785: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
2786: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
2787: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
2788: x_qte_header_rec => x_qte_header_rec,
2789: x_qte_line_tbl => x_qte_line_tbl,
2790: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
2791: x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,

Line 2945: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

2941: FROM MTL_SYSTEM_ITEMS_VL
2942: WHERE inventory_item_id = l_inv_item_id
2943: AND organization_id = l_organization_id;
2944:
2945: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2946: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 2946: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

2942: WHERE inventory_item_id = l_inv_item_id
2943: AND organization_id = l_organization_id;
2944:
2945: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2946: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

2943: AND organization_id = l_organization_id;
2944:
2945: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2946: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

2944:
2945: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2946: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

2945: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
2946: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

2946: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

2947: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

2948: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

2949: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2950: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

2951: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
2959: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;

Line 2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

2952: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
2959: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2960: LX_LINE_RELATIONSHIP_ID NUMBER;

Line 2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

2953: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
2959: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2960: LX_LINE_RELATIONSHIP_ID NUMBER;
2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

2954: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2955: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2956: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
2959: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2960: LX_LINE_RELATIONSHIP_ID NUMBER;
2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

2957: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
2959: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2960: LX_LINE_RELATIONSHIP_ID NUMBER;
2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

2958: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
2959: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2960: LX_LINE_RELATIONSHIP_ID NUMBER;
2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

Line 2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

2959: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
2960: LX_LINE_RELATIONSHIP_ID NUMBER;
2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2967: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

2960: LX_LINE_RELATIONSHIP_ID NUMBER;
2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2967: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2968: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

2961: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2967: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2968: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2969: l_return_status VARCHAR2 ( 1 );

Line 2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

2962: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2967: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2968: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2969: l_return_status VARCHAR2 ( 1 );
2970: qte_line_id NUMBER;

Line 2967: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

2963: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2967: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2968: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2969: l_return_status VARCHAR2 ( 1 );
2970: qte_line_id NUMBER;
2971: i NUMBER;

Line 2968: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

2964: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
2965: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
2966: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
2967: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
2968: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
2969: l_return_status VARCHAR2 ( 1 );
2970: qte_line_id NUMBER;
2971: i NUMBER;
2972: j NUMBER;

Line 3004: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

3000: AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
3001: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
3002: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
3003:
3004: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3005: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 3005: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

3001: AND ASO_Quote_Lines_all.item_type_code = 'MDL'
3002: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
3003:
3004: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3005: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

3002: AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
3003:
3004: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3005: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

3003:
3004: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3005: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

3004: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3005: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

3005: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3013: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

3006: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3013: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3014:

Line 3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

3007: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3013: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3014:
3015: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

3008: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3013: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3014:
3015: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3016:

Line 3013: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

3009: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3010: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3013: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3014:
3015: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3016:
3017:

Line 3015: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3011: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3012: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3013: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3014:
3015: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3016:
3017:
3018: BEGIN
3019:

Line 3219: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl

3215: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
3216: , P_price_attributes_tbl => l_price_attr_tbl
3217: , P_Price_Adj_Tbl => l_price_adj_tbl
3218: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
3219: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
3220: , P_Shipment_Tbl => l_shipment_tbl
3221: , P_Freight_Charge_Tbl => l_freight_charge_tbl
3222: , P_Tax_Detail_Tbl => l_tax_detail_tbl
3223: , P_Sales_Credit_Tbl => l_sales_credit_tbl

Line 3450: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

3446: FROM aso_line_relationships
3447: WHERE quote_line_id = qte_ln_id
3448: AND relationship_type_code = 'SERVICE';
3449:
3450: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
3451: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 3451: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

3447: WHERE quote_line_id = qte_ln_id
3448: AND relationship_type_code = 'SERVICE';
3449:
3450: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
3451: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;

3448: AND relationship_type_code = 'SERVICE';
3449:
3450: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
3451: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

3449:
3450: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
3451: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

3450: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
3451: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

3451: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3452: l_shipment_rec ASO_QUOTE_PUB.Shipment_Rec_Type;
3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

3453: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

3454: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3455: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

3456: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
3464: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;

Line 3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3457: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
3464: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
3465: LX_LINE_RELATIONSHIP_ID NUMBER;

Line 3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

3458: l_qte_line_dtl_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
3464: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
3465: LX_LINE_RELATIONSHIP_ID NUMBER;
3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

3459: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3460: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3461: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
3464: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
3465: LX_LINE_RELATIONSHIP_ID NUMBER;
3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

3462: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
3464: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
3465: LX_LINE_RELATIONSHIP_ID NUMBER;
3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

3463: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
3464: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
3465: LX_LINE_RELATIONSHIP_ID NUMBER;
3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

Line 3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

3464: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;
3465: LX_LINE_RELATIONSHIP_ID NUMBER;
3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
3472: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

3465: LX_LINE_RELATIONSHIP_ID NUMBER;
3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
3472: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3473: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

Line 3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

3466: X_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
3472: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3473: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
3474: l_service_ref_line_id NUMBER;

Line 3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;

3467: X_Sales_Credit_Tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
3472: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3473: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
3474: l_service_ref_line_id NUMBER;
3475: l_return_status VARCHAR2 ( 1 );

Line 3472: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

3468: X_Quote_Party_Tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
3472: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3473: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
3474: l_service_ref_line_id NUMBER;
3475: l_return_status VARCHAR2 ( 1 );
3476: qte_line_id NUMBER;

Line 3473: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;

3469: l_hd_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3470: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3471: l_quote_party_rec ASO_QUOTE_PUB.Quote_Party_rec_Type;
3472: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3473: l_sales_credit_rec ASO_QUOTE_PUB.Sales_Credit_rec_Type;
3474: l_service_ref_line_id NUMBER;
3475: l_return_status VARCHAR2 ( 1 );
3476: qte_line_id NUMBER;
3477: i NUMBER;

Line 3489: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

3485: WHERE quote_line_id = x_qte_line_id ;
3486:
3487: l_line_number NUMBER;
3488:
3489: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3490: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 3490: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

3486:
3487: l_line_number NUMBER;
3488:
3489: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3490: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

3487: l_line_number NUMBER;
3488:
3489: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3490: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

3488:
3489: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3490: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

3489: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
3490: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

3490: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3498: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

3491: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3498: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3499:

Line 3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

3492: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3498: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3499:
3500: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

3493: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3498: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3499:
3500: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3501:

Line 3498: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

3494: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
3495: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3498: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3499:
3500: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3501:
3502:

Line 3500: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

3496: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
3497: l_qte_line_dtl_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
3498: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
3499:
3500: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
3501:
3502:
3503: BEGIN
3504:

Line 3677: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl

3673: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
3674: , P_price_attributes_tbl => l_price_attr_tbl
3675: , P_Price_Adj_Tbl => l_price_adj_tbl
3676: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
3677: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
3678: , P_Shipment_Tbl => l_shipment_tbl
3679: , P_Freight_Charge_Tbl => l_freight_charge_tbl
3680: , P_Tax_Detail_Tbl => l_tax_detail_tbl
3681: , P_Sales_Credit_Tbl => l_sales_credit_tbl

Line 4126: l_related_obj_rec ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC;

4122: FROM ASO_QUOTE_RELATED_OBJECTS
4123: WHERE relationship_type_code = 'OPP_QUOTE'
4124: AND quote_object_id = qte_hdr;
4125:
4126: l_related_obj_rec ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC;
4127: l_related_obj_id NUMBER;
4128:
4129: BEGIN
4130:

Line 4186: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,

4182: PROCEDURE Split_Model_Line (
4183: P_Api_Version_Number IN NUMBER,
4184: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4185: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4186: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
4187: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
4188: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
4189: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4190: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

Line 4187: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,

4183: P_Api_Version_Number IN NUMBER,
4184: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4185: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4186: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
4187: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
4188: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
4189: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4190: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4191: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 4188: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,

4184: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
4185: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4186: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
4187: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
4188: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
4189: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4190: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4191: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4192: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 4189: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

4185: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
4186: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
4187: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
4188: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
4189: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4190: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4191: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4192: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4193: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )

Line 4190: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,

4186: P_Control_Rec IN ASO_QUOTE_PUB.Control_Rec_Type,
4187: P_Qte_Header_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
4188: P_Original_Qte_Line_Rec IN ASO_QUOTE_PUB.Qte_Line_Rec_Type,
4189: P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4190: X_Quote_Line_Tbl OUT NOCOPY /* file.sql.39 change */ ASO_QUOTE_PUB.Qte_Line_Tbl_Type,
4191: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4192: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
4193: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 )
4194:

Line 4276: x_qte_header_rec aso_quote_pub.qte_header_rec_type;

4272: Select Max(Line_number)
4273: From ASO_QUOTE_LINES_ALL
4274: WHERE quote_header_id = c_QUOTE_HEADER_ID;
4275:
4276: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

Line 4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;

4273: From ASO_QUOTE_LINES_ALL
4274: WHERE quote_header_id = c_QUOTE_HEADER_ID;
4275:
4276: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;

4274: WHERE quote_header_id = c_QUOTE_HEADER_ID;
4275:
4276: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

4275:
4276: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;

4276: x_qte_header_rec aso_quote_pub.qte_header_rec_type;
4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

Line 4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;

4277: x_qte_line_tbl aso_quote_pub.qte_line_tbl_type;
4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

Line 4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

4278: x_qte_line_dtl_tbl aso_quote_pub.qte_line_dtl_tbl_type;
4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

Line 4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

4279: x_hd_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

Line 4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;

4280: x_hd_payment_tbl aso_quote_pub.payment_tbl_type;
4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

Line 4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;

4281: x_hd_shipment_tbl aso_quote_pub.shipment_tbl_type;
4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

Line 4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;

4282: x_hd_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

Line 4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;

4283: x_hd_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

Line 4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;

4284: x_line_attr_ext_tbl aso_quote_pub.line_attribs_ext_tbl_type;
4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

Line 4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;

4285: x_line_rltship_tbl aso_quote_pub.line_rltship_tbl_type;
4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4293: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

Line 4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;

4286: x_price_adjustment_tbl aso_quote_pub.price_adj_tbl_type;
4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4293: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4294: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

Line 4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;

4287: x_price_adj_attr_tbl aso_quote_pub.price_adj_attr_tbl_type;
4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4293: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4294: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4295: l_line_number NUMBER;

Line 4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;

4288: x_price_adj_rltship_tbl aso_quote_pub.price_adj_rltship_tbl_type;
4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4293: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4294: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4295: l_line_number NUMBER;
4296:

Line 4293: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;

4289: x_ln_price_attributes_tbl aso_quote_pub.price_attributes_tbl_type;
4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4293: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4294: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4295: l_line_number NUMBER;
4296:
4297: l_val VARCHAR2 ( 1 );

Line 4294: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;

4290: x_ln_payment_tbl aso_quote_pub.payment_tbl_type;
4291: x_ln_shipment_tbl aso_quote_pub.shipment_tbl_type;
4292: x_ln_freight_charge_tbl aso_quote_pub.freight_charge_tbl_type;
4293: x_ln_tax_detail_tbl aso_quote_pub.tax_detail_tbl_type;
4294: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4295: l_line_number NUMBER;
4296:
4297: l_val VARCHAR2 ( 1 );
4298: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;

Line 4298: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;

4294: l_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type;
4295: l_line_number NUMBER;
4296:
4297: l_val VARCHAR2 ( 1 );
4298: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
4299: l_qte_line_detail_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4300: l_qte_shipment_dtl_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4301: l_quantity NUMBER := 0;
4302: l_remaining_quantity NUMBER := 0;

Line 4299: l_qte_line_detail_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

4295: l_line_number NUMBER;
4296:
4297: l_val VARCHAR2 ( 1 );
4298: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
4299: l_qte_line_detail_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4300: l_qte_shipment_dtl_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4301: l_quantity NUMBER := 0;
4302: l_remaining_quantity NUMBER := 0;
4303: l_return_value Varchar2(1);

Line 4300: l_qte_shipment_dtl_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

4296:
4297: l_val VARCHAR2 ( 1 );
4298: l_qte_line_rec ASO_QUOTE_PUB.qte_line_rec_Type;
4299: l_qte_line_detail_tbl ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4300: l_qte_shipment_dtl_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4301: l_quantity NUMBER := 0;
4302: l_remaining_quantity NUMBER := 0;
4303: l_return_value Varchar2(1);
4304:

Line 4315: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

4311: l_api_version_number CONSTANT NUMBER := 1.0;
4312: l_api_version CONSTANT NUMBER := 1.0;
4313: l_service_item_flag VARCHAR2 ( 1 );
4314: l_serviceable_product_flag VARCHAR2 ( 1 );
4315: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4316: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 4316: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

4312: l_api_version CONSTANT NUMBER := 1.0;
4313: l_service_item_flag VARCHAR2 ( 1 );
4314: l_serviceable_product_flag VARCHAR2 ( 1 );
4315: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4316: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4313: l_service_item_flag VARCHAR2 ( 1 );
4314: l_serviceable_product_flag VARCHAR2 ( 1 );
4315: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4316: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

Line 4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

4314: l_serviceable_product_flag VARCHAR2 ( 1 );
4315: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4316: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

Line 4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;

4315: l_Line_Attr_Ext_Tbl ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4316: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

Line 4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;

4316: l_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

Line 4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

4317: l_Price_Attr_Tbl ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

4318: l_Price_Adj_Attr_Tbl ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4326: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

Line 4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

4319: l_payment_tbl ASO_QUOTE_PUB.Payment_Tbl_Type;
4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4326: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4327: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

Line 4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

4320: l_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4326: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4327: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4328: l_config_control_rec ASO_CFG_INT.Control_Rec_Type

Line 4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

4321: l_sales_credit_tbl ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4326: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4327: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4328: l_config_control_rec ASO_CFG_INT.Control_Rec_Type
4329: := ASO_CFG_INT.G_MISS_Control_Rec;

Line 4326: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

4322: l_quote_party_tbl ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4326: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4327: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4328: l_config_control_rec ASO_CFG_INT.Control_Rec_Type
4329: := ASO_CFG_INT.G_MISS_Control_Rec;
4330: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;

Line 4327: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;

4323: l_freight_charge_tbl ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4324: l_tax_detail_tbl ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4325: lx_ln_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4326: lx_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
4327: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type;
4328: l_config_control_rec ASO_CFG_INT.Control_Rec_Type
4329: := ASO_CFG_INT.G_MISS_Control_Rec;
4330: l_Copy_Quote_Control_Rec ASO_COPY_QUOTE_PUB.Copy_Quote_Control_Rec_Type;
4331: LX_PRICE_ADJ_RLTSHIP_ID NUMBER;

Line 4339: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

4335: l_ship_id NUMBER;
4336: -- l_appl_param_rec CZ_API_PUB.appl_param_rec_type;
4337: l_price_index_link_tbl ASO_QUOTE_HEADERS_PVT.Index_Link_Tbl_Type;
4338:
4339: l_quote_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type := ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;
4340: l_api_name varchar2(50) := 'Split_Model_Line';
4341: TYPE inserted_qte_line_Rec_Type IS RECORD
4342: (
4343: quote_line_id NUMBER:= FND_API.G_MISS_NUM,

Line 4355: l_qty_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;

4351: l_inserted_qte_line_tbl inserted_qte_line_Tbl_Type := G_MISS_inserted_qte_line_tbl;
4352:
4353: l_total_lines NUMBER := 0;
4354:
4355: l_qty_qte_line_tbl ASO_QUOTE_PUB.Qte_Line_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Qte_Line_Tbl;
4356: l_orig_item_id_tbl CZ_API_PUB.number_tbl_type;
4357: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
4358: -- hyang: for bug 2692785
4359: lx_status VARCHAR2(1);

Line 4361: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;

4357: l_new_item_id_tbl CZ_API_PUB.number_tbl_type;
4358: -- hyang: for bug 2692785
4359: lx_status VARCHAR2(1);
4360:
4361: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4362: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

Line 4362: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;

4358: -- hyang: for bug 2692785
4359: lx_status VARCHAR2(1);
4360:
4361: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4362: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

Line 4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;

4359: lx_status VARCHAR2(1);
4360:
4361: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4362: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

Line 4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;

4360:
4361: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4362: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

Line 4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;

4361: l_quote_party_tbl_out ASO_QUOTE_PUB.Quote_Party_Tbl_Type;
4362: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

Line 4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;

4362: l_sales_credit_tbl_out ASO_QUOTE_PUB.Sales_Credit_Tbl_Type;
4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4370: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

Line 4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;

4363: l_tax_detail_tbl_out ASO_QUOTE_PUB.Tax_Detail_Tbl_Type;
4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4370: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4371:

Line 4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;

4364: l_freight_charge_tbl_out ASO_QUOTE_PUB.Freight_Charge_Tbl_Type;
4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4370: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4371:
4372: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

Line 4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;

4365: l_shipment_tbl_out ASO_QUOTE_PUB.Shipment_Tbl_Type;
4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4370: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4371:
4372: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4373: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;

Line 4370: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;

4366: l_payment_tbl_out ASO_QUOTE_PUB.Payment_Tbl_Type;
4367: l_Price_Adj_Attr_Tbl_out ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type;
4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4370: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4371:
4372: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4373: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
4374:

Line 4372: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;

4368: l_Price_Attr_Tbl_out ASO_QUOTE_PUB.Price_Attributes_Tbl_Type;
4369: l_qte_line_detail_tbl_out ASO_QUOTE_PUB.Qte_Line_Dtl_Tbl_Type;
4370: l_Line_Attr_Ext_Tbl_out ASO_QUOTE_PUB.Line_Attribs_Ext_Tbl_Type;
4371:
4372: l_dup_Price_Adj_Tbl ASO_QUOTE_PUB.Price_Adj_Tbl_Type;
4373: l_ato_model VARCHAR2(1) := FND_API.G_FALSE;
4374:
4375:
4376: BEGIN

Line 4874: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl

4870: , P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
4871: , P_price_attributes_tbl => l_price_attr_tbl
4872: , P_Price_Adj_Tbl => l_price_adj_tbl
4873: , P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
4874: , P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
4875: , P_Shipment_Tbl => l_shipment_tbl
4876: , P_Freight_Charge_Tbl => l_freight_charge_tbl
4877: , P_Tax_Detail_Tbl => l_tax_detail_tbl
4878: , P_Sales_Credit_Tbl => l_sales_credit_tbl

Line 5293: l_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;

5289: l_control_rec.calculate_freight_charge_flag := 'Y';
5290: */
5291:
5292:
5293: l_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
5294:
5295: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5296: aso_debug_pub.ADD ( 'No Of Qte Lines 1 = '|| to_char(l_qte_line_tbl.count), 1 , 'N' );
5297: aso_debug_pub.ADD ( ' Setting the qty and op code for new line created ', 1 , 'N' );

Line 5332: aso_quote_pub.update_quote (

5328: aso_debug_pub.ADD ( 'No Of Qte Lines before update qty = '|| to_char(l_qte_line_tbl.count), 1 , 'N' );
5329: aso_debug_pub.ADD ( ' Calling Update Quote to update all lines ', 1 , 'N' );
5330: END IF;
5331:
5332: aso_quote_pub.update_quote (
5333: p_api_version_number => 1.0,
5334: p_init_msg_list => fnd_api.g_false,
5335: p_commit => fnd_api.g_false,
5336: p_control_rec => p_control_rec,

Line 5338: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

5334: p_init_msg_list => fnd_api.g_false,
5335: p_commit => fnd_api.g_false,
5336: p_control_rec => p_control_rec,
5337: p_qte_header_rec => l_quote_header_rec,
5338: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5339: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5340: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 5339: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

5335: p_commit => fnd_api.g_false,
5336: p_control_rec => p_control_rec,
5337: p_qte_header_rec => l_quote_header_rec,
5338: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5339: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5340: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5343: p_qte_line_tbl => l_qte_line_tbl,

Line 5340: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

5336: p_control_rec => p_control_rec,
5337: p_qte_header_rec => l_quote_header_rec,
5338: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5339: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5340: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5343: p_qte_line_tbl => l_qte_line_tbl,
5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

Line 5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

5337: p_qte_header_rec => l_quote_header_rec,
5338: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5339: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5340: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5343: p_qte_line_tbl => l_qte_line_tbl,
5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,

Line 5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

5338: p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5339: p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5340: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5343: p_qte_line_tbl => l_qte_line_tbl,
5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

Line 5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,

5340: p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5343: p_qte_line_tbl => l_qte_line_tbl,
5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

Line 5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,

5341: p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5343: p_qte_line_tbl => l_qte_line_tbl,
5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

Line 5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,

5342: p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5343: p_qte_line_tbl => l_qte_line_tbl,
5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

Line 5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,

5343: p_qte_line_tbl => l_qte_line_tbl,
5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

Line 5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,

5344: p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

Line 5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,

5345: p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5353: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

Line 5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,

5346: p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_tbl,
5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5353: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5354: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

Line 5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,

5347: p_price_adjustment_tbl => aso_quote_pub.g_miss_price_adj_tbl,
5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5353: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5354: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5355: x_qte_header_rec => x_qte_header_rec,

Line 5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,

5348: p_price_adj_attr_tbl => aso_quote_pub.g_miss_price_adj_attr_tbl,
5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5353: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5354: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5355: x_qte_header_rec => x_qte_header_rec,
5356: x_qte_line_tbl => x_qte_line_tbl,

Line 5353: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,

5349: p_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5353: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5354: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5355: x_qte_header_rec => x_qte_header_rec,
5356: x_qte_line_tbl => x_qte_line_tbl,
5357: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,

Line 5354: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,

5350: p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
5351: p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
5352: p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
5353: p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
5354: p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
5355: x_qte_header_rec => x_qte_header_rec,
5356: x_qte_line_tbl => x_qte_line_tbl,
5357: x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
5358: x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,

Line 5651: PROCEDURE copy_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,

5647:
5648:
5649: END INSERT_SALES_SUPP_DATA;
5650:
5651: PROCEDURE copy_payment_row(p_payment_rec IN aso_quote_pub.payment_rec_type,
5652: x_return_status OUT NOCOPY varchar2,
5653: x_msg_count OUT NOCOPY number,
5654: x_msg_data OUT NOCOPY varchar2) is
5655:

Line 5657: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;

5653: x_msg_count OUT NOCOPY number,
5654: x_msg_data OUT NOCOPY varchar2) is
5655:
5656: l_api_name varchar2(1000) := 'copy_payment_row';
5657: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
5658: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
5659: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
5660: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
5661: lx_assign_id number;

Line 5658: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;

5654: x_msg_data OUT NOCOPY varchar2) is
5655:
5656: l_api_name varchar2(1000) := 'copy_payment_row';
5657: l_payment_rec aso_quote_pub.payment_rec_type := p_payment_rec;
5658: l_qte_header_rec ASO_QUOTE_PUB.Qte_Header_Rec_Type;
5659: l_payer IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type;
5660: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
5661: lx_assign_id number;
5662: lx_entity_id number;

Line 5664: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;

5660: lx_response IBY_FNDCPT_COMMON_PUB.Result_rec_type;
5661: lx_assign_id number;
5662: lx_entity_id number;
5663: l_trxn_attribs IBY_FNDCPT_TRXN_PUB.TrxnExtension_rec_type;
5664: l_qte_line_rec ASO_QUOTE_PUB.Qte_Line_Rec_Type;
5665: l_entities IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
5666: l_payment_ref_number varchar2(240);
5667: lx_channel_attrib_uses IBY_FNDCPT_SETUP_PUB.PmtChannel_AttribUses_rec_type;
5668: