eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RCV_INTEGRATION_APIS dependencies on MTL_LOT_NUMBERS

Line 363: FROM mtl_lot_numbers

359: , availability_type --OPM Convergence
360: , expiration_action_code --OPM Convergence
361: , expiration_action_date -- OPM Convergence
362: , hold_date --OPM Convergence
363: FROM mtl_lot_numbers
364: WHERE lot_number = Ltrim(Rtrim(v_lot_number))
365: AND inventory_item_id = v_inventory_item_id
366: AND organization_id = v_organization_id;
367:

Line 375: l_lot_number mtl_lot_numbers.lot_number%type := p_lot_number;

371: l_product_transaction_id NUMBER; --product_transaction_id generated
372: l_lot_count NUMBER; --MTLI count for given lot and interface_id
373: l_lot_exists NUMBER;
374:
375: l_lot_number mtl_lot_numbers.lot_number%type := p_lot_number;
376: l_expiration_date mtl_lot_numbers.expiration_date%type := p_expiration_date;
377: l_description mtl_lot_numbers.description%type := p_description;
378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;

Line 376: l_expiration_date mtl_lot_numbers.expiration_date%type := p_expiration_date;

372: l_lot_count NUMBER; --MTLI count for given lot and interface_id
373: l_lot_exists NUMBER;
374:
375: l_lot_number mtl_lot_numbers.lot_number%type := p_lot_number;
376: l_expiration_date mtl_lot_numbers.expiration_date%type := p_expiration_date;
377: l_description mtl_lot_numbers.description%type := p_description;
378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;

Line 377: l_description mtl_lot_numbers.description%type := p_description;

373: l_lot_exists NUMBER;
374:
375: l_lot_number mtl_lot_numbers.lot_number%type := p_lot_number;
376: l_expiration_date mtl_lot_numbers.expiration_date%type := p_expiration_date;
377: l_description mtl_lot_numbers.description%type := p_description;
378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;

Line 378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;

374:
375: l_lot_number mtl_lot_numbers.lot_number%type := p_lot_number;
376: l_expiration_date mtl_lot_numbers.expiration_date%type := p_expiration_date;
377: l_description mtl_lot_numbers.description%type := p_description;
378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;

Line 379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;

375: l_lot_number mtl_lot_numbers.lot_number%type := p_lot_number;
376: l_expiration_date mtl_lot_numbers.expiration_date%type := p_expiration_date;
377: l_description mtl_lot_numbers.description%type := p_description;
378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;

Line 380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;

376: l_expiration_date mtl_lot_numbers.expiration_date%type := p_expiration_date;
377: l_description mtl_lot_numbers.description%type := p_description;
378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;

Line 381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;

377: l_description mtl_lot_numbers.description%type := p_description;
378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;

Line 382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;

378: l_vendor_name mtl_lot_numbers.vendor_name%type := p_vendor_name;
379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;

Line 383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;

379: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type := p_supplier_lot_number;
380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;

Line 384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;

380: l_grade_code mtl_lot_numbers.grade_code%type := p_grade_code;
381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;

Line 385: l_age mtl_lot_numbers.age%type := p_age;

381: l_origination_date mtl_lot_numbers.origination_date%type := p_origination_date;
382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;

Line 386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;

382: l_date_code mtl_lot_numbers.date_code%type := p_date_code;
383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;

Line 387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;

383: l_status_id mtl_lot_numbers.status_id%type := p_status_id;
384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;

Line 388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;

384: l_change_date mtl_lot_numbers.change_date%type := p_change_date;
385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;

Line 389: l_color mtl_lot_numbers.color%type := p_color;

385: l_age mtl_lot_numbers.age%type := p_age;
386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;

Line 390: l_volume mtl_lot_numbers.volume%type := p_volume;

386: l_retest_date mtl_lot_numbers.retest_date%type := p_retest_date;
387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;

Line 391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;

387: l_maturity_date mtl_lot_numbers.maturity_date%type := p_maturity_date;
388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;

Line 392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;

388: l_item_size mtl_lot_numbers.item_size%type := p_item_size;
389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;

Line 393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;

389: l_color mtl_lot_numbers.color%type := p_color;
390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;

Line 394: l_length mtl_lot_numbers.length%type := p_length;

390: l_volume mtl_lot_numbers.volume%type := p_volume;
391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;

Line 395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;

391: l_volume_uom mtl_lot_numbers.volume_uom%type := p_volume_uom;
392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;

Line 396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;

392: l_place_of_origin mtl_lot_numbers.place_of_origin%type := p_place_of_origin;
393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;

Line 397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;

393: l_best_by_date mtl_lot_numbers.best_by_date%type := p_best_by_date;
394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;

Line 398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;

394: l_length mtl_lot_numbers.length%type := p_length;
395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;

Line 399: l_width mtl_lot_numbers.width%type := p_width;

395: l_length_uom mtl_lot_numbers.length_uom%type := p_length_uom;
396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;

Line 400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;

396: l_recycled_content mtl_lot_numbers.recycled_content%type := p_recycled_content;
397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;

Line 401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;

397: l_thickness mtl_lot_numbers.thickness%type := p_thickness;
398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;

Line 402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;

398: l_thickness_uom mtl_lot_numbers.thickness_uom%type := p_thickness_uom;
399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;

Line 403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;

399: l_width mtl_lot_numbers.width%type := p_width;
400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;

Line 404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;

400: l_width_uom mtl_lot_numbers.width_uom%type := p_width_uom;
401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;

Line 405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;

401: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type := p_curl_wrinkle_fold;
402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;

Line 406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;

402: l_vendor_id mtl_lot_numbers.vendor_id%type := p_vendor_id;
403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;

Line 407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;

403: l_territory_code mtl_lot_numbers.territory_code%type := p_territory_code;
404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;

Line 408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;

404: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE := p_lot_attribute_category;
405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;

Line 409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;

405: l_c_attribute1 mtl_lot_numbers.c_attribute1%type := p_c_attribute1;
406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;

Line 410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;

406: l_c_attribute2 mtl_lot_numbers.c_attribute2%type := p_c_attribute2;
407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;

Line 411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;

407: l_c_attribute3 mtl_lot_numbers.c_attribute3%type := p_c_attribute3;
408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;

Line 412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;

408: l_c_attribute4 mtl_lot_numbers.c_attribute4%type := p_c_attribute4;
409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;

Line 413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;

409: l_c_attribute5 mtl_lot_numbers.c_attribute5%type := p_c_attribute5;
410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;

Line 414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;

410: l_c_attribute6 mtl_lot_numbers.c_attribute6%type := p_c_attribute6;
411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;

Line 415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;

411: l_c_attribute7 mtl_lot_numbers.c_attribute7%type := p_c_attribute7;
412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;

Line 416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;

412: l_c_attribute8 mtl_lot_numbers.c_attribute8%type := p_c_attribute8;
413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;

Line 417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;

413: l_c_attribute9 mtl_lot_numbers.c_attribute9%type := p_c_attribute9;
414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;

Line 418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;

414: l_c_attribute10 mtl_lot_numbers.c_attribute10%type := p_c_attribute10;
415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;

Line 419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;

415: l_c_attribute11 mtl_lot_numbers.c_attribute11%type := p_c_attribute11;
416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;

Line 420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;

416: l_c_attribute12 mtl_lot_numbers.c_attribute12%type := p_c_attribute12;
417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;

Line 421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;

417: l_c_attribute13 mtl_lot_numbers.c_attribute13%type := p_c_attribute13;
418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;

Line 422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;

418: l_c_attribute14 mtl_lot_numbers.c_attribute14%type := p_c_attribute14;
419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;

Line 423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;

419: l_c_attribute15 mtl_lot_numbers.c_attribute15%type := p_c_attribute15;
420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;

Line 424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;

420: l_c_attribute16 mtl_lot_numbers.c_attribute16%type := p_c_attribute16;
421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;

Line 425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;

421: l_c_attribute17 mtl_lot_numbers.c_attribute17%type := p_c_attribute17;
422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;

Line 426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;

422: l_c_attribute18 mtl_lot_numbers.c_attribute18%type := p_c_attribute18;
423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;

Line 427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;

423: l_c_attribute19 mtl_lot_numbers.c_attribute19%type := p_c_attribute19;
424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;

Line 428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;

424: l_c_attribute20 mtl_lot_numbers.c_attribute20%type := p_c_attribute20;
425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;

Line 429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;

425: l_d_attribute1 mtl_lot_numbers.d_attribute1%type := p_d_attribute1;
426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;

Line 430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;

426: l_d_attribute2 mtl_lot_numbers.d_attribute2%type := p_d_attribute2;
427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;

Line 431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;

427: l_d_attribute3 mtl_lot_numbers.d_attribute3%type := p_d_attribute3;
428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;

Line 432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;

428: l_d_attribute4 mtl_lot_numbers.d_attribute4%type := p_d_attribute4;
429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;

Line 433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;

429: l_d_attribute5 mtl_lot_numbers.d_attribute5%type := p_d_attribute5;
430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;

Line 434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;

430: l_d_attribute6 mtl_lot_numbers.d_attribute6%type := p_d_attribute6;
431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;

Line 435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;

431: l_d_attribute7 mtl_lot_numbers.d_attribute7%type := p_d_attribute7;
432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;

Line 436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;

432: l_d_attribute8 mtl_lot_numbers.d_attribute8%type := p_d_attribute8;
433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;

Line 437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;

433: l_d_attribute9 mtl_lot_numbers.d_attribute9%type := p_d_attribute9;
434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;

Line 438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;

434: l_d_attribute10 mtl_lot_numbers.d_attribute10%type := p_d_attribute10;
435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;

Line 439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;

435: l_n_attribute1 mtl_lot_numbers.n_attribute1%type := p_n_attribute1;
436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;

Line 440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;

436: l_n_attribute2 mtl_lot_numbers.n_attribute2%type := p_n_attribute2;
437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;

Line 441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;

437: l_n_attribute3 mtl_lot_numbers.n_attribute3%type := p_n_attribute3;
438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;

Line 442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;

438: l_n_attribute4 mtl_lot_numbers.n_attribute4%type := p_n_attribute4;
439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;

Line 443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;

439: l_n_attribute5 mtl_lot_numbers.n_attribute5%type := p_n_attribute5;
440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;

Line 444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;

440: l_n_attribute6 mtl_lot_numbers.n_attribute6%type := p_n_attribute6;
441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;

Line 445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;

441: l_n_attribute7 mtl_lot_numbers.n_attribute7%type := p_n_attribute7;
442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;

Line 446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;

442: l_n_attribute8 mtl_lot_numbers.n_attribute8%type := p_n_attribute8;
443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;

Line 447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;

443: l_n_attribute9 mtl_lot_numbers.n_attribute9%type := p_n_attribute9;
444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;

Line 448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;

444: l_n_attribute10 mtl_lot_numbers.n_attribute10%type := p_n_attribute10;
445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;

Line 449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;

445: l_attribute_category mtl_lot_numbers.attribute_category%type := p_attribute_category;
446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;

Line 450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;

446: l_attribute1 mtl_lot_numbers.attribute1%type := p_attribute1;
447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;

Line 451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;

447: l_attribute2 mtl_lot_numbers.attribute2%type := p_attribute2;
448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;

Line 452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;

448: l_attribute3 mtl_lot_numbers.attribute3%type := p_attribute3;
449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;

Line 453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;

449: l_attribute4 mtl_lot_numbers.attribute4%type := p_attribute4;
450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;

Line 454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;

450: l_attribute5 mtl_lot_numbers.attribute5%type := p_attribute5;
451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;

Line 455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;

451: l_attribute6 mtl_lot_numbers.attribute6%type := p_attribute6;
452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;

Line 456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;

452: l_attribute7 mtl_lot_numbers.attribute7%type := p_attribute7;
453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;

Line 457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;

453: l_attribute8 mtl_lot_numbers.attribute8%type := p_attribute8;
454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;
461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;

Line 458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;

454: l_attribute9 mtl_lot_numbers.attribute9%type := p_attribute9;
455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;
461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
462: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;

Line 459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;

455: l_attribute10 mtl_lot_numbers.attribute10%type := p_attribute10;
456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;
461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
462: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
463: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;

Line 460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;

456: l_attribute11 mtl_lot_numbers.attribute11%type := p_attribute11;
457: l_attribute12 mtl_lot_numbers.attribute12%type := p_attribute12;
458: l_attribute13 mtl_lot_numbers.attribute13%type := p_attribute13;
459: l_attribute14 mtl_lot_numbers.attribute14%type := p_attribute14;
460: l_attribute15 mtl_lot_numbers.attribute15%type := p_attribute15;
461: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
462: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
463: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
464: l_api_version CONSTANT NUMBER := 1.0;

Line 472: l_origination_type mtl_lot_numbers.origination_type%TYPE := p_origination_type; --OPM Convergence

468:
469: l_att_org_id NUMBER;
470:
471: --nsinghi bug#5209065 START. Default the variables to input parameters.
472: l_origination_type mtl_lot_numbers.origination_type%TYPE := p_origination_type; --OPM Convergence
473: l_availability_type mtl_lot_numbers.availability_type%TYPE; --OPM Convergence
474: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE := p_expiration_action_code; --OPM Convergence
475: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE := p_expiration_action_date; -- OPM Convergence
476: l_hold_date mtl_lot_numbers.hold_date%TYPE := p_hold_date; --OPM Convergence

Line 473: l_availability_type mtl_lot_numbers.availability_type%TYPE; --OPM Convergence

469: l_att_org_id NUMBER;
470:
471: --nsinghi bug#5209065 START. Default the variables to input parameters.
472: l_origination_type mtl_lot_numbers.origination_type%TYPE := p_origination_type; --OPM Convergence
473: l_availability_type mtl_lot_numbers.availability_type%TYPE; --OPM Convergence
474: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE := p_expiration_action_code; --OPM Convergence
475: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE := p_expiration_action_date; -- OPM Convergence
476: l_hold_date mtl_lot_numbers.hold_date%TYPE := p_hold_date; --OPM Convergence
477: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE := p_parent_lot_number; --OPM Convergence

Line 474: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE := p_expiration_action_code; --OPM Convergence

470:
471: --nsinghi bug#5209065 START. Default the variables to input parameters.
472: l_origination_type mtl_lot_numbers.origination_type%TYPE := p_origination_type; --OPM Convergence
473: l_availability_type mtl_lot_numbers.availability_type%TYPE; --OPM Convergence
474: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE := p_expiration_action_code; --OPM Convergence
475: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE := p_expiration_action_date; -- OPM Convergence
476: l_hold_date mtl_lot_numbers.hold_date%TYPE := p_hold_date; --OPM Convergence
477: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE := p_parent_lot_number; --OPM Convergence
478: l_secondary_quantity NUMBER := p_secondary_quantity;

Line 475: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE := p_expiration_action_date; -- OPM Convergence

471: --nsinghi bug#5209065 START. Default the variables to input parameters.
472: l_origination_type mtl_lot_numbers.origination_type%TYPE := p_origination_type; --OPM Convergence
473: l_availability_type mtl_lot_numbers.availability_type%TYPE; --OPM Convergence
474: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE := p_expiration_action_code; --OPM Convergence
475: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE := p_expiration_action_date; -- OPM Convergence
476: l_hold_date mtl_lot_numbers.hold_date%TYPE := p_hold_date; --OPM Convergence
477: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE := p_parent_lot_number; --OPM Convergence
478: l_secondary_quantity NUMBER := p_secondary_quantity;
479: --nsinghi bug#5209065 END.

Line 476: l_hold_date mtl_lot_numbers.hold_date%TYPE := p_hold_date; --OPM Convergence

472: l_origination_type mtl_lot_numbers.origination_type%TYPE := p_origination_type; --OPM Convergence
473: l_availability_type mtl_lot_numbers.availability_type%TYPE; --OPM Convergence
474: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE := p_expiration_action_code; --OPM Convergence
475: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE := p_expiration_action_date; -- OPM Convergence
476: l_hold_date mtl_lot_numbers.hold_date%TYPE := p_hold_date; --OPM Convergence
477: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE := p_parent_lot_number; --OPM Convergence
478: l_secondary_quantity NUMBER := p_secondary_quantity;
479: --nsinghi bug#5209065 END.
480: /* Bug 13727314 */

Line 477: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE := p_parent_lot_number; --OPM Convergence

473: l_availability_type mtl_lot_numbers.availability_type%TYPE; --OPM Convergence
474: l_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE := p_expiration_action_code; --OPM Convergence
475: l_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE := p_expiration_action_date; -- OPM Convergence
476: l_hold_date mtl_lot_numbers.hold_date%TYPE := p_hold_date; --OPM Convergence
477: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE := p_parent_lot_number; --OPM Convergence
478: l_secondary_quantity NUMBER := p_secondary_quantity;
479: --nsinghi bug#5209065 END.
480: /* Bug 13727314 */
481: l_lot_status_id mtl_lot_numbers.status_id%type;

Line 481: l_lot_status_id mtl_lot_numbers.status_id%type;

477: l_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE := p_parent_lot_number; --OPM Convergence
478: l_secondary_quantity NUMBER := p_secondary_quantity;
479: --nsinghi bug#5209065 END.
480: /* Bug 13727314 */
481: l_lot_status_id mtl_lot_numbers.status_id%type;
482: l_default_status_id number:= NULL;
483: l_allow_status_entry VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_ALLOW_ONHAND_STATUS_ENTRY'), 'N');
484:
485: BEGIN

Line 927: --If the flag p_update_mln is set to 'Y' then update MTL_LOT_NUMBERS

923: , p_secondary_quantity --OPM Convergence
924: , l_parent_lot_number --OPM Convergence
925: );
926:
927: --If the flag p_update_mln is set to 'Y' then update MTL_LOT_NUMBERS
928: --with the attributes from the parameters
929: IF (NVL(p_update_mln, 'N') = 'Y') THEN
930: BEGIN
931: SELECT count(1)

Line 933: FROM mtl_lot_numbers

929: IF (NVL(p_update_mln, 'N') = 'Y') THEN
930: BEGIN
931: SELECT count(1)
932: INTO l_lot_exists
933: FROM mtl_lot_numbers
934: WHERE lot_number = Ltrim(Rtrim(p_lot_number))
935: AND inventory_item_id = p_inventory_item_id
936: AND organization_id = p_organization_id;
937:

Line 939: UPDATE mtl_lot_numbers

935: AND inventory_item_id = p_inventory_item_id
936: AND organization_id = p_organization_id;
937:
938: IF l_lot_exists > 0 THEN
939: UPDATE mtl_lot_numbers
940: SET description = l_description
941: , vendor_name = l_vendor_name
942: , supplier_lot_number = l_supplier_lot_number
943: , origination_date = l_origination_date

Line 1959: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;

1955: item_shelf_life_days CONSTANT NUMBER := 2;
1956: user_defined_exp_date CONSTANT NUMBER := 4;
1957: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
1958: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
1959: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
1960: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1961: BEGIN
1962: x_return_status := g_ret_sts_success;
1963:

Line 2013: FROM mtl_lot_numbers

2009: --First check if the lot exists in the given organization
2010: BEGIN
2011: SELECT 'Y'
2012: INTO l_lot_exists
2013: FROM mtl_lot_numbers
2014: WHERE lot_number = LTRIM(RTRIM(p_lot_number))
2015: AND inventory_item_id = p_inventory_item_id
2016: AND organization_id = p_org_id;
2017: EXCEPTION