[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Transaction_Header_Id IN OUT NOCOPY NUMBER,
X_Book_Type_Code VARCHAR2,
X_Asset_Id NUMBER,
X_Transaction_Type_Code VARCHAR2,
X_Transaction_Date_Entered DATE,
X_Date_Effective DATE,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Transaction_Name VARCHAR2 DEFAULT NULL,
X_Invoice_Transaction_Id NUMBER DEFAULT NULL,
X_Source_Transaction_Header_Id NUMBER DEFAULT NULL,
X_Mass_Reference_Id NUMBER DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Transaction_Subtype VARCHAR2 DEFAULT NULL,
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_Code VARCHAR2 DEFAULT NULL,
X_Transaction_Key VARCHAR2 DEFAULT NULL,
X_Amortization_Start_Date DATE DEFAULT NULL,
X_Calling_Interface VARCHAR2 DEFAULT NULL,
X_Mass_Transaction_ID NUMBER DEFAULT NULL,
X_Member_Transaction_Header_Id NUMBER DEFAULT NULL,
X_Trx_Reference_Id NUMBER DEFAULT NULL,
X_Event_Id NUMBER DEFAULT NULL,
X_Return_Status OUT NOCOPY BOOLEAN,
X_Calling_Fn VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
CURSOR C IS SELECT rowid FROM fa_transaction_headers
WHERE transaction_header_id = X_Transaction_Header_Id;
CURSOR C2 IS SELECT fa_transaction_headers_s.nextval FROM dual;
INSERT INTO fa_transaction_headers(
transaction_header_id,
book_type_code,
asset_id,
transaction_type_code,
transaction_date_entered,
date_effective,
last_update_date,
last_updated_by,
transaction_name,
invoice_transaction_id,
source_transaction_header_id,
mass_reference_id,
last_update_login,
transaction_subtype,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category_code,
transaction_key,
amortization_start_date,
calling_interface,
mass_transaction_id,
member_transaction_header_id,
trx_reference_id,
event_id
) VALUES (
X_Transaction_Header_Id,
X_Book_Type_Code,
X_Asset_Id,
X_Transaction_Type_Code,
X_Transaction_Date_Entered,
X_Date_Effective,
X_Last_Update_Date,
X_Last_Updated_By,
X_Transaction_Name,
X_Invoice_Transaction_Id,
X_Source_Transaction_Header_Id,
X_Mass_Reference_Id,
X_Last_Update_Login,
X_Transaction_Subtype,
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,
X_Attribute_Category_Code,
X_Transaction_Key,
X_Amortization_Start_Date,
X_Calling_Interface,
X_Mass_Transaction_ID,
X_Member_Transaction_Header_Id,
X_Trx_Reference_Id,
X_Event_Id
);
if (X_Calling_Fn = 'fa_unp_dep_pkg.on_insert') then
-- Unplanned depreciation is called from form, not from
-- transaction engine.
FA_STANDARD_PKG.RAISE_ERROR(
CALLED_FN => 'fa_transaction_headers_pkg.insert_row',
CALLING_FN => X_Calling_Fn
,p_log_level_rec => p_log_level_rec);
CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Insert_Row'
,p_log_level_rec => p_log_level_rec);
END Insert_Row;
SELECT transaction_header_id,
book_type_code,
asset_id,
transaction_type_code,
transaction_date_entered,
date_effective,
last_update_date,
last_updated_by,
transaction_name,
invoice_transaction_id,
source_transaction_header_id,
mass_reference_id,
last_update_login,
transaction_subtype,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
attribute11,
attribute12,
attribute13,
attribute14,
attribute15,
attribute_category_code,
transaction_key,
amortization_start_date,
calling_interface,
mass_transaction_id,
member_transaction_header_id,
trx_reference_id,
event_id
FROM fa_transaction_headers
WHERE rowid = X_Rowid
FOR UPDATE of Transaction_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(
X_Rowid VARCHAR2,
X_Transaction_Header_Id NUMBER DEFAULT NULL,
X_Book_Type_Code VARCHAR2 DEFAULT NULL,
X_Asset_Id NUMBER DEFAULT NULL,
X_Transaction_Type_Code VARCHAR2 DEFAULT NULL,
X_Transaction_Date_Entered DATE DEFAULT NULL,
X_Date_Effective DATE DEFAULT NULL,
X_Last_Update_Date DATE DEFAULT NULL,
X_Last_Updated_By NUMBER DEFAULT NULL,
X_Transaction_Name VARCHAR2 DEFAULT NULL,
X_Invoice_Transaction_Id NUMBER DEFAULT NULL,
X_Source_Transaction_Header_Id NUMBER DEFAULT NULL,
X_Mass_Reference_Id NUMBER DEFAULT NULL,
X_Last_Update_Login NUMBER DEFAULT NULL,
X_Transaction_Subtype VARCHAR2 DEFAULT NULL,
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_Code VARCHAR2 DEFAULT NULL,
X_Transaction_Key VARCHAR2 DEFAULT NULL,
X_Amortization_Start_Date DATE DEFAULT NULL,
X_Calling_Interface VARCHAR2 DEFAULT NULL,
X_Mass_Transaction_Id NUMBER DEFAULT NULL,
X_Member_Transaction_Header_Id NUMBER DEFAULT NULL,
X_Trx_Reference_Id NUMBER DEFAULT NULL,
X_Event_id NUMBER DEFAULT NULL,
X_Calling_Fn VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
BEGIN
UPDATE fa_transaction_headers
SET
transaction_header_id
= decode(X_Transaction_Header_Id,
NULL, transaction_header_id,
FND_API.G_MISS_NUM, null,
X_Transaction_Header_Id),
book_type_code = decode(X_Book_Type_Code,
NULL, book_type_code,
FND_API.G_MISS_CHAR, null,
X_Book_Type_Code),
asset_id = decode(X_Asset_Id,
NULL, asset_id,
FND_API.G_MISS_NUM, null,
X_Asset_Id),
transaction_type_code
= decode(X_Transaction_Type_Code,
NULL, transaction_type_code,
FND_API.G_MISS_CHAR, null,
X_Transaction_Type_Code),
transaction_date_entered
= decode(X_Transaction_Date_Entered,
NULL, transaction_date_entered,
X_Transaction_Date_Entered),
date_effective = decode(X_Date_Effective,
NULL, date_effective,
X_Date_Effective),
last_update_date = decode(X_Last_Update_Date,
NULL, last_update_date,
X_Last_Update_Date),
last_updated_by = decode(X_Last_Updated_By,
NULL, last_updated_by,
FND_API.G_MISS_NUM, null,
X_Last_Updated_By),
transaction_name = decode(X_Transaction_Name,
NULL, transaction_name,
FND_API.G_MISS_CHAR, null,
X_Transaction_Name),
invoice_transaction_id
= decode(X_Invoice_Transaction_Id,
NULL, invoice_transaction_id,
FND_API.G_MISS_NUM, null,
X_Invoice_Transaction_Id),
source_transaction_header_id
= decode(X_Source_Transaction_Header_Id,
NULL, source_transaction_header_id,
FND_API.G_MISS_NUM, null,
X_Source_Transaction_Header_Id),
mass_reference_id = decode(X_Mass_Reference_Id,
NULL, mass_reference_id,
FND_API.G_MISS_NUM, null,
X_Mass_Reference_Id),
last_update_login = decode(X_Last_Update_Login,
NULL, last_update_login,
FND_API.G_MISS_NUM, null,
X_Last_Update_Login),
transaction_subtype
= decode(X_Transaction_Subtype,
NULL, transaction_subtype,
FND_API.G_MISS_CHAR, null,
X_Transaction_Subtype),
attribute1 = decode(X_Attribute1,
NULL, attribute1,
FND_API.G_MISS_CHAR, null,
X_Attribute1),
attribute2 = decode(X_Attribute2,
NULL, attribute2,
FND_API.G_MISS_CHAR, null,
X_Attribute2),
attribute3 = decode(X_Attribute3,
NULL, attribute3,
FND_API.G_MISS_CHAR, null,
X_Attribute3),
attribute4 = decode(X_Attribute4,
NULL, attribute4,
FND_API.G_MISS_CHAR, null,
X_Attribute4),
attribute5 = decode(X_Attribute5,
NULL, attribute5,
FND_API.G_MISS_CHAR, null,
X_Attribute5),
attribute6 = decode(X_Attribute6,
NULL, attribute6,
FND_API.G_MISS_CHAR, null,
X_Attribute6),
attribute7 = decode(X_Attribute7,
NULL, attribute7,
FND_API.G_MISS_CHAR, null,
X_Attribute7),
attribute8 = decode(X_Attribute8,
NULL, attribute8,
FND_API.G_MISS_CHAR, null,
X_Attribute8),
attribute9 = decode(X_Attribute9,
NULL, attribute9,
FND_API.G_MISS_CHAR, null,
X_Attribute9),
attribute10 = decode(X_Attribute10,
NULL, attribute10,
FND_API.G_MISS_CHAR, null,
X_Attribute10),
attribute11 = decode(X_Attribute11,
NULL, attribute11,
FND_API.G_MISS_CHAR, null,
X_Attribute11),
attribute12 = decode(X_Attribute12,
NULL, attribute12,
FND_API.G_MISS_CHAR, null,
X_Attribute12),
attribute13 = decode(X_Attribute13,
NULL, attribute13,
FND_API.G_MISS_CHAR, null,
X_Attribute13),
attribute14 = decode(X_Attribute14,
NULL, attribute14,
FND_API.G_MISS_CHAR, null,
X_Attribute14),
attribute15 = decode(X_Attribute15,
NULL, attribute15,
FND_API.G_MISS_CHAR, null,
X_Attribute15),
attribute_category_code
= decode(X_Attribute_Category_Code,
NULL, attribute_category_code,
FND_API.G_MISS_CHAR, null,
X_Attribute_Category_Code),
transaction_key = decode(X_Transaction_Key,
NULL, transaction_key,
FND_API.G_MISS_CHAR, null,
X_Transaction_Key),
amortization_start_date
= decode(X_Amortization_Start_Date,
NULL, amortization_start_date,
X_Amortization_Start_Date),
calling_interface = decode(X_Calling_Interface,
NULL, calling_interface,
FND_API.G_MISS_CHAR, null,
X_Calling_Interface),
mass_transaction_id = decode(X_mass_transaction_id,
NULL, mass_transaction_id,
FND_API.G_MISS_NUM, null,
X_Mass_transaction_id),
member_transaction_header_id = decode(X_Member_Transaction_Header_Id,
NULL, member_transaction_header_id,
FND_API.G_MISS_NUM, null,
X_Member_Transaction_Header_Id),
trx_reference_id = decode(X_Trx_Reference_Id,
NULL, trx_reference_id,
FND_API.G_MISS_NUM, null,
X_Trx_Reference_Id),
event_id = decode(X_event_id,
NULL, event_id,
FND_API.G_MISS_NUM, null,
X_event_id)
WHERE rowid = X_Rowid;
CALLED_FN => 'fa_transaction_headers_pkg.update_row',
CALLING_FN => X_Calling_Fn
,p_log_level_rec => p_log_level_rec);
END Update_Row;
PROCEDURE Update_Trx_Type(X_Book_Type_Code VARCHAR2,
X_Asset_Id NUMBER,
X_Transaction_Type_Code VARCHAR2,
X_New_Transaction_Type VARCHAR2,
X_Return_Status OUT NOCOPY BOOLEAN,
X_Calling_Fn VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
BEGIN
Update fa_transaction_headers
set transaction_type_code = X_New_Transaction_Type
where asset_id = X_Asset_Id
and book_type_code = X_Book_Type_Code
and transaction_type_code = X_Transaction_Type_Code;
CALLING_FN => 'FA_TRANSACTION_HEADERS_PKG.Update_Trx_Type'
,p_log_level_rec => p_log_level_rec);
END Update_Trx_Type;
PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
X_Transaction_Header_Id NUMBER DEFAULT NULL,
X_Asset_Id NUMBER DEFAULT NULL,
X_Transaction_Type_Code VARCHAR2 DEFAULT NULL,
X_Calling_Fn VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
BEGIN
if X_Rowid is not null then
DELETE FROM fa_transaction_headers
WHERE rowid = X_Rowid;
DELETE FROM fa_transaction_headers
WHERE transaction_header_id = X_Transaction_Header_Id;
DELETE FROM fa_transaction_headers
WHERE asset_id = X_Asset_Id
and transaction_type_code =
nvl(X_Transaction_Type_Code, transaction_type_code);
CALLED_FN => 'fa_transaction_headers_pkg.delete_row',
CALLING_FN => X_Calling_Fn
,p_log_level_rec => p_log_level_rec);
END Delete_Row;