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_TABLE_ROUTE

Line 1575: l_from_clause pqh_table_route.from_clause%type;

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

Line 1828: p_from_clause in pqh_table_route.from_clause%type,

1824: procedure rl_member_check(p_routing_list_id in pqh_routing_lists.routing_list_id%type,
1825: p_old_routing_list_id in pqh_routing_lists.routing_list_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,

Line 1998: p_from_clause in pqh_table_route.from_clause%type,

1994:
1995: procedure ps_element_check(p_history_flag in boolean,
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,

Line 2178: p_from_clause in pqh_table_route.from_clause%type,

2174: end ps_element_check ;
2175:
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,

Line 2522: p_from_clause in pqh_table_route.from_clause%type,

2518: end list_range_check;
2519:
2520: procedure list_range_check(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
2521: p_trans_id in pqh_routing_history.transaction_id%type,
2522: p_from_clause in pqh_table_route.from_clause%type,
2523: p_used_for in varchar2 default null,
2524: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
2525: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
2526: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,

Line 2880: p_from_clause in pqh_table_route.from_clause%type,

2876: raise;
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,

Line 3155: p_from_clause in pqh_table_route.from_clause%type,

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

Line 3394: p_from_clause in pqh_table_route.from_clause%type,

3390: raise;
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,

Line 3837: p_from_clause out nocopy pqh_table_route.from_clause%type ) as

3833: end user_position_and_assignment ;
3834:
3835: procedure prepare_from_clause(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
3836: p_trans_id in pqh_routing_history.transaction_id%type,
3837: p_from_clause out nocopy pqh_table_route.from_clause%type ) as
3838: cursor c1 is select rou.from_clause,rou.where_clause
3839: from pqh_transaction_categories cat ,pqh_table_route rou
3840: where cat.transaction_category_id = p_tran_cat_id
3841: and cat.consolidated_table_route_id = rou.table_route_id ;

Line 3839: from pqh_transaction_categories cat ,pqh_table_route rou

3835: procedure prepare_from_clause(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
3836: p_trans_id in pqh_routing_history.transaction_id%type,
3837: p_from_clause out nocopy pqh_table_route.from_clause%type ) as
3838: cursor c1 is select rou.from_clause,rou.where_clause
3839: from pqh_transaction_categories cat ,pqh_table_route rou
3840: where cat.transaction_category_id = p_tran_cat_id
3841: and cat.consolidated_table_route_id = rou.table_route_id ;
3842: l_from_clause pqh_table_route.from_clause%type ;
3843: l_where_clause_in pqh_table_route.where_clause%type ;

Line 3842: l_from_clause pqh_table_route.from_clause%type ;

3838: cursor c1 is select rou.from_clause,rou.where_clause
3839: from pqh_transaction_categories cat ,pqh_table_route rou
3840: where cat.transaction_category_id = p_tran_cat_id
3841: and cat.consolidated_table_route_id = rou.table_route_id ;
3842: l_from_clause pqh_table_route.from_clause%type ;
3843: l_where_clause_in pqh_table_route.where_clause%type ;
3844: l_where_clause_out pqh_table_route.where_clause%type ;
3845: l_error_flag boolean := FALSE ;
3846: l_proc varchar2(256) := g_package||'prepare_from_clause';

Line 3843: l_where_clause_in pqh_table_route.where_clause%type ;

3839: from pqh_transaction_categories cat ,pqh_table_route rou
3840: where cat.transaction_category_id = p_tran_cat_id
3841: and cat.consolidated_table_route_id = rou.table_route_id ;
3842: l_from_clause pqh_table_route.from_clause%type ;
3843: l_where_clause_in pqh_table_route.where_clause%type ;
3844: l_where_clause_out pqh_table_route.where_clause%type ;
3845: l_error_flag boolean := FALSE ;
3846: l_proc varchar2(256) := g_package||'prepare_from_clause';
3847: begin

Line 3844: l_where_clause_out pqh_table_route.where_clause%type ;

3840: where cat.transaction_category_id = p_tran_cat_id
3841: and cat.consolidated_table_route_id = rou.table_route_id ;
3842: l_from_clause pqh_table_route.from_clause%type ;
3843: l_where_clause_in pqh_table_route.where_clause%type ;
3844: l_where_clause_out pqh_table_route.where_clause%type ;
3845: l_error_flag boolean := FALSE ;
3846: l_proc varchar2(256) := g_package||'prepare_from_clause';
3847: begin
3848: hr_utility.set_location('Entering '||l_proc,10);