The following lines contain the word 'select', 'insert', 'update' or 'delete':
| insert_gl_interface |
| DESCRIPTION |
| Insert analytical account journal lines into the GL_INTERFACE |
| table. |
| CALLED BY |
| Create_Journal_Allocations |
| RETURNS |
| TRUE if row successfully created. |
--------------------------------------------------------------------- */
FUNCTION insert_gl_interface( lp_entered_dr IN NUMBER,
lp_entered_cr IN NUMBER,
lp_accounted_dr IN NUMBER,
lp_accounted_cr IN NUMBER,
lp_offset_group_bool IN BOOLEAN) RETURN BOOLEAN IS
BEGIN
JG_UTILITY_PKG.log('> JG_CREATE_JOURNALS_PKG.insert_gl_interface');
INSERT INTO gl_interface ( STATUS,
LEDGER_ID, -- GC Ledger Architecture change
ACCOUNTING_DATE,
CURRENCY_CODE,
USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_RATE,
DATE_CREATED,
CREATED_BY,
ACTUAL_FLAG,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
ENCUMBRANCE_TYPE_ID,
BUDGET_VERSION_ID,
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,
REFERENCE1, -- Batch Name
REFERENCE2, -- Batch Description
REFERENCE4, -- Header Name
REFERENCE5, -- Header Description
REFERENCE6, -- Header Reference
REFERENCE10, -- Line Description
REFERENCE21, -- GL_JE_LINES.reference_1
REFERENCE22, -- GL_JE_LINES.reference_2
STAT_AMOUNT,
SUBLEDGER_DOC_SEQUENCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE,
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,
PERIOD_NAME)
VALUES
( 'NEW',
JG_JOURNAL_ALLOCATIONS_PKG.G_destn_set_of_books_id,
JG_JOURNAL_ALLOCATIONS_PKG.G_GL_end_date,
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
'A',
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
'A',
DECODE(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
JG_JOURNAL_ALLOCATIONS_PKG.G_translated_user)),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
'A',
DECODE(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
sysdate)),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
'A',
DECODE(JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_code,
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
1)),
SYSDATE,
JG_JOURNAL_ALLOCATIONS_PKG.G_user_id,
JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,
JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_category_name,
JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_source_name,
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'E',
JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
JG_CREATE_JOURNALS_PKG.G_key_segment( 1 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 2 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 3 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 4 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 5 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 6 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 7 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 8 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 9 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 10 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 11 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 12 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 13 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 14 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 15 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 16 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 17 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 18 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 19 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 20 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 21 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 22 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 23 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 24 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 25 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 26 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 27 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 28 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 29 ),
JG_CREATE_JOURNALS_PKG.G_key_segment( 30 ),
lp_entered_dr,
lp_entered_cr,
lp_accounted_dr,
lp_accounted_cr,
JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.external_reference,-- Reference6
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_name ||
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'A',
'/' ||JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_doc_sequence_name || '/' ||
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_doc_sequence_value || '/' ||
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num, NULL), -- Reference 10
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_header_id,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.je_line_num,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.stat_amount,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.subledger_doc_sequence_id,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.subledger_doc_sequence_value,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute1,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute2,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute3,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute4,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute5,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute6,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute7,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute8,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute9,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute10,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute11,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute12,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute13,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute14,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute15,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute16,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute17,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute18,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute19,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.attribute20,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.context,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.context2,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.invoice_date,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.tax_code,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.invoice_identifier,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.invoice_amount,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.context3,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.ussgl_transaction_code,
JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.l_je_lines_v_rec.jgzz_recon_ref,
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'B',
JG_JOURNAL_ALLOCATIONS_PKG.G_destn_period_name, NULL));
ELSE -- Inserting line for an offset group total
INSERT INTO gl_interface ( STATUS,
LEDGER_ID, -- GC Ledger Architecture change
ACCOUNTING_DATE,
CURRENCY_CODE,
USER_CURRENCY_CONVERSION_TYPE,
CURRENCY_CONVERSION_DATE,
CURRENCY_CONVERSION_RATE,
DATE_CREATED,
CREATED_BY,
ACTUAL_FLAG,
USER_JE_CATEGORY_NAME,
USER_JE_SOURCE_NAME,
ENCUMBRANCE_TYPE_ID,
BUDGET_VERSION_ID,
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,
REFERENCE1, -- Batch Name
REFERENCE2, -- Batch Description
REFERENCE4, -- Header Name
REFERENCE5, -- Header Description
REFERENCE6, -- Header Reference
REFERENCE10, -- Line Description
REFERENCE21, -- GL_JE_LINES.reference_1
REFERENCE22, -- GL_JE_LINES.reference_2
STAT_AMOUNT,
SUBLEDGER_DOC_SEQUENCE_ID,
SUBLEDGER_DOC_SEQUENCE_VALUE,
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,
PERIOD_NAME)
VALUES
( 'NEW',
JG_JOURNAL_ALLOCATIONS_PKG.G_destn_set_of_books_id,
JG_JOURNAL_ALLOCATIONS_PKG.G_GL_end_date,
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
'A',
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
'A',
DECODE(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_type,
JG_JOURNAL_ALLOCATIONS_PKG.G_translated_user)),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
'A',
DECODE(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_date,
SYSDATE)),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_amount_type,'E',
JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
'A',
DECODE(JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_code,
JG_JOURNAL_ALLOCATIONS_PKG.G_functional_currency,
JG_ALLOCATE_JOURNALS_PKG.G_last_journal_qry_rec.l_je_lines_v_rec.currency_conversion_rate,
1)),
SYSDATE,
JG_JOURNAL_ALLOCATIONS_PKG.G_user_id,
JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,
JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_category_name,
JG_JOURNAL_ALLOCATIONS_PKG.G_user_je_source_name,
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'E',
JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type,'B',
JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type_id),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 1 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 2 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 3 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 4 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 5 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 6 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 7 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 8 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 9 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 10 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 11 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 12 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 13 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 14 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 15 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 16 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 17 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 18 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 19 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 20 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 21 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 22 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 23 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 24 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 25 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 26 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 27 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 28 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 29 ),
JG_CREATE_JOURNALS_PKG.G_offset_grp_key_segment( 30 ),
lp_entered_dr,
lp_entered_cr,
lp_accounted_dr,
lp_accounted_cr,
JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference1
JG_CREATE_JOURNALS_PKG.G_Batch_Name, -- Reference2
JG_CREATE_JOURNALS_PKG.G_Journal_Name, -- Reference4
JG_CREATE_JOURNALS_PKG.G_Journal_Description, -- Reference5
NULL,-- Reference6
NULL, -- Reference 10
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
NULL,
DECODE(JG_JOURNAL_ALLOCATIONS_PKG.G_balance_type, 'B',
JG_JOURNAL_ALLOCATIONS_PKG.G_destn_period_name, NULL));
JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
JG_UTILITY_PKG.log('< JG_CREATE_JOURNALS_PKG.insert_gl_interface');
END insert_gl_interface;
IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface(l_net_dr_entered_offset_total,
l_net_cr_entered_offset_total,
l_net_dr_accted_offset_total,
l_net_cr_accted_offset_total,
TRUE) THEN
FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');
| Add allocation line to array for later reporting and inserting |
| IF offset account is defined against the rule line THEN |
| Add offset allocation line to array |
| END IF |
| END LOOP |
| Compare original entered/accounted amounts with total of allocated |
| amounts and calculate any rounding errors. |
| Add rounding errors to amounts of allocation line and offset line |
| with the max percentage in the array |
| Insert source journal allocation lines into GL_INTERFACE from array |
| (create_journal ends here) |
| END journal line LOOP |
| CALLED BY |
| JG_ALLOCATE_JOURNALS_PKG.allocate |
--------------------------------------------------------------------------------*/
PROCEDURE create_journal IS
--
-- Rule Line cursor
--
CURSOR c_rule_line IS
SELECT natural_account NATURAL_ACCOUNT,
allocation_percent ALLOCATION_PERCENT,
offset_account OFFSET_ACCOUNT,
rule_line_id RULE_LINE_ID
FROM jg_zz_ta_rule_lines
WHERE account_range_id = JG_ALLOCATE_JOURNALS_PKG.G_journal_qry_rec.account_range_id;
JG_UTILITY_PKG.debug( 'Inserting Allocated Journal Line number '||to_char(j));
IF NOT JG_CREATE_JOURNALS_PKG.insert_gl_interface
(JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_dr,
JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_entered_cr,
JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_dr,
JG_CREATE_JOURNALS_PKG.alloc_lines_arr(j).destn_accted_cr,
FALSE) THEN
FND_MESSAGE.SET_NAME(JG_JOURNAL_ALLOCATIONS_PKG.G_JG_appln_short_name , 'JG_ZZ_GL_INTERFACE_INSERT');