DBA Data[Home] [Help]

APPS.BIS_VG_DESC_FLEX dependencies on BIS_VIEW_GENERATOR_PVT

Line 87: IF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9.2' THEN

83:
84: BEGIN
85: rv.global_context := 0;
86: -- Bug 6819715
87: IF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9.2' THEN
88: FOR context_rec IN context_c_with_hints LOOP
89: i := i + 1;
90: rv.context_code(i) := context_rec.descriptive_flex_context_code;
91: rv.context_name(i) := context_rec.descriptive_flex_context_name;

Line 116: ELSIF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9i' THEN

112: 'fnd.plsql.BIS_VG_DESC_FLEX.GET_CONTENTS',
113: 'is global is '||context_rec.global_flag);
114: end if;
115: END LOOP;
116: ELSIF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = '9i' THEN
117: FOR context_rec IN context_c LOOP
118: i := i + 1;
119: rv.context_code(i) := context_rec.descriptive_flex_context_code;
120: rv.context_name(i) := context_rec.descriptive_flex_context_name;

Line 145: ELSIF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = 'NEW' THEN

141: 'fnd.plsql.BIS_VG_DESC_FLEX.GET_CONTENTS',
142: 'is global is '||context_rec.global_flag);
143: end if;
144: END LOOP;
145: ELSIF BIS_VIEW_GENERATOR_PVT.g_use_optimizer_hints = 'NEW' THEN
146: FOR context_rec IN context_c_new LOOP
147: i := i + 1;
148: rv.context_code(i) := context_rec.descriptive_flex_context_code;
149: rv.context_name(i) := context_rec.descriptive_flex_context_name;

Line 1235: RAISE bis_view_generator_pvt.CANNOT_PRUNE_NON_EDW_VIEW;

1231: --- This clause catches flexfield tags that do not have the
1232: --- _EDW tags when the generator is called via generate_pruned_view
1233: IF (p_column_table IS NOT NULL AND l_edw_flag = FALSE )
1234: THEN
1235: RAISE bis_view_generator_pvt.CANNOT_PRUNE_NON_EDW_VIEW;
1236: END IF;
1237:
1238:
1239: parse_DF_Select_Line( p_View_Select_Table

Line 1300: when bis_view_generator_pvt.cannot_prune_non_edw_view THEN

1296: --
1297:
1298:
1299: EXCEPTION
1300: when bis_view_generator_pvt.cannot_prune_non_edw_view THEN
1301: RAISE; -- same exception
1302: when FND_API.G_EXC_ERROR then
1303: x_return_status := FND_API.G_RET_STS_ERROR ;
1304: RAISE; -- same exception