DBA Data[Home] [Help]

APPS.OKL_FUNDING_CHECKLIST_PVT dependencies on OKL_RULE_PUB

Line 417: ,p_rulv_migr_rec OUT NOCOPY okl_rule_pub.rulv_rec_type

413: ,x_return_status OUT NOCOPY VARCHAR2
414: ,x_msg_count OUT NOCOPY NUMBER
415: ,x_msg_data OUT NOCOPY VARCHAR2
416: ,p_rulv_rec IN rulv_rec_type
417: ,p_rulv_migr_rec OUT NOCOPY okl_rule_pub.rulv_rec_type
418: ,p_mode IN varchar2
419: )
420: is
421: l_api_name CONSTANT VARCHAR2(30) := 'copy_rulv_rec';

Line 559: ,p_rulv_migr_tbl OUT NOCOPY okl_rule_pub.rulv_tbl_type

555: ,x_return_status OUT NOCOPY VARCHAR2
556: ,x_msg_count OUT NOCOPY NUMBER
557: ,x_msg_data OUT NOCOPY VARCHAR2
558: ,p_rulv_tbl IN rulv_tbl_type
559: ,p_rulv_migr_tbl OUT NOCOPY okl_rule_pub.rulv_tbl_type
560: ,p_mode IN varchar2)
561: is
562: l_api_name CONSTANT VARCHAR2(30) := 'copy_rulv_tbl';
563: l_api_version CONSTANT NUMBER := 1.0;

Line 666: p_rulv_migr_rec OUT NOCOPY okl_rule_pub.rulv_rec_type)

662: -- End of comments
663: ----------------------------------------------------------------------------------
664: PROCEDURE copy_rulv_rec(
665: p_rulv_rec IN rulv_rec_type,
666: p_rulv_migr_rec OUT NOCOPY okl_rule_pub.rulv_rec_type)
667: is
668: begin
669:
670: p_rulv_migr_rec.id := p_rulv_rec.id;

Line 708: p_rulv_migr_tbl OUT NOCOPY okl_rule_pub.rulv_tbl_type)

704: -- End of comments
705: ----------------------------------------------------------------------------------
706: PROCEDURE copy_rulv_tbl(
707: p_rulv_tbl IN rulv_tbl_type,
708: p_rulv_migr_tbl OUT NOCOPY okl_rule_pub.rulv_tbl_type)
709: is
710: i number;
711: begin
712:

Line 756: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

752: i NUMBER;
753: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
754: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
755: -- xp_rulv_tbl rulv_tbl_type := x_rulv_tbl;
756: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
757: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
758:
759: --START: Fixed bug 5912358 by nikshah, 06-MAR-2007
760: l_lease_app_found boolean := FALSE;

Line 757: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

753: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
754: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
755: -- xp_rulv_tbl rulv_tbl_type := x_rulv_tbl;
756: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
757: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
758:
759: --START: Fixed bug 5912358 by nikshah, 06-MAR-2007
760: l_lease_app_found boolean := FALSE;
761: l_lease_app_list_found boolean := FALSE;

Line 854: okl_rule_pub.create_rule_group(

850: lp_rgpv_rec.CHR_ID := l_chr_id;
851: lp_rgpv_rec.RGD_CODE := G_FUNDING_CHKLST_TPL;
852: lp_rgpv_rec.RGP_TYPE := G_RGP_TYPE;
853:
854: okl_rule_pub.create_rule_group(
855: p_api_version => p_api_version,
856: p_init_msg_list => p_init_msg_list,
857: x_return_status => x_return_status,
858: x_msg_count => x_msg_count,

Line 896: okl_rule_pub.create_rule(

892:
893: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
894: -- validation
895:
896: okl_rule_pub.create_rule(
897: p_api_version => p_api_version,
898: p_init_msg_list => p_init_msg_list,
899: x_return_status => x_return_status,
900: x_msg_count => x_msg_count,

Line 984: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

980: i NUMBER;
981: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
982: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
983: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
984: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
985: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
986:
987: begin
988: -- Set API savepoint

Line 985: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

981: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
982: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
983: -- lx_rulv_tbl rulv_tbl_type := x_rulv_tbl;
984: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
985: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
986:
987: begin
988: -- Set API savepoint
989: SAVEPOINT update_funding_chklst;

Line 1032: okl_rule_pub.update_rule(

1028:
1029: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1030: -- validation
1031:
1032: okl_rule_pub.update_rule(
1033: p_api_version => p_api_version,
1034: p_init_msg_list => p_init_msg_list,
1035: x_return_status => x_return_status,
1036: x_msg_count => x_msg_count,

Line 1119: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1115: i NUMBER;
1116: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1117: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1118: -- xp_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1119: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1120: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1121:
1122: begin
1123: -- Set API savepoint

Line 1120: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1116: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1117: -- lp_rulv_tbl rulv_tbl_type := p_rulv_tbl;
1118: -- xp_rulv_tbl rulv_tbl_type := x_rulv_tbl;
1119: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1120: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1121:
1122: begin
1123: -- Set API savepoint
1124: SAVEPOINT delete_funding_chklst;

Line 1166: okl_rule_pub.delete_rule(

1162: End If;
1163:
1164: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1165:
1166: okl_rule_pub.delete_rule(
1167: p_api_version => p_api_version,
1168: p_init_msg_list => p_init_msg_list,
1169: x_return_status => x_return_status,
1170: x_msg_count => x_msg_count,

Line 1348: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;

1344: l_api_version CONSTANT NUMBER := 1.0;
1345: i NUMBER;
1346: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1347:
1348: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1349: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1350: l_id number;
1351:
1352: cursor c_ids (p_chr_id okc_k_headers_b.id%TYPE, p_req_id number)

Line 1349: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;

1345: i NUMBER;
1346: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1347:
1348: lp_rulv_tbl okl_rule_pub.rulv_tbl_type;
1349: lx_rulv_tbl okl_rule_pub.rulv_tbl_type;
1350: l_id number;
1351:
1352: cursor c_ids (p_chr_id okc_k_headers_b.id%TYPE, p_req_id number)
1353: is

Line 1404: okl_rule_pub.update_rule(

1400: end loop;
1401:
1402: -- validation
1403:
1404: okl_rule_pub.update_rule(
1405: p_api_version => p_api_version,
1406: p_init_msg_list => p_init_msg_list,
1407: x_return_status => x_return_status,
1408: x_msg_count => x_msg_count,