DBA Data[Home] [Help]

APPS.PAY_AIF_UPD dependencies on PAY_AIF_SHD

Line 55: (p_rec in out nocopy pay_aif_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy pay_aif_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 114: pay_aif_shd.constraint_error

110: Exception
111: When hr_api.check_integrity_violated Then
112: -- A check constraint has been violated
113: --
114: pay_aif_shd.constraint_error
115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --

Line 119: pay_aif_shd.constraint_error

115: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
116: When hr_api.parent_integrity_violated Then
117: -- Parent integrity has been violated
118: --
119: pay_aif_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --

Line 124: pay_aif_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_aif_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;

Line 164: (p_rec in pay_aif_shd.g_rec_type

160: --
161: -- {End Of Comments}
162: -- ----------------------------------------------------------------------------
163: Procedure pre_update
164: (p_rec in pay_aif_shd.g_rec_type
165: ) is
166: --
167: l_proc varchar2(72) := g_package||'pre_update';
168: --

Line 208: (p_rec in pay_aif_shd.g_rec_type

204: --
205: -- {End Of Comments}
206: -- ----------------------------------------------------------------------------
207: Procedure post_update
208: (p_rec in pay_aif_shd.g_rec_type
209: ) is
210: --
211: l_proc varchar2(72) := g_package||'post_update';
212: --

Line 283: => pay_aif_shd.g_old_rec.action_context_id

279: => p_rec.action_information29
280: ,p_action_information30
281: => p_rec.action_information30
282: ,p_action_context_id_o
283: => pay_aif_shd.g_old_rec.action_context_id
284: ,p_action_context_type_o
285: => pay_aif_shd.g_old_rec.action_context_type
286: ,p_tax_unit_id_o
287: => pay_aif_shd.g_old_rec.tax_unit_id

Line 285: => pay_aif_shd.g_old_rec.action_context_type

281: => p_rec.action_information30
282: ,p_action_context_id_o
283: => pay_aif_shd.g_old_rec.action_context_id
284: ,p_action_context_type_o
285: => pay_aif_shd.g_old_rec.action_context_type
286: ,p_tax_unit_id_o
287: => pay_aif_shd.g_old_rec.tax_unit_id
288: ,p_jurisdiction_code_o
289: => pay_aif_shd.g_old_rec.jurisdiction_code

Line 287: => pay_aif_shd.g_old_rec.tax_unit_id

283: => pay_aif_shd.g_old_rec.action_context_id
284: ,p_action_context_type_o
285: => pay_aif_shd.g_old_rec.action_context_type
286: ,p_tax_unit_id_o
287: => pay_aif_shd.g_old_rec.tax_unit_id
288: ,p_jurisdiction_code_o
289: => pay_aif_shd.g_old_rec.jurisdiction_code
290: ,p_source_id_o
291: => pay_aif_shd.g_old_rec.source_id

Line 289: => pay_aif_shd.g_old_rec.jurisdiction_code

285: => pay_aif_shd.g_old_rec.action_context_type
286: ,p_tax_unit_id_o
287: => pay_aif_shd.g_old_rec.tax_unit_id
288: ,p_jurisdiction_code_o
289: => pay_aif_shd.g_old_rec.jurisdiction_code
290: ,p_source_id_o
291: => pay_aif_shd.g_old_rec.source_id
292: ,p_source_text_o
293: => pay_aif_shd.g_old_rec.source_text

Line 291: => pay_aif_shd.g_old_rec.source_id

287: => pay_aif_shd.g_old_rec.tax_unit_id
288: ,p_jurisdiction_code_o
289: => pay_aif_shd.g_old_rec.jurisdiction_code
290: ,p_source_id_o
291: => pay_aif_shd.g_old_rec.source_id
292: ,p_source_text_o
293: => pay_aif_shd.g_old_rec.source_text
294: ,p_tax_group_o
295: => pay_aif_shd.g_old_rec.tax_group

Line 293: => pay_aif_shd.g_old_rec.source_text

289: => pay_aif_shd.g_old_rec.jurisdiction_code
290: ,p_source_id_o
291: => pay_aif_shd.g_old_rec.source_id
292: ,p_source_text_o
293: => pay_aif_shd.g_old_rec.source_text
294: ,p_tax_group_o
295: => pay_aif_shd.g_old_rec.tax_group
296: ,p_object_version_number_o
297: => pay_aif_shd.g_old_rec.object_version_number

Line 295: => pay_aif_shd.g_old_rec.tax_group

291: => pay_aif_shd.g_old_rec.source_id
292: ,p_source_text_o
293: => pay_aif_shd.g_old_rec.source_text
294: ,p_tax_group_o
295: => pay_aif_shd.g_old_rec.tax_group
296: ,p_object_version_number_o
297: => pay_aif_shd.g_old_rec.object_version_number
298: ,p_effective_date_o
299: => pay_aif_shd.g_old_rec.effective_date

Line 297: => pay_aif_shd.g_old_rec.object_version_number

293: => pay_aif_shd.g_old_rec.source_text
294: ,p_tax_group_o
295: => pay_aif_shd.g_old_rec.tax_group
296: ,p_object_version_number_o
297: => pay_aif_shd.g_old_rec.object_version_number
298: ,p_effective_date_o
299: => pay_aif_shd.g_old_rec.effective_date
300: ,p_assignment_id_o
301: => pay_aif_shd.g_old_rec.assignment_id

Line 299: => pay_aif_shd.g_old_rec.effective_date

295: => pay_aif_shd.g_old_rec.tax_group
296: ,p_object_version_number_o
297: => pay_aif_shd.g_old_rec.object_version_number
298: ,p_effective_date_o
299: => pay_aif_shd.g_old_rec.effective_date
300: ,p_assignment_id_o
301: => pay_aif_shd.g_old_rec.assignment_id
302: ,p_action_information_categor_o
303: => pay_aif_shd.g_old_rec.action_information_category

Line 301: => pay_aif_shd.g_old_rec.assignment_id

297: => pay_aif_shd.g_old_rec.object_version_number
298: ,p_effective_date_o
299: => pay_aif_shd.g_old_rec.effective_date
300: ,p_assignment_id_o
301: => pay_aif_shd.g_old_rec.assignment_id
302: ,p_action_information_categor_o
303: => pay_aif_shd.g_old_rec.action_information_category
304: ,p_action_information1_o
305: => pay_aif_shd.g_old_rec.action_information1

Line 303: => pay_aif_shd.g_old_rec.action_information_category

299: => pay_aif_shd.g_old_rec.effective_date
300: ,p_assignment_id_o
301: => pay_aif_shd.g_old_rec.assignment_id
302: ,p_action_information_categor_o
303: => pay_aif_shd.g_old_rec.action_information_category
304: ,p_action_information1_o
305: => pay_aif_shd.g_old_rec.action_information1
306: ,p_action_information2_o
307: => pay_aif_shd.g_old_rec.action_information2

Line 305: => pay_aif_shd.g_old_rec.action_information1

301: => pay_aif_shd.g_old_rec.assignment_id
302: ,p_action_information_categor_o
303: => pay_aif_shd.g_old_rec.action_information_category
304: ,p_action_information1_o
305: => pay_aif_shd.g_old_rec.action_information1
306: ,p_action_information2_o
307: => pay_aif_shd.g_old_rec.action_information2
308: ,p_action_information3_o
309: => pay_aif_shd.g_old_rec.action_information3

Line 307: => pay_aif_shd.g_old_rec.action_information2

303: => pay_aif_shd.g_old_rec.action_information_category
304: ,p_action_information1_o
305: => pay_aif_shd.g_old_rec.action_information1
306: ,p_action_information2_o
307: => pay_aif_shd.g_old_rec.action_information2
308: ,p_action_information3_o
309: => pay_aif_shd.g_old_rec.action_information3
310: ,p_action_information4_o
311: => pay_aif_shd.g_old_rec.action_information4

Line 309: => pay_aif_shd.g_old_rec.action_information3

305: => pay_aif_shd.g_old_rec.action_information1
306: ,p_action_information2_o
307: => pay_aif_shd.g_old_rec.action_information2
308: ,p_action_information3_o
309: => pay_aif_shd.g_old_rec.action_information3
310: ,p_action_information4_o
311: => pay_aif_shd.g_old_rec.action_information4
312: ,p_action_information5_o
313: => pay_aif_shd.g_old_rec.action_information5

Line 311: => pay_aif_shd.g_old_rec.action_information4

307: => pay_aif_shd.g_old_rec.action_information2
308: ,p_action_information3_o
309: => pay_aif_shd.g_old_rec.action_information3
310: ,p_action_information4_o
311: => pay_aif_shd.g_old_rec.action_information4
312: ,p_action_information5_o
313: => pay_aif_shd.g_old_rec.action_information5
314: ,p_action_information6_o
315: => pay_aif_shd.g_old_rec.action_information6

Line 313: => pay_aif_shd.g_old_rec.action_information5

309: => pay_aif_shd.g_old_rec.action_information3
310: ,p_action_information4_o
311: => pay_aif_shd.g_old_rec.action_information4
312: ,p_action_information5_o
313: => pay_aif_shd.g_old_rec.action_information5
314: ,p_action_information6_o
315: => pay_aif_shd.g_old_rec.action_information6
316: ,p_action_information7_o
317: => pay_aif_shd.g_old_rec.action_information7

Line 315: => pay_aif_shd.g_old_rec.action_information6

311: => pay_aif_shd.g_old_rec.action_information4
312: ,p_action_information5_o
313: => pay_aif_shd.g_old_rec.action_information5
314: ,p_action_information6_o
315: => pay_aif_shd.g_old_rec.action_information6
316: ,p_action_information7_o
317: => pay_aif_shd.g_old_rec.action_information7
318: ,p_action_information8_o
319: => pay_aif_shd.g_old_rec.action_information8

Line 317: => pay_aif_shd.g_old_rec.action_information7

313: => pay_aif_shd.g_old_rec.action_information5
314: ,p_action_information6_o
315: => pay_aif_shd.g_old_rec.action_information6
316: ,p_action_information7_o
317: => pay_aif_shd.g_old_rec.action_information7
318: ,p_action_information8_o
319: => pay_aif_shd.g_old_rec.action_information8
320: ,p_action_information9_o
321: => pay_aif_shd.g_old_rec.action_information9

Line 319: => pay_aif_shd.g_old_rec.action_information8

315: => pay_aif_shd.g_old_rec.action_information6
316: ,p_action_information7_o
317: => pay_aif_shd.g_old_rec.action_information7
318: ,p_action_information8_o
319: => pay_aif_shd.g_old_rec.action_information8
320: ,p_action_information9_o
321: => pay_aif_shd.g_old_rec.action_information9
322: ,p_action_information10_o
323: => pay_aif_shd.g_old_rec.action_information10

Line 321: => pay_aif_shd.g_old_rec.action_information9

317: => pay_aif_shd.g_old_rec.action_information7
318: ,p_action_information8_o
319: => pay_aif_shd.g_old_rec.action_information8
320: ,p_action_information9_o
321: => pay_aif_shd.g_old_rec.action_information9
322: ,p_action_information10_o
323: => pay_aif_shd.g_old_rec.action_information10
324: ,p_action_information11_o
325: => pay_aif_shd.g_old_rec.action_information11

Line 323: => pay_aif_shd.g_old_rec.action_information10

319: => pay_aif_shd.g_old_rec.action_information8
320: ,p_action_information9_o
321: => pay_aif_shd.g_old_rec.action_information9
322: ,p_action_information10_o
323: => pay_aif_shd.g_old_rec.action_information10
324: ,p_action_information11_o
325: => pay_aif_shd.g_old_rec.action_information11
326: ,p_action_information12_o
327: => pay_aif_shd.g_old_rec.action_information12

Line 325: => pay_aif_shd.g_old_rec.action_information11

321: => pay_aif_shd.g_old_rec.action_information9
322: ,p_action_information10_o
323: => pay_aif_shd.g_old_rec.action_information10
324: ,p_action_information11_o
325: => pay_aif_shd.g_old_rec.action_information11
326: ,p_action_information12_o
327: => pay_aif_shd.g_old_rec.action_information12
328: ,p_action_information13_o
329: => pay_aif_shd.g_old_rec.action_information13

Line 327: => pay_aif_shd.g_old_rec.action_information12

323: => pay_aif_shd.g_old_rec.action_information10
324: ,p_action_information11_o
325: => pay_aif_shd.g_old_rec.action_information11
326: ,p_action_information12_o
327: => pay_aif_shd.g_old_rec.action_information12
328: ,p_action_information13_o
329: => pay_aif_shd.g_old_rec.action_information13
330: ,p_action_information14_o
331: => pay_aif_shd.g_old_rec.action_information14

Line 329: => pay_aif_shd.g_old_rec.action_information13

325: => pay_aif_shd.g_old_rec.action_information11
326: ,p_action_information12_o
327: => pay_aif_shd.g_old_rec.action_information12
328: ,p_action_information13_o
329: => pay_aif_shd.g_old_rec.action_information13
330: ,p_action_information14_o
331: => pay_aif_shd.g_old_rec.action_information14
332: ,p_action_information15_o
333: => pay_aif_shd.g_old_rec.action_information15

Line 331: => pay_aif_shd.g_old_rec.action_information14

327: => pay_aif_shd.g_old_rec.action_information12
328: ,p_action_information13_o
329: => pay_aif_shd.g_old_rec.action_information13
330: ,p_action_information14_o
331: => pay_aif_shd.g_old_rec.action_information14
332: ,p_action_information15_o
333: => pay_aif_shd.g_old_rec.action_information15
334: ,p_action_information16_o
335: => pay_aif_shd.g_old_rec.action_information16

Line 333: => pay_aif_shd.g_old_rec.action_information15

329: => pay_aif_shd.g_old_rec.action_information13
330: ,p_action_information14_o
331: => pay_aif_shd.g_old_rec.action_information14
332: ,p_action_information15_o
333: => pay_aif_shd.g_old_rec.action_information15
334: ,p_action_information16_o
335: => pay_aif_shd.g_old_rec.action_information16
336: ,p_action_information17_o
337: => pay_aif_shd.g_old_rec.action_information17

Line 335: => pay_aif_shd.g_old_rec.action_information16

331: => pay_aif_shd.g_old_rec.action_information14
332: ,p_action_information15_o
333: => pay_aif_shd.g_old_rec.action_information15
334: ,p_action_information16_o
335: => pay_aif_shd.g_old_rec.action_information16
336: ,p_action_information17_o
337: => pay_aif_shd.g_old_rec.action_information17
338: ,p_action_information18_o
339: => pay_aif_shd.g_old_rec.action_information18

Line 337: => pay_aif_shd.g_old_rec.action_information17

333: => pay_aif_shd.g_old_rec.action_information15
334: ,p_action_information16_o
335: => pay_aif_shd.g_old_rec.action_information16
336: ,p_action_information17_o
337: => pay_aif_shd.g_old_rec.action_information17
338: ,p_action_information18_o
339: => pay_aif_shd.g_old_rec.action_information18
340: ,p_action_information19_o
341: => pay_aif_shd.g_old_rec.action_information19

Line 339: => pay_aif_shd.g_old_rec.action_information18

335: => pay_aif_shd.g_old_rec.action_information16
336: ,p_action_information17_o
337: => pay_aif_shd.g_old_rec.action_information17
338: ,p_action_information18_o
339: => pay_aif_shd.g_old_rec.action_information18
340: ,p_action_information19_o
341: => pay_aif_shd.g_old_rec.action_information19
342: ,p_action_information20_o
343: => pay_aif_shd.g_old_rec.action_information20

Line 341: => pay_aif_shd.g_old_rec.action_information19

337: => pay_aif_shd.g_old_rec.action_information17
338: ,p_action_information18_o
339: => pay_aif_shd.g_old_rec.action_information18
340: ,p_action_information19_o
341: => pay_aif_shd.g_old_rec.action_information19
342: ,p_action_information20_o
343: => pay_aif_shd.g_old_rec.action_information20
344: ,p_action_information21_o
345: => pay_aif_shd.g_old_rec.action_information21

Line 343: => pay_aif_shd.g_old_rec.action_information20

339: => pay_aif_shd.g_old_rec.action_information18
340: ,p_action_information19_o
341: => pay_aif_shd.g_old_rec.action_information19
342: ,p_action_information20_o
343: => pay_aif_shd.g_old_rec.action_information20
344: ,p_action_information21_o
345: => pay_aif_shd.g_old_rec.action_information21
346: ,p_action_information22_o
347: => pay_aif_shd.g_old_rec.action_information22

Line 345: => pay_aif_shd.g_old_rec.action_information21

341: => pay_aif_shd.g_old_rec.action_information19
342: ,p_action_information20_o
343: => pay_aif_shd.g_old_rec.action_information20
344: ,p_action_information21_o
345: => pay_aif_shd.g_old_rec.action_information21
346: ,p_action_information22_o
347: => pay_aif_shd.g_old_rec.action_information22
348: ,p_action_information23_o
349: => pay_aif_shd.g_old_rec.action_information23

Line 347: => pay_aif_shd.g_old_rec.action_information22

343: => pay_aif_shd.g_old_rec.action_information20
344: ,p_action_information21_o
345: => pay_aif_shd.g_old_rec.action_information21
346: ,p_action_information22_o
347: => pay_aif_shd.g_old_rec.action_information22
348: ,p_action_information23_o
349: => pay_aif_shd.g_old_rec.action_information23
350: ,p_action_information24_o
351: => pay_aif_shd.g_old_rec.action_information24

Line 349: => pay_aif_shd.g_old_rec.action_information23

345: => pay_aif_shd.g_old_rec.action_information21
346: ,p_action_information22_o
347: => pay_aif_shd.g_old_rec.action_information22
348: ,p_action_information23_o
349: => pay_aif_shd.g_old_rec.action_information23
350: ,p_action_information24_o
351: => pay_aif_shd.g_old_rec.action_information24
352: ,p_action_information25_o
353: => pay_aif_shd.g_old_rec.action_information25

Line 351: => pay_aif_shd.g_old_rec.action_information24

347: => pay_aif_shd.g_old_rec.action_information22
348: ,p_action_information23_o
349: => pay_aif_shd.g_old_rec.action_information23
350: ,p_action_information24_o
351: => pay_aif_shd.g_old_rec.action_information24
352: ,p_action_information25_o
353: => pay_aif_shd.g_old_rec.action_information25
354: ,p_action_information26_o
355: => pay_aif_shd.g_old_rec.action_information26

Line 353: => pay_aif_shd.g_old_rec.action_information25

349: => pay_aif_shd.g_old_rec.action_information23
350: ,p_action_information24_o
351: => pay_aif_shd.g_old_rec.action_information24
352: ,p_action_information25_o
353: => pay_aif_shd.g_old_rec.action_information25
354: ,p_action_information26_o
355: => pay_aif_shd.g_old_rec.action_information26
356: ,p_action_information27_o
357: => pay_aif_shd.g_old_rec.action_information27

Line 355: => pay_aif_shd.g_old_rec.action_information26

351: => pay_aif_shd.g_old_rec.action_information24
352: ,p_action_information25_o
353: => pay_aif_shd.g_old_rec.action_information25
354: ,p_action_information26_o
355: => pay_aif_shd.g_old_rec.action_information26
356: ,p_action_information27_o
357: => pay_aif_shd.g_old_rec.action_information27
358: ,p_action_information28_o
359: => pay_aif_shd.g_old_rec.action_information28

Line 357: => pay_aif_shd.g_old_rec.action_information27

353: => pay_aif_shd.g_old_rec.action_information25
354: ,p_action_information26_o
355: => pay_aif_shd.g_old_rec.action_information26
356: ,p_action_information27_o
357: => pay_aif_shd.g_old_rec.action_information27
358: ,p_action_information28_o
359: => pay_aif_shd.g_old_rec.action_information28
360: ,p_action_information29_o
361: => pay_aif_shd.g_old_rec.action_information29

Line 359: => pay_aif_shd.g_old_rec.action_information28

355: => pay_aif_shd.g_old_rec.action_information26
356: ,p_action_information27_o
357: => pay_aif_shd.g_old_rec.action_information27
358: ,p_action_information28_o
359: => pay_aif_shd.g_old_rec.action_information28
360: ,p_action_information29_o
361: => pay_aif_shd.g_old_rec.action_information29
362: ,p_action_information30_o
363: => pay_aif_shd.g_old_rec.action_information30

Line 361: => pay_aif_shd.g_old_rec.action_information29

357: => pay_aif_shd.g_old_rec.action_information27
358: ,p_action_information28_o
359: => pay_aif_shd.g_old_rec.action_information28
360: ,p_action_information29_o
361: => pay_aif_shd.g_old_rec.action_information29
362: ,p_action_information30_o
363: => pay_aif_shd.g_old_rec.action_information30
364: );
365: --

Line 363: => pay_aif_shd.g_old_rec.action_information30

359: => pay_aif_shd.g_old_rec.action_information28
360: ,p_action_information29_o
361: => pay_aif_shd.g_old_rec.action_information29
362: ,p_action_information30_o
363: => pay_aif_shd.g_old_rec.action_information30
364: );
365: --
366: exception
367: --

Line 423: (p_rec in out nocopy pay_aif_shd.g_rec_type

419: --
420: -- {End Of Comments}
421: -- ----------------------------------------------------------------------------
422: Procedure convert_defs
423: (p_rec in out nocopy pay_aif_shd.g_rec_type
424: ) is
425: --
426: Begin
427: --

Line 435: pay_aif_shd.g_old_rec.action_context_id;

431: -- is being used then we must set to the 'current' argument value.
432: --
433: If (p_rec.action_context_id = hr_api.g_number) then
434: p_rec.action_context_id :=
435: pay_aif_shd.g_old_rec.action_context_id;
436: End If;
437: If (p_rec.action_context_type = hr_api.g_varchar2) then
438: p_rec.action_context_type :=
439: pay_aif_shd.g_old_rec.action_context_type;

Line 439: pay_aif_shd.g_old_rec.action_context_type;

435: pay_aif_shd.g_old_rec.action_context_id;
436: End If;
437: If (p_rec.action_context_type = hr_api.g_varchar2) then
438: p_rec.action_context_type :=
439: pay_aif_shd.g_old_rec.action_context_type;
440: End If;
441: If (p_rec.tax_unit_id = hr_api.g_number) then
442: p_rec.tax_unit_id :=
443: pay_aif_shd.g_old_rec.tax_unit_id;

Line 443: pay_aif_shd.g_old_rec.tax_unit_id;

439: pay_aif_shd.g_old_rec.action_context_type;
440: End If;
441: If (p_rec.tax_unit_id = hr_api.g_number) then
442: p_rec.tax_unit_id :=
443: pay_aif_shd.g_old_rec.tax_unit_id;
444: End If;
445: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
446: p_rec.jurisdiction_code :=
447: pay_aif_shd.g_old_rec.jurisdiction_code;

Line 447: pay_aif_shd.g_old_rec.jurisdiction_code;

443: pay_aif_shd.g_old_rec.tax_unit_id;
444: End If;
445: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
446: p_rec.jurisdiction_code :=
447: pay_aif_shd.g_old_rec.jurisdiction_code;
448: End If;
449: If (p_rec.source_id = hr_api.g_number) then
450: p_rec.source_id :=
451: pay_aif_shd.g_old_rec.source_id;

Line 451: pay_aif_shd.g_old_rec.source_id;

447: pay_aif_shd.g_old_rec.jurisdiction_code;
448: End If;
449: If (p_rec.source_id = hr_api.g_number) then
450: p_rec.source_id :=
451: pay_aif_shd.g_old_rec.source_id;
452: End If;
453: If (p_rec.source_text = hr_api.g_varchar2) then
454: p_rec.source_text :=
455: pay_aif_shd.g_old_rec.source_text;

Line 455: pay_aif_shd.g_old_rec.source_text;

451: pay_aif_shd.g_old_rec.source_id;
452: End If;
453: If (p_rec.source_text = hr_api.g_varchar2) then
454: p_rec.source_text :=
455: pay_aif_shd.g_old_rec.source_text;
456: End If;
457: If (p_rec.tax_group = hr_api.g_varchar2) then
458: p_rec.tax_group :=
459: pay_aif_shd.g_old_rec.tax_group;

Line 459: pay_aif_shd.g_old_rec.tax_group;

455: pay_aif_shd.g_old_rec.source_text;
456: End If;
457: If (p_rec.tax_group = hr_api.g_varchar2) then
458: p_rec.tax_group :=
459: pay_aif_shd.g_old_rec.tax_group;
460: End If;
461: If (p_rec.effective_date = hr_api.g_date) then
462: p_rec.effective_date :=
463: pay_aif_shd.g_old_rec.effective_date;

Line 463: pay_aif_shd.g_old_rec.effective_date;

459: pay_aif_shd.g_old_rec.tax_group;
460: End If;
461: If (p_rec.effective_date = hr_api.g_date) then
462: p_rec.effective_date :=
463: pay_aif_shd.g_old_rec.effective_date;
464: End If;
465: If (p_rec.assignment_id = hr_api.g_number) then
466: p_rec.assignment_id :=
467: pay_aif_shd.g_old_rec.assignment_id;

Line 467: pay_aif_shd.g_old_rec.assignment_id;

463: pay_aif_shd.g_old_rec.effective_date;
464: End If;
465: If (p_rec.assignment_id = hr_api.g_number) then
466: p_rec.assignment_id :=
467: pay_aif_shd.g_old_rec.assignment_id;
468: End If;
469: If (p_rec.action_information_category = hr_api.g_varchar2) then
470: p_rec.action_information_category :=
471: pay_aif_shd.g_old_rec.action_information_category;

Line 471: pay_aif_shd.g_old_rec.action_information_category;

467: pay_aif_shd.g_old_rec.assignment_id;
468: End If;
469: If (p_rec.action_information_category = hr_api.g_varchar2) then
470: p_rec.action_information_category :=
471: pay_aif_shd.g_old_rec.action_information_category;
472: End If;
473: If (p_rec.action_information1 = hr_api.g_varchar2) then
474: p_rec.action_information1 :=
475: pay_aif_shd.g_old_rec.action_information1;

Line 475: pay_aif_shd.g_old_rec.action_information1;

471: pay_aif_shd.g_old_rec.action_information_category;
472: End If;
473: If (p_rec.action_information1 = hr_api.g_varchar2) then
474: p_rec.action_information1 :=
475: pay_aif_shd.g_old_rec.action_information1;
476: End If;
477: If (p_rec.action_information2 = hr_api.g_varchar2) then
478: p_rec.action_information2 :=
479: pay_aif_shd.g_old_rec.action_information2;

Line 479: pay_aif_shd.g_old_rec.action_information2;

475: pay_aif_shd.g_old_rec.action_information1;
476: End If;
477: If (p_rec.action_information2 = hr_api.g_varchar2) then
478: p_rec.action_information2 :=
479: pay_aif_shd.g_old_rec.action_information2;
480: End If;
481: If (p_rec.action_information3 = hr_api.g_varchar2) then
482: p_rec.action_information3 :=
483: pay_aif_shd.g_old_rec.action_information3;

Line 483: pay_aif_shd.g_old_rec.action_information3;

479: pay_aif_shd.g_old_rec.action_information2;
480: End If;
481: If (p_rec.action_information3 = hr_api.g_varchar2) then
482: p_rec.action_information3 :=
483: pay_aif_shd.g_old_rec.action_information3;
484: End If;
485: If (p_rec.action_information4 = hr_api.g_varchar2) then
486: p_rec.action_information4 :=
487: pay_aif_shd.g_old_rec.action_information4;

Line 487: pay_aif_shd.g_old_rec.action_information4;

483: pay_aif_shd.g_old_rec.action_information3;
484: End If;
485: If (p_rec.action_information4 = hr_api.g_varchar2) then
486: p_rec.action_information4 :=
487: pay_aif_shd.g_old_rec.action_information4;
488: End If;
489: If (p_rec.action_information5 = hr_api.g_varchar2) then
490: p_rec.action_information5 :=
491: pay_aif_shd.g_old_rec.action_information5;

Line 491: pay_aif_shd.g_old_rec.action_information5;

487: pay_aif_shd.g_old_rec.action_information4;
488: End If;
489: If (p_rec.action_information5 = hr_api.g_varchar2) then
490: p_rec.action_information5 :=
491: pay_aif_shd.g_old_rec.action_information5;
492: End If;
493: If (p_rec.action_information6 = hr_api.g_varchar2) then
494: p_rec.action_information6 :=
495: pay_aif_shd.g_old_rec.action_information6;

Line 495: pay_aif_shd.g_old_rec.action_information6;

491: pay_aif_shd.g_old_rec.action_information5;
492: End If;
493: If (p_rec.action_information6 = hr_api.g_varchar2) then
494: p_rec.action_information6 :=
495: pay_aif_shd.g_old_rec.action_information6;
496: End If;
497: If (p_rec.action_information7 = hr_api.g_varchar2) then
498: p_rec.action_information7 :=
499: pay_aif_shd.g_old_rec.action_information7;

Line 499: pay_aif_shd.g_old_rec.action_information7;

495: pay_aif_shd.g_old_rec.action_information6;
496: End If;
497: If (p_rec.action_information7 = hr_api.g_varchar2) then
498: p_rec.action_information7 :=
499: pay_aif_shd.g_old_rec.action_information7;
500: End If;
501: If (p_rec.action_information8 = hr_api.g_varchar2) then
502: p_rec.action_information8 :=
503: pay_aif_shd.g_old_rec.action_information8;

Line 503: pay_aif_shd.g_old_rec.action_information8;

499: pay_aif_shd.g_old_rec.action_information7;
500: End If;
501: If (p_rec.action_information8 = hr_api.g_varchar2) then
502: p_rec.action_information8 :=
503: pay_aif_shd.g_old_rec.action_information8;
504: End If;
505: If (p_rec.action_information9 = hr_api.g_varchar2) then
506: p_rec.action_information9 :=
507: pay_aif_shd.g_old_rec.action_information9;

Line 507: pay_aif_shd.g_old_rec.action_information9;

503: pay_aif_shd.g_old_rec.action_information8;
504: End If;
505: If (p_rec.action_information9 = hr_api.g_varchar2) then
506: p_rec.action_information9 :=
507: pay_aif_shd.g_old_rec.action_information9;
508: End If;
509: If (p_rec.action_information10 = hr_api.g_varchar2) then
510: p_rec.action_information10 :=
511: pay_aif_shd.g_old_rec.action_information10;

Line 511: pay_aif_shd.g_old_rec.action_information10;

507: pay_aif_shd.g_old_rec.action_information9;
508: End If;
509: If (p_rec.action_information10 = hr_api.g_varchar2) then
510: p_rec.action_information10 :=
511: pay_aif_shd.g_old_rec.action_information10;
512: End If;
513: If (p_rec.action_information11 = hr_api.g_varchar2) then
514: p_rec.action_information11 :=
515: pay_aif_shd.g_old_rec.action_information11;

Line 515: pay_aif_shd.g_old_rec.action_information11;

511: pay_aif_shd.g_old_rec.action_information10;
512: End If;
513: If (p_rec.action_information11 = hr_api.g_varchar2) then
514: p_rec.action_information11 :=
515: pay_aif_shd.g_old_rec.action_information11;
516: End If;
517: If (p_rec.action_information12 = hr_api.g_varchar2) then
518: p_rec.action_information12 :=
519: pay_aif_shd.g_old_rec.action_information12;

Line 519: pay_aif_shd.g_old_rec.action_information12;

515: pay_aif_shd.g_old_rec.action_information11;
516: End If;
517: If (p_rec.action_information12 = hr_api.g_varchar2) then
518: p_rec.action_information12 :=
519: pay_aif_shd.g_old_rec.action_information12;
520: End If;
521: If (p_rec.action_information13 = hr_api.g_varchar2) then
522: p_rec.action_information13 :=
523: pay_aif_shd.g_old_rec.action_information13;

Line 523: pay_aif_shd.g_old_rec.action_information13;

519: pay_aif_shd.g_old_rec.action_information12;
520: End If;
521: If (p_rec.action_information13 = hr_api.g_varchar2) then
522: p_rec.action_information13 :=
523: pay_aif_shd.g_old_rec.action_information13;
524: End If;
525: If (p_rec.action_information14 = hr_api.g_varchar2) then
526: p_rec.action_information14 :=
527: pay_aif_shd.g_old_rec.action_information14;

Line 527: pay_aif_shd.g_old_rec.action_information14;

523: pay_aif_shd.g_old_rec.action_information13;
524: End If;
525: If (p_rec.action_information14 = hr_api.g_varchar2) then
526: p_rec.action_information14 :=
527: pay_aif_shd.g_old_rec.action_information14;
528: End If;
529: If (p_rec.action_information15 = hr_api.g_varchar2) then
530: p_rec.action_information15 :=
531: pay_aif_shd.g_old_rec.action_information15;

Line 531: pay_aif_shd.g_old_rec.action_information15;

527: pay_aif_shd.g_old_rec.action_information14;
528: End If;
529: If (p_rec.action_information15 = hr_api.g_varchar2) then
530: p_rec.action_information15 :=
531: pay_aif_shd.g_old_rec.action_information15;
532: End If;
533: If (p_rec.action_information16 = hr_api.g_varchar2) then
534: p_rec.action_information16 :=
535: pay_aif_shd.g_old_rec.action_information16;

Line 535: pay_aif_shd.g_old_rec.action_information16;

531: pay_aif_shd.g_old_rec.action_information15;
532: End If;
533: If (p_rec.action_information16 = hr_api.g_varchar2) then
534: p_rec.action_information16 :=
535: pay_aif_shd.g_old_rec.action_information16;
536: End If;
537: If (p_rec.action_information17 = hr_api.g_varchar2) then
538: p_rec.action_information17 :=
539: pay_aif_shd.g_old_rec.action_information17;

Line 539: pay_aif_shd.g_old_rec.action_information17;

535: pay_aif_shd.g_old_rec.action_information16;
536: End If;
537: If (p_rec.action_information17 = hr_api.g_varchar2) then
538: p_rec.action_information17 :=
539: pay_aif_shd.g_old_rec.action_information17;
540: End If;
541: If (p_rec.action_information18 = hr_api.g_varchar2) then
542: p_rec.action_information18 :=
543: pay_aif_shd.g_old_rec.action_information18;

Line 543: pay_aif_shd.g_old_rec.action_information18;

539: pay_aif_shd.g_old_rec.action_information17;
540: End If;
541: If (p_rec.action_information18 = hr_api.g_varchar2) then
542: p_rec.action_information18 :=
543: pay_aif_shd.g_old_rec.action_information18;
544: End If;
545: If (p_rec.action_information19 = hr_api.g_varchar2) then
546: p_rec.action_information19 :=
547: pay_aif_shd.g_old_rec.action_information19;

Line 547: pay_aif_shd.g_old_rec.action_information19;

543: pay_aif_shd.g_old_rec.action_information18;
544: End If;
545: If (p_rec.action_information19 = hr_api.g_varchar2) then
546: p_rec.action_information19 :=
547: pay_aif_shd.g_old_rec.action_information19;
548: End If;
549: If (p_rec.action_information20 = hr_api.g_varchar2) then
550: p_rec.action_information20 :=
551: pay_aif_shd.g_old_rec.action_information20;

Line 551: pay_aif_shd.g_old_rec.action_information20;

547: pay_aif_shd.g_old_rec.action_information19;
548: End If;
549: If (p_rec.action_information20 = hr_api.g_varchar2) then
550: p_rec.action_information20 :=
551: pay_aif_shd.g_old_rec.action_information20;
552: End If;
553: If (p_rec.action_information21 = hr_api.g_varchar2) then
554: p_rec.action_information21 :=
555: pay_aif_shd.g_old_rec.action_information21;

Line 555: pay_aif_shd.g_old_rec.action_information21;

551: pay_aif_shd.g_old_rec.action_information20;
552: End If;
553: If (p_rec.action_information21 = hr_api.g_varchar2) then
554: p_rec.action_information21 :=
555: pay_aif_shd.g_old_rec.action_information21;
556: End If;
557: If (p_rec.action_information22 = hr_api.g_varchar2) then
558: p_rec.action_information22 :=
559: pay_aif_shd.g_old_rec.action_information22;

Line 559: pay_aif_shd.g_old_rec.action_information22;

555: pay_aif_shd.g_old_rec.action_information21;
556: End If;
557: If (p_rec.action_information22 = hr_api.g_varchar2) then
558: p_rec.action_information22 :=
559: pay_aif_shd.g_old_rec.action_information22;
560: End If;
561: If (p_rec.action_information23 = hr_api.g_varchar2) then
562: p_rec.action_information23 :=
563: pay_aif_shd.g_old_rec.action_information23;

Line 563: pay_aif_shd.g_old_rec.action_information23;

559: pay_aif_shd.g_old_rec.action_information22;
560: End If;
561: If (p_rec.action_information23 = hr_api.g_varchar2) then
562: p_rec.action_information23 :=
563: pay_aif_shd.g_old_rec.action_information23;
564: End If;
565: If (p_rec.action_information24 = hr_api.g_varchar2) then
566: p_rec.action_information24 :=
567: pay_aif_shd.g_old_rec.action_information24;

Line 567: pay_aif_shd.g_old_rec.action_information24;

563: pay_aif_shd.g_old_rec.action_information23;
564: End If;
565: If (p_rec.action_information24 = hr_api.g_varchar2) then
566: p_rec.action_information24 :=
567: pay_aif_shd.g_old_rec.action_information24;
568: End If;
569: If (p_rec.action_information25 = hr_api.g_varchar2) then
570: p_rec.action_information25 :=
571: pay_aif_shd.g_old_rec.action_information25;

Line 571: pay_aif_shd.g_old_rec.action_information25;

567: pay_aif_shd.g_old_rec.action_information24;
568: End If;
569: If (p_rec.action_information25 = hr_api.g_varchar2) then
570: p_rec.action_information25 :=
571: pay_aif_shd.g_old_rec.action_information25;
572: End If;
573: If (p_rec.action_information26 = hr_api.g_varchar2) then
574: p_rec.action_information26 :=
575: pay_aif_shd.g_old_rec.action_information26;

Line 575: pay_aif_shd.g_old_rec.action_information26;

571: pay_aif_shd.g_old_rec.action_information25;
572: End If;
573: If (p_rec.action_information26 = hr_api.g_varchar2) then
574: p_rec.action_information26 :=
575: pay_aif_shd.g_old_rec.action_information26;
576: End If;
577: If (p_rec.action_information27 = hr_api.g_varchar2) then
578: p_rec.action_information27 :=
579: pay_aif_shd.g_old_rec.action_information27;

Line 579: pay_aif_shd.g_old_rec.action_information27;

575: pay_aif_shd.g_old_rec.action_information26;
576: End If;
577: If (p_rec.action_information27 = hr_api.g_varchar2) then
578: p_rec.action_information27 :=
579: pay_aif_shd.g_old_rec.action_information27;
580: End If;
581: If (p_rec.action_information28 = hr_api.g_varchar2) then
582: p_rec.action_information28 :=
583: pay_aif_shd.g_old_rec.action_information28;

Line 583: pay_aif_shd.g_old_rec.action_information28;

579: pay_aif_shd.g_old_rec.action_information27;
580: End If;
581: If (p_rec.action_information28 = hr_api.g_varchar2) then
582: p_rec.action_information28 :=
583: pay_aif_shd.g_old_rec.action_information28;
584: End If;
585: If (p_rec.action_information29 = hr_api.g_varchar2) then
586: p_rec.action_information29 :=
587: pay_aif_shd.g_old_rec.action_information29;

Line 587: pay_aif_shd.g_old_rec.action_information29;

583: pay_aif_shd.g_old_rec.action_information28;
584: End If;
585: If (p_rec.action_information29 = hr_api.g_varchar2) then
586: p_rec.action_information29 :=
587: pay_aif_shd.g_old_rec.action_information29;
588: End If;
589: If (p_rec.action_information30 = hr_api.g_varchar2) then
590: p_rec.action_information30 :=
591: pay_aif_shd.g_old_rec.action_information30;

Line 591: pay_aif_shd.g_old_rec.action_information30;

587: pay_aif_shd.g_old_rec.action_information29;
588: End If;
589: If (p_rec.action_information30 = hr_api.g_varchar2) then
590: p_rec.action_information30 :=
591: pay_aif_shd.g_old_rec.action_information30;
592: End If;
593: --
594: End convert_defs;
595: --

Line 600: (p_rec in out nocopy pay_aif_shd.g_rec_type

596: -- ----------------------------------------------------------------------------
597: -- |---------------------------------< upd >----------------------------------|
598: -- ----------------------------------------------------------------------------
599: Procedure upd
600: (p_rec in out nocopy pay_aif_shd.g_rec_type
601: ) is
602: --
603: l_proc varchar2(72) := g_package||'upd';
604: --

Line 610: pay_aif_shd.lck

606: hr_utility.set_location('Entering:'||l_proc, 5);
607: --
608: -- We must lock the row which we need to update.
609: --
610: pay_aif_shd.lck
611: (p_rec.action_information_id
612: ,p_rec.object_version_number
613: );
614: --

Line 687: l_rec pay_aif_shd.g_rec_type;

683: ,p_action_information29 in varchar2 default hr_api.g_varchar2
684: ,p_action_information30 in varchar2 default hr_api.g_varchar2
685: ) is
686: --
687: l_rec pay_aif_shd.g_rec_type;
688: l_proc varchar2(72) := g_package||'upd';
689: --
690: Begin
691: hr_utility.set_location('Entering:'||l_proc, 5);

Line 697: pay_aif_shd.convert_args

693: -- Call conversion function to turn arguments into the
694: -- l_rec structure.
695: --
696: l_rec :=
697: pay_aif_shd.convert_args
698: (p_action_information_id
699: ,hr_api.g_number
700: ,hr_api.g_varchar2
701: ,hr_api.g_number