The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
X_Transfer_Header_Id NUMBER,
X_Distribution_Id NUMBER,
X_Book_Header_Id NUMBER,
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_transfer_details
WHERE transfer_header_id = X_Transfer_Header_Id
AND distribution_id = X_Distribution_Id;
INSERT INTO fa_transfer_details(
transfer_header_id,
distribution_id,
book_header_id
) VALUES (
X_Transfer_Header_Id,
X_Distribution_Id,
X_Book_Header_Id
);
calling_fn => 'FA_TRANSFER_DETAILS_PKG.insert_row'
,p_log_level_rec => p_log_level_rec);
(Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Insert_Row',
Calling_Fn => X_Calling_Fn
,p_log_level_rec => p_log_level_rec); */
END Insert_Row;
SELECT transfer_header_id,
distribution_id,
book_header_id
FROM fa_transfer_details
WHERE rowid = X_Rowid
FOR UPDATE of Transfer_Header_Id NOWAIT;
FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Transfer_Header_Id NUMBER,
X_Distribution_Id NUMBER,
X_Book_Header_Id NUMBER,
X_Calling_Fn VARCHAR2,
p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
BEGIN
UPDATE fa_transfer_details
SET
transfer_header_id = X_Transfer_Header_Id,
distribution_id = X_Distribution_Id,
book_header_id = X_Book_Header_Id
WHERE rowid = X_Rowid;
calling_fn => 'FA_TRANSFER_DETAILS_PKG.update_row'
,p_log_level_rec => p_log_level_rec);
(Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Update_Row',
Calling_Fn => X_Calling_Fn
,p_log_level_rec => p_log_level_rec); */
END Update_Row;
PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
X_Transfer_Header_Id NUMBER 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_transfer_details
WHERE rowid = X_Rowid;
DELETE FROM fa_transfer_details
WHERE transfer_header_id = X_Transfer_Header_Id;
calling_fn => 'FA_TRANSFER_DETAILS_PKG.delete_row'
,p_log_level_rec => p_log_level_rec);
(Called_Fn => 'FA_TRANSFER_DETAILS_PKG.Delete_Row',
Calling_Fn => X_Calling_Fn
,p_log_level_rec => p_log_level_rec); */
END Delete_Row;