451: cline_part_number VARCHAR2(80);
452: cline_part_attrib_category VARCHAR2(80);
453:
454: -- bug 6511409
455: cline_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
456: cline_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
457: cline_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
452: cline_part_attrib_category VARCHAR2(80);
453:
454: -- bug 6511409
455: cline_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
456: cline_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
457: cline_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
453:
454: -- bug 6511409
455: cline_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
456: cline_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
457: cline_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
454: -- bug 6511409
455: cline_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
456: cline_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
457: cline_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
455: cline_part_attribute1 MTL_ITEM_FLEXFIELDS.ATTRIBUTE1%TYPE;
456: cline_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
457: cline_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
456: cline_part_attribute2 MTL_ITEM_FLEXFIELDS.ATTRIBUTE2%TYPE;
457: cline_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
457: cline_part_attribute3 MTL_ITEM_FLEXFIELDS.ATTRIBUTE3%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
458: cline_part_attribute4 MTL_ITEM_FLEXFIELDS.ATTRIBUTE4%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
459: cline_part_attribute5 MTL_ITEM_FLEXFIELDS.ATTRIBUTE5%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
467: cline_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
460: cline_part_attribute6 MTL_ITEM_FLEXFIELDS.ATTRIBUTE6%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
467: cline_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
468: cline_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
461: cline_part_attribute7 MTL_ITEM_FLEXFIELDS.ATTRIBUTE7%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
467: cline_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
468: cline_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
469: cline_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
462: cline_part_attribute8 MTL_ITEM_FLEXFIELDS.ATTRIBUTE8%TYPE;
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
467: cline_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
468: cline_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
469: cline_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
470:
463: cline_part_attribute9 MTL_ITEM_FLEXFIELDS.ATTRIBUTE9%TYPE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
467: cline_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
468: cline_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
469: cline_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
470:
471: d_dummy_date DATE;
464: cline_part_attribute10 MTL_ITEM_FLEXFIELDS.ATTRIBUTE10%TYPE;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
467: cline_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
468: cline_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
469: cline_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
470:
471: d_dummy_date DATE;
472: counter NUMBER;
465: cline_part_attribute11 MTL_ITEM_FLEXFIELDS.ATTRIBUTE11%TYPE;
466: cline_part_attribute12 MTL_ITEM_FLEXFIELDS.ATTRIBUTE12%TYPE;
467: cline_part_attribute13 MTL_ITEM_FLEXFIELDS.ATTRIBUTE13%TYPE;
468: cline_part_attribute14 MTL_ITEM_FLEXFIELDS.ATTRIBUTE14%TYPE;
469: cline_part_attribute15 MTL_ITEM_FLEXFIELDS.ATTRIBUTE15%TYPE;
470:
471: d_dummy_date DATE;
472: counter NUMBER;
473: cancel_flag_value VARCHAR2(1);