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');
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:
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');
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');
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');