12893: x_msg_count OUT NOCOPY NUMBER,
12894: x_msg_data OUT NOCOPY VARCHAR2,
12895: p_cle_id IN NUMBER,
12896: p_transaction_type IN VARCHAR2,
12897: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS
12898:
12899: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12900: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
12901: l_api_version CONSTANT NUMBER := 1.0;
12978: x_return_status OUT NOCOPY VARCHAR2,
12979: x_msg_count OUT NOCOPY NUMBER,
12980: x_msg_data OUT NOCOPY VARCHAR2,
12981: p_chrv_id IN NUMBER,
12982: x_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.party_tbl) IS
12983:
12984: l_party_tab OKL_JTOT_EXTRACT.party_tab_type;
12985: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
12986: l_api_name CONSTANT VARCHAR2(30) := 'GET_PARTY_REC';
13270: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_IB_INSTANCE';
13271: l_api_version CONSTANT NUMBER := 1.0;
13272:
13273: --instance query recs
13274: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13275: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13276: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13277: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13278:
13271: l_api_version CONSTANT NUMBER := 1.0;
13272:
13273: --instance query recs
13274: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13275: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13276: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13277: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13278:
13279: --instance recs for creation
13272:
13273: --instance query recs
13274: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13275: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13276: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13277: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13278:
13279: --instance recs for creation
13280: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13273: --instance query recs
13274: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_rec;
13275: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;
13276: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13277: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13278:
13279: --instance recs for creation
13280: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13281: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13276: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;
13277: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13278:
13279: --instance recs for creation
13280: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13281: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13282: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13277: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;
13278:
13279: --instance recs for creation
13280: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13281: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13282: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13278:
13279: --instance recs for creation
13280: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13281: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13282: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13286: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13279: --instance recs for creation
13280: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13281: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13282: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13286: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13287: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13280: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13281: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13282: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13286: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13287: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13288: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13281: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13282: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13286: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13287: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13288: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13289:
13282: l_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13286: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13287: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13288: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13289:
13290: --original instance updation parameters
13283: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13286: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13287: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13288: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13289:
13290: --original instance updation parameters
13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13284: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13286: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13287: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13288: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13289:
13290: --original instance updation parameters
13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13292: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13287: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13288: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13289:
13290: --original instance updation parameters
13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13292: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13293: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13288: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13289:
13290: --original instance updation parameters
13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13292: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13293: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13289:
13290: --original instance updation parameters
13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13292: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13293: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13290: --original instance updation parameters
13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13292: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13293: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;
13292: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13293: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13292: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
13293: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13300: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13293: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_tbl;
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13300: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13301:
13294: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_tbl;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13300: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13301:
13302: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13295: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13300: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13301:
13302: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13303: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
13297: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_tbl;
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13300: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13301:
13302: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13303: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13304:
13298: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13300: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13301:
13302: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13303: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13304:
13305:
13306: l_no_data_found BOOLEAN;
13299: l_upd_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13300: l_upd_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13301:
13302: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;
13303: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_tbl;
13304:
13305:
13306: l_no_data_found BOOLEAN;
13307: