DBA Data[Home] [Help]

APPS.OKL_SPLIT_ASSET_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 12897: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS

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;

Line 12982: x_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.party_tbl) IS

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

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

Line 13275: l_party_query_rec CSI_DATASTRUCTURES_PUB.party_query_rec;

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

Line 13276: l_account_query_rec CSI_DATASTRUCTURES_PUB.party_account_query_rec;

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;

Line 13277: l_instance_header_tbl CSI_DATASTRUCTURES_PUB.instance_header_tbl;

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;

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

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

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

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

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

Line 13285: l_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

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:

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

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

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

Line 13291: l_upd_instance_rec CSI_DATASTRUCTURES_PUB.instance_rec;

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;

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

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

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

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

Line 13296: l_upd_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;

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;

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

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

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

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

Line 13302: l_exp_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec;

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;

Line 13303: l_exp_instance_id_lst CSI_DATASTRUCTURES_PUB.id_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;
13307: