The following lines contain the word 'select', 'insert', 'update' or 'delete':
, p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type
, p_applsys_schema IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
)
IS
l_count NUMBER;
FOR l_count IN 1 .. p_View_Select_Text_Table.COUNT
LOOP
l_total := l_total+1;
AD_DDL.build_statement(p_View_Select_Text_Table(l_count)
, l_total);
BIS_DEBUG_PUB.Add(p_View_Select_Text_Table(l_count));
bis_vg_log.update_failure_log( x_error_tbl
, x_return_status
, x_error_Tbl
);
, p_View_Select_Text_Table IN bis_vg_types.View_Text_Table_Type
, p_applsys_schema IN VARCHAR2
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
)
IS
l_buffer VARCHAR2(29000);
FOR l_count IN 1 .. p_View_Select_Text_Table.COUNT
LOOP
l_buffer:=l_buffer || p_View_Select_Text_Table(l_count);
l_length := l_length + length(p_View_Select_Text_Table(l_count));
BIS_DEBUG_PUB.Add(p_View_Select_Text_Table(l_count) );
bis_vg_log.update_failure_log( x_error_tbl
, x_return_status
, x_error_Tbl
);
bis_vg_log.update_failure_log( x_error_tbl
, x_return_status
, x_error_Tbl
);
bis_vg_log.update_failure_log( x_error_tbl
, x_return_status
, x_error_Tbl
);
PROCEDURE insert_hat_in_column -- PRIVATE PROCEDURE
( p_column_name IN bis_vg_types.View_Text_Table_Rec_Type
, p_table_column_name IN bis_vg_types.View_Text_Table_Rec_Type
, x_column_name IN OUT NOCOPY bis_vg_types.View_Text_Table_Rec_Type
, x_return_status OUT NOCOPY VARCHAR2
, x_error_Tbl OUT NOCOPY BIS_VG_UTIL.Error_Tbl_Type
)
IS
--
l_pos NUMBER;
bis_debug_pub.Add('> insert_hat_in_column');
bis_debug_pub.Add('< insert_hat_in_column');
, p_error_proc_name => G_PKG_NAME||'.insert_hat_in_column'
, p_error_table => x_error_tbl
, x_error_table => x_error_tbl
);
bis_vg_log.update_failure_log( x_error_tbl
, x_return_status
, x_error_Tbl
);
END insert_hat_in_column;
insert_hat_in_column( l_column_name
, l_View_Text_Count_Table(l_index).Column_name
, l_column_name
, x_return_status
, x_error_Tbl
);
bis_vg_log.update_failure_log( x_error_tbl
, x_return_status
, x_error_Tbl
);
bis_vg_log.update_failure_log( x_error_tbl
, x_return_status
, x_error_Tbl
);
bis_vg_log.update_failure_log( x_error_tbl
, l_dummy
, x_error_Tbl
);
, p_View_Select_Text_Table IN bis_vg_types.view_text_table_type
, p_View_Column_Comment_Table IN bis_vg_types.Flex_Column_Comment_Table_Type
, x_View_Column_Comment_Table OUT bis_vg_types.Flex_Column_Comment_Table_Type
---, x_return_status OUT VARCHAR2
, x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
)
IS
--
l_View_Create_Text_Table bis_vg_types.View_Text_Table_Type;
, p_View_Select_Text_Table
, l_applsys_schema
, dummy_char
, x_error_Tbl
);
, p_View_Select_Text_Table
, l_applsys_schema
, dummy_char
, x_error_Tbl
);
bis_vg_log.update_failure_log( x_error_tbl
, dummy_char
, x_error_Tbl
);