174: END IF;
175:
176: UPDATE ego_aml_intf
177: SET mrp_planning_code =
178: DECODE(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
179: mrp_planning_code),
180: description =
181: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
182: description),
177: SET mrp_planning_code =
178: DECODE(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
179: mrp_planning_code),
180: description =
181: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
182: description),
183: attribute_category =
184: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
185: attribute_category),
180: description =
181: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
182: description),
183: attribute_category =
184: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
185: attribute_category),
186: attribute1 =
187: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
188: attribute1),
183: attribute_category =
184: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
185: attribute_category),
186: attribute1 =
187: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
188: attribute1),
189: attribute2 =
190: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
191: attribute2),
186: attribute1 =
187: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
188: attribute1),
189: attribute2 =
190: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
191: attribute2),
192: attribute3 =
193: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
194: attribute3),
189: attribute2 =
190: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
191: attribute2),
192: attribute3 =
193: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
194: attribute3),
195: attribute4 =
196: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
197: attribute4),
192: attribute3 =
193: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
194: attribute3),
195: attribute4 =
196: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
197: attribute4),
198: attribute5 =
199: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
200: attribute5),
195: attribute4 =
196: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
197: attribute4),
198: attribute5 =
199: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
200: attribute5),
201: attribute6 =
202: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
203: attribute6),
198: attribute5 =
199: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
200: attribute5),
201: attribute6 =
202: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
203: attribute6),
204: attribute7 =
205: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
206: attribute7),
201: attribute6 =
202: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
203: attribute6),
204: attribute7 =
205: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
206: attribute7),
207: attribute8 =
208: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
209: attribute8),
204: attribute7 =
205: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
206: attribute7),
207: attribute8 =
208: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
209: attribute8),
210: attribute9 =
211: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
212: attribute9),
207: attribute8 =
208: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
209: attribute8),
210: attribute9 =
211: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
212: attribute9),
213: attribute10 =
214: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
215: attribute10),
210: attribute9 =
211: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
212: attribute9),
213: attribute10 =
214: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
215: attribute10),
216: attribute11 =
217: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
218: attribute11),
213: attribute10 =
214: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
215: attribute10),
216: attribute11 =
217: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
218: attribute11),
219: attribute12 =
220: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
221: attribute12),
216: attribute11 =
217: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
218: attribute11),
219: attribute12 =
220: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
221: attribute12),
222: attribute13 =
223: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
224: attribute13),
219: attribute12 =
220: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
221: attribute12),
222: attribute13 =
223: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
224: attribute13),
225: attribute14 =
226: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
227: attribute14),
222: attribute13 =
223: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
224: attribute13),
225: attribute14 =
226: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
227: attribute14),
228: attribute15 =
229: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
230: attribute15),
225: attribute14 =
226: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
227: attribute14),
228: attribute15 =
229: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
230: attribute15),
231: first_article_status =
232: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
233: first_article_status),
228: attribute15 =
229: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
230: attribute15),
231: first_article_status =
232: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
233: first_article_status),
234: approval_status =
235: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
236: approval_status),
231: first_article_status =
232: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
233: first_article_status),
234: approval_status =
235: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
236: approval_status),
237: start_date =
238: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
239: start_date),
234: approval_status =
235: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
236: approval_status),
237: start_date =
238: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
239: start_date),
240: end_date =
241: DECODE(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
242: end_date),
237: start_date =
238: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
239: start_date),
240: end_date =
241: DECODE(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
242: end_date),
243: process_flag = NVL(p_pf_after_population,process_flag)
244: WHERE data_set_id = p_data_set_id
245: AND process_flag = p_pf_to_process
242: end_date),
243: process_flag = NVL(p_pf_after_population,process_flag)
244: WHERE data_set_id = p_data_set_id
245: AND process_flag = p_pf_to_process
246: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
247: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
248: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
249: OR
250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
243: process_flag = NVL(p_pf_after_population,process_flag)
244: WHERE data_set_id = p_data_set_id
245: AND process_flag = p_pf_to_process
246: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
247: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
248: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
249: OR
250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
251: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
244: WHERE data_set_id = p_data_set_id
245: AND process_flag = p_pf_to_process
246: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
247: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
248: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
249: OR
250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
251: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
252: OR
246: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE
247: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
248: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
249: OR
250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
251: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
252: OR
253: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
254: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
247: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
248: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
249: OR
250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
251: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
252: OR
253: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
254: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
255: OR
249: OR
250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
251: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
252: OR
253: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
254: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
255: OR
256: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
257: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
251: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
252: OR
253: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
254: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
255: OR
256: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
257: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
258: OR
252: OR
253: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
254: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
255: OR
256: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
257: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
258: OR
259: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
260: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
253: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
254: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
255: OR
256: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
257: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
258: OR
259: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
260: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
261: OR
255: OR
256: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
257: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
258: OR
259: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
260: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
261: OR
262: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
263: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
256: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
257: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
258: OR
259: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
260: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
261: OR
262: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
263: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
264: OR
258: OR
259: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
260: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
261: OR
262: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
263: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
264: OR
265: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
266: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
259: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
260: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
261: OR
262: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
263: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
264: OR
265: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
266: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
267: OR
261: OR
262: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
263: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
264: OR
265: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
266: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
267: OR
268: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
269: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
262: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
263: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
264: OR
265: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
266: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
267: OR
268: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
269: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
270: OR
264: OR
265: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
266: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
267: OR
268: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
269: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
270: OR
271: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
272: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
265: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
266: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
267: OR
268: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
269: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
270: OR
271: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
272: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
273: OR
267: OR
268: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
269: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
270: OR
271: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
272: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
273: OR
274: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
275: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
268: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
269: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
270: OR
271: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
272: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
273: OR
274: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
275: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
276: OR
270: OR
271: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
272: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
273: OR
274: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
275: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
276: OR
277: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
278: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
271: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
272: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
273: OR
274: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
275: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
276: OR
277: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
278: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
279: OR
273: OR
274: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
275: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
276: OR
277: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
278: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
279: OR
280: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
281: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
274: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
275: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
276: OR
277: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
278: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
279: OR
280: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
281: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
282: OR
276: OR
277: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
278: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
279: OR
280: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
281: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
282: OR
283: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
284: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
277: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
278: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
279: OR
280: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
281: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
282: OR
283: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
284: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
285: OR
279: OR
280: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
281: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
282: OR
283: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
284: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
285: OR
286: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
287: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
280: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
281: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
282: OR
283: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
284: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
285: OR
286: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
287: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
288: OR
282: OR
283: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
284: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
285: OR
286: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
287: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
288: OR
289: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
290: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
283: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
284: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
285: OR
286: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
287: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
288: OR
289: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
290: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
291: OR
285: OR
286: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
287: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
288: OR
289: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
290: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
291: OR
292: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
293: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
286: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
287: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
288: OR
289: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
290: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
291: OR
292: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
293: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
294: OR
288: OR
289: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
290: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
291: OR
292: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
293: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
294: OR
295: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
296: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
289: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
290: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
291: OR
292: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
293: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
294: OR
295: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
296: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
297: OR
291: OR
292: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
293: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
294: OR
295: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
296: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
297: OR
298: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
299: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
292: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
293: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
294: OR
295: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
296: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
297: OR
298: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
299: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
300: OR
294: OR
295: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
296: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
297: OR
298: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
299: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
300: OR
301: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
302: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
295: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
296: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
297: OR
298: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
299: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
300: OR
301: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
302: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
303: OR
297: OR
298: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
299: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
300: OR
301: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
302: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
303: OR
304: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
298: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
299: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
300: OR
301: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
302: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
303: OR
304: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
306: OR
300: OR
301: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
302: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
303: OR
304: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
306: OR
307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
308: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
301: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
302: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
303: OR
304: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
306: OR
307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
308: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
309: OR
303: OR
304: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
306: OR
307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
308: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
309: OR
310: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
311: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
304: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
306: OR
307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
308: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
309: OR
310: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
311: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
312: );
306: OR
307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
308: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
309: OR
310: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
311: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
312: );
313: log_now(p_log_level => G_DEBUG_LEVEL_STATEMENT
314: ,p_module => l_api_name
307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
308: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
309: OR
310: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
311: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
312: );
313: log_now(p_log_level => G_DEBUG_LEVEL_STATEMENT
314: ,p_module => l_api_name
315: ,p_message => 'Changing intf table with NULL during CREATE'
340: ,end_date
341: ,process_flag
342: )
343: = (SELECT
344: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
345: NULL,prod.mrp_planning_code,
346: intf.mrp_planning_code),
347: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
348: NULL,prod.description,
343: = (SELECT
344: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,
345: NULL,prod.mrp_planning_code,
346: intf.mrp_planning_code),
347: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
348: NULL,prod.description,
349: intf.description),
350: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
351: NULL,prod.attribute_category,
346: intf.mrp_planning_code),
347: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
348: NULL,prod.description,
349: intf.description),
350: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
351: NULL,prod.attribute_category,
352: intf.attribute_category),
353: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
354: NULL,prod.attribute1,
349: intf.description),
350: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
351: NULL,prod.attribute_category,
352: intf.attribute_category),
353: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
354: NULL,prod.attribute1,
355: intf.attribute1),
356: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
357: NULL,prod.attribute2,
352: intf.attribute_category),
353: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
354: NULL,prod.attribute1,
355: intf.attribute1),
356: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
357: NULL,prod.attribute2,
358: intf.attribute2),
359: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
360: NULL,prod.attribute3,
355: intf.attribute1),
356: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
357: NULL,prod.attribute2,
358: intf.attribute2),
359: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
360: NULL,prod.attribute3,
361: intf.attribute3),
362: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
363: NULL,prod.attribute4,
358: intf.attribute2),
359: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
360: NULL,prod.attribute3,
361: intf.attribute3),
362: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
363: NULL,prod.attribute4,
364: intf.attribute4),
365: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
366: NULL,prod.attribute5,
361: intf.attribute3),
362: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
363: NULL,prod.attribute4,
364: intf.attribute4),
365: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
366: NULL,prod.attribute5,
367: intf.attribute5),
368: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
369: NULL,prod.attribute6,
364: intf.attribute4),
365: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
366: NULL,prod.attribute5,
367: intf.attribute5),
368: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
369: NULL,prod.attribute6,
370: intf.attribute6),
371: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
372: NULL,prod.attribute7,
367: intf.attribute5),
368: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
369: NULL,prod.attribute6,
370: intf.attribute6),
371: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
372: NULL,prod.attribute7,
373: intf.attribute7),
374: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
375: NULL,prod.attribute8,
370: intf.attribute6),
371: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
372: NULL,prod.attribute7,
373: intf.attribute7),
374: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
375: NULL,prod.attribute8,
376: intf.attribute8),
377: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
378: NULL,prod.attribute9,
373: intf.attribute7),
374: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
375: NULL,prod.attribute8,
376: intf.attribute8),
377: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
378: NULL,prod.attribute9,
379: intf.attribute9),
380: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
381: NULL,prod.attribute10,
376: intf.attribute8),
377: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
378: NULL,prod.attribute9,
379: intf.attribute9),
380: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
381: NULL,prod.attribute10,
382: intf.attribute10),
383: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
384: NULL,prod.attribute11,
379: intf.attribute9),
380: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
381: NULL,prod.attribute10,
382: intf.attribute10),
383: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
384: NULL,prod.attribute11,
385: intf.attribute11),
386: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
387: NULL,prod.attribute12,
382: intf.attribute10),
383: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
384: NULL,prod.attribute11,
385: intf.attribute11),
386: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
387: NULL,prod.attribute12,
388: intf.attribute12),
389: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
390: NULL,prod.attribute13,
385: intf.attribute11),
386: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
387: NULL,prod.attribute12,
388: intf.attribute12),
389: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
390: NULL,prod.attribute13,
391: intf.attribute13),
392: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
393: NULL,prod.attribute14,
388: intf.attribute12),
389: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
390: NULL,prod.attribute13,
391: intf.attribute13),
392: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
393: NULL,prod.attribute14,
394: intf.attribute14),
395: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
396: NULL,prod.attribute15,
391: intf.attribute13),
392: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
393: NULL,prod.attribute14,
394: intf.attribute14),
395: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
396: NULL,prod.attribute15,
397: intf.attribute15),
398: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
399: NULL,prod.first_article_status,
394: intf.attribute14),
395: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
396: NULL,prod.attribute15,
397: intf.attribute15),
398: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
399: NULL,prod.first_article_status,
400: intf.first_article_status),
401: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
402: NULL,prod.approval_status,
397: intf.attribute15),
398: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
399: NULL,prod.first_article_status,
400: intf.first_article_status),
401: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
402: NULL,prod.approval_status,
403: intf.approval_status),
404: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
405: NULL,prod.start_date,
400: intf.first_article_status),
401: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,
402: NULL,prod.approval_status,
403: intf.approval_status),
404: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
405: NULL,prod.start_date,
406: intf.start_date),
407: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
408: NULL,prod.end_date,
403: intf.approval_status),
404: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
405: NULL,prod.start_date,
406: intf.start_date),
407: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,
408: NULL,prod.end_date,
409: intf.end_date),
410: NVL(p_pf_after_population,p_pf_to_process)
411: FROM mtl_mfg_part_numbers prod
415: AND intf.mfg_part_num = prod.mfg_part_num
416: )
417: WHERE data_set_id = p_data_set_id
418: AND process_flag = p_pf_to_process
419: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
420: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
421: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
422: OR
423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
416: )
417: WHERE data_set_id = p_data_set_id
418: AND process_flag = p_pf_to_process
419: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
420: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
421: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
422: OR
423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
424: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
417: WHERE data_set_id = p_data_set_id
418: AND process_flag = p_pf_to_process
419: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
420: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
421: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
422: OR
423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
424: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
425: OR
419: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE
420: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
421: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
422: OR
423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
424: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
425: OR
426: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
427: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
420: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)
421: <> EGO_ITEM_PUB.G_INTF_NULL_NUM
422: OR
423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
424: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
425: OR
426: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
427: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
428: OR
422: OR
423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
424: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
425: OR
426: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
427: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
428: OR
429: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
430: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
424: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
425: OR
426: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
427: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
428: OR
429: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
430: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
431: OR
425: OR
426: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
427: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
428: OR
429: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
430: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
431: OR
432: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
433: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
426: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
427: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
428: OR
429: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
430: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
431: OR
432: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
433: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
434: OR
428: OR
429: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
430: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
431: OR
432: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
433: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
434: OR
435: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
436: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
429: NVL(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
430: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
431: OR
432: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
433: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
434: OR
435: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
436: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
437: OR
431: OR
432: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
433: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
434: OR
435: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
436: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
437: OR
438: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
439: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
432: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
433: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
434: OR
435: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
436: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
437: OR
438: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
439: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
440: OR
434: OR
435: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
436: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
437: OR
438: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
439: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
440: OR
441: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
442: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
435: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
436: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
437: OR
438: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
439: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
440: OR
441: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
442: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
443: OR
437: OR
438: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
439: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
440: OR
441: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
442: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
443: OR
444: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
445: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
438: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
439: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
440: OR
441: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
442: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
443: OR
444: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
445: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
446: OR
440: OR
441: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
442: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
443: OR
444: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
445: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
446: OR
447: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
448: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
441: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
442: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
443: OR
444: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
445: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
446: OR
447: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
448: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
449: OR
443: OR
444: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
445: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
446: OR
447: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
448: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
449: OR
450: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
451: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
444: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
445: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
446: OR
447: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
448: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
449: OR
450: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
451: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
452: OR
446: OR
447: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
448: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
449: OR
450: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
451: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
452: OR
453: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
454: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
447: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
448: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
449: OR
450: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
451: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
452: OR
453: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
454: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
455: OR
449: OR
450: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
451: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
452: OR
453: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
454: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
455: OR
456: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
457: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
450: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
451: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
452: OR
453: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
454: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
455: OR
456: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
457: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
458: OR
452: OR
453: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
454: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
455: OR
456: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
457: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
458: OR
459: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
460: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
453: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
454: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
455: OR
456: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
457: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
458: OR
459: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
460: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
461: OR
455: OR
456: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
457: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
458: OR
459: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
460: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
461: OR
462: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
463: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
456: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
457: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
458: OR
459: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
460: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
461: OR
462: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
463: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
464: OR
458: OR
459: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
460: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
461: OR
462: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
463: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
464: OR
465: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
466: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
459: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
460: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
461: OR
462: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
463: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
464: OR
465: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
466: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
467: OR
461: OR
462: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
463: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
464: OR
465: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
466: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
467: OR
468: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
469: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
462: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
463: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
464: OR
465: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
466: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
467: OR
468: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
469: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
470: OR
464: OR
465: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
466: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
467: OR
468: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
469: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
470: OR
471: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
472: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
465: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
466: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
467: OR
468: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
469: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
470: OR
471: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
472: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
473: OR
467: OR
468: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
469: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
470: OR
471: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
472: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
473: OR
474: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
475: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
468: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
469: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
470: OR
471: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
472: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
473: OR
474: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
475: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
476: OR
470: OR
471: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
472: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
473: OR
474: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
475: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
476: OR
477: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
471: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
472: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
473: OR
474: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
475: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
476: OR
477: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
479: OR
473: OR
474: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
475: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
476: OR
477: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
479: OR
480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
481: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
474: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
475: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
476: OR
477: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
479: OR
480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
481: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
482: OR
476: OR
477: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
479: OR
480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
481: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
482: OR
483: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
484: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
477: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR
479: OR
480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
481: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
482: OR
483: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
484: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
485: );
479: OR
480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
481: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
482: OR
483: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
484: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
485: );
486: log_now(p_log_level => G_DEBUG_LEVEL_STATEMENT
487: ,p_module => l_api_name
480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
481: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
482: OR
483: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
484: <> EGO_ITEM_PUB.G_INTF_NULL_DATE
485: );
486: log_now(p_log_level => G_DEBUG_LEVEL_STATEMENT
487: ,p_module => l_api_name
488: ,p_message => 'Populate intf table with prod data for UPDATE done'