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.XLA_REPORTING_SEQUENCE_PKG dependencies on XLA_SEQ_JE_HEADERS_GT

Line 972: FROM xla_seq_je_headers_gt xgt

968: ,gjh.close_acct_seq_assign_id) =
969: (select xgt.sequence_value
970: ,xgt.sequence_version_id
971: ,xgt.sequence_assign_id
972: FROM xla_seq_je_headers_gt xgt
973: WHERE xgt.application_id = 101
974: AND gjh.je_header_id = xgt.ae_header_id)
975: WHERE gjh.je_header_id in (select ae_header_id from xla_seq_je_headers_gt where application_id=101);
976:

Line 975: WHERE gjh.je_header_id in (select ae_header_id from xla_seq_je_headers_gt where application_id=101);

971: ,xgt.sequence_assign_id
972: FROM xla_seq_je_headers_gt xgt
973: WHERE xgt.application_id = 101
974: AND gjh.je_header_id = xgt.ae_header_id)
975: WHERE gjh.je_header_id in (select ae_header_id from xla_seq_je_headers_gt where application_id=101);
976:
977: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
978: trace
979: (p_msg => '#number of rows inserted:'||to_char(SQL%ROWCOUNT)

Line 991: FROM xla_seq_je_headers_gt xgt

987: ,xah.close_acct_seq_assign_id) =
988: (SELECT xgt.sequence_value
989: ,xgt.sequence_version_id
990: ,xgt.sequence_assign_id
991: FROM xla_seq_je_headers_gt xgt
992: WHERE xgt.application_id = 602
993: AND xah.ae_header_id = xgt.ae_header_id)
994: WHERE xah.ae_header_id in (select ae_header_id from xla_seq_je_headers_gt where application_id=602);
995:

Line 994: WHERE xah.ae_header_id in (select ae_header_id from xla_seq_je_headers_gt where application_id=602);

990: ,xgt.sequence_assign_id
991: FROM xla_seq_je_headers_gt xgt
992: WHERE xgt.application_id = 602
993: AND xah.ae_header_id = xgt.ae_header_id)
994: WHERE xah.ae_header_id in (select ae_header_id from xla_seq_je_headers_gt where application_id=602);
995:
996: /*
997: UPDATE (SELECT xah.close_acct_seq_value
998: ,xah.close_acct_seq_version_id

Line 1004: ,xla_seq_je_headers_gt xgt

1000: ,xgt.sequence_assign_id
1001: ,xgt.sequence_version_id
1002: ,xgt.sequence_value
1003: FROM xla_ae_headers xah
1004: ,xla_seq_je_headers_gt xgt
1005: WHERE xgt.application_id = 602
1006: AND xah.ae_header_id = xgt.ae_header_id)
1007: SET close_acct_seq_value=sequence_value
1008: ,close_acct_seq_version_id = sequence_version_id

Line 1288: -- populate the table XLA_SEQ_JE_HEADERS_GT

1284: END IF;
1285:
1286: IF (l_temp = 1) THEN
1287: IF (p_sort_date = 'GL_DATE') THEN
1288: -- populate the table XLA_SEQ_JE_HEADERS_GT
1289: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1290: (application_id
1291: ,ledger_id
1292: ,ae_header_id

Line 1289: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1285:
1286: IF (l_temp = 1) THEN
1287: IF (p_sort_date = 'GL_DATE') THEN
1288: -- populate the table XLA_SEQ_JE_HEADERS_GT
1289: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1290: (application_id
1291: ,ledger_id
1292: ,ae_header_id
1293: ,je_source_name

Line 1347: -- populate the table XLA_SEQ_JE_HEADERS_GT

1343: ,p_module => l_log_module);
1344: END IF;
1345:
1346: ELSIF (p_sort_date = 'REFERENCE_DATE') THEN
1347: -- populate the table XLA_SEQ_JE_HEADERS_GT
1348: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1349: (application_id
1350: ,ledger_id
1351: ,ae_header_id

Line 1348: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1344: END IF;
1345:
1346: ELSIF (p_sort_date = 'REFERENCE_DATE') THEN
1347: -- populate the table XLA_SEQ_JE_HEADERS_GT
1348: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1349: (application_id
1350: ,ledger_id
1351: ,ae_header_id
1352: ,je_source_name

Line 1407: -- populate the table XLA_SEQ_JE_HEADERS_GT

1403: ,p_level => C_LEVEL_STATEMENT
1404: ,p_module => l_log_module);
1405: END IF;
1406: ELSE
1407: -- populate the table XLA_SEQ_JE_HEADERS_GT
1408: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1409: (application_id
1410: ,ledger_id
1411: ,ae_header_id

Line 1408: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1404: ,p_module => l_log_module);
1405: END IF;
1406: ELSE
1407: -- populate the table XLA_SEQ_JE_HEADERS_GT
1408: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1409: (application_id
1410: ,ledger_id
1411: ,ae_header_id
1412: ,je_source_name

Line 1467: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1463: END IF;
1464:
1465:
1466: IF (p_sort_date = 'GL_DATE') THEN
1467: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1468: (application_id
1469: ,ledger_id
1470: ,ae_header_id
1471: ,je_source_name

Line 1515: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1511: ,p_level => C_LEVEL_STATEMENT
1512: ,p_module => l_log_module);
1513: END IF;
1514: ELSIF (p_sort_date = 'REFERENCE_DATE') THEN
1515: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1516: (application_id
1517: ,ledger_id
1518: ,ae_header_id
1519: ,je_source_name

Line 1563: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1559: ,p_level => C_LEVEL_STATEMENT
1560: ,p_module => l_log_module);
1561: END IF;
1562: ELSE
1563: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1564: (application_id
1565: ,ledger_id
1566: ,ae_header_id
1567: ,je_source_name

Line 1615: -- populate the table XLA_SEQ_JE_HEADERS_GT

1611:
1612: END IF;
1613: ELSE
1614: IF (p_sort_date = 'GL_DATE') THEN
1615: -- populate the table XLA_SEQ_JE_HEADERS_GT
1616: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1617: (application_id
1618: ,ledger_id
1619: ,ae_header_id

Line 1616: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1612: END IF;
1613: ELSE
1614: IF (p_sort_date = 'GL_DATE') THEN
1615: -- populate the table XLA_SEQ_JE_HEADERS_GT
1616: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1617: (application_id
1618: ,ledger_id
1619: ,ae_header_id
1620: ,je_source_name

Line 1660: -- populate the table XLA_SEQ_JE_HEADERS_GT

1656: ,p_module => l_log_module);
1657: END IF;
1658:
1659: ELSIF (p_sort_date = 'REFERENCE_DATE') THEN
1660: -- populate the table XLA_SEQ_JE_HEADERS_GT
1661: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1662: (application_id
1663: ,ledger_id
1664: ,ae_header_id

Line 1661: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1657: END IF;
1658:
1659: ELSIF (p_sort_date = 'REFERENCE_DATE') THEN
1660: -- populate the table XLA_SEQ_JE_HEADERS_GT
1661: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1662: (application_id
1663: ,ledger_id
1664: ,ae_header_id
1665: ,je_source_name

Line 1706: -- populate the table XLA_SEQ_JE_HEADERS_GT

1702: ,p_level => C_LEVEL_STATEMENT
1703: ,p_module => l_log_module);
1704: END IF;
1705: ELSE
1706: -- populate the table XLA_SEQ_JE_HEADERS_GT
1707: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1708: (application_id
1709: ,ledger_id
1710: ,ae_header_id

Line 1707: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1703: ,p_module => l_log_module);
1704: END IF;
1705: ELSE
1706: -- populate the table XLA_SEQ_JE_HEADERS_GT
1707: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1708: (application_id
1709: ,ledger_id
1710: ,ae_header_id
1711: ,je_source_name

Line 1752: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1748: END IF;
1749:
1750:
1751: IF (p_sort_date = 'GL_DATE') THEN
1752: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1753: (application_id
1754: ,ledger_id
1755: ,ae_header_id
1756: ,je_source_name

Line 1787: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1783: ,p_level => C_LEVEL_STATEMENT
1784: ,p_module => l_log_module);
1785: END IF;
1786: ELSIF (p_sort_date = 'REFERENCE_DATE') THEN
1787: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1788: (application_id
1789: ,ledger_id
1790: ,ae_header_id
1791: ,je_source_name

Line 1822: INSERT INTO XLA_SEQ_JE_HEADERS_GT

1818: ,p_level => C_LEVEL_STATEMENT
1819: ,p_module => l_log_module);
1820: END IF;
1821: ELSE
1822: INSERT INTO XLA_SEQ_JE_HEADERS_GT
1823: (application_id
1824: ,ledger_id
1825: ,ae_header_id
1826: ,je_source_name