The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT gl_je_posting_s.NEXTVAL
FROM dual;
SELECT
'BF'
FROM
dual
WHERE EXISTS
( SELECT 'Frozen budget'
FROM GL_BUDGET_VERSIONS BV,
GL_JE_HEADERS JH
WHERE BV.status in ('I', 'F')
AND BV.budget_version_id = JH.budget_version_id
AND JH.je_batch_id = X_je_batch_id );
SELECT
'BU'
FROM
dual
WHERE EXISTS
( SELECT 'Unopened budget year'
FROM GL_BUDGETS GB,
GL_BUDGET_VERSIONS BV,
GL_JE_HEADERS JH
WHERE GB.budget_name = BV.budget_name
AND GB.budget_type = BV.budget_type
AND ( GB.latest_opened_year IS NULL
OR GB.latest_opened_year < X_period_year )
AND BV.budget_version_id = JH.budget_version_id
AND JH.je_batch_id = X_je_batch_id );
SELECT 'Out of Balance'
FROM SYS.DUAL
WHERE EXISTS
( SELECT 'x'
FROM GL_JE_HEADERS
WHERE je_batch_id = X_je_batch_id
AND nvl(display_alc_journal_flag, 'Y') = 'Y'
AND currency_code <> 'STAT'
AND nvl(running_total_dr, 0) <> nvl(running_total_cr, 0));
SELECT 'Untaxed'
FROM SYS.DUAL
WHERE EXISTS
( SELECT 'x'
FROM GL_JE_HEADERS
WHERE je_batch_id = X_je_batch_id
AND nvl(display_alc_journal_flag, 'Y') = 'Y'
AND currency_code <> 'STAT'
AND tax_status_code = 'R');
SELECT *
FROM gl_je_batches
WHERE rowid = X_Rowid
FOR UPDATE of Je_Batch_Id NOWAIT;
PROCEDURE Update_Row(X_Rowid VARCHAR2,
X_Je_Batch_Id NUMBER,
X_Last_Update_Date DATE,
X_Last_Updated_By NUMBER,
X_Chart_Of_Accounts_Id NUMBER,
X_Name VARCHAR2,
X_Status VARCHAR2,
X_Status_Verified VARCHAR2,
X_Actual_Flag VARCHAR2,
X_Budgetary_Control_Status VARCHAR2,
X_Last_Update_Login NUMBER,
X_Default_Period_Name VARCHAR2,
X_Control_Total NUMBER,
X_Running_Total_Dr NUMBER,
X_Running_Total_Cr NUMBER,
X_Posting_Run_Id NUMBER,
X_Request_Id NUMBER
) IS
BEGIN
UPDATE gl_je_batches
SET
je_batch_id = X_Je_Batch_Id,
last_update_date = X_Last_Update_Date,
last_updated_by = X_Last_Updated_By,
chart_of_accounts_id = X_Chart_Of_Accounts_Id,
name = X_Name,
status = X_Status,
status_verified = X_Status_Verified,
actual_flag = X_Actual_Flag,
budgetary_control_status = X_Budgetary_Control_Status,
last_update_login = X_Last_Update_Login,
default_period_name = X_Default_Period_Name,
control_total = X_Control_Total,
running_total_dr = X_Running_Total_Dr,
running_total_cr = X_Running_Total_Cr,
posting_run_id = X_Posting_Run_Id,
request_id = X_Request_Id
WHERE rowid = X_rowid;
UPDATE GL_CONSOLIDATION_HISTORY
SET status = 'PS',
request_id = X_Request_Id
WHERE je_batch_id = X_Je_Batch_Id;
UPDATE GL_ELIMINATION_HISTORY
SET status_code = 'PS',
request_id = X_Request_Id
WHERE je_batch_id = X_Je_Batch_Id;
END Update_Row;