[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 set_of_books_id,
name,
chart_of_accounts_id,
currency_code,
period_set_name
FROM gl_sets_of_books
WHERE set_of_books_id IN ( p_from_ledger , p_to_ledger );
SELECT je_batch_id,
name,
description
FROM gl_je_batches
WHERE actual_flag = 'A'
--AND set_of_books_id = p_sob_id
--AND posted_date IS NOT NULL
AND status = 'P'
AND default_period_name = p_period;
the original journals header id as a result of which these journals are never selected
to be posted
*/
/*
Bug 2606480 - accrual_rev_flag should be considered 'N' if accrual_rev_effective_date is null
*/
CURSOR c_header(p_batch_id NUMBER,
p_ledger_id NUMBER) IS
SELECT h.je_header_id,
h.name header_name,
h.default_effective_date,
h.description header_description,
h.currency_code,
h.currency_conversion_rate,
d.user_conversion_type,
h.currency_conversion_date,
--h.accrual_rev_flag,
decode (h.accrual_rev_effective_date, null, 'N', 'Y') accrual_rev_flag,
h.accrual_rev_effective_date,
h.global_attribute1,
h.reversed_je_header_id,
s.user_je_source_name,
s.je_source_name,
s.journal_reference_flag,
c.user_je_category_name,
c.je_category_name
FROM gl_je_headers h,
gl_je_sources s,
gl_je_categories c,
gl_daily_conversion_types d
WHERE h.je_source = s.je_source_name
AND c.je_category_name = h.je_category
AND je_batch_id = p_batch_id
AND (NVL(global_attribute1, 0) = 0
OR NVL(global_attribute1,0) <> h.je_header_id)
AND status = 'P'
AND actual_flag = 'A'
AND je_category <> 'Revaluation'
AND s.je_source_name <> 'Assets'
AND h.currency_conversion_type = d.conversion_type
AND h.ledger_id = p_ledger_id
ORDER BY s.je_source_name
FOR UPDATE OF h.global_attribute1;
SELECT rownum,
l.je_line_num,
l.entered_dr,
l.entered_cr,
l.accounted_dr,
l.accounted_cr,
l.description line_description,
l.reference_1,
l.reference_2,
l.reference_3,
l.reference_4,
l.reference_5,
l.reference_6,
l.reference_7,
l.reference_8,
l.reference_9,
l.reference_10,
l.code_combination_id,
l.stat_amount,
l.attribute1,
l.attribute2,
l.attribute3,
l.attribute4,
l.attribute5,
l.attribute6,
l.attribute7,
l.attribute8,
l.attribute9,
l.attribute10,
l.attribute11,
l.attribute12,
l.attribute13,
l.attribute14,
l.attribute15,
l.attribute16,
l.attribute17,
l.attribute18,
l.attribute19,
l.attribute20,
l.context,
l.context2,
l.context3,
l.invoice_date,
l.tax_code,
l.invoice_identifier,
l.invoice_amount,
l.ussgl_transaction_code--,
--l.jgzz_recon_ref
FROM gl_je_lines l
WHERE l.je_header_id = p_header_id;
SELECT reference_1,
reference_2,
reference_3,
reference_4,
reference_5,
reference_6,
reference_7,
reference_8,
reference_9,
reference_10
FROM gl_import_references
WHERE je_header_id = p_header_id
AND je_line_num = p_line_num;
INSERT INTO gl_interface(
STATUS,
SET_OF_BOOKS_ID,
ACCOUNTING_DATE,
CURRENCY_CODE,
DATE_CREATED,
CREATED_BY,
ACTUAL_FLAG ,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
CURRENCY_CONVERSION_DATE,
USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
ENTERED_DR,
ENTERED_CR ,
ACCOUNTED_DR,
ACCOUNTED_CR,
REFERENCE1,
REFERENCE2 ,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE10,
REFERENCE21,
REFERENCE22,
REFERENCE23,
REFERENCE24,
REFERENCE25,
REFERENCE26,
REFERENCE27,
REFERENCE28,
REFERENCE29,
REFERENCE30,
CODE_COMBINATION_ID,
STAT_AMOUNT,
GROUP_ID,
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
)
VALUES( 'NEW',
x_to_ledger.set_of_books_id,
rec_header.default_effective_date,
rec_header.currency_code,
x_sysdate,
x_last_updated_by,
'A',
rec_header.user_je_category_name,
rec_header.user_je_source_name,
rec_header.currency_conversion_date,
rec_header.user_conversion_type,
rec_header.currency_conversion_rate,
x_entered_dr,
x_entered_cr,
x_accounted_dr,
x_accounted_cr,
substr(rec_batch.name,1,40)|| to_char(rec_header.je_header_id),
rec_batch.description,
substr(rec_header.header_name,1,15)||to_char(rec_header.je_header_id),
rec_header.header_description,
to_char(rec_header.je_header_id),
rec_header.accrual_rev_flag,
rec_header.accrual_rev_effective_date,
rec_line.line_description,
x_reference_1,
x_reference_2,
x_reference_3,
x_reference_4,
x_reference_5,
x_reference_6,
x_reference_7,
x_reference_8,
x_reference_9,
x_reference_10,
rec_line.code_combination_id,
rec_line.stat_amount,
x_group_id,
rec_line.attribute1,
rec_line.attribute2,
rec_line.attribute3,
rec_line.attribute4,
rec_line.attribute5,
rec_line.attribute6,
rec_line.attribute7,
rec_line.attribute8,
rec_line.attribute9,
rec_line.attribute10,
rec_line.attribute11,
rec_line.attribute12,
rec_line.attribute13,
rec_line.attribute14,
rec_line.attribute15,
rec_line.attribute16,
rec_line.attribute17,
rec_line.attribute18,
rec_line.attribute19,
rec_line.attribute20,
rec_line.context,
rec_line.context2,
rec_line.invoice_date,
rec_line.tax_code,
rec_line.invoice_identifier,
rec_line.invoice_amount,
rec_line.context3,
rec_line.ussgl_transaction_code--,
--rec_line.jgzz_recon_ref
);
INSERT INTO gl_interface(
STATUS,
SET_OF_BOOKS_ID,
ACCOUNTING_DATE,
CURRENCY_CODE,
DATE_CREATED,
CREATED_BY,
ACTUAL_FLAG ,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
CURRENCY_CONVERSION_DATE,
USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
ENTERED_DR,
ENTERED_CR ,
ACCOUNTED_DR,
ACCOUNTED_CR,
REFERENCE1,
REFERENCE2 ,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE10,
REFERENCE21,
REFERENCE22,
REFERENCE23,
REFERENCE24,
REFERENCE25,
REFERENCE26,
REFERENCE27,
REFERENCE28,
REFERENCE29,
REFERENCE30,
CODE_COMBINATION_ID,
STAT_AMOUNT,
GROUP_ID,
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
)
VALUES( 'NEW',
x_to_ledger.set_of_books_id,
rec_header.default_effective_date,
rec_header.currency_code,
x_sysdate,
x_last_updated_by,
'A',
rec_header.user_je_category_name,
rec_header.user_je_source_name,
rec_header.currency_conversion_date,
rec_header.user_conversion_type,
rec_header.currency_conversion_rate,
rec_line.entered_dr,
rec_line.entered_cr,
rec_line.accounted_dr,
rec_line.accounted_cr,
substr(rec_batch.name,1,40)|| to_char(rec_header.je_header_id),
rec_batch.description,
substr(rec_header.header_name,1,15)||to_char(rec_header.je_header_id),
rec_header.header_description,
to_char(rec_header.je_header_id),
rec_header.accrual_rev_flag,
rec_header.accrual_rev_effective_date,
rec_line.line_description,
x_reference_1,
x_reference_2,
x_reference_3,
x_reference_4,
x_reference_5,
x_reference_6,
x_reference_7,
x_reference_8,
x_reference_9,
x_reference_10,
rec_line.code_combination_id,
rec_line.stat_amount,
x_group_id,
rec_line.attribute1,
rec_line.attribute2,
rec_line.attribute3,
rec_line.attribute4,
rec_line.attribute5,
rec_line.attribute6,
rec_line.attribute7,
rec_line.attribute8,
rec_line.attribute9,
rec_line.attribute10,
rec_line.attribute11,
rec_line.attribute12,
rec_line.attribute13,
rec_line.attribute14,
rec_line.attribute15,
rec_line.attribute16,
rec_line.attribute17,
rec_line.attribute18,
rec_line.attribute19,
rec_line.attribute20,
rec_line.context,
rec_line.context2,
rec_line.invoice_date,
rec_line.tax_code,
rec_line.invoice_identifier,
rec_line.invoice_amount,
rec_line.context3,
rec_line.ussgl_transaction_code--,
--rec_line.jgzz_recon_ref
);
UPDATE gl_je_headers
SET global_attribute1 = to_char(rec_header.je_header_id)
WHERE CURRENT OF c_header;
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_file.put_line( 1, 'last_updated_by:'||to_char(x_last_updated_by));
SELECT gl_journal_import_s.nextval
INTO x_interface_run_id
FROM sys.DUAL;
INSERT INTO gl_interface_control( je_source_name,
status,
interface_run_id,
group_id,
set_of_books_id,
packet_id)
VALUES( p_je_source_tab(i),
'S',
x_interface_run_id,
p_group_id,
p_sob,
NULL);
SELECT gl_interface_control_s.nextval
INTO p_summary
FROM sys.dual;
SELECT gl_interface_control_s.nextval
INTO p_detail
FROM sys.dual;