APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_LIST_HEADERS_V

Line 5151: p_price_list_name IN okx_list_headers_v.name%TYPE,

5147: -- Called By:
5148: ------------------------------------------------------------------------------
5149: PROCEDURE get_price_list_id(
5150: x_return_status OUT NOCOPY VARCHAR2,
5151: p_price_list_name IN okx_list_headers_v.name%TYPE,
5152: p_price_list_id IN okx_list_headers_v.id1%TYPE,
5153: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE
5154: ) IS
5155:

Line 5152: p_price_list_id IN okx_list_headers_v.id1%TYPE,

5148: ------------------------------------------------------------------------------
5149: PROCEDURE get_price_list_id(
5150: x_return_status OUT NOCOPY VARCHAR2,
5151: p_price_list_name IN okx_list_headers_v.name%TYPE,
5152: p_price_list_id IN okx_list_headers_v.id1%TYPE,
5153: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE
5154: ) IS
5155:
5156: l_proc_name VARCHAR2(35) := 'GET_PRICE_LIST_ID';

Line 5153: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE

5149: PROCEDURE get_price_list_id(
5150: x_return_status OUT NOCOPY VARCHAR2,
5151: p_price_list_name IN okx_list_headers_v.name%TYPE,
5152: p_price_list_id IN okx_list_headers_v.id1%TYPE,
5153: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE
5154: ) IS
5155:
5156: l_proc_name VARCHAR2(35) := 'GET_PRICE_LIST_ID';
5157: CURSOR price_csr (p_price_list_name VARCHAR2,

Line 5160: FROM okx_list_headers_v

5156: l_proc_name VARCHAR2(35) := 'GET_PRICE_LIST_ID';
5157: CURSOR price_csr (p_price_list_name VARCHAR2,
5158: p_price_list_id NUMBER) IS
5159: SELECT id1
5160: FROM okx_list_headers_v
5161: WHERE list_type_code = 'PRL'
5162: AND ((name = p_price_list_name
5163: AND
5164: p_price_list_name IS NOT NULL

Line 5174: l_id okx_list_headers_v.id1%TYPE;

5170: )
5171: )
5172: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE);
5173:
5174: l_id okx_list_headers_v.id1%TYPE;
5175: price_failed EXCEPTION;
5176:
5177: BEGIN
5178: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5398: x_price_list_id okx_list_headers_v.id1%TYPE;

5394: x_lienholder_id NUMBER := NULL;
5395: x_title_issuer_id NUMBER := NULL;
5396: l_rgp_id NUMBER;
5397: x_base_uom_id okx_tuom_v.id1%TYPE;
5398: x_price_list_id okx_list_headers_v.id1%TYPE;
5399: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5400: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5401: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5402: l_freq_id okl_time_units_v.id1%TYPE;

Line 5957: x_price_list_id okx_list_headers_v.id1%TYPE;

5953: l_rgp_id NUMBER;
5954: x_usage_item_id okx_system_items_v.id1%TYPE;
5955: x_usage_id2 okx_system_items_v.id2%TYPE;
5956: x_base_uom_id okx_tuom_v.id1%TYPE;
5957: x_price_list_id okx_list_headers_v.id1%TYPE;
5958: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5959: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5960: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5961: l_freq_id okl_time_units_v.id1%TYPE;