APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_TRANSACTION_CATEGORIES

Line 555: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

551:
552: --
553: PROCEDURE APP_NEXT_USER
554: (p_trans_id in pqh_routing_history.transaction_id%type,
555: p_tran_cat_id in pqh_transaction_categories.transaction_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,

Line 561: p_member_cd out nocopy pqh_transaction_categories.member_cd%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,
565: p_person_id out nocopy fnd_user.employee_id%type,

Line 662: procedure get_next_user(p_member_cd in pqh_transaction_categories.member_cd%type,

658: hr_utility.set_location('display_name is '||p_next_user_display,75);
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,

Line 664: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,

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,
668: p_routing_list_id in pqh_routing_categories.routing_list_id%type,

Line 712: PROCEDURE FND_NEXT_USER(p_member_cd IN pqh_transaction_categories.member_cd%type,

708: p_next_name => p_next_user);
709: hr_utility.set_location('user_name is '||p_next_user,70);
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,

Line 1487: from pqh_transaction_categories

1483: l_status VARCHAR2(10) := 'Y';
1484: BEGIN
1485: SELECT prevent_approver_skip
1486: into l_status
1487: from pqh_transaction_categories
1488: where transaction_category_id = p_transaction_category_id;
1489: IF l_status is null OR l_status = 'N' THEN
1490: RETURN 'N';
1491: ELSE