DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on PER_ALL_PEOPLE_F

Line 392: l_worker_full_name per_all_people_f.full_name%type;

388: l_admin_timeout number;
389: l_approval_style_id number;
390: l_tc_from_role wf_local_roles.name%type;
391: l_worker_role wf_local_roles.name%type;
392: l_worker_full_name per_all_people_f.full_name%type;
393: l_preparer_role wf_local_roles.name%type;
394: l_preparer_full_name per_all_people_f.full_name%type;
395: l_admin_role wf_local_roles.name%type;
396: l_admin_full_name per_all_people_f.full_name%type;

Line 394: l_preparer_full_name per_all_people_f.full_name%type;

390: l_tc_from_role wf_local_roles.name%type;
391: l_worker_role wf_local_roles.name%type;
392: l_worker_full_name per_all_people_f.full_name%type;
393: l_preparer_role wf_local_roles.name%type;
394: l_preparer_full_name per_all_people_f.full_name%type;
395: l_admin_role wf_local_roles.name%type;
396: l_admin_full_name per_all_people_f.full_name%type;
397: l_apr_name per_all_people_f.full_name%type;
398: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;

Line 396: l_admin_full_name per_all_people_f.full_name%type;

392: l_worker_full_name per_all_people_f.full_name%type;
393: l_preparer_role wf_local_roles.name%type;
394: l_preparer_full_name per_all_people_f.full_name%type;
395: l_admin_role wf_local_roles.name%type;
396: l_admin_full_name per_all_people_f.full_name%type;
397: l_apr_name per_all_people_f.full_name%type;
398: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
399: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
400: l_tc_stop_date date;

Line 397: l_apr_name per_all_people_f.full_name%type;

393: l_preparer_role wf_local_roles.name%type;
394: l_preparer_full_name per_all_people_f.full_name%type;
395: l_admin_role wf_local_roles.name%type;
396: l_admin_full_name per_all_people_f.full_name%type;
397: l_apr_name per_all_people_f.full_name%type;
398: l_timecard_id hxc_time_building_blocks.time_building_block_id%TYPE;
399: l_timecard_ovn hxc_time_building_blocks.time_building_block_id%TYPE;
400: l_tc_stop_date date;
401: l_tc_start_date date;

Line 1052: l_resource_id per_all_people_f.person_id%type;

1048: p_actid in number,
1049: p_funcmode in varchar2,
1050: p_result in out nocopy varchar2) is
1051:
1052: l_resource_id per_all_people_f.person_id%type;
1053: l_tc_start_date date;
1054: l_exclude_hours varchar2(1);
1055: l_proc varchar2(50) := 'exclude_total_hours';
1056: