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 GL_JE_HEADERS

Line 340: FROM gl_je_headers gjh

336: ,p_end_date IN DATE
337: ,p_sort_date IN VARCHAR2 ) return boolean is
338: cursor c_gl_date is
339: SELECT 1
340: FROM gl_je_headers gjh
341: , xla_subledgers xs
342: WHERE gjh.ledger_id = p_ledger_id
343: AND gjh.period_name = p_period_name
344: AND gjh.status = 'P'

Line 352: FROM gl_je_headers gjh

348: AND gjh.default_effective_date< p_end_date;
349:
350: cursor c_ref_date is
351: SELECT 1
352: FROM gl_je_headers gjh
353: , xla_subledgers xs
354: WHERE ledger_id = p_ledger_id
355: AND period_name = p_period_name
356: AND gjh.status = 'P'

Line 364: FROM gl_je_headers gjh

360: AND nvl(gjh.reference_date, gjh.posted_date) < p_end_date;
361:
362: cursor c_comp_date is
363: SELECT 1
364: FROM gl_je_headers gjh
365: , xla_subledgers xs
366: WHERE ledger_id = p_ledger_id
367: AND period_name = p_period_name
368: AND gjh.status = 'P'

Line 543: ,p_table_name => 'GL_JE_HEADERS'

539: ,x_seq_context_id => l_xla_seq_context_id);
540:
541: -- for gl
542: fun_seq_batch.Batch_init(p_application_id => 101
543: ,p_table_name => 'GL_JE_HEADERS'
544: ,p_event_code => 'PERIOD_CLOSE'
545: ,p_context_type => 'LEDGER_AND_CURRENCY'
546: ,p_context_value_tbl =>l_seq_context_value
547: ,p_request_id => l_request_id

Line 842: ,p_table_name => 'GL_JE_HEADERS'

838: ,x_seq_context_id => l_xla_seq_context_id);
839:
840: -- for gl
841: fun_seq_batch.Batch_init(p_application_id => 101
842: ,p_table_name => 'GL_JE_HEADERS'
843: ,p_event_code => 'PERIOD_CLOSE'
844: ,p_context_type => 'LEDGER_AND_CURRENCY'
845: ,p_context_value_tbl =>l_seq_context_value
846: ,p_request_id => l_request_id

Line 965: UPDATE gl_je_headers gjh

961: ,p_level => C_LEVEL_PROCEDURE
962: ,p_module => l_log_module);
963: END IF;
964:
965: UPDATE gl_je_headers gjh
966: SET (gjh.close_acct_seq_value
967: ,gjh.close_acct_seq_version_id
968: ,gjh.close_acct_seq_assign_id) =
969: (select xgt.sequence_value

Line 1075: FROM gl_je_headers

1071: AND gl_transfer_status_code = 'Y'
1072: AND accounting_entry_status_code = 'F'
1073: UNION
1074: SELECT close_acct_seq_value, close_acct_seq_version_id
1075: FROM gl_je_headers
1076: WHERE ledger_id=p_ledger_id
1077: AND default_effective_date >= p_start_date
1078: AND default_effective_date < p_end_date
1079: AND status = 'P'

Line 1097: FROM gl_je_headers gjh, gl_period_statuses gps

1093: AND gl_transfer_status_code = 'Y'
1094: AND accounting_entry_status_code = 'F'
1095: UNION
1096: SELECT close_acct_seq_value, close_acct_seq_version_id
1097: FROM gl_je_headers gjh, gl_period_statuses gps
1098: WHERE gjh.ledger_id=p_ledger_id
1099: AND nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) >= p_start_date
1100: AND nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) < p_end_date
1101: AND gjh.status = 'P'

Line 1122: FROM gl_je_headers

1118: AND gl_transfer_status_code = 'Y'
1119: AND accounting_entry_status_code = 'F'
1120: UNION
1121: SELECT close_acct_seq_value, close_acct_seq_version_id
1122: FROM gl_je_headers
1123: WHERE ledger_id=p_ledger_id
1124: AND posted_date >= p_start_date
1125: AND posted_date < p_end_date
1126: AND status = 'P'

Line 1166: UPDATE gl_je_headers

1162: AND close_acct_seq_version_id is not null
1163: AND gl_transfer_status_code = 'Y'
1164: AND accounting_entry_status_code = 'F';
1165:
1166: UPDATE gl_je_headers
1167: SET close_acct_seq_value = null
1168: ,close_acct_seq_version_id = null
1169: ,close_acct_seq_assign_id = null
1170: WHERE ledger_id=p_ledger_id

Line 1189: UPDATE gl_je_headers

1185: AND close_acct_seq_version_id is not null
1186: AND gl_transfer_status_code = 'Y'
1187: AND accounting_entry_status_code = 'F';
1188:
1189: UPDATE gl_je_headers
1190: SET close_acct_seq_value = null
1191: ,close_acct_seq_version_id = null
1192: ,close_acct_seq_assign_id = null
1193: WHERE je_header_id in

Line 1196: FROM gl_je_headers gjh, gl_period_statuses gps

1192: ,close_acct_seq_assign_id = null
1193: WHERE je_header_id in
1194: (
1195: SELECT gjh.je_header_id
1196: FROM gl_je_headers gjh, gl_period_statuses gps
1197: WHERE gjh.ledger_id=p_ledger_id
1198: AND nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) >= p_start_date
1199: AND nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) < p_end_date
1200: AND gjh.status = 'P'

Line 1218: UPDATE gl_je_headers

1214: AND close_acct_seq_version_id is not null
1215: AND gl_transfer_status_code = 'Y'
1216: AND accounting_entry_status_code = 'F';
1217:
1218: UPDATE gl_je_headers
1219: SET close_acct_seq_value = null
1220: ,close_acct_seq_version_id = null
1221: ,close_acct_seq_assign_id = null
1222: WHERE ledger_id=p_ledger_id

Line 1307: FROM gl_je_headers gjh

1303: ,gjh.default_effective_date
1304: ,nvl(gjh.reference_date,
1305: decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1306: ,gjh.posted_date
1307: FROM gl_je_headers gjh
1308: ,gl_period_statuses gps
1309: ,xla_subledgers xs
1310: WHERE gjh.ledger_id = p_ledger_id
1311: AND gjh.default_effective_date >= p_start_date

Line 1365: FROM gl_je_headers gjh

1361: ,gjh.je_category
1362: ,gjh.default_effective_date
1363: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1364: ,gjh.posted_date
1365: FROM gl_je_headers gjh
1366: ,gl_period_statuses gps
1367: ,xla_subledgers xs
1368: WHERE gjh.ledger_id = p_ledger_id
1369: AND nvl(gjh.reference_date

Line 1425: FROM gl_je_headers gjh

1421: ,gjh.je_category
1422: ,gjh.default_effective_date
1423: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1424: ,gjh.posted_date
1425: FROM gl_je_headers gjh
1426: ,gl_period_statuses gps
1427: ,xla_subledgers xs
1428: WHERE gjh.ledger_id = p_ledger_id
1429: AND gjh.posted_date>= p_start_date

Line 1634: FROM gl_je_headers gjh

1630: ,gjh.default_effective_date
1631: ,nvl(gjh.reference_date,
1632: decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1633: ,gjh.posted_date
1634: FROM gl_je_headers gjh
1635: ,gl_period_statuses gps
1636: ,xla_subledgers xs
1637: WHERE gjh.ledger_id = p_ledger_id
1638: AND gjh.default_effective_date >= p_start_date

Line 1678: FROM gl_je_headers gjh

1674: ,gjh.je_category
1675: ,gjh.default_effective_date
1676: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1677: ,gjh.posted_date
1678: FROM gl_je_headers gjh
1679: ,gl_period_statuses gps
1680: ,xla_subledgers xs
1681: WHERE gjh.ledger_id = p_ledger_id
1682: AND nvl(gjh.reference_date

Line 1724: FROM gl_je_headers gjh

1720: ,gjh.je_category
1721: ,gjh.default_effective_date
1722: ,nvl(gjh.reference_date, decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date))
1723: ,gjh.posted_date
1724: FROM gl_je_headers gjh
1725: ,gl_period_statuses gps
1726: ,xla_subledgers xs
1727: WHERE gjh.ledger_id = p_ledger_id
1728: AND gjh.posted_date>= p_start_date