7: p_txn_to_date IN VARCHAR2,
8: p_source_system_name IN VARCHAR2,
9: p_worker_id IN NUMBER,
10: p_commit_recs IN NUMBER,
11: p_instance_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.INSTANCE_TBL,
12: p_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_TBL,
13: p_account_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL,
14: p_ext_attrib_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL,
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
8: p_source_system_name IN VARCHAR2,
9: p_worker_id IN NUMBER,
10: p_commit_recs IN NUMBER,
11: p_instance_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.INSTANCE_TBL,
12: p_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_TBL,
13: p_account_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL,
14: p_ext_attrib_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL,
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
16: p_org_assign_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL,
9: p_worker_id IN NUMBER,
10: p_commit_recs IN NUMBER,
11: p_instance_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.INSTANCE_TBL,
12: p_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_TBL,
13: p_account_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL,
14: p_ext_attrib_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL,
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
16: p_org_assign_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL,
17: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
10: p_commit_recs IN NUMBER,
11: p_instance_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.INSTANCE_TBL,
12: p_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_TBL,
13: p_account_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL,
14: p_ext_attrib_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL,
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
16: p_org_assign_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL,
17: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
18: p_party_contact_tbl OUT NOCOPY CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE,
11: p_instance_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.INSTANCE_TBL,
12: p_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_TBL,
13: p_account_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL,
14: p_ext_attrib_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL,
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
16: p_org_assign_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL,
17: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
18: p_party_contact_tbl OUT NOCOPY CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE,
19: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
12: p_party_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_TBL,
13: p_account_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL,
14: p_ext_attrib_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL,
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
16: p_org_assign_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL,
17: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
18: p_party_contact_tbl OUT NOCOPY CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE,
19: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
20: x_return_status OUT NOCOPY VARCHAR2,
13: p_account_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_TBL,
14: p_ext_attrib_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL,
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
16: p_org_assign_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL,
17: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
18: p_party_contact_tbl OUT NOCOPY CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE,
19: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_error_message OUT NOCOPY VARCHAR2) IS
15: p_price_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL,
16: p_org_assign_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.ORGANIZATION_UNITS_TBL,
17: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
18: p_party_contact_tbl OUT NOCOPY CSI_ML_UTIL_PVT.PARTY_CONTACT_TBL_TYPE,
19: x_asset_assignment_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_tbl,
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_error_message OUT NOCOPY VARCHAR2) IS
22:
23: inst_idx PLS_INTEGER;
2496: (
2497: p_txn_from_date IN VARCHAR2,
2498: p_txn_to_date IN VARCHAR2,
2499: p_source_system_name IN VARCHAR2,
2500: p_relationship_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL,
2501: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
2502: x_return_status OUT NOCOPY VARCHAR2,
2503: x_error_message OUT NOCOPY VARCHAR2) IS
2504:
2497: p_txn_from_date IN VARCHAR2,
2498: p_txn_to_date IN VARCHAR2,
2499: p_source_system_name IN VARCHAR2,
2500: p_relationship_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.II_RELATIONSHIP_TBL,
2501: p_txn_tbl OUT NOCOPY CSI_DATASTRUCTURES_PUB.TRANSACTION_TBL,
2502: x_return_status OUT NOCOPY VARCHAR2,
2503: x_error_message OUT NOCOPY VARCHAR2) IS
2504:
2505: rel_idx PLS_INTEGER;