APPS.PQH_DE_TKTDTLS_API SQL Statements

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

Line: 12

procedure Insert_TKT_DTLS
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_TATIGKEIT_NUMBER              In  Varchar2  Default NULL
  ,P_DESCRIPTION                   In  Varchar2
  ,P_TATIGKEIT_DETAIL_ID           out nocopy Number
  ,p_object_version_number         out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 34

  savepoint Insert_TKT_DTLS;

Line: 46

   PQH_DE_TKTDTLS_BK1.Insert_TKT_DTLS_b
   (p_effective_date             => L_Effective_Date
   ,p_TATIGKEIT_NUMBER           => p_TATIGKEIT_NUMBER
   ,P_DESCRIPTION                => P_DESCRIPTION );

Line: 78

        PQH_DE_TKTDTLS_BK1.Insert_TKT_DTLS_a
           (p_effective_date             => L_Effective_Date
           ,p_TATIGKEIT_NUMBER           => p_TATIGKEIT_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_TATIGKEIT_DETAIL_ID        => l_TATIGKEIT_DETAIL_ID
           ,p_object_version_number      => l_object_version_number);

Line: 113

    rollback to Insert_TKT_DTLS;

Line: 129

    rollback to Insert_TKT_DTLS;

Line: 132

end Insert_TKT_DTLS;

Line: 139

procedure Update_TKT_DTLS
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_TATIGKEIT_NUMBER              In  Varchar2 Default hr_api.g_Varchar2
  ,P_DESCRIPTION                   In  Varchar2 Default hr_api.g_Varchar2
  ,P_TATIGKEIT_DETAIL_ID           In  Number
  ,p_object_version_number         in out nocopy number) Is

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

Line: 156

  savepoint Update_TKT_DTLS;

Line: 167

PQH_DE_TKTDTLS_BK2.Update_TKT_DTLS_b
           (p_effective_date             => L_Effective_Date
           ,p_TATIGKEIT_NUMBER           => p_TATIGKEIT_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_TATIGKEIT_DETAIL_ID        => p_TATIGKEIT_DETAIL_ID
           ,p_object_version_number      => l_object_version_number);

Line: 178

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

Line: 197

 PQH_DE_TKTDTLS_BK2.Update_TKT_DTLS_a
           (p_effective_date             => L_Effective_Date
           ,p_TATIGKEIT_NUMBER           => p_TATIGKEIT_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_TATIGKEIT_DETAIL_ID        => p_TATIGKEIT_DETAIL_ID
           ,p_object_version_number      => l_object_version_number);

Line: 207

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

Line: 231

    rollback to Update_TKT_DTLS;

Line: 244

    rollback to Update_TKT_DTLS;

Line: 247

end Update_TKT_DTLS;

Line: 253

procedure delete_TKT_DTLS
  (p_validate                      in     boolean  default false
  ,p_TATIGKEIT_DETAIL_ID           In     Number
  ,p_object_version_number         In     number) Is   --

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_TKT_DTLS';

Line: 267

  savepoint delete_TKT_DTLS;

Line: 272

  PQH_DE_TKTDTLS_BK3.Delete_TKT_DTLS_b
  (p_TATIGKEIT_DETAIL_Id           =>   p_TATIGKEIT_DETAIL_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 278

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

Line: 293

  PQH_DE_TKTDTLS_BK3.Delete_TKT_DTLS_a
  (p_TATIGKEIT_DETAIL_Id           =>   p_TATIGKEIT_DETAIL_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 300

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

Line: 319

    rollback to delete_TKT_DTLS;

Line: 330

    rollback to delete_TKT_DTLS;

Line: 333

end delete_TKT_DTLS;