2393: l_msg_data VARCHAR2(2000);
2394: l_Msg_Count NUMBER;
2395: l_Return_Status VARCHAR2(1);
2396: l_Error_Message VARCHAR2(2000);
2397: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2398: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2399: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2394: l_Msg_Count NUMBER;
2395: l_Return_Status VARCHAR2(1);
2396: l_Error_Message VARCHAR2(2000);
2397: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2398: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2399: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2402: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2395: l_Return_Status VARCHAR2(1);
2396: l_Error_Message VARCHAR2(2000);
2397: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2398: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2399: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2402: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2403: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2396: l_Error_Message VARCHAR2(2000);
2397: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2398: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2399: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2402: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2403: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2404: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2397: l_instance_rec csi_datastructures_pub.instance_header_rec ;
2398: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2399: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2402: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2403: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2404: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2405: l_time_stamp date;
2398: l_party_header_tbl csi_datastructures_pub.party_header_tbl ;
2399: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2402: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2403: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2404: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2405: l_time_stamp date;
2406:
2399: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl ;
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2402: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2403: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2404: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2405: l_time_stamp date;
2406:
2407: CURSOR fa_location_cur IS
2400: l_org_header_tbl csi_datastructures_pub.org_units_header_tbl ;
2401: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl ;
2402: l_ext_attrib_tbl csi_datastructures_pub.extend_attrib_values_tbl ;
2403: l_ext_attrib_def_tbl csi_datastructures_pub.extend_attrib_tbl ;
2404: l_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
2405: l_time_stamp date;
2406:
2407: CURSOR fa_location_cur IS
2408: SELECT cal.fa_location_id fa_location_id