[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
X_PRICING_ATTRIBUTE_ID IN OUT NUMBER
, X_CREATION_DATE DATE
, X_CREATED_BY NUMBER
, X_LAST_UPDATE_DATE DATE
, X_LAST_UPDATED_BY NUMBER
, X_LAST_UPDATE_LOGIN NUMBER
, X_PROGRAM_APPLICATION_ID NUMBER
, X_PROGRAM_ID NUMBER
, X_PROGRAM_UPDATE_DATE DATE
, X_REQUEST_ID NUMBER
, X_LIST_LINE_ID NUMBER
, X_EXCLUDER_FLAG VARCHAR2
, X_ACCUMULATE_FLAG VARCHAR2
, X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
, X_PRODUCT_ATTRIBUTE VARCHAR2
, X_PRODUCT_ATTR_VALUE VARCHAR2
, X_PRODUCT_UOM_CODE VARCHAR2
, X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
, X_PRICING_ATTRIBUTE VARCHAR2
, X_PRICING_ATTR_VALUE_FROM VARCHAR2
, X_PRICING_ATTR_VALUE_TO VARCHAR2
, X_ATTRIBUTE_GROUPING_NO NUMBER
, X_CONTEXT VARCHAR2
, 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
) IS
cursor C is select PRICING_ATTRIBUTE_ID from QP_PRICING_ATTRIBUTES
where PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID;
insert into QP_PRICING_ATTRIBUTES
(
PRICING_ATTRIBUTE_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, LIST_LINE_ID
, EXCLUDER_FLAG
, ACCUMULATE_FLAG
, PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE
, PRICING_ATTRIBUTE_CONTEXT
, PRICING_ATTRIBUTE
, PRICING_ATTR_VALUE_FROM
, PRICING_ATTR_VALUE_TO
, ATTRIBUTE_GROUPING_NO
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
)
values
(
X_PRICING_ATTRIBUTE_ID
, X_CREATION_DATE
, X_CREATED_BY
, X_LAST_UPDATE_DATE
, X_LAST_UPDATED_BY
, X_LAST_UPDATE_LOGIN
, X_PROGRAM_APPLICATION_ID
, X_PROGRAM_ID
, X_PROGRAM_UPDATE_DATE
, X_REQUEST_ID
, X_LIST_LINE_ID
, X_EXCLUDER_FLAG
, X_ACCUMULATE_FLAG
, X_PRODUCT_ATTRIBUTE_CONTEXT
, X_PRODUCT_ATTRIBUTE
, X_PRODUCT_ATTR_VALUE
, X_PRODUCT_UOM_CODE
, X_PRICING_ATTRIBUTE_CONTEXT
, X_PRICING_ATTRIBUTE
, X_PRICING_ATTR_VALUE_FROM
, X_PRICING_ATTR_VALUE_TO
, X_ATTRIBUTE_GROUPING_NO
, X_CONTEXT
, 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
);
end Insert_Row;
, X_LAST_UPDATE_DATE DATE
, X_LAST_UPDATED_BY NUMBER
, X_LAST_UPDATE_LOGIN NUMBER
, X_PROGRAM_APPLICATION_ID NUMBER
, X_PROGRAM_ID NUMBER
, X_PROGRAM_UPDATE_DATE DATE
, X_REQUEST_ID NUMBER
, X_LIST_LINE_ID NUMBER
, X_EXCLUDER_FLAG VARCHAR2
, X_ACCUMULATE_FLAG VARCHAR2
, X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
, X_PRODUCT_ATTRIBUTE VARCHAR2
, X_PRODUCT_ATTR_VALUE VARCHAR2
, X_PRODUCT_UOM_CODE VARCHAR2
, X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
, X_PRICING_ATTRIBUTE VARCHAR2
, X_PRICING_ATTR_VALUE_FROM VARCHAR2
, X_PRICING_ATTR_VALUE_TO VARCHAR2
, X_ATTRIBUTE_GROUPING_NO NUMBER
, X_CONTEXT VARCHAR2
, 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
) IS
cursor C is select * from QP_PRICING_ATTRIBUTES
where PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID
for update of PRICING_ATTRIBUTE_ID nowait;
FND_MESSAGE.Set_Name('FND','FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATE_DATE = X_LAST_UPDATE_DATE)
OR ( (Recinfo.LAST_UPDATE_DATE IS NULL)
AND (X_LAST_UPDATE_DATE IS NULL)))
AND ( ( Recinfo.LAST_UPDATED_BY = X_LAST_UPDATED_BY)
OR ( (Recinfo.LAST_UPDATED_BY IS NULL)
AND (X_LAST_UPDATED_BY IS NULL)))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN)
OR ( (Recinfo.LAST_UPDATE_LOGIN IS NULL)
AND (X_LAST_UPDATE_LOGIN IS NULL)))
AND ( ( Recinfo.PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID)
OR ( (Recinfo.PROGRAM_APPLICATION_ID IS NULL)
AND (X_PROGRAM_APPLICATION_ID IS NULL)))
AND ( ( Recinfo.PROGRAM_ID = X_PROGRAM_ID)
OR ( (Recinfo.PROGRAM_ID IS NULL)
AND (X_PROGRAM_ID IS NULL)))
AND ( ( Recinfo.PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE)
OR ( (Recinfo.PROGRAM_UPDATE_DATE IS NULL)
AND (X_PROGRAM_UPDATE_DATE IS NULL)))
AND ( ( Recinfo.REQUEST_ID = X_REQUEST_ID )
OR ( (Recinfo.REQUEST_ID IS NULL)
AND (X_REQUEST_ID IS NULL)))
AND ( ( Recinfo.EXCLUDER_FLAG = X_EXCLUDER_FLAG )
OR ( (Recinfo.EXCLUDER_FLAG IS NULL)
AND (X_EXCLUDER_FLAG IS NULL)))
AND ( ( Recinfo.ACCUMULATE_FLAG = X_ACCUMULATE_FLAG )
OR ( (Recinfo.ACCUMULATE_FLAG IS NULL)
AND (X_ACCUMULATE_FLAG IS NULL)))
AND ( ( Recinfo.PRODUCT_ATTRIBUTE_CONTEXT = X_PRODUCT_ATTRIBUTE_CONTEXT )
OR ( (Recinfo.PRODUCT_ATTRIBUTE_CONTEXT IS NULL)
AND (X_PRODUCT_ATTRIBUTE_CONTEXT IS NULL)))
AND ( ( Recinfo.PRODUCT_ATTRIBUTE = X_PRODUCT_ATTRIBUTE )
OR ( (Recinfo.PRODUCT_ATTRIBUTE IS NULL)
AND (X_PRODUCT_ATTRIBUTE IS NULL)))
AND ( ( Recinfo.PRODUCT_ATTR_VALUE = X_PRODUCT_ATTR_VALUE )
OR ( (Recinfo.PRODUCT_ATTR_VALUE IS NULL)
AND (X_PRODUCT_ATTR_VALUE IS NULL)))
AND ( ( Recinfo.PRODUCT_UOM_CODE = X_PRODUCT_UOM_CODE )
OR ( (Recinfo.PRODUCT_UOM_CODE IS NULL)
AND (X_PRODUCT_UOM_CODE IS NULL)))
AND ( ( Recinfo.PRICING_ATTRIBUTE_CONTEXT = X_PRICING_ATTRIBUTE_CONTEXT )
OR ( (Recinfo.PRICING_ATTRIBUTE_CONTEXT IS NULL)
AND (X_PRICING_ATTRIBUTE_CONTEXT IS NULL)))
AND ( ( Recinfo.PRICING_ATTRIBUTE = X_PRICING_ATTRIBUTE )
OR ( (Recinfo.PRICING_ATTRIBUTE IS NULL)
AND (X_PRICING_ATTRIBUTE IS NULL)))
AND ( ( Recinfo.PRICING_ATTR_VALUE_FROM = X_PRICING_ATTR_VALUE_FROM )
OR ( (Recinfo.PRICING_ATTR_VALUE_FROM IS NULL)
AND (X_PRICING_ATTR_VALUE_FROM IS NULL)))
AND ( ( Recinfo.PRICING_ATTR_VALUE_TO = X_PRICING_ATTR_VALUE_TO )
OR ( (Recinfo.PRICING_ATTR_VALUE_TO IS NULL)
AND (X_PRICING_ATTR_VALUE_TO IS NULL)))
AND ( ( Recinfo.ATTRIBUTE_GROUPING_NO = X_ATTRIBUTE_GROUPING_NO )
OR ( (Recinfo.ATTRIBUTE_GROUPING_NO IS NULL)
AND (X_ATTRIBUTE_GROUPING_NO IS NULL)))
AND ( ( Recinfo.CONTEXT = X_CONTEXT )
OR ( (Recinfo.CONTEXT IS NULL)
AND (X_CONTEXT IS NULL)))
AND ( ( Recinfo.ATTRIBUTE1 = X_ATTRIBUTE1 )
OR ( (Recinfo.ATTRIBUTE1 IS NULL)
AND (X_ATTRIBUTE1 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE2 = X_ATTRIBUTE2 )
OR ( (Recinfo.ATTRIBUTE2 IS NULL)
AND (X_ATTRIBUTE2 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE3 = X_ATTRIBUTE3 )
OR ( (Recinfo.ATTRIBUTE3 IS NULL)
AND (X_ATTRIBUTE3 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE4 = X_ATTRIBUTE4 )
OR ( (Recinfo.ATTRIBUTE4 IS NULL)
AND (X_ATTRIBUTE4 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE5 = X_ATTRIBUTE5 )
OR ( (Recinfo.ATTRIBUTE5 IS NULL)
AND (X_ATTRIBUTE5 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE6 = X_ATTRIBUTE6 )
OR ( (Recinfo.ATTRIBUTE6 IS NULL)
AND (X_ATTRIBUTE6 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE7 = X_ATTRIBUTE7 )
OR ( (Recinfo.ATTRIBUTE7 IS NULL)
AND (X_ATTRIBUTE7 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE8 = X_ATTRIBUTE8 )
OR ( (Recinfo.ATTRIBUTE8 IS NULL)
AND (X_ATTRIBUTE8 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE9 = X_ATTRIBUTE9 )
OR ( (Recinfo.ATTRIBUTE9 IS NULL)
AND (X_ATTRIBUTE9 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE10 = X_ATTRIBUTE10 )
OR ( (Recinfo.ATTRIBUTE10 IS NULL)
AND (X_ATTRIBUTE10 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE11 = X_ATTRIBUTE11 )
OR ( (Recinfo.ATTRIBUTE11 IS NULL)
AND (X_ATTRIBUTE11 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE12 = X_ATTRIBUTE12 )
OR ( (Recinfo.ATTRIBUTE12 IS NULL)
AND (X_ATTRIBUTE12 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE13 = X_ATTRIBUTE13 )
OR ( (Recinfo.ATTRIBUTE13 IS NULL)
AND (X_ATTRIBUTE13 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE14 = X_ATTRIBUTE14 )
OR ( (Recinfo.ATTRIBUTE14 IS NULL)
AND (X_ATTRIBUTE14 IS NULL)))
AND ( ( Recinfo.ATTRIBUTE15 = X_ATTRIBUTE15 )
OR ( (Recinfo.ATTRIBUTE15 IS NULL)
AND (X_ATTRIBUTE15 IS NULL)))
) then
return;
PROCEDURE Update_Row(
X_PRICING_ATTRIBUTE_ID IN OUT NUMBER
, X_CREATION_DATE DATE
, X_CREATED_BY NUMBER
, X_LAST_UPDATE_DATE DATE
, X_LAST_UPDATED_BY NUMBER
, X_LAST_UPDATE_LOGIN NUMBER
, X_PROGRAM_APPLICATION_ID NUMBER
, X_PROGRAM_ID NUMBER
, X_PROGRAM_UPDATE_DATE DATE
, X_REQUEST_ID NUMBER
, X_LIST_LINE_ID NUMBER
, X_EXCLUDER_FLAG VARCHAR2
, X_ACCUMULATE_FLAG VARCHAR2
, X_PRODUCT_ATTRIBUTE_CONTEXT VARCHAR2
, X_PRODUCT_ATTRIBUTE VARCHAR2
, X_PRODUCT_ATTR_VALUE VARCHAR2
, X_PRODUCT_UOM_CODE VARCHAR2
, X_PRICING_ATTRIBUTE_CONTEXT VARCHAR2
, X_PRICING_ATTRIBUTE VARCHAR2
, X_PRICING_ATTR_VALUE_FROM VARCHAR2
, X_PRICING_ATTR_VALUE_TO VARCHAR2
, X_ATTRIBUTE_GROUPING_NO NUMBER
, X_CONTEXT VARCHAR2
, 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
) IS
begin
UPDATE QP_PRICING_ATTRIBUTES
SET
PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID
, CREATION_DATE = X_CREATION_DATE
, CREATED_BY = X_CREATED_BY
, LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
, LAST_UPDATED_BY = X_LAST_UPDATED_BY
, LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID = X_PROGRAM_APPLICATION_ID
, PROGRAM_ID = X_PROGRAM_ID
, PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
, REQUEST_ID = X_REQUEST_ID
, LIST_LINE_ID = X_LIST_LINE_ID
, EXCLUDER_FLAG = X_EXCLUDER_FLAG
, ACCUMULATE_FLAG = X_ACCUMULATE_FLAG
, PRODUCT_ATTRIBUTE_CONTEXT = X_PRODUCT_ATTRIBUTE_CONTEXT
, PRODUCT_ATTRIBUTE = X_PRODUCT_ATTRIBUTE
, PRODUCT_ATTR_VALUE = X_PRODUCT_ATTR_VALUE
, PRODUCT_UOM_CODE = X_PRODUCT_UOM_CODE
, PRICING_ATTRIBUTE_CONTEXT = X_PRICING_ATTRIBUTE_CONTEXT
, PRICING_ATTRIBUTE = X_PRICING_ATTRIBUTE
, PRICING_ATTR_VALUE_FROM = X_PRICING_ATTR_VALUE_FROM
, PRICING_ATTR_VALUE_TO = X_PRICING_ATTR_VALUE_TO
, ATTRIBUTE_GROUPING_NO = X_ATTRIBUTE_GROUPING_NO
, CONTEXT = X_CONTEXT
, 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 PRICING_ATTRIBUTE_ID = X_PRICING_ATTRIBUTE_ID;
END Update_Row;
PROCEDURE Delete_Row(
X_LIST_LINE_ID NUMBER
) IS
begin
delete from QP_PRICING_ATTRIBUTES
where LIST_LINE_ID = LIST_LINE_ID;
END Delete_Row;