1083: x_msg_count OUT NOCOPY NUMBER,
1084: x_msg_data OUT NOCOPY VARCHAR2,
1085: p_cle_id IN NUMBER,
1086: p_transaction_type IN VARCHAR2,
1087: x_trx_rec OUT NOCOPY CSI_DATASTRUCTURES_PUB.transaction_rec) IS
1088:
1089: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1090: l_api_name CONSTANT VARCHAR2(30) := 'GET_TRX_REC';
1091: l_api_version CONSTANT NUMBER := 1.0;
1175: l_tas_id NUMBER;
1176: l_kle_id NUMBER;
1177: l_object_version_number NUMBER;
1178:
1179: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1180: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1181: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1176: l_kle_id NUMBER;
1177: l_object_version_number NUMBER;
1178:
1179: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1180: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1181: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1177: l_object_version_number NUMBER;
1178:
1179: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1180: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1181: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1185: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1178:
1179: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1180: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1181: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1185: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1186: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1179: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1180: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1181: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1185: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1186: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1187: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1180: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1181: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1185: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1186: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1187: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1188:
1181: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1185: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1186: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1187: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1188:
1189: l_instance_rec_type instance_rec;
1182: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1185: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1186: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1187: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1188:
1189: l_instance_rec_type instance_rec;
1190: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1183: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1184: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1185: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1186: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1187: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1188:
1189: l_instance_rec_type instance_rec;
1190: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1191: l_party_tbl party_tbl;
1310: WHERE KIT.CLE_ID = (SELECT KLB.ID FROM OKC_K_LINES_B KLB WHERE
1311: KLB.ID = p_kle_id);
1312:
1313:
1314: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1315: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1316: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1311: KLB.ID = p_kle_id);
1312:
1313:
1314: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1315: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1316: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1312:
1313:
1314: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1315: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1316: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1320: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1313:
1314: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1315: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1316: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1320: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1321: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1314: SUBTYPE instance_rec IS CSI_DATASTRUCTURES_PUB.instance_rec;
1315: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1316: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1320: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1321: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1322: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1315: SUBTYPE extend_attrib_values_tbl IS CSI_DATASTRUCTURES_PUB.extend_attrib_values_tbl;
1316: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1320: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1321: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1322: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1323:
1316: SUBTYPE party_tbl IS CSI_DATASTRUCTURES_PUB.party_tbl;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1320: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1321: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1322: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1323:
1324: l_instance_rec_type instance_rec;
1317: SUBTYPE account_tbl IS CSI_DATASTRUCTURES_PUB.party_account_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1320: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1321: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1322: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1323:
1324: l_instance_rec_type instance_rec;
1325: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1318: SUBTYPE pricing_attribs_tbl IS CSI_DATASTRUCTURES_PUB.pricing_attribs_tbl;
1319: SUBTYPE organization_units_tbl IS CSI_DATASTRUCTURES_PUB.organization_units_tbl;
1320: SUBTYPE instance_asset_tbl IS CSI_DATASTRUCTURES_PUB.instance_asset_tbl;
1321: SUBTYPE transaction_rec IS CSI_DATASTRUCTURES_PUB.transaction_rec;
1322: SUBTYPE id_tbl IS CSI_DATASTRUCTURES_PUB.id_tbl;
1323:
1324: l_instance_rec_type instance_rec;
1325: l_ext_attrib_values_tbl extend_attrib_values_tbl;
1326: l_party_tbl party_tbl;