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.AME_APT_DEL dependencies on AME_APT_SHD

Line 54: (p_rec in out nocopy ame_apt_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: Procedure dt_delete_dml
54: (p_rec in out nocopy ame_apt_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 97: (p_rec in out nocopy ame_apt_shd.g_rec_type

93: -- ----------------------------------------------------------------------------
94: -- |------------------------------< delete_dml >------------------------------|
95: -- ----------------------------------------------------------------------------
96: Procedure delete_dml
97: (p_rec in out nocopy ame_apt_shd.g_rec_type
98: ,p_effective_date in date
99: ,p_datetrack_mode in varchar2
100: ,p_validation_start_date in date
101: ,p_validation_end_date in date

Line 154: (p_rec in out nocopy ame_apt_shd.g_rec_type

150: --
151: -- {End Of Comments}
152: -- ----------------------------------------------------------------------------
153: Procedure dt_pre_delete
154: (p_rec in out nocopy ame_apt_shd.g_rec_type
155: ,p_effective_date in date
156: ,p_datetrack_mode in varchar2
157: ,p_validation_start_date in date
158: ,p_validation_end_date in date

Line 169: := ame_apt_shd.g_old_rec.start_date;

165: --
166: If (p_datetrack_mode <> hr_api.g_zap) then
167: --
168: p_rec.start_date
169: := ame_apt_shd.g_old_rec.start_date;
170: --
171: If (p_datetrack_mode = hr_api.g_delete) then
172: p_rec.end_date := p_validation_start_date;
173: Else

Line 179: ame_apt_shd.upd_effective_end_date

175: End If;
176: --
177: -- Update the current effective end date record
178: --
179: ame_apt_shd.upd_effective_end_date
180: (p_effective_date => p_effective_date
181: ,p_approver_type_id => p_rec.approver_type_id
182: ,p_new_effective_end_date => p_rec.end_date
183: ,p_validation_start_date => p_validation_start_date

Line 228: (p_rec in out nocopy ame_apt_shd.g_rec_type

224: --
225: -- {End Of Comments}
226: -- ----------------------------------------------------------------------------
227: Procedure pre_delete
228: (p_rec in out nocopy ame_apt_shd.g_rec_type
229: ,p_effective_date in date
230: ,p_datetrack_mode in varchar2
231: ,p_validation_start_date in date
232: ,p_validation_end_date in date

Line 285: (p_rec in ame_apt_shd.g_rec_type

281: --
282: -- {End Of Comments}
283: -- ----------------------------------------------------------------------------
284: Procedure post_delete
285: (p_rec in ame_apt_shd.g_rec_type
286: ,p_effective_date in date
287: ,p_datetrack_mode in varchar2
288: ,p_validation_start_date in date
289: ,p_validation_end_date in date

Line 306: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system

302: ,p_validation_end_date => p_validation_end_date
303: ,p_approver_type_id => p_rec.approver_type_id
304: ,p_start_date => p_rec.start_date
305: ,p_end_date => p_rec.end_date
306: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
307: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label

Line 307: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label

303: ,p_approver_type_id => p_rec.approver_type_id
304: ,p_start_date => p_rec.start_date
305: ,p_end_date => p_rec.end_date
306: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
307: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label

Line 308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label

304: ,p_start_date => p_rec.start_date
305: ,p_end_date => p_rec.end_date
306: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
307: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query

Line 309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label

305: ,p_end_date => p_rec.end_date
306: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
307: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query

Line 310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label

306: ,p_orig_system_o => ame_apt_shd.g_old_rec.orig_system
307: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query

Line 311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label

307: ,p_query_variable_1_label_o => ame_apt_shd.g_old_rec.query_variable_1_label
308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query

Line 312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query

308: ,p_query_variable_2_label_o => ame_apt_shd.g_old_rec.query_variable_2_label
309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query

Line 313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query

309: ,p_query_variable_3_label_o => ame_apt_shd.g_old_rec.query_variable_3_label
310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure

Line 314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query

310: ,p_query_variable_4_label_o => ame_apt_shd.g_old_rec.query_variable_4_label
311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date

Line 315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query

311: ,p_query_variable_5_label_o => ame_apt_shd.g_old_rec.query_variable_5_label
312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
319: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date

Line 316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query

312: ,p_variable_1_lov_query_o => ame_apt_shd.g_old_rec.variable_1_lov_query
313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
319: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
320: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number

Line 317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure

313: ,p_variable_2_lov_query_o => ame_apt_shd.g_old_rec.variable_2_lov_query
314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
319: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
320: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
321: );

Line 318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date

314: ,p_variable_3_lov_query_o => ame_apt_shd.g_old_rec.variable_3_lov_query
315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
319: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
320: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
321: );
322: --

Line 319: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date

315: ,p_variable_4_lov_query_o => ame_apt_shd.g_old_rec.variable_4_lov_query
316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
319: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
320: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
321: );
322: --
323: exception

Line 320: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number

316: ,p_variable_5_lov_query_o => ame_apt_shd.g_old_rec.variable_5_lov_query
317: ,p_query_procedure_o => ame_apt_shd.g_old_rec.query_procedure
318: ,p_start_date_o => ame_apt_shd.g_old_rec.start_date
319: ,p_end_date_o => ame_apt_shd.g_old_rec.end_date
320: ,p_object_version_number_o => ame_apt_shd.g_old_rec.object_version_number
321: );
322: --
323: exception
324: --

Line 342: ,p_rec in out nocopy ame_apt_shd.g_rec_type

338: -- ----------------------------------------------------------------------------
339: Procedure del
340: (p_effective_date in date
341: ,p_datetrack_mode in varchar2
342: ,p_rec in out nocopy ame_apt_shd.g_rec_type
343: ) is
344: --
345: l_proc varchar2(72) := g_package||'del';
346: l_validation_start_date date;

Line 358: ame_apt_shd.lck

354: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
355: --
356: -- We must lock the row which we need to delete.
357: --
358: ame_apt_shd.lck
359: (p_effective_date => p_effective_date
360: ,p_datetrack_mode => p_datetrack_mode
361: ,p_approver_type_id => p_rec.approver_type_id
362: ,p_orig_system => p_rec.orig_system

Line 428: l_rec ame_apt_shd.g_rec_type;

424: ,p_start_date out nocopy date
425: ,p_end_date out nocopy date
426: ) is
427: --
428: l_rec ame_apt_shd.g_rec_type;
429: l_proc varchar2(72) := g_package||'del';
430: --
431: Begin
432: hr_utility.set_location('Entering:'||l_proc, 5);