DBA Data[Home] [Help]

APPS.BIL_BI_SALES_MGMT_RPTS_PKG dependencies on BIL_BI_SALES_MGMT_RPTS_PKG

Line 1: PACKAGE BODY BIL_BI_SALES_MGMT_RPTS_PKG AS

1: PACKAGE BODY BIL_BI_SALES_MGMT_RPTS_PKG AS
2: /* $Header: bilbssb.pls 120.16 2006/01/13 04:18:02 hrpandey noship $ */
3:
4: g_pkg VARCHAR2(100);
5: g_sch_name VARCHAR2(100);

Line 107: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';

103: l_len NUMBER;
104:
105: BEGIN
106:
107: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';
108: l_proc := 'BIL_BI_SALES_MGMT_SUMRY.';
109: l_rpt_str := 'BIL_BI_SLSMGMT_R';
110: l_parameter_valid := FALSE;
111: l_region_id := 'BIL_BI_SALES_MGMT_SUMRY';

Line 1286: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';

1282: l_inner_where_pipe varchar2(4000);
1283:
1284:
1285: BEGIN
1286: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';
1287: l_region_id:= 'BIL_BI_OPPTY_OVERVIEW';
1288: l_parameter_valid:= FALSE;
1289: l_proc := 'BIL_BI_OPPTY_OVERVIEW.';
1290: l_yes := 'Y';

Line 2947: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';

2943:
2944:
2945:
2946: BEGIN
2947: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';
2948: l_region_id:= 'BIL_BI_OPPTY_OVERVIEW';
2949: l_parameter_valid:= FALSE;
2950: l_proc := 'BIL_BI_OPPTY_OVERVIEW.';
2951: l_yes := 'Y';

Line 3966: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';

3962: l_len NUMBER;
3963:
3964: BEGIN
3965:
3966: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';
3967: l_region_id := 'BIL_BI_GRP_FRCST';
3968: l_proc := 'BIL_BI_GRP_FRCST.';
3969: l_parameter_valid := FALSE;
3970: l_yes := 'Y';

Line 4396: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';

4392:
4393:
4394: BEGIN
4395:
4396: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';
4397: l_region_id := 'BIL_BI_OPEN_LDOPBKLOG';
4398: l_parameter_valid:= FALSE;
4399: l_proc := 'BIL_BI_OPEN_LDOPBKLOG.';
4400: l_yes :='Y';

Line 6004: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';

6000:
6001:
6002: BEGIN
6003:
6004: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';
6005: l_region_id := 'BIL_BI_LEAD_OPP_CAMP';
6006: l_parameter_valid := FALSE;
6007: l_proc := 'BIL_LDOPP_CAMP.';
6008: l_category_set:='CATEGORY_SET';

Line 6817: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';

6813: x_custom_attr := BIS_QUERY_ATTRIBUTES_TBL();
6814: l_custom_rec := BIS_PMV_PARAMETERS_PUB.INITIALIZE_QUERY_TYPE;
6815: l_bind_ctr := 1;
6816: l_parameter_valid := TRUE;
6817: g_pkg := 'bil.patch.115.sql.BIL_BI_SALES_MGMT_RPTS_PKG.';
6818: l_region_id := 'BIL_BI_SLS_PERF';
6819: l_proc := 'BIL_BI_SLS_PERF.';
6820: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
6821: FND_LOG.STRING(LOG_LEVEL => fnd_log.LEVEL_PROCEDURE,

Line 7654: END BIL_BI_SALES_MGMT_RPTS_PKG;

7650:
7651:
7652:
7653:
7654: END BIL_BI_SALES_MGMT_RPTS_PKG;