DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKC_RULE_PUB

Line 1370: p_rulv_tbl OKC_RULE_PUB.rulv_tbl_type;

1366: from okc_rules_b rul
1367: where rul.rule_information_category in ('IRE') and
1368: dnz_chr_id = p_chr_id;
1369:
1370: p_rulv_tbl OKC_RULE_PUB.rulv_tbl_type;
1371: l_rule_id number;
1372:
1373: BEGIN
1374:

Line 1391: OKC_RULE_PUB.delete_rule(

1387: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1388:
1389: IF p_rulv_tbl.COUNT > 0 THEN
1390:
1391: OKC_RULE_PUB.delete_rule(
1392: p_api_version => p_api_version,
1393: p_init_msg_list => p_init_msg_list,
1394: x_return_status => l_return_status,
1395: x_msg_count => x_msg_count,

Line 1764: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

1760: from okc_rules_b
1761: where rgp_id = p_rgp_id
1762: and rule_information_category = 'USV';
1763: l_rule_id NUMBER;
1764: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1765: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1766: l_create BOOLEAN := TRUE;
1767: l_api_version NUMBER := 1.0;
1768: l_msg_count NUMBER;

Line 1765: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

1761: where rgp_id = p_rgp_id
1762: and rule_information_category = 'USV';
1763: l_rule_id NUMBER;
1764: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1765: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1766: l_create BOOLEAN := TRUE;
1767: l_api_version NUMBER := 1.0;
1768: l_msg_count NUMBER;
1769: l_msg_data VARCHAR2(2000);

Line 1793: OKC_RULE_PUB.create_rule(

1789: l_rulv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
1790: l_rulv_tbl_in(1).creation_date := SYSDATE;
1791: l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
1792: l_rulv_tbl_in(1).last_update_date := SYSDATE;
1793: OKC_RULE_PUB.create_rule(
1794: p_api_version => l_api_version,
1795: x_return_status => x_status,
1796: x_msg_count => l_msg_count,
1797: x_msg_data => l_msg_data,

Line 1816: OKC_RULE_PUB.update_rule(

1812: l_rulv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
1813: l_rulv_tbl_in(1).creation_date := OKC_API.G_MISS_DATE;
1814: l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
1815: l_rulv_tbl_in(1).last_update_date := OKC_API.G_MISS_DATE;
1816: OKC_RULE_PUB.update_rule(
1817: p_api_version => l_api_version,
1818: x_return_status => x_status,
1819: x_msg_count => l_msg_count,
1820: x_msg_data => l_msg_data,