DBA Data[Home] [Help]

APPS.OKL_RAP_PVT dependencies on OKL_REPORT_ACC_PARAMS_S

Line 66: CURSOR c_pk_csr IS SELECT okl_report_acc_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_acc_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 278: ,p_seg_range_from OKL_REPORT_ACC_PARAMS.SEGMENT_RANGE_FROM%TYPE) IS

274: -- cursor to validate report id, account parameter type code and segment range from
275: CURSOR c_is_record_exists(
276: p_report_id OKL_REPORT_ACC_PARAMS.REPORT_ID%TYPE
277: ,p_acct_param_type_code OKL_REPORT_ACC_PARAMS.ACCT_PARAM_TYPE_CODE%TYPE
278: ,p_seg_range_from OKL_REPORT_ACC_PARAMS.SEGMENT_RANGE_FROM%TYPE) IS
279: select 1
280: from okl_report_acc_params a,
281: fnd_lookups b
282: where b.lookup_type='OKL_ACC_PARAMETER_TYPES'