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_LOOKUP dependencies on BIS_VG_TYPES

Line 41: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type

37: to a view.
38: EXCEPTION : None
39: ===========================================================================*/
40: PROCEDURE put_column_name
41: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
42: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
43: , p_Mode IN NUMBER
44: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
45: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

Line 42: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

38: EXCEPTION : None
39: ===========================================================================*/
40: PROCEDURE put_column_name
41: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
42: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
43: , p_Mode IN NUMBER
44: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
45: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
46: , x_return_status OUT VARCHAR2

Line 44: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type

40: PROCEDURE put_column_name
41: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
42: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
43: , p_Mode IN NUMBER
44: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
45: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
46: , x_return_status OUT VARCHAR2
47: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
48: )

Line 45: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

41: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
42: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
43: , p_Mode IN NUMBER
44: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
45: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
46: , x_return_status OUT VARCHAR2
47: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
48: )
49: IS

Line 124: IF(p_Mode = bis_vg_types.remove_tags_mode) THEN

120: , x_return_status
121: , x_error_Tbl
122: );
123: --
124: IF(p_Mode = bis_vg_types.remove_tags_mode) THEN
125: x_column_table.DELETE;
126: x_column_table(1) := l_str;
127: END IF;
128: BIS_DEBUG_PUB.Add('< put_column_name');

Line 232: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type

228: ===========================================================================*/
229: PROCEDURE write_decode_statement
230: ( p_expr IN VARCHAR2
231: , p_select IN VARCHAR2
232: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
233: , x_return_status OUT VARCHAR2
234: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
235: )
236: IS

Line 241: l_select_table BIS_VG_TYPES.View_Text_Table_Type;

237: l_cursor_id INTEGER;
238: l_lookup_code VARCHAR2(250);
239: l_meaning VARCHAR2(250);
240: l_dummy INTEGER;
241: l_select_table BIS_VG_TYPES.View_Text_Table_Type;
242: -- flag to allow verification of existence
243: -- of rows in the lookup table for the lookup
244: l_DECODE_flag BOOLEAN := TRUE;
245: l_stmt_count NUMBER := 0;

Line 391: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type

387: ( p_expr IN VARCHAR2
388: , p_lookup_table IN VARCHAR2
389: , p_lookup_type IN VARCHAR2
390: , p_lookup_column IN VARCHAR2
391: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
392: , x_return_status OUT VARCHAR2
393: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
394: )
395: IS

Line 495: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type

491: , p_lookup_table IN VARCHAR2
492: , p_lookup_type IN VARCHAR2
493: , p_lookup_column IN VARCHAR2
494: , p_language IN VARCHAR2
495: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
496: , x_return_status OUT VARCHAR2
497: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
498: )
499: IS

Line 584: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type

580: ( p_expr IN VARCHAR2
581: , p_lookup_table IN VARCHAR2
582: , p_lookup_type IN VARCHAR2
583: , p_lookup_column IN VARCHAR2
584: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
585: , x_return_status OUT VARCHAR2
586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
587: )
588: IS

Line 767: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type

763: ( p_expr IN VARCHAR2
764: , p_lookup_table IN VARCHAR2
765: , p_lookup_type IN VARCHAR2
766: , p_lookup_column IN VARCHAR2
767: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
768: , x_return_status OUT VARCHAR2
769: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
770: )
771: IS

Line 851: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type

847: -- information to a view.
848: --EXCEPTION : None
849: -- ==========================================================================
850: PROCEDURE parse_LA_select
851: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
852: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
853: , x_expr OUT VARCHAR2
854: , x_lookup_table OUT VARCHAR2
855: , x_lookup_type OUT VARCHAR2

Line 852: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

848: --EXCEPTION : None
849: -- ==========================================================================
850: PROCEDURE parse_LA_select
851: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
852: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
853: , x_expr OUT VARCHAR2
854: , x_lookup_table OUT VARCHAR2
855: , x_lookup_type OUT VARCHAR2
856: , x_lookup_column OUT VARCHAR2

Line 857: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

853: , x_expr OUT VARCHAR2
854: , x_lookup_table OUT VARCHAR2
855: , x_lookup_type OUT VARCHAR2
856: , x_lookup_column OUT VARCHAR2
857: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
858: , x_return_status OUT VARCHAR2
859: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
860: )
861: IS

Line 863: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;

859: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
860: )
861: IS
862: l_str VARCHAR2(2000);
863: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;
864: BEGIN
865:
866: BIS_DEBUG_PUB.Add('> parse_LA_select');
867: -- skip the _LA part

Line 1180: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type

1176: -- information to a view.
1177: -- EXCEPTION : None
1178: -- ==========================================================================
1179: PROCEDURE put_decode_in_select
1180: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1181: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1182: , p_Mode IN NUMBER
1183: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1184: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

Line 1181: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

1177: -- EXCEPTION : None
1178: -- ==========================================================================
1179: PROCEDURE put_decode_in_select
1180: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1181: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1182: , p_Mode IN NUMBER
1183: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1184: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1185: , x_return_status OUT VARCHAR2

Line 1183: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type

1179: PROCEDURE put_decode_in_select
1180: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1181: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1182: , p_Mode IN NUMBER
1183: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1184: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1185: , x_return_status OUT VARCHAR2
1186: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1187: )

Line 1184: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

1180: ( p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1181: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1182: , p_Mode IN NUMBER
1183: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1184: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1185: , x_return_status OUT VARCHAR2
1186: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1187: )
1188: IS

Line 1217: IF(p_Mode = bis_vg_types.remove_tags_mode) THEN

1213: , x_return_status
1214: , x_error_Tbl
1215: );
1216:
1217: IF(p_Mode = bis_vg_types.remove_tags_mode) THEN
1218: x_select_table(1) := 'TO_CHAR(NULL)';
1219: ELSE
1220: -- Check for existence of table and column
1221: IF check_lookup_exists(l_lookup_table, l_lookup_column)

Line 1303: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type

1299: to a view.
1300: EXCEPTION : None
1301: ===========================================================================*/
1302: PROCEDURE add_Lookup_Info
1303: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1304: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1305: , p_Mode IN NUMBER
1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

Line 1304: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type

1300: EXCEPTION : None
1301: ===========================================================================*/
1302: PROCEDURE add_Lookup_Info
1303: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1304: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1305: , p_Mode IN NUMBER
1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type

Line 1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

1302: PROCEDURE add_Lookup_Info
1303: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1304: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1305: , p_Mode IN NUMBER
1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1309: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1310: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

Line 1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

1303: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1304: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1305: , p_Mode IN NUMBER
1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1309: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1310: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1311: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

Line 1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type

1304: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1305: , p_Mode IN NUMBER
1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1309: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1310: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1311: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1312: , x_return_status OUT VARCHAR2

Line 1309: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type

1305: , p_Mode IN NUMBER
1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1309: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1310: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1311: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1312: , x_return_status OUT VARCHAR2
1313: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 1310: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

1306: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1309: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1310: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1311: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1312: , x_return_status OUT VARCHAR2
1313: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1314: )

Line 1311: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type

1307: , p_Select_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1308: , x_Column_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1309: , x_Select_Table OUT BIS_VG_TYPES.View_Text_Table_Type
1310: , x_Column_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1311: , x_Select_Pointer OUT BIS_VG_TYPES.View_Character_Pointer_Type
1312: , x_return_status OUT VARCHAR2
1313: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1314: )
1315: IS