DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_WF dependencies on FND_LOOKUPS

Line 172: lv_budget_type fnd_lookups.meaning%TYPE;

168: lv_total_budget VARCHAR2(200);
169: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
170: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
171: lv_requestor VARCHAR2(100);
172: lv_budget_type fnd_lookups.meaning%TYPE;
173: lv_message_body VARCHAR2(4000);
174: BEGIN
175: lv_pool_name := wf_engine.GetItemAttrText(itemtype => itemtype,
176: itemkey => itemkey,

Line 464: lv_decision_status_code fnd_lookups.lookup_code%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;
465: l_api_name CONSTANT VARCHAR2(60) DEFAULT 'update_pool_status';
466: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.UPDATE_POOL_APPROVAL_STATUS';
467: l_debug_enabled VARCHAR2(10);
468: is_debug_procedure_on BOOLEAN;

Line 679: lv_decision_status_code fnd_lookups.lookup_code%TYPE;

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);
681: x_msg_data VARCHAR2(1000);
682: x_msg_count NUMBER;
683: l_api_name CONSTANT VARCHAR2(60) DEFAULT 'update_line_status';

Line 899: lv_budget_type fnd_lookups.meaning%TYPE;

895: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
896: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
897: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
898: lv_requestor VARCHAR2(100);
899: lv_budget_type fnd_lookups.meaning%TYPE;
900:
901: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.GET_SUBSIDY_POOL_APPROVER';
902: l_debug_enabled VARCHAR2(10);
903: is_debug_procedure_on BOOLEAN;

Line 1036: lv_budget_type fnd_lookups.meaning%TYPE;

1032: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
1033: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
1034: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
1035: lv_approver VARCHAR2(100);
1036: lv_budget_type fnd_lookups.meaning%TYPE;
1037: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'set_msg_attributes';
1038:
1039: l_module CONSTANT fnd_log_messages.module%TYPE DEFAULT'okl.plsql.OKL_SUBSIDY_POOL_WF.SET_MSG_ATTRIBUTES';
1040: l_debug_enabled VARCHAR2(10);