APPS.OKL_OPEN_INTERFACE_PVT dependencies on OKC_LINE_STYLES_V

Line 16: G_FA_LINE_LTY_ID OKC_LINE_STYLES_V.ID%TYPE := 42;

12: g_bill_to_address_id NUMBER; -- only populated from populate_header_rec()
13: g_release_asset_flag VARCHAR2(1); -- only updated at load_input_record()
14: g_instance_number VARCHAR2(30); -- Parallel submission instance number
15: g_qcl_id NUMBER;
16: G_FA_LINE_LTY_ID OKC_LINE_STYLES_V.ID%TYPE := 42;
17: G_FIN_LINE_LTY_ID OKC_LINE_STYLES_V.ID%TYPE := 33;
18:
19: G_BULK_BATCH_SIZE NUMBER := 10000;
20: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OPEN_INTERFACE_PVT';

Line 17: G_FIN_LINE_LTY_ID OKC_LINE_STYLES_V.ID%TYPE := 33;

13: g_release_asset_flag VARCHAR2(1); -- only updated at load_input_record()
14: g_instance_number VARCHAR2(30); -- Parallel submission instance number
15: g_qcl_id NUMBER;
16: G_FA_LINE_LTY_ID OKC_LINE_STYLES_V.ID%TYPE := 42;
17: G_FIN_LINE_LTY_ID OKC_LINE_STYLES_V.ID%TYPE := 33;
18:
19: G_BULK_BATCH_SIZE NUMBER := 10000;
20: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_OPEN_INTERFACE_PVT';
21: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

Line 23270: FROM okc_line_styles_v ols1,

23266:
23267: CURSOR sub_lse_csr (p_lty_code VARCHAR2,
23268: p_top_line_lty_code VARCHAR2) IS
23269: SELECT ols2.id
23270: FROM okc_line_styles_v ols1,
23271: okc_line_styles_v ols2,
23272: okc_subclass_top_line ostl
23273: WHERE ostl.scs_code = 'LEASE'
23274: AND ostl.lse_id = ols1.id

Line 23271: okc_line_styles_v ols2,

23267: CURSOR sub_lse_csr (p_lty_code VARCHAR2,
23268: p_top_line_lty_code VARCHAR2) IS
23269: SELECT ols2.id
23270: FROM okc_line_styles_v ols1,
23271: okc_line_styles_v ols2,
23272: okc_subclass_top_line ostl
23273: WHERE ostl.scs_code = 'LEASE'
23274: AND ostl.lse_id = ols1.id
23275: AND ols1.lty_code = p_top_line_lty_code

Line 23472: FROM okc_line_styles_v

23468: WHERE name = p_asset_number
23469: AND chr_id = p_chr_id
23470: AND lse_id = (
23471: SELECT id
23472: FROM okc_line_styles_v
23473: WHERE lty_code = 'FREE_FORM1' -- to determine TOP line
23474: );
23475: BEGIN
23476: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 23544: okc_line_styles_v style,

23540: p_asset_line_id NUMBER) IS
23541: SELECT 'Y'
23542: FROM okc_k_items_v item,
23543: okl_k_lines_full_v model,
23544: okc_line_styles_v style,
23545: cs_counters cc,
23546: cs_ctr_associations assoc
23547: WHERE model.lse_id = style.id
23548: AND model.id = item.cle_id

Line 23971: x_lse_id okc_line_styles_v.id%TYPE;

23967: p_pth_evg_stream_purpose_code IN okl_lines_interface.pth_evg_stream_purpose_code%TYPE,
23968: p_fee_purpose_code IN okl_lines_interface.fee_purpose_code%TYPE
23969: ) IS
23970: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
23971: x_lse_id okc_line_styles_v.id%TYPE;
23972: x_inv_org_id NUMBER;
23973: x_inv_item_id NUMBER;
23974: x_asset_line_id okc_k_lines_v.id%TYPE;
23975: l_lty_code okc_line_styles_v.lty_code%TYPE;

Line 23975: l_lty_code okc_line_styles_v.lty_code%TYPE;

23971: x_lse_id okc_line_styles_v.id%TYPE;
23972: x_inv_org_id NUMBER;
23973: x_inv_item_id NUMBER;
23974: x_asset_line_id okc_k_lines_v.id%TYPE;
23975: l_lty_code okc_line_styles_v.lty_code%TYPE;
23976: l_link_lty_code okc_line_styles_v.lty_code%TYPE;
23977: l_link_top_code VARCHAR2(35);
23978: x_stream_type_id NUMBER;
23979: x_usage_item_id NUMBER;

Line 23976: l_link_lty_code okc_line_styles_v.lty_code%TYPE;

23972: x_inv_org_id NUMBER;
23973: x_inv_item_id NUMBER;
23974: x_asset_line_id okc_k_lines_v.id%TYPE;
23975: l_lty_code okc_line_styles_v.lty_code%TYPE;
23976: l_link_lty_code okc_line_styles_v.lty_code%TYPE;
23977: l_link_top_code VARCHAR2(35);
23978: x_stream_type_id NUMBER;
23979: x_usage_item_id NUMBER;
23980: x_usage_id2 NUMBER;