DBA Data[Home] [Help]

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_CONTRACT_LINE_ITEM_PVT

Line 3575: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3571: AND okc.lse_id = style.id
3572: AND style.lty_code = 'LINK_FEE_ASSET';
3573:
3574: upd NUMBER := 0;
3575: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3576: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3577: ins NUMBER := 0;
3578: l_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3579: x_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

Line 3576: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3572: AND style.lty_code = 'LINK_FEE_ASSET';
3573:
3574: upd NUMBER := 0;
3575: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3576: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3577: ins NUMBER := 0;
3578: l_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3579: x_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3580:

Line 3578: l_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3574: upd NUMBER := 0;
3575: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3576: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3577: ins NUMBER := 0;
3578: l_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3579: x_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3580:
3581: CURSOR rbk_d_fee_asset_csr (p_orig_chr_id NUMBER,
3582: p_rbk_chr_id NUMBER) IS

Line 3579: x_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3575: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3576: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3577: ins NUMBER := 0;
3578: l_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3579: x_c_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3580:
3581: CURSOR rbk_d_fee_asset_csr (p_orig_chr_id NUMBER,
3582: p_rbk_chr_id NUMBER) IS
3583: select origl.id orig_link_fee_id,

Line 3605: l_d_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

3601: and rbkl.dnz_chr_id = p_rbk_chr_id
3602: );
3603:
3604: del NUMBER := 0;
3605: l_d_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
3606:
3607: l_orig_freq_rule_id NUMBER;
3608: l_orig_freq_rgp_id NUMBER;
3609: l_orig_freq OKC_RULES_V.OBJECT1_ID1%TYPE;

Line 4217: okl_contract_line_item_pvt.update_contract_line_item(

4213: END IF;
4214: END LOOP; -- subline
4215:
4216: IF (l_u_line_item_tbl.COUNT > 0) THEN
4217: okl_contract_line_item_pvt.update_contract_line_item(
4218: p_api_version => 1.0,
4219: p_init_msg_list => OKL_API.G_FALSE,
4220: x_return_status => x_return_status,
4221: x_msg_count => x_msg_count,

Line 4235: -- Change call from okl_contract_line_item_pvt.create_contract_line_item to

4231: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Link Fee asset updated; '||l_u_line_item_tbl.COUNT);
4232: END IF;
4233:
4234: --Bug# 4899328
4235: -- Change call from okl_contract_line_item_pvt.create_contract_line_item to
4236: -- okl_copy_asset_pub.copy_all_lines in order to copy Payments associated to
4237: -- new covered asset lines.
4238: IF (l_cov_ast_tbl.COUNT > 0) THEN
4239: okl_copy_asset_pub.copy_all_lines(

Line 4267: okl_contract_line_item_pvt.create_contract_line_item(

4263:
4264:
4265: /*
4266: IF (l_c_line_item_tbl.COUNT > 0) THEN
4267: okl_contract_line_item_pvt.create_contract_line_item(
4268: p_api_version => 1.0,
4269: p_init_msg_list => OKL_API.G_FALSE,
4270: x_return_status => x_return_status,
4271: x_msg_count => x_msg_count,

Line 4507: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

4503: l_rgr_tbl OKL_RGRP_RULES_PROCESS_PVT.rgr_tbl_type;
4504: -- Bug#9689536 - End
4505:
4506: upd NUMBER := 0;
4507: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
4508: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
4509: ins NUMBER := 0;
4510:
4511: l_orig_freq_rule_id NUMBER;

Line 4508: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;

4504: -- Bug#9689536 - End
4505:
4506: upd NUMBER := 0;
4507: l_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
4508: x_u_line_item_tbl okl_contract_line_item_pvt.line_item_tbl_type;
4509: ins NUMBER := 0;
4510:
4511: l_orig_freq_rule_id NUMBER;
4512: l_orig_freq_rgp_id NUMBER;

Line 4968: okl_contract_line_item_pvt.update_contract_line_item(

4964: END IF;
4965: END LOOP; -- subline
4966:
4967: IF (l_u_line_item_tbl.COUNT > 0) THEN
4968: okl_contract_line_item_pvt.update_contract_line_item(
4969: p_api_version => 1.0,
4970: p_init_msg_list => OKL_API.G_FALSE,
4971: x_return_status => x_return_status,
4972: x_msg_count => x_msg_count,