APPS.FF_FFXWSDFF_PKG SQL Statements

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

Line: 8

procedure insert_function(x_rowid       in out varchar2,
                          x_function_id in out number,
                          x_class              varchar2,
                          x_name               varchar2,
                          x_alias_name         varchar2,
                          x_business_group_id  number,
                          x_created_by         number,
                          x_creation_date      date,
                          x_data_type          varchar2,
                          x_definition         varchar2,
                          x_last_updated_by    number,
                          x_last_update_date   date,
                          x_last_update_login  number,
                          x_legislation_code   varchar2,
                          x_description        varchar2
                         ) is

  cursor c_rowid is
    select rowid
    from ff_functions
    where function_id = x_function_id;

Line: 31

    select ff_functions_s.nextval
    from dual;

Line: 44

  insert into ff_functions(
    function_id,
    class,
    name,
    alias_name,
    business_group_id,
    created_by,
    creation_date,
    data_type,
    definition,
    last_updated_by,
    last_update_date,
    last_update_login,
    legislation_code,
    description
  )values(
    x_function_id,
    x_class,
    x_name,
    x_alias_name,
    x_business_group_id,
    x_created_by,
    x_creation_date,
    x_data_type,
    x_definition,
    x_last_updated_by,
    x_last_update_date,
    x_last_update_login,
    x_legislation_code,
    x_description
  );

Line: 84

end insert_function;

Line: 97

                        x_last_updated_by    number,
                        x_last_update_date   date,
                        x_last_update_login  number,
                        x_legislation_code   varchar2,
                        x_description        varchar2
                       ) is

  cursor c_row is
    select function_id,
    class,
    name,
    alias_name,
    business_group_id,
    data_type,
    definition,
    legislation_code,
    description
  from ff_functions
  where rowid = x_rowid
  for update of function_id nowait;

Line: 126

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 162

procedure update_function(x_rowid              varchar2,
                          x_function_id        number,
                          x_class              varchar2,
                          x_name               varchar2,
                          x_alias_name         varchar2,
                          x_business_group_id  number,
                          x_created_by         number,
                          x_creation_date      date,
                          x_data_type          varchar2,
                          x_definition         varchar2,
                          x_last_updated_by    number,
                          x_last_update_date   date,
                          x_last_update_login  number,
                          x_legislation_code   varchar2,
                          x_description        varchar2
                         ) is

begin

  update ff_functions set
    function_id       = x_function_id,
    class             = x_class,
    name              = x_name,
    alias_name        = x_alias_name,
    business_group_id = x_business_group_id,
    created_by        = x_created_by,
    creation_date     = x_creation_date,
    data_type         = x_data_type,
    definition        = x_definition,
    last_updated_by   = x_last_updated_by,
    last_update_date  = x_last_update_date,
    last_update_login = x_last_update_login,
    legislation_code  = x_legislation_code,
    description       = x_description
  where rowid = x_rowid;

Line: 202

end update_function;

Line: 205

procedure delete_function(x_rowid       varchar2,
                          x_function_id number) is

begin

  delete from ff_functions
  where rowid = x_rowid;

Line: 213

  delete from ff_function_context_usages
  where function_id = x_function_id;

Line: 216

  delete from ff_function_parameters
  where function_id = x_function_id;

Line: 219

end delete_function;

Line: 226

procedure insert_context_usage(x_rowid       in out varchar2,
                               x_function_id        number,
                               x_sequence_number    number,
                               x_context_id         number
                              ) is

  cursor c_rowid is
    select rowid
    from ff_function_context_usages
    where function_id = x_function_id;

Line: 239

  insert into ff_function_context_usages(
    function_id,
    sequence_number,
    context_id
  )values(
    x_function_id,
    x_sequence_number,
    x_context_id
  );

Line: 257

end insert_context_usage;

Line: 267

    select function_id,
    sequence_number,
    context_id
  from ff_function_context_usages
  where rowid = x_rowid
  for update of function_id nowait;

Line: 282

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 300

procedure update_context_usage(x_rowid              varchar2,
                               x_function_id        number,
                               x_sequence_number    number,
                               x_context_id         number
                              ) is

begin

  update ff_function_context_usages set
    function_id       = x_function_id,
    sequence_number   = x_sequence_number,
    context_id        = x_context_id
  where rowid = x_rowid;

Line: 318

end update_context_usage;

Line: 321

procedure delete_context_usage(x_rowid varchar2) is

begin

  delete from ff_function_context_usages
  where rowid = x_rowid;

Line: 332

end delete_context_usage;

Line: 339

procedure insert_parameter(x_rowid         in out varchar2,
                           x_function_id          number,
                           x_sequence_number      number,
                           x_class                varchar2,
                           x_continuing_parameter varchar2,
                           x_data_type            varchar2,
                           x_name                 varchar2,
                           x_optional             varchar2
                          ) is

  cursor c_rowid is
    select rowid
    from ff_function_parameters
    where function_id = x_function_id;

Line: 356

  insert into ff_function_parameters(
    function_id,
    sequence_number,
    class,
    continuing_parameter,
    data_type,
    name,
    optional
  )values(
    x_function_id,
    x_sequence_number,
    x_class,
    x_continuing_parameter,
    x_data_type,
    x_name,
    x_optional
  );

Line: 382

end insert_parameter;

Line: 396

    select function_id,
    sequence_number,
    class,
    continuing_parameter,
    data_type,
    name,
    optional
  from ff_function_parameters
  where rowid = x_rowid
  for update of function_id nowait;

Line: 415

    fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 437

procedure update_parameter(x_rowid                varchar2,
                           x_function_id          number,
                           x_sequence_number      number,
                           x_class                varchar2,
                           x_continuing_parameter varchar2,
                           x_data_type            varchar2,
                           x_name                 varchar2,
                           x_optional             varchar2
                          ) is

begin

  update ff_function_parameters set
    function_id          = x_function_id,
    sequence_number      = x_sequence_number,
    class                = x_class,
    continuing_parameter = x_continuing_parameter,
    data_type            = x_data_type,
    name                 = x_name,
    optional             = x_optional
  where rowid = x_rowid;

Line: 463

end update_parameter;

Line: 466

procedure delete_parameter(x_rowid varchar2) is

begin

  delete from ff_function_parameters
  where rowid = x_rowid;

Line: 477

end delete_parameter;

Line: 496

    select  nvl (max (sequence_number), 0) + 1
    from    ff_function_parameters
    where   function_id = p_function_id;

Line: 523

    select  nvl (max (sequence_number), 0) + 1
    from    ff_function_context_usages
    where   function_id = p_function_id;