APPS.CSD_TASKS_PKG SQL Statements

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

Line: 11

    PROCEDURE Insert_Row(
              px_repair_TASK_ID   IN OUT NOCOPY NUMBER
	     ,p_task_id       NUMBER
             ,p_REPAIR_LINE_ID    NUMBER
	     ,p_APPLICABLE_QA_PLANS VARCHAR2
	     ,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
             )

     IS

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

Line: 35

       INSERT INTO CSD_TASKS(
               REPAIR_TASK_ID
              ,TASK_ID
              ,OBJECT_VERSION_NUMBER
              ,REPAIR_LINE_ID
	      ,APPLICABLE_QA_PLANS
              ,CREATED_BY
              ,CREATION_DATE
              ,LAST_UPDATED_BY
              ,LAST_UPDATE_DATE
              ,LAST_UPDATE_LOGIN
              ) VALUES (
               px_repair_TASK_ID
	      ,decode( p_TASK_ID, FND_API.G_MISS_NUM, NULL, p_TASK_ID)
              ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
              ,decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
	      ,decode( p_APPLICABLE_QA_PLANS, FND_API.G_MISS_CHAR, NULL, p_APPLICABLE_QA_PLANS)
              ,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)
              );

Line: 58

    End Insert_Row;

Line: 60

    PROCEDURE Update_Row(
     px_repair_TASK_ID NUMBER
         ,p_TASK_ID    NUMBER
         ,p_OBJECT_VERSION_NUMBER    NUMBER
         ,p_REPAIR_LINE_ID    NUMBER
	 ,p_APPLICABLE_QA_PLANS VARCHAR2
         ,p_CREATED_BY    NUMBER
         ,p_CREATION_DATE    DATE
         ,p_LAST_UPDATED_BY    NUMBER
         ,p_LAST_UPDATE_DATE    DATE
         ,p_LAST_UPDATE_LOGIN    NUMBER
            )

    IS
    BEGIN
        Update CSD_TASKS
        SET

	    TASK_ID = decode( p_TASK_ID, FND_API.G_MISS_NUM, NULL, NULL, TASK_ID, p_TASK_ID)
	   ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, NULL, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
           ,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, NULL, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
	   ,APPLICABLE_QA_PLANS = decode( p_APPLICABLE_QA_PLANS, FND_API.G_MISS_CHAR, NULL, p_APPLICABLE_QA_PLANS)
           ,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)
            where REPAIR_TASK_ID = px_repair_TASK_ID
	    and OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER;

Line: 93

    END Update_Row;

Line: 95

    PROCEDURE Delete_Row(
		p_repair_TASK_ID    NUMBER)
    IS
    BEGIN
        DELETE FROM CSD_TASKS
        WHERE REPAIR_TASK_ID = p_REPAIR_TASK_ID;

Line: 105

    END Delete_Row;

Line: 114

       SELECT *
       FROM CSD_TASKS
       WHERE REPAIR_TASK_ID =  p_REPAIR_TASK_ID
       FOR UPDATE of REPAIR_TASK_ID NOWAIT;

Line: 124

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