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_VIEW_GENERATOR_PVT dependencies on BIS_VG_UTIL

Line 214: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

210: ( p_view_table IN bis_vg_types.View_Text_Table_Type
211: , p_string_set IN bis_vg_types.View_Text_Table_Type
212: , p_start_pointer IN bis_vg_types.View_Character_Pointer_Type
213: , x_return_status OUT VARCHAR2
214: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
215: )
216: RETURN bis_vg_types.view_character_pointer_type
217: IS
218: l_pointer bis_vg_types.View_Character_Pointer_Type;

Line 235: IF (bis_vg_util.null_pointer( l_pointer

231: , l_pointer
232: , x_return_status
233: , x_error_Tbl
234: );
235: IF (bis_vg_util.null_pointer( l_pointer
236: , x_return_status
237: , x_error_Tbl
238: ) = TRUE
239: ) THEN

Line 244: l_save_pointer := bis_vg_util.decrement_pointer

240: l_done := TRUE;
241: ELSIF(l_pointer.col_num = 1) THEN
242: l_done := TRUE;
243: ELSE
244: l_save_pointer := bis_vg_util.decrement_pointer
245: ( p_view_table
246: , l_pointer
247: , x_return_status
248: , x_error_Tbl

Line 250: l_char := bis_vg_util.get_char

246: , l_pointer
247: , x_return_status
248: , x_error_Tbl
249: );
250: l_char := bis_vg_util.get_char
251: ( p_view_table
252: , l_save_pointer
253: , x_return_status
254: , x_error_Tbl

Line 259: l_pointer := bis_vg_util.increment_pointer

255: );
256: IF(l_char = '''') THEN
257: l_done := TRUE;
258: ELSE
259: l_pointer := bis_vg_util.increment_pointer
260: ( p_view_table
261: , l_pointer
262: , x_return_status
263: , x_error_Tbl

Line 281: BIS_VG_UTIL.Add_Error_Message

277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
279: when others then
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
281: BIS_VG_UTIL.Add_Error_Message
282: ( p_error_msg_id => SQLCODE
283: , p_error_description => SQLERRM
284: , p_error_proc_name => G_PKG_NAME||'.get_tag_keyword_position'
285: , p_error_table => x_error_tbl

Line 329: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

325: , x_column_comment_table OUT bis_vg_types.Flex_Column_Comment_Table_Type
326: , x_column_pointer OUT bis_vg_types.view_character_pointer_type
327: , x_select_pointer OUT bis_vg_types.view_character_pointer_type
328: , x_return_status OUT VARCHAR2
329: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
330: )
331: IS
332: l_str VARCHAR2(300);
333: l_sel_str VARCHAR2(300);

Line 342: --- bis_vg_util.print_view_pointer ( p_select_pointer

338: bis_debug_pub.Add('> update_flexfields');
339: x_return_status := FND_API.G_RET_STS_SUCCESS;
340: --
341: --- --- --- DEBUG ---
342: --- bis_vg_util.print_view_pointer ( p_select_pointer
343: --- , x_return_status
344: --- , x_error_Tbl
345: --- );
346: l_str := bis_vg_util.get_row( p_view_select_text_table

Line 346: l_str := bis_vg_util.get_row( p_view_select_text_table

342: --- bis_vg_util.print_view_pointer ( p_select_pointer
343: --- , x_return_status
344: --- , x_error_Tbl
345: --- );
346: l_str := bis_vg_util.get_row( p_view_select_text_table
347: , p_select_pointer
348: , x_return_status
349: , x_error_Tbl
350: );

Line 363: l_str := bis_vg_util.get_row( p_view_column_text_table

359: );
360: l_sel_str := UPPER(l_str);
361: --
362: bis_debug_pub.Add('l_sel_str = '||l_sel_str);
363: l_str := bis_vg_util.get_row( p_view_column_text_table
364: , p_column_pointer
365: , x_return_status
366: , x_error_Tbl
367: );

Line 380: l_pointer := bis_vg_util.increment_pointer_by_row

376: );
377: l_str := UPPER(l_str);
378: IF (l_col IS NULL) THEN
379: bis_debug_pub.Add('out pointer is null');
380: l_pointer := bis_vg_util.increment_pointer_by_row
381: ( p_view_column_text_table
382: , p_column_pointer
383: , x_return_status
384: , x_error_Tbl

Line 393: BIS_VG_UTIL.Add_Error_message

389: END IF;
390: --
391: IF (l_str <> l_sel_str) THEN
392:
393: BIS_VG_UTIL.Add_Error_message
394: ( p_error_msg_name => MISMATCHED_TAG_EXCEPTION_MSG
395: , p_error_proc_name => G_PKG_NAME||'.update_flexfields'
396: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
397: , p_error_table => x_error_tbl

Line 422: --- bis_vg_util.print_View_Text

418: , x_return_status
419: , x_error_Tbl
420: );
421: --- --- --- DEBUG ----
422: --- bis_vg_util.print_View_Text
423: --- ( x_Column_Table
424: --- , x_return_status
425: --- , x_error_Tbl
426: --- );

Line 427: --- bis_vg_util.print_View_Text

423: --- ( x_Column_Table
424: --- , x_return_status
425: --- , x_error_Tbl
426: --- );
427: --- bis_vg_util.print_View_Text
428: --- ( x_Select_Table
429: --- , x_return_status
430: --- , x_error_Tbl
431: --- );

Line 480: BIS_VG_UTIL.Add_Error_Message

476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: when others then
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
480: BIS_VG_UTIL.Add_Error_Message
481: ( p_error_msg_id => SQLCODE
482: , p_error_description => SQLERRM
483: , p_error_proc_name => G_PKG_NAME||'. update_flexfields'
484: , p_error_table => x_error_tbl

Line 511: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

507: , p_Select_Pointer IN bis_vg_types.view_character_pointer_type
508: , p_start_pointer IN bis_vg_types.view_character_pointer_type
509: , x_Select_Pointer OUT bis_vg_types.view_character_pointer_type
510: , x_return_status OUT VARCHAR2
511: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
512: )
513: RETURN NUMBER
514: IS
515: --

Line 522: WHILE( bis_vg_util.get_char( p_View_Select_Text_Table

518: BEGIN
519: bis_debug_pub.Add('> exclude_comma');
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521: l_select_pointer := p_Select_Pointer;
522: WHILE( bis_vg_util.get_char( p_View_Select_Text_Table
523: , l_select_pointer
524: , x_return_status
525: , x_error_Tbl
526: )

Line 529: l_select_pointer := bis_vg_util.decrement_pointer

525: , x_error_Tbl
526: )
527: <> ','
528: ) LOOP
529: l_select_pointer := bis_vg_util.decrement_pointer
530: ( p_View_Select_Text_Table
531: , l_select_pointer
532: , x_return_status
533: , x_error_Tbl

Line 535: IF(bis_vg_util.equal_pointers

531: , l_select_pointer
532: , x_return_status
533: , x_error_Tbl
534: );
535: IF(bis_vg_util.equal_pointers
536: ( l_select_pointer
537: , p_start_pointer
538: , x_return_status
539: , x_error_Tbl

Line 548: IF (NOT bis_vg_util.equal_pointers

544: bis_debug_pub.Add('< exclude_comma_before_tag');
545: RETURN 0;
546: END IF;
547: END LOOP;
548: IF (NOT bis_vg_util.equal_pointers
549: ( l_select_pointer
550: , p_start_pointer
551: , x_return_status
552: , x_error_Tbl

Line 556: x_select_pointer := bis_vg_util.decrement_pointer

552: , x_error_Tbl
553: )
554: )
555: THEN
556: x_select_pointer := bis_vg_util.decrement_pointer
557: ( p_View_Select_Text_Table
558: , l_select_pointer
559: , x_return_status
560: , x_error_Tbl

Line 574: BIS_VG_UTIL.Add_Error_Message

570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: when others then
573: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
574: BIS_VG_UTIL.Add_Error_Message
575: ( p_error_msg_id => SQLCODE
576: , p_error_description => SQLERRM
577: , p_error_proc_name => G_PKG_NAME||'. exclude_comma_before_tag'
578: , p_error_table => x_error_tbl

Line 604: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

600: , p_Select_Pointer IN bis_vg_types.view_character_pointer_type
601: , p_end_pointer IN bis_vg_types.view_character_pointer_type
602: , x_Select_Pointer OUT bis_vg_types.view_character_pointer_type
603: , x_return_status OUT VARCHAR2
604: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
605: )
606: IS
607: --
608: l_select_pointer bis_vg_types.view_character_pointer_type;

Line 614: WHILE( bis_vg_util.get_char( p_View_Select_Text_Table

610: BEGIN
611: bis_debug_pub.Add('> exclude_comma_after_tag');
612: x_return_status := FND_API.G_RET_STS_SUCCESS;
613: l_select_pointer := p_Select_Pointer;
614: WHILE( bis_vg_util.get_char( p_View_Select_Text_Table
615: , l_select_pointer
616: , x_return_status
617: , x_error_Tbl
618: )

Line 621: l_select_pointer := bis_vg_util.increment_pointer

617: , x_error_Tbl
618: )
619: <> ','
620: ) LOOP
621: l_select_pointer := bis_vg_util.increment_pointer
622: ( p_View_Select_Text_Table
623: , l_select_pointer
624: , x_return_status
625: , x_error_Tbl

Line 627: IF(bis_vg_util.equal_pointers

623: , l_select_pointer
624: , x_return_status
625: , x_error_Tbl
626: );
627: IF(bis_vg_util.equal_pointers
628: ( l_select_pointer
629: , p_end_pointer
630: , x_return_status
631: , x_error_Tbl

Line 641: IF (NOT bis_vg_util.equal_pointers

637: RETURN;
638: END IF;
639: END LOOP;
640: -- we are currently pointing to ',' position beyond that
641: IF (NOT bis_vg_util.equal_pointers
642: ( l_select_pointer
643: , p_end_pointer
644: , x_return_status
645: , x_error_Tbl

Line 649: x_select_pointer := bis_vg_util.increment_pointer

645: , x_error_Tbl
646: )
647: )
648: THEN
649: x_select_pointer := bis_vg_util.increment_pointer
650: ( p_View_Select_Text_Table
651: , l_select_pointer
652: , x_return_status
653: , x_error_Tbl

Line 667: BIS_VG_UTIL.Add_Error_Message

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

Line 699: , x_error_Tbl OUT BIS_VG_UTIL.error_tbl_type

695: PROCEDURE Get_base_Table_Cols
696: ( p_extra_columns IN superset_table_type
697: , x_unique_tables OUT superset_summary_table_type
698: , x_column_table OUT bis_vg_types.View_Text_Table_Type
699: , x_error_Tbl OUT BIS_VG_UTIL.error_tbl_type
700: )
701: IS
702: l_table_count PLS_INTEGER ;
703:

Line 758: BIS_VG_UTIL.Add_Error_Message

754: RAISE FND_API.G_EXC_ERROR;
755: when FND_API.G_EXC_UNEXPECTED_ERROR then
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757: when others then
758: BIS_VG_UTIL.Add_Error_Message
759: ( p_error_msg_id => SQLCODE
760: , p_error_description => SQLERRM
761: , p_error_proc_name => G_PKG_NAME||'.Get_base_Table_Cols'
762: , p_error_table => x_error_tbl

Line 797: , x_error_Tbl OUT BIS_VG_UTIL.error_tbl_type

793: , p_start_pos IN bis_vg_types.View_Character_Pointer_Type
794: , p_unique_tables IN superset_summary_table_type
795: , p_extra_columns IN superset_table_type
796: , x_select_table OUT bis_vg_types.View_Text_Table_Type
797: , x_error_Tbl OUT BIS_VG_UTIL.error_tbl_type
798: )
799: IS
800: l_pos bis_vg_types.View_Character_Pointer_Type;
801: l_end PLS_INTEGER;

Line 821: l_pos := bis_vg_util.increment_pointer_by_row

817: , l_dummy
818: , x_error_Tbl
819: );
820: IF l_end IS NULL THEN ---- reached end of row
821: l_pos := bis_vg_util.increment_pointer_by_row
822: ( p_view_select_table
823: , p_start_pos
824: , l_dummy
825: , x_error_Tbl

Line 833: WHILE (bis_vg_util.null_pointer(l_pos, l_dummy, x_error_tbl) = FALSE)

829: l_pos.col_num := l_end;
830: END IF;
831:
832:
833: WHILE (bis_vg_util.null_pointer(l_pos, l_dummy, x_error_tbl) = FALSE)
834:
835: LOOP
836: l_str := upper(bis_vg_parser.get_string_token
837: ( p_view_select_table(l_pos.row_num)

Line 851: l_pos := bis_vg_util.increment_pointer_by_row

847: l_str = 'UNION'
848: );
849: IF l_end IS NULL
850: THEN
851: l_pos := bis_vg_util.increment_pointer_by_row
852: ( p_view_select_table
853: , l_pos
854: , l_dummy
855: , x_error_Tbl

Line 883: l_pos := bis_vg_util.increment_pointer_by_row

879: l_unique_tabs(l_table_count).currently_valid := TRUE;
880: --- increment l_pos to the next string
881: IF l_end IS NULL
882: THEN
883: l_pos := bis_vg_util.increment_pointer_by_row
884: ( p_view_select_table
885: , l_pos
886: , l_dummy
887: , x_error_Tbl

Line 940: BIS_VG_UTIL.Add_Error_Message

936: RAISE FND_API.G_EXC_ERROR;
937: when FND_API.G_EXC_UNEXPECTED_ERROR then
938: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
939: when others then
940: BIS_VG_UTIL.Add_Error_Message
941: ( p_error_msg_id => SQLCODE
942: , p_error_description => SQLERRM
943: , p_error_proc_name => G_PKG_NAME||'.Get_Base_Table_Selects'
944: , p_error_table => x_error_tbl

Line 982: , x_error_Tbl OUT BIS_VG_UTIL.error_tbl_type

978: , p_extra_columns IN superset_table_type := NULL
979: , x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type
980: , x_View_Select_Text_Table OUT bis_vg_types.View_Text_Table_Type
981: , x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
982: , x_error_Tbl OUT BIS_VG_UTIL.error_tbl_type
983: )
984: IS
985: l_col_tab_curr_pos bis_vg_types.view_character_pointer_type;
986: l_sel_tab_curr_pos bis_vg_types.view_character_pointer_type;

Line 1026: --- bis_vg_util.print_View_Text

1022: --- IF (g_mode = bis_vg_types.test_view_gen_mode) THEN
1023: --- bis_debug_pub.debug_on;
1024: --- END IF;
1025: ---
1026: --- bis_vg_util.print_View_Text
1027: --- ( p_View_Column_Text_Table
1028: --- , l_dummy
1029: --- , x_error_Tbl
1030: --- );

Line 1031: --- bis_vg_util.print_View_Text

1027: --- ( p_View_Column_Text_Table
1028: --- , l_dummy
1029: --- , x_error_Tbl
1030: --- );
1031: --- bis_vg_util.print_View_Text
1032: --- ( p_View_Select_Text_Table
1033: --- , l_dummy
1034: --- , x_error_Tbl
1035: --- );

Line 1085: --- bis_vg_util.print_view_pointer( l_col_tab_past_pos

1081: , l_dummy
1082: , x_error_Tbl
1083: );
1084: --- --- --- DEBUG ---
1085: --- bis_vg_util.print_view_pointer( l_col_tab_past_pos
1086: --- , l_dummy
1087: --- , x_error_Tbl
1088: --- );
1089: IF (l_col_tab_curr_pos.row_num IS NOT NULL) THEN

Line 1103: --- bis_vg_util.print_view_pointer( l_col_tab_past_pos

1099: l_col_tab_pretag_pos := l_col_tab_curr_pos;
1100: l_sel_tab_pretag_pos := l_sel_tab_curr_pos;
1101: bis_debug_pub.Add('PREV COLUMN POINTER');
1102: --- --- --- DEBUG ---
1103: --- bis_vg_util.print_view_pointer( l_col_tab_past_pos
1104: --- , l_dummy
1105: --- , x_error_Tbl
1106: --- );
1107: -- update the flex fields

Line 1124: l_sel_tab_pretag_pos := bis_vg_util.position_before_characters

1120: , l_dummy
1121: , x_error_Tbl
1122: );
1123: -- position the pointer before the last single quote in select
1124: l_sel_tab_pretag_pos := bis_vg_util.position_before_characters
1125: ( p_view_select_text_table
1126: , '''' ----||' '||' '
1127: , l_sel_tab_pretag_pos
1128: , l_dummy

Line 1132: --- bis_vg_util.print_view_pointer ( l_sel_tab_pretag_pos

1128: , l_dummy
1129: , x_error_Tbl
1130: );
1131: --- --- --- DEBUG ---
1132: --- bis_vg_util.print_view_pointer ( l_sel_tab_pretag_pos
1133: --- , l_dummy
1134: --- , x_error_Tbl
1135: --- );
1136: -- if tag generated an empty table (empty _DF or remove_tags mode)

Line 1168: -- bis_vg_util.print_view_pointer

1164:
1165: END IF; -- end of tag generated an empty table
1166: --
1167: bis_debug_pub.ADD('right after positioning before');
1168: -- bis_vg_util.print_view_pointer
1169: -- ( l_sel_tab_pretag_pos
1170: -- , l_dummy
1171: -- , x_error_Tbl
1172: -- );

Line 1179: l_sel_tab_pretag_pos := BIS_VG_UTIL.increment_pointer

1175: -- if we have a valid character at the current position, we need
1176: -- to increment the pointers as the copy function copies
1177: -- exclusive of the end pointer
1178: --
1179: l_sel_tab_pretag_pos := BIS_VG_UTIL.increment_pointer
1180: ( p_view_select_text_table
1181: , l_sel_tab_pretag_pos
1182: , l_dummy
1183: , x_error_Tbl

Line 1190: --- bis_vg_util.print_view_pointer

1186: -- to output tables
1187: --
1188: bis_debug_pub.Add('PREV COLUMN POINTER');
1189: --- --- --- DEBUG ---
1190: --- bis_vg_util.print_view_pointer
1191: --- (l_col_tab_past_pos
1192: --- , l_dummy
1193: --- , x_error_Tbl
1194: --- );

Line 1195: bis_vg_util.copy_part_of_table

1191: --- (l_col_tab_past_pos
1192: --- , l_dummy
1193: --- , x_error_Tbl
1194: --- );
1195: bis_vg_util.copy_part_of_table
1196: ( p_view_column_text_table
1197: , l_col_tab_past_pos
1198: , l_col_tab_pretag_pos
1199: , l_temp_column_table

Line 1204: bis_vg_util.print_view_text(l_temp_column_table

1200: , l_dummy
1201: , x_error_Tbl
1202: );
1203: bis_debug_pub.ADD('Copy column table is ');
1204: bis_vg_util.print_view_text(l_temp_column_table
1205: , l_dummy
1206: , x_error_Tbl
1207: );
1208:

Line 1211: bis_vg_util.concatenate_tables( x_view_column_text_table

1207: );
1208:
1209: IF(l_in_union = FALSE) THEN
1210: --- Column table only traversed once for a union
1211: bis_vg_util.concatenate_tables( x_view_column_text_table
1212: , l_temp_column_table
1213: , x_view_column_text_table
1214: , l_dummy
1215: , x_error_Tbl

Line 1220: --- bis_vg_util.print_view_text

1216: );
1217:
1218: --- --- --- DEBUG ---
1219: --- bis_debug_pub.ADD('Concatenated column table is ');
1220: --- bis_vg_util.print_view_text
1221: --- ( x_view_column_text_table
1222: --- , l_dummy
1223: --- , x_error_Tbl
1224: --- );

Line 1229: --- bis_vg_util.print_view_pointer

1225: END IF;
1226: --
1227: --- --- --- DEBUG ---
1228: --- bis_debug_pub.ADD('beore Copy select table');
1229: --- bis_vg_util.print_view_pointer
1230: --- ( l_sel_tab_past_pos
1231: --- , l_dummy
1232: --- , x_error_Tbl
1233: --- );

Line 1235: --- bis_vg_util.get_char( p_view_select_text_table

1231: --- , l_dummy
1232: --- , x_error_Tbl
1233: --- );
1234: --- bis_debug_pub.ADD( 'l_char := '||
1235: --- bis_vg_util.get_char( p_view_select_text_table
1236: --- , l_sel_tab_past_pos
1237: --- , l_dummy
1238: --- , x_error_Tbl
1239: --- )

Line 1242: bis_vg_util.copy_part_of_table( p_view_select_text_table

1238: --- , x_error_Tbl
1239: --- )
1240: --- );
1241: ---
1242: bis_vg_util.copy_part_of_table( p_view_select_text_table
1243: , l_sel_tab_past_pos
1244: , l_sel_tab_pretag_pos
1245: , l_temp_select_table
1246: , l_dummy

Line 1251: --- bis_vg_util.print_view_text

1247: , x_error_Tbl
1248: );
1249: --- --- --- DEBUG ---
1250: --- bis_debug_pub.ADD('Copy select table is ');
1251: --- bis_vg_util.print_view_text
1252: --- ( l_temp_select_table
1253: --- , l_dummy
1254: --- , x_error_Tbl
1255: --- );

Line 1257: bis_vg_util.concatenate_tables( x_view_select_text_table

1253: --- , l_dummy
1254: --- , x_error_Tbl
1255: --- );
1256: ---
1257: bis_vg_util.concatenate_tables( x_view_select_text_table
1258: , l_temp_select_table
1259: , x_view_select_text_table
1260: , l_dummy
1261: , x_error_Tbl

Line 1266: --- bis_vg_util.print_view_text

1262: );
1263:
1264: --- --- --- DEBUG ---
1265: --- bis_debug_pub.ADD('Concatenated select table is ');
1266: --- bis_vg_util.print_view_text
1267: --- ( x_view_select_text_table
1268: --- , l_dummy
1269: --- , x_error_Tbl
1270: --- );

Line 1278: bis_vg_util.concatenate_tables( x_view_column_text_table

1274: IF (l_column_table.COUNT > 0) THEN
1275: --- concatenate expanded flexfield columns to output
1276: IF(l_in_union = FALSE) THEN
1277: --- first the column headings
1278: bis_vg_util.concatenate_tables( x_view_column_text_table
1279: , l_column_table
1280: , x_view_column_text_table
1281: , l_dummy
1282: , x_error_Tbl

Line 1285: bis_vg_util.concatenate_tables( x_view_column_comment_table

1281: , l_dummy
1282: , x_error_Tbl
1283: );
1284: --- get the column comments
1285: bis_vg_util.concatenate_tables( x_view_column_comment_table
1286: , l_column_comment_table
1287: , x_view_column_comment_table
1288: , l_dummy
1289: , x_error_Tbl

Line 1293: bis_vg_util.concatenate_tables( x_view_select_text_table

1289: , x_error_Tbl
1290: );
1291: END IF;
1292: --- second - the select statement
1293: bis_vg_util.concatenate_tables( x_view_select_text_table
1294: , l_select_table
1295: , x_view_select_text_table
1296: , l_dummy
1297: , x_error_Tbl

Line 1304: --- bis_vg_util.print_view_text

1300:
1301: bis_debug_pub.Add('after concatenation of tables');
1302:
1303: --- --- --- DEBUG ---
1304: --- bis_vg_util.print_view_text
1305: --- ( x_view_column_text_table
1306: --- , l_dummy
1307: --- , x_error_Tbl
1308: --- );

Line 1309: --- bis_vg_util.print_view_text

1305: --- ( x_view_column_text_table
1306: --- , l_dummy
1307: --- , x_error_Tbl
1308: --- );
1309: --- bis_vg_util.print_view_text
1310: --- (x_view_select_text_table
1311: --- , l_dummy
1312: --- , x_error_Tbl
1313: --- );

Line 1328: bis_vg_util.copy_part_of_table

1324: --- bis_debug_pub.Add('out of col loop');
1325: --
1326: -- out of the columns, copy the last part of the column table
1327: IF(l_in_union = FALSE) THEN
1328: bis_vg_util.copy_part_of_table
1329: ( p_view_column_text_table
1330: , l_col_tab_past_pos
1331: , l_col_tab_curr_pos --- defaults to end of table if null
1332: , l_column_table

Line 1339: --- bis_vg_util.print_view_text(l_column_table

1335: );
1336:
1337: --- --- --- DEBUG ---
1338: --- bis_debug_pub.ADD('Copy column table is ');
1339: --- bis_vg_util.print_view_text(l_column_table
1340: --- , l_dummy
1341: --- , x_error_Tbl
1342: --- );
1343:

Line 1344: bis_vg_util.concatenate_tables( x_view_column_text_table

1340: --- , l_dummy
1341: --- , x_error_Tbl
1342: --- );
1343:
1344: bis_vg_util.concatenate_tables( x_view_column_text_table
1345: , l_column_table
1346: , x_view_column_text_table
1347: , l_dummy
1348: , x_error_Tbl

Line 1353: --- bis_vg_util.print_view_text( x_view_column_text_table

1349: );
1350:
1351: --- --- --- DEBUG ---
1352: --- bis_debug_pub.ADD('Concatenated column table is ');
1353: --- bis_vg_util.print_view_text( x_view_column_text_table
1354: --- , l_dummy
1355: --- , x_error_Tbl
1356: --- );
1357:

Line 1369: --- bis_vg_util.print_view_pointer ( l_sel_tab_FROM_pos

1365: AND x_view_column_text_table.COUNT > 0
1366: )
1367: THEN
1368: --- --- --- DEBUG ---
1369: --- bis_vg_util.print_view_pointer ( l_sel_tab_FROM_pos
1370: --- , l_dummy
1371: --- , x_error_Tbl
1372: --- );
1373: IF (l_in_union = FALSE)

Line 1380: bis_vg_util.concatenate_tables( x_view_column_text_table

1376: , l_unique_tables
1377: , l_Column_Table
1378: , x_error_Tbl
1379: );
1380: bis_vg_util.concatenate_tables( x_view_column_text_table
1381: , l_column_table
1382: , x_view_column_text_table
1383: , l_dummy
1384: , x_error_Tbl

Line 1401: bis_vg_util.concatenate_tables( x_view_select_text_table

1397: , l_select_table
1398: , x_error_Tbl
1399: );
1400:
1401: bis_vg_util.concatenate_tables( x_view_select_text_table
1402: , l_select_table
1403: , x_view_select_text_table
1404: , l_dummy
1405: , x_error_Tbl

Line 1424: --- bis_vg_util.print_view_pointer ( l_sel_tab_sec_tag_pos

1420: );
1421: --- --- --- DEBUG ---
1422: ---
1423:
1424: --- bis_vg_util.print_view_pointer ( l_sel_tab_sec_tag_pos
1425: --- , l_dummy
1426: --- , x_error_Tbl
1427: --- );
1428: ---

Line 1430: IF (bis_vg_util.null_pointer ( l_sel_tab_sec_tag_pos

1426: --- , x_error_Tbl
1427: --- );
1428: ---
1429: -- see if where pointer pointing to security is good
1430: IF (bis_vg_util.null_pointer ( l_sel_tab_sec_tag_pos
1431: , l_dummy
1432: , x_error_Tbl
1433: )
1434: = FALSE

Line 1439: l_sel_tab_pretag_pos := bis_vg_util.position_before_characters

1435: )
1436: THEN
1437: -- copy part of select table from FROM pointer to security pointer
1438: bis_debug_pub.Add('security pointer is not null');
1439: l_sel_tab_pretag_pos := bis_vg_util.position_before_characters
1440: ( p_view_select_text_table
1441: , ' ,'
1442: , l_sel_tab_sec_tag_pos
1443: , l_dummy

Line 1446: bis_vg_util.copy_part_of_table( p_view_select_text_table

1442: , l_sel_tab_sec_tag_pos
1443: , l_dummy
1444: , x_error_Tbl
1445: );
1446: bis_vg_util.copy_part_of_table( p_view_select_text_table
1447: , l_sel_tab_past_pos
1448: , l_sel_tab_pretag_pos
1449: , l_select_table
1450: , l_dummy

Line 1453: bis_vg_util.concatenate_tables( x_view_select_text_table

1449: , l_select_table
1450: , l_dummy
1451: , x_error_Tbl
1452: );
1453: bis_vg_util.concatenate_tables( x_view_select_text_table
1454: , l_select_table
1455: , x_view_select_text_table
1456: , l_dummy
1457: , x_error_Tbl

Line 1470: --- bis_vg_util.print_view_pointer ( l_sel_tab_past_pos

1466:
1467: --- --- --- DEBUG ---
1468: ---
1469: --- bis_debug_pub.Add('security pointer after add security info');
1470: --- bis_vg_util.print_view_pointer ( l_sel_tab_past_pos
1471: --- , l_dummy
1472: --- , x_error_Tbl
1473: --- );
1474: ---

Line 1475: bis_vg_util.concatenate_tables( x_view_select_text_table

1471: --- , l_dummy
1472: --- , x_error_Tbl
1473: --- );
1474: ---
1475: bis_vg_util.concatenate_tables( x_view_select_text_table
1476: , l_select_table
1477: , x_view_select_text_table
1478: , l_dummy
1479: , x_error_Tbl

Line 1493: --- bis_vg_util.print_view_pointer ( l_sel_tab_past_pos

1489: -- position at the next select statement
1490: --
1491:
1492: --- --- --- DEBUG ---
1493: --- bis_vg_util.print_view_pointer ( l_sel_tab_past_pos
1494: --- , l_dummy
1495: --- , x_error_Tbl
1496: --- );
1497:

Line 1510: --- bis_vg_util.print_view_pointer ( l_sel_tab_curr_pos

1506:
1507:
1508: --- --- --- DEBUG ---
1509: ---
1510: --- bis_vg_util.print_view_pointer ( l_sel_tab_curr_pos
1511: --- , l_dummy
1512: --- , x_error_Tbl
1513: --- );
1514: ---

Line 1528: bis_vg_util.copy_part_of_table( p_view_select_text_table

1524: END IF;
1525: --
1526: l_sel_tab_SELECT_pos := l_sel_tab_curr_pos;
1527: -- copy up to next select statement
1528: bis_vg_util.copy_part_of_table( p_view_select_text_table
1529: , l_sel_tab_past_pos
1530: , l_sel_tab_curr_pos
1531: , l_select_table
1532: , l_dummy

Line 1540: --- bis_vg_util.print_view_text(l_select_table

1536:
1537: --- --- --- DEBUG ---
1538: ---
1539: --- bis_debug_pub.ADD('Copy select table is ');
1540: --- bis_vg_util.print_view_text(l_select_table
1541: --- , l_dummy
1542: --- , x_error_Tbl
1543: --- );
1544: ---

Line 1545: bis_vg_util.concatenate_tables( x_view_select_text_table

1541: --- , l_dummy
1542: --- , x_error_Tbl
1543: --- );
1544: ---
1545: bis_vg_util.concatenate_tables( x_view_select_text_table
1546: , l_select_table
1547: , x_view_select_text_table
1548: , l_dummy
1549: , x_error_Tbl

Line 1552: bis_vg_util.concatenate_tables( x_view_column_comment_table

1548: , l_dummy
1549: , x_error_Tbl
1550: );
1551: /*
1552: bis_vg_util.concatenate_tables( x_view_column_comment_table
1553: , l_column_comment_table
1554: , x_view_column_comment_table
1555: , l_dummy
1556: , x_error_Tbl

Line 1563: --- bis_vg_util.print_view_text ( x_view_select_text_table

1559:
1560: --- --- --- DEBUG ---
1561: ---
1562: --- bis_debug_pub.ADD('Concatenated select table is ');
1563: --- bis_vg_util.print_view_text ( x_view_select_text_table
1564: --- , l_dummy
1565: --- , x_error_Tbl
1566: --- );
1567: ---

Line 1577: --- bis_vg_util.print_View_Text

1573:
1574: --- --- --- DEBUG ---
1575: ---
1576: --- bis_debug_pub.ADD('out of the select loop');
1577: --- bis_vg_util.print_View_Text
1578: --- ( x_View_Column_Text_Table
1579: --- , l_dummy
1580: --- , x_error_Tbl
1581: --- p );

Line 1582: --- bis_vg_util.print_View_Text

1578: --- ( x_View_Column_Text_Table
1579: --- , l_dummy
1580: --- , x_error_Tbl
1581: --- p );
1582: --- bis_vg_util.print_View_Text
1583: --- ( x_View_Select_Text_Table
1584: --- , l_dummy
1585: --- , x_error_Tbl
1586: --- );

Line 1599: BIS_VG_UTIL.Add_Error_Message

1595: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1597: when others then
1598: --- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1599: BIS_VG_UTIL.Add_Error_Message
1600: ( p_error_msg_id => SQLCODE
1601: , p_error_description => SQLERRM
1602: , p_error_proc_name => G_PKG_NAME||'.Update_View'
1603: , p_error_table => x_error_tbl

Line 1623: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

1619: --
1620: PROCEDURE handle_gen_exception
1621: (p_ViewName IN VARCHAR2
1622: , x_return_status OUT VARCHAR2
1623: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1624: )
1625: IS
1626: --
1627: l_error_code NUMBER;

Line 1704: BIS_VG_UTIL.Add_Error_Message

1700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1702: when others then
1703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1704: BIS_VG_UTIL.Add_Error_Message
1705: ( p_error_msg_id => SQLCODE
1706: , p_error_description => SQLERRM
1707: , p_error_proc_name => G_PKG_NAME||'. handle_gen_exception'
1708: , p_error_table => x_error_tbl

Line 1833: l_dummy_Tbl BIS_VG_UTIL.Error_Tbl_Type;

1829: --- cursor used to process a dynamic multi-row query
1830: l_FlexColRec_cur Ref_Cursor_Type;
1831:
1832: --- local variable not used but maintained for backward compatibility.
1833: l_dummy_Tbl BIS_VG_UTIL.Error_Tbl_Type;
1834:
1835: BEGIN
1836: --- --- DEBUG
1837: --- dbms_output.put_line('GENERATE_PRUNED_VIEW - '||p_viewname);

Line 2098: l_error_Tbl BIS_VG_UTIL.Error_Tbl_Type;

2094: l_instance VARCHAR2(200);
2095: l_generated_view_name bis_vg_types.view_name_type;
2096: l_error_message VARCHAR2(4000);
2097: l_return_status VARCHAR2(1000);
2098: l_error_Tbl BIS_VG_UTIL.Error_Tbl_Type;
2099:
2100: --
2101: BEGIN
2102: --

Line 2181: BIS_VG_UTIL.Add_Error_message

2177: END IF;
2178: --
2179: IF (l_View_Table.count = 0)
2180: THEN
2181: BIS_VG_UTIL.Add_Error_message
2182: ( p_error_msg_name => bis_view_generator_pvt.GENERATOR_NO_VIEWS
2183: , p_error_proc_name => G_PKG_NAME||'.generate_Views'
2184: , p_error_table => l_error_tbl
2185: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2198: bis_vg_util.get_generated_view_name (l_View_Table(i).view_name

2194: FOR i IN 1 .. l_View_Table.COUNT LOOP
2195: --
2196: fnd_msg_pub.initialize;
2197: l_generated_view_name :=
2198: bis_vg_util.get_generated_view_name (l_View_Table(i).view_name
2199: , l_return_status
2200: , l_error_Tbl
2201: );
2202: BEGIN

Line 2481: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

2477:
2478: PROCEDURE set_mode
2479: (p_mode IN bis_vg_types.view_generator_mode_type
2480: , x_return_status OUT VARCHAR2
2481: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
2482: )
2483: IS
2484: BEGIN
2485: bis_debug_pub.Add('> set_mode');

Line 2499: BIS_VG_UTIL.Add_Error_Message

2495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2496: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2497: when others then
2498: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2499: BIS_VG_UTIL.Add_Error_Message
2500: ( p_error_msg_id => SQLCODE
2501: , p_error_description => SQLERRM
2502: , p_error_proc_name => G_PKG_NAME||'.set_mode'
2503: , p_error_table => x_error_tbl