[Home] [Help]
67: lp_pdtv_rec.id := l_fin_product_id;
68:
69: -- check if the fin product has a reporting product
70: OKL_SETUPPRODUCTS_PUB.Getpdt_parameters( p_api_version => p_api_version,
71: p_init_msg_list => OKC_API.G_FALSE,
72: x_return_status => x_return_status,
73: x_no_data_found => lx_no_data_found,
74: x_msg_count => x_msg_count,
75: x_msg_data => x_msg_data,
76: p_pdtv_rec => lp_pdtv_rec,
77: p_product_date => l_start_date,
78: p_pdt_parameter_rec => lx_pdt_parameter_rec);
79:
80: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
81: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
82: OKC_API.set_message( p_app_name => 'OKL',
83: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
84: p_token1 => 'CONTRACT_NUMBER',
78: p_pdt_parameter_rec => lx_pdt_parameter_rec);
79:
80: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
81: -- Error getting financial product parameters for contract CONTRACT_NUMBER.
82: OKC_API.set_message( p_app_name => 'OKL',
83: p_msg_name => 'OKL_AM_FIN_PROD_PARAM_ERR',
84: p_token1 => 'CONTRACT_NUMBER',
85: p_token1_value => l_contract_number);
86:
140: x_stream_element_id OUT NOCOPY NUMBER) IS
141:
142: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_STREAM_INVOICE';
143: l_api_version CONSTANT NUMBER := 1.0;
144: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
145: l_msg_count NUMBER;
146: l_msg_data VARCHAR2(2000);
147: l_sty_id OKL_STRM_TYPE_V.id%TYPE;
148: l_stream_exists VARCHAR2(1) := '?';
495: IF p_stream_type_purpose IN ('FLOAT_FACTOR_ADJUSTMENT','VARIABLE_INTEREST','INTEREST_CATCHUP', 'PRINCIPAL_CATCHUP') THEN
496: --Check if financial product has a reporting product
497: get_reporting_product(
498: p_api_version => p_api_version,
499: p_init_msg_list => OKC_API.G_FALSE,
500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,
502: x_msg_data => x_msg_data,
503: p_contract_id => p_contract_id,
1116: IF (p_process_flag = 'DAILY_INTEREST') THEN
1117: IF (l_strm_element_created = OKL_API.G_TRUE) THEN
1118: OKL_STREAMS_PUB.delete_stream_elements(
1119: p_api_version => 1.0,
1120: p_init_msg_list => OKC_API.G_FALSE,
1121: x_return_status => x_return_status,
1122: x_msg_count => x_msg_count,
1123: x_msg_data => x_msg_data,
1124: p_selv_rec => lx_selv_rec);
1125: END IF;
1126: IF (l_stream_created = OKL_API.G_TRUE) THEN
1127: OKL_STREAMS_PUB.delete_streams(
1128: p_api_version => 1.0,
1129: p_init_msg_list => OKC_API.G_FALSE,
1130: x_return_status => x_return_status,
1131: x_msg_count => x_msg_count,
1132: x_msg_data => x_msg_data,
1133: p_stmv_rec => lx_stmv_rec);
1135:
1136: IF (l_okl_trx_created = OKL_API.G_TRUE) THEN
1137: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
1138: p_api_version => 1.0,
1139: p_init_msg_list => OKC_API.G_FALSE,
1140: x_return_status => x_return_status,
1141: x_msg_count => x_msg_count,
1142: x_msg_data => x_msg_data,
1143: p_tcnv_rec => l_trxH_out_rec);
1171: IF (p_process_flag = 'DAILY_INTEREST') THEN
1172: IF (l_strm_element_created = OKL_API.G_TRUE) THEN
1173: OKL_STREAMS_PUB.delete_stream_elements(
1174: p_api_version => 1.0,
1175: p_init_msg_list => OKC_API.G_FALSE,
1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data,
1179: p_selv_rec => lx_selv_rec);
1180: END IF;
1181: IF (l_stream_created = OKL_API.G_TRUE) THEN
1182: OKL_STREAMS_PUB.delete_streams(
1183: p_api_version => 1.0,
1184: p_init_msg_list => OKC_API.G_FALSE,
1185: x_return_status => x_return_status,
1186: x_msg_count => x_msg_count,
1187: x_msg_data => x_msg_data,
1188: p_stmv_rec => lx_stmv_rec);
1190:
1191: IF (l_okl_trx_created = OKL_API.G_TRUE) THEN
1192: OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
1193: p_api_version => 1.0,
1194: p_init_msg_list => OKC_API.G_FALSE,
1195: x_return_status => x_return_status,
1196: x_msg_count => x_msg_count,
1197: x_msg_data => x_msg_data,
1198: p_tcnv_rec => l_trxH_out_rec);