eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_WORKFLOW dependencies on PQH_ROUTING_LISTS

Line 1554: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

1550: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,
1551: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1552: p_person_id out nocopy fnd_user.employee_id%type,
1553: p_old_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1554: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1555: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1556: p_member_role_id out nocopy pqh_roles.role_id%type,
1557: p_member_user_id out nocopy fnd_user.user_id%type,
1558: p_cur_person_id out nocopy fnd_user.employee_id%type,

Line 1555: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

1551: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1552: p_person_id out nocopy fnd_user.employee_id%type,
1553: p_old_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1554: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1555: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1556: p_member_role_id out nocopy pqh_roles.role_id%type,
1557: p_member_user_id out nocopy fnd_user.user_id%type,
1558: p_cur_person_id out nocopy fnd_user.employee_id%type,
1559: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

Line 1824: procedure rl_member_check(p_routing_list_id in pqh_routing_lists.routing_list_id%type,

1820: p_person_id := null;
1821: raise;
1822: end person_on_assignment;
1823:
1824: procedure rl_member_check(p_routing_list_id in pqh_routing_lists.routing_list_id%type,
1825: p_old_routing_list_id in pqh_routing_lists.routing_list_id%type,
1826: p_history_flag in boolean,
1827: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1828: p_from_clause in pqh_table_route.from_clause%type,

Line 1825: p_old_routing_list_id in pqh_routing_lists.routing_list_id%type,

1821: raise;
1822: end person_on_assignment;
1823:
1824: procedure rl_member_check(p_routing_list_id in pqh_routing_lists.routing_list_id%type,
1825: p_old_routing_list_id in pqh_routing_lists.routing_list_id%type,
1826: p_history_flag in boolean,
1827: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1828: p_from_clause in pqh_table_route.from_clause%type,
1829: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

Line 2431: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

2427:
2428: procedure list_range_check(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
2429: p_used_for in varchar2 default null,
2430: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
2431: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
2432: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
2433: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
2434: p_status_flag out nocopy number ) is
2435: cursor c0 is select member_cd

Line 2525: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

2521: p_trans_id in pqh_routing_history.transaction_id%type,
2522: p_from_clause in pqh_table_route.from_clause%type,
2523: p_used_for in varchar2 default null,
2524: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
2525: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
2526: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
2527: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
2528: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
2529: p_status_flag out nocopy number )

Line 4190: procedure rlm_user_seq( p_routing_list_id in pqh_routing_lists.routing_list_id%type,

4186: hr_utility.set_location('Exiting '||l_proc,10000);
4187: return l_pos_str_ver_id;
4188: end pos_str_version;
4189:
4190: procedure rlm_user_seq( p_routing_list_id in pqh_routing_lists.routing_list_id%type,
4191: p_old_user_id in number default null,
4192: p_old_role_id in number default null,
4193: p_old_member_id in number default null,
4194: p_role_id in out nocopy pqh_roles.role_id%type,

Line 4371: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

4367: p_role_id out nocopy number,
4368: p_user_id out nocopy number,
4369: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,
4370: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,
4371: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
4372: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,
4373: p_status_flag out nocopy number) as
4374: cursor c1 is select max(routing_history_id)
4375: from pqh_routing_history