DBA Data[Home] [Help]

PACKAGE: APPS.OE_PORTAL_HEADER

Source


1 PACKAGE OE_Portal_Header AS
2 /* $Header: OEXHPORS.pls 120.0 2005/06/01 23:09:19 appldev noship $ */
3 
4 
5 g_header_rec          OE_ORDER_PUB.Header_Rec_Type;
6 g_db_header_rec          OE_ORDER_PUB.Header_Rec_Type;
7 
8 
9 PROCEDURE Default_Header_Attributes
10 ( x_return_status OUT NOCOPY VARCHAR2
11 
12 , x_msg_count OUT NOCOPY NUMBER
13 
14 , x_msg_data OUT NOCOPY VARCHAR2
15 
16 , p_sold_to_org_id                IN  NUMBER
17 , x_agreement_id OUT NOCOPY NUMBER
18 
19 , x_freight_carrier_code OUT NOCOPY VARCHAR2
20 
21 , x_freight_terms_code OUT NOCOPY VARCHAR2
22 
23 , x_header_id OUT NOCOPY VARCHAR2
24 
25 , x_invoice_to_org_id OUT NOCOPY NUMBER
26 
27 , x_order_type_id OUT NOCOPY NUMBER
28 
29 , x_org_id OUT NOCOPY NUMBER
30 
31 , x_partial_shipments_allowed OUT NOCOPY VARCHAR2
32 
33 , x_payment_term_id OUT NOCOPY NUMBER
34 
35 , x_price_list_id OUT NOCOPY NUMBER
36 
37 , x_shipment_priority_code OUT NOCOPY VARCHAR2
38 
39 , x_shipping_method_code OUT NOCOPY VARCHAR2
40 
41 , x_ship_to_org_id OUT NOCOPY NUMBER
42 
43 , x_sold_to_org_id OUT NOCOPY NUMBER
44 
45 , x_tax_exempt_flag OUT NOCOPY VARCHAR2
46 
47 , x_tax_exempt_number OUT NOCOPY VARCHAR2
48 
49 , x_tax_point_code OUT NOCOPY VARCHAR2
50 
51 , x_transactional_curr_code OUT NOCOPY VARCHAR2
52 
53 , x_payment_type_code OUT NOCOPY VARCHAR2
54 
55 , x_shipping_instructions OUT NOCOPY VARCHAR2
56 
57 , x_shipping_method OUT NOCOPY VARCHAR2
58 
59 , x_freight_terms OUT NOCOPY VARCHAR2
60 
61 , x_invoice_to_address1 OUT NOCOPY VARCHAR2
62 
63 , x_invoice_to_address2 OUT NOCOPY VARCHAR2
64 
65 , x_invoice_to_address3 OUT NOCOPY VARCHAR2
66 
67 , x_invoice_to_address4 OUT NOCOPY VARCHAR2
68 
69 , x_payment_term OUT NOCOPY VARCHAR2
70 
71 , x_shipment_priority OUT NOCOPY varchar2
72 
73 , x_ship_to_address1 OUT NOCOPY VARCHAR2
74 
75 , x_ship_to_address2 OUT NOCOPY VARCHAR2
76 
77 , x_ship_to_address3 OUT NOCOPY VARCHAR2
78 
79 , x_ship_to_address4 OUT NOCOPY VARCHAR2
80 
81 , x_sold_to_org OUT NOCOPY VARCHAR2
82 
83 , x_tax_point OUT NOCOPY VARCHAR2
84 
85 ,x_request_date OUT NOCOPY DATE
86 
87 , x_tax_exempt OUT NOCOPY VARCHAR2
88 
89 , x_partial_shipments OUT NOCOPY VARCHAR2
90 
91 , x_order_type OUT NOCOPY VARCHAR2
92 
93 , x_customer_number OUT NOCOPY VARCHAR2
94 
95 );
96 
97 
98 PROCEDURE Validate_Write_Header
99 ( x_return_status OUT NOCOPY VARCHAR2
100 
101 , x_msg_count OUT NOCOPY NUMBER
102 
103 , x_msg_data OUT NOCOPY VARCHAR2
104 
105 ,   p_header_id                     IN NUMBER
106 , p_db_record                       IN  VARCHAR2
107 , p_freight_terms_code   IN VARCHAR2
108 , p_invoice_to_org_id    IN NUMBER
109 , p_partial_shipments_allowed IN VARCHAR2
110 , p_shipment_priority_code IN  VARCHAR2
111 , p_shipping_method_code   IN VARCHAR2
112 , p_ship_to_org_id        IN NUMBER
113 , p_tax_exempt_flag      IN VARCHAR2
114 , p_request_date         IN  VARCHAR2
115 , p_cust_po_number       IN VARCHAR2
116 , p_shipping_instructions IN VARCHAR2
117 , p_sold_to_org_id        IN NUMBER
118 , x_order_number OUT NOCOPY NUMBER
119 
120 , x_agreement_id OUT NOCOPY NUMBER
121 
122 , x_freight_carrier_code OUT NOCOPY VARCHAR2
123 
124 , x_freight_terms_code OUT NOCOPY VARCHAR2
125 
126 , x_header_id OUT NOCOPY NUMBER
127 
128 , x_invoice_to_org_id OUT NOCOPY NUMBER
129 
130 , x_order_type_id OUT NOCOPY NUMBER
131 
132 , x_org_id OUT NOCOPY NUMBER
133 
134 , x_partial_shipments_allowed OUT NOCOPY VARCHAR2
135 
136 , x_payment_term_id OUT NOCOPY NUMBER
137 
138 , x_price_list_id OUT NOCOPY NUMBER
139 
140 , x_shipment_priority_code OUT NOCOPY VARCHAR2
141 
142 , x_shipping_method_code OUT NOCOPY VARCHAR2
143 
144 , x_ship_to_org_id OUT NOCOPY NUMBER
145 
146 , x_sold_to_org_id OUT NOCOPY NUMBER
147 
148 , x_tax_exempt_flag OUT NOCOPY VARCHAR2
149 
150 , x_tax_exempt_number OUT NOCOPY VARCHAR2
151 
152 , x_tax_point_code OUT NOCOPY VARCHAR2
153 
154 , x_transactional_curr_code OUT NOCOPY VARCHAR2
155 
156 , x_payment_type_code OUT NOCOPY VARCHAR2
157 
158 , x_shipping_instructions OUT NOCOPY VARCHAR2
159 
160 , x_shipping_method OUT NOCOPY VARCHAR2
161 
162 , x_freight_terms OUT NOCOPY VARCHAR2
163 
164 , x_invoice_to_address1 OUT NOCOPY VARCHAR2
165 
166 , x_invoice_to_address2 OUT NOCOPY VARCHAR2
167 
168 , x_invoice_to_address3 OUT NOCOPY VARCHAR2
169 
170 , x_invoice_to_address4 OUT NOCOPY VARCHAR2
171 
172 , x_payment_term OUT NOCOPY VARCHAR2
173 
174 , x_shipment_priority OUT NOCOPY varchar2
175 
176 , x_ship_to_address1 OUT NOCOPY VARCHAR2
177 
178 , x_ship_to_address2 OUT NOCOPY VARCHAR2
179 
180 , x_ship_to_address3 OUT NOCOPY VARCHAR2
181 
182 , x_ship_to_address4 OUT NOCOPY VARCHAR2
183 
184 , x_sold_to_org OUT NOCOPY VARCHAR2
185 
186 , x_tax_point OUT NOCOPY VARCHAR2
187 
188 , x_request_date OUT NOCOPY DATE
189 
190 , x_cust_po_number OUT NOCOPY VARCHAR2
191 
192 , x_tax_exempt OUT NOCOPY VARCHAR2
193 
194 , x_partial_shipments OUT NOCOPY VARCHAR2
195 
196 , x_order_type OUT NOCOPY VARCHAR2
197 
198 , x_customer_number OUT NOCOPY VARCHAR2
199 
200 /*, x_cascade_flag OUT NOCOPY VARCHAR2*/
201 
202 );
203 
204 
205 PROCEDURE Delete_Row
206 ( x_return_status OUT NOCOPY VARCHAR2
207 
208 , x_msg_count OUT NOCOPY NUMBER
209 
210 , x_msg_data OUT NOCOPY VARCHAR2
211 
212 ,   p_header_id                     IN  NUMBER
213 );
214 
215 
216 
217 PROCEDURE GET_HEADER_TOTALS
218 ( x_return_status OUT NOCOPY VARCHAR2
219 
220 , x_msg_count OUT NOCOPY NUMBER
221 
222 , x_msg_data OUT NOCOPY VARCHAR2
223 
224 ,   p_header_id                     IN  NUMBER
225 , x_line_total OUT NOCOPY NUMBER
226 
227 , x_tax_total OUT NOCOPY NUMBER
228 
229 , x_charge_total OUT NOCOPY NUMBER
230 
231 , x_order_total OUT NOCOPY NUMBER
232 
233 );
234 
235 
236 END OE_Portal_Header;