APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKX_LIST_HEADERS_V

Line 5319: p_price_list_name IN okx_list_headers_v.name%TYPE,

5315: -- Called By:
5316: ------------------------------------------------------------------------------
5317: PROCEDURE get_price_list_id(
5318: x_return_status OUT NOCOPY VARCHAR2,
5319: p_price_list_name IN okx_list_headers_v.name%TYPE,
5320: p_price_list_id IN okx_list_headers_v.id1%TYPE,
5321: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE
5322: ) IS
5323:

Line 5320: p_price_list_id IN okx_list_headers_v.id1%TYPE,

5316: ------------------------------------------------------------------------------
5317: PROCEDURE get_price_list_id(
5318: x_return_status OUT NOCOPY VARCHAR2,
5319: p_price_list_name IN okx_list_headers_v.name%TYPE,
5320: p_price_list_id IN okx_list_headers_v.id1%TYPE,
5321: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE
5322: ) IS
5323:
5324: l_proc_name VARCHAR2(35) := 'GET_PRICE_LIST_ID';

Line 5321: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE

5317: PROCEDURE get_price_list_id(
5318: x_return_status OUT NOCOPY VARCHAR2,
5319: p_price_list_name IN okx_list_headers_v.name%TYPE,
5320: p_price_list_id IN okx_list_headers_v.id1%TYPE,
5321: x_price_list_id OUT NOCOPY okx_list_headers_v.id1%TYPE
5322: ) IS
5323:
5324: l_proc_name VARCHAR2(35) := 'GET_PRICE_LIST_ID';
5325: CURSOR price_csr (p_price_list_name VARCHAR2,

Line 5328: FROM okx_list_headers_v

5324: l_proc_name VARCHAR2(35) := 'GET_PRICE_LIST_ID';
5325: CURSOR price_csr (p_price_list_name VARCHAR2,
5326: p_price_list_id NUMBER) IS
5327: SELECT id1
5328: FROM okx_list_headers_v
5329: WHERE list_type_code = 'PRL'
5330: AND ((name = p_price_list_name
5331: AND
5332: p_price_list_name IS NOT NULL

Line 5342: l_id okx_list_headers_v.id1%TYPE;

5338: )
5339: )
5340: AND SYSDATE BETWEEN NVL(start_date_active,SYSDATE) AND NVL(end_date_active, SYSDATE);
5341:
5342: l_id okx_list_headers_v.id1%TYPE;
5343: price_failed EXCEPTION;
5344:
5345: BEGIN
5346: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 5566: x_price_list_id okx_list_headers_v.id1%TYPE;

5562: x_lienholder_id NUMBER := NULL;
5563: x_title_issuer_id NUMBER := NULL;
5564: l_rgp_id NUMBER;
5565: x_base_uom_id okx_tuom_v.id1%TYPE;
5566: x_price_list_id okx_list_headers_v.id1%TYPE;
5567: x_stream_id okl_strmtyp_source_v.id1%TYPE;
5568: l_payment_term_id okx_payables_terms_v.id1%TYPE;
5569: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
5570: l_freq_id okl_time_units_v.id1%TYPE;

Line 6125: x_price_list_id okx_list_headers_v.id1%TYPE;

6121: l_rgp_id NUMBER;
6122: x_usage_item_id okx_system_items_v.id1%TYPE;
6123: x_usage_id2 okx_system_items_v.id2%TYPE;
6124: x_base_uom_id okx_tuom_v.id1%TYPE;
6125: x_price_list_id okx_list_headers_v.id1%TYPE;
6126: x_stream_id okl_strmtyp_source_v.id1%TYPE;
6127: l_payment_term_id okx_payables_terms_v.id1%TYPE;
6128: l_vendor_paysite_id okx_vendor_sites_v.id1%TYPE;
6129: l_freq_id okl_time_units_v.id1%TYPE;