1233: l_csiip_obj_ver_num Number := NULL;
1234: l_instance_account_id Number := NULL;
1235: l_inst_acct_obj_ver_num Number := NULL;
1236: l_object_version_number Number := NULL;
1237: l_instance_rec csi_datastructures_pub.instance_rec;
1238: l_party_tbl csi_datastructures_pub.party_tbl;
1239: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1234: l_instance_account_id Number := NULL;
1235: l_inst_acct_obj_ver_num Number := NULL;
1236: l_object_version_number Number := NULL;
1237: l_instance_rec csi_datastructures_pub.instance_rec;
1238: l_party_tbl csi_datastructures_pub.party_tbl;
1239: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1235: l_inst_acct_obj_ver_num Number := NULL;
1236: l_object_version_number Number := NULL;
1237: l_instance_rec csi_datastructures_pub.instance_rec;
1238: l_party_tbl csi_datastructures_pub.party_tbl;
1239: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1243: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1236: l_object_version_number Number := NULL;
1237: l_instance_rec csi_datastructures_pub.instance_rec;
1238: l_party_tbl csi_datastructures_pub.party_tbl;
1239: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1243: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1244: l_txn_rec csi_datastructures_pub.transaction_rec;
1237: l_instance_rec csi_datastructures_pub.instance_rec;
1238: l_party_tbl csi_datastructures_pub.party_tbl;
1239: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1243: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1244: l_txn_rec csi_datastructures_pub.transaction_rec;
1245: x_instance_id_lst csi_datastructures_pub.id_tbl;
1238: l_party_tbl csi_datastructures_pub.party_tbl;
1239: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1243: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1244: l_txn_rec csi_datastructures_pub.transaction_rec;
1245: x_instance_id_lst csi_datastructures_pub.id_tbl;
1246:
1239: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1243: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1244: l_txn_rec csi_datastructures_pub.transaction_rec;
1245: x_instance_id_lst csi_datastructures_pub.id_tbl;
1246:
1247: -- variables for create TCA relationship
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1243: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1244: l_txn_rec csi_datastructures_pub.transaction_rec;
1245: x_instance_id_lst csi_datastructures_pub.id_tbl;
1246:
1247: -- variables for create TCA relationship
1248: l_current_owner_party_type Varchar2(150) := NULL;
1241: l_pricing_attrib_tbl csi_datastructures_pub.pricing_attribs_tbl;
1242: l_org_assignments_tbl csi_datastructures_pub.organization_units_tbl;
1243: l_asset_assignment_tbl csi_datastructures_pub.instance_asset_tbl;
1244: l_txn_rec csi_datastructures_pub.transaction_rec;
1245: x_instance_id_lst csi_datastructures_pub.id_tbl;
1246:
1247: -- variables for create TCA relationship
1248: l_current_owner_party_type Varchar2(150) := NULL;
1249: l_new_owner_party_type Varchar2(150) := NULL;
3694:
3695: l_exists VARCHAR2(1);
3696:
3697: -- csi datastructures.
3698: l_party_tbl csi_datastructures_pub.party_tbl;
3699: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3700: l_txn_rec csi_datastructures_pub.transaction_rec;
3701: l_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
3702:
3695: l_exists VARCHAR2(1);
3696:
3697: -- csi datastructures.
3698: l_party_tbl csi_datastructures_pub.party_tbl;
3699: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3700: l_txn_rec csi_datastructures_pub.transaction_rec;
3701: l_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
3702:
3703: BEGIN
3696:
3697: -- csi datastructures.
3698: l_party_tbl csi_datastructures_pub.party_tbl;
3699: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3700: l_txn_rec csi_datastructures_pub.transaction_rec;
3701: l_oks_txn_inst_tbl oks_ibint_pub.txn_instance_tbl;
3702:
3703: BEGIN
3704: