APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_BPD_ACTIVE_CSH_RLS_V

Line 7813: x_cash_appl_rule_id OUT NOCOPY OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE

7809: x_msg_data OUT NOCOPY VARCHAR2,
7810: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
7811: p_org_id IN OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE,
7812: p_cash_appl_rule_name IN OKL_HEADER_INTERFACE.CASH_APPL_RULE_NAME%TYPE,
7813: x_cash_appl_rule_id OUT NOCOPY OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE
7814: ) IS
7815:
7816: cursor cash_csr (p_rule_name VARCHAR2,
7817: p_org_id NUMBER) IS

Line 7819: FROM okl_bpd_active_csh_rls_v

7815:
7816: cursor cash_csr (p_rule_name VARCHAR2,
7817: p_org_id NUMBER) IS
7818: SELECT id1
7819: FROM okl_bpd_active_csh_rls_v
7820: WHERE name = p_rule_name
7821: AND org_id = p_org_id
7822: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE),TRUNC(SYSDATE)) AND
7823: NVL(TRUNC(END_DATE),TRUNC(SYSDATE));

Line 8246: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;

8242: l_eot_serv_mant_frml VARCHAR2(150);
8243:
8244:
8245:
8246: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;
8247:
8248: l_rate_counter NUMBER := 1;
8249: l_tmpl_rate_rec krpv_rec_type;
8250: l_k_rate_tbl krpv_tbl_type;

Line 21891: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;

21887: x_payment_method_id NUMBER := NULL;
21888: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
21889: l_rgp_id NUMBER;
21890:
21891: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;
21892: BEGIN
21893:
21894: x_return_status := OKL_API.G_RET_STS_SUCCESS;
21895: debug_message(l_proc_name);