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_SO_ORCHESTRATION_PKG SQL Statements

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

Line: 15


PROCEDURE Insert_Row(
          px_ORCHESTRATION_ID      IN OUT NOCOPY NUMBER
         ,p_REPAIR_LINE_ID         NUMBER
         ,p_OBJECT_VERSION_NUMBER  NUMBER
         ,p_CREATED_BY           NUMBER
         ,p_CREATION_DATE        DATE
         ,p_LAST_UPDATED_BY      NUMBER
         ,p_LAST_UPDATE_DATE     DATE
         ,p_LAST_UPDATE_LOGIN    NUMBER
         ,p_DOCUMENT_HEADER_ID   NUMBER
         ,p_DOCUMENT_HEADER_NAME VARCHAR2
         ,p_DOCUMENT_LINE_ID     NUMBER
         ,p_DOCUMENT_LINE_NAME   VARCHAR2
         ,p_STATUS_ID            NUMBER
         ,p_STATUS_CODE          VARCHAR2
         ,p_PREV_STATUS_ID       NUMBER
         ,p_PREV_STATUS_CODE     VARCHAR2
         ,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_PARAMN1        NUMBER
       )

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

Line: 59


   INSERT INTO CSD_SO_ORCHESTRATION(
          ORCHESTRATION_ID
         ,REPAIR_LINE_ID
         ,OBJECT_VERSION_NUMBER
         ,CREATED_BY
         ,CREATION_DATE
         ,LAST_UPDATED_BY
         ,LAST_UPDATE_DATE
         ,LAST_UPDATE_LOGIN
         ,DOCUMENT_HEADER_ID
         ,DOCUMENT_HEADER_NAME
         ,DOCUMENT_LINE_ID
         ,DOCUMENT_LINE_NAME
         ,STATUS_ID
         ,STATUS_CODE
         ,PREV_STATUS_ID
         ,PREV_STATUS_CODE
         ,ATTRIBUTE_CATEGORY
         ,ATTRIBUTE1
         ,ATTRIBUTE2
         ,ATTRIBUTE3
         ,ATTRIBUTE4
         ,ATTRIBUTE5
         ,ATTRIBUTE6
         ,ATTRIBUTE7
         ,ATTRIBUTE8
         ,ATTRIBUTE9
         ,ATTRIBUTE10
         ,ATTRIBUTE11
         ,ATTRIBUTE12
         ,ATTRIBUTE13
         ,ATTRIBUTE14
         ,ATTRIBUTE15
         ,PARAMN1
          ) VALUES (
           px_ORCHESTRATION_ID
          ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
          ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
          ,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_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_HEADER_ID)
          ,decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_HEADER_NAME)
          ,decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, p_DOCUMENT_LINE_ID)
          ,decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, p_DOCUMENT_LINE_NAME)
          ,decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_STATUS_ID)
          ,decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE)
          ,decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_PREV_STATUS_ID)
          ,decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_PREV_STATUS_CODE)
          ,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)
          ,decode( p_PARAMN1, FND_API.G_MISS_NUM, NULL, p_PARAMN1)
          );

Line: 128


End Insert_Row;

Line: 132


Name: Update_Row
Description: Procedure to update a row in the CSD_SO_ORCHESTRATION table,which stores SOO documents.
*/
PROCEDURE Update_Row(
          p_ORCHESTRATION_ID      NUMBER
         ,p_REPAIR_LINE_ID         NUMBER
         ,p_OBJECT_VERSION_NUMBER  NUMBER
         ,p_CREATED_BY           NUMBER
         ,p_CREATION_DATE        DATE
         ,p_LAST_UPDATED_BY      NUMBER
         ,p_LAST_UPDATE_DATE     DATE
         ,p_LAST_UPDATE_LOGIN    NUMBER
         ,p_DOCUMENT_HEADER_ID   NUMBER
         ,p_DOCUMENT_HEADER_NAME VARCHAR2
         ,p_DOCUMENT_LINE_ID     NUMBER
         ,p_DOCUMENT_LINE_NAME   VARCHAR2
         ,p_STATUS_ID            NUMBER
         ,p_STATUS_CODE          VARCHAR2
         ,p_PREV_STATUS_ID       NUMBER
         ,p_PREV_STATUS_CODE     VARCHAR2
         ,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_PARAMN1        NUMBER
       )

IS
BEGIN
    Update CSD_SO_ORCHESTRATION
    SET
        REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
       ,OBJECT_VERSION_NUMBER = decode( P_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, P_OBJECT_VERSION_NUMBER)
       ,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)
       ,DOCUMENT_HEADER_ID = decode( p_DOCUMENT_HEADER_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_HEADER_ID, p_DOCUMENT_HEADER_ID)
       ,DOCUMENT_HEADER_NAME = decode( p_DOCUMENT_HEADER_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_HEADER_NAME, p_DOCUMENT_HEADER_NAME)
       ,DOCUMENT_LINE_ID = decode( p_DOCUMENT_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, DOCUMENT_LINE_ID, p_DOCUMENT_LINE_ID)
       ,DOCUMENT_LINE_NAME = decode( p_DOCUMENT_LINE_NAME, FND_API.G_MISS_CHAR, NULL, NULL, DOCUMENT_LINE_NAME, p_DOCUMENT_LINE_NAME)
       ,STATUS_ID = decode( p_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, STATUS_ID, p_STATUS_ID)
       ,STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, STATUS_CODE, p_STATUS_CODE)
       ,PREV_STATUS_ID = decode( p_PREV_STATUS_ID, FND_API.G_MISS_NUM, NULL, NULL, PREV_STATUS_ID, p_PREV_STATUS_ID)
       ,PREV_STATUS_CODE = decode( p_PREV_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, NULL, PREV_STATUS_CODE, p_PREV_STATUS_CODE)
       ,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)
       ,PARAMN1 = decode( P_PARAMN1, FND_API.G_MISS_NUM, NULL, NULL, PARAMN1, P_PARAMN1)

    where ORCHESTRATION_ID = p_ORCHESTRATION_ID;

Line: 213


END Update_Row;

Line: 215


PROCEDURE Delete_Row(
    p_ORCHESTRATION_ID  NUMBER)
IS
BEGIN
    DELETE FROM CSD_SO_ORCHESTRATION
    WHERE ORCHESTRATION_ID = p_ORCHESTRATION_ID;

Line: 224


END Delete_Row;

Line: 234


       SELECT *
       FROM CSD_SO_ORCHESTRATION
       WHERE ORCHESTRATION_ID =  p_ORCHESTRATION_ID
       FOR UPDATE of ORCHESTRATION_ID NOWAIT;

Line: 244


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