eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CAL_UPD dependencies on PAY_CAL_SHD

Line 58: (p_rec in out nocopy pay_cal_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_cal_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 83: pay_cal_shd.g_api_dml := true; -- Set the api dml status

79: ,p_base_key_column => 'cost_allocation_id'
80: ,p_base_key_value => p_rec.cost_allocation_id
81: );
82: --
83: pay_cal_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_cost_allocations_f Row
86: --
87: update pay_cost_allocations_f

Line 103: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

99: where cost_allocation_id = p_rec.cost_allocation_id
100: and effective_start_date = p_validation_start_date
101: and effective_end_date = p_validation_end_date;
102: --
103: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
104: --
105: -- Set the effective start and end dates
106: --
107: p_rec.effective_start_date := p_validation_start_date;

Line 115: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

111: hr_utility.set_location(' Leaving:'||l_proc, 15);
112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
116: pay_cal_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated

Line 116: pay_cal_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
116: pay_cal_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

Line 120: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

116: pay_cal_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
121: pay_cal_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

Line 121: pay_cal_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.unique_integrity_violated Then
119: -- Unique integrity has been violated
120: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
121: pay_cal_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
125: Raise;

Line 124: pay_cal_shd.g_api_dml := false; -- Unset the api dml status

120: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
121: pay_cal_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: pay_cal_shd.g_api_dml := false; -- Unset the api dml status
125: Raise;
126: End dt_update_dml;
127: --
128: -- ----------------------------------------------------------------------------

Line 160: (p_rec in out nocopy pay_cal_shd.g_rec_type

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

Line 227: (p_rec in out nocopy pay_cal_shd.g_rec_type

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

Line 243: pay_cal_shd.upd_effective_end_date

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

Line 312: (p_rec in out nocopy pay_cal_shd.g_rec_type

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

Line 370: (p_rec in pay_cal_shd.g_rec_type

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

Line 417: => pay_cal_shd.g_old_rec.effective_start_date

413: => p_rec.program_update_date
414: ,p_object_version_number
415: => p_rec.object_version_number
416: ,p_effective_start_date_o
417: => pay_cal_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o
419: => pay_cal_shd.g_old_rec.effective_end_date
420: ,p_business_group_id_o
421: => pay_cal_shd.g_old_rec.business_group_id

Line 419: => pay_cal_shd.g_old_rec.effective_end_date

415: => p_rec.object_version_number
416: ,p_effective_start_date_o
417: => pay_cal_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o
419: => pay_cal_shd.g_old_rec.effective_end_date
420: ,p_business_group_id_o
421: => pay_cal_shd.g_old_rec.business_group_id
422: ,p_cost_allocation_keyflex_id_o
423: => pay_cal_shd.g_old_rec.cost_allocation_keyflex_id

Line 421: => pay_cal_shd.g_old_rec.business_group_id

417: => pay_cal_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o
419: => pay_cal_shd.g_old_rec.effective_end_date
420: ,p_business_group_id_o
421: => pay_cal_shd.g_old_rec.business_group_id
422: ,p_cost_allocation_keyflex_id_o
423: => pay_cal_shd.g_old_rec.cost_allocation_keyflex_id
424: ,p_assignment_id_o
425: => pay_cal_shd.g_old_rec.assignment_id

Line 423: => pay_cal_shd.g_old_rec.cost_allocation_keyflex_id

419: => pay_cal_shd.g_old_rec.effective_end_date
420: ,p_business_group_id_o
421: => pay_cal_shd.g_old_rec.business_group_id
422: ,p_cost_allocation_keyflex_id_o
423: => pay_cal_shd.g_old_rec.cost_allocation_keyflex_id
424: ,p_assignment_id_o
425: => pay_cal_shd.g_old_rec.assignment_id
426: ,p_proportion_o
427: => pay_cal_shd.g_old_rec.proportion

Line 425: => pay_cal_shd.g_old_rec.assignment_id

421: => pay_cal_shd.g_old_rec.business_group_id
422: ,p_cost_allocation_keyflex_id_o
423: => pay_cal_shd.g_old_rec.cost_allocation_keyflex_id
424: ,p_assignment_id_o
425: => pay_cal_shd.g_old_rec.assignment_id
426: ,p_proportion_o
427: => pay_cal_shd.g_old_rec.proportion
428: ,p_request_id_o
429: => pay_cal_shd.g_old_rec.request_id

Line 427: => pay_cal_shd.g_old_rec.proportion

423: => pay_cal_shd.g_old_rec.cost_allocation_keyflex_id
424: ,p_assignment_id_o
425: => pay_cal_shd.g_old_rec.assignment_id
426: ,p_proportion_o
427: => pay_cal_shd.g_old_rec.proportion
428: ,p_request_id_o
429: => pay_cal_shd.g_old_rec.request_id
430: ,p_program_application_id_o
431: => pay_cal_shd.g_old_rec.program_application_id

Line 429: => pay_cal_shd.g_old_rec.request_id

425: => pay_cal_shd.g_old_rec.assignment_id
426: ,p_proportion_o
427: => pay_cal_shd.g_old_rec.proportion
428: ,p_request_id_o
429: => pay_cal_shd.g_old_rec.request_id
430: ,p_program_application_id_o
431: => pay_cal_shd.g_old_rec.program_application_id
432: ,p_program_id_o
433: => pay_cal_shd.g_old_rec.program_id

Line 431: => pay_cal_shd.g_old_rec.program_application_id

427: => pay_cal_shd.g_old_rec.proportion
428: ,p_request_id_o
429: => pay_cal_shd.g_old_rec.request_id
430: ,p_program_application_id_o
431: => pay_cal_shd.g_old_rec.program_application_id
432: ,p_program_id_o
433: => pay_cal_shd.g_old_rec.program_id
434: ,p_program_update_date_o
435: => pay_cal_shd.g_old_rec.program_update_date

Line 433: => pay_cal_shd.g_old_rec.program_id

429: => pay_cal_shd.g_old_rec.request_id
430: ,p_program_application_id_o
431: => pay_cal_shd.g_old_rec.program_application_id
432: ,p_program_id_o
433: => pay_cal_shd.g_old_rec.program_id
434: ,p_program_update_date_o
435: => pay_cal_shd.g_old_rec.program_update_date
436: ,p_object_version_number_o
437: => pay_cal_shd.g_old_rec.object_version_number

Line 435: => pay_cal_shd.g_old_rec.program_update_date

431: => pay_cal_shd.g_old_rec.program_application_id
432: ,p_program_id_o
433: => pay_cal_shd.g_old_rec.program_id
434: ,p_program_update_date_o
435: => pay_cal_shd.g_old_rec.program_update_date
436: ,p_object_version_number_o
437: => pay_cal_shd.g_old_rec.object_version_number
438: );
439: --

Line 437: => pay_cal_shd.g_old_rec.object_version_number

433: => pay_cal_shd.g_old_rec.program_id
434: ,p_program_update_date_o
435: => pay_cal_shd.g_old_rec.program_update_date
436: ,p_object_version_number_o
437: => pay_cal_shd.g_old_rec.object_version_number
438: );
439: --
440: exception
441: --

Line 497: (p_rec in out nocopy pay_cal_shd.g_rec_type

493: --
494: -- {End Of Comments}
495: -- ----------------------------------------------------------------------------
496: Procedure convert_defs
497: (p_rec in out nocopy pay_cal_shd.g_rec_type
498: ) is
499: --
500: Begin
501: --

Line 509: pay_cal_shd.g_old_rec.business_group_id;

505: -- is being used then we must set to the 'current' argument value.
506: --
507: If (p_rec.business_group_id = hr_api.g_number) then
508: p_rec.business_group_id :=
509: pay_cal_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
512: p_rec.cost_allocation_keyflex_id :=
513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;

Line 513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;

509: pay_cal_shd.g_old_rec.business_group_id;
510: End If;
511: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
512: p_rec.cost_allocation_keyflex_id :=
513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;
514: End If;
515: If (p_rec.assignment_id = hr_api.g_number) then
516: p_rec.assignment_id :=
517: pay_cal_shd.g_old_rec.assignment_id;

Line 517: pay_cal_shd.g_old_rec.assignment_id;

513: pay_cal_shd.g_old_rec.cost_allocation_keyflex_id;
514: End If;
515: If (p_rec.assignment_id = hr_api.g_number) then
516: p_rec.assignment_id :=
517: pay_cal_shd.g_old_rec.assignment_id;
518: End If;
519: If (p_rec.proportion = hr_api.g_number) then
520: p_rec.proportion :=
521: pay_cal_shd.g_old_rec.proportion;

Line 521: pay_cal_shd.g_old_rec.proportion;

517: pay_cal_shd.g_old_rec.assignment_id;
518: End If;
519: If (p_rec.proportion = hr_api.g_number) then
520: p_rec.proportion :=
521: pay_cal_shd.g_old_rec.proportion;
522: End If;
523: If (p_rec.request_id = hr_api.g_number) then
524: p_rec.request_id :=
525: pay_cal_shd.g_old_rec.request_id;

Line 525: pay_cal_shd.g_old_rec.request_id;

521: pay_cal_shd.g_old_rec.proportion;
522: End If;
523: If (p_rec.request_id = hr_api.g_number) then
524: p_rec.request_id :=
525: pay_cal_shd.g_old_rec.request_id;
526: End If;
527: If (p_rec.program_application_id = hr_api.g_number) then
528: p_rec.program_application_id :=
529: pay_cal_shd.g_old_rec.program_application_id;

Line 529: pay_cal_shd.g_old_rec.program_application_id;

525: pay_cal_shd.g_old_rec.request_id;
526: End If;
527: If (p_rec.program_application_id = hr_api.g_number) then
528: p_rec.program_application_id :=
529: pay_cal_shd.g_old_rec.program_application_id;
530: End If;
531: If (p_rec.program_id = hr_api.g_number) then
532: p_rec.program_id :=
533: pay_cal_shd.g_old_rec.program_id;

Line 533: pay_cal_shd.g_old_rec.program_id;

529: pay_cal_shd.g_old_rec.program_application_id;
530: End If;
531: If (p_rec.program_id = hr_api.g_number) then
532: p_rec.program_id :=
533: pay_cal_shd.g_old_rec.program_id;
534: End If;
535: If (p_rec.program_update_date = hr_api.g_date) then
536: p_rec.program_update_date :=
537: pay_cal_shd.g_old_rec.program_update_date;

Line 537: pay_cal_shd.g_old_rec.program_update_date;

533: pay_cal_shd.g_old_rec.program_id;
534: End If;
535: If (p_rec.program_update_date = hr_api.g_date) then
536: p_rec.program_update_date :=
537: pay_cal_shd.g_old_rec.program_update_date;
538: End If;
539: --
540: End convert_defs;
541: --

Line 548: ,p_rec in out nocopy pay_cal_shd.g_rec_type

544: -- ----------------------------------------------------------------------------
545: Procedure upd
546: (p_effective_date in date
547: ,p_datetrack_mode in varchar2
548: ,p_rec in out nocopy pay_cal_shd.g_rec_type
549: ) is
550: --
551: l_proc varchar2(72) := g_package||'upd';
552: l_validation_start_date date;

Line 564: pay_cal_shd.lck

560: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
561: --
562: -- We must lock the row which we need to update.
563: --
564: pay_cal_shd.lck
565: (p_effective_date => p_effective_date
566: ,p_datetrack_mode => p_datetrack_mode
567: ,p_cost_allocation_id => p_rec.cost_allocation_id
568: ,p_object_version_number => p_rec.object_version_number

Line 646: l_rec pay_cal_shd.g_rec_type;

642: ,p_effective_start_date out nocopy date
643: ,p_effective_end_date out nocopy date
644: ) is
645: --
646: l_rec pay_cal_shd.g_rec_type;
647: l_proc varchar2(72) := g_package||'upd';
648: --
649: Begin
650: hr_utility.set_location('Entering:'||l_proc, 5);

Line 656: pay_cal_shd.convert_args

652: -- Call conversion function to turn arguments into the
653: -- l_rec structure.
654: --
655: l_rec :=
656: pay_cal_shd.convert_args
657: (p_cost_allocation_id
658: ,null
659: ,null
660: ,p_business_group_id