24: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
28: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
29: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
30: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
31: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
32: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
25: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
26: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
27: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
28: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
29: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
30: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
31: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
32: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
33: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_header_id OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
43: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
44: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
39: x_header_id OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
43: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
44: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_msg_count OUT NOCOPY NUMBER,
42: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
43: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
44: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
41: x_msg_count OUT NOCOPY NUMBER,
42: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
43: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
44: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
42: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
43: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
44: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
43: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
44: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
44: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
45: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
46: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
47: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
48: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
49: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
50: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
51: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
52: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
53: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
54: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
55: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
56: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
57: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
58: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
59: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
60: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
61: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
62: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
63: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
64: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
65: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
66: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
67: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
68: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
69: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
70: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
71: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
72: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
73: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
74: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
75: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
76: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
77: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
78: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
79: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
80: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
81: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
82: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
83: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
84: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
85: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
86: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
87: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
88: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
89: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
90: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
91: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
92: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
93: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
94: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
95: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
96: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
97: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
98: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
99: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
100: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
101: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
102: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
103: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
104: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
105: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
106: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
107: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
108: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
109: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
110: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
111: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
112: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
113: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
114: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
115: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV