APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_WORKFLOW

Line 598: pqh_workflow.applicable_next_user

594: l_range_name VARCHAR2(80);
595: l_proc varchar2(61) := 'app_next_user';
596: BEGIN
597: hr_utility.set_location('inside'||l_proc,10);
598: pqh_workflow.applicable_next_user
599: (p_trans_id => p_trans_id
600: ,p_tran_cat_id => p_tran_cat_id
601: ,p_cur_user_id => p_cur_user_id
602: ,p_cur_user_name => p_cur_user_name

Line 680: pqh_workflow.next_applicable

676: p_status_flag out nocopy number,
677: p_next_user out nocopy varchar2,
678: p_next_user_display out nocopy varchar2) is
679: begin
680: pqh_workflow.next_applicable
681: (p_member_cd => p_member_cd,
682: p_routing_category_id => p_routing_category_id,
683: p_tran_cat_id => p_tran_cat_id,
684: p_trans_id => p_trans_id,

Line 1191: l_transaction_category_id := pqh_workflow.get_txn_cat

1187: Open csr_bg_id;
1188: Fetch csr_bg_id into l_business_group_id;
1189: Close csr_bg_id;
1190: hr_utility.set_location('Business Group id '||l_business_group_id||l_proc,12);
1191: l_transaction_category_id := pqh_workflow.get_txn_cat
1192: (p_short_name => 'PQH_BPR'
1193: ,p_business_group_id => l_business_group_id);
1194: hr_utility.set_location('transaction category id '||l_transaction_category_id||l_proc,15);
1195:

Line 1372: l_txn_catg_id := pqh_workflow.get_txn_cat('PQH_BPR',p_business_group_id);

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);
1374: FETCH csr_rout_catg INTO l_route_catg_id;
1375: IF csr_rout_catg%NOTFOUND THEN
1376: p_status := 'FALSE';

Line 1499: -- | Wrapper on top of pqh_workflow.valid_user_openingto allow multi messaging |

1495:
1496:
1497: -- ----------------------------------------------------------------------------
1498: -- |----------------------< valid_user_opening >-------------------------------|
1499: -- | Wrapper on top of pqh_workflow.valid_user_openingto allow multi messaging |
1500: -- ----------------------------------------------------------------------------
1501: procedure valid_user_opening(p_business_group_id in number default null,
1502: p_short_name in varchar2 ,
1503: p_transaction_id in number default null,

Line 1516: pqh_workflow.valid_user_opening(

1512: --
1513: -- Enable multi-messaging
1514: hr_multi_message.enable_message_list;
1515: --
1516: pqh_workflow.valid_user_opening(
1517: p_business_group_id => p_business_group_id,
1518: p_short_name => p_short_name,
1519: p_transaction_id => p_transaction_id,
1520: p_routing_history_id => p_routing_history_id,