DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_CONTRACT_PUB

Line 1809: OKL_CONTRACT_PUB.update_contract_line(

1805: --Setting the re_lease_yn column to NULL whenever creating a copy of a contract line
1806: l_klev_rec.re_lease_yn := NULL;
1807: --Bug #15992711: end
1808:
1809: OKL_CONTRACT_PUB.update_contract_line(
1810: p_api_version => p_api_version,
1811: p_init_msg_list => p_init_msg_list,
1812: x_return_status => l_return_status,
1813: x_msg_count => x_msg_count,

Line 2604: OKL_CONTRACT_PUB.delete_contract_line(

2600: OPEN abnd_tls_csr(p_copied_chr_id => l_chr_id);
2601: LOOP
2602: FETCH abnd_tls_csr into l_cle_id, l_source_cle_id;
2603: EXIT WHEN abnd_tls_csr%NOTFOUND;
2604: OKL_CONTRACT_PUB.delete_contract_line(
2605: p_api_version => p_api_version,
2606: p_init_msg_list => p_init_msg_list,
2607: x_return_status => x_return_status,
2608: x_msg_count => x_msg_count,

Line 2621: OKL_CONTRACT_PUB.delete_contract_line(

2617: OPEN abnd_sls_csr(p_copied_chr_id => l_chr_id);
2618: LOOP
2619: FETCH abnd_sls_csr into l_cle_id, l_source_cle_id;
2620: EXIT WHEN abnd_sls_csr%NOTFOUND;
2621: OKL_CONTRACT_PUB.delete_contract_line(
2622: p_api_version => p_api_version,
2623: p_init_msg_list => p_init_msg_list,
2624: x_return_status => x_return_status,
2625: x_msg_count => x_msg_count,

Line 2702: OKL_CONTRACT_PUB.delete_contract_line(

2698: OPEN roll_tls_csr(p_copied_chr_id => l_chr_id);
2699: LOOP
2700: FETCH roll_tls_csr into l_cle_id, l_source_cle_id;
2701: EXIT WHEN roll_tls_csr%NOTFOUND;
2702: OKL_CONTRACT_PUB.delete_contract_line(
2703: p_api_version => p_api_version,
2704: p_init_msg_list => p_init_msg_list,
2705: x_return_status => x_return_status,
2706: x_msg_count => x_msg_count,

Line 3021: OKL_CONTRACT_PUB.update_contract_header(

3017: null;
3018: Else
3019: l_khrv_rec.id := x_chr_id;
3020: -- Create record into okl_contract_header
3021: OKL_CONTRACT_PUB.update_contract_header(
3022: p_api_version => p_api_version,
3023: p_init_msg_list => p_init_msg_list,
3024: x_return_status => l_return_status,
3025: x_msg_count => x_msg_count,

Line 4614: okl_contract_pub.update_contract_header(

4610: l_khrv_rec.TOT_CL_NET_TRANSFER_AMT := NULL;
4611: l_khrv_rec.TOT_CL_LIMIT := NULL;
4612: l_khrv_rec.TOT_CL_FUNDING_AMT := NULL;
4613:
4614: okl_contract_pub.update_contract_header(
4615: p_api_version => p_api_version,
4616: p_init_msg_list => p_init_msg_list,
4617: x_return_status => x_return_status,
4618: x_msg_count => x_msg_count,

Line 4676: okl_contract_pub.update_contract_line(

4672: If nvl(p_trans_type,'CFA') = 'CFA' then
4673: l_klev_rec.qte_id := NULL;
4674: End If;
4675:
4676: okl_contract_pub.update_contract_line(
4677: p_api_version => p_api_version,
4678: p_init_msg_list => p_init_msg_list,
4679: x_return_status => x_return_status,
4680: x_msg_count => x_msg_count,

Line 21518: Okl_Contract_Pub.delete_contract_line(

21514: select count(1) into l_line_count -- 5207066
21515: FROM okc_k_lines_b
21516: where id = l_delete_id_tab(i);
21517: IF (l_line_count > 0) THEN -- 5207066
21518: Okl_Contract_Pub.delete_contract_line(
21519: p_api_version => p_api_version,
21520: p_init_msg_list => p_init_msg_list,
21521: x_return_status => x_return_status,
21522: x_msg_count => x_msg_count,

Line 22379: lp_khrv_rec Okl_Contract_Pub.khrv_rec_type;

22375: l_parent_sts_rec l_parent_sts_csr%ROWTYPE;
22376: --Bug# 3621663
22377:
22378: -- apaul,Bug#4381642
22379: lp_khrv_rec Okl_Contract_Pub.khrv_rec_type;
22380: lx_khrv_rec Okl_Contract_Pub.khrv_rec_type;
22381:
22382: BEGIN
22383: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 22380: lx_khrv_rec Okl_Contract_Pub.khrv_rec_type;

22376: --Bug# 3621663
22377:
22378: -- apaul,Bug#4381642
22379: lp_khrv_rec Okl_Contract_Pub.khrv_rec_type;
22380: lx_khrv_rec Okl_Contract_Pub.khrv_rec_type;
22381:
22382: BEGIN
22383: x_return_status := OKL_API.G_RET_STS_SUCCESS;
22384: -- Call start_activity to create savepoint, check compatibility

Line 22613: OKL_CONTRACT_PUB.delete_contract_line(

22609: Loop
22610: Fetch ins_top_line_csr into
22611: l_ins_top_line_id;
22612: Exit when ins_top_line_csr%NotFound;
22613: OKL_CONTRACT_PUB.delete_contract_line(
22614: p_api_version => p_api_version,
22615: p_init_msg_list => p_init_msg_list,
22616: x_return_status => x_return_status,
22617: x_msg_count => x_msg_count,

Line 22736: Okl_Contract_Pub.update_contract_header(

22732: l_chrv_rec.id := x_chr_id;
22733: lp_khrv_rec.id := x_chr_id;
22734: lp_khrv_rec.SECURITIZED_CODE := NULL;
22735:
22736: Okl_Contract_Pub.update_contract_header(
22737: p_api_version => p_api_version,
22738: p_init_msg_list => p_init_msg_list,
22739: x_return_status => x_return_status,
22740: x_msg_count => x_msg_count,