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.IBE_QUOTE_SAVESHARE_PVT dependencies on ASO_QUOTE_PUB

Line 65: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE

61: END get_Config_Rev_Nbr;
62:
63: FUNCTION getLineTblForControlledCopy(
64: p_quote_header_Id IN NUMBER
65: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
66: IS
67:
68: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
69: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

Line 68: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;

64: p_quote_header_Id IN NUMBER
65: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
66: IS
67:
68: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
69: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
70: CURSOR c_getlinetbl(l_quote_header_id number) IS
71: SELECT l.QUOTE_LINE_ID
72: ,l.CREATION_DATE

Line 69: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;

65: ) RETURN ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE
66: IS
67:
68: l_qte_line_rec ASO_QUOTE_PUB.QTE_LINE_REC_TYPE;
69: l_qte_line_tbl ASO_QUOTE_PUB.QTE_LINE_TBL_TYPE;
70: CURSOR c_getlinetbl(l_quote_header_id number) IS
71: SELECT l.QUOTE_LINE_ID
72: ,l.CREATION_DATE
73: ,l.CREATED_BY

Line 161: ,x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type

157:
158: ,p_from_quote_header_id IN NUMBER
159: ,p_to_quote_header_id IN NUMBER
160: ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
161: ,x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
162: ,x_qte_line_dtl_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

Line 162: ,x_qte_line_dtl_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type

158: ,p_from_quote_header_id IN NUMBER
159: ,p_to_quote_header_id IN NUMBER
160: ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
161: ,x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
162: ,x_qte_line_dtl_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
166: ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

Line 163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type

159: ,p_to_quote_header_id IN NUMBER
160: ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
161: ,x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
162: ,x_qte_line_dtl_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
166: ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
167: ,x_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type

Line 164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type

160: ,p_mode IN VARCHAR2 := FND_API.G_MISS_CHAR
161: ,x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
162: ,x_qte_line_dtl_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
166: ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
167: ,x_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
168: )

Line 165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type

161: ,x_qte_line_tbl OUT NOCOPY ASO_Quote_Pub.qte_line_tbl_type
162: ,x_qte_line_dtl_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
166: ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
167: ,x_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
168: )
169: IS

Line 166: ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type

162: ,x_qte_line_dtl_tbl OUT NOCOPY ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type
163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
166: ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
167: ,x_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
168: )
169: IS
170:

Line 167: ,x_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type

163: ,x_line_attr_ext_tbl OUT NOCOPY ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type
164: ,x_line_rltship_tbl OUT NOCOPY ASO_Quote_Pub.Line_Rltship_tbl_Type
165: ,x_ln_price_attributes_tbl OUT NOCOPY ASO_Quote_Pub.Price_Attributes_Tbl_Type
166: ,x_Price_Adjustment_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Tbl_Type
167: ,x_Price_Adj_Rltship_Tbl IN OUT NOCOPY ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type
168: )
169: IS
170:
171: l_api_name CONSTANT VARCHAR2(30) := 'Copy_lines';

Line 174: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;

170:
171: l_api_name CONSTANT VARCHAR2(30) := 'Copy_lines';
172: l_api_version CONSTANT NUMBER := 1.0;
173:
174: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
175: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
176: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
177: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
178:

Line 175: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;

171: l_api_name CONSTANT VARCHAR2(30) := 'Copy_lines';
172: l_api_version CONSTANT NUMBER := 1.0;
173:
174: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
175: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
176: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
177: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
178:
179: l_old_config_hdr_id NUMBER;

Line 176: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;

172: l_api_version CONSTANT NUMBER := 1.0;
173:
174: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
175: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
176: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
177: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
178:
179: l_old_config_hdr_id NUMBER;
180: l_old_config_rev_nbr NUMBER;

Line 177: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

173:
174: l_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
175: l_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
176: l_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
177: l_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
178:
179: l_old_config_hdr_id NUMBER;
180: l_old_config_rev_nbr NUMBER;
181:

Line 187: l_Price_Adjustment_Tbl_ALL ASO_Quote_Pub.Price_Adj_Tbl_Type;

183: l_new_config_rev_nbr NUMBER;
184: --l_return_value NUMBER;
185:
186: -- added 12/22/03: PRG, no line merge
187: l_Price_Adjustment_Tbl_ALL ASO_Quote_Pub.Price_Adj_Tbl_Type;
188: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
189: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
190:
191: --added for 11.5.11 Duplicate Cart feature

Line 188: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

184: --l_return_value NUMBER;
185:
186: -- added 12/22/03: PRG, no line merge
187: l_Price_Adjustment_Tbl_ALL ASO_Quote_Pub.Price_Adj_Tbl_Type;
188: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
189: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
190:
191: --added for 11.5.11 Duplicate Cart feature
192: l_permission_to_create_agrmt BOOLEAN;

Line 189: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

185:
186: -- added 12/22/03: PRG, no line merge
187: l_Price_Adjustment_Tbl_ALL ASO_Quote_Pub.Price_Adj_Tbl_Type;
188: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
189: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
190:
191: --added for 11.5.11 Duplicate Cart feature
192: l_permission_to_create_agrmt BOOLEAN;
193: l_use_line_agrmts VARCHAR2(2);

Line 679: ,p_to_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type

675: ,x_msg_data OUT NOCOPY VARCHAR2
676: ,p_from_quote_header_id IN NUMBER
677: ,p_from_last_update_date IN DATE
678: ,p_copy_only_header IN VARCHAR2 := FND_API.G_FALSE
679: ,p_to_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
680: := ASO_Quote_Pub.G_Miss_Control_Rec
681: ,p_to_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
682: ,p_to_hd_Shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type
683: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec

Line 680: := ASO_Quote_Pub.G_Miss_Control_Rec

676: ,p_from_quote_header_id IN NUMBER
677: ,p_from_last_update_date IN DATE
678: ,p_copy_only_header IN VARCHAR2 := FND_API.G_FALSE
679: ,p_to_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
680: := ASO_Quote_Pub.G_Miss_Control_Rec
681: ,p_to_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
682: ,p_to_hd_Shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type
683: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec
684: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 681: ,p_to_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type

677: ,p_from_last_update_date IN DATE
678: ,p_copy_only_header IN VARCHAR2 := FND_API.G_FALSE
679: ,p_to_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
680: := ASO_Quote_Pub.G_Miss_Control_Rec
681: ,p_to_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
682: ,p_to_hd_Shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type
683: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec
684: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
685: ,p_sharee_email_address IN jtf_varchar2_table_2000 := NULL

Line 682: ,p_to_hd_Shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type

678: ,p_copy_only_header IN VARCHAR2 := FND_API.G_FALSE
679: ,p_to_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
680: := ASO_Quote_Pub.G_Miss_Control_Rec
681: ,p_to_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
682: ,p_to_hd_Shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type
683: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec
684: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
685: ,p_sharee_email_address IN jtf_varchar2_table_2000 := NULL
686: ,p_sharee_privilege_type IN jtf_varchar2_table_100 := NULL

Line 683: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec

679: ,p_to_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
680: := ASO_Quote_Pub.G_Miss_Control_Rec
681: ,p_to_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
682: ,p_to_hd_Shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type
683: := ASO_Quote_Pub.G_MISS_SHIPMENT_rec
684: ,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
685: ,p_sharee_email_address IN jtf_varchar2_table_2000 := NULL
686: ,p_sharee_privilege_type IN jtf_varchar2_table_100 := NULL
687: ,p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 703: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

699: l_cust_account_id NUMBER ;
700: l_quote_number NUMBER := null;
701: l_quote_status_id NUMBER := null;
702:
703: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
704:
705: l_to_hd_shipment_tbl ASO_Quote_Pub.shipment_tbl_type;
706:
707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

Line 705: l_to_hd_shipment_tbl ASO_Quote_Pub.shipment_tbl_type;

701: l_quote_status_id NUMBER := null;
702:
703: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
704:
705: l_to_hd_shipment_tbl ASO_Quote_Pub.shipment_tbl_type;
706:
707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
708: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
709: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;

Line 707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

703: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
704:
705: l_to_hd_shipment_tbl ASO_Quote_Pub.shipment_tbl_type;
706:
707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
708: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
709: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
710: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 708: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;

704:
705: l_to_hd_shipment_tbl ASO_Quote_Pub.shipment_tbl_type;
706:
707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
708: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
709: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
710: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
712:

Line 709: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;

705: l_to_hd_shipment_tbl ASO_Quote_Pub.shipment_tbl_type;
706:
707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
708: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
709: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
710: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
712:
713: -- added 12/22/03: PRG, no line merge

Line 710: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;

706:
707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
708: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
709: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
710: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
712:
713: -- added 12/22/03: PRG, no line merge
714: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

Line 711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

707: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
708: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
709: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
710: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
712:
713: -- added 12/22/03: PRG, no line merge
714: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
715: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

Line 714: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

710: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
712:
713: -- added 12/22/03: PRG, no line merge
714: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
715: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
716:
717: CURSOR c_order_type(p_quote_header_id NUMBER) IS
718: SELECT order_type_id

Line 715: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

711: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
712:
713: -- added 12/22/03: PRG, no line merge
714: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
715: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
716:
717: CURSOR c_order_type(p_quote_header_id NUMBER) IS
718: SELECT order_type_id
719: FROM aso_quote_headers

Line 800: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));

796: l_quote_number := l_to_qte_header_rec.quote_number;
797: END IF;
798:
799: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
800: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
801: END IF;
802:
803: ASO_Quote_Pub.Copy_Quote(
804: p_api_version_number => p_api_version_number

Line 803: ASO_Quote_Pub.Copy_Quote(

799: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
800: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
801: END IF;
802:
803: ASO_Quote_Pub.Copy_Quote(
804: p_api_version_number => p_api_version_number
805: ,p_init_msg_list => FND_API.G_FALSE
806: ,p_commit => FND_API.G_FALSE
807: ,p_qte_header_id => p_from_quote_header_id

Line 819: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() finishes at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));

815: ,x_Msg_Count => x_Msg_Count
816: ,x_Msg_Data => x_Msg_Data);
817:
818: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
819: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() finishes at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
820: END IF;
821:
822: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
823: RAISE FND_API.G_EXC_ERROR;

Line 1002: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,

998: p_sharee_email_address IN jtf_varchar2_table_2000 := NULL,
999: p_sharee_privilege_type IN jtf_varchar2_table_100 := NULL,
1000: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1001: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1002: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,
1003: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR ,
1004: p_rep_app_invTo_partySiteId IN NUMBER := FND_API.G_MISS_NUM ,
1005: p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,
1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,

Line 1005: p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,

1001: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1002: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,
1003: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR ,
1004: p_rep_app_invTo_partySiteId IN NUMBER := FND_API.G_MISS_NUM ,
1005: p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,
1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,
1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,

Line 1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,

1002: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,
1003: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR ,
1004: p_rep_app_invTo_partySiteId IN NUMBER := FND_API.G_MISS_NUM ,
1005: p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,
1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,
1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,

Line 1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,

1003: p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR ,
1004: p_rep_app_invTo_partySiteId IN NUMBER := FND_API.G_MISS_NUM ,
1005: p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,
1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,
1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,
1011: p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,

Line 1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,

1004: p_rep_app_invTo_partySiteId IN NUMBER := FND_API.G_MISS_NUM ,
1005: p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,
1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,
1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,
1011: p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,
1012: p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type:= ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl,

Line 1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,

1005: p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,
1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,
1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,
1011: p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,
1012: p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type:= ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl,
1013: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,

Line 1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,

1006: p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,
1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,
1011: p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,
1012: p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type:= ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl,
1013: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
1014: p_party_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1011: p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,

1007: p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,
1011: p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,
1012: p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type:= ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl,
1013: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
1014: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
1015: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1012: p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type:= ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl,

1008: p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
1009: p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
1010: p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,
1011: p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,
1012: p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type:= ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl,
1013: p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
1014: p_party_id IN NUMBER := FND_API.G_MISS_NUM,
1015: p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
1016: p_validate_user IN VARCHAR2 := FND_API.G_FALSE,

Line 1025: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;

1021: is
1022: l_api_name CONSTANT VARCHAR2(30) := 'APPENDTOREPLACESHARE';
1023: l_api_version CONSTANT NUMBER := 1.0;
1024:
1025: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
1026: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
1027: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
1028: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
1029: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;

Line 1026: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;

1022: l_api_name CONSTANT VARCHAR2(30) := 'APPENDTOREPLACESHARE';
1023: l_api_version CONSTANT NUMBER := 1.0;
1024:
1025: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
1026: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
1027: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
1028: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
1029: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1030: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

Line 1027: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;

1023: l_api_version CONSTANT NUMBER := 1.0;
1024:
1025: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
1026: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
1027: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
1028: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
1029: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1030: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1031: q_ver number(5);

Line 1028: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;

1024:
1025: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
1026: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
1027: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
1028: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
1029: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1030: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1031: q_ver number(5);
1032: q_num number(5);

Line 1029: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;

1025: l_to_qte_header_rec ASO_Quote_Pub.qte_header_rec_type;
1026: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
1027: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
1028: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
1029: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1030: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1031: q_ver number(5);
1032: q_num number(5);
1033: l_quote_to_copy NUMBER;

Line 1030: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;

1026: l_to_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type;
1027: l_to_line_rltship_tbl ASO_Quote_Pub.Line_Rltship_tbl_Type;
1028: l_to_qte_line_dtl_tbl ASO_Quote_Pub.Qte_Line_Dtl_tbl_Type;
1029: l_to_line_attr_ext_tbl ASO_Quote_Pub.Line_Attribs_Ext_tbl_Type;
1030: l_to_ln_price_attributes_tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type;
1031: q_ver number(5);
1032: q_num number(5);
1033: l_quote_to_copy NUMBER;
1034: l_quote_header_id_tmp NUMBER;

Line 1071: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;

1067: l_target_cart_owner number;
1068: l_source_cart_owner number;
1069:
1070: -- added 12/22/03: PRG, no line merge
1071: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1072: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1073:
1074: BEGIN
1075: --IBE_UTIL.ENABLE_DEBUG;

Line 1072: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;

1068: l_source_cart_owner number;
1069:
1070: -- added 12/22/03: PRG, no line merge
1071: l_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type;
1072: l_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type;
1073:
1074: BEGIN
1075: --IBE_UTIL.ENABLE_DEBUG;
1076: IF (IBE_UTIL.G_DEBUGON = l_true) THEN

Line 1227: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts');

1223: ((p_mode = 'APPENDTO') and (fnd_api.to_Boolean(p_increaseversion)))) then
1224:
1225:
1226: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1227: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts');
1228: END IF;
1229: aso_quote_pub.copy_quote(
1230: p_api_version_number => P_Api_Version_Number
1231: ,p_init_msg_list => fnd_api.g_false

Line 1229: aso_quote_pub.copy_quote(

1225:
1226: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1227: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts');
1228: END IF;
1229: aso_quote_pub.copy_quote(
1230: p_api_version_number => P_Api_Version_Number
1231: ,p_init_msg_list => fnd_api.g_false
1232: ,p_commit => fnd_api.g_false
1233: ,p_qte_header_id => l_quote_to_copy

Line 1243: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() finishes');

1239: ,X_Msg_Count => x_Msg_Count
1240: ,X_Msg_Data => x_Msg_Data);
1241:
1242: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1243: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() finishes');
1244: IBE_Util.Debug('x_qte_header_id: ' || l_to_qte_header_rec.quote_header_id);
1245: END IF;
1246:
1247: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1613: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

1609: )
1610: IS
1611: l_api_name CONSTANT VARCHAR2(30) := 'ActivateQuote';
1612: l_api_version CONSTANT NUMBER := 1.0;
1613: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1614: := ASO_Quote_Pub.g_miss_qte_header_rec;
1615: l_control_rec aso_quote_pub.control_rec_type
1616: := aso_quote_pub.g_miss_control_rec;
1617: l_party_id NUMBER;

Line 1614: := ASO_Quote_Pub.g_miss_qte_header_rec;

1610: IS
1611: l_api_name CONSTANT VARCHAR2(30) := 'ActivateQuote';
1612: l_api_version CONSTANT NUMBER := 1.0;
1613: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1614: := ASO_Quote_Pub.g_miss_qte_header_rec;
1615: l_control_rec aso_quote_pub.control_rec_type
1616: := aso_quote_pub.g_miss_control_rec;
1617: l_party_id NUMBER;
1618: l_cust_account_id NUMBER;

Line 1615: l_control_rec aso_quote_pub.control_rec_type

1611: l_api_name CONSTANT VARCHAR2(30) := 'ActivateQuote';
1612: l_api_version CONSTANT NUMBER := 1.0;
1613: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1614: := ASO_Quote_Pub.g_miss_qte_header_rec;
1615: l_control_rec aso_quote_pub.control_rec_type
1616: := aso_quote_pub.g_miss_control_rec;
1617: l_party_id NUMBER;
1618: l_cust_account_id NUMBER;
1619:

Line 1616: := aso_quote_pub.g_miss_control_rec;

1612: l_api_version CONSTANT NUMBER := 1.0;
1613: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1614: := ASO_Quote_Pub.g_miss_qte_header_rec;
1615: l_control_rec aso_quote_pub.control_rec_type
1616: := aso_quote_pub.g_miss_control_rec;
1617: l_party_id NUMBER;
1618: l_cust_account_id NUMBER;
1619:
1620: l_quote_header_id_tmp NUMBER;

Line 1693: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));

1689:
1690:
1691: IF FND_API.To_Boolean(p_increaseVersion) THEN
1692: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1693: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1694: END IF;
1695:
1696: ASO_Quote_Pub.Copy_Quote(
1697: P_Api_Version_Number => P_Api_Version_Number

Line 1696: ASO_Quote_Pub.Copy_Quote(

1692: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1693: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() starts at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1694: END IF;
1695:
1696: ASO_Quote_Pub.Copy_Quote(
1697: P_Api_Version_Number => P_Api_Version_Number
1698: ,P_Init_Msg_List => FND_API.G_FALSE
1699: ,P_Commit => FND_API.G_FALSE
1700: ,P_Qte_Header_Id => l_qte_header_rec.quote_header_id

Line 1708: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() finishes at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));

1704: ,X_Msg_Count => x_msg_count
1705: ,X_Msg_Data => x_msg_data);
1706:
1707: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1708: IBE_Util.Debug('ASO_Quote_Pub.Copy_Quote() finishes at ' || TO_CHAR(SYSDATE, 'MM/DD/YYYY:HH24:MI:SS'));
1709: END IF;
1710:
1711: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1712: RAISE FND_API.G_EXC_ERROR;

Line 1860: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,

1856: p_sharee_party_id IN NUMBER := FND_API.G_MISS_NUM ,
1857: p_sharee_cust_account_id IN NUMBER := FND_API.G_MISS_NUM ,
1858: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
1859: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
1860: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,
1861: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
1862: x_quote_header_id OUT NOCOPY NUMBER ,
1863: x_last_update_date OUT NOCOPY DATE ,
1864: x_privilege_type_code OUT NOCOPY VARCHAR2

Line 1873: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

1869: l_api_version CONSTANT NUMBER := 1.0;
1870: l_expiration_date_tmp DATE;
1871: l_pricebasedonowner varchar2(30);
1872:
1873: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1874: := ASO_Quote_Pub.g_miss_qte_header_rec;
1875: -- temp var for NOCOPY OUT parameter
1876:
1877: l_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type

Line 1874: := ASO_Quote_Pub.g_miss_qte_header_rec;

1870: l_expiration_date_tmp DATE;
1871: l_pricebasedonowner varchar2(30);
1872:
1873: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1874: := ASO_Quote_Pub.g_miss_qte_header_rec;
1875: -- temp var for NOCOPY OUT parameter
1876:
1877: l_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
1878: := ASO_Quote_Pub.g_miss_qte_header_rec;

Line 1877: l_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type

1873: l_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
1874: := ASO_Quote_Pub.g_miss_qte_header_rec;
1875: -- temp var for NOCOPY OUT parameter
1876:
1877: l_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
1878: := ASO_Quote_Pub.g_miss_qte_header_rec;
1879: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1880: := ASO_Quote_Pub.g_miss_qte_line_tbl;
1881: begin

Line 1878: := ASO_Quote_Pub.g_miss_qte_header_rec;

1874: := ASO_Quote_Pub.g_miss_qte_header_rec;
1875: -- temp var for NOCOPY OUT parameter
1876:
1877: l_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
1878: := ASO_Quote_Pub.g_miss_qte_header_rec;
1879: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1880: := ASO_Quote_Pub.g_miss_qte_line_tbl;
1881: begin
1882:

Line 1879: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type

1875: -- temp var for NOCOPY OUT parameter
1876:
1877: l_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
1878: := ASO_Quote_Pub.g_miss_qte_header_rec;
1879: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1880: := ASO_Quote_Pub.g_miss_qte_line_tbl;
1881: begin
1882:
1883: -- Standard Start of API savepoint

Line 1880: := ASO_Quote_Pub.g_miss_qte_line_tbl;

1876:
1877: l_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
1878: := ASO_Quote_Pub.g_miss_qte_header_rec;
1879: lx_qte_line_tbl ASO_Quote_Pub.qte_line_tbl_type
1880: := ASO_Quote_Pub.g_miss_qte_line_tbl;
1881: begin
1882:
1883: -- Standard Start of API savepoint
1884: SAVEPOINT RETRIEVESHAREQUOTE_pvt;

Line 2070: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,

2066: p_quote_source_code IN VARCHAR2 := 'IStore Account' ,
2067: p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
2068: p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
2069: p_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
2070: p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,
2071: x_quote_header_id OUT NOCOPY NUMBER ,
2072: x_last_update_date OUT NOCOPY DATE ,
2073: x_retrieval_number OUT NOCOPY NUMBER
2074: )

Line 2078: l_db_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

2074: )
2075: IS
2076: l_api_name CONSTANT VARCHAR2(30) := 'MergeActiveQuote';
2077: l_api_version CONSTANT NUMBER := 1.0;
2078: l_db_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2079: := ASO_Quote_Pub.g_miss_qte_header_rec;
2080:
2081: l_in_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2082: := ASO_Quote_Pub.g_miss_qte_header_rec;

Line 2079: := ASO_Quote_Pub.g_miss_qte_header_rec;

2075: IS
2076: l_api_name CONSTANT VARCHAR2(30) := 'MergeActiveQuote';
2077: l_api_version CONSTANT NUMBER := 1.0;
2078: l_db_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2079: := ASO_Quote_Pub.g_miss_qte_header_rec;
2080:
2081: l_in_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2082: := ASO_Quote_Pub.g_miss_qte_header_rec;
2083:

Line 2081: l_in_qte_header_rec ASO_Quote_Pub.qte_header_rec_type

2077: l_api_version CONSTANT NUMBER := 1.0;
2078: l_db_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2079: := ASO_Quote_Pub.g_miss_qte_header_rec;
2080:
2081: l_in_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2082: := ASO_Quote_Pub.g_miss_qte_header_rec;
2083:
2084: l_default_save_qte_hdr_rec ASO_Quote_Pub.qte_header_rec_type
2085: := ASO_Quote_Pub.g_miss_qte_header_rec;

Line 2082: := ASO_Quote_Pub.g_miss_qte_header_rec;

2078: l_db_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2079: := ASO_Quote_Pub.g_miss_qte_header_rec;
2080:
2081: l_in_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2082: := ASO_Quote_Pub.g_miss_qte_header_rec;
2083:
2084: l_default_save_qte_hdr_rec ASO_Quote_Pub.qte_header_rec_type
2085: := ASO_Quote_Pub.g_miss_qte_header_rec;
2086:

Line 2084: l_default_save_qte_hdr_rec ASO_Quote_Pub.qte_header_rec_type

2080:
2081: l_in_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2082: := ASO_Quote_Pub.g_miss_qte_header_rec;
2083:
2084: l_default_save_qte_hdr_rec ASO_Quote_Pub.qte_header_rec_type
2085: := ASO_Quote_Pub.g_miss_qte_header_rec;
2086:
2087: l_quote_header_id number;
2088:

Line 2085: := ASO_Quote_Pub.g_miss_qte_header_rec;

2081: l_in_qte_header_rec ASO_Quote_Pub.qte_header_rec_type
2082: := ASO_Quote_Pub.g_miss_qte_header_rec;
2083:
2084: l_default_save_qte_hdr_rec ASO_Quote_Pub.qte_header_rec_type
2085: := ASO_Quote_Pub.g_miss_qte_header_rec;
2086:
2087: l_quote_header_id number;
2088:
2089: l_promote_guest_cart VARCHAR2(2) := FND_API.G_FALSE;

Line 2094: l_control_rec ASO_Quote_Pub.Control_Rec_Type

2090: l_retrieval_number NUMBER;
2091: l_resource_id NUMBER;
2092: l_publish_flag VARCHAR2(1);
2093: l_currency_code VARCHAR2(100);
2094: l_control_rec ASO_Quote_Pub.Control_Rec_Type
2095: := ASO_Quote_Pub.G_MISS_Control_Rec;
2096:
2097: cursor c_getHdr(p_quote_header_id number) is
2098: select quote_header_id,

Line 2095: := ASO_Quote_Pub.G_MISS_Control_Rec;

2091: l_resource_id NUMBER;
2092: l_publish_flag VARCHAR2(1);
2093: l_currency_code VARCHAR2(100);
2094: l_control_rec ASO_Quote_Pub.Control_Rec_Type
2095: := ASO_Quote_Pub.G_MISS_Control_Rec;
2096:
2097: cursor c_getHdr(p_quote_header_id number) is
2098: select quote_header_id,
2099: last_update_date,

Line 2136: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

2132:
2133: rec_getHdr c_getHdr%rowtype;
2134: rec_get_retrieval_num c_get_retrieval_num%rowtype;
2135: -- 8/12/02: added the following parameters for Default Feature
2136: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2137: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

Line 2137: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

2133: rec_getHdr c_getHdr%rowtype;
2134: rec_get_retrieval_num c_get_retrieval_num%rowtype;
2135: -- 8/12/02: added the following parameters for Default Feature
2136: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2137: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

Line 2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

2134: rec_get_retrieval_num c_get_retrieval_num%rowtype;
2135: -- 8/12/02: added the following parameters for Default Feature
2136: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2137: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2142: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;

Line 2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;

2135: -- 8/12/02: added the following parameters for Default Feature
2136: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2137: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2142: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2143: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;

Line 2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

2136: lx_Hd_Price_Attributes_Tbl ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2137: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2142: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2143: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2144:

Line 2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

2137: lx_Hd_Payment_Tbl ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2142: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2143: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2144:
2145: -- temp vars for OUT params (NOCOPY chngs)

Line 2142: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;

2138: lx_Hd_Shipment_Tbl ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2142: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2143: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2144:
2145: -- temp vars for OUT params (NOCOPY chngs)
2146: l_quote_header_id_tmp number;

Line 2143: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;

2139: lx_Hd_Freight_Charge_Tbl ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2140: lx_Hd_Tax_Detail_Tbl ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2141: lx_Price_Adjustment_Tbl ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2142: lx_Price_Adj_Attr_Tbl ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2143: lx_Price_Adj_Rltship_Tbl ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2144:
2145: -- temp vars for OUT params (NOCOPY chngs)
2146: l_quote_header_id_tmp number;
2147: l_last_update_date_tmp DATE;

Line 2148: lx_Hd_Price_Attributes_Tbl_tmp ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;

2144:
2145: -- temp vars for OUT params (NOCOPY chngs)
2146: l_quote_header_id_tmp number;
2147: l_last_update_date_tmp DATE;
2148: lx_Hd_Price_Attributes_Tbl_tmp ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2149: lx_Hd_Payment_Tbl_tmp ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

Line 2149: lx_Hd_Payment_Tbl_tmp ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;

2145: -- temp vars for OUT params (NOCOPY chngs)
2146: l_quote_header_id_tmp number;
2147: l_last_update_date_tmp DATE;
2148: lx_Hd_Price_Attributes_Tbl_tmp ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2149: lx_Hd_Payment_Tbl_tmp ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

Line 2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;

2146: l_quote_header_id_tmp number;
2147: l_last_update_date_tmp DATE;
2148: lx_Hd_Price_Attributes_Tbl_tmp ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2149: lx_Hd_Payment_Tbl_tmp ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;

Line 2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;

2147: l_last_update_date_tmp DATE;
2148: lx_Hd_Price_Attributes_Tbl_tmp ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2149: lx_Hd_Payment_Tbl_tmp ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;

Line 2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;

2148: lx_Hd_Price_Attributes_Tbl_tmp ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl;
2149: lx_Hd_Payment_Tbl_tmp ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2156: l_db_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type

Line 2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;

2149: lx_Hd_Payment_Tbl_tmp ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL;
2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2156: l_db_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
2157: := ASO_Quote_Pub.g_miss_qte_header_rec;

Line 2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;

2150: lx_Hd_Shipment_Tbl_tmp ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL;
2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2156: l_db_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
2157: := ASO_Quote_Pub.g_miss_qte_header_rec;
2158:

Line 2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;

2151: lx_Hd_Freight_Charge_Tbl_tmp ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl;
2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2156: l_db_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
2157: := ASO_Quote_Pub.g_miss_qte_header_rec;
2158:
2159: --end of default feature params

Line 2156: l_db_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type

2152: lx_Hd_Tax_Detail_Tbl_tmp ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl;
2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2156: l_db_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
2157: := ASO_Quote_Pub.g_miss_qte_header_rec;
2158:
2159: --end of default feature params
2160: --MANNAMRA: 09/16/02 for save/share

Line 2157: := ASO_Quote_Pub.g_miss_qte_header_rec;

2153: lx_Price_Adjustment_Tbl_tmp ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl;
2154: lx_Price_Adj_Attr_Tbl_tmp ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl;
2155: lx_Price_Adj_Rltship_Tbl_tmp ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl;
2156: l_db_qte_header_rec_tmp ASO_Quote_Pub.qte_header_rec_type
2157: := ASO_Quote_Pub.g_miss_qte_header_rec;
2158:
2159: --end of default feature params
2160: --MANNAMRA: 09/16/02 for save/share
2161: l_saveshare_control_rec IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type

Line 3153: l_qte_header_rec ASO_Quote_Pub.QTE_HEADER_REC_TYPE

3149: l_api_name CONSTANT VARCHAR2(30) := 'Emailsharee';
3150: l_api_version CONSTANT NUMBER := 1.0;
3151: l_url varchar2(2000);
3152:
3153: l_qte_header_rec ASO_Quote_Pub.QTE_HEADER_REC_TYPE
3154: := ASO_Quote_Pub.g_miss_qte_header_rec;
3155:
3156: cursor C_GETHEADERREC(qte_header_id number) is
3157: select quote_password, quote_number, quote_version

Line 3154: := ASO_Quote_Pub.g_miss_qte_header_rec;

3150: l_api_version CONSTANT NUMBER := 1.0;
3151: l_url varchar2(2000);
3152:
3153: l_qte_header_rec ASO_Quote_Pub.QTE_HEADER_REC_TYPE
3154: := ASO_Quote_Pub.g_miss_qte_header_rec;
3155:
3156: cursor C_GETHEADERREC(qte_header_id number) is
3157: select quote_password, quote_number, quote_version
3158: from aso_quote_headers