eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CREDIT_CHECKLIST_PVT dependencies on OKL_RULE_PUB

Line 742: ,p_rulv_migr_rec OUT NOCOPY okl_rule_pub.rulv_rec_type

738: ,x_return_status OUT NOCOPY VARCHAR2
739: ,x_msg_count OUT NOCOPY NUMBER
740: ,x_msg_data OUT NOCOPY VARCHAR2
741: ,p_rulv_rec IN rulv_rec_type
742: ,p_rulv_migr_rec OUT NOCOPY okl_rule_pub.rulv_rec_type
743: ,p_type IN varchar2
744: ,p_mode IN varchar2
745: )
746: is

Line 929: ,p_rulv_migr_tbl OUT NOCOPY okl_rule_pub.rulv_tbl_type

925: ,x_return_status OUT NOCOPY VARCHAR2
926: ,x_msg_count OUT NOCOPY NUMBER
927: ,x_msg_data OUT NOCOPY VARCHAR2
928: ,p_rulv_tbl IN rulv_tbl_type
929: ,p_rulv_migr_tbl OUT NOCOPY okl_rule_pub.rulv_tbl_type
930: ,p_type IN varchar2
931: ,p_mode IN varchar2)
932: is
933: l_api_name CONSTANT VARCHAR2(30) := 'copy_rulv_tbl';

Line 1051: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1047: i NUMBER;
1048: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1049: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1050: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1051: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1052: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1053:
1054: begin
1055: -- Set API savepoint

Line 1052: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1048: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1049: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1050: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1051: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1052: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1053:
1054: begin
1055: -- Set API savepoint
1056: SAVEPOINT create_credit_chklst;

Line 1100: okl_rule_pub.create_rule(

1096:
1097: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1098: -- validation
1099:
1100: okl_rule_pub.create_rule(
1101: p_api_version => p_api_version,
1102: p_init_msg_list => p_init_msg_list,
1103: x_return_status => x_return_status,
1104: x_msg_count => x_msg_count,

Line 1193: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1189: i NUMBER;
1190: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1191: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1192: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1193: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1194: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1195:
1196: begin
1197: -- Set API savepoint

Line 1194: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1190: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1191: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1192: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1193: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1194: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1195:
1196: begin
1197: -- Set API savepoint
1198: SAVEPOINT update_credit_chklst;

Line 1243: okl_rule_pub.update_rule(

1239:
1240: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1241: -- validation
1242:
1243: okl_rule_pub.update_rule(
1244: p_api_version => p_api_version,
1245: p_init_msg_list => p_init_msg_list,
1246: x_return_status => x_return_status,
1247: x_msg_count => x_msg_count,

Line 1335: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1331: i NUMBER;
1332: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1333: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1334: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1335: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1336: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1337:
1338: begin
1339: -- Set API savepoint

Line 1336: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1332: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1333: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1334: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1335: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1336: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1337:
1338: begin
1339: -- Set API savepoint
1340: SAVEPOINT delete_credit_chklst;

Line 1383: okl_rule_pub.delete_rule(

1379: End If;
1380:
1381: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1382:
1383: okl_rule_pub.delete_rule(
1384: p_api_version => p_api_version,
1385: p_init_msg_list => p_init_msg_list,
1386: x_return_status => x_return_status,
1387: x_msg_count => x_msg_count,

Line 1458: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1454: l_api_version CONSTANT NUMBER := 1.0;
1455: i NUMBER;
1456: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1457:
1458: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1459: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1460: l_id number;
1461:
1462: cursor c_ids (p_chr_id okc_k_headers_b.id%TYPE)

Line 1459: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1455: i NUMBER;
1456: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1457:
1458: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1459: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1460: l_id number;
1461:
1462: cursor c_ids (p_chr_id okc_k_headers_b.id%TYPE)
1463: is

Line 1510: okl_rule_pub.update_rule(

1506: end loop;
1507:
1508: -- validation
1509:
1510: okl_rule_pub.update_rule(
1511: p_api_version => p_api_version,
1512: p_init_msg_list => p_init_msg_list,
1513: x_return_status => x_return_status,
1514: x_msg_count => x_msg_count,

Line 1588: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1584: i NUMBER;
1585: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1586: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1587: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1588: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1589: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1590:
1591: begin
1592: -- Set API savepoint

Line 1589: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1585: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1586: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1587: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1588: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1589: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1590:
1591: begin
1592: -- Set API savepoint
1593: SAVEPOINT update_fund_chklst_tpl_hdr;

Line 1678: lp_rulv_rec okl_rule_pub.rulv_rec_type;

1674: i NUMBER;
1675: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1676: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1677: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1678: lp_rulv_rec okl_rule_pub.rulv_rec_type;
1679: lx_rulv_rec okl_rule_pub.rulv_rec_type;
1680:
1681: begin
1682: -- Set API savepoint

Line 1679: lx_rulv_rec okl_rule_pub.rulv_rec_type;

1675: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1676: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1677: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1678: lp_rulv_rec okl_rule_pub.rulv_rec_type;
1679: lx_rulv_rec okl_rule_pub.rulv_rec_type;
1680:
1681: begin
1682: -- Set API savepoint
1683: SAVEPOINT update_fund_chklst_tpl_hdr;

Line 1747: okl_rule_pub.update_rule(

1743:
1744: --
1745: -- call rule api
1746: --
1747: okl_rule_pub.update_rule(
1748: p_api_version => p_api_version,
1749: p_init_msg_list => p_init_msg_list,
1750: x_return_status => x_return_status,
1751: x_msg_count => x_msg_count,

Line 1840: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1836: i NUMBER;
1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1838: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1839: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1840: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1841: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1842:
1843: begin
1844: -- Set API savepoint

Line 1841: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1837: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1838: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1839: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1840: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1841: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1842:
1843: begin
1844: -- Set API savepoint
1845: SAVEPOINT update_funding_chklst_tpl;

Line 1890: okl_rule_pub.update_rule(

1886:
1887: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1888: -- validation
1889:
1890: okl_rule_pub.update_rule(
1891: p_api_version => p_api_version,
1892: p_init_msg_list => p_init_msg_list,
1893: x_return_status => x_return_status,
1894: x_msg_count => x_msg_count,

Line 1981: lp_rulv_rec okl_rule_pub.rulv_rec_type;

1977: l_api_version CONSTANT NUMBER := 1.0;
1978: i NUMBER;
1979: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1980:
1981: lp_rulv_rec okl_rule_pub.rulv_rec_type;
1982: lx_rulv_rec okl_rule_pub.rulv_rec_type;
1983:
1984: l_id number;
1985:

Line 1982: lx_rulv_rec okl_rule_pub.rulv_rec_type;

1978: i NUMBER;
1979: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1980:
1981: lp_rulv_rec okl_rule_pub.rulv_rec_type;
1982: lx_rulv_rec okl_rule_pub.rulv_rec_type;
1983:
1984: l_id number;
1985:
1986: cursor c_tpl_hdr (p_chr_id okc_k_headers_b.id%TYPE)

Line 2026: okl_rule_pub.update_rule(

2022:
2023: lp_rulv_rec.ID := l_id;
2024: lp_rulv_rec.RULE_INFORMATION3 := 'ACTIVE'; -- status
2025:
2026: okl_rule_pub.update_rule(
2027: p_api_version => p_api_version,
2028: p_init_msg_list => p_init_msg_list,
2029: x_return_status => x_return_status,
2030: x_msg_count => x_msg_count,

Line 2106: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

2102: i NUMBER;
2103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2104: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
2105: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
2106: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
2107: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
2108:
2109: begin
2110: -- Set API savepoint

Line 2107: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

2103: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2104: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
2105: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
2106: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
2107: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
2108:
2109: begin
2110: -- Set API savepoint
2111: SAVEPOINT create_funding_chklst_tpl;

Line 2156: okl_rule_pub.create_rule(

2152:
2153: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
2154: -- validation
2155:
2156: okl_rule_pub.create_rule(
2157: p_api_version => p_api_version,
2158: p_init_msg_list => p_init_msg_list,
2159: x_return_status => x_return_status,
2160: x_msg_count => x_msg_count,

Line 2247: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

2243: i NUMBER;
2244: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2245: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
2246: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
2247: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
2248: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
2249:
2250: begin
2251: -- Set API savepoint

Line 2248: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

2244: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2245: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
2246: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
2247: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
2248: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
2249:
2250: begin
2251: -- Set API savepoint
2252: SAVEPOINT delete_funding_chklst_tpl;

Line 2294: okl_rule_pub.delete_rule(

2290: raise OKC_API.G_EXCEPTION_ERROR;
2291: End If;
2292:
2293: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
2294: okl_rule_pub.delete_rule(
2295: p_api_version => p_api_version,
2296: p_init_msg_list => p_init_msg_list,
2297: x_return_status => x_return_status,
2298: x_msg_count => x_msg_count,