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 844: ,p_table_name => 'GL_JE_HEADERS'

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

Line 967: UPDATE gl_je_headers gjh

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

Line 1077: FROM gl_je_headers

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

Line 1099: FROM gl_je_headers gjh, gl_period_statuses gps

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

Line 1124: FROM gl_je_headers

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

Line 1168: UPDATE gl_je_headers

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

Line 1191: UPDATE gl_je_headers

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

Line 1198: FROM gl_je_headers gjh, gl_period_statuses gps

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

Line 1220: UPDATE gl_je_headers

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

Line 1309: FROM gl_je_headers gjh

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

Line 1367: FROM gl_je_headers gjh

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

Line 1427: FROM gl_je_headers gjh

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

Line 1636: FROM gl_je_headers gjh

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

Line 1680: FROM gl_je_headers gjh

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

Line 1726: FROM gl_je_headers gjh

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