APPS.CSF_PARAMS_PKG SQL Statements

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

Line: 86

      select uom_class
      ,      unit_of_measure
      ,      uom_code
      ,      base_uom_flag
      ,      unit_of_measure_tl
      ,      language
      from   mtl_units_of_measure_vl
      where  Upper(uom_class) = 'LENGTH'
      and    uom_code = b_code;

Line: 103

      select distinct inventory_item_id
      ,      concatenated_segments
      from   mtl_system_items_vl
      where  inventory_item_id = b_inventory_item_id;

Line: 110

      select ctt.name
      from   cs_transaction_types ctt
      ,      cs_txn_billing_types ctbt
      where  ctt.transaction_type_id = ctbt.transaction_type_id
      and    ctbt.txn_billing_type_id = b_txn_billing_type_id;

Line: 351

  PROCEDURE update_parameters ( io_param in out nocopy paramtab )
  IS
    /******************************************************
     Created by: T. Voerman, Oracle Nederland

     Date created:

     Purpose: update parametervalues

     Known Limitations:

     Remarks: uses private procedures insert_parameter, update parameter,
              save_parameter_value
    ********************************************************/

    t_csm_onlytodispatchers     number(1);

Line: 371

    procedure insert_parameter
    ( i_name  varchar2
    , i_value varchar2 )
    is
      /******************************************************
       Created by: T. Voerman, Oracle Nederland

       Date created:

       Purpose: insert parameter in csf_params

       Known Limitations:

       Remarks:
      ********************************************************/

    begin
      insert into csf_params
      ( PARAM_ID
      , LAST_UPDATE_DATE
      , LAST_UPDATED_BY
      , CREATION_DATE
      , CREATED_BY
      , LAST_UPDATE_LOGIN
      , NAME
      , VALUE
      )
      values( csf_params_s.nextval
      , sysdate
      , uid
      , sysdate
      , uid
      , 0
      , Upper(i_name)
      , i_value
      );

Line: 407

    end insert_parameter;

Line: 409

    procedure update_parameter
    ( i_name  varchar2
    , i_value varchar2 )
    is
      /******************************************************
       Created by: T. Voerman, Oracle Nederland

       Date created:

       Purpose: update parameter in csf_params

       Known Limitations:

       Remarks:
      ********************************************************/

    begin
      update csf_params par
      set    par.value        = i_value
      ,      last_updated_by  = uid
      ,      last_update_date = sysdate
      where  Upper(par.name)  = Upper(i_name);

Line: 431

    end update_parameter;

Line: 443

                If so: update the parameter value.
                If not: create the parameter together with it's value.

       Known Limitations:

       Remarks:
      ********************************************************/

      r_read_parameter c_read_parameter%rowtype;

Line: 461

        update_parameter( i_name
                        , To_Char(i_value)
                        );

Line: 465

        insert_parameter( i_name
                        , To_Char(i_value)
                        );

Line: 481

                If so: update the parameter value.
                If not: create the parameter together with it's value.

       Known Limitations:

       Remarks:
      ********************************************************/

      r_read_parameter c_read_parameter%rowtype;

Line: 499

        update_parameter( i_name
                        , i_value
                        );

Line: 503

        insert_parameter( i_name
                        , i_value
                        );

Line: 628

  END update_parameters;