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.HXC_APPROVAL_WF_HELPER dependencies on WF_LOCAL_ROLES

Line 131: return wf_local_roles.name%type

127: END find_error_admin_role;
128: ----------------------------------------------------------------------------------------------
129: FUNCTION find_preparer_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
130: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
131: return wf_local_roles.name%type
132: is
133:
134: l_user_id number;
135: l_person_id number;

Line 136: l_name wf_local_roles.name%type;

132: is
133:
134: l_user_id number;
135: l_person_id number;
136: l_name wf_local_roles.name%type;
137: l_display_name wf_local_roles.display_name%type;
138: l_proc constant varchar2(61) := g_pkg ||'find_preparer_role';
139:
140: CURSOR c_get_user_id(p_user_id IN number)

Line 137: l_display_name wf_local_roles.display_name%type;

133:
134: l_user_id number;
135: l_person_id number;
136: l_name wf_local_roles.name%type;
137: l_display_name wf_local_roles.display_name%type;
138: l_proc constant varchar2(61) := g_pkg ||'find_preparer_role';
139:
140: CURSOR c_get_user_id(p_user_id IN number)
141: is

Line 206: FUNCTION find_full_name_from_role(p_role_name in wf_local_roles.name%type,

202:
203: END find_preparer_role;
204:
205: -------------------------------------------------------------------------------------------------
206: FUNCTION find_full_name_from_role(p_role_name in wf_local_roles.name%type,
207: p_effective_date in date)
208: return varchar2
209: is
210:

Line 211: l_system_id wf_local_roles.orig_system_id%type;

207: p_effective_date in date)
208: return varchar2
209: is
210:
211: l_system_id wf_local_roles.orig_system_id%type;
212: l_original_system wf_local_roles.orig_system%type;
213: l_full_name per_all_people_f.full_name%type;
214: l_display_name wf_local_roles.display_name%type;
215: l_proc constant varchar2(61) := g_pkg ||'find_full_name_from_role';

Line 212: l_original_system wf_local_roles.orig_system%type;

208: return varchar2
209: is
210:
211: l_system_id wf_local_roles.orig_system_id%type;
212: l_original_system wf_local_roles.orig_system%type;
213: l_full_name per_all_people_f.full_name%type;
214: l_display_name wf_local_roles.display_name%type;
215: l_proc constant varchar2(61) := g_pkg ||'find_full_name_from_role';
216:

Line 214: l_display_name wf_local_roles.display_name%type;

210:
211: l_system_id wf_local_roles.orig_system_id%type;
212: l_original_system wf_local_roles.orig_system%type;
213: l_full_name per_all_people_f.full_name%type;
214: l_display_name wf_local_roles.display_name%type;
215: l_proc constant varchar2(61) := g_pkg ||'find_full_name_from_role';
216:
217: CURSOR c_get_original_system(p_role_name in wf_local_roles.name%type)
218: is

Line 217: CURSOR c_get_original_system(p_role_name in wf_local_roles.name%type)

213: l_full_name per_all_people_f.full_name%type;
214: l_display_name wf_local_roles.display_name%type;
215: l_proc constant varchar2(61) := g_pkg ||'find_full_name_from_role';
216:
217: CURSOR c_get_original_system(p_role_name in wf_local_roles.name%type)
218: is
219: select orig_system,orig_system_id,display_name
220: from wf_local_roles
221: where name= p_role_name;

Line 220: from wf_local_roles

216:
217: CURSOR c_get_original_system(p_role_name in wf_local_roles.name%type)
218: is
219: select orig_system,orig_system_id,display_name
220: from wf_local_roles
221: where name= p_role_name;
222:
223: CURSOR c_get_name_ppf(p_system_id in wf_local_roles.orig_system_id%type,
224: p_effective_date in date)

Line 223: CURSOR c_get_name_ppf(p_system_id in wf_local_roles.orig_system_id%type,

219: select orig_system,orig_system_id,display_name
220: from wf_local_roles
221: where name= p_role_name;
222:
223: CURSOR c_get_name_ppf(p_system_id in wf_local_roles.orig_system_id%type,
224: p_effective_date in date)
225: is
226: select full_name
227: from per_all_people_f

Line 270: return wf_local_roles.name%type

266:
267: --------------------------------------------------------------------------------------------------------
268: FUNCTION find_supervisor_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
269: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
270: return wf_local_roles.name%type
271: is
272:
273: l_supervisor_id per_all_assignments_f.supervisor_id%type;
274: l_name wf_local_roles.name%type;

Line 274: l_name wf_local_roles.name%type;

270: return wf_local_roles.name%type
271: is
272:
273: l_supervisor_id per_all_assignments_f.supervisor_id%type;
274: l_name wf_local_roles.name%type;
275: l_display_name wf_local_roles.display_name%type;
276: l_proc constant varchar2(61) := g_pkg ||'find_supervisor_role';
277:
278: CURSOR c_get_supervisor(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

Line 275: l_display_name wf_local_roles.display_name%type;

271: is
272:
273: l_supervisor_id per_all_assignments_f.supervisor_id%type;
274: l_name wf_local_roles.name%type;
275: l_display_name wf_local_roles.display_name%type;
276: l_proc constant varchar2(61) := g_pkg ||'find_supervisor_role';
277:
278: CURSOR c_get_supervisor(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
279: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )

Line 314: return wf_local_roles.name%type

310: END find_supervisor_role;
311: -----------------------------------------------------------------------------------------------------
312: FUNCTION find_worker_role(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
313: ,p_timecard_ovn IN hxc_time_building_blocks.object_version_number%TYPE )
314: return wf_local_roles.name%type
315: is
316:
317: l_worker_id hxc_time_building_blocks.resource_id%TYPE;
318: l_name wf_local_roles.name%type;

Line 318: l_name wf_local_roles.name%type;

314: return wf_local_roles.name%type
315: is
316:
317: l_worker_id hxc_time_building_blocks.resource_id%TYPE;
318: l_name wf_local_roles.name%type;
319: l_display_name wf_local_roles.display_name%type;
320: l_proc constant varchar2(61) := g_pkg ||'find_worker_role';
321:
322:

Line 319: l_display_name wf_local_roles.display_name%type;

315: is
316:
317: l_worker_id hxc_time_building_blocks.resource_id%TYPE;
318: l_name wf_local_roles.name%type;
319: l_display_name wf_local_roles.display_name%type;
320: l_proc constant varchar2(61) := g_pkg ||'find_worker_role';
321:
322:
323: CURSOR c_get_worker_id(p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE

Line 362: Return wf_local_roles.name%type

358: FUNCTION find_role_for_recipient
359: (p_recipient_code in wf_item_attribute_values.text_value%type,
360: p_timecard_id in number,
361: p_timecard_ovn in number)
362: Return wf_local_roles.name%type
363:
364: is
365: l_role wf_local_roles.name%type;
366: l_proc constant varchar2(61) := g_pkg ||'find_role_for_recipient';

Line 365: l_role wf_local_roles.name%type;

361: p_timecard_ovn in number)
362: Return wf_local_roles.name%type
363:
364: is
365: l_role wf_local_roles.name%type;
366: l_proc constant varchar2(61) := g_pkg ||'find_role_for_recipient';
367:
368: BEGIN
369: g_debug:=hr_utility.debug_enabled;

Line 730: l_recipient_role wf_local_roles.name%type;

726: l_resource_id hxc_time_building_blocks.resource_id%type;
727: l_recipient_action_code wf_item_attribute_values.text_value%type;
728: l_action_code wf_item_attribute_values.text_value%type;
729: l_notification_id wf_notifications.notification_id%type;
730: l_recipient_role wf_local_roles.name%type;
731: l_app_mech varchar2(30);
732: l_app_start_date date;
733: l_app_end_date date;
734: l_tc_start_date date;

Line 764: ,p_recipient_role in wf_local_roles.name%type)

760: where adl.application_period_id = p_application_period_id;
761:
762:
763: CURSOR c_get_notifications(p_timecard_id in hxc_time_building_blocks.time_building_block_id%type
764: ,p_recipient_role in wf_local_roles.name%type)
765: is
766: select wias.item_key,
767: wn.notification_id,
768: wna3.text_value bb_id

Line 1032: l_tc_from_role wf_local_roles.name%type;

1028: l_approval_comp_id number;
1029: l_can_notify boolean;
1030: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1031: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
1032: l_tc_from_role wf_local_roles.name%type;
1033: l_tc_to_role wf_local_roles.name%type;
1034: l_title varchar2(4000);
1035: l_total_hours number ;
1036: l_premium_hours number ;

Line 1033: l_tc_to_role wf_local_roles.name%type;

1029: l_can_notify boolean;
1030: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
1031: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
1032: l_tc_from_role wf_local_roles.name%type;
1033: l_tc_to_role wf_local_roles.name%type;
1034: l_title varchar2(4000);
1035: l_total_hours number ;
1036: l_premium_hours number ;
1037: l_non_worked_hours number ;

Line 1038: l_worker_role wf_local_roles.name%type;

1034: l_title varchar2(4000);
1035: l_total_hours number ;
1036: l_premium_hours number ;
1037: l_non_worked_hours number ;
1038: l_worker_role wf_local_roles.name%type;
1039: l_worker_full_name per_all_people_f.full_name%type;
1040: l_preparer_role wf_local_roles.name%type;
1041: l_preparer_full_name per_all_people_f.full_name%type;
1042: l_fyi_subject varchar2(4000);

Line 1040: l_preparer_role wf_local_roles.name%type;

1036: l_premium_hours number ;
1037: l_non_worked_hours number ;
1038: l_worker_role wf_local_roles.name%type;
1039: l_worker_full_name per_all_people_f.full_name%type;
1040: l_preparer_role wf_local_roles.name%type;
1041: l_preparer_full_name per_all_people_f.full_name%type;
1042: l_fyi_subject varchar2(4000);
1043: l_description varchar2(4000);
1044: l_tc_url varchar2(1000);

Line 1054: l_supervisor_role wf_local_roles.name%type;

1050: l_apr_rej_reason varchar2(2000);
1051: l_fyi_no_detail_body varchar2(4000);
1052: l_recipient_login fnd_user.user_name%type;
1053: l_recipient_id number;
1054: l_supervisor_role wf_local_roles.name%type;
1055: l_tc_id number;
1056: l_tc_ovn number;
1057: l_apr_person_id number;
1058: l_apr_name per_all_people_f.full_name%type;