1451:
1452:
1453: l_chr_id okl_k_headers.id%type;
1454: l_rle_code okc_k_party_roles_v.rle_code%type;
1455: l_cle_id okl_k_lines.id%type;
1456: l_lty_code okc_line_styles_b.lty_code%type;
1457:
1458:
1459:
1910: row_count Number default 0;
1911:
1912: l_chr_id okl_k_headers.id%type;
1913: l_rle_code okc_k_party_roles_v.rle_code%type;
1914: l_cle_id okl_k_lines.id%type;
1915: l_lty_code okc_line_styles_b.lty_code%type;
1916:
1917: l_api_name CONSTANT VARCHAR2(30) := 'Get_Party_Jtot_data';
1918: l_api_version CONSTANT NUMBER := 1.0;
2374: row_count Number default 0;
2375:
2376:
2377: l_chr_id okl_k_headers.id%type;
2378: l_parent_cle_id okl_k_lines.id%type;
2379: l_cle_id okl_k_lines.id%type;
2380: l_lty_code okc_line_styles_b.lty_code%type;
2381:
2382:
2375:
2376:
2377: l_chr_id okl_k_headers.id%type;
2378: l_parent_cle_id okl_k_lines.id%type;
2379: l_cle_id okl_k_lines.id%type;
2380: l_lty_code okc_line_styles_b.lty_code%type;
2381:
2382:
2383:
3452:
3453:
3454:
3455: l_chr_id okl_k_headers.id%type;
3456: l_cle_id okl_k_lines.id%type;
3457: l_cle_id okl_k_lines.id%type;
3458: l_lty_code okc_line_styles_b.lty_code%type;
3459:
3460:
3453:
3454:
3455: l_chr_id okl_k_headers.id%type;
3456: l_cle_id okl_k_lines.id%type;
3457: l_cle_id okl_k_lines.id%type;
3458: l_lty_code okc_line_styles_b.lty_code%type;
3459:
3460:
3461: l_fee_ak_prompt AK_ATTRIBUTES_VL.attribute_label_long%type;
5027: row_count Number default 0;
5028:
5029:
5030: l_chr_id okl_k_headers.id%type;
5031: l_cle_id okl_k_lines.id%type;
5032: l_cle_id okl_k_lines.id%type;
5033: l_lty_code okc_line_styles_b.lty_code%type;
5034:
5035:
5028:
5029:
5030: l_chr_id okl_k_headers.id%type;
5031: l_cle_id okl_k_lines.id%type;
5032: l_cle_id okl_k_lines.id%type;
5033: l_lty_code okc_line_styles_b.lty_code%type;
5034:
5035:
5036:
7288: l_rollover_yn varchar2(1) := null;
7289: cursor l_rollover_fee_csr is
7290: select 'Y'
7291: from okc_k_lines_b cle,
7292: okl_k_lines kle
7293: where cle.id = kle.id
7294: and cle.dnz_chr_id = p_chr_id
7295: and cle.chr_id = p_chr_id
7296: and kle.fee_type = 'ROLLOVER';