APPS.OKL_RTP_PVT dependencies on OKL_REPORT_TRX_PARAMS_S

Line 66: CURSOR c_pk_csr IS SELECT okl_report_trx_params_s.NEXTVAL FROM DUAL;

62: -- FUNCTION get_seq_id
63: ---------------------------------------------------------------------------
64: FUNCTION get_seq_id RETURN NUMBER IS
65: l_pk_value NUMBER;
66: CURSOR c_pk_csr IS SELECT okl_report_trx_params_s.NEXTVAL FROM DUAL;
67: BEGIN
68: /* Fetch the pk value from the sequence */
69: OPEN c_pk_csr;
70: FETCH c_pk_csr INTO l_pk_value;

Line 323: l_test_strm_value OKL_REPORT_TRX_PARAMS.STY_ID%TYPE;

319:
320: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
321: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
322: l_test_value NUMBER := 0;
323: l_test_strm_value OKL_REPORT_TRX_PARAMS.STY_ID%TYPE;
324:
325: -- cursor to validate existence of record for given report id, try id and sty id
326: CURSOR c_is_record_exists(
327: p_report_id OKL_REPORT_TRX_PARAMS.REPORT_ID%TYPE

Line 329: ,p_sty_id OKL_REPORT_TRX_PARAMS.STY_ID%TYPE

325: -- cursor to validate existence of record for given report id, try id and sty id
326: CURSOR c_is_record_exists(
327: p_report_id OKL_REPORT_TRX_PARAMS.REPORT_ID%TYPE
328: ,p_try_id OKL_REPORT_TRX_PARAMS.TRY_ID%TYPE
329: ,p_sty_id OKL_REPORT_TRX_PARAMS.STY_ID%TYPE
330: ,p_trx_param_id OKL_REPORT_TRX_PARAMS.TRX_PARAMETER_ID%TYPE) IS
331: SELECT 1
332: FROM OKL_REPORT_TRX_PARAMS
333: WHERE REPORT_ID = p_report_id