DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PKG SQL Statements

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

Line: 15

PROCEDURE Insert_Row(	X_Rowid                           IN OUT NOCOPY VARCHAR2,
                  	X_DEBRIEF_HEADER_ID               IN OUT NOCOPY NUMBER,
 				X_DEBRIEF_NUMBER                  VARCHAR2,
 				X_DEBRIEF_DATE                    DATE,
 				X_DEBRIEF_STATUS_ID               NUMBER,
 				X_TASK_ASSIGNMENT_ID              NUMBER,
 				X_CREATED_BY                      NUMBER,
 				X_CREATION_DATE                   DATE,
 				X_LAST_UPDATED_BY                 NUMBER,
 				X_LAST_UPDATE_DATE                DATE,
 				X_LAST_UPDATE_LOGIN               NUMBER,
 				X_ATTRIBUTE1                      VARCHAR2,
 				X_ATTRIBUTE2                      VARCHAR2,
 				X_ATTRIBUTE3                      VARCHAR2,
 				X_ATTRIBUTE4                      VARCHAR2,
 				X_ATTRIBUTE5                      VARCHAR2,
 				X_ATTRIBUTE6                      VARCHAR2,
 				X_ATTRIBUTE7                      VARCHAR2,
	 			X_ATTRIBUTE8                      VARCHAR2,
 				X_ATTRIBUTE9                      VARCHAR2,
 				X_ATTRIBUTE10                     VARCHAR2,
 				X_ATTRIBUTE11                     VARCHAR2,
	 			X_ATTRIBUTE12                     VARCHAR2,
 				X_ATTRIBUTE13                     VARCHAR2,
 				X_ATTRIBUTE14                     VARCHAR2,
 				X_ATTRIBUTE15                     VARCHAR2,
 				X_ATTRIBUTE_CATEGORY              VARCHAR2 )


 IS
   CURSOR C2 IS SELECT CSF_DEBRIEF_HEADERS_S1.nextval FROM sys.dual;
Line: 55

End  Insert_Row;
Line: 57

 PROCEDURE Update_Row( X_RowId					VARCHAR2,
				X_DEBRIEF_HEADER_ID         		NUMBER,
 				X_DEBRIEF_NUMBER                  	VARCHAR2,
 				X_DEBRIEF_DATE                    	DATE,
 				X_DEBRIEF_STATUS_ID               	NUMBER,
 				X_TASK_ASSIGNMENT_ID              	NUMBER,
 				X_CREATED_BY                      	NUMBER,
 				X_CREATION_DATE                  	DATE,
 				X_LAST_UPDATED_BY                 	NUMBER,
 				X_LAST_UPDATE_DATE                	DATE,
 				X_LAST_UPDATE_LOGIN               	NUMBER,
 				X_ATTRIBUTE1                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE2                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE3                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE4                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE5                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE6                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE7                      	VARCHAR2 DEFAULT NULL,
	 			X_ATTRIBUTE8                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE9                      	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE10                     	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE11                     	VARCHAR2 DEFAULT NULL,
	 			X_ATTRIBUTE12                     	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE13                     	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE14                     	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE15                     	VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE_CATEGORY              	VARCHAR2 DEFAULT NULL )


 IS
 BEGIN
    NULL;
Line: 89

END  Update_Row;
Line: 100

 				X_LAST_UPDATED_BY                 NUMBER,
 				X_LAST_UPDATE_DATE                DATE,
 				X_LAST_UPDATE_LOGIN               NUMBER,
 				X_ATTRIBUTE1                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE2                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE3                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE4                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE5                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE6                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE7                      VARCHAR2 DEFAULT NULL,
	 			X_ATTRIBUTE8                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE9                      VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE10                     VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE11                     VARCHAR2 DEFAULT NULL,
	 			X_ATTRIBUTE12                     VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE13                     VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE14                     VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE15                     VARCHAR2 DEFAULT NULL,
 				X_ATTRIBUTE_CATEGORY              VARCHAR2 DEFAULT NULL )


 IS

 BEGIN
		NULL;
Line: 129

PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS

BEGIN
	NULL;
Line: 134

END DELETE_ROW;