DBA Data[Home] [Help]

APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_RULE_PUB

Line 639: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;

635: AND cleb.sts_code <> 'ABANDONED'
636: AND nvl(kle.re_lease_yn,'N') = 'N');
637: l_mxd_ast VARCHAR2(1) DEFAULT '?';
638:
639: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
640: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
641:
642: --Cursor to check for the rule group LARLES
643: CURSOR l_rule_info_csr ( p_chr_id IN NUMBER) IS

Line 640: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;

636: AND nvl(kle.re_lease_yn,'N') = 'N');
637: l_mxd_ast VARCHAR2(1) DEFAULT '?';
638:
639: l_rulv_rec OKL_RULE_PUB.rulv_rec_type;
640: lx_rulv_rec OKL_RULE_PUB.rulv_rec_type;
641:
642: --Cursor to check for the rule group LARLES
643: CURSOR l_rule_info_csr ( p_chr_id IN NUMBER) IS
644: SELECT rul.id

Line 1921: OKL_RULE_PUB.update_rule

1917:
1918: IF l_rul_info1 = 'Y' THEN
1919: l_rulv_rec.id := l_rul_info;
1920: l_rulv_rec.rule_information1 := NULL;
1921: OKL_RULE_PUB.update_rule
1922: (p_api_version => p_api_version,
1923: p_init_msg_list => p_init_msg_list,
1924: x_return_status => x_return_status,
1925: x_msg_count => x_msg_count,

Line 2217: OKL_RULE_PUB.update_rule

2213: -- Start:update header level re_leased asset flag to 'Y'
2214: --when all the assets on a contract are re-leased
2215: l_rulv_rec.id := l_rul_info;
2216: l_rulv_rec.rule_information1 := 'Y';
2217: OKL_RULE_PUB.update_rule
2218: (p_api_version => p_api_version,
2219: p_init_msg_list => p_init_msg_list,
2220: x_return_status => x_return_status,
2221: x_msg_count => x_msg_count,