DBA Data[Home] [Help]

APPS.EGO_ITEM_AML_GRP dependencies on EGO_ITEM_PUB

Line 178: DECODE(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,

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),

Line 181: DECODE(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 184: DECODE(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 187: DECODE(attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 190: DECODE(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 193: DECODE(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 196: DECODE(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 199: DECODE(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 202: DECODE(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 205: DECODE(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 208: DECODE(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 211: DECODE(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 214: DECODE(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 217: DECODE(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 220: DECODE(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 223: DECODE(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 226: DECODE(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 229: DECODE(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 232: DECODE(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 235: DECODE(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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),

Line 238: DECODE(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

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),

Line 241: DECODE(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

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

Line 246: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_CREATE

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)

Line 247: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM)

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

Line 248: <> EGO_ITEM_PUB.G_INTF_NULL_NUM

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

Line 250: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

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

Line 251: <> 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

Line 253: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

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

Line 254: <> 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

Line 256: NVL(attribute1,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
259: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
260: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 257: <> 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

Line 259: NVL(attribute2,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
262: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
263: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 260: <> 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

Line 262: NVL(attribute3,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
265: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
266: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 263: <> 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

Line 265: NVL(attribute4,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
268: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
269: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 266: <> 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

Line 268: NVL(attribute5,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
271: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
272: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 269: <> 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

Line 271: NVL(attribute6,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
274: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
275: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 272: <> 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

Line 274: NVL(attribute7,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
277: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
278: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 275: <> 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

Line 277: NVL(attribute8,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
280: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
281: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 278: <> 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

Line 280: NVL(attribute9,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
283: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
284: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 281: <> 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

Line 283: NVL(attribute10,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
286: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
287: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 284: <> 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

Line 286: NVL(attribute11,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
289: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
290: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 287: <> 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

Line 289: NVL(attribute12,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
292: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
293: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 290: <> 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

Line 292: NVL(attribute13,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
295: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
296: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 293: <> 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

Line 295: NVL(attribute14,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
298: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
299: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 296: <> 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

Line 298: NVL(attribute15,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
301: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
302: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 299: <> 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

Line 301: NVL(first_article_status,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
304: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 302: <> 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

Line 304: NVL(approval_status,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
307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
308: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 305: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

Line 307: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

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

Line 308: <> 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: );

Line 310: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

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

Line 311: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

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'

Line 344: DECODE(intf.mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_NUM,NULL,

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,

Line 347: DECODE(intf.description,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 350: DECODE(intf.attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 353: DECODE(intf.attribute1,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 356: DECODE(intf.attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 359: DECODE(intf.attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 362: DECODE(intf.attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 365: DECODE(intf.attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 368: DECODE(intf.attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 371: DECODE(intf.attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 374: DECODE(intf.attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 377: DECODE(intf.attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 380: DECODE(intf.attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 383: DECODE(intf.attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 386: DECODE(intf.attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 389: DECODE(intf.attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 392: DECODE(intf.attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 395: DECODE(intf.attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 398: DECODE(intf.first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 401: DECODE(intf.approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR,NULL,

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,

Line 404: DECODE(intf.start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

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,

Line 407: DECODE(intf.end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE,NULL,

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

Line 419: AND transaction_type = EGO_ITEM_PUB.G_TTYPE_UPDATE

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)

Line 420: AND ( NVL(mrp_planning_code,EGO_ITEM_PUB.G_INTF_NULL_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)
424: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 421: <> EGO_ITEM_PUB.G_INTF_NULL_NUM

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

Line 423: NVL(description,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

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

Line 424: <> 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

Line 426: NVL(attribute_category,EGO_ITEM_PUB.G_INTF_NULL_CHAR)

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

Line 427: <> 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

Line 429: NVL(attribute1,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
432: NVL(attribute2,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
433: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 430: <> 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

Line 432: NVL(attribute2,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
435: NVL(attribute3,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
436: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 433: <> 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

Line 435: NVL(attribute3,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
438: NVL(attribute4,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
439: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 436: <> 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

Line 438: NVL(attribute4,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
441: NVL(attribute5,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
442: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 439: <> 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

Line 441: NVL(attribute5,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
444: NVL(attribute6,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
445: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 442: <> 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

Line 444: NVL(attribute6,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
447: NVL(attribute7,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
448: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 445: <> 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

Line 447: NVL(attribute7,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
450: NVL(attribute8,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
451: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 448: <> 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

Line 450: NVL(attribute8,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
453: NVL(attribute9,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
454: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 451: <> 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

Line 453: NVL(attribute9,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
456: NVL(attribute10,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
457: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 454: <> 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

Line 456: NVL(attribute10,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
459: NVL(attribute11,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
460: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 457: <> 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

Line 459: NVL(attribute11,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
462: NVL(attribute12,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
463: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 460: <> 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

Line 462: NVL(attribute12,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
465: NVL(attribute13,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
466: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 463: <> 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

Line 465: NVL(attribute13,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
468: NVL(attribute14,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
469: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 466: <> 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

Line 468: NVL(attribute14,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
471: NVL(attribute15,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
472: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 469: <> 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

Line 471: NVL(attribute15,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
474: NVL(first_article_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
475: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 472: <> 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

Line 474: NVL(first_article_status,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
477: NVL(approval_status,EGO_ITEM_PUB.G_INTF_NULL_CHAR)
478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

Line 475: <> 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

Line 477: NVL(approval_status,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
480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)
481: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

Line 478: <> EGO_ITEM_PUB.G_INTF_NULL_CHAR

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

Line 480: NVL(start_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

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

Line 481: <> 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: );

Line 483: NVL(end_date,EGO_ITEM_PUB.G_INTF_NULL_DATE)

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

Line 484: <> EGO_ITEM_PUB.G_INTF_NULL_DATE

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'