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 832: ,p_table_name => 'XLA_AE_HEADERS'

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

Line 984: UPDATE xla_ae_headers xah

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

Line 1003: FROM xla_ae_headers xah

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

Line 1066: FROM xla_ae_headers

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

Line 1088: FROM xla_ae_headers

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

Line 1113: FROM xla_ae_headers

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

Line 1155: UPDATE xla_ae_headers

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

Line 1178: UPDATE xla_ae_headers

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

Line 1207: UPDATE xla_ae_headers

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

Line 1484: FROM xla_ae_headers xah

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

Line 1532: FROM xla_ae_headers xah

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

Line 1581: FROM xla_ae_headers xah

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

Line 1770: FROM xla_ae_headers xah

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

Line 1805: FROM xla_ae_headers xah

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

Line 1840: FROM xla_ae_headers xah

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