DBA Data[Home] [Help]

APPS.PAY_ITR_UPD dependencies on PAY_ITR_SHD

Line 58: (p_rec in out nocopy pay_itr_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_itr_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_itr_shd.constraint_error

111: Exception
112: When hr_api.check_integrity_violated Then
113: -- A check constraint has been violated
114: --
115: pay_itr_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_itr_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_itr_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_itr_shd.g_rec_type

155: --
156: -- {End Of Comments}
157: -- ----------------------------------------------------------------------------
158: Procedure update_dml
159: (p_rec in out nocopy pay_itr_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_itr_shd.g_rec_type

222: --
223: -- {End Of Comments}
224: -- ----------------------------------------------------------------------------
225: Procedure dt_pre_update
226: (p_rec in out nocopy pay_itr_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_itr_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_itr_shd.upd_effective_end_date
243: (p_effective_date => p_effective_date
244: ,p_base_key_value => p_rec.iterative_rule_id
245: ,p_new_effective_end_date => (p_validation_start_date - 1)
246: ,p_validation_start_date => p_validation_start_date

Line 312: (p_rec in out nocopy pay_itr_shd.g_rec_type

308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure pre_update
312: (p_rec in out nocopy pay_itr_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_itr_shd.g_rec_type

366: --
367: -- {End Of Comments}
368: -- ----------------------------------------------------------------------------
369: Procedure post_update
370: (p_rec in pay_itr_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 415: => pay_itr_shd.g_old_rec.element_type_id

411: => p_rec.legislation_code
412: ,p_object_version_number
413: => p_rec.object_version_number
414: ,p_element_type_id_o
415: => pay_itr_shd.g_old_rec.element_type_id
416: ,p_effective_start_date_o
417: => pay_itr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o
419: => pay_itr_shd.g_old_rec.effective_end_date

Line 417: => pay_itr_shd.g_old_rec.effective_start_date

413: => p_rec.object_version_number
414: ,p_element_type_id_o
415: => pay_itr_shd.g_old_rec.element_type_id
416: ,p_effective_start_date_o
417: => pay_itr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o
419: => pay_itr_shd.g_old_rec.effective_end_date
420: ,p_result_name_o
421: => pay_itr_shd.g_old_rec.result_name

Line 419: => pay_itr_shd.g_old_rec.effective_end_date

415: => pay_itr_shd.g_old_rec.element_type_id
416: ,p_effective_start_date_o
417: => pay_itr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o
419: => pay_itr_shd.g_old_rec.effective_end_date
420: ,p_result_name_o
421: => pay_itr_shd.g_old_rec.result_name
422: ,p_iterative_rule_type_o
423: => pay_itr_shd.g_old_rec.iterative_rule_type

Line 421: => pay_itr_shd.g_old_rec.result_name

417: => pay_itr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o
419: => pay_itr_shd.g_old_rec.effective_end_date
420: ,p_result_name_o
421: => pay_itr_shd.g_old_rec.result_name
422: ,p_iterative_rule_type_o
423: => pay_itr_shd.g_old_rec.iterative_rule_type
424: ,p_input_value_id_o
425: => pay_itr_shd.g_old_rec.input_value_id

Line 423: => pay_itr_shd.g_old_rec.iterative_rule_type

419: => pay_itr_shd.g_old_rec.effective_end_date
420: ,p_result_name_o
421: => pay_itr_shd.g_old_rec.result_name
422: ,p_iterative_rule_type_o
423: => pay_itr_shd.g_old_rec.iterative_rule_type
424: ,p_input_value_id_o
425: => pay_itr_shd.g_old_rec.input_value_id
426: ,p_severity_level_o
427: => pay_itr_shd.g_old_rec.severity_level

Line 425: => pay_itr_shd.g_old_rec.input_value_id

421: => pay_itr_shd.g_old_rec.result_name
422: ,p_iterative_rule_type_o
423: => pay_itr_shd.g_old_rec.iterative_rule_type
424: ,p_input_value_id_o
425: => pay_itr_shd.g_old_rec.input_value_id
426: ,p_severity_level_o
427: => pay_itr_shd.g_old_rec.severity_level
428: ,p_business_group_id_o
429: => pay_itr_shd.g_old_rec.business_group_id

Line 427: => pay_itr_shd.g_old_rec.severity_level

423: => pay_itr_shd.g_old_rec.iterative_rule_type
424: ,p_input_value_id_o
425: => pay_itr_shd.g_old_rec.input_value_id
426: ,p_severity_level_o
427: => pay_itr_shd.g_old_rec.severity_level
428: ,p_business_group_id_o
429: => pay_itr_shd.g_old_rec.business_group_id
430: ,p_legislation_code_o
431: => pay_itr_shd.g_old_rec.legislation_code

Line 429: => pay_itr_shd.g_old_rec.business_group_id

425: => pay_itr_shd.g_old_rec.input_value_id
426: ,p_severity_level_o
427: => pay_itr_shd.g_old_rec.severity_level
428: ,p_business_group_id_o
429: => pay_itr_shd.g_old_rec.business_group_id
430: ,p_legislation_code_o
431: => pay_itr_shd.g_old_rec.legislation_code
432: ,p_object_version_number_o
433: => pay_itr_shd.g_old_rec.object_version_number

Line 431: => pay_itr_shd.g_old_rec.legislation_code

427: => pay_itr_shd.g_old_rec.severity_level
428: ,p_business_group_id_o
429: => pay_itr_shd.g_old_rec.business_group_id
430: ,p_legislation_code_o
431: => pay_itr_shd.g_old_rec.legislation_code
432: ,p_object_version_number_o
433: => pay_itr_shd.g_old_rec.object_version_number
434: );
435: --

Line 433: => pay_itr_shd.g_old_rec.object_version_number

429: => pay_itr_shd.g_old_rec.business_group_id
430: ,p_legislation_code_o
431: => pay_itr_shd.g_old_rec.legislation_code
432: ,p_object_version_number_o
433: => pay_itr_shd.g_old_rec.object_version_number
434: );
435: --
436: exception
437: --

Line 493: (p_rec in out nocopy pay_itr_shd.g_rec_type

489: --
490: -- {End Of Comments}
491: -- ----------------------------------------------------------------------------
492: Procedure convert_defs
493: (p_rec in out nocopy pay_itr_shd.g_rec_type
494: ) is
495: --
496: Begin
497: --

Line 505: pay_itr_shd.g_old_rec.element_type_id;

501: -- is being used then we must set to the 'current' argument value.
502: --
503: If (p_rec.element_type_id = hr_api.g_number) then
504: p_rec.element_type_id :=
505: pay_itr_shd.g_old_rec.element_type_id;
506: End If;
507: If (p_rec.result_name = hr_api.g_varchar2) then
508: p_rec.result_name :=
509: pay_itr_shd.g_old_rec.result_name;

Line 509: pay_itr_shd.g_old_rec.result_name;

505: pay_itr_shd.g_old_rec.element_type_id;
506: End If;
507: If (p_rec.result_name = hr_api.g_varchar2) then
508: p_rec.result_name :=
509: pay_itr_shd.g_old_rec.result_name;
510: End If;
511: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
512: p_rec.iterative_rule_type :=
513: pay_itr_shd.g_old_rec.iterative_rule_type;

Line 513: pay_itr_shd.g_old_rec.iterative_rule_type;

509: pay_itr_shd.g_old_rec.result_name;
510: End If;
511: If (p_rec.iterative_rule_type = hr_api.g_varchar2) then
512: p_rec.iterative_rule_type :=
513: pay_itr_shd.g_old_rec.iterative_rule_type;
514: End If;
515: If (p_rec.input_value_id = hr_api.g_number) then
516: p_rec.input_value_id :=
517: pay_itr_shd.g_old_rec.input_value_id;

Line 517: pay_itr_shd.g_old_rec.input_value_id;

513: pay_itr_shd.g_old_rec.iterative_rule_type;
514: End If;
515: If (p_rec.input_value_id = hr_api.g_number) then
516: p_rec.input_value_id :=
517: pay_itr_shd.g_old_rec.input_value_id;
518: End If;
519: If (p_rec.severity_level = hr_api.g_varchar2) then
520: p_rec.severity_level :=
521: pay_itr_shd.g_old_rec.severity_level;

Line 521: pay_itr_shd.g_old_rec.severity_level;

517: pay_itr_shd.g_old_rec.input_value_id;
518: End If;
519: If (p_rec.severity_level = hr_api.g_varchar2) then
520: p_rec.severity_level :=
521: pay_itr_shd.g_old_rec.severity_level;
522: End If;
523: If (p_rec.business_group_id = hr_api.g_number) then
524: p_rec.business_group_id :=
525: pay_itr_shd.g_old_rec.business_group_id;

Line 525: pay_itr_shd.g_old_rec.business_group_id;

521: pay_itr_shd.g_old_rec.severity_level;
522: End If;
523: If (p_rec.business_group_id = hr_api.g_number) then
524: p_rec.business_group_id :=
525: pay_itr_shd.g_old_rec.business_group_id;
526: End If;
527: If (p_rec.legislation_code = hr_api.g_varchar2) then
528: p_rec.legislation_code :=
529: pay_itr_shd.g_old_rec.legislation_code;

Line 529: pay_itr_shd.g_old_rec.legislation_code;

525: pay_itr_shd.g_old_rec.business_group_id;
526: End If;
527: If (p_rec.legislation_code = hr_api.g_varchar2) then
528: p_rec.legislation_code :=
529: pay_itr_shd.g_old_rec.legislation_code;
530: End If;
531: --
532: End convert_defs;
533: --

Line 540: ,p_rec in out nocopy pay_itr_shd.g_rec_type

536: -- ----------------------------------------------------------------------------
537: Procedure upd
538: (p_effective_date in date
539: ,p_datetrack_mode in varchar2
540: ,p_rec in out nocopy pay_itr_shd.g_rec_type
541: ) is
542: --
543: l_proc varchar2(72) := g_package||'upd';
544: l_validation_start_date date;

Line 556: pay_itr_shd.lck

552: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
553: --
554: -- We must lock the row which we need to update.
555: --
556: pay_itr_shd.lck
557: (p_effective_date => p_effective_date
558: ,p_datetrack_mode => p_datetrack_mode
559: ,p_iterative_rule_id => p_rec.iterative_rule_id
560: ,p_object_version_number => p_rec.object_version_number

Line 631: l_rec pay_itr_shd.g_rec_type;

627: ,p_effective_start_date out nocopy date
628: ,p_effective_end_date out nocopy date
629: ) is
630: --
631: l_rec pay_itr_shd.g_rec_type;
632: l_proc varchar2(72) := g_package||'upd';
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);

Line 641: pay_itr_shd.convert_args

637: -- Call conversion function to turn arguments into the
638: -- l_rec structure.
639: --
640: l_rec :=
641: pay_itr_shd.convert_args
642: (p_iterative_rule_id
643: ,p_element_type_id
644: ,null
645: ,null