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_ATTRIBUTE_RANGES

Line 23: g_list_range pqh_attribute_ranges.range_name%type;

19: index by binary_integer ;
20:
21: -- global variable to hold the result and return row one by one
22: g_routing_criterion t_attribute_ranges;
23: g_list_range pqh_attribute_ranges.range_name%type;
24: g_current_member_range pqh_attribute_ranges.range_name%type;
25: g_next_member_range pqh_attribute_ranges.range_name%type;
26:
27: -- function get_routinghistory_role(p_routing_history_id number) return number ;

Line 24: g_current_member_range pqh_attribute_ranges.range_name%type;

20:
21: -- global variable to hold the result and return row one by one
22: g_routing_criterion t_attribute_ranges;
23: g_list_range pqh_attribute_ranges.range_name%type;
24: g_current_member_range pqh_attribute_ranges.range_name%type;
25: g_next_member_range pqh_attribute_ranges.range_name%type;
26:
27: -- function get_routinghistory_role(p_routing_history_id number) return number ;
28:

Line 25: g_next_member_range pqh_attribute_ranges.range_name%type;

21: -- global variable to hold the result and return row one by one
22: g_routing_criterion t_attribute_ranges;
23: g_list_range pqh_attribute_ranges.range_name%type;
24: g_current_member_range pqh_attribute_ranges.range_name%type;
25: g_next_member_range pqh_attribute_ranges.range_name%type;
26:
27: -- function get_routinghistory_role(p_routing_history_id number) return number ;
28:
29: procedure get_primary_asg_details(p_person_id in number,

Line 137: p_range_name out nocopy pqh_attribute_ranges.range_name%type,

133: p_cur_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
134: p_old_assignment_id out nocopy per_all_assignments_f.assignment_id%type,
135: p_status_flag out nocopy number,
136: p_history_flag out nocopy boolean,
137: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
138: p_can_approve out nocopy boolean);
139:
140: procedure rl_member_check(p_routing_list_id in pqh_routing_lists.routing_list_id%type,
141: p_old_routing_list_id in pqh_routing_lists.routing_list_id%type,

Line 215: p_range_name out nocopy pqh_attribute_ranges.range_name%type,

211: p_member_cd out nocopy pqh_transaction_categories.member_cd%type,
212: p_routing_list_id out nocopy pqh_routing_lists.routing_list_id%type,
213: p_pos_str_id out nocopy pqh_routing_categories.position_structure_id%type,
214: p_routing_category_id out nocopy pqh_routing_categories.routing_category_id%type,
215: p_range_name out nocopy pqh_attribute_ranges.range_name%type,
216: p_status_flag out nocopy number );
217:
218: procedure assignment_applicable(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
219: p_from_clause in pqh_table_route.from_clause%type,

Line 268: procedure check_value_range(p_from_char in pqh_attribute_ranges.from_char%type,

264: procedure prepare_from_clause(p_tran_cat_id in pqh_transaction_categories.transaction_category_id%type,
265: p_trans_id in pqh_routing_history.transaction_id%type,
266: p_from_clause out nocopy pqh_table_route.from_clause%type );
267:
268: procedure check_value_range(p_from_char in pqh_attribute_ranges.from_char%type,
269: p_to_char in pqh_attribute_ranges.to_char%type,
270: p_value_char in pqh_attribute_ranges.to_char%type,
271: p_in_range out nocopy boolean ,
272: p_can_approve out nocopy boolean ) ;

Line 269: p_to_char in pqh_attribute_ranges.to_char%type,

265: p_trans_id in pqh_routing_history.transaction_id%type,
266: p_from_clause out nocopy pqh_table_route.from_clause%type );
267:
268: procedure check_value_range(p_from_char in pqh_attribute_ranges.from_char%type,
269: p_to_char in pqh_attribute_ranges.to_char%type,
270: p_value_char in pqh_attribute_ranges.to_char%type,
271: p_in_range out nocopy boolean ,
272: p_can_approve out nocopy boolean ) ;
273:

Line 270: p_value_char in pqh_attribute_ranges.to_char%type,

266: p_from_clause out nocopy pqh_table_route.from_clause%type );
267:
268: procedure check_value_range(p_from_char in pqh_attribute_ranges.from_char%type,
269: p_to_char in pqh_attribute_ranges.to_char%type,
270: p_value_char in pqh_attribute_ranges.to_char%type,
271: p_in_range out nocopy boolean ,
272: p_can_approve out nocopy boolean ) ;
273:
274: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,

Line 274: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,

270: p_value_char in pqh_attribute_ranges.to_char%type,
271: p_in_range out nocopy boolean ,
272: p_can_approve out nocopy boolean ) ;
273:
274: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,
275: p_to_num in pqh_attribute_ranges.to_number%type,
276: p_value_num in pqh_attribute_ranges.to_number%type,
277: p_in_range out nocopy boolean ,
278: p_can_approve out nocopy boolean ) ;

Line 275: p_to_num in pqh_attribute_ranges.to_number%type,

271: p_in_range out nocopy boolean ,
272: p_can_approve out nocopy boolean ) ;
273:
274: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,
275: p_to_num in pqh_attribute_ranges.to_number%type,
276: p_value_num in pqh_attribute_ranges.to_number%type,
277: p_in_range out nocopy boolean ,
278: p_can_approve out nocopy boolean ) ;
279:

Line 276: p_value_num in pqh_attribute_ranges.to_number%type,

272: p_can_approve out nocopy boolean ) ;
273:
274: procedure check_value_range(p_from_num in pqh_attribute_ranges.from_number%type,
275: p_to_num in pqh_attribute_ranges.to_number%type,
276: p_value_num in pqh_attribute_ranges.to_number%type,
277: p_in_range out nocopy boolean ,
278: p_can_approve out nocopy boolean ) ;
279:
280: procedure check_value_range(p_from_date in pqh_attribute_ranges.from_date%type,

Line 280: procedure check_value_range(p_from_date in pqh_attribute_ranges.from_date%type,

276: p_value_num in pqh_attribute_ranges.to_number%type,
277: p_in_range out nocopy boolean ,
278: p_can_approve out nocopy boolean ) ;
279:
280: procedure check_value_range(p_from_date in pqh_attribute_ranges.from_date%type,
281: p_to_date in pqh_attribute_ranges.to_date%type,
282: p_value_date in pqh_attribute_ranges.to_date%type,
283: p_in_range out nocopy boolean ,
284: p_can_approve out nocopy boolean ) ;

Line 281: p_to_date in pqh_attribute_ranges.to_date%type,

277: p_in_range out nocopy boolean ,
278: p_can_approve out nocopy boolean ) ;
279:
280: procedure check_value_range(p_from_date in pqh_attribute_ranges.from_date%type,
281: p_to_date in pqh_attribute_ranges.to_date%type,
282: p_value_date in pqh_attribute_ranges.to_date%type,
283: p_in_range out nocopy boolean ,
284: p_can_approve out nocopy boolean ) ;
285:

Line 282: p_value_date in pqh_attribute_ranges.to_date%type,

278: p_can_approve out nocopy boolean ) ;
279:
280: procedure check_value_range(p_from_date in pqh_attribute_ranges.from_date%type,
281: p_to_date in pqh_attribute_ranges.to_date%type,
282: p_value_date in pqh_attribute_ranges.to_date%type,
283: p_in_range out nocopy boolean ,
284: p_can_approve out nocopy boolean ) ;
285:
286: procedure rlm_user_seq(p_routing_list_id in pqh_routing_lists.routing_list_id%type,