The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT segment_num, application_column_name
FROM fnd_id_flex_segments
WHERE id_flex_num = coa_id
AND id_flex_code = c_flex_code
ORDER BY segment_num;
DBMS_SQL.PARSE(v_segment_cur, 'SELECT '||i.application_column_name||' FROM gl_code_combinations'
||' WHERE code_combination_id = :p_ccid', DBMS_SQL.NATIVE); -- Modified by Brathod, for 4407184 (Bind Var)
v_last_update_login number;
v_last_update_date date;
v_last_updated_by number;
select
substr(v_reference_10,1,240),
substr(p_reference_23,1,240),
substr(p_reference_24,1,240),
substr(p_reference_25,1,240),
substr(p_reference_26,1,240)
from dual;
select currency_Code
from gl_Sets_of_books
where set_of_books_id = cp_Set_of_books_id;
in gl_interface and also changed the Insert statement
of gl_interface to include organization code,
reference10,22,23,24,25,26,27 for Link to GL.
As Parameters are added, this is an huge dependency.
It is to be noted that the columns reference25 and 26 are swapped
to maintain upward compatibility.
2 20/02/2004 Nagaraj.s for Bug3456481. Version : 618.1
Accounting Date should not be punched with time stamp.
This may lead to a scenario where, GL Import Program
does not pick these records if the end date given as parameter
is equal to the date_created in gl_interface.
Hence trunc(v_accounting_date) is written to ensure that these
records are picked up.
3. 11/01/2005
ssumIth - bug# 4136981
fetch the currency code based on the set of books id retreived and use it for inserting into the
gl_interface table.
Future Dependencies For the release Of this Object:-
(Please add a row in the section below only if your bug introduces a dependency due to spec change/ A new call to a object/
A datamodel change )
----------------------------------------------------------------------------------------------------------------------------------------------------
Current Version Current Bug Dependent Files Version Author Date Remarks
Of File On Bug/Patchset Dependent On
ja_in_gl_interface_p.sql
----------------------------------------------------------------------------------------------------------------------------------------------------
616.1 2801751 IN60104D1+2801751 1. ja_in_gl_interface_p.sql
2. ja_in_receipt_acct_pkg.sql
3. ja_in_rma_receipt_p.sql
4. JAINRGAC.fmb
5. JAINRGCO.fmb
6. JAINRTVN.fmb
7. JAINPLAM.fmb
8. JAINOSPM.fmb
9. JAINIRGI.fmb
10. JAIN57F4.fmb
11. JAINIBOE.fmb
--------------------------------------------------------------------------------------------*/
BEGIN
v_reference_entry := 'India Localization Entry'; --Ramananda for File.Sql.35
FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside gl_interface_insert_new Procedure' );
INSERT into gl_interface
(status,
set_of_books_id,
user_je_source_name,
user_je_category_name,
accounting_date,
currency_code,
date_created,
created_by, actual_flag,
entered_cr,
entered_dr,
transaction_date,
code_combination_id,
currency_conversion_date,
user_currency_conversion_type,
currency_conversion_rate,
--These References are added by Nagaraj.s for Bug2801751
reference1,
reference10,
reference22,
reference23,
reference24,
reference25,
reference26,
reference27
)
VALUES (lv_status,--rchandan for bug#4428980
v_set_of_books_id,
p_je_source_name,
p_je_category_name,
v_accounting_date,
lv_currency_code , --p_currency_code,
sysdate,
p_created_by,
'A',
p_credit_amount,
p_debit_amount,
sysdate,
p_cc_id,
p_currency_conversion_date,
p_currency_conversion_type,
p_currency_conversion_rate,
--These References are added by Nagaraj.s for Bug2801751
v_organization_code,
v_reference_10,
v_reference_entry,
v_reference_23,
v_reference_24,
v_reference_26,
v_reference_25,
to_char(p_organization_id)
);
FND_FILE.PUT_LINE(FND_FILE.LOG, '**********End of gl_interface_insert_new Procedure' );
v_last_update_login number;
v_last_update_date date;
v_last_updated_by number;
select set_of_books_id
into v_set_of_books_id
From org_organization_definitions
where organization_id = n_organization_id;
INSERT into gl_interface(status,
set_of_books_id,
user_je_source_name,
user_je_category_name,
accounting_date,
currency_code,
date_created,
created_by,
actual_flag,
entered_cr,
entered_dr,
transaction_date,
code_combination_id)
VALUES
(lv_status,--rchandan for bug#4428980
v_set_of_books_id,
n_je_source_name,
n_je_category_name,
sysdate,
n_currency_code,
sysdate,
n_created_by,
'A',
n_credit_amount,
n_debit_amount,
sysdate,
n_cc_id);