1 Package pqh_routing_history_bk1 AUTHID CURRENT_USER as
2 /* $Header: pqrhtapi.pkh 120.0 2005/05/29 02:29:01 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |---------------------------< create_routing_history_b >-----------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure create_routing_history_b
9 (
10 p_approval_cd in varchar2
11 ,p_comments in varchar2
12 ,p_forwarded_by_assignment_id in number
13 ,p_forwarded_by_member_id in number
14 ,p_forwarded_by_position_id in number
15 ,p_forwarded_by_user_id in number
16 ,p_forwarded_by_role_id in number
17 ,p_forwarded_to_assignment_id in number
18 ,p_forwarded_to_member_id in number
19 ,p_forwarded_to_position_id in number
20 ,p_forwarded_to_user_id in number
21 ,p_forwarded_to_role_id in number
22 ,p_notification_date in date
23 ,p_pos_structure_version_id in number
24 ,p_routing_category_id in number
25 ,p_transaction_category_id in number
26 ,p_transaction_id in number
27 ,p_user_action_cd in varchar2
28 ,p_from_range_name in varchar2
29 ,p_to_range_name in varchar2
30 ,p_list_range_name in varchar2
31 ,p_effective_date in date
32 );
33 --
34 -- ----------------------------------------------------------------------------
35 -- |---------------------------< create_routing_history_a >-----------------|
36 -- ----------------------------------------------------------------------------
37 --
38 procedure create_routing_history_a
39 (
40 p_routing_history_id in number
41 ,p_approval_cd in varchar2
42 ,p_comments in varchar2
43 ,p_forwarded_by_assignment_id in number
44 ,p_forwarded_by_member_id in number
45 ,p_forwarded_by_position_id in number
46 ,p_forwarded_by_user_id in number
47 ,p_forwarded_by_role_id in number
48 ,p_forwarded_to_assignment_id in number
49 ,p_forwarded_to_member_id in number
50 ,p_forwarded_to_position_id in number
51 ,p_forwarded_to_user_id in number
52 ,p_forwarded_to_role_id in number
53 ,p_notification_date in date
54 ,p_pos_structure_version_id in number
55 ,p_routing_category_id in number
56 ,p_transaction_category_id in number
57 ,p_transaction_id in number
58 ,p_user_action_cd in varchar2
59 ,p_object_version_number in number
60 ,p_from_range_name in varchar2
61 ,p_to_range_name in varchar2
62 ,p_list_range_name in varchar2
63 ,p_effective_date in date
64 );
65 --
66 end pqh_routing_history_bk1;
[Home] [Help]