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

Line 198: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type

194: -- COMMENT : Call this procedure to parse the KF view column tag.
195: -- ---
196: --=============================================================================
197: PROCEDURE parse_DF_Column_Line
198: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
199: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
200: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
201: , x_EDW_flag OUT BOOLEAN --EDW flag change
202: , x_prefix OUT VARCHAR2

Line 199: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type

195: -- ---
196: --=============================================================================
197: PROCEDURE parse_DF_Column_Line
198: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
199: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
200: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
201: , x_EDW_flag OUT BOOLEAN --EDW flag change
202: , x_prefix OUT VARCHAR2
203: , x_decode OUT BOOLEAN

Line 200: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

196: --=============================================================================
197: PROCEDURE parse_DF_Column_Line
198: ( p_View_Column_Table IN bis_vg_types.View_Text_Table_Type
199: , p_Column_Pointer IN bis_vg_types.View_Character_Pointer_Type
200: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
201: , x_EDW_flag OUT BOOLEAN --EDW flag change
202: , x_prefix OUT VARCHAR2
203: , x_decode OUT BOOLEAN
204: , x_return_status OUT VARCHAR2

Line 210: l_string bis_vg_types.view_text_table_rec_type;

206: )
207: IS
208: --
209: l_token VARCHAR2(100);
210: l_string bis_vg_types.view_text_table_rec_type;
211: l_pos NUMBER;
212: --
213: BEGIN
214:

Line 422: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type

418: -- COMMENT : Call this procedure to parse the DF selected tag.
419: -- ---
420: -- =============================================================================
421: PROCEDURE parse_DF_Select_Line
422: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
423: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
424: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
425: , x_Application_Name OUT VARCHAR2
426: , x_Desc_Flex_Name OUT VARCHAR2

Line 423: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

419: -- ---
420: -- =============================================================================
421: PROCEDURE parse_DF_Select_Line
422: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
423: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
424: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
425: , x_Application_Name OUT VARCHAR2
426: , x_Desc_Flex_Name OUT VARCHAR2
427: , x_Table_Alias OUT VARCHAR2

Line 424: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

420: -- =============================================================================
421: PROCEDURE parse_DF_Select_Line
422: ( p_View_Select_Table IN bis_vg_types.View_Text_Table_Type
423: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
424: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
425: , x_Application_Name OUT VARCHAR2
426: , x_Desc_Flex_Name OUT VARCHAR2
427: , x_Table_Alias OUT VARCHAR2
428: , x_DUMMY_flag OUT BOOLEAN

Line 435: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;

431: )
432: IS
433: --
434: l_whole_tag VARCHAR2(2000);
435: l_tmp_pointer bis_vg_types.View_Character_Pointer_Type;
436: --
437: BEGIN
438: bis_debug_pub.Add('> parse_DF_Select_Line');
439: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 707: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

703: , p_decode IN BOOLEAN
704: , p_Table_Alias IN VARCHAR2
705: , p_EDW_Flag IN BOOLEAN --EDW flag change
706: , p_DUMMY_Flag IN BOOLEAN --EDW flag change
707: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
708: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
709: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
710: , p_attr_categ_flag IN BOOLEAN
711: , x_attr_categ_flag OUT BOOLEAN

Line 708: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

704: , p_Table_Alias IN VARCHAR2
705: , p_EDW_Flag IN BOOLEAN --EDW flag change
706: , p_DUMMY_Flag IN BOOLEAN --EDW flag change
707: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
708: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
709: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
710: , p_attr_categ_flag IN BOOLEAN
711: , x_attr_categ_flag OUT BOOLEAN
712: , x_return_status OUT VARCHAR2

Line 709: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type

705: , p_EDW_Flag IN BOOLEAN --EDW flag change
706: , p_DUMMY_Flag IN BOOLEAN --EDW flag change
707: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
708: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
709: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
710: , p_attr_categ_flag IN BOOLEAN
711: , x_attr_categ_flag OUT BOOLEAN
712: , x_return_status OUT VARCHAR2
713: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 920: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type

916: ( p_EDW_Flag IN BOOLEAN --EDW flag change
917: , p_DUMMY_Flag IN BOOLEAN --EDW flag change
918: , p_Prefix IN VARCHAR2
919: , p_decode IN BOOLEAN
920: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
921: , p_Application_Name IN VARCHAR2
922: , p_Desc_Flex_Name IN VARCHAR2
923: , p_Table_Alias IN VARCHAR2
924: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

Line 924: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

920: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
921: , p_Application_Name IN VARCHAR2
922: , p_Desc_Flex_Name IN VARCHAR2
923: , p_Table_Alias IN VARCHAR2
924: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
925: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
926: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
927: , x_return_status OUT VARCHAR2
928: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 925: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

921: , p_Application_Name IN VARCHAR2
922: , p_Desc_Flex_Name IN VARCHAR2
923: , p_Table_Alias IN VARCHAR2
924: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
925: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
926: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
927: , x_return_status OUT VARCHAR2
928: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
929: )

Line 926: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type

922: , p_Desc_Flex_Name IN VARCHAR2
923: , p_Table_Alias IN VARCHAR2
924: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
925: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
926: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
927: , x_return_status OUT VARCHAR2
928: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
929: )
930: IS

Line 941: l_Column_Table bis_vg_types.View_Text_Table_Type;

937: --
938: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
939: l_nContexts_flag BOOLEAN;
940: l_count NUMBER := 0;
941: l_Column_Table bis_vg_types.View_Text_Table_Type;
942: l_Select_Table bis_vg_types.View_Text_Table_Type;
943: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
944: ---
945:

Line 942: l_Select_Table bis_vg_types.View_Text_Table_Type;

938: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
939: l_nContexts_flag BOOLEAN;
940: l_count NUMBER := 0;
941: l_Column_Table bis_vg_types.View_Text_Table_Type;
942: l_Select_Table bis_vg_types.View_Text_Table_Type;
943: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
944: ---
945:
946: --to get schema name

Line 943: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;

939: l_nContexts_flag BOOLEAN;
940: l_count NUMBER := 0;
941: l_Column_Table bis_vg_types.View_Text_Table_Type;
942: l_Select_Table bis_vg_types.View_Text_Table_Type;
943: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
944: ---
945:
946: --to get schema name
947: l_dummy1 varchar2(2000);

Line 1181: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type

1177: --- ---
1178: --- ==========================================================================
1179:
1180: PROCEDURE add_Desc_Flex_Info
1181: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1182: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1183: , p_Mode IN NUMBER
1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

Line 1182: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type

1178: --- ==========================================================================
1179:
1180: PROCEDURE add_Desc_Flex_Info
1181: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1182: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1183: , p_Mode IN NUMBER
1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

Line 1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type

1180: PROCEDURE add_Desc_Flex_Info
1181: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1182: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1183: , p_Mode IN NUMBER
1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

Line 1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

1181: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1182: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1183: , p_Mode IN NUMBER
1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

Line 1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

1182: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1183: , p_Mode IN NUMBER
1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

Line 1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type

1183: , p_Mode IN NUMBER
1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

Line 1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

1184: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1192: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

Line 1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

1185: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1192: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1193: , x_return_status OUT VARCHAR2

Line 1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

1186: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1192: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1193: , x_return_status OUT VARCHAR2
1194: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

1187: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1192: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1193: , x_return_status OUT VARCHAR2
1194: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1195: )

Line 1192: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

1188: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1189: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1190: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1191: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1192: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1193: , x_return_status OUT VARCHAR2
1194: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1195: )
1196: IS

Line 1248: (p_Mode <> bis_vg_types.remove_tags_mode)

1244: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1245: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);
1246:
1247: IF(
1248: (p_Mode <> bis_vg_types.remove_tags_mode)
1249: AND
1250: (p_column_table IS NULL
1251: OR
1252: p_column_table.COUNT > 0)