3:
4:
5:
6:
7: SUBTYPE transaction_rec IS csi_datastructures_pub.transaction_rec;
8:
9: ----------------------------------------------------------------------------------
10: -- Start of comments
11: --
762: p_instance_id IN NUMBER,
763: p_location_id IN NUMBER,
764: p_install_location_id IN NUMBER DEFAULT NULL) IS
765:
766: SUBTYPE instance_rec IS csi_datastructures_pub.instance_rec;
767: SUBTYPE id_tbl IS csi_datastructures_pub.id_tbl;
768: SUBTYPE instance_query_rec IS csi_datastructures_pub.instance_query_rec;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
763: p_location_id IN NUMBER,
764: p_install_location_id IN NUMBER DEFAULT NULL) IS
765:
766: SUBTYPE instance_rec IS csi_datastructures_pub.instance_rec;
767: SUBTYPE id_tbl IS csi_datastructures_pub.id_tbl;
768: SUBTYPE instance_query_rec IS csi_datastructures_pub.instance_query_rec;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
764: p_install_location_id IN NUMBER DEFAULT NULL) IS
765:
766: SUBTYPE instance_rec IS csi_datastructures_pub.instance_rec;
767: SUBTYPE id_tbl IS csi_datastructures_pub.id_tbl;
768: SUBTYPE instance_query_rec IS csi_datastructures_pub.instance_query_rec;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
765:
766: SUBTYPE instance_rec IS csi_datastructures_pub.instance_rec;
767: SUBTYPE id_tbl IS csi_datastructures_pub.id_tbl;
768: SUBTYPE instance_query_rec IS csi_datastructures_pub.instance_query_rec;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
766: SUBTYPE instance_rec IS csi_datastructures_pub.instance_rec;
767: SUBTYPE id_tbl IS csi_datastructures_pub.id_tbl;
768: SUBTYPE instance_query_rec IS csi_datastructures_pub.instance_query_rec;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
767: SUBTYPE id_tbl IS csi_datastructures_pub.id_tbl;
768: SUBTYPE instance_query_rec IS csi_datastructures_pub.instance_query_rec;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
775: SUBTYPE pricing_attribs_tbl IS csi_datastructures_pub.pricing_attribs_tbl;
768: SUBTYPE instance_query_rec IS csi_datastructures_pub.instance_query_rec;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
775: SUBTYPE pricing_attribs_tbl IS csi_datastructures_pub.pricing_attribs_tbl;
776: SUBTYPE organization_units_tbl IS csi_datastructures_pub.organization_units_tbl;
769: SUBTYPE party_query_rec IS csi_datastructures_pub.party_query_rec;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
775: SUBTYPE pricing_attribs_tbl IS csi_datastructures_pub.pricing_attribs_tbl;
776: SUBTYPE organization_units_tbl IS csi_datastructures_pub.organization_units_tbl;
777: SUBTYPE instance_asset_tbl IS csi_datastructures_pub.instance_asset_tbl;
770: SUBTYPE party_account_query_rec IS csi_datastructures_pub.party_account_query_rec;
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
775: SUBTYPE pricing_attribs_tbl IS csi_datastructures_pub.pricing_attribs_tbl;
776: SUBTYPE organization_units_tbl IS csi_datastructures_pub.organization_units_tbl;
777: SUBTYPE instance_asset_tbl IS csi_datastructures_pub.instance_asset_tbl;
778:
771: SUBTYPE instance_header_tbl IS csi_datastructures_pub.instance_header_tbl;
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
775: SUBTYPE pricing_attribs_tbl IS csi_datastructures_pub.pricing_attribs_tbl;
776: SUBTYPE organization_units_tbl IS csi_datastructures_pub.organization_units_tbl;
777: SUBTYPE instance_asset_tbl IS csi_datastructures_pub.instance_asset_tbl;
778:
779: -- Get Item Instance parameters
772: SUBTYPE extend_attrib_values_tbl IS csi_datastructures_pub.extend_attrib_values_tbl;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
775: SUBTYPE pricing_attribs_tbl IS csi_datastructures_pub.pricing_attribs_tbl;
776: SUBTYPE organization_units_tbl IS csi_datastructures_pub.organization_units_tbl;
777: SUBTYPE instance_asset_tbl IS csi_datastructures_pub.instance_asset_tbl;
778:
779: -- Get Item Instance parameters
780: l_instance_query_rec instance_query_rec;
773: SUBTYPE party_tbl IS csi_datastructures_pub.party_tbl;
774: SUBTYPE party_account_tbl IS csi_datastructures_pub.party_account_tbl;
775: SUBTYPE pricing_attribs_tbl IS csi_datastructures_pub.pricing_attribs_tbl;
776: SUBTYPE organization_units_tbl IS csi_datastructures_pub.organization_units_tbl;
777: SUBTYPE instance_asset_tbl IS csi_datastructures_pub.instance_asset_tbl;
778:
779: -- Get Item Instance parameters
780: l_instance_query_rec instance_query_rec;
781: l_party_query_rec party_query_rec;