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.PQH_BDGT_REALLOC_UTILITY dependencies on FND_USER

Line 556: p_cur_user_id in out nocopy fnd_user.user_id%type,

552: --
553: PROCEDURE APP_NEXT_USER
554: (p_trans_id in pqh_routing_history.transaction_id%type,
555: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
556: p_cur_user_id in out nocopy fnd_user.user_id%type,
557: p_cur_user_name in out nocopy fnd_user.user_name%type,
558: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
559: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
560: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,

Line 557: p_cur_user_name in out nocopy fnd_user.user_name%type,

553: PROCEDURE APP_NEXT_USER
554: (p_trans_id in pqh_routing_history.transaction_id%type,
555: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
556: p_cur_user_id in out nocopy fnd_user.user_id%type,
557: p_cur_user_name in out nocopy fnd_user.user_name%type,
558: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
559: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
560: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
561: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,

Line 564: p_member_user_id out nocopy fnd_user.user_id%type,

560: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
561: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
562: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
563: p_member_role_id out nocopy pqh_roles.role_id%type,
564: p_member_user_id out nocopy fnd_user.user_id%type,
565: p_person_id out nocopy fnd_user.employee_id%type,
566: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
567: p_position_id out nocopy pqh_position_transactions.position_id%type,
568: p_cur_person_id out nocopy fnd_user.employee_id%type,

Line 565: p_person_id out nocopy fnd_user.employee_id%type,

561: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
562: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
563: p_member_role_id out nocopy pqh_roles.role_id%type,
564: p_member_user_id out nocopy fnd_user.user_id%type,
565: p_person_id out nocopy fnd_user.employee_id%type,
566: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
567: p_position_id out nocopy pqh_position_transactions.position_id%type,
568: p_cur_person_id out nocopy fnd_user.employee_id%type,
569: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

Line 568: p_cur_person_id out nocopy fnd_user.employee_id%type,

564: p_member_user_id out nocopy fnd_user.user_id%type,
565: p_person_id out nocopy fnd_user.employee_id%type,
566: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
567: p_position_id out nocopy pqh_position_transactions.position_id%type,
568: p_cur_person_id out nocopy fnd_user.employee_id%type,
569: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
570: p_cur_position_id out nocopy pqh_position_transactions.position_id%type,
571: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,
572: p_assignment_id out nocopy per_assignments_f.assignment_id%type,

Line 716: p_member_user_id IN fnd_user.user_id%type,

712: PROCEDURE FND_NEXT_USER(p_member_cd IN pqh_transaction_categories.member_cd%type,
713: p_position_id IN pqh_position_transactions.position_id%type,
714: p_assignment_id IN per_assignments_f.assignment_id%type,
715: p_member_role_id IN pqh_roles.role_id%type,
716: p_member_user_id IN fnd_user.user_id%type,
717: p_next_name OUT NOCOPY VARCHAR,
718: p_next_name_display OUT NOCOPY VARCHAR) is
719: l_next_name VARCHAR2(240);
720: l_person_id NUMBER;

Line 726: from fnd_user

722: IF(p_member_cd = 'R') THEN
723: IF(p_member_user_id is NOT null) THEN
724: select user_name
725: into p_next_name
726: from fnd_user
727: where user_id=p_member_user_id;
728: hr_utility.set_location('user_name is '||p_next_name,10);
729: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
730: p_lookup_code => 'USER');

Line 768: from fnd_user

764: where assignment_id = p_assignment_id;
765: hr_utility.set_location('person_id is '||l_person_id,110);
766: select user_name
767: into p_next_name
768: from fnd_user
769: where employee_id=l_person_id;
770: hr_utility.set_location('user_name is '||p_next_name,120);
771: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
772: p_lookup_code => 'USER');