APPS.JTF_GRID_LCT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 6

    x_last_update_date in varchar2,
    x_grid_datasource_name in varchar2,
    x_title_text in varchar2,
    x_owner in varchar2,
    x_db_view_name in varchar2,
    x_application_short_name in varchar2,
    x_default_row_height in varchar2,
    x_max_queried_rows in varchar2,
    x_where_clause in varchar2,
    x_alt_color_code in varchar2,
    x_alt_color_interval in varchar2,
    x_fetch_size in varchar2)
is
  l_custom_mode varchar2(20) := x_custom_mode;

Line: 21

       if x_last_update_date is null then
          l_custom_mode := 'FORCE';

Line: 31

           ,x_last_update_date => x_last_update_date);

Line: 46

            ,x_last_update_date => x_last_update_date);

Line: 57

   x_last_update_date in varchar2,
   x_grid_datasource_name in varchar2,
   x_grid_col_alias     in varchar2,
   x_label_text           in varchar2,
   x_owner      in varchar2,
   x_db_col_name     in varchar2,
   x_data_type_code  in varchar2,
   x_query_seq in varchar2,
   x_sortable_flag         in varchar2,
   x_sort_asc_by_default_flag  in varchar2,
   x_visible_flag             in varchar2,
   x_freeze_visible_flag      in varchar2,
   x_display_seq in varchar2,
   x_display_type_code in varchar2,
   x_display_hsize in varchar2,
   x_header_alignment_code   in varchar2,
   x_cell_alignment_code     in varchar2,
   x_display_format_type_code         in varchar2,
   x_display_format_mask              in varchar2,
   x_checkbox_checked_value          in varchar2,
   x_checkbox_unchecked_value        in varchar2,
   x_checkbox_other_values   in varchar2,
   x_db_currency_code_col    in varchar2,
   x_query_allowed_flag  in varchar2,
   x_validation_object_code  in varchar2,
   x_query_display_seq  in varchar2,
   x_db_sort_column          in varchar2,
   x_fire_post_query_flag     in varchar2,
   x_image_description_col in varchar2 )
is
       l_custom_mode varchar2(20) := x_custom_mode;

Line: 89

       if x_last_update_date is null then
          l_custom_mode := 'FORCE';

Line: 100

           ,x_last_update_date => x_last_update_date);

Line: 132

             ,x_last_update_date =>       x_last_update_date);

Line: 138

   x_last_update_date in varchar2,
   x_upload_mode in varchar2,
   x_owner in varchar2,
   x_grid_datasource_name in varchar2,
   x_grid_sort_col_alias1 in varchar2,
   x_grid_sort_col_alias2 in varchar2,
   x_grid_sort_col_alias3 in varchar2,
   x_custom_mode in varchar2)
is
        l_last_updated_by    number;

Line: 150

        f_ludate  date;    -- entity update date in file

Line: 152

        db_ludate date;    -- entity update date in db

Line: 156

       if x_last_update_date is null then
          l_custom_mode := 'FORCE';

Line: 167

              f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 173

		select LAST_UPDATED_BY, LAST_UPDATE_DATE
                into db_luby, db_ludate
                from JTF_GRID_sort_cols
                where GRID_DATASOURCE_NAME = x_grid_datasource_name;

Line: 183

                        update JTF_GRID_SORT_COLS
                        set GRID_SORT_COL_ALIAS1 = x_grid_sort_col_alias1
                           ,GRID_SORT_COL_ALIAS2 = x_grid_sort_col_alias2
                           ,GRID_SORT_COL_ALIAS3 = x_grid_sort_col_alias3
                           ,LAST_UPDATED_BY = f_luby
                           ,LAST_UPDATE_DATE = f_ludate
                           ,LAST_UPDATE_LOGIN = 0
                        where GRID_DATASOURCE_NAME = x_grid_datasource_name;

Line: 198

                          insert into JTF_GRID_SORT_COLS
                             (GRID_DATASOURCE_NAME
                              ,GRID_SORT_COL_ALIAS1
                              ,GRID_SORT_COL_ALIAS2
                              ,GRID_SORT_COL_ALIAS3
                              ,CREATED_BY
                              ,CREATION_DATE
                              ,LAST_UPDATED_BY
                              ,LAST_UPDATE_DATE
                              ,LAST_UPDATE_LOGIN)
                            values
                              (x_grid_datasource_name
                              ,x_grid_sort_col_alias1
                              ,x_grid_sort_col_alias2
                              ,x_grid_sort_col_alias3
	                      ,f_luby
	                      ,f_ludate
			      ,f_luby
                              ,f_ludate
                              ,0);