DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 12844: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS

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;

Line 12929: x_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.party_tbl) IS

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';

Line 13221: l_instance_query_rec CSI_DATASTRUCTURES_PUB.instance_query_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:

Line 13222: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;

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

Line 13223: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;

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;

Line 13224: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;

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;

Line 13227: l_instance_rec CSI_DATASTRUCTURES_PUB.instance_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;
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;

Line 13228: l_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_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;

Line 13229: l_party_tbl CSI_DATASTRUCTURES_PUB.party_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;

Line 13230: l_party_tbl_in CSI_DATASTRUCTURES_PUB.party_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;

Line 13231: l_account_tbl CSI_DATASTRUCTURES_PUB.party_account_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;

Line 13232: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

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:

Line 13233: l_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_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:
13237: --original instance updation parameters

Line 13234: l_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_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
13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;

Line 13235: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_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;

Line 13238: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;

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;

Line 13239: l_upd_ext_attrib_values_tbl CSI_DATASTRUCTURES_PUB.extend_attrib_values_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;

Line 13240: l_upd_party_tbl CSI_DATASTRUCTURES_PUB.party_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;

Line 13241: l_upd_party_tbl_in CSI_DATASTRUCTURES_PUB.party_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;

Line 13242: l_upd_account_tbl CSI_DATASTRUCTURES_PUB.party_account_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;

Line 13243: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

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;

Line 13244: l_upd_org_assignments_tbl CSI_DATASTRUCTURES_PUB.organization_units_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:

Line 13245: l_upd_asset_assignment_tbl CSI_DATASTRUCTURES_PUB.instance_asset_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:
13249: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

Line 13246: l_upd_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;

Line 13247: l_upd_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:

Line 13249: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

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;

Line 13250: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_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;
13254: