DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULE_PUB

Line 585: x_rulv_rec OUT NOCOPY okc_rule_pub.rulv_rec_type) IS

581: -- End of comments
582: PROCEDURE populate_rule_record( p_chr_id IN NUMBER,
583: p_rgp_id IN NUMBER,
584: p_rule_name IN VARCHAR2,
585: x_rulv_rec OUT NOCOPY okc_rule_pub.rulv_rec_type) IS
586: l_rulv_rec okc_rule_pub.rulv_rec_type;
587: BEGIN
588: l_rulv_rec.dnz_chr_id := p_chr_id;
589: l_rulv_rec.rgp_id := p_rgp_id;

Line 586: l_rulv_rec okc_rule_pub.rulv_rec_type;

582: PROCEDURE populate_rule_record( p_chr_id IN NUMBER,
583: p_rgp_id IN NUMBER,
584: p_rule_name IN VARCHAR2,
585: x_rulv_rec OUT NOCOPY okc_rule_pub.rulv_rec_type) IS
586: l_rulv_rec okc_rule_pub.rulv_rec_type;
587: BEGIN
588: l_rulv_rec.dnz_chr_id := p_chr_id;
589: l_rulv_rec.rgp_id := p_rgp_id;
590: l_rulv_rec.std_template_yn := 'N';

Line 627: l_rgpv_rec okc_rule_pub.rgpv_rec_type;

623: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
624: l_debug_enabled VARCHAR2(10);
625: lx_return_status VARCHAR2(1);
626:
627: l_rgpv_rec okc_rule_pub.rgpv_rec_type;
628: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
629: BEGIN
630: x_return_status := OKL_API.G_RET_STS_SUCCESS;
631: -- check for logging on PROCEDURE level

Line 628: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;

624: l_debug_enabled VARCHAR2(10);
625: lx_return_status VARCHAR2(1);
626:
627: l_rgpv_rec okc_rule_pub.rgpv_rec_type;
628: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
629: BEGIN
630: x_return_status := OKL_API.G_RET_STS_SUCCESS;
631: -- check for logging on PROCEDURE level
632: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 653: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule_group'

649: l_rgpv_rec.cle_id := p_cle_id;
650: l_rgpv_rec.dnz_chr_id := p_chr_id;
651: l_rgpv_rec.rgd_code := p_rgd_code;
652: IF(l_debug_enabled='Y') THEN
653: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule_group'
654: ,'begin debug call create_rule_group');
655: END IF;
656: okc_rule_pub.create_rule_group(p_api_version => p_api_version,
657: p_init_msg_list => p_init_msg_list,

Line 656: okc_rule_pub.create_rule_group(p_api_version => p_api_version,

652: IF(l_debug_enabled='Y') THEN
653: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule_group'
654: ,'begin debug call create_rule_group');
655: END IF;
656: okc_rule_pub.create_rule_group(p_api_version => p_api_version,
657: p_init_msg_list => p_init_msg_list,
658: x_return_status => x_return_status,
659: x_msg_count => x_msg_count,
660: x_msg_data => x_msg_data,

Line 664: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule_group'

660: x_msg_data => x_msg_data,
661: p_rgpv_rec => l_rgpv_rec,
662: x_rgpv_rec => lx_rgpv_rec);
663: IF(l_debug_enabled='Y') THEN
664: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule_group'
665: ,'end debug call create_rule_group');
666: END IF;
667: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1183: l_laslh_rec okc_rule_pub.rulv_rec_type;

1179: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1180: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_PMT_PLN';
1181: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1182: l_payment_levels_tbl payment_levels_tbl_type;
1183: l_laslh_rec okc_rule_pub.rulv_rec_type;
1184: l_lasll_rec okc_rule_pub.rulv_rec_type;
1185: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1186: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1187: line_number NUMBER := 0;

Line 1184: l_lasll_rec okc_rule_pub.rulv_rec_type;

1180: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_PMT_PLN';
1181: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1182: l_payment_levels_tbl payment_levels_tbl_type;
1183: l_laslh_rec okc_rule_pub.rulv_rec_type;
1184: l_lasll_rec okc_rule_pub.rulv_rec_type;
1185: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1186: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1187: line_number NUMBER := 0;
1188: l_laslh_id NUMBER;

Line 1185: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;

1181: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1182: l_payment_levels_tbl payment_levels_tbl_type;
1183: l_laslh_rec okc_rule_pub.rulv_rec_type;
1184: l_lasll_rec okc_rule_pub.rulv_rec_type;
1185: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1186: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1187: line_number NUMBER := 0;
1188: l_laslh_id NUMBER;
1189: l_rgp_id NUMBER := NULL;

Line 1186: lx_rulv_rec okc_rule_pub.rulv_rec_type;

1182: l_payment_levels_tbl payment_levels_tbl_type;
1183: l_laslh_rec okc_rule_pub.rulv_rec_type;
1184: l_lasll_rec okc_rule_pub.rulv_rec_type;
1185: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1186: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1187: line_number NUMBER := 0;
1188: l_laslh_id NUMBER;
1189: l_rgp_id NUMBER := NULL;
1190: l_start_date DATE;

Line 1290: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'

1286: l_laslh_rec.jtot_object1_code := 'OKL_STRMTYP';
1287: l_laslh_rec.rule_information2 := p_rate_type;
1288:
1289: IF(l_debug_enabled='Y') THEN
1290: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1291: ,'begin debug call create_rule');
1292: END IF;
1293: -- create rule for LASLH (payment header)
1294: okc_rule_pub.create_rule(p_api_version => p_api_version,

Line 1294: okc_rule_pub.create_rule(p_api_version => p_api_version,

1290: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1291: ,'begin debug call create_rule');
1292: END IF;
1293: -- create rule for LASLH (payment header)
1294: okc_rule_pub.create_rule(p_api_version => p_api_version,
1295: p_init_msg_list => p_init_msg_list,
1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,
1298: x_return_status => l_return_status,

Line 1302: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'

1298: x_return_status => l_return_status,
1299: p_rulv_rec => l_laslh_rec,
1300: x_rulv_rec => lx_rulv_rec);
1301: IF(l_debug_enabled='Y') THEN
1302: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1303: ,'end debug call create_rule');
1304: END IF;
1305: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1306: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1385: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'

1381: l_lasll_rec.rule_information7 := l_payment_levels_tbl(line_number).stub_days;
1382: l_lasll_rec.rule_information8 := l_payment_levels_tbl(line_number).stub_amount;
1383:
1384: IF(l_debug_enabled='Y') THEN
1385: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1386: ,'begin debug call create_rule');
1387: END IF;
1388: okc_rule_pub.create_rule(p_api_version => p_api_version,
1389: p_init_msg_list => p_init_msg_list,

Line 1388: okc_rule_pub.create_rule(p_api_version => p_api_version,

1384: IF(l_debug_enabled='Y') THEN
1385: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1386: ,'begin debug call create_rule');
1387: END IF;
1388: okc_rule_pub.create_rule(p_api_version => p_api_version,
1389: p_init_msg_list => p_init_msg_list,
1390: x_return_status => x_return_status,
1391: x_msg_count => x_msg_count,
1392: x_msg_data => x_msg_data,

Line 1396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'

1392: x_msg_data => x_msg_data,
1393: p_rulv_rec => l_lasll_rec,
1394: x_rulv_rec => lx_rulv_rec);
1395: IF(l_debug_enabled='Y') THEN
1396: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1397: ,'end debug call create_rule');
1398: END IF;
1399: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1400: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1720: lx_rulv_rec okc_rule_pub.rulv_rec_type;

1716: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_EXT_DTL';
1717: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1718: l_debug_enabled VARCHAR2(10);
1719: lx_return_status VARCHAR2(1);
1720: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1721: l_lafreq_rec okc_rule_pub.rulv_rec_type;
1722: l_lafexp_rec okc_rule_pub.rulv_rec_type;
1723: l_rgp_id NUMBER;
1724: -- find the LAFEXP rule group id

Line 1721: l_lafreq_rec okc_rule_pub.rulv_rec_type;

1717: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1718: l_debug_enabled VARCHAR2(10);
1719: lx_return_status VARCHAR2(1);
1720: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1721: l_lafreq_rec okc_rule_pub.rulv_rec_type;
1722: l_lafexp_rec okc_rule_pub.rulv_rec_type;
1723: l_rgp_id NUMBER;
1724: -- find the LAFEXP rule group id
1725: CURSOR find_fexprg_csr IS

Line 1722: l_lafexp_rec okc_rule_pub.rulv_rec_type;

1718: l_debug_enabled VARCHAR2(10);
1719: lx_return_status VARCHAR2(1);
1720: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1721: l_lafreq_rec okc_rule_pub.rulv_rec_type;
1722: l_lafexp_rec okc_rule_pub.rulv_rec_type;
1723: l_rgp_id NUMBER;
1724: -- find the LAFEXP rule group id
1725: CURSOR find_fexprg_csr IS
1726: SELECT id

Line 1807: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'

1803: l_lafreq_rec.jtot_object1_code := 'OKL_TUOM';
1804: -- create the rule
1805: IF(l_lafreq_rec.id IS NULL OR l_lafreq_rec.id = OKL_API.G_MISS_NUM) THEN
1806: IF(l_debug_enabled='Y') THEN
1807: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'
1808: ,'begin debug call create_rule');
1809: END IF;
1810: okc_rule_pub.create_rule(p_api_version => p_api_version,
1811: p_init_msg_list => p_init_msg_list,

Line 1810: okc_rule_pub.create_rule(p_api_version => p_api_version,

1806: IF(l_debug_enabled='Y') THEN
1807: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'
1808: ,'begin debug call create_rule');
1809: END IF;
1810: okc_rule_pub.create_rule(p_api_version => p_api_version,
1811: p_init_msg_list => p_init_msg_list,
1812: x_return_status => x_return_status,
1813: x_msg_count => x_msg_count,
1814: x_msg_data => x_msg_data,

Line 1818: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'

1814: x_msg_data => x_msg_data,
1815: p_rulv_rec => l_lafreq_rec,
1816: x_rulv_rec => lx_rulv_rec);
1817: IF(l_debug_enabled='Y') THEN
1818: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'
1819: ,'end debug call create_rule');
1820: END IF;
1821: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1822: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1845: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'

1841: l_lafexp_rec.rule_information2 := p_periodic_amount;
1842: -- create the rule
1843: IF(l_lafexp_rec.id IS NULL OR l_lafexp_rec.id = OKL_API.G_MISS_NUM) THEN
1844: IF(l_debug_enabled='Y') THEN
1845: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'
1846: ,'begin debug call create_rule');
1847: END IF;
1848: okc_rule_pub.create_rule(p_api_version => p_api_version,
1849: p_init_msg_list => p_init_msg_list,

Line 1848: okc_rule_pub.create_rule(p_api_version => p_api_version,

1844: IF(l_debug_enabled='Y') THEN
1845: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'
1846: ,'begin debug call create_rule');
1847: END IF;
1848: okc_rule_pub.create_rule(p_api_version => p_api_version,
1849: p_init_msg_list => p_init_msg_list,
1850: x_return_status => x_return_status,
1851: x_msg_count => x_msg_count,
1852: x_msg_data => x_msg_data,

Line 1856: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'

1852: x_msg_data => x_msg_data,
1853: p_rulv_rec => l_lafexp_rec,
1854: x_rulv_rec => lx_rulv_rec);
1855: IF(l_debug_enabled='Y') THEN
1856: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsqlokc_rule_pub.create_rule'
1857: ,'end debug call create_rule');
1858: END IF;
1859: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1860: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;