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_POSITION_TRANSACTIONS

Line 1042: p_cur_position_id in pqh_position_transactions.position_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,
1045: p_next_member_id out nocopy pqh_routing_list_members.routing_list_member_id%type,
1046: p_next_role_id out nocopy number,

Line 1044: p_next_position_id out nocopy pqh_position_transactions.position_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,
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,

Line 1314: p_cur_position_id in pqh_position_transactions.position_id%type,

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

Line 1317: p_position_id out nocopy pqh_position_transactions.position_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,
1318: p_status_flag out nocopy number,
1319: p_applicable_flag out nocopy boolean)
1320: is
1321: l_value_date date := trunc(sysdate);

Line 1326: l_cur_position_id pqh_position_transactions.position_id%type;

1322: l_from_clause varchar2(2000) ;
1323: l_can_approve boolean := FALSE;
1324: l_error_flag boolean := FALSE;
1325: l_pos_str_id pqh_routing_categories.position_structure_id%type;
1326: l_cur_position_id pqh_position_transactions.position_id%type;
1327: l_proc varchar2(256) := g_package||'next_applicable_position' ;
1328: begin
1329: p_applicable_flag := FALSE;
1330: p_status_flag := 0;

Line 1408: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,

1404: p_applicable_flag := null;
1405: raise;
1406: end next_applicable_position;
1407:
1408: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,
1409: p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type,
1410: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1411: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1412: p_trans_id in pqh_position_transactions.position_transaction_id%type,

Line 1412: p_trans_id in pqh_position_transactions.position_transaction_id%type,

1408: procedure position_applicable(p_position_id in pqh_position_transactions.position_id%type,
1409: p_pos_str_ver_id in per_pos_structure_versions.pos_structure_version_id%type,
1410: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
1411: p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
1412: p_trans_id in pqh_position_transactions.position_transaction_id%type,
1413: p_status_flag out nocopy number,
1414: p_can_approve out nocopy boolean,
1415: p_applicable_flag out nocopy boolean)
1416: as

Line 1441: procedure position_occupied(p_position_id in pqh_position_transactions.position_id%type,

1437: p_applicable_flag := null;
1438: raise;
1439: end;
1440:
1441: procedure position_occupied(p_position_id in pqh_position_transactions.position_id%type,
1442: p_value_date in date,
1443: p_applicable_flag out nocopy boolean)
1444: as
1445: cursor c1 is select person_id

Line 1560: p_position_id out nocopy pqh_position_transactions.position_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,
1564: p_old_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,

Line 1561: p_old_position_id out nocopy pqh_position_transactions.position_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,
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,

Line 1562: p_cur_position_id out nocopy pqh_position_transactions.position_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,
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,

Line 2000: p_old_position_id in pqh_position_transactions.position_id%type,

1996: p_value_date in date,
1997: p_tran_cat_id in pqh_transaction_categories.transaction_category_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,

Line 2009: p_position_id out nocopy pqh_position_transactions.position_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,
2012: p_old_can_approve out nocopy boolean,
2013: p_applicable_flag out nocopy boolean )

Line 2017: l_cur_position_id pqh_position_transactions.position_id%type;

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) ;
2021: l_pos_str_change boolean;

Line 3156: p_position_id in pqh_position_transactions.position_id%type,

3152:
3153:
3154: procedure ps_element_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
3155: p_from_clause in pqh_table_route.from_clause%type,
3156: p_position_id in pqh_position_transactions.position_id%type,
3157: p_routing_category_id in pqh_routing_categories.routing_category_id%type,
3158: p_value_date in date,
3159: p_used_for in varchar2 default null,
3160: p_applicable_flag out nocopy boolean,

Line 3755: p_position_id out nocopy pqh_position_transactions.position_id%type,

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';
3759: l_effective_date date;

Line 4514: procedure ph_next_user(p_cur_position_id in pqh_position_transactions.position_id%type,

4510: p_user_id := null;
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

Line 4516: p_position_id out nocopy pqh_position_transactions.position_id%type,

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
4520: from per_pos_structure_elements

Line 4572: from pqh_position_transactions

4568: begin
4569: if p_short_name ='POSITION_TRANSACTION' then
4570: select wf_transaction_category_id
4571: into l_txn_cat_id
4572: from pqh_position_transactions
4573: where position_transaction_id = p_transaction_id;
4574: elsif p_short_name ='BUDGET_WORKSHEET' then
4575: select wks.wf_transaction_category_id
4576: into l_txn_cat_id