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 1543: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),

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

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

1953: p_vrbl_rt_prfl_id => null,
1954: p_legal_entity_id => null,
1955: p_payroll_id => null,
1956: p_commit_data => 'N',
1957: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),
1958: p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt );
1959: --
1960: hr_utility.set_location(l_package ||' After process',10);
1961: --

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

2248: p_vrbl_rt_prfl_id => null,
2249: p_legal_entity_id => null,
2250: p_payroll_id => null,
2251: p_commit_data => 'N',
2252: p_lmt_prpnip_by_org_flag => nvl(fnd_profile.value('BEN_LMT_PRPNIP_BY_ORG_FLAG'), 'N'),
2253: p_lf_evt_ocrd_dt => l_effective_date );
2254: --
2255: hr_utility.set_location('After process',10);
2256: hr_utility.set_location('Before get_parameter',21);

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

2783: p_return_status := 'S';
2784: l_trace_param := null;
2785: l_trace_on := false;
2786: --
2787: l_trace_param := fnd_profile.value('BEN_SS_TRACE_VALUE');
2788: --
2789:
2790: if l_trace_param = 'BENOLLET' then
2791: l_trace_on := true;