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.ZX_CORE_REP_EXTRACT_PKG dependencies on ZX_REP_TRX_JX_EXT_T

Line 10: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;

6: --Private Methods Declarations
7: -----------------------------------------
8:
9: TYPE ATTRIBUTE1_TBL IS TABLE OF
10: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
11:
12: TYPE ATTRIBUTE2_TBL IS TABLE OF
13: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
14:

Line 13: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;

9: TYPE ATTRIBUTE1_TBL IS TABLE OF
10: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE1%TYPE INDEX BY BINARY_INTEGER;
11:
12: TYPE ATTRIBUTE2_TBL IS TABLE OF
13: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
14:
15: TYPE ATTRIBUTE3_TBL IS TABLE OF
16: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
17:

Line 16: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;

12: TYPE ATTRIBUTE2_TBL IS TABLE OF
13: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE2%TYPE INDEX BY BINARY_INTEGER;
14:
15: TYPE ATTRIBUTE3_TBL IS TABLE OF
16: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
17:
18: TYPE ATTRIBUTE4_TBL IS TABLE OF
19: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
20:

Line 19: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;

15: TYPE ATTRIBUTE3_TBL IS TABLE OF
16: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE3%TYPE INDEX BY BINARY_INTEGER;
17:
18: TYPE ATTRIBUTE4_TBL IS TABLE OF
19: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
20:
21: TYPE ATTRIBUTE5_TBL IS TABLE OF
22: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
23:

Line 22: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;

18: TYPE ATTRIBUTE4_TBL IS TABLE OF
19: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE4%TYPE INDEX BY BINARY_INTEGER;
20:
21: TYPE ATTRIBUTE5_TBL IS TABLE OF
22: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
23:
24: TYPE ATTRIBUTE6_TBL IS TABLE OF
25: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
26:

Line 25: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;

21: TYPE ATTRIBUTE5_TBL IS TABLE OF
22: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE5%TYPE INDEX BY BINARY_INTEGER;
23:
24: TYPE ATTRIBUTE6_TBL IS TABLE OF
25: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
26:
27: TYPE ATTRIBUTE7_TBL IS TABLE OF
28: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
29:

Line 28: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;

24: TYPE ATTRIBUTE6_TBL IS TABLE OF
25: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE6%TYPE INDEX BY BINARY_INTEGER;
26:
27: TYPE ATTRIBUTE7_TBL IS TABLE OF
28: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
29:
30: --Bug 5251425
31: TYPE TRX_CURRENCY_DESC_TBL IS TABLE OF
32: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;

Line 32: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;

28: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE7%TYPE INDEX BY BINARY_INTEGER;
29:
30: --Bug 5251425
31: TYPE TRX_CURRENCY_DESC_TBL IS TABLE OF
32: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
33:
34: TYPE batch_name_tbl IS TABLE OF
35: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
36:

Line 35: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;

31: TYPE TRX_CURRENCY_DESC_TBL IS TABLE OF
32: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE9%TYPE INDEX BY BINARY_INTEGER;
33:
34: TYPE batch_name_tbl IS TABLE OF
35: ZX_REP_TRX_JX_EXT_T.ATTRIBUTE8%TYPE INDEX BY BINARY_INTEGER;
36:
37: TYPE CCID_TBL IS TABLE OF
38: ZX_REP_ACTG_EXT_T.ACTG_LINE_CCID%TYPE INDEX BY BINARY_INTEGER;
39:

Line 43: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;

39:
40: TYPE NUMBER_TBL is table of number index by binary_integer;
41:
42: TYPE NUMERIC1_TBL IS TABLE OF
43: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
44:
45: TYPE NUMERIC2_TBL IS TABLE OF
46: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
47:

Line 46: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;

42: TYPE NUMERIC1_TBL IS TABLE OF
43: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
44:
45: TYPE NUMERIC2_TBL IS TABLE OF
46: ZX_REP_TRX_JX_EXT_T.NUMERIC2%TYPE INDEX BY BINARY_INTEGER;
47:
48: TYPE ACC_CCID_TBL IS TABLE OF ZX_ACCOUNTS.TAX_ACCOUNT_CCID%TYPE;
49:
50: -----------------------------------------

Line 187: INSERT INTO zx_rep_trx_jx_ext_t

183:
184:
185: IF P_REPORT_NAME = 'ZXXTATAT' THEN
186: BEGIN
187: INSERT INTO zx_rep_trx_jx_ext_t
188: (detail_tax_line_ext_id,
189: detail_tax_line_id,
190: attribute1,
191: created_by,

Line 197: (SELECT zx_rep_trx_jx_ext_t_s.nextval,

193: last_updated_by,
194: last_update_date,
195: last_update_login,
196: request_id)
197: (SELECT zx_rep_trx_jx_ext_t_s.nextval,
198: dtl.detail_tax_line_id,
199: 'Yes', --fl.meaning,
200: dtl.created_by,
201: dtl.creation_date,

Line 262: 'Before insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );

258: );
259:
260: IF (g_level_statement >= g_current_runtime_level ) THEN
261: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
262: 'Before insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );
263: END IF;
264:
265: FORALL i IN nvl(l_detail_tax_line_id_tbl.FIRST,1)..nvl(l_detail_tax_line_id_tbl.LAST,0)
266: MERGE INTO zx_rep_trx_jx_ext_t ext

Line 266: MERGE INTO zx_rep_trx_jx_ext_t ext

262: 'Before insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );
263: END IF;
264:
265: FORALL i IN nvl(l_detail_tax_line_id_tbl.FIRST,1)..nvl(l_detail_tax_line_id_tbl.LAST,0)
266: MERGE INTO zx_rep_trx_jx_ext_t ext
267: USING ( SELECT 1 FROM dual ) T
268: ON ( ext.detail_tax_line_id = l_detail_tax_line_id_tbl(i))
269: WHEN MATCHED THEN UPDATE SET ext.ATTRIBUTE9 = l_trx_currency_desc_tbl(i),
270: ext.attribute8 = l_batch_name_tbl(i),

Line 286: VALUES ( ZX_MIGRATE_UTIL.get_next_seqid('ZX_REP_TRX_JX_EXT_T_S'),

282: last_update_date,
283: last_update_login,
284: request_id
285: )
286: VALUES ( ZX_MIGRATE_UTIL.get_next_seqid('ZX_REP_TRX_JX_EXT_T_S'),
287: l_detail_tax_line_id_tbl(i),
288: l_trx_currency_desc_tbl(i),
289: l_batch_name_tbl(i),
290: l_match_tbl(i),

Line 408: INSERT INTO zx_rep_trx_jx_ext_t

404:
405:
406: FORALL i in nvl(l_detail_tax_line_id_tbl.first,1)..nvl(l_detail_tax_line_id_tbl.last,0)
407:
408: INSERT INTO zx_rep_trx_jx_ext_t
409: (detail_tax_line_ext_id,
410: detail_tax_line_id,
411: attribute1,
412: attribute2,

Line 421: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

417: creation_date,
418: last_updated_by,
419: last_update_date,
420: last_update_login)
421: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
422: l_detail_tax_line_id_tbl(i),
423: l_org_vat_num_tbl(i),
424: l_territory_short_name_tbl(i),
425: l_alternate_territory_name_tbl(i),

Line 436: 'After insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );

432: fnd_global.login_id);
433:
434: IF (g_level_statement >= g_current_runtime_level ) THEN
435: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
436: 'After insertion into zx_rep_trx_jx_ext_t for report '||p_report_name );
437: END IF;
438:
439: -- Delete Unwanted lines from Detail ITF
440:

Line 444: FROM zx_rep_trx_jx_ext_t ext

440:
441: DELETE FROM zx_rep_trx_detail_t itf
442: WHERE itf.request_id = p_request_id
443: AND NOT EXISTS ( SELECT 1
444: FROM zx_rep_trx_jx_ext_t ext
445: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
446:
447: IF (g_level_statement >= g_current_runtime_level ) THEN
448: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',

Line 493: INSERT INTO zx_rep_trx_jx_ext_t

489: 'After getting adjustment tax code for Italy, Poland, Portugal countries');
490: END IF;
491:
492: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
493: INSERT INTO zx_rep_trx_jx_ext_t
494: (detail_tax_line_ext_id,
495: detail_tax_line_id,
496: attribute1,
497: created_by,

Line 502: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

498: creation_date,
499: last_updated_by,
500: last_update_date,
501: last_update_login)
502: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
503: l_detail_tax_line_id_tbl(i),
504: l_adj_tax_code_tbl(i),
505: fnd_global.user_id,
506: sysdate,

Line 513: 'After insertion into zx_rep_trx_jx_ext_t ');

509: fnd_global.login_id);
510:
511: IF (g_level_statement >= g_current_runtime_level ) THEN
512: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AP',
513: 'After insertion into zx_rep_trx_jx_ext_t ');
514: END IF;
515:
516: EXCEPTION
517: WHEN OTHERS THEN

Line 1176: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,

1172: -- Insert lines into JX EXT Table with Calculated amount --
1173:
1174: FORALL i in l_detail_tax_line_id_tbl.first..l_detail_tax_line_id_tbl.last
1175:
1176: INSERT INTO zx_rep_trx_jx_ext_t(detail_tax_line_ext_id,
1177: detail_tax_line_id,
1178: attribute1,
1179: attribute2,
1180: attribute3,

Line 1186: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1182: creation_date,
1183: last_updated_by,
1184: last_update_date,
1185: last_update_login)
1186: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1187: l_detail_tax_line_id_tbl(i),
1188: l_state_tbl(i),
1189: l_county_tbl(i),
1190: l_city_tbl(i),

Line 1199: 'After insertion into zx_rep_trx_jx_ext_t ');

1195: fnd_global.login_id);
1196:
1197: IF ( g_level_statement>= g_current_runtime_level ) THEN
1198: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1199: 'After insertion into zx_rep_trx_jx_ext_t ');
1200: END IF;
1201:
1202: -- Delete Unwanted lines from Detail ITF
1203:

Line 1208: FROM zx_rep_trx_jx_ext_t ext

1204: BEGIN
1205: DELETE from zx_rep_trx_detail_t itf
1206: WHERE itf.request_id = p_request_id
1207: AND NOT EXISTS ( SELECT 1
1208: FROM zx_rep_trx_jx_ext_t ext
1209: WHERE ext.detail_tax_line_id = itf.detail_tax_line_id);
1210:
1211: IF ( g_level_statement>= g_current_runtime_level ) THEN
1212: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',

Line 1232: --Bug 5251425 : To Populate General Ledger Activity(C_GL_ACTIVITY_DISP) and C_BAL_SEGMENT_PROMPT into ZX_REP_TRX_JX_EXT_T.numeric1 and ZX_REP_TRX_JX_EXT_T.attribute1 respectively ..

1228: */
1229: END;
1230: END IF; -- End of P_REPORT_NAME = ..
1231:
1232: --Bug 5251425 : To Populate General Ledger Activity(C_GL_ACTIVITY_DISP) and C_BAL_SEGMENT_PROMPT into ZX_REP_TRX_JX_EXT_T.numeric1 and ZX_REP_TRX_JX_EXT_T.attribute1 respectively ..
1233: IF ( p_report_name = 'ZXXVATRN' ) THEN
1234: -- get details for C_GL_ACTIVITY_DISP
1235: BEGIN
1236: /* select gl.set_of_books_id

Line 1412: INSERT INTO ZX_REP_TRX_JX_EXT_T

1408: l_bal_seg_prompt_tbl(i) := l_prompt ;
1409: END LOOP ;
1410:
1411: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1412: INSERT INTO ZX_REP_TRX_JX_EXT_T
1413: (
1414: detail_tax_line_ext_id,
1415: detail_tax_line_id,
1416: numeric1,

Line 1426: zx_rep_trx_jx_ext_t_s.nextval,

1422: last_update_login
1423: )
1424: VALUES
1425: (
1426: zx_rep_trx_jx_ext_t_s.nextval,
1427: l_detail_tax_line_id_tbl(i),
1428: l_gl_activity_tbl(i),
1429: l_bal_seg_prompt_tbl(i),
1430: fnd_global.user_id,

Line 1439: 'After insertion into zx_rep_trx_jx_ext_t ');

1435: );
1436:
1437: IF ( g_level_statement>= g_current_runtime_level ) THEN
1438: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1439: 'After insertion into zx_rep_trx_jx_ext_t ');
1440: END IF;
1441:
1442: EXCEPTION WHEN OTHERS THEN
1443: -- NULL ;

Line 1486: INSERT INTO ZX_REP_TRX_JX_EXT_T

1482: l_tax_received_tbl
1483: );
1484:
1485: FORALL i in 1 .. nvl(l_detail_tax_line_id_tbl.last, 0)
1486: INSERT INTO ZX_REP_TRX_JX_EXT_T
1487: (detail_tax_line_ext_id,
1488: detail_tax_line_id,
1489: numeric1, --C_TAX_AMOUNT_RECEIVED
1490: numeric2,--C_AMOUNT_RECEIVED

Line 1496: VALUES (zx_rep_trx_jx_ext_t_s.nextval,

1492: creation_date,
1493: last_updated_by,
1494: last_update_date,
1495: last_update_login)
1496: VALUES (zx_rep_trx_jx_ext_t_s.nextval,
1497: l_detail_tax_line_id_tbl(i),
1498: l_tax_received_tbl(i),
1499: l_amount_received_tbl(i),
1500: fnd_global.user_id,

Line 1508: 'After insertion into zx_rep_trx_jx_ext_t ');

1504: fnd_global.login_id);
1505:
1506: IF ( g_level_statement>= g_current_runtime_level ) THEN
1507: FND_LOG.STRING(g_level_statement, 'ZX.TRL.ZX_CORE_REP_EXTRACT_PKG.POPULATE_CORE_AR',
1508: 'After insertion into zx_rep_trx_jx_ext_t ');
1509: END IF;
1510:
1511:
1512: END IF ;