DBA Data[Home] [Help]

APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_POSITION_TRANSACTIONS

Line 567: p_position_id out nocopy pqh_position_transactions.position_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,
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,

Line 570: p_cur_position_id out nocopy pqh_position_transactions.position_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,
573: p_cur_assignment_id out nocopy per_assignments_f.assignment_id%type,
574: p_next_user out nocopy varchar2,

Line 669: p_cur_position_id in pqh_position_transactions.position_id%type,

665: p_trans_id in pqh_routing_history.transaction_id%type,
666: p_cur_assignment_id in per_assignments_f.assignment_id%type,
667: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
668: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
669: p_cur_position_id in pqh_position_transactions.position_id%type,
670: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
671: p_next_position_id out nocopy pqh_position_transactions.position_id%type,
672: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
673: p_next_role_id out nocopy number,

Line 671: p_next_position_id out nocopy pqh_position_transactions.position_id%type,

667: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
668: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
669: p_cur_position_id in pqh_position_transactions.position_id%type,
670: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
671: p_next_position_id out nocopy pqh_position_transactions.position_id%type,
672: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
673: p_next_role_id out nocopy number,
674: p_next_user_id out nocopy number,
675: p_next_assignment_id out nocopy per_assignments_f.assignment_id%type,

Line 713: p_position_id IN pqh_position_transactions.position_id%type,

709: hr_utility.set_location('user_name is '||p_next_user,70);
710: end get_next_user;
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,