[Home] [Help]
242:
243: -- Bug 3855544
244:
245: cursor c_get_user(p_usr_id NUMBER) is
246: select user_name from fnd_user
247: where user_id=p_usr_id;
248:
249: begin
250: -- Bug 3390666
247: where user_id=p_usr_id;
248:
249: begin
250: -- Bug 3390666
251: -- Fetch the role from wf table instead of fnd_user table.
252: wf_directory.GetUserName(p_orig_system => 'PER',
253: p_orig_system_id => p_person_id,
254: p_name => l_name,
255: p_display_name => l_display_name);
797: l_tc_bb_id hxc_time_building_blocks.time_building_block_id%type;
798: l_tc_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
799: l_ap_bb_id hxc_time_building_blocks.time_building_block_id%type;
800: l_ap_bb_ovn hxc_time_building_blocks.time_building_block_id%type;
801: l_login fnd_user.user_name%type;
802: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
803: l_tc_start_time hxc_time_building_blocks.start_time%TYPE;
804: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
805: l_approval_mechanism hxc_approval_comps.approval_mechanism%TYPE;
1097: p_itemtype in varchar2
1098: ,p_itemkey in varchar2
1099: )
1100: IS
1101: l_employee_id fnd_user.employee_id%TYPE;
1102: l_real_approver VARCHAR2(500);
1103:
1104:
1105: BEGIN
1800: l_proc constant varchar2(61) := g_pkg || '.' || 'person_approval';
1801: l_effective_end_date date;
1802: l_effective_start_date date;
1803: l_apr_person_id per_all_assignments_f.person_id%type;
1804: l_login fnd_user.user_name%type;
1805: --
1806: -- Bug 4153585
1807: -- Increased size for translation
1808: l_title varchar2(4000);
2198: l_person_id per_all_assignments_f.person_id%type;
2199: --
2200: l_supervisor_id per_all_assignments_f.supervisor_id%type;
2201: l_next_supervisor_id per_all_assignments_f.supervisor_id%type;
2202: l_login fnd_user.user_name%type;
2203: l_ap_bbid hxc_time_building_blocks.time_building_block_id%type;
2204: l_ap_bbovn hxc_time_building_blocks.time_building_block_id%type;
2205:
2206: