Interface Tables :
------------------------------------------------
gl_interface
gl_interface_control
Sequence :
------------------------------------------------
Group Id : (Table : gl_interface)
SELECT gl_journal_import_s.NEXTVAL INTO x_group_id FROM DUAL;
Interface Run Id : (Table : gl_interface_control)
SELECT gl_journal_import_s.NEXTVAL INTO x_run_id FROM DUAL;
Program Name :
------------------------------------------------
Journal Import
fnd_request.submit_request ('SQLGL',
'GLLEZL',
'',
'',
FALSE,
p_run_id,
p_set_of_books_id,
'N',
'',
'',
'N',
'N');
Key Fields:
------------------------------------------------
SELECT b.user_je_source_name FROM gl_je_sources;
user_je_category_name
Insert Statements :
------------------------------------------------
INSERT INTO gl_interface (STATUS,
LEDGER_ID,
ACCOUNTING_DATE,
CURRENCY_CODE,
DATE_CREATED,
CREATED_BY,
ACTUAL_FLAG,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
CURRENCY_CONVERSION_DATE,
ENCUMBRANCE_TYPE_ID,
BUDGET_VERSION_ID,
USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_RATE,
AVERAGE_JOURNAL_FLAG,
ORIGINATING_BAL_SEG_VALUE,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
SEGMENT6,
SEGMENT7,
SEGMENT8,
SEGMENT9,
SEGMENT10,
SEGMENT11,
SEGMENT12,
SEGMENT13,
SEGMENT14,
SEGMENT15,
SEGMENT16,
SEGMENT17,
SEGMENT18,
SEGMENT19,
SEGMENT20,
SEGMENT21,
SEGMENT22,
SEGMENT23,
SEGMENT24,
SEGMENT25,
SEGMENT26,
SEGMENT27,
SEGMENT28,
SEGMENT29,
SEGMENT30,
ENTERED_DR,
ENTERED_CR,
ACCOUNTED_DR,
ACCOUNTED_CR,
TRANSACTION_DATE,
REFERENCE1,
REFERENCE2,
REFERENCE3,
REFERENCE4,
REFERENCE5,
REFERENCE6,
REFERENCE7,
REFERENCE8,
REFERENCE9,
REFERENCE10,
REFERENCE11,
REFERENCE12,
REFERENCE13,
REFERENCE14,
REFERENCE15,
REFERENCE16,
REFERENCE17,
REFERENCE18,
REFERENCE19,
REFERENCE20,
REFERENCE21,
REFERENCE22,
REFERENCE23,
REFERENCE24,
REFERENCE25,
REFERENCE26,
REFERENCE27,
REFERENCE28,
REFERENCE29,
REFERENCE30,
JE_BATCH_ID,
PERIOD_NAME,
JE_HEADER_ID,
JE_LINE_NUM,
CHART_OF_ACCOUNTS_ID,
FUNCTIONAL_CURRENCY_CODE,
CODE_COMBINATION_ID,
DATE_CREATED_IN_GL,
WARNING_CODE,
STATUS_DESCRIPTION,
STAT_AMOUNT,
GROUP_ID,
REQUEST_ID,
SUBLEDGER_DOC_SEQUENCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE,
ATTRIBUTE1,
ATTRIBUTE2,
GL_SL_LINK_ID,
GL_SL_LINK_TABLE,
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,
DESCR_FLEX_ERROR_MESSAGE,
JGZZ_RECON_REF,
REFERENCE_DATE,
SET_OF_BOOKS_ID,
BALANCING_SEGMENT_VALUE,
MANAGEMENT_SEGMENT_VALUE,
FUNDS_RESERVED_FLAG--, CODE_COMBINATION_ID_INTERIM
)
(SELECT 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,
encumbrance_type_id,
budget_version_id,
user_currency_conversion_type,
currency_conversion_rate,
average_journal_flag,
originating_bal_seg_value,
segment1,
segment2,
segment3,
segment4,
segment5,
segment6,
segment7,
segment8,
segment9,
segment10,
segment11,
segment12,
segment13,
segment14,
segment15,
segment16,
segment17,
segment18,
segment19,
segment20,
segment21,
segment22,
segment23,
segment24,
segment25,
segment26,
segment27,
segment28,
segment29,
segment30,
entered_dr,
entered_cr,
accounted_dr,
accounted_cr,
transaction_date,
reference1,
reference2,
reference3,
reference4,
reference5,
reference6,
reference7,
reference8,
reference9,
reference10,
reference11,
reference12,
reference13,
reference14,
reference15,
reference16,
reference17,
reference18,
reference19,
reference20,
reference21,
reference22,
reference23,
reference24,
reference25,
reference26,
reference27,
reference28,
reference29,
reference30,
je_batch_id,
period_name,
je_header_id,
je_line_num,
chart_of_accounts_id,
functional_currency_code,
code_combination_id,
date_created_in_gl,
warning_code,
status_description,
stat_amount,
GROUP_ID,
request_id,
subledger_doc_sequence_id,
subledger_doc_sequence_value,
attribute1,
attribute2,
gl_sl_link_id,
gl_sl_link_table,
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,
descr_flex_error_message,
jgzz_recon_ref,
reference_date,
-- start of R12 upgrade changes
set_of_books_id,
NULL,
NULL,
NULL
--,null --End of R12 upgrade changes
FROM xxt_gl_interface_gbl);
------------
INSERT INTO gl_interface_control (je_source_name,
status,
interface_run_id,
GROUP_ID,
set_of_books_id)
SELECT DISTINCT b.je_source_name,
'S',
x_run_id,
a.GROUP_ID,
set_of_books_id
FROM gl_interface a, gl_je_sources b
WHERE a.GROUP_ID = grpid_type_tbl (grp_id.set_of_books_id)
AND a.user_je_source_name = b.user_je_source_name;
