DBA Data[Home] [Help]

APPS.BIM_DBI_MKTG_MGMT_PVT dependencies on FND_PROFILE

Line 4: l_prog_view CONSTANT varchar2(1) := fnd_profile.VALUE('BIM_VIEW_PROGRAM');

1: PACKAGE BODY BIM_DBI_MKTG_MGMT_PVT AS
2: /* $Header: bimvsqlb.pls 120.24 2006/05/16 02:02:14 arvikuma noship $ */
3:
4: l_prog_view CONSTANT varchar2(1) := fnd_profile.VALUE('BIM_VIEW_PROGRAM');
5:
6: l_prog_cost CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_PROG_COST');
7: l_cost_type CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_COST_PER_LEAD');
8: l_revenue CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_REVENUE');

Line 6: l_prog_cost CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_PROG_COST');

2: /* $Header: bimvsqlb.pls 120.24 2006/05/16 02:02:14 arvikuma noship $ */
3:
4: l_prog_view CONSTANT varchar2(1) := fnd_profile.VALUE('BIM_VIEW_PROGRAM');
5:
6: l_prog_cost CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_PROG_COST');
7: l_cost_type CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_COST_PER_LEAD');
8: l_revenue CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_REVENUE');
9: l_csch_mode CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_CSCH_OA_JTF');
10:

Line 7: l_cost_type CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_COST_PER_LEAD');

3:
4: l_prog_view CONSTANT varchar2(1) := fnd_profile.VALUE('BIM_VIEW_PROGRAM');
5:
6: l_prog_cost CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_PROG_COST');
7: l_cost_type CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_COST_PER_LEAD');
8: l_revenue CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_REVENUE');
9: l_csch_mode CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_CSCH_OA_JTF');
10:
11: L_viewby_c CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_CONTEXT_VIEWBY('COUNTRY');

Line 8: l_revenue CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_REVENUE');

4: l_prog_view CONSTANT varchar2(1) := fnd_profile.VALUE('BIM_VIEW_PROGRAM');
5:
6: l_prog_cost CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_PROG_COST');
7: l_cost_type CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_COST_PER_LEAD');
8: l_revenue CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_REVENUE');
9: l_csch_mode CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_CSCH_OA_JTF');
10:
11: L_viewby_c CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_CONTEXT_VIEWBY('COUNTRY');
12: L_viewby_pc CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_CONTEXT_VIEWBY('ENI_ITEM_VBH_CAT');

Line 9: l_csch_mode CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_CSCH_OA_JTF');

5:
6: l_prog_cost CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_PROG_COST');
7: l_cost_type CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_COST_PER_LEAD');
8: l_revenue CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_REVENUE');
9: l_csch_mode CONSTANT varchar2(50) := fnd_profile.VALUE('BIM_CSCH_OA_JTF');
10:
11: L_viewby_c CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_CONTEXT_VIEWBY('COUNTRY');
12: L_viewby_pc CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_CONTEXT_VIEWBY('ENI_ITEM_VBH_CAT');
13: L_viewby_r CONSTANT varchar2(100):=BIM_PMV_DBI_UTL_PKG.GET_CONTEXT_VIEWBY('REGION');