APPS.HR_APPROVAL_SS dependencies on WF_ROLES

Line 658: select display_name into l_current_forward_to_disp_name from wf_roles where name = l_current_forward_to_username;

654:
655:
656: end if;
657:
658: select display_name into l_current_forward_to_disp_name from wf_roles where name = l_current_forward_to_username;
659: if(l_current_forward_to_disp_name is null) then
660: l_current_forward_to_disp_name := fnd_global.user_name;
661: end if;
662:

Line 1815: l_role_name wf_roles.name%TYPE;

1811: c_approver_to_notify_rec ame_util.approverRecord2;
1812: error_message_text varchar2(2000);
1813:
1814: l_is_parallel varchar2(10) := null;
1815: l_role_name wf_roles.name%TYPE;
1816: l_role_display wf_roles.display_name%TYPE;
1817: l_role_exists varchar2(1);
1818: l_users varchar2(1000) := null;
1819:

Line 1816: l_role_display wf_roles.display_name%TYPE;

1812: error_message_text varchar2(2000);
1813:
1814: l_is_parallel varchar2(10) := null;
1815: l_role_name wf_roles.name%TYPE;
1816: l_role_display wf_roles.display_name%TYPE;
1817: l_role_exists varchar2(1);
1818: l_users varchar2(1000) := null;
1819:
1820: CURSOR c_chk_wf_role (p_role_name VARCHAR2) IS

Line 2153: lv_role_name wf_roles.name%type;

2149: end updateApprovalHistory;
2150:
2151: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
2152: p_item_key in wf_items.item_key%type) is
2153: lv_role_name wf_roles.name%type;
2154: lv_role_disp_name wf_roles.name%type;
2155: lv_role_orig_system wf_roles.orig_system%type;
2156: lv_role_orig_sys_id wf_roles.orig_system_id%type;
2157: begin

Line 2154: lv_role_disp_name wf_roles.name%type;

2150:
2151: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
2152: p_item_key in wf_items.item_key%type) is
2153: lv_role_name wf_roles.name%type;
2154: lv_role_disp_name wf_roles.name%type;
2155: lv_role_orig_system wf_roles.orig_system%type;
2156: lv_role_orig_sys_id wf_roles.orig_system_id%type;
2157: begin
2158:

Line 2155: lv_role_orig_system wf_roles.orig_system%type;

2151: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,
2152: p_item_key in wf_items.item_key%type) is
2153: lv_role_name wf_roles.name%type;
2154: lv_role_disp_name wf_roles.name%type;
2155: lv_role_orig_system wf_roles.orig_system%type;
2156: lv_role_orig_sys_id wf_roles.orig_system_id%type;
2157: begin
2158:
2159: -- FORWARD_TO_PERSON_ID

Line 2156: lv_role_orig_sys_id wf_roles.orig_system_id%type;

2152: p_item_key in wf_items.item_key%type) is
2153: lv_role_name wf_roles.name%type;
2154: lv_role_disp_name wf_roles.name%type;
2155: lv_role_orig_system wf_roles.orig_system%type;
2156: lv_role_orig_sys_id wf_roles.orig_system_id%type;
2157: begin
2158:
2159: -- FORWARD_TO_PERSON_ID
2160: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_TO_PERSON_ID',true);

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

3158: l_new_fwd_display_name varchar2(360);
3159: l_is_parallel varchar2(10) := null;
3160:
3161: cursor get_person_info is
3162: select orig_system,orig_system_id,display_name from wf_roles where name = wf_engine.context_new_role;
3163:
3164: /* cursor get_name_info is
3165: select last_name,first_name from per_all_people_f where
3166: person_id = l_new_fwd_person_id;*/

Line 3621: l_curr_approver_role wf_roles.name%type;

3617: c_proc constant varchar2(60) := 'reset_approval_rfc_data';
3618: c_return_user wf_users.name%Type;
3619: c_creator_user wf_users.name%Type;
3620: l_approvalProcessVersion varchar2(10);
3621: l_curr_approver_role wf_roles.name%type;
3622: c_return_user_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3623: l_curr_approver_role_info_tbl wf_directory.wf_local_roles_tbl_type;
3624: l_is_parallel varchar2(10) := null;
3625:

Line 3846: lv_creatorUserName wf_roles.name%type;

3842: c_transaction_type varchar2(25);
3843: c_next_approvers ame_util.approverstable2;
3844: c_approvalprocesscompleteynout ame_util.charType;
3845: l_current_forward_to_username wf_users.name%type;
3846: lv_creatorUserName wf_roles.name%type;
3847: lv_rfcUserName wf_roles.name%type;
3848: lv_customRFC varchar2(5);
3849:
3850: lv_dynamicQuery varchar2(4000) ;

Line 3847: lv_rfcUserName wf_roles.name%type;

3843: c_next_approvers ame_util.approverstable2;
3844: c_approvalprocesscompleteynout ame_util.charType;
3845: l_current_forward_to_username wf_users.name%type;
3846: lv_creatorUserName wf_roles.name%type;
3847: lv_rfcUserName wf_roles.name%type;
3848: lv_customRFC varchar2(5);
3849:
3850: lv_dynamicQuery varchar2(4000) ;
3851: lv_queryProcedure varchar2(4000);

Line 4044: lv_orig_systemId wf_roles.orig_system_id%type;

4040: c_proc constant varchar2(30) := 'isApproverEditAllowed';
4041: lv_role_displayName wf_users.display_name%type;
4042: lv_roleName wf_users.name%type;
4043: lv_businessGroupId per_all_people_f.business_group_id%type;
4044: lv_orig_systemId wf_roles.orig_system_id%type;
4045: lv_orig_system wf_roles.orig_system%type;
4046: lv_creator_person_id hr_api_transactions.creator_person_id%type;
4047: begin
4048: g_debug := hr_utility.debug_enabled;

Line 4045: lv_orig_system wf_roles.orig_system%type;

4041: lv_role_displayName wf_users.display_name%type;
4042: lv_roleName wf_users.name%type;
4043: lv_businessGroupId per_all_people_f.business_group_id%type;
4044: lv_orig_systemId wf_roles.orig_system_id%type;
4045: lv_orig_system wf_roles.orig_system%type;
4046: lv_creator_person_id hr_api_transactions.creator_person_id%type;
4047: begin
4048: g_debug := hr_utility.debug_enabled;
4049: if g_debug then

Line 4104: return wf_roles.parent_orig_system%type is

4100:
4101: end isApproverEditAllowed;
4102:
4103: function getuserOrigSystem(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
4104: return wf_roles.parent_orig_system%type is
4105: -- local variables
4106: c_proc constant varchar2(30) := 'getuserOrigSystem';
4107: lv_orig_system wf_roles.parent_orig_system%type;
4108: lv_orig_system_id wf_roles.orig_system_id%type;

Line 4107: lv_orig_system wf_roles.parent_orig_system%type;

4103: function getuserOrigSystem(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
4104: return wf_roles.parent_orig_system%type is
4105: -- local variables
4106: c_proc constant varchar2(30) := 'getuserOrigSystem';
4107: lv_orig_system wf_roles.parent_orig_system%type;
4108: lv_orig_system_id wf_roles.orig_system_id%type;
4109: lv_user_name wf_roles.name%type;
4110: begin
4111: g_debug := hr_utility.debug_enabled;

Line 4108: lv_orig_system_id wf_roles.orig_system_id%type;

4104: return wf_roles.parent_orig_system%type is
4105: -- local variables
4106: c_proc constant varchar2(30) := 'getuserOrigSystem';
4107: lv_orig_system wf_roles.parent_orig_system%type;
4108: lv_orig_system_id wf_roles.orig_system_id%type;
4109: lv_user_name wf_roles.name%type;
4110: begin
4111: g_debug := hr_utility.debug_enabled;
4112: if g_debug then

Line 4109: lv_user_name wf_roles.name%type;

4105: -- local variables
4106: c_proc constant varchar2(30) := 'getuserOrigSystem';
4107: lv_orig_system wf_roles.parent_orig_system%type;
4108: lv_orig_system_id wf_roles.orig_system_id%type;
4109: lv_user_name wf_roles.name%type;
4110: begin
4111: g_debug := hr_utility.debug_enabled;
4112: if g_debug then
4113: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 4138: return wf_roles.orig_system_id%type is

4134:
4135: end getuserOrigSystem;
4136:
4137: function getUserOrigSystemId(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
4138: return wf_roles.orig_system_id%type is
4139: -- local variables
4140: c_proc constant varchar2(30) := 'getUserOrigSystemId';
4141: lv_orig_system wf_roles.parent_orig_system%type;
4142: lv_orig_system_id wf_roles.orig_system_id%type;

Line 4141: lv_orig_system wf_roles.parent_orig_system%type;

4137: function getUserOrigSystemId(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
4138: return wf_roles.orig_system_id%type is
4139: -- local variables
4140: c_proc constant varchar2(30) := 'getUserOrigSystemId';
4141: lv_orig_system wf_roles.parent_orig_system%type;
4142: lv_orig_system_id wf_roles.orig_system_id%type;
4143: lv_user_name wf_roles.name%type;
4144: begin
4145: g_debug := hr_utility.debug_enabled;

Line 4142: lv_orig_system_id wf_roles.orig_system_id%type;

4138: return wf_roles.orig_system_id%type is
4139: -- local variables
4140: c_proc constant varchar2(30) := 'getUserOrigSystemId';
4141: lv_orig_system wf_roles.parent_orig_system%type;
4142: lv_orig_system_id wf_roles.orig_system_id%type;
4143: lv_user_name wf_roles.name%type;
4144: begin
4145: g_debug := hr_utility.debug_enabled;
4146: if g_debug then

Line 4143: lv_user_name wf_roles.name%type;

4139: -- local variables
4140: c_proc constant varchar2(30) := 'getUserOrigSystemId';
4141: lv_orig_system wf_roles.parent_orig_system%type;
4142: lv_orig_system_id wf_roles.orig_system_id%type;
4143: lv_user_name wf_roles.name%type;
4144: begin
4145: g_debug := hr_utility.debug_enabled;
4146: if g_debug then
4147: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 4176: p_rfcRoleName in wf_roles.name%type,

4172: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type,
4173: p_transaction_id in hr_api_transactions.transaction_id%type,
4174: p_item_type in wf_items.item_type%type,
4175: p_item_key in wf_items.item_key%type,
4176: p_rfcRoleName in wf_roles.name%type,
4177: p_rfcUserOrigSystem in wf_roles.orig_system%type,
4178: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
4179: p_rfc_comments in varchar2,
4180: p_approverIndex in number

Line 4177: p_rfcUserOrigSystem in wf_roles.orig_system%type,

4173: p_transaction_id in hr_api_transactions.transaction_id%type,
4174: p_item_type in wf_items.item_type%type,
4175: p_item_key in wf_items.item_key%type,
4176: p_rfcRoleName in wf_roles.name%type,
4177: p_rfcUserOrigSystem in wf_roles.orig_system%type,
4178: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
4179: p_rfc_comments in varchar2,
4180: p_approverIndex in number
4181: ) is

Line 4178: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,

4174: p_item_type in wf_items.item_type%type,
4175: p_item_key in wf_items.item_key%type,
4176: p_rfcRoleName in wf_roles.name%type,
4177: p_rfcUserOrigSystem in wf_roles.orig_system%type,
4178: p_rfcUserOrigSystemId in wf_roles.orig_system_id%type,
4179: p_rfc_comments in varchar2,
4180: p_approverIndex in number
4181: ) is
4182: -- local variables

Line 4187: lv_role_name wf_roles.name%type;

4183: c_proc constant varchar2(30) := 'handleRFCAction';
4184: ln_rfc_notification_id wf_notifications.notification_id%type;
4185: l_lastDefaultApprover NUMBER;
4186: lv_dummy varchar2(10);
4187: lv_role_name wf_roles.name%type;
4188: lv_role_disp_name wf_roles.name%type;
4189: l_return_status varchar2(10);
4190: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4191:

Line 4188: lv_role_disp_name wf_roles.name%type;

4184: ln_rfc_notification_id wf_notifications.notification_id%type;
4185: l_lastDefaultApprover NUMBER;
4186: lv_dummy varchar2(10);
4187: lv_role_name wf_roles.name%type;
4188: lv_role_disp_name wf_roles.name%type;
4189: l_return_status varchar2(10);
4190: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4191:
4192: -- Cursor to find if the person (selected for RFC) is an additional approver

Line 4190: lv_role_orig_sys_id wf_roles.orig_system_id%type;

4186: lv_dummy varchar2(10);
4187: lv_role_name wf_roles.name%type;
4188: lv_role_disp_name wf_roles.name%type;
4189: l_return_status varchar2(10);
4190: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4191:
4192: -- Cursor to find if the person (selected for RFC) is an additional approver
4193: CURSOR cur_add_appr IS
4194: SELECT 'X'

Line 4455: lv_creator_role wf_roles.name%type;

4451: procedure handleRFCAction(p_approval_notification_id in wf_notifications.notification_id%type
4452: ) is
4453: lv_item_type wf_items.item_type%type;
4454: lv_item_key wf_items.item_key%type;
4455: lv_creator_role wf_roles.name%type;
4456: lv_creator_orig_system wf_roles.orig_system%type;
4457: lv_creator_orig_sys_id wf_roles.orig_system_id%type;
4458: begin
4459: hr_workflow_ss.get_item_type_and_key(p_approval_notification_id,lv_item_type,lv_item_key);

Line 4456: lv_creator_orig_system wf_roles.orig_system%type;

4452: ) is
4453: lv_item_type wf_items.item_type%type;
4454: lv_item_key wf_items.item_key%type;
4455: lv_creator_role wf_roles.name%type;
4456: lv_creator_orig_system wf_roles.orig_system%type;
4457: lv_creator_orig_sys_id wf_roles.orig_system_id%type;
4458: begin
4459: hr_workflow_ss.get_item_type_and_key(p_approval_notification_id,lv_item_type,lv_item_key);
4460:

Line 4457: lv_creator_orig_sys_id wf_roles.orig_system_id%type;

4453: lv_item_type wf_items.item_type%type;
4454: lv_item_key wf_items.item_key%type;
4455: lv_creator_role wf_roles.name%type;
4456: lv_creator_orig_system wf_roles.orig_system%type;
4457: lv_creator_orig_sys_id wf_roles.orig_system_id%type;
4458: begin
4459: hr_workflow_ss.get_item_type_and_key(p_approval_notification_id,lv_item_type,lv_item_key);
4460:
4461: -- fix for bug 4481775

Line 4500: lv_role_name wf_roles.name%type;

4496: end handleRFCAction;
4497:
4498: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
4499: p_item_key in wf_items.item_key%type) is
4500: lv_role_name wf_roles.name%type;
4501: lv_role_disp_name wf_roles.name%type;
4502: lv_role_orig_system wf_roles.orig_system%type;
4503: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4504: begin

Line 4501: lv_role_disp_name wf_roles.name%type;

4497:
4498: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
4499: p_item_key in wf_items.item_key%type) is
4500: lv_role_name wf_roles.name%type;
4501: lv_role_disp_name wf_roles.name%type;
4502: lv_role_orig_system wf_roles.orig_system%type;
4503: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4504: begin
4505:

Line 4502: lv_role_orig_system wf_roles.orig_system%type;

4498: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,
4499: p_item_key in wf_items.item_key%type) is
4500: lv_role_name wf_roles.name%type;
4501: lv_role_disp_name wf_roles.name%type;
4502: lv_role_orig_system wf_roles.orig_system%type;
4503: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4504: begin
4505:
4506: -- CREATOR_PERSON_ID

Line 4503: lv_role_orig_sys_id wf_roles.orig_system_id%type;

4499: p_item_key in wf_items.item_key%type) is
4500: lv_role_name wf_roles.name%type;
4501: lv_role_disp_name wf_roles.name%type;
4502: lv_role_orig_system wf_roles.orig_system%type;
4503: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4504: begin
4505:
4506: -- CREATOR_PERSON_ID
4507: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'CREATOR_PERSON_ID',true);

Line 4544: lv_role_name wf_roles.name%type;

4540:
4541:
4542: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
4543: p_item_key in wf_items.item_key%type) is
4544: lv_role_name wf_roles.name%type;
4545: lv_role_disp_name wf_roles.name%type;
4546: lv_role_orig_system wf_roles.orig_system%type;
4547: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4548: begin

Line 4545: lv_role_disp_name wf_roles.name%type;

4541:
4542: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
4543: p_item_key in wf_items.item_key%type) is
4544: lv_role_name wf_roles.name%type;
4545: lv_role_disp_name wf_roles.name%type;
4546: lv_role_orig_system wf_roles.orig_system%type;
4547: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4548: begin
4549:

Line 4546: lv_role_orig_system wf_roles.orig_system%type;

4542: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,
4543: p_item_key in wf_items.item_key%type) is
4544: lv_role_name wf_roles.name%type;
4545: lv_role_disp_name wf_roles.name%type;
4546: lv_role_orig_system wf_roles.orig_system%type;
4547: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4548: begin
4549:
4550: -- CURRENT_PERSON_ID

Line 4547: lv_role_orig_sys_id wf_roles.orig_system_id%type;

4543: p_item_key in wf_items.item_key%type) is
4544: lv_role_name wf_roles.name%type;
4545: lv_role_disp_name wf_roles.name%type;
4546: lv_role_orig_system wf_roles.orig_system%type;
4547: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4548: begin
4549:
4550: -- CURRENT_PERSON_ID
4551: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);

Line 4583: lv_role_name wf_roles.name%type;

4579: end selPersonRoleReInit;
4580:
4581: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
4582: p_item_key in wf_items.item_key%type) is
4583: lv_role_name wf_roles.name%type;
4584: lv_role_disp_name wf_roles.name%type;
4585: lv_role_orig_system wf_roles.orig_system%type;
4586: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4587: begin

Line 4584: lv_role_disp_name wf_roles.name%type;

4580:
4581: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
4582: p_item_key in wf_items.item_key%type) is
4583: lv_role_name wf_roles.name%type;
4584: lv_role_disp_name wf_roles.name%type;
4585: lv_role_orig_system wf_roles.orig_system%type;
4586: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4587: begin
4588:

Line 4585: lv_role_orig_system wf_roles.orig_system%type;

4581: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,
4582: p_item_key in wf_items.item_key%type) is
4583: lv_role_name wf_roles.name%type;
4584: lv_role_disp_name wf_roles.name%type;
4585: lv_role_orig_system wf_roles.orig_system%type;
4586: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4587: begin
4588:
4589: -- FORWARD_FROM_PERSON_ID

Line 4586: lv_role_orig_sys_id wf_roles.orig_system_id%type;

4582: p_item_key in wf_items.item_key%type) is
4583: lv_role_name wf_roles.name%type;
4584: lv_role_disp_name wf_roles.name%type;
4585: lv_role_orig_system wf_roles.orig_system%type;
4586: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4587: begin
4588:
4589: -- FORWARD_FROM_PERSON_ID
4590: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'FORWARD_FROM_PERSON_ID',true);

Line 4630: lv_role_name wf_roles.name%type;

4626:
4627:
4628: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
4629: p_item_key in wf_items.item_key%type) is
4630: lv_role_name wf_roles.name%type;
4631: lv_role_disp_name wf_roles.name%type;
4632: lv_role_orig_system wf_roles.orig_system%type;
4633: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4634: begin

Line 4631: lv_role_disp_name wf_roles.name%type;

4627:
4628: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
4629: p_item_key in wf_items.item_key%type) is
4630: lv_role_name wf_roles.name%type;
4631: lv_role_disp_name wf_roles.name%type;
4632: lv_role_orig_system wf_roles.orig_system%type;
4633: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4634: begin
4635:

Line 4632: lv_role_orig_system wf_roles.orig_system%type;

4628: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,
4629: p_item_key in wf_items.item_key%type) is
4630: lv_role_name wf_roles.name%type;
4631: lv_role_disp_name wf_roles.name%type;
4632: lv_role_orig_system wf_roles.orig_system%type;
4633: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4634: begin
4635:
4636: -- RETURN_TO_USER_ORIG_SYS_ID

Line 4633: lv_role_orig_sys_id wf_roles.orig_system_id%type;

4629: p_item_key in wf_items.item_key%type) is
4630: lv_role_name wf_roles.name%type;
4631: lv_role_disp_name wf_roles.name%type;
4632: lv_role_orig_system wf_roles.orig_system%type;
4633: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4634: begin
4635:
4636: -- RETURN_TO_USER_ORIG_SYS_ID
4637: lv_role_orig_sys_id:=wf_engine.getitemattrnumber(p_item_type,p_item_key,'RETURN_TO_USER_ORIG_SYS_ID',true);

Line 4668: lv_role_name wf_roles.name%type;

4664:
4665:
4666: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
4667: p_item_key in wf_items.item_key%type) is
4668: lv_role_name wf_roles.name%type;
4669: lv_role_disp_name wf_roles.name%type;
4670: lv_role_orig_system wf_roles.orig_system%type;
4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;

Line 4669: lv_role_disp_name wf_roles.name%type;

4665:
4666: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
4667: p_item_key in wf_items.item_key%type) is
4668: lv_role_name wf_roles.name%type;
4669: lv_role_disp_name wf_roles.name%type;
4670: lv_role_orig_system wf_roles.orig_system%type;
4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;
4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;

Line 4670: lv_role_orig_system wf_roles.orig_system%type;

4666: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,
4667: p_item_key in wf_items.item_key%type) is
4668: lv_role_name wf_roles.name%type;
4669: lv_role_disp_name wf_roles.name%type;
4670: lv_role_orig_system wf_roles.orig_system%type;
4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;
4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
4674: l_appraiser_person_id per_appraisals.appraiser_person_id%type;

Line 4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;

4667: p_item_key in wf_items.item_key%type) is
4668: lv_role_name wf_roles.name%type;
4669: lv_role_disp_name wf_roles.name%type;
4670: lv_role_orig_system wf_roles.orig_system%type;
4671: lv_role_orig_sys_id wf_roles.orig_system_id%type;
4672: l_appraisal_id per_appraisals.appraisal_id%type;
4673: l_main_appraiser_id per_appraisals.main_appraiser_id%type;
4674: l_appraiser_person_id per_appraisals.appraiser_person_id%type;
4675: l_appraisee_person_id per_appraisals.appraisee_person_id%type;

Line 5064: l_role_name wf_roles.name%type;

5060: lv_errorActid wf_item_activity_statuses.process_activity%type;
5061: lv_errname VARCHAR2(4000);
5062: l_index binary_integer;
5063: l_temp_item_attribute varchar2(2000);
5064: l_role_name wf_roles.name%type;
5065: l_role_displayname wf_roles.display_name%type;
5066: l_current_person_name per_all_people_f.full_name%type;
5067: l_manager_id per_all_people_f.person_id%type;
5068: begin

Line 5065: l_role_displayname wf_roles.display_name%type;

5061: lv_errname VARCHAR2(4000);
5062: l_index binary_integer;
5063: l_temp_item_attribute varchar2(2000);
5064: l_role_name wf_roles.name%type;
5065: l_role_displayname wf_roles.display_name%type;
5066: l_current_person_name per_all_people_f.full_name%type;
5067: l_manager_id per_all_people_f.person_id%type;
5068: begin
5069: g_debug := hr_utility.debug_enabled;