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.GL_CI_REMOTE_INVOKE_PKG dependencies on GL_LEDGERS

Line 199: l_ledger_name GL_LEDGERS.NAME%TYPE;

195: function Get_Ledger_Name(
196: ledger_id IN number
197: ) return varchar2
198: IS
199: l_ledger_name GL_LEDGERS.NAME%TYPE;
200: v_SQL1 varchar2(500);
201: begin
202: v_SQL1 := 'select name from gl_ledgers' ||
203: ' WHERE ledger_id = :l_id';

Line 202: v_SQL1 := 'select name from gl_ledgers' ||

198: IS
199: l_ledger_name GL_LEDGERS.NAME%TYPE;
200: v_SQL1 varchar2(500);
201: begin
202: v_SQL1 := 'select name from gl_ledgers' ||
203: ' WHERE ledger_id = :l_id';
204: EXECUTE IMMEDIATE v_SQL1 INTO l_ledger_name USING ledger_id;
205: return l_ledger_name;
206: end Get_Ledger_Name;

Line 215: l_suspense_flag GL_LEDGERS.SUSPENSE_ALLOWED_FLAG%TYPE;

211: function Get_Suspense_Flag(
212: ledger_id IN number
213: ) return varchar2
214: IS
215: l_suspense_flag GL_LEDGERS.SUSPENSE_ALLOWED_FLAG%TYPE;
216: v_SQL1 varchar2(500);
217: begin
218: v_SQL1 := 'select suspense_allowed_flag from gl_ledgers' ||
219: ' WHERE ledger_id = :l_id';

Line 218: v_SQL1 := 'select suspense_allowed_flag from gl_ledgers' ||

214: IS
215: l_suspense_flag GL_LEDGERS.SUSPENSE_ALLOWED_FLAG%TYPE;
216: v_SQL1 varchar2(500);
217: begin
218: v_SQL1 := 'select suspense_allowed_flag from gl_ledgers' ||
219: ' WHERE ledger_id = :l_id';
220: EXECUTE IMMEDIATE v_SQL1 INTO l_suspense_flag USING ledger_id;
221: return l_suspense_flag;
222: end Get_Suspense_Flag;

Line 230: l_balance_flag GL_LEDGERS.ENABLE_AVERAGE_BALANCES_FLAG%TYPE;

226: function Get_Daily_Balance_Flag(
227: ledger_id IN number
228: ) return varchar2
229: IS
230: l_balance_flag GL_LEDGERS.ENABLE_AVERAGE_BALANCES_FLAG%TYPE;
231: v_SQL1 varchar2(500);
232: begin
233: v_SQL1 := 'select enable_average_balances_flag from gl_ledgers' ||
234: ' where ledger_id = :ledger_id';

Line 233: v_SQL1 := 'select enable_average_balances_flag from gl_ledgers' ||

229: IS
230: l_balance_flag GL_LEDGERS.ENABLE_AVERAGE_BALANCES_FLAG%TYPE;
231: v_SQL1 varchar2(500);
232: begin
233: v_SQL1 := 'select enable_average_balances_flag from gl_ledgers' ||
234: ' where ledger_id = :ledger_id';
235: EXECUTE IMMEDIATE v_SQL1 INTO l_balance_flag USING ledger_id;
236: return l_balance_flag;
237: end Get_Daily_Balance_Flag;

Line 246: l_cons_ledger_flag GL_LEDGERS.CONSOLIDATION_LEDGER_FLAG%TYPE;

242: function Get_Cons_ledger_Flag(
243: ledger_id IN number
244: ) return varchar2
245: IS
246: l_cons_ledger_flag GL_LEDGERS.CONSOLIDATION_LEDGER_FLAG%TYPE;
247: v_SQL1 varchar2(500);
248: begin
249: v_SQL1 := 'select consolidation_ledger_flag from gl_ledgers' ||
250: ' where ledger_id = :ledger_id';

Line 249: v_SQL1 := 'select consolidation_ledger_flag from gl_ledgers' ||

245: IS
246: l_cons_ledger_flag GL_LEDGERS.CONSOLIDATION_LEDGER_FLAG%TYPE;
247: v_SQL1 varchar2(500);
248: begin
249: v_SQL1 := 'select consolidation_ledger_flag from gl_ledgers' ||
250: ' where ledger_id = :ledger_id';
251: EXECUTE IMMEDIATE v_SQL1 INTO l_cons_ledger_flag USING ledger_id;
252: return l_cons_ledger_flag;
253: end Get_Cons_ledger_Flag;

Line 261: l_currency_code GL_LEDGERS.CURRENCY_CODE%TYPE;

257: function Get_Currency_Code(
258: ledger_id IN number
259: ) return varchar2
260: IS
261: l_currency_code GL_LEDGERS.CURRENCY_CODE%TYPE;
262: v_SQL1 varchar2(500);
263: begin
264: v_SQL1 := 'SELECT CURRENCY_CODE FROM gl_ledgers' ||
265: ' WHERE ledger_id = :ledger_id';

Line 264: v_SQL1 := 'SELECT CURRENCY_CODE FROM gl_ledgers' ||

260: IS
261: l_currency_code GL_LEDGERS.CURRENCY_CODE%TYPE;
262: v_SQL1 varchar2(500);
263: begin
264: v_SQL1 := 'SELECT CURRENCY_CODE FROM gl_ledgers' ||
265: ' WHERE ledger_id = :ledger_id';
266: EXECUTE IMMEDIATE v_SQL1 INTO l_currency_code USING ledger_id;
267: return l_currency_code;
268: end Get_Currency_Code;

Line 276: l_coa_id GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;

272: function Get_COA_Id(
273: ledger_id IN number
274: ) return number
275: IS
276: l_coa_id GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;
277: v_SQL1 varchar2(500);
278: begin
279: v_SQL1 := 'select chart_of_accounts_id from gl_ledgers' ||
280: ' where ledger_id = :ledger_id';

Line 279: v_SQL1 := 'select chart_of_accounts_id from gl_ledgers' ||

275: IS
276: l_coa_id GL_LEDGERS.CHART_OF_ACCOUNTS_ID%TYPE;
277: v_SQL1 varchar2(500);
278: begin
279: v_SQL1 := 'select chart_of_accounts_id from gl_ledgers' ||
280: ' where ledger_id = :ledger_id';
281: EXECUTE IMMEDIATE v_SQL1 INTO l_coa_id USING ledger_id;
282: return l_coa_id;
283: end Get_COA_Id;

Line 296: v_SQL1 := 'select count(*) from gl_periods p, gl_ledgers l ' ||

292: IS
293: l_count number;
294: v_SQL1 varchar2(1000);
295: begin
296: v_SQL1 := 'select count(*) from gl_periods p, gl_ledgers l ' ||
297: 'where p.period_set_name = l.period_set_name ' ||
298: 'and p.period_type = l.accounted_period_type ' ||
299: 'and l.ledger_id = :s ' ||
300: 'and p.period_name = :pd';

Line 321: 'gl_periods p, gl_ledgers l ' ||

317:
318: BEGIN
319: v_PDSQL := 'select p.start_date, p.end_date, p.quarter_start_date, ' ||
320: 'p.year_start_date from ' ||
321: 'gl_periods p, gl_ledgers l ' ||
322: 'where p.period_set_name = l.period_set_name ' ||
323: 'and p.period_type = l.accounted_period_type ' ||
324: 'and l.ledger_id = :s ' ||
325: 'and p.period_name = :pd';

Line 822: from gl_ledgers

818: FROM sys.dual;
819:
820: cursor ledger is
821: select chart_of_accounts_id
822: from gl_ledgers
823: where ledger_id = ledger_id;
824:
825: value_return boolean;
826: l_coa_id number;