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

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

Line: 127


    EAM_CONSTRUCTION_UNIT_PKG.Insert_CU_Row(
           px_cu_id		         => l_cu_id
          ,p_cu_name		       => l_cu_rec.CU_NAME
          ,p_description	     => l_cu_rec.DESCRIPTION
          ,p_organization_id	 => l_cu_rec.ORGANIZATION_ID
          ,p_cu_effective_from => l_cu_rec.CU_EFFECTIVE_FROM
          ,p_cu_effective_to   => l_cu_rec.CU_EFFECTIVE_TO
          ,p_attribute_category => l_cu_rec.attribute_category
		      ,p_attribute1        => l_cu_rec.attribute1
		      ,p_attribute2        => l_cu_rec.attribute2
		      ,p_attribute3        => l_cu_rec.attribute3
		      ,p_attribute4        => l_cu_rec.attribute4
		      ,p_attribute5        => l_cu_rec.attribute5
		      ,p_attribute6        => l_cu_rec.attribute6
		      ,p_attribute7        => l_cu_rec.attribute7
		      ,p_attribute8        => l_cu_rec.attribute8
		      ,p_attribute9        => l_cu_rec.attribute9
		      ,p_attribute10       => l_cu_rec.attribute10
		      ,p_attribute11       => l_cu_rec.attribute11
		      ,p_attribute12       => l_cu_rec.attribute12
		      ,p_attribute13       => l_cu_rec.attribute13
		      ,p_attribute14       => l_cu_rec.attribute14
		      ,p_attribute15     	 => l_cu_rec.attribute15
  		    ,p_creation_date     => SYSDATE
          ,p_created_by        => FND_GLOBAL.USER_ID
          ,p_last_update_date  => SYSDATE
          ,p_last_updated_by   => FND_GLOBAL.USER_ID
          ,p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
          );

Line: 163


      EAM_CONSTRUCTION_UNIT_PKG.Insert_CU_Activity_Row(
           px_cu_detail_id		          => l_cu_activity_id
          ,p_cu_id			                => l_cu_id
          ,p_acct_class_code		        => l_cu_activity_rec.ACCT_CLASS_CODE
          ,p_activity_id		            => l_cu_activity_rec.ACTIVITY_ID
          ,p_cu_activity_qty		        => l_cu_activity_rec.CU_ACTIVITY_QTY
          ,p_cu_activity_effective_from => l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM
          ,p_cu_activity_effective_to   => l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_TO
          ,p_creation_date              => SYSDATE
          ,p_created_by                 => FND_GLOBAL.USER_ID
          ,p_last_update_date           => SYSDATE
          ,p_last_updated_by            => FND_GLOBAL.USER_ID
          ,p_last_update_login          => FND_GLOBAL.CONC_LOGIN_ID
          );

Line: 198


PROCEDURE update_construction_unit(
      p_api_version             IN    NUMBER
     ,p_commit                  IN    VARCHAR2
     ,p_cu_rec			            IN    EAM_CONSTRUCTION_UNIT_PUB.CU_rec
     ,p_cu_activity_tbl         IN    EAM_CONSTRUCTION_UNIT_PUB.CU_Activity_tbl
     ,x_cu_id                   OUT   NOCOPY  NUMBER
     ,x_return_status           OUT   NOCOPY VARCHAR2
     ,x_msg_count               OUT   NOCOPY NUMBER
     ,x_msg_data                OUT   NOCOPY VARCHAR2

      )  IS
  l_api_name          CONSTANT VARCHAR2(30) := 'UPDATE_CONSTRUCTION_UNIT';

Line: 224


    SAVEPOINT  update_construction_unit;

Line: 238


      debug('UPDATE_CONSTRUCTION_UNIT');

Line: 243


        debug('UPDATE_CONSTRUCTION_UNIT' ||
               To_Char(p_api_version)     ||'-'||
               p_commit);

Line: 276


          ,p_action            => 'UPDATE'
          ,x_return_status     => x_return_status
          ,x_msg_count         => x_msg_count
          ,x_msg_data          => x_msg_data
          );

Line: 295


    EAM_CONSTRUCTION_UNIT_PKG.Update_CU_Row(
           p_cu_id		         => l_cu_id
          ,p_cu_name		       => l_cu_rec.CU_NAME
          ,p_description	     => l_cu_rec.DESCRIPTION
          ,p_organization_id	 => l_cu_rec.ORGANIZATION_ID
          ,p_cu_effective_from => l_cu_rec.CU_EFFECTIVE_FROM
          ,p_cu_effective_to   => l_cu_rec.CU_EFFECTIVE_TO
          ,p_attribute_category         => l_cu_rec.attribute_category
		      ,p_attribute1                 => l_cu_rec.attribute1
		      ,p_attribute2                 => l_cu_rec.attribute2
		      ,p_attribute3                 => l_cu_rec.attribute3
		      ,p_attribute4                 => l_cu_rec.attribute4
		      ,p_attribute5                 => l_cu_rec.attribute5
		      ,p_attribute6                 => l_cu_rec.attribute6
		      ,p_attribute7                 => l_cu_rec.attribute7
		      ,p_attribute8                 => l_cu_rec.attribute8
		      ,p_attribute9                 => l_cu_rec.attribute9
		      ,p_attribute10                => l_cu_rec.attribute10
		      ,p_attribute11                => l_cu_rec.attribute11
		      ,p_attribute12                => l_cu_rec.attribute12
		      ,p_attribute13                => l_cu_rec.attribute13
		      ,p_attribute14                => l_cu_rec.attribute14
		      ,p_attribute15     			=> l_cu_rec.attribute15
		      ,p_last_update_date  => SYSDATE
          ,p_last_updated_by   => FND_GLOBAL.USER_ID
          ,p_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
          );

Line: 332


          EAM_CONSTRUCTION_UNIT_PKG.Insert_CU_Activity_Row(
              px_cu_detail_id		          => l_cu_activity_id
              ,p_cu_id			                => l_cu_id
              ,p_acct_class_code		        => l_cu_activity_rec.ACCT_CLASS_CODE
              ,p_activity_id		            => l_cu_activity_rec.ACTIVITY_ID
              ,p_cu_activity_qty		        => l_cu_activity_rec.CU_ACTIVITY_QTY
              ,p_cu_activity_effective_from => l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM
              ,p_cu_activity_effective_to   => l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_TO
              ,p_creation_date              => SYSDATE
              ,p_created_by                 => FND_GLOBAL.USER_ID
              ,p_last_update_date           => SYSDATE
              ,p_last_updated_by            => FND_GLOBAL.USER_ID
              ,p_last_update_login          => FND_GLOBAL.CONC_LOGIN_ID
              );

Line: 349


          EAM_CONSTRUCTION_UNIT_PKG.Update_CU_Activity_Row(
               p_cu_detail_id		            => l_cu_activity_id
              ,p_cu_id			                => l_cu_id
              ,p_acct_class_code		        => l_cu_activity_rec.ACCT_CLASS_CODE
              ,p_activity_id		            => l_cu_activity_rec.ACTIVITY_ID
              ,p_cu_activity_qty		        => l_cu_activity_rec.CU_ACTIVITY_QTY
              ,p_cu_activity_effective_from => l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_FROM
              ,p_cu_activity_effective_to   => l_cu_activity_rec.CU_ACTIVITY_EFFECTIVE_TO
              ,p_last_update_date           => SYSDATE
              ,p_last_updated_by            => FND_GLOBAL.USER_ID
              ,p_last_update_login          => FND_GLOBAL.CONC_LOGIN_ID
              );

Line: 369


    ROLLBACK TO update_construction_unit;

Line: 372


    ROLLBACK TO update_construction_unit;

Line: 379


END update_construction_unit;

Line: 456


            SELECT  'X'
            INTO    l_temp
            FROM    mtl_system_items_b
            WHERE   inventory_item_id = p_cu_activity_tbl(l_assign_count).ACTIVITY_ID
            AND     organization_id = p_cu_rec.ORGANIZATION_ID;

Line: 507


            X_last_update_login     =>  '',
            X_program_application_id=>  '',
            X_program_id            =>  '',
            X_request_id            =>  ''
            );

Line: 578


        SELECT  'X'
        INTO    l_temp
        FROM    eam_construction_units
        WHERE   cu_name = l_cu_rec.CU_NAME
		    AND     cu_id <> Nvl(l_cu_rec.CU_ID, FND_API.G_MISS_NUM);

Line: 638


        SELECT  concatenated_segments
        INTO    l_activity_name
        FROM    mtl_system_items_kfv
        WHERE   inventory_item_id = l_cu_activity_rec.ACTIVITY_ID
        AND     ROWNUM < 2 ;

Line: 645


        SELECT  organization_code
        INTO    l_org_code
        FROM    mtl_parameters
        WHERE   organization_id =  l_cu_rec.ORGANIZATION_ID
        AND     ROWNUM < 2 ;

Line: 662


        SELECT  'X'
        INTO    l_temp
        FROM    mtl_system_items_b
        WHERE   inventory_item_id = l_cu_activity_rec.ACTIVITY_ID
        AND     organization_id = l_cu_rec.ORGANIZATION_ID;

Line: 679


          SELECT  'X'
          INTO    l_temp
          FROM    WIP_ACCOUNTING_CLASSES
          WHERE   organization_id = l_cu_rec.ORGANIZATION_ID
          AND     class_code = l_cu_activity_rec.ACCT_CLASS_CODE
          AND     ((disable_date IS NULL )OR (disable_date > SYSDATE))
          AND     class_type = 6;