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 86: v_reference_10 gl_interface.reference10%type;

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

Line 87: v_reference_23 gl_interface.reference23%type;

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

Line 88: v_reference_24 gl_interface.reference24%type;

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

Line 89: v_reference_25 gl_interface.reference25%type;

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

Line 90: v_reference_26 gl_interface.reference26%type;

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

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

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

Line 115: FILENAME: ja_in_gl_interface_p.sql

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

Line 121: in gl_interface and also changed the Insert statement

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

Line 122: of gl_interface to include organization code,

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

Line 132: is equal to the date_created in gl_interface.

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

Line 139: gl_interface table.

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

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

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

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

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

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

Line 252: INSERT into gl_interface

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

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

302: to_char(p_organization_id)
303: );
304: END IF;
305: IF v_debug='Y' THEN
306: FND_FILE.PUT_LINE(FND_FILE.LOG, '**********End of gl_interface_insert_new Procedure' );
307: END IF;
308: --Exception Introduced by Nagaraj.s for Bug2801751.
309: exception
310: when others then

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

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

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

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

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

327: v_created_by number;
328: v_last_update_date date;
329: v_last_updated_by number;
330: v_set_of_books_id number;
331: lv_status gl_interface.status%TYPE ;--rchandan for bug#4428980
332:
333: Begin
334: select set_of_books_id
335: into v_set_of_books_id

Line 340: INSERT into gl_interface(status,

336: From org_organization_definitions
337: where organization_id = n_organization_id;
338: If NVL(n_credit_amount,0) <> 0 Or NVL(n_debit_amount,0) <> 0 Then
339: lv_status := 'NEW';--rchandan for bug#4428980
340: INSERT into gl_interface(status,
341: set_of_books_id,
342: user_je_source_name,
343: user_je_category_name,
344: