APPS.XLA_MAPPING_SETS_PKG SQL Statements

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

Line: 23

| delete_mapping_set_details                                            |
|                                                                       |
| Deletes all details of the mapping set                                |
|                                                                       |
+======================================================================*/

PROCEDURE delete_mapping_set_details
  (p_mapping_set_code                IN VARCHAR2
  ,p_amb_context_code                IN VARCHAR2)
IS

BEGIN

   xla_utility_pkg.trace('> xla_mapping_sets_pkg.delete_mapping_set_details'   , 10);

Line: 40

   DELETE
     FROM xla_mapping_set_values
    WHERE mapping_set_code         = p_mapping_set_code
      AND amb_context_code         = p_amb_context_code;

Line: 45

   xla_utility_pkg.trace('< xla_mapping_sets_pkg.delete_mapping_set_details'    , 10);

Line: 52

        (p_location   => 'xla_mapping_sets_pkg.delete_seg_rule_details');

Line: 54

END delete_mapping_set_details;

Line: 81

   SELECT application_id, amb_context_code, segment_rule_code, segment_rule_type_code
     FROM xla_seg_rule_details
    WHERE value_mapping_set_code = p_mapping_set_code
      AND amb_context_code       = p_amb_context_code
      AND value_mapping_set_code is not null;

Line: 96

   IF p_event in ('DELETE','UPDATE','DISABLE') THEN
      OPEN c_assignment_exist;

Line: 165

   SELECT 'x'
     FROM xla_seg_rule_details xsr
    WHERE xsr.value_mapping_set_code    = p_mapping_set_code
      AND xsr.amb_context_code          = p_amb_context_code
      AND xsr.value_mapping_set_code is not null
      AND exists      (SELECT 'x'
                         FROM xla_line_defn_adr_assgns xld
                            , xla_aad_line_defn_assgns xal
                            , xla_prod_acct_headers    xpa
                        WHERE xsr.application_id             = xld.application_id
                          AND xsr.amb_context_code           = xld.amb_context_code
                          AND xsr.segment_rule_type_code     = xld.segment_rule_type_code
                          AND xsr.segment_rule_code          = xld.segment_rule_code
                          AND xld.application_id             = xal.application_id
                          AND xld.amb_context_code           = xal.amb_context_code
                          AND xld.event_class_code           = xal.event_class_code
                          AND xld.event_type_code            = xal.event_type_code
                          AND xld.line_definition_owner_code = xal.line_definition_owner_code
                          AND xld.line_definition_code       = xal.line_definition_code
                          AND xal.application_id             = xpa.application_id
                          AND xal.amb_context_code           = xpa.amb_context_code
                          AND xal.product_rule_type_code     = xpa.product_rule_type_code
                          AND xal.product_rule_code          = xpa.product_rule_code
                          AND xal.event_class_code           = xpa.event_class_code
                          AND xal.event_type_code            = xpa.event_type_code
                          AND xpa.locking_status_flag        = 'Y');

Line: 194

   SELECT 'x'
     FROM xla_seg_rule_details d
    WHERE d.value_mapping_set_code    = p_mapping_set_code
      AND d.amb_context_code          = p_amb_context_code
      AND d.value_mapping_set_code is not null
      AND exists      (SELECT 'x'
                         FROM xla_tab_acct_defs_b a, xla_tab_acct_def_details s
                        WHERE a.application_id               = s.application_id
                          AND a.amb_context_code             = s.amb_context_code
                          AND a.account_definition_type_code = s.account_definition_type_code
                          AND a.account_definition_code      = s.account_definition_code
                          AND s.application_id               = d.application_id
                          AND s.amb_context_code             = d.amb_context_code
                          AND s.segment_rule_type_code       = d.segment_rule_type_code
                          AND s.segment_rule_code            = d.segment_rule_code
                          AND a.locking_status_flag          = 'Y');

Line: 346

   SELECT application_id, amb_context_code, segment_rule_type_code, segment_rule_code
     FROM xla_seg_rule_details d
    WHERE d.value_mapping_set_code    = p_mapping_set_code
      AND d.value_mapping_set_code is not null;

Line: 439

   SELECT application_id, amb_context_code,
          segment_rule_type_code, segment_rule_code
     FROM xla_seg_rule_details d
    WHERE d.value_mapping_set_code    = p_mapping_set_code
      AND d.value_mapping_set_code is not null;