APPS.WSH_FLEXFIELD_UTILS SQL Statements

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

Line: 10

                                       update_flag    	Varchar2(1));

Line: 64

     SELECT /* $Header: WSHFFUTB.pls 120.1.12000000.3 2007/03/30 09:36:11 nchellam ship $ */
          a.application_id, df.descriptive_flexfield_name
     FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
     WHERE a.application_short_name = appl_short_name
     AND a.application_id = df.application_id
     AND df.descriptive_flexfield_name = flexfield_name;

Line: 73

     SELECT /* $Header: WSHFFUTB.pls 120.1.12000000.3 2007/03/30 09:36:11 nchellam ship $ */
          df.title, df.application_table_name, a.application_short_name,
     df.description, df.concatenated_segment_delimiter,
     df.default_context_field_name, df.default_context_value,
     protected_flag,
     form_context_prompt, context_column_name, df.context_required_flag
     FROM fnd_application_vl a, fnd_descriptive_flexs_vl df
     WHERE df.application_id = ffld.application_id
     AND df.descriptive_flexfield_name = ffld.flexfield_name
     AND a.application_id = df.table_application_id;

Line: 318

        g_def_attributes(j).update_flag := 'Y';

Line: 321

             g_def_attributes(j).update_flag := 'Y';

Line: 385

           p_update_flag OUT NOCOPY  VARCHAR2,
           x_return_status OUT NOCOPY  VARCHAR2) IS


   j BINARY_INTEGER;

Line: 437

  p_update_flag := g_def_attributes(j).update_flag;

Line: 474

   update_flag VARCHAR2(1);

Line: 514

                      p_update_flag => update_flag,
                      x_return_status => x_return_status);

Line: 528

     IF update_flag = 'Y' THEN

       IF (UPPER(p_table_name) = 'WSH_NEW_DELIVERIES')  THEN
         UPDATE wsh_new_deliveries
         SET Attribute_Category = context,
            Attribute1 = attributes(1),
            Attribute2 = attributes(2),
            Attribute3 = attributes(3),
            Attribute4 = attributes(4),
            Attribute5 = attributes(5),
            Attribute6 = attributes(6),
            Attribute7 = attributes(7),
            Attribute8 = attributes(8),
            Attribute9 = attributes(9),
            Attribute10 = attributes(10),
            Attribute11 = attributes(11),
            Attribute12 = attributes(12),
            Attribute13 = attributes(13),
            Attribute14 = attributes(14),
            Attribute15 = attributes(15),
	    last_update_date             = SYSDATE,
	    last_updated_by              = FND_GLOBAL.USER_ID,
	    last_update_login            = FND_GLOBAL.LOGIN_ID
         WHERE delivery_id = p_primary_id;

Line: 554

	 UPDATE wsh_trips
         SET Attribute_Category = context,
            Attribute1 = attributes(1),
            Attribute2 = attributes(2),
            Attribute3 = attributes(3),
            Attribute4 = attributes(4),
            Attribute5 = attributes(5),
            Attribute6 = attributes(6),
            Attribute7 = attributes(7),
            Attribute8 = attributes(8),
            Attribute9 = attributes(9),
            Attribute10 = attributes(10),
            Attribute11 = attributes(11),
            Attribute12 = attributes(12),
            Attribute13 = attributes(13),
            Attribute14 = attributes(14),
            Attribute15 = attributes(15),
	    last_update_date             = SYSDATE,
	    last_updated_by              = FND_GLOBAL.USER_ID,
	    last_update_login            = FND_GLOBAL.LOGIN_ID
         WHERE trip_id = p_primary_id;

Line: 642

   select attribute_category, attribute1, attribute2, attribute3, attribute4, attribute5, attribute6, attribute7,
       attribute8, attribute9, attribute10, attribute11, attribute12, attribute13, attribute14, attribute15
   from   wsh_new_deliveries
   where delivery_id = c_delivery_id;

Line: 649

      SELECT attribute_category,
             attribute1,  attribute2,  attribute3,  attribute4,  attribute5,
             attribute6,  attribute7,  attribute8,  attribute9,  attribute10,
             attribute11, attribute12, attribute13, attribute14, attribute15
      FROM wsh_delivery_details
      WHERE delivery_detail_id = c_delivery_detail_id;