5127: ) IS
5128:
5129: /*
5130: *CURSOR strm_profile_csr IS
5131: *SELECT fnd_profile.VALUE('OKL_STREAMS_GEN_PATH')
5132: *FROM dual;
5133: */
5134:
5135: l_strm_profile VARCHAR2(50);
10806: Exit when l_orig_ast_csr%NOTFOUND;
10807: If l_pdt_rec.start_date <= l_orig_ast_rec.date_terminated Then
10808: -- Raise Error: start date of the contract should not be less than or equal to termination
10809: -- date of the asset.
10810: l_icx_date_format := nvl(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
10811:
10812: l_termination_date := to_char(l_orig_ast_rec.date_terminated,l_icx_date_format);
10813: l_k_start_date := to_char(l_pdt_rec.start_date,l_icx_date_format);
10814: