eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.DEFCONDN_PKG SQL Statements

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

Line: 12


   		SELECT 1
		FROM dual
		WHERE EXISTS (SELECT 1
			FROM OE_DEF_ATTR_CONDNS
			WHERE CONDITION_ID = p_condition_id);

Line: 18


   		SELECT 1
		FROM dual
		WHERE EXISTS (SELECT 1
			FROM OE_DEF_CONDN_ELEMS
			WHERE CONDITION_ID = p_condition_id);

Line: 62


	SELECT display_name from OE_DEF_CONDITIONS_VL
	WHERE display_name = p_display_name
	and database_object_name = p_database_object_name
	and ((p_rowid is null) OR (row_id <> p_rowid));

Line: 85


   PROCEDURE Insert_Row(
--------------------------------------------------------------------------
      p_rowid    				in out NOCOPY /* file.sql.39 change */  varchar2
      ,p_condition_id 			in out NOCOPY /* file.sql.39 change */  number
      ,p_display_name			in      varchar2
      ,p_description			in      varchar2
      ,p_database_object_name		in      varchar2
      ,p_number_of_elements		in     number
      ,p_system_flag	        	in      varchar2
      ,p_created_by       	 	in      number
      ,p_creation_date       		in      date
      ,p_last_updated_by 	    	in      number
      ,p_last_update_date        	in      date
      ,p_last_update_login       	in      number
      ,p_attribute_category       	in      varchar2
      ,p_attribute1	       	in      varchar2
      ,p_attribute2	       	in      varchar2
      ,p_attribute3	       	in      varchar2
      ,p_attribute4	       	in      varchar2
      ,p_attribute5	       	in      varchar2
      ,p_attribute6	       	in      varchar2
      ,p_attribute7	       	in      varchar2
      ,p_attribute8	       	in      varchar2
      ,p_attribute9	       	in      varchar2
      ,p_attribute10	       	in      varchar2
      ,p_attribute11	       	in      varchar2
      ,p_attribute12	       	in      varchar2
      ,p_attribute13	       	in      varchar2
      ,p_attribute14	       	in      varchar2
      ,p_attribute15	       	in      varchar2
   ) IS

CURSOR C IS SELECT rowid from OE_DEF_CONDITIONS
	    WHERE condition_id = p_condition_id;

Line: 122


      INSERT INTO OE_DEF_CONDITIONS(
		condition_id,
		database_object_name,
		number_of_elements,
		created_by,
		creation_date,
		last_updated_by,
		system_flag,
		last_update_date,last_update_login)
      VALUES (
		p_condition_id,
		p_database_object_name,
		p_number_of_elements,
		p_created_by,
		p_creation_date,
		p_last_updated_by,
		p_system_flag,
		p_last_update_date,p_last_update_login);

Line: 141


      INSERT INTO OE_DEF_CONDITIONS_TL(display_name,description,condition_id,
			     created_by,
	             	     creation_date,
		             last_updated_by,
		             last_update_date,
		             last_update_login,
			     language,source_lang)
      SELECT
	p_display_name,
	p_description,
	p_condition_id
         ,p_created_by
         ,p_creation_date
         ,p_last_updated_by
         ,p_last_update_date
         ,p_last_update_login
         ,l.language_code
         ,USERENV('LANG')
      FROM fnd_languages l
      WHERE l.installed_flag in ('I', 'B')
      AND   not exists (
                        SELECT  null
                        FROM oe_def_conditions_tl t
                        WHERE t.condition_id = p_condition_id
                        AND   t.language      = l.language_code);

Line: 182


END Insert_Row;

Line: 186


PROCEDURE Update_Row(
--------------------------------------------------------------------------
      p_rowid    				in      varchar2
      ,p_condition_id 			in   number
      ,p_display_name			in      varchar2
      ,p_description			in      varchar2
      ,p_database_object_name		in      varchar2
      ,p_number_of_elements		in     number
      ,p_system_flag	        	in      varchar2
      ,p_created_by       	 	in      number
      ,p_creation_date       		in      date
      ,p_last_updated_by 	    	in      number
      ,p_last_update_date        	in      date
      ,p_last_update_login       	in      number
      ,p_attribute_category       	in      varchar2
      ,p_attribute1	       	in      varchar2
      ,p_attribute2	       	in      varchar2
      ,p_attribute3	       	in      varchar2
      ,p_attribute4	       	in      varchar2
      ,p_attribute5	       	in      varchar2
      ,p_attribute6	       	in      varchar2
      ,p_attribute7	       	in      varchar2
      ,p_attribute8	       	in      varchar2
      ,p_attribute9	       	in      varchar2
      ,p_attribute10	       	in      varchar2
      ,p_attribute11	       	in      varchar2
      ,p_attribute12	       	in      varchar2
      ,p_attribute13	       	in      varchar2
      ,p_attribute14	       	in      varchar2
      ,p_attribute15	       	in      varchar2
) IS

BEGIN

      UPDATE oe_def_conditions
      SET
         condition_id 		 = p_condition_id
         ,system_flag          = p_system_flag
         ,created_by   		 = p_created_by
         ,creation_date		 = p_creation_date
         ,last_updated_by    	 = p_last_updated_by
         ,last_update_date     = p_last_update_date
         ,last_update_login     = p_last_update_login
         ,attribute_category   = p_attribute_category
         ,attribute1           = p_attribute1
         ,attribute2           = p_attribute2
         ,attribute3           = p_attribute3
         ,attribute4           = p_attribute4
         ,attribute5           = p_attribute5
         ,attribute6           = p_attribute6
         ,attribute7           = p_attribute7
         ,attribute8           = p_attribute8
         ,attribute9           = p_attribute9
         ,attribute10           = p_attribute10
         ,attribute11           = p_attribute11
         ,attribute12           = p_attribute12
         ,attribute13           = p_attribute13
         ,attribute14           = p_attribute14
         ,attribute15           = p_attribute15
      WHERE condition_id = p_condition_id
        AND database_object_name = p_database_object_name;

Line: 251


      UPDATE oe_def_conditions_tl
      SET
         source_lang		 = USERENV('LANG')
         ,last_updated_by    	 = p_last_updated_by
         ,last_update_date     = p_last_update_date
         ,last_update_login    = p_last_update_login
         ,display_name         = p_display_name
         ,description          = p_description
	WHERE condition_id = p_condition_id
      AND   USERENV('LANG') in (language, source_lang);

Line: 266


END Update_Row;

Line: 270


PROCEDURE Delete_Row(p_Rowid in	  VARCHAR2,
		     p_system_flag in VARCHAR2) IS
--------------------------------------------------------------------------
l_condition_id  NUMBER;

Line: 277


  SELECT condition_id INTO l_condition_id
  FROM OE_DEF_CONDITIONS
  WHERE rowid = p_rowid;

Line: 286


  DELETE FROM OE_DEF_CONDITIONS
  WHERE rowid = p_rowid;

Line: 289


  DELETE FROM OE_DEF_CONDITIONS_TL
  WHERE condition_id = l_condition_id;

Line: 292


  DELETE FROM OE_DEF_CONDN_ELEMS
  WHERE condition_id = l_condition_id;

Line: 295


 DELETE FROM OE_DEF_ATTR_DEF_RULES
 WHERE attr_def_condition_id = l_condition_id;

Line: 298


 DELETE FROM OE_DEF_ATTR_CONDNS
 WHERE condition_id = l_condition_id;

Line: 303


END Delete_Row;

Line: 317


      ,p_last_updated_by 	    	in      number
      ,p_last_update_date        	in      date
      ,p_last_update_login       	in      number
      ,p_attribute_category       	in      varchar2
      ,p_attribute1	       	in      varchar2
      ,p_attribute2	       	in      varchar2
      ,p_attribute3	       	in      varchar2
      ,p_attribute4	       	in      varchar2
      ,p_attribute5	       	in      varchar2
      ,p_attribute6	       	in      varchar2
      ,p_attribute7	       	in      varchar2
      ,p_attribute8	       	in      varchar2
      ,p_attribute9	       	in      varchar2
      ,p_attribute10	       	in      varchar2
      ,p_attribute11	       	in      varchar2
      ,p_attribute12	       	in      varchar2
      ,p_attribute13	       	in      varchar2
      ,p_attribute14	       	in      varchar2
      ,p_attribute15	       	in      varchar2
   ) IS

CURSOR C IS
SELECT * FROM OE_DEF_CONDITIONS
WHERE rowid = p_Rowid
FOR UPDATE OF condition_id NOWAIT;

Line: 346


 SELECT *
 FROM oe_def_conditions_tl t
 WHERE condition_id = p_condition_id
 AND   language = userenv('LANG')
FOR UPDATE OF condition_id NOWAIT;

Line: 359


FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');

Line: 429


         FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');

Line: 436


           AND (tlinfo.last_updated_by    = p_last_updated_by)
           AND (tlinfo.creation_date    = p_creation_date)
           AND (tlinfo.created_by    = p_created_by)
           AND (tlinfo.last_update_date   = p_last_update_date)
           AND (tlinfo.last_update_login   = p_last_update_login)
           AND (    (rtrim(tlinfo.description) = p_description)
                 OR (    (tlinfo.description IS NULL)
                      AND(p_description IS NULL)))
         ) then
	 return;

Line: 463


      UPDATE oe_def_conditions_tl
      SET
         source_lang		 = USERENV('LANG')
         ,last_updated_by    	 = decode(p_OWNER, 'SEED', 1, 0)
         ,last_update_date     = sysdate
         ,last_update_login    = 0
         ,display_name         = p_display_name
         ,description          = p_description
	WHERE condition_id = p_condition_id
      AND   USERENV('LANG') in (language, source_lang);

Line: 514


  defcondn_pkg.UPDATE_ROW(
      p_rowid    			     => row_id
      ,p_condition_id 		 => p_condition_id
      ,p_display_name		 => p_display_name
      ,p_description		 => p_description
      ,p_database_object_name  => p_database_object_name
      ,p_number_of_elements	 => p_number_of_elements
      ,p_system_flag	      => p_system_flag
      ,p_created_by            => user_id
      ,p_creation_date         => sysdate
      ,p_last_updated_by 	 => user_id
      ,p_last_update_date      => sysdate
      ,p_last_update_login     => 0
      ,p_attribute_category    => p_attribute_category
      ,p_attribute1	           => p_attribute1
      ,p_attribute2	           => p_attribute2
      ,p_attribute3	           => p_attribute3
      ,p_attribute4	           => p_attribute4
      ,p_attribute5	           => p_attribute5
      ,p_attribute6	           => p_attribute6
      ,p_attribute7	           => p_attribute7
      ,p_attribute8	           => p_attribute8
      ,p_attribute9	           => p_attribute9
      ,p_attribute10	           => p_attribute10
      ,p_attribute11	           => p_attribute11
      ,p_attribute12	           => p_attribute12
      ,p_attribute13	           => p_attribute13
      ,p_attribute14	           => p_attribute14
      ,p_attribute15	           => p_attribute15
	 );

Line: 550


	 defcondn_pkg.INSERT_ROW(
      p_rowid    			     => row_id
      ,p_condition_id 		 => l_condition_id
      ,p_display_name		 => p_display_name
      ,p_description		 => p_description
      ,p_database_object_name  => p_database_object_name
      ,p_number_of_elements	 => p_number_of_elements
      ,p_system_flag	      => p_system_flag
      ,p_created_by            => user_id
      ,p_creation_date         => sysdate
      ,p_last_updated_by 	 => user_id
      ,p_last_update_date      => sysdate
      ,p_last_update_login     => 0
      ,p_attribute_category    => p_attribute_category
      ,p_attribute1	           => p_attribute1
      ,p_attribute2	           => p_attribute2
      ,p_attribute3	           => p_attribute3
      ,p_attribute4	           => p_attribute4
      ,p_attribute5	           => p_attribute5
      ,p_attribute6	           => p_attribute6
      ,p_attribute7	           => p_attribute7
      ,p_attribute8	           => p_attribute8
      ,p_attribute9	           => p_attribute9
      ,p_attribute10	           => p_attribute10
      ,p_attribute11	           => p_attribute11
      ,p_attribute12	           => p_attribute12
      ,p_attribute13	           => p_attribute13
      ,p_attribute14	           => p_attribute14
      ,p_attribute15	           => p_attribute15
	 );

Line: 589


     DELETE FROM oe_def_conditions_tl t
     WHERE NOT EXISTS
              (SELECT null
               FROM oe_def_conditions b
               where b.condition_id = t.condition_id);

Line: 595


     UPDATE oe_def_conditions_tl t
     SET
     (
       display_name,
       description
     ) = (
          SELECT
            b.display_name,
            b.description
          FROM oe_def_conditions_tl b
          WHERE b.condition_id = t.condition_id
          AND   b.language      = t.source_lang
         )
     where
     (
       t.condition_id,
       t.language
     ) IN (
           SELECT
              subt.condition_id,
              subt.language
           FROM oe_def_conditions_tl subb, oe_def_conditions_tl subt
           WHERE subb.condition_id = subt.condition_id
           AND   subb.language      = subt.source_lang
           AND(subb.display_name <> subt.display_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: 626


     INSERT INTO oe_def_conditions_tl
     (
         condition_id
         ,language
         ,source_lang
         ,created_by
         ,creation_date
         ,last_updated_by
         ,last_update_date
         ,display_name
         ,description
         ,last_update_login
     )
     SELECT
         b.condition_id
         ,l.language_code
         ,b.source_lang       -- bug 2329327
         ,b.created_by
         ,b.creation_date
         ,b.last_updated_by
         ,b.last_update_date
         ,b.display_name
         ,b.description
         ,b.last_update_login
     FROM oe_def_conditions_tl b, fnd_languages l
     WHERE l.installed_flag IN ('I', 'B')
     AND   b.language = USERENV('LANG')
     AND   NOT EXISTS
              ( SELECT null
                FROM oe_def_conditions_tl t
                WHERE t.condition_id = b.condition_id
                AND   t.language      = l.language_code);