DBA Data[Home] [Help]

APPS.BEN_PERSON_LIFE_EVENT_SWI dependencies on HR_API

Line 27: (p_validate in number default hr_api.g_false_num

23: --
24: -- {End of comments}
25: -- ----------------------------------------------------------------------------
26: PROCEDURE create_Person_Life_Event
27: (p_validate in number default hr_api.g_false_num
28: ,p_per_in_ler_id out NOCOPY number
29: ,p_per_in_ler_stat_cd in varchar2 default null
30: ,p_prvs_stat_cd in varchar2 default null
31: ,p_lf_evt_ocrd_dt in date default null

Line 112: (p_validate in number default hr_api.g_false_num

108: --
109: -- {End of comments}
110: -- ----------------------------------------------------------------------------
111: PROCEDURE delete_Person_Life_Event
112: (p_validate in number default hr_api.g_false_num
113: ,p_per_in_ler_id in number
114: ,p_object_version_number in out NOCOPY number
115: ,p_effective_date in date
116: ,p_return_status out nocopy varchar2

Line 170: (p_validate in number default hr_api.g_false_num

166: --
167: -- {End of comments}
168: -- ----------------------------------------------------------------------------
169: PROCEDURE update_Person_Life_Event
170: (p_validate in number default hr_api.g_false_num
171: ,p_per_in_ler_id in number
172: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
173: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
174: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

Line 172: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2

168: -- ----------------------------------------------------------------------------
169: PROCEDURE update_Person_Life_Event
170: (p_validate in number default hr_api.g_false_num
171: ,p_per_in_ler_id in number
172: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
173: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
174: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
175: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
176: ,p_procd_dt out NOCOPY date

Line 173: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2

169: PROCEDURE update_Person_Life_Event
170: (p_validate in number default hr_api.g_false_num
171: ,p_per_in_ler_id in number
172: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
173: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
174: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
175: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
176: ,p_procd_dt out NOCOPY date
177: ,p_strtd_dt out NOCOPY date

Line 174: ,p_lf_evt_ocrd_dt in date default hr_api.g_date

170: (p_validate in number default hr_api.g_false_num
171: ,p_per_in_ler_id in number
172: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
173: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
174: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
175: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
176: ,p_procd_dt out NOCOPY date
177: ,p_strtd_dt out NOCOPY date
178: ,p_voidd_dt out NOCOPY date

Line 175: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes

171: ,p_per_in_ler_id in number
172: ,p_per_in_ler_stat_cd in varchar2 default hr_api.g_varchar2
173: ,p_prvs_stat_cd in varchar2 default hr_api.g_varchar2
174: ,p_lf_evt_ocrd_dt in date default hr_api.g_date
175: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
176: ,p_procd_dt out NOCOPY date
177: ,p_strtd_dt out NOCOPY date
178: ,p_voidd_dt out NOCOPY date
179: ,p_bckt_dt in date default hr_api.g_date

Line 179: ,p_bckt_dt in date default hr_api.g_date

175: ,p_trgr_table_pk_id in number default hr_api.g_number --ABSE changes
176: ,p_procd_dt out NOCOPY date
177: ,p_strtd_dt out NOCOPY date
178: ,p_voidd_dt out NOCOPY date
179: ,p_bckt_dt in date default hr_api.g_date
180: ,p_clsd_dt in date default hr_api.g_date
181: ,p_ntfn_dt in date default hr_api.g_date
182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number

Line 180: ,p_clsd_dt in date default hr_api.g_date

176: ,p_procd_dt out NOCOPY date
177: ,p_strtd_dt out NOCOPY date
178: ,p_voidd_dt out NOCOPY date
179: ,p_bckt_dt in date default hr_api.g_date
180: ,p_clsd_dt in date default hr_api.g_date
181: ,p_ntfn_dt in date default hr_api.g_date
182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number

Line 181: ,p_ntfn_dt in date default hr_api.g_date

177: ,p_strtd_dt out NOCOPY date
178: ,p_voidd_dt out NOCOPY date
179: ,p_bckt_dt in date default hr_api.g_date
180: ,p_clsd_dt in date default hr_api.g_date
181: ,p_ntfn_dt in date default hr_api.g_date
182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number

Line 182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number

178: ,p_voidd_dt out NOCOPY date
179: ,p_bckt_dt in date default hr_api.g_date
180: ,p_clsd_dt in date default hr_api.g_date
181: ,p_ntfn_dt in date default hr_api.g_date
182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number

Line 183: ,p_bckt_per_in_ler_id in number default hr_api.g_number

179: ,p_bckt_dt in date default hr_api.g_date
180: ,p_clsd_dt in date default hr_api.g_date
181: ,p_ntfn_dt in date default hr_api.g_date
182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number

Line 184: ,p_ler_id in number default hr_api.g_number

180: ,p_clsd_dt in date default hr_api.g_date
181: ,p_ntfn_dt in date default hr_api.g_date
182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number

Line 185: ,p_person_id in number default hr_api.g_number

181: ,p_ntfn_dt in date default hr_api.g_date
182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number

Line 186: ,p_business_group_id in number default hr_api.g_number

182: ,p_ptnl_ler_for_per_id in number default hr_api.g_number
183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number

Line 187: ,p_ASSIGNMENT_ID in number default hr_api.g_number

183: ,p_bckt_per_in_ler_id in number default hr_api.g_number
184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date

Line 188: ,p_WS_MGR_ID in number default hr_api.g_number

184: ,p_ler_id in number default hr_api.g_number
185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2

Line 189: ,p_GROUP_PL_ID in number default hr_api.g_number

185: ,p_person_id in number default hr_api.g_number
186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2

Line 190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number

186: ,p_business_group_id in number default hr_api.g_number
187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2

Line 191: ,p_MGR_OVRID_DT in date default hr_api.g_date

187: ,p_ASSIGNMENT_ID in number default hr_api.g_number
188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2

Line 192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2

188: ,p_WS_MGR_ID in number default hr_api.g_number
189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2

Line 193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2

189: ,p_GROUP_PL_ID in number default hr_api.g_number
190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2

Line 194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2

190: ,p_MGR_OVRID_PERSON_ID in number default hr_api.g_number
191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2

Line 195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2

191: ,p_MGR_OVRID_DT in date default hr_api.g_date
192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2

Line 196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2

192: ,p_pil_attribute_category in varchar2 default hr_api.g_varchar2
193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2

Line 197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2

193: ,p_pil_attribute1 in varchar2 default hr_api.g_varchar2
194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2

Line 198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2

194: ,p_pil_attribute2 in varchar2 default hr_api.g_varchar2
195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2

Line 199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2

195: ,p_pil_attribute3 in varchar2 default hr_api.g_varchar2
196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2

Line 200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2

196: ,p_pil_attribute4 in varchar2 default hr_api.g_varchar2
197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2

Line 201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2

197: ,p_pil_attribute5 in varchar2 default hr_api.g_varchar2
198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2

Line 202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2

198: ,p_pil_attribute6 in varchar2 default hr_api.g_varchar2
199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2

Line 203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2

199: ,p_pil_attribute7 in varchar2 default hr_api.g_varchar2
200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2

Line 204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2

200: ,p_pil_attribute8 in varchar2 default hr_api.g_varchar2
201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2

Line 205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2

201: ,p_pil_attribute9 in varchar2 default hr_api.g_varchar2
202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2

Line 206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2

202: ,p_pil_attribute10 in varchar2 default hr_api.g_varchar2
203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2

Line 207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2

203: ,p_pil_attribute11 in varchar2 default hr_api.g_varchar2
204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2

Line 208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2

204: ,p_pil_attribute12 in varchar2 default hr_api.g_varchar2
205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2

Line 209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2

205: ,p_pil_attribute13 in varchar2 default hr_api.g_varchar2
206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2

Line 210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2

206: ,p_pil_attribute14 in varchar2 default hr_api.g_varchar2
207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2

Line 211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2

207: ,p_pil_attribute15 in varchar2 default hr_api.g_varchar2
208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2

Line 212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2

208: ,p_pil_attribute16 in varchar2 default hr_api.g_varchar2
209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2

Line 213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2

209: ,p_pil_attribute17 in varchar2 default hr_api.g_varchar2
210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2

Line 214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2

210: ,p_pil_attribute18 in varchar2 default hr_api.g_varchar2
211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2

Line 215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2

211: ,p_pil_attribute19 in varchar2 default hr_api.g_varchar2
212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2

Line 216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2

212: ,p_pil_attribute20 in varchar2 default hr_api.g_varchar2
213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2

Line 217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2

213: ,p_pil_attribute21 in varchar2 default hr_api.g_varchar2
214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2

Line 218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2

214: ,p_pil_attribute22 in varchar2 default hr_api.g_varchar2
215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2

Line 219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2

215: ,p_pil_attribute23 in varchar2 default hr_api.g_varchar2
216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number

Line 220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2

216: ,p_pil_attribute24 in varchar2 default hr_api.g_varchar2
217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number
224: ,p_program_application_id in number default hr_api.g_number

Line 221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2

217: ,p_pil_attribute25 in varchar2 default hr_api.g_varchar2
218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number
224: ,p_program_application_id in number default hr_api.g_number
225: ,p_program_id in number default hr_api.g_number

Line 222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2

218: ,p_pil_attribute26 in varchar2 default hr_api.g_varchar2
219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number
224: ,p_program_application_id in number default hr_api.g_number
225: ,p_program_id in number default hr_api.g_number
226: ,p_program_update_date in date default hr_api.g_date

Line 223: ,p_request_id in number default hr_api.g_number

219: ,p_pil_attribute27 in varchar2 default hr_api.g_varchar2
220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number
224: ,p_program_application_id in number default hr_api.g_number
225: ,p_program_id in number default hr_api.g_number
226: ,p_program_update_date in date default hr_api.g_date
227: ,p_object_version_number in out NOCOPY number

Line 224: ,p_program_application_id in number default hr_api.g_number

220: ,p_pil_attribute28 in varchar2 default hr_api.g_varchar2
221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number
224: ,p_program_application_id in number default hr_api.g_number
225: ,p_program_id in number default hr_api.g_number
226: ,p_program_update_date in date default hr_api.g_date
227: ,p_object_version_number in out NOCOPY number
228: ,p_effective_date in date

Line 225: ,p_program_id in number default hr_api.g_number

221: ,p_pil_attribute29 in varchar2 default hr_api.g_varchar2
222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number
224: ,p_program_application_id in number default hr_api.g_number
225: ,p_program_id in number default hr_api.g_number
226: ,p_program_update_date in date default hr_api.g_date
227: ,p_object_version_number in out NOCOPY number
228: ,p_effective_date in date
229: ,p_return_status out nocopy varchar2

Line 226: ,p_program_update_date in date default hr_api.g_date

222: ,p_pil_attribute30 in varchar2 default hr_api.g_varchar2
223: ,p_request_id in number default hr_api.g_number
224: ,p_program_application_id in number default hr_api.g_number
225: ,p_program_id in number default hr_api.g_number
226: ,p_program_update_date in date default hr_api.g_date
227: ,p_object_version_number in out NOCOPY number
228: ,p_effective_date in date
229: ,p_return_status out nocopy varchar2
230: );