APPS.BEN_PLAN_DESIGN_TXNS_API dependencies on FND_PROFILE

Line 418: fnd_profile.get( NAME => 'ICX_DATE_FORMAT_MASK'

414: if p_action_date <> hr_api.g_date and
415: p_action_date < l_ben_start_date
416: then
417: --
418: fnd_profile.get( NAME => 'ICX_DATE_FORMAT_MASK'
419: ,VAL => l_icx_date_format_mask );
420: --
421: fnd_message.set_name('BEN', 'BEN_94216_EFF_DATE_INCORRECT');
422: fnd_message.set_token('DATE', to_char(l_ben_start_date, l_icx_date_format_mask));

Line 2329: from FND_PROFILE_OPTION_VALUES optval,

2325: and business_group_id is not null ;
2326: /* Bug 3170928 Changes
2327: cursor c_get_user_resp_value(p_user_id number) is
2328: select optval.PROFILE_OPTION_VALUE
2329: from FND_PROFILE_OPTION_VALUES optval,
2330: fnd_profile_options_vl opt,
2331: FND_USER_RESP_GROUPS resp
2332: where opt.profile_option_id = optval.profile_option_id
2333: and optval.level_value = resp.RESPONSIBILITY_ID

Line 2330: fnd_profile_options_vl opt,

2326: /* Bug 3170928 Changes
2327: cursor c_get_user_resp_value(p_user_id number) is
2328: select optval.PROFILE_OPTION_VALUE
2329: from FND_PROFILE_OPTION_VALUES optval,
2330: fnd_profile_options_vl opt,
2331: FND_USER_RESP_GROUPS resp
2332: where opt.profile_option_id = optval.profile_option_id
2333: and optval.level_value = resp.RESPONSIBILITY_ID
2334: and resp.user_id = p_user_id

Line 2363: p_business_group_ids := p_business_group_ids||','''||FND_PROFILE.VALUE_SPECIFIC(

2359: */
2360: --
2361: for l_rec in c_get_user_resp_value(p_user_id) loop
2362: --
2363: p_business_group_ids := p_business_group_ids||','''||FND_PROFILE.VALUE_SPECIFIC(
2364: NAME => 'PER_BUSINESS_GROUP_ID'
2365: ,USER_ID => l_rec.user_id
2366: ,RESPONSIBILITY_ID => l_rec.responsibility_id
2367: ,APPLICATION_ID => l_rec.application_id

Line 2601: fnd_profile.get( NAME => 'ICX_DATE_FORMAT_MASK',

2597: -- Update target details to ben_copy_entity_results_table
2598: update_cer_with_target(p_copy_entity_txn_id);
2599:
2600: -- Bug 4317567
2601: fnd_profile.get( NAME => 'ICX_DATE_FORMAT_MASK',
2602: VAL => l_icx_date_format_mask );
2603: --
2604: l_icx_date_format_mask := nvl(l_icx_date_format_mask, 'DD/MM/YYYY');
2605: -- Bug 4317567