APPS.OKL_CREATE_STREAMS_PVT dependencies on OKL_STREAM_INTERFACES_V

Line 2483: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE

2479: ---------------------------------------------------------------------------
2480: FUNCTION pending_request_exists(
2481: p_khr_id IN NUMBER
2482: --smahapat 11/10/02 multi-gaap - addition
2483: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE
2484: --smahapat addition end
2485: ,x_return_status OUT NOCOPY VARCHAR2
2486: ) RETURN BOOLEAN
2487: IS

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

2484: --smahapat addition end
2485: ,x_return_status OUT NOCOPY VARCHAR2
2486: ) RETURN BOOLEAN
2487: IS
2488: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2489: SELECT '1' FROM dual
2490: WHERE EXISTS
2491: (SELECT '1'
2492: FROM OKL_STREAM_INTERFACES

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

2493: WHERE khr_id = p_khr_id
2494: AND SIS_CODE IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST,G_SIS_RET_DATA_RECEIVED)
2495: );
2496: --smahapat 11/10/02 multi-gaap - addition
2497: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
2498:
2499: SELECT '1' FROM dual
2500: WHERE EXISTS
2501: (SELECT '1'

Line 3126: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE

3122: ---------------------------------------------------------------------------
3123: FUNCTION pending_request_exists(
3124: p_khr_id IN NUMBER
3125: --smahapat 11/10/02 multi-gaap - addition
3126: ,p_purpose_code IN OKL_STREAM_INTERFACES_V.PURPOSE_CODE%TYPE
3127: --smahapat addition end
3128: ,x_return_status OUT NOCOPY VARCHAR2
3129: ) RETURN BOOLEAN
3130: IS

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

3127: --smahapat addition end
3128: ,x_return_status OUT NOCOPY VARCHAR2
3129: ) RETURN BOOLEAN
3130: IS
3131: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
3132: SELECT '1' FROM dual
3133: WHERE EXISTS
3134: (SELECT '1'
3135: FROM OKL_STREAM_INTERFACES

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

3138: );
3139: --smahapat 11/10/02 multi-gaap - addition
3140:
3141:
3142: CURSOR l_okl_sif_rpt_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
3143: SELECT '1' FROM dual
3144: WHERE EXISTS
3145: (SELECT '1'
3146: FROM OKL_STREAM_INTERFACES

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

4952:
4953: ,x_return_status OUT NOCOPY VARCHAR2
4954: ) RETURN BOOLEAN
4955: IS
4956: CURSOR l_okl_sif_status_csr(p_khr_id IN OKL_STREAM_INTERFACES_V.KHR_ID%TYPE) IS
4957: SELECT '1' FROM dual
4958: WHERE EXISTS
4959: (SELECT '1'
4960: FROM OKL_STREAM_INTERFACES