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_POOLS_B

Line 118: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;

114: END get_message;
115:
116: FUNCTION get_pool_msg_body(itemtype IN VARCHAR2
117: ,itemkey IN VARCHAR2) RETURN VARCHAR2 IS
118: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
119: lv_total_budget VARCHAR2(200);
120: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
121: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
122: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;

Line 120: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;

116: FUNCTION get_pool_msg_body(itemtype IN VARCHAR2
117: ,itemkey IN VARCHAR2) RETURN VARCHAR2 IS
118: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
119: lv_total_budget VARCHAR2(200);
120: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
121: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
122: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
123: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
124: lv_requestor VARCHAR2(100);

Line 121: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;

117: ,itemkey IN VARCHAR2) RETURN VARCHAR2 IS
118: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
119: lv_total_budget VARCHAR2(200);
120: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
121: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
122: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
123: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
124: lv_requestor VARCHAR2(100);
125: lv_message_body VARCHAR2(4000);

Line 122: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;

118: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
119: lv_total_budget VARCHAR2(200);
120: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
121: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;
122: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;
123: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
124: lv_requestor VARCHAR2(100);
125: lv_message_body VARCHAR2(4000);
126: BEGIN

Line 167: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;

163: END get_pool_msg_body;
164:
165: FUNCTION get_pool_line_msg_body(itemtype IN VARCHAR2
166: ,itemkey IN VARCHAR2) RETURN VARCHAR2 IS
167: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%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);

Line 169: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;

165: FUNCTION get_pool_line_msg_body(itemtype IN VARCHAR2
166: ,itemkey IN VARCHAR2) RETURN VARCHAR2 IS
167: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%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);

Line 170: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;

166: ,itemkey IN VARCHAR2) RETURN VARCHAR2 IS
167: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%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

Line 218: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;

214: ,message fnd_new_messages.message_name%TYPE
215: ,attrib wf_item_attributes.name%TYPE
216: ,pool_or_line IN VARCHAR2
217: ) IS
218: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
219: lv_total_budget VARCHAR2(200);
220: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
221:
222: BEGIN

Line 220: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;

216: ,pool_or_line IN VARCHAR2
217: ) IS
218: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
219: lv_total_budget VARCHAR2(200);
220: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;
221:
222: BEGIN
223: lv_currency_code := wf_engine.GetItemAttrText(itemtype => itemtype,
224: itemkey => itemkey,

Line 451: CURSOR c_get_bud_line_csr (cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS

447: ,itemkey IN VARCHAR2
448: ,actid IN NUMBER
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:

Line 459: lv_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

455:
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;

Line 669: CURSOR c_get_total_budget_csr (cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE) IS

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;
673: lv_approval_status VARCHAR2(10);

Line 671: FROM okl_subsidy_pools_b

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;
673: lv_approval_status VARCHAR2(10);
674: lv_approval_status_ame VARCHAR2(10);
675: lv_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

Line 675: lv_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

671: FROM okl_subsidy_pools_b
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;

Line 677: lv_total_budget okl_subsidy_pools_b.total_budgets%TYPE;

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);
681: x_msg_data VARCHAR2(1000);

Line 892: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;

888: l_api_name CONSTANT VARCHAR2(200) DEFAULT 'get_subsidy_pool_approver';
889:
890: l_user_id VARCHAR2(200);
891: lv_receiving_event wf_events.name%TYPE;
892: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
893: lv_total_budget VARCHAR2(200);
894: lv_currency_code okl_subsidy_pools_b.currency_code%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;

Line 894: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;

890: l_user_id VARCHAR2(200);
891: lv_receiving_event wf_events.name%TYPE;
892: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
893: lv_total_budget VARCHAR2(200);
894: lv_currency_code okl_subsidy_pools_b.currency_code%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);

Line 895: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;

891: lv_receiving_event wf_events.name%TYPE;
892: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
893: lv_total_budget VARCHAR2(200);
894: lv_currency_code okl_subsidy_pools_b.currency_code%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;

Line 896: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;

892: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
893: lv_total_budget VARCHAR2(200);
894: lv_currency_code okl_subsidy_pools_b.currency_code%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:

Line 1029: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;

1025: ,funcmode IN VARCHAR2
1026: ,resultout OUT NOCOPY VARCHAR2) IS
1027: lv_approval_status VARCHAR2(10);
1028: lv_receiving_event wf_events.name%TYPE;
1029: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
1030: lv_total_budget VARCHAR2(200);
1031: lv_currency_code okl_subsidy_pools_b.currency_code%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;

Line 1031: lv_currency_code okl_subsidy_pools_b.currency_code%TYPE;

1027: lv_approval_status VARCHAR2(10);
1028: lv_receiving_event wf_events.name%TYPE;
1029: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
1030: lv_total_budget VARCHAR2(200);
1031: lv_currency_code okl_subsidy_pools_b.currency_code%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);

Line 1032: lv_from_date okl_subsidy_pools_b.effective_from_date%TYPE;

1028: lv_receiving_event wf_events.name%TYPE;
1029: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
1030: lv_total_budget VARCHAR2(200);
1031: lv_currency_code okl_subsidy_pools_b.currency_code%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;

Line 1033: lv_to_date okl_subsidy_pools_b.effective_to_date%TYPE;

1029: lv_pool_name okl_subsidy_pools_b.subsidy_pool_name%TYPE;
1030: lv_total_budget VARCHAR2(200);
1031: lv_currency_code okl_subsidy_pools_b.currency_code%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';

Line 1280: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE) IS

1276: ,p_init_msg_list IN VARCHAR2
1277: ,x_return_status OUT NOCOPY VARCHAR2
1278: ,x_msg_count OUT NOCOPY NUMBER
1279: ,x_msg_data OUT NOCOPY VARCHAR2
1280: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE) IS
1281:
1282: l_api_name CONSTANT VARCHAR2(150) DEFAULT 'raise_pool_event';
1283: l_parameter_list wf_parameter_list_t;
1284: l_approval_option VARCHAR2(10);

Line 1289: CURSOR c_get_pool_info_csr (cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS

1285: l_requester VARCHAR2(200);
1286: l_name VARCHAR2(200);
1287: -- cursor to fetch the initial budget amount and the pool details
1288: -- at this point of approval, only one budget line is allowed.
1289: CURSOR c_get_pool_info_csr (cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE)IS
1290: SELECT pool.subsidy_pool_name
1291: ,pool.effective_from_date
1292: ,pool.effective_to_date
1293: ,pool.total_budgets

Line 1511: FROM okl_subsidy_pools_b sub

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