eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_APPROVAL_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 23: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

19: ,p_init_msg_list IN VARCHAR2
20: ,x_return_status OUT NOCOPY VARCHAR2
21: ,x_msg_count OUT NOCOPY NUMBER
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
24: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE
25: ,x_total_budgets OUT NOCOPY okl_subsidy_pools_b.total_budgets%TYPE) IS
26: CURSOR c_get_pool_details_csr IS
27: SELECT decision_status_code

Line 24: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE

20: ,x_return_status OUT NOCOPY VARCHAR2
21: ,x_msg_count OUT NOCOPY NUMBER
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
24: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE
25: ,x_total_budgets OUT NOCOPY okl_subsidy_pools_b.total_budgets%TYPE) IS
26: CURSOR c_get_pool_details_csr IS
27: SELECT decision_status_code
28: ,pool_type_code

Line 25: ,x_total_budgets OUT NOCOPY okl_subsidy_pools_b.total_budgets%TYPE) IS

21: ,x_msg_count OUT NOCOPY NUMBER
22: ,x_msg_data OUT NOCOPY VARCHAR2
23: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
24: ,x_pool_status OUT NOCOPY okl_subsidy_pools_b.decision_status_code%TYPE
25: ,x_total_budgets OUT NOCOPY okl_subsidy_pools_b.total_budgets%TYPE) IS
26: CURSOR c_get_pool_details_csr IS
27: SELECT decision_status_code
28: ,pool_type_code
29: ,subsidy_pool_name

Line 33: FROM okl_subsidy_pools_b

29: ,subsidy_pool_name
30: ,effective_from_date
31: ,effective_to_date
32: ,id
33: FROM okl_subsidy_pools_b
34: WHERE id = p_subsidy_pool_id;
35: cv_pool_details_csr c_get_pool_details_csr%ROWTYPE;
36:
37: CURSOR c_get_pool_line_number IS

Line 59: l_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;

55: WHERE subsidy_pool_id = p_subsidy_pool_id;
56: lv_dummy_var VARCHAR2(1);
57:
58: l_approval_process VARCHAR2(30);
59: l_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
60:
61: l_api_version CONSTANT NUMBER DEFAULT 1.0;
62: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_POOL_FOR_APPROVAL';
63:

Line 376: FROM okl_subsidy_pools_b pool

372: ,line.budget_amount
373: ,line.budget_type_code
374: ,line.decision_status_code line_status
375: ,line.id budget_line_id
376: FROM okl_subsidy_pools_b pool
377: ,okl_subsidy_pool_budgets_b line
378: WHERE pool.id = line.subsidy_pool_id
379: AND line.id = p_subsidy_pool_budget_id;
380: cv_get_pool_info c_get_pool_info_csr%ROWTYPE;

Line 385: lv_calc_total_budget okl_subsidy_pools_b.total_budgets%TYPE;

381:
382: l_approval_process VARCHAR2(30);
383:
384: l_budget_status okl_subsidy_pool_budgets_b.decision_status_code%TYPE;
385: lv_calc_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
386:
387: l_api_version CONSTANT NUMBER DEFAULT 1.0;
388: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_BUDGET_APPROVAL';
389: