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_PERIOD_STATUSES

Line 300: FROM gl_period_statuses

296:
297:
298: SELECT min(start_date)
299: INTO l_end_date
300: FROM gl_period_statuses
301: WHERE ledger_id=p_ledger_id
302: AND adjustment_period_flag = 'N'
303: AND CLOSING_STATUS in (C_PERIOD_STATUS_O, C_PERIOD_STATUS_F, C_PERIOD_STATUS_N)
304: AND start_date>p_end_date

Line 311: FROM gl_period_statuses

307: IF (l_end_date is null) THEN
308: -- all the following period is closed or permentantly closed
309: SELECT max(end_date)
310: INTO l_end_date
311: FROM gl_period_statuses
312: WHERE ledger_id=p_ledger_id
313: AND adjustment_period_flag = 'N'
314: AND end_date>=p_end_date
315: AND application_id = 101;

Line 447: l_start_date gl_period_statuses.start_date%TYPE;

443: l_period_name varchar2(100);
444: l_seq_context_value fun_seq_batch.context_value_tbl_type;
445: l_xla_seq_status varchar2(30);
446: l_gl_seq_status varchar2(30);
447: l_start_date gl_period_statuses.start_date%TYPE;
448: l_end_date gl_period_statuses.end_date%TYPE;
449: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;
450: l_xla_seq_context_id NUMBER;
451: l_gl_seq_context_id NUMBER;

Line 448: l_end_date gl_period_statuses.end_date%TYPE;

444: l_seq_context_value fun_seq_batch.context_value_tbl_type;
445: l_xla_seq_status varchar2(30);
446: l_gl_seq_status varchar2(30);
447: l_start_date gl_period_statuses.start_date%TYPE;
448: l_end_date gl_period_statuses.end_date%TYPE;
449: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;
450: l_xla_seq_context_id NUMBER;
451: l_gl_seq_context_id NUMBER;
452: l_sort_date VARCHAR2(30);

Line 449: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;

445: l_xla_seq_status varchar2(30);
446: l_gl_seq_status varchar2(30);
447: l_start_date gl_period_statuses.start_date%TYPE;
448: l_end_date gl_period_statuses.end_date%TYPE;
449: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;
450: l_xla_seq_context_id NUMBER;
451: l_gl_seq_context_id NUMBER;
452: l_sort_date VARCHAR2(30);
453:

Line 461: FROM gl_period_statuses

457:
458: l_temp NUMBER;
459: cursor c_open_previous_normal_period is
460: SELECT 1
461: FROM gl_period_statuses
462: WHERE ledger_id = p_ledger_id
463: AND start_date 464: AND closing_status = C_PERIOD_STATUS_O
465: AND adjustment_period_flag = 'N'

Line 490: FROM GL_PERIOD_STATUSES

486:
487: -- get the start date and end date of the period
488: SELECT trunc(start_date), trunc(end_date), adjustment_period_flag
489: INTO l_start_date, l_end_date, l_adjustment_flag
490: FROM GL_PERIOD_STATUSES
491: WHERE ledger_id = p_ledger_id
492: AND period_name = p_period_name
493: AND application_id = 101;
494:

Line 628: FROM gl_period_statuses

624: -- get the normal entry start date
625: -- reset the sequence number.
626: SELECT trunc(max(start_date))
627: INTO l_start_date
628: FROM gl_period_statuses
629: WHERE ledger_id = p_ledger_id
630: AND start_date <= l_start_date
631: AND adjustment_period_flag = 'N'
632: AND application_id = 101;

Line 749: l_start_date gl_period_statuses.start_date%TYPE;

745: l_period_name varchar2(100);
746: l_seq_context_value fun_seq_batch.context_value_tbl_type;
747: l_xla_seq_status varchar2(30);
748: l_gl_seq_status varchar2(30);
749: l_start_date gl_period_statuses.start_date%TYPE;
750: l_end_date gl_period_statuses.end_date%TYPE;
751: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;
752: l_xla_seq_context_id NUMBER;
753: l_gl_seq_context_id NUMBER;

Line 750: l_end_date gl_period_statuses.end_date%TYPE;

746: l_seq_context_value fun_seq_batch.context_value_tbl_type;
747: l_xla_seq_status varchar2(30);
748: l_gl_seq_status varchar2(30);
749: l_start_date gl_period_statuses.start_date%TYPE;
750: l_end_date gl_period_statuses.end_date%TYPE;
751: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;
752: l_xla_seq_context_id NUMBER;
753: l_gl_seq_context_id NUMBER;
754: l_sort_date VARCHAR2(30);

Line 751: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;

747: l_xla_seq_status varchar2(30);
748: l_gl_seq_status varchar2(30);
749: l_start_date gl_period_statuses.start_date%TYPE;
750: l_end_date gl_period_statuses.end_date%TYPE;
751: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;
752: l_xla_seq_context_id NUMBER;
753: l_gl_seq_context_id NUMBER;
754: l_sort_date VARCHAR2(30);
755: l_temp NUMBER;

Line 760: FROM gl_period_statuses

756: l_request_id NUMBER;
757:
758: cursor c_open_previous_normal_period is
759: SELECT 1
760: FROM gl_period_statuses
761: WHERE ledger_id = p_ledger_id
762: AND start_date 763: AND closing_status = C_PERIOD_STATUS_O
764: AND adjustment_period_flag = 'N'

Line 781: FROM GL_PERIOD_STATUSES

777:
778: -- get the start date and end date of the period
779: SELECT trunc(start_date), trunc(end_date), adjustment_period_flag
780: INTO l_start_date, l_end_date, l_adjustment_flag
781: FROM GL_PERIOD_STATUSES
782: WHERE ledger_id = p_ledger_id
783: AND period_name = p_period_name
784: AND application_id = 101;
785:

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 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 1308: ,gl_period_statuses gps

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
1312: AND gjh.default_effective_date < p_end_date

Line 1366: ,gl_period_statuses gps

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
1370: ,decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) >= p_start_date

Line 1426: ,gl_period_statuses gps

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
1430: AND gjh.posted_date< p_end_date

Line 1635: ,gl_period_statuses gps

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
1639: AND gjh.default_effective_date < p_end_date

Line 1679: ,gl_period_statuses gps

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
1683: ,decode(gps.adjustment_period_flag, 'Y', gjh.posted_date, gjh.default_effective_date)) >= p_start_date

Line 1725: ,gl_period_statuses gps

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
1729: AND gjh.posted_date< p_end_date