eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_GL_PKG dependencies on GL_INTERFACE

Line 87: v_reference_10 gl_interface.reference10%type;

83: v_accounting_date date;
84: v_organization_code org_organization_definitions.organization_code%type;
85: v_reference_entry varchar2(240); -- := 'India Localization Entry'; --Ramananda for File.Sql.35
86: v_debug char(1); -- :='Y'; --Ramananda for File.Sql.35
87: v_reference_10 gl_interface.reference10%type;
88: v_reference_23 gl_interface.reference23%type;
89: v_reference_24 gl_interface.reference24%type;
90: v_reference_25 gl_interface.reference25%type;
91: v_reference_26 gl_interface.reference26%type;

Line 88: v_reference_23 gl_interface.reference23%type;

84: v_organization_code org_organization_definitions.organization_code%type;
85: v_reference_entry varchar2(240); -- := 'India Localization Entry'; --Ramananda for File.Sql.35
86: v_debug char(1); -- :='Y'; --Ramananda for File.Sql.35
87: v_reference_10 gl_interface.reference10%type;
88: v_reference_23 gl_interface.reference23%type;
89: v_reference_24 gl_interface.reference24%type;
90: v_reference_25 gl_interface.reference25%type;
91: v_reference_26 gl_interface.reference26%type;
92: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980

Line 89: v_reference_24 gl_interface.reference24%type;

85: v_reference_entry varchar2(240); -- := 'India Localization Entry'; --Ramananda for File.Sql.35
86: v_debug char(1); -- :='Y'; --Ramananda for File.Sql.35
87: v_reference_10 gl_interface.reference10%type;
88: v_reference_23 gl_interface.reference23%type;
89: v_reference_24 gl_interface.reference24%type;
90: v_reference_25 gl_interface.reference25%type;
91: v_reference_26 gl_interface.reference26%type;
92: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980
93:

Line 90: v_reference_25 gl_interface.reference25%type;

86: v_debug char(1); -- :='Y'; --Ramananda for File.Sql.35
87: v_reference_10 gl_interface.reference10%type;
88: v_reference_23 gl_interface.reference23%type;
89: v_reference_24 gl_interface.reference24%type;
90: v_reference_25 gl_interface.reference25%type;
91: v_reference_26 gl_interface.reference26%type;
92: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980
93:
94: cursor c_trunc_references is

Line 91: v_reference_26 gl_interface.reference26%type;

87: v_reference_10 gl_interface.reference10%type;
88: v_reference_23 gl_interface.reference23%type;
89: v_reference_24 gl_interface.reference24%type;
90: v_reference_25 gl_interface.reference25%type;
91: v_reference_26 gl_interface.reference26%type;
92: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980
93:
94: cursor c_trunc_references is
95: select

Line 92: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980

88: v_reference_23 gl_interface.reference23%type;
89: v_reference_24 gl_interface.reference24%type;
90: v_reference_25 gl_interface.reference25%type;
91: v_reference_26 gl_interface.reference26%type;
92: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980
93:
94: cursor c_trunc_references is
95: select
96: substr(v_reference_10,1,240),

Line 116: FILENAME: ja_in_gl_interface_p.sql

112: */
113: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
114:
115: /*------------------------------------------------------------------------------------------
116: FILENAME: ja_in_gl_interface_p.sql
117:
118: CHANGE HISTORY:
119: S.No Date Author and Details
120: 1 08/08/2003 By Nagaraj.s for Bug2801751 Version : 616.1

Line 122: in gl_interface and also changed the Insert statement

118: CHANGE HISTORY:
119: S.No Date Author and Details
120: 1 08/08/2003 By Nagaraj.s for Bug2801751 Version : 616.1
121: Added 5 parameters to capture the reference values
122: in gl_interface and also changed the Insert statement
123: of gl_interface to include organization code,
124: reference10,22,23,24,25,26,27 for Link to GL.
125: As Parameters are added, this is an huge dependency.
126: It is to be noted that the columns reference25 and 26 are swapped

Line 123: of gl_interface to include organization code,

119: S.No Date Author and Details
120: 1 08/08/2003 By Nagaraj.s for Bug2801751 Version : 616.1
121: Added 5 parameters to capture the reference values
122: in gl_interface and also changed the Insert statement
123: of gl_interface to include organization code,
124: reference10,22,23,24,25,26,27 for Link to GL.
125: As Parameters are added, this is an huge dependency.
126: It is to be noted that the columns reference25 and 26 are swapped
127: to maintain upward compatibility.

Line 133: is equal to the date_created in gl_interface.

129: 2 20/02/2004 Nagaraj.s for Bug3456481. Version : 618.1
130: Accounting Date should not be punched with time stamp.
131: This may lead to a scenario where, GL Import Program
132: does not pick these records if the end date given as parameter
133: is equal to the date_created in gl_interface.
134: Hence trunc(v_accounting_date) is written to ensure that these
135: records are picked up.
136:
137: 3. 11/01/2005

Line 140: gl_interface table.

136:
137: 3. 11/01/2005
138: ssumIth - bug# 4136981
139: fetch the currency code based on the set of books id retreived and use it for inserting into the
140: gl_interface table.
141:
142:
143: Future Dependencies For the release Of this Object:-
144: (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/

Line 150: ja_in_gl_interface_p.sql

146:
147: ----------------------------------------------------------------------------------------------------------------------------------------------------
148: Current Version Current Bug Dependent Files Version Author Date Remarks
149: Of File On Bug/Patchset Dependent On
150: ja_in_gl_interface_p.sql
151: ----------------------------------------------------------------------------------------------------------------------------------------------------
152: 616.1 2801751 IN60104D1+2801751 1. ja_in_gl_interface_p.sql
153: 2. ja_in_receipt_acct_pkg.sql
154: 3. ja_in_rma_receipt_p.sql

Line 152: 616.1 2801751 IN60104D1+2801751 1. ja_in_gl_interface_p.sql

148: Current Version Current Bug Dependent Files Version Author Date Remarks
149: Of File On Bug/Patchset Dependent On
150: ja_in_gl_interface_p.sql
151: ----------------------------------------------------------------------------------------------------------------------------------------------------
152: 616.1 2801751 IN60104D1+2801751 1. ja_in_gl_interface_p.sql
153: 2. ja_in_receipt_acct_pkg.sql
154: 3. ja_in_rma_receipt_p.sql
155: 4. JAINRGAC.fmb
156: 5. JAINRGCO.fmb

Line 212: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside gl_interface_insert_new Procedure' );

208: v_reference_26;
209: close c_trunc_references;
210:
211: IF v_debug='Y' THEN
212: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********Inside gl_interface_insert_new Procedure' );
213: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.0 The Value of v_reference_10 is ' || v_reference_10 );
214: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.1 The Value of v_reference_23 is ' || v_reference_23 );
215: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.2 The Value of v_reference_24 is ' || v_reference_24 );
216: FND_FILE.PUT_LINE(FND_FILE.LOG, '9.3 The Value of v_reference_25 is ' || v_reference_25 );

Line 253: INSERT into gl_interface

249: --the upward compatibility of the existing feature and this decision was done, after the code
250: --was implemented and hence now reference25 is populated with p_reference_26 and reference26
251: --is populated with p_reference_25.
252: lv_status := 'NEW';----rchandan for bug#4428980
253: INSERT into gl_interface
254: (status,
255: set_of_books_id,
256: user_je_source_name,
257: user_je_category_name,

Line 311: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********End of gl_interface_insert_new Procedure' );

307: to_char(p_organization_id)
308: );
309: END IF;
310: IF v_debug='Y' THEN
311: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********End of gl_interface_insert_new Procedure' );
312: END IF;
313: --Exception Introduced by Nagaraj.s for Bug2801751.
314: exception
315: when others then

Line 317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error is raised in gl_interface procedure ' || sqlerrm );

313: --Exception Introduced by Nagaraj.s for Bug2801751.
314: exception
315: when others then
316: IF v_debug='Y' THEN
317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error is raised in gl_interface procedure ' || sqlerrm );
318: END IF;
319: raise_application_error(-20106,'Error is raised in gl_interface procedure ' || sqlerrm);
320: END create_gl_entry;
321:

Line 319: raise_application_error(-20106,'Error is raised in gl_interface procedure ' || sqlerrm);

315: when others then
316: IF v_debug='Y' THEN
317: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error is raised in gl_interface procedure ' || sqlerrm );
318: END IF;
319: raise_application_error(-20106,'Error is raised in gl_interface procedure ' || sqlerrm);
320: END create_gl_entry;
321:
322: Procedure create_gl_entry_for_opm(n_organization_id number,
323: n_currency_code varchar2,

Line 336: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980

332: v_created_by number;
333: v_last_update_date date;
334: v_last_updated_by number;
335: v_set_of_books_id number;
336: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980
337:
338: Begin
339: select set_of_books_id
340: into v_set_of_books_id

Line 345: INSERT into gl_interface(status,

341: From org_organization_definitions
342: where organization_id = n_organization_id;
343: If NVL(n_credit_amount,0) <> 0 Or NVL(n_debit_amount,0) <> 0 Then
344: lv_status := 'NEW';--rchandan for bug#4428980
345: INSERT into gl_interface(status,
346: set_of_books_id,
347: user_je_source_name,
348: user_je_category_name,
349: accounting_date,