APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_BPD_ACTIVE_CSH_RLS_V

Line 7645: x_cash_appl_rule_id OUT NOCOPY OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE

7641: x_msg_data OUT NOCOPY VARCHAR2,
7642: p_contract_number IN OKL_HEADER_INTERFACE.CONTRACT_NUMBER_OLD%TYPE,
7643: p_org_id IN OKC_K_HEADERS_V.AUTHORING_ORG_ID%TYPE,
7644: p_cash_appl_rule_name IN OKL_HEADER_INTERFACE.CASH_APPL_RULE_NAME%TYPE,
7645: x_cash_appl_rule_id OUT NOCOPY OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE
7646: ) IS
7647:
7648: cursor cash_csr (p_rule_name VARCHAR2,
7649: p_org_id NUMBER) IS

Line 7651: FROM okl_bpd_active_csh_rls_v

7647:
7648: cursor cash_csr (p_rule_name VARCHAR2,
7649: p_org_id NUMBER) IS
7650: SELECT id1
7651: FROM okl_bpd_active_csh_rls_v
7652: WHERE name = p_rule_name
7653: AND org_id = p_org_id
7654: AND TRUNC(SYSDATE) BETWEEN NVL(TRUNC(START_DATE),TRUNC(SYSDATE)) AND
7655: NVL(TRUNC(END_DATE),TRUNC(SYSDATE));

Line 8078: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;

8074: l_eot_serv_mant_frml VARCHAR2(150);
8075:
8076:
8077:
8078: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;
8079:
8080: l_rate_counter NUMBER := 1;
8081: l_tmpl_rate_rec krpv_rec_type;
8082: l_k_rate_tbl krpv_tbl_type;

Line 21705: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;

21701: x_payment_method_id NUMBER := NULL;
21702: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
21703: l_rgp_id NUMBER;
21704:
21705: x_cash_appl_rule_id OKL_BPD_ACTIVE_CSH_RLS_V.ID1%TYPE;
21706: BEGIN
21707:
21708: x_return_status := OKL_API.G_RET_STS_SUCCESS;
21709: debug_message(l_proc_name);