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
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
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
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: ,
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
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
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
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
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
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
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
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
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
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: ,
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: )
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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);
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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 ();
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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;
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;
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;
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;
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;
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;
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;
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);
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;
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;
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
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;
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;
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;
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;
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;
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;
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);
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);
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;
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
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
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
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
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
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
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
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
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
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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;
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;
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;
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;
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;
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;
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;
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);
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;
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;
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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
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
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
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
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
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
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
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
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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);
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;
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;
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;
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;
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;
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;
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;
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;
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
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;
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;
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;
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;
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;
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;
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;
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;
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;
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;
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
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
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
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
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
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
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
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
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
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