DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_ASSET_PVT dependencies on OKL_CDJ_PVT

Line 108: PROCEDURE process_adj_cashflows(p_cdjv_rec IN okl_cdj_pvt.cdjv_rec_type

104: --Bug # 5142940 ssdeshpa start
105: -----------------------------------
106: -- PROCEDURE process_adj_cashflows
107: -----------------------------------
108: PROCEDURE process_adj_cashflows(p_cdjv_rec IN okl_cdj_pvt.cdjv_rec_type
109: ,p_event_mode IN VARCHAR2
110: ,x_msg_count OUT NOCOPY NUMBER
111: ,x_msg_data OUT NOCOPY VARCHAR2
112: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 118: l_adj_assets_rec okl_cdj_pvt.cdjv_rec_type;

114: l_p_id NUMBER;
115: l_start_date DATE;
116: l_cf_hdr_rec cashflow_hdr_rec_type;
117: l_cashflow_level_tbl cashflow_level_tbl_type;
118: l_adj_assets_rec okl_cdj_pvt.cdjv_rec_type;
119: lv_parent_object_code okl_lease_quotes_b.parent_object_code%TYPE;
120:
121: CURSOR get_quote_rec(p_quote_id NUMBER) IS
122: SELECT qte.id, qte.expected_start_date, qte.parent_object_code

Line 758: p_input_adj_rec IN okl_cdj_pvt.cdjv_rec_type,

754: -- PROCEDURE validate_subsidy_usage
755: -----------------------------------
756: PROCEDURE validate_subsidy_usage(p_asset_id IN NUMBER,
757: p_total_subsidy_amount IN NUMBER,
758: p_input_adj_rec IN okl_cdj_pvt.cdjv_rec_type,
759: x_return_status OUT NOCOPY VARCHAR2) IS
760:
761: l_program_name CONSTANT VARCHAR2(30) := 'validate_subsidy_usage';
762: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;

Line 829: l_input_adj_rec okl_cdj_pvt.cdjv_rec_type;

825: SELECT asset_number
826: FROM okl_assets_b
827: WHERE id = p_asset_id;
828:
829: l_input_adj_rec okl_cdj_pvt.cdjv_rec_type;
830:
831: BEGIN
832: l_input_adj_rec := p_input_adj_rec;
833:

Line 1906: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

1902: RAISE OKL_API.G_EXCEPTION_ERROR;
1903: END IF;
1904: END IF;
1905:
1906: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
1907: ,p_init_msg_list => G_FALSE
1908: ,x_return_status => x_return_status
1909: ,x_msg_count => x_msg_count
1910: ,x_msg_data => x_msg_data

Line 2233: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

2229: RAISE OKL_API.G_EXCEPTION_ERROR;
2230: END IF;
2231: END IF;
2232:
2233: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
2234: ,p_init_msg_list => G_FALSE
2235: ,x_return_status => x_return_status
2236: ,x_msg_count => x_msg_count
2237: ,x_msg_data => x_msg_data

Line 2439: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION

2435: RAISE OKL_API.G_EXCEPTION_ERROR;
2436: END IF;
2437:
2438: IF l_deleted_adjust_tbl.COUNT > 0 THEN
2439: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION
2440: ,p_init_msg_list => G_FALSE
2441: ,x_return_status => x_return_status
2442: ,x_msg_count => x_msg_count
2443: ,x_msg_data => x_msg_data

Line 2503: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

2499: RAISE OKL_API.G_EXCEPTION_ERROR;
2500: END IF;
2501: END IF;
2502:
2503: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
2504: ,p_init_msg_list => G_FALSE
2505: ,x_return_status => x_return_status
2506: ,x_msg_count => x_msg_count
2507: ,x_msg_data => x_msg_data

Line 2596: okl_cdj_pvt.update_row (p_api_version => G_API_VERSION

2592: RAISE OKL_API.G_EXCEPTION_ERROR;
2593: END IF;
2594: END IF;
2595:
2596: okl_cdj_pvt.update_row (p_api_version => G_API_VERSION
2597: ,p_init_msg_list => G_FALSE
2598: ,x_return_status => x_return_status
2599: ,x_msg_count => x_msg_count
2600: ,x_msg_data => x_msg_data

Line 2782: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION

2778: END IF;
2779: --Fix Bug # 4894844 end
2780: --Bug # 5142940 ssdeshpa end
2781: IF l_adj_assets_tbl.COUNT > 0 THEN
2782: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION
2783: ,p_init_msg_list => G_FALSE
2784: ,x_return_status => x_return_status
2785: ,x_msg_count => x_msg_count
2786: ,x_msg_data => x_msg_data

Line 4725: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

4721: RAISE OKL_API.G_EXCEPTION_ERROR;
4722: END IF;
4723: END IF;
4724:
4725: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
4726: ,p_init_msg_list => G_FALSE
4727: ,x_return_status => x_return_status
4728: ,x_msg_count => x_msg_count
4729: ,x_msg_data => x_msg_data