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.AP_ACCTG_DATA_FIX_PKG dependencies on GL_PERIOD_STATUSES

Line 1110: TYPE period_name_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;

1106: TYPE source_type_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1107: TYPE source_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SOURCE_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1108: TYPE transaction_number_t IS TABLE OF XLA_TRANSACTION_ENTITIES.TRANSACTION_NUMBER%TYPE INDEX BY BINARY_INTEGER;
1109: TYPE security_id_int_1_t IS TABLE OF XLA_TRANSACTION_ENTITIES.SECURITY_ID_INT_1%TYPE INDEX BY BINARY_INTEGER;
1110: TYPE period_name_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
1111: TYPE closing_status_t IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
1112: TYPE ledger_name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
1113:
1114: TYPE period_close_rec_typ IS RECORD

Line 1237: ' gl_period_statuses glps, '||

1233: ' FROM xla_events xe, '||
1234: ' xla_ae_headers xah, '||
1235: l_driver_table||' dr, '||
1236: ' xla_transaction_entities_upg xte, '||
1237: ' gl_period_statuses glps, '||
1238: ' gl_ledgers gl '||
1239: ' WHERE xe.application_id = 200 '||
1240: ' AND xah.application_id =200 '||
1241: ' AND xte.application_id =200 '||

Line 1373: ' gl_period_statuses glps, '||

1369: ' FROM xla_events xe, '||
1370: ' xla_ae_headers xah, '||
1371: l_driver_table||' dr, '||
1372: ' xla_transaction_entities_upg xte, '||
1373: ' gl_period_statuses glps, '||
1374: ' gl_ledgers gl '||
1375: ' WHERE xe.application_id = 200 '||
1376: ' AND xah.application_id =200 '||
1377: ' AND xte.application_id =200 '||

Line 1404: ' FROM gl_period_statuses glpse, '||

1400: IF p_check_sysdate = 'Y' AND p_check_event_date = 'Y' THEN
1401: l_sql_stmt := l_sql_stmt||
1402: ' AND EXISTS '||
1403: ' (SELECT 1 '||
1404: ' FROM gl_period_statuses glpse, '||
1405: ' xla_ae_headers xahe '||
1406: ' WHERE xahe.application_id = 200 '||
1407: ' AND (glpse.application_id = 101 OR '||
1408: ' (glpse.application_id = 200 AND '||

Line 1528: ' gl_period_statuses glps, '||

1524: ' SET (dr.calculated_undo_date, '||
1525: ' dr.calculated_undo_period) = '||
1526: ' (SELECT dr.proposed_undo_date, glps.period_name '||
1527: ' FROM xla_events xe, '||
1528: ' gl_period_statuses glps, '||
1529: ' xla_transaction_entities_upg xte '||
1530: ' WHERE xe.application_id = 200 '||
1531: ' AND glps.application_id = 200 '||
1532: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||

Line 1551: ' FROM gl_period_statuses glps, '||

1547: ' AND dr.process_flag = ''Y'' '||
1548: ' AND dr.calculated_undo_date IS NULL '||
1549: ' AND NOT EXISTS '||
1550: ' (SELECT 1 '||
1551: ' FROM gl_period_statuses glps, '||
1552: ' xla_transaction_entities_upg xte, '||
1553: ' xla_ae_headers xah '||
1554: ' WHERE (glps.application_id = 101 OR '||
1555: ' (glps.application_id = 200 AND '||

Line 1582: ' gl_period_statuses glps, '||

1578: ' SET (dr.calculated_undo_date, '||
1579: ' dr.calculated_undo_period) = '||
1580: ' (SELECT xe.event_date, glps.period_name '||
1581: ' FROM xla_events xe, '||
1582: ' gl_period_statuses glps, '||
1583: ' xla_transaction_entities_upg xte '||
1584: ' WHERE xe.application_id = 200 '||
1585: ' AND glps.application_id = 200 '||
1586: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||

Line 1605: ' FROM gl_period_statuses glps, '||

1601: ' AND dr.process_flag = ''Y'' '||
1602: ' AND dr.calculated_undo_date IS NULL '||
1603: ' AND NOT EXISTS '||
1604: ' (SELECT 1 '||
1605: ' FROM gl_period_statuses glps, '||
1606: ' xla_transaction_entities_upg xte, '||
1607: ' xla_ae_headers xah '||
1608: ' WHERE (glps.application_id = 101 OR '||
1609: ' (glps.application_id = 200 AND '||

Line 1634: ' gl_period_statuses glps, '||

1630: ' SET (dr.calculated_undo_date, '||
1631: ' dr.calculated_undo_period) = '||
1632: ' (SELECT trunc(sysdate), glps.period_name '||
1633: ' FROM xla_events xe, '||
1634: ' gl_period_statuses glps, '||
1635: ' xla_transaction_entities_upg xte '||
1636: ' WHERE xe.application_id = 200 '||
1637: ' AND glps.application_id = 200 '||
1638: ' AND nvl(glps.adjustment_period_flag, ''N'') = ''N'' '||

Line 1657: ' FROM gl_period_statuses glps, '||

1653: ' AND dr.process_flag = ''Y'' '||
1654: ' AND dr.calculated_undo_date IS NULL '||
1655: ' AND NOT EXISTS '||
1656: ' (SELECT 1 '||
1657: ' FROM gl_period_statuses glps, '||
1658: ' xla_transaction_entities_upg xte, '||
1659: ' xla_ae_headers xah '||
1660: ' WHERE (glps.application_id = 101 OR '||
1661: ' (glps.application_id = 200 AND '||

Line 1998: FROM gl_Period_Statuses gps,

1994:
1995: CURSOR Check_period_Status(p_Date DATE,
1996: p_org_id NUMBER) IS
1997: SELECT DISTINCT gps.Period_Name
1998: FROM gl_Period_Statuses gps,
1999: ap_System_Parameters_All Asp
2000: WHERE gps.Application_Id = 200
2001: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2002: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 2009: FROM gl_Period_Statuses gps,

2005: AND Nvl(Asp.Org_Id,- 99) = Nvl(p_org_id,- 99)
2006: AND gps.closing_Status in ('O', 'F')
2007: INTERSECT
2008: SELECT DISTINCT gps.Period_Name
2009: FROM gl_Period_Statuses gps,
2010: ap_System_Parameters_All Asp
2011: WHERE gps.Application_Id = 101
2012: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2013: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 2030: FROM gl_Period_Statuses gps,

2026: CURSOR Check_Open_Period(p_org_id NUMBER) IS
2027: SELECT Period_Name, End_Date
2028: FROM (
2029: SELECT DISTINCT gps.Period_Name, trunc(gps.End_Date) End_date
2030: FROM gl_Period_Statuses gps,
2031: ap_System_Parameters_All Asp
2032: WHERE gps.Application_Id = 200
2033: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2034: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 2039: FROM gl_Period_Statuses gps,

2035: AND Nvl(Asp.Org_Id,- 99) = Nvl(p_org_id,- 99)
2036: AND gps.closing_Status in ('O', 'F')
2037: INTERSECT
2038: SELECT DISTINCT gps.Period_Name, trunc(gps.End_Date) End_date
2039: FROM gl_Period_Statuses gps,
2040: ap_System_Parameters_All Asp
2041: WHERE gps.Application_Id = 101
2042: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
2043: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 2052: FROM gl_Period_Statuses gps,

2048: WHERE rownum < 2;
2049:
2050: CURSOR Check_Entered_Gl_date(p_org_id NUMBER) IS
2051: SELECT DISTINCT gps.Period_Name
2052: FROM gl_Period_Statuses gps,
2053: ap_System_Parameters_All Asp
2054: WHERE gps.Application_Id = 200
2055: AND p_Gl_Date between trunc(gps.start_date) and trunc(gps.end_date)
2056: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id

Line 2062: FROM gl_Period_Statuses gps,

2058: AND Nvl(Asp.Org_Id,- 99) = Nvl(p_org_id,- 99)
2059: AND gps.closing_Status in ('O', 'F')
2060: INTERSECT
2061: SELECT DISTINCT gps.Period_Name
2062: FROM gl_Period_Statuses gps,
2063: ap_System_Parameters_All Asp
2064: WHERE gps.Application_Id = 101
2065: AND p_Gl_Date between trunc(gps.start_date) and trunc(gps.end_date)
2066: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id

Line 2641: TYPE calc_undo_period_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;

2637: TYPE accounted_cr_t IS TABLE OF XLA_AE_LINES.ACCOUNTED_CR%TYPE INDEX BY BINARY_INTEGER;
2638: TYPE description_t IS TABLE OF XLA_AE_LINES.DESCRIPTION%TYPE INDEX BY BINARY_INTEGER;
2639: TYPE name_t IS TABLE OF GL_LEDGERS.NAME%TYPE INDEX BY BINARY_INTEGER;
2640: TYPE calc_undo_date_t IS TABLE OF XLA_EVENTS.EVENT_DATE%TYPE INDEX BY BINARY_INTEGER;
2641: TYPE calc_undo_period_t IS TABLE OF GL_PERIOD_STATUSES.PERIOD_NAME%TYPE INDEX BY BINARY_INTEGER;
2642: TYPE error_reason_t IS TABLE OF VARCHAR2(1000) INDEX BY BINARY_INTEGER;
2643: TYPE budgetary_control_flag_t IS TABLE OF XLA_EVENTS.budgetary_control_flag%TYPE INDEX BY BINARY_INTEGER; /*Bug 10072990*/
2644:
2645: TYPE undo_rec_typ IS RECORD

Line 4130: FROM gl_period_statuses GLPS,

4126: l_period_name Varchar2(15) Default Null;
4127: Begin
4128: SELECT period_name
4129: Into l_period_name
4130: FROM gl_period_statuses GLPS,
4131: ap_system_parameters_all SP
4132: WHERE application_id = 200
4133: AND sp.org_id = P_Org_Id
4134: AND GLPS.set_of_books_id = SP.set_of_books_id

Line 4156: FROM gl_Period_Statuses gps,

4152: SELECT Start_Date
4153: Into l_start_date
4154: FROM (
4155: SELECT DISTINCT gps.Period_Name, trunc(gps.Start_Date) Start_date
4156: FROM gl_Period_Statuses gps,
4157: ap_System_Parameters_All Asp
4158: WHERE gps.Application_Id = 200
4159: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
4160: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 4165: FROM gl_Period_Statuses gps,

4161: AND Nvl(Asp.Org_Id,- 99) = Nvl(p_org_id,- 99)
4162: AND gps.closing_Status in ('O', 'F')
4163: INTERSECT
4164: SELECT DISTINCT gps.Period_Name, trunc(gps.start_Date) start_date
4165: FROM gl_Period_Statuses gps,
4166: ap_System_Parameters_All Asp
4167: WHERE gps.Application_Id = 101
4168: AND gps.Set_Of_Books_Id = Asp.Set_Of_Books_Id
4169: AND Nvl(gps.Adjustment_Period_Flag,'N') = 'N'

Line 5441: FROM gl_period_statuses gps

5437:
5438: CURSOR check_period_status( p_date DATE, p_org_id NUMBER )
5439: IS
5440: SELECT DISTINCT gps.period_name
5441: FROM gl_period_statuses gps
5442: , ap_system_parameters_all asp
5443: WHERE gps.application_id = 200
5444: AND gps.set_of_books_id = asp.set_of_books_id
5445: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'

Line 5451: FROM gl_period_statuses gps

5447: AND NVL( asp.org_id, - 99 ) = NVL( p_org_id, - 99 )
5448: AND gps.closing_status IN( 'O', 'F' )
5449: INTERSECT
5450: SELECT DISTINCT gps.period_name
5451: FROM gl_period_statuses gps
5452: , ap_system_parameters_all asp
5453: WHERE gps.application_id = 101
5454: AND gps.set_of_books_id = asp.set_of_books_id
5455: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'

Line 5467: FROM gl_period_statuses gps

5463: , end_date
5464: FROM
5465: ( SELECT DISTINCT gps.period_name
5466: , TRUNC( gps.end_date ) end_date
5467: FROM gl_period_statuses gps
5468: , ap_system_parameters_all asp
5469: WHERE gps.application_id = 200
5470: AND gps.set_of_books_id = asp.set_of_books_id
5471: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'

Line 5477: FROM gl_period_statuses gps

5473: AND gps.closing_status IN( 'O', 'F' )
5474: INTERSECT
5475: SELECT DISTINCT gps.period_name
5476: , TRUNC( gps.end_date ) end_date
5477: FROM gl_period_statuses gps
5478: , ap_system_parameters_all asp
5479: WHERE gps.application_id = 101
5480: AND gps.set_of_books_id = asp.set_of_books_id
5481: AND NVL( gps.adjustment_period_flag, 'N' ) = 'N'

Line 5492: FROM gl_period_statuses gps

5488:
5489: CURSOR check_entered_gl_date( p_org_id NUMBER )
5490: IS
5491: SELECT DISTINCT gps.period_name
5492: FROM gl_period_statuses gps
5493: , ap_system_parameters_all asp
5494: WHERE gps.application_id = 200
5495: AND p_gl_date BETWEEN TRUNC( gps.start_date ) AND TRUNC( gps.end_date )
5496: AND gps.set_of_books_id = asp.set_of_books_id

Line 5502: FROM gl_period_statuses gps

5498: AND NVL( asp.org_id, - 99 ) = NVL( p_org_id, - 99 )
5499: AND gps.closing_status IN( 'O', 'F' )
5500: INTERSECT
5501: SELECT DISTINCT gps.period_name
5502: FROM gl_period_statuses gps
5503: , ap_system_parameters_all asp
5504: WHERE gps.application_id = 101
5505: AND p_gl_date BETWEEN TRUNC( gps.start_date ) AND TRUNC( gps.end_date )
5506: AND gps.set_of_books_id = asp.set_of_books_id