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_MTL_TRXS_PKG dependencies on GL_INTERFACE

Line 96: Fix : In the gl_interface table the user_je_category_name should be populated as

92: recoverable tax which was not hitting the register and also not included in the accounting.
93:
94: 16. 16/10/2007 rchandan for bug#6504150, File Version 120.15
95: Issue : R12RUP04.I/ORG.QA.ST1:USER_JE_CATEGORY_NAM TO BE CHANGED FOR PPV ENTRY
96: Fix : In the gl_interface table the user_je_category_name should be populated as
97: 'MTL' for PPV entry which is being generated for the receiving org in the
98: Direct Org Transfer. Made a change to this effect.
99:
100: 17. 12-May-2008 Changes by nprashar for bug # 6710747. Forward ported from 11i bug#6086452.

Line 243: credit_account gl_interface.code_combination_id%TYPE,

239: */
240:
241: TYPE gl_params IS RECORD (
242: amount NUMBER,
243: credit_account gl_interface.code_combination_id%TYPE,
244: debit_account gl_interface.code_combination_id%TYPE,
245: organization_id NUMBER,
246: organization_code gl_interface.reference1%TYPE,
247: remarks VARCHAR2(64));

Line 244: debit_account gl_interface.code_combination_id%TYPE,

240:
241: TYPE gl_params IS RECORD (
242: amount NUMBER,
243: credit_account gl_interface.code_combination_id%TYPE,
244: debit_account gl_interface.code_combination_id%TYPE,
245: organization_id NUMBER,
246: organization_code gl_interface.reference1%TYPE,
247: remarks VARCHAR2(64));
248:

Line 246: organization_code gl_interface.reference1%TYPE,

242: amount NUMBER,
243: credit_account gl_interface.code_combination_id%TYPE,
244: debit_account gl_interface.code_combination_id%TYPE,
245: organization_id NUMBER,
246: organization_code gl_interface.reference1%TYPE,
247: remarks VARCHAR2(64));
248:
249: TYPE gl_entries IS TABLE OF gl_params INDEX BY PLS_INTEGER;
250:

Line 1252: stmt_name := 'Calling insert into gl_interface debit';

1248: IF p_params(i).amount IS NOT NULL AND
1249: p_params(i).debit_account IS NOT NULL AND
1250: p_params(i).credit_account IS NOT NULL
1251: THEN
1252: stmt_name := 'Calling insert into gl_interface debit';
1253: insert into gl_interface
1254: ( status,
1255: set_of_books_id,
1256: user_je_source_name,

Line 1253: insert into gl_interface

1249: p_params(i).debit_account IS NOT NULL AND
1250: p_params(i).credit_account IS NOT NULL
1251: THEN
1252: stmt_name := 'Calling insert into gl_interface debit';
1253: insert into gl_interface
1254: ( status,
1255: set_of_books_id,
1256: user_je_source_name,
1257: user_je_category_name,

Line 1371: stmt_name := 'Calling insert int gl_interface credit';

1367: p_transaction_temp_id
1368: );
1369:
1370:
1371: stmt_name := 'Calling insert int gl_interface credit';
1372: insert into gl_interface
1373: ( status,
1374: set_of_books_id,
1375: user_je_source_name,

Line 1372: insert into gl_interface

1368: );
1369:
1370:
1371: stmt_name := 'Calling insert int gl_interface credit';
1372: insert into gl_interface
1373: ( status,
1374: set_of_books_id,
1375: user_je_source_name,
1376: user_je_category_name,

Line 3433: lv_status gl_interface.status%type;

3429: lv_organization_code org_organization_definitions.organization_code%type;
3430: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
3431:
3432: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3433: lv_status gl_interface.status%type;
3434: lv_reference_entry gl_interface.reference22%type;
3435: lv_reference_10 gl_interface.reference10%TYPE;
3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;

Line 3434: lv_reference_entry gl_interface.reference22%type;

3430: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
3431:
3432: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3433: lv_status gl_interface.status%type;
3434: lv_reference_entry gl_interface.reference22%type;
3435: lv_reference_10 gl_interface.reference10%TYPE;
3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;

Line 3435: lv_reference_10 gl_interface.reference10%TYPE;

3431:
3432: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3433: lv_status gl_interface.status%type;
3434: lv_reference_entry gl_interface.reference22%type;
3435: lv_reference_10 gl_interface.reference10%TYPE;
3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;

Line 3436: lv_reference_23 gl_interface.reference23%TYPE;

3432: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3433: lv_status gl_interface.status%type;
3434: lv_reference_entry gl_interface.reference22%type;
3435: lv_reference_10 gl_interface.reference10%TYPE;
3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;
3440: lv_source_name gl_interface.user_je_source_name%TYPE;

Line 3437: lv_reference_24 gl_interface.reference24%TYPE;

3433: lv_status gl_interface.status%type;
3434: lv_reference_entry gl_interface.reference22%type;
3435: lv_reference_10 gl_interface.reference10%TYPE;
3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;
3440: lv_source_name gl_interface.user_je_source_name%TYPE;
3441: lv_category_name gl_interface.user_je_category_name%TYPE;

Line 3438: lv_reference_25 gl_interface.reference25%TYPE;

3434: lv_reference_entry gl_interface.reference22%type;
3435: lv_reference_10 gl_interface.reference10%TYPE;
3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;
3440: lv_source_name gl_interface.user_je_source_name%TYPE;
3441: lv_category_name gl_interface.user_je_category_name%TYPE;
3442: lv_currency_code gl_interface.currency_code%TYPE;

Line 3439: lv_reference_26 gl_interface.reference26%TYPE;

3435: lv_reference_10 gl_interface.reference10%TYPE;
3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;
3440: lv_source_name gl_interface.user_je_source_name%TYPE;
3441: lv_category_name gl_interface.user_je_category_name%TYPE;
3442: lv_currency_code gl_interface.currency_code%TYPE;
3443:

Line 3440: lv_source_name gl_interface.user_je_source_name%TYPE;

3436: lv_reference_23 gl_interface.reference23%TYPE;
3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;
3440: lv_source_name gl_interface.user_je_source_name%TYPE;
3441: lv_category_name gl_interface.user_je_category_name%TYPE;
3442: lv_currency_code gl_interface.currency_code%TYPE;
3443:
3444: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/

Line 3441: lv_category_name gl_interface.user_je_category_name%TYPE;

3437: lv_reference_24 gl_interface.reference24%TYPE;
3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;
3440: lv_source_name gl_interface.user_je_source_name%TYPE;
3441: lv_category_name gl_interface.user_je_category_name%TYPE;
3442: lv_currency_code gl_interface.currency_code%TYPE;
3443:
3444: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/
3445: IS

Line 3442: lv_currency_code gl_interface.currency_code%TYPE;

3438: lv_reference_25 gl_interface.reference25%TYPE;
3439: lv_reference_26 gl_interface.reference26%TYPE;
3440: lv_source_name gl_interface.user_je_source_name%TYPE;
3441: lv_category_name gl_interface.user_je_category_name%TYPE;
3442: lv_currency_code gl_interface.currency_code%TYPE;
3443:
3444: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/
3445: IS
3446: select receiving_account_id

Line 3477: insert into gl_interface

3473: lv_status := 'NEW' ;
3474:
3475:
3476: /*The following code is all added/modified for rchandan for bug#6487489 to generate PPV accounting*/
3477: insert into gl_interface
3478: (
3479: status,
3480: set_of_books_id,
3481: user_je_source_name,

Line 3598: insert into gl_interface

3594:
3595: /*removed the insert to MTA by vkaranam for bug #6030615 as part of SLA uptake*/
3596:
3597:
3598: insert into gl_interface
3599: (
3600: status,
3601: set_of_books_id,
3602: user_je_source_name,

Line 3978: INSERT INTO GL_INTERFACE

3974: fnd_global.user_id,/*6497301*/
3975: fnd_global.login_id/*6497301*/
3976: );
3977: --cr excise receivable accnt
3978: INSERT INTO GL_INTERFACE
3979: (
3980: status,
3981: set_of_books_id,
3982: user_je_source_name,

Line 4093: INSERT INTO GL_INTERFACE

4089: fnd_global.user_id,/*6497301*/
4090: fnd_global.login_id/*6497301*/
4091: );
4092: --dr modvat cg acount
4093: INSERT INTO GL_INTERFACE
4094: (
4095: status,
4096: set_of_books_id,
4097: user_je_source_name,

Line 4271: INSERT INTO GL_INTERFACE

4267: fnd_global.user_id,/*6497301*/
4268: fnd_global.login_id/*6497301*/
4269: );
4270: --cr excise cess recvable accnt --10607819
4271: INSERT INTO GL_INTERFACE
4272: (
4273: status,
4274: set_of_books_id,
4275: user_je_source_name,

Line 4386: INSERT INTO GL_INTERFACE

4382: fnd_global.user_id,/*6497301*/
4383: fnd_global.login_id/*6497301*/
4384: );
4385: --dr edu cess cg account 10607819
4386: INSERT INTO GL_INTERFACE
4387: (
4388: status,
4389: set_of_books_id,
4390: user_je_source_name,

Line 4502: INSERT INTO GL_INTERFACE

4498: fnd_global.user_id,/*6497301*/
4499: fnd_global.login_id/*6497301*/
4500: );
4501: --cr excise rcvble accnt 10607819
4502: INSERT INTO GL_INTERFACE
4503: (
4504: status,
4505: set_of_books_id,
4506: user_je_source_name,

Line 4617: INSERT INTO GL_INTERFACE

4613: fnd_global.user_id,/*6497301*/
4614: fnd_global.login_id/*6497301*/
4615: );
4616: --dr cg accnt 10607819
4617: INSERT INTO GL_INTERFACE
4618: (
4619: status,
4620: set_of_books_id,
4621: user_je_source_name,

Line 5162: lv_reference_10 gl_interface.reference10%TYPE;

5158: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
5159:
5160: rec_claims cur_claims%ROWTYPE;
5161:
5162: lv_reference_10 gl_interface.reference10%TYPE;
5163: lv_reference_23 gl_interface.reference23%TYPE;
5164: lv_reference_24 gl_interface.reference24%TYPE;
5165: lv_reference_26 gl_interface.reference26%TYPE;
5166:

Line 5163: lv_reference_23 gl_interface.reference23%TYPE;

5159:
5160: rec_claims cur_claims%ROWTYPE;
5161:
5162: lv_reference_10 gl_interface.reference10%TYPE;
5163: lv_reference_23 gl_interface.reference23%TYPE;
5164: lv_reference_24 gl_interface.reference24%TYPE;
5165: lv_reference_26 gl_interface.reference26%TYPE;
5166:
5167: sqlstmt VARCHAR2(512);

Line 5164: lv_reference_24 gl_interface.reference24%TYPE;

5160: rec_claims cur_claims%ROWTYPE;
5161:
5162: lv_reference_10 gl_interface.reference10%TYPE;
5163: lv_reference_23 gl_interface.reference23%TYPE;
5164: lv_reference_24 gl_interface.reference24%TYPE;
5165: lv_reference_26 gl_interface.reference26%TYPE;
5166:
5167: sqlstmt VARCHAR2(512);
5168: BEGIN

Line 5165: lv_reference_26 gl_interface.reference26%TYPE;

5161:
5162: lv_reference_10 gl_interface.reference10%TYPE;
5163: lv_reference_23 gl_interface.reference23%TYPE;
5164: lv_reference_24 gl_interface.reference24%TYPE;
5165: lv_reference_26 gl_interface.reference26%TYPE;
5166:
5167: sqlstmt VARCHAR2(512);
5168: BEGIN
5169: