[Home] [Help]
PACKAGE: APPS.OE_BULK_ORDER_PVT
Source
1 PACKAGE OE_BULK_ORDER_PVT AUTHID CURRENT_USER AS
2 /* $Header: OEBVORDS.pls 120.4.12010000.2 2008/11/18 13:02:34 smusanna ship $ */
3
4
5 -----------------------------------------------------------------
6 -- DATA TYPES (RECORD/TABLE TYPES)
7 -----------------------------------------------------------------
8
9 -------------------------------------------------------------------
10 -- **** The Data Type Definitions are moved to OE_WSH_BULK_GRP ****
11 -------------------------------------------------------------------
12
13 -- Define Record Data Types
14
15 TYPE HEADER_REC_TYPE IS RECORD
16 (
17 accounting_rule_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
18 , accounting_rule_duration OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
19 , agreement_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
20 , attribute1 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
21 , attribute10 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
22 , attribute11 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
23 , attribute12 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
24 , attribute13 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
25 , attribute14 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
26 , attribute15 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
27 , attribute16 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240() --For bug 2184255
28 , attribute17 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
29 , attribute18 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
30 , attribute19 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
31 , attribute2 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
32 , attribute20 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
33 , attribute3 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
34 , attribute4 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
35 , attribute5 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
36 , attribute6 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
37 , attribute7 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
38 , attribute8 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
39 , attribute9 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
40 , booked_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
41 --, cancelled_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1() -- Do we need this?
42 , context OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
43 , conversion_rate OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
44 , conversion_rate_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
45 , conversion_type_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
46 , customer_preference_set_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
47 --, created_by OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM() -- Do we need this?
48 --, creation_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE() -- Do we need this?
49 , cust_po_number OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50()
50 , deliver_to_contact_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
51 , deliver_to_org_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
52 , demand_class_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
53 , earliest_schedule_limit OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
54 --, expiration_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
55 , fob_point_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
56 , freight_carrier_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
57 , freight_terms_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
58 , global_attribute1 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
59 , global_attribute10 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
60 , global_attribute11 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
61 , global_attribute12 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
62 , global_attribute13 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
63 , global_attribute14 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
64 , global_attribute15 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
65 , global_attribute16 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
66 , global_attribute17 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
67 , global_attribute18 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
68 , global_attribute19 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
69 , global_attribute2 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
70 , global_attribute20 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
71 , global_attribute3 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
72 , global_attribute4 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
73 , global_attribute5 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
74 , global_attribute6 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
75 , global_attribute7 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
76 , global_attribute8 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
77 , global_attribute9 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
78 , global_attribute_category OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
79 , TP_CONTEXT OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
80 , TP_ATTRIBUTE1 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
81 , TP_ATTRIBUTE2 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
82 , TP_ATTRIBUTE3 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
83 , TP_ATTRIBUTE4 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
84 , TP_ATTRIBUTE5 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
85 , TP_ATTRIBUTE6 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
86 , TP_ATTRIBUTE7 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
87 , TP_ATTRIBUTE8 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
88 , TP_ATTRIBUTE9 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
89 , TP_ATTRIBUTE10 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
90 , TP_ATTRIBUTE11 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
91 , TP_ATTRIBUTE12 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
92 , TP_ATTRIBUTE13 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
93 , TP_ATTRIBUTE14 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
94 , TP_ATTRIBUTE15 OE_WSH_BULK_GRP.T_V240 := OE_WSH_BULK_GRP.T_V240()
95 , header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
96 , invoice_to_contact_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
97 , invoice_to_org_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
98 , invoicing_rule_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
99 --, last_updated_by OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
100 --, last_update_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
101 --, last_update_login OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
102 , latest_schedule_limit OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
103 --, open_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
104 , order_category_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
105 , ordered_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
106 , order_date_type_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
107 , order_number OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
108 , order_source_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
109 , order_type_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
110 , org_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
111 , orig_sys_document_ref OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50()
112 , partial_shipments_allowed OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
113 , payment_term_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
114 , price_list_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
115 , pricing_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
116 --, program_application_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
117 --, program_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
118 --, program_update_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
119 , request_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
120 , request_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
121 --, return_reason_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
122 , salesrep_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
123 , sales_channel_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
124 , shipment_priority_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
125 , shipping_method_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
126 , ship_from_org_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
127 , ship_tolerance_above OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
128 , ship_tolerance_below OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
129 , ship_to_contact_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
130 , ship_to_org_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
131 , sold_from_org_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
132 , sold_to_contact_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
133 , sold_to_org_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
134 --, source_document_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
135 --, source_document_type_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
136 , tax_exempt_flag OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
137 , tax_exempt_number OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50()
138 , tax_exempt_reason_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
139 , tax_point_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
140 , transactional_curr_code OE_WSH_BULK_GRP.T_V15 := OE_WSH_BULK_GRP.T_V15()
141 , version_number OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
142 --, return_status OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
143 --, db_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
144 --, operation OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
145 , first_ack_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
146 --, first_ack_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
147 --, last_ack_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
148 --, last_ack_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
149 --, change_reason OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
150 --, change_comments OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000()
151 , change_sequence OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50()
152 --, change_request_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
153 --, ready_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
154 --, status_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
155 --, force_apply_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
156 --, drop_ship_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
157 --, customer_payment_term_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
158 , payment_type_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
159 , payment_amount OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
160 , check_number OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50()
161 , credit_card_code OE_WSH_BULK_GRP.T_V80 := OE_WSH_BULK_GRP.T_V80()
162 , credit_card_holder_name OE_WSH_BULK_GRP.T_V80 := OE_WSH_BULK_GRP.T_V80()
163 , credit_card_number OE_WSH_BULK_GRP.T_V80 := OE_WSH_BULK_GRP.T_V80()
164 , credit_card_expiration_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
165 , credit_card_approval_code OE_WSH_BULK_GRP.T_V80 := OE_WSH_BULK_GRP.T_V80()
166 , credit_card_approval_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
167 , shipping_instructions OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000()
168 , packing_instructions OE_WSH_BULK_GRP.T_V2000 := OE_WSH_BULK_GRP.T_V2000()
169 --, flow_status_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
170 --, booked_date OE_WSH_BULK_GRP.T_DATE := OE_WSH_BULK_GRP.T_DATE()
171 --, marketing_source_code_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
172 --, upgraded_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
173 , lock_control OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
174 --, ship_to_edi_location_code OE_WSH_BULK_GRP.T_V40 := OE_WSH_BULK_GRP.T_V40()
175 --, sold_to_edi_location_code OE_WSH_BULK_GRP.T_V40 := OE_WSH_BULK_GRP.T_V40()
176 --, bill_to_edi_location_code OE_WSH_BULK_GRP.T_V40 := OE_WSH_BULK_GRP.T_V40()
177 , order_type_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
178 , wf_process_name OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
179 , xml_message_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
180 --PIB
181 , calculate_price_flag OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
182 , header_index OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
183 , event_code OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
184 --PIB
185 --abghosh
186 , sold_to_site_use_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
187 -- added for end customer (Bug 5054618)
188 , End_customer_contact_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
189 , End_customer_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
190 , End_customer_site_use_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
191 , IB_owner OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
192 , IB_current_location OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
193 , IB_Installed_at_Location OE_WSH_BULK_GRP.T_V30 := OE_WSH_BULK_GRP.T_V30()
194 , start_line_index OE_WSH_BULK_GRP.T_B_INT := OE_WSH_BULK_GRP.T_B_INT()
198
195 , end_line_index OE_WSH_BULK_GRP.T_B_INT := OE_WSH_BULK_GRP.T_B_INT()
196 );
197
199 -- Line record type
200 ---------------------------------------------------------------------
201 -- **** The Line Record Definitions are moved to OE_WSH_BULK_GRP ****
202 ---------------------------------------------------------------------
203
204 TYPE Scredit_Rec_Type IS RECORD
205 ( header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
206 , line_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
207 , salesrep_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
208 , sales_credit_type_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
209 );
210
211 -- Record to store pointers to invalid records
212
213 TYPE invalid_hdr_rec_type IS RECORD
214 (
215 order_source_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
216 , orig_sys_document_ref OE_WSH_BULK_GRP.T_V50 := OE_WSH_BULK_GRP.T_V50()
217 , header_id OE_WSH_BULK_GRP.T_NUM := OE_WSH_BULK_GRP.T_NUM()
218 , ineligible_for_hvop OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
219 , skip_batch OE_WSH_BULK_GRP.T_V1 := OE_WSH_BULK_GRP.T_V1()
220 );
221
222 -- Global Number Table of Records Type
223 TYPE Number_Tbl_Type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
224
225
226 ---------------------------------------------------------------------
227 -- GLOBAL RECORDS/TABLES
228 ---------------------------------------------------------------------
229
230 --bug 3798477
231 G_CATCHWEIGHT BOOLEAN := FALSE;
232 --bug 3798477
233
234 -- Global Header Record
235
236 G_HEADER_REC Header_Rec_Type;
237
238 -- Global Line Record
239 G_LINE_REC OE_WSH_BULK_GRP.Line_Rec_Type;
240
241 -- Global Record to store pointers to invalid records
242 G_ERROR_REC invalid_hdr_rec_type;
243
244
245 --------------------------------------------------------------------
246 -- REQUEST LEVEL GLOBALS
247 --------------------------------------------------------------------
248
249 -- Global Request ID
250
251 G_REQUEST_ID NUMBER;
252 -- Globals required for message context
253 G_ORDER_SOURCE_ID NUMBER;
254 G_ORIG_SYS_DOCUMENT_REF VARCHAR2(50);
255 G_ORIG_SYS_LINE_REF VARCHAR2(50);
256 G_ORIG_SYS_SHIPMENT_REF VARCHAR2(50);
257
258 -- Globals to identify whether the desc-flex are in use
259 G_OE_HEADER_ATTRIBUTES VARCHAR2(1);
260 G_OE_HEADER_GLOBAL_ATTRIBUTE VARCHAR2(1);
261 G_OE_LINE_ATTRIBUTES VARCHAR2(1);
262 G_OE_LINE_INDUSTRY_ATTRIBUTE VARCHAR2(1);
263 G_OE_HEADER_TP_ATTRIBUTES VARCHAR2(1);
264 G_OE_LINE_TP_ATTRIBUTES VARCHAR2(1);
265
266
267 -- Globals to store various profilles
268
269 G_AUTO_SCHEDULE VARCHAR2(30) :=
270 FND_PROFILE.VALUE('ONT_AUTOSCHEDULE');
271 G_IIFM VARCHAR2(30) :=
272 FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD');
273
274 -- Changing the following profile fetch to sys parameter fetch.
275 G_SCHEDULE_LINE_ON_HOLD VARCHAR2(30); -- Initialized in OEBVIMNB.pls
276
277 G_IMPORT_SHIPMENTS VARCHAR2(3) :=
278 nvl(FND_PROFILE.VALUE('ONT_IMP_MULTIPLE_SHIPMENTS'),'NO');
279 G_DBI_INSTALLED VARCHAR2(1) :=
280 nvl(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N');
281 -- Changing the following profile fetch to sys parameter fetch.
282 G_RESERVATION_TIME_FENCE VARCHAR2(30); -- Initialized in OEBVIMNB.pls
283
284 G_NOTIFICATION_APPROVER VARCHAR2(4000) :=
285 FND_PROFILE.VALUE('OE_NOTIFICATION_APPROVER');
286 G_RESP_APPL_ID VARCHAR2(30) :=
287 fnd_profile.value('RESP_APPL_ID');
288 G_RESP_ID VARCHAR2(30) :=
289 fnd_profile.value('RESP_ID');
290 G_CONFIGURATOR_USED VARCHAR2(10) :=
291 fnd_profile.value('ONT_USE_CONFIGURATOR');
292 G_BYPASS_ATP VARCHAR2(1) :=
293 fnd_profile.value('ONT_BYPASS_ATP');
294
295
296 -- Globals to store system parameters
297 -- These globals are not reset. The assumption is that the org_id WILL NOT
298 -- change in a session.
299
300 G_ITEM_ORG NUMBER; -- Initialized in OEBVIMNB.pls
301
302 G_SOB_ID NUMBER; -- Initialized in OEBVIMNB.pls
303
304 G_CUST_RELATIONS VARCHAR2(1); -- Initialized in OEBVIMNB.pls
305
306 G_CONFIG_EFFECT_DATE VARCHAR2(10) :=
307 - nvl(OE_Sys_Parameters.VALUE('ONT_CONFIG_EFFECTIVITY_DATE',204),'1');
308 --------------------------------------------------------------------
309 -- BATCH LEVEL GLOBALS
310 --------------------------------------------------------------------
311
312 G_ERROR_COUNT NUMBER := 0;
313 G_PRICING_NEEDED VARCHAR2(1) := 'N';
314 G_ACK_NEEDED VARCHAR2(1) := 'N';
315 G_SCH_COUNT NUMBER;
316
317 --BCT
318 G_REALTIME_CC_REQUIRED VARCHAR2(1):='Y';
319 G_CC_REQUIRED VARCHAR2(1):='Y';
320 --BCT
321
322 ---------------------------------------------------------------------
323 -- PROCEDURES/FUNCTIONS
324 ---------------------------------------------------------------------
325
326 ---------------------------------------------------------------------
327 -- This function is called by desc flex validation routines to first
328 -- check if a flex is enabled or not.
329 -- Returns 'Y' if flex is enabled else returns 'N'.
330 ---------------------------------------------------------------------
331
332 FUNCTION GET_FLEX_ENABLED_FLAG(p_flex_name VARCHAR2)
333 RETURN VARCHAR2;
334
335 ---------------------------------------------------------------------
336 -- This is the MAIN procedure called from order import for processing
337 -- orders in this batch.
338 ---------------------------------------------------------------------
339
340 PROCEDURE Process_Batch
341 ( p_batch_id IN NUMBER
342 , p_validate_only IN VARCHAR2 DEFAULT 'N'
343 , p_validate_desc_flex IN VARCHAR2 DEFAULT 'Y'
344 , p_defaulting_mode IN VARCHAR2 DEFAULT 'N'
345 , p_process_configurations IN VARCHAR2 DEFAULT 'N'
346 , p_validate_configurations IN VARCHAR2 DEFAULT 'Y'
347 , p_schedule_configurations IN VARCHAR2 DEFAULT 'N'
348 , p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
349 , p_process_tax IN VARCHAR2 DEFAULT 'N'
350 , x_msg_count OUT NOCOPY NUMBER
351 , x_msg_data OUT NOCOPY VARCHAR2
352 , x_return_status OUT NOCOPY VARCHAR
353 );
354
355 PROCEDURE mark_header_error(p_header_index IN NUMBER,
356 p_header_rec IN OUT NOCOPY OE_BULK_ORDER_PVT.HEADER_REC_TYPE);
357
358 END OE_BULK_ORDER_PVT;