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 974: FROM xla_seq_je_headers_gt xgt

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

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

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

Line 993: FROM xla_seq_je_headers_gt xgt

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

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

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

Line 1006: ,xla_seq_je_headers_gt xgt

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

Line 1290: -- populate the table XLA_SEQ_JE_HEADERS_GT

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

Line 1291: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1349: -- populate the table XLA_SEQ_JE_HEADERS_GT

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

Line 1350: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1409: -- populate the table XLA_SEQ_JE_HEADERS_GT

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

Line 1410: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1469: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1517: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1565: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1617: -- populate the table XLA_SEQ_JE_HEADERS_GT

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

Line 1618: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1662: -- populate the table XLA_SEQ_JE_HEADERS_GT

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

Line 1663: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1708: -- populate the table XLA_SEQ_JE_HEADERS_GT

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

Line 1709: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1754: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1789: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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

Line 1824: INSERT INTO XLA_SEQ_JE_HEADERS_GT

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