DBA Data[Home] [Help]

APPS.OKL_LA_STREAM_PVT dependencies on FND_PROFILE

Line 2078: AND txd.tax_book = fnd_profile.value('OKL_REPORTING_PDT_ASSET_BOOK'));

2074: FROM DUAL
2075: WHERE EXISTS (SELECT 'Y'
2076: FROM okl_txd_assets_b txd
2077: WHERE txd.asset_number = p_asset_number
2078: AND txd.tax_book = fnd_profile.value('OKL_REPORTING_PDT_ASSET_BOOK'));
2079: */
2080: CURSOR get_rep_tax_csr(p_corp_book VARCHAR2)
2081: IS
2082: SELECT 'Y'

Line 7750: l_timeout := FND_PROFILE.value('OKL_STREAMS_TIME_OUT');

7746: IF(l_report_req_status NOT IN('PROCESS_COMPLETE', 'PROCESS_COMPLETE_ERRORS','PROCESSING_FAILED'
7747: ,'PROCESS_ABORTED','SERVER_NA','TIME_OUT')) THEN
7748:
7749: --Fetching the value of the time out variable
7750: l_timeout := FND_PROFILE.value('OKL_STREAMS_TIME_OUT');
7751: l_timeout := l_timeout * 60;
7752:
7753: OPEN get_rep_trans_num(p_chr_id);
7754: FETCH get_rep_trans_num INTO l_alert_name;

Line 20597: --IF ( fnd_profile.value('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN

20593: raise OKL_API.G_EXCEPTION_ERROR;
20594: END IF;
20595:
20596:
20597: --IF ( fnd_profile.value('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN
20598: IF ( l_pricing_engine = 'EXTERNAL') THEN
20599:
20600: --
20601: -- Call EXTERNAL Stream genration process

Line 20622: --ELSE -- fnd_profile = INTERNAL or NONE

20618: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
20619: raise OKL_API.G_EXCEPTION_ERROR;
20620: END IF;
20621:
20622: --ELSE -- fnd_profile = INTERNAL or NONE
20623: ELSIF ( l_pricing_engine = 'INTERNAL') THEN
20624: --
20625: -- Call INTERNAL Stream genration process
20626: --

Line 20726: END IF; -- fnd_profile

20722: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
20723: raise OKL_API.G_EXCEPTION_ERROR;
20724: End If;
20725:
20726: END IF; -- fnd_profile
20727:
20728: print( l_api_name, 'end', x_return_status);
20729: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
20730: x_msg_data => x_msg_data);