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 FND_USER

Line 3092: function getuserOrigSystem(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)

3088: end if;
3089:
3090: end isApproverEditAllowed;
3091:
3092: function getuserOrigSystem(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
3093: return wf_roles.parent_orig_system%type is
3094: -- local variables
3095: c_proc constant varchar2(30) := 'getuserOrigSystem';
3096: lv_orig_system wf_roles.parent_orig_system%type;

Line 3126: function getUserOrigSystemId(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)

3122: end if;
3123:
3124: end getuserOrigSystem;
3125:
3126: function getUserOrigSystemId(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
3127: return wf_roles.orig_system_id%type is
3128: -- local variables
3129: c_proc constant varchar2(30) := 'getUserOrigSystemId';
3130: lv_orig_system wf_roles.parent_orig_system%type;

Line 3196: fnd_user pth

3192: --
3193: CURSOR cur_appr IS
3194: SELECT pth.employee_id
3195: FROM pqh_ss_approval_history pah,
3196: fnd_user pth
3197: WHERE pah.user_name = pth.user_name
3198: AND pah.transaction_history_id = p_transaction_id
3199: AND approval_history_id = (
3200: SELECT MAX(approval_history_id)

Line 3202: fnd_user pth1

3198: AND pah.transaction_history_id = p_transaction_id
3199: AND approval_history_id = (
3200: SELECT MAX(approval_history_id)
3201: FROM pqh_ss_approval_history pah1,
3202: fnd_user pth1
3203: WHERE pah1.user_name = pth1.user_name
3204: AND pah1.transaction_history_id = pah.transaction_history_id
3205: AND pth1.employee_id IN (
3206: SELECT pth2.employee_id --, pth2.user_name, approval_history_id

Line 3208: fnd_user pth2

3204: AND pah1.transaction_history_id = pah.transaction_history_id
3205: AND pth1.employee_id IN (
3206: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
3207: FROM pqh_ss_approval_history pah2,
3208: fnd_user pth2
3209: WHERE pah2.user_name = pth2.user_name
3210: AND pah2.transaction_history_id = pah.transaction_history_id
3211: AND approval_history_id < (
3212: SELECT MIN(approval_history_id)

Line 3393: fnd_user pth

3389: begin
3390: select employee_id into lv_role_orig_sys_id from (
3391: SELECT pth.employee_id
3392: FROM pqh_ss_approval_history pah,
3393: fnd_user pth
3394: WHERE pah.user_name = pth.user_name
3395: AND pah.transaction_history_id = p_transaction_id
3396: and approval_history_id > 0
3397: and approval_history_id = (select min(approval_history_id) from pqh_ss_approval_history where USER_NAME = p_rfcRoleName and transaction_history_id = p_transaction_id)

Line 4297: lv_loginPersonUserName fnd_user.user_name%type;

4293: c_proc constant varchar2(30) := 'getinitApprovalBlockId';
4294: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4295: ln_activity_id number;
4296: lv_loginPersonDispName per_all_people_f.full_name%type;
4297: lv_loginPersonUserName fnd_user.user_name%type;
4298: ln_loginPersonId fnd_user.employee_id%type;
4299: begin
4300: if(p_transaction_id is not null) then
4301: select * into lr_hr_api_transaction_rec

Line 4298: ln_loginPersonId fnd_user.employee_id%type;

4294: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4295: ln_activity_id number;
4296: lv_loginPersonDispName per_all_people_f.full_name%type;
4297: lv_loginPersonUserName fnd_user.user_name%type;
4298: ln_loginPersonId fnd_user.employee_id%type;
4299: begin
4300: if(p_transaction_id is not null) then
4301: select * into lr_hr_api_transaction_rec
4302: from hr_api_transactions

Line 4495: lv_loginPersonUserName fnd_user.user_name%type;

4491: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4492: ln_activity_id wf_item_activity_statuses.process_activity%type;
4493: ln_notification_id wf_notifications.notification_id%type;
4494: lv_loginPersonDispName per_all_people_f.full_name%type;
4495: lv_loginPersonUserName fnd_user.user_name%type;
4496: ln_loginPersonId fnd_user.employee_id%type;
4497:
4498: begin
4499: if g_debug then

Line 4496: ln_loginPersonId fnd_user.employee_id%type;

4492: ln_activity_id wf_item_activity_statuses.process_activity%type;
4493: ln_notification_id wf_notifications.notification_id%type;
4494: lv_loginPersonDispName per_all_people_f.full_name%type;
4495: lv_loginPersonUserName fnd_user.user_name%type;
4496: ln_loginPersonId fnd_user.employee_id%type;
4497:
4498: begin
4499: if g_debug then
4500: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 4627: lv_loginPersonUserName fnd_user.user_name%type;

4623: c_proc constant varchar2(30) := 'processApprovalSubmit';
4624: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4625: ln_activity_id wf_item_activity_statuses.process_activity%type;
4626: lv_loginPersonDispName per_all_people_f.full_name%type;
4627: lv_loginPersonUserName fnd_user.user_name%type;
4628: ln_loginPersonId fnd_user.employee_id%type;
4629: lv_item_type wf_items.item_type%type;
4630: lv_item_key wf_items.item_key%type;
4631: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;

Line 4628: ln_loginPersonId fnd_user.employee_id%type;

4624: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
4625: ln_activity_id wf_item_activity_statuses.process_activity%type;
4626: lv_loginPersonDispName per_all_people_f.full_name%type;
4627: lv_loginPersonUserName fnd_user.user_name%type;
4628: ln_loginPersonId fnd_user.employee_id%type;
4629: lv_item_type wf_items.item_type%type;
4630: lv_item_key wf_items.item_key%type;
4631: lv_oaf_nav_attr wf_item_attribute_values.text_value%type;
4632: begin