APPS.BEN_ON_LINE_LF_EVT dependencies on FND_PROFILE

Line 42: username varchar2(50) := fnd_profile.value('USERNAME');

38: select to_char(WF_ERROR_PROCESSES_S.NEXTVAL)
39: from SYS.DUAL;
40: --
41: ItemKey varchar2(240);
42: username varchar2(50) := fnd_profile.value('USERNAME');
43: ItemType varchar2(30) := 'BEN_OLLE';
44: process varchar2(100) := 'ON_LINE_LIFE_EVENT_PROC';
45: l_ben_seq number;
46: l_package varchar2(80) := g_package||'.Start_on_line_lf_evt_proc';

Line 67: fnd_profile.value('USERNAME'));

63: --
64: -- Populate "special" attributes, if they exist
65: begin
66: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'USER_NAME',
67: fnd_profile.value('USERNAME'));
68: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'USER_ID',
69: fnd_profile.value('USER_ID'));
70: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'RESP_ID',
71: fnd_profile.value('RESP_ID'));

Line 69: fnd_profile.value('USER_ID'));

65: begin
66: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'USER_NAME',
67: fnd_profile.value('USERNAME'));
68: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'USER_ID',
69: fnd_profile.value('USER_ID'));
70: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'RESP_ID',
71: fnd_profile.value('RESP_ID'));
72: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'RESP_APPL_ID',
73: fnd_profile.value('RESP_APPL_ID'));

Line 71: fnd_profile.value('RESP_ID'));

67: fnd_profile.value('USERNAME'));
68: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'USER_ID',
69: fnd_profile.value('USER_ID'));
70: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'RESP_ID',
71: fnd_profile.value('RESP_ID'));
72: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'RESP_APPL_ID',
73: fnd_profile.value('RESP_APPL_ID'));
74: exception
75: when others then

Line 73: fnd_profile.value('RESP_APPL_ID'));

69: fnd_profile.value('USER_ID'));
70: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'RESP_ID',
71: fnd_profile.value('RESP_ID'));
72: Wf_Engine.SetItemAttrText(itemtype, itemkey, 'RESP_APPL_ID',
73: fnd_profile.value('RESP_APPL_ID'));
74: exception
75: when others then
76: null;
77: end;

Line 656: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),

652: p_vrbl_rt_prfl_id => null,
653: p_legal_entity_id => null,
654: p_payroll_id => null,
655: p_commit_data => 'N',
656: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),
657: p_lf_evt_ocrd_dt => l_effective_date );
658: --
659: ben_comp_object_list.build_comp_object_list
660: (p_benefit_action_id => benutils.g_benefit_action_id,

Line 1544: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),

1540: p_vrbl_rt_prfl_id => null,
1541: p_legal_entity_id => null,
1542: p_payroll_id => null,
1543: p_commit_data => 'N',
1544: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),
1545: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt ); -- GLOBAL CWB l_effective_date );
1546: --
1547: hr_utility.set_location('After process',10);
1548: hr_utility.set_location('Before get_parameter',21);

Line 1969: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),

1965: p_vrbl_rt_prfl_id => null,
1966: p_legal_entity_id => null,
1967: p_payroll_id => null,
1968: p_commit_data => 'N',
1969: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),
1970: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt );
1971: --
1972: hr_utility.set_location(l_package ||' After process',10);
1973: --

Line 2264: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),

2260: p_vrbl_rt_prfl_id => null,
2261: p_legal_entity_id => null,
2262: p_payroll_id => null,
2263: p_commit_data => 'N',
2264: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),
2265: p_lf_evt_ocrd_dt => l_effective_date );
2266: --
2267: hr_utility.set_location('After process',10);
2268: hr_utility.set_location('Before get_parameter',21);

Line 2822: l_trace_param := fnd_profile.value('BEN_SS_TRACE_VALUE');

2818: p_return_status := 'S';
2819: l_trace_param := null;
2820: l_trace_on := false;
2821: --
2822: l_trace_param := fnd_profile.value('BEN_SS_TRACE_VALUE');
2823: --
2824:
2825: if l_trace_param = 'BENOLLET' then
2826: l_trace_on := true;