DBA Data[Home] [Help]

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKL_STREAMS

Line 1561: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;

1557: l_khrv_rec khrv_rec_type;
1558: l_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1559: lx_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1560: ln_orig_system_id1 OKC_K_HEADERS_B.ORIG_SYSTEM_ID1%TYPE;
1561: l_stmv_rec OKL_STREAMS_PUB.stmv_rec_type;
1562: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1563:
1564: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1565: SELECT id stm_id

Line 1566: FROM OKL_STREAMS

1562: r_tcnv_rec OKL_TRX_CONTRACTS_PVT.tcnv_rec_type;
1563:
1564: CURSOR c_get_k_stream(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1565: SELECT id stm_id
1566: FROM OKL_STREAMS
1567: WHERE khr_id = p_khr_id;
1568:
1569: CURSOR c_get_je_trans(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
1570: SELECT id trx_id

Line 1735: OKL_STREAMS_PUB.delete_streams(

1731: END IF;
1732: -- Delete the streams for the contract
1733: FOR r_get_k_stream IN c_get_k_stream(p_khr_id => p_contract_id) LOOP
1734: l_stmv_rec.id := r_get_k_stream.stm_id;
1735: OKL_STREAMS_PUB.delete_streams(
1736: p_api_version => p_api_version,
1737: p_init_msg_list => p_init_msg_list,
1738: x_return_status => x_return_status,
1739: x_msg_count => x_msg_count,

Line 4932: --l_stream_path := okl_streams_util.get_pricing_engine (p_khr_id => p_new1_contract_id);

4928: RAISE OKL_API.G_EXCEPTION_ERROR;
4929: END IF;
4930: -- We need to commit this transaction also since we have to get the
4931: -- Stream generation Kicked off
4932: --l_stream_path := okl_streams_util.get_pricing_engine (p_khr_id => p_new1_contract_id);
4933: okl_streams_util.get_pricing_engine
4934: (p_khr_id => p_new1_contract_id,
4935: x_pricing_engine => l_stream_path,
4936: x_return_status => x_return_status

Line 4933: okl_streams_util.get_pricing_engine

4929: END IF;
4930: -- We need to commit this transaction also since we have to get the
4931: -- Stream generation Kicked off
4932: --l_stream_path := okl_streams_util.get_pricing_engine (p_khr_id => p_new1_contract_id);
4933: okl_streams_util.get_pricing_engine
4934: (p_khr_id => p_new1_contract_id,
4935: x_pricing_engine => l_stream_path,
4936: x_return_status => x_return_status
4937: );

Line 4944: --IF (p_commit = OKL_API.G_TRUE AND (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL')) THEN

4940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4941: RAISE OKL_API.G_EXCEPTION_ERROR;
4942: END IF;
4943:
4944: --IF (p_commit = OKL_API.G_TRUE AND (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL')) THEN
4945: IF (p_commit = OKL_API.G_TRUE AND (l_stream_path = 'EXTERNAL')) THEN
4946: COMMIT;
4947: END IF;
4948:

Line 4951: --IF (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN

4947: END IF;
4948:
4949: -- Need to make sure that the stream generation process has actually completed successfully
4950: -- for that first contract
4951: --IF (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN
4952: IF (l_stream_path = 'EXTERNAL') THEN
4953:
4954: IF (G_DEBUG_SPLIT) THEN
4955: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'External Stream Generation in progress

Line 5157: --l_stream_path := okl_streams_util.get_pricing_engine (p_khr_id => p_new2_contract_id);

5153: RAISE OKL_API.G_EXCEPTION_ERROR;
5154: END IF;
5155: -- We are using the below since we have commit the workflow
5156: -- Of generating the Streams
5157: --l_stream_path := okl_streams_util.get_pricing_engine (p_khr_id => p_new2_contract_id);
5158: okl_streams_util.get_pricing_engine
5159: (p_khr_id => p_new2_contract_id,
5160: x_pricing_engine => l_stream_path,
5161: x_return_status => x_return_status

Line 5158: okl_streams_util.get_pricing_engine

5154: END IF;
5155: -- We are using the below since we have commit the workflow
5156: -- Of generating the Streams
5157: --l_stream_path := okl_streams_util.get_pricing_engine (p_khr_id => p_new2_contract_id);
5158: okl_streams_util.get_pricing_engine
5159: (p_khr_id => p_new2_contract_id,
5160: x_pricing_engine => l_stream_path,
5161: x_return_status => x_return_status
5162: );

Line 5169: --IF (p_commit = OKL_API.G_TRUE AND (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL')) THEN

5165: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5166: RAISE OKL_API.G_EXCEPTION_ERROR;
5167: END IF;
5168:
5169: --IF (p_commit = OKL_API.G_TRUE AND (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL')) THEN
5170: IF (p_commit = OKL_API.G_TRUE AND (l_stream_path = 'EXTERNAL')) THEN
5171: COMMIT;
5172: END IF;
5173:

Line 5176: --IF (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN

5172: END IF;
5173:
5174: -- Need to make sure that the stream generation process has actually completed successfully
5175: -- for that second contract
5176: --IF (FND_PROFILE.VALUE('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN
5177: IF (l_stream_path = 'EXTERNAL') THEN
5178: IF (G_DEBUG_SPLIT) THEN
5179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'External Stream Generation in progress
5180: for second Split contract ..');