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

Line 40: ( p_view_name IN BIS_VG_TYPES.view_name_type

36: -- the runtime repository.
37: -- EXCEPTION : None
38: -- ===========================================================================
39: PROCEDURE string_generator_init
40: ( p_view_name IN BIS_VG_TYPES.view_name_type
41: --- , x_return_status OUT VARCHAR2
42: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
43: )
44: IS

Line 171: ( p_view_name IN BIS_VG_TYPES.View_name_Type := null

167: -- the runtime repository.
168: -- EXCEPTION : None
169: -- ============================================================================
170: PROCEDURE create_View_Select_Text_Table
171: ( p_view_name IN BIS_VG_TYPES.View_name_Type := null
172: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
173: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
174: )
175: IS

Line 172: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type

168: -- EXCEPTION : None
169: -- ============================================================================
170: PROCEDURE create_View_Select_Text_Table
171: ( p_view_name IN BIS_VG_TYPES.View_name_Type := null
172: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
173: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
174: )
175: IS
176: --

Line 246: ( p_view_name IN BIS_VG_TYPES.View_name_type := null

242: --- repository.
243: --- EXCEPTION : None
244: --- ============================================================================
245: PROCEDURE create_View_Text_Tables
246: ( p_view_name IN BIS_VG_TYPES.View_name_type := null
247: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
248: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
249: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
250: )

Line 247: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type

243: --- EXCEPTION : None
244: --- ============================================================================
245: PROCEDURE create_View_Text_Tables
246: ( p_view_name IN BIS_VG_TYPES.View_name_type := null
247: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
248: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
249: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
250: )
251: IS

Line 248: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type

244: --- ============================================================================
245: PROCEDURE create_View_Text_Tables
246: ( p_view_name IN BIS_VG_TYPES.View_name_type := null
247: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
248: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
249: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
250: )
251: IS
252: l_count NUMBER;

Line 328: ( p_view_rec IN bis_vg_types.view_table_rec_type

324: returns view record with all the info
325: Exception : none
326: ========================================================================== */
327: FUNCTION get_app_info
328: ( p_view_rec IN bis_vg_types.view_table_rec_type
329: , x_return_status OUT VARCHAR2
330: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
331: )
332: RETURN bis_vg_types.view_table_rec_type

Line 332: RETURN bis_vg_types.view_table_rec_type

328: ( p_view_rec IN bis_vg_types.view_table_rec_type
329: , x_return_status OUT VARCHAR2
330: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
331: )
332: RETURN bis_vg_types.view_table_rec_type
333: IS
334: l_str fnd_application.application_short_name%TYPE;
335: l_pos NUMBER;
336: l_view_rec bis_vg_types.view_table_rec_type;

Line 336: l_view_rec bis_vg_types.view_table_rec_type;

332: RETURN bis_vg_types.view_table_rec_type
333: IS
334: l_str fnd_application.application_short_name%TYPE;
335: l_pos NUMBER;
336: l_view_rec bis_vg_types.view_table_rec_type;
337:
338: CURSOR app_cursor(p_short_name IN VARCHAR2) IS
339: SELECT application_id
340: FROM fnd_application

Line 489: , x_View_Table OUT BIS_VG_TYPES.view_table_type

485: ========================================================================== */
486: PROCEDURE retrieve_business_views_field
487: ( p_compare_string IN VARCHAR2
488: , p_search_string IN VARCHAR2
489: , x_View_Table OUT BIS_VG_TYPES.view_table_type
490: , x_return_status OUT VARCHAR2
491: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
492: )
493: IS

Line 517: l_view_rec bis_vg_types.view_table_rec_type;

513: OR column_name LIKE Lower(p_like_str) escape '\'
514: )
515: ;
516:
517: l_view_rec bis_vg_types.view_table_rec_type;
518: l_valid_view BOOLEAN;
519: begin
520: BIS_DEBUG_PUB.Add('> retrieve_business_views_field');
521:

Line 576: ( p_KF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL

572:
573: EXCEPTION : None
574: ========================================================================== */
575: PROCEDURE retrieve_business_views_kfx
576: ( p_KF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
577: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
578: , x_View_Table OUT BIS_VG_TYPES.view_table_type
579: , x_return_status OUT VARCHAR2
580: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 577: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL

573: EXCEPTION : None
574: ========================================================================== */
575: PROCEDURE retrieve_business_views_kfx
576: ( p_KF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
577: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
578: , x_View_Table OUT BIS_VG_TYPES.view_table_type
579: , x_return_status OUT VARCHAR2
580: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
581: )

Line 578: , x_View_Table OUT BIS_VG_TYPES.view_table_type

574: ========================================================================== */
575: PROCEDURE retrieve_business_views_kfx
576: ( p_KF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
577: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
578: , x_View_Table OUT BIS_VG_TYPES.view_table_type
579: , x_return_status OUT VARCHAR2
580: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
581: )
582: IS

Line 636: ( p_DF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL

632:
633: EXCEPTION : None
634: ========================================================================== */
635: PROCEDURE retrieve_business_views_dfx
636: ( p_DF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
637: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
638: , x_View_Table OUT BIS_VG_TYPES.view_table_type
639: , x_return_status OUT VARCHAR2
640: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 637: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL

633: EXCEPTION : None
634: ========================================================================== */
635: PROCEDURE retrieve_business_views_dfx
636: ( p_DF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
637: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
638: , x_View_Table OUT BIS_VG_TYPES.view_table_type
639: , x_return_status OUT VARCHAR2
640: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
641: )

Line 638: , x_View_Table OUT BIS_VG_TYPES.view_table_type

634: ========================================================================== */
635: PROCEDURE retrieve_business_views_dfx
636: ( p_DF_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
637: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
638: , x_View_Table OUT BIS_VG_TYPES.view_table_type
639: , x_return_status OUT VARCHAR2
640: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
641: )
642: IS

Line 699: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type

695: EXCEPTION : None
696: ========================================================================== */
697: PROCEDURE retrieve_business_views_lat
698: ( p_Lookup_Table_Name IN VARCHAR2
699: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
700: , x_View_Table OUT BIS_VG_TYPES.view_table_type
701: , x_return_status OUT VARCHAR2
702: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
703: )

Line 700: , x_View_Table OUT BIS_VG_TYPES.view_table_type

696: ========================================================================== */
697: PROCEDURE retrieve_business_views_lat
698: ( p_Lookup_Table_Name IN VARCHAR2
699: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
700: , x_View_Table OUT BIS_VG_TYPES.view_table_type
701: , x_return_status OUT VARCHAR2
702: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
703: )
704: IS

Line 758: ( p_view_name IN BIS_VG_TYPES.View_name_Type

754: from the runtime repository.
755: EXCEPTION : None
756: ========================================================================== */
757: PROCEDURE retrieve_business_view_name
758: ( p_view_name IN BIS_VG_TYPES.View_name_Type
759: , x_View_Table OUT BIS_VG_TYPES.view_table_type
760: , x_return_status OUT VARCHAR2
761: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
762: )

Line 759: , x_View_Table OUT BIS_VG_TYPES.view_table_type

755: EXCEPTION : None
756: ========================================================================== */
757: PROCEDURE retrieve_business_view_name
758: ( p_view_name IN BIS_VG_TYPES.View_name_Type
759: , x_View_Table OUT BIS_VG_TYPES.view_table_type
760: , x_return_status OUT VARCHAR2
761: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
762: )
763: IS

Line 770: l_view_rec bis_vg_types.view_table_rec_type;

766: view_name
767: , text_length
768: FROM user_views
769: WHERE view_name = Upper(p_view_name);
770: l_view_rec bis_vg_types.view_table_rec_type;
771: BEGIN
772: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_view_name');
773: BIS_DEBUG_PUB.Add('view-name is '||p_view_name);
774: FOR cr IN c_all_views LOOP

Line 821: ( p_app_short_name IN BIS_VG_TYPES.App_Short_Name_Type

817: from the runtime repository.
818: EXCEPTION : None
819: ========================================================================== */
820: PROCEDURE retrieve_business_views_app
821: ( p_app_short_name IN BIS_VG_TYPES.App_Short_Name_Type
822: , x_View_Table OUT BIS_VG_TYPES.view_table_type
823: , x_return_status OUT VARCHAR2
824: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
825: )

Line 822: , x_View_Table OUT BIS_VG_TYPES.view_table_type

818: EXCEPTION : None
819: ========================================================================== */
820: PROCEDURE retrieve_business_views_app
821: ( p_app_short_name IN BIS_VG_TYPES.App_Short_Name_Type
822: , x_View_Table OUT BIS_VG_TYPES.view_table_type
823: , x_return_status OUT VARCHAR2
824: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
825: )
826: IS

Line 847: l_view_rec bis_vg_types.view_table_rec_type;

843: OR view_name LIKE 'IRC'||'BV\_%' escape '\'
844: OR view_name LIKE 'IRC'||'FV\_%' escape '\';
845:
846: l_count NUMBER := 1;
847: l_view_rec bis_vg_types.view_table_rec_type;
848: l_app_abbrev BIS_VG_TYPES.app_short_name_type;
849: l_view_table BIS_VG_TYPES.view_table_type;
850: BEGIN
851:

Line 848: l_app_abbrev BIS_VG_TYPES.app_short_name_type;

844: OR view_name LIKE 'IRC'||'FV\_%' escape '\';
845:
846: l_count NUMBER := 1;
847: l_view_rec bis_vg_types.view_table_rec_type;
848: l_app_abbrev BIS_VG_TYPES.app_short_name_type;
849: l_view_table BIS_VG_TYPES.view_table_type;
850: BEGIN
851:
852: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_app');

Line 849: l_view_table BIS_VG_TYPES.view_table_type;

845:
846: l_count NUMBER := 1;
847: l_view_rec bis_vg_types.view_table_rec_type;
848: l_app_abbrev BIS_VG_TYPES.app_short_name_type;
849: l_view_table BIS_VG_TYPES.view_table_type;
850: BEGIN
851:
852: BIS_DEBUG_PUB.Add('> retrieve_Business_Views_app');
853:

Line 969: (x_View_Table OUT BIS_VG_TYPES.view_table_type

965:
966: EXCEPTION : None
967: ========================================================================== */
968: PROCEDURE retrieve_business_views_all
969: (x_View_Table OUT BIS_VG_TYPES.view_table_type
970: , x_return_status OUT VARCHAR2
971: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
972: )
973: IS

Line 985: l_view_rec bis_vg_types.view_table_rec_type;

981: OR view_name LIKE '__FV\_%' escape '\'
982: OR view_name LIKE '___BV\_%' escape '\'
983: OR view_name LIKE '___FV\_%' escape '\';
984:
985: l_view_rec bis_vg_types.view_table_rec_type;
986:
987: BEGIN
988:
989: FOR cr IN c_all_views LOOP

Line 1045: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL

1041: EXCEPTION : None
1042: ========================================================================== */
1043: PROCEDURE retrieve_Business_Views
1044: ( p_all_flag IN VARCHAR2 := NULL
1045: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1046: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1047: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL

Line 1046: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL

1042: ========================================================================== */
1043: PROCEDURE retrieve_Business_Views
1044: ( p_all_flag IN VARCHAR2 := NULL
1045: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1046: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1047: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
1050: , p_Lookup_Table_Name IN VARCHAR2 := NULL

Line 1047: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL

1043: PROCEDURE retrieve_Business_Views
1044: ( p_all_flag IN VARCHAR2 := NULL
1045: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1046: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1047: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
1050: , p_Lookup_Table_Name IN VARCHAR2 := NULL
1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL

Line 1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL

1044: ( p_all_flag IN VARCHAR2 := NULL
1045: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1046: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1047: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
1050: , p_Lookup_Table_Name IN VARCHAR2 := NULL
1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
1052: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL

Line 1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL

1045: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1046: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1047: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
1050: , p_Lookup_Table_Name IN VARCHAR2 := NULL
1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
1052: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
1053: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type

Line 1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL

1047: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
1050: , p_Lookup_Table_Name IN VARCHAR2 := NULL
1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
1052: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
1053: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
1054: , x_return_status OUT VARCHAR2
1055: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type

Line 1052: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL

1048: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
1050: , p_Lookup_Table_Name IN VARCHAR2 := NULL
1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
1052: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
1053: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
1054: , x_return_status OUT VARCHAR2
1055: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1056: )

Line 1053: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type

1049: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
1050: , p_Lookup_Table_Name IN VARCHAR2 := NULL
1051: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
1052: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
1053: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
1054: , x_return_status OUT VARCHAR2
1055: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
1056: )
1057: IS