APPS.PQH_DE_OPERATION_GROUPS_API SQL Statements

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

Line: 12

procedure Insert_OPERATION_GROUPS
 ( p_validate                           in  boolean  default false
  ,p_effective_date                     in  date
  ,p_operation_Group_CODE               In  Varchar2
  ,P_DESCRIPTION                        In  Varchar2
  ,p_business_group_id                  in  number
  ,p_operation_GROUP_ID                 out nocopy Number
  ,p_object_version_number              out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 34

  savepoint Insert_OPERATION_GROUPS;

Line: 43

   PQH_DE_OPERATION_GROUPS_BK1.Insert_OPERATION_GROUPS_b
  (p_effective_date                 => L_Effective_Date
           ,p_operation_Group_CODE           => p_operation_Group_CODE
           ,P_DESCRIPTION                    => P_DESCRIPTION
           ,p_operation_GROUP_ID             => l_operation_GROUP_ID
           ,p_object_version_number          => P_object_version_number
           ,p_business_group_id       	     => p_business_group_id
           );

Line: 80

        PQH_DE_OPERATION_GROUPS_BK1.Insert_OPERATION_GROUPS_a
           (p_effective_date                 => L_Effective_Date
           ,p_operation_Group_CODE           => p_operation_Group_CODE
           ,P_DESCRIPTION                    => P_DESCRIPTION
           ,p_operation_GROUP_ID             => l_operation_GROUP_ID
           ,p_object_version_number          => P_object_version_number
           ,p_business_group_id       	     => p_business_group_id
           );

Line: 117

    rollback to Insert_OPERATION_GROUPS;

Line: 133

    rollback to Insert_OPERATION_GROUPS;

Line: 136

end Insert_OPERATION_GROUPS;

Line: 142

Procedure Update_OPERATION_GROUPS
  (p_validate                       in     boolean  default false
  ,p_effective_date                 in     date
  ,p_operation_GROUP_ID             in     number
  ,p_object_version_number          in out nocopy number
  ,p_operation_Group_CODE           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_OPERATION_GROUPS';

Line: 161

  savepoint Update_OPERATION_GROUPS;

Line: 171

           PQH_DE_OPERATION_GROUPS_BK2.Update_OPERATION_GROUPS_b
           (p_effective_date                 => L_Effective_Date
           ,p_operation_Group_CODE           => p_operation_Group_CODE
           ,P_DESCRIPTION                    => P_DESCRIPTION
           ,p_operation_GROUP_ID             => p_operation_GROUP_ID
           ,p_object_version_number          => P_object_version_number
           ,p_business_group_id       	     => p_business_group_id
           );

Line: 184

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

Line: 204

 PQH_DE_OPERATION_GROUPS_BK2.Update_OPERATION_GROUPS_a
           (p_effective_date                 => L_Effective_Date
           ,p_operation_Group_CODE           => p_operation_Group_CODE
           ,P_DESCRIPTION                    => P_DESCRIPTION
           ,p_operation_GROUP_ID             => p_operation_GROUP_ID
           ,p_object_version_number          => P_object_version_number
           ,p_business_group_id       	     => p_business_group_id
            );

Line: 216

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

Line: 240

    rollback to Update_OPERATION_GROUPS;

Line: 253

    rollback to Update_OPERATION_GROUPS;

Line: 256

end Update_OPERATION_GROUPS;

Line: 262

procedure delete_OPERATION_GROUPS
  (p_validate                      in     boolean  default false
  ,p_operation_GROUP_ID            In     Number
  ,p_object_version_number         In     number) Is
 --

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

Line: 277

  savepoint delete_OPERATION_GROUPS;

Line: 282

  PQH_DE_OPERATION_GROUPS_BK3.Delete_OPERATION_GROUPS_b
  (p_operation_GROUP_ID            =>   p_operation_GROUP_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 290

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

Line: 305

  PQH_DE_OPERATION_GROUPS_BK3.Delete_OPERATION_GROUPS_a
  (p_operation_GROUP_ID            =>   p_operation_GROUP_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 312

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

Line: 331

    rollback to delete_OPERATION_GROUPS;

Line: 342

    rollback to delete_OPERATION_GROUPS;

Line: 345

end delete_OPERATION_GROUPS;