APPS.OKL_LA_STREAM_PVT dependencies on FND_PROFILE

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

2053: FROM DUAL
2054: WHERE EXISTS (SELECT 'Y'
2055: FROM okl_txd_assets_b txd
2056: WHERE txd.asset_number = p_asset_number
2057: AND txd.tax_book = fnd_profile.value('OKL_REPORTING_PDT_ASSET_BOOK'));
2058: */
2059: CURSOR get_rep_tax_csr(p_corp_book VARCHAR2)
2060: IS
2061: SELECT 'Y'

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

9244: IF(l_report_req_status NOT IN('PROCESS_COMPLETE', 'PROCESS_COMPLETE_ERRORS','PROCESSING_FAILED'
9245: ,'PROCESS_ABORTED','SERVER_NA','TIME_OUT')) THEN
9246:
9247: --Fetching the value of the time out variable
9248: l_timeout := FND_PROFILE.value('OKL_STREAMS_TIME_OUT');
9249: l_timeout := l_timeout * 60;
9250:
9251: OPEN get_rep_trans_num(p_chr_id);
9252: FETCH get_rep_trans_num INTO l_alert_name;

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

23410: raise OKL_API.G_EXCEPTION_ERROR;
23411: END IF;
23412:
23413:
23414: --IF ( fnd_profile.value('OKL_STREAMS_GEN_PATH') = 'EXTERNAL') THEN
23415: IF ( l_pricing_engine = 'EXTERNAL') THEN
23416:
23417: -- populate orig_contract_line_id for the lines.
23418: -- orig_contract_line_id would be null for existing contracts and needing upgrade

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

23454: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
23455: raise OKL_API.G_EXCEPTION_ERROR;
23456: END IF;
23457:
23458: --ELSE -- fnd_profile = INTERNAL or NONE
23459: ELSIF ( l_pricing_engine = 'INTERNAL') THEN
23460: --
23461: -- Call INTERNAL Stream genration process
23462: --

Line 23563: END IF; -- fnd_profile

23559: ElSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
23560: raise OKL_API.G_EXCEPTION_ERROR;
23561: End If;
23562:
23563: END IF; -- fnd_profile
23564: print( l_api_name, 'end', x_return_status);
23565: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
23566: x_msg_data => x_msg_data);
23567:

Line 23822: lt_sll_date_tbl_type(i).end_date := to_date(r_get_sll_lines_rec.end_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')); -- sechawla 8429670

23818:
23819: lt_sll_date_tbl_type(i).start_date := r_get_sll_lines_rec.start_date;
23820:
23821: -- lt_sll_date_tbl_type(i).end_date := r_get_sll_lines_rec.end_date; -- sechawla 8429670
23822: lt_sll_date_tbl_type(i).end_date := to_date(r_get_sll_lines_rec.end_date, fnd_profile.value('ICX_DATE_FORMAT_MASK')); -- sechawla 8429670
23823:
23824: IF r_get_sll_lines_rec.amount IS NULL THEN
23825: ln_cnt_amt_null := ln_cnt_amt_null + 1;
23826: ELSIF r_get_sll_lines_rec.amount IS NOT NULL THEN