APPS.PQH_DE_ENT_MINUTES_API SQL Statements

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

Line: 12

procedure Insert_ENT_MINUTES
  (p_validate                            in  boolean  default false
  ,p_effective_date                      in  date
  ,p_TARIFF_Group_CD                     In  Varchar2
  ,p_ent_minutes_CD                      In  Varchar2
  ,P_DESCRIPTION                         In  Varchar2
  ,p_business_group_id                   in  number
  ,P_ENT_MINUTES_ID                      out nocopy Number
  ,p_object_version_number               out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 35

  savepoint Insert_ENT_MINUTES;

Line: 44

   PQH_DE_ENT_MINUTES_BK1.Insert_ENT_MINUTES_b
    (p_effective_date                 => L_Effective_date
    ,p_ent_minutes_CD                 => p_ent_minutes_CD
    ,P_ENT_MINUTES_ID                 => l_ENT_MINUTES_ID
    ,p_TARIFF_Group_CD                => p_TARIFF_Group_CD
    ,p_description                    => P_DESCRIPTION
    ,p_business_group_id       	      => p_business_group_id
    );

Line: 82

        PQH_DE_ENT_MINUTES_BK1.Insert_ENT_MINUTES_a
           (p_effective_date                 => L_Effective_date
            ,P_ENT_MINUTES_ID                  => l_ENT_MINUTES_ID
            ,p_ent_minutes_CD                 => p_ent_minutes_CD
            ,p_TARIFF_Group_CD                => p_TARIFF_Group_CD
            ,p_description                    => P_DESCRIPTION
            ,p_business_group_id       	      => p_business_group_id
           );

Line: 119

    rollback to Insert_ENT_MINUTES;

Line: 135

    rollback to Insert_ENT_MINUTES;

Line: 138

end Insert_ENT_MINUTES;

Line: 144

  Procedure Update_ENT_MINUTES
  (p_validate                       in     boolean  default false
  ,p_effective_date                 in     date
  ,p_ENT_MINUTES_ID                 in     number
  ,p_object_version_number          in     out nocopy number
  ,p_TARIFF_Group_CD                in     varchar2  default hr_api.g_varchar2
  ,p_ent_minutes_CD                 In      Varchar2     default hr_api.g_varchar2
  ,p_description                    in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id              in     number    default hr_api.g_number
  ) is

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

Line: 164

  savepoint Update_ENT_MINUTES;

Line: 174

           PQH_DE_ENT_MINUTES_BK2.Update_ENT_MINUTES_b
           (p_effective_date                 => L_Effective_date
            ,P_ENT_MINUTES_ID                => P_ENT_MINUTES_ID
            ,p_TARIFF_Group_CD               => p_TARIFF_Group_CD
            ,p_ent_minutes_CD                => p_ent_minutes_CD
            ,p_description                   => P_DESCRIPTION
            ,p_business_group_id       	     => p_business_group_id
           );

Line: 186

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

Line: 207

 PQH_DE_ENT_MINUTES_BK2.Update_ENT_MINUTES_a
          (p_effective_date                  => L_Effective_date
            ,P_ENT_MINUTES_ID                => P_ENT_MINUTES_ID
            ,p_ent_minutes_CD                 => p_ent_minutes_CD
            ,p_TARIFF_Group_CD               => p_TARIFF_Group_CD
            ,p_description                   => P_DESCRIPTION
            ,p_business_group_id       	     => p_business_group_id
           );

Line: 219

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

Line: 243

    rollback to Update_ENT_MINUTES;

Line: 256

    rollback to Update_ENT_MINUTES;

Line: 259

end Update_ENT_MINUTES;

Line: 265

procedure delete_ENT_MINUTES
  (p_validate                      in     boolean  default false
  ,p_ENT_MINUTES_ID                 In     Number
  ,p_object_version_number         In     number) Is
 --

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

Line: 280

  savepoint delete_ENT_MINUTES;

Line: 285

  PQH_DE_ENT_MINUTES_BK3.Delete_ENT_MINUTES_b
  (p_ENT_MINUTES_ID                =>   p_ENT_MINUTES_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 293

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

Line: 308

  PQH_DE_ENT_MINUTES_BK3.Delete_ENT_MINUTES_a
  (p_ENT_MINUTES_ID                  =>   p_ENT_MINUTES_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 315

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

Line: 334

    rollback to delete_ENT_MINUTES;

Line: 345

    rollback to delete_ENT_MINUTES;

Line: 348

end delete_ENT_MINUTES;