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_WF dependencies on OKL_SUBSIDY_POOL_BUDGETS_B

Line 453: FROM okl_subsidy_pool_budgets_b

449: ,funcmode IN VARCHAR2
450: ,resultout OUT NOCOPY VARCHAR2) IS
451: CURSOR c_get_bud_line_csr (cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS
452: SELECT id
453: FROM okl_subsidy_pool_budgets_b
454: WHERE subsidy_pool_id = cp_subsidy_pool_id;
455:
456: lv_approval_status VARCHAR2(10);
457: lv_approval_status_ame VARCHAR2(10);

Line 460: lv_budget_line_id okl_subsidy_pool_budgets_b.id%TYPE;

456: lv_approval_status VARCHAR2(10);
457: lv_approval_status_ame VARCHAR2(10);
458: lv_total_budget VARCHAR2(200);
459: lv_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
460: lv_budget_line_id okl_subsidy_pool_budgets_b.id%TYPE;
461: x_return_status VARCHAR2(10);
462: x_msg_data VARCHAR2(1000);
463: x_msg_count NUMBER;
464: lv_decision_status_code fnd_lookups.lookup_code%TYPE;

Line 668: lv_budget_type_code okl_subsidy_pool_budgets_b.budget_type_code%TYPE;

664: ,itemkey IN VARCHAR2
665: ,actid IN NUMBER
666: ,funcmode IN VARCHAR2
667: ,resultout OUT NOCOPY VARCHAR2) IS
668: lv_budget_type_code okl_subsidy_pool_budgets_b.budget_type_code%TYPE;
669: CURSOR c_get_total_budget_csr (cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE) IS
670: SELECT total_budgets
671: FROM okl_subsidy_pools_b
672: WHERE id = cp_subsidy_pool_id;

Line 676: lv_budget_line_id okl_subsidy_pool_budgets_b.id%TYPE;

672: WHERE id = cp_subsidy_pool_id;
673: lv_approval_status VARCHAR2(10);
674: lv_approval_status_ame VARCHAR2(10);
675: lv_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
676: lv_budget_line_id okl_subsidy_pool_budgets_b.id%TYPE;
677: lv_total_budget okl_subsidy_pools_b.total_budgets%TYPE;
678: lv_line_amount NUMBER;
679: lv_decision_status_code fnd_lookups.lookup_code%TYPE;
680: x_return_status VARCHAR2(10);

Line 1298: ,okl_subsidy_pool_budgets_b bud

1294: ,pool.currency_code
1295: ,pool.short_description
1296: ,bud.budget_amount
1297: FROM okl_subsidy_pools_v pool
1298: ,okl_subsidy_pool_budgets_b bud
1299: WHERE pool.id = cp_subsidy_pool_id
1300: AND pool.id = bud.subsidy_pool_id;
1301: cv_get_pool_info c_get_pool_info_csr%ROWTYPE;
1302:

Line 1491: ,p_subsidy_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE) IS

1487: ,p_init_msg_list IN VARCHAR2
1488: ,x_return_status OUT NOCOPY VARCHAR2
1489: ,x_msg_count OUT NOCOPY NUMBER
1490: ,x_msg_data OUT NOCOPY VARCHAR2
1491: ,p_subsidy_pool_budget_id IN okl_subsidy_pool_budgets_b.id%TYPE) IS
1492: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'raise_budget_event';
1493: l_parameter_list wf_parameter_list_t;
1494: l_approval_option VARCHAR2(10);
1495: l_requester VARCHAR2(200);

Line 1499: CURSOR c_get_budget_info_csr (cp_pool_budget_id okl_subsidy_pool_budgets_b.id%TYPE) IS

1495: l_requester VARCHAR2(200);
1496: l_name VARCHAR2(200);
1497: lv_wf_item_key NUMBER;
1498:
1499: CURSOR c_get_budget_info_csr (cp_pool_budget_id okl_subsidy_pool_budgets_b.id%TYPE) IS
1500: SELECT sub.subsidy_pool_name
1501: ,sub.id subsidy_pool_id
1502: ,sub.effective_from_date pool_start_date
1503: ,sub.effective_to_date

Line 1510: ,okl_subsidy_pool_budgets_b bud

1506: ,bud.effective_from_date budget_line_date
1507: ,bud.budget_amount
1508: ,sub.currency_code
1509: FROM okl_subsidy_pools_b sub
1510: ,okl_subsidy_pool_budgets_b bud
1511: WHERE bud.subsidy_pool_id = sub.id
1512: AND bud.id = cp_pool_budget_id;
1513: cv_get_budget_info c_get_budget_info_csr%ROWTYPE;
1514: