APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_ROUTING_CATEGORIES

Line 560: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,

556: p_cur_user_id in out nocopy fnd_user.user_id%type,
557: p_cur_user_name in out nocopy fnd_user.user_name%type,
558: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
559: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
560: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
561: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
562: p_routing_list_id out nocopy pqh_routing_lists.routing_list_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,

Line 663: p_routing_category_id in pqh_routing_categories.routing_category_id%type,

659: end if;
660: END APP_NEXT_USER;
661:
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,

Line 668: p_routing_list_id in pqh_routing_categories.routing_list_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,
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,

Line 1369: FROM pqh_routing_categories

1365: l_txn_catg_id Number;
1366: l_route_catg_id Number;
1367: CURSOR csr_rout_catg(p_txn_catg_id IN Number) IS
1368: SELECT routing_category_id
1369: FROM pqh_routing_categories
1370: WHERE transaction_category_id = p_txn_catg_id;
1371: BEGIN
1372: l_txn_catg_id := pqh_workflow.get_txn_cat('PQH_BPR',p_business_group_id);
1373: OPEN csr_rout_catg(l_txn_catg_id);