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 PER_ALL_ASSIGNMENTS_F

Line 11: from per_all_assignments_f

7: p_position_id out nocopy number) is
8: begin
9: select assignment_id,position_id
10: into p_assignment_id, p_position_id
11: from per_all_assignments_f
12: where person_id = p_person_id
13: and primary_flag ='Y'
14: AND assignment_type = 'E' -- bug 7330323
15: and p_effective_date between effective_start_date and effective_end_date;

Line 187: from per_all_assignments_f asg

183: where transaction_category_id = p_transaction_category_id;
184:
185: cursor c_get_assignment (p_user_id number) IS
186: select asg.assignment_id,asg.position_id
187: from per_all_assignments_f asg
188: , fnd_user fu
189: where asg.person_id = fu.employee_id
190: and fu.user_id = p_user_id
191: and asg.primary_flag = 'Y'

Line 197: from per_position_extra_info pei, hr_all_positions_f pos, per_all_assignments_f asg

193: and p_session_date between asg.effective_start_date and asg.effective_end_date;
194:
195: cursor c_get_pos_role(p_assignment_id number) is
196: select decode(information_type, 'PQH_POS_ROLE_ID' , to_number(poei_information3), -1) ROLE_ID
197: from per_position_extra_info pei, hr_all_positions_f pos, per_all_assignments_f asg
198: where pei.position_id=pos.position_id and pei.information_type='PQH_POS_ROLE_ID'
199: and pos.position_id = asg.position_id
200: and p_session_date between pos.effective_start_date and pos.effective_end_date
201: and p_session_date between asg.effective_start_date and asg.effective_end_date

Line 489: from per_all_assignments_f

485: and pei.information_type='PQH_POS_ROLE_ID';
486:
487: cursor c_asg_details(p_assignment_id number,l_person_id number) is
488: select position_id
489: from per_all_assignments_f
490: where assignment_id = p_assignment_id
491: and person_id = l_person_id
492: and primary_flag = 'Y'
493: and sysdate between effective_start_date and effective_end_date;

Line 1039: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,

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,
1043: p_pos_str_ver_id in per_pos_structure_elements.pos_structure_version_id%type,

Line 1048: p_next_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

1044: p_next_position_id out nocopy pqh_position_transactions.position_id%type,
1045: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1046: p_next_role_id out nocopy number,
1047: p_next_user_id out nocopy number,
1048: p_next_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
1049: p_status_flag out nocopy number)
1050: is
1051: l_applicable_flag boolean := FALSE;
1052: l_proc varchar2(256) := g_package||'next_applicable' ;

Line 1137: p_cur_assignment_id in per_all_assignments_f.assignment_id%type,

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,
1141: p_applicable_flag out nocopy boolean)

Line 1139: p_assignment_id out nocopy per_all_assignments_f.assignment_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,
1141: p_applicable_flag out nocopy boolean)
1142: is
1143: l_value_date date := trunc(sysdate);

Line 1146: l_cur_assignment_id per_all_assignments_f.assignment_id%type;

1142: is
1143: l_value_date date := trunc(sysdate);
1144: l_from_clause varchar2(2000) ;
1145: l_can_approve boolean := FALSE;
1146: l_cur_assignment_id per_all_assignments_f.assignment_id%type;
1147: l_proc varchar2(256) := g_package||'next_applicable_assignment' ;
1148: begin
1149: p_applicable_flag := FALSE;
1150: p_status_flag := 0;

Line 1446: from per_all_assignments_f

1442: p_value_date in date,
1443: p_applicable_flag out nocopy boolean)
1444: as
1445: cursor c1 is select person_id
1446: from per_all_assignments_f
1447: where position_id = p_position_id
1448: and primary_flag = 'Y'
1449: and p_value_date between effective_start_date and effective_end_date;
1450: l_person_id fnd_user.employee_id%type;

Line 1567: p_assignment_id out nocopy per_all_assignments_f.assignment_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,
1570: p_status_flag out nocopy number,
1571: p_history_flag out nocopy boolean,

Line 1568: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_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,
1570: p_status_flag out nocopy number,
1571: p_history_flag out nocopy boolean,
1572: p_range_name out nocopy pqh_attribute_ranges.range_name%type,

Line 1569: p_old_assignment_id out nocopy per_all_assignments_f.assignment_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,
1570: p_status_flag out nocopy number,
1571: p_history_flag out nocopy boolean,
1572: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
1573: p_can_approve out nocopy boolean)

Line 1795: procedure person_on_assignment(p_assignment_id in per_all_assignments_f.assignment_id%type,

1791: p_can_approve := null;
1792: raise;
1793: end applicable_next_user;
1794:
1795: procedure person_on_assignment(p_assignment_id in per_all_assignments_f.assignment_id%type,
1796: p_value_date in date,
1797: p_person_id out nocopy fnd_user.employee_id%type )
1798: as
1799: cursor c1 is select person_id

Line 1800: from per_all_assignments_f

1796: p_value_date in date,
1797: p_person_id out nocopy fnd_user.employee_id%type )
1798: as
1799: cursor c1 is select person_id
1800: from per_all_assignments_f
1801: where assignment_id = p_assignment_id
1802: and p_value_date between effective_start_date and effective_end_date;
1803: l_proc varchar2(256) := g_package||'person_on_assignment';
1804: begin

Line 2005: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,

2001: p_pos_str_id in per_pos_structure_versions.position_structure_id%type,
2002: p_cur_user_id in out nocopy fnd_user.user_id%type,
2003: p_cur_user_name in out nocopy fnd_user.user_name%type,
2004: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
2005: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
2006: p_cur_person_id out nocopy fnd_user.employee_id%type,
2007: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2008: p_old_pos_str_id out nocopy per_pos_structure_versions.position_structure_id%type,
2009: p_position_id out nocopy pqh_position_transactions.position_id%type,

Line 2007: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

2003: p_cur_user_name in out nocopy fnd_user.user_name%type,
2004: p_pos_str_ver_id out nocopy per_pos_structure_elements.pos_structure_version_id%type,
2005: p_cur_position_id out nocopy per_all_assignments_f.position_id%type,
2006: p_cur_person_id out nocopy fnd_user.employee_id%type,
2007: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2008: p_old_pos_str_id out nocopy per_pos_structure_versions.position_structure_id%type,
2009: p_position_id out nocopy pqh_position_transactions.position_id%type,
2010: p_status_flag out nocopy number,
2011: p_can_approve out nocopy boolean,

Line 2180: p_old_assignment_id in per_all_assignments_f.assignment_id%type,

2176: procedure assignment_check(p_history_flag in boolean,
2177: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
2178: p_from_clause in pqh_table_route.from_clause%type,
2179: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
2180: p_old_assignment_id in per_all_assignments_f.assignment_id%type,
2181: p_value_date in date,
2182: p_cur_user_id in out nocopy fnd_user.user_id%type,
2183: p_cur_user_name in out nocopy fnd_user.user_name%type,
2184: p_cur_person_id out nocopy fnd_user.employee_id%type,

Line 2185: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

2181: p_value_date in date,
2182: p_cur_user_id in out nocopy fnd_user.user_id%type,
2183: p_cur_user_name in out nocopy fnd_user.user_name%type,
2184: p_cur_person_id out nocopy fnd_user.employee_id%type,
2185: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2186: p_person_id out nocopy per_all_assignments_f.person_id%type,
2187: p_status_flag out nocopy number,
2188: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2189: p_old_can_approve out nocopy boolean,

Line 2186: p_person_id out nocopy per_all_assignments_f.person_id%type,

2182: p_cur_user_id in out nocopy fnd_user.user_id%type,
2183: p_cur_user_name in out nocopy fnd_user.user_name%type,
2184: p_cur_person_id out nocopy fnd_user.employee_id%type,
2185: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2186: p_person_id out nocopy per_all_assignments_f.person_id%type,
2187: p_status_flag out nocopy number,
2188: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2189: p_old_can_approve out nocopy boolean,
2190: p_can_approve out nocopy boolean,

Line 2188: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

2184: p_cur_person_id out nocopy fnd_user.employee_id%type,
2185: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2186: p_person_id out nocopy per_all_assignments_f.person_id%type,
2187: p_status_flag out nocopy number,
2188: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
2189: p_old_can_approve out nocopy boolean,
2190: p_can_approve out nocopy boolean,
2191: p_applicable_flag out nocopy boolean )
2192: as

Line 2193: l_old_assignment_id per_all_assignments_f.assignment_id%type;

2189: p_old_can_approve out nocopy boolean,
2190: p_can_approve out nocopy boolean,
2191: p_applicable_flag out nocopy boolean )
2192: as
2193: l_old_assignment_id per_all_assignments_f.assignment_id%type;
2194: l_applicable_flag boolean ;
2195: l_override_approver boolean;
2196: l_error_flag boolean := FALSE ;
2197: l_proc varchar2(256) := g_package||'assignment_check';

Line 2881: p_assignment_id in per_all_assignments_f.assignment_id%type,

2877: end list_range_check;
2878:
2879: procedure assignment_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
2880: p_from_clause in pqh_table_route.from_clause%type,
2881: p_assignment_id in per_all_assignments_f.assignment_id%type,
2882: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
2883: p_value_date in date,
2884: p_used_for in varchar2 default null,
2885: p_applicable_flag out nocopy boolean,

Line 3643: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,

3639: end rl_member_applicable;
3640:
3641: procedure su_next_user(p_cur_assignment_id in number,
3642: p_value_date in date,
3643: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
3644: p_status_flag out nocopy number) as
3645: l_person_id per_all_assignments_f.supervisor_id%type;
3646: l_position_id per_all_assignments_f.position_id%type;
3647: cursor c2 is select supervisor_id

Line 3645: l_person_id per_all_assignments_f.supervisor_id%type;

3641: procedure su_next_user(p_cur_assignment_id in number,
3642: p_value_date in date,
3643: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
3644: p_status_flag out nocopy number) as
3645: l_person_id per_all_assignments_f.supervisor_id%type;
3646: l_position_id per_all_assignments_f.position_id%type;
3647: cursor c2 is select supervisor_id
3648: from per_all_assignments_f
3649: where assignment_id = p_cur_assignment_id

Line 3646: l_position_id per_all_assignments_f.position_id%type;

3642: p_value_date in date,
3643: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
3644: p_status_flag out nocopy number) as
3645: l_person_id per_all_assignments_f.supervisor_id%type;
3646: l_position_id per_all_assignments_f.position_id%type;
3647: cursor c2 is select supervisor_id
3648: from per_all_assignments_f
3649: where assignment_id = p_cur_assignment_id
3650: and primary_flag ='Y'

Line 3648: from per_all_assignments_f

3644: p_status_flag out nocopy number) as
3645: l_person_id per_all_assignments_f.supervisor_id%type;
3646: l_position_id per_all_assignments_f.position_id%type;
3647: cursor c2 is select supervisor_id
3648: from per_all_assignments_f
3649: where assignment_id = p_cur_assignment_id
3650: and primary_flag ='Y'
3651: and p_value_date between effective_start_date and effective_end_date;
3652: l_proc varchar2(256) := g_package||'su_next_user';

Line 3693: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type) as

3689: procedure user_assignment(p_value_date in date,
3690: p_user_id in out nocopy fnd_user.user_id%type,
3691: p_user_name in out nocopy fnd_user.user_name%type,
3692: p_person_id out nocopy fnd_user.employee_id%type,
3693: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type) as
3694: l_error_flag boolean := FALSE;
3695: l_person_name varchar2(240);
3696: l_user_id fnd_user.user_id%type := p_user_id;
3697: l_user_name fnd_user.user_name%type := p_user_name;

Line 3756: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type) as

3752: p_user_id in out nocopy fnd_user.user_id%type,
3753: p_user_name in out nocopy fnd_user.user_name%type,
3754: p_person_id out nocopy fnd_user.employee_id%type,
3755: p_position_id out nocopy pqh_position_transactions.position_id%type,
3756: p_assignment_id out nocopy per_all_assignments_f.assignment_id%type) as
3757: l_error_flag boolean := FALSE;
3758: l_proc varchar2(256) := g_package||'user_position_and_assignment';
3759: l_effective_date date;
3760: l_person_name varchar2(240);