APPS.OKL_REP_PVT dependencies on OKL_REPORTS_B_S

Line 66: CURSOR c_pk_csr IS SELECT okl_reports_b_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_reports_b_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 649: CURSOR c_is_valid_rpt_status_code(p_rpt_status_code OKL_REPORTS_B.STATUS_CODE%TYPE) IS

645: WHERE LOOKUP_TYPE = 'OKL_REPORT_TYPES'
646: AND LOOKUP_CODE = p_rpt_type_code;
647:
648: -- cursor to validate report status code
649: CURSOR c_is_valid_rpt_status_code(p_rpt_status_code OKL_REPORTS_B.STATUS_CODE%TYPE) IS
650: SELECT 1
651: FROM FND_LOOKUPS
652: WHERE LOOKUP_TYPE = 'OKL_RECON_REPORT_STATUSES'
653: AND LOOKUP_CODE = p_rpt_status_code;