[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;