APPS.INV_LOT_TRX_VALIDATION_PVT dependencies on INV_LOT_TRX_VALIDATION_PUB

Line 127: , x_st_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

123: *****************************************************************************/
124: PROCEDURE populate_records (
125: x_validation_status OUT NOCOPY VARCHAR2
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_st_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
128: , x_st_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table

Line 128: , x_st_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

124: PROCEDURE populate_records (
125: x_validation_status OUT NOCOPY VARCHAR2
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_st_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
128: , x_st_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

125: x_validation_status OUT NOCOPY VARCHAR2
126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_st_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
128: , x_st_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table

Line 130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table

126: , x_return_status OUT NOCOPY VARCHAR2
127: , x_st_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
128: , x_st_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
134: ,

Line 131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table

127: , x_st_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
128: , x_st_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
134: ,
135: --Support for Lot Serial

Line 132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

128: , x_st_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
134: ,
135: --Support for Lot Serial
136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table

Line 133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table

129: , x_st_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
130: , x_st_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
131: , x_st_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
134: ,
135: --Support for Lot Serial
136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table

Line 136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table

132: , x_st_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
134: ,
135: --Support for Lot Serial
136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table

133: , x_st_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
134: ,
135: --Support for Lot Serial
136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table

134: ,
135: --Support for Lot Serial
136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table

135: --Support for Lot Serial
136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

136: x_st_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table

Line 141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

137: , x_st_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table
145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table

Line 142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

138: , x_rs_ser_parent_lot_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_lot_table
139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table
145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table
146: ,

Line 143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

139: , x_rs_ser_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.serial_number_table
140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table
145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table
146: ,
147: --Support for Lot Serial

Line 144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table

140: , x_st_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table
145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table
146: ,
147: --Support for Lot Serial
148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table

141: , x_rs_ser_status_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
142: , x_st_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
143: , x_rs_ser_grp_mark_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table
145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table
146: ,
147: --Support for Lot Serial
148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

144: , x_st_ser_parent_sub_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_sub_table
145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table
146: ,
147: --Support for Lot Serial
148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

145: , x_st_ser_parent_loc_tbl OUT NOCOPY inv_lot_trx_validation_pub.parent_loc_table
146: ,
147: --Support for Lot Serial
148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

146: ,
147: --Support for Lot Serial
148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table

147: --Support for Lot Serial
148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

148: x_st_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table

Line 153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

149: , x_st_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table

Line 154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

150: , x_st_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

151: , x_st_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table

Line 156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table

152: , x_st_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table

153: , x_rs_interface_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

154: , x_rs_item_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table

155: , x_rs_org_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table

Line 160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

156: , x_rs_revision_tbl OUT NOCOPY inv_lot_trx_validation_pub.revision_table
157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

157: , x_rs_sub_code_tbl OUT NOCOPY inv_lot_trx_validation_pub.sub_code_table
158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table

Line 162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

158: , x_rs_locator_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
166: , x_rs_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table

Line 163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table

159: , x_rs_lot_num_tbl OUT NOCOPY inv_lot_trx_validation_pub.lot_number_table
160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
166: , x_rs_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
167: , x_transaction_type_id OUT NOCOPY NUMBER

Line 164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

160: , x_rs_lpn_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
166: , x_rs_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
167: , x_transaction_type_id OUT NOCOPY NUMBER
168: , x_acct_period_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

Line 165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table

161: , x_rs_quantity_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
166: , x_rs_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
167: , x_transaction_type_id OUT NOCOPY NUMBER
168: , x_acct_period_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
169: , x_st_dist_account_id OUT NOCOPY NUMBER

Line 166: , x_rs_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table

162: , x_rs_cost_group_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
163: , x_rs_uom_tbl OUT NOCOPY inv_lot_trx_validation_pub.uom_table
164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
166: , x_rs_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
167: , x_transaction_type_id OUT NOCOPY NUMBER
168: , x_acct_period_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
169: , x_st_dist_account_id OUT NOCOPY NUMBER
170: , x_rs_dist_account_id OUT NOCOPY NUMBER

Line 168: , x_acct_period_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table

164: , x_rs_status_id_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
165: , x_st_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
166: , x_rs_lot_exp_tbl OUT NOCOPY inv_lot_trx_validation_pub.date_table
167: , x_transaction_type_id OUT NOCOPY NUMBER
168: , x_acct_period_tbl OUT NOCOPY inv_lot_trx_validation_pub.number_table
169: , x_st_dist_account_id OUT NOCOPY NUMBER
170: , x_rs_dist_account_id OUT NOCOPY NUMBER
171: , p_parent_id IN NUMBER
172: )

Line 362: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;

358: l_ser_msn_csr msn_csr%ROWTYPE;
359: l_transaction_type_id NUMBER;
360: l_transaction_interface_id NUMBER;
361: l_transaction_action_id NUMBER;
362: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
363: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;

Line 363: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;

359: l_transaction_type_id NUMBER;
360: l_transaction_interface_id NUMBER;
361: l_transaction_action_id NUMBER;
362: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
363: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;

360: l_transaction_interface_id NUMBER;
361: l_transaction_action_id NUMBER;
362: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
363: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;

361: l_transaction_action_id NUMBER;
362: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
363: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;

362: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
363: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

363: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

364: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

Line 369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

365: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

Line 370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

366: l_st_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

Line 371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

367: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

Line 372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

368: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;

Line 373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

369: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

370: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

371: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;

372: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

373: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

374: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

Line 379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

375: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

Line 380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

376: l_rs_primary_quantity_tbl inv_lot_trx_validation_pub.number_table;
377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

Line 381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

377: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

Line 382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

378: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

Line 383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

379: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

Line 384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

380: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

381: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

382: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

383: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

384: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
392: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

Line 389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

385: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
392: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
393: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

Line 390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;

386: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
392: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
393: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
394: l_serial_transaction_temp_id NUMBER;

Line 391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;

387: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
392: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
393: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
394: l_serial_transaction_temp_id NUMBER;
395: l_serial_diff NUMBER;

Line 392: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

388: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
392: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
393: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
394: l_serial_transaction_temp_id NUMBER;
395: l_serial_diff NUMBER;
396: l_status_id NUMBER;

Line 393: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

389: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
390: l_st_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
391: l_rs_ser_group_mark_id_tbl inv_lot_trx_validation_pub.number_table;
392: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
393: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
394: l_serial_transaction_temp_id NUMBER;
395: l_serial_diff NUMBER;
396: l_status_id NUMBER;
397: l_group_mark_id NUMBER;

Line 398: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;

394: l_serial_transaction_temp_id NUMBER;
395: l_serial_diff NUMBER;
396: l_status_id NUMBER;
397: l_group_mark_id NUMBER;
398: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
399: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
400: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
401: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
402: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

Line 399: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;

395: l_serial_diff NUMBER;
396: l_status_id NUMBER;
397: l_group_mark_id NUMBER;
398: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
399: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
400: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
401: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
402: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
403: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

Line 400: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;

396: l_status_id NUMBER;
397: l_group_mark_id NUMBER;
398: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
399: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
400: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
401: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
402: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
403: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
404: l_rs_index NUMBER;

Line 401: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;

397: l_group_mark_id NUMBER;
398: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
399: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
400: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
401: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
402: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
403: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
404: l_rs_index NUMBER;
405: l_st_index NUMBER;

Line 402: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

398: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
399: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
400: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
401: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
402: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
403: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
404: l_rs_index NUMBER;
405: l_st_index NUMBER;
406: l_st_ser_index NUMBER;

Line 403: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

399: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
400: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
401: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
402: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
403: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
404: l_rs_index NUMBER;
405: l_st_index NUMBER;
406: l_st_ser_index NUMBER;
407: l_rs_ser_index NUMBER;

Line 416: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;

412: l_count NUMBER;
413: l_primary_quantity NUMBER;
414: l_primary_uom_code VARCHAR2 (3);
415: l_transaction_quantity NUMBER;
416: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
417: l_st_dist_account_id NUMBER;
418: l_rs_dist_account_id NUMBER;
419: l_validation_status VARCHAR2 (1);
420: l_start_primary_uom VARCHAR2 (3);

Line 434: l_st_item_id_tbl := inv_lot_trx_validation_pub.number_table ();

430: print_debug ('l_marker 10', 'Populate_REcords');
431: print_debug ('p_parent_id is ' || p_parent_id, 'Populate_Records');
432: END IF;
433:
434: l_st_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
435: l_st_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();

Line 435: l_st_org_id_tbl := inv_lot_trx_validation_pub.number_table ();

431: print_debug ('p_parent_id is ' || p_parent_id, 'Populate_Records');
432: END IF;
433:
434: l_st_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
435: l_st_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();

Line 436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();

432: END IF;
433:
434: l_st_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
435: l_st_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();

433:
434: l_st_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
435: l_st_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();

Line 438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();

434: l_st_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
435: l_st_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();

435: l_st_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();

436: l_st_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();

437: l_st_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();

438: l_st_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();

Line 443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();

439: l_st_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();

Line 444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();

440: l_st_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();

Line 445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();

441: l_st_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();

Line 446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();

442: l_st_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();

443: l_st_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();

Line 448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();

444: l_rs_item_id_tbl := inv_lot_trx_validation_pub.number_table ();
445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();

445: l_rs_org_id_tbl := inv_lot_trx_validation_pub.number_table ();
446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();

446: l_rs_revision_tbl := inv_lot_trx_validation_pub.revision_table ();
447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();

Line 451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();

447: l_rs_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();

Line 452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();

448: l_rs_primary_quantity_tbl := inv_lot_trx_validation_pub.number_table ();
449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();

Line 453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();

449: l_rs_uom_tbl := inv_lot_trx_validation_pub.uom_table ();
450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();

Line 454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();

450: l_rs_locator_id_tbl := inv_lot_trx_validation_pub.number_table ();
451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();

451: l_rs_sub_code_tbl := inv_lot_trx_validation_pub.sub_code_table ();
452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();

452: l_rs_lpn_id_tbl := inv_lot_trx_validation_pub.number_table ();
453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();

453: l_rs_cost_group_id_tbl := inv_lot_trx_validation_pub.number_table ();
454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();

454: l_st_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();

455: l_rs_lot_number_tbl := inv_lot_trx_validation_pub.lot_number_table ();
456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();

Line 460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();

456: l_st_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();

Line 461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();

457: l_rs_ser_status_tbl := inv_lot_trx_validation_pub.number_table ();
458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
465: l_rs_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();

Line 462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();

458: l_st_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
465: l_rs_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
466: l_acct_period_tbl := inv_lot_trx_validation_pub.number_table ();

Line 463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();

459: l_rs_ser_group_mark_id_tbl := inv_lot_trx_validation_pub.number_table ();
460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
465: l_rs_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
466: l_acct_period_tbl := inv_lot_trx_validation_pub.number_table ();
467: l_count := 0;

Line 464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();

460: l_st_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
465: l_rs_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
466: l_acct_period_tbl := inv_lot_trx_validation_pub.number_table ();
467: l_count := 0;
468: l_rs_index := 0;

Line 465: l_rs_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();

461: l_rs_interface_id_tbl := inv_lot_trx_validation_pub.number_table ();
462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
465: l_rs_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
466: l_acct_period_tbl := inv_lot_trx_validation_pub.number_table ();
467: l_count := 0;
468: l_rs_index := 0;
469: l_st_index := 0;

Line 466: l_acct_period_tbl := inv_lot_trx_validation_pub.number_table ();

462: l_st_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
463: l_rs_status_id_tbl := inv_lot_trx_validation_pub.number_table ();
464: l_st_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
465: l_rs_lot_exp_tbl := inv_lot_trx_validation_pub.date_table ();
466: l_acct_period_tbl := inv_lot_trx_validation_pub.number_table ();
467: l_count := 0;
468: l_rs_index := 0;
469: l_st_index := 0;
470: l_st_ser_index := 0;

Line 1855: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;

1851: l_transaction_type_id NUMBER;
1852: -- l_acct_period_id NUMBER;
1853: l_transaction_interface_id NUMBER;
1854: l_transaction_action_id NUMBER;
1855: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
1856: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 1856: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;

1852: -- l_acct_period_id NUMBER;
1853: l_transaction_interface_id NUMBER;
1854: l_transaction_action_id NUMBER;
1855: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
1856: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;

1853: l_transaction_interface_id NUMBER;
1854: l_transaction_action_id NUMBER;
1855: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
1856: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;

1854: l_transaction_action_id NUMBER;
1855: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
1856: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

1855: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
1856: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

1856: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

1857: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

1858: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

Line 1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

1859: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

Line 1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

1860: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

1861: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

1862: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

1863: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

1864: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

1865: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

Line 1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

1866: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

Line 1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

1867: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1875: --Added for OSFM Support to Serialized Lot Items

Line 1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

1868: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1875: --Added for OSFM Support to Serialized Lot Items
1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

Line 1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

1869: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1875: --Added for OSFM Support to Serialized Lot Items
1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

Line 1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

1870: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
1871: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1875: --Added for OSFM Support to Serialized Lot Items
1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

Line 1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

1872: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1875: --Added for OSFM Support to Serialized Lot Items
1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

1873: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1875: --Added for OSFM Support to Serialized Lot Items
1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

1874: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
1875: --Added for OSFM Support to Serialized Lot Items
1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

1875: --Added for OSFM Support to Serialized Lot Items
1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

1876: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1884: l_is_serial_control VARCHAR2 (1);

Line 1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

1877: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1884: l_is_serial_control VARCHAR2 (1);
1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

Line 1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

1878: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1884: l_is_serial_control VARCHAR2 (1);
1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

Line 1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

1879: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
1880: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1884: l_is_serial_control VARCHAR2 (1);
1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
1887: --Added for OSFM Support to Serialized Lot Items

Line 1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

1881: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1884: l_is_serial_control VARCHAR2 (1);
1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
1887: --Added for OSFM Support to Serialized Lot Items
1888: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
1889: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

1882: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1883: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
1884: l_is_serial_control VARCHAR2 (1);
1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
1887: --Added for OSFM Support to Serialized Lot Items
1888: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
1889: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
1890: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;

Line 1888: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;

1884: l_is_serial_control VARCHAR2 (1);
1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
1887: --Added for OSFM Support to Serialized Lot Items
1888: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
1889: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
1890: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1891: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1892: l_rs_index NUMBER;

Line 1889: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;

1885: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
1887: --Added for OSFM Support to Serialized Lot Items
1888: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
1889: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
1890: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1891: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1892: l_rs_index NUMBER;
1893: l_count NUMBER;

Line 1890: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;

1886: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
1887: --Added for OSFM Support to Serialized Lot Items
1888: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
1889: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
1890: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1891: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1892: l_rs_index NUMBER;
1893: l_count NUMBER;
1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 1891: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;

1887: --Added for OSFM Support to Serialized Lot Items
1888: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
1889: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
1890: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1891: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
1892: l_rs_index NUMBER;
1893: l_count NUMBER;
1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 1897: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

1893: l_count NUMBER;
1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1896: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1897: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1898: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1899: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
1900: l_wms_installed VARCHAR2 (1);
1901: l_wms_enabled VARCHAR2 (1);

Line 1898: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

1894: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1896: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1897: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1898: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1899: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
1900: l_wms_installed VARCHAR2 (1);
1901: l_wms_enabled VARCHAR2 (1);
1902: l_wsm_enabled VARCHAR2 (1);

Line 1899: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;

1895: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1896: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1897: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1898: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
1899: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
1900: l_wms_installed VARCHAR2 (1);
1901: l_wms_enabled VARCHAR2 (1);
1902: l_wsm_enabled VARCHAR2 (1);
1903: l_st_dist_account_id NUMBER;

Line 1994: inv_lot_trx_validation_pub.get_org_info

1990: print_debug ('breadcrumb 20', 'validate_lot_split_trx');
1991: END IF;
1992: /* Removing the check...
1993: -- If wms is not installed and wsm is not enabled, we do not support lot transactions through the interface
1994: inv_lot_trx_validation_pub.get_org_info
1995: (x_wms_installed => l_wms_installed
1996: , x_wsm_enabled => l_wsm_enabled
1997: , x_wms_enabled => l_wms_enabled
1998: , x_return_status => x_return_status

Line 2050: inv_lot_trx_validation_pub.validate_organization

2046: print_debug ('breadcrumb 60', 'validate_lot_split_trx');
2047: END IF;
2048:
2049: BEGIN
2050: inv_lot_trx_validation_pub.validate_organization
2051: (x_return_status => x_return_status
2052: , x_msg_count => x_msg_count
2053: , x_msg_data => x_msg_data
2054: , x_validation_status => l_validation_status

Line 2081: inv_lot_trx_validation_pub.validate_lots

2077: print_debug ('breadcrumb 70', 'validate_lot_split_trx');
2078: END IF;
2079:
2080: BEGIN
2081: inv_lot_trx_validation_pub.validate_lots
2082: (x_return_status => x_return_status
2083: , x_msg_count => x_msg_count
2084: , x_msg_data => x_msg_data
2085: , x_validation_status => l_validation_status

Line 2138: inv_lot_trx_validation_pub.validate_material_status

2134: THEN
2135: print_debug ('breadcrumb 100', 'validate_lot_split_trx');
2136: END IF;
2137:
2138: inv_lot_trx_validation_pub.validate_material_status
2139: (x_return_status => x_return_status
2140: , x_msg_count => x_msg_count
2141: , x_msg_data => x_msg_data
2142: , x_validation_status => l_validation_status

Line 2239: inv_lot_trx_validation_pub.validate_cost_groups

2235: THEN
2236: print_debug ('breadcrumb 150', 'validate_lot_split_trx');
2237: END IF;
2238:
2239: inv_lot_trx_validation_pub.validate_cost_groups
2240: (x_rs_cost_group_tbl => l_rs_cost_group_id_tbl
2241: , x_return_status => x_return_status
2242: , x_msg_count => x_msg_count
2243: , x_msg_data => x_msg_data

Line 2305: inv_lot_trx_validation_pub.validate_quantity

2301: print_debug ('breadcrumb 170', 'validate_lot_split_trx');
2302: END IF;
2303:
2304:
2305: inv_lot_trx_validation_pub.validate_quantity
2306: (x_return_status => x_return_status
2307: , x_msg_count => x_msg_count
2308: , x_msg_data => x_msg_data
2309: , x_validation_status => l_validation_status

Line 2374: inv_lot_trx_validation_pub.validate_lpn_info

2370: print_debug ('breadcrumb 191', 'validate_lot_split_trx');
2371: END IF;
2372:
2373:
2374: inv_lot_trx_validation_pub.validate_lpn_info
2375: (x_return_status => x_return_status
2376: , x_msg_count => x_msg_count
2377: , x_msg_data => x_msg_data
2378: , x_validation_status => l_validation_status

Line 2480: inv_lot_trx_validation_pub.validate_serials

2476: , 'Validate_lot_Split_Trx'
2477: );
2478: END IF;
2479:
2480: inv_lot_trx_validation_pub.validate_serials
2481: (x_return_status => x_return_status
2482: , x_msg_count => x_msg_count
2483: , x_msg_data => x_msg_data
2484: , x_validation_status => l_validation_status

Line 2620: inv_lot_trx_validation_pub.validate_attributes

2616: print_debug ('calling validate_attributes', 'Validate_lot_split_trx');
2617: END IF;
2618:
2619: BEGIN
2620: inv_lot_trx_validation_pub.validate_attributes
2621: (x_return_status => x_return_status
2622: , x_msg_count => x_msg_count
2623: , x_msg_data => x_msg_data
2624: , x_validation_status => l_validation_status

Line 2677: inv_lot_trx_validation_pub.compute_lot_expiration

2673: END LOOP;
2674:
2675: -- Call to compute the correct expiration date
2676: BEGIN
2677: inv_lot_trx_validation_pub.compute_lot_expiration
2678: (x_return_status => x_return_status
2679: , x_msg_count => x_msg_count
2680: , x_msg_data => x_msg_data
2681: , p_parent_id => p_parent_id

Line 2754: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;

2750: l_transaction_type_id NUMBER;
2751: -- l_acct_period_id NUMBER;
2752: l_transaction_interface_id NUMBER;
2753: l_transaction_action_id NUMBER;
2754: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
2755: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 2755: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;

2751: -- l_acct_period_id NUMBER;
2752: l_transaction_interface_id NUMBER;
2753: l_transaction_action_id NUMBER;
2754: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
2755: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;

2752: l_transaction_interface_id NUMBER;
2753: l_transaction_action_id NUMBER;
2754: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
2755: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;

2753: l_transaction_action_id NUMBER;
2754: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
2755: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

2754: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
2755: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

2755: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

2756: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

2757: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

Line 2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

2758: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

Line 2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

2759: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

2760: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

2761: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

2762: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

2763: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

2764: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

Line 2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

2765: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2773: --Added for OSFM Support to Serialized Lot Items

Line 2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

2766: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2773: --Added for OSFM Support to Serialized Lot Items
2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

Line 2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

2767: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2773: --Added for OSFM Support to Serialized Lot Items
2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

Line 2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

2768: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
2769: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2773: --Added for OSFM Support to Serialized Lot Items
2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

Line 2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

2770: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2773: --Added for OSFM Support to Serialized Lot Items
2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

2771: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2773: --Added for OSFM Support to Serialized Lot Items
2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

2772: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2773: --Added for OSFM Support to Serialized Lot Items
2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

2773: --Added for OSFM Support to Serialized Lot Items
2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

2774: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2782: l_is_serial_controlled VARCHAR2 (1);

Line 2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

2775: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2782: l_is_serial_controlled VARCHAR2 (1);
2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

Line 2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

2776: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2782: l_is_serial_controlled VARCHAR2 (1);
2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

Line 2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

2777: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
2778: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2782: l_is_serial_controlled VARCHAR2 (1);
2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
2785: --Added for OSFM Support to Serialized Lot Items

Line 2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

2779: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2782: l_is_serial_controlled VARCHAR2 (1);
2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
2785: --Added for OSFM Support to Serialized Lot Items
2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

2780: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2781: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
2782: l_is_serial_controlled VARCHAR2 (1);
2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
2785: --Added for OSFM Support to Serialized Lot Items
2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

2782: l_is_serial_controlled VARCHAR2 (1);
2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
2785: --Added for OSFM Support to Serialized Lot Items
2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;

Line 2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;

2783: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
2785: --Added for OSFM Support to Serialized Lot Items
2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

Line 2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;

2784: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
2785: --Added for OSFM Support to Serialized Lot Items
2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

Line 2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;

2785: --Added for OSFM Support to Serialized Lot Items
2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2793: l_rs_index NUMBER;

Line 2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;

2786: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2793: l_rs_index NUMBER;
2794: l_count NUMBER;

Line 2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

2787: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2793: l_rs_index NUMBER;
2794: l_count NUMBER;
2795: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

2788: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
2789: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2790: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
2791: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2792: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
2793: l_rs_index NUMBER;
2794: l_count NUMBER;
2795: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2796: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 2803: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;

2799: := NULL;
2800: l_max_lot_qty NUMBER := 0;
2801: l_lot_number mtl_transaction_lots_interface.lot_number%TYPE
2802: := NULL;
2803: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
2804: l_wms_installed VARCHAR2 (1);
2805: l_wms_enabled VARCHAR2 (1);
2806: l_wsm_enabled VARCHAR2 (1);
2807: l_st_dist_account_id NUMBER;

Line 2890: inv_lot_trx_validation_pub.get_org_info

2886: RAISE fnd_api.g_exc_error;
2887: END IF;
2888: /*Removing the check...
2889: -- If wms is not installed and wsm is not enabled, we do not support lot transactions through the interface
2890: inv_lot_trx_validation_pub.get_org_info
2891: (x_wms_installed => l_wms_installed
2892: , x_wsm_enabled => l_wsm_enabled
2893: , x_wms_enabled => l_wms_enabled
2894: , x_return_status => x_return_status

Line 2931: inv_lot_trx_validation_pub.validate_organization

2927: print_debug ('calling Validate_Organization', 'Validate_lot_Split_Trx');
2928: END IF;
2929:
2930: BEGIN
2931: inv_lot_trx_validation_pub.validate_organization
2932: (x_return_status => x_return_status
2933: , x_msg_count => x_msg_count
2934: , x_msg_data => x_msg_data
2935: , x_validation_status => l_validation_status

Line 2961: inv_lot_trx_validation_pub.validate_lots

2957: THEN
2958: print_debug ('calling validate_lots', 'validate_lot_merge_trx');
2959: END IF;
2960:
2961: inv_lot_trx_validation_pub.validate_lots
2962: (x_return_status => x_return_status
2963: , x_msg_count => x_msg_count
2964: , x_msg_data => x_msg_data
2965: , x_validation_status => l_validation_status

Line 2997: inv_lot_trx_validation_pub.validate_material_status

2993: END IF;
2994:
2995: FOR i IN 1 .. l_st_lot_number_tbl.COUNT
2996: LOOP
2997: inv_lot_trx_validation_pub.validate_material_status
2998: (x_return_status => x_return_status
2999: , x_msg_count => x_msg_count
3000: , x_msg_data => x_msg_data
3001: , x_validation_status => l_validation_status

Line 3068: inv_lot_trx_validation_pub.validate_cost_groups

3064: THEN
3065: print_debug ('calling validate_cost_groups', 'validate_lot_merge_trx');
3066: END IF;
3067:
3068: inv_lot_trx_validation_pub.validate_cost_groups
3069: (x_rs_cost_group_tbl => l_rs_cost_group_id_tbl
3070: , x_return_status => x_return_status
3071: , x_msg_count => x_msg_count
3072: , x_msg_data => x_msg_data

Line 3116: inv_lot_trx_validation_pub.validate_quantity

3112: THEN
3113: print_debug ('calling validate_quantity', 'validate_lot_merge_trx');
3114: END IF;
3115:
3116: inv_lot_trx_validation_pub.validate_quantity
3117: (x_return_status => x_return_status
3118: , x_msg_count => x_msg_count
3119: , x_msg_data => x_msg_data
3120: , x_validation_status => l_validation_status

Line 3171: inv_lot_trx_validation_pub.validate_lpn_info

3167: END IF;
3168:
3169:
3170:
3171: inv_lot_trx_validation_pub.validate_lpn_info
3172: (x_return_status => x_return_status
3173: , x_msg_count => x_msg_count
3174: , x_msg_data => x_msg_data
3175: , x_validation_status => l_validation_status

Line 3272: inv_lot_trx_validation_pub.validate_serials

3268: , 'Validate_lot_Merge_Trx'
3269: );
3270: END IF;
3271:
3272: inv_lot_trx_validation_pub.validate_serials
3273: (x_return_status => x_return_status
3274: , x_msg_count => x_msg_count
3275: , x_msg_data => x_msg_data
3276: , x_validation_status => l_validation_status

Line 3413: inv_lot_trx_validation_pub.validate_attributes

3409: THEN
3410: print_debug ('calling validate_attributes', 'Validate_lot_merge_trx');
3411: END IF;
3412:
3413: inv_lot_trx_validation_pub.validate_attributes
3414: (x_return_status => x_return_status
3415: , x_msg_count => x_msg_count
3416: , x_msg_data => x_msg_data
3417: , x_validation_status => l_validation_status

Line 3462: inv_lot_trx_validation_pub.compute_lot_expiration

3458: -- Call to compute the correct expiration dates
3459: BEGIN
3460: l_st_lot_number_tbl (1) := l_lot_number;
3461: -- Send in just one lot number
3462: inv_lot_trx_validation_pub.compute_lot_expiration
3463: (x_return_status => x_return_status
3464: , x_msg_count => x_msg_count
3465: , x_msg_data => x_msg_data
3466: , p_parent_id => p_parent_id

Line 3539: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;

3535: l_transaction_type_id NUMBER;
3536: -- l_acct_period_id NUMBER;
3537: l_transaction_interface_id NUMBER;
3538: l_transaction_action_id NUMBER;
3539: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
3540: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 3540: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;

3536: -- l_acct_period_id NUMBER;
3537: l_transaction_interface_id NUMBER;
3538: l_transaction_action_id NUMBER;
3539: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
3540: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;

3537: l_transaction_interface_id NUMBER;
3538: l_transaction_action_id NUMBER;
3539: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
3540: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;

3538: l_transaction_action_id NUMBER;
3539: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
3540: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;

3539: l_st_item_id_tbl inv_lot_trx_validation_pub.number_table;
3540: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;

3540: l_st_org_id_tbl inv_lot_trx_validation_pub.number_table;
3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

3541: l_st_revision_tbl inv_lot_trx_validation_pub.revision_table;
3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

3542: l_st_quantity_tbl inv_lot_trx_validation_pub.number_table;
3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

Line 3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

3543: l_st_uom_tbl inv_lot_trx_validation_pub.uom_table;
3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

Line 3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;

3544: l_st_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

Line 3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;

3545: l_st_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;

3546: l_st_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

Line 3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;

3547: l_st_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;

3548: l_rs_item_id_tbl inv_lot_trx_validation_pub.number_table;
3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;

3549: l_rs_org_id_tbl inv_lot_trx_validation_pub.number_table;
3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

Line 3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;

3550: l_rs_revision_tbl inv_lot_trx_validation_pub.revision_table;
3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

Line 3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;

3551: l_rs_quantity_tbl inv_lot_trx_validation_pub.number_table;
3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3559: --Added for OSFM Support to Serialized Lot Items

Line 3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;

3552: l_rs_uom_tbl inv_lot_trx_validation_pub.uom_table;
3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3559: --Added for OSFM Support to Serialized Lot Items
3560: l_is_serial_controlled VARCHAR2 (1);

Line 3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

3553: l_rs_locator_id_tbl inv_lot_trx_validation_pub.number_table;
3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3559: --Added for OSFM Support to Serialized Lot Items
3560: l_is_serial_controlled VARCHAR2 (1);
3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

Line 3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;

3554: l_rs_sub_code_tbl inv_lot_trx_validation_pub.sub_code_table;
3555: l_rs_lpn_id_tbl inv_lot_trx_validation_pub.number_table;
3556: l_rs_cost_group_id_tbl inv_lot_trx_validation_pub.number_table;
3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3559: --Added for OSFM Support to Serialized Lot Items
3560: l_is_serial_controlled VARCHAR2 (1);
3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

Line 3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

3557: l_st_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3559: --Added for OSFM Support to Serialized Lot Items
3560: l_is_serial_controlled VARCHAR2 (1);
3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

3558: l_rs_lot_number_tbl inv_lot_trx_validation_pub.lot_number_table;
3559: --Added for OSFM Support to Serialized Lot Items
3560: l_is_serial_controlled VARCHAR2 (1);
3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

Line 3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;

3559: --Added for OSFM Support to Serialized Lot Items
3560: l_is_serial_controlled VARCHAR2 (1);
3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;

3560: l_is_serial_controlled VARCHAR2 (1);
3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;

3561: l_st_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

Line 3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;

3562: l_st_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

Line 3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

3563: l_rs_ser_parent_lot_tbl inv_lot_trx_validation_pub.parent_lot_table;
3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
3571: --Added for OSFM Support to Serialized Lot Items

Line 3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;

3564: l_rs_ser_number_tbl inv_lot_trx_validation_pub.serial_number_table;
3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
3571: --Added for OSFM Support to Serialized Lot Items
3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;

3565: l_st_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
3571: --Added for OSFM Support to Serialized Lot Items
3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
3573: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;

3566: l_rs_ser_status_tbl inv_lot_trx_validation_pub.number_table;
3567: l_st_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
3571: --Added for OSFM Support to Serialized Lot Items
3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
3573: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
3574: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;

Line 3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;

3568: l_rs_ser_grp_mark_id_tbl inv_lot_trx_validation_pub.number_table;
3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
3571: --Added for OSFM Support to Serialized Lot Items
3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
3573: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
3574: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3575: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3576: l_rs_index NUMBER;

Line 3573: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;

3569: l_st_ser_parent_sub_tbl inv_lot_trx_validation_pub.parent_sub_table;
3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
3571: --Added for OSFM Support to Serialized Lot Items
3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
3573: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
3574: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3575: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3576: l_rs_index NUMBER;
3577: l_count NUMBER;

Line 3574: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;

3570: l_st_ser_parent_loc_tbl inv_lot_trx_validation_pub.parent_loc_table;
3571: --Added for OSFM Support to Serialized Lot Items
3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
3573: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
3574: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3575: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3576: l_rs_index NUMBER;
3577: l_count NUMBER;
3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 3575: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;

3571: --Added for OSFM Support to Serialized Lot Items
3572: l_st_status_id_tbl inv_lot_trx_validation_pub.number_table;
3573: l_rs_status_id_tbl inv_lot_trx_validation_pub.number_table;
3574: l_st_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3575: l_rs_interface_id_tbl inv_lot_trx_validation_pub.number_table;
3576: l_rs_index NUMBER;
3577: l_count NUMBER;
3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3579: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

Line 3580: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

3576: l_rs_index NUMBER;
3577: l_count NUMBER;
3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3579: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3580: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3581: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3582: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3583: l_distribution_account_id wsm_parameters.transaction_account_id%TYPE
3584: := NULL;

Line 3581: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;

3577: l_count NUMBER;
3578: l_st_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3579: l_rs_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3580: l_st_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3581: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3582: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3583: l_distribution_account_id wsm_parameters.transaction_account_id%TYPE
3584: := NULL;
3585: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;

Line 3585: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;

3581: l_rs_lot_exp_tbl inv_lot_trx_validation_pub.date_table;
3582: l_lot_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3583: l_distribution_account_id wsm_parameters.transaction_account_id%TYPE
3584: := NULL;
3585: l_acct_period_tbl inv_lot_trx_validation_pub.number_table;
3586: l_wms_installed VARCHAR2 (1);
3587: l_wms_enabled VARCHAR2 (1);
3588: l_wsm_enabled VARCHAR2 (1);
3589: l_st_dist_account_id NUMBER;

Line 3680: inv_lot_trx_validation_pub.get_org_info

3676: THEN
3677: print_debug ('calling get_org_info', 'Validate_lot_translate_Trx');
3678: END IF;
3679:
3680: inv_lot_trx_validation_pub.get_org_info
3681: (x_wms_installed => l_wms_installed
3682: , x_wsm_enabled => l_wsm_enabled
3683: , x_wms_enabled => l_wms_enabled
3684: , x_return_status => x_return_status

Line 3735: inv_lot_trx_validation_pub.validate_organization

3731: print_debug ('calling Validate_Organization', 'Validate_lot_Split_Trx');
3732: END IF;
3733:
3734: BEGIN
3735: inv_lot_trx_validation_pub.validate_organization
3736: (x_return_status => x_return_status
3737: , x_msg_count => x_msg_count
3738: , x_msg_data => x_msg_data
3739: , x_validation_status => l_validation_status

Line 3918: inv_lot_trx_validation_pub.validate_lots

3914: THEN
3915: print_debug ('Calling validate_lots', 'Validate_lot_translate');
3916: END IF;
3917:
3918: inv_lot_trx_validation_pub.validate_lots
3919: (x_return_status => x_return_status
3920: , x_msg_count => x_msg_count
3921: , x_msg_data => x_msg_data
3922: , x_validation_status => l_validation_status

Line 3952: inv_lot_trx_validation_pub.validate_material_status

3948: , 'Validate_lot_translate'
3949: );
3950: END IF;
3951:
3952: inv_lot_trx_validation_pub.validate_material_status
3953: (x_return_status => x_return_status
3954: , x_msg_count => x_msg_count
3955: , x_msg_data => x_msg_data
3956: , x_validation_status => l_validation_status

Line 4019: inv_lot_trx_validation_pub.validate_cost_groups

4015: THEN
4016: print_debug ('Calling validate_cost_groups', 'Validate_lot_translate');
4017: END IF;
4018:
4019: inv_lot_trx_validation_pub.validate_cost_groups
4020: (x_rs_cost_group_tbl => l_rs_cost_group_id_tbl
4021: , x_return_status => x_return_status
4022: , x_msg_count => x_msg_count
4023: , x_msg_data => x_msg_data

Line 4068: inv_lot_trx_validation_pub.validate_quantity

4064: THEN
4065: print_debug ('Calling validate_quantity', 'Validate_lot_translate');
4066: END IF;
4067:
4068: inv_lot_trx_validation_pub.validate_quantity
4069: (x_return_status => x_return_status
4070: , x_msg_count => x_msg_count
4071: , x_msg_data => x_msg_data
4072: , x_validation_status => l_validation_status

Line 4129: inv_lot_trx_validation_pub.validate_lpn_info

4125: END IF;
4126:
4127:
4128:
4129: inv_lot_trx_validation_pub.validate_lpn_info
4130: (x_return_status => x_return_status
4131: , x_msg_count => x_msg_count
4132: , x_msg_data => x_msg_data
4133: , x_validation_status => l_validation_status

Line 4231: inv_lot_trx_validation_pub.validate_serials

4227: , 'Validate_lot_Translate_Trx'
4228: );
4229: END IF;
4230:
4231: inv_lot_trx_validation_pub.validate_serials
4232: (x_return_status => x_return_status
4233: , x_msg_count => x_msg_count
4234: , x_msg_data => x_msg_data
4235: , x_validation_status => l_validation_status

Line 4347: inv_lot_trx_validation_pub.validate_attributes

4343: , 'Validate_lot_translate'
4344: );
4345: END IF;
4346:
4347: inv_lot_trx_validation_pub.validate_attributes
4348: (x_return_status => x_return_status
4349: , x_msg_count => x_msg_count
4350: , x_msg_data => x_msg_data
4351: , x_validation_status => l_validation_status

Line 4391: inv_lot_trx_validation_pub.compute_lot_expiration

4387: --end loop;
4388: -- Call to compute the correct expiration dates
4389: BEGIN
4390: -- Send in just one lot number
4391: inv_lot_trx_validation_pub.compute_lot_expiration
4392: (x_return_status => x_return_status
4393: , x_msg_count => x_msg_count
4394: , x_msg_data => x_msg_data
4395: , p_parent_id => p_parent_id