APPS.EDW_FACT_SV dependencies on EDW_GEN_VIEW

Line 32: AND version =edw_gen_view.g_version;

28: CURSOR c_getViewNamesForFact(p_fact_name in varchar2) IS
29: SELECT flex_view_name, generated_view_name, collection_view_name
30: FROM edw_source_views
31: WHERE upper(object_name) = p_fact_name
32: AND version =edw_gen_view.g_version;
33:
34: BEGIN
35: IF (g_log) THEN
36: edw_gen_view.indentBegin;

Line 36: edw_gen_view.indentBegin;

32: AND version =edw_gen_view.g_version;
33:
34: BEGIN
35: IF (g_log) THEN
36: edw_gen_view.indentBegin;
37: edw_gen_view.writelog(newline);
38: edw_gen_view.writelog('Inside getViewNameForFact');
39: END IF;
40:

Line 37: edw_gen_view.writelog(newline);

33:
34: BEGIN
35: IF (g_log) THEN
36: edw_gen_view.indentBegin;
37: edw_gen_view.writelog(newline);
38: edw_gen_view.writelog('Inside getViewNameForFact');
39: END IF;
40:
41: OPEN c_getViewNamesForFact(fact_name);

Line 38: edw_gen_view.writelog('Inside getViewNameForFact');

34: BEGIN
35: IF (g_log) THEN
36: edw_gen_view.indentBegin;
37: edw_gen_view.writelog(newline);
38: edw_gen_view.writelog('Inside getViewNameForFact');
39: END IF;
40:
41: OPEN c_getViewNamesForFact(fact_name);
42: FETCH c_getViewNamesForFact into g_flex_view_name,

Line 48: edw_gen_view.g_success := false;

44: CLOSE c_getViewNamesForFact ;
45:
46: IF (g_generated_view_name IS NULL OR g_flex_view_name IS NULL OR
47: g_collection_view_name IS NULL) THEN
48: edw_gen_view.g_success := false;
49: edw_gen_view.g_error := 'View Names not seeded for ' ||fact_name;
50: raise edw_gen_view.viewgen_exception;
51:
52: END IF;

Line 49: edw_gen_view.g_error := 'View Names not seeded for ' ||fact_name;

45:
46: IF (g_generated_view_name IS NULL OR g_flex_view_name IS NULL OR
47: g_collection_view_name IS NULL) THEN
48: edw_gen_view.g_success := false;
49: edw_gen_view.g_error := 'View Names not seeded for ' ||fact_name;
50: raise edw_gen_view.viewgen_exception;
51:
52: END IF;
53:

Line 50: raise edw_gen_view.viewgen_exception;

46: IF (g_generated_view_name IS NULL OR g_flex_view_name IS NULL OR
47: g_collection_view_name IS NULL) THEN
48: edw_gen_view.g_success := false;
49: edw_gen_view.g_error := 'View Names not seeded for ' ||fact_name;
50: raise edw_gen_view.viewgen_exception;
51:
52: END IF;
53:
54: IF (g_log) THEN

Line 55: edw_gen_view.writelog(' Flex view is:'||g_flex_view_name);

51:
52: END IF;
53:
54: IF (g_log) THEN
55: edw_gen_view.writelog(' Flex view is:'||g_flex_view_name);
56: edw_gen_view.writelog(' Generated view is:'||g_generated_view_name);
57: edw_gen_view.writelog(' Collection view is:'||g_collection_view_name);
58: edw_gen_view.writelog('Completed getViewNameForFact');
59: edw_gen_view.indentEnd;

Line 56: edw_gen_view.writelog(' Generated view is:'||g_generated_view_name);

52: END IF;
53:
54: IF (g_log) THEN
55: edw_gen_view.writelog(' Flex view is:'||g_flex_view_name);
56: edw_gen_view.writelog(' Generated view is:'||g_generated_view_name);
57: edw_gen_view.writelog(' Collection view is:'||g_collection_view_name);
58: edw_gen_view.writelog('Completed getViewNameForFact');
59: edw_gen_view.indentEnd;
60:

Line 57: edw_gen_view.writelog(' Collection view is:'||g_collection_view_name);

53:
54: IF (g_log) THEN
55: edw_gen_view.writelog(' Flex view is:'||g_flex_view_name);
56: edw_gen_view.writelog(' Generated view is:'||g_generated_view_name);
57: edw_gen_view.writelog(' Collection view is:'||g_collection_view_name);
58: edw_gen_view.writelog('Completed getViewNameForFact');
59: edw_gen_view.indentEnd;
60:
61: END IF;

Line 58: edw_gen_view.writelog('Completed getViewNameForFact');

54: IF (g_log) THEN
55: edw_gen_view.writelog(' Flex view is:'||g_flex_view_name);
56: edw_gen_view.writelog(' Generated view is:'||g_generated_view_name);
57: edw_gen_view.writelog(' Collection view is:'||g_collection_view_name);
58: edw_gen_view.writelog('Completed getViewNameForFact');
59: edw_gen_view.indentEnd;
60:
61: END IF;
62:

Line 59: edw_gen_view.indentEnd;

55: edw_gen_view.writelog(' Flex view is:'||g_flex_view_name);
56: edw_gen_view.writelog(' Generated view is:'||g_generated_view_name);
57: edw_gen_view.writelog(' Collection view is:'||g_collection_view_name);
58: edw_gen_view.writelog('Completed getViewNameForFact');
59: edw_gen_view.indentEnd;
60:
61: END IF;
62:
63:

Line 79: attColumns edw_gen_view.tab_att_maps;

75: v_retCode INTEGER;
76: nColCount INTEGER := 0;
77: nOuterLoopCount INTEGER := 0;
78: nInnerLoopCount INTEGER := 0;
79: attColumns edw_gen_view.tab_att_maps;
80: multiAttList edw_gen_view.tab_multi_att_list;
81: flexColumns edw_gen_view.tab_flex_att_maps;
82: fkColumns edw_gen_view.tab_fact_flex_fk_maps;
83: bColumnMapped BOOLEAN := false;

Line 80: multiAttList edw_gen_view.tab_multi_att_list;

76: nColCount INTEGER := 0;
77: nOuterLoopCount INTEGER := 0;
78: nInnerLoopCount INTEGER := 0;
79: attColumns edw_gen_view.tab_att_maps;
80: multiAttList edw_gen_view.tab_multi_att_list;
81: flexColumns edw_gen_view.tab_flex_att_maps;
82: fkColumns edw_gen_view.tab_fact_flex_fk_maps;
83: bColumnMapped BOOLEAN := false;
84: curColumn VARCHAR2(300) := NULL;

Line 81: flexColumns edw_gen_view.tab_flex_att_maps;

77: nOuterLoopCount INTEGER := 0;
78: nInnerLoopCount INTEGER := 0;
79: attColumns edw_gen_view.tab_att_maps;
80: multiAttList edw_gen_view.tab_multi_att_list;
81: flexColumns edw_gen_view.tab_flex_att_maps;
82: fkColumns edw_gen_view.tab_fact_flex_fk_maps;
83: bColumnMapped BOOLEAN := false;
84: curColumn VARCHAR2(300) := NULL;
85: curColType VARCHAR2(300) := NULL;

Line 82: fkColumns edw_gen_view.tab_fact_flex_fk_maps;

78: nInnerLoopCount INTEGER := 0;
79: attColumns edw_gen_view.tab_att_maps;
80: multiAttList edw_gen_view.tab_multi_att_list;
81: flexColumns edw_gen_view.tab_flex_att_maps;
82: fkColumns edw_gen_view.tab_fact_flex_fk_maps;
83: bColumnMapped BOOLEAN := false;
84: curColumn VARCHAR2(300) := NULL;
85: curColType VARCHAR2(300) := NULL;
86: stmt VARCHAR2(10000) := NULL;

Line 119: edw_gen_view.indentBegin;

115:
116:
117:
118: IF (g_log) THEN
119: edw_gen_view.indentBegin;
120: edw_gen_view.writelog('Inside generateViewForFact');
121: END IF;
122:
123:

Line 120: edw_gen_view.writelog('Inside generateViewForFact');

116:
117:
118: IF (g_log) THEN
119: edw_gen_view.indentBegin;
120: edw_gen_view.writelog('Inside generateViewForFact');
121: END IF;
122:
123:
124: getViewNameForFact(upper(fact_name));

Line 130: nColCount := edw_gen_view.getColumnCountForView(g_collection_view_name);

126:
127: /* figure out which attributes are mapped */
128: srcview := 'CREATE OR REPLACE FORCE VIEW '||g_collection_view_name||' AS SELECT ';
129:
130: nColCount := edw_gen_view.getColumnCountForView(g_collection_view_name);
131:
132:
133: IF (NOT edw_gen_view.g_success) THEN
134: return;

Line 133: IF (NOT edw_gen_view.g_success) THEN

129:
130: nColCount := edw_gen_view.getColumnCountForView(g_collection_view_name);
131:
132:
133: IF (NOT edw_gen_view.g_success) THEN
134: return;
135: END IF;
136:
137: IF (nColCount = 0 ) THEN

Line 138: edw_gen_view.g_success := false;

134: return;
135: END IF;
136:
137: IF (nColCount = 0 ) THEN
138: edw_gen_view.g_success := false;
139: edw_gen_view.g_error := 'Error! No. of columns for ' ||g_collection_view_name||
140: '@'||edw_gen_view.g_source_db_link||' is zero!!!';
141:
142: IF (g_log) THEN

Line 139: edw_gen_view.g_error := 'Error! No. of columns for ' ||g_collection_view_name||

135: END IF;
136:
137: IF (nColCount = 0 ) THEN
138: edw_gen_view.g_success := false;
139: edw_gen_view.g_error := 'Error! No. of columns for ' ||g_collection_view_name||
140: '@'||edw_gen_view.g_source_db_link||' is zero!!!';
141:
142: IF (g_log) THEN
143: edw_gen_view.writelog('ERROR...'||edw_gen_view.g_error);

Line 140: '@'||edw_gen_view.g_source_db_link||' is zero!!!';

136:
137: IF (nColCount = 0 ) THEN
138: edw_gen_view.g_success := false;
139: edw_gen_view.g_error := 'Error! No. of columns for ' ||g_collection_view_name||
140: '@'||edw_gen_view.g_source_db_link||' is zero!!!';
141:
142: IF (g_log) THEN
143: edw_gen_view.writelog('ERROR...'||edw_gen_view.g_error);
144: END IF;

Line 143: edw_gen_view.writelog('ERROR...'||edw_gen_view.g_error);

139: edw_gen_view.g_error := 'Error! No. of columns for ' ||g_collection_view_name||
140: '@'||edw_gen_view.g_source_db_link||' is zero!!!';
141:
142: IF (g_log) THEN
143: edw_gen_view.writelog('ERROR...'||edw_gen_view.g_error);
144: END IF;
145:
146: raise edw_gen_view.viewgen_exception;
147: RETURN;

Line 146: raise edw_gen_view.viewgen_exception;

142: IF (g_log) THEN
143: edw_gen_view.writelog('ERROR...'||edw_gen_view.g_error);
144: END IF;
145:
146: raise edw_gen_view.viewgen_exception;
147: RETURN;
148: END IF;
149:
150:

Line 151: stmt := ' SELECT distinct column_name , data_type FROM all_tab_columns@'||edw_gen_view.g_source_db_link;

147: RETURN;
148: END IF;
149:
150:
151: stmt := ' SELECT distinct column_name , data_type FROM all_tab_columns@'||edw_gen_view.g_source_db_link;
152: stmt := stmt||' WHERE table_name = upper('''||g_collection_view_name
153: ||''') AND owner = '''||edw_gen_view.g_apps_schema||'''';
154:
155:

Line 153: ||''') AND owner = '''||edw_gen_view.g_apps_schema||'''';

149:
150:
151: stmt := ' SELECT distinct column_name , data_type FROM all_tab_columns@'||edw_gen_view.g_source_db_link;
152: stmt := stmt||' WHERE table_name = upper('''||g_collection_view_name
153: ||''') AND owner = '''||edw_gen_view.g_apps_schema||'''';
154:
155:
156: BEGIN
157: cid := DBMS_SQL.open_cursor;

Line 169: edw_gen_view.getColumnMaps(fact_name, attColumns, multiAttList,

165: DBMS_SQL.CLOSE_CURSOR(cid);
166:
167:
168:
169: edw_gen_view.getColumnMaps(fact_name, attColumns, multiAttList,
170: flexColumns, fkColumns);
171:
172: IF (NOT edw_gen_view.g_success) THEN
173: return;

Line 172: IF (NOT edw_gen_view.g_success) THEN

168:
169: edw_gen_view.getColumnMaps(fact_name, attColumns, multiAttList,
170: flexColumns, fkColumns);
171:
172: IF (NOT edw_gen_view.g_success) THEN
173: return;
174: END IF;
175:
176:

Line 224: edw_gen_view.writelog('View text is longer than 32760.');

220: if (length(srcview)+length(l_temp_stmt)> 32760) then
221: g_view_text_table(g_view_table_num):= srcview;
222: srcview:=null;
223: if g_log then
224: edw_gen_view.writelog('View text is longer than 32760.');
225: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
226: end if;
227: g_view_table_num:= g_view_table_num+1;
228: g_long_stmt_flag:=true;

Line 225: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

221: g_view_text_table(g_view_table_num):= srcview;
222: srcview:=null;
223: if g_log then
224: edw_gen_view.writelog('View text is longer than 32760.');
225: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
226: end if;
227: g_view_table_num:= g_view_table_num+1;
228: g_long_stmt_flag:=true;
229: end if;

Line 248: edw_gen_view.writelog('View text is longer than 32760.');

244: if (length(srcview)+length(l_temp_stmt)> 32760) then
245: g_view_text_table(g_view_table_num):= srcview;
246: srcview:=null;
247: if g_log then
248: edw_gen_view.writelog('View text is longer than 32760.');
249: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
250: end if;
251: g_view_table_num:= g_view_table_num+1;
252: g_long_stmt_flag:=true;

Line 249: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

245: g_view_text_table(g_view_table_num):= srcview;
246: srcview:=null;
247: if g_log then
248: edw_gen_view.writelog('View text is longer than 32760.');
249: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
250: end if;
251: g_view_table_num:= g_view_table_num+1;
252: g_long_stmt_flag:=true;
253: end if;

Line 257: edw_gen_view.writelog('Processing column ' || curColumn);

253: end if;
254: srcview := srcview || l_temp_stmt;
255: END IF;
256: IF (g_log) THEN
257: edw_gen_view.writelog('Processing column ' || curColumn);
258: END IF;
259: /* need to process only if its a user attribute or user fk */
260:
261: IF (curColumn LIKE 'USER_ATTRIBUTE%' OR curColumn LIKE 'USER_FK%'

Line 279: edw_gen_view.writelog(' Attributes mapped to a single attribute exist');

275:
276: IF (attColumns(nInnerLoopCount).attribute_name = curColumn) THEN
277: bColumnMapped := true;
278: IF (g_log) THEN
279: edw_gen_view.writelog(' Attributes mapped to a single attribute exist');
280: edw_gen_view.writelog(' '||curColumn||' is of datatype '||attColumns(nInnerLoopCount).datatype);
281: END IF;
282: IF (attColumns(nInnerLoopCount).datatype <> 'DATE') THEN
283: IF (g_log) THEN

Line 280: edw_gen_view.writelog(' '||curColumn||' is of datatype '||attColumns(nInnerLoopCount).datatype);

276: IF (attColumns(nInnerLoopCount).attribute_name = curColumn) THEN
277: bColumnMapped := true;
278: IF (g_log) THEN
279: edw_gen_view.writelog(' Attributes mapped to a single attribute exist');
280: edw_gen_view.writelog(' '||curColumn||' is of datatype '||attColumns(nInnerLoopCount).datatype);
281: END IF;
282: IF (attColumns(nInnerLoopCount).datatype <> 'DATE') THEN
283: IF (g_log) THEN
284: edw_gen_view.writelog(' not a date column ');

Line 284: edw_gen_view.writelog(' not a date column ');

280: edw_gen_view.writelog(' '||curColumn||' is of datatype '||attColumns(nInnerLoopCount).datatype);
281: END IF;
282: IF (attColumns(nInnerLoopCount).datatype <> 'DATE') THEN
283: IF (g_log) THEN
284: edw_gen_view.writelog(' not a date column ');
285: END IF;
286:
287:
288: l_temp_stmt:= 'a.'||attColumns(nInnerLoopCount).source_attribute||' '||curColumn ;

Line 290: edw_gen_view.writelog(' '||attColumns(nInnerLoopCount).source_attribute||' '||curColumn ||newline||newline);

286:
287:
288: l_temp_stmt:= 'a.'||attColumns(nInnerLoopCount).source_attribute||' '||curColumn ;
289: IF (g_log) THEN
290: edw_gen_view.writelog(' '||attColumns(nInnerLoopCount).source_attribute||' '||curColumn ||newline||newline);
291: END IF;
292: if (length(srcview)+length(l_temp_stmt)> 32760) then
293: g_view_text_table(g_view_table_num):= srcview;
294: srcview:=null;

Line 296: edw_gen_view.writelog('View text is longer than 32760.');

292: if (length(srcview)+length(l_temp_stmt)> 32760) then
293: g_view_text_table(g_view_table_num):= srcview;
294: srcview:=null;
295: if g_log then
296: edw_gen_view.writelog('View text is longer than 32760.');
297: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
298: end if;
299: g_view_table_num:= g_view_table_num+1;
300: g_long_stmt_flag:=true;

Line 297: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

293: g_view_text_table(g_view_table_num):= srcview;
294: srcview:=null;
295: if g_log then
296: edw_gen_view.writelog('View text is longer than 32760.');
297: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
298: end if;
299: g_view_table_num:= g_view_table_num+1;
300: g_long_stmt_flag:=true;
301: end if;

Line 305: edw_gen_view.writelog( 'and so doing a to_char');

301: end if;
302: srcview := srcview || l_temp_stmt;
303: ELSE
304: IF (g_log) THEN
305: edw_gen_view.writelog( 'and so doing a to_char');
306: END IF;
307: l_temp_stmt :=' to_char(a.'||attColumns(nInnerLoopCount).source_attribute||' , ''mm/dd/yyyy hh24:mi:ss'') '||' '||curColumn ;
308: if (length(srcview)+length(l_temp_stmt)> 32760) then
309: g_view_text_table(g_view_table_num):= srcview;

Line 312: edw_gen_view.writelog('View text is longer than 32760.');

308: if (length(srcview)+length(l_temp_stmt)> 32760) then
309: g_view_text_table(g_view_table_num):= srcview;
310: srcview:=null;
311: if g_log then
312: edw_gen_view.writelog('View text is longer than 32760.');
313: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
314: end if;
315: g_view_table_num:= g_view_table_num+1;
316: g_long_stmt_flag:=true;

Line 313: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

309: g_view_text_table(g_view_table_num):= srcview;
310: srcview:=null;
311: if g_log then
312: edw_gen_view.writelog('View text is longer than 32760.');
313: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
314: end if;
315: g_view_table_num:= g_view_table_num+1;
316: g_long_stmt_flag:=true;
317: end if;

Line 334: l_temp_stmt := edw_gen_view.getNvlClause(fact_name, null,

330: LOOP
331:
332: IF (multiAttList(nInnerLoopCount).attribute_name = curColumn) THEN
333: bColumnMapped := true;
334: l_temp_stmt := edw_gen_view.getNvlClause(fact_name, null,
335: edw_gen_view.g_instance , curColumn)||' '||curColumn ;
336: IF (g_log) THEN
337: edw_gen_view.writelog('getNvlClause returned : '||l_temp_stmt);
338: END IF;

Line 335: edw_gen_view.g_instance , curColumn)||' '||curColumn ;

331:
332: IF (multiAttList(nInnerLoopCount).attribute_name = curColumn) THEN
333: bColumnMapped := true;
334: l_temp_stmt := edw_gen_view.getNvlClause(fact_name, null,
335: edw_gen_view.g_instance , curColumn)||' '||curColumn ;
336: IF (g_log) THEN
337: edw_gen_view.writelog('getNvlClause returned : '||l_temp_stmt);
338: END IF;
339: if (length(srcview)+length(l_temp_stmt)> 32760) then

Line 337: edw_gen_view.writelog('getNvlClause returned : '||l_temp_stmt);

333: bColumnMapped := true;
334: l_temp_stmt := edw_gen_view.getNvlClause(fact_name, null,
335: edw_gen_view.g_instance , curColumn)||' '||curColumn ;
336: IF (g_log) THEN
337: edw_gen_view.writelog('getNvlClause returned : '||l_temp_stmt);
338: END IF;
339: if (length(srcview)+length(l_temp_stmt)> 32760) then
340: g_view_text_table(g_view_table_num):= srcview;
341: srcview:=null;

Line 343: edw_gen_view.writelog('View text is longer than 32760.');

339: if (length(srcview)+length(l_temp_stmt)> 32760) then
340: g_view_text_table(g_view_table_num):= srcview;
341: srcview:=null;
342: if g_log then
343: edw_gen_view.writelog('View text is longer than 32760.');
344: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
345: end if;
346: g_view_table_num:= g_view_table_num+1;
347: g_long_stmt_flag:=true;

Line 344: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

340: g_view_text_table(g_view_table_num):= srcview;
341: srcview:=null;
342: if g_log then
343: edw_gen_view.writelog('View text is longer than 32760.');
344: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
345: end if;
346: g_view_table_num:= g_view_table_num+1;
347: g_long_stmt_flag:=true;
348: end if;

Line 352: IF (NOT edw_gen_view.g_success) THEN

348: end if;
349: srcview := srcview || l_temp_stmt;
350: goto nomatch;
351: END IF;
352: IF (NOT edw_gen_view.g_success) THEN
353: return;
354: END IF;
355:
356: EXIT WHEN nInnerLoopCount = multiAttList.last;

Line 371: decodeClause := edw_gen_view.getDecodeClauseForFlexCol(

367:
368: IF (flexColumns(nInnerLoopCount).attribute_name = curColumn) THEN
369: bColumnMapped := true;
370: -- decode flex
371: decodeClause := edw_gen_view.getDecodeClauseForFlexCol(
372: g_flex_view_name, curColumn,
373: flexColumns(nInnerLoopCount).id_flex_code,
374: flexColumns(nInnerLoopCount).flex_field_type);
375: l_temp_stmt := decodeClause||' '||curColumn;

Line 380: edw_gen_view.writelog('View text is longer than 32760.');

376: if (length(srcview)+length(l_temp_stmt)> 32760) then
377: g_view_text_table(g_view_table_num):= srcview;
378: srcview:=null;
379: if g_log then
380: edw_gen_view.writelog('View text is longer than 32760.');
381: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
382: end if;
383: g_view_table_num:= g_view_table_num+1;
384: g_long_stmt_flag:=true;

Line 381: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

377: g_view_text_table(g_view_table_num):= srcview;
378: srcview:=null;
379: if g_log then
380: edw_gen_view.writelog('View text is longer than 32760.');
381: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
382: end if;
383: g_view_table_num:= g_view_table_num+1;
384: g_long_stmt_flag:=true;
385: end if;

Line 389: IF (NOT edw_gen_view.g_success) THEN

385: end if;
386: srcview := srcview || l_temp_stmt;
387: goto nomatch;
388: END IF;
389: IF (NOT edw_gen_view.g_success) THEN
390: return;
391: END IF;
392:
393: EXIT WHEN nInnerLoopCount= flexColumns.last;

Line 412: edw_gen_view.writelog('View text is longer than 32760.');

408: if (length(srcview)+length(l_temp_stmt)> 32760) then
409: g_view_text_table(g_view_table_num):= srcview;
410: srcview:=null;
411: if g_log then
412: edw_gen_view.writelog('View text is longer than 32760.');
413: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
414: end if;
415: g_view_table_num:= g_view_table_num+1;
416: g_long_stmt_flag:=true;

Line 413: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

409: g_view_text_table(g_view_table_num):= srcview;
410: srcview:=null;
411: if g_log then
412: edw_gen_view.writelog('View text is longer than 32760.');
413: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
414: end if;
415: g_view_table_num:= g_view_table_num+1;
416: g_long_stmt_flag:=true;
417: end if;

Line 422: IF (NOT edw_gen_view.g_success) THEN

418: srcview := srcview || l_temp_stmt;
419: goto nomatch;
420: END IF;
421:
422: IF (NOT edw_gen_view.g_success) THEN
423: return;
424: END IF;
425:
426: EXIT WHEN nInnerLoopCount= fkColumns.last;

Line 438: edw_gen_view.writelog('View text is longer than 32760.');

434: if (length(srcview)+length(l_temp_stmt)> 32760) then
435: g_view_text_table(g_view_table_num):= srcview;
436: srcview:=null;
437: if g_log then
438: edw_gen_view.writelog('View text is longer than 32760.');
439: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
440: end if;
441: g_view_table_num:= g_view_table_num+1;
442: g_long_stmt_flag:=true;

Line 439: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

435: g_view_text_table(g_view_table_num):= srcview;
436: srcview:=null;
437: if g_log then
438: edw_gen_view.writelog('View text is longer than 32760.');
439: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
440: end if;
441: g_view_table_num:= g_view_table_num+1;
442: g_long_stmt_flag:=true;
443: end if;

Line 452: edw_gen_view.writelog('View text is longer than 32760.');

448: if (length(srcview)+length(l_temp_stmt)> 32760) then
449: g_view_text_table(g_view_table_num):= srcview;
450: srcview:=null;
451: if g_log then
452: edw_gen_view.writelog('View text is longer than 32760.');
453: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
454: end if;
455: g_view_table_num:= g_view_table_num+1;
456: g_long_stmt_flag:=true;

Line 453: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

449: g_view_text_table(g_view_table_num):= srcview;
450: srcview:=null;
451: if g_log then
452: edw_gen_view.writelog('View text is longer than 32760.');
453: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
454: end if;
455: g_view_table_num:= g_view_table_num+1;
456: g_long_stmt_flag:=true;
457: end if;

Line 467: edw_gen_view.writelog('View text is longer than 32760.');

463: if (length(srcview)+length(l_temp_stmt)> 32760) then
464: g_view_text_table(g_view_table_num):= srcview;
465: srcview:=null;
466: if g_log then
467: edw_gen_view.writelog('View text is longer than 32760.');
468: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
469: end if;
470: g_view_table_num:= g_view_table_num+1;
471: g_long_stmt_flag:=true;

Line 468: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

464: g_view_text_table(g_view_table_num):= srcview;
465: srcview:=null;
466: if g_log then
467: edw_gen_view.writelog('View text is longer than 32760.');
468: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
469: end if;
470: g_view_table_num:= g_view_table_num+1;
471: g_long_stmt_flag:=true;
472: end if;

Line 486: edw_gen_view.writelog('View text is longer than 32760.');

482: if (length(srcview)+length(l_temp_stmt)> 32760) then
483: g_view_text_table(g_view_table_num):= srcview;
484: srcview:=null;
485: if g_log then
486: edw_gen_view.writelog('View text is longer than 32760.');
487: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
488: end if;
489: g_view_table_num:= g_view_table_num+1;
490: g_long_stmt_flag:=true;

Line 487: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

483: g_view_text_table(g_view_table_num):= srcview;
484: srcview:=null;
485: if g_log then
486: edw_gen_view.writelog('View text is longer than 32760.');
487: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
488: end if;
489: g_view_table_num:= g_view_table_num+1;
490: g_long_stmt_flag:=true;
491: end if;

Line 499: /*' and b.instance(+) = '||''''|| edw_gen_view.g_instance ||''''||newline||*/

495: IF (g_acct_flex_exists) THEN
496:
497: l_temp_stmt:= ', '||newline||' edw_local_set_of_books b, edw_local_equi_set_of_books c, edw_local_set_of_books d '|| newline||
498: ' where a.set_of_books_id = b.set_of_books_id (+) '||newline||
499: /*' and b.instance(+) = '||''''|| edw_gen_view.g_instance ||''''||newline||*/
500: ' and b.edw_set_of_books_id = c.edw_set_of_books_id (+) '||
501: ' and c.equi_set_of_books_id = d.edw_set_of_books_id (+)';
502:
503: if (length(srcview)+length(l_temp_stmt)> 32760) then

Line 507: edw_gen_view.writelog('View text is longer than 32760.');

503: if (length(srcview)+length(l_temp_stmt)> 32760) then
504: g_view_text_table(g_view_table_num):= srcview;
505: srcview:=null;
506: if g_log then
507: edw_gen_view.writelog('View text is longer than 32760.');
508: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
509: end if;
510: g_long_stmt_flag:=true;
511: end if;

Line 508: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');

504: g_view_text_table(g_view_table_num):= srcview;
505: srcview:=null;
506: if g_log then
507: edw_gen_view.writelog('View text is longer than 32760.');
508: edw_gen_view.writelog('View Text stored in the '|| g_view_table_num||'th element of the view text table.');
509: end if;
510: g_long_stmt_flag:=true;
511: end if;
512: srcview := srcview || l_temp_stmt;

Line 521: edw_gen_view.writelog( g_view_text_table(l_write_view_counter));

517:
518: if (g_long_stmt_flag) then
519: for l_write_view_counter in 1 .. g_view_text_table.count loop
520: IF(g_log) THEN
521: edw_gen_view.writelog( g_view_text_table(l_write_view_counter));
522: edw_gen_view.writeoutline('/* Writing Part '||l_write_view_counter||' of the view */');
523: edw_gen_view.writeout( g_view_text_table(l_write_view_counter));
524: END IF;
525: end loop;

Line 522: edw_gen_view.writeoutline('/* Writing Part '||l_write_view_counter||' of the view */');

518: if (g_long_stmt_flag) then
519: for l_write_view_counter in 1 .. g_view_text_table.count loop
520: IF(g_log) THEN
521: edw_gen_view.writelog( g_view_text_table(l_write_view_counter));
522: edw_gen_view.writeoutline('/* Writing Part '||l_write_view_counter||' of the view */');
523: edw_gen_view.writeout( g_view_text_table(l_write_view_counter));
524: END IF;
525: end loop;
526: end if;

Line 523: edw_gen_view.writeout( g_view_text_table(l_write_view_counter));

519: for l_write_view_counter in 1 .. g_view_text_table.count loop
520: IF(g_log) THEN
521: edw_gen_view.writelog( g_view_text_table(l_write_view_counter));
522: edw_gen_view.writeoutline('/* Writing Part '||l_write_view_counter||' of the view */');
523: edw_gen_view.writeout( g_view_text_table(l_write_view_counter));
524: END IF;
525: end loop;
526: end if;
527:

Line 529: edw_gen_view.writeoutline('/* Writing remaining piece of view */');

525: end loop;
526: end if;
527:
528: IF (g_log) THEN
529: edw_gen_view.writeoutline('/* Writing remaining piece of view */');
530: edw_gen_view.writeOutline(srcview);
531: edw_gen_view.writelog(newline||newline);
532: edw_gen_view.writelog('View formation complete.');
533: --edw_gen_view.writelog(srcview);

Line 530: edw_gen_view.writeOutline(srcview);

526: end if;
527:
528: IF (g_log) THEN
529: edw_gen_view.writeoutline('/* Writing remaining piece of view */');
530: edw_gen_view.writeOutline(srcview);
531: edw_gen_view.writelog(newline||newline);
532: edw_gen_view.writelog('View formation complete.');
533: --edw_gen_view.writelog(srcview);
534: edw_gen_view.writeOutLine('/');

Line 531: edw_gen_view.writelog(newline||newline);

527:
528: IF (g_log) THEN
529: edw_gen_view.writeoutline('/* Writing remaining piece of view */');
530: edw_gen_view.writeOutline(srcview);
531: edw_gen_view.writelog(newline||newline);
532: edw_gen_view.writelog('View formation complete.');
533: --edw_gen_view.writelog(srcview);
534: edw_gen_view.writeOutLine('/');
535: edw_gen_view.writeOutLine('EXIT;');

Line 532: edw_gen_view.writelog('View formation complete.');

528: IF (g_log) THEN
529: edw_gen_view.writeoutline('/* Writing remaining piece of view */');
530: edw_gen_view.writeOutline(srcview);
531: edw_gen_view.writelog(newline||newline);
532: edw_gen_view.writelog('View formation complete.');
533: --edw_gen_view.writelog(srcview);
534: edw_gen_view.writeOutLine('/');
535: edw_gen_view.writeOutLine('EXIT;');
536: END IF;

Line 533: --edw_gen_view.writelog(srcview);

529: edw_gen_view.writeoutline('/* Writing remaining piece of view */');
530: edw_gen_view.writeOutline(srcview);
531: edw_gen_view.writelog(newline||newline);
532: edw_gen_view.writelog('View formation complete.');
533: --edw_gen_view.writelog(srcview);
534: edw_gen_view.writeOutLine('/');
535: edw_gen_view.writeOutLine('EXIT;');
536: END IF;
537: end if;

Line 534: edw_gen_view.writeOutLine('/');

530: edw_gen_view.writeOutline(srcview);
531: edw_gen_view.writelog(newline||newline);
532: edw_gen_view.writelog('View formation complete.');
533: --edw_gen_view.writelog(srcview);
534: edw_gen_view.writeOutLine('/');
535: edw_gen_view.writeOutLine('EXIT;');
536: END IF;
537: end if;
538:

Line 535: edw_gen_view.writeOutLine('EXIT;');

531: edw_gen_view.writelog(newline||newline);
532: edw_gen_view.writelog('View formation complete.');
533: --edw_gen_view.writelog(srcview);
534: edw_gen_view.writeOutLine('/');
535: edw_gen_view.writeOutLine('EXIT;');
536: END IF;
537: end if;
538:
539:

Line 541: IF (NOT edw_gen_view.g_success) THEN

537: end if;
538:
539:
540:
541: IF (NOT edw_gen_view.g_success) THEN
542: return;
543: END IF;
544:
545: if (not g_long_stmt_flag) then

Line 547: edw_gen_view.writelog('Short text. Call edw_gen_view.createView');

543: END IF;
544:
545: if (not g_long_stmt_flag) then
546: IF (g_log) THEN
547: edw_gen_view.writelog('Short text. Call edw_gen_view.createView');
548: END IF;
549: edw_gen_view.createView(srcview, g_collection_view_name);
550: else
551: IF (g_log) THEN

Line 549: edw_gen_view.createView(srcview, g_collection_view_name);

545: if (not g_long_stmt_flag) then
546: IF (g_log) THEN
547: edw_gen_view.writelog('Short text. Call edw_gen_view.createView');
548: END IF;
549: edw_gen_view.createView(srcview, g_collection_view_name);
550: else
551: IF (g_log) THEN
552: edw_gen_view.writelog('Long text. Call edw_gen_view.createLongView');
553: END IF;

Line 552: edw_gen_view.writelog('Long text. Call edw_gen_view.createLongView');

548: END IF;
549: edw_gen_view.createView(srcview, g_collection_view_name);
550: else
551: IF (g_log) THEN
552: edw_gen_view.writelog('Long text. Call edw_gen_view.createLongView');
553: END IF;
554:
555: /*---------------------------------------------------------------------------
556: cut the view text into 256 chars chunks and call edw_gen_view.buildViewStmt

Line 556: cut the view text into 256 chars chunks and call edw_gen_view.buildViewStmt

552: edw_gen_view.writelog('Long text. Call edw_gen_view.createLongView');
553: END IF;
554:
555: /*---------------------------------------------------------------------------
556: cut the view text into 256 chars chunks and call edw_gen_view.buildViewStmt
557: ----------------------------------------------------------------------------*/
558: l_build_stmt_counter:=0;
559: for l_write_view_counter in 1 .. g_view_text_table.count loop
560: l_temp_stmt:= g_view_text_table(l_write_view_counter);

Line 564: edw_gen_view.BuildViewStmt(substr(l_temp_stmt,1,256), l_build_stmt_counter);

560: l_temp_stmt:= g_view_text_table(l_write_view_counter);
561:
562: while (length(l_temp_stmt) >256 ) loop
563: l_build_stmt_counter:= l_build_stmt_counter +1;
564: edw_gen_view.BuildViewStmt(substr(l_temp_stmt,1,256), l_build_stmt_counter);
565: l_temp_stmt:= substr(l_temp_stmt,257);
566: end loop;
567: l_build_stmt_counter:= l_build_stmt_counter +1;
568: edw_gen_view.BuildViewStmt(l_temp_stmt, l_build_stmt_counter);

Line 568: edw_gen_view.BuildViewStmt(l_temp_stmt, l_build_stmt_counter);

564: edw_gen_view.BuildViewStmt(substr(l_temp_stmt,1,256), l_build_stmt_counter);
565: l_temp_stmt:= substr(l_temp_stmt,257);
566: end loop;
567: l_build_stmt_counter:= l_build_stmt_counter +1;
568: edw_gen_view.BuildViewStmt(l_temp_stmt, l_build_stmt_counter);
569: end loop;
570: l_temp_stmt := srcview;
571: while (length(l_temp_stmt) >256 ) loop
572: l_build_stmt_counter:= l_build_stmt_counter +1;

Line 573: edw_gen_view.BuildViewStmt(substr(l_temp_stmt,1,256), l_build_stmt_counter);

569: end loop;
570: l_temp_stmt := srcview;
571: while (length(l_temp_stmt) >256 ) loop
572: l_build_stmt_counter:= l_build_stmt_counter +1;
573: edw_gen_view.BuildViewStmt(substr(l_temp_stmt,1,256), l_build_stmt_counter);
574: l_temp_stmt:= substr(l_temp_stmt,257);
575: end loop;
576: l_build_stmt_counter:= l_build_stmt_counter +1;
577: edw_gen_view.BuildViewStmt(l_temp_stmt, l_build_stmt_counter);

Line 577: edw_gen_view.BuildViewStmt(l_temp_stmt, l_build_stmt_counter);

573: edw_gen_view.BuildViewStmt(substr(l_temp_stmt,1,256), l_build_stmt_counter);
574: l_temp_stmt:= substr(l_temp_stmt,257);
575: end loop;
576: l_build_stmt_counter:= l_build_stmt_counter +1;
577: edw_gen_view.BuildViewStmt(l_temp_stmt, l_build_stmt_counter);
578:
579: edw_gen_view.createLongView(g_collection_view_name, 1, l_build_stmt_counter);
580: end if;
581:

Line 579: edw_gen_view.createLongView(g_collection_view_name, 1, l_build_stmt_counter);

575: end loop;
576: l_build_stmt_counter:= l_build_stmt_counter +1;
577: edw_gen_view.BuildViewStmt(l_temp_stmt, l_build_stmt_counter);
578:
579: edw_gen_view.createLongView(g_collection_view_name, 1, l_build_stmt_counter);
580: end if;
581:
582: IF (NOT edw_gen_view.g_success) THEN
583:

Line 582: IF (NOT edw_gen_view.g_success) THEN

578:
579: edw_gen_view.createLongView(g_collection_view_name, 1, l_build_stmt_counter);
580: end if;
581:
582: IF (NOT edw_gen_view.g_success) THEN
583:
584: return;
585: END IF;
586:

Line 588: edw_gen_view.writelog('Completed generateViewForFact');

584: return;
585: END IF;
586:
587: IF (g_log) THEN
588: edw_gen_view.writelog('Completed generateViewForFact');
589: edw_gen_view.indentEnd;
590: END IF;
591: END;
592:

Line 589: edw_gen_view.indentEnd;

585: END IF;
586:
587: IF (g_log) THEN
588: edw_gen_view.writelog('Completed generateViewForFact');
589: edw_gen_view.indentEnd;
590: END IF;
591: END;
592:
593: END;

Line 620: AND a.instance_code = edw_gen_view.g_instance

616: FROM edw_flex_seg_mappings a, edw_fact_flex_fk_maps b
617: WHERE b.fact_short_name = pFactName
618: AND b.enabled_flag = 'Y'
619: AND b.dimension_short_name = a.dimension_short_name
620: AND a.instance_code = edw_gen_view.g_instance
621: AND (b.fk_physical_name = pAttributeName
622: or b.fk_physical_name = pAttributeName||'_KEY')
623: AND NOT EXISTS( select 1 from edw_flex_seg_mappings c
624: where c.parent_value_set_id = a.value_set_id

Line 640: edw_gen_view.indentBegin;

636: tempvar varchar2(300);
637: BEGIN
638:
639: IF (g_log) THEN
640: edw_gen_view.indentBegin;
641:
642: edw_gen_view.writelog('Inside getDecodeClauseForFlexFK');
643: edw_gen_view.writelog(' Parameter pFactname:'||pFactName);
644: edw_gen_view.writelog(' Parameter pAttributeName:'||pAttributeName);

Line 642: edw_gen_view.writelog('Inside getDecodeClauseForFlexFK');

638:
639: IF (g_log) THEN
640: edw_gen_view.indentBegin;
641:
642: edw_gen_view.writelog('Inside getDecodeClauseForFlexFK');
643: edw_gen_view.writelog(' Parameter pFactname:'||pFactName);
644: edw_gen_view.writelog(' Parameter pAttributeName:'||pAttributeName);
645: END IF;
646:

Line 643: edw_gen_view.writelog(' Parameter pFactname:'||pFactName);

639: IF (g_log) THEN
640: edw_gen_view.indentBegin;
641:
642: edw_gen_view.writelog('Inside getDecodeClauseForFlexFK');
643: edw_gen_view.writelog(' Parameter pFactname:'||pFactName);
644: edw_gen_view.writelog(' Parameter pAttributeName:'||pAttributeName);
645: END IF;
646:
647: OPEN c;

Line 644: edw_gen_view.writelog(' Parameter pAttributeName:'||pAttributeName);

640: edw_gen_view.indentBegin;
641:
642: edw_gen_view.writelog('Inside getDecodeClauseForFlexFK');
643: edw_gen_view.writelog(' Parameter pFactname:'||pFactName);
644: edw_gen_view.writelog(' Parameter pAttributeName:'||pAttributeName);
645: END IF;
646:
647: OPEN c;
648: FETCH c INTO cRec;

Line 650: sPrefix := edw_gen_view.getFlexPrefix(g_flex_view_name, cRec.id_flex_code);

646:
647: OPEN c;
648: FETCH c INTO cRec;
649:
650: sPrefix := edw_gen_view.getFlexPrefix(g_flex_view_name, cRec.id_flex_code);
651: sDecodePrefix := ' DECODE('||sPrefix||'_CONTEXT, '||newline||' ';
652: --sDecodeClause := ' DECODE('||sPrefix||'_CONTEXT, '||newline||' ';
653:
654: LOOP

Line 665: edw_gen_view.writelog('l_gen_seg_name is :'|| l_gen_seg_name);

661: ------------------------------------------------
662: l_gen_seg_name := cRec.segment_name;
663:
664: IF (g_log) THEN
665: edw_gen_view.writelog('l_gen_seg_name is :'|| l_gen_seg_name);
666: edw_gen_view.writelog('calling formSegmentName');
667: END IF;
668:
669: l_gen_seg_name := edw_gen_view.formSegmentName(sPrefix, cRec.segment_name, cRec.structure_num, pFactName, cRec.flex_field_type);

Line 666: edw_gen_view.writelog('calling formSegmentName');

662: l_gen_seg_name := cRec.segment_name;
663:
664: IF (g_log) THEN
665: edw_gen_view.writelog('l_gen_seg_name is :'|| l_gen_seg_name);
666: edw_gen_view.writelog('calling formSegmentName');
667: END IF;
668:
669: l_gen_seg_name := edw_gen_view.formSegmentName(sPrefix, cRec.segment_name, cRec.structure_num, pFactName, cRec.flex_field_type);
670:

Line 669: l_gen_seg_name := edw_gen_view.formSegmentName(sPrefix, cRec.segment_name, cRec.structure_num, pFactName, cRec.flex_field_type);

665: edw_gen_view.writelog('l_gen_seg_name is :'|| l_gen_seg_name);
666: edw_gen_view.writelog('calling formSegmentName');
667: END IF;
668:
669: l_gen_seg_name := edw_gen_view.formSegmentName(sPrefix, cRec.segment_name, cRec.structure_num, pFactName, cRec.flex_field_type);
670:
671: IF (upper(cRec.value_set_type) = 'D' ) THEN /* Dependant Value Set, need parent segment name also */
672: stmt := ' SELECT segment_name, structure_num FROM edw_flex_seg_mappings'||
673: ' WHERE value_set_id = :s1 AND ';

Line 687: l_parent_seg_name := edw_gen_view.formSegmentName(sPrefix, l_parent_seg_name, cRec.structure_num, pFactName, cRec.flex_field_type);

683: open cv for stmt using cRec.parent_value_set_id, cRec.structure_num;
684: fetch cv into l_parent_seg_name, l_parent_struct_num ;
685: close cv;
686: END IF;
687: l_parent_seg_name := edw_gen_view.formSegmentName(sPrefix, l_parent_seg_name, cRec.structure_num, pFactName, cRec.flex_field_type);
688:
689: IF (g_log) THEN
690: edw_gen_view.writelog('Parent segment is :'|| l_parent_seg_name);
691: END IF;

Line 690: edw_gen_view.writelog('Parent segment is :'|| l_parent_seg_name);

686: END IF;
687: l_parent_seg_name := edw_gen_view.formSegmentName(sPrefix, l_parent_seg_name, cRec.structure_num, pFactName, cRec.flex_field_type);
688:
689: IF (g_log) THEN
690: edw_gen_view.writelog('Parent segment is :'|| l_parent_seg_name);
691: END IF;
692: END IF;
693:
694: -------------------------------------------------

Line 696: edw_gen_view.writelog('dimension name is :'|| cRec.dimension_short_name);

692: END IF;
693:
694: -------------------------------------------------
695: IF (g_log) THEN
696: edw_gen_view.writelog('dimension name is :'|| cRec.dimension_short_name);
697: END IF;
698:
699:
700: IF (cRec.dimension_short_name LIKE 'EDW_GL_ACCT%_M' ) THEN /* A/c Flex dim */

Line 712: ||''''||edw_gen_view.g_instance||''''||'),';

708: newline||' "'||l_gen_seg_name||'"';
709: sDecodeClause := sDecodeClause||'||'||
710: ''''||'-'||''''||'|| a.set_of_books_id ';
711: sDecodeClause := sDecodeClause||'||'||''''||'-'||''''||'||'
712: ||''''||edw_gen_view.g_instance||''''||'),';
713:
714: sDecodeClause := sDecodeClause||
715: newline||' DECODE("'||l_gen_seg_name||'", null, ''NA_EDW'','||
716: newline||' "'||l_gen_seg_name||'"';

Line 728: edw_gen_view.writelog('Mapped to a non a/c flex dimension ');

724:
725:
726: ELSE
727: IF (g_log) THEN
728: edw_gen_view.writelog('Mapped to a non a/c flex dimension ');
729: edw_gen_view.writelog('Structure name is : '||cRec.structure_name);
730: END IF;
731:
732: IF (cRec.flex_field_type = 'D') THEN /* Descr Flex */

Line 729: edw_gen_view.writelog('Structure name is : '||cRec.structure_name);

725:
726: ELSE
727: IF (g_log) THEN
728: edw_gen_view.writelog('Mapped to a non a/c flex dimension ');
729: edw_gen_view.writelog('Structure name is : '||cRec.structure_name);
730: END IF;
731:
732: IF (cRec.flex_field_type = 'D') THEN /* Descr Flex */
733: IF (g_log) THEN

Line 734: edw_gen_view.writelog('struct is : '||cRec.structure_name);

730: END IF;
731:
732: IF (cRec.flex_field_type = 'D') THEN /* Descr Flex */
733: IF (g_log) THEN
734: edw_gen_view.writelog('struct is : '||cRec.structure_name);
735: END IF;
736: tempvar := replace(cRec.structure_name, '''', '''''');
737: IF (g_Log) THEN
738: edw_gen_view.writelog('struct after replace is : '||tempvar);

Line 738: edw_gen_view.writelog('struct after replace is : '||tempvar);

734: edw_gen_view.writelog('struct is : '||cRec.structure_name);
735: END IF;
736: tempvar := replace(cRec.structure_name, '''', '''''');
737: IF (g_Log) THEN
738: edw_gen_view.writelog('struct after replace is : '||tempvar);
739: END IF;
740:
741: IF (cRec.value_set_type = 'D') THEN /* Dependant VS, so different FK Structure */
742: sDecodeClause := sDecodeClause||'''';

Line 778: edw_gen_view.writelog('decode clause is : '||sDecodeClause);

774:
775: sDecodeClause := sDecodePrefix ||sDecodeClause||', ''NA_EDW'')';
776:
777: IF (g_log) THEN
778: edw_gen_view.writelog('decode clause is : '||sDecodeClause);
779: END IF;
780:
781: IF (cRec.flex_field_type = 'D') THEN
782: l_structure_col := edw_gen_view.getContextColForFlex(cRec.id_flex_code, 'D');

Line 782: l_structure_col := edw_gen_view.getContextColForFlex(cRec.id_flex_code, 'D');

778: edw_gen_view.writelog('decode clause is : '||sDecodeClause);
779: END IF;
780:
781: IF (cRec.flex_field_type = 'D') THEN
782: l_structure_col := edw_gen_view.getContextColForFlex(cRec.id_flex_code, 'D');
783: IF (g_log) THEN
784: edw_gen_view.writelog('Descr. flexfield structure column is : '||l_structure_col);
785: END IF;
786: l_structure_col:= replace(l_structure_col, '''', '''''') ;

Line 784: edw_gen_view.writelog('Descr. flexfield structure column is : '||l_structure_col);

780:
781: IF (cRec.flex_field_type = 'D') THEN
782: l_structure_col := edw_gen_view.getContextColForFlex(cRec.id_flex_code, 'D');
783: IF (g_log) THEN
784: edw_gen_view.writelog('Descr. flexfield structure column is : '||l_structure_col);
785: END IF;
786: l_structure_col:= replace(l_structure_col, '''', '''''') ;
787: IF (g_log) THEN
788: edw_gen_view.writelog('structure is : '||l_structure_col);

Line 788: edw_gen_view.writelog('structure is : '||l_structure_col);

784: edw_gen_view.writelog('Descr. flexfield structure column is : '||l_structure_col);
785: END IF;
786: l_structure_col:= replace(l_structure_col, '''', '''''') ;
787: IF (g_log) THEN
788: edw_gen_view.writelog('structure is : '||l_structure_col);
789: END IF;
790:
791: IF ( upper(cRec.structure_name)='GLOBAL DATA ELEMENTS' OR l_structure_col IS NULL) THEN
792: IF (dependantVSExists ) THEN

Line 803: l_structure_col := edw_gen_view.getContextColForFlex(cRec.id_flex_code, 'K');

799: '"'||l_gen_seg_name||'")';
800: END IF;
801: END IF;
802: ELSE /* Key Flex */
803: l_structure_col := edw_gen_view.getContextColForFlex(cRec.id_flex_code, 'K');
804: IF (g_log) THEN
805: edw_gen_view.writelog('Key flexfield structure column is : '||l_structure_col);
806: END IF;
807:

Line 805: edw_gen_view.writelog('Key flexfield structure column is : '||l_structure_col);

801: END IF;
802: ELSE /* Key Flex */
803: l_structure_col := edw_gen_view.getContextColForFlex(cRec.id_flex_code, 'K');
804: IF (g_log) THEN
805: edw_gen_view.writelog('Key flexfield structure column is : '||l_structure_col);
806: END IF;
807:
808: IF (l_structure_col IS NULL) THEN
809: IF (dependantVSExists ) THEN

Line 824: edw_gen_view.writelog('Completed getdecodeclauseforflexfk, returning '||sDecodeClause||newline||newline);

820:
821: /* DBMS_SQL.CLOSE_CURSOR(cid); */
822:
823: IF (g_log) THEN
824: edw_gen_view.writelog('Completed getdecodeclauseforflexfk, returning '||sDecodeClause||newline||newline);
825: edw_gen_view.indentEnd;
826:
827: END IF;
828:

Line 825: edw_gen_view.indentEnd;

821: /* DBMS_SQL.CLOSE_CURSOR(cid); */
822:
823: IF (g_log) THEN
824: edw_gen_view.writelog('Completed getdecodeclauseforflexfk, returning '||sDecodeClause||newline||newline);
825: edw_gen_view.indentEnd;
826:
827: END IF;
828:
829: RETURN sDecodeClause;