DBA Data[Home] [Help]

APPS.OKL_QA_DATA_INTEGRITY dependencies on FND_PROFILE

Line 4744: *SELECT fnd_profile.VALUE('OKL_STREAMS_GEN_PATH')

4740: ) IS
4741:
4742: /*
4743: *CURSOR strm_profile_csr IS
4744: *SELECT fnd_profile.VALUE('OKL_STREAMS_GEN_PATH')
4745: *FROM dual;
4746: */
4747:
4748: l_strm_profile VARCHAR2(50);

Line 10387: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');

10383: Exit when l_orig_ast_csr%NOTFOUND;
10384: If l_pdt_rec.start_date <= l_orig_ast_rec.date_terminated Then
10385: -- Raise Error: start date of the contract should not be less than or equal to termination
10386: -- date of the asset.
10387: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
10388:
10389: l_termination_date := to_char(l_orig_ast_rec.date_terminated,l_icx_date_format);
10390: l_k_start_date := to_char(l_pdt_rec.start_date,l_icx_date_format);
10391: