DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKL_RULE_PUB

Line 15: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;

11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13:
14:
15: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
16: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
17: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
18: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
19:

Line 16: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;

12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13:
14:
15: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
16: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
17: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
18: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
19:
20:

Line 17: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;

13:
14:
15: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
16: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
17: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
18: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
19:
20:
21: ------------------------------------------------------------------------------

Line 18: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;

14:
15: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
16: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
17: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
18: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
19:
20:
21: ------------------------------------------------------------------------------
22: -- PROCEDURE Report_Error

Line 1213: OKL_RULE_PUB.create_rule_group(

1209: l_rgpv_rec.chr_id := NULL;
1210: l_rgpv_rec.cle_id := p_cle_id;
1211: l_rgpv_rec.dnz_chr_id := p_chr_id;
1212:
1213: OKL_RULE_PUB.create_rule_group(
1214: p_api_version => 1.0,
1215: p_init_msg_list => OKC_API.G_FALSE,
1216: x_return_status => x_return_status,
1217: x_msg_count => x_msg_count,

Line 1260: OKL_RULE_PUB.create_rule(

1256: FOR i IN 1..x_slh_rule_count
1257: LOOP
1258: l_slh_rulv_rec := x_slh_rulv_tbl(i);
1259: l_slh_rulv_rec.rgp_id := x_new_rgpv_rec.id;
1260: OKL_RULE_PUB.create_rule(
1261: p_api_version => 1.0,
1262: p_init_msg_list => OKC_API.G_FALSE,
1263: x_return_status => x_return_status,
1264: x_msg_count => x_msg_count,

Line 1347: OKL_RULE_PUB.create_rule(

1343: p_tot_capital_amount),p_precision);
1344: END IF;
1345: l_sll_rulv_rec.object2_id1 := x_new_slh_rulv_rec.id;
1346:
1347: OKL_RULE_PUB.create_rule(
1348: p_api_version => 1.0,
1349: p_init_msg_list => OKC_API.G_FALSE,
1350: x_return_status => x_return_status,
1351: x_msg_count => x_msg_count,

Line 1401: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

1397: x_rg_count OUT NOCOPY NUMBER
1398: ) IS
1399: l_proc_name VARCHAR2(35) := 'CHECK_HEADER_RULE';
1400: check_header_failed EXCEPTION;
1401: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;
1402: BEGIN
1403: IF (G_DEBUG_ENABLED = 'Y') THEN
1404: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
1405: END IF;

Line 1587: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

1583: l_api_version CONSTANT NUMBER := 1;
1584: l_precision FND_CURRENCIES.PRECISION%TYPE;
1585:
1586: l_del_yn VARCHAR2(1) := 'N';
1587: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1588: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1589: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1590:
1591: l_rg_count NUMBER := 0;

Line 1588: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1584: l_precision FND_CURRENCIES.PRECISION%TYPE;
1585:
1586: l_del_yn VARCHAR2(1) := 'N';
1587: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1588: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1589: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1590:
1591: l_rg_count NUMBER := 0;
1592: l_slh_rule_count NUMBER := 0;

Line 1589: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1585:
1586: l_del_yn VARCHAR2(1) := 'N';
1587: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1588: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1589: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1590:
1591: l_rg_count NUMBER := 0;
1592: l_slh_rule_count NUMBER := 0;
1593: l_sll_rule_count NUMBER := 0;

Line 1741: okl_rule_pub.delete_rule(

1737: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1738: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
1739: END IF;
1740: END LOOP; -- SLH
1741: okl_rule_pub.delete_rule(
1742: p_api_version => 1.0,
1743: p_init_msg_list => p_init_msg_list,
1744: x_return_status => x_return_status,
1745: x_msg_count => x_msg_count,

Line 1761: okl_rule_pub.delete_rule(

1757: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1758: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
1759: END IF;
1760: END LOOP; -- SLL
1761: okl_rule_pub.delete_rule(
1762: p_api_version => 1.0,
1763: p_init_msg_list => p_init_msg_list,
1764: x_return_status => x_return_status,
1765: x_msg_count => x_msg_count,

Line 1787: okl_rule_pub.delete_rule_group(

1783: FETCH rg_del_csr INTO l_del_yn;
1784: CLOSE rg_del_csr;
1785: IF (l_del_yn = 'Y') THEN
1786: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
1787: okl_rule_pub.delete_rule_group(
1788: p_api_version => 1.0,
1789: p_init_msg_list => p_init_msg_list,
1790: x_return_status => x_return_status,
1791: x_msg_count => x_msg_count,

Line 1922: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

1918: l_api_version CONSTANT NUMBER := 1;
1919: l_precision FND_CURRENCIES.PRECISION%TYPE;
1920:
1921: l_del_yn VARCHAR2(1) := 'N';
1922: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1923: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1924: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1925:
1926: l_rg_count NUMBER := 0;

Line 1923: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1919: l_precision FND_CURRENCIES.PRECISION%TYPE;
1920:
1921: l_del_yn VARCHAR2(1) := 'N';
1922: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1923: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1924: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1925:
1926: l_rg_count NUMBER := 0;
1927: l_slh_rule_count NUMBER := 0;

Line 1924: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1920:
1921: l_del_yn VARCHAR2(1) := 'N';
1922: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1923: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1924: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1925:
1926: l_rg_count NUMBER := 0;
1927: l_slh_rule_count NUMBER := 0;
1928: l_sll_rule_count NUMBER := 0;

Line 2078: okl_rule_pub.delete_rule(

2074: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2075: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2076: END IF;
2077: END LOOP; -- SLH
2078: okl_rule_pub.delete_rule(
2079: p_api_version => 1.0,
2080: p_init_msg_list => p_init_msg_list,
2081: x_return_status => x_return_status,
2082: x_msg_count => x_msg_count,

Line 2098: okl_rule_pub.delete_rule(

2094: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2095: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2096: END IF;
2097: END LOOP; -- SLL
2098: okl_rule_pub.delete_rule(
2099: p_api_version => 1.0,
2100: p_init_msg_list => p_init_msg_list,
2101: x_return_status => x_return_status,
2102: x_msg_count => x_msg_count,

Line 2123: okl_rule_pub.delete_rule_group(

2119: FETCH rg_del_csr INTO l_del_yn;
2120: CLOSE rg_del_csr;
2121: IF (l_del_yn = 'Y') THEN
2122: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
2123: okl_rule_pub.delete_rule_group(
2124: p_api_version => 1.0,
2125: p_init_msg_list => p_init_msg_list,
2126: x_return_status => x_return_status,
2127: x_msg_count => x_msg_count,

Line 2241: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

2237: l_api_version CONSTANT NUMBER := 1;
2238: l_precision FND_CURRENCIES.PRECISION%TYPE;
2239:
2240: l_del_yn VARCHAR2(1) := 'N';
2241: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2242: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2243: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2244:
2245: l_rg_count NUMBER := 0;

Line 2242: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2238: l_precision FND_CURRENCIES.PRECISION%TYPE;
2239:
2240: l_del_yn VARCHAR2(1) := 'N';
2241: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2242: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2243: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2244:
2245: l_rg_count NUMBER := 0;
2246: l_slh_rule_count NUMBER := 0;

Line 2243: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2239:
2240: l_del_yn VARCHAR2(1) := 'N';
2241: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2242: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2243: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2244:
2245: l_rg_count NUMBER := 0;
2246: l_slh_rule_count NUMBER := 0;
2247: l_sll_rule_count NUMBER := 0;

Line 2412: okl_rule_pub.delete_rule(

2408: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2409: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2410: END IF;
2411: END LOOP; -- SLH
2412: okl_rule_pub.delete_rule(
2413: p_api_version => 1.0,
2414: p_init_msg_list => p_init_msg_list,
2415: x_return_status => x_return_status,
2416: x_msg_count => x_msg_count,

Line 2432: okl_rule_pub.delete_rule(

2428: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2429: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2430: END IF;
2431: END LOOP; -- SLL
2432: okl_rule_pub.delete_rule(
2433: p_api_version => 1.0,
2434: p_init_msg_list => p_init_msg_list,
2435: x_return_status => x_return_status,
2436: x_msg_count => x_msg_count,

Line 2458: okl_rule_pub.delete_rule_group(

2454: FETCH rg_del_csr INTO l_del_yn;
2455: CLOSE rg_del_csr;
2456: IF (l_del_yn = 'Y') THEN
2457: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
2458: okl_rule_pub.delete_rule_group(
2459: p_api_version => 1.0,
2460: p_init_msg_list => p_init_msg_list,
2461: x_return_status => x_return_status,
2462: x_msg_count => x_msg_count,

Line 2576: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

2572: l_api_version CONSTANT NUMBER := 1;
2573: l_precision FND_CURRENCIES.PRECISION%TYPE;
2574:
2575: l_del_yn VARCHAR2(1) := 'N';
2576: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2577: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2578: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2579:
2580: l_rg_count NUMBER := 0;

Line 2577: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2573: l_precision FND_CURRENCIES.PRECISION%TYPE;
2574:
2575: l_del_yn VARCHAR2(1) := 'N';
2576: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2577: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2578: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2579:
2580: l_rg_count NUMBER := 0;
2581: l_slh_rule_count NUMBER := 0;

Line 2578: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2574:
2575: l_del_yn VARCHAR2(1) := 'N';
2576: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2577: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2578: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2579:
2580: l_rg_count NUMBER := 0;
2581: l_slh_rule_count NUMBER := 0;
2582: l_sll_rule_count NUMBER := 0;

Line 2747: okl_rule_pub.delete_rule(

2743: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2744: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2745: END IF;
2746: END LOOP; -- SLH
2747: okl_rule_pub.delete_rule(
2748: p_api_version => 1.0,
2749: p_init_msg_list => p_init_msg_list,
2750: x_return_status => x_return_status,
2751: x_msg_count => x_msg_count,

Line 2767: okl_rule_pub.delete_rule(

2763: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2764: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2765: END IF;
2766: END LOOP; -- SLL
2767: okl_rule_pub.delete_rule(
2768: p_api_version => 1.0,
2769: p_init_msg_list => p_init_msg_list,
2770: x_return_status => x_return_status,
2771: x_msg_count => x_msg_count,

Line 2793: okl_rule_pub.delete_rule_group(

2789: FETCH rg_del_csr INTO l_del_yn;
2790: CLOSE rg_del_csr;
2791: IF (l_del_yn = 'Y') THEN
2792: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
2793: okl_rule_pub.delete_rule_group(
2794: p_api_version => 1.0,
2795: p_init_msg_list => p_init_msg_list,
2796: x_return_status => x_return_status,
2797: x_msg_count => x_msg_count,

Line 2938: okl_rule_pub.delete_rule(

2934: l_rulv_tbl(i).id := sll_rec.id;
2935: END LOOP;
2936:
2937: IF (i > 0) THEN
2938: okl_rule_pub.delete_rule(
2939: p_api_version => 1.0,
2940: p_init_msg_list => OKC_API.G_FALSE,
2941: x_return_status => x_return_status,
2942: x_msg_count => x_msg_count,

Line 2963: okl_rule_pub.delete_rule(

2959:
2960: IF (l_slh = 'Y') THEN
2961:
2962: l_rulv_rec.id := p_rule_id; -- SLH Rule ID
2963: okl_rule_pub.delete_rule(
2964: p_api_version => 1.0,
2965: p_init_msg_list => OKC_API.G_FALSE,
2966: x_return_status => x_return_status,
2967: x_msg_count => x_msg_count,

Line 2988: okl_rule_pub.delete_rule_group(

2984:
2985: IF (l_rule_present = 'N') THEN -- No more rules under this rule group
2986:
2987: l_rgpv_rec.id := p_rgp_id;
2988: okl_rule_pub.delete_rule_group(
2989: p_api_version => p_api_version,
2990: p_init_msg_list => p_init_msg_list,
2991: x_return_status => x_return_status,
2992: x_msg_count => x_msg_count,