[Home] [Help]
PACKAGE: APPS.ASO_MAP_QUOTE_ORDER_INT
Source
1 PACKAGE ASO_MAP_QUOTE_ORDER_INT AUTHID CURRENT_USER as
2 /* $Header: asoimqos.pls 120.2.12010000.1 2008/07/28 22:14:30 appldev ship $ */
3 -- Start of Comments
4 -- Package name : ASO_MAP_QUOTE_ORDER_INT
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 -- Default number of records fetch per call
12 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
13
14
15 PROCEDURE Map_Quote_to_order(
16 P_Operation IN VARCHAR2,
17 P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
18 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
19 P_Header_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
20 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
21 P_Header_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
22 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
23 P_Header_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
24 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
25 P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
26 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
27 P_Header_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
28 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
29 P_Header_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
30 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
31 P_Header_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
32 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
33 P_Header_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
34 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
35 P_header_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
36 := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
37 P_Qte_Line_Tbl IN ASO_QUOTE_PUB.Qte_Line_Tbl_Type
38 := ASO_QUOTE_PUB.G_MISS_qte_line_TBL,
39 P_Qte_Line_Dtl_TBL IN ASO_QUOTE_PUB.Qte_Line_Dtl_TBL_Type
40 := ASO_QUOTE_PUB.G_MISS_qte_line_dtl_TBL,
41 P_Line_Payment_Tbl IN ASO_QUOTE_PUB.Payment_Tbl_Type
42 := ASO_QUOTE_PUB.G_MISS_Payment_TBL,
43 P_Line_Price_Adj_Tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type
44 := ASO_QUOTE_PUB.G_MISS_Price_Adj_TBL,
45 P_Line_Price_Attributes_Tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type
46 := ASO_QUOTE_PUB.G_MISS_Price_attributes_TBL,
47 P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
48 := ASO_QUOTE_PUB.G_MISS_price_adj_rltship_TBL,
49 P_Line_Price_Adj_Attr_Tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type
50 := ASO_QUOTE_PUB.G_Miss_PRICE_ADJ_ATTR_Tbl,
51 P_Line_Shipment_Tbl IN ASO_QUOTE_PUB.Shipment_Tbl_Type
52 := ASO_QUOTE_PUB.G_MISS_shipment_TBL,
53 P_Line_TAX_DETAIL_Tbl IN ASO_QUOTE_PUB.TAX_DETAIL_Tbl_Type
54 := ASO_QUOTE_PUB.G_MISS_TAX_DETAIL_TBL,
55 P_Line_FREIGHT_CHARGE_Tbl IN ASO_QUOTE_PUB.FREIGHT_CHARGE_Tbl_Type
56 := ASO_QUOTE_PUB.G_MISS_FREIGHT_CHARGE_Tbl,
57 P_Line_Rltship_Tbl IN ASO_QUOTE_PUB.Line_Rltship_Tbl_Type
58 := ASO_QUOTE_PUB.G_MISS_line_rltship_TBL,
59 P_Line_sales_credit_TBL IN ASO_QUOTE_PUB.Sales_credit_tbl_type
60 := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL,
61 P_Lot_Serial_Tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type
62 := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl,
63 P_Calculate_Price_Flag IN VARCHAR2 := FND_API.G_FALSE
64 , x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
65 , x_header_val_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Val_Rec_Type
66 , x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
67 , x_Header_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Val_Tbl_Type
68 , x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
69 , x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
70 , x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
71 , x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
72 , x_Header_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Val_Tbl_Type
73 , x_Header_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Payment_Tbl_Type
74 , x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
75 , x_line_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Val_Tbl_Type
76 , x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
77 , x_Line_Adj_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Val_Tbl_Type
78 , x_Line_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
79 , x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
80 , x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81 , x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
82 , x_Line_Scredit_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Val_Tbl_Type
83 , x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
84 , x_Lot_Serial_val_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Val_Tbl_Type
85 , x_Line_Payment_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Payment_Tbl_Type
86 );
87
88
89 PROCEDURE get_org_contact(
90 p_party_id IN NUMBER,
91 x_org_contact OUT NOCOPY /* file.sql.39 change */ number
92 );
93
94 PROCEDURE get_acct_site_uses
95 (
96 p_party_site_id IN NUMBER,
97 p_acct_site_type IN VARCHAR2,
98 p_cust_account_id IN NUMBER,
99 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
100 x_site_use_id OUT NOCOPY /* file.sql.39 change */ number
101 );
102
103 PROCEDURE get_cust_acct_roles
104 (
105 p_party_id IN NUMBER,
106 p_party_site_id IN NUMBER,
107 p_acct_site_type IN VARCHAR2,
108 p_cust_account_id IN NUMBER,
109 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
110 x_party_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
111 x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ number
112 );
113
114 PROCEDURE Get_Cust_Accnt_Id(
115 P_Qte_Rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type
116 := ASO_QUOTE_PUB.G_MISS_QTE_HEADER_REC,
117 p_Party_Id IN NUMBER,
118 p_Cust_Acct_Id OUT NOCOPY /* file.sql.39 change */ NUMBER,
119 x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
120 x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
121 x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
122
123 PROCEDURE get_org_contact_role(
124 p_Org_Contact_Id IN NUMBER
125 ,p_Cust_account_id IN NUMBER
126 ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
127 ,x_party_id OUT NOCOPY /* file.sql.39 change */ NUMBER
128 ,x_cust_account_role_id OUT NOCOPY /* file.sql.39 change */ NUMBER
129 );
130
131
132 PROCEDURE map_header_price_attr(
133 p_header_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
134 p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
135 p_operation IN VARCHAR2,
136 x_Header_price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
137 );
138
139 PROCEDURE map_header_price_adj(
140 p_header_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
141 p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
142 p_operation IN VARCHAR2 ,
143 x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
144 );
145
146 PROCEDURE map_header_price_adj_attr(
147 p_header_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
148 p_operation IN VARCHAR2,
149 x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
150 );
151
152 PROCEDURE map_header_price_adj_rltn(
153 P_Header_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
154 P_operation IN VARCHAR2,
155 x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
156 );
157
158 PROCEDURE map_header_sales_credits(
159 P_header_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type ,
160 p_operation IN VARCHAR2,
161 p_qte_rec IN ASO_QUOTE_PUB.Qte_Header_Rec_Type,
162 p_header_operation IN VARCHAR2,
163 x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
164 );
165
166 PROCEDURE map_line_price_att(
167 p_line_price_attributes_tbl IN ASO_QUOTE_PUB.Price_Attributes_Tbl_Type,
168 p_line_index IN NUMBER,
169 p_qte_line_index IN NUMBER,
170 p_operation IN VARCHAR2,
171 x_line_price_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type
172 );
173
174 PROCEDURE map_line_price_adj(
175 p_line_price_adj_tbl IN ASO_QUOTE_PUB.Price_Adj_Tbl_Type,
176 p_line_price_adj_attr_tbl IN ASO_QUOTE_PUB.Price_Adj_Attr_Tbl_Type,
177 p_line_index IN NUMBER,
178 p_qte_line_index IN NUMBER,
179 p_operation IN VARCHAR2,
180 x_line_adj_tbl IN OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
181 x_line_adj_att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
182 lx_Line_Price_Adj_rltship_Tbl IN OUT NOCOPY ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type
183 );
184
185
186 PROCEDURE map_line_price_adj_rltn(
187 P_Line_Price_Adj_rltship_Tbl IN ASO_QUOTE_PUB.Price_Adj_Rltship_Tbl_Type,
188 p_line_index IN NUMBER,
189 p_qte_line_index IN NUMBER,
190 p_operation IN VARCHAR2,
191 x_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
192 );
193
194 PROCEDURE map_line_sales_credit(
195 P_line_sales_credit_Tbl IN ASO_QUOTE_PUB.Sales_credit_tbl_type,
196 p_line_index IN NUMBER,
197 p_qte_line_index IN NUMBER,
198 p_line_operation IN VARCHAR2,
199 p_operation IN VARCHAR2,
200 x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
201 );
202
203 PROCEDURE map_lot_serial(
204 P_lot_serial_tbl IN ASO_QUOTE_PUB.Lot_Serial_Tbl_Type,
205 p_operation IN VARCHAR2,
206 p_line_index IN NUMBER,
207 p_qte_line_index IN NUMBER,
208 x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
209 );
210
211
212 -- Line Payments Change
213 PROCEDURE map_line_payments(
214 P_line_payment_Tbl IN ASO_QUOTE_PUB.payment_tbl_type,
215 p_line_index IN NUMBER,
216 p_qte_line_index IN NUMBER,
217 p_line_operation IN VARCHAR2,
218 p_operation IN VARCHAR2,
219 x_Line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
220 x_Line_Payment_tbl IN OUT NOCOPY OE_Order_PUB.Line_Payment_Tbl_Type
221 );
222
223
224 End ASO_MAP_QUOTE_ORDER_INT;