APPS.OKL_LOAN_BAL_UPDATE_PVT dependencies on OKL_CONTRACT_BALANCES

Line 87: FROM okl_contract_balances

83: -- Cursor to check the presence of contract balances for a contract
84: CURSOR chk_contract_bal(p_chr_id NUMBER) IS
85: SELECT id
86: , object_version_number
87: FROM okl_contract_balances
88: WHERE khr_id = p_chr_id
89: AND kle_id IS NULL ;
90:
91: -- Cursor to check the presence of contract balances for a contract asset

Line 95: FROM okl_contract_balances

91: -- Cursor to check the presence of contract balances for a contract asset
92: CURSOR chk_asset_bal(p_chr_id NUMBER, p_kle_id NUMBER) IS
93: SELECT id
94: , object_version_number
95: FROM okl_contract_balances
96: WHERE khr_id = p_chr_id
97: AND kle_id = p_kle_id;
98: BEGIN
99: l_debug_enabled := okl_debug_pub.check_log_enabled;

Line 297: -- Insert the table of records into OKL_CONTRACT_BALANCES

293: END IF; -- end of check for presence of contract asset balances
294: CLOSE chk_contract_bal;
295:
296: IF l_crt_cblv_tbl.COUNT > 0 THEN
297: -- Insert the table of records into OKL_CONTRACT_BALANCES
298: OKL_CONTRACT_BALANCES_PVT.create_contract_balance(
299: p_api_version => l_api_version
300: , p_init_msg_list => p_init_msg_list
301: , x_return_status => x_return_status

Line 298: OKL_CONTRACT_BALANCES_PVT.create_contract_balance(

294: CLOSE chk_contract_bal;
295:
296: IF l_crt_cblv_tbl.COUNT > 0 THEN
297: -- Insert the table of records into OKL_CONTRACT_BALANCES
298: OKL_CONTRACT_BALANCES_PVT.create_contract_balance(
299: p_api_version => l_api_version
300: , p_init_msg_list => p_init_msg_list
301: , x_return_status => x_return_status
302: , x_msg_count => x_msg_count

Line 315: -- Update the table of records in OKL_CONTRACT_BALANCES

311: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully created balances for Contract Number: '|| p_khr_rec.contract_number);
312: END IF;
313:
314: IF l_upd_cblv_tbl.COUNT > 0 THEN
315: -- Update the table of records in OKL_CONTRACT_BALANCES
316: OKL_CONTRACT_BALANCES_PVT.update_contract_balance(
317: p_api_version => l_api_version
318: , p_init_msg_list => p_init_msg_list
319: , x_return_status => x_return_status

Line 316: OKL_CONTRACT_BALANCES_PVT.update_contract_balance(

312: END IF;
313:
314: IF l_upd_cblv_tbl.COUNT > 0 THEN
315: -- Update the table of records in OKL_CONTRACT_BALANCES
316: OKL_CONTRACT_BALANCES_PVT.update_contract_balance(
317: p_api_version => l_api_version
318: , p_init_msg_list => p_init_msg_list
319: , x_return_status => x_return_status
320: , x_msg_count => x_msg_count