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 120: credit_account gl_interface.code_combination_id%TYPE,

116: */
117:
118: TYPE gl_params IS RECORD (
119: amount NUMBER,
120: credit_account gl_interface.code_combination_id%TYPE,
121: debit_account gl_interface.code_combination_id%TYPE,
122: organization_id NUMBER,
123: organization_code gl_interface.reference1%TYPE,
124: remarks VARCHAR2(64));

Line 121: debit_account gl_interface.code_combination_id%TYPE,

117:
118: TYPE gl_params IS RECORD (
119: amount NUMBER,
120: credit_account gl_interface.code_combination_id%TYPE,
121: debit_account gl_interface.code_combination_id%TYPE,
122: organization_id NUMBER,
123: organization_code gl_interface.reference1%TYPE,
124: remarks VARCHAR2(64));
125:

Line 123: organization_code gl_interface.reference1%TYPE,

119: amount NUMBER,
120: credit_account gl_interface.code_combination_id%TYPE,
121: debit_account gl_interface.code_combination_id%TYPE,
122: organization_id NUMBER,
123: organization_code gl_interface.reference1%TYPE,
124: remarks VARCHAR2(64));
125:
126: TYPE gl_entries IS TABLE OF gl_params INDEX BY PLS_INTEGER;
127:

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

1120: IF p_params(i).amount IS NOT NULL AND
1121: p_params(i).debit_account IS NOT NULL AND
1122: p_params(i).credit_account IS NOT NULL
1123: THEN
1124: stmt_name := 'Calling insert into gl_interface debit';
1125: insert into gl_interface
1126: ( status,
1127: set_of_books_id,
1128: user_je_source_name,

Line 1125: insert into gl_interface

1121: p_params(i).debit_account IS NOT NULL AND
1122: p_params(i).credit_account IS NOT NULL
1123: THEN
1124: stmt_name := 'Calling insert into gl_interface debit';
1125: insert into gl_interface
1126: ( status,
1127: set_of_books_id,
1128: user_je_source_name,
1129: user_je_category_name,

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

1239: p_transaction_temp_id
1240: );
1241:
1242:
1243: stmt_name := 'Calling insert int gl_interface credit';
1244: insert into gl_interface
1245: ( status,
1246: set_of_books_id,
1247: user_je_source_name,

Line 1244: insert into gl_interface

1240: );
1241:
1242:
1243: stmt_name := 'Calling insert int gl_interface credit';
1244: insert into gl_interface
1245: ( status,
1246: set_of_books_id,
1247: user_je_source_name,
1248: user_je_category_name,

Line 3269: lv_status gl_interface.status%type;

3265: lv_organization_code org_organization_definitions.organization_code%type;
3266: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
3267:
3268: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3269: lv_status gl_interface.status%type;
3270: lv_reference_entry gl_interface.reference22%type;
3271: lv_reference_10 gl_interface.reference10%TYPE;
3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;

Line 3270: lv_reference_entry gl_interface.reference22%type;

3266: ln_set_of_books_id org_organization_definitions.set_of_books_id%type;
3267:
3268: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3269: lv_status gl_interface.status%type;
3270: lv_reference_entry gl_interface.reference22%type;
3271: lv_reference_10 gl_interface.reference10%TYPE;
3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;

Line 3271: lv_reference_10 gl_interface.reference10%TYPE;

3267:
3268: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3269: lv_status gl_interface.status%type;
3270: lv_reference_entry gl_interface.reference22%type;
3271: lv_reference_10 gl_interface.reference10%TYPE;
3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;

Line 3272: lv_reference_23 gl_interface.reference23%TYPE;

3268: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3269: lv_status gl_interface.status%type;
3270: lv_reference_entry gl_interface.reference22%type;
3271: lv_reference_10 gl_interface.reference10%TYPE;
3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;
3276: lv_source_name gl_interface.user_je_source_name%TYPE;

Line 3273: lv_reference_24 gl_interface.reference24%TYPE;

3269: lv_status gl_interface.status%type;
3270: lv_reference_entry gl_interface.reference22%type;
3271: lv_reference_10 gl_interface.reference10%TYPE;
3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;
3276: lv_source_name gl_interface.user_je_source_name%TYPE;
3277: lv_category_name gl_interface.user_je_category_name%TYPE;

Line 3274: lv_reference_25 gl_interface.reference25%TYPE;

3270: lv_reference_entry gl_interface.reference22%type;
3271: lv_reference_10 gl_interface.reference10%TYPE;
3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;
3276: lv_source_name gl_interface.user_je_source_name%TYPE;
3277: lv_category_name gl_interface.user_je_category_name%TYPE;
3278: lv_currency_code gl_interface.currency_code%TYPE;

Line 3275: lv_reference_26 gl_interface.reference26%TYPE;

3271: lv_reference_10 gl_interface.reference10%TYPE;
3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;
3276: lv_source_name gl_interface.user_je_source_name%TYPE;
3277: lv_category_name gl_interface.user_je_category_name%TYPE;
3278: lv_currency_code gl_interface.currency_code%TYPE;
3279:

Line 3276: lv_source_name gl_interface.user_je_source_name%TYPE;

3272: lv_reference_23 gl_interface.reference23%TYPE;
3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;
3276: lv_source_name gl_interface.user_je_source_name%TYPE;
3277: lv_category_name gl_interface.user_je_category_name%TYPE;
3278: lv_currency_code gl_interface.currency_code%TYPE;
3279:
3280: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/

Line 3277: lv_category_name gl_interface.user_je_category_name%TYPE;

3273: lv_reference_24 gl_interface.reference24%TYPE;
3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;
3276: lv_source_name gl_interface.user_je_source_name%TYPE;
3277: lv_category_name gl_interface.user_je_category_name%TYPE;
3278: lv_currency_code gl_interface.currency_code%TYPE;
3279:
3280: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/
3281: IS

Line 3278: lv_currency_code gl_interface.currency_code%TYPE;

3274: lv_reference_25 gl_interface.reference25%TYPE;
3275: lv_reference_26 gl_interface.reference26%TYPE;
3276: lv_source_name gl_interface.user_je_source_name%TYPE;
3277: lv_category_name gl_interface.user_je_category_name%TYPE;
3278: lv_currency_code gl_interface.currency_code%TYPE;
3279:
3280: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/
3281: IS
3282: select receiving_account_id

Line 3313: insert into gl_interface

3309: lv_status := 'NEW' ;
3310:
3311:
3312: /*The following code is all added/modified for rchandan for bug#6487489 to generate PPV accounting*/
3313: insert into gl_interface
3314: (
3315: status,
3316: set_of_books_id,
3317: user_je_source_name,

Line 3434: insert into gl_interface

3430:
3431: /*removed the insert to MTA by vkaranam for bug #6030615 as part of SLA uptake*/
3432:
3433:
3434: insert into gl_interface
3435: (
3436: status,
3437: set_of_books_id,
3438: user_je_source_name,

Line 3802: INSERT INTO GL_INTERFACE

3798: fnd_global.user_id,/*6497301*/
3799: fnd_global.login_id/*6497301*/
3800: );
3801:
3802: INSERT INTO GL_INTERFACE
3803: (
3804: status,
3805: set_of_books_id,
3806: user_je_source_name,

Line 3916: INSERT INTO GL_INTERFACE

3912: fnd_global.user_id,/*6497301*/
3913: fnd_global.login_id/*6497301*/
3914: );
3915:
3916: INSERT INTO GL_INTERFACE
3917: (
3918: status,
3919: set_of_books_id,
3920: user_je_source_name,

Line 4063: INSERT INTO GL_INTERFACE

4059: fnd_global.user_id,/*6497301*/
4060: fnd_global.login_id/*6497301*/
4061: );
4062:
4063: INSERT INTO GL_INTERFACE
4064: (
4065: status,
4066: set_of_books_id,
4067: user_je_source_name,

Line 4178: INSERT INTO GL_INTERFACE

4174: fnd_global.user_id,/*6497301*/
4175: fnd_global.login_id/*6497301*/
4176: );
4177:
4178: INSERT INTO GL_INTERFACE
4179: (
4180: status,
4181: set_of_books_id,
4182: user_je_source_name,

Line 4719: lv_reference_10 gl_interface.reference10%TYPE;

4715: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
4716:
4717: rec_claims cur_claims%ROWTYPE;
4718:
4719: lv_reference_10 gl_interface.reference10%TYPE;
4720: lv_reference_23 gl_interface.reference23%TYPE;
4721: lv_reference_24 gl_interface.reference24%TYPE;
4722: lv_reference_26 gl_interface.reference26%TYPE;
4723:

Line 4720: lv_reference_23 gl_interface.reference23%TYPE;

4716:
4717: rec_claims cur_claims%ROWTYPE;
4718:
4719: lv_reference_10 gl_interface.reference10%TYPE;
4720: lv_reference_23 gl_interface.reference23%TYPE;
4721: lv_reference_24 gl_interface.reference24%TYPE;
4722: lv_reference_26 gl_interface.reference26%TYPE;
4723:
4724: sqlstmt VARCHAR2(512);

Line 4721: lv_reference_24 gl_interface.reference24%TYPE;

4717: rec_claims cur_claims%ROWTYPE;
4718:
4719: lv_reference_10 gl_interface.reference10%TYPE;
4720: lv_reference_23 gl_interface.reference23%TYPE;
4721: lv_reference_24 gl_interface.reference24%TYPE;
4722: lv_reference_26 gl_interface.reference26%TYPE;
4723:
4724: sqlstmt VARCHAR2(512);
4725: BEGIN

Line 4722: lv_reference_26 gl_interface.reference26%TYPE;

4718:
4719: lv_reference_10 gl_interface.reference10%TYPE;
4720: lv_reference_23 gl_interface.reference23%TYPE;
4721: lv_reference_24 gl_interface.reference24%TYPE;
4722: lv_reference_26 gl_interface.reference26%TYPE;
4723:
4724: sqlstmt VARCHAR2(512);
4725: BEGIN
4726: