33: --- COMMENT : Call this procedure to retrieve the view text from the runtime repository.
34: --- EXCEPTION : None
35: --- ======================================================================================
36: PROCEDURE create_View_Text_Tables
37: ( p_View_name IN BIS_VG_TYPES.View_name_type := null
38: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
39: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
40: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
41: );
34: --- EXCEPTION : None
35: --- ======================================================================================
36: PROCEDURE create_View_Text_Tables
37: ( p_View_name IN BIS_VG_TYPES.View_name_type := null
38: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
39: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
40: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
41: );
42: --
35: --- ======================================================================================
36: PROCEDURE create_View_Text_Tables
37: ( p_View_name IN BIS_VG_TYPES.View_name_type := null
38: , x_View_Column_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
39: , x_View_Select_Text_Table OUT BIS_VG_TYPES.View_Text_Table_Type
40: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
41: );
42: --
43: /* ======================================================================================
60: EXCEPTION : None
61: ====================================================================================== */
62: PROCEDURE retrieve_Business_Views
63: ( p_all_flag IN VARCHAR2 := NULL
64: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
65: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
66: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
67: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
61: ====================================================================================== */
62: PROCEDURE retrieve_Business_Views
63: ( p_all_flag IN VARCHAR2 := NULL
64: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
65: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
66: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
67: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69: , p_Lookup_Table_Name IN VARCHAR2 := NULL
62: PROCEDURE retrieve_Business_Views
63: ( p_all_flag IN VARCHAR2 := NULL
64: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
65: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
66: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
67: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69: , p_Lookup_Table_Name IN VARCHAR2 := NULL
70: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
63: ( p_all_flag IN VARCHAR2 := NULL
64: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
65: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
66: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
67: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69: , p_Lookup_Table_Name IN VARCHAR2 := NULL
70: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
71: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
64: , p_App_Short_name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
65: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
66: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
67: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69: , p_Lookup_Table_Name IN VARCHAR2 := NULL
70: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
71: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
72: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
66: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type := NULL
67: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69: , p_Lookup_Table_Name IN VARCHAR2 := NULL
70: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
71: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
72: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
73: , x_return_status OUT VARCHAR2
74: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
67: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type := NULL
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69: , p_Lookup_Table_Name IN VARCHAR2 := NULL
70: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
71: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
72: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
73: , x_return_status OUT VARCHAR2
74: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
75: );
68: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type := NULL
69: , p_Lookup_Table_Name IN VARCHAR2 := NULL
70: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type := NULL
71: , p_View_Name IN BIS_VG_TYPES.View_name_Type := NULL
72: , x_View_Table OUT BIS_VG_TYPES.View_Table_Type
73: , x_return_status OUT VARCHAR2
74: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
75: );
76: --