32:
33: -- Ignore if dependent attribute is one of the internal fields.
34: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
35: IF l_extn_dep_tbl(l_index).dependent_attribute IN
36: ( OE_HEADER_UTIL.G_ORDER_CATEGORY
37: ) THEN
38: IF l_debug_level > 0 THEN
39: oe_debug_pub.add( 'INTERNAL FIELD DEPENDENCY' ) ;
40: END IF;
155: IF p_entity_code = OE_GLOBALS.G_ENTITY_HEADER THEN
156:
157: -- Populate dependent attributes for one source at a time.
158:
159: l_index := OE_HEADER_UTIL.G_ORDER_TYPE * G_MAX ;
160: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
161: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
156:
157: -- Populate dependent attributes for one source at a time.
158:
159: l_index := OE_HEADER_UTIL.G_ORDER_TYPE * G_MAX ;
160: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
161: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
157: -- Populate dependent attributes for one source at a time.
158:
159: l_index := OE_HEADER_UTIL.G_ORDER_TYPE * G_MAX ;
160: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
161: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
158:
159: l_index := OE_HEADER_UTIL.G_ORDER_TYPE * G_MAX ;
160: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
161: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
159: l_index := OE_HEADER_UTIL.G_ORDER_TYPE * G_MAX ;
160: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
161: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
160: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
161: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
161: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
162: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
163: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_SHIPMENT_PRIORITY;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
164: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
165: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
166: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
174: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET;
167: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
174: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET;
175: g_dep_tbl(l_index +15).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
168: g_dep_tbl(l_index + 8).attribute := OE_HEADER_UTIL.G_ORDER_CATEGORY;
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
174: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET;
175: g_dep_tbl(l_index +15).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
176: -- QUOTING changes
169: g_dep_tbl(l_index + 9).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
174: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET;
175: g_dep_tbl(l_index +15).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
176: -- QUOTING changes
177: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
170: g_dep_tbl(l_index + 10).attribute := OE_HEADER_UTIL.G_REQUEST_DATE;
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
174: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET;
175: g_dep_tbl(l_index +15).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
176: -- QUOTING changes
177: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
178:
171: g_dep_tbl(l_index + 11).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
172: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
174: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET;
175: g_dep_tbl(l_index +15).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
176: -- QUOTING changes
177: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
178:
179: l_index := OE_HEADER_UTIL.G_AGREEMENT * G_MAX ;
173: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
174: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_DEFAULT_FULFILLMENT_SET;
175: g_dep_tbl(l_index +15).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
176: -- QUOTING changes
177: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
178:
179: l_index := OE_HEADER_UTIL.G_AGREEMENT * G_MAX ;
180: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_CUST_PO_NUMBER;
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
175: g_dep_tbl(l_index +15).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
176: -- QUOTING changes
177: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
178:
179: l_index := OE_HEADER_UTIL.G_AGREEMENT * G_MAX ;
180: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_CUST_PO_NUMBER;
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
176: -- QUOTING changes
177: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
178:
179: l_index := OE_HEADER_UTIL.G_AGREEMENT * G_MAX ;
180: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_CUST_PO_NUMBER;
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
177: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_TRANSACTION_PHASE;
178:
179: l_index := OE_HEADER_UTIL.G_AGREEMENT * G_MAX ;
180: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_CUST_PO_NUMBER;
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
185: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
178:
179: l_index := OE_HEADER_UTIL.G_AGREEMENT * G_MAX ;
180: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_CUST_PO_NUMBER;
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
185: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
186: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
179: l_index := OE_HEADER_UTIL.G_AGREEMENT * G_MAX ;
180: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_CUST_PO_NUMBER;
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
185: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
186: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
187: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
180: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_CUST_PO_NUMBER;
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
185: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
186: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
187: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
188:
181: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
185: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
186: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
187: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
188:
189:
182: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
185: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
186: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
187: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
188:
189:
190: l_index := OE_HEADER_UTIL.G_INVOICE_TO_ORG * G_MAX ;
183: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
184: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
185: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
186: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
187: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
188:
189:
190: l_index := OE_HEADER_UTIL.G_INVOICE_TO_ORG * G_MAX ;
191: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
186: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
187: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
188:
189:
190: l_index := OE_HEADER_UTIL.G_INVOICE_TO_ORG * G_MAX ;
191: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
192: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
193: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
187: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
188:
189:
190: l_index := OE_HEADER_UTIL.G_INVOICE_TO_ORG * G_MAX ;
191: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
192: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
193: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
195: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
188:
189:
190: l_index := OE_HEADER_UTIL.G_INVOICE_TO_ORG * G_MAX ;
191: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
192: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
193: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
195: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
196: -- Added by Manish
189:
190: l_index := OE_HEADER_UTIL.G_INVOICE_TO_ORG * G_MAX ;
191: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
192: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
193: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
195: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
196: -- Added by Manish
197: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
190: l_index := OE_HEADER_UTIL.G_INVOICE_TO_ORG * G_MAX ;
191: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
192: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
193: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
195: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
196: -- Added by Manish
197: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
198: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
191: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
192: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT;
193: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
195: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
196: -- Added by Manish
197: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
198: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
199: -- Added by Manish
193: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
195: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
196: -- Added by Manish
197: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
198: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
199: -- Added by Manish
200: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
201: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
194: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
195: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
196: -- Added by Manish
197: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
198: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
199: -- Added by Manish
200: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
201: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
202: -- Adding for OM-iPayment - Raju
196: -- Added by Manish
197: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
198: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
199: -- Added by Manish
200: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
201: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
202: -- Adding for OM-iPayment - Raju
203: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
197: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
198: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
199: -- Added by Manish
200: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
201: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
202: -- Adding for OM-iPayment - Raju
203: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
205: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
199: -- Added by Manish
200: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
201: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
202: -- Adding for OM-iPayment - Raju
203: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
205: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
206: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
200: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_SALESREP;
201: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
202: -- Adding for OM-iPayment - Raju
203: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
205: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
206: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
208: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
201: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
202: -- Adding for OM-iPayment - Raju
203: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
205: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
206: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
208: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
209: /* Fix Bug # 2297053: Added to clear Credit Card Type */
202: -- Adding for OM-iPayment - Raju
203: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
205: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
206: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
208: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
209: /* Fix Bug # 2297053: Added to clear Credit Card Type */
210: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
203: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
205: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
206: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
208: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
209: /* Fix Bug # 2297053: Added to clear Credit Card Type */
210: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
211: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
204: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
205: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
206: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
208: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
209: /* Fix Bug # 2297053: Added to clear Credit Card Type */
210: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
211: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
212:
206: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
208: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
209: /* Fix Bug # 2297053: Added to clear Credit Card Type */
210: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
211: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
212:
213: l_index := OE_HEADER_UTIL.G_SHIP_TO_ORG * G_MAX ;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
207: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
208: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
209: /* Fix Bug # 2297053: Added to clear Credit Card Type */
210: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
211: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
212:
213: l_index := OE_HEADER_UTIL.G_SHIP_TO_ORG * G_MAX ;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
209: /* Fix Bug # 2297053: Added to clear Credit Card Type */
210: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
211: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
212:
213: l_index := OE_HEADER_UTIL.G_SHIP_TO_ORG * G_MAX ;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
210: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
211: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
212:
213: l_index := OE_HEADER_UTIL.G_SHIP_TO_ORG * G_MAX ;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
211: g_dep_tbl(l_index +16).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
212:
213: l_index := OE_HEADER_UTIL.G_SHIP_TO_ORG * G_MAX ;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
212:
213: l_index := OE_HEADER_UTIL.G_SHIP_TO_ORG * G_MAX ;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
213: l_index := OE_HEADER_UTIL.G_SHIP_TO_ORG * G_MAX ;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
214: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
215: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
216: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
217: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
218: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
219: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
220: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_DEMAND_CLASS;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
221: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
222: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_SALESREP;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
223: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
224: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
232:
225: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
232:
233: l_index := OE_HEADER_UTIL.G_REQUEST_DATE * G_MAX ;
226: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
232:
233: l_index := OE_HEADER_UTIL.G_REQUEST_DATE * G_MAX ;
234: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
227: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
228: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_CONTACT;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
232:
233: l_index := OE_HEADER_UTIL.G_REQUEST_DATE * G_MAX ;
234: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
235: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
229: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
232:
233: l_index := OE_HEADER_UTIL.G_REQUEST_DATE * G_MAX ;
234: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
235: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
236:
237: l_index := OE_HEADER_UTIL.G_TAX_EXEMPT * G_MAX ;
230: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
232:
233: l_index := OE_HEADER_UTIL.G_REQUEST_DATE * G_MAX ;
234: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
235: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
236:
237: l_index := OE_HEADER_UTIL.G_TAX_EXEMPT * G_MAX ;
238: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
231: g_dep_tbl(l_index +17).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
232:
233: l_index := OE_HEADER_UTIL.G_REQUEST_DATE * G_MAX ;
234: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
235: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
236:
237: l_index := OE_HEADER_UTIL.G_TAX_EXEMPT * G_MAX ;
238: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
239: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
233: l_index := OE_HEADER_UTIL.G_REQUEST_DATE * G_MAX ;
234: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
235: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
236:
237: l_index := OE_HEADER_UTIL.G_TAX_EXEMPT * G_MAX ;
238: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
239: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
240: -- Added by Manish
241:
234: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
235: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
236:
237: l_index := OE_HEADER_UTIL.G_TAX_EXEMPT * G_MAX ;
238: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
239: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
240: -- Added by Manish
241:
242: l_index := OE_HEADER_UTIL.G_SOLD_TO_ORG * G_MAX ;
235: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
236:
237: l_index := OE_HEADER_UTIL.G_TAX_EXEMPT * G_MAX ;
238: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
239: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
240: -- Added by Manish
241:
242: l_index := OE_HEADER_UTIL.G_SOLD_TO_ORG * G_MAX ;
243: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
238: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
239: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
240: -- Added by Manish
241:
242: l_index := OE_HEADER_UTIL.G_SOLD_TO_ORG * G_MAX ;
243: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
244: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
239: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
240: -- Added by Manish
241:
242: l_index := OE_HEADER_UTIL.G_SOLD_TO_ORG * G_MAX ;
243: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
244: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
240: -- Added by Manish
241:
242: l_index := OE_HEADER_UTIL.G_SOLD_TO_ORG * G_MAX ;
243: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
244: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
241:
242: l_index := OE_HEADER_UTIL.G_SOLD_TO_ORG * G_MAX ;
243: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
244: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
242: l_index := OE_HEADER_UTIL.G_SOLD_TO_ORG * G_MAX ;
243: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
244: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
250: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
243: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
244: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
250: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
251: -- Added by Manish
244: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
250: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
251: -- Added by Manish
252: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
245: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
250: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
251: -- Added by Manish
252: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
253: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
246: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_FOB_POINT;
247: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
250: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
251: -- Added by Manish
252: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
253: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
254: -- Added by Manish
248: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
250: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
251: -- Added by Manish
252: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
253: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
254: -- Added by Manish
255: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SALESREP;
256: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
249: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
250: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_ORDER_TYPE;
251: -- Added by Manish
252: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
253: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
254: -- Added by Manish
255: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SALESREP;
256: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
257: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
251: -- Added by Manish
252: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
253: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
254: -- Added by Manish
255: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SALESREP;
256: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
257: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
258: -- Adding for OM-iPayment - Raju
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
252: g_dep_tbl(l_index +8 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_NUMBER;
253: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
254: -- Added by Manish
255: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SALESREP;
256: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
257: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
258: -- Adding for OM-iPayment - Raju
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
253: g_dep_tbl(l_index +9 ).attribute := OE_HEADER_UTIL.G_TAX_EXEMPT_REASON;
254: -- Added by Manish
255: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SALESREP;
256: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
257: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
258: -- Adding for OM-iPayment - Raju
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
255: g_dep_tbl(l_index +10 ).attribute := OE_HEADER_UTIL.G_SALESREP;
256: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
257: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
258: -- Adding for OM-iPayment - Raju
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
256: g_dep_tbl(l_index +11 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
257: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
258: -- Adding for OM-iPayment - Raju
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
257: g_dep_tbl(l_index +12 ).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
258: -- Adding for OM-iPayment - Raju
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
258: -- Adding for OM-iPayment - Raju
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
259: g_dep_tbl(l_index +13 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
260: g_dep_tbl(l_index +14 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
268: /* Fix Bug # 2297053: Added to clear Credit Card Type */
261: g_dep_tbl(l_index +15 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
268: /* Fix Bug # 2297053: Added to clear Credit Card Type */
269: g_dep_tbl(l_index +22 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
262: g_dep_tbl(l_index +16 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_BELOW;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
268: /* Fix Bug # 2297053: Added to clear Credit Card Type */
269: g_dep_tbl(l_index +22 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
270: g_dep_tbl(l_index +23 ).attribute := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
263: g_dep_tbl(l_index +17 ).attribute := OE_HEADER_UTIL.G_SHIP_TOLERANCE_ABOVE;
264: g_dep_tbl(l_index +18 ).attribute := OE_HEADER_UTIL.G_SALES_CHANNEL;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
268: /* Fix Bug # 2297053: Added to clear Credit Card Type */
269: g_dep_tbl(l_index +22 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
270: g_dep_tbl(l_index +23 ).attribute := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
271: g_dep_tbl(l_index +24).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
265: g_dep_tbl(l_index +19 ).attribute := OE_HEADER_UTIL.G_ORDER_DATE_TYPE_CODE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
268: /* Fix Bug # 2297053: Added to clear Credit Card Type */
269: g_dep_tbl(l_index +22 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
270: g_dep_tbl(l_index +23 ).attribute := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
271: g_dep_tbl(l_index +24).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
272: -- QUOTING changes
273: g_dep_tbl(l_index +25).attribute := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
266: g_dep_tbl(l_index +20 ).attribute := OE_HEADER_UTIL.G_LATEST_SCHEDULE_LIMIT;
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
268: /* Fix Bug # 2297053: Added to clear Credit Card Type */
269: g_dep_tbl(l_index +22 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
270: g_dep_tbl(l_index +23 ).attribute := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
271: g_dep_tbl(l_index +24).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
272: -- QUOTING changes
273: g_dep_tbl(l_index +25).attribute := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
274: --distributed orders
267: g_dep_tbl(l_index +21 ).attribute := OE_HEADER_UTIL.G_AGREEMENT;
268: /* Fix Bug # 2297053: Added to clear Credit Card Type */
269: g_dep_tbl(l_index +22 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
270: g_dep_tbl(l_index +23 ).attribute := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
271: g_dep_tbl(l_index +24).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
272: -- QUOTING changes
273: g_dep_tbl(l_index +25).attribute := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
274: --distributed orders
275: g_dep_tbl(l_index +26).attribute := OE_HEADER_UTIL.G_END_CUSTOMER;
269: g_dep_tbl(l_index +22 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
270: g_dep_tbl(l_index +23 ).attribute := OE_HEADER_UTIL.G_SOLD_TO_PHONE;
271: g_dep_tbl(l_index +24).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
272: -- QUOTING changes
273: g_dep_tbl(l_index +25).attribute := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
274: --distributed orders
275: g_dep_tbl(l_index +26).attribute := OE_HEADER_UTIL.G_END_CUSTOMER;
276:
277: l_index := OE_HEADER_UTIL.G_PRICE_LIST * G_MAX ;
271: g_dep_tbl(l_index +24).attribute := OE_HEADER_UTIL.G_CUSTOMER_PREFERENCE_SET;
272: -- QUOTING changes
273: g_dep_tbl(l_index +25).attribute := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
274: --distributed orders
275: g_dep_tbl(l_index +26).attribute := OE_HEADER_UTIL.G_END_CUSTOMER;
276:
277: l_index := OE_HEADER_UTIL.G_PRICE_LIST * G_MAX ;
278: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
279: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
273: g_dep_tbl(l_index +25).attribute := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE;
274: --distributed orders
275: g_dep_tbl(l_index +26).attribute := OE_HEADER_UTIL.G_END_CUSTOMER;
276:
277: l_index := OE_HEADER_UTIL.G_PRICE_LIST * G_MAX ;
278: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
279: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
280: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
281: /* Added the following if condition to fix the bug 2478334 */
274: --distributed orders
275: g_dep_tbl(l_index +26).attribute := OE_HEADER_UTIL.G_END_CUSTOMER;
276:
277: l_index := OE_HEADER_UTIL.G_PRICE_LIST * G_MAX ;
278: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
279: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
280: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
281: /* Added the following if condition to fix the bug 2478334 */
282: IF UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN ('Y', 'YES') THEN
275: g_dep_tbl(l_index +26).attribute := OE_HEADER_UTIL.G_END_CUSTOMER;
276:
277: l_index := OE_HEADER_UTIL.G_PRICE_LIST * G_MAX ;
278: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
279: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
280: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
281: /* Added the following if condition to fix the bug 2478334 */
282: IF UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN ('Y', 'YES') THEN
283: null;
276:
277: l_index := OE_HEADER_UTIL.G_PRICE_LIST * G_MAX ;
278: g_dep_tbl(l_index ).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
279: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
280: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
281: /* Added the following if condition to fix the bug 2478334 */
282: IF UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN ('Y', 'YES') THEN
283: null;
284: ELSE
281: /* Added the following if condition to fix the bug 2478334 */
282: IF UPPER(fnd_profile.value('QP_MULTI_CURRENCY_INSTALLED')) IN ('Y', 'YES') THEN
283: null;
284: ELSE
285: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
286: END IF;
287:
288: -- Adding for OM-iPayment - Raju
289: l_index := OE_HEADER_UTIL.G_PAYMENT_TYPE * G_MAX ;
285: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
286: END IF;
287:
288: -- Adding for OM-iPayment - Raju
289: l_index := OE_HEADER_UTIL.G_PAYMENT_TYPE * G_MAX ;
290: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
291: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
286: END IF;
287:
288: -- Adding for OM-iPayment - Raju
289: l_index := OE_HEADER_UTIL.G_PAYMENT_TYPE * G_MAX ;
290: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
291: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
287:
288: -- Adding for OM-iPayment - Raju
289: l_index := OE_HEADER_UTIL.G_PAYMENT_TYPE * G_MAX ;
290: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
291: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
295: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_CHECK_NUMBER;
288: -- Adding for OM-iPayment - Raju
289: l_index := OE_HEADER_UTIL.G_PAYMENT_TYPE * G_MAX ;
290: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
291: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
295: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_CHECK_NUMBER;
296: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
289: l_index := OE_HEADER_UTIL.G_PAYMENT_TYPE * G_MAX ;
290: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
291: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
295: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_CHECK_NUMBER;
296: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
297: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
290: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER;
291: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
295: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_CHECK_NUMBER;
296: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
297: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
298:
291: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
295: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_CHECK_NUMBER;
296: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
297: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
298:
299: /* Fix Bug # 2297053: Added to make attributes depended on CC Number */
292: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
295: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_CHECK_NUMBER;
296: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
297: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
298:
299: /* Fix Bug # 2297053: Added to make attributes depended on CC Number */
300: l_index := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER * G_MAX ;
293: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
294: g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
295: g_dep_tbl(l_index +5 ).attribute := OE_HEADER_UTIL.G_CHECK_NUMBER;
296: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
297: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
298:
299: /* Fix Bug # 2297053: Added to make attributes depended on CC Number */
300: l_index := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER * G_MAX ;
301: /*
296: g_dep_tbl(l_index +6 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
297: g_dep_tbl(l_index +7 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
298:
299: /* Fix Bug # 2297053: Added to make attributes depended on CC Number */
300: l_index := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER * G_MAX ;
301: /*
302: ** Fix Bug # 2867744: Commented the clearing of Credit Card Type
303: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
304: */
299: /* Fix Bug # 2297053: Added to make attributes depended on CC Number */
300: l_index := OE_HEADER_UTIL.G_CREDIT_CARD_NUMBER * G_MAX ;
301: /*
302: ** Fix Bug # 2867744: Commented the clearing of Credit Card Type
303: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
304: */
305: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
306: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
307: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
301: /*
302: ** Fix Bug # 2867744: Commented the clearing of Credit Card Type
303: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
304: */
305: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
306: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
307: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
308: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
309: --7337623 g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
302: ** Fix Bug # 2867744: Commented the clearing of Credit Card Type
303: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
304: */
305: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
306: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
307: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
308: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
309: --7337623 g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
310:
303: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD;
304: */
305: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
306: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
307: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
308: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
309: --7337623 g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
310:
311: -- Adding for Currency conversion. -- Added by Aswin.
304: */
305: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
306: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
307: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
308: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
309: --7337623 g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
310:
311: -- Adding for Currency conversion. -- Added by Aswin.
312: l_index := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR * G_MAX ;
305: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_HOLDER_NAME;
306: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_EXPIRATION_DATE;
307: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL_DATE;
308: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
309: --7337623 g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
310:
311: -- Adding for Currency conversion. -- Added by Aswin.
312: l_index := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR * G_MAX ;
313: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CONVERSION_TYPE;
308: g_dep_tbl(l_index +3 ).attribute := OE_HEADER_UTIL.G_CREDIT_CARD_APPROVAL;
309: --7337623 g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
310:
311: -- Adding for Currency conversion. -- Added by Aswin.
312: l_index := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR * G_MAX ;
313: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CONVERSION_TYPE;
314: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE_DATE;
315: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE;
316:
309: --7337623 g_dep_tbl(l_index +4 ).attribute := OE_HEADER_UTIL.G_PAYMENT_AMOUNT;
310:
311: -- Adding for Currency conversion. -- Added by Aswin.
312: l_index := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR * G_MAX ;
313: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CONVERSION_TYPE;
314: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE_DATE;
315: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE;
316:
317: -- Adding for deliver to org . -- Added by Shashi.
310:
311: -- Adding for Currency conversion. -- Added by Aswin.
312: l_index := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR * G_MAX ;
313: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CONVERSION_TYPE;
314: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE_DATE;
315: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE;
316:
317: -- Adding for deliver to org . -- Added by Shashi.
318: l_index := OE_HEADER_UTIL.G_DELIVER_TO_ORG * G_MAX ;
311: -- Adding for Currency conversion. -- Added by Aswin.
312: l_index := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR * G_MAX ;
313: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_CONVERSION_TYPE;
314: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE_DATE;
315: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE;
316:
317: -- Adding for deliver to org . -- Added by Shashi.
318: l_index := OE_HEADER_UTIL.G_DELIVER_TO_ORG * G_MAX ;
319: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_DELIVER_TO_CONTACT;
314: g_dep_tbl(l_index +1 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE_DATE;
315: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE;
316:
317: -- Adding for deliver to org . -- Added by Shashi.
318: l_index := OE_HEADER_UTIL.G_DELIVER_TO_ORG * G_MAX ;
319: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_DELIVER_TO_CONTACT;
320:
321:
322: -- Begin Fix bug 1282800: added dependencies for contact fields
315: g_dep_tbl(l_index +2 ).attribute := OE_HEADER_UTIL.G_CONVERSION_RATE;
316:
317: -- Adding for deliver to org . -- Added by Shashi.
318: l_index := OE_HEADER_UTIL.G_DELIVER_TO_ORG * G_MAX ;
319: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_DELIVER_TO_CONTACT;
320:
321:
322: -- Begin Fix bug 1282800: added dependencies for contact fields
323:
320:
321:
322: -- Begin Fix bug 1282800: added dependencies for contact fields
323:
324: l_index := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT * G_MAX ;
325: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
326:
327: l_index := OE_HEADER_UTIL.G_SHIP_TO_CONTACT * G_MAX ;
328: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
321:
322: -- Begin Fix bug 1282800: added dependencies for contact fields
323:
324: l_index := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT * G_MAX ;
325: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
326:
327: l_index := OE_HEADER_UTIL.G_SHIP_TO_CONTACT * G_MAX ;
328: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
329:
323:
324: l_index := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT * G_MAX ;
325: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
326:
327: l_index := OE_HEADER_UTIL.G_SHIP_TO_CONTACT * G_MAX ;
328: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
329:
330: -- End Fix bug 1282800
331:
324: l_index := OE_HEADER_UTIL.G_INVOICE_TO_CONTACT * G_MAX ;
325: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
326:
327: l_index := OE_HEADER_UTIL.G_SHIP_TO_CONTACT * G_MAX ;
328: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
329:
330: -- End Fix bug 1282800
331:
332: -- bug 5127922 : added dependency for cusotmer_location
329:
330: -- End Fix bug 1282800
331:
332: -- bug 5127922 : added dependency for cusotmer_location
333: l_index := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE * G_MAX ;
334: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
335:
336: -- BLANKETS: Add dependencies on blanket number for order header
337: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
330: -- End Fix bug 1282800
331:
332: -- bug 5127922 : added dependency for cusotmer_location
333: l_index := OE_HEADER_UTIL.G_SOLD_TO_SITE_USE * G_MAX ;
334: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
335:
336: -- BLANKETS: Add dependencies on blanket number for order header
337: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
338:
335:
336: -- BLANKETS: Add dependencies on blanket number for order header
337: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
338:
339: l_index := OE_HEADER_UTIL.G_BLANKET_NUMBER * G_MAX ;
340: -- Bug 3279125 -
341: -- Remove dependency of sold to (customer) on blanket number
342: -- g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_ORG;
343: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
338:
339: l_index := OE_HEADER_UTIL.G_BLANKET_NUMBER * G_MAX ;
340: -- Bug 3279125 -
341: -- Remove dependency of sold to (customer) on blanket number
342: -- g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_ORG;
343: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
344: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
339: l_index := OE_HEADER_UTIL.G_BLANKET_NUMBER * G_MAX ;
340: -- Bug 3279125 -
341: -- Remove dependency of sold to (customer) on blanket number
342: -- g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_ORG;
343: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
344: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
340: -- Bug 3279125 -
341: -- Remove dependency of sold to (customer) on blanket number
342: -- g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_ORG;
343: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
344: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
341: -- Remove dependency of sold to (customer) on blanket number
342: -- g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_ORG;
343: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
344: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
342: -- g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_SOLD_TO_ORG;
343: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
344: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
343: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ACCOUNTING_RULE;
344: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
344: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_INVOICING_RULE;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
345: g_dep_tbl(l_index+2).attribute := OE_HEADER_UTIL.G_TRANSACTIONAL_CURR;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
346: g_dep_tbl(l_index+3).attribute := OE_HEADER_UTIL.G_SHIP_TO_ORG;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
347: g_dep_tbl(l_index+4).attribute := OE_HEADER_UTIL.G_INVOICE_TO_ORG;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
355: g_dep_tbl(l_index+12).attribute := OE_HEADER_UTIL.G_SALESREP;
348: g_dep_tbl(l_index+5).attribute := OE_HEADER_UTIL.G_DELIVER_TO_ORG;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
355: g_dep_tbl(l_index+12).attribute := OE_HEADER_UTIL.G_SALESREP;
356: g_dep_tbl(l_index+13).attribute := OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS;
349: g_dep_tbl(l_index+6).attribute := OE_HEADER_UTIL.G_SOLD_TO_CONTACT;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
355: g_dep_tbl(l_index+12).attribute := OE_HEADER_UTIL.G_SALESREP;
356: g_dep_tbl(l_index+13).attribute := OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS;
357: g_dep_tbl(l_index+14).attribute := OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS;
350: g_dep_tbl(l_index+7).attribute := OE_HEADER_UTIL.G_SHIP_FROM_ORG;
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
355: g_dep_tbl(l_index+12).attribute := OE_HEADER_UTIL.G_SALESREP;
356: g_dep_tbl(l_index+13).attribute := OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS;
357: g_dep_tbl(l_index+14).attribute := OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS;
358:
351: g_dep_tbl(l_index+8).attribute := OE_HEADER_UTIL.G_PAYMENT_TERM;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
355: g_dep_tbl(l_index+12).attribute := OE_HEADER_UTIL.G_SALESREP;
356: g_dep_tbl(l_index+13).attribute := OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS;
357: g_dep_tbl(l_index+14).attribute := OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS;
358:
359: END IF;
352: g_dep_tbl(l_index+9).attribute := OE_HEADER_UTIL.G_PRICE_LIST;
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
355: g_dep_tbl(l_index+12).attribute := OE_HEADER_UTIL.G_SALESREP;
356: g_dep_tbl(l_index+13).attribute := OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS;
357: g_dep_tbl(l_index+14).attribute := OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS;
358:
359: END IF;
360:
353: g_dep_tbl(l_index+10).attribute := OE_HEADER_UTIL.G_SHIPPING_METHOD;
354: g_dep_tbl(l_index+11).attribute := OE_HEADER_UTIL.G_FREIGHT_TERMS;
355: g_dep_tbl(l_index+12).attribute := OE_HEADER_UTIL.G_SALESREP;
356: g_dep_tbl(l_index+13).attribute := OE_HEADER_UTIL.G_SHIPPING_INSTRUCTIONS;
357: g_dep_tbl(l_index+14).attribute := OE_HEADER_UTIL.G_PACKING_INSTRUCTIONS;
358:
359: END IF;
360:
361: -- QUOTING changes
361: -- QUOTING changes
362: -- Add dependency of quote date/ordered date on transaction phase
363: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
364:
365: l_index := OE_HEADER_UTIL.G_TRANSACTION_PHASE * G_MAX ;
366: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_QUOTE_DATE;
367: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_ORDERED_DATE;
368:
369: END IF;
362: -- Add dependency of quote date/ordered date on transaction phase
363: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
364:
365: l_index := OE_HEADER_UTIL.G_TRANSACTION_PHASE * G_MAX ;
366: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_QUOTE_DATE;
367: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_ORDERED_DATE;
368:
369: END IF;
370: -- END QUOTING changes
363: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
364:
365: l_index := OE_HEADER_UTIL.G_TRANSACTION_PHASE * G_MAX ;
366: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_QUOTE_DATE;
367: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_ORDERED_DATE;
368:
369: END IF;
370: -- END QUOTING changes
371:
370: -- END QUOTING changes
371:
372: --distributed orders
373: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
374: l_index := OE_HEADER_UTIL.G_END_CUSTOMER * G_MAX ;
375: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT;
376: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE;
377: END IF;
378:
371:
372: --distributed orders
373: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
374: l_index := OE_HEADER_UTIL.G_END_CUSTOMER * G_MAX ;
375: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT;
376: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE;
377: END IF;
378:
379: --key transaction dates
372: --distributed orders
373: IF OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
374: l_index := OE_HEADER_UTIL.G_END_CUSTOMER * G_MAX ;
375: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_END_CUSTOMER_CONTACT;
376: g_dep_tbl(l_index+1).attribute := OE_HEADER_UTIL.G_END_CUSTOMER_SITE_USE;
377: END IF;
378:
379: --key transaction dates
380: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
377: END IF;
378:
379: --key transaction dates
380: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
381: l_index := OE_HEADER_UTIL.G_ORDERED_DATE * G_MAX ;
382: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ORDER_FIRMED_DATE;
383: END IF;
384:
385: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
378:
379: --key transaction dates
380: IF OE_CODE_CONTROL.Code_Release_Level >= '110509' THEN
381: l_index := OE_HEADER_UTIL.G_ORDERED_DATE * G_MAX ;
382: g_dep_tbl(l_index).attribute := OE_HEADER_UTIL.G_ORDER_FIRMED_DATE;
383: END IF;
384:
385: ELSIF p_entity_code = OE_GLOBALS.G_ENTITY_LINE THEN
386: