DBA Data[Home] [Help]

APPS.BEN_ELIGIBLE_PERSON_PERF_API dependencies on DT_API

Line 140: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

136: l_last_update_date ben_elig_per_f.last_update_date%TYPE;
137: l_last_updated_by ben_elig_per_f.last_updated_by%TYPE;
138: l_last_update_login ben_elig_per_f.last_update_login%TYPE;
139: --
140: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
141: l_dummy_pep_id number;
142: l_dummy_esd date;
143: l_dummy_eed date;
144: l_dummy_ovn number;

Line 422: ben_batch_dt_api.get_personobject

418: l_effective_end_date := hr_api.g_eot;
419: --
420: -- Person
421: --
422: ben_batch_dt_api.get_personobject
423: (p_person_id => p_person_id
424: ,p_rec => l_minmax_rec
425: );
426: --

Line 427: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

423: (p_person_id => p_person_id
424: ,p_rec => l_minmax_rec
425: );
426: --
427: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
428: (p_effective_date => p_effective_date
429: ,p_parcolumn_name => 'person_id'
430: ,p_min_esd => l_minmax_rec.min_esd
431: ,p_max_eed => l_minmax_rec.max_eed

Line 441: ben_batch_dt_api.get_lerobject

437: -- Ler
438: --
439: if p_ler_id is not null then
440: --
441: ben_batch_dt_api.get_lerobject
442: (p_ler_id => p_ler_id
443: ,p_rec => l_minmax_rec
444: );
445: --

Line 446: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

442: (p_ler_id => p_ler_id
443: ,p_rec => l_minmax_rec
444: );
445: --
446: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
447: (p_effective_date => p_effective_date
448: ,p_parcolumn_name => 'ler_id'
449: ,p_min_esd => l_minmax_rec.min_esd
450: ,p_max_eed => l_minmax_rec.max_eed

Line 462: ben_batch_dt_api.get_pgmobject

458: -- Pgm
459: --
460: if p_pgm_id is not null then
461: --
462: ben_batch_dt_api.get_pgmobject
463: (p_pgm_id => p_pgm_id
464: ,p_rec => l_minmax_rec
465: );
466: --

Line 467: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

463: (p_pgm_id => p_pgm_id
464: ,p_rec => l_minmax_rec
465: );
466: --
467: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
468: (p_effective_date => p_effective_date
469: ,p_parcolumn_name => 'pgm_id'
470: ,p_min_esd => l_minmax_rec.min_esd
471: ,p_max_eed => l_minmax_rec.max_eed

Line 483: ben_batch_dt_api.get_ptipobject

479: -- Ptip
480: --
481: if p_ptip_id is not null then
482: --
483: ben_batch_dt_api.get_ptipobject
484: (p_ptip_id => p_ptip_id
485: ,p_rec => l_minmax_rec
486: );
487: --

Line 488: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

484: (p_ptip_id => p_ptip_id
485: ,p_rec => l_minmax_rec
486: );
487: --
488: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
489: (p_effective_date => p_effective_date
490: ,p_parcolumn_name => 'ptip_id'
491: ,p_min_esd => l_minmax_rec.min_esd
492: ,p_max_eed => l_minmax_rec.max_eed

Line 504: ben_batch_dt_api.get_plipobject

500: -- Plip
501: --
502: if p_plip_id is not null then
503: --
504: ben_batch_dt_api.get_plipobject
505: (p_plip_id => p_plip_id
506: ,p_rec => l_minmax_rec
507: );
508: --

Line 509: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

505: (p_plip_id => p_plip_id
506: ,p_rec => l_minmax_rec
507: );
508: --
509: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
510: (p_effective_date => p_effective_date
511: ,p_parcolumn_name => 'plip_id'
512: ,p_min_esd => l_minmax_rec.min_esd
513: ,p_max_eed => l_minmax_rec.max_eed

Line 525: ben_batch_dt_api.get_plobject

521: -- Plan
522: --
523: if p_pl_id is not null then
524: --
525: ben_batch_dt_api.get_plobject
526: (p_pl_id => p_pl_id
527: ,p_rec => l_minmax_rec
528: );
529: --

Line 530: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

526: (p_pl_id => p_pl_id
527: ,p_rec => l_minmax_rec
528: );
529: --
530: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
531: (p_effective_date => p_effective_date
532: ,p_parcolumn_name => 'pl_id'
533: ,p_min_esd => l_minmax_rec.min_esd
534: ,p_max_eed => l_minmax_rec.max_eed

Line 1387: ben_batch_dt_api.validate_dt_mode_pep

1383: --
1384: -- Validate the datetrack mode mode getting the validation start
1385: -- and end dates for the specified datetrack operation.
1386: --
1387: ben_batch_dt_api.validate_dt_mode_pep
1388: (p_effective_date => p_effective_date
1389: ,p_datetrack_mode => p_datetrack_mode
1390: ,p_elig_per_id => p_elig_per_id
1391: --

Line 2130: ben_batch_dt_api.validate_dt_mode_pep

2126: --
2127: -- Validate the datetrack mode mode getting the validation start
2128: -- and end dates for the specified datetrack operation.
2129: --
2130: ben_batch_dt_api.validate_dt_mode_pep
2131: (p_effective_date => p_effective_date
2132: ,p_datetrack_mode => p_datetrack_mode
2133: ,p_elig_per_id => p_elig_per_id
2134: --

Line 2985: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;

2981: l_last_update_login ben_elig_per_opt_f.last_update_login%TYPE;
2982: --
2983: Cursor C_Sel1 is select ben_elig_per_opt_f_s.nextval from sys.dual;
2984: --
2985: l_minmax_rec ben_batch_dt_api.gtyp_dtsum_row;
2986: --
2987: begin
2988: --
2989: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 3004: ben_batch_dt_api.get_elig_perobject

3000: -- Elig Per
3001: --
3002: if p_elig_per_id is not null then
3003: --
3004: ben_batch_dt_api.get_elig_perobject
3005: (p_elig_per_id => p_elig_per_id
3006: ,p_rec => l_minmax_rec
3007: );
3008: --

Line 3009: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates

3005: (p_elig_per_id => p_elig_per_id
3006: ,p_rec => l_minmax_rec
3007: );
3008: --
3009: ben_batch_dt_api.Get_DtIns_Start_and_End_Dates
3010: (p_effective_date => p_effective_date
3011: ,p_parcolumn_name => 'elig_per_id'
3012: ,p_min_esd => l_minmax_rec.min_esd
3013: ,p_max_eed => l_minmax_rec.max_eed

Line 3454: dt_api.validate_dt_mode

3450: --
3451: -- Validate the datetrack mode mode getting the validation start
3452: -- and end dates for the specified datetrack operation.
3453: --
3454: dt_api.validate_dt_mode
3455: (p_effective_date => p_effective_date,
3456: p_datetrack_mode => p_datetrack_mode,
3457: p_base_table_name => 'ben_elig_per_opt_f',
3458: p_base_key_column => 'elig_per_opt_id',

Line 3988: dt_api.get_object_version_number

3984: -- Because we are updating a row we must get the next object
3985: -- version number.
3986: --
3987: p_rec.object_version_number :=
3988: dt_api.get_object_version_number
3989: (p_base_table_name => 'ben_elig_per_opt_f',
3990: p_base_key_column => 'elig_per_opt_id',
3991: p_base_key_value => p_rec.elig_per_opt_id);
3992: --