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

Line 67: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type

63: -- --- EXCEPTION : FND_API.G_EXC_UNEXPECTED_ERROR
64: --- FND_API.G_EXC_ERROR;
65: -- ============================================================================
66: PROCEDURE parse_KF_Column_Line
67: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
68: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
69: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
70: , x_Concat_Seg_Name OUT VARCHAR2
71: , x_concat_segment_flag OUT BOOLEAN

Line 68: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type

64: --- FND_API.G_EXC_ERROR;
65: -- ============================================================================
66: PROCEDURE parse_KF_Column_Line
67: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
68: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
69: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
70: , x_Concat_Seg_Name OUT VARCHAR2
71: , x_concat_segment_flag OUT BOOLEAN
72: , x_decode_on_segments OUT BOOLEAN

Line 69: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

65: -- ============================================================================
66: PROCEDURE parse_KF_Column_Line
67: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
68: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
69: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
70: , x_Concat_Seg_Name OUT VARCHAR2
71: , x_concat_segment_flag OUT BOOLEAN
72: , x_decode_on_segments OUT BOOLEAN
73: , x_EDW_flag OUT BOOLEAN

Line 81: l_string bis_vg_types.view_text_table_rec_type;

77: )
78: IS
79: --
80: l_token VARCHAR2(100);
81: l_string bis_vg_types.view_text_table_rec_type;
82: l_pos NUMBER;
83: l_message_token VARCHAR2(2000);
84: --
85: BEGIN

Line 309: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type

305: -- --- EXCEPTION : FND_API.G_EXC_UNEXPECTED_ERROR
306: --- FND_API.G_EXC_ERROR;
307: -- =============================================================================
308: PROCEDURE parse_KF_Select_Line
309: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
310: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
311: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
312: , x_PLSQL_Expression OUT VARCHAR2
313: , x_Application_Name OUT VARCHAR2

Line 310: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

306: --- FND_API.G_EXC_ERROR;
307: -- =============================================================================
308: PROCEDURE parse_KF_Select_Line
309: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
310: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
311: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
312: , x_PLSQL_Expression OUT VARCHAR2
313: , x_Application_Name OUT VARCHAR2
314: , x_Key_Flex_Code OUT VARCHAR2

Line 311: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

307: -- =============================================================================
308: PROCEDURE parse_KF_Select_Line
309: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
310: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
311: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
312: , x_PLSQL_Expression OUT VARCHAR2
313: , x_Application_Name OUT VARCHAR2
314: , x_Key_Flex_Code OUT VARCHAR2
315: , x_Table_Alias OUT VARCHAR2

Line 325: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;

321: IS
322: --
323: l_token VARCHAR2(100);
324: l_message_token VARCHAR2(2000);
325: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;
326: --
327: BEGIN
328: bis_debug_pub.Add('> parse_KF_Select_Line');
329: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 582: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

578: , p_Concat_Seg_Name IN VARCHAR2
579: , p_decode_on_segments IN BOOLEAN
580: , p_Prefix IN VARCHAR2
581: , p_Table_Alias IN VARCHAR2
582: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
583: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
584: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
585: , x_return_status OUT VARCHAR2
586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 583: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

579: , p_decode_on_segments IN BOOLEAN
580: , p_Prefix IN VARCHAR2
581: , p_Table_Alias IN VARCHAR2
582: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
583: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
584: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
585: , x_return_status OUT VARCHAR2
586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
587: )

Line 584: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

580: , p_Prefix IN VARCHAR2
581: , p_Table_Alias IN VARCHAR2
582: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
583: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
584: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
585: , x_return_status OUT VARCHAR2
586: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
587: )
588: IS

Line 727: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

723: , p_Flexfield IN FND_FLEX_KEY_API.FLEXFIELD_TYPE
724: , p_Structure IN FND_FLEX_KEY_API.STRUCTURE_TYPE
725: , p_Table_Alias IN VARCHAR2
726: , p_pad_count IN NUMBER
727: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
728: , x_return_status OUT VARCHAR2
729: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
730: )
731: IS

Line 852: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type

848: , p_Concat_Segment_Flag IN BOOLEAN
849: , p_decode_on_segments IN BOOLEAN
850: , p_EDW_Flag IN BOOLEAN
851: , p_dummy_flag IN BOOLEAN
852: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
853: , p_Prefix IN VARCHAR2
854: , p_PLSQL_Expression IN VARCHAR2
855: , p_Application_Name IN VARCHAR2
856: , p_Key_Flex_Code IN VARCHAR2

Line 859: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

855: , p_Application_Name IN VARCHAR2
856: , p_Key_Flex_Code IN VARCHAR2
857: , p_Table_Alias IN VARCHAR2
858: , p_Structure_Column IN VARCHAR2
859: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
860: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
861: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
862: , x_return_status OUT VARCHAR2
863: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 860: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

856: , p_Key_Flex_Code IN VARCHAR2
857: , p_Table_Alias IN VARCHAR2
858: , p_Structure_Column IN VARCHAR2
859: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
860: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
861: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
862: , x_return_status OUT VARCHAR2
863: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
864: )

Line 861: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

857: , p_Table_Alias IN VARCHAR2
858: , p_Structure_Column IN VARCHAR2
859: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
860: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
861: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
862: , x_return_status OUT VARCHAR2
863: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
864: )
865: IS

Line 875: l_Column_Table bis_vg_types.View_Text_Table_Type;

871: l_Structure FND_FLEX_KEY_API.STRUCTURE_TYPE;
872: --
873: l_nStructures NUMBER;
874: l_count NUMBER;
875: l_Column_Table bis_vg_types.View_Text_Table_Type;
876: l_Select_Table bis_vg_types.View_Text_Table_Type;
877: l_Column_Comment_Table BIS_VG_TYPES.Flex_Column_Comment_Table_Type;
878: --
879: l_prefix VARCHAR2(100) := NULL;

Line 876: l_Select_Table bis_vg_types.View_Text_Table_Type;

872: --
873: l_nStructures NUMBER;
874: l_count NUMBER;
875: l_Column_Table bis_vg_types.View_Text_Table_Type;
876: l_Select_Table bis_vg_types.View_Text_Table_Type;
877: l_Column_Comment_Table BIS_VG_TYPES.Flex_Column_Comment_Table_Type;
878: --
879: l_prefix VARCHAR2(100) := NULL;
880: l_suffix VARCHAR2(100) := NULL;

Line 877: l_Column_Comment_Table BIS_VG_TYPES.Flex_Column_Comment_Table_Type;

873: l_nStructures NUMBER;
874: l_count NUMBER;
875: l_Column_Table bis_vg_types.View_Text_Table_Type;
876: l_Select_Table bis_vg_types.View_Text_Table_Type;
877: l_Column_Comment_Table BIS_VG_TYPES.Flex_Column_Comment_Table_Type;
878: --
879: l_prefix VARCHAR2(100) := NULL;
880: l_suffix VARCHAR2(100) := NULL;
881: l_delimiter VARCHAR2(10) := ' ';

Line 1265: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type

1261: --- FND_API.G_EXC_ERROR;
1262: --- ==================================================================================== */
1263:
1264: PROCEDURE add_Key_Flex_Info
1265: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
1266: , p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
1267: , p_Mode IN NUMBER
1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type

Line 1266: , p_View_Select_Table IN bis_vg_types.View_Text_Table_Type

1262: --- ==================================================================================== */
1263:
1264: PROCEDURE add_Key_Flex_Info
1265: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
1266: , p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
1267: , p_Mode IN NUMBER
1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

Line 1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type

1264: PROCEDURE add_Key_Flex_Info
1265: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
1266: , p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
1267: , p_Mode IN NUMBER
1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

Line 1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type

1265: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
1266: , p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
1267: , p_Mode IN NUMBER
1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

Line 1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

1266: , p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
1267: , p_Mode IN NUMBER
1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

Line 1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type

1267: , p_Mode IN NUMBER
1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

Line 1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

1268: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1276: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

Line 1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

1269: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1276: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1277: , x_return_status OUT VARCHAR2

Line 1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

1270: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1276: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1277: , x_return_status OUT VARCHAR2
1278: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

1271: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1276: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1277: , x_return_status OUT VARCHAR2
1278: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1279: )

Line 1276: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

1272: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1273: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1274: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1275: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1276: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1277: , x_return_status OUT VARCHAR2
1278: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1279: )
1280: IS

Line 1349: (p_Mode <> bis_vg_types.remove_tags_mode)

1345: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1346: bis_debug_pub.Add('l_Structure_Column = ' || l_Structure_Column);
1347:
1348: IF(
1349: (p_Mode <> bis_vg_types.remove_tags_mode)
1350: AND
1351: (p_column_table IS NULL
1352: OR
1353: p_column_table.COUNT > 0