APPS.OE_PARAMETERS_DEF_UTIL SQL Statements

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

Line: 13

PROCEDURE Insert_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 20

   INSERT INTO oe_sys_parameter_def_b (
       parameter_code,
       creation_date,
       created_by,
       last_update_date,
       last_updated_by,
       last_update_login,
       category_code,
       value_set_id,
       open_orders_check_flag,
       enabled_flag,
       Seeded_flag)
   VALUES (
       p_sys_param_def_rec.parameter_code,
       p_sys_param_def_rec.creation_date,
       p_sys_param_def_rec.created_by,
       p_sys_param_def_rec.last_update_date,
       p_sys_param_def_rec.last_updated_by,
       p_sys_param_def_rec.last_update_login,
       p_sys_param_def_rec.category_code,
       p_sys_param_def_rec.value_set_id,
       p_sys_param_def_rec.open_orders_check_flag,
       p_sys_param_def_rec.enabled_flag,
       p_sys_param_def_rec.seeded_flag);

Line: 45

   INSERT INTO oe_sys_parameter_def_tl (
       parameter_code,
       creation_date,
       created_by,
       last_update_date,
       last_updated_by,
       last_update_login,
       language,
       source_lang,
       name,
       description)
   SELECT
       p_sys_param_def_rec.parameter_code,
       p_sys_param_def_rec.creation_date,
       p_sys_param_def_rec.created_by,
       p_sys_param_def_rec.last_update_date,
       p_sys_param_def_rec.last_updated_by,
       p_sys_param_def_rec.last_update_login,
       L.language_code,
       userenv('LANG'),
       p_sys_param_def_rec.name,
       p_sys_param_def_rec.description
   FROM fnd_languages L
   WHERE L.installed_flag IN ('I', 'B')
   AND NOT EXISTS
    (SELECT NULL
     FROM oe_sys_parameter_def_tl T
    where T.parameter_code = p_sys_param_def_rec.parameter_code
    and T.language = L.language_code);

Line: 74

END Insert_Row;

Line: 85

PROCEDURE Delete_Row(p_parameter_code IN VARCHAR2)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 91

   DELETE FROM oe_sys_parameter_def_tl
   WHERE parameter_code = p_parameter_code;

Line: 97

   DELETE FROM oe_sys_parameter_def_b
   WHERE parameter_code = p_parameter_code;

Line: 102

END Delete_Row;

Line: 113

PROCEDURE Update_Row(p_sys_param_def_rec IN OE_PARAMETERS_DEF_UTIL.sys_param_def_rec_type)
IS
--
l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line: 119

   UPDATE oe_sys_parameter_def_b
   SET last_update_date = p_sys_param_def_rec.last_update_date,
       last_updated_by = p_sys_param_def_rec.last_updated_by,
       last_update_login = p_sys_param_def_rec.last_update_login,
       category_code = p_sys_param_def_rec.category_code,
       value_set_id = p_sys_param_def_rec.value_set_id,
       open_orders_check_flag = p_sys_param_def_rec.open_orders_check_flag,
       enabled_flag =p_sys_param_def_rec.enabled_flag,
       seeded_flag =p_sys_param_def_rec.seeded_flag
   WHERE parameter_code = p_sys_param_def_rec.parameter_code;

Line: 133

   UPDATE oe_sys_parameter_def_tl
   SET last_update_date = p_sys_param_def_rec.last_update_date,
       last_updated_by = p_sys_param_def_rec.last_updated_by,
       last_update_login = p_sys_param_def_rec.last_update_login,
       name = p_sys_param_def_rec.name,
       description = p_sys_param_def_rec.description,
       source_lang = userenv('LANG')
   WHERE parameter_code = p_sys_param_def_rec.parameter_code
   AND  userenv('LANG') in (language, source_lang);

Line: 145

END Update_Row;

Line: 159

   SELECT parameter_code,
          category_code,
	  value_set_id,
	  open_orders_check_flag,
	  enabled_flag
   FROM oe_sys_parameter_def_b
   WHERE parameter_code = p_parameter_code
   FOR UPDATE OF value_set_id NOWAIT;

Line: 169

   SELECT name,
          description,
	  decode(LANGUAGE, userenv('LANG'), 'Y', 'N') baselang
   FROM oe_sys_parameter_def_tl
   WHERE parameter_code = p_parameter_code
   AND userenv('LANG') IN (language, source_lang)
   FOR UPDATE OF name NOWAIT;

Line: 187

     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 196

     fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

Line: 276

                        p_updated_by  IN NUMBER,
                        p_update_login  IN NUMBER,
			p_custom_mode    in varchar2 default null)
IS
   l_last_upd_by   NUMBER;

Line: 283

   SELECT last_updated_by,last_update_date
   INTO l_last_upd_by, l_last_upd_dt
   FROM oe_sys_parameter_def_tl
   WHERE parameter_code = p_parameter_code
   AND LANGUAGE  = userenv('LANG');

Line: 289

   /*IF upload_test(p_file_upb  => p_updated_by
                 ,p_file_upd  => sysdate
                 ,p_db_upb    => l_last_upd_by
                 ,p_db_upd    => l_last_upd_dt) THEN*/
  IF fnd_load_util.upload_test(p_file_id =>p_updated_by,
                      p_file_lud  => sysdate,
                      p_db_id=> l_last_upd_by,
                      p_db_lud => l_last_upd_dt,
		      p_custom_mode=>p_custom_mode) then
      UPDATE oe_sys_parameter_def_tl
      SET name = p_name,
          description = p_description,
          last_update_date = sysdate,
          last_updated_by = p_updated_by,
          last_update_login = p_update_login,
          source_lang = userenv('LANG')
      WHERE parameter_code = p_parameter_code
      AND userenv('LANG') in (LANGUAGE, SOURCE_LANG);

Line: 316

                   p_updated_by      IN NUMBER,
                   p_update_login    IN NUMBER,
                   p_category_code   IN VARCHAR2,
                   p_value_set       IN VARCHAR2,
                   p_open_orders_check_flag  IN VARCHAR2,
                   p_enabled_flag    IN VARCHAR2,
                   p_seeded_flag     IN VARCHAR2,
  	           p_custom_mode     IN VARCHAR2 default null) --Seed data changes)
IS
   CURSOR get_value_set_id IS
   SELECT flex_value_set_id
   FROM fnd_flex_value_sets
   WHERE flex_value_set_name= p_value_set;

Line: 331

   SELECT lookup_code
   FROM oe_lookups
   WHERE lookup_type ='OM_PARAMETER_CATEGORY'
   AND lookup_code =p_category_code;

Line: 361

   l_sys_param_def_rec.Last_update_date := sysdate;

Line: 362

   l_sys_param_def_rec.last_updated_by  := p_updated_by;

Line: 363

   l_sys_param_def_rec.last_update_login := 0;

Line: 365

   l_sys_param_def_rec.Created_By := p_updated_by;

Line: 374

   SELECT last_updated_by,last_update_date
   INTO l_last_upd_by, l_last_upd_dt
   FROM oe_sys_parameter_def_vl
   WHERE parameter_code = p_parameter_code;

Line: 379

   /*IF upload_test(p_file_upb  => p_updated_by
                 ,p_file_upd  => sysdate
                 ,p_db_upb    => l_last_upd_by
                 ,p_db_upd    => l_last_upd_dt) THEN*/
   IF fnd_load_util.upload_test(p_file_id     =>l_sys_param_def_rec.last_updated_by
                 ,p_file_lud  => sysdate
                 ,p_db_id    => l_last_upd_by
                 ,p_db_lud    => l_last_upd_dt
		 ,p_custom_mode=>p_custom_mode) THEN
      Update_Row(p_sys_param_def_rec => l_sys_param_def_rec);

Line: 394

         Insert_Row(p_sys_param_def_rec => l_sys_param_def_rec);

Line: 406

     DELETE FROM oe_sys_parameter_def_tl t
     WHERE NOT EXISTS
              (SELECT null
               FROM oe_sys_parameter_def_b b
               where b.parameter_code = t.parameter_code);

Line: 412

     UPDATE oe_sys_parameter_def_tl t
     SET
     (
       name,
       description
     ) = (
          SELECT
            b.name,
            b.description
          FROM oe_sys_parameter_def_tl b
          WHERE b.parameter_code = t.parameter_code
          AND   b.language      = t.source_lang
         )
     where
     (
       t.parameter_code,
       t.language
     ) IN (
           SELECT
              subt.parameter_code,
              subt.language
           FROM oe_sys_parameter_def_tl subb,
                oe_sys_parameter_def_tl subt
           WHERE subb.parameter_code = subt.parameter_code
           AND   subb.language      = subt.source_lang
           AND(subb.name <> subt.name
               OR subb.DESCRIPTION <> subt.description
               OR (subb.description IS null
                          AND subt.description IS NOT null)
               OR (subb.description IS NOT null
                          AND subt.description IS null)
              )
          );

Line: 446

     INSERT INTO oe_sys_parameter_def_tl
     (
       parameter_code,
       creation_date,
       created_by,
       last_update_date,
       last_updated_by,
       last_update_login,
       language,
       source_lang,
       name,
       description
     )
     SELECT
       b.parameter_code,
       b.creation_date,
       b.created_by,
       b.last_update_date,
       b.last_updated_by,
       b.last_update_login,
       l.language_code,
       b.source_lang,
       b.name,
       b.description
     FROM oe_sys_parameter_def_tl b, fnd_languages l
     WHERE l.installed_flag IN ('I', 'B')
     AND   b.language = USERENV('LANG')
     AND   NOT EXISTS
              ( SELECT null
                FROM oe_sys_parameter_def_tl t
                WHERE t.parameter_code = b.parameter_code
                AND   t.language      = l.language_code);