1 Package pqh_routing_history_bk2 as
2 /* $Header: pqrhtapi.pkh 120.0 2005/05/29 02:29:01 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< update_routing_history_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure update_routing_history_b
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_object_version_number in number
30 ,p_from_range_name in varchar2
31 ,p_to_range_name in varchar2
32 ,p_list_range_name in varchar2
33 ,p_effective_date in date
34 );
35 --
36 -- ----------------------------------------------------------------------------
37 -- |---------------------------< update_routing_history_a >-----------------|
38 -- ----------------------------------------------------------------------------
39 --
40 procedure update_routing_history_a
41 (
42 p_routing_history_id in number
43 ,p_approval_cd in varchar2
44 ,p_comments in varchar2
45 ,p_forwarded_by_assignment_id in number
46 ,p_forwarded_by_member_id in number
47 ,p_forwarded_by_position_id in number
48 ,p_forwarded_by_user_id in number
49 ,p_forwarded_by_role_id in number
50 ,p_forwarded_to_assignment_id in number
51 ,p_forwarded_to_member_id in number
52 ,p_forwarded_to_position_id in number
53 ,p_forwarded_to_user_id in number
54 ,p_forwarded_to_role_id in number
55 ,p_notification_date in date
56 ,p_pos_structure_version_id in number
57 ,p_routing_category_id in number
58 ,p_transaction_category_id in number
59 ,p_transaction_id in number
60 ,p_user_action_cd in varchar2
61 ,p_object_version_number in number
62 ,p_from_range_name in varchar2
63 ,p_to_range_name in varchar2
64 ,p_list_range_name in varchar2
65 ,p_effective_date in date
66 );
67 --
68 end pqh_routing_history_bk2;
[Home] [Help]