APPS.XLA_DESCRIPT_DETAILS_PKG SQL Statements

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

Line: 23

| delete_desc_prio_details                                              |
|                                                                       |
| Deletes all details attached to the priority                          |
|                                                                       |
+======================================================================*/

PROCEDURE delete_desc_prio_details
  (p_description_prio_id              IN NUMBER)

IS
   CURSOR c_desc_prio_details
   IS
   SELECT description_detail_id
     FROM xla_descript_details_b
    WHERE description_prio_id = p_description_prio_id;

Line: 43

   xla_utility_pkg.trace('> xla_descript_details_pkg.delete_desc_prio_details'   , 10);

Line: 53

        xla_descript_details_f_pkg.delete_row
          (x_description_detail_id   => l_description_detail_id);

Line: 59

   xla_utility_pkg.trace('< xla_descript_details_pkg.delete_desc_prio_details'    , 10);

Line: 72

        (p_location   => 'xla_descript_details_pkg.delete_desc_prio_details');

Line: 74

END delete_desc_prio_details;

Line: 96

   SELECT user_sequence, value_type_code,
          source_application_id, source_type_code, source_code, source_name,
          source_flex_appl_id, source_id_flex_code,
          flexfield_segment_code, literal
     FROM xla_descript_details_fvl
    WHERE description_prio_id = p_description_prio_id
    ORDER BY user_sequence;