APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_INDICES

Line 4570: x_index_id OUT NOCOPY okl_indices.id%TYPE

4566: ------------------------------------------------------------------------------
4567: PROCEDURE get_index_id(
4568: x_return_status OUT NOCOPY VARCHAR2,
4569: p_index_name IN okl_header_interface.index_name%TYPE,
4570: x_index_id OUT NOCOPY okl_indices.id%TYPE
4571: ) IS
4572:
4573: CURSOR index_csr (p_index_name okl_header_interface.index_name%TYPE) IS
4574: SELECT id

Line 4575: FROM okl_indices

4571: ) IS
4572:
4573: CURSOR index_csr (p_index_name okl_header_interface.index_name%TYPE) IS
4574: SELECT id
4575: FROM okl_indices
4576: WHERE name = p_index_name;
4577:
4578: l_proc_name VARCHAR2(35) := 'GET_INDEX_ID';
4579: l_id okl_indices.id%TYPE;

Line 4579: l_id okl_indices.id%TYPE;

4575: FROM okl_indices
4576: WHERE name = p_index_name;
4577:
4578: l_proc_name VARCHAR2(35) := 'GET_INDEX_ID';
4579: l_id okl_indices.id%TYPE;
4580: index_failed EXCEPTION;
4581:
4582: BEGIN
4583: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 7752: x_index_id okl_indices.id%TYPE;

7748: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
7749: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;
7750: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7751: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7752: x_index_id okl_indices.id%TYPE;
7753:
7754: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7755: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7756: