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_TYPES

Line 34: --- bis_vg_types.Flex_Column_Comment_Table_Type. Created new procedure

30: --- 26-DEC-00 Edited by WNASRALL@US: final debug of cross-database links
31: --- 02-FEB-00 Edited by WNASRALL@US: preparation for base table select
32: --- 06-APR-00 Edited by DBOWLES. Modified update_flexfields
33: --- procedure, update_View procedure passing parameter of
34: --- bis_vg_types.Flex_Column_Comment_Table_Type. Created new procedure
35: --- comment_Flex_Columns which is called after the view is generated.
36: --- This procedure will comment columns derived from flexfield
37: --- with data regarding specifics of the flexfield definition.
38: --- 11-DEC-01 Edited by DBOWLES Added dr driver comments.

Line 157: g_mode bis_vg_types.view_generator_mode_type := bis_vg_types.production_mode;

153: --============================================================================
154: -- mode for the program
155: --============================================================================
156: --
157: g_mode bis_vg_types.view_generator_mode_type := bis_vg_types.production_mode;
158: --
159:
160:
161: --=====================

Line 210: ( p_view_table IN bis_vg_types.View_Text_Table_Type

206: --RETURN : view_character_pointer
207: --EXCEPTION : None
208: -- ============================================================================
209: FUNCTION get_tag_keyword_position
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

Line 211: , p_string_set IN bis_vg_types.View_Text_Table_Type

207: --EXCEPTION : None
208: -- ============================================================================
209: FUNCTION get_tag_keyword_position
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: )

Line 212: , p_start_pointer IN bis_vg_types.View_Character_Pointer_Type

208: -- ============================================================================
209: FUNCTION get_tag_keyword_position
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

Line 216: RETURN bis_vg_types.view_character_pointer_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;
219: l_save_pointer bis_vg_types.View_Character_Pointer_Type;
220: l_done BOOLEAN ;

Line 218: l_pointer bis_vg_types.View_Character_Pointer_Type;

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;
219: l_save_pointer bis_vg_types.View_Character_Pointer_Type;
220: l_done BOOLEAN ;
221: l_char VARCHAR2(1);
222: BEGIN

Line 219: l_save_pointer bis_vg_types.View_Character_Pointer_Type;

215: )
216: RETURN bis_vg_types.view_character_pointer_type
217: IS
218: l_pointer bis_vg_types.View_Character_Pointer_Type;
219: l_save_pointer bis_vg_types.View_Character_Pointer_Type;
220: l_done BOOLEAN ;
221: l_char VARCHAR2(1);
222: BEGIN
223: l_done := FALSE;

Line 297: --- 4. p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type:

293: --- PARAMETERS:
294: --- 1. p_View_Column_Table table of varchars to hold columns of view text
295: --- 2. p_View_Select_Table table of varchars to hold select clause of view
296: --- 3. p_Mode mode of the program
297: --- 4. p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type:
298: --- Use only for calls from generate_pruned_view
299: --- 5. p_Column_Pointer pointer to the key flex column in column table
300: --- 6. p_Select_Pointer pointer to the select clause
301: --- 7. x_Column_Table table of varchars to hold additional columns

Line 317: ( p_view_column_text_table IN bis_vg_types.View_Text_Table_Type

313: --- EXCEPTION : None
314: --- ========================================================================
315:
316: PROCEDURE update_flexfields -- PRIVATE PROCEDURE
317: ( p_view_column_text_table IN bis_vg_types.View_Text_Table_Type
318: , p_view_select_text_table IN bis_vg_types.View_Text_Table_Type
319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type

Line 318: , p_view_select_text_table IN bis_vg_types.View_Text_Table_Type

314: --- ========================================================================
315:
316: PROCEDURE update_flexfields -- PRIVATE PROCEDURE
317: ( p_view_column_text_table IN bis_vg_types.View_Text_Table_Type
318: , p_view_select_text_table IN bis_vg_types.View_Text_Table_Type
319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type

Line 319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode

315:
316: PROCEDURE update_flexfields -- PRIVATE PROCEDURE
317: ( p_view_column_text_table IN bis_vg_types.View_Text_Table_Type
318: , p_view_select_text_table IN bis_vg_types.View_Text_Table_Type
319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type

Line 320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL

316: PROCEDURE update_flexfields -- PRIVATE PROCEDURE
317: ( p_view_column_text_table IN bis_vg_types.View_Text_Table_Type
318: , p_view_select_text_table IN bis_vg_types.View_Text_Table_Type
319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_Type

Line 321: , p_column_pointer IN bis_vg_types.view_character_pointer_type

317: ( p_view_column_text_table IN bis_vg_types.View_Text_Table_Type
318: , p_view_select_text_table IN bis_vg_types.View_Text_Table_Type
319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_Type
325: , x_column_comment_table OUT bis_vg_types.Flex_Column_Comment_Table_Type

Line 322: , p_select_pointer IN bis_vg_types.view_character_pointer_type

318: , p_view_select_text_table IN bis_vg_types.View_Text_Table_Type
319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_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

Line 323: , x_column_table OUT bis_vg_types.View_Text_Table_Type

319: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_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

Line 324: , x_select_table OUT bis_vg_types.View_Text_Table_Type

320: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_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

Line 325: , x_column_comment_table OUT bis_vg_types.Flex_Column_Comment_Table_Type

321: , p_column_pointer IN bis_vg_types.view_character_pointer_type
322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_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

Line 326: , x_column_pointer OUT bis_vg_types.view_character_pointer_type

322: , p_select_pointer IN bis_vg_types.view_character_pointer_type
323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_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: )

Line 327: , x_select_pointer OUT bis_vg_types.view_character_pointer_type

323: , x_column_table OUT bis_vg_types.View_Text_Table_Type
324: , x_select_table OUT bis_vg_types.View_Text_Table_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

Line 334: l_pointer bis_vg_types.view_character_pointer_type;

330: )
331: IS
332: l_str VARCHAR2(300);
333: l_sel_str VARCHAR2(300);
334: l_pointer bis_vg_types.view_character_pointer_type;
335: l_col NUMBER;
336: BEGIN
337: --
338: bis_debug_pub.Add('> update_flexfields');

Line 506: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type

502: --Return : 1 iff found a comma else 0
503: --EXCEPTION : None
504: -- ============================================================================
505: FUNCTION exclude_comma_before_tag -- PRIVATE function
506: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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

Line 507: , p_Select_Pointer IN bis_vg_types.view_character_pointer_type

503: --EXCEPTION : None
504: -- ============================================================================
505: FUNCTION exclude_comma_before_tag -- PRIVATE function
506: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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

Line 508: , p_start_pointer IN bis_vg_types.view_character_pointer_type

504: -- ============================================================================
505: FUNCTION exclude_comma_before_tag -- PRIVATE function
506: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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: )

Line 509: , x_Select_Pointer OUT bis_vg_types.view_character_pointer_type

505: FUNCTION exclude_comma_before_tag -- PRIVATE function
506: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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

Line 516: l_select_pointer bis_vg_types.view_character_pointer_type;

512: )
513: RETURN NUMBER
514: IS
515: --
516: l_select_pointer bis_vg_types.view_character_pointer_type;
517: --
518: BEGIN
519: bis_debug_pub.Add('> exclude_comma');
520: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 599: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type

595: --Return : 1 iff found a comma else 0
596: --EXCEPTION : None
597: -- ============================================================================
598: PROCEDURE exclude_comma_after_tag -- PRIVATE PROCEDURE
599: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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

Line 600: , p_Select_Pointer IN bis_vg_types.view_character_pointer_type

596: --EXCEPTION : None
597: -- ============================================================================
598: PROCEDURE exclude_comma_after_tag -- PRIVATE PROCEDURE
599: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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

Line 601: , p_end_pointer IN bis_vg_types.view_character_pointer_type

597: -- ============================================================================
598: PROCEDURE exclude_comma_after_tag -- PRIVATE PROCEDURE
599: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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: )

Line 602: , x_Select_Pointer OUT bis_vg_types.view_character_pointer_type

598: PROCEDURE exclude_comma_after_tag -- PRIVATE PROCEDURE
599: ( p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_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

Line 608: l_select_pointer bis_vg_types.view_character_pointer_type;

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;
609: --
610: BEGIN
611: bis_debug_pub.Add('> exclude_comma_after_tag');
612: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 687: --- 3. x_view_column_text_table OUT bis_vg_types.View_Text_Table_Type

683: --- the base table, as selected in APPS integrator
684: --- 2. x_unique_tables OUT superset_summary_table_type
685: --- table built in this procedure, contains all unique
686: --- table names referenced in p_extra_columns.
687: --- 3. x_view_column_text_table OUT bis_vg_types.View_Text_Table_Type
688: --- table of all old + new column names
689: --- 4. x_error_Tbl table of error messages
690: --- COMMENT : Call this procedure to add extra columns selected from
691: --- the view base tables in APPS Integrator to the column list

Line 698: , x_column_table OUT bis_vg_types.View_Text_Table_Type

694: --- =========================================================================
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 ;

Line 778: --- 3. p_select_table IN bis_vg_types.View_Text_Table_Type

774: --- 2. p_extra_columns IN superset_table_type
775: --- table built in get_base_table_selects when the first
776: --- union branch was parsed. Contains all unique table
777: --- names referenced in p_extra_columns.
778: --- 3. p_select_table IN bis_vg_types.View_Text_Table_Type
779: --- contains the "FROM" clause of the union branch
780: --- currently being parsed
781: --- 4. x_select_table OUT bis_vg_types.View_Text_Table_Type
782: --- contains all the selects for the extra columns, with

Line 781: --- 4. x_select_table OUT bis_vg_types.View_Text_Table_Type

777: --- names referenced in p_extra_columns.
778: --- 3. p_select_table IN bis_vg_types.View_Text_Table_Type
779: --- contains the "FROM" clause of the union branch
780: --- currently being parsed
781: --- 4. x_select_table OUT bis_vg_types.View_Text_Table_Type
782: --- contains all the selects for the extra columns, with
783: --- a alias.column reference if the table name and alias
784: --- exist in this union branch, or a "NULL" if it does not.
785: --- 5. x_error_Tbl table of error messages

Line 792: (p_view_select_table IN bis_vg_types.View_Text_Table_Type

788: --- references is concatenated to the select clause of the
789: --- generated view, one union barnch at a time.
790: --- =========================================================================
791: PROCEDURE Get_Base_Table_Selects
792: (p_view_select_table IN bis_vg_types.View_Text_Table_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

Line 793: , p_start_pos IN bis_vg_types.View_Character_Pointer_Type

789: --- generated view, one union barnch at a time.
790: --- =========================================================================
791: PROCEDURE Get_Base_Table_Selects
792: (p_view_select_table IN bis_vg_types.View_Text_Table_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

Line 796: , x_select_table OUT bis_vg_types.View_Text_Table_Type

792: (p_view_select_table IN bis_vg_types.View_Text_Table_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;

Line 800: l_pos bis_vg_types.View_Character_Pointer_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;
802: l_dummy VARCHAR2(2000);
803: l_str VARCHAR2(60);
804: l_str2 VARCHAR2(60);

Line 952: --- 1. p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type:

948:
949: --- ========================================================================
950: --- PROCEDURE : Update_View
951: --- PARAMETERS:
952: --- 1. p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type:
953: --- contains column names
954: --- 2. p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type:
955: --- contains select text
956: --- 3. p_mode IN bi_vg_types.View_Generator_Mode_type:

Line 954: --- 2. p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type:

950: --- PROCEDURE : Update_View
951: --- PARAMETERS:
952: --- 1. p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type:
953: --- contains column names
954: --- 2. p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type:
955: --- contains select text
956: --- 3. p_mode IN bi_vg_types.View_Generator_Mode_type:
957: --- production, plsql or test
958: --- 4. p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type

Line 958: --- 4. p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type

954: --- 2. p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type:
955: --- contains select text
956: --- 3. p_mode IN bi_vg_types.View_Generator_Mode_type:
957: --- production, plsql or test
958: --- 4. p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type
959: --- Used only for calls from generate_pruned_view
960: --- 5. p_extra_columns IN superset_table_type
961: --- Used only for calls from generate_pruned_view
962: --- 6. x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type:

Line 962: --- 6. x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type:

958: --- 4. p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type
959: --- Used only for calls from generate_pruned_view
960: --- 5. p_extra_columns IN superset_table_type
961: --- Used only for calls from generate_pruned_view
962: --- 6. x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type:
963: --- return column names
964: --- 7. x_View_Select_Text_Table OUT bis_vg_types.View_Text_Table_Type
965: --- return select text
966: --- 8. x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type

Line 964: --- 7. x_View_Select_Text_Table OUT bis_vg_types.View_Text_Table_Type

960: --- 5. p_extra_columns IN superset_table_type
961: --- Used only for calls from generate_pruned_view
962: --- 6. x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type:
963: --- return column names
964: --- 7. x_View_Select_Text_Table OUT bis_vg_types.View_Text_Table_Type
965: --- return select text
966: --- 8. x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
967: --- returns table of records with comments
968: --- for flex derived columns.

Line 966: --- 8. x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type

962: --- 6. x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type:
963: --- return column names
964: --- 7. x_View_Select_Text_Table OUT bis_vg_types.View_Text_Table_Type
965: --- return select text
966: --- 8. x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
967: --- returns table of records with comments
968: --- for flex derived columns.
969: --- 8. x_error_Tbl table of error messages
970: --- COMMENT : Call this procedure to update the flex filed in a view

Line 974: ( p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type

970: --- COMMENT : Call this procedure to update the flex filed in a view
971: --- ==========================================================================
972:
973: PROCEDURE Update_View --- PRIVATE PROCEDURE
974: ( p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type
975: , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
976: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
978: , p_extra_columns IN superset_table_type := NULL

Line 975: , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type

971: --- ==========================================================================
972:
973: PROCEDURE Update_View --- PRIVATE PROCEDURE
974: ( p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type
975: , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
976: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
978: , p_extra_columns IN superset_table_type := NULL
979: , x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type

Line 976: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode

972:
973: PROCEDURE Update_View --- PRIVATE PROCEDURE
974: ( p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type
975: , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
976: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
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

Line 977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL

973: PROCEDURE Update_View --- PRIVATE PROCEDURE
974: ( p_View_Column_Text_Table IN bis_vg_types.View_Text_Table_Type
975: , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
976: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
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

Line 979: , x_View_Column_Text_Table OUT bis_vg_types.View_Text_Table_Type

975: , p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
976: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
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: )

Line 980: , x_View_Select_Text_Table OUT bis_vg_types.View_Text_Table_Type

976: , p_mode IN NUMBER := bis_vg_types.sqlplus_production_mode
977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
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

Line 981: , x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type

977: , p_selected_columns IN BIS_VG_TYPES.flexfield_column_table_type := NULL
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;

Line 985: l_col_tab_curr_pos bis_vg_types.view_character_pointer_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;
987: l_col_tab_past_pos bis_vg_types.view_character_pointer_type;
988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;

Line 986: l_sel_tab_curr_pos bis_vg_types.view_character_pointer_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;
987: l_col_tab_past_pos bis_vg_types.view_character_pointer_type;
988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;

Line 987: l_col_tab_past_pos bis_vg_types.view_character_pointer_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;
987: l_col_tab_past_pos bis_vg_types.view_character_pointer_type;
988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;

Line 988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;

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;
987: l_col_tab_past_pos bis_vg_types.view_character_pointer_type;
988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;

Line 989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;

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;
987: l_col_tab_past_pos bis_vg_types.view_character_pointer_type;
988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;

Line 990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;

986: l_sel_tab_curr_pos bis_vg_types.view_character_pointer_type;
987: l_col_tab_past_pos bis_vg_types.view_character_pointer_type;
988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;

Line 991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;

987: l_col_tab_past_pos bis_vg_types.view_character_pointer_type;
988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;

Line 992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;

988: l_sel_tab_past_pos bis_vg_types.view_character_pointer_type;
989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;

Line 993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;

989: l_sel_tab_pretag_pos bis_vg_types.view_character_pointer_type;
990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;

Line 994: l_select_string_table bis_vg_types.view_text_table_type;

990: l_col_tab_pretag_pos bis_vg_types.view_character_pointer_type;
991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;

Line 995: l_union_string_table bis_vg_types.view_text_table_type;

991: l_sel_tab_FROM_pos bis_vg_types.view_character_pointer_type;
992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;

Line 996: l_flex_string_table bis_vg_types.view_text_table_type;

992: l_sel_tab_SELECT_pos bis_vg_types.view_character_pointer_type;
993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;

Line 997: l_from_string_table bis_vg_types.view_text_table_type;

993: l_sel_tab_sec_tag_pos bis_vg_types.view_character_pointer_type;
994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;
1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;

Line 998: l_security_string_table bis_vg_types.view_text_table_type;

994: l_select_string_table bis_vg_types.view_text_table_type;
995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;
1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;
1002: l_temp_column_table bis_vg_types.view_text_table_type;

Line 999: l_column_table bis_vg_types.view_text_table_type;

995: l_union_string_table bis_vg_types.view_text_table_type;
996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;
1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;
1002: l_temp_column_table bis_vg_types.view_text_table_type;
1003: l_temp_select_table bis_vg_types.view_text_table_type;

Line 1000: l_select_table bis_vg_types.view_text_table_type;

996: l_flex_string_table bis_vg_types.view_text_table_type;
997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;
1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;
1002: l_temp_column_table bis_vg_types.view_text_table_type;
1003: l_temp_select_table bis_vg_types.view_text_table_type;
1004: l_unique_tables superset_summary_table_type;

Line 1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;

997: l_from_string_table bis_vg_types.view_text_table_type;
998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;
1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;
1002: l_temp_column_table bis_vg_types.view_text_table_type;
1003: l_temp_select_table bis_vg_types.view_text_table_type;
1004: l_unique_tables superset_summary_table_type;
1005: l_done BOOLEAN;

Line 1002: l_temp_column_table bis_vg_types.view_text_table_type;

998: l_security_string_table bis_vg_types.view_text_table_type;
999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;
1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;
1002: l_temp_column_table bis_vg_types.view_text_table_type;
1003: l_temp_select_table bis_vg_types.view_text_table_type;
1004: l_unique_tables superset_summary_table_type;
1005: l_done BOOLEAN;
1006: l_select_count NUMBER;

Line 1003: l_temp_select_table bis_vg_types.view_text_table_type;

999: l_column_table bis_vg_types.view_text_table_type;
1000: l_select_table bis_vg_types.view_text_table_type;
1001: l_column_comment_table bis_vg_types.Flex_Column_Comment_Table_Type;
1002: l_temp_column_table bis_vg_types.view_text_table_type;
1003: l_temp_select_table bis_vg_types.view_text_table_type;
1004: l_unique_tables superset_summary_table_type;
1005: l_done BOOLEAN;
1006: l_select_count NUMBER;
1007: l_in_union BOOLEAN ;

Line 1022: --- IF (g_mode = bis_vg_types.test_view_gen_mode) THEN

1018:
1019:
1020: --- --- --- DEBUG ---
1021:
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

Line 1037: --- IF (g_mode = bis_vg_types.test_view_gen_mode) THEN

1033: --- , l_dummy
1034: --- , x_error_Tbl
1035: --- );
1036: ---
1037: --- IF (g_mode = bis_vg_types.test_view_gen_mode) THEN
1038: --- bis_debug_pub.debug_off;
1039: --- END IF;
1040: ---
1041: l_flex_string_table(1) := '_KF';

Line 1410: IF (p_mode = bis_vg_types.remove_tags_mode) THEN

1406: );
1407:
1408: END IF;
1409:
1410: IF (p_mode = bis_vg_types.remove_tags_mode) THEN
1411: l_sel_tab_sec_tag_pos := NULL;
1412: ELSE
1413:
1414: l_sel_tab_sec_tag_pos := bis_vg_parser.get_keyword_position

Line 1665: fnd_message.set_name( application => bis_vg_types.MESSAGE_APPLICATION

1661: --- message explaining the exception and then with the execution trace for
1662: --- every procedure in the call stack, the user-friendly message is the first
1663: --- one
1664: l_error_msg := fnd_msg_pub.get(p_encoded => FND_API.G_FALSE);
1665: fnd_message.set_name( application => bis_vg_types.MESSAGE_APPLICATION
1666: , name => 'BIS_VG_FAIL_VIEW_NAME_PROMPT'
1667: );
1668: fnd_message.set_token('VIEW_NAME', p_viewname);
1669: fnd_message.set_token('ERROR_NUMBER',l_error_code );

Line 1726: , p_column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type

1722: --EXCEPTION : None
1723: -- ============================================================================
1724: PROCEDURE comment_Flex_Columns
1725: (p_View_Name IN VARCHAR2
1726: , p_column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type
1727: )
1728: IS
1729:
1730: l_comment_stmt VARCHAR2(5000);

Line 1808: ( p_viewname IN BIS_VG_TYPES.view_name_type

1804: -- =====================
1805: --
1806:
1807: PROCEDURE Generate_Pruned_View
1808: ( p_viewname IN BIS_VG_TYPES.view_name_type
1809: , p_objectname IN varchar2
1810: , p_gen_viewname IN varchar2 := NULL
1811: )
1812:

Line 1815: l_SubsetColRec BIS_VG_TYPES.Flexfield_column_rec_Type;

1811: )
1812:
1813: IS
1814: l_instance VARCHAR2(200);
1815: l_SubsetColRec BIS_VG_TYPES.Flexfield_column_rec_Type;
1816: l_subset_table BIS_VG_TYPES.flexfield_column_table_type
1817: := BIS_VG_TYPES.flexfield_column_table_type();
1818: l_SupersetColRec superset_Rec_Type;
1819: l_superset_table superset_table_type

Line 1816: l_subset_table BIS_VG_TYPES.flexfield_column_table_type

1812:
1813: IS
1814: l_instance VARCHAR2(200);
1815: l_SubsetColRec BIS_VG_TYPES.Flexfield_column_rec_Type;
1816: l_subset_table BIS_VG_TYPES.flexfield_column_table_type
1817: := BIS_VG_TYPES.flexfield_column_table_type();
1818: l_SupersetColRec superset_Rec_Type;
1819: l_superset_table superset_table_type
1820: := superset_table_type();

Line 1817: := BIS_VG_TYPES.flexfield_column_table_type();

1813: IS
1814: l_instance VARCHAR2(200);
1815: l_SubsetColRec BIS_VG_TYPES.Flexfield_column_rec_Type;
1816: l_subset_table BIS_VG_TYPES.flexfield_column_table_type
1817: := BIS_VG_TYPES.flexfield_column_table_type();
1818: l_SupersetColRec superset_Rec_Type;
1819: l_superset_table superset_table_type
1820: := superset_table_type();
1821: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;

Line 1821: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;

1817: := BIS_VG_TYPES.flexfield_column_table_type();
1818: l_SupersetColRec superset_Rec_Type;
1819: l_superset_table superset_table_type
1820: := superset_table_type();
1821: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
1822: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
1823: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
1824: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
1825: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;

Line 1822: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;

1818: l_SupersetColRec superset_Rec_Type;
1819: l_superset_table superset_table_type
1820: := superset_table_type();
1821: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
1822: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
1823: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
1824: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
1825: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
1826: l_success VARCHAR2(100); --changed the length from 2 to 100 for bug 4093769

Line 1823: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;

1819: l_superset_table superset_table_type
1820: := superset_table_type();
1821: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
1822: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
1823: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
1824: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
1825: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
1826: l_success VARCHAR2(100); --changed the length from 2 to 100 for bug 4093769
1827: l_error_string VARCHAR2(4000);

Line 1824: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;

1820: := superset_table_type();
1821: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
1822: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
1823: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
1824: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
1825: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
1826: l_success VARCHAR2(100); --changed the length from 2 to 100 for bug 4093769
1827: l_error_string VARCHAR2(4000);
1828:

Line 1825: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;

1821: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
1822: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
1823: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
1824: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
1825: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
1826: l_success VARCHAR2(100); --changed the length from 2 to 100 for bug 4093769
1827: l_error_string VARCHAR2(4000);
1828:
1829: --- cursor used to process a dynamic multi-row query

Line 1843: g_mode := bis_vg_types.production_mode;

1839:
1840: l_success := bis_debug_pub.set_debug_mode('FILE');
1841: bis_debug_pub.initialize;
1842: bis_debug_pub.setdebuglevel(10);
1843: g_mode := bis_vg_types.production_mode;
1844:
1845: BEGIN
1846: execute immediate 'ALTER session SET global_names=FALSE';
1847: --- --- DEBUG

Line 1979: ( bis_vg_types.sqlplus_production_mode

1975: --create the view
1976: IF p_gen_viewname IS NULL
1977: THEN
1978: BIS_VG_COMPILE.write_View
1979: ( bis_vg_types.sqlplus_production_mode
1980: , p_viewname
1981: , l_View_Column_out_Table
1982: , l_View_Select_out_Table
1983: , l_View_Column_Comment_Table

Line 1989: ( bis_vg_types.EDW_verify_mode

1985: , l_dummy_tbl ----- not used
1986: );
1987: ELSE
1988: BIS_VG_COMPILE.write_View
1989: ( bis_vg_types.EDW_verify_mode
1990: , p_gen_viewname
1991: , l_View_Column_out_Table
1992: , l_View_Select_out_Table
1993: , l_View_Column_Comment_Table

Line 2072: , p_App_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL

2068: PROCEDURE generate_Views -- PUBLIC PROCEDURE
2069: ( x_error_buf OUT VARCHAR2
2070: , x_ret_code OUT NUMBER
2071: , p_all_flag IN VARCHAR2 := NULL
2072: , p_App_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2073: , p_KF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2074: , p_Key_Flex_Code IN bis_vg_types.Key_Flex_Code_Type := NULL
2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL

Line 2073: , p_KF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL

2069: ( x_error_buf OUT VARCHAR2
2070: , x_ret_code OUT NUMBER
2071: , p_all_flag IN VARCHAR2 := NULL
2072: , p_App_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2073: , p_KF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2074: , p_Key_Flex_Code IN bis_vg_types.Key_Flex_Code_Type := NULL
2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL
2077: , p_Lookup_Table_Name IN VARCHAR2 := NULL

Line 2074: , p_Key_Flex_Code IN bis_vg_types.Key_Flex_Code_Type := NULL

2070: , x_ret_code OUT NUMBER
2071: , p_all_flag IN VARCHAR2 := NULL
2072: , p_App_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2073: , p_KF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2074: , p_Key_Flex_Code IN bis_vg_types.Key_Flex_Code_Type := NULL
2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL
2077: , p_Lookup_Table_Name IN VARCHAR2 := NULL
2078: , p_Lookup_Type IN bis_vg_types.Lookup_Code_Type := NULL

Line 2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL

2071: , p_all_flag IN VARCHAR2 := NULL
2072: , p_App_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2073: , p_KF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2074: , p_Key_Flex_Code IN bis_vg_types.Key_Flex_Code_Type := NULL
2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL
2077: , p_Lookup_Table_Name IN VARCHAR2 := NULL
2078: , p_Lookup_Type IN bis_vg_types.Lookup_Code_Type := NULL
2079: , p_View_Name IN bis_vg_types.View_Name_Type := NULL

Line 2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL

2072: , p_App_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2073: , p_KF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2074: , p_Key_Flex_Code IN bis_vg_types.Key_Flex_Code_Type := NULL
2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL
2077: , p_Lookup_Table_Name IN VARCHAR2 := NULL
2078: , p_Lookup_Type IN bis_vg_types.Lookup_Code_Type := NULL
2079: , p_View_Name IN bis_vg_types.View_Name_Type := NULL
2080: )

Line 2078: , p_Lookup_Type IN bis_vg_types.Lookup_Code_Type := NULL

2074: , p_Key_Flex_Code IN bis_vg_types.Key_Flex_Code_Type := NULL
2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL
2077: , p_Lookup_Table_Name IN VARCHAR2 := NULL
2078: , p_Lookup_Type IN bis_vg_types.Lookup_Code_Type := NULL
2079: , p_View_Name IN bis_vg_types.View_Name_Type := NULL
2080: )
2081: IS
2082: --

Line 2079: , p_View_Name IN bis_vg_types.View_Name_Type := NULL

2075: , p_DF_Appl_Short_Name IN bis_vg_types.App_Short_Name_Type := NULL
2076: , p_Desc_Flex_Name IN bis_vg_types.Desc_Flex_Name_Type := NULL
2077: , p_Lookup_Table_Name IN VARCHAR2 := NULL
2078: , p_Lookup_Type IN bis_vg_types.Lookup_Code_Type := NULL
2079: , p_View_Name IN bis_vg_types.View_Name_Type := NULL
2080: )
2081: IS
2082: --
2083: l_View_Table bis_vg_types.View_Table_Type;

Line 2083: l_View_Table bis_vg_types.View_Table_Type;

2079: , p_View_Name IN bis_vg_types.View_Name_Type := NULL
2080: )
2081: IS
2082: --
2083: l_View_Table bis_vg_types.View_Table_Type;
2084: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;

Line 2084: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;

2080: )
2081: IS
2082: --
2083: l_View_Table bis_vg_types.View_Table_Type;
2084: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
2088: l_View_Text_Table bis_vg_types.View_Text_Table_Type;

Line 2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;

2081: IS
2082: --
2083: l_View_Table bis_vg_types.View_Table_Type;
2084: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
2088: l_View_Text_Table bis_vg_types.View_Text_Table_Type;
2089: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;

Line 2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;

2082: --
2083: l_View_Table bis_vg_types.View_Table_Type;
2084: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
2088: l_View_Text_Table bis_vg_types.View_Text_Table_Type;
2089: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
2090: l_debug_file VARCHAR2(2000);

Line 2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;

2083: l_View_Table bis_vg_types.View_Table_Type;
2084: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
2088: l_View_Text_Table bis_vg_types.View_Text_Table_Type;
2089: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
2090: l_debug_file VARCHAR2(2000);
2091: l_log_file VARCHAR2(2000);

Line 2088: l_View_Text_Table bis_vg_types.View_Text_Table_Type;

2084: l_View_Column_Text_Table bis_vg_types.View_Text_Table_Type;
2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
2088: l_View_Text_Table bis_vg_types.View_Text_Table_Type;
2089: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
2090: l_debug_file VARCHAR2(2000);
2091: l_log_file VARCHAR2(2000);
2092: l_out_file VARCHAR2(2000);

Line 2089: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;

2085: l_View_Select_Text_Table bis_vg_types.View_Text_Table_Type;
2086: l_View_Column_Out_Table bis_vg_types.View_Text_Table_Type;
2087: l_View_Select_Out_Table bis_vg_types.View_Text_Table_Type;
2088: l_View_Text_Table bis_vg_types.View_Text_Table_Type;
2089: l_View_Column_Comment_Table bis_vg_types.Flex_Column_Comment_Table_Type;
2090: l_debug_file VARCHAR2(2000);
2091: l_log_file VARCHAR2(2000);
2092: l_out_file VARCHAR2(2000);
2093: l_warehouse_exists NUMBER(1) ;

Line 2095: l_generated_view_name bis_vg_types.view_name_type;

2091: l_log_file VARCHAR2(2000);
2092: l_out_file VARCHAR2(2000);
2093: l_warehouse_exists NUMBER(1) ;
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:

Line 2104: IF ( g_mode = bis_vg_types.production_mode

2100: --
2101: BEGIN
2102: --
2103: l_warehouse_exists := 1;
2104: IF ( g_mode = bis_vg_types.production_mode
2105: OR g_mode = bis_vg_types.sqlplus_production_mode
2106: OR g_mode = bis_vg_types.remove_tags_mode
2107: ) THEN
2108: fnd_profile.put('FND_AS_MSG_LEVEL_THRESHOLD'

Line 2105: OR g_mode = bis_vg_types.sqlplus_production_mode

2101: BEGIN
2102: --
2103: l_warehouse_exists := 1;
2104: IF ( g_mode = bis_vg_types.production_mode
2105: OR g_mode = bis_vg_types.sqlplus_production_mode
2106: OR g_mode = bis_vg_types.remove_tags_mode
2107: ) THEN
2108: fnd_profile.put('FND_AS_MSG_LEVEL_THRESHOLD'
2109: , FND_MSG_PUB.G_MSG_LVL_SUCCESS);

Line 2106: OR g_mode = bis_vg_types.remove_tags_mode

2102: --
2103: l_warehouse_exists := 1;
2104: IF ( g_mode = bis_vg_types.production_mode
2105: OR g_mode = bis_vg_types.sqlplus_production_mode
2106: OR g_mode = bis_vg_types.remove_tags_mode
2107: ) THEN
2108: fnd_profile.put('FND_AS_MSG_LEVEL_THRESHOLD'
2109: , FND_MSG_PUB.G_MSG_LVL_SUCCESS);
2110: ELSE

Line 2157: IF (g_mode <> bis_vg_types.production_mode) THEN

2153: , l_error_Tbl
2154: );
2155: bis_vg_log.init_log(l_return_status, l_error_Tbl);
2156:
2157: IF (g_mode <> bis_vg_types.production_mode) THEN
2158: --
2159: BEGIN
2160: -- only dbms_output allowed in the whole program
2161: --dbms_output.put_line('Debug file - ' || l_debug_file);

Line 2170: IF (g_mode <> bis_vg_types.sqlplus_production_mode) THEN

2166: END;
2167:
2168: --
2169: --
2170: IF (g_mode <> bis_vg_types.sqlplus_production_mode) THEN
2171: bis_debug_pub.debug_on;
2172: bis_debug_pub.Add('BIS_VEW_GENERATOR. Generate_Views : '
2173: || 'l_View_Table.count = ' || l_View_Table.COUNT);
2174: bis_debug_pub.debug_off;

Line 2204: IF (g_mode <> bis_vg_types.test_no_view_gen_mode) then

2200: , l_error_Tbl
2201: );
2202: BEGIN
2203: --
2204: IF (g_mode <> bis_vg_types.test_no_view_gen_mode) then
2205: --- start a block for use in updating warehouse status
2206: BEGIN --- BLOCK inside IF enumerate-without-generate mode
2207: -- Bug 6819715
2208: -- Check the profile and database version to decide if the we need to modify some session and system settings

Line 2448: IF (g_mode = bis_vg_types.production_mode) THEN

2444: , l_return_status
2445: , l_error_Tbl
2446: );
2447: WHEN OTHERS THEN
2448: IF (g_mode = bis_vg_types.production_mode) THEN
2449: x_error_buf := SQLERRM;
2450: x_ret_code := 2;
2451: ELSE
2452: bis_debug_pub.debug_on;

Line 2460: (p_mode IN bis_vg_types.view_generator_mode_type)

2456: END IF;
2457: END generate_Views;
2458:
2459: PROCEDURE set_mode
2460: (p_mode IN bis_vg_types.view_generator_mode_type)
2461: IS
2462: BEGIN
2463: bis_debug_pub.Add('> set_mode');
2464: g_mode := p_mode;

Line 2479: (p_mode IN bis_vg_types.view_generator_mode_type

2475: --
2476: END set_mode;
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