[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select alphanumeric_allowed_flag, uppercase_only_flag, numeric_mode_enabled_flag, maximum_size
into p_alphanumeric_allowed_flag, p_uppercase_only_flag ,p_numeric_mode_enabled_flag, p_maximum_size
from fnd_flex_value_sets
where flex_value_set_name like l_value_set_name;
select PARENT_FLEX_VALUE_SET_ID into l_parent_flex_value_set_id
from fnd_flex_value_sets
where flex_value_set_name like p_value_set_name
and PARENT_FLEX_VALUE_SET_ID is not null;
SELECT s.segment_num into p_dependent_seg_num
FROM fnd_id_flex_segments s, fnd_segment_attribute_values sav,
fnd_segment_attribute_types sat
WHERE s.application_id = 101
AND s.id_flex_code = 'GL#'
AND s.id_flex_num = p_chart_of_accounts_id
AND s.enabled_flag = 'Y'
AND s.application_column_name = sav.application_column_name
AND sav.application_id = 101
AND sav.id_flex_code = 'GL#'
AND sav.id_flex_num = p_chart_of_accounts_id
AND sav.attribute_value = 'Y'
AND sav.segment_attribute_type = sat.segment_attribute_type
AND sat.application_id = 101
AND sat.id_flex_code = 'GL#'
AND sat.unique_flag = 'Y'
AND s.FLEX_VALUE_SET_ID=l_parent_flex_value_set_id
AND rownum =1;
SELECT FLEX_CONCACTENATED into l_FlexConcactenated
FROM ap_expense_report_params_all
WHERE parameter_id = p_exp_type_parameter_id;
SELECT GS.chart_of_accounts_id
INTO l_chart_of_accounts_id
FROM ap_system_parameters S,
gl_sets_of_books GS
WHERE GS.set_of_books_id = S.set_of_books_id
AND rownum = 1;
SELECT flex.application_column_name
FROM fnd_id_flex_segments flex
WHERE flex.application_id = 101
AND flex.id_flex_code = 'GL#'
AND flex.id_flex_num = p_chart_accounts_id
AND flex.enabled_flag='Y'
AND flex.display_flag='Y'
order by segment_num;
l_debug_info := 'First build the select statment';
sqlstmt := 'SELECT '||sqlstmt||' FROM AP_EXP_REPORT_DISTS
WHERE report_distribution_id = :report_distribution_id';
SELECT
aerh.employee_id,
aerh.flex_concatenated header_cost_center,
aerh.default_currency_code reimbursement_currency_code,
aerh.week_end_date,
aerh.attribute_category header_attribute_category,
aerh.attribute1 header_attribute1,
aerh.attribute2 header_attribute2,
aerh.attribute3 header_attribute3,
aerh.attribute4 header_attribute4,
aerh.attribute5 header_attribute5,
aerh.attribute6 header_attribute6,
aerh.attribute7 header_attribute7,
aerh.attribute8 header_attribute8,
aerh.attribute9 header_attribute9,
aerh.attribute10 header_attribute10,
aerh.attribute11 header_attribute11,
aerh.attribute12 header_attribute12,
aerh.attribute13 header_attribute13,
aerh.attribute14 header_attribute14,
aerh.attribute15 header_attribute15,
aerl.start_expense_date,
dist.amount,
aerl.credit_card_trx_id,
aerl.expenditure_item_date,
aerl.expenditure_type,
aerl.pa_quantity,
dist.expenditure_organization_id,
aerl.adjustment_reason,
aerl.category_code,
aerl.attribute_category line_attribute_category,
aerl.attribute1 line_attribute1,
aerl.attribute2 line_attribute2,
aerl.attribute3 line_attribute3,
aerl.attribute4 line_attribute4,
aerl.attribute5 line_attribute5,
aerl.attribute6 line_attribute6,
aerl.attribute7 line_attribute7,
aerl.attribute8 line_attribute8,
aerl.attribute9 line_attribute9,
aerl.attribute10 line_attribute10,
aerl.attribute11 line_attribute11,
aerl.attribute12 line_attribute12,
aerl.attribute13 line_attribute13,
aerl.attribute14 line_attribute14,
aerl.attribute15 line_attribute15,
dist.cost_center line_flex_concat,
aerl.ap_validation_error,
dist.project_id,
dist.task_id,
dist.award_id,
s.base_currency_code,
s.default_exchange_rate_type,
sob.chart_of_accounts_id,
erp.pa_expenditure_type new_expenditure_type
FROM ap_expense_report_headers aerh,
ap_expense_report_lines aerl,
ap_exp_report_dists dist,
ap_system_parameters s,
fnd_currencies_vl c,
gl_sets_of_books sob,
ap_expense_report_params erp
WHERE c.currency_code = s.base_currency_code
AND sob.set_of_books_id = s.set_of_books_id
AND erp.parameter_id = p_exp_type_parameter_id
AND dist.report_distribution_id = p_report_distribution_id
AND dist.report_line_id = aerl.report_line_id
AND aerh.report_header_id = aerl.report_header_id;
l_debug_info := 'gms_oie_int_pkg.DeleteACGenADL';
IF gms_oie_int_pkg.DeleteACGenADL(ln_award_set_id) THEN
null;
SELECT
aerh.employee_id,
aerh.flex_concatenated header_cost_center,
aerh.default_currency_code reimbursement_currency_code,
aerh.week_end_date,
aerh.attribute_category header_attribute_category,
aerh.attribute1 header_attribute1,
aerh.attribute2 header_attribute2,
aerh.attribute3 header_attribute3,
aerh.attribute4 header_attribute4,
aerh.attribute5 header_attribute5,
aerh.attribute6 header_attribute6,
aerh.attribute7 header_attribute7,
aerh.attribute8 header_attribute8,
aerh.attribute9 header_attribute9,
aerh.attribute10 header_attribute10,
aerh.attribute11 header_attribute11,
aerh.attribute12 header_attribute12,
aerh.attribute13 header_attribute13,
aerh.attribute14 header_attribute14,
aerh.attribute15 header_attribute15,
aerl.start_expense_date,
aerl.end_expense_date,
aerl.credit_card_trx_id,
aerl.expenditure_item_date,
aerl.expenditure_type,
aerl.pa_quantity,
aerl.adjustment_reason,
aerl.category_code,
aerl.attribute_category line_attribute_category,
aerl.attribute1 line_attribute1,
aerl.attribute2 line_attribute2,
aerl.attribute3 line_attribute3,
aerl.attribute4 line_attribute4,
aerl.attribute5 line_attribute5,
aerl.attribute6 line_attribute6,
aerl.attribute7 line_attribute7,
aerl.attribute8 line_attribute8,
aerl.attribute9 line_attribute9,
aerl.attribute10 line_attribute10,
aerl.attribute11 line_attribute11,
aerl.attribute12 line_attribute12,
aerl.attribute13 line_attribute13,
aerl.attribute14 line_attribute14,
aerl.attribute15 line_attribute15,
aerl.ap_validation_error,
s.base_currency_code,
s.default_exchange_rate_type,
sob.chart_of_accounts_id,
erp.pa_expenditure_type new_expenditure_type
FROM ap_expense_report_headers_all aerh,
ap_expense_report_lines_all aerl,
ap_system_parameters_all s,
fnd_currencies_vl c,
gl_sets_of_books sob,
ap_expense_report_params_all erp
WHERE c.currency_code = s.base_currency_code
AND sob.set_of_books_id = s.set_of_books_id
AND erp.parameter_id = p_web_parameter_id
AND aerh.report_header_id = aerl.report_header_id
AND aerl.report_line_id = p_report_line_id;