1 Package pqh_rht_rku as
2 /* $Header: pqrhtrhi.pkh 120.0 2005/05/29 02:29:21 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update
9 (
10 p_routing_history_id in number
11 ,p_approval_cd in varchar2
12 ,p_comments in varchar2
13 ,p_forwarded_by_assignment_id in number
14 ,p_forwarded_by_member_id in number
15 ,p_forwarded_by_position_id in number
16 ,p_forwarded_by_user_id in number
17 ,p_forwarded_by_role_id in number
18 ,p_forwarded_to_assignment_id in number
19 ,p_forwarded_to_member_id in number
20 ,p_forwarded_to_position_id in number
21 ,p_forwarded_to_user_id in number
22 ,p_forwarded_to_role_id in number
23 ,p_notification_date in date
24 ,p_pos_structure_version_id in number
25 ,p_routing_category_id in number
26 ,p_transaction_category_id in number
27 ,p_transaction_id in number
28 ,p_user_action_cd in varchar2
29 ,p_from_range_name in varchar2
30 ,p_to_range_name in varchar2
31 ,p_list_range_name in varchar2
32 ,p_object_version_number in number
33 ,p_effective_date in date
34 ,p_approval_cd_o in varchar2
35 ,p_comments_o in varchar2
36 ,p_forwarded_by_assignment_id_o in number
37 ,p_forwarded_by_member_id_o in number
38 ,p_forwarded_by_position_id_o in number
39 ,p_forwarded_by_user_id_o in number
40 ,p_forwarded_by_role_id_o in number
41 ,p_forwarded_to_assignment_id_o in number
42 ,p_forwarded_to_member_id_o in number
43 ,p_forwarded_to_position_id_o in number
44 ,p_forwarded_to_user_id_o in number
45 ,p_forwarded_to_role_id_o in number
46 ,p_notification_date_o in date
47 ,p_pos_structure_version_id_o in number
48 ,p_routing_category_id_o in number
49 ,p_transaction_category_id_o in number
50 ,p_transaction_id_o in number
51 ,p_user_action_cd_o in varchar2
52 ,p_from_range_name_o in varchar2
53 ,p_to_range_name_o in varchar2
54 ,p_list_range_name_o in varchar2
55 ,p_object_version_number_o in number
56 );
57 --
58 end pqh_rht_rku;
[Home] [Help]