[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cfh.name, cfh.aging_type,
cfh.overdue_transactions, cfh.transaction_calendar_id,
cfh.start_project_id, cfh.end_project_id
FROM CE_FORECAST_HEADERS cfh
WHERE cfh.forecast_header_id = p_forecast_header_id;
SELECT rowid, forecast_row_id, row_number, trx_type, nvl(lead_time,0),
NVL(forecast_method,'F'), discount_option, DECODE(trx_type, 'PAY', 'PAY', 'XTR', 'XTR', 'XTI', 'XTR', 'XTO', 'XTR', SUBSTR(trx_type, 1,2)),
include_float_flag, NVL(order_status,'A'),
order_date_type, code_combination_id, budget_name,
encumbrance_type_id, chart_of_accounts_id,
set_of_books_id, NVL(org_id,-99), legal_entity_id,
roll_forward_type, roll_forward_period,
NVL(include_dispute_flag,'N'), sales_stage_id,
channel_code, NVL(win_probability,0), sales_forecast_status,
customer_profile_class_id, bank_account_id,
receipt_method_id, vendor_type, payment_method, pay_group,
payment_priority, authorization_status, type, budget_type,
budget_version, include_hold_flag, include_net_cash_flag, budget_version_id,
payroll_id, xtr_bank_account, company_code, exclude_indic_exp, org_payment_method_id,
external_source_type, criteria_category,
criteria1, criteria2, criteria3, criteria4, criteria5,
criteria6, criteria7, criteria8, criteria9, criteria10,
criteria11, criteria12, criteria13, criteria14, criteria15,
use_average_payment_days, period, order_type_id,
use_payment_terms, include_temp_labor_flag
FROM ce_forecast_rows
WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
NVL(p_rownum_to, row_number)
AND forecast_header_id = p_forecast_header_id
AND trx_type <> 'GLC';
SELECT rowid, forecast_row_id, row_number,
set_of_books_id, code_combination_id, chart_of_accounts_id
FROM ce_forecast_rows
WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
NVL(p_rownum_to, row_number)
AND forecast_header_id = p_forecast_header_id
AND trx_type = 'GLC';
SELECT forecast_header_id
INTO l_forecast_header_id
FROM ce_forecasts
WHERE forecast_id = G_forecast_id;
SELECT currency_code
FROM fnd_currencies
WHERE enabled_flag = 'Y'
AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
AND currency_code <> 'STAT'
AND CE_CASH_FCST.G_rp_exchange_date BETWEEN
NVL(start_date_active,CE_CASH_FCST.G_rp_exchange_date) and
NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date);
SELECT currency_code
FROM fnd_currencies
WHERE enabled_flag = 'Y'
AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
AND currency_code <> 'STAT'
AND ( CE_CASH_FCST.G_rp_exchange_date <
NVL(start_date_active,CE_CASH_FCST.G_rp_exchange_date) OR
CE_CASH_FCST.G_rp_exchange_date >
NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date));
SELECT distinct(org.currency_code)
FROM ce_forecast_rows r,
ce_forecast_oe_orgs_v org
WHERE r.row_number BETWEEN
NVL(CE_CASH_FCST.G_rp_rownum_from, row_number) and
NVL(CE_CASH_FCST.G_rp_rownum_to, row_number)
AND r.forecast_header_id = CE_CASH_FCST.G_rp_forecast_header_id
AND org.currency_code <> CE_CASH_FCST.G_rp_forecast_currency
AND r.trx_type = 'OEO'
AND org.org_id = NVL(r.org_id, org.org_id);
insert into CE_CURRENCY_RATES_TEMP
(forecast_request_id, currency_code, exchange_rate, to_currency)
values (CE_CASH_FCST.G_forecast_id, curr, xrate, to_curr);
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
G_rp_forecast_header_id, null,'CE_FC_MISSING_RATE', error_msg);
insert into CE_CURRENCY_RATES_TEMP (forecast_request_id, currency_code,
exchange_rate, to_currency)
values (CE_CASH_FCST.G_forecast_id, to_curr, 1, to_curr);
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);
SELECT currency_code
FROM fnd_currencies
WHERE enabled_flag = 'Y'
AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
AND currency_code <> 'STAT'
AND CE_CASH_FCST.G_rp_exchange_date BETWEEN
NVL(start_date_active,CE_CASH_FCST.G_rp_exchange_date)
and NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date);
SELECT currency_code
FROM fnd_currencies
WHERE enabled_flag = 'Y'
AND currency_code <> CE_CASH_FCST.G_rp_forecast_currency
AND currency_code <> 'STAT'
AND ( CE_CASH_FCST.G_rp_exchange_date <
NVL(start_date_active,CE_CASH_FCST.G_rp_exchange_date) OR
CE_CASH_FCST.G_rp_exchange_date >
NVL(end_date_active,CE_CASH_FCST.G_rp_exchange_date));
insert into CE_CURRENCY_RATES_TEMP
(forecast_request_id, currency_code, exchange_rate, to_currency)
values (CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_currency, 1,
CE_CASH_FCST.G_rp_forecast_currency);
SELECT DECODE(COUNT(*),0,'N','Y')
INTO fcast_curr_is_emu
FROM FND_CURRENCIES
WHERE currency_code = CE_CASH_FCST.G_rp_forecast_currency AND
derive_type = 'EMU';
SELECT DECODE(COUNT(*),0,'N','Y')
INTO src_curr_is_emu
FROM FND_CURRENCIES
WHERE currency_code = CE_CASH_FCST.G_rp_src_currency AND
derive_type = 'EMU';
SELECT currency_code
INTO euro_curr
FROM fnd_currencies
WHERE derive_type = 'EURO';
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
G_rp_forecast_header_id, null,'CE_FC_EURO_NOT_DEFINED',
error_msg);
SELECT DECODE(COUNT(*),0,'N','Y')
INTO from_curr_is_emu
FROM FND_CURRENCIES
WHERE currency_code = from_curr AND
derive_type IN ('EMU','EURO');
insert into CE_CURRENCY_RATES_TEMP (forecast_request_id,
currency_code, exchange_rate, to_currency)
values (CE_CASH_FCST.G_forecast_id, from_curr, xrate,
G_rp_forecast_currency);
SELECT decode( derive_type,
'EURO', 'EURO',
'EMU', decode( sign( trunc(CE_CASH_FCST.G_rp_exchange_date)
- trunc(derive_effective)),
-1, 'OTHER',
'EMU'),
'OTHER' )
INTO l_currency_type
FROM FND_CURRENCIES
WHERE currency_code = to_curr;
SELECT decode( derive_type,
'EURO', 'EURO',
'EMU', decode( sign( trunc(CE_CASH_FCST.G_rp_exchange_date)
- trunc(derive_effective)),
-1, 'OTHER',
'EMU'),
'OTHER' )
INTO l_currency_type
FROM FND_CURRENCIES
WHERE currency_code = from_curr;
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
G_rp_forecast_header_id, null,'CE_FC_MISSING_RATE',
error_msg);
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,
G_rp_forecast_header_id, null,'CE_FC_BAD_CURRENCY', error_msg);
cep_standard.debug('Delete all xrate information');
delete from CE_CURRENCY_RATES_TEMP
where forecast_request_id = CE_CASH_FCST.G_forecast_id;
SELECT min(transaction_date), max(transaction_date)
INTO CE_CSH_FCST_POP.G_calendar_start, CE_CSH_FCST_POP.G_calendar_end
FROM gl_transaction_dates
WHERE transaction_calendar_id = G_transaction_calendar_id;
SELECT gsb.period_set_name, org.set_of_books_id, org.set_of_books_name
FROM ce_forecast_orgs_v org,
gl_sets_of_books gsb
WHERE gsb.set_of_books_id = org.set_of_books_id
AND org.app_short_name = G_app_short_name
AND org.set_of_books_id = NVL(G_set_of_books_id,org.set_of_books_id)
AND (org.org_id = DECODE(G_org_id, -1, org.org_id,-99, org.org_id, G_org_id)
or org.org_id IS NULL);
SELECT period_set_name, set_of_books_id, name, currency_code
INTO calendar, sob_id, sob_name, G_sob_currency_code
FROM gl_sets_of_books gsb
WHERE gsb.set_of_books_id = G_set_of_books_id;
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
'CE_FC_INVALID_PERIOD', error_msg);
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
'CE_FC_INVALID_PERIOD', error_msg);
SELECT count(1)
INTO col_count
FROM ce_forecast_columns
WHERE forecast_header_id = G_rp_forecast_header_id;
SELECT count(1)
INTO col_count
FROM ce_forecast_periods
WHERE forecast_header_id = G_rp_forecast_header_id;
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
'CE_FC_NO_COLUMN', error_msg);
CURSOR cCol IS SELECT forecast_column_id, column_number, days_from, days_to
FROM ce_forecast_columns
WHERE forecast_header_id = G_rp_forecast_header_id;
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
null,'CE_FC_COLUMN_NOT_IN_RANGE', error_msg);
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
'CE_FC_NO_ROW', error_msg);
SELECT row_number
FROM ce_forecast_rows
WHERE row_number BETWEEN NVL(p_rownum_from, row_number) AND
NVL(p_rownum_to, row_number)
AND forecast_header_id = p_forecast_header_id
AND trx_type <> 'GLC';
SELECT forecast_id
INTO fid
FROM ce_forecasts
WHERE name = G_rp_forecast_runname;
SELECT forecast_id
INTO fid
FROM ce_forecasts
WHERE name = G_rp_forecast_runname
AND forecast_id <> G_forecast_id;
SELECT count(1)
INTO l_fc_count
FROM ce_forecasts
WHERE forecast_id = G_forecast_id;
CE_FORECASTS_TABLE_PKG.Insert_Row(
X_Rowid => l_forecast_rowid,
X_forecast_id => G_forecast_id,
X_forecast_header_id => G_rp_forecast_header_id,
X_name => G_rp_forecast_runname,
X_description => null,
X_start_date => G_rp_forecast_start_date,
X_period_set_name => G_rp_calendar_name,
X_start_period => G_rp_forecast_start_period,
X_forecast_currency => G_rp_forecast_currency,
X_currency_type => NVL(G_rp_src_curr_type,'F'),
X_source_currency => G_rp_src_currency,
X_exchange_rate_type => G_rp_exchange_type,
X_exchange_date => G_rp_exchange_date,
X_exchange_rate => G_rp_exchange_rate,
X_error_status => 'R',
X_amount_threshold => G_rp_amount_threshold,
X_project_id => G_rp_project_id,
X_drilldown_flag => 'Y',
X_bank_balance_type => nvl(G_rp_bank_balance_type,'L'),
X_float_type => nvl(G_rp_float_type,'NONE'),
X_view_by => nvl(G_rp_view_by,'NONE'),
X_include_sub_account => nvl(G_rp_include_sub_account,'N'),
X_factor => nvl(G_rp_factor,0),
X_request_id => l_request_id,
X_created_by => nvl(fnd_global.user_id, -1),
X_creation_date => sysdate,
X_last_updated_by => nvl(fnd_global.user_id, -1),
X_last_update_date => sysdate,
X_last_update_login => nvl(fnd_global.user_id, -1),
X_attribute_category => null,
X_attribute1 => null,
X_attribute2 => null,
X_attribute3 => null,
X_attribute4 => null,
X_attribute5 => null,
X_attribute6 => null,
X_attribute7 => null,
X_attribute8 => null,
X_attribute9 => null,
X_attribute10 => null,
X_attribute11 => null,
X_attribute12 => null,
X_attribute13 => null,
X_attribute14 => null,
X_attribute15 => null);
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id,
null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
UPDATE ce_forecasts
SET error_status = 'X'
WHERE forecast_id = G_forecast_id;
CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, null,
'CE_FC_PMR_MISSING_XINFO', error_msg);
UPDATE ce_forecasts
SET error_status = 'E'
WHERE forecast_id = G_forecast_id;
SELECT forecast_column_id
INTO G_overdue_column_id
FROM ce_forecast_columns
WHERE forecast_header_id = G_rp_forecast_header_id AND
developer_column_num = 0;
UPDATE ce_forecasts
SET error_status = 'X'
WHERE forecast_id = G_forecast_id;
UPDATE ce_forecasts
set error_status = 'X'
where forecast_id = G_forecast_id;
UPDATE ce_forecasts
SET error_status = 'X'
WHERE forecast_id = G_forecast_id;
SELECT nvl(column_setup,'M')
INTO col_setup
FROM ce_forecast_headers
WHERE forecast_header_id = G_rp_forecast_header_id;
SELECT error_status
INTO l_status
FROM ce_forecasts
WHERE forecast_id = G_forecast_id;
UPDATE ce_forecasts
SET error_status = 'S'
WHERE forecast_id = G_forecast_id;
UPDATE ce_forecasts
SET error_status = 'W'
WHERE forecast_id = G_forecast_id;
SELECT project_id, segment1
FROM pa_projects_all
WHERE segment1 >= p_start_project_num
AND segment1 <= p_end_project_num;
UPDATE ce_forecasts
SET error_status = 'R'
WHERE forecast_id = p_forecast_id
AND error_status = 'P';
CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
UPDATE ce_forecasts
SET error_status = 'X'
WHERE forecast_id = p_forecast_id;
SELECT project_id, segment1
FROM pa_projects_all
WHERE segment1 >= p_start_project_num
AND segment1 <= p_end_project_num;
UPDATE ce_forecasts
SET error_status = 'R'
WHERE forecast_id = p_forecast_id
AND error_status = 'P';
CE_FORECAST_ERRORS_PKG.insert_row(p_forecast_id,p_forecast_header_id,
null,'CE_FC_DUPLICATE_FORECAST_NAME', error_msg);
UPDATE ce_forecasts
SET error_status = 'X'
WHERE forecast_id = p_forecast_id;