DBA Data[Home] [Help]

APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PER_ASSIGNMENTS_F

Line 572: p_assignment_id out nocopy per_assignments_f.assignment_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,
575: p_next_user_display out nocopy varchar2,
576: p_status_flag out nocopy number,

Line 573: p_cur_assignment_id out nocopy per_assignments_f.assignment_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,
575: p_next_user_display out nocopy varchar2,
576: p_status_flag out nocopy number,
577: p_can_approve out nocopy number)

Line 666: p_cur_assignment_id in per_assignments_f.assignment_id%type,

662: procedure get_next_user(p_member_cd in pqh_transaction_categories.member_cd%type,
663: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
664: p_tran_cat_id in pqh_transaction_categories.transaction_category_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,

Line 675: p_next_assignment_id out nocopy per_assignments_f.assignment_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,
676: p_status_flag out nocopy number,
677: p_next_user out nocopy varchar2,
678: p_next_user_display out nocopy varchar2) is
679: begin

Line 714: p_assignment_id IN per_assignments_f.assignment_id%type,

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,
718: p_next_name_display OUT NOCOPY VARCHAR) is