[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_WARRANTY_CONTRACT_XREF_ID IN OUT NOCOPY 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_SOURCE_TABLE VARCHAR2
,p_SOURCE_COLUMN VARCHAR2
,p_SOURCE_ID NUMBER
,p_WARRANTY_CONTRACT_ID NUMBER
,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_REPAIR_LINE_ID NUMBER
,p_INSTANCE_ID NUMBER) --yvchen
IS
CURSOR C2 IS SELECT CSD_AHL_W_CONTRACT_XREF_S1.nextval FROM sys.dual;
INSERT INTO CSD_AHL_W_CONTRACT_XREF(
WARRANTY_CONTRACT_XREF_ID
,OBJECT_VERSION_NUMBER
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,SOURCE_TABLE
,SOURCE_COLUMN
,SOURCE_ID
,WARRANTY_CONTRACT_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,REPAIR_LINE_ID
,INSTANCE_ID --yvchen
) VALUES (
px_WARRANTY_CONTRACT_XREF_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_SOURCE_TABLE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_TABLE)
,decode( p_SOURCE_COLUMN, FND_API.G_MISS_CHAR, NULL, p_SOURCE_COLUMN)
,decode( p_SOURCE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_ID)
,decode( p_WARRANTY_CONTRACT_ID, FND_API.G_MISS_NUM, NULL, p_WARRANTY_CONTRACT_ID)
,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_REPAIR_LINE_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_LINE_ID)
,decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, NULL, p_INSTANCE_ID)); --yvchen
End Insert_Row;
/*This Update_Row is not need for R12.2 project.. this procedure was auto generate.
It has not fully testing.. This procedure is not use by any of Depot code
any dev plan to use it, please test and make sure it is working */
PROCEDURE Update_Row(
p_WARRANTY_CONTRACT_XREF_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_SOURCE_TABLE VARCHAR2
,p_SOURCE_COLUMN VARCHAR2
,p_SOURCE_ID NUMBER
,p_WARRANTY_CONTRACT_ID NUMBER
,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_REPAIR_LINE_ID NUMBER
,p_INSTANCE_ID NUMBER) --yvchen
IS
BEGIN
Update CSD_AHL_W_CONTRACT_XREF
SET
OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
,SOURCE_TABLE = decode( p_SOURCE_TABLE, FND_API.G_MISS_CHAR, SOURCE_TABLE, p_SOURCE_TABLE)
,SOURCE_COLUMN = decode( p_SOURCE_COLUMN, FND_API.G_MISS_CHAR, SOURCE_COLUMN, p_SOURCE_COLUMN)
,SOURCE_ID = decode( p_SOURCE_ID, FND_API.G_MISS_NUM, SOURCE_ID, p_SOURCE_ID)
,WARRANTY_CONTRACT_ID = decode( p_WARRANTY_CONTRACT_ID, FND_API.G_MISS_NUM, WARRANTY_CONTRACT_ID, p_WARRANTY_CONTRACT_ID)
,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
,REPAIR_LINE_ID = decode( p_REPAIR_LINE_ID, FND_API.G_MISS_NUM, REPAIR_LINE_ID, p_REPAIR_LINE_ID)
,INSTANCE_ID = decode( p_INSTANCE_ID, FND_API.G_MISS_NUM, INSTANCE_ID, p_INSTANCE_ID) --yvchen
where WARRANTY_CONTRACT_XREF_ID = p_WARRANTY_CONTRACT_XREF_ID;
END Update_Row;
/*This Delete_Row is not need for R12.2 project.. this procedure was auto generate.
It has not fully testing.. This procedure is not use by any of Depot code
any dev plan to use it, please test and make sure it is working */
PROCEDURE Delete_Row(
p_WARRANTY_CONTRACT_XREF_ID NUMBER)
IS
BEGIN
DELETE FROM CSD_AHL_W_CONTRACT_XREF
WHERE WARRANTY_CONTRACT_XREF_ID = p_WARRANTY_CONTRACT_XREF_ID;
END Delete_Row;
,p_LAST_UPDATED_BY NUMBER
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATE_LOGIN NUMBER
,p_SOURCE_TABLE VARCHAR2
,p_SOURCE_COLUMN VARCHAR2
,p_SOURCE_ID NUMBER
,p_WARRANTY_CONTRACT_ID NUMBER
,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_REPAIR_LINE_ID NUMBER
,p_INSTANCE_ID NUMBER) --yvchen
IS
CURSOR C IS
SELECT *
FROM CSD_AHL_W_CONTRACT_XREF
WHERE WARRANTY_CONTRACT_XREF_ID = p_WARRANTY_CONTRACT_XREF_ID
FOR UPDATE of WARRANTY_CONTRACT_XREF_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( p_LAST_UPDATED_BY IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( p_LAST_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( p_LAST_UPDATE_LOGIN IS NULL )))
AND ( ( Recinfo.SOURCE_TABLE = p_SOURCE_TABLE)
OR ( ( Recinfo.SOURCE_TABLE IS NULL )
AND ( p_SOURCE_TABLE IS NULL )))
AND ( ( Recinfo.SOURCE_COLUMN = p_SOURCE_COLUMN)
OR ( ( Recinfo.SOURCE_COLUMN IS NULL )
AND ( p_SOURCE_COLUMN IS NULL )))
AND ( ( Recinfo.SOURCE_ID = p_SOURCE_ID)
OR ( ( Recinfo.SOURCE_ID IS NULL )
AND ( p_SOURCE_ID IS NULL )))
AND ( ( Recinfo.WARRANTY_CONTRACT_ID = p_WARRANTY_CONTRACT_ID)
OR ( ( Recinfo.WARRANTY_CONTRACT_ID IS NULL )
AND ( p_WARRANTY_CONTRACT_ID IS NULL )))
AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( p_ATTRIBUTE1 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( p_ATTRIBUTE2 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( p_ATTRIBUTE3 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( p_ATTRIBUTE4 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( p_ATTRIBUTE5 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( p_ATTRIBUTE6 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( p_ATTRIBUTE7 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( p_ATTRIBUTE8 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( p_ATTRIBUTE9 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( p_ATTRIBUTE10 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( p_ATTRIBUTE11 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( p_ATTRIBUTE12 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( p_ATTRIBUTE13 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( p_ATTRIBUTE14 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( p_ATTRIBUTE15 IS NULL )))
AND ( ( Recinfo.REPAIR_LINE_ID = p_REPAIR_LINE_ID)
OR ( ( Recinfo.REPAIR_LINE_ID IS NULL )
AND ( p_REPAIR_LINE_ID IS NULL )))
AND ( ( Recinfo.INSTANCE_ID = p_INSTANCE_ID) --yvchen
OR ( ( Recinfo.INSTANCE_ID IS NULL )
AND ( p_INSTANCE_ID IS NULL )))
) then
return;