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_EVQ_UPD dependencies on PAY_EVQ_SHD

Line 58: (p_rec in out nocopy pay_evq_shd.g_rec_type

54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_evq_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date

Line 119: pay_evq_shd.constraint_error

115: Exception
116: When hr_api.check_integrity_violated Then
117: -- A check constraint has been violated
118: --
119: pay_evq_shd.constraint_error
120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --

Line 124: pay_evq_shd.constraint_error

120: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
121: When hr_api.unique_integrity_violated Then
122: -- Unique integrity has been violated
123: --
124: pay_evq_shd.constraint_error
125: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
126: When Others Then
127: --
128: Raise;

Line 163: (p_rec in out nocopy pay_evq_shd.g_rec_type

159: --
160: -- {End Of Comments}
161: -- ----------------------------------------------------------------------------
162: Procedure update_dml
163: (p_rec in out nocopy pay_evq_shd.g_rec_type
164: ,p_effective_date in date
165: ,p_datetrack_mode in varchar2
166: ,p_validation_start_date in date
167: ,p_validation_end_date in date

Line 230: (p_rec in out nocopy pay_evq_shd.g_rec_type

226: --
227: -- {End Of Comments}
228: -- ----------------------------------------------------------------------------
229: Procedure dt_pre_update
230: (p_rec in out nocopy pay_evq_shd.g_rec_type
231: ,p_effective_date in date
232: ,p_datetrack_mode in varchar2
233: ,p_validation_start_date in date
234: ,p_validation_end_date in date

Line 246: pay_evq_shd.upd_effective_end_date

242: If (p_datetrack_mode <> hr_api.g_correction) then
243: --
244: -- Update the current effective end date
245: --
246: pay_evq_shd.upd_effective_end_date
247: (p_effective_date => p_effective_date
248: ,p_base_key_value => p_rec.event_qualifier_id
249: ,p_new_effective_end_date => (p_validation_start_date - 1)
250: ,p_validation_start_date => p_validation_start_date

Line 315: (p_rec in out nocopy pay_evq_shd.g_rec_type

311: --
312: -- {End Of Comments}
313: -- ----------------------------------------------------------------------------
314: Procedure pre_update
315: (p_rec in out nocopy pay_evq_shd.g_rec_type
316: ,p_effective_date in date
317: ,p_datetrack_mode in varchar2
318: ,p_validation_start_date in date
319: ,p_validation_end_date in date

Line 373: (p_rec in pay_evq_shd.g_rec_type

369: --
370: -- {End Of Comments}
371: -- ----------------------------------------------------------------------------
372: Procedure post_update
373: (p_rec in pay_evq_shd.g_rec_type
374: ,p_effective_date in date
375: ,p_datetrack_mode in varchar2
376: ,p_validation_start_date in date
377: ,p_validation_end_date in date

Line 416: => pay_evq_shd.g_old_rec.effective_start_date

412: => p_rec.multi_event_sql
413: ,p_object_version_number
414: => p_rec.object_version_number
415: ,p_effective_start_date_o
416: => pay_evq_shd.g_old_rec.effective_start_date
417: ,p_effective_end_date_o
418: => pay_evq_shd.g_old_rec.effective_end_date
419: ,p_dated_table_id_o
420: => pay_evq_shd.g_old_rec.dated_table_id

Line 418: => pay_evq_shd.g_old_rec.effective_end_date

414: => p_rec.object_version_number
415: ,p_effective_start_date_o
416: => pay_evq_shd.g_old_rec.effective_start_date
417: ,p_effective_end_date_o
418: => pay_evq_shd.g_old_rec.effective_end_date
419: ,p_dated_table_id_o
420: => pay_evq_shd.g_old_rec.dated_table_id
421: ,p_column_name_o
422: => pay_evq_shd.g_old_rec.column_name

Line 420: => pay_evq_shd.g_old_rec.dated_table_id

416: => pay_evq_shd.g_old_rec.effective_start_date
417: ,p_effective_end_date_o
418: => pay_evq_shd.g_old_rec.effective_end_date
419: ,p_dated_table_id_o
420: => pay_evq_shd.g_old_rec.dated_table_id
421: ,p_column_name_o
422: => pay_evq_shd.g_old_rec.column_name
423: ,p_qualifier_name_o
424: => pay_evq_shd.g_old_rec.qualifier_name

Line 422: => pay_evq_shd.g_old_rec.column_name

418: => pay_evq_shd.g_old_rec.effective_end_date
419: ,p_dated_table_id_o
420: => pay_evq_shd.g_old_rec.dated_table_id
421: ,p_column_name_o
422: => pay_evq_shd.g_old_rec.column_name
423: ,p_qualifier_name_o
424: => pay_evq_shd.g_old_rec.qualifier_name
425: ,p_legislation_code_o
426: => pay_evq_shd.g_old_rec.legislation_code

Line 424: => pay_evq_shd.g_old_rec.qualifier_name

420: => pay_evq_shd.g_old_rec.dated_table_id
421: ,p_column_name_o
422: => pay_evq_shd.g_old_rec.column_name
423: ,p_qualifier_name_o
424: => pay_evq_shd.g_old_rec.qualifier_name
425: ,p_legislation_code_o
426: => pay_evq_shd.g_old_rec.legislation_code
427: ,p_business_group_id_o
428: => pay_evq_shd.g_old_rec.business_group_id

Line 426: => pay_evq_shd.g_old_rec.legislation_code

422: => pay_evq_shd.g_old_rec.column_name
423: ,p_qualifier_name_o
424: => pay_evq_shd.g_old_rec.qualifier_name
425: ,p_legislation_code_o
426: => pay_evq_shd.g_old_rec.legislation_code
427: ,p_business_group_id_o
428: => pay_evq_shd.g_old_rec.business_group_id
429: ,p_comparison_column_o
430: => pay_evq_shd.g_old_rec.comparison_column

Line 428: => pay_evq_shd.g_old_rec.business_group_id

424: => pay_evq_shd.g_old_rec.qualifier_name
425: ,p_legislation_code_o
426: => pay_evq_shd.g_old_rec.legislation_code
427: ,p_business_group_id_o
428: => pay_evq_shd.g_old_rec.business_group_id
429: ,p_comparison_column_o
430: => pay_evq_shd.g_old_rec.comparison_column
431: ,p_qualifier_definition_o
432: => pay_evq_shd.g_old_rec.qualifier_definition

Line 430: => pay_evq_shd.g_old_rec.comparison_column

426: => pay_evq_shd.g_old_rec.legislation_code
427: ,p_business_group_id_o
428: => pay_evq_shd.g_old_rec.business_group_id
429: ,p_comparison_column_o
430: => pay_evq_shd.g_old_rec.comparison_column
431: ,p_qualifier_definition_o
432: => pay_evq_shd.g_old_rec.qualifier_definition
433: ,p_qualifier_where_clause_o
434: => pay_evq_shd.g_old_rec.qualifier_where_clause

Line 432: => pay_evq_shd.g_old_rec.qualifier_definition

428: => pay_evq_shd.g_old_rec.business_group_id
429: ,p_comparison_column_o
430: => pay_evq_shd.g_old_rec.comparison_column
431: ,p_qualifier_definition_o
432: => pay_evq_shd.g_old_rec.qualifier_definition
433: ,p_qualifier_where_clause_o
434: => pay_evq_shd.g_old_rec.qualifier_where_clause
435: ,p_entry_qualification_o
436: => pay_evq_shd.g_old_rec.entry_qualification

Line 434: => pay_evq_shd.g_old_rec.qualifier_where_clause

430: => pay_evq_shd.g_old_rec.comparison_column
431: ,p_qualifier_definition_o
432: => pay_evq_shd.g_old_rec.qualifier_definition
433: ,p_qualifier_where_clause_o
434: => pay_evq_shd.g_old_rec.qualifier_where_clause
435: ,p_entry_qualification_o
436: => pay_evq_shd.g_old_rec.entry_qualification
437: ,p_assignment_qualification_o
438: => pay_evq_shd.g_old_rec.assignment_qualification

Line 436: => pay_evq_shd.g_old_rec.entry_qualification

432: => pay_evq_shd.g_old_rec.qualifier_definition
433: ,p_qualifier_where_clause_o
434: => pay_evq_shd.g_old_rec.qualifier_where_clause
435: ,p_entry_qualification_o
436: => pay_evq_shd.g_old_rec.entry_qualification
437: ,p_assignment_qualification_o
438: => pay_evq_shd.g_old_rec.assignment_qualification
439: ,p_multi_event_sql_o
440: => pay_evq_shd.g_old_rec.multi_event_sql

Line 438: => pay_evq_shd.g_old_rec.assignment_qualification

434: => pay_evq_shd.g_old_rec.qualifier_where_clause
435: ,p_entry_qualification_o
436: => pay_evq_shd.g_old_rec.entry_qualification
437: ,p_assignment_qualification_o
438: => pay_evq_shd.g_old_rec.assignment_qualification
439: ,p_multi_event_sql_o
440: => pay_evq_shd.g_old_rec.multi_event_sql
441: ,p_object_version_number_o
442: => pay_evq_shd.g_old_rec.object_version_number

Line 440: => pay_evq_shd.g_old_rec.multi_event_sql

436: => pay_evq_shd.g_old_rec.entry_qualification
437: ,p_assignment_qualification_o
438: => pay_evq_shd.g_old_rec.assignment_qualification
439: ,p_multi_event_sql_o
440: => pay_evq_shd.g_old_rec.multi_event_sql
441: ,p_object_version_number_o
442: => pay_evq_shd.g_old_rec.object_version_number
443: );
444: --

Line 442: => pay_evq_shd.g_old_rec.object_version_number

438: => pay_evq_shd.g_old_rec.assignment_qualification
439: ,p_multi_event_sql_o
440: => pay_evq_shd.g_old_rec.multi_event_sql
441: ,p_object_version_number_o
442: => pay_evq_shd.g_old_rec.object_version_number
443: );
444: --
445: exception
446: --

Line 502: (p_rec in out nocopy pay_evq_shd.g_rec_type

498: --
499: -- {End Of Comments}
500: -- ----------------------------------------------------------------------------
501: Procedure convert_defs
502: (p_rec in out nocopy pay_evq_shd.g_rec_type
503: ) is
504: --
505: Begin
506: --

Line 514: pay_evq_shd.g_old_rec.dated_table_id;

510: -- is being used then we must set to the 'current' argument value.
511: --
512: If (p_rec.dated_table_id = hr_api.g_number) then
513: p_rec.dated_table_id :=
514: pay_evq_shd.g_old_rec.dated_table_id;
515: End If;
516: If (p_rec.column_name = hr_api.g_varchar2) then
517: p_rec.column_name :=
518: pay_evq_shd.g_old_rec.column_name;

Line 518: pay_evq_shd.g_old_rec.column_name;

514: pay_evq_shd.g_old_rec.dated_table_id;
515: End If;
516: If (p_rec.column_name = hr_api.g_varchar2) then
517: p_rec.column_name :=
518: pay_evq_shd.g_old_rec.column_name;
519: End If;
520: If (p_rec.qualifier_name = hr_api.g_varchar2) then
521: p_rec.qualifier_name :=
522: pay_evq_shd.g_old_rec.qualifier_name;

Line 522: pay_evq_shd.g_old_rec.qualifier_name;

518: pay_evq_shd.g_old_rec.column_name;
519: End If;
520: If (p_rec.qualifier_name = hr_api.g_varchar2) then
521: p_rec.qualifier_name :=
522: pay_evq_shd.g_old_rec.qualifier_name;
523: End If;
524: If (p_rec.legislation_code = hr_api.g_varchar2) then
525: p_rec.legislation_code :=
526: pay_evq_shd.g_old_rec.legislation_code;

Line 526: pay_evq_shd.g_old_rec.legislation_code;

522: pay_evq_shd.g_old_rec.qualifier_name;
523: End If;
524: If (p_rec.legislation_code = hr_api.g_varchar2) then
525: p_rec.legislation_code :=
526: pay_evq_shd.g_old_rec.legislation_code;
527: End If;
528: If (p_rec.business_group_id = hr_api.g_number) then
529: p_rec.business_group_id :=
530: pay_evq_shd.g_old_rec.business_group_id;

Line 530: pay_evq_shd.g_old_rec.business_group_id;

526: pay_evq_shd.g_old_rec.legislation_code;
527: End If;
528: If (p_rec.business_group_id = hr_api.g_number) then
529: p_rec.business_group_id :=
530: pay_evq_shd.g_old_rec.business_group_id;
531: End If;
532: If (p_rec.comparison_column = hr_api.g_varchar2) then
533: p_rec.comparison_column :=
534: pay_evq_shd.g_old_rec.comparison_column;

Line 534: pay_evq_shd.g_old_rec.comparison_column;

530: pay_evq_shd.g_old_rec.business_group_id;
531: End If;
532: If (p_rec.comparison_column = hr_api.g_varchar2) then
533: p_rec.comparison_column :=
534: pay_evq_shd.g_old_rec.comparison_column;
535: End If;
536: If (p_rec.qualifier_definition = hr_api.g_varchar2) then
537: p_rec.qualifier_definition :=
538: pay_evq_shd.g_old_rec.qualifier_definition;

Line 538: pay_evq_shd.g_old_rec.qualifier_definition;

534: pay_evq_shd.g_old_rec.comparison_column;
535: End If;
536: If (p_rec.qualifier_definition = hr_api.g_varchar2) then
537: p_rec.qualifier_definition :=
538: pay_evq_shd.g_old_rec.qualifier_definition;
539: End If;
540: If (p_rec.qualifier_where_clause = hr_api.g_varchar2) then
541: p_rec.qualifier_where_clause :=
542: pay_evq_shd.g_old_rec.qualifier_where_clause;

Line 542: pay_evq_shd.g_old_rec.qualifier_where_clause;

538: pay_evq_shd.g_old_rec.qualifier_definition;
539: End If;
540: If (p_rec.qualifier_where_clause = hr_api.g_varchar2) then
541: p_rec.qualifier_where_clause :=
542: pay_evq_shd.g_old_rec.qualifier_where_clause;
543: End If;
544: If (p_rec.entry_qualification = hr_api.g_varchar2) then
545: p_rec.entry_qualification :=
546: pay_evq_shd.g_old_rec.entry_qualification;

Line 546: pay_evq_shd.g_old_rec.entry_qualification;

542: pay_evq_shd.g_old_rec.qualifier_where_clause;
543: End If;
544: If (p_rec.entry_qualification = hr_api.g_varchar2) then
545: p_rec.entry_qualification :=
546: pay_evq_shd.g_old_rec.entry_qualification;
547: End If;
548: If (p_rec.assignment_qualification = hr_api.g_varchar2) then
549: p_rec.assignment_qualification :=
550: pay_evq_shd.g_old_rec.assignment_qualification;

Line 550: pay_evq_shd.g_old_rec.assignment_qualification;

546: pay_evq_shd.g_old_rec.entry_qualification;
547: End If;
548: If (p_rec.assignment_qualification = hr_api.g_varchar2) then
549: p_rec.assignment_qualification :=
550: pay_evq_shd.g_old_rec.assignment_qualification;
551: End If;
552: If (p_rec.multi_event_sql = hr_api.g_varchar2) then
553: p_rec.multi_event_sql :=
554: pay_evq_shd.g_old_rec.multi_event_sql;

Line 554: pay_evq_shd.g_old_rec.multi_event_sql;

550: pay_evq_shd.g_old_rec.assignment_qualification;
551: End If;
552: If (p_rec.multi_event_sql = hr_api.g_varchar2) then
553: p_rec.multi_event_sql :=
554: pay_evq_shd.g_old_rec.multi_event_sql;
555: End If;
556: --
557: End convert_defs;
558: --

Line 565: ,p_rec in out nocopy pay_evq_shd.g_rec_type

561: -- ----------------------------------------------------------------------------
562: Procedure upd
563: (p_effective_date in date
564: ,p_datetrack_mode in varchar2
565: ,p_rec in out nocopy pay_evq_shd.g_rec_type
566: ) is
567: --
568: l_proc varchar2(72) := g_package||'upd';
569: l_validation_start_date date;

Line 581: pay_evq_shd.lck

577: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
578: --
579: -- We must lock the row which we need to update.
580: --
581: pay_evq_shd.lck
582: (p_effective_date => p_effective_date
583: ,p_datetrack_mode => p_datetrack_mode
584: ,p_event_qualifier_id => p_rec.event_qualifier_id
585: ,p_object_version_number => p_rec.object_version_number

Line 661: l_rec pay_evq_shd.g_rec_type;

657: ,p_effective_start_date out nocopy date
658: ,p_effective_end_date out nocopy date
659: ) is
660: --
661: l_rec pay_evq_shd.g_rec_type;
662: l_proc varchar2(72) := g_package||'upd';
663: --
664: Begin
665: hr_utility.set_location('Entering:'||l_proc, 5);

Line 671: pay_evq_shd.convert_args

667: -- Call conversion function to turn arguments into the
668: -- l_rec structure.
669: --
670: l_rec :=
671: pay_evq_shd.convert_args
672: (p_event_qualifier_id
673: ,null
674: ,null
675: ,hr_api.g_number