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

Line 54: (p_rec in out nocopy pay_ppr_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_ppr_shd.g_rec_type
55: ,p_effective_date in date
56: ,p_datetrack_mode in varchar2
57: ,p_validation_start_date in date
58: ,p_validation_end_date in date

Line 66: pay_ppr_shd.g_api_dml := true; -- Set the api dml status

62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: pay_ppr_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.
70: --

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

71: delete from pay_status_processing_rules_f
72: where status_processing_rule_id = p_rec.status_processing_rule_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_ppr_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than

Line 77: pay_ppr_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_ppr_shd.g_api_dml := true; -- Set the api dml status
78: --
79: -- Delete the row(s) where the effective start date is greater than
80: -- or equal to the validation start date.
81: --

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

82: delete from pay_status_processing_rules_f
83: where status_processing_rule_id = p_rec.status_processing_rule_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --

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

89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: pay_ppr_shd.g_api_dml := false; -- Unset the api dml status
94: Raise;
95: --
96: End dt_delete_dml;
97: --

Line 142: (p_rec in out nocopy pay_ppr_shd.g_rec_type

138: -- ----------------------------------------------------------------------------
139: -- |------------------------------< delete_dml >------------------------------|
140: -- ----------------------------------------------------------------------------
141: Procedure delete_dml
142: (p_rec in out nocopy pay_ppr_shd.g_rec_type
143: ,p_effective_date in date
144: ,p_datetrack_mode in varchar2
145: ,p_validation_start_date in date
146: ,p_validation_end_date in date

Line 199: (p_rec in out nocopy pay_ppr_shd.g_rec_type

195: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure dt_pre_delete
199: (p_rec in out nocopy pay_ppr_shd.g_rec_type
200: ,p_effective_date in date
201: ,p_datetrack_mode in varchar2
202: ,p_validation_start_date in date
203: ,p_validation_end_date in date

Line 214: := pay_ppr_shd.g_old_rec.effective_start_date;

210: --
211: If (p_datetrack_mode <> hr_api.g_zap) then
212: --
213: p_rec.effective_start_date
214: := pay_ppr_shd.g_old_rec.effective_start_date;
215: --
216: If (p_datetrack_mode = hr_api.g_delete) then
217: p_rec.effective_end_date := p_validation_start_date - 1;
218: Else

Line 224: pay_ppr_shd.upd_effective_end_date

220: End If;
221: --
222: -- Update the current effective end date record
223: --
224: pay_ppr_shd.upd_effective_end_date
225: (p_effective_date => p_effective_date
226: ,p_base_key_value => p_rec.status_processing_rule_id
227: ,p_new_effective_end_date => p_rec.effective_end_date
228: ,p_validation_start_date => p_validation_start_date

Line 273: (p_rec in out nocopy pay_ppr_shd.g_rec_type

269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure pre_delete
273: (p_rec in out nocopy pay_ppr_shd.g_rec_type
274: ,p_effective_date in date
275: ,p_datetrack_mode in varchar2
276: ,p_validation_start_date in date
277: ,p_validation_end_date in date

Line 355: (p_rec in pay_ppr_shd.g_rec_type

351: --
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure post_delete
355: (p_rec in pay_ppr_shd.g_rec_type
356: ,p_effective_date in date
357: ,p_datetrack_mode in varchar2
358: ,p_validation_start_date in date
359: ,p_validation_end_date in date

Line 390: => pay_ppr_shd.g_old_rec.effective_start_date

386: => p_rec.effective_start_date
387: ,p_effective_end_date
388: => p_rec.effective_end_date
389: ,p_effective_start_date_o
390: => pay_ppr_shd.g_old_rec.effective_start_date
391: ,p_effective_end_date_o
392: => pay_ppr_shd.g_old_rec.effective_end_date
393: ,p_business_group_id_o
394: => pay_ppr_shd.g_old_rec.business_group_id

Line 392: => pay_ppr_shd.g_old_rec.effective_end_date

388: => p_rec.effective_end_date
389: ,p_effective_start_date_o
390: => pay_ppr_shd.g_old_rec.effective_start_date
391: ,p_effective_end_date_o
392: => pay_ppr_shd.g_old_rec.effective_end_date
393: ,p_business_group_id_o
394: => pay_ppr_shd.g_old_rec.business_group_id
395: ,p_legislation_code_o
396: => pay_ppr_shd.g_old_rec.legislation_code

Line 394: => pay_ppr_shd.g_old_rec.business_group_id

390: => pay_ppr_shd.g_old_rec.effective_start_date
391: ,p_effective_end_date_o
392: => pay_ppr_shd.g_old_rec.effective_end_date
393: ,p_business_group_id_o
394: => pay_ppr_shd.g_old_rec.business_group_id
395: ,p_legislation_code_o
396: => pay_ppr_shd.g_old_rec.legislation_code
397: ,p_element_type_id_o
398: => pay_ppr_shd.g_old_rec.element_type_id

Line 396: => pay_ppr_shd.g_old_rec.legislation_code

392: => pay_ppr_shd.g_old_rec.effective_end_date
393: ,p_business_group_id_o
394: => pay_ppr_shd.g_old_rec.business_group_id
395: ,p_legislation_code_o
396: => pay_ppr_shd.g_old_rec.legislation_code
397: ,p_element_type_id_o
398: => pay_ppr_shd.g_old_rec.element_type_id
399: ,p_assignment_status_type_id_o
400: => pay_ppr_shd.g_old_rec.assignment_status_type_id

Line 398: => pay_ppr_shd.g_old_rec.element_type_id

394: => pay_ppr_shd.g_old_rec.business_group_id
395: ,p_legislation_code_o
396: => pay_ppr_shd.g_old_rec.legislation_code
397: ,p_element_type_id_o
398: => pay_ppr_shd.g_old_rec.element_type_id
399: ,p_assignment_status_type_id_o
400: => pay_ppr_shd.g_old_rec.assignment_status_type_id
401: ,p_formula_id_o
402: => pay_ppr_shd.g_old_rec.formula_id

Line 400: => pay_ppr_shd.g_old_rec.assignment_status_type_id

396: => pay_ppr_shd.g_old_rec.legislation_code
397: ,p_element_type_id_o
398: => pay_ppr_shd.g_old_rec.element_type_id
399: ,p_assignment_status_type_id_o
400: => pay_ppr_shd.g_old_rec.assignment_status_type_id
401: ,p_formula_id_o
402: => pay_ppr_shd.g_old_rec.formula_id
403: ,p_processing_rule_o
404: => pay_ppr_shd.g_old_rec.processing_rule

Line 402: => pay_ppr_shd.g_old_rec.formula_id

398: => pay_ppr_shd.g_old_rec.element_type_id
399: ,p_assignment_status_type_id_o
400: => pay_ppr_shd.g_old_rec.assignment_status_type_id
401: ,p_formula_id_o
402: => pay_ppr_shd.g_old_rec.formula_id
403: ,p_processing_rule_o
404: => pay_ppr_shd.g_old_rec.processing_rule
405: ,p_comment_id_o
406: => pay_ppr_shd.g_old_rec.comment_id

Line 404: => pay_ppr_shd.g_old_rec.processing_rule

400: => pay_ppr_shd.g_old_rec.assignment_status_type_id
401: ,p_formula_id_o
402: => pay_ppr_shd.g_old_rec.formula_id
403: ,p_processing_rule_o
404: => pay_ppr_shd.g_old_rec.processing_rule
405: ,p_comment_id_o
406: => pay_ppr_shd.g_old_rec.comment_id
407: ,p_comments_o
408: => pay_ppr_shd.g_old_rec.comments

Line 406: => pay_ppr_shd.g_old_rec.comment_id

402: => pay_ppr_shd.g_old_rec.formula_id
403: ,p_processing_rule_o
404: => pay_ppr_shd.g_old_rec.processing_rule
405: ,p_comment_id_o
406: => pay_ppr_shd.g_old_rec.comment_id
407: ,p_comments_o
408: => pay_ppr_shd.g_old_rec.comments
409: ,p_legislation_subgroup_o
410: => pay_ppr_shd.g_old_rec.legislation_subgroup

Line 408: => pay_ppr_shd.g_old_rec.comments

404: => pay_ppr_shd.g_old_rec.processing_rule
405: ,p_comment_id_o
406: => pay_ppr_shd.g_old_rec.comment_id
407: ,p_comments_o
408: => pay_ppr_shd.g_old_rec.comments
409: ,p_legislation_subgroup_o
410: => pay_ppr_shd.g_old_rec.legislation_subgroup
411: ,p_object_version_number_o
412: => pay_ppr_shd.g_old_rec.object_version_number

Line 410: => pay_ppr_shd.g_old_rec.legislation_subgroup

406: => pay_ppr_shd.g_old_rec.comment_id
407: ,p_comments_o
408: => pay_ppr_shd.g_old_rec.comments
409: ,p_legislation_subgroup_o
410: => pay_ppr_shd.g_old_rec.legislation_subgroup
411: ,p_object_version_number_o
412: => pay_ppr_shd.g_old_rec.object_version_number
413: );
414: --

Line 412: => pay_ppr_shd.g_old_rec.object_version_number

408: => pay_ppr_shd.g_old_rec.comments
409: ,p_legislation_subgroup_o
410: => pay_ppr_shd.g_old_rec.legislation_subgroup
411: ,p_object_version_number_o
412: => pay_ppr_shd.g_old_rec.object_version_number
413: );
414: --
415: exception
416: --

Line 434: ,p_rec in out nocopy pay_ppr_shd.g_rec_type

430: -- ----------------------------------------------------------------------------
431: Procedure del
432: (p_effective_date in date
433: ,p_datetrack_mode in varchar2
434: ,p_rec in out nocopy pay_ppr_shd.g_rec_type
435: ) is
436: --
437: l_proc varchar2(72) := g_package||'del';
438: l_validation_start_date date;

Line 450: pay_ppr_shd.lck

446: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
447: --
448: -- We must lock the row which we need to delete.
449: --
450: pay_ppr_shd.lck
451: (p_effective_date => p_effective_date
452: ,p_datetrack_mode => p_datetrack_mode
453: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
454: ,p_object_version_number => p_rec.object_version_number

Line 470: ,p_element_type_id => pay_ppr_shd.g_old_rec.element_type_id

466: l_validation_end_date = hr_api.g_eot) then
467: pay_ppr_bus.set_effective_end_date
468: (p_effective_date => p_effective_date
469: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
470: ,p_element_type_id => pay_ppr_shd.g_old_rec.element_type_id
471: ,p_formula_id => pay_ppr_shd.g_old_rec.formula_id
472: ,p_assignment_status_type_id => pay_ppr_shd.g_old_rec.assignment_status_type_id
473: ,p_processing_rule => pay_ppr_shd.g_old_rec.processing_rule
474: ,p_business_group_id => pay_ppr_shd.g_old_rec.business_group_id

Line 471: ,p_formula_id => pay_ppr_shd.g_old_rec.formula_id

467: pay_ppr_bus.set_effective_end_date
468: (p_effective_date => p_effective_date
469: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
470: ,p_element_type_id => pay_ppr_shd.g_old_rec.element_type_id
471: ,p_formula_id => pay_ppr_shd.g_old_rec.formula_id
472: ,p_assignment_status_type_id => pay_ppr_shd.g_old_rec.assignment_status_type_id
473: ,p_processing_rule => pay_ppr_shd.g_old_rec.processing_rule
474: ,p_business_group_id => pay_ppr_shd.g_old_rec.business_group_id
475: ,p_legislation_code => pay_ppr_shd.g_old_rec.legislation_code

Line 472: ,p_assignment_status_type_id => pay_ppr_shd.g_old_rec.assignment_status_type_id

468: (p_effective_date => p_effective_date
469: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
470: ,p_element_type_id => pay_ppr_shd.g_old_rec.element_type_id
471: ,p_formula_id => pay_ppr_shd.g_old_rec.formula_id
472: ,p_assignment_status_type_id => pay_ppr_shd.g_old_rec.assignment_status_type_id
473: ,p_processing_rule => pay_ppr_shd.g_old_rec.processing_rule
474: ,p_business_group_id => pay_ppr_shd.g_old_rec.business_group_id
475: ,p_legislation_code => pay_ppr_shd.g_old_rec.legislation_code
476: ,p_datetrack_mode => p_datetrack_mode

Line 473: ,p_processing_rule => pay_ppr_shd.g_old_rec.processing_rule

469: ,p_status_processing_rule_id => p_rec.status_processing_rule_id
470: ,p_element_type_id => pay_ppr_shd.g_old_rec.element_type_id
471: ,p_formula_id => pay_ppr_shd.g_old_rec.formula_id
472: ,p_assignment_status_type_id => pay_ppr_shd.g_old_rec.assignment_status_type_id
473: ,p_processing_rule => pay_ppr_shd.g_old_rec.processing_rule
474: ,p_business_group_id => pay_ppr_shd.g_old_rec.business_group_id
475: ,p_legislation_code => pay_ppr_shd.g_old_rec.legislation_code
476: ,p_datetrack_mode => p_datetrack_mode
477: ,p_validation_start_date => l_validation_start_date

Line 474: ,p_business_group_id => pay_ppr_shd.g_old_rec.business_group_id

470: ,p_element_type_id => pay_ppr_shd.g_old_rec.element_type_id
471: ,p_formula_id => pay_ppr_shd.g_old_rec.formula_id
472: ,p_assignment_status_type_id => pay_ppr_shd.g_old_rec.assignment_status_type_id
473: ,p_processing_rule => pay_ppr_shd.g_old_rec.processing_rule
474: ,p_business_group_id => pay_ppr_shd.g_old_rec.business_group_id
475: ,p_legislation_code => pay_ppr_shd.g_old_rec.legislation_code
476: ,p_datetrack_mode => p_datetrack_mode
477: ,p_validation_start_date => l_validation_start_date
478: ,p_validation_end_date => l_validation_end_date

Line 475: ,p_legislation_code => pay_ppr_shd.g_old_rec.legislation_code

471: ,p_formula_id => pay_ppr_shd.g_old_rec.formula_id
472: ,p_assignment_status_type_id => pay_ppr_shd.g_old_rec.assignment_status_type_id
473: ,p_processing_rule => pay_ppr_shd.g_old_rec.processing_rule
474: ,p_business_group_id => pay_ppr_shd.g_old_rec.business_group_id
475: ,p_legislation_code => pay_ppr_shd.g_old_rec.legislation_code
476: ,p_datetrack_mode => p_datetrack_mode
477: ,p_validation_start_date => l_validation_start_date
478: ,p_validation_end_date => l_validation_end_date
479: );

Line 555: l_rec pay_ppr_shd.g_rec_type;

551: ,p_effective_start_date out nocopy date
552: ,p_effective_end_date out nocopy date
553: ) is
554: --
555: l_rec pay_ppr_shd.g_rec_type;
556: l_proc varchar2(72) := g_package||'del';
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);