997: x_msg_count OUT NOCOPY NUMBER,
998: x_msg_data OUT NOCOPY VARCHAR2,
999: p_cle_id IN NUMBER,
1000: p_transaction_type IN VARCHAR2,
1001: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS
1002:
1003: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1004: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
1005: l_api_version CONSTANT NUMBER := 1.0;
1089: l_tas_id NUMBER;
1090: l_kle_id NUMBER;
1091: l_object_version_number NUMBER;
1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1090: l_kle_id NUMBER;
1091: l_object_version_number NUMBER;
1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1091: l_object_version_number NUMBER;
1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1092:
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1093: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1094: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:
1095: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:
1103: l_instance_rec_type instance_rec;
1096: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:
1103: l_instance_rec_type instance_rec;
1104: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1097: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1098: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1099: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1100: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1101: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1102:
1103: l_instance_rec_type instance_rec;
1104: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1105: l_party_tbl party_tbl;
1224: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE
1225: KLB.ID = p_kle_id);
1226:
1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1225: KLB.ID = p_kle_id);
1226:
1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1226:
1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1227:
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1228: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1229: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:
1230: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:
1238: l_instance_rec_type instance_rec;
1231: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:
1238: l_instance_rec_type instance_rec;
1239: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1232: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1233: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1234: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1235: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1236: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1237:
1238: l_instance_rec_type instance_rec;
1239: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1240: l_party_tbl party_tbl;