DBA Data[Home] [Help]

APPS.OKL_QUOTE_TO_CONTRACT_PVT dependencies on OKC_RULE_PUB

Line 583: x_rulv_rec OUT NOCOPY okc_rule_pub.rulv_rec_type) IS

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

Line 584: l_rulv_rec okc_rule_pub.rulv_rec_type;

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

Line 625: l_rgpv_rec okc_rule_pub.rgpv_rec_type;

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

Line 626: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;

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

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

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

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

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

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

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

Line 1178: l_laslh_rec okc_rule_pub.rulv_rec_type;

1174: l_api_version CONSTANT NUMBER DEFAULT 1.0;
1175: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_PMT_PLN';
1176: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1177: l_payment_levels_tbl payment_levels_tbl_type;
1178: l_laslh_rec okc_rule_pub.rulv_rec_type;
1179: l_lasll_rec okc_rule_pub.rulv_rec_type;
1180: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1181: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1182: line_number NUMBER := 0;

Line 1179: l_lasll_rec okc_rule_pub.rulv_rec_type;

1175: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'CRT_PMT_PLN';
1176: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1177: l_payment_levels_tbl payment_levels_tbl_type;
1178: l_laslh_rec okc_rule_pub.rulv_rec_type;
1179: l_lasll_rec okc_rule_pub.rulv_rec_type;
1180: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1181: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1182: line_number NUMBER := 0;
1183: l_laslh_id NUMBER;

Line 1180: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;

1176: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1177: l_payment_levels_tbl payment_levels_tbl_type;
1178: l_laslh_rec okc_rule_pub.rulv_rec_type;
1179: l_lasll_rec okc_rule_pub.rulv_rec_type;
1180: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1181: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1182: line_number NUMBER := 0;
1183: l_laslh_id NUMBER;
1184: l_rgp_id NUMBER := NULL;

Line 1181: lx_rulv_rec okc_rule_pub.rulv_rec_type;

1177: l_payment_levels_tbl payment_levels_tbl_type;
1178: l_laslh_rec okc_rule_pub.rulv_rec_type;
1179: l_lasll_rec okc_rule_pub.rulv_rec_type;
1180: lx_rgpv_rec okc_rule_pub.rgpv_rec_type;
1181: lx_rulv_rec okc_rule_pub.rulv_rec_type;
1182: line_number NUMBER := 0;
1183: l_laslh_id NUMBER;
1184: l_rgp_id NUMBER := NULL;
1185: l_start_date DATE;

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

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

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

1285: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1286: ,'begin debug call create_rule');
1287: END IF;
1288: -- create rule for LASLH (payment header)
1289: okc_rule_pub.create_rule(p_api_version => p_api_version,
1290: p_init_msg_list => p_init_msg_list,
1291: x_msg_count => x_msg_count,
1292: x_msg_data => x_msg_data,
1293: x_return_status => l_return_status,

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

1293: x_return_status => l_return_status,
1294: p_rulv_rec => l_laslh_rec,
1295: x_rulv_rec => lx_rulv_rec);
1296: IF(l_debug_enabled='Y') THEN
1297: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1298: ,'end debug call create_rule');
1299: END IF;
1300: IF(l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

1376: l_lasll_rec.rule_information7 := l_payment_levels_tbl(line_number).stub_days;
1377: l_lasll_rec.rule_information8 := l_payment_levels_tbl(line_number).stub_amount;
1378:
1379: IF(l_debug_enabled='Y') THEN
1380: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1381: ,'begin debug call create_rule');
1382: END IF;
1383: okc_rule_pub.create_rule(p_api_version => p_api_version,
1384: p_init_msg_list => p_init_msg_list,

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

1379: IF(l_debug_enabled='Y') THEN
1380: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1381: ,'begin debug call create_rule');
1382: END IF;
1383: okc_rule_pub.create_rule(p_api_version => p_api_version,
1384: p_init_msg_list => p_init_msg_list,
1385: x_return_status => x_return_status,
1386: x_msg_count => x_msg_count,
1387: x_msg_data => x_msg_data,

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

1387: x_msg_data => x_msg_data,
1388: p_rulv_rec => l_lasll_rec,
1389: x_rulv_rec => lx_rulv_rec);
1390: IF(l_debug_enabled='Y') THEN
1391: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okc_rule_pub.create_rule'
1392: ,'end debug call create_rule');
1393: END IF;
1394: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1716: lx_rulv_rec okc_rule_pub.rulv_rec_type;

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

Line 1717: l_lafreq_rec okc_rule_pub.rulv_rec_type;

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

Line 1718: l_lafexp_rec okc_rule_pub.rulv_rec_type;

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

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

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

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

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

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

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

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

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

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

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

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

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