DBA Data[Home] [Help]

APPS.PQH_WORKFLOW dependencies on FND_USER

Line 26: l_user_id fnd_user.user_id%type;

22: end;
23: procedure get_user_name_details(p_user_name in varchar2,
24: p_user_id out nocopy number,
25: p_employee_id out nocopy varchar2) is
26: l_user_id fnd_user.user_id%type;
27: l_employee_id fnd_user.employee_id%type;
28: begin
29: select user_id,employee_id
30: into l_user_id,l_employee_id

Line 27: l_employee_id fnd_user.employee_id%type;

23: procedure get_user_name_details(p_user_name in varchar2,
24: p_user_id out nocopy number,
25: p_employee_id out nocopy varchar2) is
26: l_user_id fnd_user.user_id%type;
27: l_employee_id fnd_user.employee_id%type;
28: begin
29: select user_id,employee_id
30: into l_user_id,l_employee_id
31: from fnd_user

Line 31: from fnd_user

27: l_employee_id fnd_user.employee_id%type;
28: begin
29: select user_id,employee_id
30: into l_user_id,l_employee_id
31: from fnd_user
32: where user_name = p_user_name;
33: p_user_id := l_user_id;
34: p_employee_id := l_employee_id;
35: exception

Line 44: l_user_name fnd_user.user_name%type;

40:
41: procedure get_user_id_details(p_user_id in number,
42: p_user_name out nocopy varchar2,
43: p_employee_id out nocopy varchar2) is
44: l_user_name fnd_user.user_name%type;
45: l_employee_id fnd_user.employee_id%type;
46: begin
47: select user_name,employee_id
48: into l_user_name,l_employee_id

Line 45: l_employee_id fnd_user.employee_id%type;

41: procedure get_user_id_details(p_user_id in number,
42: p_user_name out nocopy varchar2,
43: p_employee_id out nocopy varchar2) is
44: l_user_name fnd_user.user_name%type;
45: l_employee_id fnd_user.employee_id%type;
46: begin
47: select user_name,employee_id
48: into l_user_name,l_employee_id
49: from fnd_user

Line 49: from fnd_user

45: l_employee_id fnd_user.employee_id%type;
46: begin
47: select user_name,employee_id
48: into l_user_name,l_employee_id
49: from fnd_user
50: where user_id = p_user_id;
51: p_user_name := l_user_name;
52: p_employee_id := l_employee_id;
53: exception

Line 146: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr

142: p_session_date in date) return number is
143: l_role_id number;
144: cursor c_get_user_role (p_user_id number) is
145: select decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0) role_id
146: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr
147: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
148: and p_session_date between ppf.effective_start_date and ppf.effective_end_date
149: and usr.employee_id = ppf.person_id
150: and nvl(pei.pei_information5,'Y')='Y'

Line 173: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

169: l_position_name hr_all_positions_f.name%type;
170: l_assignment_id number;
171: l_workflow_enable_flag pqh_transaction_categories.workflow_enable_flag%type;
172: l_proc varchar2(256) := g_package||'get_default_role';
173: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
174:
175: cursor c_get_employee(p_user_id number) is
176: select employee_id
177: from fnd_user

Line 177: from fnd_user

173: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
174:
175: cursor c_get_employee(p_user_id number) is
176: select employee_id
177: from fnd_user
178: where user_id = p_user_id;
179:
180: cursor c_get_txn_cat (p_transaction_category_id number) IS
181: select member_cd, workflow_enable_flag

Line 188: , fnd_user fu

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'
192: AND asg.assignment_type = 'E' -- Bug 7422915

Line 309: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

305: l_position_id number;
306: l_assignment_id number;
307: l_proc varchar2(256) := g_package||'check_user_pos_details';
308: l_effective_date date;
309: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
310: l_position_name varchar2(240);
311: l_person_name varchar2(240);
312: begin
313: hr_utility.set_location('Entering '||l_proc,10);

Line 353: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

349: p_person_id in number) return number is
350: l_error_cd number := 0 ;
351: l_assignment_id number;
352: l_position_id number;
353: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
354: l_person_name varchar2(240);
355: l_proc varchar2(256) := g_package||'check_user_asg_details';
356: begin
357: hr_utility.set_location('Entering '||l_proc,10);

Line 383: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr

379: cursor c1 is select role_name from pqh_roles
380: where role_id = p_role_id
381: and nvl(enable_flag,'X') = 'Y';
382: cursor c3 is select 'X'
383: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr
384: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
385: and p_session_date between ppf.effective_start_date and ppf.effective_end_date
386: and usr.employee_id = ppf.person_id
387: and decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0)= p_role_id

Line 436: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr

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'
436: from per_people_extra_info pei , per_all_people_f ppf, fnd_user usr
437: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
438: and sysdate between ppf.effective_start_date and ppf.effective_end_date
439: and usr.employee_id = ppf.person_id
440: and decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0)= p_role_id

Line 479: select employee_id from fnd_user

475: l_rht_member_id number;
476: l_rht_position_id number;
477: l_rht_assignment_id number;
478: cursor c_person_details is
479: select employee_id from fnd_user
480: where user_id = p_user_id;
481: cursor c_position_role(p_position_id number) is
482: SELECT decode(information_type, 'PQH_POS_ROLE_ID' , to_number(poei_information3), -1) ROLE_ID
483: from per_position_extra_info pei

Line 503: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

499: and sysdate between ppf.effective_start_date and ppf.effective_end_date
500: and ppf.person_id = p_person_id
501: and nvl(pei.pei_information5,'Y')='Y'
502: and nvl(pei.pei_information4,'N')='Y';
503: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
504: l_person_name varchar2(240);
505: l_proc varchar2(71) := g_package||'get_routinghist_role' ;
506: BEGIN
507: hr_utility.set_location('entering'||l_proc,10);

Line 1230: l_member_user_id fnd_user.user_id%type;

1226: l_from_clause varchar2(2000) ;
1227: l_can_approve boolean := FALSE;
1228: l_error_flag boolean := FALSE;
1229: l_member_role_id pqh_roles.role_id%type;
1230: l_member_user_id fnd_user.user_id%type;
1231: l_cur_member_id number;
1232: l_proc varchar2(256) := g_package||'next_applicable_member' ;
1233: begin
1234: p_applicable_flag := FALSE;

Line 1450: l_person_id fnd_user.employee_id%type;

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;
1451: l_proc varchar2(256) := g_package||'Position_occupied';
1452: l_error_flag boolean := FALSE ;
1453: begin
1454: hr_utility.set_location('Entering '||l_proc,10);

Line 1502: procedure person_has_user(p_person_id in fnd_user.employee_id%type,

1498: p_applicable_flag := null;
1499: raise;
1500: end position_occupied;
1501:
1502: procedure person_has_user(p_person_id in fnd_user.employee_id%type,
1503: p_value_date in date,
1504: p_applicable_flag out nocopy boolean)
1505: as
1506: l_user_id fnd_user.user_id%type;

Line 1506: l_user_id fnd_user.user_id%type;

1502: procedure person_has_user(p_person_id in fnd_user.employee_id%type,
1503: p_value_date in date,
1504: p_applicable_flag out nocopy boolean)
1505: as
1506: l_user_id fnd_user.user_id%type;
1507: cursor c1 is select user_id
1508: from fnd_user
1509: where employee_id = p_person_id
1510: and p_value_date between nvl(start_date,p_value_date)

Line 1508: from fnd_user

1504: p_applicable_flag out nocopy boolean)
1505: as
1506: l_user_id fnd_user.user_id%type;
1507: cursor c1 is select user_id
1508: from fnd_user
1509: where employee_id = p_person_id
1510: and p_value_date between nvl(start_date,p_value_date)
1511: and nvl(end_date,p_value_date);
1512: l_proc varchar2(256) := g_package||'person_has_user';

Line 1543: p_cur_user_id in out nocopy fnd_user.user_id%type,

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,
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,

Line 1544: p_cur_user_name in out nocopy fnd_user.user_name%type,

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,
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,

Line 1552: p_person_id out nocopy fnd_user.employee_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,
1555: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1556: p_member_role_id out nocopy pqh_roles.role_id%type,

Line 1557: p_member_user_id out nocopy fnd_user.user_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,
1555: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1556: p_member_role_id out nocopy pqh_roles.role_id%type,
1557: p_member_user_id out nocopy fnd_user.user_id%type,
1558: p_cur_person_id out nocopy fnd_user.employee_id%type,
1559: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1560: p_position_id out nocopy pqh_position_transactions.position_id%type,
1561: p_old_position_id out nocopy pqh_position_transactions.position_id%type,

Line 1558: p_cur_person_id out nocopy fnd_user.employee_id%type,

1554: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1555: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
1556: p_member_role_id out nocopy pqh_roles.role_id%type,
1557: p_member_user_id out nocopy fnd_user.user_id%type,
1558: p_cur_person_id out nocopy fnd_user.employee_id%type,
1559: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1560: p_position_id out nocopy pqh_position_transactions.position_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,

Line 1578: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;

1574: as
1575: l_from_clause pqh_table_route.from_clause%type;
1576: l_applicable_flag boolean;
1577: l_value_date date := trunc(sysdate);
1578: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
1579: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
1580: l_user_active_role_id pqh_roles.role_id%type := p_user_active_role_id;
1581: l_user_active_role_name pqh_roles.role_name%type := p_user_active_role_name;
1582:

Line 1579: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;

1575: l_from_clause pqh_table_route.from_clause%type;
1576: l_applicable_flag boolean;
1577: l_value_date date := trunc(sysdate);
1578: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
1579: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
1580: l_user_active_role_id pqh_roles.role_id%type := p_user_active_role_id;
1581: l_user_active_role_name pqh_roles.role_name%type := p_user_active_role_name;
1582:
1583: -- variable used to hold the value of approve_flag for thenext user

Line 1797: p_person_id out nocopy fnd_user.employee_id%type )

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
1800: from per_all_assignments_f
1801: where assignment_id = p_assignment_id

Line 1835: p_cur_user_id in out nocopy fnd_user.user_id%type,

1831: p_old_user_id in number,
1832: p_old_role_id in number,
1833: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
1834: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
1835: p_cur_user_id in out nocopy fnd_user.user_id%type,
1836: p_cur_user_name in out nocopy fnd_user.user_name%type,
1837: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1838: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1839: p_member_role_id out nocopy pqh_routing_list_members.role_id%type,

Line 1836: p_cur_user_name in out nocopy fnd_user.user_name%type,

1832: p_old_role_id in number,
1833: p_user_active_role_id in out nocopy pqh_roles.role_id%type,
1834: p_user_active_role_name in out nocopy pqh_roles.role_name%type,
1835: p_cur_user_id in out nocopy fnd_user.user_id%type,
1836: p_cur_user_name in out nocopy fnd_user.user_name%type,
1837: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1838: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1839: p_member_role_id out nocopy pqh_routing_list_members.role_id%type,
1840: p_member_user_id out nocopy pqh_routing_list_members.user_id%type,

Line 1848: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;

1844: p_can_approve out nocopy boolean )
1845: as
1846: l_user_active_role_id pqh_roles.role_id%type := p_user_active_role_id;
1847: l_user_active_role_name pqh_roles.role_name%type := p_user_active_role_name;
1848: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
1849: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
1850:
1851: l_member_id pqh_routing_list_members.routing_list_member_id%type;
1852: l_member_flag boolean ;

Line 1849: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;

1845: as
1846: l_user_active_role_id pqh_roles.role_id%type := p_user_active_role_id;
1847: l_user_active_role_name pqh_roles.role_name%type := p_user_active_role_name;
1848: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
1849: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
1850:
1851: l_member_id pqh_routing_list_members.routing_list_member_id%type;
1852: l_member_flag boolean ;
1853: l_applicable_flag boolean;

Line 2002: p_cur_user_id in out nocopy fnd_user.user_id%type,

1998: p_from_clause in pqh_table_route.from_clause%type,
1999: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
2000: p_old_position_id in pqh_position_transactions.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,

Line 2003: p_cur_user_name in out nocopy fnd_user.user_name%type,

1999: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
2000: p_old_position_id in pqh_position_transactions.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,

Line 2006: p_cur_person_id out nocopy fnd_user.employee_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,
2010: p_status_flag out nocopy number,

Line 2015: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;

2011: p_can_approve out nocopy boolean,
2012: p_old_can_approve out nocopy boolean,
2013: p_applicable_flag out nocopy boolean )
2014: as
2015: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
2016: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
2017: l_cur_position_id pqh_position_transactions.position_id%type;
2018: l_override_approver boolean ;
2019: l_error_flag boolean := FALSE;

Line 2016: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;

2012: p_old_can_approve out nocopy boolean,
2013: p_applicable_flag out nocopy boolean )
2014: as
2015: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
2016: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
2017: l_cur_position_id pqh_position_transactions.position_id%type;
2018: l_override_approver boolean ;
2019: l_error_flag boolean := FALSE;
2020: l_member_flag varchar2(30) ;

Line 2182: p_cur_user_id in out nocopy fnd_user.user_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,
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,

Line 2183: p_cur_user_name in out nocopy fnd_user.user_name%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,
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,

Line 2184: p_cur_person_id out nocopy fnd_user.employee_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,
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,

Line 2198: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;

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';
2198: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
2199: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
2200: begin
2201: hr_utility.set_location('Entering '||l_proc,10);
2202: if p_tran_cat_id is null then

Line 2199: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;

2195: l_override_approver boolean;
2196: l_error_flag boolean := FALSE ;
2197: l_proc varchar2(256) := g_package||'assignment_check';
2198: l_cur_user_id fnd_user.user_id%type := p_cur_user_id;
2199: l_cur_user_name fnd_user.user_name%type := p_cur_user_name;
2200: begin
2201: hr_utility.set_location('Entering '||l_proc,10);
2202: if p_tran_cat_id is null then
2203: hr_utility.set_location('Trans_cat reqd '||l_proc,20);

Line 2926: l_person_id fnd_user.employee_id%type;

2922: l_in_range boolean ;
2923: l_error_flag boolean := FALSE;
2924: l_approver_flag boolean;
2925: l_override_approver boolean;
2926: l_person_id fnd_user.employee_id%type;
2927: l_proc varchar2(256) := g_package||'assignment_applicable';
2928: begin
2929: hr_utility.set_location('Entering '||l_proc,10);
2930: if p_tran_cat_id is null then

Line 3690: p_user_id in out nocopy fnd_user.user_id%type,

3686: raise;
3687: end su_next_user;
3688:
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;

Line 3691: p_user_name in out nocopy fnd_user.user_name%type,

3687: end su_next_user;
3688:
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);

Line 3692: p_person_id out nocopy fnd_user.employee_id%type,

3688:
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;

Line 3696: l_user_id fnd_user.user_id%type := p_user_id;

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;
3698: l_position_id number;
3699: l_proc varchar2(256) := g_package||'user_assignment';
3700: begin

Line 3697: l_user_name fnd_user.user_name%type := p_user_name;

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;
3698: l_position_id number;
3699: l_proc varchar2(256) := g_package||'user_assignment';
3700: begin
3701: hr_utility.set_location('Entering '||l_proc,10);

Line 3752: p_user_id in out nocopy fnd_user.user_id%type,

3748: raise;
3749: end user_assignment ;
3750:
3751: procedure user_position_and_assignment(p_value_date in date,
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

Line 3753: p_user_name in out nocopy fnd_user.user_name%type,

3749: end user_assignment ;
3750:
3751: procedure user_position_and_assignment(p_value_date in date,
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;

Line 3754: p_person_id out nocopy fnd_user.employee_id%type,

3750:
3751: procedure user_position_and_assignment(p_value_date in date,
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';

Line 3761: l_user_id fnd_user.user_id%type := p_user_id;

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);
3761: l_user_id fnd_user.user_id%type := p_user_id;
3762: l_user_name fnd_user.user_name%type := p_user_name;
3763: l_position varchar2(240);
3764: begin
3765: hr_utility.set_location('Entering '||l_proc,10);

Line 3762: l_user_name fnd_user.user_name%type := p_user_name;

3758: l_proc varchar2(256) := g_package||'user_position_and_assignment';
3759: l_effective_date date;
3760: l_person_name varchar2(240);
3761: l_user_id fnd_user.user_id%type := p_user_id;
3762: l_user_name fnd_user.user_name%type := p_user_name;
3763: l_position varchar2(240);
3764: begin
3765: hr_utility.set_location('Entering '||l_proc,10);
3766: if p_user_id is null and p_user_name is null then

Line 4196: p_user_id in out nocopy fnd_user.user_id%type,

4192: p_old_role_id in number default null,
4193: p_old_member_id in number default null,
4194: p_role_id in out nocopy pqh_roles.role_id%type,
4195: p_role_name in out nocopy pqh_roles.role_name%type,
4196: p_user_id in out nocopy fnd_user.user_id%type,
4197: p_user_name in out nocopy fnd_user.user_name%type,
4198: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
4199: p_member_flag out nocopy boolean) as
4200:

Line 4197: p_user_name in out nocopy fnd_user.user_name%type,

4193: p_old_member_id in number default null,
4194: p_role_id in out nocopy pqh_roles.role_id%type,
4195: p_role_name in out nocopy pqh_roles.role_name%type,
4196: p_user_id in out nocopy fnd_user.user_id%type,
4197: p_user_name in out nocopy fnd_user.user_name%type,
4198: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
4199: p_member_flag out nocopy boolean) as
4200:
4201: l_role_id pqh_roles.role_id%type := p_role_id;

Line 4203: l_user_id fnd_user.user_id%type := p_user_id;

4199: p_member_flag out nocopy boolean) as
4200:
4201: l_role_id pqh_roles.role_id%type := p_role_id;
4202: l_role_name pqh_roles.role_name%type := p_role_name;
4203: l_user_id fnd_user.user_id%type := p_user_id;
4204: l_user_name fnd_user.user_name%type := p_user_name;
4205:
4206: cursor c1 is select role_id,role_name
4207: from pqh_roles

Line 4204: l_user_name fnd_user.user_name%type := p_user_name;

4200:
4201: l_role_id pqh_roles.role_id%type := p_role_id;
4202: l_role_name pqh_roles.role_name%type := p_role_name;
4203: l_user_id fnd_user.user_id%type := p_user_id;
4204: l_user_name fnd_user.user_name%type := p_user_name;
4205:
4206: cursor c1 is select role_id,role_name
4207: from pqh_roles
4208: where role_name = nvl(p_role_name,role_name)

Line 4607: l_user_id fnd_user.user_id%type := fnd_profile.value('USER_ID');

4603: l_proc varchar2(256) := g_package||'valid_user_opening';
4604: l_freeze_status_cd varchar2(30);
4605: l_member_cd varchar2(30);
4606: l_txn_catg_name varchar2(240);
4607: l_user_id fnd_user.user_id%type := fnd_profile.value('USER_ID');
4608: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
4609: l_scope_name varchar2(240);
4610: l_default_role_id number;
4611: l_routing_role_id number;

Line 4608: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');

4604: l_freeze_status_cd varchar2(30);
4605: l_member_cd varchar2(30);
4606: l_txn_catg_name varchar2(240);
4607: l_user_id fnd_user.user_id%type := fnd_profile.value('USER_ID');
4608: l_user_name fnd_user.user_name%type := fnd_profile.value('USERNAME');
4609: l_scope_name varchar2(240);
4610: l_default_role_id number;
4611: l_routing_role_id number;
4612: l_routing_history_id number;

Line 4626: from fnd_user

4622: where transaction_category_id = p_transaction_category_id
4623: and nvl(enable_flag,'Y') = 'Y';
4624: cursor c_get_person_id(p_user_id number) is
4625: select employee_id
4626: from fnd_user
4627: where user_id = p_user_id;
4628: cursor c_emp_term(p_date date) is
4629: select ppos.date_start, ppos.actual_termination_date
4630: from per_periods_of_service ppos

Line 4864: from per_people_extra_info pei , fnd_user usr

4860: --
4861: Cursor csr_def_rl is
4862: Select
4863: decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0) role_id
4864: from per_people_extra_info pei , fnd_user usr
4865: WHERE usr.user_id = p_user_id
4866: and usr.employee_id = pei.person_id
4867: and information_type = 'PQH_ROLE_USERS'
4868: /** Check if default role **/