APPS.PER_ABS_SHADOW_BOOKING_PKG SQL Statements

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

Line: 88

      SELECT assignment_id
      FROM   per_all_assignments_f
      WHERE  person_id = cp_person_id
      AND    primary_flag = 'Y'
      AND    effective_start_date <= NVL(cp_end_date, SYSDATE)
      AND    effective_end_date >= NVL(cp_start_date, SYSDATE);

Line: 134

      SELECT task_type_id
      FROM   jtf_task_types_vl
      WHERE  name = cp_bkg_type;

Line: 178

      SELECT task_type_id
            ,object_version_number
      FROM   jtf_tasks_vl
      WHERE  source_object_type_code = 'ABSENCE'
      AND    source_object_id = cp_abs_id;

Line: 327

  PROCEDURE update_shadow_booking( p_person_id      IN         NUMBER DEFAULT NULL
                                 , p_assignment_id  IN         NUMBER DEFAULT NULL
                                 , p_absence_id     IN         NUMBER
                                 , p_start_date     IN         DATE
                                 , p_end_date       IN         DATE
                                 , x_return_status  OUT NOCOPY NUMBER
                                 , x_return_message OUT NOCOPY VARCHAR2
                                 ) IS

    l_proc           VARCHAR2(50);

Line: 347

    l_proc := 'per_abs_shadow_booking_pkg.update_shadow_booking';

Line: 400

    cac_bookings_pub.update_booking
    ( p_api_version           => 1.0
    , p_init_msg_list         => 'T'
    , p_commit                => 'T'
    , p_booking_rec           => lr_booking
    , p_object_version_number => l_booking_ovn
    , x_return_status         => l_return_status
    , x_msg_count             => l_msg_count
    , x_msg_data              => l_msg_data
    );

Line: 435

  END update_shadow_booking;

Line: 445

  PROCEDURE delete_shadow_booking( p_person_id      IN         NUMBER DEFAULT NULL
                                 , p_assignment_id  IN         NUMBER DEFAULT NULL
                                 , p_absence_id     IN         NUMBER
                                 , x_return_status  OUT NOCOPY NUMBER
                                 , x_return_message OUT NOCOPY VARCHAR2
                                 ) IS

    l_proc           VARCHAR2(50);

Line: 463

    l_proc := 'per_abs_shadow_booking_pkg.delete_shadow_booking';

Line: 498

    cac_bookings_pub.delete_booking
    ( p_api_version           => 1.0
    , p_init_msg_list         => 'T'
    , p_commit                => 'T'
    , p_booking_id            => l_booking_id
    , p_object_version_number => l_booking_ovn
    , x_return_status         => l_return_status
    , x_msg_count             => l_msg_count
    , x_msg_data              => l_msg_data
    );

Line: 533

  END delete_shadow_booking;

Line: 584

    OPEN c_bkgs FOR ' SELECT T.task_id'||
                           ',T.source_object_id'||
                           ',T.task_name'||
                           ',TA.booking_start_date'||
                           ',TA.booking_end_date'||
                           ',TA.free_busy_type'||
                    ' FROM jtf_tasks_vl T'||
                         ',jtf_task_assignments TA'||
                    ' WHERE T.entity = "BOOKING"'||
                    ' AND T.task_id = TA.task_id'||
                    ' AND T.source_object_type_code = "ABSENCE"'||
                    ' AND TA.resource_type_code = "PERSON_ASSIGNMENT"'||
                    ' AND TA.resource_id = :1'||
                    ' AND TA.booking_start_date <= NVL(:2, TA.booking_start_date)'||
                    ' AND TA.booking_end_date >= NVL(:3, TA.booking_end_date)'
                    USING p_assignment_id
                         ,p_start_date
                         ,p_end_date;