[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
X_Price_Update_Tolerance NUMBER,
X_Global_Attribute_Category VARCHAR2,
X_Global_Attribute1 VARCHAR2,
X_Global_Attribute2 VARCHAR2,
X_Global_Attribute3 VARCHAR2,
X_Global_Attribute4 VARCHAR2,
X_Global_Attribute5 VARCHAR2,
X_Global_Attribute6 VARCHAR2,
X_Global_Attribute7 VARCHAR2,
X_Global_Attribute8 VARCHAR2,
X_Global_Attribute9 VARCHAR2,
X_Global_Attribute10 VARCHAR2,
X_Global_Attribute11 VARCHAR2,
X_Global_Attribute12 VARCHAR2,
X_Global_Attribute13 VARCHAR2,
X_Global_Attribute14 VARCHAR2,
X_Global_Attribute15 VARCHAR2,
X_Global_Attribute16 VARCHAR2,
X_Global_Attribute17 VARCHAR2,
X_Global_Attribute18 VARCHAR2,
X_Global_Attribute19 VARCHAR2,
X_Global_Attribute20 VARCHAR2,
x_new_print_count OUT NOCOPY NUMBER,
x_new_printed_date OUT NOCOPY DATE,
p_shipping_control IN VARCHAR2 --
,p_conterms_exist_flag IN VARCHAR2 --
,p_encumbrance_required_flag IN VARCHAR2 --
) IS
CURSOR C IS
SELECT *
FROM PO_HEADERS
WHERE rowid = X_Rowid
FOR UPDATE of Po_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
AND ( (Recinfo.Price_Update_Tolerance = X_Price_Update_Tolerance)
OR ( (Recinfo.Price_Update_Tolerance IS NULL)
AND (X_Price_Update_Tolerance IS NULL)))
AND ( (TRIM(Recinfo.global_attribute_category) = TRIM(X_Global_Attribute_Category))
OR ( (TRIM(Recinfo.global_attribute_category) IS NULL)
AND (TRIM(X_Global_Attribute_Category) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute1) = TRIM(X_Global_Attribute1))
OR ( (TRIM(Recinfo.global_attribute1) IS NULL)
AND (TRIM(X_Global_Attribute1) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute2) = TRIM(X_Global_Attribute2))
OR ( (TRIM(Recinfo.global_attribute2) IS NULL)
AND (TRIM(X_Global_Attribute2) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute3) = TRIM(X_Global_Attribute3))
OR ( (TRIM(Recinfo.global_attribute3) IS NULL)
AND (TRIM(X_Global_Attribute3) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute4) = TRIM(X_Global_Attribute4))
OR ( (TRIM(Recinfo.global_attribute4) IS NULL)
AND (TRIM(X_Global_Attribute4) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute5) = TRIM(X_Global_Attribute5))
OR ( (TRIM(Recinfo.global_attribute5) IS NULL)
AND (TRIM(X_Global_Attribute5) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute6) = TRIM(X_Global_Attribute6))
OR ( (TRIM(Recinfo.global_attribute6) IS NULL)
AND (TRIM(X_Global_Attribute6) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute7) = TRIM(X_Global_Attribute7))
OR ( (TRIM(Recinfo.global_attribute7) IS NULL)
AND (TRIM(X_Global_Attribute7) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute8) = TRIM(X_Global_Attribute8))
OR ( (TRIM(Recinfo.global_attribute8) IS NULL)
AND (TRIM(X_Global_Attribute8) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute9) = TRIM(X_Global_Attribute9))
OR ( (TRIM(Recinfo.global_attribute9) IS NULL)
AND (TRIM(X_Global_Attribute9) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute10) = TRIM(X_Global_Attribute10))
OR ( (TRIM(Recinfo.global_attribute10) IS NULL)
AND (TRIM(X_Global_Attribute10) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute11) = TRIM(X_Global_Attribute11))
OR ( (TRIM(Recinfo.global_attribute11) IS NULL)
AND (TRIM(X_Global_Attribute11) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute12) = TRIM(X_Global_Attribute12))
OR ( (TRIM(Recinfo.global_attribute12) IS NULL)
AND (TRIM(X_Global_Attribute12) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute13) = TRIM(X_Global_Attribute13))
OR ( (TRIM(Recinfo.global_attribute13) IS NULL)
AND (TRIM(X_Global_Attribute13) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute14) = TRIM(X_Global_Attribute14))
OR ( (TRIM(Recinfo.global_attribute14) IS NULL)
AND (TRIM(X_Global_Attribute14) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute15) = TRIM(X_Global_Attribute15))
OR ( (TRIM(Recinfo.global_attribute15) IS NULL)
AND (TRIM(X_Global_Attribute15) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute16)= TRIM(X_Global_Attribute16))
OR ( (TRIM(Recinfo.global_attribute16) IS NULL)
AND (TRIM(X_Global_Attribute16) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute17) = TRIM(X_Global_Attribute17))
OR ( (TRIM(Recinfo.global_attribute17) IS NULL)
AND (TRIM(X_Global_Attribute17) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute18) = TRIM(X_Global_Attribute18))
OR ( (TRIM(Recinfo.global_attribute18) IS NULL)
AND (TRIM(X_Global_Attribute18) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute19) = TRIM(X_Global_Attribute19))
OR ( (TRIM(Recinfo.global_attribute19) IS NULL)
AND (TRIM(X_Global_Attribute19) IS NULL)))
AND ( (TRIM(Recinfo.global_attribute20) = TRIM(X_Global_Attribute20))
OR ( (TRIM(Recinfo.global_attribute20) IS NULL)
AND (TRIM(X_Global_Attribute20) IS NULL)))
) then
-- Bug 2701425. If print_count and printed_date are different, then
-- update the new parameters with the values from the database.
IF (nvl(recinfo.print_count,-99) <> nvl(x_print_count,-99)) THEN
x_new_print_count := recinfo.print_count;
IF (NVL(X_Price_Update_Tolerance,-999) <> NVL(Recinfo.price_update_tolerance,-999)) THEN
FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_module_prefix || l_api_name,' Form price_update_tolerance'||X_Price_Update_Tolerance ||' Database price_update_tolerance '|| Recinfo.price_update_tolerance);
IF (NVL(X_Price_Update_Tolerance,-999) <> NVL(Recinfo.price_update_tolerance,-999)) THEN
FND_LOG.string(FND_LOG.LEVEL_STATEMENT,g_module_prefix || l_api_name,' Form price_update_tolerance'||X_Price_Update_Tolerance ||' Database price_update_tolerance '|| Recinfo.price_update_tolerance);