APPS.OKL_RELEASE_PVT dependencies on OKC_K_LINES_V

Line 53: TYPE g_top_line_tbl IS TABLE OF OKC_K_LINES_V.ID%TYPE

49: G_YN_ERROR CONSTANT VARCHAR2(200) := 'Invalid Value for ';
50: -------------------------------------------------------------------------------------------------
51: -- GLOBAL COMPOSITE TYPE VARIABLES
52: -------------------------------------------------------------------------------------------------
53: TYPE g_top_line_tbl IS TABLE OF OKC_K_LINES_V.ID%TYPE
54: INDEX BY BINARY_INTEGER;
55: TYPE g_asset_num_tbl IS TABLE OF OKL_TXL_ASSETS_V.ASSET_NUMBER%TYPE
56: INDEX BY BINARY_INTEGER;
57: subtype clev_rec_type is OKL_OKC_MIGRATION_PVT.CLEV_REC_TYPE;

Line 1069: ln_new_cle_id OKC_K_LINES_V.ID%TYPE;

1065: l_api_name CONSTANT VARCHAR2(30) := 'LOCAL_COPY_CONTRACT';
1066: l_chrv_rec chrv_rec_type;
1067: l_khrv_rec khrv_rec_type;
1068: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
1069: ln_new_cle_id OKC_K_LINES_V.ID%TYPE;
1070: lt_klev_tbl_type klev_tbl_type;
1071: ltx_klev_tbl_type klev_tbl_type;
1072: i number := 0;
1073:

Line 1455: CURSOR c_validate_top_line(p_cle_id OKC_K_LINES_V.ID%TYPE) IS

1451: j NUMBER := 0;
1452: ln_top_present NUMBER := 0;
1453: ln_asset_present NUMBER := 0;
1454: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1455: CURSOR c_validate_top_line(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1456: SELECT 1
1457: FROM DUAL
1458: WHERE EXISTS (SELECT '1'
1459: FROM OKL_ASSET_RETURNS_B

Line 1856: FROM okc_k_lines_v cle,

1852: tcl.source_column_2,
1853: tcl.source_value_2,
1854: tcl.source_column_3,
1855: tcl.source_value_3
1856: FROM okc_k_lines_v cle,
1857: okc_line_styles_b lse,
1858: okl_txl_cntrct_lns tcl
1859: WHERE cle.chr_id = p_chr_id
1860: AND cle.dnz_chr_id = p_chr_id

Line 2322: FROM okc_k_lines_v fin_ast_cle,

2318: (p_orig_chr_id IN NUMBER)
2319: IS
2320: SELECT fin_ast_cle.id,
2321: fin_ast_cle.name
2322: FROM okc_k_lines_v fin_ast_cle,
2323: okc_k_headers_b chr,
2324: okc_line_styles_b fin_ast_lse,
2325: okl_trx_quotes_b qte,
2326: okl_txl_quote_lines_b tql

Line 2346: okc_k_lines_v fin_ast_cle,

2342: IS
2343: SELECT fin_ast_cle.id,
2344: fin_ast_cle.name
2345: FROM okl_txl_cntrct_lns tcl,
2346: okc_k_lines_v fin_ast_cle,
2347: okl_trx_quotes_b qte,
2348: okl_txl_quote_lines_b tql
2349: WHERE tcl.tcn_id = p_source_trx_id
2350: AND tcl.before_transfer_yn = 'N'

Line 2365: FROM okc_k_lines_v fin_ast_cle,

2361: (p_orig_chr_id IN NUMBER)
2362: IS
2363: SELECT fin_ast_cle.id,
2364: fin_ast_cle.name
2365: FROM okc_k_lines_v fin_ast_cle,
2366: okc_k_headers_b chr,
2367: okc_line_styles_b fin_ast_lse,
2368: okl_trx_assets ota,
2369: okl_txl_assets_b otl

Line 2389: okc_k_lines_v fin_ast_cle,

2385: IS
2386: SELECT fin_ast_cle.id,
2387: fin_ast_cle.name
2388: FROM okl_txl_cntrct_lns tcl,
2389: okc_k_lines_v fin_ast_cle,
2390: okl_trx_assets ota,
2391: okl_txl_assets_b otl
2392: WHERE tcl.tcn_id = p_source_trx_id
2393: AND tcl.before_transfer_yn = 'N'

Line 3275: FROM okc_k_lines_v fin_ast_cle,

3271: (p_orig_chr_id IN NUMBER)
3272: IS
3273: SELECT fin_ast_cle.id,
3274: fin_ast_cle.name
3275: FROM okc_k_lines_v fin_ast_cle,
3276: okc_k_headers_b chr,
3277: okc_line_styles_b fin_ast_lse
3278: WHERE chr.id = p_orig_chr_id
3279: AND fin_ast_cle.chr_id = chr.id

Line 3292: okc_k_lines_v fin_ast_cle

3288: IS
3289: SELECT fin_ast_cle.id,
3290: fin_ast_cle.name
3291: FROM okl_txl_cntrct_lns tcl,
3292: okc_k_lines_v fin_ast_cle
3293: WHERE tcl.tcn_id = p_source_trx_id
3294: AND tcl.before_transfer_yn = 'N'
3295: AND fin_ast_cle.chr_id = p_orig_chr_id
3296: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id

Line 6930: FROM okc_k_lines_v

6926: lse_rec lse_csr%ROWTYPE;
6927:
6928: CURSOR asset_number_csr(p_cle_id IN NUMBER) IS
6929: SELECT name asset_number
6930: FROM okc_k_lines_v
6931: WHERE id = p_cle_id;
6932:
6933: asset_number_rec asset_number_csr%ROWTYPE;
6934: