APPS.HR_APPROVAL_SS dependencies on WF_ROLES

Line 1619: lv_role_name wf_roles.name%type;

1615: end updateApprovalHistory;
1616:
1617: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
1618: p_item_key in wf_items.item_key%type) is
1619: lv_role_name wf_roles.name%type;
1620: lv_role_disp_name wf_roles.name%type;
1621: lv_role_orig_system wf_roles.orig_system%type;
1622: lv_role_orig_sys_id wf_roles.orig_system_id%type;
1623: begin

Line 1620: lv_role_disp_name wf_roles.name%type;

1616:
1617: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
1618: p_item_key in wf_items.item_key%type) is
1619: lv_role_name wf_roles.name%type;
1620: lv_role_disp_name wf_roles.name%type;
1621: lv_role_orig_system wf_roles.orig_system%type;
1622: lv_role_orig_sys_id wf_roles.orig_system_id%type;
1623: begin
1624:

Line 1621: lv_role_orig_system wf_roles.orig_system%type;

1617: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
1618: p_item_key in wf_items.item_key%type) is
1619: lv_role_name wf_roles.name%type;
1620: lv_role_disp_name wf_roles.name%type;
1621: lv_role_orig_system wf_roles.orig_system%type;
1622: lv_role_orig_sys_id wf_roles.orig_system_id%type;
1623: begin
1624:
1625: -- FORWARD_TO_PERSON_ID

Line 1622: lv_role_orig_sys_id wf_roles.orig_system_id%type;

1618: p_item_key in wf_items.item_key%type) is
1619: lv_role_name wf_roles.name%type;
1620: lv_role_disp_name wf_roles.name%type;
1621: lv_role_orig_system wf_roles.orig_system%type;
1622: lv_role_orig_sys_id wf_roles.orig_system_id%type;
1623: begin
1624:
1625: -- FORWARD_TO_PERSON_ID
1626: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',true);

Line 2347: select orig_system,orig_system_id,display_name from wf_roles where name = wf_engine.context_new_role;

2343: l_new_orig_system varchar2(30);
2344: l_new_fwd_display_name varchar2(360);
2345:
2346: cursor get_person_info is
2347: select orig_system,orig_system_id,display_name from wf_roles where name = wf_engine.context_new_role;
2348:
2349: /* cursor get_name_info is
2350: select last_name,first_name from per_all_people_f where
2351: person_id = l_new_fwd_person_id;*/

Line 2659: l_curr_approver_role wf_roles.name%type;

2655: c_proc constant varchar2(60) := 'reset_approval_rfc_data';
2656: c_return_user wf_users.name%Type;
2657: c_creator_user wf_users.name%Type;
2658: l_approvalProcessVersion varchar2(10);
2659: l_curr_approver_role wf_roles.name%type;
2660: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
2661: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
2662:
2663: begin

Line 2846: lv_creatorUserName wf_roles.name%type;

2842: c_transaction_type varchar2(25);
2843: c_next_approvers ame_util.approverstable2;
2844: c_approvalprocesscompleteynout ame_util.charType;
2845: l_current_forward_to_username wf_users.name%type;
2846: lv_creatorUserName wf_roles.name%type;
2847: lv_rfcUserName wf_roles.name%type;
2848: lv_customRFC varchar2(5);
2849:
2850: lv_dynamicQuery varchar2(4000) ;

Line 2847: lv_rfcUserName wf_roles.name%type;

2843: c_next_approvers ame_util.approverstable2;
2844: c_approvalprocesscompleteynout ame_util.charType;
2845: l_current_forward_to_username wf_users.name%type;
2846: lv_creatorUserName wf_roles.name%type;
2847: lv_rfcUserName wf_roles.name%type;
2848: lv_customRFC varchar2(5);
2849:
2850: lv_dynamicQuery varchar2(4000) ;
2851: lv_queryProcedure varchar2(4000);

Line 3033: lv_orig_systemId wf_roles.orig_system_id%type;

3029: c_proc constant varchar2(30) := 'isApproverEditAllowed';
3030: lv_role_displayName wf_users.display_name%type;
3031: lv_roleName wf_users.name%type;
3032: lv_businessGroupId per_all_people_f.business_group_id%type;
3033: lv_orig_systemId wf_roles.orig_system_id%type;
3034: lv_orig_system wf_roles.orig_system%type;
3035: lv_creator_person_id hr_api_transactions.creator_person_id%type;
3036: begin
3037: g_debug := hr_utility.debug_enabled;

Line 3034: lv_orig_system wf_roles.orig_system%type;

3030: lv_role_displayName wf_users.display_name%type;
3031: lv_roleName wf_users.name%type;
3032: lv_businessGroupId per_all_people_f.business_group_id%type;
3033: lv_orig_systemId wf_roles.orig_system_id%type;
3034: lv_orig_system wf_roles.orig_system%type;
3035: lv_creator_person_id hr_api_transactions.creator_person_id%type;
3036: begin
3037: g_debug := hr_utility.debug_enabled;
3038: if g_debug then

Line 3093: return wf_roles.parent_orig_system%type is

3089:
3090: end isApproverEditAllowed;
3091:
3092: function getuserOrigSystem(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
3093: return wf_roles.parent_orig_system%type is
3094: -- local variables
3095: c_proc constant varchar2(30) := 'getuserOrigSystem';
3096: lv_orig_system wf_roles.parent_orig_system%type;
3097: lv_orig_system_id wf_roles.orig_system_id%type;

Line 3096: lv_orig_system wf_roles.parent_orig_system%type;

3092: function getuserOrigSystem(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
3093: return wf_roles.parent_orig_system%type is
3094: -- local variables
3095: c_proc constant varchar2(30) := 'getuserOrigSystem';
3096: lv_orig_system wf_roles.parent_orig_system%type;
3097: lv_orig_system_id wf_roles.orig_system_id%type;
3098: lv_user_name wf_roles.name%type;
3099: begin
3100: g_debug := hr_utility.debug_enabled;

Line 3097: lv_orig_system_id wf_roles.orig_system_id%type;

3093: return wf_roles.parent_orig_system%type is
3094: -- local variables
3095: c_proc constant varchar2(30) := 'getuserOrigSystem';
3096: lv_orig_system wf_roles.parent_orig_system%type;
3097: lv_orig_system_id wf_roles.orig_system_id%type;
3098: lv_user_name wf_roles.name%type;
3099: begin
3100: g_debug := hr_utility.debug_enabled;
3101: if g_debug then

Line 3098: lv_user_name wf_roles.name%type;

3094: -- local variables
3095: c_proc constant varchar2(30) := 'getuserOrigSystem';
3096: lv_orig_system wf_roles.parent_orig_system%type;
3097: lv_orig_system_id wf_roles.orig_system_id%type;
3098: lv_user_name wf_roles.name%type;
3099: begin
3100: g_debug := hr_utility.debug_enabled;
3101: if g_debug then
3102: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 3127: return wf_roles.orig_system_id%type is

3123:
3124: end getuserOrigSystem;
3125:
3126: function getUserOrigSystemId(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
3127: return wf_roles.orig_system_id%type is
3128: -- local variables
3129: c_proc constant varchar2(30) := 'getUserOrigSystemId';
3130: lv_orig_system wf_roles.parent_orig_system%type;
3131: lv_orig_system_id wf_roles.orig_system_id%type;

Line 3130: lv_orig_system wf_roles.parent_orig_system%type;

3126: function getUserOrigSystemId(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
3127: return wf_roles.orig_system_id%type is
3128: -- local variables
3129: c_proc constant varchar2(30) := 'getUserOrigSystemId';
3130: lv_orig_system wf_roles.parent_orig_system%type;
3131: lv_orig_system_id wf_roles.orig_system_id%type;
3132: lv_user_name wf_roles.name%type;
3133: begin
3134: g_debug := hr_utility.debug_enabled;

Line 3131: lv_orig_system_id wf_roles.orig_system_id%type;

3127: return wf_roles.orig_system_id%type is
3128: -- local variables
3129: c_proc constant varchar2(30) := 'getUserOrigSystemId';
3130: lv_orig_system wf_roles.parent_orig_system%type;
3131: lv_orig_system_id wf_roles.orig_system_id%type;
3132: lv_user_name wf_roles.name%type;
3133: begin
3134: g_debug := hr_utility.debug_enabled;
3135: if g_debug then

Line 3132: lv_user_name wf_roles.name%type;

3128: -- local variables
3129: c_proc constant varchar2(30) := 'getUserOrigSystemId';
3130: lv_orig_system wf_roles.parent_orig_system%type;
3131: lv_orig_system_id wf_roles.orig_system_id%type;
3132: lv_user_name wf_roles.name%type;
3133: begin
3134: g_debug := hr_utility.debug_enabled;
3135: if g_debug then
3136: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 3165: p_rfcRoleName in wf_roles.name%type,

3161: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,
3162: p_transaction_id in hr_api_transactions.transaction_id%type,
3163: p_item_type in wf_items.item_type%type,
3164: p_item_key in wf_items.item_key%type,
3165: p_rfcRoleName in wf_roles.name%type,
3166: p_rfcUserOrigSystem in wf_roles.orig_system%type,
3167: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
3168: p_rfc_comments in varchar2,
3169: p_approverIndex in number

Line 3166: p_rfcUserOrigSystem in wf_roles.orig_system%type,

3162: p_transaction_id in hr_api_transactions.transaction_id%type,
3163: p_item_type in wf_items.item_type%type,
3164: p_item_key in wf_items.item_key%type,
3165: p_rfcRoleName in wf_roles.name%type,
3166: p_rfcUserOrigSystem in wf_roles.orig_system%type,
3167: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
3168: p_rfc_comments in varchar2,
3169: p_approverIndex in number
3170: ) is

Line 3167: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,

3163: p_item_type in wf_items.item_type%type,
3164: p_item_key in wf_items.item_key%type,
3165: p_rfcRoleName in wf_roles.name%type,
3166: p_rfcUserOrigSystem in wf_roles.orig_system%type,
3167: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
3168: p_rfc_comments in varchar2,
3169: p_approverIndex in number
3170: ) is
3171: -- local variables

Line 3176: lv_role_name wf_roles.name%type;

3172: c_proc constant varchar2(30) := 'handleRFCAction';
3173: ln_rfc_notification_id wf_notifications.notification_id%type;
3174: l_lastDefaultApprover NUMBER;
3175: lv_dummy varchar2(10);
3176: lv_role_name wf_roles.name%type;
3177: lv_role_disp_name wf_roles.name%type;
3178: l_return_status varchar2(10);
3179: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3180:

Line 3177: lv_role_disp_name wf_roles.name%type;

3173: ln_rfc_notification_id wf_notifications.notification_id%type;
3174: l_lastDefaultApprover NUMBER;
3175: lv_dummy varchar2(10);
3176: lv_role_name wf_roles.name%type;
3177: lv_role_disp_name wf_roles.name%type;
3178: l_return_status varchar2(10);
3179: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3180:
3181: -- Cursor to find if the person (selected for RFC) is an additional approver

Line 3179: lv_role_orig_sys_id wf_roles.orig_system_id%type;

3175: lv_dummy varchar2(10);
3176: lv_role_name wf_roles.name%type;
3177: lv_role_disp_name wf_roles.name%type;
3178: l_return_status varchar2(10);
3179: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3180:
3181: -- Cursor to find if the person (selected for RFC) is an additional approver
3182: CURSOR cur_add_appr IS
3183: SELECT 'X'

Line 3444: lv_creator_role wf_roles.name%type;

3440: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type
3441: ) is
3442: lv_item_type wf_items.item_type%type;
3443: lv_item_key wf_items.item_key%type;
3444: lv_creator_role wf_roles.name%type;
3445: lv_creator_orig_system wf_roles.orig_system%type;
3446: lv_creator_orig_sys_id wf_roles.orig_system_id%type;
3447: begin
3448: hr_workflow_ss.get_item_type_and_key(p_approval_notification_id,lv_item_type,lv_item_key);

Line 3445: lv_creator_orig_system wf_roles.orig_system%type;

3441: ) is
3442: lv_item_type wf_items.item_type%type;
3443: lv_item_key wf_items.item_key%type;
3444: lv_creator_role wf_roles.name%type;
3445: lv_creator_orig_system wf_roles.orig_system%type;
3446: lv_creator_orig_sys_id wf_roles.orig_system_id%type;
3447: begin
3448: hr_workflow_ss.get_item_type_and_key(p_approval_notification_id,lv_item_type,lv_item_key);
3449:

Line 3446: lv_creator_orig_sys_id wf_roles.orig_system_id%type;

3442: lv_item_type wf_items.item_type%type;
3443: lv_item_key wf_items.item_key%type;
3444: lv_creator_role wf_roles.name%type;
3445: lv_creator_orig_system wf_roles.orig_system%type;
3446: lv_creator_orig_sys_id wf_roles.orig_system_id%type;
3447: begin
3448: hr_workflow_ss.get_item_type_and_key(p_approval_notification_id,lv_item_type,lv_item_key);
3449:
3450: -- fix for bug 4481775

Line 3489: lv_role_name wf_roles.name%type;

3485: end handleRFCAction;
3486:
3487: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
3488: p_item_key in wf_items.item_key%type) is
3489: lv_role_name wf_roles.name%type;
3490: lv_role_disp_name wf_roles.name%type;
3491: lv_role_orig_system wf_roles.orig_system%type;
3492: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3493: begin

Line 3490: lv_role_disp_name wf_roles.name%type;

3486:
3487: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
3488: p_item_key in wf_items.item_key%type) is
3489: lv_role_name wf_roles.name%type;
3490: lv_role_disp_name wf_roles.name%type;
3491: lv_role_orig_system wf_roles.orig_system%type;
3492: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3493: begin
3494:

Line 3491: lv_role_orig_system wf_roles.orig_system%type;

3487: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
3488: p_item_key in wf_items.item_key%type) is
3489: lv_role_name wf_roles.name%type;
3490: lv_role_disp_name wf_roles.name%type;
3491: lv_role_orig_system wf_roles.orig_system%type;
3492: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3493: begin
3494:
3495: -- CREATOR_PERSON_ID

Line 3492: lv_role_orig_sys_id wf_roles.orig_system_id%type;

3488: p_item_key in wf_items.item_key%type) is
3489: lv_role_name wf_roles.name%type;
3490: lv_role_disp_name wf_roles.name%type;
3491: lv_role_orig_system wf_roles.orig_system%type;
3492: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3493: begin
3494:
3495: -- CREATOR_PERSON_ID
3496: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'CREATOR_PERSON_ID',true);

Line 3533: lv_role_name wf_roles.name%type;

3529:
3530:
3531: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
3532: p_item_key in wf_items.item_key%type) is
3533: lv_role_name wf_roles.name%type;
3534: lv_role_disp_name wf_roles.name%type;
3535: lv_role_orig_system wf_roles.orig_system%type;
3536: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3537: begin

Line 3534: lv_role_disp_name wf_roles.name%type;

3530:
3531: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
3532: p_item_key in wf_items.item_key%type) is
3533: lv_role_name wf_roles.name%type;
3534: lv_role_disp_name wf_roles.name%type;
3535: lv_role_orig_system wf_roles.orig_system%type;
3536: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3537: begin
3538:

Line 3535: lv_role_orig_system wf_roles.orig_system%type;

3531: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
3532: p_item_key in wf_items.item_key%type) is
3533: lv_role_name wf_roles.name%type;
3534: lv_role_disp_name wf_roles.name%type;
3535: lv_role_orig_system wf_roles.orig_system%type;
3536: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3537: begin
3538:
3539: -- CURRENT_PERSON_ID

Line 3536: lv_role_orig_sys_id wf_roles.orig_system_id%type;

3532: p_item_key in wf_items.item_key%type) is
3533: lv_role_name wf_roles.name%type;
3534: lv_role_disp_name wf_roles.name%type;
3535: lv_role_orig_system wf_roles.orig_system%type;
3536: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3537: begin
3538:
3539: -- CURRENT_PERSON_ID
3540: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);

Line 3565: lv_role_name wf_roles.name%type;

3561: end selPersonRoleReInit;
3562:
3563: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
3564: p_item_key in wf_items.item_key%type) is
3565: lv_role_name wf_roles.name%type;
3566: lv_role_disp_name wf_roles.name%type;
3567: lv_role_orig_system wf_roles.orig_system%type;
3568: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3569: begin

Line 3566: lv_role_disp_name wf_roles.name%type;

3562:
3563: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
3564: p_item_key in wf_items.item_key%type) is
3565: lv_role_name wf_roles.name%type;
3566: lv_role_disp_name wf_roles.name%type;
3567: lv_role_orig_system wf_roles.orig_system%type;
3568: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3569: begin
3570:

Line 3567: lv_role_orig_system wf_roles.orig_system%type;

3563: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
3564: p_item_key in wf_items.item_key%type) is
3565: lv_role_name wf_roles.name%type;
3566: lv_role_disp_name wf_roles.name%type;
3567: lv_role_orig_system wf_roles.orig_system%type;
3568: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3569: begin
3570:
3571: -- FORWARD_FROM_PERSON_ID

Line 3568: lv_role_orig_sys_id wf_roles.orig_system_id%type;

3564: p_item_key in wf_items.item_key%type) is
3565: lv_role_name wf_roles.name%type;
3566: lv_role_disp_name wf_roles.name%type;
3567: lv_role_orig_system wf_roles.orig_system%type;
3568: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3569: begin
3570:
3571: -- FORWARD_FROM_PERSON_ID
3572: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_FROM_PERSON_ID',true);

Line 3603: lv_role_name wf_roles.name%type;

3599:
3600:
3601: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
3602: p_item_key in wf_items.item_key%type) is
3603: lv_role_name wf_roles.name%type;
3604: lv_role_disp_name wf_roles.name%type;
3605: lv_role_orig_system wf_roles.orig_system%type;
3606: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3607: begin

Line 3604: lv_role_disp_name wf_roles.name%type;

3600:
3601: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
3602: p_item_key in wf_items.item_key%type) is
3603: lv_role_name wf_roles.name%type;
3604: lv_role_disp_name wf_roles.name%type;
3605: lv_role_orig_system wf_roles.orig_system%type;
3606: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3607: begin
3608:

Line 3605: lv_role_orig_system wf_roles.orig_system%type;

3601: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
3602: p_item_key in wf_items.item_key%type) is
3603: lv_role_name wf_roles.name%type;
3604: lv_role_disp_name wf_roles.name%type;
3605: lv_role_orig_system wf_roles.orig_system%type;
3606: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3607: begin
3608:
3609: -- RETURN_TO_USER_ORIG_SYS_ID

Line 3606: lv_role_orig_sys_id wf_roles.orig_system_id%type;

3602: p_item_key in wf_items.item_key%type) is
3603: lv_role_name wf_roles.name%type;
3604: lv_role_disp_name wf_roles.name%type;
3605: lv_role_orig_system wf_roles.orig_system%type;
3606: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3607: begin
3608:
3609: -- RETURN_TO_USER_ORIG_SYS_ID
3610: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'RETURN_TO_USER_ORIG_SYS_ID',true);

Line 3641: lv_role_name wf_roles.name%type;

3637:
3638:
3639: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
3640: p_item_key in wf_items.item_key%type) is
3641: lv_role_name wf_roles.name%type;
3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;

Line 3642: lv_role_disp_name wf_roles.name%type;

3638:
3639: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
3640: p_item_key in wf_items.item_key%type) is
3641: lv_role_name wf_roles.name%type;
3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;
3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;

Line 3643: lv_role_orig_system wf_roles.orig_system%type;

3639: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
3640: p_item_key in wf_items.item_key%type) is
3641: lv_role_name wf_roles.name%type;
3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;
3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
3647: l_appraiser_person_id per_appraisals.appraiser_person_id%type;

Line 3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;

3640: p_item_key in wf_items.item_key%type) is
3641: lv_role_name wf_roles.name%type;
3642: lv_role_disp_name wf_roles.name%type;
3643: lv_role_orig_system wf_roles.orig_system%type;
3644: lv_role_orig_sys_id wf_roles.orig_system_id%type;
3645: l_appraisal_id per_appraisals.appraisal_id%type;
3646: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
3647: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
3648: l_appraisee_person_id per_appraisals.appraisee_person_id%type;

Line 4023: l_role_name wf_roles.name%type;

4019: lv_errorActid wf_item_activity_statuses.process_activity%type;
4020: lv_errname VARCHAR2(4000);
4021: l_index binary_integer;
4022: l_temp_item_attribute varchar2(2000);
4023: l_role_name wf_roles.name%type;
4024: l_role_displayname wf_roles.display_name%type;
4025: l_current_person_name per_all_people_f.full_name%type;
4026: l_manager_id per_all_people_f.person_id%type;
4027: begin

Line 4024: l_role_displayname wf_roles.display_name%type;

4020: lv_errname VARCHAR2(4000);
4021: l_index binary_integer;
4022: l_temp_item_attribute varchar2(2000);
4023: l_role_name wf_roles.name%type;
4024: l_role_displayname wf_roles.display_name%type;
4025: l_current_person_name per_all_people_f.full_name%type;
4026: l_manager_id per_all_people_f.person_id%type;
4027: begin
4028: g_debug := hr_utility.debug_enabled;