DBA Data[Home] [Help]

APPS.BEN_EXT_FMT dependencies on BEN_EXT_ADV_CONDITIONS

Line 4540: ben_ext_adv_conditions.chg_evt_incl

4536: --
4537: --
4538: if p_data_typ_cd = 'C' then -- changes only extract
4539: --
4540: ben_ext_adv_conditions.chg_evt_incl
4541: (p_ext_data_elmt_in_rcd_id => elmt.ext_data_elmt_in_rcd_id,
4542: p_data_elmt_seq_num => elmt.seq_num,
4543: p_chg_evt_cd => p_chg_evt_cd,
4544: p_exclude_flag => l_exclude_flag);

Line 4555: ben_ext_adv_conditions.data_elmt_in_rcd

4551: --
4552: END LOOP;
4553: --
4554: if g_rqd_elmt_is_present = 'Y' then
4555: ben_ext_adv_conditions.data_elmt_in_rcd
4556: (p_ext_rcd_id => l_ext_rcd_id,
4557: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4558: --
4559: if l_exclude_this_rcd_flag = true then

Line 4564: ben_ext_adv_conditions.rcd_in_file

4560: l_write_rcd := 'N';
4561: end if;
4562: --
4563: if l_write_rcd = 'Y' then
4564: ben_ext_adv_conditions.rcd_in_file
4565: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4566: p_sprs_cd => ben_extract.gtt_rcd_typ_vals(i).sprs_cd,
4567: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4568: --

Line 4576: ben_ext_adv_conditions.chg_evt_incl

4572: --
4573: end if;
4574: --
4575: if l_write_rcd = 'Y' and p_data_typ_cd = 'C' then -- changes only extract
4576: ben_ext_adv_conditions.chg_evt_incl
4577: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4578: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4579: p_chg_evt_cd => p_chg_evt_cd,
4580: p_exclude_flag => l_exclude_flag);

Line 4611: ben_ext_adv_conditions.prevent_duplicates

4607: end if ;
4608: --
4609:
4610: if l_write_rcd = 'Y' then
4611: ben_ext_adv_conditions.prevent_duplicates
4612: (p_ext_rslt_id => p_ext_rslt_id,
4613: p_person_id => p_person_id,
4614: p_any_or_all_cd => ben_extract.gtt_rcd_typ_vals(i).any_or_all_cd,
4615: p_ext_rcd_id => l_ext_rcd_id,

Line 4655: ben_ext_adv_conditions.chg_rcd_merge

4651: l_ext_chg_rcd_mode := 'C' ;
4652: if p_data_typ_cd = 'C' and l_chg_rcd_upd_flag = 'Y' then
4653: -- of the record to be sonsoldated for change event extract
4654:
4655: ben_ext_adv_conditions.chg_rcd_merge
4656: (p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
4657: ,p_ext_rslt_id => p_ext_rslt_id
4658: ,p_ext_rcd_id => l_ext_rcd_id
4659: ,p_person_id => p_person_id