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_ROLES

Line 130: from pqh_roles

126: end get_transaction_category_name;
127:
128: function get_role_name(p_role_id in number) return varchar2 is
129: cursor c1 is select role_name
130: from pqh_roles
131: where role_id = p_role_id;
132: l_role_name pqh_roles.role_name%type;
133: begin
134: open c1;

Line 132: l_role_name pqh_roles.role_name%type;

128: function get_role_name(p_role_id in number) return varchar2 is
129: cursor c1 is select role_name
130: from pqh_roles
131: where role_id = p_role_id;
132: l_role_name pqh_roles.role_name%type;
133: begin
134: open c1;
135: fetch c1 into l_role_name;
136: close c1;

Line 285: l_role_name pqh_roles.role_name%type;

281: where role_id = p_role_id
282: and transaction_category_id = p_transaction_category_id
283: and enable_flag = 'Y';
284: l_template_id pqh_role_templates.template_id%type;
285: l_role_name pqh_roles.role_name%type;
286: l_transaction_category_name pqh_transaction_categories.name%type;
287: begin
288: open c1;
289: fetch c1 into l_template_id;

Line 379: cursor c1 is select role_name from pqh_roles

375:
376: function check_user_role_details(p_role_id in number,
377: p_user_id in number,
378: p_session_date in date) return number is
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

Line 391: l_role_name pqh_roles.role_name%type;

387: and decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0)= p_role_id
388: and nvl(pei.pei_information5,'Y')='Y'
389: and usr.user_id = p_user_id ;
390: l_error_cd number := 0;
391: l_role_name pqh_roles.role_name%type;
392: l_dummy varchar2(30);
393: l_proc varchar2(256) := g_package||'check_user_role_details';
394: begin
395: hr_utility.set_location('Entering '||l_proc,10);

Line 1229: l_member_role_id pqh_roles.role_id%type;

1225: l_value_date date := trunc(sysdate);
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

Line 1545: p_user_active_role_id in out nocopy pqh_roles.role_id%type,

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,
1549: p_old_member_cd out nocopy pqh_transaction_categories.member_cd%type,

Line 1546: p_user_active_role_name in out nocopy pqh_roles.role_name%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,
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,

Line 1556: p_member_role_id out nocopy pqh_roles.role_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,
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,

Line 1580: l_user_active_role_id pqh_roles.role_id%type := p_user_active_role_id;

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
1584: l_can_approve boolean;

Line 1581: l_user_active_role_name pqh_roles.role_name%type := p_user_active_role_name;

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
1584: l_can_approve boolean;
1585:

Line 1833: p_user_active_role_id in out nocopy pqh_roles.role_id%type,

1829: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1830: p_old_member_id in pqh_routing_list_members.routing_list_member_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,

Line 1834: p_user_active_role_name in out nocopy pqh_roles.role_name%type,

1830: p_old_member_id in pqh_routing_list_members.routing_list_member_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,

Line 1846: l_user_active_role_id pqh_roles.role_id%type := p_user_active_role_id;

1842: p_applicable_flag out nocopy boolean,
1843: p_old_can_approve out nocopy boolean,
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:

Line 1847: l_user_active_role_name pqh_roles.role_name%type := p_user_active_role_name;

1843: p_old_can_approve out nocopy boolean,
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;

Line 4194: p_role_id in out nocopy pqh_roles.role_id%type,

4190: procedure rlm_user_seq( p_routing_list_id in pqh_routing_lists.routing_list_id%type,
4191: p_old_user_id in number default null,
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,

Line 4195: p_role_name in out nocopy pqh_roles.role_name%type,

4191: p_old_user_id in number default null,
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

Line 4201: l_role_id pqh_roles.role_id%type := p_role_id;

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

Line 4202: l_role_name pqh_roles.role_name%type := p_role_name;

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

Line 4207: from pqh_roles

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)
4209: and role_id = nvl(p_role_id,role_id)
4210: and nvl(enable_flag,'X') ='Y';
4211: cursor c2 is select routing_list_member_id

Line 4859: l_role_id pqh_roles.role_id%type;

4855: function get_user_default_role(p_user_id in number)
4856: return Number is
4857: --
4858: l_proc varchar2(256) := g_package||'get_user_default_role';
4859: l_role_id pqh_roles.role_id%type;
4860: --
4861: Cursor csr_def_rl is
4862: Select
4863: decode(information_type, 'PQH_ROLE_USERS', to_number(pei.pei_information3), 0) role_id