[Home] [Help]
PACKAGE: APPS.BEN_EXT_CHG_EVT_API
Source
1 Package ben_EXT_CHG_EVT_api AUTHID CURRENT_USER as
2 /* $Header: bexclapi.pkh 120.1 2005/06/23 15:04:14 tjesumic noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |------------------------< create_EXT_CHG_EVT >------------------------|
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_chg_evt_cd Yes varchar2
18 -- p_chg_eff_dt Yes date
19 -- p_chg_user_id No number
20 -- p_prmtr_01 No varchar2
21 -- p_prmtr_02 No varchar2
22 -- p_prmtr_03 No varchar2
23 -- p_prmtr_04 No varchar2
24 -- p_prmtr_05 No varchar2
28 -- p_prmtr_09 No varchar2
25 -- p_prmtr_06 No varchar2
26 -- p_prmtr_07 No varchar2
27 -- p_prmtr_08 No varchar2
29 -- p_prmtr_10 No varchar2
30 -- p_person_id Yes number
31 -- p_business_group_id Yes number Business Group of Record
32 -- p_effective_date Yes date Session Date.
33 --
34 -- Post Success:
35 --
36 -- Out Parameters:
37 -- Name Type Description
38 -- p_ext_chg_evt_log_id Yes number PK of record
39 -- p_object_version_number No number OVN of record
40 --
41 -- Post Failure:
42 --
43 -- Access Status:
44 -- Public.
45 --
46 -- {End Of Comments}
47 --
48 procedure create_EXT_CHG_EVT
49 (
50 p_validate in boolean default false
51 ,p_ext_chg_evt_log_id out nocopy number
52 ,p_chg_evt_cd in varchar2 default null
53 ,p_chg_eff_dt in date default null
54 ,p_chg_user_id in number default null
55 ,p_prmtr_01 in varchar2 default null
56 ,p_prmtr_02 in varchar2 default null
57 ,p_prmtr_03 in varchar2 default null
58 ,p_prmtr_04 in varchar2 default null
59 ,p_prmtr_05 in varchar2 default null
60 ,p_prmtr_06 in varchar2 default null
61 ,p_prmtr_07 in varchar2 default null
62 ,p_prmtr_08 in varchar2 default null
63 ,p_prmtr_09 in varchar2 default null
64 ,p_prmtr_10 in varchar2 default null
65 ,p_person_id in number default null
66 ,p_business_group_id in number default null
67 ,p_object_version_number out nocopy number
68 ,p_effective_date in date
69 ,p_new_val1 in varchar2 default null
70 ,p_new_val2 in varchar2 default null
71 ,p_new_val3 in varchar2 default null
72 ,p_new_val4 in varchar2 default null
73 ,p_new_val5 in varchar2 default null
74 ,p_new_val6 in varchar2 default null
75 ,p_old_val1 in varchar2 default null
76 ,p_old_val2 in varchar2 default null
77 ,p_old_val3 in varchar2 default null
78 ,p_old_val4 in varchar2 default null
79 ,p_old_val5 in varchar2 default null
80 ,p_old_val6 in varchar2 default null
81 );
82 -- ----------------------------------------------------------------------------
83 -- |------------------------< update_EXT_CHG_EVT >------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start Of Comments}
86 --
87 -- Description:
88 --
89 -- Prerequisites:
90 --
91 --
92 -- In Parameters:
93 -- Name Reqd Type Description
94 -- p_validate Yes boolean Commit or Rollback.
95 -- p_ext_chg_evt_log_id Yes number PK of record
96 -- p_chg_evt_cd Yes varchar2
97 -- p_chg_eff_dt Yes date
98 -- p_chg_user_id No number
99 -- p_prmtr_01 No varchar2
100 -- p_prmtr_02 No varchar2
101 -- p_prmtr_03 No varchar2
102 -- p_prmtr_04 No varchar2
103 -- p_prmtr_05 No varchar2
104 -- p_prmtr_06 No varchar2
105 -- p_prmtr_07 No varchar2
106 -- p_prmtr_08 No varchar2
107 -- p_prmtr_09 No varchar2
108 -- p_prmtr_10 No varchar2
109 -- p_person_id Yes number
110 -- p_business_group_id Yes number Business Group of Record
111 -- p_effective_date Yes date Session Date.
112 --
113 -- Post Success:
114 --
115 -- Name Type Description
116 -- p_object_version_number No number OVN of record
117 --
118 -- Post Failure:
119 --
120 -- Access Status:
121 -- Public.
122 --
123 -- {End Of Comments}
124 --
125 procedure update_EXT_CHG_EVT
126 (
127 p_validate in boolean default false
128 ,p_ext_chg_evt_log_id in number
129 ,p_chg_evt_cd in varchar2 default hr_api.g_varchar2
130 ,p_chg_eff_dt in date default hr_api.g_date
131 ,p_chg_user_id in number default hr_api.g_number
132 ,p_prmtr_01 in varchar2 default hr_api.g_varchar2
133 ,p_prmtr_02 in varchar2 default hr_api.g_varchar2
134 ,p_prmtr_03 in varchar2 default hr_api.g_varchar2
135 ,p_prmtr_04 in varchar2 default hr_api.g_varchar2
136 ,p_prmtr_05 in varchar2 default hr_api.g_varchar2
137 ,p_prmtr_06 in varchar2 default hr_api.g_varchar2
138 ,p_prmtr_07 in varchar2 default hr_api.g_varchar2
139 ,p_prmtr_08 in varchar2 default hr_api.g_varchar2
140 ,p_prmtr_09 in varchar2 default hr_api.g_varchar2
144 ,p_object_version_number in out nocopy number
141 ,p_prmtr_10 in varchar2 default hr_api.g_varchar2
142 ,p_person_id in number default hr_api.g_number
143 ,p_business_group_id in number default hr_api.g_number
145 ,p_effective_date in date
146 );
147 --
148 -- ----------------------------------------------------------------------------
149 -- |------------------------< delete_EXT_CHG_EVT >------------------------|
150 -- ----------------------------------------------------------------------------
151 -- {Start Of Comments}
152 --
153 -- Description:
154 --
155 -- Prerequisites:
156 --
157 --
158 -- In Parameters:
159 -- Name Reqd Type Description
160 -- p_validate Yes boolean Commit or Rollback.
161 -- p_ext_chg_evt_log_id Yes number PK of record
162 -- p_effective_date Yes date Session Date.
163 --
164 -- Post Success:
165 --
166 -- Name Type Description
167 -- p_object_version_number No number OVN of record
168 --
169 -- Post Failure:
170 --
171 -- Access Status:
172 -- Public.
173 --
174 -- {End Of Comments}
175 --
176 procedure delete_EXT_CHG_EVT
177 (
178 p_validate in boolean default false
179 ,p_ext_chg_evt_log_id in number
180 ,p_object_version_number in out nocopy number
181 ,p_effective_date in date
182 );
183 --
184 -- ----------------------------------------------------------------------------
185 -- |----------------------------------< lck >---------------------------------|
186 -- ----------------------------------------------------------------------------
187 -- {Start Of Comments}
188 --
189 -- Description:
190 --
191 -- Prerequisites:
192 --
193 --
194 -- In Parameters:
195 -- Name Reqd Type Description
196 -- p_ext_chg_evt_log_id Yes number PK of record
197 -- p_object_version_number Yes number OVN of record
198 --
199 -- Post Success:
200 --
201 -- Name Type Description
202 --
203 -- Post Failure:
204 --
205 -- Access Status:
206 -- Public.
207 --
208 -- {End Of Comments}
209 --
210 procedure lck
211 (
212 p_ext_chg_evt_log_id in number
213 ,p_object_version_number in number
214 );
215 --
216
217 Function pay_interpreter_ressult (p_assignment_id in number,
218 p_event_group_id in number,
219 p_actl_date in date ,
220 p_dated_table_id in number,
221 p_column_name in varchar2,
222 p_effective_date in date ,
223 p_eff_date in date ,
224 p_change_type in varchar2 ,
225 p_process_event_id in number)
226 return varchar2 ;
227
228 end ben_EXT_CHG_EVT_api;