[Home] [Help]
39:
40: oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_hdr_null_to_miss', 1);
41:
42: IF p_x_header_rec.accounting_rule_id IS NULL THEN
43: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
44: END IF;
45:
46: IF p_x_header_rec.accounting_rule_duration IS NULL THEN
47: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
43: p_x_header_rec.accounting_rule_id := FND_API.G_MISS_NUM;
44: END IF;
45:
46: IF p_x_header_rec.accounting_rule_duration IS NULL THEN
47: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
48: END IF;
49:
50: IF p_x_header_rec.agreement_id IS NULL THEN
51: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
47: p_x_header_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
48: END IF;
49:
50: IF p_x_header_rec.agreement_id IS NULL THEN
51: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
52: END IF;
53:
54: IF p_x_header_rec.blanket_number IS NULL THEN
55: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
51: p_x_header_rec.agreement_id := FND_API.G_MISS_NUM;
52: END IF;
53:
54: IF p_x_header_rec.blanket_number IS NULL THEN
55: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
56: END IF;
57:
58: IF p_x_header_rec.booked_flag IS NULL THEN
59: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
55: p_x_header_rec.blanket_number := FND_API.G_MISS_NUM;
56: END IF;
57:
58: IF p_x_header_rec.booked_flag IS NULL THEN
59: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
60: END IF;
61:
62: IF p_x_header_rec.upgraded_flag IS NULL THEN
63: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
59: p_x_header_rec.booked_flag := FND_API.G_MISS_CHAR;
60: END IF;
61:
62: IF p_x_header_rec.upgraded_flag IS NULL THEN
63: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
64: END IF;
65:
66: IF p_x_header_rec.booked_date IS NULL THEN
67: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
63: p_x_header_rec.upgraded_flag := FND_API.G_MISS_CHAR;
64: END IF;
65:
66: IF p_x_header_rec.booked_date IS NULL THEN
67: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
68: END IF;
69:
70: IF p_x_header_rec.cancelled_flag IS NULL THEN
71: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
67: p_x_header_rec.booked_date := FND_API.G_MISS_DATE;
68: END IF;
69:
70: IF p_x_header_rec.cancelled_flag IS NULL THEN
71: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
72: END IF;
73:
74: IF p_x_header_rec.attribute1 IS NULL THEN
75: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
71: p_x_header_rec.cancelled_flag := FND_API.G_MISS_CHAR;
72: END IF;
73:
74: IF p_x_header_rec.attribute1 IS NULL THEN
75: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
76: END IF;
77:
78: IF p_x_header_rec.attribute10 IS NULL THEN
79: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
75: p_x_header_rec.attribute1 := FND_API.G_MISS_CHAR;
76: END IF;
77:
78: IF p_x_header_rec.attribute10 IS NULL THEN
79: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
80: END IF;
81:
82: IF p_x_header_rec.attribute11 IS NULL THEN
83: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
79: p_x_header_rec.attribute10 := FND_API.G_MISS_CHAR;
80: END IF;
81:
82: IF p_x_header_rec.attribute11 IS NULL THEN
83: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
84: END IF;
85:
86: IF p_x_header_rec.attribute12 IS NULL THEN
87: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
83: p_x_header_rec.attribute11 := FND_API.G_MISS_CHAR;
84: END IF;
85:
86: IF p_x_header_rec.attribute12 IS NULL THEN
87: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
88: END IF;
89:
90: IF p_x_header_rec.attribute13 IS NULL THEN
91: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
87: p_x_header_rec.attribute12 := FND_API.G_MISS_CHAR;
88: END IF;
89:
90: IF p_x_header_rec.attribute13 IS NULL THEN
91: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
92: END IF;
93:
94: IF p_x_header_rec.attribute14 IS NULL THEN
95: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
91: p_x_header_rec.attribute13 := FND_API.G_MISS_CHAR;
92: END IF;
93:
94: IF p_x_header_rec.attribute14 IS NULL THEN
95: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
96: END IF;
97:
98: IF p_x_header_rec.attribute15 IS NULL THEN
99: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
95: p_x_header_rec.attribute14 := FND_API.G_MISS_CHAR;
96: END IF;
97:
98: IF p_x_header_rec.attribute15 IS NULL THEN
99: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
100: END IF;
101:
102: IF p_x_header_rec.attribute16 IS NULL THEN --For bug 2184255
103: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
99: p_x_header_rec.attribute15 := FND_API.G_MISS_CHAR;
100: END IF;
101:
102: IF p_x_header_rec.attribute16 IS NULL THEN --For bug 2184255
103: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
104: END IF;
105:
106: IF p_x_header_rec.attribute17 IS NULL THEN
107: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
103: p_x_header_rec.attribute16 := FND_API.G_MISS_CHAR;
104: END IF;
105:
106: IF p_x_header_rec.attribute17 IS NULL THEN
107: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
108: END IF;
109:
110: IF p_x_header_rec.attribute18 IS NULL THEN
111: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
107: p_x_header_rec.attribute17 := FND_API.G_MISS_CHAR;
108: END IF;
109:
110: IF p_x_header_rec.attribute18 IS NULL THEN
111: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
112: END IF;
113:
114: IF p_x_header_rec.attribute19 IS NULL THEN
115: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
111: p_x_header_rec.attribute18 := FND_API.G_MISS_CHAR;
112: END IF;
113:
114: IF p_x_header_rec.attribute19 IS NULL THEN
115: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
116: END IF;
117:
118: IF p_x_header_rec.attribute2 IS NULL THEN
119: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
115: p_x_header_rec.attribute19 := FND_API.G_MISS_CHAR;
116: END IF;
117:
118: IF p_x_header_rec.attribute2 IS NULL THEN
119: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
120: END IF;
121:
122: IF p_x_header_rec.attribute20 IS NULL THEN --For bug 2184255
123: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
119: p_x_header_rec.attribute2 := FND_API.G_MISS_CHAR;
120: END IF;
121:
122: IF p_x_header_rec.attribute20 IS NULL THEN --For bug 2184255
123: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
124: END IF;
125:
126: IF p_x_header_rec.attribute3 IS NULL THEN
127: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
123: p_x_header_rec.attribute20 := FND_API.G_MISS_CHAR;
124: END IF;
125:
126: IF p_x_header_rec.attribute3 IS NULL THEN
127: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
128: END IF;
129:
130: IF p_x_header_rec.attribute4 IS NULL THEN
131: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
127: p_x_header_rec.attribute3 := FND_API.G_MISS_CHAR;
128: END IF;
129:
130: IF p_x_header_rec.attribute4 IS NULL THEN
131: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
132: END IF;
133:
134: IF p_x_header_rec.attribute5 IS NULL THEN
135: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
131: p_x_header_rec.attribute4 := FND_API.G_MISS_CHAR;
132: END IF;
133:
134: IF p_x_header_rec.attribute5 IS NULL THEN
135: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
136: END IF;
137:
138: IF p_x_header_rec.attribute6 IS NULL THEN
139: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
135: p_x_header_rec.attribute5 := FND_API.G_MISS_CHAR;
136: END IF;
137:
138: IF p_x_header_rec.attribute6 IS NULL THEN
139: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
140: END IF;
141:
142: IF p_x_header_rec.attribute7 IS NULL THEN
143: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
139: p_x_header_rec.attribute6 := FND_API.G_MISS_CHAR;
140: END IF;
141:
142: IF p_x_header_rec.attribute7 IS NULL THEN
143: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
144: END IF;
145:
146: IF p_x_header_rec.attribute8 IS NULL THEN
147: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
143: p_x_header_rec.attribute7 := FND_API.G_MISS_CHAR;
144: END IF;
145:
146: IF p_x_header_rec.attribute8 IS NULL THEN
147: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
148: END IF;
149:
150: IF p_x_header_rec.attribute9 IS NULL THEN
151: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
147: p_x_header_rec.attribute8 := FND_API.G_MISS_CHAR;
148: END IF;
149:
150: IF p_x_header_rec.attribute9 IS NULL THEN
151: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
152: END IF;
153:
154: IF p_x_header_rec.context IS NULL THEN
155: p_x_header_rec.context := FND_API.G_MISS_CHAR;
151: p_x_header_rec.attribute9 := FND_API.G_MISS_CHAR;
152: END IF;
153:
154: IF p_x_header_rec.context IS NULL THEN
155: p_x_header_rec.context := FND_API.G_MISS_CHAR;
156: END IF;
157:
158: IF p_x_header_rec.conversion_rate IS NULL THEN
159: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
155: p_x_header_rec.context := FND_API.G_MISS_CHAR;
156: END IF;
157:
158: IF p_x_header_rec.conversion_rate IS NULL THEN
159: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
160: END IF;
161:
162: IF p_x_header_rec.conversion_rate_date IS NULL THEN
163: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
159: p_x_header_rec.conversion_rate := FND_API.G_MISS_NUM;
160: END IF;
161:
162: IF p_x_header_rec.conversion_rate_date IS NULL THEN
163: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
164: END IF;
165:
166: IF p_x_header_rec.conversion_type_code IS NULL THEN
167: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
163: p_x_header_rec.conversion_rate_date := FND_API.G_MISS_DATE;
164: END IF;
165:
166: IF p_x_header_rec.conversion_type_code IS NULL THEN
167: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
168: END IF;
169:
170: IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE IS NULL THEN
171: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
167: p_x_header_rec.conversion_type_code := FND_API.G_MISS_CHAR;
168: END IF;
169:
170: IF p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE IS NULL THEN
171: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
172: END IF;
173:
174: IF p_x_header_rec.created_by IS NULL THEN
175: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
171: p_x_header_rec.CUSTOMER_PREFERENCE_SET_CODE := FND_API.G_MISS_CHAR;
172: END IF;
173:
174: IF p_x_header_rec.created_by IS NULL THEN
175: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
176: END IF;
177:
178: IF p_x_header_rec.creation_date IS NULL THEN
179: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
175: p_x_header_rec.created_by := FND_API.G_MISS_NUM;
176: END IF;
177:
178: IF p_x_header_rec.creation_date IS NULL THEN
179: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
180: END IF;
181:
182: IF p_x_header_rec.cust_po_number IS NULL THEN
183: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
179: p_x_header_rec.creation_date := FND_API.G_MISS_DATE;
180: END IF;
181:
182: IF p_x_header_rec.cust_po_number IS NULL THEN
183: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
184: END IF;
185:
186: IF p_x_header_rec.default_fulfillment_set IS NULL THEN
187: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
183: p_x_header_rec.cust_po_number := FND_API.G_MISS_CHAR;
184: END IF;
185:
186: IF p_x_header_rec.default_fulfillment_set IS NULL THEN
187: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
188: END IF;
189:
190: IF p_x_header_rec.deliver_to_contact_id IS NULL THEN
191: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
187: p_x_header_rec.default_fulfillment_set := FND_API.G_MISS_CHAR;
188: END IF;
189:
190: IF p_x_header_rec.deliver_to_contact_id IS NULL THEN
191: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
192: END IF;
193:
194: IF p_x_header_rec.deliver_to_org_id IS NULL THEN
195: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
191: p_x_header_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
192: END IF;
193:
194: IF p_x_header_rec.deliver_to_org_id IS NULL THEN
195: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
196: END IF;
197:
198: IF p_x_header_rec.demand_class_code IS NULL THEN
199: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
195: p_x_header_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
196: END IF;
197:
198: IF p_x_header_rec.demand_class_code IS NULL THEN
199: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
200: END IF;
201:
202: IF p_x_header_rec.expiration_date IS NULL THEN
203: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
199: p_x_header_rec.demand_class_code := FND_API.G_MISS_CHAR;
200: END IF;
201:
202: IF p_x_header_rec.expiration_date IS NULL THEN
203: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
204: END IF;
205:
206: IF p_x_header_rec.earliest_schedule_limit IS NULL THEN
207: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
203: p_x_header_rec.expiration_date := FND_API.G_MISS_DATE;
204: END IF;
205:
206: IF p_x_header_rec.earliest_schedule_limit IS NULL THEN
207: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
208: END IF;
209:
210: IF p_x_header_rec.fob_point_code IS NULL THEN
211: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
207: p_x_header_rec.earliest_schedule_limit := FND_API.G_MISS_NUM;
208: END IF;
209:
210: IF p_x_header_rec.fob_point_code IS NULL THEN
211: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
212: END IF;
213:
214: IF p_x_header_rec.freight_carrier_code IS NULL THEN
215: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
211: p_x_header_rec.fob_point_code := FND_API.G_MISS_CHAR;
212: END IF;
213:
214: IF p_x_header_rec.freight_carrier_code IS NULL THEN
215: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
216: END IF;
217:
218: IF p_x_header_rec.freight_terms_code IS NULL THEN
219: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
215: p_x_header_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
216: END IF;
217:
218: IF p_x_header_rec.freight_terms_code IS NULL THEN
219: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
220: END IF;
221:
222: IF p_x_header_rec.fulfillment_set_name IS NULL THEN
223: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
219: p_x_header_rec.freight_terms_code := FND_API.G_MISS_CHAR;
220: END IF;
221:
222: IF p_x_header_rec.fulfillment_set_name IS NULL THEN
223: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
224: END IF;
225:
226: IF p_x_header_rec.global_attribute1 IS NULL THEN
227: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
223: p_x_header_rec.fulfillment_set_name := FND_API.G_MISS_CHAR;
224: END IF;
225:
226: IF p_x_header_rec.global_attribute1 IS NULL THEN
227: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
228: END IF;
229:
230: IF p_x_header_rec.global_attribute10 IS NULL THEN
231: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
227: p_x_header_rec.global_attribute1 := FND_API.G_MISS_CHAR;
228: END IF;
229:
230: IF p_x_header_rec.global_attribute10 IS NULL THEN
231: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
232: END IF;
233:
234: IF p_x_header_rec.global_attribute11 IS NULL THEN
235: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
231: p_x_header_rec.global_attribute10 := FND_API.G_MISS_CHAR;
232: END IF;
233:
234: IF p_x_header_rec.global_attribute11 IS NULL THEN
235: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
236: END IF;
237:
238: IF p_x_header_rec.global_attribute12 IS NULL THEN
239: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
235: p_x_header_rec.global_attribute11 := FND_API.G_MISS_CHAR;
236: END IF;
237:
238: IF p_x_header_rec.global_attribute12 IS NULL THEN
239: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
240: END IF;
241:
242: IF p_x_header_rec.global_attribute13 IS NULL THEN
243: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
239: p_x_header_rec.global_attribute12 := FND_API.G_MISS_CHAR;
240: END IF;
241:
242: IF p_x_header_rec.global_attribute13 IS NULL THEN
243: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
244: END IF;
245:
246: IF p_x_header_rec.global_attribute14 IS NULL THEN
247: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
243: p_x_header_rec.global_attribute13 := FND_API.G_MISS_CHAR;
244: END IF;
245:
246: IF p_x_header_rec.global_attribute14 IS NULL THEN
247: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
248: END IF;
249:
250: IF p_x_header_rec.global_attribute15 IS NULL THEN
251: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
247: p_x_header_rec.global_attribute14 := FND_API.G_MISS_CHAR;
248: END IF;
249:
250: IF p_x_header_rec.global_attribute15 IS NULL THEN
251: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
252: END IF;
253:
254: IF p_x_header_rec.global_attribute16 IS NULL THEN
255: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
251: p_x_header_rec.global_attribute15 := FND_API.G_MISS_CHAR;
252: END IF;
253:
254: IF p_x_header_rec.global_attribute16 IS NULL THEN
255: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
256: END IF;
257:
258: IF p_x_header_rec.global_attribute17 IS NULL THEN
259: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
255: p_x_header_rec.global_attribute16 := FND_API.G_MISS_CHAR;
256: END IF;
257:
258: IF p_x_header_rec.global_attribute17 IS NULL THEN
259: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
260: END IF;
261:
262: IF p_x_header_rec.global_attribute18 IS NULL THEN
263: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
259: p_x_header_rec.global_attribute17 := FND_API.G_MISS_CHAR;
260: END IF;
261:
262: IF p_x_header_rec.global_attribute18 IS NULL THEN
263: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
264: END IF;
265:
266: IF p_x_header_rec.global_attribute19 IS NULL THEN
267: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
263: p_x_header_rec.global_attribute18 := FND_API.G_MISS_CHAR;
264: END IF;
265:
266: IF p_x_header_rec.global_attribute19 IS NULL THEN
267: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
268: END IF;
269:
270: IF p_x_header_rec.global_attribute2 IS NULL THEN
271: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
267: p_x_header_rec.global_attribute19 := FND_API.G_MISS_CHAR;
268: END IF;
269:
270: IF p_x_header_rec.global_attribute2 IS NULL THEN
271: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
272: END IF;
273:
274: IF p_x_header_rec.global_attribute20 IS NULL THEN
275: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
271: p_x_header_rec.global_attribute2 := FND_API.G_MISS_CHAR;
272: END IF;
273:
274: IF p_x_header_rec.global_attribute20 IS NULL THEN
275: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
276: END IF;
277:
278: IF p_x_header_rec.global_attribute3 IS NULL THEN
279: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
275: p_x_header_rec.global_attribute20 := FND_API.G_MISS_CHAR;
276: END IF;
277:
278: IF p_x_header_rec.global_attribute3 IS NULL THEN
279: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
280: END IF;
281:
282: IF p_x_header_rec.global_attribute4 IS NULL THEN
283: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
279: p_x_header_rec.global_attribute3 := FND_API.G_MISS_CHAR;
280: END IF;
281:
282: IF p_x_header_rec.global_attribute4 IS NULL THEN
283: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
284: END IF;
285:
286: IF p_x_header_rec.global_attribute5 IS NULL THEN
287: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
283: p_x_header_rec.global_attribute4 := FND_API.G_MISS_CHAR;
284: END IF;
285:
286: IF p_x_header_rec.global_attribute5 IS NULL THEN
287: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
288: END IF;
289:
290: IF p_x_header_rec.global_attribute6 IS NULL THEN
291: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
287: p_x_header_rec.global_attribute5 := FND_API.G_MISS_CHAR;
288: END IF;
289:
290: IF p_x_header_rec.global_attribute6 IS NULL THEN
291: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
292: END IF;
293:
294: IF p_x_header_rec.global_attribute7 IS NULL THEN
295: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
291: p_x_header_rec.global_attribute6 := FND_API.G_MISS_CHAR;
292: END IF;
293:
294: IF p_x_header_rec.global_attribute7 IS NULL THEN
295: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
296: END IF;
297:
298: IF p_x_header_rec.global_attribute8 IS NULL THEN
299: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
295: p_x_header_rec.global_attribute7 := FND_API.G_MISS_CHAR;
296: END IF;
297:
298: IF p_x_header_rec.global_attribute8 IS NULL THEN
299: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
300: END IF;
301:
302: IF p_x_header_rec.global_attribute9 IS NULL THEN
303: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
299: p_x_header_rec.global_attribute8 := FND_API.G_MISS_CHAR;
300: END IF;
301:
302: IF p_x_header_rec.global_attribute9 IS NULL THEN
303: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
304: END IF;
305:
306: IF p_x_header_rec.global_attribute_category IS NULL THEN
307: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
303: p_x_header_rec.global_attribute9 := FND_API.G_MISS_CHAR;
304: END IF;
305:
306: IF p_x_header_rec.global_attribute_category IS NULL THEN
307: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
308: END IF;
309:
310: IF p_x_header_rec.header_id IS NULL THEN
311: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
307: p_x_header_rec.global_attribute_category := FND_API.G_MISS_CHAR;
308: END IF;
309:
310: IF p_x_header_rec.header_id IS NULL THEN
311: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
312: END IF;
313:
314: IF p_x_header_rec.invoice_to_contact_id IS NULL THEN
315: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
311: p_x_header_rec.header_id := FND_API.G_MISS_NUM;
312: END IF;
313:
314: IF p_x_header_rec.invoice_to_contact_id IS NULL THEN
315: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
316: END IF;
317:
318: IF p_x_header_rec.invoice_to_org_id IS NULL THEN
319: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
315: p_x_header_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
316: END IF;
317:
318: IF p_x_header_rec.invoice_to_org_id IS NULL THEN
319: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
320: END IF;
321:
322: IF p_x_header_rec.invoicing_rule_id IS NULL THEN
323: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
319: p_x_header_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
320: END IF;
321:
322: IF p_x_header_rec.invoicing_rule_id IS NULL THEN
323: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
324: END IF;
325:
326: IF p_x_header_rec.last_updated_by IS NULL THEN
327: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
323: p_x_header_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
324: END IF;
325:
326: IF p_x_header_rec.last_updated_by IS NULL THEN
327: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
328: END IF;
329:
330: IF p_x_header_rec.last_update_date IS NULL THEN
331: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
327: p_x_header_rec.last_updated_by := FND_API.G_MISS_NUM;
328: END IF;
329:
330: IF p_x_header_rec.last_update_date IS NULL THEN
331: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
332: END IF;
333:
334: IF p_x_header_rec.last_update_login IS NULL THEN
335: p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
331: p_x_header_rec.last_update_date := FND_API.G_MISS_DATE;
332: END IF;
333:
334: IF p_x_header_rec.last_update_login IS NULL THEN
335: p_x_header_rec.last_update_login := FND_API.G_MISS_NUM;
336: END IF;
337:
338:
339: IF p_x_header_rec.latest_schedule_limit IS NULL THEN
336: END IF;
337:
338:
339: IF p_x_header_rec.latest_schedule_limit IS NULL THEN
340: p_x_header_rec.latest_schedule_limit := FND_API.G_MISS_NUM;
341: END IF;
342:
343: IF p_x_header_rec.line_set_name IS NULL THEN
344: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
340: p_x_header_rec.latest_schedule_limit := FND_API.G_MISS_NUM;
341: END IF;
342:
343: IF p_x_header_rec.line_set_name IS NULL THEN
344: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
345: END IF;
346:
347: IF p_x_header_rec.open_flag IS NULL THEN
348: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
344: p_x_header_rec.line_set_name := FND_API.G_MISS_CHAR;
345: END IF;
346:
347: IF p_x_header_rec.open_flag IS NULL THEN
348: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
349: END IF;
350:
351: IF p_x_header_rec.ordered_date IS NULL THEN
352: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
348: p_x_header_rec.open_flag := FND_API.G_MISS_CHAR;
349: END IF;
350:
351: IF p_x_header_rec.ordered_date IS NULL THEN
352: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
353: END IF;
354:
355: IF p_x_header_rec.order_date_type_code IS NULL THEN
356: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
352: p_x_header_rec.ordered_date := FND_API.G_MISS_DATE;
353: END IF;
354:
355: IF p_x_header_rec.order_date_type_code IS NULL THEN
356: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
357: END IF;
358:
359: IF p_x_header_rec.order_number IS NULL THEN
360: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
356: p_x_header_rec.order_date_type_code := FND_API.G_MISS_CHAR;
357: END IF;
358:
359: IF p_x_header_rec.order_number IS NULL THEN
360: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
361: END IF;
362:
363: IF p_x_header_rec.order_source_id IS NULL THEN
364: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
360: p_x_header_rec.order_number := FND_API.G_MISS_NUM;
361: END IF;
362:
363: IF p_x_header_rec.order_source_id IS NULL THEN
364: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
365: END IF;
366:
367: IF p_x_header_rec.order_type_id IS NULL THEN
368: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
364: p_x_header_rec.order_source_id := FND_API.G_MISS_NUM;
365: END IF;
366:
367: IF p_x_header_rec.order_type_id IS NULL THEN
368: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
369: END IF;
370: IF p_x_header_rec.order_category_code IS NULL THEN
371: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
372: END IF;
367: IF p_x_header_rec.order_type_id IS NULL THEN
368: p_x_header_rec.order_type_id := FND_API.G_MISS_NUM;
369: END IF;
370: IF p_x_header_rec.order_category_code IS NULL THEN
371: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
372: END IF;
373:
374: IF p_x_header_rec.org_id IS NULL THEN
375: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
371: p_x_header_rec.order_category_code := FND_API.G_MISS_CHAR;
372: END IF;
373:
374: IF p_x_header_rec.org_id IS NULL THEN
375: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
376: END IF;
377:
378: IF p_x_header_rec.orig_sys_document_ref IS NULL THEN
379: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
375: p_x_header_rec.org_id := FND_API.G_MISS_NUM;
376: END IF;
377:
378: IF p_x_header_rec.orig_sys_document_ref IS NULL THEN
379: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
380: END IF;
381:
382: IF p_x_header_rec.partial_shipments_allowed IS NULL THEN
383: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
379: p_x_header_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
380: END IF;
381:
382: IF p_x_header_rec.partial_shipments_allowed IS NULL THEN
383: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
384: END IF;
385:
386: IF p_x_header_rec.payment_term_id IS NULL THEN
387: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
383: p_x_header_rec.partial_shipments_allowed := FND_API.G_MISS_CHAR;
384: END IF;
385:
386: IF p_x_header_rec.payment_term_id IS NULL THEN
387: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
388: END IF;
389:
390: IF p_x_header_rec.price_list_id IS NULL THEN
391: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
387: p_x_header_rec.payment_term_id := FND_API.G_MISS_NUM;
388: END IF;
389:
390: IF p_x_header_rec.price_list_id IS NULL THEN
391: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
392: END IF;
393:
394: IF p_x_header_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
395: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
391: p_x_header_rec.price_list_id := FND_API.G_MISS_NUM;
392: END IF;
393:
394: IF p_x_header_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
395: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
396: END IF;
397:
398: IF p_x_header_rec.pricing_date IS NULL THEN
399: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
395: p_x_header_rec.price_request_code := FND_API.G_MISS_CHAR;
396: END IF;
397:
398: IF p_x_header_rec.pricing_date IS NULL THEN
399: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
400: END IF;
401:
402: IF p_x_header_rec.program_application_id IS NULL THEN
403: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
399: p_x_header_rec.pricing_date := FND_API.G_MISS_DATE;
400: END IF;
401:
402: IF p_x_header_rec.program_application_id IS NULL THEN
403: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
404: END IF;
405:
406: IF p_x_header_rec.program_id IS NULL THEN
407: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
403: p_x_header_rec.program_application_id := FND_API.G_MISS_NUM;
404: END IF;
405:
406: IF p_x_header_rec.program_id IS NULL THEN
407: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
408: END IF;
409:
410: IF p_x_header_rec.program_update_date IS NULL THEN
411: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
407: p_x_header_rec.program_id := FND_API.G_MISS_NUM;
408: END IF;
409:
410: IF p_x_header_rec.program_update_date IS NULL THEN
411: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
412: END IF;
413:
414: IF p_x_header_rec.request_date IS NULL THEN
415: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
411: p_x_header_rec.program_update_date := FND_API.G_MISS_DATE;
412: END IF;
413:
414: IF p_x_header_rec.request_date IS NULL THEN
415: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
416: END IF;
417:
418: IF p_x_header_rec.request_id IS NULL THEN
419: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
415: p_x_header_rec.request_date := FND_API.G_MISS_DATE;
416: END IF;
417:
418: IF p_x_header_rec.request_id IS NULL THEN
419: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
420: END IF;
421:
422: IF p_x_header_rec.return_reason_code IS NULL THEN
423: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
419: p_x_header_rec.request_id := FND_API.G_MISS_NUM;
420: END IF;
421:
422: IF p_x_header_rec.return_reason_code IS NULL THEN
423: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
424: END IF;
425:
426: IF p_x_header_rec.salesrep_id IS NULL THEN
427: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
423: p_x_header_rec.return_reason_code := FND_API.G_MISS_CHAR;
424: END IF;
425:
426: IF p_x_header_rec.salesrep_id IS NULL THEN
427: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
428: END IF;
429:
430: IF p_x_header_rec.sales_channel_code IS NULL THEN
431: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
427: p_x_header_rec.salesrep_id := FND_API.G_MISS_NUM;
428: END IF;
429:
430: IF p_x_header_rec.sales_channel_code IS NULL THEN
431: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
432: END IF;
433:
434: IF p_x_header_rec.shipment_priority_code IS NULL THEN
435: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
431: p_x_header_rec.sales_channel_code := FND_API.G_MISS_CHAR;
432: END IF;
433:
434: IF p_x_header_rec.shipment_priority_code IS NULL THEN
435: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
436: END IF;
437:
438: IF p_x_header_rec.shipping_method_code IS NULL THEN
439: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
435: p_x_header_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
436: END IF;
437:
438: IF p_x_header_rec.shipping_method_code IS NULL THEN
439: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
440: END IF;
441:
442: IF p_x_header_rec.ship_from_org_id IS NULL THEN
443: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
439: p_x_header_rec.shipping_method_code := FND_API.G_MISS_CHAR;
440: END IF;
441:
442: IF p_x_header_rec.ship_from_org_id IS NULL THEN
443: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
444: END IF;
445:
446: IF p_x_header_rec.ship_tolerance_above IS NULL THEN
447: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
443: p_x_header_rec.ship_from_org_id := FND_API.G_MISS_NUM;
444: END IF;
445:
446: IF p_x_header_rec.ship_tolerance_above IS NULL THEN
447: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
448: END IF;
449:
450: IF p_x_header_rec.ship_tolerance_below IS NULL THEN
451: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
447: p_x_header_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
448: END IF;
449:
450: IF p_x_header_rec.ship_tolerance_below IS NULL THEN
451: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
452: END IF;
453:
454: IF p_x_header_rec.ship_to_contact_id IS NULL THEN
455: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
451: p_x_header_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
452: END IF;
453:
454: IF p_x_header_rec.ship_to_contact_id IS NULL THEN
455: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
456: END IF;
457:
458: IF p_x_header_rec.ship_to_org_id IS NULL THEN
459: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
455: p_x_header_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
456: END IF;
457:
458: IF p_x_header_rec.ship_to_org_id IS NULL THEN
459: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
460: END IF;
461:
462: IF p_x_header_rec.sold_from_org_id IS NULL THEN
463: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
459: p_x_header_rec.ship_to_org_id := FND_API.G_MISS_NUM;
460: END IF;
461:
462: IF p_x_header_rec.sold_from_org_id IS NULL THEN
463: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
464: END IF;
465:
466: IF p_x_header_rec.sold_to_contact_id IS NULL THEN
467: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
463: p_x_header_rec.sold_from_org_id := FND_API.G_MISS_NUM;
464: END IF;
465:
466: IF p_x_header_rec.sold_to_contact_id IS NULL THEN
467: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
468: END IF;
469:
470: IF p_x_header_rec.sold_to_org_id IS NULL THEN
471: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
467: p_x_header_rec.sold_to_contact_id := FND_API.G_MISS_NUM;
468: END IF;
469:
470: IF p_x_header_rec.sold_to_org_id IS NULL THEN
471: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
472: END IF;
473:
474: IF p_x_header_rec.sold_to_phone_id IS NULL THEN
475: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
471: p_x_header_rec.sold_to_org_id := FND_API.G_MISS_NUM;
472: END IF;
473:
474: IF p_x_header_rec.sold_to_phone_id IS NULL THEN
475: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
476: END IF;
477:
478: IF p_x_header_rec.source_document_id IS NULL THEN
479: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
475: p_x_header_rec.sold_to_phone_id := FND_API.G_MISS_NUM;
476: END IF;
477:
478: IF p_x_header_rec.source_document_id IS NULL THEN
479: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
480: END IF;
481:
482: IF p_x_header_rec.source_document_type_id IS NULL THEN
483: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
479: p_x_header_rec.source_document_id := FND_API.G_MISS_NUM;
480: END IF;
481:
482: IF p_x_header_rec.source_document_type_id IS NULL THEN
483: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
484: END IF;
485:
486: IF p_x_header_rec.tax_exempt_flag IS NULL THEN
487: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
483: p_x_header_rec.source_document_type_id := FND_API.G_MISS_NUM;
484: END IF;
485:
486: IF p_x_header_rec.tax_exempt_flag IS NULL THEN
487: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
488: END IF;
489:
490: IF p_x_header_rec.tax_exempt_number IS NULL THEN
491: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
487: p_x_header_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
488: END IF;
489:
490: IF p_x_header_rec.tax_exempt_number IS NULL THEN
491: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
492: END IF;
493:
494: IF p_x_header_rec.tax_exempt_reason_code IS NULL THEN
495: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
491: p_x_header_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
492: END IF;
493:
494: IF p_x_header_rec.tax_exempt_reason_code IS NULL THEN
495: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
496: END IF;
497:
498: IF p_x_header_rec.tax_point_code IS NULL THEN
499: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
495: p_x_header_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
496: END IF;
497:
498: IF p_x_header_rec.tax_point_code IS NULL THEN
499: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
500: END IF;
501:
502: IF p_x_header_rec.transactional_curr_code IS NULL THEN
503: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
499: p_x_header_rec.tax_point_code := FND_API.G_MISS_CHAR;
500: END IF;
501:
502: IF p_x_header_rec.transactional_curr_code IS NULL THEN
503: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
504: END IF;
505:
506: IF p_x_header_rec.version_number IS NULL THEN
507: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
503: p_x_header_rec.transactional_curr_code := FND_API.G_MISS_CHAR;
504: END IF;
505:
506: IF p_x_header_rec.version_number IS NULL THEN
507: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
508: END IF;
509:
510: IF p_x_header_rec.payment_type_code IS NULL THEN
511: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
507: p_x_header_rec.version_number := FND_API.G_MISS_NUM;
508: END IF;
509:
510: IF p_x_header_rec.payment_type_code IS NULL THEN
511: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
512: END IF;
513:
514: IF p_x_header_rec.payment_amount IS NULL THEN
515: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
511: p_x_header_rec.payment_type_code := FND_API.G_MISS_CHAR;
512: END IF;
513:
514: IF p_x_header_rec.payment_amount IS NULL THEN
515: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
516: END IF;
517:
518: IF p_x_header_rec.check_number IS NULL THEN
519: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
515: p_x_header_rec.payment_amount := FND_API.G_MISS_NUM;
516: END IF;
517:
518: IF p_x_header_rec.check_number IS NULL THEN
519: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
520: END IF;
521:
522: IF p_x_header_rec.credit_card_code IS NULL THEN
523: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
519: p_x_header_rec.check_number := FND_API.G_MISS_CHAR;
520: END IF;
521:
522: IF p_x_header_rec.credit_card_code IS NULL THEN
523: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
524: END IF;
525:
526: IF p_x_header_rec.credit_card_holder_name IS NULL THEN
527: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
523: p_x_header_rec.credit_card_code := FND_API.G_MISS_CHAR;
524: END IF;
525:
526: IF p_x_header_rec.credit_card_holder_name IS NULL THEN
527: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
528: END IF;
529:
530: IF p_x_header_rec.credit_card_number IS NULL THEN
531: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
527: p_x_header_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
528: END IF;
529:
530: IF p_x_header_rec.credit_card_number IS NULL THEN
531: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
532: END IF;
533:
534: IF p_x_header_rec.credit_card_expiration_date IS NULL THEN
535: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
531: p_x_header_rec.credit_card_number := FND_API.G_MISS_CHAR;
532: END IF;
533:
534: IF p_x_header_rec.credit_card_expiration_date IS NULL THEN
535: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
536: END IF;
537:
538: IF p_x_header_rec.credit_card_approval_date IS NULL THEN
539: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
535: p_x_header_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
536: END IF;
537:
538: IF p_x_header_rec.credit_card_approval_date IS NULL THEN
539: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
540: END IF;
541:
542: IF p_x_header_rec.credit_card_approval_code IS NULL THEN
543: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
539: p_x_header_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
540: END IF;
541:
542: IF p_x_header_rec.credit_card_approval_code IS NULL THEN
543: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
544: END IF;
545:
546: IF p_x_header_rec.first_ack_code IS NULL THEN
547: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
543: p_x_header_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
544: END IF;
545:
546: IF p_x_header_rec.first_ack_code IS NULL THEN
547: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
548: END IF;
549:
550: IF p_x_header_rec.first_ack_date IS NULL THEN
551: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
547: p_x_header_rec.first_ack_code := FND_API.G_MISS_CHAR;
548: END IF;
549:
550: IF p_x_header_rec.first_ack_date IS NULL THEN
551: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
552: END IF;
553:
554: IF p_x_header_rec.last_ack_code IS NULL THEN
555: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
551: p_x_header_rec.first_ack_date := FND_API.G_MISS_DATE;
552: END IF;
553:
554: IF p_x_header_rec.last_ack_code IS NULL THEN
555: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
556: END IF;
557:
558: IF p_x_header_rec.last_ack_date IS NULL THEN
559: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
555: p_x_header_rec.last_ack_code := FND_API.G_MISS_CHAR;
556: END IF;
557:
558: IF p_x_header_rec.last_ack_date IS NULL THEN
559: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
560: END IF;
561:
562: IF p_x_header_rec.shipping_instructions IS NULL THEN
563: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
559: p_x_header_rec.last_ack_date := FND_API.G_MISS_DATE;
560: END IF;
561:
562: IF p_x_header_rec.shipping_instructions IS NULL THEN
563: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
564: END IF;
565:
566: IF p_x_header_rec.packing_instructions IS NULL THEN
567: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
563: p_x_header_rec.shipping_instructions := FND_API.G_MISS_CHAR;
564: END IF;
565:
566: IF p_x_header_rec.packing_instructions IS NULL THEN
567: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
568: END IF;
569:
570: IF p_x_header_rec.flow_status_code IS NULL THEN
571: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
567: p_x_header_rec.packing_instructions := FND_API.G_MISS_CHAR;
568: END IF;
569:
570: IF p_x_header_rec.flow_status_code IS NULL THEN
571: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
572: END IF;
573:
574: IF p_x_header_rec.marketing_source_code_id IS NULL THEN
575: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
571: p_x_header_rec.flow_status_code := FND_API.G_MISS_CHAR;
572: END IF;
573:
574: IF p_x_header_rec.marketing_source_code_id IS NULL THEN
575: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
576: END IF;
577:
578: IF p_x_header_rec.change_sequence IS NULL THEN --2416561
579: p_x_header_rec.change_sequence := FND_API.G_MISS_CHAR;
575: p_x_header_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
576: END IF;
577:
578: IF p_x_header_rec.change_sequence IS NULL THEN --2416561
579: p_x_header_rec.change_sequence := FND_API.G_MISS_CHAR;
580: END IF;
581:
582: -- QUOTING changes
583:
581:
582: -- QUOTING changes
583:
584: IF p_x_header_rec.quote_date IS NULL THEN
585: p_x_header_rec.quote_date := FND_API.G_MISS_DATE;
586: END IF;
587:
588: IF p_x_header_rec.quote_number IS NULL THEN
589: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
585: p_x_header_rec.quote_date := FND_API.G_MISS_DATE;
586: END IF;
587:
588: IF p_x_header_rec.quote_number IS NULL THEN
589: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
590: END IF;
591:
592: IF p_x_header_rec.sales_document_name IS NULL THEN
593: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
589: p_x_header_rec.quote_number := FND_API.G_MISS_NUM;
590: END IF;
591:
592: IF p_x_header_rec.sales_document_name IS NULL THEN
593: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
594: END IF;
595:
596: IF p_x_header_rec.transaction_phase_code IS NULL THEN
597: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
593: p_x_header_rec.sales_document_name := FND_API.G_MISS_CHAR;
594: END IF;
595:
596: IF p_x_header_rec.transaction_phase_code IS NULL THEN
597: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
598: END IF;
599:
600: IF p_x_header_rec.user_status_code IS NULL THEN
601: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
597: p_x_header_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
598: END IF;
599:
600: IF p_x_header_rec.user_status_code IS NULL THEN
601: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
602: END IF;
603:
604: IF p_x_header_rec.draft_submitted_flag IS NULL THEN
605: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
601: p_x_header_rec.user_status_code := FND_API.G_MISS_CHAR;
602: END IF;
603:
604: IF p_x_header_rec.draft_submitted_flag IS NULL THEN
605: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
606: END IF;
607:
608: IF p_x_header_rec.source_document_version_number IS NULL THEN
609: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
605: p_x_header_rec.draft_submitted_flag := FND_API.G_MISS_CHAR;
606: END IF;
607:
608: IF p_x_header_rec.source_document_version_number IS NULL THEN
609: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
610: END IF;
611:
612: IF p_x_header_rec.sold_to_site_use_id IS NULL THEN
613: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
609: p_x_header_rec.source_document_version_number := FND_API.G_MISS_NUM;
610: END IF;
611:
612: IF p_x_header_rec.sold_to_site_use_id IS NULL THEN
613: p_x_header_rec.sold_to_site_use_id := FND_API.G_MISS_NUM;
614: END IF;
615:
616: -- QUOTING changes END
617:
615:
616: -- QUOTING changes END
617:
618: IF p_x_header_rec.Minisite_id IS NULL THEN
619: p_x_header_rec.Minisite_id := FND_API.G_MISS_NUM;
620: END IF;
621:
622: IF p_x_header_rec.End_customer_id IS NULL THEN
623: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
619: p_x_header_rec.Minisite_id := FND_API.G_MISS_NUM;
620: END IF;
621:
622: IF p_x_header_rec.End_customer_id IS NULL THEN
623: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
624: END IF;
625:
626: IF p_x_header_rec.End_customer_contact_id IS NULL THEN
627: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
623: p_x_header_rec.End_customer_id := FND_API.G_MISS_NUM;
624: END IF;
625:
626: IF p_x_header_rec.End_customer_contact_id IS NULL THEN
627: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
628: END IF;
629:
630: IF p_x_header_rec.End_customer_site_use_id IS NULL THEN
631: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
627: p_x_header_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
628: END IF;
629:
630: IF p_x_header_rec.End_customer_site_use_id IS NULL THEN
631: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
632: END IF;
633:
634: IF p_x_header_rec.Ib_owner IS NULL THEN
635: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
631: p_x_header_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
632: END IF;
633:
634: IF p_x_header_rec.Ib_owner IS NULL THEN
635: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
636: END IF;
637:
638: IF p_x_header_rec.Ib_installed_at_location IS NULL THEN
639: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
635: p_x_header_rec.Ib_owner := FND_API.G_MISS_CHAR;
636: END IF;
637:
638: IF p_x_header_rec.Ib_installed_at_location IS NULL THEN
639: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
640: END IF;
641:
642: IF p_x_header_rec.Ib_current_location IS NULL THEN
643: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
639: p_x_header_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
640: END IF;
641:
642: IF p_x_header_rec.Ib_current_location IS NULL THEN
643: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
644: END IF;
645:
646: IF p_x_header_rec.supplier_signature IS NULL THEN
647: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
643: p_x_header_rec.Ib_current_location := FND_API.G_MISS_CHAR;
644: END IF;
645:
646: IF p_x_header_rec.supplier_signature IS NULL THEN
647: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
648: END IF;
649:
650: IF p_x_header_rec.supplier_signature_date IS NULL THEN
651: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
647: p_x_header_rec.supplier_signature := FND_API.G_MISS_CHAR;
648: END IF;
649:
650: IF p_x_header_rec.supplier_signature_date IS NULL THEN
651: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
652: END IF;
653:
654: IF p_x_header_rec.customer_signature IS NULL THEN
655: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
651: p_x_header_rec.supplier_signature_date := FND_API.G_MISS_DATE;
652: END IF;
653:
654: IF p_x_header_rec.customer_signature IS NULL THEN
655: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
656: END IF;
657:
658: IF p_x_header_rec.customer_signature_date IS NULL THEN
659: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
655: p_x_header_rec.customer_signature := FND_API.G_MISS_CHAR;
656: END IF;
657:
658: IF p_x_header_rec.customer_signature_date IS NULL THEN
659: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
660: END IF;
661:
662: IF p_x_header_rec.contract_template_id IS NULL THEN
663: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
659: p_x_header_rec.customer_signature_date := FND_API.G_MISS_DATE;
660: END IF;
661:
662: IF p_x_header_rec.contract_template_id IS NULL THEN
663: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
664: END IF;
665:
666: IF p_x_header_rec.contract_source_doc_type_code IS NULL THEN
667: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
663: p_x_header_rec.contract_template_id := FND_API.G_MISS_NUM;
664: END IF;
665:
666: IF p_x_header_rec.contract_source_doc_type_code IS NULL THEN
667: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
668: END IF;
669:
670: IF p_x_header_rec.contract_source_document_id IS NULL THEN
671: p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
667: p_x_header_rec.contract_source_doc_type_code := FND_API.G_MISS_CHAR;
668: END IF;
669:
670: IF p_x_header_rec.contract_source_document_id IS NULL THEN
671: p_x_header_rec.contract_source_document_id := FND_API.G_MISS_NUM;
672: END IF;
673:
674: --key Transaction dates
675: IF p_x_header_rec.order_firmed_date IS NULL THEN
672: END IF;
673:
674: --key Transaction dates
675: IF p_x_header_rec.order_firmed_date IS NULL THEN
676: p_x_header_rec.order_firmed_date := FND_API.G_MISS_DATE;
677: END IF;
678:
679: oe_debug_pub.add('Exiting Convert_hdr_null_to_miss', 1);
680:
697:
698: oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
699:
700: IF p_x_Header_Payment_rec.attribute1 IS NULL THEN
701: p_x_Header_Payment_rec.attribute1 := FND_API.G_MISS_CHAR;
702: END IF;
703:
704: IF p_x_Header_Payment_rec.attribute2 IS NULL THEN
705: p_x_Header_Payment_rec.attribute2 := FND_API.G_MISS_CHAR;
701: p_x_Header_Payment_rec.attribute1 := FND_API.G_MISS_CHAR;
702: END IF;
703:
704: IF p_x_Header_Payment_rec.attribute2 IS NULL THEN
705: p_x_Header_Payment_rec.attribute2 := FND_API.G_MISS_CHAR;
706: END IF;
707:
708: IF p_x_Header_Payment_rec.attribute3 IS NULL THEN
709: p_x_Header_Payment_rec.attribute3 := FND_API.G_MISS_CHAR;
705: p_x_Header_Payment_rec.attribute2 := FND_API.G_MISS_CHAR;
706: END IF;
707:
708: IF p_x_Header_Payment_rec.attribute3 IS NULL THEN
709: p_x_Header_Payment_rec.attribute3 := FND_API.G_MISS_CHAR;
710: END IF;
711:
712: IF p_x_Header_Payment_rec.attribute4 IS NULL THEN
713: p_x_Header_Payment_rec.attribute4 := FND_API.G_MISS_CHAR;
709: p_x_Header_Payment_rec.attribute3 := FND_API.G_MISS_CHAR;
710: END IF;
711:
712: IF p_x_Header_Payment_rec.attribute4 IS NULL THEN
713: p_x_Header_Payment_rec.attribute4 := FND_API.G_MISS_CHAR;
714: END IF;
715:
716: IF p_x_Header_Payment_rec.attribute5 IS NULL THEN
717: p_x_Header_Payment_rec.attribute5 := FND_API.G_MISS_CHAR;
713: p_x_Header_Payment_rec.attribute4 := FND_API.G_MISS_CHAR;
714: END IF;
715:
716: IF p_x_Header_Payment_rec.attribute5 IS NULL THEN
717: p_x_Header_Payment_rec.attribute5 := FND_API.G_MISS_CHAR;
718: END IF;
719:
720: IF p_x_Header_Payment_rec.attribute6 IS NULL THEN
721: p_x_Header_Payment_rec.attribute6 := FND_API.G_MISS_CHAR;
717: p_x_Header_Payment_rec.attribute5 := FND_API.G_MISS_CHAR;
718: END IF;
719:
720: IF p_x_Header_Payment_rec.attribute6 IS NULL THEN
721: p_x_Header_Payment_rec.attribute6 := FND_API.G_MISS_CHAR;
722: END IF;
723:
724: IF p_x_Header_Payment_rec.attribute7 IS NULL THEN
725: p_x_Header_Payment_rec.attribute7 := FND_API.G_MISS_CHAR;
721: p_x_Header_Payment_rec.attribute6 := FND_API.G_MISS_CHAR;
722: END IF;
723:
724: IF p_x_Header_Payment_rec.attribute7 IS NULL THEN
725: p_x_Header_Payment_rec.attribute7 := FND_API.G_MISS_CHAR;
726: END IF;
727:
728: IF p_x_Header_Payment_rec.attribute8 IS NULL THEN
729: p_x_Header_Payment_rec.attribute8 := FND_API.G_MISS_CHAR;
725: p_x_Header_Payment_rec.attribute7 := FND_API.G_MISS_CHAR;
726: END IF;
727:
728: IF p_x_Header_Payment_rec.attribute8 IS NULL THEN
729: p_x_Header_Payment_rec.attribute8 := FND_API.G_MISS_CHAR;
730: END IF;
731:
732: IF p_x_Header_Payment_rec.attribute9 IS NULL THEN
733: p_x_Header_Payment_rec.attribute9 := FND_API.G_MISS_CHAR;
729: p_x_Header_Payment_rec.attribute8 := FND_API.G_MISS_CHAR;
730: END IF;
731:
732: IF p_x_Header_Payment_rec.attribute9 IS NULL THEN
733: p_x_Header_Payment_rec.attribute9 := FND_API.G_MISS_CHAR;
734: END IF;
735:
736: IF p_x_Header_Payment_rec.attribute10 IS NULL THEN
737: p_x_Header_Payment_rec.attribute10 := FND_API.G_MISS_CHAR;
733: p_x_Header_Payment_rec.attribute9 := FND_API.G_MISS_CHAR;
734: END IF;
735:
736: IF p_x_Header_Payment_rec.attribute10 IS NULL THEN
737: p_x_Header_Payment_rec.attribute10 := FND_API.G_MISS_CHAR;
738: END IF;
739:
740: IF p_x_Header_Payment_rec.attribute11 IS NULL THEN
741: p_x_Header_Payment_rec.attribute11 := FND_API.G_MISS_CHAR;
737: p_x_Header_Payment_rec.attribute10 := FND_API.G_MISS_CHAR;
738: END IF;
739:
740: IF p_x_Header_Payment_rec.attribute11 IS NULL THEN
741: p_x_Header_Payment_rec.attribute11 := FND_API.G_MISS_CHAR;
742: END IF;
743:
744: IF p_x_Header_Payment_rec.attribute12 IS NULL THEN
745: p_x_Header_Payment_rec.attribute12 := FND_API.G_MISS_CHAR;
741: p_x_Header_Payment_rec.attribute11 := FND_API.G_MISS_CHAR;
742: END IF;
743:
744: IF p_x_Header_Payment_rec.attribute12 IS NULL THEN
745: p_x_Header_Payment_rec.attribute12 := FND_API.G_MISS_CHAR;
746: END IF;
747:
748: IF p_x_Header_Payment_rec.attribute13 IS NULL THEN
749: p_x_Header_Payment_rec.attribute13 := FND_API.G_MISS_CHAR;
745: p_x_Header_Payment_rec.attribute12 := FND_API.G_MISS_CHAR;
746: END IF;
747:
748: IF p_x_Header_Payment_rec.attribute13 IS NULL THEN
749: p_x_Header_Payment_rec.attribute13 := FND_API.G_MISS_CHAR;
750: END IF;
751:
752: IF p_x_Header_Payment_rec.attribute14 IS NULL THEN
753: p_x_Header_Payment_rec.attribute14 := FND_API.G_MISS_CHAR;
749: p_x_Header_Payment_rec.attribute13 := FND_API.G_MISS_CHAR;
750: END IF;
751:
752: IF p_x_Header_Payment_rec.attribute14 IS NULL THEN
753: p_x_Header_Payment_rec.attribute14 := FND_API.G_MISS_CHAR;
754: END IF;
755:
756: IF p_x_Header_Payment_rec.attribute15 IS NULL THEN
757: p_x_Header_Payment_rec.attribute15 := FND_API.G_MISS_CHAR;
753: p_x_Header_Payment_rec.attribute14 := FND_API.G_MISS_CHAR;
754: END IF;
755:
756: IF p_x_Header_Payment_rec.attribute15 IS NULL THEN
757: p_x_Header_Payment_rec.attribute15 := FND_API.G_MISS_CHAR;
758: END IF;
759:
760: IF p_x_Header_Payment_rec.context IS NULL THEN
761: p_x_Header_Payment_rec.context := FND_API.G_MISS_CHAR;
757: p_x_Header_Payment_rec.attribute15 := FND_API.G_MISS_CHAR;
758: END IF;
759:
760: IF p_x_Header_Payment_rec.context IS NULL THEN
761: p_x_Header_Payment_rec.context := FND_API.G_MISS_CHAR;
762: END IF;
763:
764: IF p_x_Header_Payment_rec.created_by IS NULL THEN
765: p_x_Header_Payment_rec.created_by := FND_API.G_MISS_NUM;
761: p_x_Header_Payment_rec.context := FND_API.G_MISS_CHAR;
762: END IF;
763:
764: IF p_x_Header_Payment_rec.created_by IS NULL THEN
765: p_x_Header_Payment_rec.created_by := FND_API.G_MISS_NUM;
766: END IF;
767:
768: IF p_x_Header_Payment_rec.creation_date IS NULL THEN
769: p_x_Header_Payment_rec.creation_date := FND_API.G_MISS_DATE;
765: p_x_Header_Payment_rec.created_by := FND_API.G_MISS_NUM;
766: END IF;
767:
768: IF p_x_Header_Payment_rec.creation_date IS NULL THEN
769: p_x_Header_Payment_rec.creation_date := FND_API.G_MISS_DATE;
770: END IF;
771:
772: IF p_x_Header_Payment_rec.last_updated_by IS NULL THEN
773: p_x_Header_Payment_rec.last_updated_by := FND_API.G_MISS_NUM;
769: p_x_Header_Payment_rec.creation_date := FND_API.G_MISS_DATE;
770: END IF;
771:
772: IF p_x_Header_Payment_rec.last_updated_by IS NULL THEN
773: p_x_Header_Payment_rec.last_updated_by := FND_API.G_MISS_NUM;
774: END IF;
775:
776: IF p_x_Header_Payment_rec.last_update_date IS NULL THEN
777: p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;
773: p_x_Header_Payment_rec.last_updated_by := FND_API.G_MISS_NUM;
774: END IF;
775:
776: IF p_x_Header_Payment_rec.last_update_date IS NULL THEN
777: p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;
778: END IF;
779:
780: IF p_x_Header_Payment_rec.last_update_login IS NULL THEN
781: p_x_Header_Payment_rec.last_update_login := FND_API.G_MISS_NUM;
777: p_x_Header_Payment_rec.last_update_date := FND_API.G_MISS_DATE;
778: END IF;
779:
780: IF p_x_Header_Payment_rec.last_update_login IS NULL THEN
781: p_x_Header_Payment_rec.last_update_login := FND_API.G_MISS_NUM;
782: END IF;
783:
784: IF p_x_Header_Payment_rec.check_number IS NULL THEN
785: p_x_Header_Payment_rec.check_number := FND_API.G_MISS_CHAR;
781: p_x_Header_Payment_rec.last_update_login := FND_API.G_MISS_NUM;
782: END IF;
783:
784: IF p_x_Header_Payment_rec.check_number IS NULL THEN
785: p_x_Header_Payment_rec.check_number := FND_API.G_MISS_CHAR;
786: END IF;
787:
788: IF p_x_Header_Payment_rec.credit_card_approval_code IS NULL THEN
789: p_x_Header_Payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
785: p_x_Header_Payment_rec.check_number := FND_API.G_MISS_CHAR;
786: END IF;
787:
788: IF p_x_Header_Payment_rec.credit_card_approval_code IS NULL THEN
789: p_x_Header_Payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
790: END IF;
791:
792: IF p_x_Header_Payment_rec.credit_card_approval_date IS NULL THEN
793: p_x_Header_Payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
789: p_x_Header_Payment_rec.credit_card_approval_code := FND_API.G_MISS_CHAR;
790: END IF;
791:
792: IF p_x_Header_Payment_rec.credit_card_approval_date IS NULL THEN
793: p_x_Header_Payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
794: END IF;
795:
796: IF p_x_Header_Payment_rec.credit_card_code IS NULL THEN
797: p_x_Header_Payment_rec.credit_card_code := FND_API.G_MISS_CHAR;
793: p_x_Header_Payment_rec.credit_card_approval_date := FND_API.G_MISS_DATE;
794: END IF;
795:
796: IF p_x_Header_Payment_rec.credit_card_code IS NULL THEN
797: p_x_Header_Payment_rec.credit_card_code := FND_API.G_MISS_CHAR;
798: END IF;
799:
800: IF p_x_Header_Payment_rec.credit_card_expiration_date IS NULL THEN
801: p_x_Header_Payment_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
797: p_x_Header_Payment_rec.credit_card_code := FND_API.G_MISS_CHAR;
798: END IF;
799:
800: IF p_x_Header_Payment_rec.credit_card_expiration_date IS NULL THEN
801: p_x_Header_Payment_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
802: END IF;
803:
804: IF p_x_Header_Payment_rec.credit_card_holder_name IS NULL THEN
805: p_x_Header_Payment_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
801: p_x_Header_Payment_rec.credit_card_expiration_date := FND_API.G_MISS_DATE;
802: END IF;
803:
804: IF p_x_Header_Payment_rec.credit_card_holder_name IS NULL THEN
805: p_x_Header_Payment_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
806: END IF;
807:
808: IF p_x_Header_Payment_rec.credit_card_number IS NULL THEN
809: p_x_Header_Payment_rec.credit_card_number := FND_API.G_MISS_CHAR;
805: p_x_Header_Payment_rec.credit_card_holder_name := FND_API.G_MISS_CHAR;
806: END IF;
807:
808: IF p_x_Header_Payment_rec.credit_card_number IS NULL THEN
809: p_x_Header_Payment_rec.credit_card_number := FND_API.G_MISS_CHAR;
810: END IF;
811:
812: IF p_x_Header_Payment_rec.payment_level_code IS NULL THEN
813: p_x_Header_Payment_rec.payment_level_code := FND_API.G_MISS_CHAR;
809: p_x_Header_Payment_rec.credit_card_number := FND_API.G_MISS_CHAR;
810: END IF;
811:
812: IF p_x_Header_Payment_rec.payment_level_code IS NULL THEN
813: p_x_Header_Payment_rec.payment_level_code := FND_API.G_MISS_CHAR;
814: END IF;
815:
816: IF p_x_Header_Payment_rec.commitment_applied_amount IS NULL THEN
817: p_x_Header_Payment_rec.commitment_applied_amount := FND_API.G_MISS_NUM;
813: p_x_Header_Payment_rec.payment_level_code := FND_API.G_MISS_CHAR;
814: END IF;
815:
816: IF p_x_Header_Payment_rec.commitment_applied_amount IS NULL THEN
817: p_x_Header_Payment_rec.commitment_applied_amount := FND_API.G_MISS_NUM;
818: END IF;
819:
820: IF p_x_Header_Payment_rec.commitment_interfaced_amount IS NULL THEN
821: p_x_Header_Payment_rec.commitment_interfaced_amount := FND_API.G_MISS_NUM;
817: p_x_Header_Payment_rec.commitment_applied_amount := FND_API.G_MISS_NUM;
818: END IF;
819:
820: IF p_x_Header_Payment_rec.commitment_interfaced_amount IS NULL THEN
821: p_x_Header_Payment_rec.commitment_interfaced_amount := FND_API.G_MISS_NUM;
822: END IF;
823:
824: IF p_x_Header_Payment_rec.payment_number IS NULL THEN
825: p_x_Header_Payment_rec.payment_number := FND_API.G_MISS_NUM;
821: p_x_Header_Payment_rec.commitment_interfaced_amount := FND_API.G_MISS_NUM;
822: END IF;
823:
824: IF p_x_Header_Payment_rec.payment_number IS NULL THEN
825: p_x_Header_Payment_rec.payment_number := FND_API.G_MISS_NUM;
826: END IF;
827:
828: IF p_x_Header_Payment_rec.header_id IS NULL THEN
829: p_x_Header_Payment_rec.header_id := FND_API.G_MISS_NUM;
825: p_x_Header_Payment_rec.payment_number := FND_API.G_MISS_NUM;
826: END IF;
827:
828: IF p_x_Header_Payment_rec.header_id IS NULL THEN
829: p_x_Header_Payment_rec.header_id := FND_API.G_MISS_NUM;
830: END IF;
831:
832: IF p_x_Header_Payment_rec.line_id IS NULL THEN
833: p_x_Header_Payment_rec.line_id := FND_API.G_MISS_NUM;
829: p_x_Header_Payment_rec.header_id := FND_API.G_MISS_NUM;
830: END IF;
831:
832: IF p_x_Header_Payment_rec.line_id IS NULL THEN
833: p_x_Header_Payment_rec.line_id := FND_API.G_MISS_NUM;
834: END IF;
835:
836: IF p_x_Header_Payment_rec.payment_amount IS NULL THEN
837: p_x_Header_Payment_rec.payment_amount := FND_API.G_MISS_NUM;
833: p_x_Header_Payment_rec.line_id := FND_API.G_MISS_NUM;
834: END IF;
835:
836: IF p_x_Header_Payment_rec.payment_amount IS NULL THEN
837: p_x_Header_Payment_rec.payment_amount := FND_API.G_MISS_NUM;
838: END IF;
839:
840: IF p_x_Header_Payment_rec.payment_collection_event IS NULL THEN
841: p_x_Header_Payment_rec.payment_collection_event := FND_API.G_MISS_CHAR;
837: p_x_Header_Payment_rec.payment_amount := FND_API.G_MISS_NUM;
838: END IF;
839:
840: IF p_x_Header_Payment_rec.payment_collection_event IS NULL THEN
841: p_x_Header_Payment_rec.payment_collection_event := FND_API.G_MISS_CHAR;
842: END IF;
843:
844: IF p_x_Header_Payment_rec.defer_payment_processing_flag IS NULL THEN
845: p_x_Header_Payment_rec.defer_payment_processing_flag := FND_API.G_MISS_CHAR;
841: p_x_Header_Payment_rec.payment_collection_event := FND_API.G_MISS_CHAR;
842: END IF;
843:
844: IF p_x_Header_Payment_rec.defer_payment_processing_flag IS NULL THEN
845: p_x_Header_Payment_rec.defer_payment_processing_flag := FND_API.G_MISS_CHAR;
846: END IF;
847:
848: IF p_x_Header_Payment_rec.payment_trx_id IS NULL THEN
849: p_x_Header_Payment_rec.payment_trx_id := FND_API.G_MISS_NUM;
845: p_x_Header_Payment_rec.defer_payment_processing_flag := FND_API.G_MISS_CHAR;
846: END IF;
847:
848: IF p_x_Header_Payment_rec.payment_trx_id IS NULL THEN
849: p_x_Header_Payment_rec.payment_trx_id := FND_API.G_MISS_NUM;
850: END IF;
851:
852: IF p_x_Header_Payment_rec.payment_type_code IS NULL THEN
853: p_x_Header_Payment_rec.payment_type_code := FND_API.G_MISS_CHAR;
849: p_x_Header_Payment_rec.payment_trx_id := FND_API.G_MISS_NUM;
850: END IF;
851:
852: IF p_x_Header_Payment_rec.payment_type_code IS NULL THEN
853: p_x_Header_Payment_rec.payment_type_code := FND_API.G_MISS_CHAR;
854: END IF;
855:
856: IF p_x_Header_Payment_rec.payment_set_id IS NULL THEN
857: p_x_Header_Payment_rec.payment_set_id := FND_API.G_MISS_NUM;
853: p_x_Header_Payment_rec.payment_type_code := FND_API.G_MISS_CHAR;
854: END IF;
855:
856: IF p_x_Header_Payment_rec.payment_set_id IS NULL THEN
857: p_x_Header_Payment_rec.payment_set_id := FND_API.G_MISS_NUM;
858: END IF;
859:
860: IF p_x_Header_Payment_rec.prepaid_amount IS NULL THEN
861: p_x_Header_Payment_rec.prepaid_amount := FND_API.G_MISS_NUM;
857: p_x_Header_Payment_rec.payment_set_id := FND_API.G_MISS_NUM;
858: END IF;
859:
860: IF p_x_Header_Payment_rec.prepaid_amount IS NULL THEN
861: p_x_Header_Payment_rec.prepaid_amount := FND_API.G_MISS_NUM;
862: END IF;
863:
864: IF p_x_Header_Payment_rec.program_application_id IS NULL THEN
865: p_x_Header_Payment_rec.program_application_id := FND_API.G_MISS_NUM;
861: p_x_Header_Payment_rec.prepaid_amount := FND_API.G_MISS_NUM;
862: END IF;
863:
864: IF p_x_Header_Payment_rec.program_application_id IS NULL THEN
865: p_x_Header_Payment_rec.program_application_id := FND_API.G_MISS_NUM;
866: END IF;
867:
868: IF p_x_Header_Payment_rec.program_id IS NULL THEN
869: p_x_Header_Payment_rec.program_id := FND_API.G_MISS_NUM;
865: p_x_Header_Payment_rec.program_application_id := FND_API.G_MISS_NUM;
866: END IF;
867:
868: IF p_x_Header_Payment_rec.program_id IS NULL THEN
869: p_x_Header_Payment_rec.program_id := FND_API.G_MISS_NUM;
870: END IF;
871:
872: IF p_x_Header_Payment_rec.program_update_date IS NULL THEN
873: p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;
869: p_x_Header_Payment_rec.program_id := FND_API.G_MISS_NUM;
870: END IF;
871:
872: IF p_x_Header_Payment_rec.program_update_date IS NULL THEN
873: p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;
874: END IF;
875:
876: IF p_x_Header_Payment_rec.receipt_method_id IS NULL THEN
877: p_x_Header_Payment_rec.receipt_method_id := FND_API.G_MISS_NUM;
873: p_x_Header_Payment_rec.program_update_date := FND_API.G_MISS_DATE;
874: END IF;
875:
876: IF p_x_Header_Payment_rec.receipt_method_id IS NULL THEN
877: p_x_Header_Payment_rec.receipt_method_id := FND_API.G_MISS_NUM;
878: END IF;
879:
880: IF p_x_Header_Payment_rec.request_id IS NULL THEN
881: p_x_Header_Payment_rec.request_id := FND_API.G_MISS_NUM;
877: p_x_Header_Payment_rec.receipt_method_id := FND_API.G_MISS_NUM;
878: END IF;
879:
880: IF p_x_Header_Payment_rec.request_id IS NULL THEN
881: p_x_Header_Payment_rec.request_id := FND_API.G_MISS_NUM;
882: END IF;
883:
884: IF p_x_Header_Payment_rec.tangible_id IS NULL THEN
885: p_x_Header_Payment_rec.tangible_id := FND_API.G_MISS_CHAR;
881: p_x_Header_Payment_rec.request_id := FND_API.G_MISS_NUM;
882: END IF;
883:
884: IF p_x_Header_Payment_rec.tangible_id IS NULL THEN
885: p_x_Header_Payment_rec.tangible_id := FND_API.G_MISS_CHAR;
886: END IF;
887:
888: oe_debug_pub.add('Exiting OE_GENESIS_UTIL.Convert_hdr_pymnt_null_to_miss', 1);
889:
908: oe_debug_pub.add('Entering OE_GENESIS_UTIL.Convert_Line_null_to_miss', 1);
909: end if;
910:
911: IF p_x_line_rec.unit_cost IS NULL THEN
912: p_x_line_rec.unit_cost := FND_API.G_MISS_NUM;
913: END IF;
914:
915:
916: IF p_x_line_rec.accounting_rule_id IS NULL THEN
913: END IF;
914:
915:
916: IF p_x_line_rec.accounting_rule_id IS NULL THEN
917: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
918: END IF;
919:
920: IF p_x_line_rec.accounting_rule_duration IS NULL THEN
921: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
917: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
918: END IF;
919:
920: IF p_x_line_rec.accounting_rule_duration IS NULL THEN
921: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
922: END IF;
923:
924: IF p_x_line_rec.actual_arrival_date IS NULL THEN
925: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
921: p_x_line_rec.accounting_rule_duration := FND_API.G_MISS_NUM;
922: END IF;
923:
924: IF p_x_line_rec.actual_arrival_date IS NULL THEN
925: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
926: END IF;
927:
928: IF p_x_line_rec.actual_shipment_date IS NULL THEN
929: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
925: p_x_line_rec.actual_arrival_date := FND_API.G_MISS_DATE;
926: END IF;
927:
928: IF p_x_line_rec.actual_shipment_date IS NULL THEN
929: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
930: END IF;
931:
932: IF p_x_line_rec.agreement_id IS NULL THEN
933: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
929: p_x_line_rec.actual_shipment_date := FND_API.G_MISS_DATE;
930: END IF;
931:
932: IF p_x_line_rec.agreement_id IS NULL THEN
933: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
934: END IF;
935: IF p_x_line_rec.arrival_set_id IS NULL THEN
936: p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
937: END IF;
932: IF p_x_line_rec.agreement_id IS NULL THEN
933: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
934: END IF;
935: IF p_x_line_rec.arrival_set_id IS NULL THEN
936: p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
937: END IF;
938:
939: IF p_x_line_rec.ato_line_id IS NULL THEN
940: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
936: p_x_line_rec.arrival_set_id := FND_API.G_MISS_NUM;
937: END IF;
938:
939: IF p_x_line_rec.ato_line_id IS NULL THEN
940: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
941: END IF;
942: IF p_x_line_rec.upgraded_flag IS NULL THEN
943: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
944: END IF;
939: IF p_x_line_rec.ato_line_id IS NULL THEN
940: p_x_line_rec.ato_line_id := FND_API.G_MISS_NUM;
941: END IF;
942: IF p_x_line_rec.upgraded_flag IS NULL THEN
943: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
944: END IF;
945:
946: IF p_x_line_rec.attribute1 IS NULL THEN
947: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
943: p_x_line_rec.upgraded_flag := FND_API.G_MISS_CHAR;
944: END IF;
945:
946: IF p_x_line_rec.attribute1 IS NULL THEN
947: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
948: END IF;
949:
950: IF p_x_line_rec.attribute10 IS NULL THEN
951: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
947: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
948: END IF;
949:
950: IF p_x_line_rec.attribute10 IS NULL THEN
951: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
952: END IF;
953:
954: IF p_x_line_rec.attribute11 IS NULL THEN
955: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
951: p_x_line_rec.attribute10 := FND_API.G_MISS_CHAR;
952: END IF;
953:
954: IF p_x_line_rec.attribute11 IS NULL THEN
955: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
956: END IF;
957:
958: IF p_x_line_rec.attribute12 IS NULL THEN
959: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
955: p_x_line_rec.attribute11 := FND_API.G_MISS_CHAR;
956: END IF;
957:
958: IF p_x_line_rec.attribute12 IS NULL THEN
959: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
960: END IF;
961:
962: IF p_x_line_rec.attribute13 IS NULL THEN
963: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
959: p_x_line_rec.attribute12 := FND_API.G_MISS_CHAR;
960: END IF;
961:
962: IF p_x_line_rec.attribute13 IS NULL THEN
963: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
964: END IF;
965:
966: IF p_x_line_rec.attribute14 IS NULL THEN
967: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
963: p_x_line_rec.attribute13 := FND_API.G_MISS_CHAR;
964: END IF;
965:
966: IF p_x_line_rec.attribute14 IS NULL THEN
967: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
968: END IF;
969:
970: IF p_x_line_rec.attribute15 IS NULL THEN
971: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
967: p_x_line_rec.attribute14 := FND_API.G_MISS_CHAR;
968: END IF;
969:
970: IF p_x_line_rec.attribute15 IS NULL THEN
971: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
972: END IF;
973:
974: IF p_x_line_rec.attribute16 IS NULL THEN --For bug 2184255
975: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
971: p_x_line_rec.attribute15 := FND_API.G_MISS_CHAR;
972: END IF;
973:
974: IF p_x_line_rec.attribute16 IS NULL THEN --For bug 2184255
975: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
976: END IF;
977:
978: IF p_x_line_rec.attribute17 IS NULL THEN
979: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
975: p_x_line_rec.attribute16 := FND_API.G_MISS_CHAR;
976: END IF;
977:
978: IF p_x_line_rec.attribute17 IS NULL THEN
979: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
980: END IF;
981:
982: IF p_x_line_rec.attribute18 IS NULL THEN
983: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
979: p_x_line_rec.attribute17 := FND_API.G_MISS_CHAR;
980: END IF;
981:
982: IF p_x_line_rec.attribute18 IS NULL THEN
983: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
984: END IF;
985:
986: IF p_x_line_rec.attribute19 IS NULL THEN
987: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
983: p_x_line_rec.attribute18 := FND_API.G_MISS_CHAR;
984: END IF;
985:
986: IF p_x_line_rec.attribute19 IS NULL THEN
987: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
988: END IF;
989:
990: IF p_x_line_rec.attribute2 IS NULL THEN
991: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
987: p_x_line_rec.attribute19 := FND_API.G_MISS_CHAR;
988: END IF;
989:
990: IF p_x_line_rec.attribute2 IS NULL THEN
991: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
992: END IF;
993:
994: IF p_x_line_rec.attribute20 IS NULL THEN
995: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
991: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
992: END IF;
993:
994: IF p_x_line_rec.attribute20 IS NULL THEN
995: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
996: END IF;
997:
998: IF p_x_line_rec.attribute3 IS NULL THEN
999: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
995: p_x_line_rec.attribute20 := FND_API.G_MISS_CHAR;
996: END IF;
997:
998: IF p_x_line_rec.attribute3 IS NULL THEN
999: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
1000: END IF;
1001:
1002: IF p_x_line_rec.attribute4 IS NULL THEN
1003: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
999: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
1000: END IF;
1001:
1002: IF p_x_line_rec.attribute4 IS NULL THEN
1003: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
1004: END IF;
1005:
1006: IF p_x_line_rec.attribute5 IS NULL THEN
1007: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
1003: p_x_line_rec.attribute4 := FND_API.G_MISS_CHAR;
1004: END IF;
1005:
1006: IF p_x_line_rec.attribute5 IS NULL THEN
1007: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
1008: END IF;
1009:
1010: IF p_x_line_rec.attribute6 IS NULL THEN
1011: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
1007: p_x_line_rec.attribute5 := FND_API.G_MISS_CHAR;
1008: END IF;
1009:
1010: IF p_x_line_rec.attribute6 IS NULL THEN
1011: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
1012: END IF;
1013:
1014: IF p_x_line_rec.attribute7 IS NULL THEN
1015: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
1011: p_x_line_rec.attribute6 := FND_API.G_MISS_CHAR;
1012: END IF;
1013:
1014: IF p_x_line_rec.attribute7 IS NULL THEN
1015: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
1016: END IF;
1017:
1018: IF p_x_line_rec.attribute8 IS NULL THEN
1019: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
1015: p_x_line_rec.attribute7 := FND_API.G_MISS_CHAR;
1016: END IF;
1017:
1018: IF p_x_line_rec.attribute8 IS NULL THEN
1019: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
1020: END IF;
1021:
1022: IF p_x_line_rec.attribute9 IS NULL THEN
1023: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
1019: p_x_line_rec.attribute8 := FND_API.G_MISS_CHAR;
1020: END IF;
1021:
1022: IF p_x_line_rec.attribute9 IS NULL THEN
1023: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
1024: END IF;
1025:
1026: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
1027: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
1023: p_x_line_rec.attribute9 := FND_API.G_MISS_CHAR;
1024: END IF;
1025:
1026: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
1027: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
1028: END IF;
1029: IF p_x_line_rec.authorized_to_ship_flag IS NULL THEN
1030: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
1031: END IF;
1026: IF p_x_line_rec.auto_selected_quantity IS NULL THEN
1027: p_x_line_rec.auto_selected_quantity := FND_API.G_MISS_NUM;
1028: END IF;
1029: IF p_x_line_rec.authorized_to_ship_flag IS NULL THEN
1030: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
1031: END IF;
1032:
1033: IF p_x_line_rec.booked_flag IS NULL THEN
1034: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
1030: p_x_line_rec.authorized_to_ship_flag := FND_API.G_MISS_CHAR;
1031: END IF;
1032:
1033: IF p_x_line_rec.booked_flag IS NULL THEN
1034: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
1035: END IF;
1036:
1037: IF p_x_line_rec.cancelled_flag IS NULL THEN
1038: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
1034: p_x_line_rec.booked_flag := FND_API.G_MISS_CHAR;
1035: END IF;
1036:
1037: IF p_x_line_rec.cancelled_flag IS NULL THEN
1038: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
1039: END IF;
1040:
1041: IF p_x_line_rec.cancelled_quantity IS NULL THEN
1042: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1038: p_x_line_rec.cancelled_flag := FND_API.G_MISS_CHAR;
1039: END IF;
1040:
1041: IF p_x_line_rec.cancelled_quantity IS NULL THEN
1042: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1043: END IF;
1044:
1045: IF p_x_line_rec.component_code IS NULL THEN
1046: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
1042: p_x_line_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1043: END IF;
1044:
1045: IF p_x_line_rec.component_code IS NULL THEN
1046: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
1047: END IF;
1048:
1049: IF p_x_line_rec.component_number IS NULL THEN
1050: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
1046: p_x_line_rec.component_code := FND_API.G_MISS_CHAR;
1047: END IF;
1048:
1049: IF p_x_line_rec.component_number IS NULL THEN
1050: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
1051: END IF;
1052:
1053: IF p_x_line_rec.component_sequence_id IS NULL THEN
1054: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
1050: p_x_line_rec.component_number := FND_API.G_MISS_NUM;
1051: END IF;
1052:
1053: IF p_x_line_rec.component_sequence_id IS NULL THEN
1054: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
1055: END IF;
1056:
1057: IF p_x_line_rec.config_header_id IS NULL THEN
1058: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
1054: p_x_line_rec.component_sequence_id := FND_API.G_MISS_NUM;
1055: END IF;
1056:
1057: IF p_x_line_rec.config_header_id IS NULL THEN
1058: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
1059: END IF;
1060:
1061: IF p_x_line_rec.config_rev_nbr IS NULL THEN
1062: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
1058: p_x_line_rec.config_header_id := FND_API.G_MISS_NUM;
1059: END IF;
1060:
1061: IF p_x_line_rec.config_rev_nbr IS NULL THEN
1062: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
1063: END IF;
1064:
1065: IF p_x_line_rec.config_display_sequence IS NULL THEN
1066: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
1062: p_x_line_rec.config_rev_nbr := FND_API.G_MISS_NUM;
1063: END IF;
1064:
1065: IF p_x_line_rec.config_display_sequence IS NULL THEN
1066: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
1067: END IF;
1068:
1069: IF p_x_line_rec.configuration_id IS NULL THEN
1070: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
1066: p_x_line_rec.config_display_sequence := FND_API.G_MISS_NUM;
1067: END IF;
1068:
1069: IF p_x_line_rec.configuration_id IS NULL THEN
1070: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
1071: END IF;
1072:
1073: IF p_x_line_rec.context IS NULL THEN
1074: p_x_line_rec.context := FND_API.G_MISS_CHAR;
1070: p_x_line_rec.configuration_id := FND_API.G_MISS_NUM;
1071: END IF;
1072:
1073: IF p_x_line_rec.context IS NULL THEN
1074: p_x_line_rec.context := FND_API.G_MISS_CHAR;
1075: END IF;
1076:
1077:
1078:
1078:
1079:
1080:
1081: IF p_x_line_rec.created_by IS NULL THEN
1082: p_x_line_rec.created_by := FND_API.G_MISS_NUM;
1083: END IF;
1084:
1085: IF p_x_line_rec.creation_date IS NULL THEN
1086: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
1082: p_x_line_rec.created_by := FND_API.G_MISS_NUM;
1083: END IF;
1084:
1085: IF p_x_line_rec.creation_date IS NULL THEN
1086: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
1087: END IF;
1088:
1089: IF p_x_line_rec.credit_invoice_line_id IS NULL THEN
1090: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
1086: p_x_line_rec.creation_date := FND_API.G_MISS_DATE;
1087: END IF;
1088:
1089: IF p_x_line_rec.credit_invoice_line_id IS NULL THEN
1090: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
1091: END IF;
1092:
1093: IF p_x_line_rec.customer_dock_code IS NULL THEN
1094: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
1090: p_x_line_rec.credit_invoice_line_id := FND_API.G_MISS_NUM;
1091: END IF;
1092:
1093: IF p_x_line_rec.customer_dock_code IS NULL THEN
1094: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
1095: END IF;
1096:
1097: IF p_x_line_rec.customer_job IS NULL THEN
1098: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
1094: p_x_line_rec.customer_dock_code := FND_API.G_MISS_CHAR;
1095: END IF;
1096:
1097: IF p_x_line_rec.customer_job IS NULL THEN
1098: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
1099: END IF;
1100:
1101: IF p_x_line_rec.customer_production_line IS NULL THEN
1102: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
1098: p_x_line_rec.customer_job := FND_API.G_MISS_CHAR;
1099: END IF;
1100:
1101: IF p_x_line_rec.customer_production_line IS NULL THEN
1102: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
1103: END IF;
1104:
1105: IF p_x_line_rec.cust_production_seq_num IS NULL THEN
1106: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
1102: p_x_line_rec.customer_production_line := FND_API.G_MISS_CHAR;
1103: END IF;
1104:
1105: IF p_x_line_rec.cust_production_seq_num IS NULL THEN
1106: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
1107: END IF;
1108:
1109: IF p_x_line_rec.customer_trx_line_id IS NULL THEN
1110: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
1106: p_x_line_rec.cust_production_seq_num := FND_API.G_MISS_CHAR;
1107: END IF;
1108:
1109: IF p_x_line_rec.customer_trx_line_id IS NULL THEN
1110: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
1111: END IF;
1112:
1113: IF p_x_line_rec.cust_model_serial_number IS NULL THEN
1114: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
1110: p_x_line_rec.customer_trx_line_id := FND_API.G_MISS_NUM;
1111: END IF;
1112:
1113: IF p_x_line_rec.cust_model_serial_number IS NULL THEN
1114: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
1115: END IF;
1116:
1117: IF p_x_line_rec.cust_po_number IS NULL THEN
1118: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
1114: p_x_line_rec.cust_model_serial_number := FND_API.G_MISS_CHAR;
1115: END IF;
1116:
1117: IF p_x_line_rec.cust_po_number IS NULL THEN
1118: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
1119: END IF;
1120:
1121: IF p_x_line_rec.customer_line_number IS NULL THEN
1122: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
1118: p_x_line_rec.cust_po_number := FND_API.G_MISS_CHAR;
1119: END IF;
1120:
1121: IF p_x_line_rec.customer_line_number IS NULL THEN
1122: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
1123: END IF;
1124:
1125: IF p_x_line_rec.customer_shipment_number IS NULL THEN
1126: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
1122: p_x_line_rec.customer_line_number := FND_API.G_MISS_CHAR;
1123: END IF;
1124:
1125: IF p_x_line_rec.customer_shipment_number IS NULL THEN
1126: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
1127: END IF;
1128:
1129: IF p_x_line_rec.delivery_lead_time IS NULL THEN
1130: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
1126: p_x_line_rec.customer_shipment_number := FND_API.G_MISS_CHAR;
1127: END IF;
1128:
1129: IF p_x_line_rec.delivery_lead_time IS NULL THEN
1130: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
1131: END IF;
1132:
1133: IF p_x_line_rec.deliver_to_contact_id IS NULL THEN
1134: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
1130: p_x_line_rec.delivery_lead_time := FND_API.G_MISS_NUM;
1131: END IF;
1132:
1133: IF p_x_line_rec.deliver_to_contact_id IS NULL THEN
1134: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
1135: END IF;
1136:
1137: IF p_x_line_rec.deliver_to_org_id IS NULL THEN
1138: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
1134: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
1135: END IF;
1136:
1137: IF p_x_line_rec.deliver_to_org_id IS NULL THEN
1138: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
1139: END IF;
1140:
1141: IF p_x_line_rec.demand_bucket_type_code IS NULL THEN
1142: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
1138: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
1139: END IF;
1140:
1141: IF p_x_line_rec.demand_bucket_type_code IS NULL THEN
1142: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
1143: END IF;
1144:
1145: IF p_x_line_rec.demand_class_code IS NULL THEN
1146: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
1142: p_x_line_rec.demand_bucket_type_code := FND_API.G_MISS_CHAR;
1143: END IF;
1144:
1145: IF p_x_line_rec.demand_class_code IS NULL THEN
1146: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
1147: END IF;
1148:
1149: IF p_x_line_rec.dep_plan_required_flag IS NULL THEN
1150: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
1146: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
1147: END IF;
1148:
1149: IF p_x_line_rec.dep_plan_required_flag IS NULL THEN
1150: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
1151: END IF;
1152:
1153:
1154: IF p_x_line_rec.earliest_acceptable_date IS NULL THEN
1151: END IF;
1152:
1153:
1154: IF p_x_line_rec.earliest_acceptable_date IS NULL THEN
1155: p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
1156: END IF;
1157:
1158: IF p_x_line_rec.explosion_date IS NULL THEN
1159: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
1155: p_x_line_rec.earliest_acceptable_date := FND_API.G_MISS_DATE;
1156: END IF;
1157:
1158: IF p_x_line_rec.explosion_date IS NULL THEN
1159: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
1160: END IF;
1161:
1162: IF p_x_line_rec.fob_point_code IS NULL THEN
1163: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
1159: p_x_line_rec.explosion_date := FND_API.G_MISS_DATE;
1160: END IF;
1161:
1162: IF p_x_line_rec.fob_point_code IS NULL THEN
1163: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
1164: END IF;
1165:
1166: IF p_x_line_rec.freight_carrier_code IS NULL THEN
1167: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
1163: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
1164: END IF;
1165:
1166: IF p_x_line_rec.freight_carrier_code IS NULL THEN
1167: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
1168: END IF;
1169:
1170: IF p_x_line_rec.freight_terms_code IS NULL THEN
1171: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
1167: p_x_line_rec.freight_carrier_code := FND_API.G_MISS_CHAR;
1168: END IF;
1169:
1170: IF p_x_line_rec.freight_terms_code IS NULL THEN
1171: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
1172: END IF;
1173:
1174: IF p_x_line_rec.fulfilled_quantity IS NULL THEN
1175: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
1171: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
1172: END IF;
1173:
1174: IF p_x_line_rec.fulfilled_quantity IS NULL THEN
1175: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
1176: END IF;
1177:
1178: IF p_x_line_rec.fulfilled_flag IS NULL THEN
1179: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
1175: p_x_line_rec.fulfilled_quantity := FND_API.G_MISS_NUM;
1176: END IF;
1177:
1178: IF p_x_line_rec.fulfilled_flag IS NULL THEN
1179: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
1180: END IF;
1181:
1182: IF p_x_line_rec.fulfillment_method_code IS NULL THEN
1183: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
1179: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
1180: END IF;
1181:
1182: IF p_x_line_rec.fulfillment_method_code IS NULL THEN
1183: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
1184: END IF;
1185:
1186: IF p_x_line_rec.fulfillment_date IS NULL THEN
1187: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
1183: p_x_line_rec.fulfillment_method_code := FND_API.G_MISS_CHAR;
1184: END IF;
1185:
1186: IF p_x_line_rec.fulfillment_date IS NULL THEN
1187: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
1188: END IF;
1189:
1190: IF p_x_line_rec.global_attribute1 IS NULL THEN
1191: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
1187: p_x_line_rec.fulfillment_date := FND_API.G_MISS_DATE;
1188: END IF;
1189:
1190: IF p_x_line_rec.global_attribute1 IS NULL THEN
1191: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
1192: END IF;
1193:
1194: IF p_x_line_rec.global_attribute10 IS NULL THEN
1195: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
1191: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
1192: END IF;
1193:
1194: IF p_x_line_rec.global_attribute10 IS NULL THEN
1195: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
1196: END IF;
1197:
1198: IF p_x_line_rec.global_attribute11 IS NULL THEN
1199: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
1195: p_x_line_rec.global_attribute10 := FND_API.G_MISS_CHAR;
1196: END IF;
1197:
1198: IF p_x_line_rec.global_attribute11 IS NULL THEN
1199: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
1200: END IF;
1201:
1202: IF p_x_line_rec.global_attribute12 IS NULL THEN
1203: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
1199: p_x_line_rec.global_attribute11 := FND_API.G_MISS_CHAR;
1200: END IF;
1201:
1202: IF p_x_line_rec.global_attribute12 IS NULL THEN
1203: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
1204: END IF;
1205:
1206: IF p_x_line_rec.global_attribute13 IS NULL THEN
1207: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
1203: p_x_line_rec.global_attribute12 := FND_API.G_MISS_CHAR;
1204: END IF;
1205:
1206: IF p_x_line_rec.global_attribute13 IS NULL THEN
1207: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
1208: END IF;
1209:
1210: IF p_x_line_rec.global_attribute14 IS NULL THEN
1211: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
1207: p_x_line_rec.global_attribute13 := FND_API.G_MISS_CHAR;
1208: END IF;
1209:
1210: IF p_x_line_rec.global_attribute14 IS NULL THEN
1211: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
1212: END IF;
1213:
1214: IF p_x_line_rec.global_attribute15 IS NULL THEN
1215: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
1211: p_x_line_rec.global_attribute14 := FND_API.G_MISS_CHAR;
1212: END IF;
1213:
1214: IF p_x_line_rec.global_attribute15 IS NULL THEN
1215: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
1216: END IF;
1217:
1218: IF p_x_line_rec.global_attribute16 IS NULL THEN
1219: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
1215: p_x_line_rec.global_attribute15 := FND_API.G_MISS_CHAR;
1216: END IF;
1217:
1218: IF p_x_line_rec.global_attribute16 IS NULL THEN
1219: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
1220: END IF;
1221:
1222: IF p_x_line_rec.global_attribute17 IS NULL THEN
1223: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
1219: p_x_line_rec.global_attribute16 := FND_API.G_MISS_CHAR;
1220: END IF;
1221:
1222: IF p_x_line_rec.global_attribute17 IS NULL THEN
1223: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
1224: END IF;
1225:
1226: IF p_x_line_rec.global_attribute18 IS NULL THEN
1227: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
1223: p_x_line_rec.global_attribute17 := FND_API.G_MISS_CHAR;
1224: END IF;
1225:
1226: IF p_x_line_rec.global_attribute18 IS NULL THEN
1227: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
1228: END IF;
1229:
1230: IF p_x_line_rec.global_attribute19 IS NULL THEN
1231: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
1227: p_x_line_rec.global_attribute18 := FND_API.G_MISS_CHAR;
1228: END IF;
1229:
1230: IF p_x_line_rec.global_attribute19 IS NULL THEN
1231: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
1232: END IF;
1233:
1234: IF p_x_line_rec.global_attribute2 IS NULL THEN
1235: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
1231: p_x_line_rec.global_attribute19 := FND_API.G_MISS_CHAR;
1232: END IF;
1233:
1234: IF p_x_line_rec.global_attribute2 IS NULL THEN
1235: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
1236: END IF;
1237:
1238: IF p_x_line_rec.global_attribute20 IS NULL THEN
1239: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
1235: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
1236: END IF;
1237:
1238: IF p_x_line_rec.global_attribute20 IS NULL THEN
1239: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
1240: END IF;
1241:
1242: IF p_x_line_rec.global_attribute3 IS NULL THEN
1243: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
1239: p_x_line_rec.global_attribute20 := FND_API.G_MISS_CHAR;
1240: END IF;
1241:
1242: IF p_x_line_rec.global_attribute3 IS NULL THEN
1243: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
1244: END IF;
1245:
1246: IF p_x_line_rec.global_attribute4 IS NULL THEN
1247: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
1243: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
1244: END IF;
1245:
1246: IF p_x_line_rec.global_attribute4 IS NULL THEN
1247: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
1248: END IF;
1249:
1250: IF p_x_line_rec.global_attribute5 IS NULL THEN
1251: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
1247: p_x_line_rec.global_attribute4 := FND_API.G_MISS_CHAR;
1248: END IF;
1249:
1250: IF p_x_line_rec.global_attribute5 IS NULL THEN
1251: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
1252: END IF;
1253:
1254: IF p_x_line_rec.global_attribute6 IS NULL THEN
1255: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
1251: p_x_line_rec.global_attribute5 := FND_API.G_MISS_CHAR;
1252: END IF;
1253:
1254: IF p_x_line_rec.global_attribute6 IS NULL THEN
1255: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
1256: END IF;
1257:
1258: IF p_x_line_rec.global_attribute7 IS NULL THEN
1259: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
1255: p_x_line_rec.global_attribute6 := FND_API.G_MISS_CHAR;
1256: END IF;
1257:
1258: IF p_x_line_rec.global_attribute7 IS NULL THEN
1259: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
1260: END IF;
1261:
1262: IF p_x_line_rec.global_attribute8 IS NULL THEN
1263: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
1259: p_x_line_rec.global_attribute7 := FND_API.G_MISS_CHAR;
1260: END IF;
1261:
1262: IF p_x_line_rec.global_attribute8 IS NULL THEN
1263: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
1264: END IF;
1265:
1266: IF p_x_line_rec.global_attribute9 IS NULL THEN
1267: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
1263: p_x_line_rec.global_attribute8 := FND_API.G_MISS_CHAR;
1264: END IF;
1265:
1266: IF p_x_line_rec.global_attribute9 IS NULL THEN
1267: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
1268: END IF;
1269:
1270: IF p_x_line_rec.global_attribute_category IS NULL THEN
1271: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
1267: p_x_line_rec.global_attribute9 := FND_API.G_MISS_CHAR;
1268: END IF;
1269:
1270: IF p_x_line_rec.global_attribute_category IS NULL THEN
1271: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
1272: END IF;
1273:
1274: IF p_x_line_rec.header_id IS NULL THEN
1275: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
1271: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
1272: END IF;
1273:
1274: IF p_x_line_rec.header_id IS NULL THEN
1275: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
1276: END IF;
1277:
1278: IF p_x_line_rec.industry_attribute1 IS NULL THEN
1279: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
1275: p_x_line_rec.header_id := FND_API.G_MISS_NUM;
1276: END IF;
1277:
1278: IF p_x_line_rec.industry_attribute1 IS NULL THEN
1279: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
1280: END IF;
1281:
1282: IF p_x_line_rec.industry_attribute10 IS NULL THEN
1283: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
1279: p_x_line_rec.industry_attribute1 := FND_API.G_MISS_CHAR;
1280: END IF;
1281:
1282: IF p_x_line_rec.industry_attribute10 IS NULL THEN
1283: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
1284: END IF;
1285:
1286: IF p_x_line_rec.industry_attribute11 IS NULL THEN
1287: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
1283: p_x_line_rec.industry_attribute10 := FND_API.G_MISS_CHAR;
1284: END IF;
1285:
1286: IF p_x_line_rec.industry_attribute11 IS NULL THEN
1287: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
1288: END IF;
1289:
1290: IF p_x_line_rec.industry_attribute12 IS NULL THEN
1291: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
1287: p_x_line_rec.industry_attribute11 := FND_API.G_MISS_CHAR;
1288: END IF;
1289:
1290: IF p_x_line_rec.industry_attribute12 IS NULL THEN
1291: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
1292: END IF;
1293:
1294: IF p_x_line_rec.industry_attribute13 IS NULL THEN
1295: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
1291: p_x_line_rec.industry_attribute12 := FND_API.G_MISS_CHAR;
1292: END IF;
1293:
1294: IF p_x_line_rec.industry_attribute13 IS NULL THEN
1295: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
1296: END IF;
1297:
1298: IF p_x_line_rec.industry_attribute14 IS NULL THEN
1299: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
1295: p_x_line_rec.industry_attribute13 := FND_API.G_MISS_CHAR;
1296: END IF;
1297:
1298: IF p_x_line_rec.industry_attribute14 IS NULL THEN
1299: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
1300: END IF;
1301:
1302: IF p_x_line_rec.industry_attribute15 IS NULL THEN
1303: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
1299: p_x_line_rec.industry_attribute14 := FND_API.G_MISS_CHAR;
1300: END IF;
1301:
1302: IF p_x_line_rec.industry_attribute15 IS NULL THEN
1303: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
1304: END IF;
1305:
1306: IF p_x_line_rec.industry_attribute16 IS NULL THEN
1307: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
1303: p_x_line_rec.industry_attribute15 := FND_API.G_MISS_CHAR;
1304: END IF;
1305:
1306: IF p_x_line_rec.industry_attribute16 IS NULL THEN
1307: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
1308: END IF;
1309: IF p_x_line_rec.industry_attribute17 IS NULL THEN
1310: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
1311: END IF;
1306: IF p_x_line_rec.industry_attribute16 IS NULL THEN
1307: p_x_line_rec.industry_attribute16 := FND_API.G_MISS_CHAR;
1308: END IF;
1309: IF p_x_line_rec.industry_attribute17 IS NULL THEN
1310: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
1311: END IF;
1312: IF p_x_line_rec.industry_attribute18 IS NULL THEN
1313: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
1314: END IF;
1309: IF p_x_line_rec.industry_attribute17 IS NULL THEN
1310: p_x_line_rec.industry_attribute17 := FND_API.G_MISS_CHAR;
1311: END IF;
1312: IF p_x_line_rec.industry_attribute18 IS NULL THEN
1313: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
1314: END IF;
1315: IF p_x_line_rec.industry_attribute19 IS NULL THEN
1316: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
1317: END IF;
1312: IF p_x_line_rec.industry_attribute18 IS NULL THEN
1313: p_x_line_rec.industry_attribute18 := FND_API.G_MISS_CHAR;
1314: END IF;
1315: IF p_x_line_rec.industry_attribute19 IS NULL THEN
1316: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
1317: END IF;
1318: IF p_x_line_rec.industry_attribute20 IS NULL THEN
1319: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
1320: END IF;
1315: IF p_x_line_rec.industry_attribute19 IS NULL THEN
1316: p_x_line_rec.industry_attribute19 := FND_API.G_MISS_CHAR;
1317: END IF;
1318: IF p_x_line_rec.industry_attribute20 IS NULL THEN
1319: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
1320: END IF;
1321: IF p_x_line_rec.industry_attribute21 IS NULL THEN
1322: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
1323: END IF;
1318: IF p_x_line_rec.industry_attribute20 IS NULL THEN
1319: p_x_line_rec.industry_attribute20 := FND_API.G_MISS_CHAR;
1320: END IF;
1321: IF p_x_line_rec.industry_attribute21 IS NULL THEN
1322: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
1323: END IF;
1324: IF p_x_line_rec.industry_attribute22 IS NULL THEN
1325: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
1326: END IF;
1321: IF p_x_line_rec.industry_attribute21 IS NULL THEN
1322: p_x_line_rec.industry_attribute21 := FND_API.G_MISS_CHAR;
1323: END IF;
1324: IF p_x_line_rec.industry_attribute22 IS NULL THEN
1325: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
1326: END IF;
1327: IF p_x_line_rec.industry_attribute23 IS NULL THEN
1328: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
1329: END IF;
1324: IF p_x_line_rec.industry_attribute22 IS NULL THEN
1325: p_x_line_rec.industry_attribute22 := FND_API.G_MISS_CHAR;
1326: END IF;
1327: IF p_x_line_rec.industry_attribute23 IS NULL THEN
1328: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
1329: END IF;
1330: IF p_x_line_rec.industry_attribute24 IS NULL THEN
1331: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
1332: END IF;
1327: IF p_x_line_rec.industry_attribute23 IS NULL THEN
1328: p_x_line_rec.industry_attribute23 := FND_API.G_MISS_CHAR;
1329: END IF;
1330: IF p_x_line_rec.industry_attribute24 IS NULL THEN
1331: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
1332: END IF;
1333: IF p_x_line_rec.industry_attribute25 IS NULL THEN
1334: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
1335: END IF;
1330: IF p_x_line_rec.industry_attribute24 IS NULL THEN
1331: p_x_line_rec.industry_attribute24 := FND_API.G_MISS_CHAR;
1332: END IF;
1333: IF p_x_line_rec.industry_attribute25 IS NULL THEN
1334: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
1335: END IF;
1336: IF p_x_line_rec.industry_attribute26 IS NULL THEN
1337: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
1338: END IF;
1333: IF p_x_line_rec.industry_attribute25 IS NULL THEN
1334: p_x_line_rec.industry_attribute25 := FND_API.G_MISS_CHAR;
1335: END IF;
1336: IF p_x_line_rec.industry_attribute26 IS NULL THEN
1337: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
1338: END IF;
1339: IF p_x_line_rec.industry_attribute27 IS NULL THEN
1340: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
1341: END IF;
1336: IF p_x_line_rec.industry_attribute26 IS NULL THEN
1337: p_x_line_rec.industry_attribute26 := FND_API.G_MISS_CHAR;
1338: END IF;
1339: IF p_x_line_rec.industry_attribute27 IS NULL THEN
1340: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
1341: END IF;
1342: IF p_x_line_rec.industry_attribute28 IS NULL THEN
1343: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
1344: END IF;
1339: IF p_x_line_rec.industry_attribute27 IS NULL THEN
1340: p_x_line_rec.industry_attribute27 := FND_API.G_MISS_CHAR;
1341: END IF;
1342: IF p_x_line_rec.industry_attribute28 IS NULL THEN
1343: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
1344: END IF;
1345: IF p_x_line_rec.industry_attribute29 IS NULL THEN
1346: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
1347: END IF;
1342: IF p_x_line_rec.industry_attribute28 IS NULL THEN
1343: p_x_line_rec.industry_attribute28 := FND_API.G_MISS_CHAR;
1344: END IF;
1345: IF p_x_line_rec.industry_attribute29 IS NULL THEN
1346: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
1347: END IF;
1348: IF p_x_line_rec.industry_attribute30 IS NULL THEN
1349: p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
1350: END IF;
1345: IF p_x_line_rec.industry_attribute29 IS NULL THEN
1346: p_x_line_rec.industry_attribute29 := FND_API.G_MISS_CHAR;
1347: END IF;
1348: IF p_x_line_rec.industry_attribute30 IS NULL THEN
1349: p_x_line_rec.industry_attribute30 := FND_API.G_MISS_CHAR;
1350: END IF;
1351:
1352:
1353: IF p_x_line_rec.industry_attribute2 IS NULL THEN
1350: END IF;
1351:
1352:
1353: IF p_x_line_rec.industry_attribute2 IS NULL THEN
1354: p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
1355: END IF;
1356:
1357: IF p_x_line_rec.industry_attribute3 IS NULL THEN
1358: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
1354: p_x_line_rec.industry_attribute2 := FND_API.G_MISS_CHAR;
1355: END IF;
1356:
1357: IF p_x_line_rec.industry_attribute3 IS NULL THEN
1358: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
1359: END IF;
1360:
1361: IF p_x_line_rec.industry_attribute4 IS NULL THEN
1362: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
1358: p_x_line_rec.industry_attribute3 := FND_API.G_MISS_CHAR;
1359: END IF;
1360:
1361: IF p_x_line_rec.industry_attribute4 IS NULL THEN
1362: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
1363: END IF;
1364:
1365: IF p_x_line_rec.industry_attribute5 IS NULL THEN
1366: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
1362: p_x_line_rec.industry_attribute4 := FND_API.G_MISS_CHAR;
1363: END IF;
1364:
1365: IF p_x_line_rec.industry_attribute5 IS NULL THEN
1366: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
1367: END IF;
1368:
1369: IF p_x_line_rec.industry_attribute6 IS NULL THEN
1370: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
1366: p_x_line_rec.industry_attribute5 := FND_API.G_MISS_CHAR;
1367: END IF;
1368:
1369: IF p_x_line_rec.industry_attribute6 IS NULL THEN
1370: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
1371: END IF;
1372:
1373: IF p_x_line_rec.industry_attribute7 IS NULL THEN
1374: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
1370: p_x_line_rec.industry_attribute6 := FND_API.G_MISS_CHAR;
1371: END IF;
1372:
1373: IF p_x_line_rec.industry_attribute7 IS NULL THEN
1374: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
1375: END IF;
1376:
1377: IF p_x_line_rec.industry_attribute8 IS NULL THEN
1378: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
1374: p_x_line_rec.industry_attribute7 := FND_API.G_MISS_CHAR;
1375: END IF;
1376:
1377: IF p_x_line_rec.industry_attribute8 IS NULL THEN
1378: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
1379: END IF;
1380:
1381: IF p_x_line_rec.industry_attribute9 IS NULL THEN
1382: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
1378: p_x_line_rec.industry_attribute8 := FND_API.G_MISS_CHAR;
1379: END IF;
1380:
1381: IF p_x_line_rec.industry_attribute9 IS NULL THEN
1382: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
1383: END IF;
1384:
1385: IF p_x_line_rec.industry_context IS NULL THEN
1386: p_x_line_rec.industry_context := FND_API.G_MISS_CHAR;
1382: p_x_line_rec.industry_attribute9 := FND_API.G_MISS_CHAR;
1383: END IF;
1384:
1385: IF p_x_line_rec.industry_context IS NULL THEN
1386: p_x_line_rec.industry_context := FND_API.G_MISS_CHAR;
1387: END IF;
1388:
1389: /* TP_ATTRIBUTE */
1390: IF p_x_line_rec.tp_context IS NULL THEN
1387: END IF;
1388:
1389: /* TP_ATTRIBUTE */
1390: IF p_x_line_rec.tp_context IS NULL THEN
1391: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
1392: END IF;
1393: IF p_x_line_rec.tp_attribute1 IS NULL THEN
1394: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
1395: END IF;
1390: IF p_x_line_rec.tp_context IS NULL THEN
1391: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
1392: END IF;
1393: IF p_x_line_rec.tp_attribute1 IS NULL THEN
1394: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
1395: END IF;
1396: IF p_x_line_rec.tp_attribute2 IS NULL THEN
1397: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
1398: END IF;
1393: IF p_x_line_rec.tp_attribute1 IS NULL THEN
1394: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
1395: END IF;
1396: IF p_x_line_rec.tp_attribute2 IS NULL THEN
1397: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
1398: END IF;
1399: IF p_x_line_rec.tp_attribute3 IS NULL THEN
1400: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
1401: END IF;
1396: IF p_x_line_rec.tp_attribute2 IS NULL THEN
1397: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
1398: END IF;
1399: IF p_x_line_rec.tp_attribute3 IS NULL THEN
1400: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
1401: END IF;
1402: IF p_x_line_rec.tp_attribute4 IS NULL THEN
1403: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
1404: END IF;
1399: IF p_x_line_rec.tp_attribute3 IS NULL THEN
1400: p_x_line_rec.tp_attribute3 := FND_API.G_MISS_CHAR;
1401: END IF;
1402: IF p_x_line_rec.tp_attribute4 IS NULL THEN
1403: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
1404: END IF;
1405: IF p_x_line_rec.tp_attribute5 IS NULL THEN
1406: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
1407: END IF;
1402: IF p_x_line_rec.tp_attribute4 IS NULL THEN
1403: p_x_line_rec.tp_attribute4 := FND_API.G_MISS_CHAR;
1404: END IF;
1405: IF p_x_line_rec.tp_attribute5 IS NULL THEN
1406: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
1407: END IF;
1408: IF p_x_line_rec.tp_attribute6 IS NULL THEN
1409: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
1410: END IF;
1405: IF p_x_line_rec.tp_attribute5 IS NULL THEN
1406: p_x_line_rec.tp_attribute5 := FND_API.G_MISS_CHAR;
1407: END IF;
1408: IF p_x_line_rec.tp_attribute6 IS NULL THEN
1409: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
1410: END IF;
1411: IF p_x_line_rec.tp_attribute7 IS NULL THEN
1412: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
1413: END IF;
1408: IF p_x_line_rec.tp_attribute6 IS NULL THEN
1409: p_x_line_rec.tp_attribute6 := FND_API.G_MISS_CHAR;
1410: END IF;
1411: IF p_x_line_rec.tp_attribute7 IS NULL THEN
1412: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
1413: END IF;
1414: IF p_x_line_rec.tp_attribute8 IS NULL THEN
1415: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
1416: END IF;
1411: IF p_x_line_rec.tp_attribute7 IS NULL THEN
1412: p_x_line_rec.tp_attribute7 := FND_API.G_MISS_CHAR;
1413: END IF;
1414: IF p_x_line_rec.tp_attribute8 IS NULL THEN
1415: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
1416: END IF;
1417: IF p_x_line_rec.tp_attribute9 IS NULL THEN
1418: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
1419: END IF;
1414: IF p_x_line_rec.tp_attribute8 IS NULL THEN
1415: p_x_line_rec.tp_attribute8 := FND_API.G_MISS_CHAR;
1416: END IF;
1417: IF p_x_line_rec.tp_attribute9 IS NULL THEN
1418: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
1419: END IF;
1420: IF p_x_line_rec.tp_attribute10 IS NULL THEN
1421: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
1422: END IF;
1417: IF p_x_line_rec.tp_attribute9 IS NULL THEN
1418: p_x_line_rec.tp_attribute9 := FND_API.G_MISS_CHAR;
1419: END IF;
1420: IF p_x_line_rec.tp_attribute10 IS NULL THEN
1421: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
1422: END IF;
1423: IF p_x_line_rec.tp_attribute11 IS NULL THEN
1424: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
1425: END IF;
1420: IF p_x_line_rec.tp_attribute10 IS NULL THEN
1421: p_x_line_rec.tp_attribute10 := FND_API.G_MISS_CHAR;
1422: END IF;
1423: IF p_x_line_rec.tp_attribute11 IS NULL THEN
1424: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
1425: END IF;
1426: IF p_x_line_rec.tp_attribute12 IS NULL THEN
1427: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
1428: END IF;
1423: IF p_x_line_rec.tp_attribute11 IS NULL THEN
1424: p_x_line_rec.tp_attribute11 := FND_API.G_MISS_CHAR;
1425: END IF;
1426: IF p_x_line_rec.tp_attribute12 IS NULL THEN
1427: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
1428: END IF;
1429: IF p_x_line_rec.tp_attribute13 IS NULL THEN
1430: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
1431: END IF;
1426: IF p_x_line_rec.tp_attribute12 IS NULL THEN
1427: p_x_line_rec.tp_attribute12 := FND_API.G_MISS_CHAR;
1428: END IF;
1429: IF p_x_line_rec.tp_attribute13 IS NULL THEN
1430: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
1431: END IF;
1432: IF p_x_line_rec.tp_attribute14 IS NULL THEN
1433: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
1434: END IF;
1429: IF p_x_line_rec.tp_attribute13 IS NULL THEN
1430: p_x_line_rec.tp_attribute13 := FND_API.G_MISS_CHAR;
1431: END IF;
1432: IF p_x_line_rec.tp_attribute14 IS NULL THEN
1433: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
1434: END IF;
1435: IF p_x_line_rec.tp_attribute15 IS NULL THEN
1436: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
1437: END IF;
1432: IF p_x_line_rec.tp_attribute14 IS NULL THEN
1433: p_x_line_rec.tp_attribute14 := FND_API.G_MISS_CHAR;
1434: END IF;
1435: IF p_x_line_rec.tp_attribute15 IS NULL THEN
1436: p_x_line_rec.tp_attribute15 := FND_API.G_MISS_CHAR;
1437: END IF;
1438:
1439:
1440: IF p_x_line_rec.intermed_ship_to_contact_id IS NULL THEN
1437: END IF;
1438:
1439:
1440: IF p_x_line_rec.intermed_ship_to_contact_id IS NULL THEN
1441: p_x_line_rec.intermed_ship_to_contact_id := FND_API.G_MISS_NUM;
1442: END IF;
1443:
1444: IF p_x_line_rec.intermed_ship_to_org_id IS NULL THEN
1445: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
1441: p_x_line_rec.intermed_ship_to_contact_id := FND_API.G_MISS_NUM;
1442: END IF;
1443:
1444: IF p_x_line_rec.intermed_ship_to_org_id IS NULL THEN
1445: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
1446: END IF;
1447:
1448: IF p_x_line_rec.inventory_item_id IS NULL THEN
1449: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
1445: p_x_line_rec.intermed_ship_to_org_id := FND_API.G_MISS_NUM;
1446: END IF;
1447:
1448: IF p_x_line_rec.inventory_item_id IS NULL THEN
1449: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
1450: END IF;
1451:
1452: IF p_x_line_rec.invoice_interface_status_code IS NULL THEN
1453: p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
1449: p_x_line_rec.inventory_item_id := FND_API.G_MISS_NUM;
1450: END IF;
1451:
1452: IF p_x_line_rec.invoice_interface_status_code IS NULL THEN
1453: p_x_line_rec.invoice_interface_status_code := FND_API.G_MISS_CHAR;
1454: END IF;
1455:
1456:
1457:
1455:
1456:
1457:
1458: IF p_x_line_rec.invoice_to_contact_id IS NULL THEN
1459: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
1460: END IF;
1461:
1462: IF p_x_line_rec.invoiced_quantity IS NULL THEN
1463: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
1459: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
1460: END IF;
1461:
1462: IF p_x_line_rec.invoiced_quantity IS NULL THEN
1463: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
1464: END IF;
1465:
1466: IF p_x_line_rec.invoice_to_org_id IS NULL THEN
1467: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1463: p_x_line_rec.invoiced_quantity := FND_API.G_MISS_NUM;
1464: END IF;
1465:
1466: IF p_x_line_rec.invoice_to_org_id IS NULL THEN
1467: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1468: END IF;
1469:
1470: IF p_x_line_rec.invoicing_rule_id IS NULL THEN
1471: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
1467: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
1468: END IF;
1469:
1470: IF p_x_line_rec.invoicing_rule_id IS NULL THEN
1471: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
1472: END IF;
1473:
1474: IF p_x_line_rec.ordered_item_id IS NULL THEN
1475: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
1471: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
1472: END IF;
1473:
1474: IF p_x_line_rec.ordered_item_id IS NULL THEN
1475: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
1476: END IF;
1477:
1478: IF p_x_line_rec.item_identifier_type IS NULL THEN
1479: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1475: p_x_line_rec.ordered_item_id := FND_API.G_MISS_NUM;
1476: END IF;
1477:
1478: IF p_x_line_rec.item_identifier_type IS NULL THEN
1479: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1480: END IF;
1481:
1482: IF p_x_line_rec.ordered_item IS NULL THEN
1483: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
1479: p_x_line_rec.item_identifier_type := FND_API.G_MISS_CHAR;
1480: END IF;
1481:
1482: IF p_x_line_rec.ordered_item IS NULL THEN
1483: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
1484: END IF;
1485:
1486: IF p_x_line_rec.item_revision IS NULL THEN
1487: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
1483: p_x_line_rec.ordered_item := FND_API.G_MISS_CHAR;
1484: END IF;
1485:
1486: IF p_x_line_rec.item_revision IS NULL THEN
1487: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
1488: END IF;
1489:
1490: IF p_x_line_rec.item_type_code IS NULL THEN
1491: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
1487: p_x_line_rec.item_revision := FND_API.G_MISS_CHAR;
1488: END IF;
1489:
1490: IF p_x_line_rec.item_type_code IS NULL THEN
1491: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
1492: END IF;
1493:
1494: IF p_x_line_rec.last_updated_by IS NULL THEN
1495: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
1491: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
1492: END IF;
1493:
1494: IF p_x_line_rec.last_updated_by IS NULL THEN
1495: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
1496: END IF;
1497:
1498: IF p_x_line_rec.last_update_date IS NULL THEN
1499: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
1495: p_x_line_rec.last_updated_by := FND_API.G_MISS_NUM;
1496: END IF;
1497:
1498: IF p_x_line_rec.last_update_date IS NULL THEN
1499: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
1500: END IF;
1501:
1502: IF p_x_line_rec.last_update_login IS NULL THEN
1503: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
1499: p_x_line_rec.last_update_date := FND_API.G_MISS_DATE;
1500: END IF;
1501:
1502: IF p_x_line_rec.last_update_login IS NULL THEN
1503: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
1504: END IF;
1505:
1506: IF p_x_line_rec.latest_acceptable_date IS NULL THEN
1507: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
1503: p_x_line_rec.last_update_login := FND_API.G_MISS_NUM;
1504: END IF;
1505:
1506: IF p_x_line_rec.latest_acceptable_date IS NULL THEN
1507: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
1508: END IF;
1509:
1510: IF p_x_line_rec.line_category_code IS NULL THEN
1511: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
1507: p_x_line_rec.latest_acceptable_date := FND_API.G_MISS_DATE;
1508: END IF;
1509:
1510: IF p_x_line_rec.line_category_code IS NULL THEN
1511: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
1512: END IF;
1513:
1514: IF p_x_line_rec.line_id IS NULL THEN
1515: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
1511: p_x_line_rec.line_category_code := FND_API.G_MISS_CHAR;
1512: END IF;
1513:
1514: IF p_x_line_rec.line_id IS NULL THEN
1515: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
1516: END IF;
1517:
1518: IF p_x_line_rec.line_number IS NULL THEN
1519: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
1515: p_x_line_rec.line_id := FND_API.G_MISS_NUM;
1516: END IF;
1517:
1518: IF p_x_line_rec.line_number IS NULL THEN
1519: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
1520: END IF;
1521:
1522: IF p_x_line_rec.line_type_id IS NULL THEN
1523: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
1519: p_x_line_rec.line_number := FND_API.G_MISS_NUM;
1520: END IF;
1521:
1522: IF p_x_line_rec.line_type_id IS NULL THEN
1523: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
1524: END IF;
1525:
1526: IF p_x_line_rec.link_to_line_id IS NULL THEN
1527: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
1523: p_x_line_rec.line_type_id := FND_API.G_MISS_NUM;
1524: END IF;
1525:
1526: IF p_x_line_rec.link_to_line_id IS NULL THEN
1527: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
1528: END IF;
1529:
1530: IF p_x_line_rec.model_group_number IS NULL THEN
1531: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
1527: p_x_line_rec.link_to_line_id := FND_API.G_MISS_NUM;
1528: END IF;
1529:
1530: IF p_x_line_rec.model_group_number IS NULL THEN
1531: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
1532: END IF;
1533:
1534: IF p_x_line_rec.mfg_component_sequence_id IS NULL THEN
1535: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
1531: p_x_line_rec.model_group_number := FND_API.G_MISS_NUM;
1532: END IF;
1533:
1534: IF p_x_line_rec.mfg_component_sequence_id IS NULL THEN
1535: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
1536: END IF;
1537:
1538: IF p_x_line_rec.mfg_lead_time IS NULL THEN
1539: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
1535: p_x_line_rec.mfg_component_sequence_id := FND_API.G_MISS_NUM;
1536: END IF;
1537:
1538: IF p_x_line_rec.mfg_lead_time IS NULL THEN
1539: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
1540: END IF;
1541:
1542: IF p_x_line_rec.open_flag IS NULL THEN
1543: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
1539: p_x_line_rec.mfg_lead_time := FND_API.G_MISS_NUM;
1540: END IF;
1541:
1542: IF p_x_line_rec.open_flag IS NULL THEN
1543: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
1544: END IF;
1545:
1546: IF p_x_line_rec.option_flag IS NULL THEN
1547: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
1543: p_x_line_rec.open_flag := FND_API.G_MISS_CHAR;
1544: END IF;
1545:
1546: IF p_x_line_rec.option_flag IS NULL THEN
1547: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
1548: END IF;
1549:
1550: IF p_x_line_rec.option_number IS NULL THEN
1551: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
1547: p_x_line_rec.option_flag := FND_API.G_MISS_CHAR;
1548: END IF;
1549:
1550: IF p_x_line_rec.option_number IS NULL THEN
1551: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
1552: END IF;
1553:
1554: IF p_x_line_rec.ordered_quantity IS NULL THEN
1555: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
1551: p_x_line_rec.option_number := FND_API.G_MISS_NUM;
1552: END IF;
1553:
1554: IF p_x_line_rec.ordered_quantity IS NULL THEN
1555: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
1556: END IF;
1557:
1558: IF p_x_line_rec.order_quantity_uom IS NULL THEN
1559: p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1555: p_x_line_rec.ordered_quantity := FND_API.G_MISS_NUM;
1556: END IF;
1557:
1558: IF p_x_line_rec.order_quantity_uom IS NULL THEN
1559: p_x_line_rec.order_quantity_uom := FND_API.G_MISS_CHAR;
1560: END IF;
1561:
1562: -- OPM 02/JUN/00 - Deal with process attributes
1563: -- IS===========================================
1561:
1562: -- OPM 02/JUN/00 - Deal with process attributes
1563: -- IS===========================================
1564: IF p_x_line_rec.ordered_quantity2 IS NULL THEN
1565: p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
1566: END IF;
1567:
1568: IF p_x_line_rec.ordered_quantity_uom2 IS NULL THEN
1569: p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
1565: p_x_line_rec.ordered_quantity2 := FND_API.G_MISS_NUM;
1566: END IF;
1567:
1568: IF p_x_line_rec.ordered_quantity_uom2 IS NULL THEN
1569: p_x_line_rec.ordered_quantity_uom2 := FND_API.G_MISS_CHAR;
1570: END IF;
1571: -- OPM 02/JUN/00 - END
1572: -- IS==================
1573:
1571: -- OPM 02/JUN/00 - END
1572: -- IS==================
1573:
1574: IF p_x_line_rec.org_id IS NULL THEN
1575: p_x_line_rec.org_id := FND_API.G_MISS_NUM;
1576: END IF;
1577:
1578: IF p_x_line_rec.orig_sys_document_ref IS NULL THEN
1579: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
1575: p_x_line_rec.org_id := FND_API.G_MISS_NUM;
1576: END IF;
1577:
1578: IF p_x_line_rec.orig_sys_document_ref IS NULL THEN
1579: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
1580: END IF;
1581:
1582: IF p_x_line_rec.orig_sys_line_ref IS NULL THEN
1583: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
1579: p_x_line_rec.orig_sys_document_ref := FND_API.G_MISS_CHAR;
1580: END IF;
1581:
1582: IF p_x_line_rec.orig_sys_line_ref IS NULL THEN
1583: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
1584: END IF;
1585:
1586: IF p_x_line_rec.orig_sys_shipment_ref IS NULL THEN
1587: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
1583: p_x_line_rec.orig_sys_line_ref := FND_API.G_MISS_CHAR;
1584: END IF;
1585:
1586: IF p_x_line_rec.orig_sys_shipment_ref IS NULL THEN
1587: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
1588: END IF;
1589:
1590: IF p_x_line_rec.original_list_price IS NULL THEN
1591: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
1587: p_x_line_rec.orig_sys_shipment_ref := FND_API.G_MISS_CHAR;
1588: END IF;
1589:
1590: IF p_x_line_rec.original_list_price IS NULL THEN
1591: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
1592: END IF;
1593:
1594: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
1595: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
1591: p_x_line_rec.original_list_price:= FND_API.G_MISS_NUM;
1592: END IF;
1593:
1594: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
1595: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
1596: END IF;
1597: IF p_x_line_rec.over_ship_resolved_flag IS NULL THEN
1598: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
1599: END IF;
1594: IF p_x_line_rec.over_ship_reason_code IS NULL THEN
1595: p_x_line_rec.over_ship_reason_code := FND_API.G_MISS_CHAR;
1596: END IF;
1597: IF p_x_line_rec.over_ship_resolved_flag IS NULL THEN
1598: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
1599: END IF;
1600:
1601: IF p_x_line_rec.payment_term_id IS NULL THEN
1602: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
1598: p_x_line_rec.over_ship_resolved_flag := FND_API.G_MISS_CHAR;
1599: END IF;
1600:
1601: IF p_x_line_rec.payment_term_id IS NULL THEN
1602: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
1603: END IF;
1604:
1605: IF p_x_line_rec.planning_priority IS NULL THEN
1606: p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
1602: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
1603: END IF;
1604:
1605: IF p_x_line_rec.planning_priority IS NULL THEN
1606: p_x_line_rec.planning_priority := FND_API.G_MISS_NUM;
1607: END IF;
1608:
1609: -- OPM 02/JUN/00 - Deal with process attributes
1610: -- IS===========================================
1608:
1609: -- OPM 02/JUN/00 - Deal with process attributes
1610: -- IS===========================================
1611: IF p_x_line_rec.preferred_grade IS NULL THEN
1612: p_x_line_rec.preferred_grade := FND_API.G_MISS_CHAR;
1613: END IF;
1614: -- OPM 02/JUN/00 - END
1615: -- IS==================
1616:
1614: -- OPM 02/JUN/00 - END
1615: -- IS==================
1616:
1617: IF p_x_line_rec.price_list_id IS NULL THEN
1618: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
1619: END IF;
1620:
1621: IF p_x_line_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
1622: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
1618: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
1619: END IF;
1620:
1621: IF p_x_line_rec.price_request_code IS NULL THEN -- PROMOTIONS SEP/01
1622: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
1623: END IF;
1624:
1625: IF p_x_line_rec.pricing_attribute1 IS NULL THEN
1626: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
1622: p_x_line_rec.price_request_code := FND_API.G_MISS_CHAR;
1623: END IF;
1624:
1625: IF p_x_line_rec.pricing_attribute1 IS NULL THEN
1626: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
1627: END IF;
1628:
1629: IF p_x_line_rec.pricing_attribute10 IS NULL THEN
1630: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
1626: p_x_line_rec.pricing_attribute1 := FND_API.G_MISS_CHAR;
1627: END IF;
1628:
1629: IF p_x_line_rec.pricing_attribute10 IS NULL THEN
1630: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
1631: END IF;
1632:
1633: IF p_x_line_rec.pricing_attribute2 IS NULL THEN
1634: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
1630: p_x_line_rec.pricing_attribute10 := FND_API.G_MISS_CHAR;
1631: END IF;
1632:
1633: IF p_x_line_rec.pricing_attribute2 IS NULL THEN
1634: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
1635: END IF;
1636:
1637: IF p_x_line_rec.pricing_attribute3 IS NULL THEN
1638: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
1634: p_x_line_rec.pricing_attribute2 := FND_API.G_MISS_CHAR;
1635: END IF;
1636:
1637: IF p_x_line_rec.pricing_attribute3 IS NULL THEN
1638: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
1639: END IF;
1640:
1641: IF p_x_line_rec.pricing_attribute4 IS NULL THEN
1642: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
1638: p_x_line_rec.pricing_attribute3 := FND_API.G_MISS_CHAR;
1639: END IF;
1640:
1641: IF p_x_line_rec.pricing_attribute4 IS NULL THEN
1642: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
1643: END IF;
1644:
1645: IF p_x_line_rec.pricing_attribute5 IS NULL THEN
1646: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
1642: p_x_line_rec.pricing_attribute4 := FND_API.G_MISS_CHAR;
1643: END IF;
1644:
1645: IF p_x_line_rec.pricing_attribute5 IS NULL THEN
1646: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
1647: END IF;
1648:
1649: IF p_x_line_rec.pricing_attribute6 IS NULL THEN
1650: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
1646: p_x_line_rec.pricing_attribute5 := FND_API.G_MISS_CHAR;
1647: END IF;
1648:
1649: IF p_x_line_rec.pricing_attribute6 IS NULL THEN
1650: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
1651: END IF;
1652:
1653: IF p_x_line_rec.pricing_attribute7 IS NULL THEN
1654: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
1650: p_x_line_rec.pricing_attribute6 := FND_API.G_MISS_CHAR;
1651: END IF;
1652:
1653: IF p_x_line_rec.pricing_attribute7 IS NULL THEN
1654: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
1655: END IF;
1656:
1657: IF p_x_line_rec.pricing_attribute8 IS NULL THEN
1658: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
1654: p_x_line_rec.pricing_attribute7 := FND_API.G_MISS_CHAR;
1655: END IF;
1656:
1657: IF p_x_line_rec.pricing_attribute8 IS NULL THEN
1658: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
1659: END IF;
1660:
1661: IF p_x_line_rec.pricing_attribute9 IS NULL THEN
1662: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
1658: p_x_line_rec.pricing_attribute8 := FND_API.G_MISS_CHAR;
1659: END IF;
1660:
1661: IF p_x_line_rec.pricing_attribute9 IS NULL THEN
1662: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
1663: END IF;
1664:
1665: IF p_x_line_rec.pricing_context IS NULL THEN
1666: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
1662: p_x_line_rec.pricing_attribute9 := FND_API.G_MISS_CHAR;
1663: END IF;
1664:
1665: IF p_x_line_rec.pricing_context IS NULL THEN
1666: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
1667: END IF;
1668:
1669: IF p_x_line_rec.pricing_date IS NULL THEN
1670: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
1666: p_x_line_rec.pricing_context := FND_API.G_MISS_CHAR;
1667: END IF;
1668:
1669: IF p_x_line_rec.pricing_date IS NULL THEN
1670: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
1671: END IF;
1672:
1673: IF p_x_line_rec.pricing_quantity IS NULL THEN
1674: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
1670: p_x_line_rec.pricing_date := FND_API.G_MISS_DATE;
1671: END IF;
1672:
1673: IF p_x_line_rec.pricing_quantity IS NULL THEN
1674: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
1675: END IF;
1676:
1677: IF p_x_line_rec.pricing_quantity_uom IS NULL THEN
1678: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
1674: p_x_line_rec.pricing_quantity := FND_API.G_MISS_NUM;
1675: END IF;
1676:
1677: IF p_x_line_rec.pricing_quantity_uom IS NULL THEN
1678: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
1679: END IF;
1680:
1681: IF p_x_line_rec.program_application_id IS NULL THEN
1682: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
1678: p_x_line_rec.pricing_quantity_uom := FND_API.G_MISS_CHAR;
1679: END IF;
1680:
1681: IF p_x_line_rec.program_application_id IS NULL THEN
1682: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
1683: END IF;
1684:
1685: IF p_x_line_rec.program_id IS NULL THEN
1686: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
1682: p_x_line_rec.program_application_id := FND_API.G_MISS_NUM;
1683: END IF;
1684:
1685: IF p_x_line_rec.program_id IS NULL THEN
1686: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
1687: END IF;
1688:
1689: IF p_x_line_rec.program_update_date IS NULL THEN
1690: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
1686: p_x_line_rec.program_id := FND_API.G_MISS_NUM;
1687: END IF;
1688:
1689: IF p_x_line_rec.program_update_date IS NULL THEN
1690: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
1691: END IF;
1692:
1693: IF p_x_line_rec.project_id IS NULL THEN
1694: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
1690: p_x_line_rec.program_update_date := FND_API.G_MISS_DATE;
1691: END IF;
1692:
1693: IF p_x_line_rec.project_id IS NULL THEN
1694: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
1695: END IF;
1696:
1697: IF p_x_line_rec.promise_date IS NULL THEN
1698: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
1694: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
1695: END IF;
1696:
1697: IF p_x_line_rec.promise_date IS NULL THEN
1698: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
1699: END IF;
1700:
1701: IF p_x_line_rec.re_source_flag IS NULL THEN
1702: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
1698: p_x_line_rec.promise_date := FND_API.G_MISS_DATE;
1699: END IF;
1700:
1701: IF p_x_line_rec.re_source_flag IS NULL THEN
1702: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
1703: END IF;
1704:
1705: IF p_x_line_rec.reference_customer_trx_line_id IS NULL THEN
1706: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
1702: p_x_line_rec.re_source_flag := FND_API.G_MISS_CHAR;
1703: END IF;
1704:
1705: IF p_x_line_rec.reference_customer_trx_line_id IS NULL THEN
1706: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
1707: END IF;
1708:
1709: IF p_x_line_rec.reference_header_id IS NULL THEN
1710: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
1706: p_x_line_rec.reference_customer_trx_line_id := FND_API.G_MISS_NUM;
1707: END IF;
1708:
1709: IF p_x_line_rec.reference_header_id IS NULL THEN
1710: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
1711: END IF;
1712:
1713: IF p_x_line_rec.reference_line_id IS NULL THEN
1714: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
1710: p_x_line_rec.reference_header_id := FND_API.G_MISS_NUM;
1711: END IF;
1712:
1713: IF p_x_line_rec.reference_line_id IS NULL THEN
1714: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
1715: END IF;
1716:
1717: IF p_x_line_rec.reference_type IS NULL THEN
1718: p_x_line_rec.reference_type := FND_API.G_MISS_CHAR;
1714: p_x_line_rec.reference_line_id := FND_API.G_MISS_NUM;
1715: END IF;
1716:
1717: IF p_x_line_rec.reference_type IS NULL THEN
1718: p_x_line_rec.reference_type := FND_API.G_MISS_CHAR;
1719: END IF;
1720:
1721:
1722:
1720:
1721:
1722:
1723: IF p_x_line_rec.request_date IS NULL THEN
1724: p_x_line_rec.request_date := FND_API.G_MISS_DATE;
1725: END IF;
1726:
1727: IF p_x_line_rec.request_id IS NULL THEN
1728: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
1724: p_x_line_rec.request_date := FND_API.G_MISS_DATE;
1725: END IF;
1726:
1727: IF p_x_line_rec.request_id IS NULL THEN
1728: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
1729: END IF;
1730:
1731: IF p_x_line_rec.return_attribute1 IS NULL THEN
1732: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
1728: p_x_line_rec.request_id := FND_API.G_MISS_NUM;
1729: END IF;
1730:
1731: IF p_x_line_rec.return_attribute1 IS NULL THEN
1732: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
1733: END IF;
1734:
1735: IF p_x_line_rec.return_attribute10 IS NULL THEN
1736: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
1732: p_x_line_rec.return_attribute1 := FND_API.G_MISS_CHAR;
1733: END IF;
1734:
1735: IF p_x_line_rec.return_attribute10 IS NULL THEN
1736: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
1737: END IF;
1738:
1739: IF p_x_line_rec.return_attribute11 IS NULL THEN
1740: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
1736: p_x_line_rec.return_attribute10 := FND_API.G_MISS_CHAR;
1737: END IF;
1738:
1739: IF p_x_line_rec.return_attribute11 IS NULL THEN
1740: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
1741: END IF;
1742:
1743: IF p_x_line_rec.return_attribute12 IS NULL THEN
1744: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
1740: p_x_line_rec.return_attribute11 := FND_API.G_MISS_CHAR;
1741: END IF;
1742:
1743: IF p_x_line_rec.return_attribute12 IS NULL THEN
1744: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
1745: END IF;
1746:
1747: IF p_x_line_rec.return_attribute13 IS NULL THEN
1748: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
1744: p_x_line_rec.return_attribute12 := FND_API.G_MISS_CHAR;
1745: END IF;
1746:
1747: IF p_x_line_rec.return_attribute13 IS NULL THEN
1748: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
1749: END IF;
1750:
1751: IF p_x_line_rec.return_attribute14 IS NULL THEN
1752: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
1748: p_x_line_rec.return_attribute13 := FND_API.G_MISS_CHAR;
1749: END IF;
1750:
1751: IF p_x_line_rec.return_attribute14 IS NULL THEN
1752: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
1753: END IF;
1754:
1755: IF p_x_line_rec.return_attribute15 IS NULL THEN
1756: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
1752: p_x_line_rec.return_attribute14 := FND_API.G_MISS_CHAR;
1753: END IF;
1754:
1755: IF p_x_line_rec.return_attribute15 IS NULL THEN
1756: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
1757: END IF;
1758:
1759: IF p_x_line_rec.return_attribute2 IS NULL THEN
1760: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
1756: p_x_line_rec.return_attribute15 := FND_API.G_MISS_CHAR;
1757: END IF;
1758:
1759: IF p_x_line_rec.return_attribute2 IS NULL THEN
1760: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
1761: END IF;
1762:
1763: IF p_x_line_rec.return_attribute3 IS NULL THEN
1764: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
1760: p_x_line_rec.return_attribute2 := FND_API.G_MISS_CHAR;
1761: END IF;
1762:
1763: IF p_x_line_rec.return_attribute3 IS NULL THEN
1764: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
1765: END IF;
1766:
1767: IF p_x_line_rec.return_attribute4 IS NULL THEN
1768: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
1764: p_x_line_rec.return_attribute3 := FND_API.G_MISS_CHAR;
1765: END IF;
1766:
1767: IF p_x_line_rec.return_attribute4 IS NULL THEN
1768: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
1769: END IF;
1770:
1771: IF p_x_line_rec.return_attribute5 IS NULL THEN
1772: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
1768: p_x_line_rec.return_attribute4 := FND_API.G_MISS_CHAR;
1769: END IF;
1770:
1771: IF p_x_line_rec.return_attribute5 IS NULL THEN
1772: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
1773: END IF;
1774:
1775: IF p_x_line_rec.return_attribute6 IS NULL THEN
1776: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
1772: p_x_line_rec.return_attribute5 := FND_API.G_MISS_CHAR;
1773: END IF;
1774:
1775: IF p_x_line_rec.return_attribute6 IS NULL THEN
1776: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
1777: END IF;
1778:
1779: IF p_x_line_rec.return_attribute7 IS NULL THEN
1780: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
1776: p_x_line_rec.return_attribute6 := FND_API.G_MISS_CHAR;
1777: END IF;
1778:
1779: IF p_x_line_rec.return_attribute7 IS NULL THEN
1780: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
1781: END IF;
1782:
1783: IF p_x_line_rec.return_attribute8 IS NULL THEN
1784: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
1780: p_x_line_rec.return_attribute7 := FND_API.G_MISS_CHAR;
1781: END IF;
1782:
1783: IF p_x_line_rec.return_attribute8 IS NULL THEN
1784: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
1785: END IF;
1786:
1787: IF p_x_line_rec.return_attribute9 IS NULL THEN
1788: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
1784: p_x_line_rec.return_attribute8 := FND_API.G_MISS_CHAR;
1785: END IF;
1786:
1787: IF p_x_line_rec.return_attribute9 IS NULL THEN
1788: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
1789: END IF;
1790:
1791: IF p_x_line_rec.return_context IS NULL THEN
1792: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
1788: p_x_line_rec.return_attribute9 := FND_API.G_MISS_CHAR;
1789: END IF;
1790:
1791: IF p_x_line_rec.return_context IS NULL THEN
1792: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
1793: END IF;
1794: IF p_x_line_rec.return_reason_code IS NULL THEN
1795: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
1796: END IF;
1791: IF p_x_line_rec.return_context IS NULL THEN
1792: p_x_line_rec.return_context := FND_API.G_MISS_CHAR;
1793: END IF;
1794: IF p_x_line_rec.return_reason_code IS NULL THEN
1795: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
1796: END IF;
1797: IF p_x_line_rec.salesrep_id IS NULL THEN
1798: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
1799: END IF;
1794: IF p_x_line_rec.return_reason_code IS NULL THEN
1795: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
1796: END IF;
1797: IF p_x_line_rec.salesrep_id IS NULL THEN
1798: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
1799: END IF;
1800:
1801: IF p_x_line_rec.rla_schedule_type_code IS NULL THEN
1802: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
1798: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
1799: END IF;
1800:
1801: IF p_x_line_rec.rla_schedule_type_code IS NULL THEN
1802: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
1803: END IF;
1804:
1805: IF p_x_line_rec.schedule_arrival_date IS NULL THEN
1806: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
1802: p_x_line_rec.rla_schedule_type_code := FND_API.G_MISS_CHAR;
1803: END IF;
1804:
1805: IF p_x_line_rec.schedule_arrival_date IS NULL THEN
1806: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
1807: END IF;
1808:
1809: IF p_x_line_rec.schedule_ship_date IS NULL THEN
1810: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
1806: p_x_line_rec.schedule_arrival_date := FND_API.G_MISS_DATE;
1807: END IF;
1808:
1809: IF p_x_line_rec.schedule_ship_date IS NULL THEN
1810: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
1811: END IF;
1812:
1813: IF p_x_line_rec.schedule_action_code IS NULL THEN
1814: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
1810: p_x_line_rec.schedule_ship_date := FND_API.G_MISS_DATE;
1811: END IF;
1812:
1813: IF p_x_line_rec.schedule_action_code IS NULL THEN
1814: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
1815: END IF;
1816:
1817: IF p_x_line_rec.schedule_status_code IS NULL THEN
1818: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
1814: p_x_line_rec.schedule_action_code := FND_API.G_MISS_CHAR;
1815: END IF;
1816:
1817: IF p_x_line_rec.schedule_status_code IS NULL THEN
1818: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
1819: END IF;
1820:
1821: IF p_x_line_rec.shipment_number IS NULL THEN
1822: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
1818: p_x_line_rec.schedule_status_code := FND_API.G_MISS_CHAR;
1819: END IF;
1820:
1821: IF p_x_line_rec.shipment_number IS NULL THEN
1822: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
1823: END IF;
1824:
1825: IF p_x_line_rec.shipment_priority_code IS NULL THEN
1826: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
1822: p_x_line_rec.shipment_number := FND_API.G_MISS_NUM;
1823: END IF;
1824:
1825: IF p_x_line_rec.shipment_priority_code IS NULL THEN
1826: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
1827: END IF;
1828:
1829: IF p_x_line_rec.shipped_quantity IS NULL THEN
1830: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
1826: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
1827: END IF;
1828:
1829: IF p_x_line_rec.shipped_quantity IS NULL THEN
1830: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
1831: END IF;
1832:
1833: IF p_x_line_rec.shipped_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
1834: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1830: p_x_line_rec.shipped_quantity := FND_API.G_MISS_NUM;
1831: END IF;
1832:
1833: IF p_x_line_rec.shipped_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
1834: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1835: END IF;
1836:
1837: IF p_x_line_rec.shipping_method_code IS NULL THEN
1838: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
1834: p_x_line_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1835: END IF;
1836:
1837: IF p_x_line_rec.shipping_method_code IS NULL THEN
1838: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
1839: END IF;
1840:
1841: IF p_x_line_rec.shipping_quantity IS NULL THEN
1842: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
1838: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
1839: END IF;
1840:
1841: IF p_x_line_rec.shipping_quantity IS NULL THEN
1842: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
1843: END IF;
1844:
1845: IF p_x_line_rec.shipping_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
1846: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
1842: p_x_line_rec.shipping_quantity := FND_API.G_MISS_NUM;
1843: END IF;
1844:
1845: IF p_x_line_rec.shipping_quantity2 IS NULL THEN -- OPM B1661023 04/02/01
1846: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
1847: END IF;
1848:
1849: IF p_x_line_rec.shipping_quantity_uom IS NULL THEN
1850: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
1846: p_x_line_rec.shipping_quantity2 := FND_API.G_MISS_NUM;
1847: END IF;
1848:
1849: IF p_x_line_rec.shipping_quantity_uom IS NULL THEN
1850: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
1851: END IF;
1852:
1853: IF p_x_line_rec.ship_from_org_id IS NULL THEN
1854: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1850: p_x_line_rec.shipping_quantity_uom := FND_API.G_MISS_CHAR;
1851: END IF;
1852:
1853: IF p_x_line_rec.ship_from_org_id IS NULL THEN
1854: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1855: END IF;
1856:
1857: IF p_x_line_rec.subinventory IS NULL THEN
1858: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
1854: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
1855: END IF;
1856:
1857: IF p_x_line_rec.subinventory IS NULL THEN
1858: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
1859: END IF;
1860:
1861: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
1862: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
1858: p_x_line_rec.subinventory := FND_API.G_MISS_CHAR;
1859: END IF;
1860:
1861: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
1862: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
1863: END IF;
1864: IF p_x_line_rec.ship_set_id IS NULL THEN
1865: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
1866: END IF;
1861: IF p_x_line_rec.ship_model_complete_flag IS NULL THEN
1862: p_x_line_rec.ship_model_complete_flag := FND_API.G_MISS_CHAR;
1863: END IF;
1864: IF p_x_line_rec.ship_set_id IS NULL THEN
1865: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
1866: END IF;
1867:
1868: IF p_x_line_rec.ship_tolerance_above IS NULL THEN
1869: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
1865: p_x_line_rec.ship_set_id := FND_API.G_MISS_NUM;
1866: END IF;
1867:
1868: IF p_x_line_rec.ship_tolerance_above IS NULL THEN
1869: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
1870: END IF;
1871:
1872: IF p_x_line_rec.ship_tolerance_below IS NULL THEN
1873: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
1869: p_x_line_rec.ship_tolerance_above := FND_API.G_MISS_NUM;
1870: END IF;
1871:
1872: IF p_x_line_rec.ship_tolerance_below IS NULL THEN
1873: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
1874: END IF;
1875:
1876: IF p_x_line_rec.shippable_flag IS NULL THEN
1877: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
1873: p_x_line_rec.ship_tolerance_below := FND_API.G_MISS_NUM;
1874: END IF;
1875:
1876: IF p_x_line_rec.shippable_flag IS NULL THEN
1877: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
1878: END IF;
1879:
1880: IF p_x_line_rec.shipping_interfaced_flag IS NULL THEN
1881: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
1877: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
1878: END IF;
1879:
1880: IF p_x_line_rec.shipping_interfaced_flag IS NULL THEN
1881: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
1882: END IF;
1883:
1884: IF p_x_line_rec.ship_to_contact_id IS NULL THEN
1885: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
1881: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
1882: END IF;
1883:
1884: IF p_x_line_rec.ship_to_contact_id IS NULL THEN
1885: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
1886: END IF;
1887:
1888: IF p_x_line_rec.ship_to_org_id IS NULL THEN
1889: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1885: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
1886: END IF;
1887:
1888: IF p_x_line_rec.ship_to_org_id IS NULL THEN
1889: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1890: END IF;
1891:
1892: IF p_x_line_rec.sold_from_org_id IS NULL THEN
1893: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
1889: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
1890: END IF;
1891:
1892: IF p_x_line_rec.sold_from_org_id IS NULL THEN
1893: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
1894: END IF;
1895:
1896: IF p_x_line_rec.sold_to_org_id IS NULL THEN
1897: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
1893: p_x_line_rec.sold_from_org_id := FND_API.G_MISS_NUM;
1894: END IF;
1895:
1896: IF p_x_line_rec.sold_to_org_id IS NULL THEN
1897: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
1898: END IF;
1899:
1900: IF p_x_line_rec.sort_order IS NULL THEN
1901: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
1897: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
1898: END IF;
1899:
1900: IF p_x_line_rec.sort_order IS NULL THEN
1901: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
1902: END IF;
1903:
1904: IF p_x_line_rec.source_document_id IS NULL THEN
1905: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
1901: p_x_line_rec.sort_order := FND_API.G_MISS_CHAR;
1902: END IF;
1903:
1904: IF p_x_line_rec.source_document_id IS NULL THEN
1905: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
1906: END IF;
1907:
1908: IF p_x_line_rec.source_document_line_id IS NULL THEN
1909: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
1905: p_x_line_rec.source_document_id := FND_API.G_MISS_NUM;
1906: END IF;
1907:
1908: IF p_x_line_rec.source_document_line_id IS NULL THEN
1909: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
1910: END IF;
1911:
1912: IF p_x_line_rec.source_document_type_id IS NULL THEN
1913: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
1909: p_x_line_rec.source_document_line_id := FND_API.G_MISS_NUM;
1910: END IF;
1911:
1912: IF p_x_line_rec.source_document_type_id IS NULL THEN
1913: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
1914: END IF;
1915:
1916: IF p_x_line_rec.source_type_code IS NULL THEN
1917: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
1913: p_x_line_rec.source_document_type_id := FND_API.G_MISS_NUM;
1914: END IF;
1915:
1916: IF p_x_line_rec.source_type_code IS NULL THEN
1917: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
1918: END IF;
1919: IF p_x_line_rec.split_from_line_id IS NULL THEN
1920: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
1921: END IF;
1916: IF p_x_line_rec.source_type_code IS NULL THEN
1917: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
1918: END IF;
1919: IF p_x_line_rec.split_from_line_id IS NULL THEN
1920: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
1921: END IF;
1922: IF p_x_line_rec.line_set_id IS NULL THEN
1923: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
1924: END IF;
1919: IF p_x_line_rec.split_from_line_id IS NULL THEN
1920: p_x_line_rec.split_from_line_id := FND_API.G_MISS_NUM;
1921: END IF;
1922: IF p_x_line_rec.line_set_id IS NULL THEN
1923: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
1924: END IF;
1925:
1926: IF p_x_line_rec.split_by IS NULL THEN
1927: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
1923: p_x_line_rec.line_set_id := FND_API.G_MISS_NUM;
1924: END IF;
1925:
1926: IF p_x_line_rec.split_by IS NULL THEN
1927: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
1928: END IF;
1929: IF p_x_line_rec.model_remnant_flag IS NULL THEN
1930: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
1931: END IF;
1926: IF p_x_line_rec.split_by IS NULL THEN
1927: p_x_line_rec.split_by := FND_API.G_MISS_CHAR;
1928: END IF;
1929: IF p_x_line_rec.model_remnant_flag IS NULL THEN
1930: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
1931: END IF;
1932: IF p_x_line_rec.task_id IS NULL THEN
1933: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
1934: END IF;
1929: IF p_x_line_rec.model_remnant_flag IS NULL THEN
1930: p_x_line_rec.model_remnant_flag := FND_API.G_MISS_CHAR;
1931: END IF;
1932: IF p_x_line_rec.task_id IS NULL THEN
1933: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
1934: END IF;
1935:
1936: IF p_x_line_rec.tax_code IS NULL THEN
1937: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
1933: p_x_line_rec.task_id := FND_API.G_MISS_NUM;
1934: END IF;
1935:
1936: IF p_x_line_rec.tax_code IS NULL THEN
1937: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
1938: END IF;
1939:
1940: IF p_x_line_rec.tax_date IS NULL THEN
1941: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
1937: p_x_line_rec.tax_code := FND_API.G_MISS_CHAR;
1938: END IF;
1939:
1940: IF p_x_line_rec.tax_date IS NULL THEN
1941: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
1942: END IF;
1943:
1944: IF p_x_line_rec.tax_exempt_flag IS NULL THEN
1945: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
1941: p_x_line_rec.tax_date := FND_API.G_MISS_DATE;
1942: END IF;
1943:
1944: IF p_x_line_rec.tax_exempt_flag IS NULL THEN
1945: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
1946: END IF;
1947:
1948: IF p_x_line_rec.tax_exempt_number IS NULL THEN
1949: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
1945: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
1946: END IF;
1947:
1948: IF p_x_line_rec.tax_exempt_number IS NULL THEN
1949: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
1950: END IF;
1951:
1952: IF p_x_line_rec.tax_exempt_reason_code IS NULL THEN
1953: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
1949: p_x_line_rec.tax_exempt_number := FND_API.G_MISS_CHAR;
1950: END IF;
1951:
1952: IF p_x_line_rec.tax_exempt_reason_code IS NULL THEN
1953: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
1954: END IF;
1955:
1956: IF p_x_line_rec.tax_point_code IS NULL THEN
1957: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
1953: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
1954: END IF;
1955:
1956: IF p_x_line_rec.tax_point_code IS NULL THEN
1957: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
1958: END IF;
1959:
1960: IF p_x_line_rec.tax_rate IS NULL THEN
1961: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
1957: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
1958: END IF;
1959:
1960: IF p_x_line_rec.tax_rate IS NULL THEN
1961: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
1962: END IF;
1963:
1964: IF p_x_line_rec.tax_value IS NULL THEN
1965: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
1961: p_x_line_rec.tax_rate := FND_API.G_MISS_NUM;
1962: END IF;
1963:
1964: IF p_x_line_rec.tax_value IS NULL THEN
1965: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
1966: END IF;
1967:
1968: IF p_x_line_rec.top_model_line_id IS NULL THEN
1969: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
1965: p_x_line_rec.tax_value := FND_API.G_MISS_NUM;
1966: END IF;
1967:
1968: IF p_x_line_rec.top_model_line_id IS NULL THEN
1969: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
1970: END IF;
1971:
1972: IF p_x_line_rec.unit_list_price IS NULL THEN
1973: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
1969: p_x_line_rec.top_model_line_id := FND_API.G_MISS_NUM;
1970: END IF;
1971:
1972: IF p_x_line_rec.unit_list_price IS NULL THEN
1973: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
1974: END IF;
1975:
1976: IF p_x_line_rec.unit_list_price_per_pqty IS NULL THEN
1977: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
1973: p_x_line_rec.unit_list_price := FND_API.G_MISS_NUM;
1974: END IF;
1975:
1976: IF p_x_line_rec.unit_list_price_per_pqty IS NULL THEN
1977: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
1978: END IF;
1979:
1980: IF p_x_line_rec.unit_selling_price IS NULL THEN
1981: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
1977: p_x_line_rec.unit_list_price_per_pqty := FND_API.G_MISS_NUM;
1978: END IF;
1979:
1980: IF p_x_line_rec.unit_selling_price IS NULL THEN
1981: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
1982: END IF;
1983:
1984: IF p_x_line_rec.unit_selling_price_per_pqty IS NULL THEN
1985: p_x_line_rec.unit_selling_price_per_pqty := FND_API.G_MISS_NUM;
1981: p_x_line_rec.unit_selling_price := FND_API.G_MISS_NUM;
1982: END IF;
1983:
1984: IF p_x_line_rec.unit_selling_price_per_pqty IS NULL THEN
1985: p_x_line_rec.unit_selling_price_per_pqty := FND_API.G_MISS_NUM;
1986: END IF;
1987:
1988:
1989: IF p_x_line_rec.visible_demand_flag IS NULL THEN
1986: END IF;
1987:
1988:
1989: IF p_x_line_rec.visible_demand_flag IS NULL THEN
1990: p_x_line_rec.visible_demand_flag := FND_API.G_MISS_CHAR;
1991: END IF;
1992: IF p_x_line_rec.veh_cus_item_cum_key_id IS NULL THEN
1993: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
1994: END IF;
1989: IF p_x_line_rec.visible_demand_flag IS NULL THEN
1990: p_x_line_rec.visible_demand_flag := FND_API.G_MISS_CHAR;
1991: END IF;
1992: IF p_x_line_rec.veh_cus_item_cum_key_id IS NULL THEN
1993: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
1994: END IF;
1995:
1996: IF p_x_line_rec.first_ack_code IS NULL THEN
1997: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
1993: p_x_line_rec.veh_cus_item_cum_key_id := FND_API.G_MISS_NUM;
1994: END IF;
1995:
1996: IF p_x_line_rec.first_ack_code IS NULL THEN
1997: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
1998: END IF;
1999:
2000: IF p_x_line_rec.first_ack_date IS NULL THEN
2001: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
1997: p_x_line_rec.first_ack_code := FND_API.G_MISS_CHAR;
1998: END IF;
1999:
2000: IF p_x_line_rec.first_ack_date IS NULL THEN
2001: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
2002: END IF;
2003:
2004: IF p_x_line_rec.last_ack_code IS NULL THEN
2005: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
2001: p_x_line_rec.first_ack_date := FND_API.G_MISS_DATE;
2002: END IF;
2003:
2004: IF p_x_line_rec.last_ack_code IS NULL THEN
2005: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
2006: END IF;
2007:
2008: IF p_x_line_rec.last_ack_date IS NULL THEN
2009: p_x_line_rec.last_ack_date := FND_API.G_MISS_DATE;
2005: p_x_line_rec.last_ack_code := FND_API.G_MISS_CHAR;
2006: END IF;
2007:
2008: IF p_x_line_rec.last_ack_date IS NULL THEN
2009: p_x_line_rec.last_ack_date := FND_API.G_MISS_DATE;
2010: END IF;
2011:
2012:
2013: IF p_x_line_rec.end_item_unit_number IS NULL THEN
2010: END IF;
2011:
2012:
2013: IF p_x_line_rec.end_item_unit_number IS NULL THEN
2014: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2015: END IF;
2016:
2017: IF p_x_line_rec.shipping_instructions IS NULL THEN
2018: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
2014: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2015: END IF;
2016:
2017: IF p_x_line_rec.shipping_instructions IS NULL THEN
2018: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
2019: END IF;
2020:
2021: IF p_x_line_rec.packing_instructions IS NULL THEN
2022: p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
2018: p_x_line_rec.shipping_instructions := FND_API.G_MISS_CHAR;
2019: END IF;
2020:
2021: IF p_x_line_rec.packing_instructions IS NULL THEN
2022: p_x_line_rec.packing_instructions := FND_API.G_MISS_CHAR;
2023: END IF;
2024:
2025: -- Service related columns
2026:
2024:
2025: -- Service related columns
2026:
2027: IF p_x_line_rec.service_txn_reason_code IS NULL THEN
2028: p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
2029: END IF;
2030:
2031: IF p_x_line_rec.service_txn_comments IS NULL THEN
2032: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
2028: p_x_line_rec.service_txn_reason_code := FND_API.G_MISS_CHAR;
2029: END IF;
2030:
2031: IF p_x_line_rec.service_txn_comments IS NULL THEN
2032: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
2033: END IF;
2034:
2035: IF p_x_line_rec.service_duration IS NULL THEN
2036: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
2032: p_x_line_rec.service_txn_comments := FND_API.G_MISS_CHAR;
2033: END IF;
2034:
2035: IF p_x_line_rec.service_duration IS NULL THEN
2036: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
2037: END IF;
2038:
2039: IF p_x_line_rec.service_period IS NULL THEN
2040: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
2036: p_x_line_rec.service_duration := FND_API.G_MISS_NUM;
2037: END IF;
2038:
2039: IF p_x_line_rec.service_period IS NULL THEN
2040: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
2041: END IF;
2042:
2043: IF p_x_line_rec.service_start_date IS NULL THEN
2044: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
2040: p_x_line_rec.service_period := FND_API.G_MISS_CHAR;
2041: END IF;
2042:
2043: IF p_x_line_rec.service_start_date IS NULL THEN
2044: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
2045: END IF;
2046:
2047: IF p_x_line_rec.service_end_date IS NULL THEN
2048: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
2044: p_x_line_rec.service_start_date := FND_API.G_MISS_DATE;
2045: END IF;
2046:
2047: IF p_x_line_rec.service_end_date IS NULL THEN
2048: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
2049: END IF;
2050:
2051: IF p_x_line_rec.service_coterminate_flag IS NULL THEN
2052: p_x_line_rec.service_coterminate_flag := FND_API.G_MISS_CHAR;
2048: p_x_line_rec.service_end_date := FND_API.G_MISS_DATE;
2049: END IF;
2050:
2051: IF p_x_line_rec.service_coterminate_flag IS NULL THEN
2052: p_x_line_rec.service_coterminate_flag := FND_API.G_MISS_CHAR;
2053: END IF;
2054:
2055:
2056: IF p_x_line_rec.unit_list_percent IS NULL THEN
2053: END IF;
2054:
2055:
2056: IF p_x_line_rec.unit_list_percent IS NULL THEN
2057: p_x_line_rec.unit_list_percent := FND_API.G_MISS_NUM;
2058: END IF;
2059:
2060: IF p_x_line_rec.unit_selling_percent IS NULL THEN
2061: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
2057: p_x_line_rec.unit_list_percent := FND_API.G_MISS_NUM;
2058: END IF;
2059:
2060: IF p_x_line_rec.unit_selling_percent IS NULL THEN
2061: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
2062: END IF;
2063:
2064: IF p_x_line_rec.unit_percent_base_price IS NULL THEN
2065: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
2061: p_x_line_rec.unit_selling_percent := FND_API.G_MISS_NUM;
2062: END IF;
2063:
2064: IF p_x_line_rec.unit_percent_base_price IS NULL THEN
2065: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
2066: END IF;
2067:
2068: IF p_x_line_rec.service_number IS NULL THEN
2069: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
2065: p_x_line_rec.unit_percent_base_price := FND_API.G_MISS_NUM;
2066: END IF;
2067:
2068: IF p_x_line_rec.service_number IS NULL THEN
2069: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
2070: END IF;
2071:
2072: IF p_x_line_rec.service_reference_type_code IS NULL THEN
2073: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
2069: p_x_line_rec.service_number := FND_API.G_MISS_NUM;
2070: END IF;
2071:
2072: IF p_x_line_rec.service_reference_type_code IS NULL THEN
2073: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
2074: END IF;
2075:
2076: IF p_x_line_rec.service_reference_line_id IS NULL THEN
2077: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
2073: p_x_line_rec.service_reference_type_code := FND_API.G_MISS_CHAR;
2074: END IF;
2075:
2076: IF p_x_line_rec.service_reference_line_id IS NULL THEN
2077: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
2078: END IF;
2079:
2080: IF p_x_line_rec.service_reference_system_id IS NULL THEN
2081: p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
2077: p_x_line_rec.service_reference_line_id := FND_API.G_MISS_NUM;
2078: END IF;
2079:
2080: IF p_x_line_rec.service_reference_system_id IS NULL THEN
2081: p_x_line_rec.service_reference_system_id := FND_API.G_MISS_NUM;
2082: END IF;
2083:
2084: /* Marketing source code related */
2085:
2083:
2084: /* Marketing source code related */
2085:
2086: IF p_x_line_rec.marketing_source_code_id IS NULL THEN
2087: p_x_line_rec.marketing_source_code_id := FND_API.G_MISS_NUM;
2088: END IF;
2089:
2090: /* End of Marketing source code related */
2091:
2089:
2090: /* End of Marketing source code related */
2091:
2092: IF p_x_line_rec.order_source_id IS NULL THEN
2093: p_x_line_rec.order_source_id := FND_API.G_MISS_NUM;
2094: END IF;
2095:
2096: IF p_x_line_rec.flow_status_code IS NULL THEN
2097: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
2093: p_x_line_rec.order_source_id := FND_API.G_MISS_NUM;
2094: END IF;
2095:
2096: IF p_x_line_rec.flow_status_code IS NULL THEN
2097: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
2098: END IF;
2099:
2100: -- Commitment related
2101: IF p_x_line_rec.commitment_id IS NULL THEN
2098: END IF;
2099:
2100: -- Commitment related
2101: IF p_x_line_rec.commitment_id IS NULL THEN
2102: p_x_line_rec.commitment_id := FND_API.G_MISS_NUM;
2103: END IF;
2104:
2105:
2106: -- Item Substitution changes.
2104:
2105:
2106: -- Item Substitution changes.
2107: IF p_x_line_rec.Original_Inventory_Item_Id IS NULL THEN
2108: p_x_line_rec.Original_Inventory_Item_Id := FND_API.G_MISS_NUM;
2109: END IF;
2110:
2111: IF p_x_line_rec.Original_item_identifier_Type IS NULL THEN
2112: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
2108: p_x_line_rec.Original_Inventory_Item_Id := FND_API.G_MISS_NUM;
2109: END IF;
2110:
2111: IF p_x_line_rec.Original_item_identifier_Type IS NULL THEN
2112: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
2113: END IF;
2114:
2115: IF p_x_line_rec.Original_ordered_item_id IS NULL THEN
2116: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
2112: p_x_line_rec.Original_item_identifier_Type := FND_API.G_MISS_CHAR;
2113: END IF;
2114:
2115: IF p_x_line_rec.Original_ordered_item_id IS NULL THEN
2116: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
2117: END IF;
2118:
2119: IF p_x_line_rec.Original_ordered_item IS NULL THEN
2120: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
2116: p_x_line_rec.Original_ordered_item_id := FND_API.G_MISS_NUM;
2117: END IF;
2118:
2119: IF p_x_line_rec.Original_ordered_item IS NULL THEN
2120: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
2121: END IF;
2122:
2123: IF p_x_line_rec.item_relationship_type IS NULL THEN
2124: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
2120: p_x_line_rec.Original_ordered_item := FND_API.G_MISS_CHAR;
2121: END IF;
2122:
2123: IF p_x_line_rec.item_relationship_type IS NULL THEN
2124: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
2125: END IF;
2126:
2127: IF p_x_line_rec.Item_substitution_type_code IS NULL THEN
2128: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
2124: p_x_line_rec.item_relationship_type := FND_API.G_MISS_NUM;
2125: END IF;
2126:
2127: IF p_x_line_rec.Item_substitution_type_code IS NULL THEN
2128: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
2129: END IF;
2130:
2131: IF p_x_line_rec.Late_Demand_Penalty_Factor IS NULL THEN
2132: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
2128: p_x_line_rec.Item_substitution_type_code := FND_API.G_MISS_CHAR;
2129: END IF;
2130:
2131: IF p_x_line_rec.Late_Demand_Penalty_Factor IS NULL THEN
2132: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
2133: END IF;
2134:
2135: IF p_x_line_rec.Override_atp_date_code IS NULL THEN
2136: p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
2132: p_x_line_rec.Late_Demand_Penalty_Factor := FND_API.G_MISS_NUM;
2133: END IF;
2134:
2135: IF p_x_line_rec.Override_atp_date_code IS NULL THEN
2136: p_x_line_rec.Override_atp_date_code := FND_API.G_MISS_CHAR;
2137: END IF;
2138:
2139: -- Changes for Blanket Orders
2140:
2138:
2139: -- Changes for Blanket Orders
2140:
2141: IF p_x_line_rec.Blanket_Number IS NULL THEN
2142: p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
2143: END IF;
2144:
2145: IF p_x_line_rec.Blanket_Line_Number IS NULL THEN
2146: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
2142: p_x_line_rec.Blanket_Number := FND_API.G_MISS_NUM;
2143: END IF;
2144:
2145: IF p_x_line_rec.Blanket_Line_Number IS NULL THEN
2146: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
2147: END IF;
2148:
2149: IF p_x_line_rec.Blanket_Version_Number IS NULL THEN
2150: p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
2146: p_x_line_rec.Blanket_Line_Number := FND_API.G_MISS_NUM;
2147: END IF;
2148:
2149: IF p_x_line_rec.Blanket_Version_Number IS NULL THEN
2150: p_x_line_rec.Blanket_Version_Number := FND_API.G_MISS_NUM;
2151: END IF;
2152:
2153: -- QUOTING changes
2154: IF p_x_line_rec.transaction_phase_code IS NULL THEN
2151: END IF;
2152:
2153: -- QUOTING changes
2154: IF p_x_line_rec.transaction_phase_code IS NULL THEN
2155: p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
2156: END IF;
2157:
2158: IF p_x_line_rec.source_document_version_number IS NULL THEN
2159: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
2155: p_x_line_rec.transaction_phase_code := FND_API.G_MISS_CHAR;
2156: END IF;
2157:
2158: IF p_x_line_rec.source_document_version_number IS NULL THEN
2159: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
2160: END IF;
2161: -- END QUOTING changes
2162: IF p_x_line_rec.Minisite_id IS NULL THEN
2163: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
2159: p_x_line_rec.source_document_version_number := FND_API.G_MISS_NUM;
2160: END IF;
2161: -- END QUOTING changes
2162: IF p_x_line_rec.Minisite_id IS NULL THEN
2163: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
2164: END IF;
2165:
2166: IF p_x_line_rec.End_customer_id IS NULL THEN
2167: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
2163: p_x_line_rec.Minisite_id := FND_API.G_MISS_NUM;
2164: END IF;
2165:
2166: IF p_x_line_rec.End_customer_id IS NULL THEN
2167: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
2168: END IF;
2169:
2170: IF p_x_line_rec.End_customer_contact_id IS NULL THEN
2171: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
2167: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
2168: END IF;
2169:
2170: IF p_x_line_rec.End_customer_contact_id IS NULL THEN
2171: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
2172: END IF;
2173:
2174: IF p_x_line_rec.End_customer_site_use_id IS NULL THEN
2175: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
2171: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
2172: END IF;
2173:
2174: IF p_x_line_rec.End_customer_site_use_id IS NULL THEN
2175: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
2176: END IF;
2177:
2178: IF p_x_line_rec.ib_owner IS NULL THEN
2179: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
2175: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
2176: END IF;
2177:
2178: IF p_x_line_rec.ib_owner IS NULL THEN
2179: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
2180: END IF;
2181:
2182: IF p_x_line_rec.ib_installed_at_location IS NULL THEN
2183: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
2179: p_x_line_rec.ib_owner := FND_API.G_MISS_CHAR;
2180: END IF;
2181:
2182: IF p_x_line_rec.ib_installed_at_location IS NULL THEN
2183: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
2184: END IF;
2185:
2186: IF p_x_line_rec.ib_current_location IS NULL THEN
2187: p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
2183: p_x_line_rec.ib_installed_at_location := FND_API.G_MISS_CHAR;
2184: END IF;
2185:
2186: IF p_x_line_rec.ib_current_location IS NULL THEN
2187: p_x_line_rec.ib_current_location := FND_API.G_MISS_CHAR;
2188: END IF;
2189:
2190: --retro{
2191: IF p_x_line_rec.retrobill_request_id IS NULL THEN
2188: END IF;
2189:
2190: --retro{
2191: IF p_x_line_rec.retrobill_request_id IS NULL THEN
2192: p_x_line_rec.retrobill_request_id := FND_API.G_MISS_NUM;
2193: END IF;
2194: --retro}
2195:
2196: IF p_x_line_rec.firm_demand_flag IS NULL THEN
2193: END IF;
2194: --retro}
2195:
2196: IF p_x_line_rec.firm_demand_flag IS NULL THEN
2197: p_x_line_rec.firm_demand_flag := FND_API.G_MISS_CHAR;
2198: END IF;
2199:
2200: --key Transaction Dates
2201: IF p_x_line_rec.order_firmed_date IS NULL THEN
2198: END IF;
2199:
2200: --key Transaction Dates
2201: IF p_x_line_rec.order_firmed_date IS NULL THEN
2202: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
2203: END IF;
2204:
2205: IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
2206: p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
2202: p_x_line_rec.order_firmed_date := FND_API.G_MISS_DATE;
2203: END IF;
2204:
2205: IF p_x_line_rec.actual_fulfillment_date IS NULL THEN
2206: p_x_line_rec.actual_fulfillment_date := FND_API.G_MISS_DATE;
2207: END IF;
2208: --end
2209:
2210: /* IF p_x_line_rec.supplier_signature IS NULL THEN
2207: END IF;
2208: --end
2209:
2210: /* IF p_x_line_rec.supplier_signature IS NULL THEN
2211: p_x_line_rec.supplier_signature := FND_API.G_MISS_CHAR;
2212: END IF;
2213:
2214: IF p_x_line_rec.supplier_signature_date IS NULL THEN
2215: p_x_line_rec.supplier_signature_date := FND_API.G_MISS_DATE;
2211: p_x_line_rec.supplier_signature := FND_API.G_MISS_CHAR;
2212: END IF;
2213:
2214: IF p_x_line_rec.supplier_signature_date IS NULL THEN
2215: p_x_line_rec.supplier_signature_date := FND_API.G_MISS_DATE;
2216: END IF;
2217:
2218: IF p_x_line_rec.customer_signature IS NULL THEN
2219: p_x_line_rec.customer_signature := FND_API.G_MISS_CHAR;
2215: p_x_line_rec.supplier_signature_date := FND_API.G_MISS_DATE;
2216: END IF;
2217:
2218: IF p_x_line_rec.customer_signature IS NULL THEN
2219: p_x_line_rec.customer_signature := FND_API.G_MISS_CHAR;
2220: END IF;
2221:
2222: IF p_x_line_rec.customer_signature_date IS NULL THEN
2223: p_x_line_rec.customer_signature_date := FND_API.G_MISS_CHAR;
2219: p_x_line_rec.customer_signature := FND_API.G_MISS_CHAR;
2220: END IF;
2221:
2222: IF p_x_line_rec.customer_signature_date IS NULL THEN
2223: p_x_line_rec.customer_signature_date := FND_API.G_MISS_CHAR;
2224: END IF;
2225: */
2226:
2227: if l_debug_level > 0 then