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.LOT_SPLIT_DATA_INSERT dependencies on MTL_LOT_NUMBERS

Line 25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,

21: item_secondary_uom_code MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE, -- Bug #4093379 INVCONV
22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV

Line 26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV

22: item_shelf_life_code MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
23: item_shelf_life_days MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV

Line 28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,

24: allowed_units_lookup_code MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
25: lot_number MTL_LOT_NUMBERS.lot_number%TYPE,
26: parent_lot_number MTL_LOT_NUMBERS.parent_lot_number%TYPE, -- Bug #4093379 INVCONV
27: origination_type MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE, -- Bug #4093379 INVCONV
28: lot_expiration_date MTL_LOT_NUMBERS.expiration_date%TYPE,
29: expiration_action_date MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE, -- Bug #4093379 INVCONV
30: expiration_action_code MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE, -- Bug #4093379 INVCONV
31: hold_date MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE, -- Bug #4093379 INVCONV
32: reason_id MTL_TRANSACTION_LOTS_TEMP.reason_id%TYPE, -- Bug #4093379 INVCONV

Line 43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,

39: transaction_temp_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_temp_id%TYPE,
40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,
41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,

Line 44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,

40: transaction_header_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_header_id%TYPE,
41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,

Line 45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,

41: transaction_batch_id MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_id%TYPE,
42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,

Line 46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,

42: transaction_batch_seq MTL_MATERIAL_TRANSACTIONS_TEMP.transaction_batch_seq%TYPE,
43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,

Line 47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,

43: description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,

Line 48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,

44: vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,

Line 49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,

45: supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

Line 50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,

46: territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

Line 51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,

47: grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

Line 52: age MTL_LOT_NUMBERS.AGE%TYPE,

48: origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,

Line 53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

49: date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,

Line 54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

50: status_id MTL_LOT_NUMBERS.STATUS_ID%TYPE,
51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,

Line 55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

51: change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,

Line 56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,

52: age MTL_LOT_NUMBERS.AGE%TYPE,
53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,

Line 57: color MTL_LOT_NUMBERS.COLOR%TYPE,

53: retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,

Line 58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,

54: maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,

Line 59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,

55: lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,

Line 60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,

56: item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,

Line 61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,

57: color MTL_LOT_NUMBERS.COLOR%TYPE,
58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,

Line 62: length MTL_LOT_NUMBERS.LENGTH%TYPE,

58: volume MTL_LOT_NUMBERS.VOLUME%TYPE,
59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,

Line 63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,

59: volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,

Line 64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,

60: place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,

Line 65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,

61: best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,

Line 66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,

62: length MTL_LOT_NUMBERS.LENGTH%TYPE,
63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,

Line 67: width MTL_LOT_NUMBERS.WIDTH%TYPE,

63: length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,

Line 68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,

64: recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,

Line 69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,

65: thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,

Line 70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,

66: thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,

Line 71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,

67: width MTL_LOT_NUMBERS.WIDTH%TYPE,
68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,

Line 72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,

68: width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,

Line 73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,

69: curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,

Line 74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,

70: c_attribute1 MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,

Line 75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,

71: c_attribute2 MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,

Line 76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,

72: c_attribute3 MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,

Line 77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,

73: c_attribute4 MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,

Line 78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,

74: c_attribute5 MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,

Line 79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,

75: c_attribute6 MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,

Line 80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,

76: c_attribute7 MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,

Line 81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,

77: c_attribute8 MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,

Line 82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,

78: c_attribute9 MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,

Line 83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,

79: c_attribute10 MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,

Line 84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,

80: c_attribute11 MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,

Line 85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,

81: c_attribute12 MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,

Line 86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,

82: c_attribute13 MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,

Line 87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,

83: c_attribute14 MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,

Line 88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,

84: c_attribute15 MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,

Line 89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,

85: c_attribute16 MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,

Line 90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,

86: c_attribute17 MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,

Line 91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,

87: c_attribute18 MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,

Line 92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,

88: c_attribute19 MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,

Line 93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,

89: c_attribute20 MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,

Line 94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,

90: d_attribute1 MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,

Line 95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,

91: d_attribute2 MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,

Line 96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,

92: d_attribute3 MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,

Line 97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,

93: d_attribute4 MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,

Line 98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,

94: d_attribute5 MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,

Line 99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,

95: d_attribute6 MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,

Line 100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,

96: d_attribute7 MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,

Line 101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,

97: d_attribute8 MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,

Line 102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,

98: d_attribute9 MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,

Line 103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,

99: d_attribute10 MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,

Line 104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,

100: n_attribute1 MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
108: n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,

Line 105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,

101: n_attribute2 MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
108: n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
109: n_attribute10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE

Line 106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,

102: n_attribute3 MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
108: n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
109: n_attribute10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE
110: );

Line 107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,

103: n_attribute4 MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
108: n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
109: n_attribute10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE
110: );
111: TYPE input_table IS TABLE OF inputrec

Line 108: n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,

104: n_attribute5 MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
108: n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
109: n_attribute10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE
110: );
111: TYPE input_table IS TABLE OF inputrec
112: INDEX BY BINARY_INTEGER;

Line 109: n_attribute10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE

105: n_attribute6 MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
106: n_attribute7 MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
107: n_attribute8 MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
108: n_attribute9 MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
109: n_attribute10 MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE
110: );
111: TYPE input_table IS TABLE OF inputrec
112: INDEX BY BINARY_INTEGER;
113: tab_index INTEGER ;

Line 151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,

147: p_item_primary_uom_code IN MTL_SYSTEM_ITEMS_KFV.primary_uom_code%TYPE,
148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
154: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
155: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,

Line 152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,

148: p_item_shelf_life_code IN MTL_SYSTEM_ITEMS_KFV.shelf_life_code%TYPE,
149: p_item_shelf_life_days IN MTL_SYSTEM_ITEMS_KFV.shelf_life_days%TYPE,
150: p_allowed_units_lookup_code IN MTL_SYSTEM_ITEMS_KFV.allowed_units_lookup_code%TYPE,
151: p_lot_number IN MTL_LOT_NUMBERS.lot_number%TYPE,
152: p_lot_expiration_date IN MTL_LOT_NUMBERS.expiration_date%TYPE,
153: p_total_qty IN MTL_MATERIAL_TRANSACTIONS.transaction_quantity%TYPE,
154: p_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,
155: p_lpn_number IN WMS_LICENSE_PLATE_NUMBERS.license_plate_number%TYPE,
156: p_xfr_lpn_id IN WMS_LICENSE_PLATE_NUMBERS.lpn_id%TYPE,

Line 165: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,

161: x_return_status OUT NOCOPY VARCHAR2,
162: x_header_id OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
166: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,

Line 166: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,

162: x_header_id OUT NOCOPY NUMBER,
163: x_msg_data OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
166: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,

Line 167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,

163: x_msg_data OUT NOCOPY VARCHAR2,
164: x_msg_count OUT NOCOPY NUMBER,
165: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
166: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,

Line 168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,

164: x_msg_count OUT NOCOPY NUMBER,
165: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
166: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,

Line 169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,

165: p_description IN MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
166: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,

Line 170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,

166: p_vendor_id IN MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,

Line 171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,

167: p_supplier_lot_number IN MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

Line 172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,

168: p_territory_code IN MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

Line 173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,

169: p_grade_code IN MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

Line 174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,

170: p_origination_date IN MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,

Line 175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

171: p_date_code IN MTL_LOT_NUMBERS.DATE_CODE%TYPE,
172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,

Line 176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

172: p_status_id IN MTL_LOT_NUMBERS.STATUS_ID%TYPE,
173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,

Line 177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

173: p_change_date IN MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,

Line 178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,

174: p_age IN MTL_LOT_NUMBERS.AGE%TYPE,
175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,

Line 179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,

175: p_retest_date IN MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,

Line 180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,

176: p_maturity_date IN MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,

Line 181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,

177: p_lot_attribute_category IN MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,

Line 182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,

178: p_item_size IN MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,

Line 183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,

179: p_color IN MTL_LOT_NUMBERS.COLOR%TYPE,
180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,

Line 184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,

180: p_volume IN MTL_LOT_NUMBERS.VOLUME%TYPE,
181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,

Line 185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,

181: p_volume_uom IN MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,

Line 186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,

182: p_place_of_origin IN MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,

Line 187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,

183: p_best_by_date IN MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,

Line 188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,

184: p_length IN MTL_LOT_NUMBERS.LENGTH%TYPE,
185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,

Line 189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,

185: p_length_uom IN MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,

Line 190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,

186: p_recycled_content IN MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,

Line 191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,

187: p_thickness IN MTL_LOT_NUMBERS.THICKNESS%TYPE,
188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,

Line 192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,

188: p_thickness_uom IN MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,

Line 193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,

189: p_width IN MTL_LOT_NUMBERS.WIDTH%TYPE,
190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,

Line 194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,

190: p_width_uom IN MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,

Line 195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,

191: p_curl_wrinkle_fold IN MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,

Line 196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,

192: p_c_attribute1 IN MTL_LOT_NUMBERS.C_ATTRIBUTE1%TYPE,
193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,

Line 197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,

193: p_c_attribute2 IN MTL_LOT_NUMBERS.C_ATTRIBUTE2%TYPE,
194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,

Line 198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,

194: p_c_attribute3 IN MTL_LOT_NUMBERS.C_ATTRIBUTE3%TYPE,
195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,

Line 199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,

195: p_c_attribute4 IN MTL_LOT_NUMBERS.C_ATTRIBUTE4%TYPE,
196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,

Line 200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,

196: p_c_attribute5 IN MTL_LOT_NUMBERS.C_ATTRIBUTE5%TYPE,
197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,

Line 201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,

197: p_c_attribute6 IN MTL_LOT_NUMBERS.C_ATTRIBUTE6%TYPE,
198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,

Line 202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,

198: p_c_attribute7 IN MTL_LOT_NUMBERS.C_ATTRIBUTE7%TYPE,
199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,

Line 203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,

199: p_c_attribute8 IN MTL_LOT_NUMBERS.C_ATTRIBUTE8%TYPE,
200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,

Line 204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,

200: p_c_attribute9 IN MTL_LOT_NUMBERS.C_ATTRIBUTE9%TYPE,
201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,

Line 205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,

201: p_c_attribute10 IN MTL_LOT_NUMBERS.C_ATTRIBUTE10%TYPE,
202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,

Line 206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,

202: p_c_attribute11 IN MTL_LOT_NUMBERS.C_ATTRIBUTE11%TYPE,
203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,

Line 207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,

203: p_c_attribute12 IN MTL_LOT_NUMBERS.C_ATTRIBUTE12%TYPE,
204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,

Line 208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,

204: p_c_attribute13 IN MTL_LOT_NUMBERS.C_ATTRIBUTE13%TYPE,
205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,

Line 209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,

205: p_c_attribute14 IN MTL_LOT_NUMBERS.C_ATTRIBUTE14%TYPE,
206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,

Line 210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,

206: p_c_attribute15 IN MTL_LOT_NUMBERS.C_ATTRIBUTE15%TYPE,
207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,

Line 211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,

207: p_c_attribute16 IN MTL_LOT_NUMBERS.C_ATTRIBUTE16%TYPE,
208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,

Line 212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,

208: p_c_attribute17 IN MTL_LOT_NUMBERS.C_ATTRIBUTE17%TYPE,
209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,

Line 213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,

209: p_c_attribute18 IN MTL_LOT_NUMBERS.C_ATTRIBUTE18%TYPE,
210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,

Line 214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,

210: p_c_attribute19 IN MTL_LOT_NUMBERS.C_ATTRIBUTE19%TYPE,
211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,

Line 215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,

211: p_c_attribute20 IN MTL_LOT_NUMBERS.C_ATTRIBUTE20%TYPE,
212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,

Line 216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,

212: p_d_attribute1 IN MTL_LOT_NUMBERS.D_ATTRIBUTE1%TYPE,
213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,

Line 217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,

213: p_d_attribute2 IN MTL_LOT_NUMBERS.D_ATTRIBUTE2%TYPE,
214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,

Line 218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,

214: p_d_attribute3 IN MTL_LOT_NUMBERS.D_ATTRIBUTE3%TYPE,
215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,

Line 219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,

215: p_d_attribute4 IN MTL_LOT_NUMBERS.D_ATTRIBUTE4%TYPE,
216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,

Line 220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,

216: p_d_attribute5 IN MTL_LOT_NUMBERS.D_ATTRIBUTE5%TYPE,
217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,

Line 221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,

217: p_d_attribute6 IN MTL_LOT_NUMBERS.D_ATTRIBUTE6%TYPE,
218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,

Line 222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,

218: p_d_attribute7 IN MTL_LOT_NUMBERS.D_ATTRIBUTE7%TYPE,
219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,

Line 223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,

219: p_d_attribute8 IN MTL_LOT_NUMBERS.D_ATTRIBUTE8%TYPE,
220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,

Line 224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,

220: p_d_attribute9 IN MTL_LOT_NUMBERS.D_ATTRIBUTE9%TYPE,
221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,

Line 225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,

221: p_d_attribute10 IN MTL_LOT_NUMBERS.D_ATTRIBUTE10%TYPE,
222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,

Line 226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,

222: p_n_attribute1 IN MTL_LOT_NUMBERS.N_ATTRIBUTE1%TYPE,
223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,

Line 227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,

223: p_n_attribute2 IN MTL_LOT_NUMBERS.N_ATTRIBUTE2%TYPE,
224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,

Line 228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,

224: p_n_attribute3 IN MTL_LOT_NUMBERS.N_ATTRIBUTE3%TYPE,
225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

Line 229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,

225: p_n_attribute4 IN MTL_LOT_NUMBERS.N_ATTRIBUTE4%TYPE,
226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

Line 230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,

226: p_n_attribute5 IN MTL_LOT_NUMBERS.N_ATTRIBUTE5%TYPE,
227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

Line 231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,

227: p_n_attribute6 IN MTL_LOT_NUMBERS.N_ATTRIBUTE6%TYPE,
228: p_n_attribute7 IN MTL_LOT_NUMBERS.N_ATTRIBUTE7%TYPE,
229: p_n_attribute8 IN MTL_LOT_NUMBERS.N_ATTRIBUTE8%TYPE,
230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

Line 234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV

230: p_n_attribute9 IN MTL_LOT_NUMBERS.N_ATTRIBUTE9%TYPE,
231: p_n_attribute10 IN MTL_LOT_NUMBERS.N_ATTRIBUTE10%TYPE,
232: p_sec_transaction_quantity IN MTL_MATERIAL_TRANSACTIONS.secondary_transaction_quantity%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
233: p_item_secondary_uom_code IN MTL_SYSTEM_ITEMS_KFV.secondary_uom_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
234: p_parent_lot_number IN MTL_LOT_NUMBERS.parent_lot_number%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
235: p_origination_type IN MTL_TRANSACTION_LOTS_TEMP.origination_type%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
236: p_expiration_action_date IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
237: p_expiration_action_code IN MTL_TRANSACTION_LOTS_TEMP.expiration_action_code%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV
238: p_hold_date IN MTL_TRANSACTION_LOTS_TEMP.hold_date%TYPE DEFAULT NULL, -- Bug #4093379 INVCONV