APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKL_INDICES

Line 4738: x_index_id OUT NOCOPY okl_indices.id%TYPE

4734: ------------------------------------------------------------------------------
4735: PROCEDURE get_index_id(
4736: x_return_status OUT NOCOPY VARCHAR2,
4737: p_index_name IN okl_header_interface.index_name%TYPE,
4738: x_index_id OUT NOCOPY okl_indices.id%TYPE
4739: ) IS
4740:
4741: CURSOR index_csr (p_index_name okl_header_interface.index_name%TYPE) IS
4742: SELECT id

Line 4743: FROM okl_indices

4739: ) IS
4740:
4741: CURSOR index_csr (p_index_name okl_header_interface.index_name%TYPE) IS
4742: SELECT id
4743: FROM okl_indices
4744: WHERE name = p_index_name;
4745:
4746: l_proc_name VARCHAR2(35) := 'GET_INDEX_ID';
4747: l_id okl_indices.id%TYPE;

Line 4747: l_id okl_indices.id%TYPE;

4743: FROM okl_indices
4744: WHERE name = p_index_name;
4745:
4746: l_proc_name VARCHAR2(35) := 'GET_INDEX_ID';
4747: l_id okl_indices.id%TYPE;
4748: index_failed EXCEPTION;
4749:
4750: BEGIN
4751: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 7920: x_index_id okl_indices.id%TYPE;

7916: x_bank_account_id OKX_RCPT_METHOD_ACCOUNTS_V.ID1%TYPE;
7917: x_invoice_format_id OKL_INVOICE_FORMATS_V.ID%TYPE;
7918: x_payment_method_id OKX_RECEIPT_METHODS_V.ID1%TYPE;
7919: x_invoice_format_name okl_invoice_formats_v.name%TYPE;
7920: x_index_id okl_indices.id%TYPE;
7921:
7922: l_rgd_code OKC_RULE_GROUPS_V.RGD_CODE%TYPE;
7923: l_rgp_type OKC_RULE_GROUPS_V.RGP_TYPE%TYPE;
7924: