eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKC_K_HEADERS_V

Line 78: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

74: PROCEDURE check_line_rule (
75: x_return_status OUT NOCOPY VARCHAR2,
76: x_msg_count OUT NOCOPY NUMBER,
77: x_msg_data OUT NOCOPY VARCHAR2,
78: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
79: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
80: x_rule_present OUT NOCOPY VARCHAR2) IS
81: l_proc_name VARCHAR2(35) := 'CHECK_LINE_RULE';
82:

Line 83: CURSOR lrule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

79: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
80: x_rule_present OUT NOCOPY VARCHAR2) IS
81: l_proc_name VARCHAR2(35) := 'CHECK_LINE_RULE';
82:
83: CURSOR lrule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
84: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
85: SELECT 'Y'
86: FROM okc_rules_v rule,
87: okc_rule_groups_v rg,

Line 162: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

158: PROCEDURE check_ro_subline_rule (
159: x_return_status OUT NOCOPY VARCHAR2,
160: x_msg_count OUT NOCOPY NUMBER,
161: x_msg_data OUT NOCOPY VARCHAR2,
162: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
163: p_cle_id IN OKL_K_LINES.ID%TYPE,
164: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
165: x_rule_present OUT NOCOPY VARCHAR2) IS
166: l_proc_name VARCHAR2(35) := 'CHECK_RO_SUBLINE_RULE';

Line 168: CURSOR l_ro_sl_rule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

164: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
165: x_rule_present OUT NOCOPY VARCHAR2) IS
166: l_proc_name VARCHAR2(35) := 'CHECK_RO_SUBLINE_RULE';
167:
168: CURSOR l_ro_sl_rule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
169: p_cle_id OKL_K_LINES.ID%TYPE,
170: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
171:
172: SELECT 'Y'

Line 1063: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1059: -- Called By:
1060: ------------------------------------------------------------------------------
1061: PROCEDURE get_currency_precision (
1062: x_return_status OUT NOCOPY VARCHAR2,
1063: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1064: x_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE
1065: ) IS
1066: CURSOR chr_csr (p_chr_id NUMBER) IS
1067: SELECT currency_code

Line 1068: FROM okc_k_headers_v

1064: x_precision OUT NOCOPY FND_CURRENCIES.PRECISION%TYPE
1065: ) IS
1066: CURSOR chr_csr (p_chr_id NUMBER) IS
1067: SELECT currency_code
1068: FROM okc_k_headers_v
1069: WHERE id = p_chr_id;
1070:
1071: CURSOR curr_csr (p_curr_code VARCHAR2) IS
1072: SELECT precision

Line 1130: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1126: PROCEDURE create_line_rule(
1127: x_return_status OUT NOCOPY VARCHAR2,
1128: x_msg_count OUT NOCOPY NUMBER,
1129: x_msg_data OUT NOCOPY VARCHAR2,
1130: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1131: p_cle_id IN NUMBER,
1132: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
1133: p_fin_line_capital_amount IN NUMBER,
1134: p_tot_capital_amount IN NUMBER,

Line 1398: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1394: PROCEDURE check_header_rule(
1395: x_return_status OUT NOCOPY VARCHAR2,
1396: x_msg_count OUT NOCOPY NUMBER,
1397: x_msg_data OUT NOCOPY VARCHAR2,
1398: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1399: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
1400: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type,
1401: x_rg_count OUT NOCOPY NUMBER
1402: ) IS

Line 1462: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1458: PROCEDURE get_total_capital_amount(
1459: x_return_status OUT NOCOPY VARCHAR2,
1460: x_msg_count OUT NOCOPY NUMBER,
1461: x_msg_data OUT NOCOPY VARCHAR2,
1462: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1463: x_tot_capital_amount OUT NOCOPY NUMBER
1464: ) IS
1465: l_proc_name VARCHAR2(35) := 'GET_TOTAL_CAPITAL_AMOUNT';
1466:

Line 1468: CURSOR fin_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1464: ) IS
1465: l_proc_name VARCHAR2(35) := 'GET_TOTAL_CAPITAL_AMOUNT';
1466:
1467: -- Total Capital amount from Financial Asset Top line
1468: CURSOR fin_cap_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1469: SELECT SUM(NVL(line.capital_amount,0))
1470: FROM okl_k_lines_full_v line
1471: WHERE line.dnz_chr_id = p_chr_id
1472: AND EXISTS ( SELECT 'Y'

Line 1552: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1548: ------------------------------------------------------------------------------
1549: PROCEDURE split_payments(
1550: p_api_version IN NUMBER,
1551: p_init_msg_list IN VARCHAR2,
1552: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1553: p_line_csr_tbl IN line_csr_tbl,
1554: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
1555: p_tot_capital_amount IN NUMBER,
1556: p_precision IN FND_CURRENCIES.PRECISION%TYPE,

Line 1879: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

1875: p_init_msg_list IN VARCHAR2,
1876: x_return_status OUT NOCOPY VARCHAR2,
1877: x_msg_count OUT NOCOPY NUMBER,
1878: x_msg_data OUT NOCOPY VARCHAR2,
1879: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1880: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
1881: ) IS
1882: --Changed query for performance --dkagrawa
1883: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

Line 1883: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1879: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1880: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
1881: ) IS
1882: --Changed query for performance --dkagrawa
1883: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1884: SELECT okl.id, okl.capital_amount -- bug# 7661717
1885: FROM okl_k_lines_full_v okl,
1886: okc_line_styles_b ols,
1887: okc_statuses_b okcsts

Line 2212: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2208: p_init_msg_list IN VARCHAR2,
2209: x_return_status OUT NOCOPY VARCHAR2,
2210: x_msg_count OUT NOCOPY NUMBER,
2211: x_msg_data OUT NOCOPY VARCHAR2,
2212: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2213: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2214: ) IS
2215: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2216: SELECT okl.id, okl.capital_amount

Line 2215: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

2211: x_msg_data OUT NOCOPY VARCHAR2,
2212: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2213: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2214: ) IS
2215: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
2216: SELECT okl.id, okl.capital_amount
2217: FROM okl_k_lines_full_v okl,
2218: okc_line_styles_v ols,
2219: okc_rule_groups_b rgp,

Line 2550: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2546: p_init_msg_list IN VARCHAR2,
2547: x_return_status OUT NOCOPY VARCHAR2,
2548: x_msg_count OUT NOCOPY NUMBER,
2549: x_msg_data OUT NOCOPY VARCHAR2,
2550: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2551: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line
2552: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2553: ) IS
2554: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

Line 2554: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2550: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2551: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line
2552: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2553: ) IS
2554: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2555: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2556: SELECT kle.id, kle.amount
2557: FROM okc_k_lines_b cleb,
2558: okl_k_lines kle

Line 2583: CURSOR rg_del_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2579: SELECT kle.name
2580: FROM okc_k_lines_v kle
2581: WHERE kle.ID = p_kle_id;
2582:
2583: CURSOR rg_del_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2584: p_rgp_id NUMBER) IS
2585: SELECT 'Y'
2586: FROM okc_rule_groups_v rg
2587: WHERE NOT EXISTS (SELECT 'Y'

Line 2885: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

2881: p_init_msg_list IN VARCHAR2,
2882: x_return_status OUT NOCOPY VARCHAR2,
2883: x_msg_count OUT NOCOPY NUMBER,
2884: x_msg_data OUT NOCOPY VARCHAR2,
2885: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2886: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line
2887: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2888: ) IS
2889: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

Line 2889: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2885: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2886: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line
2887: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2888: ) IS
2889: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2890: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2891: SELECT kle.id, kle.amount
2892: FROM okc_k_lines_b cleb,
2893: okl_k_lines kle

Line 2918: CURSOR rg_del_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

2914: SELECT kle.name
2915: FROM okc_k_lines_v kle
2916: WHERE kle.ID = p_kle_id;
2917:
2918: CURSOR rg_del_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2919: p_rgp_id NUMBER) IS
2920: SELECT 'Y'
2921: FROM okc_rule_groups_v rg
2922: WHERE NOT EXISTS (SELECT 'Y'

Line 3218: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

3214: p_init_msg_list IN VARCHAR2,
3215: x_return_status OUT NOCOPY VARCHAR2,
3216: x_msg_count OUT NOCOPY NUMBER,
3217: x_msg_data OUT NOCOPY VARCHAR2,
3218: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
3219: p_rgp_id IN OKC_RULE_GROUPS_V.ID%TYPE,
3220: p_rule_id IN OKC_RULES_V.ID%TYPE
3221: ) IS
3222: l_api_name VARCHAR2(35) := 'delete_payment';

Line 3226: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

3222: l_api_name VARCHAR2(35) := 'delete_payment';
3223: l_proc_name VARCHAR2(35) := 'DELETE_PAYMENT';
3224: l_api_version CONSTANT NUMBER := 1;
3225:
3226: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
3227: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE,
3228: p_rule_id OKC_RULES_V.ID%TYPE) IS
3229: SELECT id
3230: FROM okc_rules_v

Line 3236: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

3232: AND rgp_id = p_rgp_id
3233: AND object2_id1 = p_rule_id
3234: AND rule_information_category = 'LASLL';
3235:
3236: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
3237: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS
3238: SELECT 'Y'
3239: FROM okc_rules_v
3240: WHERE dnz_chr_id = p_chr_id

Line 3244: CURSOR slh_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

3240: WHERE dnz_chr_id = p_chr_id
3241: AND rgp_id = p_rgp_id;
3242:
3243: -- Fix Bug# 2819175
3244: CURSOR slh_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
3245: p_rule_id OKC_RULES_V.ID%TYPE) IS
3246: SELECT 'Y'
3247: FROM okc_rules_v
3248: WHERE id = p_rule_id