eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SPLIT_CONTRACT_PVT dependencies on OKL_STREAM_INTERFACES

Line 4476: lv1_stream_id OKL_STREAM_INTERFACES.ID%TYPE;

4472: lv_severity OKC_QA_LIST_PROCESSES_V.SEVERITY%TYPE;
4473: lv1_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4474: lv2_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4475: lv_data VARCHAR2(2000);
4476: lv1_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4477: lv2_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4478: lv1_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4479: lv2_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4480: lv1_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 4477: lv2_stream_id OKL_STREAM_INTERFACES.ID%TYPE;

4473: lv1_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4474: lv2_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4475: lv_data VARCHAR2(2000);
4476: lv1_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4477: lv2_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4478: lv1_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4479: lv2_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4480: lv1_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4481: lv2_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;

Line 4478: lv1_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;

4474: lv2_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4475: lv_data VARCHAR2(2000);
4476: lv1_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4477: lv2_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4478: lv1_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4479: lv2_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4480: lv1_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4481: lv2_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4482: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;

Line 4479: lv2_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;

4475: lv_data VARCHAR2(2000);
4476: lv1_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4477: lv2_stream_id OKL_STREAM_INTERFACES.ID%TYPE;
4478: lv1_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4479: lv2_sis_code OKL_STREAM_INTERFACES.SIS_CODE%TYPE;
4480: lv1_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4481: lv2_sts_code OKC_K_HEADERS_B.STS_CODE%TYPE;
4482: lv_contract_number OKC_K_HEADERS_B.CONTRACT_NUMBER%TYPE;
4483: l_stream_path OKL_ST_GEN_TMPT_SETS.PRICING_ENGINE%TYPE;

Line 4489: CURSOR c_ok_stream(p_khr_id OKL_STREAM_INTERFACES.KHR_ID%TYPE) IS

4485: -- Log Directory Path variable
4486: l_temp_dir VARCHAR2(1000);
4487:
4488: -- To check if the stream generation of the contract went thru good.
4489: CURSOR c_ok_stream(p_khr_id OKL_STREAM_INTERFACES.KHR_ID%TYPE) IS
4490: SELECT a.id,
4491: a.sis_code,
4492: h.sts_code
4493: FROM okl_stream_interfaces a,

Line 4493: FROM okl_stream_interfaces a,

4489: CURSOR c_ok_stream(p_khr_id OKL_STREAM_INTERFACES.KHR_ID%TYPE) IS
4490: SELECT a.id,
4491: a.sis_code,
4492: h.sts_code
4493: FROM okl_stream_interfaces a,
4494: okc_k_headers_b h
4495: WHERE a.khr_id = p_khr_id
4496: AND h.id = a.khr_id
4497: AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))

Line 4498: FROM okl_stream_interfaces b

4494: okc_k_headers_b h
4495: WHERE a.khr_id = p_khr_id
4496: AND h.id = a.khr_id
4497: AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))
4498: FROM okl_stream_interfaces b
4499: WHERE b.khr_id = p_khr_id);
4500:
4501: CURSOR get_dir IS
4502: SELECT NVL(SUBSTRB(TRANSLATE(LTRIM(value),',',' '), 1,

Line 4519: CURSOR c_ok_stream_loop(p_khr_id OKL_STREAM_INTERFACES.KHR_ID%TYPE,

4515: WHERE id = (SELECT ORIG_SYSTEM_ID1
4516: FROM okc_k_headers_b
4517: WHERE id = p_khr_id);
4518:
4519: CURSOR c_ok_stream_loop(p_khr_id OKL_STREAM_INTERFACES.KHR_ID%TYPE,
4520: p_stream_id OKL_STREAM_INTERFACES.ID%TYPE) IS
4521: SELECT a.sis_code,
4522: h.sts_code
4523: FROM okl_stream_interfaces a,

Line 4520: p_stream_id OKL_STREAM_INTERFACES.ID%TYPE) IS

4516: FROM okc_k_headers_b
4517: WHERE id = p_khr_id);
4518:
4519: CURSOR c_ok_stream_loop(p_khr_id OKL_STREAM_INTERFACES.KHR_ID%TYPE,
4520: p_stream_id OKL_STREAM_INTERFACES.ID%TYPE) IS
4521: SELECT a.sis_code,
4522: h.sts_code
4523: FROM okl_stream_interfaces a,
4524: okc_k_headers_b h

Line 4523: FROM okl_stream_interfaces a,

4519: CURSOR c_ok_stream_loop(p_khr_id OKL_STREAM_INTERFACES.KHR_ID%TYPE,
4520: p_stream_id OKL_STREAM_INTERFACES.ID%TYPE) IS
4521: SELECT a.sis_code,
4522: h.sts_code
4523: FROM okl_stream_interfaces a,
4524: okc_k_headers_b h
4525: WHERE a.id = p_stream_id
4526: AND a.khr_id = p_khr_id
4527: AND h.id = a.khr_id

Line 4529: FROM okl_stream_interfaces b

4525: WHERE a.id = p_stream_id
4526: AND a.khr_id = p_khr_id
4527: AND h.id = a.khr_id
4528: AND TRUNC(a.date_processed) IN (SELECT MAX(TRUNC(b.date_processed))
4529: FROM okl_stream_interfaces b
4530: WHERE b.khr_id = p_khr_id);
4531:
4532: CURSOR c_get_source_id(p_khr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE) IS
4533: SELECT id

Line 4967: p_token1_value => 'OKL_STREAM_INTERFACES.SIS_CODE');

4963: IF c_ok_stream_loop%NOTFOUND THEN
4964: OKL_API.set_message(p_app_name => G_APP_NAME,
4965: p_msg_name => G_NO_MATCHING_RECORD,
4966: p_token1 => G_COL_NAME_TOKEN,
4967: p_token1_value => 'OKL_STREAM_INTERFACES.SIS_CODE');
4968: x_return_status := OKL_API.G_RET_STS_ERROR;
4969:
4970: IF (G_DEBUG_SPLIT) THEN
4971: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'External Stream Generation information missing

Line 5191: p_token1_value => 'OKL_STREAM_INTERFACES.SIS_CODE');

5187: IF c_ok_stream_loop%NOTFOUND THEN
5188: OKL_API.set_message(p_app_name => G_APP_NAME,
5189: p_msg_name => G_NO_MATCHING_RECORD,
5190: p_token1 => G_COL_NAME_TOKEN,
5191: p_token1_value => 'OKL_STREAM_INTERFACES.SIS_CODE');
5192: x_return_status := OKL_API.G_RET_STS_ERROR;
5193:
5194: IF (G_DEBUG_SPLIT) THEN
5195: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, 'External Stream Generation information missing