DBA Data[Home] [Help]

APPS.OKC_DELETE_CONTRACT_PVT dependencies on OKC_RULE_PUB

Line 516: l_ctiv_tbl_in OKC_RULE_PUB.ctiv_tbl_type;

512: --Function DELETE_COVER_TIMES
513:
514: FUNCTION DELETE_COVER_TIMES( p_chr_id number ) Return varchar2 IS
515:
516: l_ctiv_tbl_in OKC_RULE_PUB.ctiv_tbl_type;
517:
518: CURSOR l_ctiv_csr (p_id IN NUMBER) IS
519: SELECT RUL_ID, TVE_ID
520: FROM OKC_COVER_TIMES_V

Line 532: OKC_RULE_PUB.delete_cover_time(

528: LOOP
529: l_ctiv_tbl_in(1).RUL_ID := rec.rul_id;
530: l_ctiv_tbl_in(1).TVE_ID := rec.tve_id;
531:
532: OKC_RULE_PUB.delete_cover_time(
533: p_api_version => l_api_version,
534: p_init_msg_list => l_init_msg_list,
535: x_return_status => l_return_status,
536: x_msg_count => l_msg_count,

Line 1305: l_rilv_tbl_in OKC_RULE_PUB.rilv_tbl_type;

1301: --Function DELETE_REACT_INTERVALS
1302:
1303: FUNCTION DELETE_REACT_INTERVALS( p_chr_id number) Return varchar2 IS
1304:
1305: l_rilv_tbl_in OKC_RULE_PUB.rilv_tbl_type;
1306:
1307: CURSOR l_rilv_csr (p_id IN NUMBER) IS
1308: SELECT TVE_ID, RUL_ID
1309: FROM OKC_REACT_INTERVALS_V

Line 1321: OKC_RULE_PUB.delete_react_interval (

1317: LOOP
1318: l_rilv_tbl_in(1).TVE_ID := rec.TVE_ID;
1319: l_rilv_tbl_in(1).RUL_ID := rec.RUL_ID;
1320:
1321: OKC_RULE_PUB.delete_react_interval (
1322: p_api_version => l_api_version,
1323: p_init_msg_list => l_init_msg_list,
1324: x_return_status => l_return_status,
1325: x_msg_count => l_msg_count,

Line 1364: l_rmpv_tbl_in OKC_RULE_PUB.rmpv_tbl_type;

1360: --Function DELETE_RG_PARTY_ROLES
1361:
1362: FUNCTION DELETE_RG_PARTY_ROLES( p_chr_id number) Return varchar2 IS
1363:
1364: l_rmpv_tbl_in OKC_RULE_PUB.rmpv_tbl_type;
1365:
1366: CURSOR l_rmpv_csr (p_id IN NUMBER) IS
1367: SELECT ID
1368: FROM OKC_RG_PARTY_ROLES_V

Line 1379: OKC_RULE_PUB.delete_rg_mode_pty_role (

1375: FOR rec IN l_rmpv_csr(p_chr_id)
1376: LOOP
1377: l_rmpv_tbl_in(1).ID := rec.id;
1378:
1379: OKC_RULE_PUB.delete_rg_mode_pty_role (
1380: p_api_version => l_api_version,
1381: p_init_msg_list => l_init_msg_list,
1382: x_return_status => l_return_status,
1383: x_msg_count => l_msg_count,

Line 1421: l_rgpv_tbl_in OKC_RULE_PUB.rgpv_tbl_type;

1417: --Function DELETE_RULE_GROUPS
1418:
1419: FUNCTION DELETE_RULE_GROUPS( p_chr_id number) Return varchar2 IS
1420:
1421: l_rgpv_tbl_in OKC_RULE_PUB.rgpv_tbl_type;
1422:
1423: CURSOR l_rgpv_csr (p_id IN NUMBER) IS
1424: SELECT ID
1425: FROM OKC_RULE_GROUPS_V

Line 1436: OKC_RULE_PUB.delete_rule_group (

1432: FOR rec IN l_rgpv_csr(p_chr_id)
1433: LOOP
1434: l_rgpv_tbl_in(1).ID := rec.id;
1435:
1436: OKC_RULE_PUB.delete_rule_group (
1437: p_api_version => l_api_version,
1438: p_init_msg_list => l_init_msg_list,
1439: x_return_status => l_return_status,
1440: x_msg_count => l_msg_count,

Line 1478: l_rulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;

1474: --Function DELETE_RULES
1475:
1476: FUNCTION DELETE_RULES( p_chr_id number) Return varchar2 IS
1477:
1478: l_rulv_tbl_in OKC_RULE_PUB.rulv_tbl_type;
1479:
1480: CURSOR l_rulv_csr (p_id IN NUMBER) IS
1481: SELECT ID
1482: FROM OKC_RULES_V

Line 1493: OKC_RULE_PUB.Delete_Rule (

1489: FOR rec IN l_rulv_csr(p_chr_id)
1490: LOOP
1491: l_rulv_tbl_in(1).ID := rec.id;
1492:
1493: OKC_RULE_PUB.Delete_Rule (
1494: p_api_version => l_api_version,
1495: p_init_msg_list => l_init_msg_list,
1496: x_return_status => l_return_status,
1497: x_msg_count => l_msg_count,