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 630: FROM gl_period_statuses

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

Line 751: l_start_date gl_period_statuses.start_date%TYPE;

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

Line 752: l_end_date gl_period_statuses.end_date%TYPE;

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

Line 753: l_adjustment_flag gl_period_statuses.adjustment_period_flag%TYPE;

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

Line 762: FROM gl_period_statuses

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

Line 783: FROM GL_PERIOD_STATUSES

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

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

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

Line 1368: ,gl_period_statuses gps

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

Line 1428: ,gl_period_statuses gps

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

Line 1637: ,gl_period_statuses gps

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

Line 1681: ,gl_period_statuses gps

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

Line 1727: ,gl_period_statuses gps

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