APPS.AHL_OSP_ORDER_LOGS_PKG SQL Statements

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

Line: 3

PROCEDURE INSERT_ROW (
        X_OSP_ORDER_LOG_ID	       IN OUT NOCOPY NUMBER,
	    X_OBJECT_VERSION_NUMBER    IN NUMBER,
	    X_LAST_UPDATE_DATE	       IN DATE,
	    X_LAST_UPDATED_BY		   IN NUMBER,
	    X_CREATION_DATE			   IN DATE,
	    X_CREATED_BY			   IN NUMBER,
	    X_LAST_UPDATE_LOGIN		   IN NUMBER,
        X_TRANSACTION_DATE         IN DATE,
        X_TRANSACTION_TYPE_CODE    IN VARCHAR2,
        X_SOURCE_DOCUMENT_ID       IN NUMBER ,
        X_SOURCE_DOCUMENT_TYPE_CODE IN VARCHAR2,
        X_DESTINATION_DOCUMENT_ID  IN NUMBER,
        X_DEST_DOCUMENT_TYPE_CODE  IN VARCHAR2,
        X_TRANSACTION_STATUS_CODE  IN VARCHAR2,
        X_PROGRAM_ID               IN NUMBER,
	    X_ATTRIBUTE_CATEGORY	   IN VARCHAR2,
	    X_ATTRIBUTE1			   IN VARCHAR2,
	    X_ATTRIBUTE2               IN VARCHAR2,
	    X_ATTRIBUTE3               IN VARCHAR2,
	    X_ATTRIBUTE4               IN VARCHAR2,
	    X_ATTRIBUTE5               IN VARCHAR2,
	    X_ATTRIBUTE6               IN VARCHAR2,
	    X_ATTRIBUTE7               IN VARCHAR2,
	    X_ATTRIBUTE8               IN VARCHAR2,
	    X_ATTRIBUTE9               IN VARCHAR2,
	    X_ATTRIBUTE10              IN VARCHAR2,
	    X_ATTRIBUTE11              IN VARCHAR2,
	    X_ATTRIBUTE12              IN VARCHAR2,
	    X_ATTRIBUTE13              IN VARCHAR2,
	    X_ATTRIBUTE14              IN VARCHAR2,
        X_ATTRIBUTE15              IN VARCHAR2
) IS


BEGIN
  insert into AHL_OSP_ORDER_LOGS (
    OSP_ORDER_LOG_ID,
	OBJECT_VERSION_NUMBER,
	LAST_UPDATE_DATE,
	LAST_UPDATED_BY,
	CREATION_DATE,
	CREATED_BY,
	LAST_UPDATE_LOGIN,
    TRANSACTION_DATE,
    TRANSACTION_TYPE_CODE,
    SOURCE_DOCUMENT_ID,
    SOURCE_DOCUMENT_TYPE_CODE,
    DESTINATION_DOCUMENT_ID,
    DESTINATION_DOCUMENT_TYPE_CODE,
    TRANSACTION_STATUS_CODE,
    PROGRAM_ID,
	ATTRIBUTE_CATEGORY,
	ATTRIBUTE1,
	ATTRIBUTE2,
	ATTRIBUTE3,
	ATTRIBUTE4,
	ATTRIBUTE5,
	ATTRIBUTE6,
	ATTRIBUTE7,
	ATTRIBUTE8,
	ATTRIBUTE9,
	ATTRIBUTE10,
	ATTRIBUTE11,
	ATTRIBUTE12,
	ATTRIBUTE13,
	ATTRIBUTE14,
    ATTRIBUTE15
   )  values (
        AHL_OSP_ORDER_LOGS_S.NEXTVAL,
        X_OBJECT_VERSION_NUMBER,
	    X_LAST_UPDATE_DATE,
	    X_LAST_UPDATED_BY,
	    X_CREATION_DATE,
	    X_CREATED_BY,
	    X_LAST_UPDATE_LOGIN,
        X_TRANSACTION_DATE,
        X_TRANSACTION_TYPE_CODE,
        X_SOURCE_DOCUMENT_ID,
        X_SOURCE_DOCUMENT_TYPE_CODE,
        X_DESTINATION_DOCUMENT_ID,
        X_DEST_DOCUMENT_TYPE_CODE,
        X_TRANSACTION_STATUS_CODE,
        X_PROGRAM_ID,
	    X_ATTRIBUTE_CATEGORY,
	    X_ATTRIBUTE1,
	    X_ATTRIBUTE2,
	    X_ATTRIBUTE3,
	    X_ATTRIBUTE4,
	    X_ATTRIBUTE5,
	    X_ATTRIBUTE6,
	    X_ATTRIBUTE7,
	    X_ATTRIBUTE8,
	    X_ATTRIBUTE9,
	    X_ATTRIBUTE10,
	    X_ATTRIBUTE11,
	    X_ATTRIBUTE12,
	    X_ATTRIBUTE13,
	    X_ATTRIBUTE14,
        X_ATTRIBUTE15

) RETURNING OSP_ORDER_LOG_ID INTO X_OSP_ORDER_LOG_ID;

Line: 116

END INSERT_ROW;

Line: 119

PROCEDURE UPDATE_ROW (
        X_OSP_ORDER_LOG_ID	       IN NUMBER,
	    X_OBJECT_VERSION_NUMBER    IN NUMBER,
	    X_LAST_UPDATE_DATE	       IN DATE,
	    X_LAST_UPDATED_BY		   IN NUMBER,
	    X_LAST_UPDATE_LOGIN		   IN NUMBER,
        X_TRANSACTION_DATE         IN DATE,
        X_TRANSACTION_TYPE_CODE    IN VARCHAR2,
        X_SOURCE_DOCUMENT_ID       IN NUMBER ,
        X_SOURCE_DOCUMENT_TYPE_CODE IN VARCHAR2,
        X_DESTINATION_DOCUMENT_ID  IN NUMBER,
        X_DEST_DOCUMENT_TYPE_CODE  IN VARCHAR2,
        X_TRANSACTION_STATUS_CODE  IN VARCHAR2,
        X_PROGRAM_ID               IN NUMBER,
	    X_ATTRIBUTE_CATEGORY	   IN VARCHAR2,
	    X_ATTRIBUTE1			   IN VARCHAR2,
	    X_ATTRIBUTE2               IN VARCHAR2,
	    X_ATTRIBUTE3               IN VARCHAR2,
	    X_ATTRIBUTE4               IN VARCHAR2,
	    X_ATTRIBUTE5               IN VARCHAR2,
	    X_ATTRIBUTE6               IN VARCHAR2,
	    X_ATTRIBUTE7               IN VARCHAR2,
	    X_ATTRIBUTE8               IN VARCHAR2,
	    X_ATTRIBUTE9               IN VARCHAR2,
	    X_ATTRIBUTE10              IN VARCHAR2,
	    X_ATTRIBUTE11              IN VARCHAR2,
	    X_ATTRIBUTE12              IN VARCHAR2,
	    X_ATTRIBUTE13              IN VARCHAR2,
	    X_ATTRIBUTE14              IN VARCHAR2,
        X_ATTRIBUTE15              IN VARCHAR2
) IS


BEGIN
  update AHL_OSP_ORDER_LOGS set
        OSP_ORDER_LOG_ID = X_OSP_ORDER_LOG_ID,
	    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER ,
	    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
	    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
	    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,
        TRANSACTION_DATE = X_TRANSACTION_DATE,
        TRANSACTION_TYPE_CODE = X_TRANSACTION_TYPE_CODE,
        SOURCE_DOCUMENT_ID = X_SOURCE_DOCUMENT_ID,
        SOURCE_DOCUMENT_TYPE_CODE = X_SOURCE_DOCUMENT_TYPE_CODE,
        DESTINATION_DOCUMENT_ID = X_DESTINATION_DOCUMENT_ID,
        DESTINATION_DOCUMENT_TYPE_CODE = X_DEST_DOCUMENT_TYPE_CODE,
        TRANSACTION_STATUS_CODE = X_TRANSACTION_STATUS_CODE,
        PROGRAM_ID = X_PROGRAM_ID,
	    ATTRIBUTE_CATEGORY = X_ATTRIBUTE_CATEGORY,
	    ATTRIBUTE1 = X_ATTRIBUTE1,
	    ATTRIBUTE2 = X_ATTRIBUTE2,
	    ATTRIBUTE3 = X_ATTRIBUTE3,
	    ATTRIBUTE4 = X_ATTRIBUTE4,
	    ATTRIBUTE5 = X_ATTRIBUTE5,
	    ATTRIBUTE6 = X_ATTRIBUTE6,
	    ATTRIBUTE7 = X_ATTRIBUTE7,
	    ATTRIBUTE8 = X_ATTRIBUTE8,
	    ATTRIBUTE9 = X_ATTRIBUTE9,
	    ATTRIBUTE10 = X_ATTRIBUTE10,
	    ATTRIBUTE11 = X_ATTRIBUTE11,
	    ATTRIBUTE12 = X_ATTRIBUTE12,
	    ATTRIBUTE13 = X_ATTRIBUTE13,
	    ATTRIBUTE14 = X_ATTRIBUTE14,
        ATTRIBUTE15 = X_ATTRIBUTE15
  where OSP_ORDER_LOG_ID = X_OSP_ORDER_LOG_ID
  and OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER - 1;

Line: 200

END UPDATE_ROW;

Line: 202

PROCEDURE DELETE_ROW (
  X_OSP_ORDER_LOG_ID in NUMBER
) is

BEGIN

  delete from AHL_OSP_ORDER_LOGS
  where OSP_ORDER_LOG_ID = X_OSP_ORDER_LOG_ID;

Line: 215

END DELETE_ROW;