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_PUR_DEL dependencies on PAY_PUR_SHD

Line 54: (p_rec in out nocopy pay_pur_shd.g_rec_type

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

71: delete from pay_user_rows_f
72: where user_row_id = p_rec.user_row_id
73: and effective_start_date = p_validation_start_date;
74: --
75: pay_pur_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: pay_pur_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_pur_shd.g_api_dml := true; -- Set the api dml status

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

82: delete from pay_user_rows_f
83: where user_row_id = p_rec.user_row_id
84: and effective_start_date >= p_validation_start_date;
85: --
86: pay_pur_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_pur_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_pur_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_pur_shd.g_rec_type

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

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

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

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

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

Line 371: => pay_pur_shd.g_old_rec.effective_start_date

367: => p_rec.effective_end_date
368: ,p_disable_range_overlap_check
369: => p_disable_range_overlap_check
370: ,p_effective_start_date_o
371: => pay_pur_shd.g_old_rec.effective_start_date
372: ,p_effective_end_date_o
373: => pay_pur_shd.g_old_rec.effective_end_date
374: ,p_business_group_id_o
375: => pay_pur_shd.g_old_rec.business_group_id

Line 373: => pay_pur_shd.g_old_rec.effective_end_date

369: => p_disable_range_overlap_check
370: ,p_effective_start_date_o
371: => pay_pur_shd.g_old_rec.effective_start_date
372: ,p_effective_end_date_o
373: => pay_pur_shd.g_old_rec.effective_end_date
374: ,p_business_group_id_o
375: => pay_pur_shd.g_old_rec.business_group_id
376: ,p_legislation_code_o
377: => pay_pur_shd.g_old_rec.legislation_code

Line 375: => pay_pur_shd.g_old_rec.business_group_id

371: => pay_pur_shd.g_old_rec.effective_start_date
372: ,p_effective_end_date_o
373: => pay_pur_shd.g_old_rec.effective_end_date
374: ,p_business_group_id_o
375: => pay_pur_shd.g_old_rec.business_group_id
376: ,p_legislation_code_o
377: => pay_pur_shd.g_old_rec.legislation_code
378: ,p_user_table_id_o
379: => pay_pur_shd.g_old_rec.user_table_id

Line 377: => pay_pur_shd.g_old_rec.legislation_code

373: => pay_pur_shd.g_old_rec.effective_end_date
374: ,p_business_group_id_o
375: => pay_pur_shd.g_old_rec.business_group_id
376: ,p_legislation_code_o
377: => pay_pur_shd.g_old_rec.legislation_code
378: ,p_user_table_id_o
379: => pay_pur_shd.g_old_rec.user_table_id
380: ,p_row_low_range_or_name_o
381: => pay_pur_shd.g_old_rec.row_low_range_or_name

Line 379: => pay_pur_shd.g_old_rec.user_table_id

375: => pay_pur_shd.g_old_rec.business_group_id
376: ,p_legislation_code_o
377: => pay_pur_shd.g_old_rec.legislation_code
378: ,p_user_table_id_o
379: => pay_pur_shd.g_old_rec.user_table_id
380: ,p_row_low_range_or_name_o
381: => pay_pur_shd.g_old_rec.row_low_range_or_name
382: ,p_display_sequence_o
383: => pay_pur_shd.g_old_rec.display_sequence

Line 381: => pay_pur_shd.g_old_rec.row_low_range_or_name

377: => pay_pur_shd.g_old_rec.legislation_code
378: ,p_user_table_id_o
379: => pay_pur_shd.g_old_rec.user_table_id
380: ,p_row_low_range_or_name_o
381: => pay_pur_shd.g_old_rec.row_low_range_or_name
382: ,p_display_sequence_o
383: => pay_pur_shd.g_old_rec.display_sequence
384: ,p_row_high_range_o
385: => pay_pur_shd.g_old_rec.row_high_range

Line 383: => pay_pur_shd.g_old_rec.display_sequence

379: => pay_pur_shd.g_old_rec.user_table_id
380: ,p_row_low_range_or_name_o
381: => pay_pur_shd.g_old_rec.row_low_range_or_name
382: ,p_display_sequence_o
383: => pay_pur_shd.g_old_rec.display_sequence
384: ,p_row_high_range_o
385: => pay_pur_shd.g_old_rec.row_high_range
386: ,p_object_version_number_o
387: => pay_pur_shd.g_old_rec.object_version_number

Line 385: => pay_pur_shd.g_old_rec.row_high_range

381: => pay_pur_shd.g_old_rec.row_low_range_or_name
382: ,p_display_sequence_o
383: => pay_pur_shd.g_old_rec.display_sequence
384: ,p_row_high_range_o
385: => pay_pur_shd.g_old_rec.row_high_range
386: ,p_object_version_number_o
387: => pay_pur_shd.g_old_rec.object_version_number
388: );
389: --

Line 387: => pay_pur_shd.g_old_rec.object_version_number

383: => pay_pur_shd.g_old_rec.display_sequence
384: ,p_row_high_range_o
385: => pay_pur_shd.g_old_rec.row_high_range
386: ,p_object_version_number_o
387: => pay_pur_shd.g_old_rec.object_version_number
388: );
389: --
390: exception
391: --

Line 409: ,p_rec in out nocopy pay_pur_shd.g_rec_type

405: -- ----------------------------------------------------------------------------
406: Procedure del
407: (p_effective_date in date
408: ,p_datetrack_mode in varchar2
409: ,p_rec in out nocopy pay_pur_shd.g_rec_type
410: ,p_disable_range_overlap_check in boolean default false
411: ) is
412: --
413: l_proc varchar2(72) := g_package||'del';

Line 426: pay_pur_shd.lck

422: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
423: --
424: -- We must lock the row which we need to delete.
425: --
426: pay_pur_shd.lck
427: (p_effective_date => p_effective_date
428: ,p_datetrack_mode => p_datetrack_mode
429: ,p_user_row_id => p_rec.user_row_id
430: ,p_object_version_number => p_rec.object_version_number

Line 498: l_rec pay_pur_shd.g_rec_type;

494: ,p_effective_start_date out nocopy date
495: ,p_effective_end_date out nocopy date
496: ) is
497: --
498: l_rec pay_pur_shd.g_rec_type;
499: l_proc varchar2(72) := g_package||'del';
500: --
501: Begin
502: hr_utility.set_location('Entering:'||l_proc, 5);