DBA Data[Home] [Help]

APPS.HR_APPROVAL_SS dependencies on FND_USER

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

4099: end if;
4100:
4101: end isApproverEditAllowed;
4102:
4103: function getuserOrigSystem(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
4104: return wf_roles.parent_orig_system%type is
4105: -- local variables
4106: c_proc constant varchar2(30) := 'getuserOrigSystem';
4107: lv_orig_system wf_roles.parent_orig_system%type;

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

4133: end if;
4134:
4135: end getuserOrigSystem;
4136:
4137: function getUserOrigSystemId(p_user_name in fnd_user.user_name%type,p_notification_id in number default null)
4138: return wf_roles.orig_system_id%type is
4139: -- local variables
4140: c_proc constant varchar2(30) := 'getUserOrigSystemId';
4141: lv_orig_system wf_roles.parent_orig_system%type;

Line 4207: fnd_user pth

4203: --
4204: CURSOR cur_appr IS
4205: SELECT pth.employee_id
4206: FROM pqh_ss_approval_history pah,
4207: fnd_user pth
4208: WHERE pah.user_name = pth.user_name
4209: AND pah.transaction_history_id = p_transaction_id
4210: AND approval_history_id = (
4211: SELECT MAX(approval_history_id)

Line 4213: fnd_user pth1

4209: AND pah.transaction_history_id = p_transaction_id
4210: AND approval_history_id = (
4211: SELECT MAX(approval_history_id)
4212: FROM pqh_ss_approval_history pah1,
4213: fnd_user pth1
4214: WHERE pah1.user_name = pth1.user_name
4215: AND pah1.transaction_history_id = pah.transaction_history_id
4216: AND pth1.employee_id IN (
4217: SELECT pth2.employee_id --, pth2.user_name, approval_history_id

Line 4219: fnd_user pth2

4215: AND pah1.transaction_history_id = pah.transaction_history_id
4216: AND pth1.employee_id IN (
4217: SELECT pth2.employee_id --, pth2.user_name, approval_history_id
4218: FROM pqh_ss_approval_history pah2,
4219: fnd_user pth2
4220: WHERE pah2.user_name = pth2.user_name
4221: AND pah2.transaction_history_id = pah.transaction_history_id
4222: AND approval_history_id < (
4223: SELECT MIN(approval_history_id)

Line 4404: fnd_user pth

4400: begin
4401: select employee_id into lv_role_orig_sys_id from (
4402: SELECT pth.employee_id
4403: FROM pqh_ss_approval_history pah,
4404: fnd_user pth
4405: WHERE pah.user_name = pth.user_name
4406: AND pah.transaction_history_id = p_transaction_id
4407: and approval_history_id > 0
4408: 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 5338: lv_loginPersonUserName fnd_user.user_name%type;

5334: c_proc constant varchar2(30) := 'getinitApprovalBlockId';
5335: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5336: ln_activity_id number;
5337: lv_loginPersonDispName per_all_people_f.full_name%type;
5338: lv_loginPersonUserName fnd_user.user_name%type;
5339: ln_loginPersonId fnd_user.employee_id%type;
5340: begin
5341: if(p_transaction_id is not null) then
5342: select * into lr_hr_api_transaction_rec

Line 5339: ln_loginPersonId fnd_user.employee_id%type;

5335: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5336: ln_activity_id number;
5337: lv_loginPersonDispName per_all_people_f.full_name%type;
5338: lv_loginPersonUserName fnd_user.user_name%type;
5339: ln_loginPersonId fnd_user.employee_id%type;
5340: begin
5341: if(p_transaction_id is not null) then
5342: select * into lr_hr_api_transaction_rec
5343: from hr_api_transactions

Line 5536: lv_loginPersonUserName fnd_user.user_name%type;

5532: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
5533: ln_activity_id wf_item_activity_statuses.process_activity%type;
5534: ln_notification_id wf_notifications.notification_id%type;
5535: lv_loginPersonDispName per_all_people_f.full_name%type;
5536: lv_loginPersonUserName fnd_user.user_name%type;
5537: ln_loginPersonId fnd_user.employee_id%type;
5538:
5539: begin
5540: if g_debug then

Line 5537: ln_loginPersonId fnd_user.employee_id%type;

5533: ln_activity_id wf_item_activity_statuses.process_activity%type;
5534: ln_notification_id wf_notifications.notification_id%type;
5535: lv_loginPersonDispName per_all_people_f.full_name%type;
5536: lv_loginPersonUserName fnd_user.user_name%type;
5537: ln_loginPersonId fnd_user.employee_id%type;
5538:
5539: begin
5540: if g_debug then
5541: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);

Line 5675: lv_loginPersonUserName fnd_user.user_name%type;

5671: c_proc constant varchar2(30) := 'processApprovalSubmit';
5672: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
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;

Line 5676: ln_loginPersonId fnd_user.employee_id%type;

5672: lr_hr_api_transaction_rec hr_api_transactions%rowtype;
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