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.HR_APPROVAL_SS dependencies on WF_ITEMS

Line 126: function getOAFPageActId(p_item_type in wf_items.item_type%type,

122: hr_approval_custom.g_itemkey := p_itemkey;
123: hr_utility.set_location('Leaving: '|| l_proc,10);
124: END set_custom_wf_globals;
125:
126: function getOAFPageActId(p_item_type in wf_items.item_type%type,
127: p_item_key in wf_items.item_key%type) return number
128: is
129: -- local variables
130: c_proc constant varchar2(30) := 'storeApproverDetails';

Line 127: p_item_key in wf_items.item_key%type) return number

123: hr_utility.set_location('Leaving: '|| l_proc,10);
124: END set_custom_wf_globals;
125:
126: function getOAFPageActId(p_item_type in wf_items.item_type%type,
127: p_item_key in wf_items.item_key%type) return number
128: is
129: -- local variables
130: c_proc constant varchar2(30) := 'storeApproverDetails';
131: ln_activity_id WF_ITEM_ACTIVITY_STATUSES.process_activity%type;

Line 152: WF_ITEMS WI

148: select wpa.instance_id
149: FROM WF_PROCESS_ACTIVITIES WPA,
150: WF_ACTIVITY_ATTRIBUTES WAA,
151: WF_ACTIVITIES WA,
152: WF_ITEMS WI
153: WHERE wpa.process_item_type = ias.item_type
154: and wa.item_type = wpa.process_item_type
155: and wa.name = wpa.activity_name
156: and wi.item_type = ias.item_type

Line 2151: procedure forwardToRoleReInit(p_item_type in wf_items.item_type%type,

2147: when others then
2148: raise;
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;

Line 2152: p_item_key in wf_items.item_key%type) is

2148: raise;
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;

Line 4174: p_item_type in wf_items.item_type%type,

4170:
4171:
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,

Line 4175: p_item_key in wf_items.item_key%type,

4171:
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,

Line 4453: lv_item_type wf_items.item_type%type;

4449: end handleRFCAction;
4450:
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;

Line 4454: lv_item_key wf_items.item_key%type;

4450:
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

Line 4498: procedure creatorRoleReInit(p_item_type in wf_items.item_type%type,

4494: );
4495:
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;

Line 4499: p_item_key in wf_items.item_key%type) is

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

Line 4542: procedure selPersonRoleReInit(p_item_type in wf_items.item_type%type,

4538:
4539: end creatorRoleReInit;
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;

Line 4543: p_item_key in wf_items.item_key%type) is

4539: end creatorRoleReInit;
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;

Line 4581: procedure forwardFromRoleReInit(p_item_type in wf_items.item_type%type,

4577: end if;
4578:
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;

Line 4582: p_item_key in wf_items.item_key%type) is

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

Line 4628: procedure rfcUserRoleReInit(p_item_type in wf_items.item_type%type,

4624:
4625: end forwardFromRoleReInit;
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;

Line 4629: p_item_key in wf_items.item_key%type) is

4625: end forwardFromRoleReInit;
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;

Line 4666: procedure appraisalRolesReInit(p_item_type in wf_items.item_type%type,

4662:
4663: end rfcUserRoleReInit;
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;

Line 4667: p_item_key in wf_items.item_key%type) is

4663: end rfcUserRoleReInit;
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;

Line 4761: p_item_type in wf_items.item_type%type,

4757:
4758:
4759: procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,
4760: p_transaction_id in hr_api_transactions.transaction_id%type,
4761: p_item_type in wf_items.item_type%type,
4762: p_item_key in wf_items.item_key%type) is
4763: c_proc constant varchar2(30) := 'reInitPerformerRoles';
4764: lv_item_type wf_items.item_type%type;
4765: lv_item_key wf_items.item_key%type;

Line 4762: p_item_key in wf_items.item_key%type) is

4758:
4759: procedure reInitPerformerRoles(p_notification_id in wf_notifications.notification_id%type,
4760: p_transaction_id in hr_api_transactions.transaction_id%type,
4761: p_item_type in wf_items.item_type%type,
4762: p_item_key in wf_items.item_key%type) is
4763: c_proc constant varchar2(30) := 'reInitPerformerRoles';
4764: lv_item_type wf_items.item_type%type;
4765: lv_item_key wf_items.item_key%type;
4766:

Line 4764: lv_item_type wf_items.item_type%type;

4760: p_transaction_id in hr_api_transactions.transaction_id%type,
4761: p_item_type in wf_items.item_type%type,
4762: p_item_key in wf_items.item_key%type) is
4763: c_proc constant varchar2(30) := 'reInitPerformerRoles';
4764: lv_item_type wf_items.item_type%type;
4765: lv_item_key wf_items.item_key%type;
4766:
4767: begin
4768: g_debug := hr_utility.debug_enabled;

Line 4765: lv_item_key wf_items.item_key%type;

4761: p_item_type in wf_items.item_type%type,
4762: p_item_key in wf_items.item_key%type) is
4763: c_proc constant varchar2(30) := 'reInitPerformerRoles';
4764: lv_item_type wf_items.item_type%type;
4765: lv_item_key wf_items.item_key%type;
4766:
4767: begin
4768: g_debug := hr_utility.debug_enabled;
4769: if g_debug then

Line 4873: (p_item_type in wf_items.item_type%type

4869: -- ----------------------------------------------------------------------------
4870: -- |--------------------< wf_get_runnable_process_name >----------------------|
4871: -- ----------------------------------------------------------------------------
4872: function wf_get_runnable_process_name
4873: (p_item_type in wf_items.item_type%type
4874: ,p_process_name in wf_process_activities.process_name%type)
4875: return wf_runnable_processes_v.display_name%type is
4876: -- cursor determines is the specified process is runnable
4877: cursor csr_wrpv is

Line 4900: (p_item_type in wf_items.item_type%type

4896: -- ----------------------------------------------------------------------------
4897: -- |-------------------------< wf_process_runnable >--------------------------|
4898: -- ----------------------------------------------------------------------------
4899: function wf_process_runnable
4900: (p_item_type in wf_items.item_type%type
4901: ,p_process_name in wf_process_activities.process_name%type)
4902: return boolean is
4903: --
4904: begin

Line 4918: (p_item_type in wf_items.item_type%type

4914: -- ----------------------------------------------------------------------------
4915: -- |------------------------< create_hr_directory_services >------------------|
4916: -- ----------------------------------------------------------------------------
4917: procedure create_hr_directory_services
4918: (p_item_type in wf_items.item_type%type
4919: ,p_item_key in wf_items.item_key%type
4920: ,p_service_name in varchar2
4921: ,p_service_orig_sys_id in number
4922: ,p_service_orig_sys in varchar2) is

Line 4919: ,p_item_key in wf_items.item_key%type

4915: -- |------------------------< create_hr_directory_services >------------------|
4916: -- ----------------------------------------------------------------------------
4917: procedure create_hr_directory_services
4918: (p_item_type in wf_items.item_type%type
4919: ,p_item_key in wf_items.item_key%type
4920: ,p_service_name in varchar2
4921: ,p_service_orig_sys_id in number
4922: ,p_service_orig_sys in varchar2) is
4923: --

Line 5045: ,p_item_key in out nocopy wf_items.item_key%type

5041: --
5042: END getPersonNameFromID;
5043:
5044: procedure startGenericApprovalProcess(p_transaction_id in number
5045: ,p_item_key in out nocopy wf_items.item_key%type
5046: ,p_wf_ntf_sub_fnd_msg in fnd_new_messages.message_name%type
5047: ,p_relaunch_function hr_api_transactions.relaunch_function%type
5048: ,p_additional_wf_attributes in HR_WF_ATTR_TABLE
5049: ,p_status out nocopy varchar2

Line 5055: lv_item_type wf_items.item_type%type;

5051: ,p_errstack out nocopy varchar2
5052: )
5053: is
5054: c_proc constant varchar2(30) := 'startGenericApprovalProcess';
5055: lv_item_type wf_items.item_type%type;
5056: lv_item_key wf_items.item_key%type;
5057: lr_transaction_rec hr_api_transactions%rowtype;
5058: lv_status varchar2(8);
5059: lv_result varchar2(30);

Line 5056: lv_item_key wf_items.item_key%type;

5052: )
5053: is
5054: c_proc constant varchar2(30) := 'startGenericApprovalProcess';
5055: lv_item_type wf_items.item_type%type;
5056: lv_item_key wf_items.item_key%type;
5057: lr_transaction_rec hr_api_transactions%rowtype;
5058: lv_status varchar2(8);
5059: lv_result varchar2(30);
5060: lv_errorActid wf_item_activity_statuses.process_activity%type;

Line 5677: lv_item_type wf_items.item_type%type;

5673: ln_activity_id wf_item_activity_statuses.process_activity%type;
5674: lv_loginPersonDispName per_all_people_f.full_name%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

Line 5678: lv_item_key wf_items.item_key%type;

5674: lv_loginPersonDispName per_all_people_f.full_name%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);

Line 5882: procedure handleApprovalErrors(p_item_type in wf_items.item_type%type,

5878: when others then
5879: raise;
5880: end checktransactionState;
5881:
5882: procedure handleApprovalErrors(p_item_type in wf_items.item_type%type,
5883: p_item_key in wf_items.item_key%type,
5884: error_message_text in varchar2)
5885: is
5886:

Line 5883: p_item_key in wf_items.item_key%type,

5879: raise;
5880: end checktransactionState;
5881:
5882: procedure handleApprovalErrors(p_item_type in wf_items.item_type%type,
5883: p_item_key in wf_items.item_key%type,
5884: error_message_text in varchar2)
5885: is
5886:
5887: l_creator_disp_name wf_users.display_name%type;