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_LIST_MEMBERS

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 754: from pqh_routing_list_members

750: procedure get_role_user(p_member_id in number,
751: p_role_id out nocopy number,
752: p_user_id out nocopy number ) is
753: cursor c1 is select role_id,user_id
754: from pqh_routing_list_members
755: where routing_list_member_id = p_member_id ;
756: begin
757: open c1;
758: fetch c1 into p_role_id,p_user_id;

Line 855: from pqh_routing_categories rc,pqh_routing_list_members rlm

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
857: and rc.routing_list_id = rlm.routing_list_id
858: and rlm.routing_list_member_id = l_member_id
859: and nvl(rc.enable_flag,'X') = 'Y'

Line 1040: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%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,
1044: p_next_position_id out nocopy pqh_position_transactions.position_id%type,

Line 1045: p_next_member_id out nocopy 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,
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)

Line 1216: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,

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,
1220: p_role_id out nocopy number,

Line 1219: p_member_id out nocopy pqh_routing_list_members.routing_list_member_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,
1220: p_role_id out nocopy number,
1221: p_user_id out nocopy number,
1222: p_status_flag out nocopy number,
1223: p_applicable_flag out nocopy boolean)

Line 1551: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%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,
1555: p_old_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,

Line 1553: p_old_member_id out nocopy pqh_routing_list_members.routing_list_member_id%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,
1557: p_member_user_id out nocopy fnd_user.user_id%type,

Line 1559: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_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,
1563: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,

Line 1830: p_old_member_id in pqh_routing_list_members.routing_list_member_id%type,

1826: p_history_flag in boolean,
1827: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1828: p_from_clause in pqh_table_route.from_clause%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,

Line 1837: p_cur_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

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,
1841: p_status_flag out nocopy number,

Line 1838: p_member_id out nocopy pqh_routing_list_members.routing_list_member_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,
1841: p_status_flag out nocopy number,
1842: p_applicable_flag out nocopy boolean,

Line 1839: p_member_role_id out nocopy pqh_routing_list_members.role_id%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,
1841: p_status_flag out nocopy number,
1842: p_applicable_flag out nocopy boolean,
1843: p_old_can_approve out nocopy boolean,

Line 1840: p_member_user_id out nocopy pqh_routing_list_members.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,
1841: p_status_flag out nocopy number,
1842: p_applicable_flag out nocopy boolean,
1843: p_old_can_approve out nocopy boolean,
1844: p_can_approve out nocopy boolean )

Line 1851: l_member_id pqh_routing_list_members.routing_list_member_id%type;

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;
1854: l_error_flag boolean := FALSE ;
1855: l_override_approver boolean ;

Line 3395: p_member_id in pqh_routing_list_members.routing_list_member_id%type,

3391: end ps_element_applicable;
3392:
3393: procedure rl_member_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
3394: p_from_clause in pqh_table_route.from_clause%type,
3395: p_member_id in pqh_routing_list_members.routing_list_member_id%type,
3396: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
3397: p_used_for in varchar2 default null,
3398: p_applicable_flag out nocopy boolean,
3399: p_status_flag out nocopy number,

Line 3423: from pqh_routing_list_members

3419: and routing_category_id = p_routing_category_id
3420: and nvl(delete_flag,'N') = 'N'
3421: and nvl(enable_flag,'X') ='Y';
3422: cursor c4 is select approver_flag
3423: from pqh_routing_list_members
3424: where routing_list_member_id = p_member_id
3425: and nvl(enable_flag,'X') = 'Y';
3426: l_attribute_value_char varchar2(2000);
3427: l_attribute_value_num number ;

Line 3438: l_member_approve_flag pqh_routing_list_members.approver_flag%type;

3434: index by binary_integer;
3435: l_member_rules rule_tab;
3436: l_rule_cnt number := 0 ;
3437: l_in_range boolean ;
3438: l_member_approve_flag pqh_routing_list_members.approver_flag%type;
3439: l_error_flag boolean := FALSE;
3440: l_approver_flag boolean;
3441: l_override_approver boolean;
3442: l_role_id number;

Line 4198: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

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;
4202: l_role_name pqh_roles.role_name%type := p_role_name;

Line 4212: from pqh_routing_list_members

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
4212: from pqh_routing_list_members
4213: where routing_list_id = p_routing_list_id
4214: and role_id = p_role_id
4215: and user_id = p_user_id
4216: and nvl(enable_flag,'X') ='Y';

Line 4218: from pqh_routing_list_members

4214: and role_id = p_role_id
4215: and user_id = p_user_id
4216: and nvl(enable_flag,'X') ='Y';
4217: cursor c3 is select routing_list_member_id
4218: from pqh_routing_list_members
4219: where routing_list_id = p_routing_list_id
4220: and role_id = p_role_id and user_id is null
4221: and nvl(enable_flag,'X') ='Y';
4222:

Line 4225: from pqh_routing_list_members

4221: and nvl(enable_flag,'X') ='Y';
4222:
4223: -- finding new member based on old member and new routing list
4224: cursor c4 is select routing_list_member_id
4225: from pqh_routing_list_members
4226: where routing_list_id = p_routing_list_id
4227: and role_id = p_old_role_id
4228: and user_id = p_old_user_id
4229: and nvl(enable_flag,'X') ='Y';

Line 4231: from pqh_routing_list_members

4227: and role_id = p_old_role_id
4228: and user_id = p_old_user_id
4229: and nvl(enable_flag,'X') ='Y';
4230: cursor c5 is select routing_list_member_id
4231: from pqh_routing_list_members
4232: where routing_list_id = p_routing_list_id
4233: and role_id = p_old_role_id
4234: and (user_id is null or user_id = p_user_id)
4235: and nvl(enable_flag,'X') ='Y';

Line 4446: procedure rl_next_user(p_routing_list_id in pqh_routing_list_members.routing_list_id%type,

4442: p_status_flag := null;
4443: raise;
4444: end routing_current;
4445:
4446: procedure rl_next_user(p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
4447: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
4448: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
4449: p_role_id out nocopy pqh_routing_list_members.role_id%type,
4450: p_user_id out nocopy pqh_routing_list_members.user_id%type,

Line 4447: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,

4443: raise;
4444: end routing_current;
4445:
4446: procedure rl_next_user(p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
4447: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
4448: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
4449: p_role_id out nocopy pqh_routing_list_members.role_id%type,
4450: p_user_id out nocopy pqh_routing_list_members.user_id%type,
4451: p_status_flag out nocopy number)

Line 4448: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,

4444: end routing_current;
4445:
4446: procedure rl_next_user(p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
4447: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
4448: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
4449: p_role_id out nocopy pqh_routing_list_members.role_id%type,
4450: p_user_id out nocopy pqh_routing_list_members.user_id%type,
4451: p_status_flag out nocopy number)
4452: as

Line 4449: p_role_id out nocopy pqh_routing_list_members.role_id%type,

4445:
4446: procedure rl_next_user(p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
4447: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
4448: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
4449: p_role_id out nocopy pqh_routing_list_members.role_id%type,
4450: p_user_id out nocopy pqh_routing_list_members.user_id%type,
4451: p_status_flag out nocopy number)
4452: as
4453: cursor c1 is

Line 4450: p_user_id out nocopy pqh_routing_list_members.user_id%type,

4446: procedure rl_next_user(p_routing_list_id in pqh_routing_list_members.routing_list_id%type,
4447: p_cur_member_id in pqh_routing_list_members.routing_list_member_id%type,
4448: p_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
4449: p_role_id out nocopy pqh_routing_list_members.role_id%type,
4450: p_user_id out nocopy pqh_routing_list_members.user_id%type,
4451: p_status_flag out nocopy number)
4452: as
4453: cursor c1 is
4454: select routing_list_member_id,role_id,user_id

Line 4455: from pqh_routing_list_members

4451: p_status_flag out nocopy number)
4452: as
4453: cursor c1 is
4454: select routing_list_member_id,role_id,user_id
4455: from pqh_routing_list_members
4456: where routing_list_id = p_routing_list_id
4457: and seq_no = (select min(seq_no)
4458: from pqh_routing_list_members
4459: where routing_list_id = p_routing_list_id

Line 4458: from pqh_routing_list_members

4454: select routing_list_member_id,role_id,user_id
4455: from pqh_routing_list_members
4456: where routing_list_id = p_routing_list_id
4457: and seq_no = (select min(seq_no)
4458: from pqh_routing_list_members
4459: where routing_list_id = p_routing_list_id
4460: and seq_no > (select seq_no
4461: from pqh_routing_list_members
4462: where routing_list_id = p_routing_list_id

Line 4461: from pqh_routing_list_members

4457: and seq_no = (select min(seq_no)
4458: from pqh_routing_list_members
4459: where routing_list_id = p_routing_list_id
4460: and seq_no > (select seq_no
4461: from pqh_routing_list_members
4462: where routing_list_id = p_routing_list_id
4463: and routing_list_member_id = p_cur_member_id)
4464: and nvl(enable_flag,'X') = 'Y');
4465: cursor c2 is select routing_list_member_id,role_id,user_id

Line 4466: from pqh_routing_list_members

4462: where routing_list_id = p_routing_list_id
4463: and routing_list_member_id = p_cur_member_id)
4464: and nvl(enable_flag,'X') = 'Y');
4465: cursor c2 is select routing_list_member_id,role_id,user_id
4466: from pqh_routing_list_members
4467: where routing_list_id = p_routing_list_id
4468: and seq_no = (select min(seq_no)
4469: from pqh_routing_list_members
4470: where routing_list_id = p_routing_list_id

Line 4469: from pqh_routing_list_members

4465: cursor c2 is select routing_list_member_id,role_id,user_id
4466: from pqh_routing_list_members
4467: where routing_list_id = p_routing_list_id
4468: and seq_no = (select min(seq_no)
4469: from pqh_routing_list_members
4470: where routing_list_id = p_routing_list_id
4471: and nvl(enable_flag,'X') = 'Y');
4472: l_error_flag boolean := FALSE;
4473: l_proc varchar2(256) := g_package||'rl_next_user';