1 Package ben_EXT_RSLT_api as
2 /* $Header: bexrsapi.pkh 120.1 2005/06/08 14:27:02 tjesumic noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_EXT_RSLT >------------------------|
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_run_strt_dt No date
18 -- p_run_end_dt No date
19 -- p_ext_stat_cd No varchar2
20 -- p_tot_rec_num No number
21 -- p_tot_per_num No number
22 -- p_tot_err_num No number
23 -- p_eff_dt No date
24 -- p_ext_strt_dt No date
25 -- p_ext_end_dt No date
26 -- p_output_name No varchar2
27 -- p_drctry_name No varchar2
28 -- p_ext_dfn_id Yes number
29 -- p_business_group_id Yes number Business Group of Record
30 -- p_program_application_id No number
31 -- p_program_id No number
32 -- p_program_update_date No date
33 -- p_request_id No number
34 -- p_effective_date Yes date Session Date.
35 --
36 -- Post Success:
37 --
38 -- Out Parameters:
39 -- Name Type Description
40 -- p_ext_rslt_id Yes number PK of record
41 -- p_object_version_number No number OVN of record
42 --
43 -- Post Failure:
44 --
45 -- Access Status:
46 -- Public.
47 --
48 -- {End Of Comments}
49 --
50 procedure create_EXT_RSLT
51 (
52 p_validate in boolean default false
53 ,p_ext_rslt_id out nocopy number
54 ,p_run_strt_dt in date default null
55 ,p_run_end_dt in date default null
56 ,p_ext_stat_cd in varchar2 default null
57 ,p_tot_rec_num in number default null
58 ,p_tot_per_num in number default null
59 ,p_tot_err_num in number default null
60 ,p_eff_dt in date default null
61 ,p_ext_strt_dt in date default null
62 ,p_ext_end_dt in date default null
63 ,p_output_name in varchar2 default null
64 ,p_drctry_name in varchar2 default null
65 ,p_ext_dfn_id in number default null
66 ,p_business_group_id in number default null
67 ,p_program_application_id in number default null
68 ,p_program_id in number default null
69 ,p_program_update_date in date default null
70 ,p_request_id in number default null
71 ,p_output_type in varchar2 default null
72 ,p_xdo_template_id in number default null
73 ,p_object_version_number out nocopy number
74 ,p_effective_date in date
75 );
76 -- ----------------------------------------------------------------------------
77 -- |------------------------< update_EXT_RSLT >------------------------|
78 -- ----------------------------------------------------------------------------
79 -- {Start Of Comments}
80 --
81 -- Description:
82 --
83 -- Prerequisites:
84 --
85 --
86 -- In Parameters:
87 -- Name Reqd Type Description
88 -- p_validate Yes boolean Commit or Rollback.
89 -- p_ext_rslt_id Yes number PK of record
90 -- p_run_strt_dt No date
91 -- p_run_end_dt No date
92 -- p_ext_stat_cd No varchar2
93 -- p_tot_rec_num No number
94 -- p_tot_per_num No number
95 -- p_tot_err_num No number
96 -- p_eff_dt No date
97 -- p_ext_strt_dt No date
98 -- p_ext_end_dt No date
99 -- p_output_name No varchar2
100 -- p_drctry_name No varchar2
101 -- p_ext_dfn_id Yes number
102 -- p_business_group_id Yes number Business Group of Record
103 -- p_program_application_id No number
104 -- p_program_id No number
105 -- p_program_update_date No date
106 -- p_request_id No number
107 -- ,p_output_type in varchar2 default null
108 -- ,p_xdo_template_id in number default null
109 -- p_effective_date Yes date Session Date.
110 --
111 -- Post Success:
112 --
113 -- Name Type Description
114 -- p_object_version_number No number OVN of record
115 --
116 -- Post Failure:
117 --
118 -- Access Status:
119 -- Public.
120 --
121 -- {End Of Comments}
122 --
123 procedure update_EXT_RSLT
124 (
125 p_validate in boolean default false
126 ,p_ext_rslt_id in number
127 ,p_run_strt_dt in date default hr_api.g_date
128 ,p_run_end_dt in date default hr_api.g_date
129 ,p_ext_stat_cd in varchar2 default hr_api.g_varchar2
130 ,p_tot_rec_num in number default hr_api.g_number
131 ,p_tot_per_num in number default hr_api.g_number
132 ,p_tot_err_num in number default hr_api.g_number
133 ,p_eff_dt in date default hr_api.g_date
134 ,p_ext_strt_dt in date default hr_api.g_date
135 ,p_ext_end_dt in date default hr_api.g_date
136 ,p_output_name in varchar2 default hr_api.g_varchar2
137 ,p_drctry_name in varchar2 default hr_api.g_varchar2
138 ,p_ext_dfn_id in number default hr_api.g_number
139 ,p_business_group_id in number default hr_api.g_number
140 ,p_program_application_id in number default hr_api.g_number
141 ,p_program_id in number default hr_api.g_number
142 ,p_program_update_date in date default hr_api.g_date
143 ,p_request_id in number default hr_api.g_number
144 ,p_output_type in varchar2 default hr_api.g_varchar2
145 ,p_xdo_template_id in number default hr_api.g_number
146 ,p_object_version_number in out nocopy number
147 ,p_effective_date in date
148 );
149 --
150 -- ----------------------------------------------------------------------------
151 -- |------------------------< delete_EXT_RSLT >------------------------|
152 -- ----------------------------------------------------------------------------
153 -- {Start Of Comments}
154 --
155 -- Description:
156 --
157 -- Prerequisites:
158 --
159 --
160 -- In Parameters:
161 -- Name Reqd Type Description
162 -- p_validate Yes boolean Commit or Rollback.
163 -- p_ext_rslt_id Yes number PK of record
164 -- p_effective_date Yes date Session Date.
165 --
166 -- Post Success:
167 --
168 -- Name Type Description
169 -- p_object_version_number No number OVN of record
170 --
171 -- Post Failure:
172 --
173 -- Access Status:
174 -- Public.
175 --
176 -- {End Of Comments}
177 --
178 procedure delete_EXT_RSLT
179 (
180 p_validate in boolean default false
181 ,p_ext_rslt_id in number
182 ,p_object_version_number in out nocopy number
183 ,p_effective_date in date
184 );
185 --
186 -- ----------------------------------------------------------------------------
187 -- |----------------------------------< lck >---------------------------------|
188 -- ----------------------------------------------------------------------------
189 -- {Start Of Comments}
190 --
191 -- Description:
192 --
193 -- Prerequisites:
194 --
195 --
196 -- In Parameters:
197 -- Name Reqd Type Description
198 -- p_ext_rslt_id Yes number PK of record
199 -- p_object_version_number Yes number OVN of record
200 --
201 -- Post Success:
202 --
203 -- Name Type Description
204 --
205 -- Post Failure:
206 --
207 -- Access Status:
208 -- Public.
209 --
210 -- {End Of Comments}
211 --
212 procedure lck
213 (
214 p_ext_rslt_id in number
215 ,p_object_version_number in number
216 );
217 --
218 end ben_EXT_RSLT_api;