[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT *
FROM GL_INTERFACE
WHERE rowid = X_Rowid
FOR UPDATE of User_Je_Source_Name NOWAIT;
SELECT upper(nvl(max(syn.table_name),'')),
upper(nvl(max(syn.table_owner),''))
INTO syntname, syntown
FROM user_synonyms syn
WHERE syn.synonym_name = upper(Itable);
SELECT upper(Itable), upper(nvl(max(usr.oracle_username),''))
INTO syntname, syntown
FROM fnd_responsibility resp, fnd_data_group_units dg,
fnd_oracle_userid usr
WHERE resp.application_id = Resp_appl_id
AND resp.responsibility_id = Resp_id
AND dg.application_id = resp.data_group_application_id
AND dg.data_group_id = resp.data_group_id
AND usr.oracle_id = dg.oracle_id;
SELECT nvl(sum(decode(column_name, 'LEDGER_ID', 10,
'SET_OF_BOOKS_ID', 1)),10)
INTO ledger_column_num
FROM dba_tab_columns tab
WHERE tab.table_name = syntname
AND tab.owner = syntown;
lgrstr := 'SELECT '|| Ledger_Column_Name || ' ' ||
'FROM ' || Itable || ' ' ||
'WHERE rowid = :X_Rowid ';
PROCEDURE Insert_Budget_Transfer_Row(
X_From_Rowid IN OUT NOCOPY VARCHAR2,
X_To_Rowid IN OUT NOCOPY VARCHAR2,
X_Status VARCHAR2,
X_Ledger_Id NUMBER,
X_User_Je_Source_Name VARCHAR2,
X_Group_Id NUMBER,
X_User_Je_Category_Name VARCHAR2,
X_Budget_Version_Id NUMBER,
X_Je_Batch_Name VARCHAR2,
X_Currency_Code VARCHAR2,
X_From_Code_Combination_Id NUMBER,
X_To_Code_Combination_Id NUMBER,
X_Combination_Number NUMBER,
X_Period_Name VARCHAR2,
X_From_Entered_Dr NUMBER,
X_From_Entered_Cr NUMBER,
X_To_Entered_Dr NUMBER,
X_To_Entered_Cr NUMBER,
X_Date_Created DATE,
X_Created_By NUMBER
) IS
CURSOR C (ccid IN NUMBER, unique_value IN VARCHAR2) IS
SELECT rowid FROM GL_INTERFACE
WHERE user_je_source_name = X_User_Je_Source_Name
AND group_id = X_Group_Id
AND ledger_id = X_Ledger_Id
AND status_description = unique_value
AND code_combination_id = ccid
AND je_batch_id = X_Combination_Number
AND period_name = X_Period_Name;
INSERT INTO GL_INTERFACE(
status,
ledger_id,
user_je_source_name,
user_je_category_name,
accounting_date,
currency_code,
date_created,
created_by,
actual_flag,
budget_version_id,
entered_dr,
entered_cr,
reference1,
group_id,
period_name,
je_batch_id,
status_description,
code_combination_id
) VALUES (
X_Status,
X_Ledger_Id,
X_User_Je_Source_Name,
X_User_Je_Category_Name,
sysdate,
X_Currency_Code,
X_Date_Created,
X_Created_By,
'B',
X_Budget_Version_Id,
X_From_Entered_Dr,
X_From_Entered_Cr,
X_Je_Batch_Name,
X_Group_Id,
X_Period_Name,
X_Combination_Number,
'New Budget Transfer Row',
X_From_Code_Combination_Id);
INSERT INTO GL_INTERFACE(
status,
ledger_id,
user_je_source_name,
user_je_category_name,
accounting_date,
currency_code,
date_created,
created_by,
actual_flag,
budget_version_id,
entered_dr,
entered_cr,
reference1,
group_id,
period_name,
je_batch_id,
status_description,
code_combination_id
) VALUES (
X_Status,
X_Ledger_Id,
X_User_Je_Source_Name,
X_User_Je_Category_Name,
sysdate,
X_Currency_Code,
X_Date_Created,
X_Created_By,
'B',
X_Budget_Version_Id,
X_To_Entered_Dr,
X_To_Entered_Cr,
X_Je_Batch_Name,
X_Group_Id,
X_Period_Name,
X_Combination_Number,
X_From_RowId,
X_To_Code_Combination_Id);
UPDATE GL_INTERFACE
SET status_description = X_To_RowId
WHERE user_je_source_name = X_User_Je_Source_Name
AND group_id = X_Group_Id
AND ledger_id = X_Ledger_Id
AND status_description = 'New Budget Transfer Row'
AND code_combination_id = X_From_Code_Combination_Id
AND je_batch_id = X_Combination_Number
AND period_name = X_Period_Name;
END Insert_Budget_Transfer_Row;
PROCEDURE Update_Budget_Transfer_Row(
X_From_Rowid VARCHAR2,
X_To_Rowid VARCHAR2,
X_Status VARCHAR2,
X_Ledger_Id NUMBER,
X_User_Je_Source_Name VARCHAR2,
X_Group_Id NUMBER,
X_User_Je_Category_Name VARCHAR2,
X_Budget_Version_Id NUMBER,
X_Je_Batch_Name VARCHAR2,
X_Currency_Code VARCHAR2,
X_From_Code_Combination_Id NUMBER,
X_To_Code_Combination_Id NUMBER,
X_Combination_Number NUMBER,
X_Period_Name VARCHAR2,
X_From_Entered_Dr NUMBER,
X_From_Entered_Cr NUMBER,
X_To_Entered_Dr NUMBER,
X_To_Entered_Cr NUMBER
) IS
BEGIN
UPDATE GL_INTERFACE
SET
status = X_Status,
ledger_id = X_Ledger_Id,
user_je_source_name = X_User_Je_Source_Name,
group_id = X_Group_Id,
user_je_category_name = X_User_Je_Category_Name,
actual_flag = 'B',
budget_version_id = X_Budget_Version_Id,
reference1 = X_Je_Batch_Name,
currency_code = X_Currency_Code,
code_combination_id = decode(rowid,
X_From_Rowid, X_From_Code_Combination_Id,
X_To_Rowid, X_To_Code_Combination_Id),
je_batch_id = X_Combination_Number,
period_name = X_Period_Name,
entered_dr = decode(rowid,
X_From_Rowid, X_From_Entered_Dr,
X_To_Rowid, X_To_Entered_Dr),
entered_cr = decode(rowid,
X_From_Rowid, X_From_Entered_Cr,
X_To_Rowid, X_To_Entered_Cr)
WHERE rowid IN (X_From_Rowid, X_To_RowId);
END Update_Budget_Transfer_Row;
PROCEDURE Delete_Budget_Transfer_Row(X_From_Rowid VARCHAR2,
X_To_Rowid VARCHAR2) IS
BEGIN
DELETE FROM GL_INTERFACE
WHERE rowid IN (X_From_Rowid, X_To_Rowid);
END Delete_Budget_Transfer_Row;
PROCEDURE delete_rows(x_ledger_id NUMBER,
x_user_je_source_name VARCHAR2,
x_group_id NUMBER DEFAULT NULL,
x_je_batch_id NUMBER DEFAULT NULL) IS
BEGIN
DELETE gl_interface
WHERE ledger_id = x_ledger_id
AND user_je_source_name = x_user_je_source_name
AND nvl(group_id,-1) = nvl(x_group_id, -1)
AND nvl(je_batch_id, -1) = nvl(x_je_batch_id, nvl(je_batch_id, -1));
END delete_rows;
SELECT 'Has data'
FROM dual
WHERE EXISTS (SELECT 'Has data'
FROM gl_interface
WHERE ledger_id = x_ledger_id
AND user_je_source_name = x_user_je_source_name
AND group_id = x_group_id);
sqlstmt := 'select
STATUS,
decode(LEDGER_ID, -1, SET_OF_BOOKS_ID, LEDGER_ID),
ACCOUNTING_DATE,
CURRENCY_CODE,
DATE_CREATED,
CREATED_BY,
ACTUAL_FLAG,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
CURRENCY_CONVERSION_DATE,
ENCUMBRANCE_TYPE_ID,
BUDGET_VERSION_ID,
USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
SEGMENT8,
SEGMENT9,
SEGMENT10,
SEGMENT11,
SEGMENT12,
SEGMENT13,
SEGMENT14,
SEGMENT15,
SEGMENT16,
SEGMENT17,
SEGMENT18,
SEGMENT19,
SEGMENT20,
SEGMENT21,
SEGMENT22,
SEGMENT23,
SEGMENT24,
SEGMENT25,
SEGMENT26,
SEGMENT27,
SEGMENT28,
SEGMENT29,
SEGMENT30,
ENTERED_DR,
ENTERED_CR,
ACCOUNTED_DR,
ACCOUNTED_CR,
REFERENCE1,
REFERENCE2,
REFERENCE3,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE9,
REFERENCE10,
REFERENCE11,
REFERENCE12,
REFERENCE13,
REFERENCE14,
REFERENCE15,
REFERENCE16,
REFERENCE17,
REFERENCE18,
REFERENCE19,
REFERENCE20,
REFERENCE21,
REFERENCE22,
REFERENCE23,
REFERENCE24,
REFERENCE25,
REFERENCE26,
REFERENCE27,
REFERENCE28,
REFERENCE29,
REFERENCE30,
PERIOD_NAME,
CODE_COMBINATION_ID,
STAT_AMOUNT,
GROUP_ID,
SUBLEDGER_DOC_SEQUENCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
CONTEXT,
CONTEXT2,
INVOICE_DATE,
TAX_CODE,
INVOICE_IDENTIFIER,
INVOICE_AMOUNT,
CONTEXT3,
USSGL_TRANSACTION_CODE,
JGZZ_RECON_REF,
AVERAGE_JOURNAL_FLAG,
ORIGINATING_BAL_SEG_VALUE,
GL_SL_LINK_ID,
GL_SL_LINK_TABLE
from ' || X_ITABLE ||
' where ROWID = :X_ROWID
for update of USER_JE_SOURCE_NAME nowait';
procedure UPDATE_ROW (
X_ROWID in VARCHAR2,
X_ITABLE in VARCHAR2,
X_STATUS in VARCHAR2,
X_LEDGER_ID in NUMBER,
X_ACCOUNTING_DATE in DATE,
X_CURRENCY_CODE in VARCHAR2,
X_DATE_CREATED in DATE,
X_CREATED_BY in NUMBER,
X_ACTUAL_FLAG in VARCHAR2,
X_USER_JE_CATEGORY_NAME in VARCHAR2,
X_USER_JE_SOURCE_NAME in VARCHAR2,
X_CURRENCY_CONVERSION_DATE in DATE,
X_ENCUMBRANCE_TYPE_ID in NUMBER,
X_BUDGET_VERSION_ID in NUMBER,
X_USER_CURRENCY_CONV_TYPE in VARCHAR2,
X_CURRENCY_CONVERSION_RATE in NUMBER,
X_AVERAGE_JOURNAL_FLAG in VARCHAR2,
X_SEGMENT1 in VARCHAR2,
X_SEGMENT2 in VARCHAR2,
X_SEGMENT3 in VARCHAR2,
X_SEGMENT4 in VARCHAR2,
X_SEGMENT5 in VARCHAR2,
X_SEGMENT6 in VARCHAR2,
X_SEGMENT7 in VARCHAR2,
X_SEGMENT8 in VARCHAR2,
X_SEGMENT9 in VARCHAR2,
X_SEGMENT10 in VARCHAR2,
X_SEGMENT11 in VARCHAR2,
X_SEGMENT12 in VARCHAR2,
X_SEGMENT13 in VARCHAR2,
X_SEGMENT14 in VARCHAR2,
X_SEGMENT15 in VARCHAR2,
X_SEGMENT16 in VARCHAR2,
X_SEGMENT17 in VARCHAR2,
X_SEGMENT18 in VARCHAR2,
X_SEGMENT19 in VARCHAR2,
X_SEGMENT20 in VARCHAR2,
X_SEGMENT21 in VARCHAR2,
X_SEGMENT22 in VARCHAR2,
X_SEGMENT23 in VARCHAR2,
X_SEGMENT24 in VARCHAR2,
X_SEGMENT25 in VARCHAR2,
X_SEGMENT26 in VARCHAR2,
X_SEGMENT27 in VARCHAR2,
X_SEGMENT28 in VARCHAR2,
X_SEGMENT29 in VARCHAR2,
X_SEGMENT30 in VARCHAR2,
X_ENTERED_DR in NUMBER,
X_ENTERED_CR in NUMBER,
X_ACCOUNTED_DR in NUMBER,
X_ACCOUNTED_CR in NUMBER,
X_REFERENCE1 in VARCHAR2,
X_REFERENCE2 in VARCHAR2,
X_REFERENCE3 in VARCHAR2,
X_REFERENCE4 in VARCHAR2,
X_REFERENCE5 in VARCHAR2,
X_REFERENCE6 in VARCHAR2,
X_REFERENCE7 in VARCHAR2,
X_REFERENCE8 in VARCHAR2,
X_REFERENCE9 in VARCHAR2,
X_REFERENCE10 in VARCHAR2,
X_REFERENCE11 in VARCHAR2,
X_REFERENCE12 in VARCHAR2,
X_REFERENCE13 in VARCHAR2,
X_REFERENCE14 in VARCHAR2,
X_REFERENCE15 in VARCHAR2,
X_REFERENCE16 in VARCHAR2,
X_REFERENCE17 in VARCHAR2,
X_REFERENCE18 in VARCHAR2,
X_REFERENCE19 in VARCHAR2,
X_REFERENCE20 in VARCHAR2,
X_REFERENCE21 in VARCHAR2,
X_REFERENCE22 in VARCHAR2,
X_REFERENCE23 in VARCHAR2,
X_REFERENCE24 in VARCHAR2,
X_REFERENCE25 in VARCHAR2,
X_REFERENCE26 in VARCHAR2,
X_REFERENCE27 in VARCHAR2,
X_REFERENCE28 in VARCHAR2,
X_REFERENCE29 in VARCHAR2,
X_REFERENCE30 in VARCHAR2,
X_PERIOD_NAME in VARCHAR2,
X_CODE_COMBINATION_ID in NUMBER,
X_STAT_AMOUNT in NUMBER,
X_GROUP_ID in NUMBER,
X_REQUEST_ID in NUMBER,
X_SUBLEDGER_DOC_SEQUENCE_ID in NUMBER,
X_SUBLEDGER_DOC_SEQUENCE_VALUE in NUMBER,
X_ATTRIBUTE1 in VARCHAR2,
X_ATTRIBUTE2 in VARCHAR2,
X_ATTRIBUTE3 in VARCHAR2,
X_ATTRIBUTE4 in VARCHAR2,
X_ATTRIBUTE5 in VARCHAR2,
X_ATTRIBUTE6 in VARCHAR2,
X_ATTRIBUTE7 in VARCHAR2,
X_ATTRIBUTE8 in VARCHAR2,
X_ATTRIBUTE9 in VARCHAR2,
X_ATTRIBUTE10 in VARCHAR2,
X_ATTRIBUTE11 in VARCHAR2,
X_ATTRIBUTE12 in VARCHAR2,
X_ATTRIBUTE13 in VARCHAR2,
X_ATTRIBUTE14 in VARCHAR2,
X_ATTRIBUTE15 in VARCHAR2,
X_ATTRIBUTE16 in VARCHAR2,
X_ATTRIBUTE17 in VARCHAR2,
X_ATTRIBUTE18 in VARCHAR2,
X_ATTRIBUTE19 in VARCHAR2,
X_ATTRIBUTE20 in VARCHAR2,
X_CONTEXT in VARCHAR2,
X_CONTEXT2 in VARCHAR2,
X_INVOICE_DATE in DATE,
X_TAX_CODE in VARCHAR2,
X_INVOICE_IDENTIFIER in VARCHAR2,
X_INVOICE_AMOUNT in NUMBER,
X_CONTEXT3 in VARCHAR2,
X_USSGL_TRANSACTION_CODE in VARCHAR2,
X_JGZZ_RECON_REF in VARCHAR2,
X_ORIGINATING_BAL_SEG_VALUE in VARCHAR2,
X_GL_SL_LINK_ID in NUMBER,
X_GL_SL_LINK_TABLE in VARCHAR2
) IS
sqlstmt VARCHAR2(10000);
'update ' || X_ITABLE || ' set
STATUS = :X_STATUS,
LEDGER_ID = :X_LEDGER_ID,
ACCOUNTING_DATE = :X_ACCOUNTING_DATE,
CURRENCY_CODE = :X_CURRENCY_CODE,
DATE_CREATED = :X_DATE_CREATED,
CREATED_BY = :X_CREATED_BY,
ACTUAL_FLAG = :X_ACTUAL_FLAG,
USER_JE_CATEGORY_NAME = :X_USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME = :X_USER_JE_SOURCE_NAME,
CURRENCY_CONVERSION_DATE = :X_CURRENCY_CONVERSION_DATE,
ENCUMBRANCE_TYPE_ID = :X_ENCUMBRANCE_TYPE_ID,
BUDGET_VERSION_ID = :X_BUDGET_VERSION_ID,
USER_CURRENCY_CONVERSION_TYPE = :X_USER_CURRENCY_CONV_TYPE,
CURRENCY_CONVERSION_RATE = :X_CURRENCY_CONVERSION_RATE,
AVERAGE_JOURNAL_FLAG = :X_AVERAGE_JOURNAL_FLAG,
SEGMENT1 = :X_SEGMENT1,
SEGMENT2 = :X_SEGMENT2,
SEGMENT3 = :X_SEGMENT3,
SEGMENT4 = :X_SEGMENT4,
SEGMENT5 = :X_SEGMENT5,
SEGMENT6 = :X_SEGMENT6,
SEGMENT7 = :X_SEGMENT7,
SEGMENT8 = :X_SEGMENT8,
SEGMENT9 = :X_SEGMENT9,
SEGMENT10 = :X_SEGMENT10,
SEGMENT11 = :X_SEGMENT11,
SEGMENT12 = :X_SEGMENT12,
SEGMENT13 = :X_SEGMENT13,
SEGMENT14 = :X_SEGMENT14,
SEGMENT15 = :X_SEGMENT15,
SEGMENT16 = :X_SEGMENT16,
SEGMENT17 = :X_SEGMENT17,
SEGMENT18 = :X_SEGMENT18,
SEGMENT19 = :X_SEGMENT19,
SEGMENT20 = :X_SEGMENT20,
SEGMENT21 = :X_SEGMENT21,
SEGMENT22 = :X_SEGMENT22,
SEGMENT23 = :X_SEGMENT23,
SEGMENT24 = :X_SEGMENT24,
SEGMENT25 = :X_SEGMENT25,
SEGMENT26 = :X_SEGMENT26,
SEGMENT27 = :X_SEGMENT27,
SEGMENT28 = :X_SEGMENT28,
SEGMENT29 = :X_SEGMENT29,
SEGMENT30 = :X_SEGMENT30,
ENTERED_DR = :X_ENTERED_DR,
ENTERED_CR = :X_ENTERED_CR,
ACCOUNTED_DR = :X_ACCOUNTED_DR,
ACCOUNTED_CR = :X_ACCOUNTED_CR,
REFERENCE1 = :X_REFERENCE1,
REFERENCE2 = :X_REFERENCE2,
REFERENCE3 = :X_REFERENCE3,
REFERENCE4 = :X_REFERENCE4,
REFERENCE5 = :X_REFERENCE5,
REFERENCE6 = :X_REFERENCE6,
REFERENCE7 = :X_REFERENCE7,
REFERENCE8 = :X_REFERENCE8,
REFERENCE9 = :X_REFERENCE9,
REFERENCE10 = :X_REFERENCE10,
REFERENCE11 = :X_REFERENCE11,
REFERENCE12 = :X_REFERENCE12,
REFERENCE13 = :X_REFERENCE13,
REFERENCE14 = :X_REFERENCE14,
REFERENCE15 = :X_REFERENCE15,
REFERENCE16 = :X_REFERENCE16,
REFERENCE17 = :X_REFERENCE17,
REFERENCE18 = :X_REFERENCE18,
REFERENCE19 = :X_REFERENCE19,
REFERENCE20 = :X_REFERENCE20,
REFERENCE21 = :X_REFERENCE21,
REFERENCE22 = :X_REFERENCE22,
REFERENCE23 = :X_REFERENCE23,
REFERENCE24 = :X_REFERENCE24,
REFERENCE25 = :X_REFERENCE25,
REFERENCE26 = :X_REFERENCE26,
REFERENCE27 = :X_REFERENCE27,
REFERENCE28 = :X_REFERENCE28,
REFERENCE29 = :X_REFERENCE29,
REFERENCE30 = :X_REFERENCE30,
PERIOD_NAME = :X_PERIOD_NAME,
CODE_COMBINATION_ID = :X_CODE_COMBINATION_ID,
STAT_AMOUNT = :X_STAT_AMOUNT,
GROUP_ID = :X_GROUP_ID,
REQUEST_ID = :X_REQUEST_ID,
SUBLEDGER_DOC_SEQUENCE_ID = :X_SUBLEDGER_DOC_SEQUENCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE = :X_SUBLEDGER_DOC_SEQUENCE_VALUE,
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,
ATTRIBUTE16 = :X_ATTRIBUTE16,
ATTRIBUTE17 = :X_ATTRIBUTE17,
ATTRIBUTE18 = :X_ATTRIBUTE18,
ATTRIBUTE19 = :X_ATTRIBUTE19,
ATTRIBUTE20 = :X_ATTRIBUTE20,
CONTEXT = :X_CONTEXT,
CONTEXT2 = :X_CONTEXT2,
INVOICE_DATE = :X_INVOICE_DATE,
TAX_CODE = :X_TAX_CODE,
INVOICE_IDENTIFIER = :X_INVOICE_IDENTIFIER,
INVOICE_AMOUNT = :X_INVOICE_AMOUNT,
CONTEXT3 = :X_CONTEXT3,
USSGL_TRANSACTION_CODE = :X_USSGL_TRANSACTION_CODE,
JGZZ_RECON_REF = :X_JGZZ_RECON_REF,
ORIGINATING_BAL_SEG_VALUE = :X_ORIGINATING_BAL_SEG_VALUE,
GL_SL_LINK_ID = :X_GL_SL_LINK_ID,
GL_SL_LINK_TABLE = :X_GL_SL_LINK_TABLE
where ROWID = :X_ROWID';
END update_row;
procedure DELETE_ROW (
X_ROWID in VARCHAR2,
X_ITABLE in VARCHAR2
) IS
sqlstmt VARCHAR2(2000);
'delete from ' || X_ITABLE || ' ' ||
'where ROW_ID = :X_ROWID';
END delete_row;