APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_TRANSACTION_CATEGORIES

Line 84: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

80: ) RETURN VARCHAR;
81:
82: PROCEDURE APP_NEXT_USER
83: (p_trans_id in pqh_routing_history.transaction_id%type,
84: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
85: p_cur_user_id in out nocopy fnd_user.user_id%type,
86: p_cur_user_name in out nocopy fnd_user.user_name%type,
87: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
88: p_user_active_role_name in out nocopy pqh_roles.role_name%type,

Line 90: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,

86: p_cur_user_name in out nocopy fnd_user.user_name%type,
87: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
88: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
89: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
90: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
91: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
92: p_member_role_id out nocopy pqh_roles.role_id%type,
93: p_member_user_id out nocopy fnd_user.user_id%type,
94: p_person_id out nocopy fnd_user.employee_id%type,

Line 107: procedure get_next_user(p_member_cd in pqh_transaction_categories.member_cd%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);
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,

Line 109: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

105: p_status_flag out nocopy number,
106: p_can_approve out nocopy number);
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,

Line 126: p_member_cd IN pqh_transaction_categories.member_cd%type,

122: p_next_user out nocopy varchar2,
123: p_next_user_display out nocopy varchar2) ;
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,