[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_last_updated_by NUMBER(15);
x_last_update_login NUMBER(15);
SELECT c.je_category_name,
c.user_je_category_name
FROM gl_je_categories c,
fa_book_controls b
WHERE b.book_type_code = p_book
AND c.je_category_name IN ( b.global_attribute6,
b.global_attribute7,
b.global_attribute8,
b.global_attribute9,
b.global_attribute10,
b.global_attribute11,
b.global_attribute12,
b.global_attribute13,
b.global_attribute14,
b.global_attribute15,
b.global_attribute16,
b.global_attribute17,
b.global_attribute18)
UNION
SELECT c.je_category_name,
c.user_je_category_name
FROM gl_je_categories c
WHERE c.je_category_name IN
(SELECT b.je_category_name
FROM xla_event_class_attrs b
WHERE b.application_id = 140);
SELECT source_type_code,
debit_credit_flag,
code_combination_id,
sum(adjustment_amount) x_amount
FROM jl_co_fa_adjustments
WHERE book_type_code = p_book
AND period_counter_created = p_counter
AND je_category_name = p_je_category_name
AND NVL(posting_flag, 'E') <> 'C'
GROUP BY source_type_code,
debit_credit_flag,
code_combination_id;
SELECT bc.set_of_books_id,
bc.deprn_calendar,
bc.gl_je_source,
bc.distribution_source_book,
(bc.global_attribute19 +1), -- Period counter for which posting is to be performed.
bc.global_attribute5,
js.user_je_source_name
INTO x_set_of_book_id,
x_deprn_calendar,
x_gl_je_source,
x_distribution_source_book,
x_period_counter,
x_period_closed,
x_user_je_source_name
FROM fa_book_controls bc,
gl_je_sources js
WHERE book_type_code = p_book
AND js.je_source_name = bc.gl_je_source;
SELECT bc.set_of_books_id,
bc.deprn_calendar,
bc.distribution_source_book,
(bc.global_attribute19 +1), -- Period counter for which posting is to be performed.
bc.global_attribute5
INTO x_set_of_book_id,
x_deprn_calendar,
x_distribution_source_book,
x_period_counter,
x_period_closed
FROM fa_book_controls bc
WHERE book_type_code = p_book;
SELECT xs.je_source_name,
js.user_je_source_name
INTO x_gl_je_source,
x_user_je_source_name
FROM gl_je_sources js,
xla_subledgers xs
WHERE js.je_source_name = xs.je_source_name
AND xs.application_id = 140;
SELECT period_name
INTO x_period_name
FROM fa_deprn_periods
WHERE book_type_code = p_book
AND period_counter = x_period_counter;
SELECT end_date
INTO x_end_date
FROM fa_calendar_periods
WHERE calendar_type = x_deprn_calendar
AND period_name = x_period_name;
SELECT currency_code
INTO x_currency_code
FROM gl_sets_of_books
WHERE set_of_books_id = x_set_of_book_id;
fnd_file.put_line( 1, 'Inserting row into GL_INTERFACE');
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserting row into GL_INTERFACE');
INSERT INTO gl_interface (status,
set_of_books_id,
-- Bug 11799412 Start
ledger_id,
-- Bug 11799412 End
accounting_date,
currency_code,
date_created,
created_by,
actual_flag,
user_je_category_name,
user_je_source_name,
entered_dr,
entered_cr,
reference1,
reference2,
reference4,
reference6,
reference10,
reference21,
reference22,
code_combination_id)
VALUES( x_status,
x_set_of_book_id,
-- Bug 11799412 Start
x_set_of_book_id,
-- Bug 11799412 Start
x_end_date,
x_currency_code,
x_sysdate,
x_last_updated_by,
x_actual_flag,
rec_category.user_je_category_name,
x_user_je_source_name,
x_entered_dr,
x_entered_cr,
x_batch_name,
x_batch_description,
x_journal_entry_name,
p_book,
x_batch_description,
rec_category.je_category_name,
jl_co_fa_adj_je_header_s.NEXTVAL,
rec_adjustment.code_combination_id);
fnd_file.put_line( 1, 'Inserted row into GL_INTERFACE');
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'Inserted row into GL_INTERFACE');
UPDATE jl_co_fa_adjustments
SET sequence_line = jl_co_fa_adj_je_header_s.CURRVAL,
posting_flag = 'C',
last_update_date = x_sysdate,
last_updated_by = x_last_updated_by,
last_update_login = x_last_update_login,
program_update_date = x_sysdate
WHERE book_type_code = p_book
AND je_category_name = rec_category.je_category_name
AND NVL(posting_flag, 'E') <> 'C'
AND period_counter_created = x_period_counter
AND code_combination_id = rec_adjustment.code_combination_id
AND debit_credit_flag = rec_adjustment.debit_credit_flag
AND source_type_code = rec_adjustment.source_type_code;
UPDATE fa_book_controls
SET global_attribute19 = x_period_counter,
last_update_date = x_sysdate,
last_updated_by = x_last_updated_by
WHERE book_type_code = p_book;
x_last_updated_by := fnd_global.user_id;
x_last_update_login := fnd_global.login_id;
fnd_file.put_line( 1, 'last_update_login:'||to_char(x_last_update_login));
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_update_login:'||to_char(x_last_update_login));
fnd_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'last_updated_by:'||to_char(x_last_updated_by));