APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_STREAM_INTERFACES_V

Line 2225: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE

2221: ---------------------------------------------------------------------------
2222: FUNCTION pending_request_exists(
2223: p_khr_id IN NUMBER
2224: --smahapat 11/10/02 multi-gaap - addition
2225: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE
2226: --smahapat addition end
2227: ,x_return_status OUT NOCOPY VARCHAR2
2228: ) RETURN BOOLEAN
2229: IS

Line 2230: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2226: --smahapat addition end
2227: ,x_return_status OUT NOCOPY VARCHAR2
2228: ) RETURN BOOLEAN
2229: IS
2230: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2231: SELECT '1' FROM dual
2232: WHERE EXISTS
2233: (SELECT '1'
2234: FROM OKL_STREAM_INTERFACES

Line 2239: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2235: WHERE khr_id = p_khr_id
2236: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
2237: );
2238: --smahapat 11/10/02 multi-gaap - addition
2239: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2240:
2241: SELECT '1' FROM dual
2242: WHERE EXISTS
2243: (SELECT '1'

Line 2864: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE

2860: ---------------------------------------------------------------------------
2861: FUNCTION pending_request_exists(
2862: p_khr_id IN NUMBER
2863: --smahapat 11/10/02 multi-gaap - addition
2864: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE
2865: --smahapat addition end
2866: ,x_return_status OUT NOCOPY VARCHAR2
2867: ) RETURN BOOLEAN
2868: IS

Line 2869: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2865: --smahapat addition end
2866: ,x_return_status OUT NOCOPY VARCHAR2
2867: ) RETURN BOOLEAN
2868: IS
2869: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2870: SELECT '1' FROM dual
2871: WHERE EXISTS
2872: (SELECT '1'
2873: FROM OKL_STREAM_INTERFACES

Line 2880: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

2876: );
2877: --smahapat 11/10/02 multi-gaap - addition
2878:
2879:
2880: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2881: SELECT '1' FROM dual
2882: WHERE EXISTS
2883: (SELECT '1'
2884: FROM OKL_STREAM_INTERFACES

Line 4694: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS

4690:
4691: ,x_return_status OUT NOCOPY VARCHAR2
4692: ) RETURN BOOLEAN
4693: IS
4694: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
4695: SELECT '1' FROM dual
4696: WHERE EXISTS
4697: (SELECT '1'
4698: FROM OKL_STREAM_INTERFACES