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_FRR_DEL dependencies on PAY_FRR_SHD

Line 54: (p_rec in out nocopy pay_frr_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy pay_frr_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_frr_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_frr_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_frr_shd.g_api_dml := false; -- Unset the api dml status

71: delete from pay_formula_result_rules_f
72: where formula_result_rule_id = p_rec.formula_result_rule_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_frr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_frr_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_frr_shd.g_api_dml := true; -- Set the api dml status

73: and effective_start_date = p_validation_start_date;
74: --
75: pay_frr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_frr_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_frr_shd.g_api_dml := false; -- Unset the api dml status

82: delete from pay_formula_result_rules_f
83: where formula_result_rule_id = p_rec.formula_result_rule_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_frr_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_frr_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_frr_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_frr_shd.g_rec_type

138: -- ----------------------------------------------------------------------------
139: -- |------------------------------< delete_dml >------------------------------|
140: -- ----------------------------------------------------------------------------
141: Procedure delete_dml
142: (p_rec in out nocopy pay_frr_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_frr_shd.g_rec_type

195: --
196: -- {End Of Comments}
197: -- ----------------------------------------------------------------------------
198: Procedure dt_pre_delete
199: (p_rec in out nocopy pay_frr_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_frr_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_frr_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_frr_shd.upd_effective_end_date

220: End If;
221: --
222: -- Update the current effective end date record
223: --
224: pay_frr_shd.upd_effective_end_date
225: (p_effective_date => p_effective_date
226: ,p_base_key_value => p_rec.formula_result_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_frr_shd.g_rec_type

269: --
270: -- {End Of Comments}
271: -- ----------------------------------------------------------------------------
272: Procedure pre_delete
273: (p_rec in out nocopy pay_frr_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 333: (p_rec in pay_frr_shd.g_rec_type

329: --
330: -- {End Of Comments}
331: -- ----------------------------------------------------------------------------
332: Procedure post_delete
333: (p_rec in pay_frr_shd.g_rec_type
334: ,p_effective_date in date
335: ,p_datetrack_mode in varchar2
336: ,p_validation_start_date in date
337: ,p_validation_end_date in date

Line 368: => pay_frr_shd.g_old_rec.effective_start_date

364: => p_rec.effective_start_date
365: ,p_effective_end_date
366: => p_rec.effective_end_date
367: ,p_effective_start_date_o
368: => pay_frr_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => pay_frr_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => pay_frr_shd.g_old_rec.business_group_id

Line 370: => pay_frr_shd.g_old_rec.effective_end_date

366: => p_rec.effective_end_date
367: ,p_effective_start_date_o
368: => pay_frr_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => pay_frr_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => pay_frr_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_frr_shd.g_old_rec.legislation_code

Line 372: => pay_frr_shd.g_old_rec.business_group_id

368: => pay_frr_shd.g_old_rec.effective_start_date
369: ,p_effective_end_date_o
370: => pay_frr_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => pay_frr_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_frr_shd.g_old_rec.legislation_code
375: ,p_element_type_id_o
376: => pay_frr_shd.g_old_rec.element_type_id

Line 374: => pay_frr_shd.g_old_rec.legislation_code

370: => pay_frr_shd.g_old_rec.effective_end_date
371: ,p_business_group_id_o
372: => pay_frr_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_frr_shd.g_old_rec.legislation_code
375: ,p_element_type_id_o
376: => pay_frr_shd.g_old_rec.element_type_id
377: ,p_status_processing_rule_id_o
378: => pay_frr_shd.g_old_rec.status_processing_rule_id

Line 376: => pay_frr_shd.g_old_rec.element_type_id

372: => pay_frr_shd.g_old_rec.business_group_id
373: ,p_legislation_code_o
374: => pay_frr_shd.g_old_rec.legislation_code
375: ,p_element_type_id_o
376: => pay_frr_shd.g_old_rec.element_type_id
377: ,p_status_processing_rule_id_o
378: => pay_frr_shd.g_old_rec.status_processing_rule_id
379: ,p_result_name_o
380: => pay_frr_shd.g_old_rec.result_name

Line 378: => pay_frr_shd.g_old_rec.status_processing_rule_id

374: => pay_frr_shd.g_old_rec.legislation_code
375: ,p_element_type_id_o
376: => pay_frr_shd.g_old_rec.element_type_id
377: ,p_status_processing_rule_id_o
378: => pay_frr_shd.g_old_rec.status_processing_rule_id
379: ,p_result_name_o
380: => pay_frr_shd.g_old_rec.result_name
381: ,p_result_rule_type_o
382: => pay_frr_shd.g_old_rec.result_rule_type

Line 380: => pay_frr_shd.g_old_rec.result_name

376: => pay_frr_shd.g_old_rec.element_type_id
377: ,p_status_processing_rule_id_o
378: => pay_frr_shd.g_old_rec.status_processing_rule_id
379: ,p_result_name_o
380: => pay_frr_shd.g_old_rec.result_name
381: ,p_result_rule_type_o
382: => pay_frr_shd.g_old_rec.result_rule_type
383: ,p_legislation_subgroup_o
384: => pay_frr_shd.g_old_rec.legislation_subgroup

Line 382: => pay_frr_shd.g_old_rec.result_rule_type

378: => pay_frr_shd.g_old_rec.status_processing_rule_id
379: ,p_result_name_o
380: => pay_frr_shd.g_old_rec.result_name
381: ,p_result_rule_type_o
382: => pay_frr_shd.g_old_rec.result_rule_type
383: ,p_legislation_subgroup_o
384: => pay_frr_shd.g_old_rec.legislation_subgroup
385: ,p_severity_level_o
386: => pay_frr_shd.g_old_rec.severity_level

Line 384: => pay_frr_shd.g_old_rec.legislation_subgroup

380: => pay_frr_shd.g_old_rec.result_name
381: ,p_result_rule_type_o
382: => pay_frr_shd.g_old_rec.result_rule_type
383: ,p_legislation_subgroup_o
384: => pay_frr_shd.g_old_rec.legislation_subgroup
385: ,p_severity_level_o
386: => pay_frr_shd.g_old_rec.severity_level
387: ,p_input_value_id_o
388: => pay_frr_shd.g_old_rec.input_value_id

Line 386: => pay_frr_shd.g_old_rec.severity_level

382: => pay_frr_shd.g_old_rec.result_rule_type
383: ,p_legislation_subgroup_o
384: => pay_frr_shd.g_old_rec.legislation_subgroup
385: ,p_severity_level_o
386: => pay_frr_shd.g_old_rec.severity_level
387: ,p_input_value_id_o
388: => pay_frr_shd.g_old_rec.input_value_id
389: ,p_object_version_number_o
390: => pay_frr_shd.g_old_rec.object_version_number

Line 388: => pay_frr_shd.g_old_rec.input_value_id

384: => pay_frr_shd.g_old_rec.legislation_subgroup
385: ,p_severity_level_o
386: => pay_frr_shd.g_old_rec.severity_level
387: ,p_input_value_id_o
388: => pay_frr_shd.g_old_rec.input_value_id
389: ,p_object_version_number_o
390: => pay_frr_shd.g_old_rec.object_version_number
391: );
392: --

Line 390: => pay_frr_shd.g_old_rec.object_version_number

386: => pay_frr_shd.g_old_rec.severity_level
387: ,p_input_value_id_o
388: => pay_frr_shd.g_old_rec.input_value_id
389: ,p_object_version_number_o
390: => pay_frr_shd.g_old_rec.object_version_number
391: );
392: --
393: exception
394: --

Line 412: ,p_rec in out nocopy pay_frr_shd.g_rec_type

408: -- ----------------------------------------------------------------------------
409: Procedure del
410: (p_effective_date in date
411: ,p_datetrack_mode in varchar2
412: ,p_rec in out nocopy pay_frr_shd.g_rec_type
413: ) is
414: --
415: l_proc varchar2(72) := g_package||'del';
416: l_validation_start_date date;

Line 428: pay_frr_shd.lck

424: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
425: --
426: -- We must lock the row which we need to delete.
427: --
428: pay_frr_shd.lck
429: (p_effective_date => p_effective_date
430: ,p_datetrack_mode => p_datetrack_mode
431: ,p_formula_result_rule_id => p_rec.formula_result_rule_id
432: ,p_object_version_number => p_rec.object_version_number

Line 443: ,p_result_rule_type => pay_frr_shd.g_old_rec.result_rule_type

439: --
440: If p_datetrack_mode = hr_api.g_delete_next_change then
441: pay_frr_bus.set_effective_end_date
442: (p_effective_date => p_effective_date
443: ,p_result_rule_type => pay_frr_shd.g_old_rec.result_rule_type
444: ,p_result_name => pay_frr_shd.g_old_rec.result_name
445: ,p_status_processing_rule_id =>
446: pay_frr_shd.g_old_rec.status_processing_rule_id
447: ,p_element_type_id => pay_frr_shd.g_old_rec.element_type_id

Line 444: ,p_result_name => pay_frr_shd.g_old_rec.result_name

440: If p_datetrack_mode = hr_api.g_delete_next_change then
441: pay_frr_bus.set_effective_end_date
442: (p_effective_date => p_effective_date
443: ,p_result_rule_type => pay_frr_shd.g_old_rec.result_rule_type
444: ,p_result_name => pay_frr_shd.g_old_rec.result_name
445: ,p_status_processing_rule_id =>
446: pay_frr_shd.g_old_rec.status_processing_rule_id
447: ,p_element_type_id => pay_frr_shd.g_old_rec.element_type_id
448: ,p_input_value_id => pay_frr_shd.g_old_rec.input_value_id

Line 446: pay_frr_shd.g_old_rec.status_processing_rule_id

442: (p_effective_date => p_effective_date
443: ,p_result_rule_type => pay_frr_shd.g_old_rec.result_rule_type
444: ,p_result_name => pay_frr_shd.g_old_rec.result_name
445: ,p_status_processing_rule_id =>
446: pay_frr_shd.g_old_rec.status_processing_rule_id
447: ,p_element_type_id => pay_frr_shd.g_old_rec.element_type_id
448: ,p_input_value_id => pay_frr_shd.g_old_rec.input_value_id
449: ,p_datetrack_mode => p_datetrack_mode
450: ,p_formula_result_rule_id => p_rec.formula_result_rule_id

Line 447: ,p_element_type_id => pay_frr_shd.g_old_rec.element_type_id

443: ,p_result_rule_type => pay_frr_shd.g_old_rec.result_rule_type
444: ,p_result_name => pay_frr_shd.g_old_rec.result_name
445: ,p_status_processing_rule_id =>
446: pay_frr_shd.g_old_rec.status_processing_rule_id
447: ,p_element_type_id => pay_frr_shd.g_old_rec.element_type_id
448: ,p_input_value_id => pay_frr_shd.g_old_rec.input_value_id
449: ,p_datetrack_mode => p_datetrack_mode
450: ,p_formula_result_rule_id => p_rec.formula_result_rule_id
451: ,p_validation_end_date => l_validation_end_date

Line 448: ,p_input_value_id => pay_frr_shd.g_old_rec.input_value_id

444: ,p_result_name => pay_frr_shd.g_old_rec.result_name
445: ,p_status_processing_rule_id =>
446: pay_frr_shd.g_old_rec.status_processing_rule_id
447: ,p_element_type_id => pay_frr_shd.g_old_rec.element_type_id
448: ,p_input_value_id => pay_frr_shd.g_old_rec.input_value_id
449: ,p_datetrack_mode => p_datetrack_mode
450: ,p_formula_result_rule_id => p_rec.formula_result_rule_id
451: ,p_validation_end_date => l_validation_end_date
452: );

Line 515: l_rec pay_frr_shd.g_rec_type;

511: ,p_effective_start_date out nocopy date
512: ,p_effective_end_date out nocopy date
513: ) is
514: --
515: l_rec pay_frr_shd.g_rec_type;
516: l_proc varchar2(72) := g_package||'del';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);