APPS.PAY_EVQ_DEL dependencies on PAY_EVQ_SHD

Line 54: (p_rec in out nocopy pay_evq_shd.g_rec_type

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

130: -- ----------------------------------------------------------------------------
131: -- |------------------------------< delete_dml >------------------------------|
132: -- ----------------------------------------------------------------------------
133: Procedure delete_dml
134: (p_rec in out nocopy pay_evq_shd.g_rec_type
135: ,p_effective_date in date
136: ,p_datetrack_mode in varchar2
137: ,p_validation_start_date in date
138: ,p_validation_end_date in date

Line 191: (p_rec in out nocopy pay_evq_shd.g_rec_type

187: --
188: -- {End Of Comments}
189: -- ----------------------------------------------------------------------------
190: Procedure dt_pre_delete
191: (p_rec in out nocopy pay_evq_shd.g_rec_type
192: ,p_effective_date in date
193: ,p_datetrack_mode in varchar2
194: ,p_validation_start_date in date
195: ,p_validation_end_date in date

Line 206: := pay_evq_shd.g_old_rec.effective_start_date;

202: --
203: If (p_datetrack_mode <> hr_api.g_zap) then
204: --
205: p_rec.effective_start_date
206: := pay_evq_shd.g_old_rec.effective_start_date;
207: --
208: If (p_datetrack_mode = hr_api.g_delete) then
209: p_rec.effective_end_date := p_validation_start_date - 1;
210: Else

Line 216: pay_evq_shd.upd_effective_end_date

212: End If;
213: --
214: -- Update the current effective end date record
215: --
216: pay_evq_shd.upd_effective_end_date
217: (p_effective_date => p_effective_date
218: ,p_base_key_value => p_rec.event_qualifier_id
219: ,p_new_effective_end_date => p_rec.effective_end_date
220: ,p_validation_start_date => p_validation_start_date

Line 265: (p_rec in out nocopy pay_evq_shd.g_rec_type

261: --
262: -- {End Of Comments}
263: -- ----------------------------------------------------------------------------
264: Procedure pre_delete
265: (p_rec in out nocopy pay_evq_shd.g_rec_type
266: ,p_effective_date in date
267: ,p_datetrack_mode in varchar2
268: ,p_validation_start_date in date
269: ,p_validation_end_date in date

Line 325: (p_rec in pay_evq_shd.g_rec_type

321: --
322: -- {End Of Comments}
323: -- ----------------------------------------------------------------------------
324: Procedure post_delete
325: (p_rec in pay_evq_shd.g_rec_type
326: ,p_effective_date in date
327: ,p_datetrack_mode in varchar2
328: ,p_validation_start_date in date
329: ,p_validation_end_date in date

Line 361: => pay_evq_shd.g_old_rec.effective_start_date

357: => p_rec.effective_start_date
358: ,p_effective_end_date
359: => p_rec.effective_end_date
360: ,p_effective_start_date_o
361: => pay_evq_shd.g_old_rec.effective_start_date
362: ,p_effective_end_date_o
363: => pay_evq_shd.g_old_rec.effective_end_date
364: ,p_dated_table_id_o
365: => pay_evq_shd.g_old_rec.dated_table_id

Line 363: => pay_evq_shd.g_old_rec.effective_end_date

359: => p_rec.effective_end_date
360: ,p_effective_start_date_o
361: => pay_evq_shd.g_old_rec.effective_start_date
362: ,p_effective_end_date_o
363: => pay_evq_shd.g_old_rec.effective_end_date
364: ,p_dated_table_id_o
365: => pay_evq_shd.g_old_rec.dated_table_id
366: ,p_column_name_o
367: => pay_evq_shd.g_old_rec.column_name

Line 365: => pay_evq_shd.g_old_rec.dated_table_id

361: => pay_evq_shd.g_old_rec.effective_start_date
362: ,p_effective_end_date_o
363: => pay_evq_shd.g_old_rec.effective_end_date
364: ,p_dated_table_id_o
365: => pay_evq_shd.g_old_rec.dated_table_id
366: ,p_column_name_o
367: => pay_evq_shd.g_old_rec.column_name
368: ,p_qualifier_name_o
369: => pay_evq_shd.g_old_rec.qualifier_name

Line 367: => pay_evq_shd.g_old_rec.column_name

363: => pay_evq_shd.g_old_rec.effective_end_date
364: ,p_dated_table_id_o
365: => pay_evq_shd.g_old_rec.dated_table_id
366: ,p_column_name_o
367: => pay_evq_shd.g_old_rec.column_name
368: ,p_qualifier_name_o
369: => pay_evq_shd.g_old_rec.qualifier_name
370: ,p_legislation_code_o
371: => pay_evq_shd.g_old_rec.legislation_code

Line 369: => pay_evq_shd.g_old_rec.qualifier_name

365: => pay_evq_shd.g_old_rec.dated_table_id
366: ,p_column_name_o
367: => pay_evq_shd.g_old_rec.column_name
368: ,p_qualifier_name_o
369: => pay_evq_shd.g_old_rec.qualifier_name
370: ,p_legislation_code_o
371: => pay_evq_shd.g_old_rec.legislation_code
372: ,p_business_group_id_o
373: => pay_evq_shd.g_old_rec.business_group_id

Line 371: => pay_evq_shd.g_old_rec.legislation_code

367: => pay_evq_shd.g_old_rec.column_name
368: ,p_qualifier_name_o
369: => pay_evq_shd.g_old_rec.qualifier_name
370: ,p_legislation_code_o
371: => pay_evq_shd.g_old_rec.legislation_code
372: ,p_business_group_id_o
373: => pay_evq_shd.g_old_rec.business_group_id
374: ,p_comparison_column_o
375: => pay_evq_shd.g_old_rec.comparison_column

Line 373: => pay_evq_shd.g_old_rec.business_group_id

369: => pay_evq_shd.g_old_rec.qualifier_name
370: ,p_legislation_code_o
371: => pay_evq_shd.g_old_rec.legislation_code
372: ,p_business_group_id_o
373: => pay_evq_shd.g_old_rec.business_group_id
374: ,p_comparison_column_o
375: => pay_evq_shd.g_old_rec.comparison_column
376: ,p_qualifier_definition_o
377: => pay_evq_shd.g_old_rec.qualifier_definition

Line 375: => pay_evq_shd.g_old_rec.comparison_column

371: => pay_evq_shd.g_old_rec.legislation_code
372: ,p_business_group_id_o
373: => pay_evq_shd.g_old_rec.business_group_id
374: ,p_comparison_column_o
375: => pay_evq_shd.g_old_rec.comparison_column
376: ,p_qualifier_definition_o
377: => pay_evq_shd.g_old_rec.qualifier_definition
378: ,p_qualifier_where_clause_o
379: => pay_evq_shd.g_old_rec.qualifier_where_clause

Line 377: => pay_evq_shd.g_old_rec.qualifier_definition

373: => pay_evq_shd.g_old_rec.business_group_id
374: ,p_comparison_column_o
375: => pay_evq_shd.g_old_rec.comparison_column
376: ,p_qualifier_definition_o
377: => pay_evq_shd.g_old_rec.qualifier_definition
378: ,p_qualifier_where_clause_o
379: => pay_evq_shd.g_old_rec.qualifier_where_clause
380: ,p_entry_qualification_o
381: => pay_evq_shd.g_old_rec.entry_qualification

Line 379: => pay_evq_shd.g_old_rec.qualifier_where_clause

375: => pay_evq_shd.g_old_rec.comparison_column
376: ,p_qualifier_definition_o
377: => pay_evq_shd.g_old_rec.qualifier_definition
378: ,p_qualifier_where_clause_o
379: => pay_evq_shd.g_old_rec.qualifier_where_clause
380: ,p_entry_qualification_o
381: => pay_evq_shd.g_old_rec.entry_qualification
382: ,p_assignment_qualification_o
383: => pay_evq_shd.g_old_rec.assignment_qualification

Line 381: => pay_evq_shd.g_old_rec.entry_qualification

377: => pay_evq_shd.g_old_rec.qualifier_definition
378: ,p_qualifier_where_clause_o
379: => pay_evq_shd.g_old_rec.qualifier_where_clause
380: ,p_entry_qualification_o
381: => pay_evq_shd.g_old_rec.entry_qualification
382: ,p_assignment_qualification_o
383: => pay_evq_shd.g_old_rec.assignment_qualification
384: ,p_multi_event_sql_o
385: => pay_evq_shd.g_old_rec.multi_event_sql

Line 383: => pay_evq_shd.g_old_rec.assignment_qualification

379: => pay_evq_shd.g_old_rec.qualifier_where_clause
380: ,p_entry_qualification_o
381: => pay_evq_shd.g_old_rec.entry_qualification
382: ,p_assignment_qualification_o
383: => pay_evq_shd.g_old_rec.assignment_qualification
384: ,p_multi_event_sql_o
385: => pay_evq_shd.g_old_rec.multi_event_sql
386: ,p_object_version_number_o
387: => pay_evq_shd.g_old_rec.object_version_number

Line 385: => pay_evq_shd.g_old_rec.multi_event_sql

381: => pay_evq_shd.g_old_rec.entry_qualification
382: ,p_assignment_qualification_o
383: => pay_evq_shd.g_old_rec.assignment_qualification
384: ,p_multi_event_sql_o
385: => pay_evq_shd.g_old_rec.multi_event_sql
386: ,p_object_version_number_o
387: => pay_evq_shd.g_old_rec.object_version_number
388: );
389: --

Line 387: => pay_evq_shd.g_old_rec.object_version_number

383: => pay_evq_shd.g_old_rec.assignment_qualification
384: ,p_multi_event_sql_o
385: => pay_evq_shd.g_old_rec.multi_event_sql
386: ,p_object_version_number_o
387: => pay_evq_shd.g_old_rec.object_version_number
388: );
389: --
390: exception
391: --

Line 409: ,p_rec in out nocopy pay_evq_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_evq_shd.g_rec_type
410: ) is
411: --
412: l_proc varchar2(72) := g_package||'del';
413: l_validation_start_date date;

Line 425: pay_evq_shd.lck

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

Line 494: l_rec pay_evq_shd.g_rec_type;

490: ,p_effective_start_date out nocopy date
491: ,p_effective_end_date out nocopy date
492: ) is
493: --
494: l_rec pay_evq_shd.g_rec_type;
495: l_proc varchar2(72) := g_package||'del';
496: --
497: Begin
498: hr_utility.set_location('Entering:'||l_proc, 5);