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.OE_LINE_ATTRIBUTES SQL Statements

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

Line: 7


** For op_code = INSERT/UPDATE, we only do UPDATE the records since
** insertion is already done in oeoord()
** For op_code = DELETE, we don't do any deletion since the complementing record in
** so_line_attributes is deleted from oeoord()
*/

PROCEDURE set_so_line_attributes
  (in_line_id		IN NUMBER,
   in_op_code	        IN VARCHAR2,
   in_ord_source	IN VARCHAR2,
   in_orig_sys_ref	IN VARCHAR2,
   in_orig_sys_l_ref    IN VARCHAR2,
   in_req_id	        IN NUMBER,
   out_result	        OUT NUMBER   )
  IS


	l_date			DATE;

Line: 25


	l_updated_by		NUMBER;

Line: 73


   l_updated_by := FND_GLOBAL.USER_ID;

Line: 82


   IF ((in_op_code = 'INSERT') OR (in_op_code = 'UPDATE')) THEN

	SELECT
	  industry_context,
	  industry_attribute1,
	  industry_attribute2,
	  industry_attribute3,
	  industry_attribute4,
	  industry_attribute5,
	  industry_attribute6,
	  industry_attribute7,
	  industry_attribute8,
	  industry_attribute9,
	  industry_attribute10,
	  industry_attribute11,
	  industry_attribute12,
	  industry_attribute13,
	  industry_attribute14,
	  industry_attribute15,
	  global_attribute_category,
	  global_attribute1,
	  global_attribute2,
	  global_attribute3,
	  global_attribute4,
	  global_attribute5,
	  global_attribute6,
	  global_attribute7,
	  global_attribute8,
	  global_attribute9,
	  global_attribute10,
	  global_attribute11,
	  global_attribute12,
	  global_attribute13,
	  global_attribute14,
	  global_attribute15,
	  global_attribute16,
	  global_attribute17,
	  global_attribute18,
	  global_attribute19,
	  global_attribute20
        INTO
	  l_industry_context,
	  l_industry_attribute1,
	  l_industry_attribute2,
	  l_industry_attribute3,
	  l_industry_attribute4,
	  l_industry_attribute5,
	  l_industry_attribute6,
	  l_industry_attribute7,
	  l_industry_attribute8,
	  l_industry_attribute9,
	  l_industry_attribute10,
	  l_industry_attribute11,
	  l_industry_attribute12,
	  l_industry_attribute13,
	  l_industry_attribute14,
	  l_industry_attribute15,
	  l_global_attribute_category,
	  l_global_attribute1,
	  l_global_attribute2,
	  l_global_attribute3,
	  l_global_attribute4,
	  l_global_attribute5,
	  l_global_attribute6,
	  l_global_attribute7,
	  l_global_attribute8,
	  l_global_attribute9,
	  l_global_attribute10,
	  l_global_attribute11,
	  l_global_attribute12,
	  l_global_attribute13,
	  l_global_attribute14,
	  l_global_attribute15,
	  l_global_attribute16,
	  l_global_attribute17,
	  l_global_attribute18,
	  l_global_attribute19,
	  l_global_attribute20

	FROM   so_line_attributes_interface
	WHERE  order_source_id = in_ord_source
	AND    original_system_reference = in_orig_sys_ref
	AND    original_system_line_reference = in_orig_sys_l_ref
	AND    Nvl(error_flag,'N') <> 'Y';

Line: 168


      UPDATE so_line_attributes
	SET
	last_update_date = sysdate,
	last_updated_by = l_updated_by,
	last_update_login = l_login_id,
	program_application_id = l_program_application_id,
	program_id = l_program_id,
	program_update_date = l_date,
	request_id = l_request_id,
	industry_context = l_industry_context,
	industry_attribute1 = l_industry_attribute1,
	industry_attribute2 = l_industry_attribute2,
	industry_attribute3 = l_industry_attribute3,
	industry_attribute4 = l_industry_attribute4,
	industry_attribute5 = l_industry_attribute5,
	industry_attribute6 = l_industry_attribute6,
	industry_attribute7 = l_industry_attribute7,
	industry_attribute8 = l_industry_attribute8,
	industry_attribute9 = l_industry_attribute9,
	industry_attribute10 = l_industry_attribute10,
	industry_attribute11 = l_industry_attribute11,
	industry_attribute12 = l_industry_attribute12,
	industry_attribute13 = l_industry_attribute13,
	industry_attribute14 = l_industry_attribute14,
	industry_attribute15 = l_industry_attribute15,
	global_attribute_category = l_global_attribute_category,
	global_attribute1 = l_global_attribute1,
	global_attribute2 = l_global_attribute2,
	global_attribute3 = l_global_attribute3,
	global_attribute4 = l_global_attribute4,
	global_attribute5 = l_global_attribute5,
	global_attribute6 = l_global_attribute6,
	global_attribute7 = l_global_attribute7,
	global_attribute8 = l_global_attribute8,
	global_attribute9 = l_global_attribute9,
	global_attribute10 = l_global_attribute10,
	global_attribute11 = l_global_attribute11,
	global_attribute12 = l_global_attribute12,
	global_attribute13 = l_global_attribute13,
	global_attribute14 = l_global_attribute14,
	global_attribute15 = l_global_attribute15,
	global_attribute16 = l_global_attribute16,
	global_attribute17 = l_global_attribute17,
	global_attribute18 = l_global_attribute18,
	global_attribute19 = l_global_attribute19,
	global_attribute20  = l_global_attribute20
     WHERE  line_id = in_line_id;

Line: 216


     /* we don't do anything for DELETE */

   END IF;

Line: 232


** to insert(delete) a complementing null record into so_line_attributes
** whenever a line is inserted(deleted) into so_lines.
** Also called from Order User Exit to update records when in GUI mode,
** or to insert/delete records when in Character mode.
*/

PROCEDURE set_industry_attributes
  (in_op_code                   IN VARCHAR2,
   in_line_id                   IN NUMBER,
   in_industry_context          IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute1       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute2       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute3       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute4       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute5       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute6       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute7       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute8       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute9       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute10       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute11       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute12       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute13       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute14       IN VARCHAR2 DEFAULT NULL,
   in_industry_attribute15       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute_category  IN VARCHAR2 DEFAULT NULL,
   in_global_attribute1        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute2        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute3        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute4        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute5        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute6        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute7        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute8        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute9        IN VARCHAR2 DEFAULT NULL,
   in_global_attribute10       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute11       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute12       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute13       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute14       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute15       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute16       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute17       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute18       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute19       IN VARCHAR2 DEFAULT NULL,
   in_global_attribute20       IN VARCHAR2 DEFAULT NULL)

IS

   l_date			DATE;

Line: 301


   IF (in_op_code = 'INSERT') THEN

      INSERT INTO so_line_attributes
        (line_id,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login,
         program_application_id,
         program_id,
         program_update_date,
         request_id,
         industry_context,
         industry_attribute1,
         industry_attribute2,
         industry_attribute3,
         industry_attribute4,
         industry_attribute5,
         industry_attribute6,
         industry_attribute7,
         industry_attribute8,
         industry_attribute9,
         industry_attribute10,
         industry_attribute11,
         industry_attribute12,
         industry_attribute13,
         industry_attribute14,
         industry_attribute15,
         global_attribute_category,
         global_attribute1,
         global_attribute2,
         global_attribute3,
         global_attribute4,
         global_attribute5,
         global_attribute6,
         global_attribute7,
         global_attribute8,
         global_attribute9,
         global_attribute10,
         global_attribute11,
         global_attribute12,
         global_attribute13,
         global_attribute14,
         global_attribute15,
         global_attribute16,
         global_attribute17,
         global_attribute18,
         global_attribute19,
         global_attribute20)

      VALUES
        (in_line_id,
   	 l_date,
   	 l_user_id,
   	 l_date,
   	 l_user_id,
   	 l_login_id,
         l_prog_application_id,
         l_program_id,
         l_date,
         l_request_id,
         in_industry_context,
         in_industry_attribute1,
         in_industry_attribute2,
         in_industry_attribute3,
         in_industry_attribute4,
         in_industry_attribute5,
         in_industry_attribute6,
         in_industry_attribute7,
         in_industry_attribute8,
         in_industry_attribute9,
         in_industry_attribute10,
         in_industry_attribute11,
         in_industry_attribute12,
         in_industry_attribute13,
         in_industry_attribute14,
         in_industry_attribute15,
         in_global_attribute_category,
         in_global_attribute1,
         in_global_attribute2,
         in_global_attribute3,
         in_global_attribute4,
         in_global_attribute5,
         in_global_attribute6,
         in_global_attribute7,
         in_global_attribute8,
         in_global_attribute9,
         in_global_attribute10,
         in_global_attribute11,
         in_global_attribute12,
         in_global_attribute13,
         in_global_attribute14,
         in_global_attribute15,
         in_global_attribute16,
         in_global_attribute17,
         in_global_attribute18,
         in_global_attribute19,
         in_global_attribute20);

Line: 401


    ELSIF (in_op_code = 'UPDATE') THEN

    BEGIN

      UPDATE so_line_attributes
        SET
        last_update_date = l_date,
        last_updated_by = l_user_id,
        last_update_login = l_login_id,
        program_application_id = l_prog_application_id,
        program_id = l_program_id,
        program_update_date = l_date,
        request_id = l_request_id,
        industry_context = in_industry_context,
        industry_attribute1 = in_industry_attribute1,
        industry_attribute2 = in_industry_attribute2,
        industry_attribute3 = in_industry_attribute3,
        industry_attribute4 = in_industry_attribute4,
        industry_attribute5 = in_industry_attribute5,
        industry_attribute6 = in_industry_attribute6,
        industry_attribute7 = in_industry_attribute7,
        industry_attribute8 = in_industry_attribute9,
        industry_attribute9 = in_industry_attribute9,
        industry_attribute10 = in_industry_attribute10,
        industry_attribute11 = in_industry_attribute11,
        industry_attribute12 = in_industry_attribute12,
        industry_attribute13 = in_industry_attribute13,
        industry_attribute14 = in_industry_attribute14,
        industry_attribute15 = in_industry_attribute15,
        global_attribute_category = in_global_attribute_category,
        global_attribute1 = in_global_attribute1,
        global_attribute2 = in_global_attribute2,
        global_attribute3 = in_global_attribute3,
        global_attribute4 = in_global_attribute4,
        global_attribute5 = in_global_attribute5,
        global_attribute6 = in_global_attribute6,
        global_attribute7 = in_global_attribute7,
        global_attribute8 = in_global_attribute8,
        global_attribute9 = in_global_attribute9,
        global_attribute10 = in_global_attribute10,
        global_attribute11 = in_global_attribute11,
        global_attribute12 = in_global_attribute12,
        global_attribute13 = in_global_attribute13,
        global_attribute14 = in_global_attribute14,
        global_attribute15 = in_global_attribute15,
        global_attribute16 = in_global_attribute16,
        global_attribute17 = in_global_attribute17,
        global_attribute18 = in_global_attribute18,
        global_attribute19 = in_global_attribute19,
        global_attribute20 = in_global_attribute20
	WHERE line_id = in_line_id;

Line: 453


      /* existing order lines that were inserted PRE-ReleaseAccountingInstallation
	 would have no complementing records in so_line_attributes.
         In this case, we should insert a new record with the new information */

      IF SQL%NOTFOUND THEN -- update failed

      INSERT INTO so_line_attributes
        (line_id,
         creation_date,
         created_by,
         last_update_date,
         last_updated_by,
         last_update_login,
         program_application_id,
         program_id,
         program_update_date,
         request_id,
         industry_context,
         industry_attribute1,
         industry_attribute2,
         industry_attribute3,
         industry_attribute4,
         industry_attribute5,
         industry_attribute6,
         industry_attribute7,
         industry_attribute8,
         industry_attribute9,
         industry_attribute10,
         industry_attribute11,
         industry_attribute12,
         industry_attribute13,
         industry_attribute14,
         industry_attribute15,
         global_attribute_category,
         global_attribute1,
         global_attribute2,
         global_attribute3,
         global_attribute4,
         global_attribute5,
         global_attribute6,
         global_attribute7,
         global_attribute8,
         global_attribute9,
         global_attribute10,
         global_attribute11,
         global_attribute12,
         global_attribute13,
         global_attribute14,
         global_attribute15,
         global_attribute16,
         global_attribute17,
         global_attribute18,
         global_attribute19,
         global_attribute20)

      VALUES
        (in_line_id,
   	 l_date,
   	 l_user_id,
   	 l_date,
   	 l_user_id,
   	 l_login_id,
         l_prog_application_id,
         l_program_id,
         l_date,
         l_request_id,
         in_industry_context,
         in_industry_attribute1,
         in_industry_attribute2,
         in_industry_attribute3,
         in_industry_attribute4,
         in_industry_attribute5,
         in_industry_attribute6,
         in_industry_attribute7,
         in_industry_attribute8,
         in_industry_attribute9,
         in_industry_attribute10,
         in_industry_attribute11,
         in_industry_attribute12,
         in_industry_attribute13,
         in_industry_attribute14,
         in_industry_attribute15,
         in_global_attribute_category,
         in_global_attribute1,
         in_global_attribute2,
         in_global_attribute3,
         in_global_attribute4,
         in_global_attribute5,
         in_global_attribute6,
         in_global_attribute7,
         in_global_attribute8,
         in_global_attribute9,
         in_global_attribute10,
         in_global_attribute11,
         in_global_attribute12,
         in_global_attribute13,
         in_global_attribute14,
         in_global_attribute15,
         in_global_attribute16,
         in_global_attribute17,
         in_global_attribute18,
         in_global_attribute19,
         in_global_attribute20);

Line: 557


      END IF; /* no record exists for update */

Line: 561


    ELSIF (in_op_code = 'DELETE') THEN

        DELETE
        FROM  so_line_attributes
        WHERE line_id = in_line_id;

Line: 622


    IF (in_op_code = 'SELECT') THEN

      SELECT
         industry_context,
         industry_attribute1,
         industry_attribute2,
         industry_attribute3,
         industry_attribute4,
         industry_attribute5,
         industry_attribute6,
         industry_attribute7,
         industry_attribute8,
         industry_attribute9,
         industry_attribute10,
         industry_attribute11,
         industry_attribute12,
         industry_attribute13,
         industry_attribute14,
         industry_attribute15,
         global_attribute_category,
         global_attribute1,
         global_attribute2,
         global_attribute3,
         global_attribute4,
         global_attribute5,
         global_attribute6,
         global_attribute7,
         global_attribute8,
         global_attribute9,
         global_attribute10,
         global_attribute11,
         global_attribute12,
         global_attribute13,
         global_attribute14,
         global_attribute15,
         global_attribute16,
         global_attribute17,
         global_attribute18,
         global_attribute19,
         global_attribute20

      INTO
         out_industry_context,
         out_industry_attribute1,
         out_industry_attribute2,
         out_industry_attribute3,
         out_industry_attribute4,
         out_industry_attribute5,
         out_industry_attribute6,
         out_industry_attribute7,
         out_industry_attribute8,
         out_industry_attribute9,
         out_industry_attribute10,
         out_industry_attribute11,
         out_industry_attribute12,
         out_industry_attribute13,
         out_industry_attribute14,
         out_industry_attribute15,
         out_global_attribute_category,
         out_global_attribute1,
         out_global_attribute2,
         out_global_attribute3,
         out_global_attribute4,
         out_global_attribute5,
         out_global_attribute6,
         out_global_attribute7,
         out_global_attribute8,
         out_global_attribute9,
         out_global_attribute10,
         out_global_attribute11,
         out_global_attribute12,
         out_global_attribute13,
         out_global_attribute14,
         out_global_attribute15,
         out_global_attribute16,
         out_global_attribute17,
         out_global_attribute18,
         out_global_attribute19,
         out_global_attribute20
      FROM
         so_line_attributes
      WHERE
         line_id = in_line_id;