APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_ROLES

Line 558: p_user_active_role_id in out nocopy pqh_roles.role_id%type,

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,
562: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

Line 559: p_user_active_role_name in out nocopy pqh_roles.role_name%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,
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,

Line 563: p_member_role_id 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,
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,

Line 715: p_member_role_id IN pqh_roles.role_id%type,

711:
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);

Line 737: from pqh_roles

733: hr_utility.set_location('name is '||p_next_name_display,30);
734: ELSIF p_member_role_id is not null then
735: select role_name
736: into p_next_name
737: from pqh_roles
738: where role_id= p_member_role_id;
739: hr_utility.set_location('user_name is '||p_next_name,40);
740: l_next_name := hr_general.decode_lookup(p_lookup_type => 'PQH_BPR_ROUTING',
741: p_lookup_code => 'ROLE');

Line 1157: From pqh_roles

1153: -- added business_group_id is null condition
1154: CURSOR csr_bgt_manager_rls(l_business_group_id IN number)
1155: IS
1156: Select role_id,role_name
1157: From pqh_roles
1158: Where role_type_cd = 'BUDGET'
1159: And enable_flag = 'Y'
1160: And( business_group_id = l_business_group_id
1161: OR business_group_id IS NULL );