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 79: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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:
83: CURSOR lrule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

Line 84: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) IS

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,
88: okc_k_lines_b cle,

Line 86: FROM okc_rules_v 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,
88: okc_k_lines_b cle,
89: okc_line_styles_b lsb
90: WHERE rule.dnz_chr_id = p_chr_id

Line 164: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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';
167:
168: CURSOR l_ro_sl_rule_csr (p_chr_id OKC_K_HEADERS_V.ID%TYPE,

Line 170: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE) 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'
173: FROM okc_rules_v rule,
174: okc_rule_groups_v rg,

Line 173: FROM okc_rules_v rule,

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

Line 302: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2,
300: p_chr_id IN NUMBER,
301: p_cle_id IN NUMBER,
302: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
303: p_rgd_code IN VARCHAR2,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,

Line 326: p_strm_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

322: ) RETURN rgpv_tbl_type IS
323: CURSOR okc_rgpv_csr (p_chr_id IN NUMBER,
324: p_cle_id IN NUMBER,
325: p_dnz_chr_id IN NUMBER,
326: p_strm_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
327: p_rgd_code IN VARCHAR2) IS
328: SELECT
329: rg.ID,
330: rg.OBJECT_VERSION_NUMBER,

Line 362: Okc_Rules_V rule

358: rg.LAST_UPDATED_BY,
359: rg.LAST_UPDATE_DATE,
360: rg.LAST_UPDATE_LOGIN
361: FROM Okc_Rule_Groups_V rg,
362: Okc_Rules_V rule
363: WHERE NVL(rg.chr_id,-9999) = p_chr_id
364: --AND NVL(rg.cle_id,-9999) = p_cle_id
365: --AND rg.dnz_chr_id = DECODE(p_chr_id,-9999,rg.dnz_chr_id,p_dnz_chr_id)
366: AND rg.dnz_chr_id = p_chr_id

Line 489: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

485: p_api_version IN NUMBER,
486: p_init_msg_list IN VARCHAR2,
487: p_chr_id IN NUMBER,
488: p_cle_id IN NUMBER,
489: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
490: p_rgd_code IN VARCHAR2,
491: x_return_status OUT NOCOPY VARCHAR2,
492: x_msg_count OUT NOCOPY NUMBER,
493: x_msg_data OUT NOCOPY VARCHAR2,

Line 512: p_strm_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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

Line 548: Okc_Rules_V rule

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

Line 671: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

667:
668: PROCEDURE get_slh_rules(
669: p_rgpv_rec IN rgpv_rec_type,
670: p_rdf_code IN VARCHAR2,
671: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,
672: x_return_status OUT NOCOPY VARCHAR2,
673: x_msg_count OUT NOCOPY NUMBER,
674: x_msg_data OUT NOCOPY VARCHAR2,
675: x_rulv_tbl OUT NOCOPY rulv_tbl_type,

Line 683: -- FUNCTION get_rec for: OKC_RULES_V

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

Line 688: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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

Line 692: p_strm_id OKC_RULES_V.OBJECT1_ID1%TYPE,

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

Line 756: FROM Okc_Rules_V

752: ans_set_jtot_object_code,
753: ans_set_jtot_object_id1,
754: ans_set_jtot_object_id2,
755: DISPLAY_SEQUENCE
756: FROM Okc_Rules_V
757: WHERE okc_rules_v.rgp_id = p_rgp_id
758: AND object1_id1 = p_strm_id
759: AND RULE_INFORMATION_CATEGORY = DECODE(p_rdf_code,NULL,RULE_INFORMATION_CATEGORY,p_rdf_code);
760: l_rulv_rec rulv_rec_type;

Line 757: WHERE okc_rules_v.rgp_id = p_rgp_id

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

Line 959: FROM Okc_Rules_V

955: ans_set_jtot_object_code,
956: ans_set_jtot_object_id1,
957: ans_set_jtot_object_id2,
958: DISPLAY_SEQUENCE
959: FROM Okc_Rules_V
960: WHERE okc_rules_v.rgp_id = p_rgp_id
961: AND okc_rules_v.object2_id1 = p_slh_id
962: AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
963:

Line 960: WHERE okc_rules_v.rgp_id = p_rgp_id

956: ans_set_jtot_object_id1,
957: ans_set_jtot_object_id2,
958: DISPLAY_SEQUENCE
959: FROM Okc_Rules_V
960: WHERE okc_rules_v.rgp_id = p_rgp_id
961: AND okc_rules_v.object2_id1 = p_slh_id
962: AND RULE_INFORMATION_CATEGORY = decode(p_rdf_code,null,RULE_INFORMATION_CATEGORY,p_rdf_code);
963:
964: l_rulv_rec rulv_rec_type;

Line 961: AND okc_rules_v.object2_id1 = p_slh_id

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

Line 1132: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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,
1135: p_precision IN FND_CURRENCIES.PRECISION%TYPE,
1136: p_rgpv_tbl IN rgpv_tbl_type,

Line 1399: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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
1403: l_proc_name VARCHAR2(35) := 'CHECK_HEADER_RULE';

Line 1554: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE,

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,
1557: p_rgpv_tbl IN rgpv_tbl_type,
1558: x_slh_rulv_tbl_out OUT NOCOPY rulv_tbl_type,

Line 1880: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

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
1884: SELECT okl.id, okl.capital_amount -- bug# 7661717

Line 1900: FROM okc_rules_v rule

1896: p_rgp_id NUMBER) IS
1897: SELECT 'Y'
1898: FROM okc_rule_groups_v rg
1899: WHERE NOT EXISTS (SELECT 'Y'
1900: FROM okc_rules_v rule
1901: WHERE rule.rgp_id = rg.id
1902: )
1903: AND rg.dnz_chr_id = p_chr_id
1904: AND rg.rgd_code = 'LALEVL'

Line 2213: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

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
2217: FROM okl_k_lines_full_v okl,

Line 2248: FROM okc_rules_v rule

2244: p_rgp_id NUMBER) IS
2245: SELECT 'Y'
2246: FROM okc_rule_groups_v rg
2247: WHERE NOT EXISTS (SELECT 'Y'
2248: FROM okc_rules_v rule
2249: WHERE rule.rgp_id = rg.id
2250: )
2251: AND rg.dnz_chr_id = p_chr_id
2252: AND rg.rgd_code = 'LALEVL'

Line 2552: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

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,
2555: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2556: SELECT kle.id, kle.amount

Line 2588: FROM okc_rules_v rule

2584: p_rgp_id NUMBER) IS
2585: SELECT 'Y'
2586: FROM okc_rule_groups_v rg
2587: WHERE NOT EXISTS (SELECT 'Y'
2588: FROM okc_rules_v rule
2589: WHERE rule.rgp_id = rg.id
2590: )
2591: AND rg.dnz_chr_id = p_chr_id
2592: AND rg.rgd_code = 'LALEVL'

Line 2887: p_stream_id IN OKC_RULES_V.OBJECT1_ID1%TYPE

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,
2890: p_kle_id OKC_K_LINES_B.ID%TYPE) IS
2891: SELECT kle.id, kle.amount

Line 2923: FROM okc_rules_v rule

2919: p_rgp_id NUMBER) IS
2920: SELECT 'Y'
2921: FROM okc_rule_groups_v rg
2922: WHERE NOT EXISTS (SELECT 'Y'
2923: FROM okc_rules_v rule
2924: WHERE rule.rgp_id = rg.id
2925: )
2926: AND rg.dnz_chr_id = p_chr_id
2927: AND rg.rgd_code = 'LALEVL'

Line 3220: p_rule_id IN OKC_RULES_V.ID%TYPE

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';
3223: l_proc_name VARCHAR2(35) := 'DELETE_PAYMENT';
3224: l_api_version CONSTANT NUMBER := 1;

Line 3228: p_rule_id OKC_RULES_V.ID%TYPE) IS

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
3231: WHERE dnz_chr_id = p_chr_id
3232: AND rgp_id = p_rgp_id

Line 3230: FROM okc_rules_v

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
3231: WHERE dnz_chr_id = p_chr_id
3232: AND rgp_id = p_rgp_id
3233: AND object2_id1 = p_rule_id
3234: AND rule_information_category = 'LASLL';

Line 3239: FROM okc_rules_v

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
3241: AND rgp_id = p_rgp_id;
3242:
3243: -- Fix Bug# 2819175

Line 3245: p_rule_id OKC_RULES_V.ID%TYPE) IS

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
3249: AND dnz_chr_id = p_chr_id;

Line 3247: FROM okc_rules_v

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
3249: AND dnz_chr_id = p_chr_id;
3250:
3251: l_rulv_tbl rulv_tbl_type;