12840: x_msg_count OUT NOCOPY NUMBER,
12841: x_msg_data OUT NOCOPY VARCHAR2,
12842: p_cle_id IN NUMBER,
12843: p_transaction_type IN VARCHAR2,
12844: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS
12845:
12846: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12847: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
12848: l_api_version CONSTANT NUMBER := 1.0;
12925: x_return_status OUT NOCOPY VARCHAR2,
12926: x_msg_count OUT NOCOPY NUMBER,
12927: x_msg_data OUT NOCOPY VARCHAR2,
12928: p_chrv_id IN NUMBER,
12929: x_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.party_tbl) IS
12930:
12931: l_party_tab OKL_JTOT_EXTRACT.party_tab_type;
12932: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12933: l_api_name CONSTANT VARCHAR2(30) := 'GET_PARTY_REC';
13217: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_IB_INSTANCE';
13218: l_api_version CONSTANT NUMBER := 1.0;
13219:
13220: --instance query recs
13221: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13222: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13223: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13224: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13225:
13218: l_api_version CONSTANT NUMBER := 1.0;
13219:
13220: --instance query recs
13221: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13222: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13223: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13224: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13225:
13226: --instance recs for creation
13219:
13220: --instance query recs
13221: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13222: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13223: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13224: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13225:
13226: --instance recs for creation
13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13220: --instance query recs
13221: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13222: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13223: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13224: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13225:
13226: --instance recs for creation
13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13223: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13224: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13225:
13226: --instance recs for creation
13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13224: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13225:
13226: --instance recs for creation
13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13225:
13226: --instance recs for creation
13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13226: --instance recs for creation
13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13236:
13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13236:
13237: --original instance updation parameters
13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13236:
13237: --original instance updation parameters
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13236:
13237: --original instance updation parameters
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13236:
13237: --original instance updation parameters
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13236:
13237: --original instance updation parameters
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13236:
13237: --original instance updation parameters
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13237: --original instance updation parameters
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13247: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13247: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13248:
13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13247: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13248:
13249: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13247: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13248:
13249: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13250: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13247: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13248:
13249: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13250: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13251:
13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13247: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13248:
13249: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13250: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13251:
13252:
13253: l_no_data_found BOOLEAN;
13246: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13247: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13248:
13249: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13250: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13251:
13252:
13253: l_no_data_found BOOLEAN;
13254: