APPS.HR_APPROVAL_SS dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 21: from wf_item_attribute_values wiav

17: ,p_item_key in varchar2
18: ,p_name in varchar2)
19: IS
20: select 1
21: from wf_item_attribute_values wiav
22: where wiav.item_type = p_item_type
23: and wiav.item_key = p_item_key
24: and wiav.name = p_name;
25:

Line 200: lv_comments wf_item_attribute_values.text_value%type;

196: l_current_forward_to_username wf_users.name%type;
197: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
198: lv_result_display varchar2(250);
199: lv_test_result_code varchar2(250);
200: lv_comments wf_item_attribute_values.text_value%type;
201: lv_recipient varchar2(250);
202: lv_new_transaction varchar2(250);
203: l_cpersonId VARCHAR2(15);
204: begin

Line 2893: lv_comments wf_item_attribute_values.text_value%type;

2889: l_current_forward_to_username wf_users.name%type;
2890: lv_transaction_status varchar2(100);
2891: lv_approval_required varchar2(100);
2892: lv_result varchar2(100);
2893: lv_comments wf_item_attribute_values.text_value%type;
2894:
2895: begin
2896: g_debug := hr_utility.debug_enabled;
2897:

Line 3332: lv_comments wf_item_attribute_values.text_value%type;

3328: l_current_forward_to_username wf_users.name%type;
3329: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
3330: lv_result_display varchar2(250);
3331: lv_test_result_code varchar2(250);
3332: lv_comments wf_item_attribute_values.text_value%type;
3333: lv_new_transaction varchar2(240);
3334: l_cpersonId VARCHAR2(30); --added for bug 13485539
3335: l_is_parallel varchar2(10) := null;
3336: prll_ntf varchar2(600) := null;

Line 4195: FROM wf_item_attribute_values

4191:
4192: -- Cursor to find if the person (selected for RFC) is an additional approver
4193: CURSOR cur_add_appr IS
4194: SELECT 'X'
4195: FROM wf_item_attribute_values
4196: WHERE item_type = p_item_Type
4197: AND item_key = p_item_Key
4198: AND name like 'ADDITIONAL_APPROVER_%'
4199: AND number_value = p_rfcUserOrigSystemId;

Line 4232: FROM wf_item_attribute_values

4228: )
4229: and approval_history_id > 0
4230: MINUS
4231: SELECT number_value
4232: FROM wf_item_attribute_values
4233: WHERE item_type = p_item_Type
4234: AND item_key = p_item_Key
4235: AND name like 'ADDITIONAL_APPROVER_%'
4236: )

Line 5679: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;

5675: lv_loginPersonUserName fnd_user.user_name%type;
5676: ln_loginPersonId fnd_user.employee_id%type;
5677: lv_item_type wf_items.item_type%type;
5678: lv_item_key wf_items.item_key%type;
5679: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
5680: begin
5681: if g_debug then
5682: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
5683: end if;

Line 5764: ln_activity_id wf_item_attribute_values.number_value%type;

5760:
5761: procedure resetWfPageFlowState(p_transaction_id in number)
5762: is
5763: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5764: ln_activity_id wf_item_attribute_values.number_value%type;
5765: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
5766: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
5767: begin
5768:

Line 5766: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;

5762: is
5763: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5764: ln_activity_id wf_item_attribute_values.number_value%type;
5765: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
5766: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
5767: begin
5768:
5769: if(p_transaction_id is not null) then
5770: begin

Line 5896: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;

5892: c_transaction_type varchar2(25);
5893: l_forward_from_display_name wf_users.display_name%type;
5894: l_forward_to_display_name wf_users.display_name%type;
5895: c_approver_to_notify_rec ame_util.approverRecord2;
5896: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
5897:
5898:
5899: begin
5900: