DBA Data[Home] [Help]

APPS.PAY_IE_SB_API SQL Statements

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

Line: 48

        SELECT business_group_id
        FROM   per_all_assignments_f
        WHERE  assignment_id = p_assignment_id
        AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;
Line: 122

    ,p_program_update_date      => sysdate
    ,p_reduced_tax_credit       => p_reduced_tax_credit
    ,p_reduced_standard_cutoff  => p_reduced_standard_cutoff
    ,p_social_benefit_id        => l_social_benefit_id
    ,p_object_version_number    => l_object_version_number
    ,p_effective_start_date     => l_effective_start_date
    ,p_effective_end_date       => l_effective_end_date
    );
Line: 206

procedure update_ie_sb_details
  (p_validate                       in      boolean     default false
  ,p_effective_date                 in      date
  ,p_datetrack_update_mode          in      varchar2
  ,p_absence_start_date             in      date        default hr_api.g_date
  ,p_absence_end_date               in      date        default hr_api.g_date
  ,p_benefit_amount                 in      number      default hr_api.g_number
  ,p_benefit_type                   in      varchar2    default hr_api.g_varchar2
  ,p_calculation_option             in      varchar2    default hr_api.g_varchar2
  ,p_reduced_tax_credit             in      number      default hr_api.g_number
  ,p_reduced_standard_cutoff        in      number      default hr_api.g_number
  ,p_incident_id                    in      number      default hr_api.g_number
  ,p_social_benefit_id              in      number
  ,p_object_version_number          in out  nocopy number
  ,p_effective_start_date           out     nocopy date
  ,p_effective_end_date             out     nocopy date
  ) is
  l_proc                            varchar2(72) := g_package||'update_ie_sb_details';
Line: 225

  l_datetrack_update_mode           number;
Line: 235

  l_update_mode                     varchar2(30);
Line: 248

        SELECT assignment_id,calculation_option
        FROM   pay_ie_social_benefits_f
        WHERE  social_benefit_id = p_social_benefit_id
        AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;
Line: 254

        SELECT business_group_id
        FROM   per_all_assignments_f
        WHERE  assignment_id = l_assignment_id
        AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;
Line: 265

    savepoint update_ie_sb_details;
Line: 324

        pay_ie_sb_api_bk2.update_ie_sb_details_b
            (p_effective_date               =>  l_effective_date
            ,p_business_group_id            =>  l_business_group_id
            ,p_datetrack_update_mode        =>  p_datetrack_update_mode
            ,p_absence_start_date           =>  l_absence_start_date
            ,p_absence_end_date             =>  l_absence_end_date
            ,p_benefit_amount               =>  l_benefit_amount
            ,p_benefit_type                 =>  l_benefit_type
            ,p_calculation_option           =>  p_calculation_option
            ,p_reduced_tax_credit           =>  l_reduced_tax_credit
            ,p_reduced_standard_cutoff      =>  l_reduced_standard_cutoff
            ,p_incident_id                  =>  l_incident_id
            ,p_social_benefit_id            =>  p_social_benefit_id
            ,p_object_version_number        =>  l_object_version_number
            );
Line: 342

          (p_module_name => 'update_ie_sb_details'
          ,p_hook_type   => 'BP'
          );
Line: 357

    ,p_datetrack_mode               =>  p_datetrack_update_mode
    ,p_social_benefit_id            =>  p_social_benefit_id
    ,p_object_version_number        =>  l_object_version_number
    ,p_assignment_id                =>  l_assignment_id
    ,p_absence_start_date           =>  l_absence_start_date
    ,p_absence_end_date             =>  l_absence_end_date
    ,p_benefit_amount               =>  l_benefit_amount
    ,p_benefit_type                 =>  l_benefit_type
    ,p_calculation_option           =>  p_calculation_option
    ,p_incident_id                  =>  l_incident_id
    ,p_request_id                   =>  l_request_id
    ,p_program_application_id       =>  l_prog_appl_id
    ,p_program_id                   =>  l_program_id
    ,p_program_update_date          =>  sysdate
    ,p_reduced_tax_credit           =>  l_reduced_tax_credit
    ,p_reduced_standard_cutoff      =>  l_reduced_standard_cutoff
    ,p_effective_start_date         =>  l_effective_start_date
    ,p_effective_end_date           =>  l_effective_end_date
    );
Line: 378

        pay_ie_sb_api_bk2.update_ie_sb_details_a
        (p_effective_date               =>  l_effective_date
        ,p_business_group_id            =>  l_business_group_id
        ,p_datetrack_update_mode        =>  p_datetrack_update_mode
        ,p_absence_start_date           =>  l_absence_start_date
        ,p_absence_end_date             =>  l_absence_end_date
        ,p_benefit_amount               =>  l_benefit_amount
        ,p_benefit_type                 =>  l_benefit_type
        ,p_calculation_option           =>  p_calculation_option
        ,p_reduced_tax_credit           =>  l_reduced_tax_credit
        ,p_reduced_standard_cutoff      =>  l_reduced_standard_cutoff
        ,p_incident_id                  =>  l_incident_id
        ,p_social_benefit_id            =>  p_social_benefit_id
        ,p_object_version_number        =>  l_object_version_number
        ,p_effective_start_date         =>  l_effective_start_date
        ,p_effective_end_date           =>  l_effective_end_date
        );
Line: 398

            (p_module_name => 'pay_ie_sb_api_bk2.update_ie_sb_details_a'
            ,p_hook_type   => 'AP'
            );
Line: 423

    rollback to update_ie_sb_details;
Line: 437

    rollback to update_ie_sb_details;
Line: 443

end update_ie_sb_details;
Line: 449

procedure delete_ie_sb_details
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_delete_mode         in     varchar2
  ,p_social_benefit_id             in     number
  ,p_object_version_number         in out nocopy number
  ,p_effective_start_date          out    nocopy date
  ,p_effective_end_date            out    nocopy date
  )
 is
    l_proc                          varchar2(72) := g_package||'delete_ie_social_benefits';
Line: 469

        SELECT assignment_id
        FROM   pay_ie_social_benefits_f
        WHERE  social_benefit_id = p_social_benefit_id
        AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;
Line: 475

        SELECT business_group_id
        FROM   per_all_assignments_f
        WHERE  assignment_id = l_assignment_id
        AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;
Line: 484

  savepoint delete_ie_sb_details;
Line: 498

        pay_ie_sb_api_bk3.delete_ie_sb_details_b
          (p_effective_date                =>   p_effective_date
          ,p_business_group_id             =>   l_business_group_id
          ,p_datetrack_delete_mode         =>   p_datetrack_delete_mode
          ,p_social_benefit_id             =>   p_social_benefit_id
          ,p_object_version_number         =>   l_object_version_number
          );
Line: 508

        (p_module_name => 'delete_ie_sb_details'
        ,p_hook_type   => 'BP'
        );
Line: 519

          ,P_DATETRACK_MODE             =>  p_datetrack_delete_mode
          ,P_SOCIAL_BENEFIT_ID          =>  p_social_benefit_id
          ,P_OBJECT_VERSION_NUMBER      =>  l_object_version_number
          ,P_EFFECTIVE_START_DATE       =>  l_effective_start_date
          ,P_EFFECTIVE_END_DATE         =>  l_effective_end_date
          );
Line: 529

        pay_ie_sb_api_bk3.delete_ie_sb_details_a
          (p_effective_date             =>  p_effective_date
          ,p_business_group_id          =>  l_business_group_id
          ,p_datetrack_delete_mode      =>  p_datetrack_delete_mode
          ,p_social_benefit_id          =>  p_social_benefit_id
          ,p_object_version_number      =>  l_object_version_number
          ,p_effective_start_date       =>  l_effective_start_date
          ,p_effective_end_date         =>  l_effective_end_date
          );
Line: 541

                (p_module_name => 'delete_ie_sb_details'
                ,p_hook_type   => 'AP'
                );
Line: 566

    rollback to delete_ie_sb_details;
Line: 581

    rollback to delete_ie_sb_details;
Line: 587

end delete_ie_sb_details;