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 1055: ln_new_cle_id OKC_K_LINES_V.ID%TYPE;

1051: l_api_name CONSTANT VARCHAR2(30) := 'LOCAL_COPY_CONTRACT';
1052: l_chrv_rec chrv_rec_type;
1053: l_khrv_rec khrv_rec_type;
1054: ln_new_chr_id OKC_K_HEADERS_V.ID%TYPE;
1055: ln_new_cle_id OKC_K_LINES_V.ID%TYPE;
1056: lt_klev_tbl_type klev_tbl_type;
1057: ltx_klev_tbl_type klev_tbl_type;
1058: i number := 0;
1059:

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

1430: j NUMBER := 0;
1431: ln_top_present NUMBER := 0;
1432: ln_asset_present NUMBER := 0;
1433: x_return_status VARCHAR2(3) := OKL_API.G_RET_STS_SUCCESS;
1434: CURSOR c_validate_top_line(p_cle_id OKC_K_LINES_V.ID%TYPE) IS
1435: SELECT 1
1436: FROM DUAL
1437: WHERE EXISTS (SELECT '1'
1438: FROM OKL_ASSET_RETURNS_B

Line 1835: FROM okc_k_lines_v cle,

1831: tcl.source_column_2,
1832: tcl.source_value_2,
1833: tcl.source_column_3,
1834: tcl.source_value_3
1835: FROM okc_k_lines_v cle,
1836: okc_line_styles_b lse,
1837: okl_txl_cntrct_lns tcl
1838: WHERE cle.chr_id = p_chr_id
1839: AND cle.dnz_chr_id = p_chr_id

Line 2298: FROM okc_k_lines_v fin_ast_cle,

2294: (p_orig_chr_id IN NUMBER)
2295: IS
2296: SELECT fin_ast_cle.id,
2297: fin_ast_cle.name
2298: FROM okc_k_lines_v fin_ast_cle,
2299: okc_k_headers_b chr,
2300: okc_line_styles_b fin_ast_lse,
2301: okl_trx_quotes_b qte,
2302: okl_txl_quote_lines_b tql

Line 2322: okc_k_lines_v fin_ast_cle,

2318: IS
2319: SELECT fin_ast_cle.id,
2320: fin_ast_cle.name
2321: FROM okl_txl_cntrct_lns tcl,
2322: okc_k_lines_v fin_ast_cle,
2323: okl_trx_quotes_b qte,
2324: okl_txl_quote_lines_b tql
2325: WHERE tcl.tcn_id = p_source_trx_id
2326: AND tcl.before_transfer_yn = 'N'

Line 2341: FROM okc_k_lines_v fin_ast_cle,

2337: (p_orig_chr_id IN NUMBER)
2338: IS
2339: SELECT fin_ast_cle.id,
2340: fin_ast_cle.name
2341: FROM okc_k_lines_v fin_ast_cle,
2342: okc_k_headers_b chr,
2343: okc_line_styles_b fin_ast_lse,
2344: okl_trx_assets ota,
2345: okl_txl_assets_b otl

Line 2365: okc_k_lines_v fin_ast_cle,

2361: IS
2362: SELECT fin_ast_cle.id,
2363: fin_ast_cle.name
2364: FROM okl_txl_cntrct_lns tcl,
2365: okc_k_lines_v fin_ast_cle,
2366: okl_trx_assets ota,
2367: okl_txl_assets_b otl
2368: WHERE tcl.tcn_id = p_source_trx_id
2369: AND tcl.before_transfer_yn = 'N'

Line 3221: FROM okc_k_lines_v fin_ast_cle,

3217: (p_orig_chr_id IN NUMBER)
3218: IS
3219: SELECT fin_ast_cle.id,
3220: fin_ast_cle.name
3221: FROM okc_k_lines_v fin_ast_cle,
3222: okc_k_headers_b chr,
3223: okc_line_styles_b fin_ast_lse
3224: WHERE chr.id = p_orig_chr_id
3225: AND fin_ast_cle.chr_id = chr.id

Line 3238: okc_k_lines_v fin_ast_cle

3234: IS
3235: SELECT fin_ast_cle.id,
3236: fin_ast_cle.name
3237: FROM okl_txl_cntrct_lns tcl,
3238: okc_k_lines_v fin_ast_cle
3239: WHERE tcl.tcn_id = p_source_trx_id
3240: AND tcl.before_transfer_yn = 'N'
3241: AND fin_ast_cle.chr_id = p_orig_chr_id
3242: AND fin_ast_cle.dnz_chr_id = p_orig_chr_id

Line 6621: FROM okc_k_lines_v

6617: lse_rec lse_csr%ROWTYPE;
6618:
6619: CURSOR asset_number_csr(p_cle_id IN NUMBER) IS
6620: SELECT name asset_number
6621: FROM okc_k_lines_v
6622: WHERE id = p_cle_id;
6623:
6624: asset_number_rec asset_number_csr%ROWTYPE;
6625: