eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BIS_VG_COMPILE dependencies on AD_DDL

Line 214: -- force AD_DDL to behave like a single instance as we want the view

210: -- bis_debug_pub.Add('p_View_Table_Rec.View_Name = '
211: -- || p_View_Table_Rec.View_Name);
212: --*************************************************************************
213: -- BIG COMMENT
214: -- force AD_DDL to behave like a single instance as we want the view
215: -- to be created only once; here FND has been hardcoded for this purpose
216: --*************************************************************************
217: -- l_application_short_name := 'FND';
218: -- l_View_Name := p_View_Table_Rec.View_Name;

Line 222: -- bis_debug_pub.ADD(' ad_ddl.create_view = '||ad_ddl.create_view);

218: -- l_View_Name := p_View_Table_Rec.View_Name;
219: --
220: -- bis_debug_pub.Add(' l_applsys_schema = '||l_applsys_schema);
221: -- bis_debug_pub.ADD(' l_application_short_name = '||l_application_short_name);
222: -- bis_debug_pub.ADD(' ad_ddl.create_view = '||ad_ddl.create_view);
223: -- bis_debug_pub.ADD(' l_lb = '||l_lb);
224: -- bis_debug_pub.ADD(' p_ub = '||p_ub);
225: -- bis_debug_pub.ADD(' l_View_Name = '||l_View_Name);
226: --

Line 227: -- AD_DDL.do_array_ddl( l_applsys_schema

223: -- bis_debug_pub.ADD(' l_lb = '||l_lb);
224: -- bis_debug_pub.ADD(' p_ub = '||p_ub);
225: -- bis_debug_pub.ADD(' l_View_Name = '||l_View_Name);
226: --
227: -- AD_DDL.do_array_ddl( l_applsys_schema
228: -- , l_application_short_name
229: -- , ad_ddl.create_view
230: -- , l_lb
231: -- , p_ub

Line 229: -- , ad_ddl.create_view

225: -- bis_debug_pub.ADD(' l_View_Name = '||l_View_Name);
226: --
227: -- AD_DDL.do_array_ddl( l_applsys_schema
228: -- , l_application_short_name
229: -- , ad_ddl.create_view
230: -- , l_lb
231: -- , p_ub
232: -- , l_View_Name
233: -- );

Line 288: -- AD_DDL.build_statement(' '||p_View_Text_Table(l_count)||' ', l_count);

284: --BEGIN
285: -- bis_debug_pub.Add('> build_DDL_Statement');
286: -- x_return_status := FND_API.G_RET_STS_SUCCESS;
287: -- FOR l_count IN 1 .. p_View_Text_Table.COUNT LOOP
288: -- AD_DDL.build_statement(' '||p_View_Text_Table(l_count)||' ', l_count);
289: -- END LOOP;
290: -- bis_debug_pub.Add('< build_DDL_Statement');
291: --
292: --

Line 327: -- 4. p_applsys_schema name of schema tobe used in call to ad_ddl

323: --PARAMETERS:
324: -- 1. p_View_Table_Rec record of view table
325: -- 2. p_View_Create_Text_Table table of varchars for create view text
326: -- 3. p_View_Select_Text_Table table of varchars for select view text
327: -- 4. p_applsys_schema name of schema tobe used in call to ad_ddl
328: -- 5. x_return_status error or normal
329: -- 6. x_error_Tbl table of error messages
330: --COMMENT : Creates a DDL statement from the tables directly.
331: -- Best used whenthe view text is bigger than 30K.

Line 355: AD_DDL.build_statement(p_View_Create_Text_Table(l_count)

351:
352:
353: FOR l_count IN 1 .. p_View_Create_Text_Table.COUNT
354: LOOP
355: AD_DDL.build_statement(p_View_Create_Text_Table(l_count)
356: , l_count);
357: IF (p_mode <> bis_vg_types.production_mode AND
358: p_mode <> bis_vg_types.sqlplus_production_mode) THEN
359: BIS_DEBUG_PUB.Add(p_View_Create_Text_Table(l_count));

Line 367: AD_DDL.build_statement(p_View_Select_Text_Table(l_count)

363:
364: FOR l_count IN 1 .. p_View_Select_Text_Table.COUNT
365: LOOP
366: l_total := l_total+1;
367: AD_DDL.build_statement(p_View_Select_Text_Table(l_count)
368: , l_total);
369: IF (p_mode <> bis_vg_types.production_mode AND
370: p_mode <> bis_vg_types.sqlplus_production_mode) THEN
371: BIS_DEBUG_PUB.Add(p_View_Select_Text_Table(l_count));

Line 375: AD_DDL.do_array_ddl( p_applsys_schema

371: BIS_DEBUG_PUB.Add(p_View_Select_Text_Table(l_count));
372: END IF;
373:
374: END LOOP;
375: AD_DDL.do_array_ddl( p_applsys_schema
376: , 'FND' -- hardcoded to force AD_DDL
377: -- to create the view only once
378: , ad_ddl.create_view -- type
379: , 1

Line 376: , 'FND' -- hardcoded to force AD_DDL

372: END IF;
373:
374: END LOOP;
375: AD_DDL.do_array_ddl( p_applsys_schema
376: , 'FND' -- hardcoded to force AD_DDL
377: -- to create the view only once
378: , ad_ddl.create_view -- type
379: , 1
380: , l_total

Line 378: , ad_ddl.create_view -- type

374: END LOOP;
375: AD_DDL.do_array_ddl( p_applsys_schema
376: , 'FND' -- hardcoded to force AD_DDL
377: -- to create the view only once
378: , ad_ddl.create_view -- type
379: , 1
380: , l_total
381: , p_View_Name
382: );

Line 396: , p_error_description => SQLERRM||'[ '||ad_ddl.error_buf||' ]'

392: when others then
393: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
394: BIS_VG_UTIL.Add_Error_Message
395: ( p_error_msg_id => SQLCODE
396: , p_error_description => SQLERRM||'[ '||ad_ddl.error_buf||' ]'
397: , p_error_proc_name => G_PKG_NAME||'.do_long_ddl'
398: , p_error_table => x_error_tbl
399: , x_error_table => x_error_tbl
400: );

Line 415: -- 4. p_applsys_schema name of schema tobe used in call to ad_ddl

411: --PARAMETERS:
412: -- 1. p_View_name name of view table
413: -- 2. p_View_Create_Text_Table table of varchars for create view text
414: -- 3. p_View_Select_Text_Table table of varchars for select view text
415: -- 4. p_applsys_schema name of schema tobe used in call to ad_ddl
416: -- 5. x_return_status error or normal
417: -- 6. x_error_Tbl table of error messages
418: --COMMENT : Creates a DDL statement using a 28K vcarchar2.
419: -- Best used whenthe view text is smaller than 28K.

Line 481: AD_DDL.DO_DDL( p_applsys_schema

477: raise;
478:
479: END;
480:
481: AD_DDL.DO_DDL( p_applsys_schema
482: , 'FND' -- hardcoded to force AD_DDL
483: -- to create the view only once
484: , ad_ddl.create_view -- type
485: , l_buffer

Line 482: , 'FND' -- hardcoded to force AD_DDL

478:
479: END;
480:
481: AD_DDL.DO_DDL( p_applsys_schema
482: , 'FND' -- hardcoded to force AD_DDL
483: -- to create the view only once
484: , ad_ddl.create_view -- type
485: , l_buffer
486: , p_View_Name

Line 484: , ad_ddl.create_view -- type

480:
481: AD_DDL.DO_DDL( p_applsys_schema
482: , 'FND' -- hardcoded to force AD_DDL
483: -- to create the view only once
484: , ad_ddl.create_view -- type
485: , l_buffer
486: , p_View_Name
487: );
488: bis_debug_pub.Add('< do_short_ddl');

Line 509: , p_error_description => SQLERRM||'[ '||ad_ddl.error_buf||' ]'

505: when others then
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
507: BIS_VG_UTIL.Add_Error_Message
508: ( p_error_msg_id => SQLCODE
509: , p_error_description => SQLERRM||'[ '||ad_ddl.error_buf||' ]'
510: , p_error_proc_name => G_PKG_NAME||'.do_short_ddl'
511: , p_error_table => x_error_tbl
512: , x_error_table => x_error_tbl
513: );