DBA Data[Home] [Help]

APPS.BEN_PROVIDER_POOLS dependencies on BEN_EPE_SHD

Line 516: l_epe ben_epe_shd.g_rec_type;

512: epe.cmbn_ptip_id,
513: epe.cmbn_ptip_opt_id ;
514:
515:
516: l_epe ben_epe_shd.g_rec_type;
517: --
518: l_bnft_prvdd_ldgr_id number;
519: l_prtt_enrt_rslt_id number;
520: l_prtt_rt_val_id number;

Line 572: p_epe_rec in ben_epe_shd.g_rec_type,

568: --------------------------------------------------------------------------------
569: procedure accumulate_pools_for_choice(
570: p_validate in boolean default false,
571: p_person_id in number,
572: p_epe_rec in ben_epe_shd.g_rec_type,
573: p_enrt_mthd_cd in varchar2,
574: p_effective_date in date
575: ) is
576: --

Line 620: p_epe_rec ben_epe_shd.g_rec_type,

616: -- person_enrolled_in_choice
617: --------------------------------------------------------------------------------
618: function person_enrolled_in_choice(
619: p_person_id number,
620: p_epe_rec ben_epe_shd.g_rec_type,
621: p_old_result_id number default hr_api.g_number,
622: p_effective_date date) return boolean is
623:
624: l_proc varchar2(72) := g_package||'.person_enrolled_in_choice';

Line 978: l_epe_rec ben_epe_shd.g_rec_type;

974: p_effective_date in date
975: )
976: is
977: l_proc varchar2(72) := g_package||'.create_credit_ledger_entry';
978: l_epe_rec ben_epe_shd.g_rec_type;
979: l_bnft_prvdd_ldgr_id number;
980: l_dummy_number number;
981: l_pgm_id number;
982: --

Line 1032: ,p_epe_rec in ben_epe_shd.g_rec_type

1028: procedure create_credit_ledger_entry
1029: (p_validate in boolean default null
1030: ,p_calculate_only_mode in boolean default false
1031: ,p_person_id in number
1032: ,p_epe_rec in ben_epe_shd.g_rec_type
1033: ,p_enrt_mthd_cd in varchar2
1034: ,p_effective_date in date
1035: --
1036: ,p_bnft_prvdd_ldgr_id out nocopy number -- to pass back created id

Line 1285: l_epe_rec ben_epe_shd.g_rec_type;

1281: )
1282: is
1283:
1284: l_proc varchar2(72) := g_package||'.create_debit_ledger_entry';
1285: l_epe_rec ben_epe_shd.g_rec_type;
1286: l_ecr_rec ben_ecr_shd.g_rec_type;
1287: l_prtt_enrt_rslt_id number;
1288: l_prtt_rt_val_id number;
1289: l_pgm_id number;

Line 1363: ,p_epe_rec in ben_epe_shd.g_rec_type

1359: (p_validate in boolean default false
1360: ,p_calculate_only_mode in boolean default false
1361: ,p_person_id in number
1362: ,p_enrt_mthd_cd in varchar2
1363: ,p_epe_rec in ben_epe_shd.g_rec_type
1364: ,p_enrt_rt_rec in ben_ecr_shd.g_rec_type
1365: ,p_bnft_prvdd_ldgr_id in out nocopy number -- to pass back created id
1366: ,p_business_group_id in number
1367: ,p_effective_date in date

Line 1526: l_epe ben_epe_shd.g_rec_type;

1522: p_effective_date in date,
1523: p_business_group_id in number
1524: ) is
1525: l_proc varchar2(72) := g_package||'.cleanup_invalid_ledger_entries';
1526: l_epe ben_epe_shd.g_rec_type;
1527: l_rt_usg_cd varchar2(30);
1528: l_bnft_prvdd_ldgr_id number;
1529: l_ldgr_id number;
1530: l_per_in_ler_id number;

Line 2015: l_epe ben_epe_shd.g_rec_type;

2011: p_effective_date in date,
2012: p_business_group_id in number
2013: ) is
2014: l_proc varchar2(72) := g_package||'.cleanup_invalid_ledger_entries';
2015: l_epe ben_epe_shd.g_rec_type;
2016: l_rt_usg_cd varchar2(30);
2017: l_bnft_prvdd_ldgr_id number;
2018: l_person_enrolled boolean;
2019: l_effective_start_date date;

Line 6602: l_epe_rec ben_epe_shd.g_rec_type;

6598: l_rt_val number;
6599: l_uses_net_crs_mthd boolean := false;
6600: l_prv_exists boolean := false;
6601: l_def_exc_amount number := 0;
6602: l_epe_rec ben_epe_shd.g_rec_type;
6603: l_dummy_number number;
6604: l_rt_strt_dt date;
6605: --
6606: cursor c_pgm is