618: l_transaction_type_id NUMBER;
619: l_attribute_id NUMBER;
620: l_attribute_value_id NUMBER;
621: l_attribute_value csi_iea_values.attribute_value%TYPE;
622: l_csi_instance_rec csi_datastructures_pub.instance_rec;
623: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
624: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
625: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
626:
619: l_attribute_id NUMBER;
620: l_attribute_value_id NUMBER;
621: l_attribute_value csi_iea_values.attribute_value%TYPE;
622: l_csi_instance_rec csi_datastructures_pub.instance_rec;
623: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
624: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
625: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
626:
627: CURSOR get_serial_number(c_instance_id NUMBER) IS
620: l_attribute_value_id NUMBER;
621: l_attribute_value csi_iea_values.attribute_value%TYPE;
622: l_csi_instance_rec csi_datastructures_pub.instance_rec;
623: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
624: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
625: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
626:
627: CURSOR get_serial_number(c_instance_id NUMBER) IS
628: SELECT serial_number, mfg_serial_number_flag
621: l_attribute_value csi_iea_values.attribute_value%TYPE;
622: l_csi_instance_rec csi_datastructures_pub.instance_rec;
623: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
624: l_csi_extend_attrib_rec csi_datastructures_pub.extend_attrib_values_rec;
625: l_csi_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
626:
627: CURSOR get_serial_number(c_instance_id NUMBER) IS
628: SELECT serial_number, mfg_serial_number_flag
629: FROM csi_item_instances
1174: l_msg_count NUMBER;
1175: l_msg_data VARCHAR2(2000);
1176: l_uc_header_rec get_uc_header%ROWTYPE;
1177: l_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
1178: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1179: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1180: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1181: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1182: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1175: l_msg_data VARCHAR2(2000);
1176: l_uc_header_rec get_uc_header%ROWTYPE;
1177: l_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
1178: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1179: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1180: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1181: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1182: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1183: l_csi_relationship_id NUMBER;
1176: l_uc_header_rec get_uc_header%ROWTYPE;
1177: l_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
1178: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1179: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1180: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1181: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1182: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1183: l_csi_relationship_id NUMBER;
1184: l_transaction_type_id NUMBER;
1177: l_uc_status ahl_unit_config_headers.unit_config_status_code%TYPE;
1178: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1179: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1180: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1181: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1182: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1183: l_csi_relationship_id NUMBER;
1184: l_transaction_type_id NUMBER;
1185: l_return_value BOOLEAN;
1178: l_csi_transaction_rec csi_datastructures_pub.transaction_rec;
1179: l_csi_upd_transaction_rec csi_datastructures_pub.transaction_rec;
1180: l_csi_instance_rec csi_datastructures_pub.instance_rec;
1181: l_csi_relationship_rec csi_datastructures_pub.ii_relationship_rec;
1182: l_csi_instance_id_lst csi_datastructures_pub.id_tbl;
1183: l_csi_relationship_id NUMBER;
1184: l_transaction_type_id NUMBER;
1185: l_return_value BOOLEAN;
1186: l_csi_instance_ovn NUMBER;