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_RULE_GROUPS_V

Line 87: okc_rule_groups_v rg,

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
91: AND rule_information_category IN ('LASLH','LASLL')

Line 174: okc_rule_groups_v rg,

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
178: WHERE rule.dnz_chr_id = p_chr_id

Line 314: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

310: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
311: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULE_GROUP';
312: l_api_version CONSTANT NUMBER := 1.0;
313: ---------------------------------------------------------------------------
314: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
315: ---------------------------------------------------------------------------
316: FUNCTION get_rgpv_tab (
317: p_chr_id IN NUMBER,
318: p_cle_id IN NUMBER,

Line 361: FROM Okc_Rule_Groups_V rg,

357: rg.CREATION_DATE,
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)

Line 501: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

497: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
498: l_api_name CONSTANT VARCHAR2(30) := 'GET_RO_FEE_TOPLN_RG';
499: l_api_version CONSTANT NUMBER := 1.0;
500: ---------------------------------------------------------------------------
501: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V
502: ---------------------------------------------------------------------------
503: FUNCTION get_rgpv_tab (
504: p_chr_id IN NUMBER,
505: p_cle_id IN NUMBER,

Line 547: FROM Okc_Rule_Groups_V rg,

543: rg.CREATION_DATE,
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)

Line 1148: FROM okc_rule_groups_v

1144:
1145: CURSOR rg_csr (p_chr_id NUMBER,
1146: p_cle_id NUMBER) IS
1147: SELECT ID
1148: FROM okc_rule_groups_v
1149: WHERE dnz_chr_id = p_chr_id
1150: AND cle_id = p_cle_id
1151: AND rgd_code = 'LALEVL';
1152:

Line 1571: FROM okc_rule_groups_v

1567:
1568: CURSOR rg_csr (p_chr_id NUMBER,
1569: p_cle_id NUMBER) IS
1570: SELECT ID
1571: FROM okc_rule_groups_v
1572: WHERE dnz_chr_id = p_chr_id
1573: AND cle_id = p_cle_id
1574: AND rgd_code = 'LALEVL';
1575:

Line 1898: FROM okc_rule_groups_v rg

1894:
1895: CURSOR rg_del_csr (p_chr_id NUMBER,
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: )

Line 2246: FROM okc_rule_groups_v rg

2242:
2243: CURSOR rg_del_csr (p_chr_id NUMBER,
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: )

Line 2586: FROM okc_rule_groups_v rg

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'
2588: FROM okc_rules_v rule
2589: WHERE rule.rgp_id = rg.id
2590: )

Line 2921: FROM okc_rule_groups_v rg

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'
2923: FROM okc_rules_v rule
2924: WHERE rule.rgp_id = rg.id
2925: )

Line 3219: p_rgp_id IN OKC_RULE_GROUPS_V.ID%TYPE,

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

Line 3227: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE,

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
3231: WHERE dnz_chr_id = p_chr_id

Line 3237: p_rgp_id OKC_RULE_GROUPS_V.ID%TYPE) IS

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
3241: AND rgp_id = p_rgp_id;