APPS.PQP_GB_ABSENCE_PLAN_PROCESS SQL Statements

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

Line: 337

  PROCEDURE update_absence_plan_details(
    p_person_id                 IN       NUMBER
   ,p_assignment_id             IN       NUMBER
   ,p_business_group_id         IN       NUMBER
   ,p_legislation_code          IN       VARCHAR2
   ,p_effective_date            IN       DATE
   ,p_element_type_id           IN       NUMBER
   ,p_effective_start_date      IN       DATE
   ,p_effective_end_date        IN       DATE
   ,p_pl_id                     IN       NUMBER
   ,p_pl_typ_id                 IN       NUMBER
   ,p_ler_id                    IN       NUMBER
   ,p_per_in_ler_id             IN       NUMBER
   ,p_absence_attendance_id     IN       NUMBER
   ,p_absence_date_start        IN       DATE
   ,p_absence_date_end          IN       DATE
   ,p_formula_outputs           IN       ff_exec.outputs_t
   ,p_error_code                OUT NOCOPY NUMBER
   ,p_error_message             OUT NOCOPY VARCHAR2
  )
  IS
    l_absence_pay_plan_category   pay_element_type_extra_info.eei_information30%TYPE;

Line: 363

                           := g_package_name || 'update_absence_plan_details';

Line: 390

      pqp_absval_pkg.update_absence_plan_details(
        p_assignment_id =>              p_assignment_id
       ,p_person_id =>                  p_person_id
       ,p_business_group_id =>          p_business_group_id
       ,p_absence_id =>                 p_absence_attendance_id
       ,p_absence_date_start =>         p_absence_date_start
       ,p_absence_date_end =>           p_absence_date_end
       ,p_pl_id =>                      p_pl_id
       ,p_pl_typ_id =>                  p_pl_typ_id
       ,p_element_type_id =>            p_element_type_id
       ,p_update_start_date =>          p_effective_start_date
       ,p_update_end_date =>            p_effective_end_date
       ,p_output_type =>                p_formula_outputs
       ,p_error_code =>                 l_error_code
       ,p_message =>                    l_message
      );

Line: 414

      pqp_gb_omp_daily_absences.update_absence_plan_details(
        p_assignment_id =>              p_assignment_id
       ,p_person_id =>                  p_person_id
       ,p_business_group_id =>          p_business_group_id
       ,p_absence_id =>                 p_absence_attendance_id
       ,p_absence_date_start =>         p_absence_date_start
       ,p_absence_date_end =>           p_absence_date_end
       ,p_pl_id =>                      p_pl_id
       ,p_pl_typ_id =>                  p_pl_typ_id
       ,p_element_type_id =>            p_element_type_id
       ,p_update_start_date =>          p_effective_start_date
       ,p_update_end_date =>            p_effective_end_date
       ,p_output_type =>                p_formula_outputs
       ,p_error_code =>                 l_error_code
       ,p_message =>                    l_message
      );

Line: 463

  END update_absence_plan_details;

Line: 468

  PROCEDURE delete_absence_plan_details(
    p_assignment_id             IN       NUMBER
   ,p_business_group_id         IN       NUMBER
   ,p_legislation_code          IN       VARCHAR2
   ,p_effective_date            IN       DATE
   ,p_pl_id                     IN       NUMBER
   ,p_pl_typ_id                 IN       NUMBER
   ,p_ler_id                    IN       NUMBER
   ,p_per_in_ler_id             IN       NUMBER
   ,p_absence_attendance_id     IN       NUMBER
   ,p_effective_start_date      IN       DATE
   ,p_effective_end_date        IN       DATE
   ,p_formula_outputs           IN       ff_exec.outputs_t
   ,p_error_code                OUT NOCOPY NUMBER
   ,p_error_message             OUT NOCOPY VARCHAR2
   ,p_element_type_id           IN       NUMBER DEFAULT NULL
  )
  IS
    l_absence_pay_plan_category   pay_element_type_extra_info.eei_information30%TYPE;

Line: 491

                           := g_package_name || 'delete_absence_plan_details';

Line: 522

      pqp_absval_pkg.delete_absence_plan_details(
        p_assignment_id =>              p_assignment_id
       ,p_business_group_id =>          p_business_group_id
       ,p_plan_id =>                    p_pl_id
       ,p_absence_id =>                 p_absence_attendance_id
       ,p_delete_start_date =>          p_effective_start_date
       ,p_delete_end_date =>            p_effective_end_date
       ,p_error_code =>                 l_error_code
       ,p_message =>                    l_message
      );

Line: 570

  END delete_absence_plan_details;