APPS.IRC_TEMPLATE_ASSOCIATION_API SQL Statements

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

Line: 150

procedure update_template_association
( p_validate                         in      boolean    default false
 ,p_effective_date                   in      date       default null
 ,p_template_association_id          in      number
 ,p_template_id                      in      number
 ,p_default_association              in      varchar2   default null
 ,p_job_id                           in      number     default null
 ,p_position_id                      in      number     default null
 ,p_organization_id                  in      number     default null
 ,p_start_date                       in      date       default null
 ,p_end_date                         in      date       default null
 ,p_object_version_number            in out  nocopy number

) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'update_template_association';

Line: 178

  savepoint update_template_association;

Line: 191

    irc_template_association_bk2.update_template_association_b
    (p_template_association_id          =>      p_template_association_id
    ,p_template_id                      =>      p_template_id
    ,p_effective_date                   =>      l_effective_date
    ,p_default_association              =>      p_default_association
    ,p_job_id                           =>      p_job_id
    ,p_position_id                      =>      p_position_id
    ,p_organization_id                  =>      p_organization_id
    ,p_start_date                       =>      p_start_date
    ,p_end_date                         =>      p_end_date
    );

Line: 205

        (p_module_name => 'update_template_association'
        ,p_hook_type   => 'BP'
        );

Line: 232

     irc_template_association_bk2.update_template_association_a
     (p_template_association_id          =>  p_template_association_id
     ,p_template_id                      =>  p_template_id
     ,p_effective_date                   =>  l_effective_date
     ,p_default_association              =>  p_default_association
     ,p_job_id                           =>  p_job_id
     ,p_position_id                      =>  p_position_id
     ,p_organization_id                  =>  p_organization_id
     ,p_start_date                       =>  p_start_date
     ,p_end_date                         =>  p_end_date
     );

Line: 246

        (p_module_name => 'update_template_association'
        ,p_hook_type   => 'AP'
        );

Line: 266

    rollback to update_template_association;

Line: 277

    rollback to update_template_association;

Line: 280

end update_template_association;

Line: 286

procedure delete_template_association
  (p_validate                       in       boolean  default false
  ,p_template_association_id        in       number
  ,p_object_version_number          in       number
  ) is

  --
  -- Declare cursors and local variables
  --

  l_proc                   varchar2(72) := g_package||'delete_template_association';

Line: 304

  savepoint delete_template_association;

Line: 310

    irc_template_association_bk3.delete_template_association_b
      (p_template_association_id          =>      p_template_association_id
      ,p_object_version_number            =>      p_object_version_number
      );

Line: 317

        (p_module_name => 'delete_template_association'
        ,p_hook_type   => 'BP'
        );

Line: 340

    irc_template_association_bk3.delete_template_association_a
     (p_template_association_id          =>      p_template_association_id
     ,p_object_version_number            =>      p_object_version_number
     );

Line: 347

        (p_module_name => 'delete_template_association'
        ,p_hook_type   => 'AP'
        );

Line: 365

    rollback to delete_template_association;

Line: 376

    rollback to delete_template_association;

Line: 379

end delete_template_association;