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

Line 79: ); */ -- commented out to change this based on MTL_LOT_NUMBERS table

75: l_supplier_lot_number VARCHAR2(150),
76: l_curl_wrinkle_fold VARCHAR2(150),
77: l_lot_attribute_category VARCHAR2(30),
78: l_attribute_category VARCHAR2(30)
79: ); */ -- commented out to change this based on MTL_LOT_NUMBERS table
80:
81: Type lot_attributes_rec_type is RECORD
82: (
83: l_mtli_txn_id NUMBER,

Line 84: l_description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,

80:
81: Type lot_attributes_rec_type is RECORD
82: (
83: l_mtli_txn_id NUMBER,
84: l_description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
85: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,

Line 85: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,

81: Type lot_attributes_rec_type is RECORD
82: (
83: l_mtli_txn_id NUMBER,
84: l_description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
85: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,

Line 86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,

82: (
83: l_mtli_txn_id NUMBER,
84: l_description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
85: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

Line 87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,

83: l_mtli_txn_id NUMBER,
84: l_description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
85: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

Line 88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,

84: l_description MTL_LOT_NUMBERS.DESCRIPTION%TYPE,
85: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,

Line 89: l_age MTL_LOT_NUMBERS.AGE%TYPE,

85: l_grade_code MTL_LOT_NUMBERS.GRADE_CODE%TYPE,
86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,

Line 90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,

86: l_origination_date MTL_LOT_NUMBERS.ORIGINATION_DATE%TYPE,
87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,

Line 91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,

87: l_date_code MTL_LOT_NUMBERS.DATE_CODE%TYPE,
88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,

Line 92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,

88: l_change_date MTL_LOT_NUMBERS.CHANGE_DATE%TYPE,
89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,

Line 93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,

89: l_age MTL_LOT_NUMBERS.AGE%TYPE,
90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,

Line 94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,

90: l_retest_date MTL_LOT_NUMBERS.RETEST_DATE%TYPE,
91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,

Line 95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,

91: l_maturity_date MTL_LOT_NUMBERS.MATURITY_DATE%TYPE,
92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,

Line 96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,

92: l_item_size MTL_LOT_NUMBERS.ITEM_SIZE%TYPE,
93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,

Line 97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,

93: l_color MTL_LOT_NUMBERS.COLOR%TYPE,
94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,

Line 98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,

94: l_volume MTL_LOT_NUMBERS.VOLUME%TYPE,
95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,

Line 99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,

95: l_volume_uom MTL_LOT_NUMBERS.VOLUME_UOM%TYPE,
96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,

Line 100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,

96: l_place_of_origin MTL_LOT_NUMBERS.PLACE_OF_ORIGIN%TYPE,
97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,

Line 101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,

97: l_best_by_date MTL_LOT_NUMBERS.BEST_BY_DATE%TYPE,
98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,

Line 102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,

98: l_length MTL_LOT_NUMBERS.LENGTH%TYPE,
99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,

Line 103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,

99: l_length_uom MTL_LOT_NUMBERS.LENGTH_UOM%TYPE,
100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,

Line 104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,

100: l_recycled_content MTL_LOT_NUMBERS.RECYCLED_CONTENT%TYPE,
101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,

Line 105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,

101: l_thickness MTL_LOT_NUMBERS.THICKNESS%TYPE,
102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,

Line 106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,

102: l_thickness_uom MTL_LOT_NUMBERS.THICKNESS_UOM%TYPE,
103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
110: l_lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

Line 107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,

103: l_width MTL_LOT_NUMBERS.WIDTH%TYPE,
104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
110: l_lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
111: l_attribute_category MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE

Line 108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,

104: l_width_uom MTL_LOT_NUMBERS.WIDTH_UOM%TYPE,
105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
110: l_lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
111: l_attribute_category MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE
112: );

Line 109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,

105: l_vendor_id MTL_LOT_NUMBERS.VENDOR_ID%TYPE,
106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
110: l_lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
111: l_attribute_category MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE
112: );
113:

Line 110: l_lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,

106: l_vendor_name MTL_LOT_NUMBERS.VENDOR_NAME%TYPE,
107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
110: l_lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
111: l_attribute_category MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE
112: );
113:
114: /* This is the main routing for processing inventory lot transactions

Line 111: l_attribute_category MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE

107: l_territory_code MTL_LOT_NUMBERS.TERRITORY_CODE%TYPE,
108: l_supplier_lot_number MTL_LOT_NUMBERS.SUPPLIER_LOT_NUMBER%TYPE,
109: l_curl_wrinkle_fold MTL_LOT_NUMBERS.CURL_WRINKLE_FOLD%TYPE,
110: l_lot_attribute_category MTL_LOT_NUMBERS.LOT_ATTRIBUTE_CATEGORY%TYPE,
111: l_attribute_category MTL_LOT_NUMBERS.ATTRIBUTE_CATEGORY%TYPE
112: );
113:
114: /* This is the main routing for processing inventory lot transactions
115: You can call the routine to process a group of rows by passing a group