DBA Data[Home] [Help]

APPS.BEN_ELIGIBLE_PERSON_PERF_API dependencies on DT_API

Line 144: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

140: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
141: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
142: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
143: --
144: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
145: l_dummy_pep_id number;
146: l_dummy_esd date;
147: l_dummy_eed date;
148: l_dummy_ovn number;

Line 426: ben_batch_dt_api.get_personobject

422: l_effective_end_date := hr_api.g_eot;
423: --
424: -- Person
425: --
426: ben_batch_dt_api.get_personobject
427: (p_person_id => p_person_id
428: ,p_rec => l_minmax_rec
429: );
430: --

Line 431: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

427: (p_person_id => p_person_id
428: ,p_rec => l_minmax_rec
429: );
430: --
431: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
432: (p_effective_date => p_effective_date
433: ,p_parcolumn_name => 'person_id'
434: ,p_min_esd => l_minmax_rec.min_esd
435: ,p_max_eed => l_minmax_rec.max_eed

Line 445: ben_batch_dt_api.get_lerobject

441: -- Ler
442: --
443: if p_ler_id is not null then
444: --
445: ben_batch_dt_api.get_lerobject
446: (p_ler_id => p_ler_id
447: ,p_rec => l_minmax_rec
448: );
449: --

Line 450: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

446: (p_ler_id => p_ler_id
447: ,p_rec => l_minmax_rec
448: );
449: --
450: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
451: (p_effective_date => p_effective_date
452: ,p_parcolumn_name => 'ler_id'
453: ,p_min_esd => l_minmax_rec.min_esd
454: ,p_max_eed => l_minmax_rec.max_eed

Line 466: ben_batch_dt_api.get_pgmobject

462: -- Pgm
463: --
464: if p_pgm_id is not null then
465: --
466: ben_batch_dt_api.get_pgmobject
467: (p_pgm_id => p_pgm_id
468: ,p_rec => l_minmax_rec
469: );
470: --

Line 471: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

467: (p_pgm_id => p_pgm_id
468: ,p_rec => l_minmax_rec
469: );
470: --
471: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
472: (p_effective_date => p_effective_date
473: ,p_parcolumn_name => 'pgm_id'
474: ,p_min_esd => l_minmax_rec.min_esd
475: ,p_max_eed => l_minmax_rec.max_eed

Line 487: ben_batch_dt_api.get_ptipobject

483: -- Ptip
484: --
485: if p_ptip_id is not null then
486: --
487: ben_batch_dt_api.get_ptipobject
488: (p_ptip_id => p_ptip_id
489: ,p_rec => l_minmax_rec
490: );
491: --

Line 492: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

488: (p_ptip_id => p_ptip_id
489: ,p_rec => l_minmax_rec
490: );
491: --
492: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
493: (p_effective_date => p_effective_date
494: ,p_parcolumn_name => 'ptip_id'
495: ,p_min_esd => l_minmax_rec.min_esd
496: ,p_max_eed => l_minmax_rec.max_eed

Line 508: ben_batch_dt_api.get_plipobject

504: -- Plip
505: --
506: if p_plip_id is not null then
507: --
508: ben_batch_dt_api.get_plipobject
509: (p_plip_id => p_plip_id
510: ,p_rec => l_minmax_rec
511: );
512: --

Line 513: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

509: (p_plip_id => p_plip_id
510: ,p_rec => l_minmax_rec
511: );
512: --
513: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
514: (p_effective_date => p_effective_date
515: ,p_parcolumn_name => 'plip_id'
516: ,p_min_esd => l_minmax_rec.min_esd
517: ,p_max_eed => l_minmax_rec.max_eed

Line 529: ben_batch_dt_api.get_plobject

525: -- Plan
526: --
527: if p_pl_id is not null then
528: --
529: ben_batch_dt_api.get_plobject
530: (p_pl_id => p_pl_id
531: ,p_rec => l_minmax_rec
532: );
533: --

Line 534: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

530: (p_pl_id => p_pl_id
531: ,p_rec => l_minmax_rec
532: );
533: --
534: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
535: (p_effective_date => p_effective_date
536: ,p_parcolumn_name => 'pl_id'
537: ,p_min_esd => l_minmax_rec.min_esd
538: ,p_max_eed => l_minmax_rec.max_eed

Line 1408: ben_batch_dt_api.validate_dt_mode_pep

1404: --
1405: -- Validate the datetrack mode mode getting the validation start
1406: -- and end dates for the specified datetrack operation.
1407: --
1408: ben_batch_dt_api.validate_dt_mode_pep
1409: (p_effective_date => p_effective_date
1410: ,p_datetrack_mode => p_datetrack_mode
1411: ,p_elig_per_id => p_elig_per_id
1412: --

Line 2151: ben_batch_dt_api.validate_dt_mode_pep

2147: --
2148: -- Validate the datetrack mode mode getting the validation start
2149: -- and end dates for the specified datetrack operation.
2150: --
2151: ben_batch_dt_api.validate_dt_mode_pep
2152: (p_effective_date => p_effective_date
2153: ,p_datetrack_mode => p_datetrack_mode
2154: ,p_elig_per_id => p_elig_per_id
2155: --

Line 3015: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

3011: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
3012: --
3013: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
3014: --
3015: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
3016: --
3017: begin
3018: --
3019: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3034: ben_batch_dt_api.get_elig_perobject

3030: -- Elig Per
3031: --
3032: if p_elig_per_id is not null then
3033: --
3034: ben_batch_dt_api.get_elig_perobject
3035: (p_elig_per_id => p_elig_per_id
3036: ,p_rec => l_minmax_rec
3037: );
3038: --

Line 3039: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

3035: (p_elig_per_id => p_elig_per_id
3036: ,p_rec => l_minmax_rec
3037: );
3038: --
3039: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
3040: (p_effective_date => p_effective_date
3041: ,p_parcolumn_name => 'elig_per_id'
3042: ,p_min_esd => l_minmax_rec.min_esd
3043: ,p_max_eed => l_minmax_rec.max_eed

Line 3484: dt_api.validate_dt_mode

3480: --
3481: -- Validate the datetrack mode mode getting the validation start
3482: -- and end dates for the specified datetrack operation.
3483: --
3484: dt_api.validate_dt_mode
3485: (p_effective_date => p_effective_date,
3486: p_datetrack_mode => p_datetrack_mode,
3487: p_base_table_name => 'ben_elig_per_opt_f',
3488: p_base_key_column => 'elig_per_opt_id',

Line 4018: dt_api.get_object_version_number

4014: -- Because we are updating a row we must get the next object
4015: -- version number.
4016: --
4017: p_rec.object_version_number :=
4018: dt_api.get_object_version_number
4019: (p_base_table_name => 'ben_elig_per_opt_f',
4020: p_base_key_column => 'elig_per_opt_id',
4021: p_base_key_value => p_rec.elig_per_opt_id);
4022: --