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_PPR_UPD dependencies on PAY_PPR_SHD

Line 58: (p_rec in out nocopy pay_ppr_shd.g_rec_type

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

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

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

99: where status_processing_rule_id = p_rec.status_processing_rule_id
100: and effective_start_date = p_validation_start_date
101: and effective_end_date = p_validation_end_date;
102: --
103: pay_ppr_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_ppr_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_ppr_shd.g_api_dml := false; -- Unset the api dml status
116: pay_ppr_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_ppr_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
116: pay_ppr_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_ppr_shd.g_api_dml := false; -- Unset the api dml status

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

116: pay_ppr_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_ppr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_ppr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status

Line 121: pay_ppr_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_ppr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_ppr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
125: Raise;

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

120: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
121: pay_ppr_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When Others Then
124: pay_ppr_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_ppr_shd.g_rec_type

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

223: --
224: -- {End Of Comments}
225: -- ----------------------------------------------------------------------------
226: Procedure dt_pre_update
227: (p_rec in out nocopy pay_ppr_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_ppr_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_ppr_shd.upd_effective_end_date
244: (p_effective_date => p_effective_date
245: ,p_base_key_value => p_rec.status_processing_rule_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_ppr_shd.g_rec_type

308: --
309: -- {End Of Comments}
310: -- ----------------------------------------------------------------------------
311: Procedure pre_update
312: (p_rec in out nocopy pay_ppr_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 334: pay_ppr_shd.g_old_rec.comments) then

330: ,p_comment_text => p_rec.comments
331: );
332: -- Update the comments if they have changed
333: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
334: pay_ppr_shd.g_old_rec.comments) then
335: hr_comm_api.upd(p_comment_id => p_rec.comment_id
336: ,p_source_table_name => 'PAY_STATUS_PROCESSING_RULES_F'
337: ,p_comment_text => p_rec.comments
338: );

Line 385: (p_rec in pay_ppr_shd.g_rec_type

381: --
382: -- {End Of Comments}
383: -- ----------------------------------------------------------------------------
384: Procedure post_update
385: (p_rec in pay_ppr_shd.g_rec_type
386: ,p_effective_date in date
387: ,p_datetrack_mode in varchar2
388: ,p_validation_start_date in date
389: ,p_validation_end_date in date

Line 417: ,p_effective_start_date_o => pay_ppr_shd.g_old_rec.effective_start_date

413: ,p_comments => p_rec.comments
414: ,p_legislation_subgroup => p_rec.legislation_subgroup
415: ,p_object_version_number => p_rec.object_version_number
416: ,p_formula_mismatch_warning => p_formula_mismatch_warning
417: ,p_effective_start_date_o => pay_ppr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o => pay_ppr_shd.g_old_rec.effective_end_date
419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id
420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id

Line 418: ,p_effective_end_date_o => pay_ppr_shd.g_old_rec.effective_end_date

414: ,p_legislation_subgroup => p_rec.legislation_subgroup
415: ,p_object_version_number => p_rec.object_version_number
416: ,p_formula_mismatch_warning => p_formula_mismatch_warning
417: ,p_effective_start_date_o => pay_ppr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o => pay_ppr_shd.g_old_rec.effective_end_date
419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id
420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id

Line 419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id

415: ,p_object_version_number => p_rec.object_version_number
416: ,p_formula_mismatch_warning => p_formula_mismatch_warning
417: ,p_effective_start_date_o => pay_ppr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o => pay_ppr_shd.g_old_rec.effective_end_date
419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id
420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id

Line 420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code

416: ,p_formula_mismatch_warning => p_formula_mismatch_warning
417: ,p_effective_start_date_o => pay_ppr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o => pay_ppr_shd.g_old_rec.effective_end_date
419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id
420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule

Line 421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id

417: ,p_effective_start_date_o => pay_ppr_shd.g_old_rec.effective_start_date
418: ,p_effective_end_date_o => pay_ppr_shd.g_old_rec.effective_end_date
419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id
420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id

Line 422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id

418: ,p_effective_end_date_o => pay_ppr_shd.g_old_rec.effective_end_date
419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id
420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id
426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments

Line 423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id

419: ,p_business_group_id_o => pay_ppr_shd.g_old_rec.business_group_id
420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id
426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments
427: ,p_legislation_subgroup_o => pay_ppr_shd.g_old_rec.legislation_subgroup

Line 424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule

420: ,p_legislation_code_o => pay_ppr_shd.g_old_rec.legislation_code
421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id
426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments
427: ,p_legislation_subgroup_o => pay_ppr_shd.g_old_rec.legislation_subgroup
428: ,p_object_version_number_o => pay_ppr_shd.g_old_rec.object_version_number

Line 425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id

421: ,p_element_type_id_o => pay_ppr_shd.g_old_rec.element_type_id
422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id
426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments
427: ,p_legislation_subgroup_o => pay_ppr_shd.g_old_rec.legislation_subgroup
428: ,p_object_version_number_o => pay_ppr_shd.g_old_rec.object_version_number
429: );

Line 426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments

422: ,p_assignment_status_type_id_o => pay_ppr_shd.g_old_rec.assignment_status_type_id
423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id
426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments
427: ,p_legislation_subgroup_o => pay_ppr_shd.g_old_rec.legislation_subgroup
428: ,p_object_version_number_o => pay_ppr_shd.g_old_rec.object_version_number
429: );
430: --

Line 427: ,p_legislation_subgroup_o => pay_ppr_shd.g_old_rec.legislation_subgroup

423: ,p_formula_id_o => pay_ppr_shd.g_old_rec.formula_id
424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id
426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments
427: ,p_legislation_subgroup_o => pay_ppr_shd.g_old_rec.legislation_subgroup
428: ,p_object_version_number_o => pay_ppr_shd.g_old_rec.object_version_number
429: );
430: --
431: exception

Line 428: ,p_object_version_number_o => pay_ppr_shd.g_old_rec.object_version_number

424: ,p_processing_rule_o => pay_ppr_shd.g_old_rec.processing_rule
425: ,p_comment_id_o => pay_ppr_shd.g_old_rec.comment_id
426: ,p_comments_o => pay_ppr_shd.g_old_rec.comments
427: ,p_legislation_subgroup_o => pay_ppr_shd.g_old_rec.legislation_subgroup
428: ,p_object_version_number_o => pay_ppr_shd.g_old_rec.object_version_number
429: );
430: --
431: exception
432: --

Line 488: (p_rec in out nocopy pay_ppr_shd.g_rec_type

484: --
485: -- {End Of Comments}
486: -- ----------------------------------------------------------------------------
487: Procedure convert_defs
488: (p_rec in out nocopy pay_ppr_shd.g_rec_type
489: ) is
490: --
491: Begin
492: --

Line 500: pay_ppr_shd.g_old_rec.business_group_id;

496: -- is being used then we must set to the 'current' argument value.
497: --
498: If (p_rec.business_group_id = hr_api.g_number) then
499: p_rec.business_group_id :=
500: pay_ppr_shd.g_old_rec.business_group_id;
501: End If;
502: If (p_rec.legislation_code = hr_api.g_varchar2) then
503: p_rec.legislation_code :=
504: pay_ppr_shd.g_old_rec.legislation_code;

Line 504: pay_ppr_shd.g_old_rec.legislation_code;

500: pay_ppr_shd.g_old_rec.business_group_id;
501: End If;
502: If (p_rec.legislation_code = hr_api.g_varchar2) then
503: p_rec.legislation_code :=
504: pay_ppr_shd.g_old_rec.legislation_code;
505: End If;
506: If (p_rec.element_type_id = hr_api.g_number) then
507: p_rec.element_type_id :=
508: pay_ppr_shd.g_old_rec.element_type_id;

Line 508: pay_ppr_shd.g_old_rec.element_type_id;

504: pay_ppr_shd.g_old_rec.legislation_code;
505: End If;
506: If (p_rec.element_type_id = hr_api.g_number) then
507: p_rec.element_type_id :=
508: pay_ppr_shd.g_old_rec.element_type_id;
509: End If;
510: If (p_rec.assignment_status_type_id = hr_api.g_number) then
511: p_rec.assignment_status_type_id :=
512: pay_ppr_shd.g_old_rec.assignment_status_type_id;

Line 512: pay_ppr_shd.g_old_rec.assignment_status_type_id;

508: pay_ppr_shd.g_old_rec.element_type_id;
509: End If;
510: If (p_rec.assignment_status_type_id = hr_api.g_number) then
511: p_rec.assignment_status_type_id :=
512: pay_ppr_shd.g_old_rec.assignment_status_type_id;
513: End If;
514: If (p_rec.formula_id = hr_api.g_number) then
515: p_rec.formula_id :=
516: pay_ppr_shd.g_old_rec.formula_id;

Line 516: pay_ppr_shd.g_old_rec.formula_id;

512: pay_ppr_shd.g_old_rec.assignment_status_type_id;
513: End If;
514: If (p_rec.formula_id = hr_api.g_number) then
515: p_rec.formula_id :=
516: pay_ppr_shd.g_old_rec.formula_id;
517: End If;
518: If (p_rec.processing_rule = hr_api.g_varchar2) then
519: p_rec.processing_rule :=
520: pay_ppr_shd.g_old_rec.processing_rule;

Line 520: pay_ppr_shd.g_old_rec.processing_rule;

516: pay_ppr_shd.g_old_rec.formula_id;
517: End If;
518: If (p_rec.processing_rule = hr_api.g_varchar2) then
519: p_rec.processing_rule :=
520: pay_ppr_shd.g_old_rec.processing_rule;
521: End If;
522: If (p_rec.comment_id = hr_api.g_number) then
523: p_rec.comment_id :=
524: pay_ppr_shd.g_old_rec.comment_id;

Line 524: pay_ppr_shd.g_old_rec.comment_id;

520: pay_ppr_shd.g_old_rec.processing_rule;
521: End If;
522: If (p_rec.comment_id = hr_api.g_number) then
523: p_rec.comment_id :=
524: pay_ppr_shd.g_old_rec.comment_id;
525: End If;
526: If (p_rec.comments = hr_api.g_varchar2) then
527: p_rec.comments :=
528: pay_ppr_shd.g_old_rec.comments;

Line 528: pay_ppr_shd.g_old_rec.comments;

524: pay_ppr_shd.g_old_rec.comment_id;
525: End If;
526: If (p_rec.comments = hr_api.g_varchar2) then
527: p_rec.comments :=
528: pay_ppr_shd.g_old_rec.comments;
529: End If;
530: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
531: p_rec.legislation_subgroup :=
532: pay_ppr_shd.g_old_rec.legislation_subgroup;

Line 532: pay_ppr_shd.g_old_rec.legislation_subgroup;

528: pay_ppr_shd.g_old_rec.comments;
529: End If;
530: If (p_rec.legislation_subgroup = hr_api.g_varchar2) then
531: p_rec.legislation_subgroup :=
532: pay_ppr_shd.g_old_rec.legislation_subgroup;
533: End If;
534: --
535: End convert_defs;
536: --

Line 543: ,p_rec in out nocopy pay_ppr_shd.g_rec_type

539: -- ----------------------------------------------------------------------------
540: Procedure upd
541: (p_effective_date in date
542: ,p_datetrack_mode in varchar2
543: ,p_rec in out nocopy pay_ppr_shd.g_rec_type
544: ,p_formula_mismatch_warning out nocopy boolean
545: ) is
546: --
547: l_proc varchar2(72) := g_package||'upd';

Line 562: pay_ppr_shd.lck

558: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
559: --
560: -- We must lock the row which we need to update.
561: --
562: pay_ppr_shd.lck
563: (p_effective_date => p_effective_date
564: ,p_datetrack_mode => p_datetrack_mode
565: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
566: ,p_object_version_number => p_rec.object_version_number

Line 646: l_rec pay_ppr_shd.g_rec_type;

642: ,p_effective_end_date out nocopy date
643: ,p_formula_mismatch_warning out nocopy boolean
644: ) is
645: --
646: l_rec pay_ppr_shd.g_rec_type;
647: l_proc varchar2(72) := g_package||'upd';
648: l_formula_mismatch_warning boolean;
649: --
650: Begin

Line 657: pay_ppr_shd.convert_args

653: -- Call conversion function to turn arguments into the
654: -- l_rec structure.
655: --
656: l_rec :=
657: pay_ppr_shd.convert_args
658: (p_status_processing_rule_id
659: ,null
660: ,null
661: ,hr_api.g_number