APPS.PQH_WORKFLOW dependencies on FND_PROFILE

Line 173: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

169: l_position_name hr_all_positions_f.name%type;
170: l_assignment_id number;
171: l_workflow_enable_flag pqh_transaction_categories.workflow_enable_flag%type;
172: l_proc varchar2(256) := g_package||'get_default_role';
173: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
174:
175: cursor c_get_employee(p_user_id number) is
176: select employee_id
177: from fnd_user

Line 309: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

305: l_position_id number;
306: l_assignment_id number;
307: l_proc varchar2(256) := g_package||'check_user_pos_details';
308: l_effective_date date;
309: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
310: l_position_name varchar2(240);
311: l_person_name varchar2(240);
312: begin
313: hr_utility.set_location('Entering '||l_proc,10);

Line 353: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

349: p_person_id in number) return number is
350: l_error_cd number := 0 ;
351: l_assignment_id number;
352: l_position_id number;
353: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
354: l_person_name varchar2(240);
355: l_proc varchar2(256) := g_package||'check_user_asg_details';
356: begin
357: hr_utility.set_location('Entering '||l_proc,10);

Line 503: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

499: and sysdate between ppf.effective_start_date and ppf.effective_end_date
500: and ppf.person_id = p_person_id
501: and nvl(pei.pei_information5,'Y')='Y'
502: and nvl(pei.pei_information4,'N')='Y';
503: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
504: l_person_name varchar2(240);
505: l_proc varchar2(71) := g_package||'get_routinghist_role' ;
506: BEGIN
507: hr_utility.set_location('entering'||l_proc,10);

Line 4607: l_user_id fnd_user.user_id%type := fnd_profile.value('USER_ID');

4603: l_proc varchar2(256) := g_package||'valid_user_opening';
4604: l_freeze_status_cd varchar2(30);
4605: l_member_cd varchar2(30);
4606: l_txn_catg_name varchar2(240);
4607: l_user_id fnd_user.user_id%type := fnd_profile.value('USER_ID');
4608: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
4609: l_scope_name varchar2(240);
4610: l_default_role_id number;
4611: l_routing_role_id number;

Line 4608: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

4604: l_freeze_status_cd varchar2(30);
4605: l_member_cd varchar2(30);
4606: l_txn_catg_name varchar2(240);
4607: l_user_id fnd_user.user_id%type := fnd_profile.value('USER_ID');
4608: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
4609: l_scope_name varchar2(240);
4610: l_default_role_id number;
4611: l_routing_role_id number;
4612: l_routing_history_id number;