APPS.BIS_PMF_GET_DIMLEVELS_PVT dependencies on BIS_PMF_GET_DIMLEVELS_PVT

Line 1: PACKAGE BODY BIS_PMF_GET_DIMLEVELS_PVT AS

1: PACKAGE BODY BIS_PMF_GET_DIMLEVELS_PVT AS
2: /* $Header: BISVGDLB.pls 120.19 2007/12/27 13:33:25 lbodired ship $ */
3: /*
4: REM dbdrv: sql ~PROD ~PATH ~FILE none none none package &phase=plb \
5: REM dbdrv: checkfile:~PROD:~PATH:~FILE

Line 78: G_PKG_NAME VARCHAR2(200) := 'BIS_PMF_GET_DIMLEVELS_PVT';

74: EDW_ACCT_FLEXFIELD VARCHAR2(200) := 'EDW_GL_ACCT';
75: EDW_LVL_TBL_SUFFIX VARCHAR2(200) := '_LTC';
76: EDW_LVL_FLEX_PK_SUFFIX VARCHAR2(200) := '_NAME';
77: EDW_PK_KEY VARCHAR2(200) := '%PK_KEY';
78: G_PKG_NAME VARCHAR2(200) := 'BIS_PMF_GET_DIMLEVELS_PVT';
79: G_DIM_LEVEL_SELECT_INFO_REC BIS_PMF_GET_DIMLEVELS_PVT.dim_level_select_rec_Type;
80:
81: G_PMF_BIND_VAR VARCHAR2(200) := ':PARENT_DIMLVL_VALUE_ID';
82: G_BIND_INTEGER NUMBER(2) := 1;

Line 79: G_DIM_LEVEL_SELECT_INFO_REC BIS_PMF_GET_DIMLEVELS_PVT.dim_level_select_rec_Type;

75: EDW_LVL_TBL_SUFFIX VARCHAR2(200) := '_LTC';
76: EDW_LVL_FLEX_PK_SUFFIX VARCHAR2(200) := '_NAME';
77: EDW_PK_KEY VARCHAR2(200) := '%PK_KEY';
78: G_PKG_NAME VARCHAR2(200) := 'BIS_PMF_GET_DIMLEVELS_PVT';
79: G_DIM_LEVEL_SELECT_INFO_REC BIS_PMF_GET_DIMLEVELS_PVT.dim_level_select_rec_Type;
80:
81: G_PMF_BIND_VAR VARCHAR2(200) := ':PARENT_DIMLVL_VALUE_ID';
82: G_BIND_INTEGER NUMBER(2) := 1;
83: G_BIND_VARCHAR2 NUMBER(2) := 2;

Line 319: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING

315: --IF (fnd_profile.value('BIS_SOURCE') = 'EDW')
316: IF ((l_source = 'EDW') and
317: (l_level_values_view_name IS NULL))-- OR l_level_values_view_name='AAA'))
318: THEN
319: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING
320: (p_dim_level_name => p_DimLevelName
321: ,p_source => l_source
322: ,x_table_name => x_table_name
323: ,x_id_name => x_id_name

Line 332: BIS_PMF_GET_DIMLEVELS_PVT.GET_BIS_SELECT_STRING

328: ,x_msg_count => x_msg_count
329: ,x_msg_data => x_msg_data
330: );
331: ELSE
332: BIS_PMF_GET_DIMLEVELS_PVT.GET_BIS_SELECT_STRING
333: (p_dim_level_name => p_DimLevelName
334: ,p_source => l_source
335: ,p_add_distinct => p_add_distinct
336: ,x_table_name => x_table_name

Line 482: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING

478: --END IF;
479: --IF (fnd_profile.value('BIS_SOURCE') = 'EDW')
480: IF ((l_source = 'EDW') and (l_level_values_view_name IS NULL))
481: THEN
482: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING
483: (p_dim_level_name => p_DimLevelName
484: ,p_source => l_source
485: ,x_table_name => x_table_name
486: ,x_id_name => x_id_name

Line 495: BIS_PMF_GET_DIMLEVELS_PVT.GET_BIS_SELECT_STRING

491: ,x_msg_count => x_msg_count
492: ,x_msg_data => x_msg_data
493: );
494: ELSE
495: BIS_PMF_GET_DIMLEVELS_PVT.GET_BIS_SELECT_STRING
496: (p_dim_level_name => p_DimLevelName
497: ,p_source => l_source
498: ,x_table_name => x_table_name
499: ,x_id_name => x_id_name

Line 639: IF (BIS_PMF_GET_DIMLEVELS_PVT.isAccounting_Flexfield(l_lvlshortname))

635: FND_MESSAGE.SET_TOKEN('DIMLEVEL_SHORT_NAME',p_dim_level_name);
636: FND_MSG_PUB.ADD;
637: RAISE FND_API.G_EXC_ERROR;
638: END;
639: IF (BIS_PMF_GET_DIMLEVELS_PVT.isAccounting_Flexfield(l_lvlshortname))
640: THEN
641: l_pkkey := l_prefix||EDW_LVL_FLEX_PK_SUFFIX;
642: l_tablename := l_dimshortname;
643: l_distinct := ' DISTINCT ';

Line 1059: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING

1055: CLOSE c_dims;
1056: --IF (fnd_profile.value('BIS_SOURCE') = 'EDW')
1057: IF ((l_source = 'EDW') AND (l_level_Values_view_name IS NULL))
1058: THEN
1059: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING
1060: (p_dim_level_name => l_Short_name
1061: ,p_source => l_source
1062: ,x_table_name => x_table_name
1063: ,x_id_name => x_id_name

Line 1072: BIS_PMF_GET_DIMLEVELS_PVT.GET_BIS_SELECT_STRING

1068: ,x_msg_count => x_msg_count
1069: ,x_msg_data => x_msg_data
1070: );
1071: ELSE
1072: BIS_PMF_GET_DIMLEVELS_PVT.GET_BIS_SELECT_STRING
1073: (p_dim_level_name => l_short_name
1074: ,p_source => l_source
1075: ,x_table_name => x_table_name
1076: ,x_id_name => x_id_name

Line 1628: BIS_PMF_GET_DIMLEVELS_PVT.Get_Bsc_Dim_Obj_details

1624: BEGIN
1625:
1626: l_relation_type := p_dim_rel_info_rec.relation_type;
1627:
1628: BIS_PMF_GET_DIMLEVELS_PVT.Get_Bsc_Dim_Obj_details
1629: (
1630: p_dim_rel_info_rec => p_dim_rel_info_rec
1631: ,p_region_code => p_region_code
1632: ,x_child_level_pk_col => l_child_level_pk_col

Line 1959: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING

1955: END IF;
1956: CLOSE c_bis_levels_source;
1957:
1958: IF ((p_Source = G_EDW) AND (l_data_source IS NULL)) THEN
1959: BIS_PMF_GET_DIMLEVELS_PVT.GET_EDW_SELECT_STRING
1960: (p_dim_level_name => p_Dim_Level_Short_Name
1961: ,p_source => p_Source
1962: ,x_table_name => x_table_name
1963: ,x_id_name => x_id_name

Line 2210: END BIS_PMF_GET_DIMLEVELS_PVT;

2206:
2207:
2208: --======================================================================
2209:
2210: END BIS_PMF_GET_DIMLEVELS_PVT;