APPS.HXC_LAYOUTS_UPLOAD_PKG SQL Statements

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

Line: 24

      SELECT application_id
        INTO l_appl_id
        FROM fnd_application
       WHERE application_short_name = P_APPLICATION_SHORT_NAME;

Line: 50

   SELECT layout_id
     INTO l_layout_id
     FROM hxc_layouts
    WHERE layout_name = p_layout_name;

Line: 77

   SELECT layout_comp_definition_id
     INTO l_layout_comp_definition_id
     FROM hxc_layout_comp_definitions
    WHERE component_type = p_component_type
      AND render_type = p_render_type;

Line: 108

      SELECT layout_component_id
        INTO l_layout_component_id
        FROM hxc_layout_components comp
            ,hxc_layouts lay
       WHERE component_name = p_component_name
         AND comp.layout_id = lay.layout_id
         AND lay.layout_name = p_layout_name;

Line: 140

   SELECT layout_comp_qualifier_id
     INTO l_layout_comp_qualifier_id
     FROM hxc_layout_comp_qualifiers
    WHERE qualifier_name = p_comp_qualifier_name
      AND layout_component_id = p_layout_component_id;

Line: 178

       SELECT 'yes'
              FROM dual
             WHERE EXISTS (SELECT 'x'
                             FROM hxc_layouts_tl
                            WHERE layout_id   = p_layout_id
                            and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME  --added
                              AND userenv('LANG') in ( language, source_lang )
                     );

Line: 208

      SELECT modifier_level
            ,layout_id
            ,object_version_number
        INTO l_modifier_level
            ,l_layout_id
            ,l_object_version_number
        FROM hxc_layouts
       WHERE layout_name = p_layout_name
         AND application_id = l_application_id;

Line: 221

      DELETE FROM hxc_layout_comp_prompts
       WHERE layout_component_id IN
               (SELECT comp.layout_component_id
                  FROM hxc_layout_components comp
                 WHERE comp.layout_id = l_layout_id);

Line: 228

      DELETE FROM hxc_layout_comp_qualifiers cq
       WHERE EXISTS
               (SELECT comp.layout_component_id
                  FROM hxc_layout_components comp
                 WHERE comp.layout_id = l_layout_id
                   AND cq.layout_component_id = comp.layout_component_id);

Line: 236

      DELETE FROM hxc_layout_components
       WHERE layout_id = l_layout_id;

Line: 333

      SELECT 'yes'
        INTO l_dummy
        FROM dual
       WHERE EXISTS (SELECT 'x'
                       FROM hxc_layouts_tl
                      WHERE layout_id   = l_layout_id
                      and DISPLAY_LAYOUT_NAME <> P_DISPLAY_LAYOUT_NAME  --added
                        AND userenv('LANG') in ( language, source_lang )
                     );

Line: 375

SELECT layout_comp_definition_id
       ,object_version_number
FROM hxc_layout_comp_definitions
WHERE component_type = p_component_type
  AND render_type = p_render_type;

Line: 384

SELECT 'N'
FROM  hxc_layout_components lc
WHERE lc.layout_comp_definition_id =  p_layout_comp_definition_id;

Line: 529

      SELECT layout_component_id
            ,comp.object_version_number
        INTO l_layout_component_id
            ,l_object_version_number
        FROM hxc_layout_components comp
            ,hxc_layouts lay
       WHERE component_name = P_COMPONENT_NAME
         AND comp.layout_id = lay.layout_id
         AND layout_name = p_layout_name;

Line: 659

      SELECT lcp.layout_comp_prompt_id
            ,lcp.object_version_number
      INTO  l_layout_comp_prompt_id
            ,l_object_version_number
      FROM  HXC_LAYOUT_COMP_PROMPTS lcp
      WHERE lcp.prompt_alias = p_prompt_alias
        AND lcp.prompt_type = p_prompt_type
        AND lcp.layout_component_id = l_layout_component_id;

Line: 775

      SELECT layout_comp_qualifier_id
            ,object_version_number
        INTO l_layout_comp_qualifier_id
            ,l_object_version_number
        FROM HXC_LAYOUT_COMP_QUALIFIERS
       WHERE qualifier_name = p_qualifier_name
         and layout_component_id = l_layout_component_id;

Line: 938

      SELECT layout_comp_qual_rule_id
            ,object_version_number
        INTO l_layout_comp_qual_rule_id
            ,l_object_version_number
        FROM HXC_LAYOUT_COMP_QUAL_RULES
       WHERE rule_name = p_rule_name;

Line: 1003

      p_last_update_date         IN   VARCHAR2
   )
   IS

--
      l_layout_id               hxc_layouts.layout_id%TYPE;

Line: 1012

      l_last_update_date_db     DATE;

Line: 1013

      l_last_updated_by_db      NUMBER(15);

Line: 1014

      l_last_updated_by_f       NUMBER(15);

Line: 1015

      l_last_update_date_f      DATE;

Line: 1019

         SELECT 'yes'
           FROM dual
          WHERE EXISTS( SELECT 'x'
                          FROM hxc_layouts_tl
                         WHERE layout_id = p_layout_id
                           AND display_layout_name <>
                                                 p_display_layout_name --added
                           AND userenv('LANG') IN (LANGUAGE, source_lang));

Line: 1030

      l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 1031

      l_last_update_date_f :=
                       nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1053

         SELECT modifier_level,
                layout_id,
                object_version_number,
                last_update_date,
                last_updated_by
           INTO l_modifier_level,
                l_layout_id,
                l_object_version_number,
                l_last_update_date_db,
                l_last_updated_by_db
           FROM hxc_layouts
          WHERE layout_name = p_layout_name
            AND application_id = l_application_id;

Line: 1071

         DELETE FROM hxc_layout_comp_prompts
               WHERE layout_component_id IN (SELECT comp.layout_component_id
                                               FROM hxc_layout_components comp
                                              WHERE comp.layout_id =
                                                                  l_layout_id);

Line: 1079

         DELETE FROM hxc_layout_comp_qualifiers cq
               WHERE EXISTS( SELECT comp.layout_component_id
                               FROM hxc_layout_components comp
                              WHERE comp.layout_id = l_layout_id
                                AND cq.layout_component_id =
                                                     comp.layout_component_id);

Line: 1088

         DELETE FROM hxc_layout_components
               WHERE layout_id = l_layout_id;

Line: 1107

                l_last_updated_by_f,
                l_last_update_date_f,
                l_last_updated_by_db,
                l_last_update_date_db,
                p_custom_mode
             )
            )
         THEN
            hxc_ula_upd.upd(
               p_layout_name=> p_layout_name,
               p_application_id=> l_application_id,
               p_layout_type=> p_layout_type,
               p_modifier_level=> p_modifier_level,
               p_modifier_value=> p_modifier_value,
               p_top_level_region_code=> p_top_level_region_code,
               p_layout_id=> l_layout_id,
               p_object_version_number=> l_object_version_number
            );

Line: 1187

      p_last_update_date         IN   VARCHAR2
   )
   IS

--
      l_layout_id             hxc_layouts.layout_id%TYPE;

Line: 1194

      l_last_update_date_db   DATE;

Line: 1195

      l_last_updated_by_db    NUMBER(15);

Line: 1196

      l_last_updated_by_f     NUMBER(15);

Line: 1197

      l_last_update_date_f    DATE;

Line: 1204

      l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 1205

      l_last_update_date_f :=
                       nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1212

         SELECT 'yes'
           INTO l_dummy
           FROM dual
          WHERE EXISTS( SELECT 'x'
                          FROM hxc_layouts_tl
                         WHERE layout_id = l_layout_id
                           AND display_layout_name <>
                                                 p_display_layout_name --added
                           AND userenv('LANG') IN (LANGUAGE, source_lang));

Line: 1223

	 SELECT last_update_date,
                last_updated_by
           INTO l_last_update_date_db,
                l_last_updated_by_db
           FROM hxc_layouts_tl
          WHERE layout_id = l_layout_id
            AND display_layout_name <> p_display_layout_name --added
            AND userenv('LANG') = LANGUAGE;

Line: 1233

                   l_last_updated_by_f,
                   l_last_update_date_f,
                   l_last_updated_by_db,
                   l_last_update_date_db,
                   p_custom_mode
                )
             OR (l_dummy = 'yes')
            )
         THEN
            hxc_ult_upd.upd_tl(
               p_language_code=> userenv('LANG'),
               p_layout_id=> l_layout_id,
               p_display_layout_name=> p_display_layout_name
            );

Line: 1272

      p_last_update_date   IN   VARCHAR2
   )
   IS

--
      l_last_update_date_db         DATE;

Line: 1278

      l_last_updated_by_db          NUMBER(15);

Line: 1279

      l_last_updated_by_f           NUMBER(15);

Line: 1280

      l_last_update_date_f          DATE;

Line: 1284

         SELECT layout_comp_definition_id,
                object_version_number,
                last_update_date,
                last_updated_by
           FROM hxc_layout_comp_definitions
          WHERE component_type = p_component_type
            AND render_type = p_render_type;

Line: 1296

         SELECT 'N'
           FROM hxc_layout_components lc
          WHERE lc.layout_comp_definition_id = p_layout_comp_definition_id;

Line: 1308

      l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 1309

      l_last_update_date_f :=
                       nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1314

                            l_last_update_date_db,
                            l_last_updated_by_db;

Line: 1335

             l_last_updated_by_f,
             l_last_update_date_f,
             l_last_updated_by_db,
             l_last_update_date_db,
             p_custom_mode
          )
         )
      THEN
         --
         -- Call the row handler to update the row
         --
         hxc_uld_upd.upd(
            p_component_class=> p_component_class,
            p_component_type=> p_component_type,
            p_layout_comp_definition_id=> l_layout_comp_definition_id,
            p_render_type=> p_render_type,
            p_object_version_number=> l_object_version_number
         );

Line: 1409

      p_last_update_date             IN   VARCHAR2
   )
   IS

--
      l_layout_id                   hxc_layouts.layout_id%TYPE;

Line: 1423

      l_last_update_date_db         DATE;

Line: 1424

      l_last_updated_by_db          NUMBER(15);

Line: 1425

      l_last_updated_by_f           NUMBER(15);

Line: 1426

      l_last_update_date_f          DATE;

Line: 1429

      l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 1430

      l_last_update_date_f :=
                       nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1471

         SELECT layout_component_id,
                comp.object_version_number,
                comp.last_update_date,
                comp.last_updated_by
           INTO l_layout_component_id,
                l_object_version_number,
                l_last_update_date_db,
                l_last_updated_by_db
           FROM hxc_layout_components comp,
                hxc_layouts lay
          WHERE component_name = p_component_name
            AND comp.layout_id = lay.layout_id
            AND layout_name = p_layout_name;

Line: 1487

                l_last_updated_by_f,
                l_last_update_date_f,
                l_last_updated_by_db,
                l_last_update_date_db,
                p_custom_mode
             )
            )
         THEN
            hxc_ulc_upd.upd(
               p_layout_id=> l_layout_id,
               p_parent_component_id=> l_parent_comp_id,
               p_sequence=> p_sequence,
               p_component_name=> p_component_name,
               p_component_value=> p_component_value,
               p_name_value_string=> p_name_value_string,
               p_region_code=> p_region_code,
               p_region_code_app_id=> l_application_id,
               p_attribute_code=> p_attribute_code,
               p_attribute_code_app_id=> l_attr_application_id,
               p_layout_component_id=> l_layout_component_id,
               p_object_version_number=> l_object_version_number,
               p_layout_comp_definition_id=> l_layout_comp_definition_id,
               p_component_alias=> p_component_alias,
               p_parent_bean=> p_parent_bean,
               p_attribute1=> p_attribute1,
               p_attribute2=> p_attribute2,
               p_attribute3=> p_attribute3,
               p_attribute4=> p_attribute4,
               p_attribute5=> p_attribute5
            );

Line: 1587

      p_last_update_date           IN   VARCHAR2
   )
   IS

--
      l_layout_component_id     hxc_layout_components.layout_component_id%TYPE;

Line: 1599

      l_last_update_date_db     DATE;

Line: 1600

      l_last_updated_by_db      NUMBER(15);

Line: 1601

      l_last_updated_by_f       NUMBER(15);

Line: 1602

      l_last_update_date_f      DATE;

Line: 1607

      l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 1608

      l_last_update_date_f :=
                       nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1629

         SELECT lcp.layout_comp_prompt_id,
                lcp.object_version_number,
                last_update_date,
                last_updated_by
           INTO l_layout_comp_prompt_id,
                l_object_version_number,
                l_last_update_date_db,
                l_last_updated_by_db
           FROM hxc_layout_comp_prompts lcp
          WHERE lcp.prompt_alias = p_prompt_alias
            AND lcp.prompt_type = p_prompt_type
            AND lcp.layout_component_id = l_layout_component_id;

Line: 1643

                l_last_updated_by_f,
                l_last_update_date_f,
                l_last_updated_by_db,
                l_last_update_date_db,
                p_custom_mode
             )
            )
         THEN
            --
            -- Use the Row handler to update the row
            --
            hxc_ulp_upd.upd(
               p_layout_component_id=> l_layout_component_id,
               p_prompt_alias=> p_prompt_alias,
               p_prompt_type=> p_prompt_type,
               p_region_code=> p_region_code,
               p_region_application_id=> l_region_app_id,
               p_attribute_code=> p_attribute_code,
               p_attribute_application_id=> l_attribute_app_id,
               p_layout_comp_prompt_id=> l_layout_comp_prompt_id,
               p_object_version_number=> l_object_version_number
            );

Line: 1743

      p_last_update_date               IN   VARCHAR2
   )
   IS

--
      l_layout_component_id        hxc_layout_components.layout_component_id%TYPE;

Line: 1753

      l_last_update_date_db        DATE;

Line: 1754

      l_last_updated_by_db         NUMBER(15);

Line: 1755

      l_last_updated_by_f          NUMBER(15);

Line: 1756

      l_last_update_date_f         DATE;

Line: 1759

      l_last_updated_by_f := fnd_load_util.owner_id(p_owner);

Line: 1760

      l_last_update_date_f :=
                       nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 1772

         SELECT layout_comp_qualifier_id,
                object_version_number,
                last_update_date,
                last_updated_by
           INTO l_layout_comp_qualifier_id,
                l_object_version_number,
                l_last_update_date_db,
                l_last_updated_by_db
           FROM hxc_layout_comp_qualifiers
          WHERE qualifier_name = p_qualifier_name
            AND layout_component_id = l_layout_component_id;

Line: 1785

                l_last_updated_by_f,
                l_last_update_date_f,
                l_last_updated_by_db,
                l_last_update_date_db,
                p_custom_mode
             )
            )
         THEN
            --
            -- Use the Row handler to update the row
            --
            hxc_ulq_upd.upd(
               p_layout_component_id=> l_layout_component_id,
               p_qualifier_name=> p_qualifier_name,
               p_qualifier_attribute_category=> p_qualifier_attribute_category,
               p_qualifier_attribute1=> p_qualifier_attribute1,
               p_qualifier_attribute2=> p_qualifier_attribute2,
               p_qualifier_attribute3=> p_qualifier_attribute3,
               p_qualifier_attribute4=> p_qualifier_attribute4,
               p_qualifier_attribute5=> p_qualifier_attribute5,
               p_qualifier_attribute6=> p_qualifier_attribute6,
               p_qualifier_attribute7=> p_qualifier_attribute7,
               p_qualifier_attribute8=> p_qualifier_attribute8,
               p_qualifier_attribute9=> p_qualifier_attribute9,
               p_qualifier_attribute10=> p_qualifier_attribute10,
               p_qualifier_attribute11=> p_qualifier_attribute11,
               p_qualifier_attribute12=> p_qualifier_attribute12,
               p_qualifier_attribute13=> p_qualifier_attribute13,
               p_qualifier_attribute14=> p_qualifier_attribute14,
               p_qualifier_attribute15=> p_qualifier_attribute15,
               p_qualifier_attribute16=> p_qualifier_attribute16,
               p_qualifier_attribute17=> p_qualifier_attribute17,
               p_qualifier_attribute18=> p_qualifier_attribute18,
               p_qualifier_attribute19=> p_qualifier_attribute19,
               p_qualifier_attribute20=> p_qualifier_attribute20,
               p_qualifier_attribute21=> p_qualifier_attribute21,
               p_qualifier_attribute22=> p_qualifier_attribute22,
               p_qualifier_attribute23=> p_qualifier_attribute23,
               p_qualifier_attribute24=> p_qualifier_attribute24,
               p_qualifier_attribute25=> p_qualifier_attribute25,
               p_qualifier_attribute26=> p_qualifier_attribute26,
               p_qualifier_attribute27=> p_qualifier_attribute27,
               p_qualifier_attribute28=> p_qualifier_attribute28,
               p_qualifier_attribute29=> p_qualifier_attribute29,
               p_qualifier_attribute30=> p_qualifier_attribute30,
               p_layout_comp_qualifier_id=> l_layout_comp_qualifier_id,
               p_object_version_number=> l_object_version_number
            );

Line: 1949

      SELECT layout_comp_qual_rule_id
            ,object_version_number
        INTO l_layout_comp_qual_rule_id
            ,l_object_version_number
        FROM HXC_LAYOUT_COMP_QUAL_RULES
       WHERE rule_name = p_rule_name;