DBA Data[Home] [Help]

APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PER_ASSIGNMENTS_F

Line 101: p_assignment_id out nocopy per_assignments_f.assignment_id%type,

97: p_cur_person_id out nocopy fnd_user.employee_id%type,
98: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
99: p_cur_position_id out nocopy pqh_position_transactions.position_id%type,
100: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,
101: p_assignment_id out nocopy per_assignments_f.assignment_id%type,
102: p_cur_assignment_id out nocopy per_assignments_f.assignment_id%type,
103: p_next_user out nocopy varchar2,
104: p_next_user_display out nocopy varchar2,
105: p_status_flag out nocopy number,

Line 102: p_cur_assignment_id out nocopy per_assignments_f.assignment_id%type,

98: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
99: p_cur_position_id out nocopy pqh_position_transactions.position_id%type,
100: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,
101: p_assignment_id out nocopy per_assignments_f.assignment_id%type,
102: p_cur_assignment_id out nocopy per_assignments_f.assignment_id%type,
103: p_next_user out nocopy varchar2,
104: p_next_user_display out nocopy varchar2,
105: p_status_flag out nocopy number,
106: p_can_approve out nocopy number);

Line 111: p_cur_assignment_id in per_assignments_f.assignment_id%type,

107: procedure get_next_user(p_member_cd in pqh_transaction_categories.member_cd%type,
108: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
109: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
110: p_trans_id in pqh_routing_history.transaction_id%type,
111: p_cur_assignment_id in per_assignments_f.assignment_id%type,
112: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
113: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
114: p_cur_position_id in pqh_position_transactions.position_id%type,
115: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,

Line 120: p_next_assignment_id out nocopy per_assignments_f.assignment_id%type,

116: p_next_position_id out nocopy pqh_position_transactions.position_id%type,
117: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
118: p_next_role_id out nocopy number,
119: p_next_user_id out nocopy number,
120: p_next_assignment_id out nocopy per_assignments_f.assignment_id%type,
121: p_status_flag out nocopy number,
122: p_next_user out nocopy varchar2,
123: p_next_user_display out nocopy varchar2) ;
124: PROCEDURE FND_NEXT_USER

Line 128: p_assignment_id IN per_assignments_f.assignment_id%type,

124: PROCEDURE FND_NEXT_USER
125: (
126: p_member_cd IN pqh_transaction_categories.member_cd%type,
127: p_position_id IN pqh_position_transactions.position_id%type,
128: p_assignment_id IN per_assignments_f.assignment_id%type,
129: p_member_role_id IN pqh_roles.role_id%type,
130: p_member_user_id IN fnd_user.user_id%type,
131: p_next_name OUT NOCOPY VARCHAR,
132: p_next_name_display OUT NOCOPY VARCHAR