2129: l_msg_data VARCHAR2(2000);
2130: l_Msg_Count NUMBER;
2131: l_Return_Status VARCHAR2(1);
2132: l_Error_Message VARCHAR2(2000);
2133: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2134: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2135: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2130: l_Msg_Count NUMBER;
2131: l_Return_Status VARCHAR2(1);
2132: l_Error_Message VARCHAR2(2000);
2133: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2134: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2135: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2138: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2131: l_Return_Status VARCHAR2(1);
2132: l_Error_Message VARCHAR2(2000);
2133: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2134: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2135: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2138: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2139: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2132: l_Error_Message VARCHAR2(2000);
2133: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2134: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2135: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2138: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2139: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2140: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2133: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2134: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2135: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2138: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2139: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2140: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2141: l_time_stamp date;
2134: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2135: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2138: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2139: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2140: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2141: l_time_stamp date;
2142:
2135: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2138: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2139: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2140: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2141: l_time_stamp date;
2142:
2143: CURSOR fa_location_cur IS
2136: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2137: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2138: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2139: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2140: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2141: l_time_stamp date;
2142:
2143: CURSOR fa_location_cur IS
2144: SELECT cal.fa_location_id fa_location_id