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_RULES_V

Line 75: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

71: x_return_status OUT NOCOPY VARCHAR2,
72: x_msg_count OUT NOCOPY NUMBER,
73: x_msg_data OUT NOCOPY VARCHAR2,
74: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
75: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
76: x_rule_present OUT NOCOPY VARCHAR2) IS
77: l_proc_name VARCHAR2(35) := 'CHECK_LINE_RULE';
78:
79: CURSOR lrule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

Line 80: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS

76: x_rule_present OUT NOCOPY VARCHAR2) IS
77: l_proc_name VARCHAR2(35) := 'CHECK_LINE_RULE';
78:
79: CURSOR lrule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
80: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
81: SELECT 'Y'
82: FROM okc_rules_v rule,
83: okc_rule_groups_v rg,
84: okc_k_lines_b cle,

Line 82: FROM okc_rules_v rule,

78:
79: CURSOR lrule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
80: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
81: SELECT 'Y'
82: FROM okc_rules_v rule,
83: okc_rule_groups_v rg,
84: okc_k_lines_b cle,
85: okc_line_styles_b lsb
86: WHERE rule.dnz_chr_id = p_chr_id

Line 160: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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

Line 166: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS

162: l_proc_name VARCHAR2(35) := 'CHECK_RO_SUBLINE_RULE';
163:
164: CURSOR l_ro_sl_rule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
165: p_cle_id OKL_K_LINES.ID%TYPE,
166: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
167:
168: SELECT 'Y'
169: FROM okc_rules_v rule,
170: okc_rule_groups_v rg,

Line 169: FROM okc_rules_v rule,

165: p_cle_id OKL_K_LINES.ID%TYPE,
166: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS
167:
168: SELECT 'Y'
169: FROM okc_rules_v rule,
170: okc_rule_groups_v rg,
171: okc_k_lines_b cleb, -- Top Line
172: okc_k_lines_b cle, -- Sub Line
173: okc_line_styles_b lsb

Line 298: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2,
296: p_chr_id IN NUMBER,
297: p_cle_id IN NUMBER,
298: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
299: p_rgd_code IN VARCHAR2,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,

Line 322: p_strm_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

318: ) RETURN rgpv_tbl_type IS
319: CURSOR okc_rgpv_csr (p_chr_id IN NUMBER,
320: p_cle_id IN NUMBER,
321: p_dnz_chr_id IN NUMBER,
322: p_strm_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
323: p_rgd_code IN VARCHAR2) IS
324: SELECT
325: rg.ID,
326: rg.OBJECT_VERSION_NUMBER,

Line 358: Okc_Rules_V rule

354: rg.LAST_UPDATED_BY,
355: rg.LAST_UPDATE_DATE,
356: rg.LAST_UPDATE_LOGIN
357: FROM Okc_Rule_Groups_V rg,
358: Okc_Rules_V rule
359: WHERE NVL(rg.chr_id,-9999) = p_chr_id
360: --AND NVL(rg.cle_id,-9999) = p_cle_id
361: --AND rg.dnz_chr_id = DECODE(p_chr_id,-9999,rg.dnz_chr_id,p_dnz_chr_id)
362: AND rg.dnz_chr_id = p_chr_id

Line 485: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

481: p_api_version IN NUMBER,
482: p_init_msg_list IN VARCHAR2,
483: p_chr_id IN NUMBER,
484: p_cle_id IN NUMBER,
485: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
486: p_rgd_code IN VARCHAR2,
487: x_return_status OUT NOCOPY VARCHAR2,
488: x_msg_count OUT NOCOPY NUMBER,
489: x_msg_data OUT NOCOPY VARCHAR2,

Line 508: p_strm_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

504: x_rg_count OUT NOCOPY NUMBER
505: ) RETURN rgpv_tbl_type IS
506: CURSOR okc_rgpv_csr (p_chr_id IN NUMBER,
507: p_cle_id IN NUMBER,
508: p_strm_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
509: p_rgd_code IN VARCHAR2) IS
510: SELECT
511: rg.ID,
512: rg.OBJECT_VERSION_NUMBER,

Line 544: Okc_Rules_V rule

540: rg.LAST_UPDATED_BY,
541: rg.LAST_UPDATE_DATE,
542: rg.LAST_UPDATE_LOGIN
543: FROM Okc_Rule_Groups_V rg,
544: Okc_Rules_V rule
545: WHERE rg.dnz_chr_id = p_chr_id
546: AND rg.cle_id = p_cle_id
547: AND rule.object1_id1 = to_char(p_strm_id)
548: AND rg.rgd_code = DECODE(p_rgd_code,NULL,rgd_code,p_rgd_code)

Line 667: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

663:
664: PROCEDURE get_slh_rules(
665: p_rgpv_rec IN rgpv_rec_type,
666: p_rdf_code IN VARCHAR2,
667: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
668: x_return_status OUT NOCOPY VARCHAR2,
669: x_msg_count OUT NOCOPY NUMBER,
670: x_msg_data OUT NOCOPY VARCHAR2,
671: x_rulv_tbl OUT NOCOPY rulv_tbl_type,

Line 679: -- FUNCTION get_rec for: OKC_RULES_V

675: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
676: l_api_name CONSTANT VARCHAR2(30) := 'GET_SLH_RULES';
677: l_api_version CONSTANT NUMBER := 1.0;
678: ---------------------------------------------------------------------------
679: -- FUNCTION get_rec for: OKC_RULES_V
680: ---------------------------------------------------------------------------
681: FUNCTION get_rulv_tab (
682: p_rgpv_rec IN rgpv_rec_type,
683: p_rdf_code IN VARCHAR2,

Line 684: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

680: ---------------------------------------------------------------------------
681: FUNCTION get_rulv_tab (
682: p_rgpv_rec IN rgpv_rec_type,
683: p_rdf_code IN VARCHAR2,
684: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
685: x_Rule_Count OUT NOCOPY NUMBER
686: ) RETURN rulv_tbl_type IS
687: CURSOR okc_rulv_csr (p_rgp_id IN NUMBER,
688: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE,

Line 688: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE,

684: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
685: x_Rule_Count OUT NOCOPY NUMBER
686: ) RETURN rulv_tbl_type IS
687: CURSOR okc_rulv_csr (p_rgp_id IN NUMBER,
688: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE,
689: p_rdf_code IN VARCHAR2) IS
690: SELECT
691: ID,
692: OBJECT_VERSION_NUMBER,

Line 752: FROM Okc_Rules_V

748: ans_set_jtot_object_code,
749: ans_set_jtot_object_id1,
750: ans_set_jtot_object_id2,
751: DISPLAY_SEQUENCE
752: FROM Okc_Rules_V
753: WHERE okc_rules_v.rgp_id = p_rgp_id
754: AND object1_id1 = p_strm_id
755: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
756: l_rulv_rec rulv_rec_type;

Line 753: WHERE okc_rules_v.rgp_id = p_rgp_id

749: ans_set_jtot_object_id1,
750: ans_set_jtot_object_id2,
751: DISPLAY_SEQUENCE
752: FROM Okc_Rules_V
753: WHERE okc_rules_v.rgp_id = p_rgp_id
754: AND object1_id1 = p_strm_id
755: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
756: l_rulv_rec rulv_rec_type;
757: l_rulv_tab rulv_tbl_type;

Line 955: FROM Okc_Rules_V

951: ans_set_jtot_object_code,
952: ans_set_jtot_object_id1,
953: ans_set_jtot_object_id2,
954: DISPLAY_SEQUENCE
955: FROM Okc_Rules_V
956: WHERE okc_rules_v.rgp_id = p_rgp_id
957: AND okc_rules_v.object2_id1 = p_slh_id
958: AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
959:

Line 956: WHERE okc_rules_v.rgp_id = p_rgp_id

952: ans_set_jtot_object_id1,
953: ans_set_jtot_object_id2,
954: DISPLAY_SEQUENCE
955: FROM Okc_Rules_V
956: WHERE okc_rules_v.rgp_id = p_rgp_id
957: AND okc_rules_v.object2_id1 = p_slh_id
958: AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
959:
960: l_rulv_rec rulv_rec_type;

Line 957: AND okc_rules_v.object2_id1 = p_slh_id

953: ans_set_jtot_object_id2,
954: DISPLAY_SEQUENCE
955: FROM Okc_Rules_V
956: WHERE okc_rules_v.rgp_id = p_rgp_id
957: AND okc_rules_v.object2_id1 = p_slh_id
958: AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
959:
960: l_rulv_rec rulv_rec_type;
961: i NUMBER default 0;

Line 1128: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

1124: x_msg_count OUT NOCOPY NUMBER,
1125: x_msg_data OUT NOCOPY VARCHAR2,
1126: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1127: p_cle_id IN NUMBER,
1128: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
1129: p_fin_line_capital_amount IN NUMBER,
1130: p_tot_capital_amount IN NUMBER,
1131: p_precision IN FND_CURRENCIES.PRECISION%TYPE,
1132: p_rgpv_tbl IN rgpv_tbl_type,

Line 1395: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

1391: x_return_status OUT NOCOPY VARCHAR2,
1392: x_msg_count OUT NOCOPY NUMBER,
1393: x_msg_data OUT NOCOPY VARCHAR2,
1394: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1395: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
1396: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type,
1397: x_rg_count OUT NOCOPY NUMBER
1398: ) IS
1399: l_proc_name VARCHAR2(35) := 'CHECK_HEADER_RULE';

Line 1555: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

1551: x_return_status OUT NOCOPY VARCHAR2,
1552: x_msg_count OUT NOCOPY NUMBER,
1553: x_msg_data OUT NOCOPY VARCHAR2,
1554: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1555: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
1556: ) IS
1557: --Changed query for performance --dkagrawa
1558: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1559: SELECT okl.*

Line 1574: FROM okc_rules_v rule

1570: p_rgp_id NUMBER) IS
1571: SELECT 'Y'
1572: FROM okc_rule_groups_v rg
1573: WHERE NOT EXISTS (SELECT 'Y'
1574: FROM okc_rules_v rule
1575: WHERE rule.rgp_id = rg.id
1576: )
1577: AND rg.dnz_chr_id = p_chr_id
1578: AND rg.rgd_code = 'LALEVL'

Line 1853: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

1849: x_return_status OUT NOCOPY VARCHAR2,
1850: x_msg_count OUT NOCOPY NUMBER,
1851: x_msg_data OUT NOCOPY VARCHAR2,
1852: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
1853: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
1854: ) IS
1855: CURSOR line_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1856: SELECT okl.id, okl.capital_amount
1857: FROM okl_k_lines_full_v okl,

Line 1888: FROM okc_rules_v rule

1884: p_rgp_id NUMBER) IS
1885: SELECT 'Y'
1886: FROM okc_rule_groups_v rg
1887: WHERE NOT EXISTS (SELECT 'Y'
1888: FROM okc_rules_v rule
1889: WHERE rule.rgp_id = rg.id
1890: )
1891: AND rg.dnz_chr_id = p_chr_id
1892: AND rg.rgd_code = 'LALEVL'

Line 2192: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

2188: x_msg_count OUT NOCOPY NUMBER,
2189: x_msg_data OUT NOCOPY VARCHAR2,
2190: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2191: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Rollover Fee Top Line
2192: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2193: ) IS
2194: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2195: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2196: SELECT kle.id, kle.amount

Line 2228: FROM okc_rules_v rule

2224: p_rgp_id NUMBER) IS
2225: SELECT 'Y'
2226: FROM okc_rule_groups_v rg
2227: WHERE NOT EXISTS (SELECT 'Y'
2228: FROM okc_rules_v rule
2229: WHERE rule.rgp_id = rg.id
2230: )
2231: AND rg.dnz_chr_id = p_chr_id
2232: AND rg.rgd_code = 'LALEVL'

Line 2527: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

2523: x_msg_count OUT NOCOPY NUMBER,
2524: x_msg_data OUT NOCOPY VARCHAR2,
2525: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2526: p_kle_id IN OKC_K_LINES_B.ID%TYPE,-- Fee Top Line
2527: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE
2528: ) IS
2529: CURSOR ro_fee_subline_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2530: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2531: SELECT kle.id, kle.amount

Line 2563: FROM okc_rules_v rule

2559: p_rgp_id NUMBER) IS
2560: SELECT 'Y'
2561: FROM okc_rule_groups_v rg
2562: WHERE NOT EXISTS (SELECT 'Y'
2563: FROM okc_rules_v rule
2564: WHERE rule.rgp_id = rg.id
2565: )
2566: AND rg.dnz_chr_id = p_chr_id
2567: AND rg.rgd_code = 'LALEVL'

Line 2860: p_rule_id IN OKC_RULES_V.ID%TYPE

2856: x_msg_count OUT NOCOPY NUMBER,
2857: x_msg_data OUT NOCOPY VARCHAR2,
2858: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,
2859: p_rgp_id IN OKC_RULE_GROUPS_V.ID%TYPE,
2860: p_rule_id IN OKC_RULES_V.ID%TYPE
2861: ) IS
2862: l_api_name VARCHAR2(35) := 'delete_payment';
2863: l_proc_name VARCHAR2(35) := 'DELETE_PAYMENT';
2864: l_api_version CONSTANT NUMBER := 1;

Line 2868: p_rule_id OKC_RULES_V.ID%TYPE) IS

2864: l_api_version CONSTANT NUMBER := 1;
2865:
2866: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2867: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE,
2868: p_rule_id OKC_RULES_V.ID%TYPE) IS
2869: SELECT id
2870: FROM okc_rules_v
2871: WHERE dnz_chr_id = p_chr_id
2872: AND rgp_id = p_rgp_id

Line 2870: FROM okc_rules_v

2866: CURSOR sll_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2867: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE,
2868: p_rule_id OKC_RULES_V.ID%TYPE) IS
2869: SELECT id
2870: FROM okc_rules_v
2871: WHERE dnz_chr_id = p_chr_id
2872: AND rgp_id = p_rgp_id
2873: AND object2_id1 = p_rule_id
2874: AND rule_information_category = 'LASLL';

Line 2879: FROM okc_rules_v

2875:
2876: CURSOR rgp_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2877: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS
2878: SELECT 'Y'
2879: FROM okc_rules_v
2880: WHERE dnz_chr_id = p_chr_id
2881: AND rgp_id = p_rgp_id;
2882:
2883: -- Fix Bug# 2819175

Line 2885: p_rule_id OKC_RULES_V.ID%TYPE) IS

2881: AND rgp_id = p_rgp_id;
2882:
2883: -- Fix Bug# 2819175
2884: CURSOR slh_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2885: p_rule_id OKC_RULES_V.ID%TYPE) IS
2886: SELECT 'Y'
2887: FROM okc_rules_v
2888: WHERE id = p_rule_id
2889: AND dnz_chr_id = p_chr_id;

Line 2887: FROM okc_rules_v

2883: -- Fix Bug# 2819175
2884: CURSOR slh_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,
2885: p_rule_id OKC_RULES_V.ID%TYPE) IS
2886: SELECT 'Y'
2887: FROM okc_rules_v
2888: WHERE id = p_rule_id
2889: AND dnz_chr_id = p_chr_id;
2890:
2891: l_rulv_tbl rulv_tbl_type;