34:
35: l_serial_number VARCHAR2(1000);
36: l_instance_qty NUMBER;
37: l_instance_end_date DATE;
38: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
39: l_location_tbl csi_item_instance_pvt.location_tbl;
40: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
41: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
35: l_serial_number VARCHAR2(1000);
36: l_instance_qty NUMBER;
37: l_instance_end_date DATE;
38: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
39: l_location_tbl csi_item_instance_pvt.location_tbl;
40: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
41: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
43:
36: l_instance_qty NUMBER;
37: l_instance_end_date DATE;
38: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
39: l_location_tbl csi_item_instance_pvt.location_tbl;
40: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
41: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
43:
44: l_u_instance_rec csi_datastructures_pub.instance_rec;
37: l_instance_end_date DATE;
38: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
39: l_location_tbl csi_item_instance_pvt.location_tbl;
40: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
41: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
43:
44: l_u_instance_rec csi_datastructures_pub.instance_rec;
45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
38: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
39: l_location_tbl csi_item_instance_pvt.location_tbl;
40: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
41: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
42: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
43:
44: l_u_instance_rec csi_datastructures_pub.instance_rec;
45: l_u_parties_tbl csi_datastructures_pub.party_tbl;
46: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
138: debug(' quantity : '||l_u_instance_rec.quantity );
139: debug(' p_asset_quantity : '||p_asset_quantity );
140: debug(' l_instance_qty : '||l_instance_qty );
141: END IF;
142: csi_item_instance_pvt.update_item_instance(
143: p_api_version => 1.0,
144: p_commit => fnd_api.g_false,
145: p_init_msg_list => fnd_api.g_true,
146: p_validation_level => fnd_api.g_valid_level_full,