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 2108: lv_comments wf_item_attribute_values.text_value%type;

2104: l_current_forward_to_username wf_users.name%type;
2105: lv_transaction_status varchar2(100);
2106: lv_approval_required varchar2(100);
2107: lv_result varchar2(100);
2108: lv_comments wf_item_attribute_values.text_value%type;
2109:
2110: begin
2111: g_debug := hr_utility.debug_enabled;
2112:

Line 2496: lv_comments wf_item_attribute_values.text_value%type;

2492: l_current_forward_to_username wf_users.name%type;
2493: lv_result_code WF_ITEM_ACTIVITY_STATUSES.activity_result_code%type;
2494: lv_result_display varchar2(250);
2495: lv_test_result_code varchar2(250);
2496: lv_comments wf_item_attribute_values.text_value%type;
2497: lv_new_transaction varchar2(240);
2498:
2499: begin
2500: g_debug := hr_utility.debug_enabled;

Line 3184: FROM wf_item_attribute_values

3180:
3181: -- Cursor to find if the person (selected for RFC) is an additional approver
3182: CURSOR cur_add_appr IS
3183: SELECT 'X'
3184: FROM wf_item_attribute_values
3185: WHERE item_type = p_item_Type
3186: AND item_key = p_item_Key
3187: AND name like 'ADDITIONAL_APPROVER_%'
3188: AND number_value = p_rfcUserOrigSystemId;

Line 3221: FROM wf_item_attribute_values

3217: )
3218: and approval_history_id > 0
3219: MINUS
3220: SELECT number_value
3221: FROM wf_item_attribute_values
3222: WHERE item_type = p_item_Type
3223: AND item_key = p_item_Key
3224: AND name like 'ADDITIONAL_APPROVER_%'
3225: )

Line 4631: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;

4627: lv_loginPersonUserName fnd_user.user_name%type;
4628: ln_loginPersonId fnd_user.employee_id%type;
4629: lv_item_type wf_items.item_type%type;
4630: lv_item_key wf_items.item_key%type;
4631: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
4632: begin
4633: if g_debug then
4634: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
4635: end if;

Line 4716: ln_activity_id wf_item_attribute_values.number_value%type;

4712:
4713: procedure resetWfPageFlowState(p_transaction_id in number)
4714: is
4715: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4716: ln_activity_id wf_item_attribute_values.number_value%type;
4717: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
4718: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
4719: begin
4720:

Line 4718: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;

4714: is
4715: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4716: ln_activity_id wf_item_attribute_values.number_value%type;
4717: ln_oaf_page_act_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;
4718: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
4719: begin
4720:
4721: if(p_transaction_id is not null) then
4722: begin

Line 4848: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;

4844: c_transaction_type varchar2(25);
4845: l_forward_from_display_name wf_users.display_name%type;
4846: l_forward_to_display_name wf_users.display_name%type;
4847: c_approver_to_notify_rec ame_util.approverRecord2;
4848: lv_ntf_sub_msg wf_item_attribute_values.text_value%type;
4849:
4850:
4851: begin
4852: