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_AE_HEADERS

Line 533: ,p_table_name => 'XLA_AE_HEADERS'

529: -- call fun_seq_batch.batch_init
530: -- for xla first
531: l_seq_context_value(1) := p_ledger_id;
532: fun_seq_batch.Batch_init(p_application_id => 602
533: ,p_table_name => 'XLA_AE_HEADERS'
534: ,p_event_code => 'PERIOD_CLOSE'
535: ,p_context_type => 'LEDGER_AND_CURRENCY'
536: ,p_context_value_tbl =>l_seq_context_value
537: ,p_request_id => l_request_id

Line 834: ,p_table_name => 'XLA_AE_HEADERS'

830: -- call fun_seq_batch.batch_init
831: -- for xla first
832: l_seq_context_value(1) := p_ledger_id;
833: fun_seq_batch.Batch_init(p_application_id => 602
834: ,p_table_name => 'XLA_AE_HEADERS'
835: ,p_event_code => 'PERIOD_CLOSE'
836: ,p_context_type => 'LEDGER_AND_CURRENCY'
837: ,p_context_value_tbl =>l_seq_context_value
838: ,p_request_id => l_request_id

Line 986: UPDATE xla_ae_headers xah

982: ,p_level => C_LEVEL_STATEMENT
983: ,p_module => l_log_module);
984: END IF;
985:
986: UPDATE xla_ae_headers xah
987: SET (xah.close_acct_seq_value
988: ,xah.close_acct_seq_version_id
989: ,xah.close_acct_seq_assign_id) =
990: (SELECT xgt.sequence_value

Line 1005: FROM xla_ae_headers xah

1001: ,xah.close_acct_seq_assign_id
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

Line 1068: FROM xla_ae_headers

1064: OPEN c_reset_cursor FOR
1065: SELECT min(close_acct_seq_value), close_acct_seq_version_id
1066: FROM (
1067: SELECT close_acct_seq_value, close_acct_seq_version_id
1068: FROM xla_ae_headers
1069: WHERE ledger_id=p_ledger_id
1070: AND accounting_date >= p_start_date
1071: AND accounting_date < p_end_date
1072: AND close_acct_seq_version_id is not null

Line 1090: FROM xla_ae_headers

1086: OPEN c_reset_cursor FOR
1087: SELECT min(close_acct_seq_value), close_acct_seq_version_id
1088: FROM (
1089: SELECT close_acct_seq_value, close_acct_seq_version_id
1090: FROM xla_ae_headers
1091: WHERE ledger_id=p_ledger_id
1092: AND nvl(reference_date, accounting_date) >= p_start_date
1093: AND nvl(reference_date, accounting_date) < p_end_date
1094: AND close_acct_seq_version_id is not null

Line 1115: FROM xla_ae_headers

1111: OPEN c_reset_cursor FOR
1112: SELECT min(close_acct_seq_value), close_acct_seq_version_id
1113: FROM (
1114: SELECT close_acct_seq_value, close_acct_seq_version_id
1115: FROM xla_ae_headers
1116: WHERE ledger_id=p_ledger_id
1117: AND nvl(completed_date,accounting_date)>= p_start_date
1118: AND nvl(completed_date,accounting_date) < p_end_date
1119: AND close_acct_seq_version_id is not null

Line 1157: UPDATE xla_ae_headers

1153: END LOOP;
1154: CLOSE c_reset_cursor;
1155:
1156: IF(p_sort_date = 'GL_DATE') THEN
1157: UPDATE xla_ae_headers
1158: SET close_acct_seq_value = null
1159: ,close_acct_seq_version_id = null
1160: ,close_acct_seq_assign_id = null
1161: WHERE ledger_id=p_ledger_id

Line 1180: UPDATE xla_ae_headers

1176: AND close_acct_seq_version_id is not null;
1177:
1178: ELSIF (p_sort_date = 'REFERENCE_DATE') THEN
1179:
1180: UPDATE xla_ae_headers
1181: SET close_acct_seq_value = null
1182: ,close_acct_seq_version_id = null
1183: ,close_acct_seq_assign_id = null
1184: WHERE ledger_id=p_ledger_id

Line 1209: UPDATE xla_ae_headers

1205: AND gps.ledger_id=p_ledger_id
1206: AND gps.period_name = gjh.period_name
1207: );
1208: ELSE
1209: UPDATE xla_ae_headers
1210: SET close_acct_seq_value = null
1211: ,close_acct_seq_version_id = null
1212: ,close_acct_seq_assign_id = null
1213: WHERE ledger_id=p_ledger_id

Line 1486: FROM xla_ae_headers xah

1482: ,xah.je_category_name
1483: ,xah.accounting_date
1484: ,nvl(xah.reference_date, xah.accounting_date)
1485: ,nvl(xah.completed_date, xah.accounting_date)
1486: FROM xla_ae_headers xah
1487: ,xla_subledgers xs
1488: WHERE xah.ledger_id = p_ledger_id
1489: AND xah.accounting_date >= p_start_date
1490: AND xah.accounting_date < p_end_date

Line 1534: FROM xla_ae_headers xah

1530: ,xah.je_category_name
1531: ,xah.accounting_date
1532: ,nvl(xah.reference_date, xah.accounting_date)
1533: ,nvl(xah.completed_date, xah.accounting_date)
1534: FROM xla_ae_headers xah
1535: ,xla_subledgers xs
1536: WHERE xah.ledger_id = p_ledger_id
1537: AND nvl(xah.reference_date, xah.accounting_date) >= p_start_date
1538: AND nvl(xah.reference_date, xah.accounting_date) < p_end_date

Line 1583: FROM xla_ae_headers xah

1579: ,xah.accounting_date
1580: ,nvl(xah.reference_date, xah.accounting_date)
1581: ,nvl(xah.completed_date, xah.accounting_date)
1582:
1583: FROM xla_ae_headers xah
1584: ,xla_subledgers xs
1585: WHERE xah.ledger_id = p_ledger_id
1586: AND nvl(xah.completed_date, xah.accounting_date) >= p_start_date
1587: AND nvl(xah.completed_date, xah.accounting_date) < p_end_date

Line 1772: FROM xla_ae_headers xah

1768: ,xah.accounting_date
1769: ,nvl(xah.reference_date, xah.accounting_date)
1770: ,nvl(xah.completed_date, xah.accounting_date)
1771:
1772: FROM xla_ae_headers xah
1773: ,xla_subledgers xs
1774: WHERE xah.ledger_id = p_ledger_id
1775: AND xah.accounting_date >= p_start_date
1776: AND xah.accounting_date < p_end_date

Line 1807: FROM xla_ae_headers xah

1803: ,xah.accounting_date
1804: ,nvl(xah.reference_date, xah.accounting_date)
1805: ,nvl(xah.completed_date, xah.accounting_date)
1806:
1807: FROM xla_ae_headers xah
1808: ,xla_subledgers xs
1809: WHERE xah.ledger_id = p_ledger_id
1810: AND nvl(xah.reference_date, xah.accounting_date) >= p_start_date
1811: AND nvl(xah.reference_date, xah.accounting_date) < p_end_date

Line 1842: FROM xla_ae_headers xah

1838: ,xah.accounting_date
1839: ,nvl(xah.reference_date, xah.accounting_date)
1840: ,nvl(xah.completed_date, xah.accounting_date)
1841:
1842: FROM xla_ae_headers xah
1843: ,xla_subledgers xs
1844: WHERE xah.ledger_id = p_ledger_id
1845: AND nvl(xah.completed_date, xah.accounting_date)>= p_start_date
1846: AND nvl(xah.completed_date, xah.accounting_date) < p_end_date