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

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

Line: 16


PROCEDURE Insert_Row(
          px_WIP_TRANSACTION_DETAIL_ID IN OUT NOCOPY NUMBER
         ,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_INVENTORY_ITEM_ID    IN NUMBER
         ,p_WIP_ENTITY_ID        IN NUMBER
         ,p_OPERATION_SEQ_NUM    IN NUMBER
         ,p_RESOURCE_SEQ_NUM     IN NUMBER
         ,p_employee_id          IN NUMBER
         ,p_TRANSACTION_QUANTITY IN NUMBER
         ,p_TRANSACTION_UOM      IN VARCHAR2
         ,p_SERIAL_NUMBER        IN VARCHAR2
         ,p_REVISION             IN VARCHAR2 -- swai: bug 7182047 (FP of 6995498)
         -- swai bug 6841113: added material txn reason code
         ,p_REASON_ID      IN NUMBER
         -- swai: added code for operations
         ,p_BACKFLUSH_FLAG             IN NUMBER
         ,p_COUNT_POINT_TYPE           IN NUMBER
         ,p_DEPARTMENT_ID              IN NUMBER
         ,p_DESCRIPTION                IN VARCHAR2
         ,p_FIRST_UNIT_COMPLETION_DATE IN DATE
         ,p_FIRST_UNIT_START_DATE      IN DATE
         ,p_LAST_UNIT_COMPLETION_DATE  IN DATE
         ,p_LAST_UNIT_START_DATE       IN DATE
         ,p_MINIMUM_TRANSFER_QUANTITY  IN NUMBER
         ,p_STANDARD_OPERATION_ID      IN NUMBER
         -- yvchen: bug 13258460
         -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
         ,p_ATTRIBUTE_CATEGORY        VARCHAR2 := null
         ,p_ATTRIBUTE1                VARCHAR2 := null
         ,p_ATTRIBUTE2                VARCHAR2 := null
         ,p_ATTRIBUTE3                VARCHAR2 := null
         ,p_ATTRIBUTE4                VARCHAR2 := null
         ,p_ATTRIBUTE5                VARCHAR2 := null
         ,p_ATTRIBUTE6                VARCHAR2 := null
         ,p_ATTRIBUTE7                VARCHAR2 := null
         ,p_ATTRIBUTE8                VARCHAR2 := null
         ,p_ATTRIBUTE9                VARCHAR2 := null
         ,p_ATTRIBUTE10               VARCHAR2 := null
         ,p_ATTRIBUTE11               VARCHAR2 := null
         ,p_ATTRIBUTE12               VARCHAR2 := null
         ,p_ATTRIBUTE13               VARCHAR2 := null
         ,p_ATTRIBUTE14               VARCHAR2 := null
         ,p_ATTRIBUTE15               VARCHAR2 := null
         ,p_CREATE_RO_FLAG            VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro
         )

 IS
   CURSOR C2 IS SELECT CSD_WIP_TRANSACTION_DETAILS_S1.nextval FROM sys.dual;

Line: 75


   INSERT INTO CSD_WIP_TRANSACTION_DETAILS(
          WIP_TRANSACTION_DETAIL_ID
          ,CREATED_BY
         ,CREATION_DATE
         ,LAST_UPDATED_BY
         ,LAST_UPDATE_DATE
         ,LAST_UPDATE_LOGIN
         ,INVENTORY_ITEM_ID
         ,WIP_ENTITY_ID
         ,OPERATION_SEQ_NUM
         ,RESOURCE_SEQ_NUM
         ,employee_id
         ,TRANSACTION_QUANTITY
         ,TRANSACTION_UOM
         ,SERIAL_NUMBER
         ,REVISION         -- swai: bug 7182047 (FP of 6995498)
         , REASON_ID         -- swai bug 6841113: added material txn reason code
         -- swai: added code for operations
         ,BACKFLUSH_FLAG
         ,COUNT_POINT_TYPE
         ,DEPARTMENT_ID
         ,DESCRIPTION
         ,FIRST_UNIT_COMPLETION_DATE
         ,FIRST_UNIT_START_DATE
         ,LAST_UNIT_COMPLETION_DATE
         ,LAST_UNIT_START_DATE
         ,MINIMUM_TRANSFER_QUANTITY
         ,STANDARD_OPERATION_ID
         -- end swai: added code for operations
         ,OBJECT_VERSION_NUMBER
         -- yvchen: bug 13258460
         -- 12.1.3+ add DFF attributes
         ,ATTRIBUTE_CATEGORY
         ,ATTRIBUTE1
         ,ATTRIBUTE2
         ,ATTRIBUTE3
         ,ATTRIBUTE4
         ,ATTRIBUTE5
         ,ATTRIBUTE6
         ,ATTRIBUTE7
         ,ATTRIBUTE8
         ,ATTRIBUTE9
         ,ATTRIBUTE10
         ,ATTRIBUTE11
         ,ATTRIBUTE12
         ,ATTRIBUTE13
         ,ATTRIBUTE14
         ,ATTRIBUTE15
         -- end yvchen: bug 13258460
         ,CREATE_RO_FLAG -- bug#13698799 auto create ro, parent ro
          ) VALUES (
           px_WIP_TRANSACTION_DETAIL_ID
          ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
          ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
          ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
          ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
          ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
          ,decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, p_INVENTORY_ITEM_ID)
          ,decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, p_WIP_ENTITY_ID)
          ,decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_OPERATION_SEQ_NUM)
          ,decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, p_RESOURCE_SEQ_NUM)
          ,decode( p_employee_id, FND_API.G_MISS_NUM, NULL, p_employee_id)
          ,decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_QUANTITY)
          ,decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, p_TRANSACTION_UOM)
          ,decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, p_SERIAL_NUMBER)
          -- swai: bug 7182047 (FP of 6995498) added item revision
          ,decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, p_REVISION)
          -- end swai: bug 7182047 (FP of 6995498) added item revision
          -- swai bug 6841113: added material txn reason code
          ,decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, p_REASON_ID)
          -- end swai bug 6841113: added material txn reason code
          -- swai: added code for operations
          ,decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, p_BACKFLUSH_FLAG)
          ,decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, p_COUNT_POINT_TYPE)
          ,decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, p_DEPARTMENT_ID)
          ,decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
          ,decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_COMPLETION_DATE)
          ,decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_FIRST_UNIT_START_DATE)
          ,decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_COMPLETION_DATE)
          ,decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UNIT_START_DATE)
          ,decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, p_MINIMUM_TRANSFER_QUANTITY)
          ,decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, p_STANDARD_OPERATION_ID)
          -- end swai:  added code for operations
          ,l_object_version_number
          -- yvchen: bug 13258460
          -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
          ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
          ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
          ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
          ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
          ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
          ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
          ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
          ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
          ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
          ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
          ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
          ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
          ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
          ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
          ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
          ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
          -- end yvchen: bug 13258460
          ,decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, NULL, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro
            );

Line: 180


End Insert_Row;

Line: 182


PROCEDURE Update_Row(
          p_WIP_TRANSACTION_DETAIL_ID IN NUMBER
         ,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_INVENTORY_ITEM_ID    IN NUMBER
         ,p_WIP_ENTITY_ID        IN NUMBER
         ,p_OPERATION_SEQ_NUM    IN NUMBER
         ,p_RESOURCE_SEQ_NUM     IN NUMBER
         ,p_employee_id          IN NUMBER
         ,p_TRANSACTION_QUANTITY IN NUMBER
         ,p_TRANSACTION_UOM      IN VARCHAR2
         ,p_SERIAL_NUMBER        IN VARCHAR2
         ,p_REVISION             IN VARCHAR2 -- swai: bug 7182047 (FP of 6995498)
         -- swai bug 6841113: added material txn reason code
         ,p_REASON_ID            IN NUMBER
         -- swai: added code for operations
         ,p_BACKFLUSH_FLAG             IN NUMBER
         ,p_COUNT_POINT_TYPE           IN NUMBER
         ,p_DEPARTMENT_ID              IN NUMBER
         ,p_DESCRIPTION                IN VARCHAR2
         ,p_FIRST_UNIT_COMPLETION_DATE IN DATE
         ,p_FIRST_UNIT_START_DATE      IN DATE
         ,p_LAST_UNIT_COMPLETION_DATE  IN DATE
         ,p_LAST_UNIT_START_DATE       IN DATE
         ,p_MINIMUM_TRANSFER_QUANTITY  IN NUMBER
         ,p_STANDARD_OPERATION_ID      IN NUMBER
         ,p_OBJECT_VERSION_NUMBER IN NUMBER
         -- yvchen: bug 13258460
         -- 12.1.3+ add attributes to csd_wip_transaction_details
         -- default these to null so they will remain unchanged unless
         -- unless otherwise specified
         ,p_ATTRIBUTE_CATEGORY        VARCHAR2 := null
         ,p_ATTRIBUTE1                VARCHAR2 := null
         ,p_ATTRIBUTE2                VARCHAR2 := null
         ,p_ATTRIBUTE3                VARCHAR2 := null
         ,p_ATTRIBUTE4                VARCHAR2 := null
         ,p_ATTRIBUTE5                VARCHAR2 := null
         ,p_ATTRIBUTE6                VARCHAR2 := null
         ,p_ATTRIBUTE7                VARCHAR2 := null
         ,p_ATTRIBUTE8                VARCHAR2 := null
         ,p_ATTRIBUTE9                VARCHAR2 := null
         ,p_ATTRIBUTE10               VARCHAR2 := null
         ,p_ATTRIBUTE11               VARCHAR2 := null
         ,p_ATTRIBUTE12               VARCHAR2 := null
         ,p_ATTRIBUTE13               VARCHAR2 := null
         ,p_ATTRIBUTE14               VARCHAR2 := null
         ,p_ATTRIBUTE15               VARCHAR2 := null
         ,p_CREATE_RO_FLAG            VARCHAR2 := FND_API.G_MISS_CHAR --bug#13698799 auto create ro, parent ro
 )

IS
BEGIN
    Update CSD_WIP_TRANSACTION_DETAILS
    SET
       CREATED_BY             = decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, NULL, CREATED_BY, p_CREATED_BY)
       ,CREATION_DATE          = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, NULL, CREATION_DATE, p_CREATION_DATE)
       ,LAST_UPDATED_BY        = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
       ,LAST_UPDATE_DATE       = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
       ,LAST_UPDATE_LOGIN      = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, NULL, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
       ,INVENTORY_ITEM_ID      = decode( p_INVENTORY_ITEM_ID, FND_API.G_MISS_NUM, NULL, NULL, INVENTORY_ITEM_ID, p_INVENTORY_ITEM_ID)
       ,WIP_ENTITY_ID          = decode( p_WIP_ENTITY_ID, FND_API.G_MISS_NUM, NULL, NULL, WIP_ENTITY_ID, p_WIP_ENTITY_ID)
       ,OPERATION_SEQ_NUM        = decode( p_OPERATION_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, OPERATION_SEQ_NUM, p_OPERATION_SEQ_NUM)
       ,RESOURCE_SEQ_NUM         = decode( p_RESOURCE_SEQ_NUM, FND_API.G_MISS_NUM, NULL, NULL, RESOURCE_SEQ_NUM, p_RESOURCE_SEQ_NUM)
       ,employee_id = decode( p_employee_id, FND_API.G_MISS_NUM, NULL, NULL, employee_id , p_employee_id)
       ,TRANSACTION_QUANTITY            = decode( p_TRANSACTION_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, TRANSACTION_QUANTITY, p_TRANSACTION_QUANTITY)
       ,TRANSACTION_UOM            = decode( p_TRANSACTION_UOM, FND_API.G_MISS_CHAR, NULL, NULL, TRANSACTION_UOM, p_TRANSACTION_UOM)
       ,SERIAL_NUMBER             = decode( p_SERIAL_NUMBER, FND_API.G_MISS_CHAR, NULL, NULL, SERIAL_NUMBER, p_SERIAL_NUMBER)
       -- swai: bug 7182047 (FP of 6995498) added item revision
       ,REVISION                  = decode( p_REVISION, FND_API.G_MISS_CHAR, NULL, NULL, REVISION, p_REVISION)
       -- end swai: bug 7182047 (FP of 6995498) added item revision
       -- swai bug 6841113: added material txn reason code
       ,REASON_ID      = decode( p_REASON_ID, FND_API.G_MISS_NUM, NULL, NULL, REASON_ID, p_REASON_ID)
       -- end swai bug 6841113: added material txn reason code
       -- swai: added code for operations
       ,BACKFLUSH_FLAG             = decode( p_BACKFLUSH_FLAG, FND_API.G_MISS_NUM, NULL, NULL, BACKFLUSH_FLAG, p_BACKFLUSH_FLAG)
       ,COUNT_POINT_TYPE           = decode( p_COUNT_POINT_TYPE, FND_API.G_MISS_NUM, NULL, NULL, COUNT_POINT_TYPE, p_COUNT_POINT_TYPE)
       ,DEPARTMENT_ID              = decode( p_DEPARTMENT_ID, FND_API.G_MISS_NUM, NULL, NULL, DEPARTMENT_ID, p_DEPARTMENT_ID)
       ,DESCRIPTION                = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, NULL, DESCRIPTION, p_DESCRIPTION)
       ,FIRST_UNIT_COMPLETION_DATE = decode( p_FIRST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_COMPLETION_DATE, p_FIRST_UNIT_COMPLETION_DATE)
       ,FIRST_UNIT_START_DATE      = decode( p_FIRST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, FIRST_UNIT_START_DATE, p_FIRST_UNIT_START_DATE)
       ,LAST_UNIT_COMPLETION_DATE  = decode( p_LAST_UNIT_COMPLETION_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_COMPLETION_DATE, p_LAST_UNIT_COMPLETION_DATE)
       ,LAST_UNIT_START_DATE       = decode( p_LAST_UNIT_START_DATE, FND_API.G_MISS_DATE, NULL, NULL, LAST_UNIT_START_DATE, p_LAST_UNIT_START_DATE)
       ,MINIMUM_TRANSFER_QUANTITY  = decode( p_MINIMUM_TRANSFER_QUANTITY, FND_API.G_MISS_NUM, NULL, NULL, MINIMUM_TRANSFER_QUANTITY, p_MINIMUM_TRANSFER_QUANTITY)
       ,STANDARD_OPERATION_ID      = decode( p_STANDARD_OPERATION_ID, FND_API.G_MISS_NUM, NULL, NULL, STANDARD_OPERATION_ID, p_STANDARD_OPERATION_ID)
       -- end swai:  added code for operations
       ,OBJECT_VERSION_NUMBER                = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
       -- yvchen: bug 13258460
       -- 12.1.3+ add DFF attributes to csd_wip_transaction_details
       ,ATTRIBUTE_CATEGORY         = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
       ,ATTRIBUTE1                 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE1, p_ATTRIBUTE1)
       ,ATTRIBUTE2                 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE2, p_ATTRIBUTE2)
       ,ATTRIBUTE3                 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE3, p_ATTRIBUTE3)
       ,ATTRIBUTE4                 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE4, p_ATTRIBUTE4)
       ,ATTRIBUTE5                 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE5, p_ATTRIBUTE5)
       ,ATTRIBUTE6                 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE6, p_ATTRIBUTE6)
       ,ATTRIBUTE7                 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE7, p_ATTRIBUTE7)
       ,ATTRIBUTE8                 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE8, p_ATTRIBUTE8)
       ,ATTRIBUTE9                 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE9, p_ATTRIBUTE9)
       ,ATTRIBUTE10                = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE10, p_ATTRIBUTE10)
       ,ATTRIBUTE11                = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE11, p_ATTRIBUTE11)
       ,ATTRIBUTE12                = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE12, p_ATTRIBUTE12)
       ,ATTRIBUTE13                = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE13, p_ATTRIBUTE13)
       ,ATTRIBUTE14                = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE14, p_ATTRIBUTE14)
       ,ATTRIBUTE15                = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, NULL, ATTRIBUTE15, p_ATTRIBUTE15)
       -- end yvchen: bug 13258460
       ,CREATE_RO_FLAG             = decode( p_CREATE_RO_FLAG, FND_API.G_MISS_CHAR, CREATE_RO_FLAG, p_CREATE_RO_FLAG) -- bug#13698799 auto create ro, parent ro

    where WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;

Line: 297


END Update_Row;

Line: 299


PROCEDURE Delete_Row(
    p_WIP_TRANSACTION_DETAIL_ID  NUMBER)
IS
BEGIN
    DELETE FROM CSD_WIP_TRANSACTION_DETAILS
    WHERE WIP_TRANSACTION_DETAIL_ID = p_WIP_TRANSACTION_DETAIL_ID;

Line: 308


END Delete_Row;