DBA Data[Home] [Help]

APPS.OKS_BILL_UTIL_PUB dependencies on OKC_RULE_PUB

Line 1404: p_rulv_tbl OKC_RULE_PUB.rulv_tbl_type;

1400: from okc_rules_b rul
1401: where rul.rule_information_category in ('IRE') and
1402: dnz_chr_id = p_chr_id;
1403:
1404: p_rulv_tbl OKC_RULE_PUB.rulv_tbl_type;
1405: l_rule_id number;
1406:
1407: BEGIN
1408:

Line 1425: OKC_RULE_PUB.delete_rule(

1421: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1422:
1423: IF p_rulv_tbl.COUNT > 0 THEN
1424:
1425: OKC_RULE_PUB.delete_rule(
1426: p_api_version => p_api_version,
1427: p_init_msg_list => p_init_msg_list,
1428: x_return_status => l_return_status,
1429: x_msg_count => x_msg_count,

Line 1798: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;

1794: from okc_rules_b
1795: where rgp_id = p_rgp_id
1796: and rule_information_category = 'USV';
1797: l_rule_id NUMBER;
1798: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1799: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1800: l_create BOOLEAN := TRUE;
1801: l_api_version NUMBER := 1.0;
1802: l_msg_count NUMBER;

Line 1799: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;

1795: where rgp_id = p_rgp_id
1796: and rule_information_category = 'USV';
1797: l_rule_id NUMBER;
1798: l_rulv_tbl_in okc_rule_pub.rulv_tbl_type;
1799: l_rulv_tbl_out okc_rule_pub.rulv_tbl_type;
1800: l_create BOOLEAN := TRUE;
1801: l_api_version NUMBER := 1.0;
1802: l_msg_count NUMBER;
1803: l_msg_data VARCHAR2(2000);

Line 1827: OKC_RULE_PUB.create_rule(

1823: l_rulv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
1824: l_rulv_tbl_in(1).creation_date := SYSDATE;
1825: l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
1826: l_rulv_tbl_in(1).last_update_date := SYSDATE;
1827: OKC_RULE_PUB.create_rule(
1828: p_api_version => l_api_version,
1829: x_return_status => x_status,
1830: x_msg_count => l_msg_count,
1831: x_msg_data => l_msg_data,

Line 1850: OKC_RULE_PUB.update_rule(

1846: l_rulv_tbl_in(1).created_by := OKC_API.G_MISS_NUM;
1847: l_rulv_tbl_in(1).creation_date := OKC_API.G_MISS_DATE;
1848: l_rulv_tbl_in(1).last_updated_by := OKC_API.G_MISS_NUM;
1849: l_rulv_tbl_in(1).last_update_date := OKC_API.G_MISS_DATE;
1850: OKC_RULE_PUB.update_rule(
1851: p_api_version => l_api_version,
1852: x_return_status => x_status,
1853: x_msg_count => l_msg_count,
1854: x_msg_data => l_msg_data,