DBA Data[Home] [Help]

APPS.PAY_PGA_UPD dependencies on PAY_PGA_SHD

Line 58: (p_rec in out nocopy pay_pga_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_pga_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 115: pay_pga_shd.constraint_error

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

Line 120: pay_pga_shd.constraint_error

116: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
117: When hr_api.unique_integrity_violated Then
118: -- Unique integrity has been violated
119: --
120: pay_pga_shd.constraint_error
121: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
122: When Others Then
123: --
124: Raise;

Line 159: (p_rec in out nocopy pay_pga_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure update_dml
159: (p_rec in out nocopy pay_pga_shd.g_rec_type
160: ,p_effective_date in date
161: ,p_datetrack_mode in varchar2
162: ,p_validation_start_date in date
163: ,p_validation_end_date in date

Line 226: (p_rec in out nocopy pay_pga_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure dt_pre_update
226: (p_rec in out nocopy pay_pga_shd.g_rec_type
227: ,p_effective_date in date
228: ,p_datetrack_mode in varchar2
229: ,p_validation_start_date in date
230: ,p_validation_end_date in date

Line 242: pay_pga_shd.upd_effective_end_date

238: If (p_datetrack_mode <> hr_api.g_correction) then
239: --
240: -- Update the current effective end date
241: --
242: pay_pga_shd.upd_effective_end_date
243: (p_effective_date => p_effective_date
244: ,p_base_key_value => p_rec.pay_gl_account_id
245: ,p_new_effective_end_date => (p_validation_start_date - 1)
246: ,p_validation_start_date => p_validation_start_date

Line 311: (p_rec in out nocopy pay_pga_shd.g_rec_type

307: --
308: -- {End Of Comments}
309: -- ----------------------------------------------------------------------------
310: Procedure pre_update
311: (p_rec in out nocopy pay_pga_shd.g_rec_type
312: ,p_effective_date in date
313: ,p_datetrack_mode in varchar2
314: ,p_validation_start_date in date
315: ,p_validation_end_date in date

Line 369: (p_rec in pay_pga_shd.g_rec_type

365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure post_update
369: (p_rec in pay_pga_shd.g_rec_type
370: ,p_effective_date in date
371: ,p_datetrack_mode in varchar2
372: ,p_validation_start_date in date
373: ,p_validation_end_date in date

Line 433: (p_rec in out nocopy pay_pga_shd.g_rec_type

429: --
430: -- {End Of Comments}
431: -- ----------------------------------------------------------------------------
432: Procedure convert_defs
433: (p_rec in out nocopy pay_pga_shd.g_rec_type
434: ) is
435: --
436: Begin
437: --

Line 445: pay_pga_shd.g_old_rec.set_of_books_id;

441: -- is being used then we must set to the 'current' argument value.
442: --
443: If (p_rec.set_of_books_id = hr_api.g_number) then
444: p_rec.set_of_books_id :=
445: pay_pga_shd.g_old_rec.set_of_books_id;
446: End If;
447: If (p_rec.gl_cash_ac_id = hr_api.g_number) then
448: p_rec.gl_cash_ac_id :=
449: pay_pga_shd.g_old_rec.gl_cash_ac_id;

Line 449: pay_pga_shd.g_old_rec.gl_cash_ac_id;

445: pay_pga_shd.g_old_rec.set_of_books_id;
446: End If;
447: If (p_rec.gl_cash_ac_id = hr_api.g_number) then
448: p_rec.gl_cash_ac_id :=
449: pay_pga_shd.g_old_rec.gl_cash_ac_id;
450: End If;
451: If (p_rec.gl_cash_clearing_ac_id = hr_api.g_number) then
452: p_rec.gl_cash_clearing_ac_id :=
453: pay_pga_shd.g_old_rec.gl_cash_clearing_ac_id;

Line 453: pay_pga_shd.g_old_rec.gl_cash_clearing_ac_id;

449: pay_pga_shd.g_old_rec.gl_cash_ac_id;
450: End If;
451: If (p_rec.gl_cash_clearing_ac_id = hr_api.g_number) then
452: p_rec.gl_cash_clearing_ac_id :=
453: pay_pga_shd.g_old_rec.gl_cash_clearing_ac_id;
454: End If;
455: If (p_rec.gl_control_ac_id = hr_api.g_number) then
456: p_rec.gl_control_ac_id :=
457: pay_pga_shd.g_old_rec.gl_control_ac_id;

Line 457: pay_pga_shd.g_old_rec.gl_control_ac_id;

453: pay_pga_shd.g_old_rec.gl_cash_clearing_ac_id;
454: End If;
455: If (p_rec.gl_control_ac_id = hr_api.g_number) then
456: p_rec.gl_control_ac_id :=
457: pay_pga_shd.g_old_rec.gl_control_ac_id;
458: End If;
459: If (p_rec.gl_error_ac_id = hr_api.g_number) then
460: p_rec.gl_error_ac_id :=
461: pay_pga_shd.g_old_rec.gl_error_ac_id;

Line 461: pay_pga_shd.g_old_rec.gl_error_ac_id;

457: pay_pga_shd.g_old_rec.gl_control_ac_id;
458: End If;
459: If (p_rec.gl_error_ac_id = hr_api.g_number) then
460: p_rec.gl_error_ac_id :=
461: pay_pga_shd.g_old_rec.gl_error_ac_id;
462: End If;
463: If (p_rec.external_account_id = hr_api.g_number) then
464: p_rec.external_account_id :=
465: pay_pga_shd.g_old_rec.external_account_id;

Line 465: pay_pga_shd.g_old_rec.external_account_id;

461: pay_pga_shd.g_old_rec.gl_error_ac_id;
462: End If;
463: If (p_rec.external_account_id = hr_api.g_number) then
464: p_rec.external_account_id :=
465: pay_pga_shd.g_old_rec.external_account_id;
466: End If;
467: If (p_rec.org_payment_method_id = hr_api.g_number) then
468: p_rec.org_payment_method_id :=
469: pay_pga_shd.g_old_rec.org_payment_method_id;

Line 469: pay_pga_shd.g_old_rec.org_payment_method_id;

465: pay_pga_shd.g_old_rec.external_account_id;
466: End If;
467: If (p_rec.org_payment_method_id = hr_api.g_number) then
468: p_rec.org_payment_method_id :=
469: pay_pga_shd.g_old_rec.org_payment_method_id;
470: End If;
471: --
472: End convert_defs;
473: --

Line 480: ,p_rec in out nocopy pay_pga_shd.g_rec_type

476: -- ----------------------------------------------------------------------------
477: Procedure upd
478: (p_effective_date in date
479: ,p_datetrack_mode in varchar2
480: ,p_rec in out nocopy pay_pga_shd.g_rec_type
481: ) is
482: --
483: l_proc varchar2(72) := g_package||'upd';
484: l_validation_start_date date;

Line 496: pay_pga_shd.lck

492: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
493: --
494: -- We must lock the row which we need to update.
495: --
496: pay_pga_shd.lck
497: (p_effective_date => p_effective_date
498: ,p_datetrack_mode => p_datetrack_mode
499: ,p_pay_gl_account_id => p_rec.pay_gl_account_id
500: ,p_object_version_number => p_rec.object_version_number

Line 577: l_rec pay_pga_shd.g_rec_type;

573: ,p_effective_start_date out nocopy date
574: ,p_effective_end_date out nocopy date
575: ) is
576: --
577: l_rec pay_pga_shd.g_rec_type;
578: l_proc varchar2(72) := g_package||'upd';
579: --
580: Begin
581: hr_utility.set_location('Entering:'||l_proc, 5);

Line 587: pay_pga_shd.convert_args

583: -- Call conversion function to turn arguments into the
584: -- l_rec structure.
585: --
586: l_rec :=
587: pay_pga_shd.convert_args
588: (p_pay_gl_account_id
589: ,null
590: ,null
591: ,p_set_of_books_id