1 Package pqh_routing_hist_attrib_api AUTHID CURRENT_USER as
2 /* $Header: pqrhaapi.pkh 120.0 2005/05/29 02:28:23 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_routing_hist_attrib >------------------------|
6 -- ----------------------------------------------------------------------------
7 -- {Start Of Comments}
8 --
9 -- Description:
10 --
11 -- Prerequisites:
12 --
13 --
14 -- In Parameters:
15 -- Name Reqd Type Description
16 -- p_validate Yes boolean Commit or Rollback.
17 -- p_routing_history_id Yes number
18 -- p_attribute_id Yes number Descriptive Flexfield
19 -- p_from_char No varchar2
20 -- p_from_date No date
21 -- p_from_number No number
22 -- p_to_char No varchar2
23 -- p_to_date No date
24 -- p_to_number No number
25 -- p_range_type_cd No varchar2
26 -- p_value_date No date
27 -- p_value_number No number
28 -- p_value_char No varchar2
29 -- p_effective_date Yes date Session Date.
30 --
31 -- Post Success:
32 --
33 -- Out Parameters:
34 -- Name Type Description
35 -- p_routing_hist_attrib_id Yes number PK of record
36 -- p_object_version_number Yes number OVN of record
37 --
38 -- Post Failure:
39 --
40 -- Access Status:
41 -- Public.
42 --
43 -- {End Of Comments}
44 --
45 procedure create_routing_hist_attrib
46 (
47 p_validate in boolean default false
48 ,p_routing_hist_attrib_id out nocopy number
49 ,p_routing_history_id in number default null
50 ,p_attribute_id in number default null
51 ,p_from_char in varchar2 default null
52 ,p_from_date in date default null
53 ,p_from_number in number default null
54 ,p_to_char in varchar2 default null
55 ,p_to_date in date default null
56 ,p_to_number in number default null
57 ,p_object_version_number out nocopy number
58 ,p_range_type_cd in varchar2 default null
59 ,p_value_date in date default null
60 ,p_value_number in number default null
61 ,p_value_char in varchar2 default null
62 ,p_effective_date in date
63 );
64 -- ----------------------------------------------------------------------------
65 -- |------------------------< update_routing_hist_attrib >------------------------|
66 -- ----------------------------------------------------------------------------
67 -- {Start Of Comments}
68 --
69 -- Description:
70 --
71 -- Prerequisites:
72 --
73 --
74 -- In Parameters:
75 -- Name Reqd Type Description
76 -- p_validate Yes boolean Commit or Rollback.
77 -- p_routing_hist_attrib_id Yes number PK of record
78 -- p_routing_history_id Yes number
79 -- p_attribute_id Yes number Descriptive Flexfield
80 -- p_from_char No varchar2
81 -- p_from_date No date
82 -- p_from_number No number
83 -- p_to_char No varchar2
84 -- p_to_date No date
85 -- p_to_number No number
86 -- p_range_type_cd No varchar2
87 -- p_value_date No date
88 -- p_value_number No number
89 -- p_value_char No varchar2
90 -- p_effective_date Yes date Session Date.
91 --
92 -- Post Success:
93 --
94 -- Name Type Description
95 -- p_object_version_number Yes number OVN of record
96 --
97 -- Post Failure:
98 --
99 -- Access Status:
100 -- Public.
101 --
102 -- {End Of Comments}
103 --
104 procedure update_routing_hist_attrib
105 (
106 p_validate in boolean default false
107 ,p_routing_hist_attrib_id in number
108 ,p_routing_history_id in number default hr_api.g_number
109 ,p_attribute_id in number default hr_api.g_number
110 ,p_from_char in varchar2 default hr_api.g_varchar2
111 ,p_from_date in date default hr_api.g_date
112 ,p_from_number in number default hr_api.g_number
113 ,p_to_char in varchar2 default hr_api.g_varchar2
114 ,p_to_date in date default hr_api.g_date
115 ,p_to_number in number default hr_api.g_number
116 ,p_object_version_number in out nocopy number
117 ,p_range_type_cd in varchar2 default hr_api.g_varchar2
118 ,p_value_date in date default hr_api.g_date
119 ,p_value_number in number default hr_api.g_number
120 ,p_value_char in varchar2 default hr_api.g_varchar2
121 ,p_effective_date in date
122 );
123 --
124 -- ----------------------------------------------------------------------------
125 -- |------------------------< delete_routing_hist_attrib >------------------------|
126 -- ----------------------------------------------------------------------------
127 -- {Start Of Comments}
128 --
129 -- Description:
130 --
131 -- Prerequisites:
132 --
133 --
134 -- In Parameters:
135 -- Name Reqd Type Description
136 -- p_validate Yes boolean Commit or Rollback.
137 -- p_routing_hist_attrib_id Yes number PK of record
138 -- p_effective_date Yes date Session Date.
139 --
140 -- Post Success:
141 --
142 -- Name Type Description
143 -- p_object_version_number Yes number OVN of record
144 --
145 -- Post Failure:
146 --
147 -- Access Status:
148 -- Public.
149 --
150 -- {End Of Comments}
151 --
152 procedure delete_routing_hist_attrib
153 (
154 p_validate in boolean default false
155 ,p_routing_hist_attrib_id in number
156 ,p_object_version_number in number
157 ,p_effective_date in date
158 );
159 --
160 --
161 --
162 end pqh_routing_hist_attrib_api;