APPS.EAM_ASSET_ACTIVITIES_PVT SQL Statements

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

Line: 85

PROCEDURE INSERT_ROW(
  P_API_VERSION IN NUMBER,
  P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
  P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
  P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
  P_ROWID                         IN OUT NOCOPY VARCHAR2,
  P_ACTIVITY_ASSOCIATION_ID       IN OUT NOCOPY NUMBER,
  P_ORGANIZATION_ID               NUMBER,
  P_ASSET_ACTIVITY_ID             NUMBER,
  P_INVENTORY_ITEM_ID             NUMBER,
  P_SERIAL_NUMBER                 VARCHAR2,
  P_START_DATE_ACTIVE             DATE,
  P_END_DATE_ACTIVE               DATE,
  P_PRIORITY_CODE                 VARCHAR2,
  P_ACTIVITY_CAUSE_CODE           VARCHAR2,
  P_ACTIVITY_TYPE_CODE            VARCHAR2,
  P_ACTIVITY_SOURCE_CODE          VARCHAR2,
  P_WORK_ORDER_TYPE               NUMBER,
  P_PLANNER                       NUMBER,
  P_FIRM                          IN  NUMBER,
  P_PLANNED                       IN  VARCHAR2,
  P_NOTIFICATION_REQUIRED         IN  VARCHAR2,
  P_CLASS_CODE                    VARCHAR2,
  P_OWNING_DEPARTMENT_ID          NUMBER,
  P_TAGGING_REQUIRED_FLAG         VARCHAR2,
  P_SHUTDOWN_TYPE_CODE            VARCHAR2,
  P_LAST_UPDATE_DATE              DATE,
  P_LAST_UPDATED_BY               NUMBER,
  P_CREATION_DATE                 DATE,
  P_CREATED_BY                    NUMBER,
  P_LAST_UPDATE_LOGIN             NUMBER,
  P_ATTRIBUTE_CATEGORY            VARCHAR2,
  P_ATTRIBUTE1                    VARCHAR2,
  P_ATTRIBUTE2                    VARCHAR2,
  P_ATTRIBUTE3                    VARCHAR2,
  P_ATTRIBUTE4                    VARCHAR2,
  P_ATTRIBUTE5                    VARCHAR2,
  P_ATTRIBUTE6                    VARCHAR2,
  P_ATTRIBUTE7                    VARCHAR2,
  P_ATTRIBUTE8                    VARCHAR2,
  P_ATTRIBUTE9                    VARCHAR2,
  P_ATTRIBUTE10                   VARCHAR2,
  P_ATTRIBUTE11                   VARCHAR2,
  P_ATTRIBUTE12                   VARCHAR2,
  P_ATTRIBUTE13                   VARCHAR2,
  P_ATTRIBUTE14                   VARCHAR2,
  P_ATTRIBUTE15                   VARCHAR2,
  P_REQUEST_ID                    NUMBER,
  P_PROGRAM_APPLICATION_ID        NUMBER,
  P_PROGRAM_ID                    NUMBER,
  P_PROGRAM_UPDATE_DATE           DATE,
  P_TMPL_FLAG			VARCHAR2,
  P_MAINTENANCE_OBJECT_ID	NUMBER,
  P_MAINTENANCE_OBJECT_TYPE	NUMBER,
  P_CREATION_ORGANIZATION_ID	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) := 'insert_row';

Line: 149

    CURSOR C IS SELECT rowid FROM MTL_EAM_ASSET_ACTIVITIES
                 WHERE ACTIVITY_ASSOCIATION_ID = P_ACTIVITY_ASSOCIATION_ID;

Line: 155

      SAVEPOINT insert_row;

Line: 172

       INSERT INTO MTL_EAM_ASSET_ACTIVITIES(
       ACTIVITY_ASSOCIATION_ID,
       ASSET_ACTIVITY_ID,
       INVENTORY_ITEM_ID,
       SERIAL_NUMBER,
       START_DATE_ACTIVE,
       END_DATE_ACTIVE,
       PRIORITY_CODE,
       LAST_UPDATE_DATE,
       LAST_UPDATED_BY,
       CREATION_DATE,
       CREATED_BY,
       LAST_UPDATE_LOGIN,
       ATTRIBUTE_CATEGORY,
       ATTRIBUTE1,
       ATTRIBUTE2,
       ATTRIBUTE3,
       ATTRIBUTE4,
       ATTRIBUTE5,
       ATTRIBUTE6,
       ATTRIBUTE7,
       ATTRIBUTE8,
       ATTRIBUTE9,
       ATTRIBUTE10,
       ATTRIBUTE11,
       ATTRIBUTE12,
       ATTRIBUTE13,
       ATTRIBUTE14,
       ATTRIBUTE15,
       REQUEST_ID,
       PROGRAM_APPLICATION_ID,
       PROGRAM_ID,
       PROGRAM_UPDATE_DATE,
	TMPL_FLAG,
	MAINTENANCE_OBJECT_ID,
	MAINTENANCE_OBJECT_TYPE
       ) VALUES (
       mtl_eam_asset_activities_s.nextval,
       P_ASSET_ACTIVITY_ID,
       P_INVENTORY_ITEM_ID,
       P_SERIAL_NUMBER,
       P_START_DATE_ACTIVE,
       P_END_DATE_ACTIVE,
       P_PRIORITY_CODE,
       P_LAST_UPDATE_DATE,
       P_LAST_UPDATED_BY,
       P_CREATION_DATE,
       P_CREATED_BY,
       P_LAST_UPDATE_LOGIN,
       P_ATTRIBUTE_CATEGORY,
       P_ATTRIBUTE1,
       P_ATTRIBUTE2,
       P_ATTRIBUTE3,
       P_ATTRIBUTE4,
       P_ATTRIBUTE5,
       P_ATTRIBUTE6,
       P_ATTRIBUTE7,
       P_ATTRIBUTE8,
       P_ATTRIBUTE9,
       P_ATTRIBUTE10,
       P_ATTRIBUTE11,
       P_ATTRIBUTE12,
       P_ATTRIBUTE13,
       P_ATTRIBUTE14,
       P_ATTRIBUTE15,
       P_REQUEST_ID,
       P_PROGRAM_APPLICATION_ID,
       P_PROGRAM_ID,
       P_PROGRAM_UPDATE_DATE,
       P_TMPL_FLAG,
       P_MAINTENANCE_OBJECT_ID,
       P_MAINTENANCE_OBJECT_TYPE
       ) returning activity_association_id, rowid into P_ACTIVITY_ASSOCIATION_ID, P_ROWID;

Line: 252

       eam_org_maint_defaults_pvt.insert_row
	(
	      p_api_version           => 1.0
	     ,p_object_type           => l_object_type
	     ,p_object_id             => p_activity_association_id
	     ,p_organization_id       => p_organization_Id
	     ,p_owning_department_id  => p_owning_department_id
	     ,p_accounting_class_code => p_class_code
	     ,p_activity_cause_code   => p_activity_cause_code
	     ,p_activity_type_code    => p_activity_type_code
	     ,p_activity_source_code  => p_activity_source_code
         ,p_work_order_type       => p_work_order_type
         ,p_planner               => p_planner
         ,p_firm                  => p_firm
         ,p_planned               => p_planned
	     ,p_notification_required => p_notification_required
	     ,p_shutdown_type_code    => p_shutdown_type_code
	     ,p_tagging_required_flag => p_tagging_required_flag
	     ,x_return_status         => x_return_status
	     ,x_msg_count             => x_msg_count
	     ,x_msg_data              => x_msg_data
	);

Line: 298

         ROLLBACK TO insert_row;

Line: 302

         ROLLBACK TO insert_row;

Line: 308

         ROLLBACK TO insert_row;

Line: 317

  END Insert_Row;

Line: 359

  P_PROGRAM_UPDATE_DATE               DATE,
  P_MAINTENANCE_OBJECT_ID	NUMBER,
  P_MAINTENANCE_OBJECT_TYPE	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) := 'lock_row';

Line: 371

        SELECT *
        FROM   MTL_EAM_ASSET_ACTIVITIES
        WHERE  rowid = P_Rowid
        FOR UPDATE of ASSET_ACTIVITY_ID NOWAIT;

Line: 401

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

Line: 474

       AND (   (Recinfo.PROGRAM_UPDATE_DATE = P_PROGRAM_UPDATE_DATE)
            OR (    (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
                AND (P_PROGRAM_UPDATE_DATE IS NULL)))
       AND (   (Recinfo.MAINTENANCE_OBJECT_ID = P_MAINTENANCE_OBJECT_ID)
            OR (    (Recinfo.MAINTENANCE_OBJECT_ID IS NULL)
                AND (P_MAINTENANCE_OBJECT_ID IS NULL)))
       AND (   (Recinfo.MAINTENANCE_OBJECT_TYPE = P_MAINTENANCE_OBJECT_TYPE)
            OR (    (Recinfo.MAINTENANCE_OBJECT_TYPE IS NULL)
                AND (P_MAINTENANCE_OBJECT_TYPE IS NULL)))
      ) then
      return;

Line: 521

PROCEDURE UPDATE_ROW(
  P_API_VERSION IN NUMBER,
  P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE,
  P_COMMIT IN VARCHAR2 := FND_API.G_FALSE,
  P_VALIDATION_LEVEL IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
  P_ROWID                         VARCHAR2,
  P_ACTIVITY_ASSOCIATION_ID       NUMBER,
  P_ORGANIZATION_ID               NUMBER,
  P_ASSET_ACTIVITY_ID             NUMBER,
  P_INVENTORY_ITEM_ID             NUMBER,
  P_SERIAL_NUMBER                 VARCHAR2,
  P_START_DATE_ACTIVE             DATE,
  P_END_DATE_ACTIVE               DATE,
  P_PRIORITY_CODE                 VARCHAR2,
  P_ACTIVITY_CAUSE_CODE           VARCHAR2,
  P_ACTIVITY_TYPE_CODE            VARCHAR2,
  P_ACTIVITY_SOURCE_CODE          VARCHAR2,
  P_WORK_ORDER_TYPE               NUMBER,
  P_PLANNER                       NUMBER,
  P_FIRM                          IN  NUMBER,
  P_PLANNED                       IN  VARCHAR2,
  P_NOTIFICATION_REQUIRED         IN  VARCHAR2,
  P_CLASS_CODE                    VARCHAR2,
  P_OWNING_DEPARTMENT_ID          NUMBER,
  P_TAGGING_REQUIRED_FLAG         VARCHAR2,
  P_SHUTDOWN_TYPE_CODE            VARCHAR2,
  P_LAST_UPDATE_DATE              DATE,
  P_LAST_UPDATED_BY               NUMBER,
  P_LAST_UPDATE_LOGIN             NUMBER,
  P_ATTRIBUTE_CATEGORY            VARCHAR2,
  P_ATTRIBUTE1                    VARCHAR2,
  P_ATTRIBUTE2                    VARCHAR2,
  P_ATTRIBUTE3                    VARCHAR2,
  P_ATTRIBUTE4                    VARCHAR2,
  P_ATTRIBUTE5                    VARCHAR2,
  P_ATTRIBUTE6                    VARCHAR2,
  P_ATTRIBUTE7                    VARCHAR2,
  P_ATTRIBUTE8                    VARCHAR2,
  P_ATTRIBUTE9                    VARCHAR2,
  P_ATTRIBUTE10                   VARCHAR2,
  P_ATTRIBUTE11                   VARCHAR2,
  P_ATTRIBUTE12                   VARCHAR2,
  P_ATTRIBUTE13                   VARCHAR2,
  P_ATTRIBUTE14                   VARCHAR2,
  P_ATTRIBUTE15                   VARCHAR2,
  P_REQUEST_ID                    NUMBER,
  P_PROGRAM_APPLICATION_ID        NUMBER,
  P_PROGRAM_ID                    NUMBER,
  P_PROGRAM_UPDATE_DATE           DATE,
  P_MAINTENANCE_OBJECT_ID	NUMBER,
  P_MAINTENANCE_OBJECT_TYPE	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_row';

Line: 582

    select eps.pm_schedule_id
    from mtl_eam_asset_activities meaa, eam_pm_activities epa, eam_pm_schedulings eps
    where epa.activity_association_id=meaa.activity_association_id and
    epa.pm_schedule_id=eps.pm_schedule_id AND meaa.activity_association_id = P_ACTIVITY_ASSOCIATION_ID;  --bug 10381070

Line: 588

      SAVEPOINT update_row;

Line: 605

    UPDATE MTL_EAM_ASSET_ACTIVITIES
    SET
--     INVENTORY_ITEM_ID               =     P_INVENTORY_ITEM_ID,
--     SERIAL_NUMBER                   =     P_SERIAL_NUMBER,
     START_DATE_ACTIVE               =     P_START_DATE_ACTIVE,
     END_DATE_ACTIVE                 =     P_END_DATE_ACTIVE,
     PRIORITY_CODE                   =     P_PRIORITY_CODE,
     LAST_UPDATE_DATE                =     P_LAST_UPDATE_DATE,
     LAST_UPDATED_BY                 =     P_LAST_UPDATED_BY,
     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,
     REQUEST_ID                      =     P_REQUEST_ID,
     PROGRAM_APPLICATION_ID          =     P_PROGRAM_APPLICATION_ID,
     PROGRAM_ID                      =     P_PROGRAM_ID,
     PROGRAM_UPDATE_DATE             =     P_PROGRAM_UPDATE_DATE,
	MAINTENANCE_OBJECT_ID	=	P_MAINTENANCE_OBJECT_ID,
 	MAINTENANCE_OBJECT_TYPE	=	P_MAINTENANCE_OBJECT_TYPE
    WHERE ROWID = P_ROWID;

Line: 649

    eam_org_maint_defaults_pvt.update_insert_row
    (
      p_api_version           => 1.0
     ,p_object_type           => l_object_type
     ,p_object_id             => p_activity_association_id
     ,p_organization_id       => p_organization_Id
     ,p_owning_department_id  => to_fnd_std_num(p_owning_department_id)
     ,p_accounting_class_code => to_fnd_std_char(p_class_code)
     ,p_activity_cause_code   => to_fnd_std_char(p_activity_cause_code)
     ,p_activity_type_code    => to_fnd_std_char(p_activity_type_code)
     ,p_activity_source_code  => to_fnd_std_char(p_activity_source_code)
     ,p_work_order_type       => to_fnd_std_num(p_work_order_type)
     ,p_planner               => to_fnd_std_num(p_planner)
     ,p_firm                  => to_fnd_std_num(p_firm)
     ,p_planned               => to_fnd_std_char(p_planned)
     ,p_notification_required => to_fnd_std_char(p_notification_required)
     ,p_shutdown_type_code    => to_fnd_std_char(p_shutdown_type_code)
     ,p_tagging_required_flag => to_fnd_std_char(p_tagging_required_flag)
     ,x_return_status         => x_return_status
     ,x_msg_count             => x_msg_count
     ,x_msg_data              => x_msg_data
    );

Line: 676

   /*bug 10381070: when activity association is enddated, if PM exists then update PM last cyclic activity*/
   BEGIN
    for schedule in pmSchedules loop
     eam_pmdef_pub.update_pm_last_cyclic_act
       (  p_api_version => 1.0 ,
         p_init_msg_list     => 'F' ,
         p_commit            => 'T' ,
         p_validation_level  => 100 ,
         x_return_status => x_return_status,
         x_msg_count => x_msg_count,
         x_msg_data => x_msg_data ,
         p_pm_schedule_id => schedule.pm_schedule_id
        );

Line: 707

         ROLLBACK TO update_row;

Line: 711

         ROLLBACK TO update_row;

Line: 717

         ROLLBACK TO update_row;

Line: 726

  END Update_Row;