APPS.HR_RU_ADDRESS_HOOK SQL Statements

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

Line: 33

   PROCEDURE update_ru_address (
      p_address_id          IN   NUMBER,
      p_add_information13   IN   VARCHAR2,
      p_postal_code         IN   VARCHAR2
   )
   AS
      l_proc       CONSTANT VARCHAR2 (72) := g_package || 'UPDATE_RU_ADDRESS';

Line: 45

         SELECT style, add_information13, postal_code
           FROM per_addresses
          WHERE address_id = p_id;

Line: 90

   END update_ru_address;

Line: 92

   PROCEDURE update_ru_address_with_style (
      p_style               IN   VARCHAR2,
      p_address_id          IN   NUMBER,
      p_add_information13   IN   VARCHAR2,
      p_postal_code         IN   VARCHAR2
   )
   AS
      l_proc       CONSTANT VARCHAR2 (72) := g_package || 'UPDATE_RU_ADDRESS_WITH_STYLE';

Line: 105

         SELECT add_information13, postal_code
           FROM per_addresses
          WHERE address_id = p_id;

Line: 150

   END update_ru_address_with_style ;