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_HISTORY

Line 431: from pqh_routing_history rht, pqh_routing_list_members rlm

427: l_role_name varchar2(300);
428: l_dummy varchar2(10);
429: cursor c_rlm(p_routing_history_id number) is
430: select role_id
431: from pqh_routing_history rht, pqh_routing_list_members rlm
432: where rht.forwarded_to_member_id = rlm.routing_list_member_id
433: and rht.routing_history_id = p_routing_history_id;
434: cursor c_role_users(p_user_id number, p_role_id number) is
435: select 'X'

Line 517: from pqh_routing_history

513: hr_utility.set_location('person_id is'||l_person_id||l_proc,20);
514: hr_utility.set_location('person_name is'||l_person_name||l_proc,21);
515: select forwarded_to_member_id, forwarded_to_position_id,forwarded_to_assignment_id
516: into l_rht_member_id,l_rht_position_id,l_rht_assignment_id
517: from pqh_routing_history
518: where routing_history_id = p_routing_history_id;
519: hr_utility.set_location('rout_hist details pulled'||l_proc,30);
520: if l_rht_member_id is not null then
521: hr_utility.set_location('member role to be pulled'||l_proc,40);

Line 852: from pqh_routing_history

848: l_range_name varchar2(100);
849: l_proc varchar2(256) := g_package||'old_approver_valid' ;
850: cursor c1 is select forwarded_by_position_id,forwarded_by_assignment_id,forwarded_by_user_id,forwarded_by_role_id,
851: forwarded_by_member_id,routing_category_id
852: from pqh_routing_history
853: where routing_history_id = l_max_routing_history_id;
854: cursor c2 is select rlm.role_id
855: from pqh_routing_categories rc,pqh_routing_list_members rlm
856: where rc.routing_category_id = l_rh_routing_category_id

Line 877: from pqh_routing_history

873: if l_error_flag = FALSE then
874: begin
875: select max(routing_history_id)
876: into l_max_routing_history_id
877: from pqh_routing_history
878: where transaction_category_id = p_transaction_category_id
879: and transaction_id = p_transaction_id
880: and approval_cd ='APPROVED' ;
881: hr_utility.set_location('max RH id is '||l_max_routing_history_id||l_proc,10);

Line 1038: p_trans_id in pqh_routing_history.transaction_id%type,

1034: end old_approver_valid;
1035: procedure next_applicable(p_member_cd in pqh_transaction_categories.member_cd%type,
1036: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1037: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1038: p_trans_id in pqh_routing_history.transaction_id%type,
1039: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,
1040: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
1041: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
1042: p_cur_position_id in pqh_position_transactions.position_id%type,

Line 1136: p_trans_id in pqh_routing_history.transaction_id%type,

1132: raise;
1133: end next_applicable;
1134: procedure next_applicable_assignment(p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1135: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1136: p_trans_id in pqh_routing_history.transaction_id%type,
1137: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,
1138: p_used_for in varchar2,
1139: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
1140: p_status_flag out nocopy number,

Line 1215: p_trans_id in pqh_routing_history.transaction_id%type,

1211: end next_applicable_assignment;
1212:
1213: procedure next_applicable_member(p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1214: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1215: p_trans_id in pqh_routing_history.transaction_id%type,
1216: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
1217: p_routing_list_id in pqh_routing_categories.routing_list_id%type,
1218: p_used_for in varchar2,
1219: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

Line 1313: p_trans_id in pqh_routing_history.transaction_id%type,

1309: end next_applicable_member;
1310:
1311: procedure next_applicable_position(p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1312: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1313: p_trans_id in pqh_routing_history.transaction_id%type,
1314: p_cur_position_id in pqh_position_transactions.position_id%type,
1315: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,
1316: p_used_for in varchar2,
1317: p_position_id out nocopy pqh_position_transactions.position_id%type,

Line 1541: procedure applicable_next_user(p_trans_id in pqh_routing_history.transaction_id%type,

1537: p_applicable_flag := null;
1538: raise;
1539: end person_has_user;
1540:
1541: procedure applicable_next_user(p_trans_id in pqh_routing_history.transaction_id%type,
1542: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1543: p_cur_user_id in out nocopy fnd_user.user_id%type,
1544: p_cur_user_name in out nocopy fnd_user.user_name%type,
1545: p_user_active_role_id in out nocopy pqh_roles.role_id%type,

Line 1550: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,

1546: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
1547: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
1548: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
1549: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%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,

Line 1565: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,

1561: p_old_position_id out nocopy pqh_position_transactions.position_id%type,
1562: p_cur_position_id out nocopy pqh_position_transactions.position_id%type,
1563: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
1564: p_old_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
1565: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,
1566: p_old_pos_str_ver_id out nocopy pqh_routing_categories.position_structure_id%type,
1567: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
1568: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
1569: p_old_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

Line 2521: p_trans_id in pqh_routing_history.transaction_id%type,

2517: hr_utility.raise_error;
2518: end list_range_check;
2519:
2520: procedure list_range_check(p_tran_cat_id in pqh_transaction_categories.transaction_category_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,

Line 3836: p_trans_id in pqh_routing_history.transaction_id%type,

3832: raise;
3833: end user_position_and_assignment ;
3834:
3835: procedure prepare_from_clause(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
3836: p_trans_id in pqh_routing_history.transaction_id%type,
3837: p_from_clause out nocopy pqh_table_route.from_clause%type ) as
3838: cursor c1 is select rou.from_clause,rou.where_clause
3839: from pqh_transaction_categories cat ,pqh_table_route rou
3840: where cat.transaction_category_id = p_tran_cat_id

Line 4362: p_trans_id in pqh_routing_history.transaction_id%type,

4358: raise;
4359: end rlm_user_seq;
4360:
4361: procedure routing_current (p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
4362: p_trans_id in pqh_routing_history.transaction_id%type,
4363: p_history_flag out nocopy boolean,
4364: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
4365: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
4366: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,

Line 4365: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,

4361: procedure routing_current (p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
4362: p_trans_id in pqh_routing_history.transaction_id%type,
4363: p_history_flag out nocopy boolean,
4364: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
4365: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
4366: p_member_id out nocopy pqh_routing_history.forwarded_to_member_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,

Line 4366: p_member_id out nocopy pqh_routing_history.forwarded_to_member_id%type,

4362: p_trans_id in pqh_routing_history.transaction_id%type,
4363: p_history_flag out nocopy boolean,
4364: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,
4365: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
4366: p_member_id out nocopy pqh_routing_history.forwarded_to_member_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,

Line 4369: p_assignment_id out nocopy pqh_routing_history.forwarded_to_assignment_id%type,

4365: p_position_id out nocopy pqh_routing_history.forwarded_to_position_id%type,
4366: p_member_id out nocopy pqh_routing_history.forwarded_to_member_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

Line 4370: p_pos_str_ver_id out nocopy pqh_routing_history.pos_structure_version_id%type,

4366: p_member_id out nocopy pqh_routing_history.forwarded_to_member_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)

Line 4372: p_routing_history_id out nocopy pqh_routing_history.routing_history_id%type,

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
4376: where transaction_category_id = p_tran_cat_id

Line 4375: from pqh_routing_history

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
4376: where transaction_category_id = p_tran_cat_id
4377: and transaction_id = p_trans_id
4378: and user_action_cd <> 'APPLY';
4379: cursor c2 is select rh.forwarded_to_position_id,rh.forwarded_to_role_id,rh.forwarded_to_user_id,rh.forwarded_to_member_id,

Line 4381: from pqh_routing_history rh,pqh_routing_categories rc

4377: and transaction_id = p_trans_id
4378: and user_action_cd <> 'APPLY';
4379: cursor c2 is select rh.forwarded_to_position_id,rh.forwarded_to_role_id,rh.forwarded_to_user_id,rh.forwarded_to_member_id,
4380: rh.forwarded_to_assignment_id,rh.pos_structure_version_id,rc.routing_list_id
4381: from pqh_routing_history rh,pqh_routing_categories rc
4382: where routing_history_id = p_routing_history_id
4383: and rh.routing_category_id = rc.routing_category_id;
4384: l_error_flag boolean := FALSE;
4385: l_proc varchar2(256) := g_package||'routing_current';

Line 4515: p_pos_str_ver_id in pqh_routing_history.pos_structure_version_id%type,

4511: p_status_flag := null;
4512: raise;
4513: end rl_next_user;
4514: procedure ph_next_user(p_cur_position_id in pqh_position_transactions.position_id%type,
4515: p_pos_str_ver_id in pqh_routing_history.pos_structure_version_id%type,
4516: p_position_id out nocopy pqh_position_transactions.position_id%type,
4517: p_status_flag out nocopy number ) as
4518: cursor c1(l_position_id number) is
4519: select parent_position_id

Line 4641: from pqh_routing_history

4637: where ppos.person_id = l_person_id;
4638:
4639: cursor c_user_action is
4640: select user_action_cd
4641: from pqh_routing_history
4642: where routing_history_id = p_routing_history_id;
4643: --
4644: l_user_action_cd varchar2(30);
4645: --

Line 4772: from pqh_routing_history

4768: hr_utility.set_location('transaction was saved in inbox after start'||l_proc,115);
4769: else
4770: select max(routing_history_id)
4771: into l_routing_history_id
4772: from pqh_routing_history
4773: where routing_history_id > nvl(p_routing_history_id,0)
4774: and transaction_id = p_transaction_id
4775: and transaction_category_id = p_wf_transaction_category_id;
4776: if l_routing_history_id > 0 then