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 762: p_input_adj_rec IN okl_cdj_pvt.cdjv_rec_type,

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

Line 833: l_input_adj_rec okl_cdj_pvt.cdjv_rec_type;

829: SELECT asset_number
830: FROM okl_assets_b
831: WHERE id = p_asset_id;
832:
833: l_input_adj_rec okl_cdj_pvt.cdjv_rec_type;
834:
835: BEGIN
836: l_input_adj_rec := p_input_adj_rec;
837:

Line 1910: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

1906: RAISE OKL_API.G_EXCEPTION_ERROR;
1907: END IF;
1908: END IF;
1909:
1910: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
1911: ,p_init_msg_list => G_FALSE
1912: ,x_return_status => x_return_status
1913: ,x_msg_count => x_msg_count
1914: ,x_msg_data => x_msg_data

Line 2237: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

2233: RAISE OKL_API.G_EXCEPTION_ERROR;
2234: END IF;
2235: END IF;
2236:
2237: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
2238: ,p_init_msg_list => G_FALSE
2239: ,x_return_status => x_return_status
2240: ,x_msg_count => x_msg_count
2241: ,x_msg_data => x_msg_data

Line 2443: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION

2439: RAISE OKL_API.G_EXCEPTION_ERROR;
2440: END IF;
2441:
2442: IF l_deleted_adjust_tbl.COUNT > 0 THEN
2443: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION
2444: ,p_init_msg_list => G_FALSE
2445: ,x_return_status => x_return_status
2446: ,x_msg_count => x_msg_count
2447: ,x_msg_data => x_msg_data

Line 2507: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

2503: RAISE OKL_API.G_EXCEPTION_ERROR;
2504: END IF;
2505: END IF;
2506:
2507: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
2508: ,p_init_msg_list => G_FALSE
2509: ,x_return_status => x_return_status
2510: ,x_msg_count => x_msg_count
2511: ,x_msg_data => x_msg_data

Line 2600: okl_cdj_pvt.update_row (p_api_version => G_API_VERSION

2596: RAISE OKL_API.G_EXCEPTION_ERROR;
2597: END IF;
2598: END IF;
2599:
2600: okl_cdj_pvt.update_row (p_api_version => G_API_VERSION
2601: ,p_init_msg_list => G_FALSE
2602: ,x_return_status => x_return_status
2603: ,x_msg_count => x_msg_count
2604: ,x_msg_data => x_msg_data

Line 2786: okl_cdj_pvt.delete_row (p_api_version => G_API_VERSION

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

Line 4729: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION

4725: RAISE OKL_API.G_EXCEPTION_ERROR;
4726: END IF;
4727: END IF;
4728:
4729: okl_cdj_pvt.insert_row (p_api_version => G_API_VERSION
4730: ,p_init_msg_list => G_FALSE
4731: ,x_return_status => x_return_status
4732: ,x_msg_count => x_msg_count
4733: ,x_msg_data => x_msg_data