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 BIS_VG_UTIL

Line 69: --x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type ) IS l_str

65: --============================================================================
66: --PROCEDURE remove_blank_lines ( p_view_text_table IN
67: --bis_vg_types.view_text_table_type , x_view_text_table out
68: --bis_vg_types.view_text_table_type , x_return_status OUT VARCHAR2 ,
69: --x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type ) IS l_str
70: --bis_vg_types.view_text_table_rec_type; l_char VARCHAR(1); l_length NUMBER;
71: --BEGIN
72: -- bis_debug_pub.Add('> remove_blank_lines');
73: -- x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 101: -- BIS_VG_UTIL.Add_Error_Message

97: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
99: -- when others then
100: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101: -- BIS_VG_UTIL.Add_Error_Message
102: -- ( p_error_msg_id => SQLCODE
103: -- , p_error_description => SQLERRM
104: -- , p_error_proc_name => G_PKG_NAME||'.remove_blank_lines'
105: -- , p_error_table => x_error_tbl

Line 129: --, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

125: -- ============================================================================
126: --PROCEDURE create_DSQL_view
127: --( p_View_Text_Table IN bis_vg_types.View_Text_Table_Type
128: --, x_return_status OUT VARCHAR2
129: --, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
130: --)
131: -- IS
132: ----
133: -- p_CursorID INTEGER;

Line 159: -- BIS_VG_UTIL.Add_Error_Message

155: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: -- when others then
157: --
158: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
159: -- BIS_VG_UTIL.Add_Error_Message
160: -- ( p_error_msg_id => SQLCODE
161: -- , p_error_description => SQLERRM
162: -- , p_error_proc_name => G_PKG_NAME||'.create_DSQL_view'
163: -- , p_error_table => x_error_tbl

Line 188: --, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

184: --PROCEDURE execute_DDL_Statement -- PRIVATE PROCEDURE
185: --( p_View_Table_Rec IN bis_vg_types.View_Table_Rec_Type
186: --, p_ub IN INTEGER
187: --, x_return_status OUT VARCHAR2
188: --, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
189: --)
190: --IS
191: ----
192: --l_applsys_schema VARCHAR2(100);

Line 248: -- BIS_VG_UTIL.Add_Error_Message

244: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
245: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
246: -- when others then
247: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
248: -- BIS_VG_UTIL.Add_Error_Message
249: -- ( p_error_msg_id => SQLCODE
250: -- , p_error_description => SQLERRM
251: -- , p_error_proc_name => G_PKG_NAME||'.execute_DDL_Statement'
252: -- , p_error_table => x_error_tbl

Line 278: --, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

274: -- ============================================================================
275: --PROCEDURE build_DDL_Statement -- PRIVATE PROCEDURE
276: --( p_View_Text_Table IN bis_vg_types.View_Text_Table_Type
277: --, x_return_status OUT VARCHAR2
278: --, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
279: --)
280: --IS
281: --
282: --l_count INTEGER;

Line 302: -- BIS_VG_UTIL.Add_Error_Message

298: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
299: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: -- when others then
301: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
302: -- BIS_VG_UTIL.Add_Error_Message
303: -- ( p_error_msg_id => SQLCODE
304: -- , p_error_description => SQLERRM
305: -- , p_error_proc_name => G_PKG_NAME||'.build_DDL_Statement'
306: -- , p_error_table => x_error_tbl

Line 341: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

337: , p_View_Create_Text_Table IN bis_vg_types.View_Text_Table_Type
338: , p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type
339: , p_applsys_schema IN VARCHAR2
340: , x_return_status OUT NOCOPY VARCHAR2
341: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
342: )
343:
344: IS
345: l_count NUMBER;

Line 394: BIS_VG_UTIL.Add_Error_Message

390: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 431: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

427: , p_View_Create_Text_Table IN bis_vg_types.View_Text_Table_Type
428: , p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type
429: , p_applsys_schema IN VARCHAR2
430: , x_return_status OUT NOCOPY VARCHAR2
431: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
432: )
433:
434: IS
435: l_buffer VARCHAR2(29000);

Line 507: BIS_VG_UTIL.Add_Error_Message

503: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
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

Line 540: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

536: , p_View_Column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type
537: , x_View_Column_Table IN OUT NOCOPY bis_vg_types.View_Text_Table_Type
538: , x_View_Column_Comment_Table IN OUT NOCOPY bis_vg_types.Flex_Column_Comment_Table_Type
539: , x_return_status OUT NOCOPY VARCHAR2
540: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
541: )
542: IS
543: --
544: l_column_name bis_vg_types.View_Text_Table_Rec_Type;

Line 606: BIS_VG_UTIL.Add_Error_Message

602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: when others then
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
606: BIS_VG_UTIL.Add_Error_Message
607: ( p_error_msg_id => SQLCODE
608: , p_error_description => SQLERRM
609: , p_error_proc_name => G_PKG_NAME||'.make_column_len30'
610: , p_error_table => x_error_tbl

Line 637: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

633: FUNCTION find_column -- PRIVATE FUNCTION
634: ( p_column_name IN bis_vg_types.View_Text_Table_Rec_Type
635: , p_View_Text_Count_Table IN View_Text_Count_Table_Type
636: , x_return_status OUT NOCOPY VARCHAR2
637: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
638: )
639: RETURN NUMBER IS
640: --
641: BEGIN

Line 664: BIS_VG_UTIL.Add_Error_Message

660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
661: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
662: when others then
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
664: BIS_VG_UTIL.Add_Error_Message
665: ( p_error_msg_id => SQLCODE
666: , p_error_description => SQLERRM
667: , p_error_proc_name => G_PKG_NAME||'.find_column'
668: , p_error_table => x_error_tbl

Line 695: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

691: ( p_column_name IN bis_vg_types.View_Text_Table_Rec_Type
692: , p_table_column_name IN bis_vg_types.View_Text_Table_Rec_Type
693: , x_column_name IN OUT NOCOPY bis_vg_types.View_Text_Table_Rec_Type
694: , x_return_status OUT NOCOPY VARCHAR2
695: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
696: )
697: IS
698: --
699: l_pos NUMBER;

Line 723: BIS_VG_UTIL.Add_Error_Message

719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: when others then
722: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
723: BIS_VG_UTIL.Add_Error_Message
724: ( p_error_msg_id => SQLCODE
725: , p_error_description => SQLERRM
726: , p_error_proc_name => G_PKG_NAME||'.insert_hat_in_column'
727: , p_error_table => x_error_tbl

Line 757: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

753: , p_View_Column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type
754: , x_View_Column_Table IN OUT NOCOPY bis_vg_types.View_Text_Table_Type
755: , x_View_Column_Comment_Table IN OUT NOCOPY bis_vg_types.Flex_Column_Comment_Table_Type
756: , x_return_status OUT NOCOPY VARCHAR2
757: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
758: )
759: IS
760: --
761: l_View_Text_Count_Table View_Text_Count_Table_Type;

Line 827: BIS_VG_UTIL.Add_Error_Message

823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: when others then
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
827: BIS_VG_UTIL.Add_Error_Message
828: ( p_error_msg_id => SQLCODE
829: , p_error_description => SQLERRM
830: , p_error_proc_name => G_PKG_NAME||'.make_unique_columns'
831: , p_error_table => x_error_tbl

Line 857: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

853: , p_View_Column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type
854: , x_View_Column_Table IN OUT NOCOPY bis_vg_types.View_Text_Table_Type
855: , x_View_Column_Comment_Table IN OUT NOCOPY bis_vg_types.Flex_Column_Comment_Table_Type
856: , x_return_status OUT NOCOPY VARCHAR2
857: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
858: )
859: IS
860: l_length NUMBER;
861: l_x_View_Column_Table bis_vg_types.View_Text_Table_Type;

Line 955: BIS_VG_UTIL.Add_Error_Message

951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
952: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
953: when others then
954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
955: BIS_VG_UTIL.Add_Error_Message
956: ( p_error_msg_id => SQLCODE
957: , p_error_description => SQLERRM
958: , p_error_proc_name => G_PKG_NAME||'.format_columns'
959: , p_error_table => x_error_tbl

Line 991: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type

987: , x_View_Column_Table OUT NOCOPY bis_vg_types.View_Text_Table_Type
988: , x_View_Column_Comment_Table OUT NOCOPY bis_vg_types.Flex_Column_Comment_Table_Type
989:
990: ---, x_return_status OUT VARCHAR2
991: , x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
992: )
993: IS
994: --
995: l_count INTEGER := 1;

Line 1015: x_View_Name := bis_vg_util.get_generated_view_name

1011: BEGIN
1012: bis_debug_pub.Add('> format_Table');
1013: --- x_return_status := FND_API.G_RET_STS_SUCCESS;
1014: l_pos := INSTRB(p_View_Name, 'V_');
1015: x_View_Name := bis_vg_util.get_generated_view_name
1016: ( p_View_name
1017: , l_dummy
1018: , x_error_Tbl
1019: );

Line 1104: BIS_VG_UTIL.Add_Error_Message

1100: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1101: RAISE;
1102: when others then
1103: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104: BIS_VG_UTIL.Add_Error_Message
1105: ( p_error_msg_id => SQLCODE
1106: , p_error_description => SQLERRM
1107: , p_error_proc_name => G_PKG_NAME||'.format_Table'
1108: , p_error_table => x_error_tbl

Line 1142: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1138: , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
1139: , p_View_Column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type
1140: , x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
1141: ---, x_return_status OUT VARCHAR2
1142: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1143: )
1144: IS
1145: --
1146: l_View_Create_Text_Table bis_vg_types.View_Text_Table_Type;

Line 1222: BIS_VG_UTIL.Add_Error_Message

1218: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: RAISE;
1220: when others then
1221: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1222: BIS_VG_UTIL.Add_Error_Message
1223: ( p_error_msg_id => SQLCODE
1224: , p_error_description => SQLERRM
1225: , p_error_proc_name => G_PKG_NAME||'.write_View'
1226: , p_error_table => x_error_tbl