APPS.OKL_RSP_PVT dependencies on OKL_REPORT_STREAM_PARAMS_S

Line 66: CURSOR c_pk_csr IS SELECT okl_report_stream_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_stream_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 118: WHERE okl_report_stream_params.stream_parameter_id = p_stream_parameter_id;

114: LAST_UPDATED_BY,
115: LAST_UPDATE_DATE,
116: LAST_UPDATE_LOGIN
117: FROM Okl_Report_Stream_Params
118: WHERE okl_report_stream_params.stream_parameter_id = p_stream_parameter_id;
119: l_okl_report_stream_params_pk okl_report_stream_p1%ROWTYPE;
120: l_rps_rec rps_rec_type;
121: BEGIN
122: x_no_data_found := TRUE;

Line 349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE

345:
346: -- cursor to validate existence of record for a given report id and stram type
347: CURSOR c_is_record_exists(
348: p_report_id OKL_REPORT_STREAM_PARAMS.REPORT_ID%TYPE
349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE
350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
351: SELECT 1
352: FROM OKL_REPORT_STREAM_PARAMS
353: WHERE REPORT_ID = p_report_id

Line 350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS

346: -- cursor to validate existence of record for a given report id and stram type
347: CURSOR c_is_record_exists(
348: p_report_id OKL_REPORT_STREAM_PARAMS.REPORT_ID%TYPE
349: ,p_sty_id OKL_REPORT_STREAM_PARAMS.STY_ID%TYPE
350: ,p_stream_param_id OKL_REPORT_STREAM_PARAMS.STREAM_PARAMETER_ID%TYPE) IS
351: SELECT 1
352: FROM OKL_REPORT_STREAM_PARAMS
353: WHERE REPORT_ID = p_report_id
354: AND STY_ID = p_sty_id