54: --RETURN : None
55: --EXCEPTION : None
56: -- ============================================================================
57: PROCEDURE update_success_log
58: ( p_origbv IN bis_vg_types.view_name_type
59: , p_genbv IN bis_vg_types.view_name_type
60: , x_return_status OUT VARCHAR2
61: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
62: );
55: --EXCEPTION : None
56: -- ============================================================================
57: PROCEDURE update_success_log
58: ( p_origbv IN bis_vg_types.view_name_type
59: , p_genbv IN bis_vg_types.view_name_type
60: , x_return_status OUT VARCHAR2
61: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
62: );
63:
72: --RETURN : None
73: --EXCEPTION : None
74: -- ============================================================================
75: PROCEDURE update_failure_log
76: ( p_origbv IN bis_vg_types.view_name_type
77: , p_code IN NUMBER
78: , p_errm IN VARCHAR2
79: , x_return_status OUT VARCHAR2
80: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
106: --RETURN : None
107: --EXCEPTION : None
108: -- ============================================================================
109: PROCEDURE backpatch_failure_log
110: ( p_origbv IN bis_vg_types.view_name_type
111: , x_return_status OUT VARCHAR2
112: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
113: );
114:
114:
115:
116: -- ============================================================================
117: --PROCEDURE : Write_Log
118: --PARAMETERS 1. p_mode IN bis_vg_Types.view_generator_mode_type
119: -- 2. p_all_flag IN VARCHAR2
120: -- 3. p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
121: -- 4. p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
122: -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
116: -- ============================================================================
117: --PROCEDURE : Write_Log
118: --PARAMETERS 1. p_mode IN bis_vg_Types.view_generator_mode_type
119: -- 2. p_all_flag IN VARCHAR2
120: -- 3. p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
121: -- 4. p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
122: -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
123: -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124: -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
117: --PROCEDURE : Write_Log
118: --PARAMETERS 1. p_mode IN bis_vg_Types.view_generator_mode_type
119: -- 2. p_all_flag IN VARCHAR2
120: -- 3. p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
121: -- 4. p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
122: -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
123: -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124: -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
125: -- 8. p_Lookup_Table_Name IN VARCHAR2
118: --PARAMETERS 1. p_mode IN bis_vg_Types.view_generator_mode_type
119: -- 2. p_all_flag IN VARCHAR2
120: -- 3. p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
121: -- 4. p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
122: -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
123: -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124: -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
125: -- 8. p_Lookup_Table_Name IN VARCHAR2
126: -- 9. p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
119: -- 2. p_all_flag IN VARCHAR2
120: -- 3. p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
121: -- 4. p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
122: -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
123: -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124: -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
125: -- 8. p_Lookup_Table_Name IN VARCHAR2
126: -- 9. p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
127: -- 10. p_View_Name IN BIS_VG_TYPES.View_Name_Type
120: -- 3. p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
121: -- 4. p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
122: -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
123: -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124: -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
125: -- 8. p_Lookup_Table_Name IN VARCHAR2
126: -- 9. p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
127: -- 10. p_View_Name IN BIS_VG_TYPES.View_Name_Type
128: -- 11. x_return_status error or normal
122: -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
123: -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124: -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
125: -- 8. p_Lookup_Table_Name IN VARCHAR2
126: -- 9. p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
127: -- 10. p_View_Name IN BIS_VG_TYPES.View_Name_Type
128: -- 11. x_return_status error or normal
129: -- 12. x_error_Tbl table of error messages
130: --COMMENT : Call this function to write the log to the out file in production
123: -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124: -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
125: -- 8. p_Lookup_Table_Name IN VARCHAR2
126: -- 9. p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
127: -- 10. p_View_Name IN BIS_VG_TYPES.View_Name_Type
128: -- 11. x_return_status error or normal
129: -- 12. x_error_Tbl table of error messages
130: --COMMENT : Call this function to write the log to the out file in production
131: --RETURN : None
131: --RETURN : None
132: --EXCEPTION : None
133: -- ============================================================================
134: PROCEDURE write_log
135: ( p_mode IN bis_vg_types.View_Generator_Mode_Type
136: , p_all_flag IN VARCHAR2
137: , p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
138: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
139: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
133: -- ============================================================================
134: PROCEDURE write_log
135: ( p_mode IN bis_vg_types.View_Generator_Mode_Type
136: , p_all_flag IN VARCHAR2
137: , p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
138: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
139: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
140: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
134: PROCEDURE write_log
135: ( p_mode IN bis_vg_types.View_Generator_Mode_Type
136: , p_all_flag IN VARCHAR2
137: , p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
138: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
139: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
140: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
142: , p_Lookup_Table_Name IN VARCHAR2
135: ( p_mode IN bis_vg_types.View_Generator_Mode_Type
136: , p_all_flag IN VARCHAR2
137: , p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
138: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
139: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
140: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
142: , p_Lookup_Table_Name IN VARCHAR2
143: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
136: , p_all_flag IN VARCHAR2
137: , p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
138: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
139: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
140: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
142: , p_Lookup_Table_Name IN VARCHAR2
143: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
144: , p_View_Name IN BIS_VG_TYPES.View_Name_Type
137: , p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
138: , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
139: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
140: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
142: , p_Lookup_Table_Name IN VARCHAR2
143: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
144: , p_View_Name IN BIS_VG_TYPES.View_Name_Type
145: , x_return_status OUT VARCHAR2
139: , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
140: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
142: , p_Lookup_Table_Name IN VARCHAR2
143: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
144: , p_View_Name IN BIS_VG_TYPES.View_Name_Type
145: , x_return_status OUT VARCHAR2
146: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
147: );
140: , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141: , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
142: , p_Lookup_Table_Name IN VARCHAR2
143: , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
144: , p_View_Name IN BIS_VG_TYPES.View_Name_Type
145: , x_return_status OUT VARCHAR2
146: , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
147: );
148: -- ============================================================================