DBA Data[Home] [Help]

APPS.BEN_ADD_LER dependencies on BENUTILS

Line 144: benutils.set_data_migrator_mode;

140: l_trigger boolean := TRUE;
141: --
142: begin
143: -- Bug 2016857
144: benutils.set_data_migrator_mode;
145: --
146: if hr_general.g_data_migrator_mode in ( 'Y','P') then
147: --
148: return;

Line 259: benutils.exec_rule(

255: l_col_old_val := p_old.address_type;
256: l_col_new_val := p_new.address_type;
257: end if;
258: --
259: benutils.exec_rule(
260: p_formula_id => l_per_info_chg_cs_ler_rl,
261: p_effective_date => l_session_date,
262: p_lf_evt_ocrd_dt => null,
263: p_business_group_id => nvl(p_new.business_group_id, p_old.business_group_id),

Line 306: l_changed := (benutils.column_changed(p_old.date_from

302: --
303:
304: --
305: if l_column = 'DATE_FROM' then
306: l_changed := (benutils.column_changed(p_old.date_from
307: ,p_new.date_from,l_new_val) AND
308: benutils.column_changed(p_new.date_from
309: ,p_old.date_from,l_old_val) AND
310: (l_changed));

Line 308: benutils.column_changed(p_new.date_from

304: --
305: if l_column = 'DATE_FROM' then
306: l_changed := (benutils.column_changed(p_old.date_from
307: ,p_new.date_from,l_new_val) AND
308: benutils.column_changed(p_new.date_from
309: ,p_old.date_from,l_old_val) AND
310: (l_changed));
311: hr_utility.set_location(' l_changed:',40);
312: end if;

Line 315: l_changed := (benutils.column_changed(p_old.date_to

311: hr_utility.set_location(' l_changed:',40);
312: end if;
313: --
314: if l_column = 'DATE_TO' then
315: l_changed := (benutils.column_changed(p_old.date_to
316: ,p_new.date_to,l_new_val) AND
317: benutils.column_changed(p_new.date_to
318: ,p_old.date_to,l_old_val) AND
319: (l_changed));

Line 317: benutils.column_changed(p_new.date_to

313: --
314: if l_column = 'DATE_TO' then
315: l_changed := (benutils.column_changed(p_old.date_to
316: ,p_new.date_to,l_new_val) AND
317: benutils.column_changed(p_new.date_to
318: ,p_old.date_to,l_old_val) AND
319: (l_changed));
320: --
321: if l_ocrd_dt_cd is null then

Line 338: l_changed := (benutils.column_changed(p_old.primary_flag

334: --
335: end if;
336: --
337: if l_column = 'PRIMARY_FLAG' then
338: l_changed := (benutils.column_changed(p_old.primary_flag
339: ,p_new.primary_flag,l_new_val) AND
340: benutils.column_changed(p_new.primary_flag
341: ,p_old.primary_flag,l_old_val) AND
342: (l_changed));

Line 340: benutils.column_changed(p_new.primary_flag

336: --
337: if l_column = 'PRIMARY_FLAG' then
338: l_changed := (benutils.column_changed(p_old.primary_flag
339: ,p_new.primary_flag,l_new_val) AND
340: benutils.column_changed(p_new.primary_flag
341: ,p_old.primary_flag,l_old_val) AND
342: (l_changed));
343: end if;
344: --

Line 346: l_changed := (benutils.column_changed(p_old.postal_code

342: (l_changed));
343: end if;
344: --
345: if l_column = 'POSTAL_CODE' then
346: l_changed := (benutils.column_changed(p_old.postal_code
347: ,p_new.postal_code,l_new_val) AND
348: benutils.column_changed(p_new.postal_code
349: ,p_old.postal_code,l_old_val) );
350: end if;

Line 348: benutils.column_changed(p_new.postal_code

344: --
345: if l_column = 'POSTAL_CODE' then
346: l_changed := (benutils.column_changed(p_old.postal_code
347: ,p_new.postal_code,l_new_val) AND
348: benutils.column_changed(p_new.postal_code
349: ,p_old.postal_code,l_old_val) );
350: end if;
351: --
352: if l_column = 'REGION_2' then

Line 353: l_changed := (benutils.column_changed(p_old.region_2

349: ,p_old.postal_code,l_old_val) );
350: end if;
351: --
352: if l_column = 'REGION_2' then
353: l_changed := (benutils.column_changed(p_old.region_2
354: ,p_new.region_2,l_new_val) AND
355: benutils.column_changed(p_new.region_2
356: ,p_old.region_2,l_old_val) );
357: end if;

Line 355: benutils.column_changed(p_new.region_2

351: --
352: if l_column = 'REGION_2' then
353: l_changed := (benutils.column_changed(p_old.region_2
354: ,p_new.region_2,l_new_val) AND
355: benutils.column_changed(p_new.region_2
356: ,p_old.region_2,l_old_val) );
357: end if;
358: --
359: if l_column = 'ADDRESS_TYPE' then

Line 360: l_changed := (benutils.column_changed(p_old.address_type

356: ,p_old.region_2,l_old_val) );
357: end if;
358: --
359: if l_column = 'ADDRESS_TYPE' then
360: l_changed := (benutils.column_changed(p_old.address_type
361: ,p_new.address_type,l_new_val) AND
362: benutils.column_changed(p_new.address_type
363: ,p_old.address_type,l_old_val) );
364: end if;

Line 362: benutils.column_changed(p_new.address_type

358: --
359: if l_column = 'ADDRESS_TYPE' then
360: l_changed := (benutils.column_changed(p_old.address_type
361: ,p_new.address_type,l_new_val) AND
362: benutils.column_changed(p_new.address_type
363: ,p_old.address_type,l_old_val) );
364: end if;
365: --
366: