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 927: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type

923: ( p_EDW_Flag IN BOOLEAN --EDW flag change
924: , p_DUMMY_Flag IN BOOLEAN --EDW flag change
925: , p_Prefix IN VARCHAR2
926: , p_decode IN BOOLEAN
927: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
928: , p_Application_Name IN VARCHAR2
929: , p_Desc_Flex_Name IN VARCHAR2
930: , p_Table_Alias IN VARCHAR2
931: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

Line 931: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

927: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
928: , p_Application_Name IN VARCHAR2
929: , p_Desc_Flex_Name IN VARCHAR2
930: , p_Table_Alias IN VARCHAR2
931: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
932: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
933: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
934: , x_return_status OUT VARCHAR2
935: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 932: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

928: , p_Application_Name IN VARCHAR2
929: , p_Desc_Flex_Name IN VARCHAR2
930: , p_Table_Alias IN VARCHAR2
931: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
932: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
933: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
934: , x_return_status OUT VARCHAR2
935: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
936: )

Line 933: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type

929: , p_Desc_Flex_Name IN VARCHAR2
930: , p_Table_Alias IN VARCHAR2
931: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
932: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
933: , x_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
934: , x_return_status OUT VARCHAR2
935: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
936: )
937: IS

Line 948: l_Column_Table bis_vg_types.View_Text_Table_Type;

944: --
945: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
946: l_nContexts_flag BOOLEAN;
947: l_count NUMBER := 0;
948: l_Column_Table bis_vg_types.View_Text_Table_Type;
949: l_Select_Table bis_vg_types.View_Text_Table_Type;
950: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
951: ---
952:

Line 949: l_Select_Table bis_vg_types.View_Text_Table_Type;

945: l_ATT_CATEGORY_flag BOOLEAN := TRUE;
946: l_nContexts_flag BOOLEAN;
947: l_count NUMBER := 0;
948: l_Column_Table bis_vg_types.View_Text_Table_Type;
949: l_Select_Table bis_vg_types.View_Text_Table_Type;
950: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
951: ---
952:
953: --to get schema name

Line 950: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;

946: l_nContexts_flag BOOLEAN;
947: l_count NUMBER := 0;
948: l_Column_Table bis_vg_types.View_Text_Table_Type;
949: l_Select_Table bis_vg_types.View_Text_Table_Type;
950: l_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
951: ---
952:
953: --to get schema name
954: l_dummy1 varchar2(2000);

Line 1188: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type

1184: --- ---
1185: --- ==========================================================================
1186:
1187: PROCEDURE add_Desc_Flex_Info
1188: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1189: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1190: , p_Mode IN NUMBER
1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

Line 1189: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type

1185: --- ==========================================================================
1186:
1187: PROCEDURE add_Desc_Flex_Info
1188: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1189: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1190: , p_Mode IN NUMBER
1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

Line 1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type

1187: PROCEDURE add_Desc_Flex_Info
1188: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1189: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1190: , p_Mode IN NUMBER
1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

Line 1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type

1188: ( p_View_Column_Table IN BIS_VG_TYPES.View_Text_Table_Type
1189: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1190: , p_Mode IN NUMBER
1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

Line 1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type

1189: , p_View_Select_Table IN BIS_VG_TYPES.View_Text_Table_Type
1190: , p_Mode IN NUMBER
1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

Line 1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type

1190: , p_Mode IN NUMBER
1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

Line 1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type

1191: , p_column_table IN BIS_VG_TYPES.flexfield_column_table_type
1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1199: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

Line 1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type

1192: , p_Column_Pointer IN BIS_VG_TYPES.View_Character_Pointer_Type
1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1199: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1200: , x_return_status OUT VARCHAR2

Line 1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type

1193: , p_Select_Pointer IN bis_vg_types.View_Character_Pointer_Type
1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1199: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1200: , x_return_status OUT VARCHAR2
1201: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type

1194: , p_From_Pointer IN bis_vg_types.View_Character_Pointer_Type
1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1199: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1200: , x_return_status OUT VARCHAR2
1201: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1202: )

Line 1199: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type

1195: , x_Column_Table OUT bis_vg_types.View_Text_Table_Type
1196: , x_Select_Table OUT bis_vg_types.View_Text_Table_Type
1197: , x_Column_Comment_Table OUT BIS_VG_TYPES.Flex_Column_Comment_Table_Type
1198: , x_Column_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1199: , x_Select_Pointer OUT bis_vg_types.View_Character_Pointer_Type
1200: , x_return_status OUT VARCHAR2
1201: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1202: )
1203: IS

Line 1255: (p_Mode <> bis_vg_types.remove_tags_mode)

1251: bis_debug_pub.Add('l_Table_Alias = ' || l_Table_Alias);
1252: bis_debug_pub.Add('l_Prefix = ' || l_Prefix);
1253:
1254: IF(
1255: (p_Mode <> bis_vg_types.remove_tags_mode)
1256: AND
1257: (p_column_table IS NULL
1258: OR
1259: p_column_table.COUNT > 0)