DBA Data[Home] [Help]

APPS.OKL_PAYMENT_APPLICATION_PVT dependencies on OKL_RULE_PUB

Line 19: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;

15: TYPE line_csr_rec IS RECORD (id NUMBER, capital_amount NUMBER);
16: TYPE line_csr_tbl IS TABLE OF line_csr_rec
17: INDEX BY BINARY_INTEGER;
18:
19: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
20: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
21: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
22: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
23:

Line 20: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;

16: TYPE line_csr_tbl IS TABLE OF line_csr_rec
17: INDEX BY BINARY_INTEGER;
18:
19: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
20: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
21: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
22: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
23:
24:

Line 21: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;

17: INDEX BY BINARY_INTEGER;
18:
19: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
20: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
21: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
22: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
23:
24:
25: ------------------------------------------------------------------------------

Line 22: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;

18:
19: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;
20: subtype rulv_rec_type IS OKL_RULE_PUB.rulv_rec_type;
21: subtype rgpv_tbl_type IS OKL_RULE_PUB.rgpv_tbl_type;
22: subtype rulv_tbl_type IS OKL_RULE_PUB.rulv_tbl_type;
23:
24:
25: ------------------------------------------------------------------------------
26: -- PROCEDURE Report_Error

Line 1217: OKL_RULE_PUB.create_rule_group(

1213: l_rgpv_rec.chr_id := NULL;
1214: l_rgpv_rec.cle_id := p_cle_id;
1215: l_rgpv_rec.dnz_chr_id := p_chr_id;
1216:
1217: OKL_RULE_PUB.create_rule_group(
1218: p_api_version => 1.0,
1219: p_init_msg_list => OKC_API.G_FALSE,
1220: x_return_status => x_return_status,
1221: x_msg_count => x_msg_count,

Line 1264: OKL_RULE_PUB.create_rule(

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

Line 1351: OKL_RULE_PUB.create_rule(

1347: p_tot_capital_amount),p_precision);
1348: END IF;
1349: l_sll_rulv_rec.object2_id1 := x_new_slh_rulv_rec.id;
1350:
1351: OKL_RULE_PUB.create_rule(
1352: p_api_version => 1.0,
1353: p_init_msg_list => OKC_API.G_FALSE,
1354: x_return_status => x_return_status,
1355: x_msg_count => x_msg_count,

Line 1405: l_rgpv_rec OKL_RULE_PUB.rgpv_rec_type;

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

Line 1589: x_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1585: INDEX BY BINARY_INTEGER;
1586:
1587: l_rgpv_rec rgpv_rec_type;
1588: l_slh_rulv_rec rulv_rec_type;
1589: x_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1590: l_sll_rulv_rec rulv_rec_type;
1591: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1592: x_sll_rulv_tbl rulv_tbl_type;
1593: x_sll_rulv_new_tbl rulv_tbl_type;

Line 1591: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1587: l_rgpv_rec rgpv_rec_type;
1588: l_slh_rulv_rec rulv_rec_type;
1589: x_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1590: l_sll_rulv_rec rulv_rec_type;
1591: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1592: x_sll_rulv_tbl rulv_tbl_type;
1593: x_sll_rulv_new_tbl rulv_tbl_type;
1594: l_kle_rgp_cache_tbl kle_map_tbl;
1595: l_kle_slh_cache_tbl kle_map_tbl;

Line 1740: OKL_RULE_PUB.create_rule_group(

1736: l_rgpv_rec.chr_id := NULL;
1737: l_rgpv_rec.cle_id := l_line_csr_tbl(k).id;
1738: l_rgpv_rec.dnz_chr_id := p_chr_id;
1739:
1740: OKL_RULE_PUB.create_rule_group(
1741: p_api_version => 1.0,
1742: p_init_msg_list => OKC_API.G_FALSE,
1743: x_return_status => x_return_status,
1744: x_msg_count => x_msg_count,

Line 1765: OKL_RULE_PUB.create_rule(

1761: ---------------------------------------
1762: IF k > l_kle_slh_cache_tbl.COUNT THEN
1763: l_slh_rulv_rec := x_slh_rulv_tbl(i);
1764: l_slh_rulv_rec.rgp_id := l_kle_rgp_cache_tbl(k);
1765: OKL_RULE_PUB.create_rule(
1766: p_api_version => 1.0,
1767: p_init_msg_list => OKC_API.G_FALSE,
1768: x_return_status => x_return_status,
1769: x_msg_count => x_msg_count,

Line 1833: OKL_RULE_PUB.create_rule(

1829:
1830: ---------------------------------------
1831: -- Create all SLLs using the table of records of SLLs formed
1832: ---------------------------------------
1833: OKL_RULE_PUB.create_rule(
1834: p_api_version => 1.0,
1835: p_init_msg_list => OKC_API.G_FALSE,
1836: x_return_status => x_return_status,
1837: x_msg_count => x_msg_count,

Line 1913: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

1909: l_api_version CONSTANT NUMBER := 1;
1910: l_precision FND_CURRENCIES.PRECISION%TYPE;
1911:
1912: l_del_yn VARCHAR2(1) := 'N';
1913: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1914: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1915: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1916:
1917: l_rg_count NUMBER := 0;

Line 1914: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1910: l_precision FND_CURRENCIES.PRECISION%TYPE;
1911:
1912: l_del_yn VARCHAR2(1) := 'N';
1913: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1914: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1915: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1916:
1917: l_rg_count NUMBER := 0;
1918: x_slh_rule_count NUMBER;

Line 1915: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

1911:
1912: l_del_yn VARCHAR2(1) := 'N';
1913: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
1914: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1915: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
1916:
1917: l_rg_count NUMBER := 0;
1918: x_slh_rule_count NUMBER;
1919: l_slh_rule_count NUMBER := 0;

Line 2101: okl_rule_pub.delete_rule(

2097: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2098: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2099: END IF;
2100: END LOOP; -- SLH
2101: okl_rule_pub.delete_rule(
2102: p_api_version => 1.0,
2103: p_init_msg_list => p_init_msg_list,
2104: x_return_status => x_return_status,
2105: x_msg_count => x_msg_count,

Line 2121: okl_rule_pub.delete_rule(

2117: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2118: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2119: END IF;
2120: END LOOP; -- SLL
2121: okl_rule_pub.delete_rule(
2122: p_api_version => 1.0,
2123: p_init_msg_list => p_init_msg_list,
2124: x_return_status => x_return_status,
2125: x_msg_count => x_msg_count,

Line 2147: okl_rule_pub.delete_rule_group(

2143: FETCH rg_del_csr INTO l_del_yn;
2144: CLOSE rg_del_csr;
2145: IF (l_del_yn = 'Y') THEN
2146: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
2147: okl_rule_pub.delete_rule_group(
2148: p_api_version => 1.0,
2149: p_init_msg_list => p_init_msg_list,
2150: x_return_status => x_return_status,
2151: x_msg_count => x_msg_count,

Line 2282: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

2278: l_api_version CONSTANT NUMBER := 1;
2279: l_precision FND_CURRENCIES.PRECISION%TYPE;
2280:
2281: l_del_yn VARCHAR2(1) := 'N';
2282: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2283: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2284: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2285:
2286: l_rg_count NUMBER := 0;

Line 2283: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2279: l_precision FND_CURRENCIES.PRECISION%TYPE;
2280:
2281: l_del_yn VARCHAR2(1) := 'N';
2282: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2283: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2284: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2285:
2286: l_rg_count NUMBER := 0;
2287: l_slh_rule_count NUMBER := 0;

Line 2284: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2280:
2281: l_del_yn VARCHAR2(1) := 'N';
2282: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2283: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2284: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2285:
2286: l_rg_count NUMBER := 0;
2287: l_slh_rule_count NUMBER := 0;
2288: l_sll_rule_count NUMBER := 0;

Line 2438: okl_rule_pub.delete_rule(

2434: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2435: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2436: END IF;
2437: END LOOP; -- SLH
2438: okl_rule_pub.delete_rule(
2439: p_api_version => 1.0,
2440: p_init_msg_list => p_init_msg_list,
2441: x_return_status => x_return_status,
2442: x_msg_count => x_msg_count,

Line 2458: okl_rule_pub.delete_rule(

2454: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2455: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2456: END IF;
2457: END LOOP; -- SLL
2458: okl_rule_pub.delete_rule(
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 2483: okl_rule_pub.delete_rule_group(

2479: FETCH rg_del_csr INTO l_del_yn;
2480: CLOSE rg_del_csr;
2481: IF (l_del_yn = 'Y') THEN
2482: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
2483: okl_rule_pub.delete_rule_group(
2484: p_api_version => 1.0,
2485: p_init_msg_list => p_init_msg_list,
2486: x_return_status => x_return_status,
2487: x_msg_count => x_msg_count,

Line 2601: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

2597: l_api_version CONSTANT NUMBER := 1;
2598: l_precision FND_CURRENCIES.PRECISION%TYPE;
2599:
2600: l_del_yn VARCHAR2(1) := 'N';
2601: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2602: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2603: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2604:
2605: l_rg_count NUMBER := 0;

Line 2602: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2598: l_precision FND_CURRENCIES.PRECISION%TYPE;
2599:
2600: l_del_yn VARCHAR2(1) := 'N';
2601: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2602: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2603: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2604:
2605: l_rg_count NUMBER := 0;
2606: l_slh_rule_count NUMBER := 0;

Line 2603: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2599:
2600: l_del_yn VARCHAR2(1) := 'N';
2601: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2602: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2603: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2604:
2605: l_rg_count NUMBER := 0;
2606: l_slh_rule_count NUMBER := 0;
2607: l_sll_rule_count NUMBER := 0;

Line 2772: okl_rule_pub.delete_rule(

2768: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2769: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
2770: END IF;
2771: END LOOP; -- SLH
2772: okl_rule_pub.delete_rule(
2773: p_api_version => 1.0,
2774: p_init_msg_list => p_init_msg_list,
2775: x_return_status => x_return_status,
2776: x_msg_count => x_msg_count,

Line 2792: okl_rule_pub.delete_rule(

2788: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2789: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
2790: END IF;
2791: END LOOP; -- SLL
2792: okl_rule_pub.delete_rule(
2793: p_api_version => 1.0,
2794: p_init_msg_list => p_init_msg_list,
2795: x_return_status => x_return_status,
2796: x_msg_count => x_msg_count,

Line 2818: okl_rule_pub.delete_rule_group(

2814: FETCH rg_del_csr INTO l_del_yn;
2815: CLOSE rg_del_csr;
2816: IF (l_del_yn = 'Y') THEN
2817: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
2818: okl_rule_pub.delete_rule_group(
2819: p_api_version => 1.0,
2820: p_init_msg_list => p_init_msg_list,
2821: x_return_status => x_return_status,
2822: x_msg_count => x_msg_count,

Line 2936: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;

2932: l_api_version CONSTANT NUMBER := 1;
2933: l_precision FND_CURRENCIES.PRECISION%TYPE;
2934:
2935: l_del_yn VARCHAR2(1) := 'N';
2936: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2937: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2938: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2939:
2940: l_rg_count NUMBER := 0;

Line 2937: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2933: l_precision FND_CURRENCIES.PRECISION%TYPE;
2934:
2935: l_del_yn VARCHAR2(1) := 'N';
2936: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2937: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2938: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2939:
2940: l_rg_count NUMBER := 0;
2941: l_slh_rule_count NUMBER := 0;

Line 2938: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;

2934:
2935: l_del_yn VARCHAR2(1) := 'N';
2936: l_rgpv_tbl OKL_RULE_PUB.rgpv_tbl_type;
2937: l_slh_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2938: l_sll_rulv_tbl OKL_RULE_PUB.rulv_tbl_type;
2939:
2940: l_rg_count NUMBER := 0;
2941: l_slh_rule_count NUMBER := 0;
2942: l_sll_rule_count NUMBER := 0;

Line 3107: okl_rule_pub.delete_rule(

3103: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3104: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH delete: '||x_slh_rulv_tbl_out(i).id);
3105: END IF;
3106: END LOOP; -- SLH
3107: okl_rule_pub.delete_rule(
3108: p_api_version => 1.0,
3109: p_init_msg_list => p_init_msg_list,
3110: x_return_status => x_return_status,
3111: x_msg_count => x_msg_count,

Line 3127: okl_rule_pub.delete_rule(

3123: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3124: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLL delete: '||x_sll_rulv_tbl_out(i).id);
3125: END IF;
3126: END LOOP; -- SLL
3127: okl_rule_pub.delete_rule(
3128: p_api_version => 1.0,
3129: p_init_msg_list => p_init_msg_list,
3130: x_return_status => x_return_status,
3131: x_msg_count => x_msg_count,

Line 3153: okl_rule_pub.delete_rule_group(

3149: FETCH rg_del_csr INTO l_del_yn;
3150: CLOSE rg_del_csr;
3151: IF (l_del_yn = 'Y') THEN
3152: l_rgpv_del_rec.id := l_rgpv_tbl(i).id;
3153: okl_rule_pub.delete_rule_group(
3154: p_api_version => 1.0,
3155: p_init_msg_list => p_init_msg_list,
3156: x_return_status => x_return_status,
3157: x_msg_count => x_msg_count,

Line 3298: okl_rule_pub.delete_rule(

3294: l_rulv_tbl(i).id := sll_rec.id;
3295: END LOOP;
3296:
3297: IF (i > 0) THEN
3298: okl_rule_pub.delete_rule(
3299: p_api_version => 1.0,
3300: p_init_msg_list => OKC_API.G_FALSE,
3301: x_return_status => x_return_status,
3302: x_msg_count => x_msg_count,

Line 3323: okl_rule_pub.delete_rule(

3319:
3320: IF (l_slh = 'Y') THEN
3321:
3322: l_rulv_rec.id := p_rule_id; -- SLH Rule ID
3323: okl_rule_pub.delete_rule(
3324: p_api_version => 1.0,
3325: p_init_msg_list => OKC_API.G_FALSE,
3326: x_return_status => x_return_status,
3327: x_msg_count => x_msg_count,

Line 3348: okl_rule_pub.delete_rule_group(

3344:
3345: IF (l_rule_present = 'N') THEN -- No more rules under this rule group
3346:
3347: l_rgpv_rec.id := p_rgp_id;
3348: okl_rule_pub.delete_rule_group(
3349: p_api_version => p_api_version,
3350: p_init_msg_list => p_init_msg_list,
3351: x_return_status => x_return_status,
3352: x_msg_count => x_msg_count,