APPS.PAY_AU_PROCESSES_API SQL Statements

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

Line: 40

  select process_id from pay_au_processes pap
  where  pap.legislation_code = p_legislation_code
  and    (pap.business_group_id is null
          or pap.business_group_id = p_business_group_id)
  and    (pap.short_name = p_short_name
          or pap.name = p_name);

Line: 127

procedure delete_au_process
  (p_validate                      in      boolean  default false,
   p_process_id                    in      number,
   p_object_version_number         in      number)  is
  --
  l_proc                       varchar2(72);

Line: 135

  l_proc                       := g_package||'delete_au_process';

Line: 142

    savepoint delete_au_process;

Line: 172

    ROLLBACK TO delete_au_process;

Line: 173

end delete_au_process;

Line: 180

procedure update_au_process
  (p_validate                      in      boolean  default false,
   p_process_id                    in      number,
   p_short_name                    in      varchar2,
   p_name                          in      varchar2,
   p_enabled_flag                  in      varchar2,
   p_business_group_id             in      number,
   p_legislation_code              in      varchar2,
   p_description                   in      varchar2,
   p_accrual_category              in      varchar2,
   p_object_version_number         in out  nocopy   number
  )  is
  --
  l_proc                       varchar2(72);

Line: 196

  l_proc := g_package||'update_au_process';

Line: 202

    savepoint update_au_process;

Line: 240

    ROLLBACK TO update_au_process;

Line: 241

end update_au_process;