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 23459: FROM okc_line_styles_v ols1,

23455:
23456: CURSOR sub_lse_csr (p_lty_code VARCHAR2,
23457: p_top_line_lty_code VARCHAR2) IS
23458: SELECT ols2.id
23459: FROM okc_line_styles_v ols1,
23460: okc_line_styles_v ols2,
23461: okc_subclass_top_line ostl
23462: WHERE ostl.scs_code = 'LEASE'
23463: AND ostl.lse_id = ols1.id

Line 23460: okc_line_styles_v ols2,

23456: CURSOR sub_lse_csr (p_lty_code VARCHAR2,
23457: p_top_line_lty_code VARCHAR2) IS
23458: SELECT ols2.id
23459: FROM okc_line_styles_v ols1,
23460: okc_line_styles_v ols2,
23461: okc_subclass_top_line ostl
23462: WHERE ostl.scs_code = 'LEASE'
23463: AND ostl.lse_id = ols1.id
23464: AND ols1.lty_code = p_top_line_lty_code

Line 23661: FROM okc_line_styles_v

23657: WHERE name = p_asset_number
23658: AND chr_id = p_chr_id
23659: AND lse_id = (
23660: SELECT id
23661: FROM okc_line_styles_v
23662: WHERE lty_code = 'FREE_FORM1' -- to determine TOP line
23663: );
23664: BEGIN
23665: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 23733: okc_line_styles_v style,

23729: p_asset_line_id NUMBER) IS
23730: SELECT 'Y'
23731: FROM okc_k_items_v item,
23732: okl_k_lines_full_v model,
23733: okc_line_styles_v style,
23734: cs_counters cc,
23735: cs_ctr_associations assoc
23736: WHERE model.lse_id = style.id
23737: AND model.id = item.cle_id

Line 24178: x_lse_id okc_line_styles_v.id%TYPE;

24174: p_attribute15 IN okl_lines_interface.attribute15%TYPE DEFAULT NULL,
24175: p_origination_income IN okl_lines_interface.origination_income%TYPE DEFAULT NULL
24176: ) IS
24177: l_proc_name VARCHAR2(35) := 'PROCESS_OTHER_LINE';
24178: x_lse_id okc_line_styles_v.id%TYPE;
24179: x_inv_org_id NUMBER;
24180: x_inv_item_id NUMBER;
24181: x_asset_line_id okc_k_lines_v.id%TYPE;
24182: l_lty_code okc_line_styles_v.lty_code%TYPE;

Line 24182: l_lty_code okc_line_styles_v.lty_code%TYPE;

24178: x_lse_id okc_line_styles_v.id%TYPE;
24179: x_inv_org_id NUMBER;
24180: x_inv_item_id NUMBER;
24181: x_asset_line_id okc_k_lines_v.id%TYPE;
24182: l_lty_code okc_line_styles_v.lty_code%TYPE;
24183: l_link_lty_code okc_line_styles_v.lty_code%TYPE;
24184: l_link_top_code VARCHAR2(35);
24185: x_stream_type_id NUMBER;
24186: x_usage_item_id NUMBER;

Line 24183: l_link_lty_code okc_line_styles_v.lty_code%TYPE;

24179: x_inv_org_id NUMBER;
24180: x_inv_item_id NUMBER;
24181: x_asset_line_id okc_k_lines_v.id%TYPE;
24182: l_lty_code okc_line_styles_v.lty_code%TYPE;
24183: l_link_lty_code okc_line_styles_v.lty_code%TYPE;
24184: l_link_top_code VARCHAR2(35);
24185: x_stream_type_id NUMBER;
24186: x_usage_item_id NUMBER;
24187: x_usage_id2 NUMBER;