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.OKL_REVERSAL_PVT dependencies on GL_PERIOD_STATUSES_V

Line 110: l_closing_status GL_PERIOD_STATUSES_V.closing_status%TYPE;

106:
107: l_set_of_books_id NUMBER;
108: l_org_id NUMBER;
109: l_period_name GL_PERIODS_V.period_name%TYPE;
110: l_closing_status GL_PERIOD_STATUSES_V.closing_status%TYPE;
111:
112: l_new_description OKL_AE_HEADERS.DESCRIPTION%TYPE;
113:
114: l_dist_tbl_in OKL_TRNS_ACC_DSTRS_PUB.tabv_tbl_type;

Line 134: l_period_status GL_PERIOD_STATUSES_V.CLOSING_STATUS%TYPE;

130: l_string VARCHAR2(500);
131: l_event_number NUMBER := 0;
132: l_start_date DATE;
133: l_end_date DATE;
134: l_period_status GL_PERIOD_STATUSES_V.CLOSING_STATUS%TYPE;
135:
136:
137:
138: CURSOR prdst_csr(v_period_name VARCHAR2) IS

Line 140: FROM GL_PERIOD_STATUSES_V prdst

136:
137:
138: CURSOR prdst_csr(v_period_name VARCHAR2) IS
139: SELECT prdst.closing_status
140: FROM GL_PERIOD_STATUSES_V prdst
141: WHERE prdst.ledger_id = OKL_ACCOUNTING_UTIL.get_set_of_books_id
142: AND prdst.period_name = v_period_name
143: AND prdst.APPLICATION_ID = l_application_id;
144: