463: line_part_number VARCHAR2(80);
464: line_part_attrib_category VARCHAR2(80);
465:
466: -- bug 6511409
467: line_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
468: line_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
469: line_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
464: line_part_attrib_category VARCHAR2(80);
465:
466: -- bug 6511409
467: line_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
468: line_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
469: line_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
465:
466: -- bug 6511409
467: line_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
468: line_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
469: line_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
466: -- bug 6511409
467: line_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
468: line_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
469: line_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
467: line_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
468: line_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
469: line_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
468: line_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
469: line_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
469: line_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
470: line_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
471: line_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
479: line_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
472: line_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
479: line_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
480: line_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
473: line_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
479: line_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
480: line_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
481: line_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
474: line_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
479: line_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
480: line_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
481: line_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
482:
475: line_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
479: line_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
480: line_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
481: line_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
482:
483: d_dummy_date DATE;
476: line_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
479: line_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
480: line_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
481: line_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
482:
483: d_dummy_date DATE;
484:
477: line_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
478: line_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
479: line_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
480: line_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
481: line_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
482:
483: d_dummy_date DATE;
484:
485: iMap_ID NUMBER;