DBA Data[Home] [Help]

APPS.BEN_EXT_FMT dependencies on BEN_EXT_ADV_CONDITIONS

Line 4534: ben_ext_adv_conditions.chg_evt_incl

4530: --
4531: --
4532: if p_data_typ_cd = 'C' then -- changes only extract
4533: --
4534: ben_ext_adv_conditions.chg_evt_incl
4535: (p_ext_data_elmt_in_rcd_id => elmt.ext_data_elmt_in_rcd_id,
4536: p_data_elmt_seq_num => elmt.seq_num,
4537: p_chg_evt_cd => p_chg_evt_cd,
4538: p_exclude_flag => l_exclude_flag);

Line 4549: ben_ext_adv_conditions.data_elmt_in_rcd

4545: --
4546: END LOOP;
4547: --
4548: if g_rqd_elmt_is_present = 'Y' then
4549: ben_ext_adv_conditions.data_elmt_in_rcd
4550: (p_ext_rcd_id => l_ext_rcd_id,
4551: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4552: --
4553: if l_exclude_this_rcd_flag = true then

Line 4558: ben_ext_adv_conditions.rcd_in_file

4554: l_write_rcd := 'N';
4555: end if;
4556: --
4557: if l_write_rcd = 'Y' then
4558: ben_ext_adv_conditions.rcd_in_file
4559: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4560: p_sprs_cd => ben_extract.gtt_rcd_typ_vals(i).sprs_cd,
4561: p_exclude_this_rcd_flag => l_exclude_this_rcd_flag);
4562: --

Line 4570: ben_ext_adv_conditions.chg_evt_incl

4566: --
4567: end if;
4568: --
4569: if l_write_rcd = 'Y' and p_data_typ_cd = 'C' then -- changes only extract
4570: ben_ext_adv_conditions.chg_evt_incl
4571: (p_ext_rcd_in_file_id => ben_extract.gtt_rcd_typ_vals(i).ext_rcd_in_file_id,
4572: p_rcd_seq_num => ben_extract.gtt_rcd_typ_vals(i).seq_num,
4573: p_chg_evt_cd => p_chg_evt_cd,
4574: p_exclude_flag => l_exclude_flag);

Line 4605: ben_ext_adv_conditions.prevent_duplicates

4601: end if ;
4602: --
4603:
4604: if l_write_rcd = 'Y' then
4605: ben_ext_adv_conditions.prevent_duplicates
4606: (p_ext_rslt_id => p_ext_rslt_id,
4607: p_person_id => p_person_id,
4608: p_any_or_all_cd => ben_extract.gtt_rcd_typ_vals(i).any_or_all_cd,
4609: p_ext_rcd_id => l_ext_rcd_id,

Line 4649: ben_ext_adv_conditions.chg_rcd_merge

4645: l_ext_chg_rcd_mode := 'C' ;
4646: if p_data_typ_cd = 'C' and l_chg_rcd_upd_flag = 'Y' then
4647: -- of the record to be sonsoldated for change event extract
4648:
4649: ben_ext_adv_conditions.chg_rcd_merge
4650: (p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
4651: ,p_ext_rslt_id => p_ext_rslt_id
4652: ,p_ext_rcd_id => l_ext_rcd_id
4653: ,p_person_id => p_person_id