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_DATE_HANDLER_PKG dependencies on GL_PERIOD_STATUSES

Line 29: FROM gl_period_statuses ps

25:
26: CURSOR find_period IS
27: SELECT ps.period_name, ps.start_date, ps.end_date, ps.period_num,
28: ps.period_year
29: FROM gl_period_statuses ps
30: WHERE ps.application_id = 101
31: AND ps.ledger_id = lgr_id
32: AND ps.start_date <= trunc(active_date)
33: AND ps.end_date >= trunc(active_date)

Line 44: FROM gl_date_period_map map, gl_period_statuses ps

40: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
41: ps.period_num, ps.period_year
42: INTO x_active_period, period_status, x_per_start_date, x_per_end_date,
43: x_per_number, x_per_year
44: FROM gl_date_period_map map, gl_period_statuses ps
45: WHERE map.period_set_name = calendar
46: AND map.period_type = per_type
47: AND map.accounting_date = trunc(active_date)
48: AND ps.application_id = 101

Line 107: FROM gl_period_statuses ps

103:
104: CURSOR find_period IS
105: SELECT ps.period_name, ps.start_date, ps.end_date, ps.period_num,
106: ps.period_year
107: FROM gl_period_statuses ps
108: WHERE ps.application_id = 101
109: AND ps.ledger_id = lgr_id
110: AND ps.start_date <= trunc(active_date)
111: AND ps.end_date >= trunc(active_date)

Line 127: FROM gl_date_period_map map, gl_period_statuses ps

123: SELECT ps.period_name, ps.start_date, ps.end_date,
124: ps.period_num, ps.period_year
125: INTO x_active_period, x_per_start_date, x_per_end_date,
126: x_per_number, x_per_year
127: FROM gl_date_period_map map, gl_period_statuses ps
128: WHERE map.period_set_name = calendar
129: AND map.period_type = per_type
130: AND map.accounting_date = trunc(active_date)
131: AND ps.application_id = 101

Line 193: FROM gl_period_statuses ps

189:
190: CURSOR find_period IS
191: SELECT ps.period_name, ps.start_date, ps.end_date, ps.period_num,
192: ps.period_year
193: FROM gl_period_statuses ps
194: WHERE ps.application_id = 101
195: AND ps.ledger_id = one_ledger_id
196: AND ps.start_date <= trunc(active_date)
197: AND ps.end_date >= trunc(active_date)

Line 221: FROM gl_date_period_map map, gl_period_statuses ps

217: SELECT ps.period_name, ps.start_date, ps.end_date,
218: ps.period_num, ps.period_year
219: INTO x_active_period, x_per_start_date, x_per_end_date,
220: x_per_number, x_per_year
221: FROM gl_date_period_map map, gl_period_statuses ps
222: WHERE map.period_set_name = calendar
223: AND map.period_type = per_type
224: AND map.accounting_date = trunc(active_date)
225: AND ps.application_id = 101

Line 301: FROM gl_period_statuses ps

297:
298: CURSOR find_period IS
299: SELECT ps.period_name, ps.start_date, ps.end_date, ps.period_year,
300: ps.period_num
301: FROM gl_period_statuses ps
302: WHERE ps.application_id = 101
303: AND ps.ledger_id = lgr_id
304: AND ps.start_date <= trunc(initial_accounting_date)
305: AND ps.end_date >= trunc(initial_accounting_date)

Line 324: FROM gl_period_statuses

320:
321: IF (minimum_period IS NOT NULL) THEN
322: SELECT effective_period_num
323: INTO min_eff_period_num
324: FROM gl_period_statuses
325: WHERE application_id = 101
326: AND ledger_id = lgr_id
327: AND period_name = minimum_period;
328: END IF;

Line 334: FROM gl_date_period_map map, gl_period_statuses ps

330: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
331: ps.period_year, ps.period_num
332: INTO x_period_name, period_status, period_start_date,
333: period_end_date, tmp_year, tmp_num
334: FROM gl_date_period_map map, gl_period_statuses ps
335: WHERE map.period_set_name = acct_cal_name
336: AND map.period_type = acc_period_type
337: AND map.accounting_date = initial_accounting_date
338: AND ps.application_id = 101

Line 358: FROM gl_period_statuses ps

354: SELECT ps.closing_status, ps.start_date, ps.end_date,
355: ps.period_year, ps.period_num
356: INTO period_status, period_start_date, period_end_date,
357: tmp_year, tmp_num
358: FROM gl_period_statuses ps
359: WHERE ps.application_id = 101
360: AND ps.ledger_id = lgr_id
361: AND ps.period_name = x_period_name
362: AND ps.effective_period_num >= min_eff_period_num;

Line 495: FROM gl_period_statuses ps

491:
492: CURSOR find_period IS
493: SELECT ps.period_name, ps.start_date, ps.end_date, ps.period_year,
494: ps.period_num
495: FROM gl_period_statuses ps
496: WHERE ps.application_id = 101
497: AND ps.ledger_id = one_ledger_id
498: AND ps.start_date <= trunc(initial_accounting_date)
499: AND ps.end_date >= trunc(initial_accounting_date)

Line 504: FROM gl_je_headers jeh, gl_period_statuses ps2

500: AND ps.effective_period_num >= min_eff_period_num
501: AND ps.closing_status IN ('O', 'F')
502: AND NOT EXISTS
503: (SELECT 'not open or future'
504: FROM gl_je_headers jeh, gl_period_statuses ps2
505: WHERE jeh.je_batch_id = batch_id
506: AND ps2.application_id = 101
507: AND ps2.ledger_id = jeh.ledger_id
508: AND ps2.period_name = ps.period_name

Line 539: FROM gl_date_period_map map, gl_period_statuses ps

535: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
536: ps.period_year, ps.period_num
537: INTO x_period_name, period_status, period_start_date,
538: period_end_date, tmp_year, tmp_num
539: FROM gl_date_period_map map, gl_period_statuses ps
540: WHERE map.period_set_name = acct_cal_name
541: AND map.period_type = acc_period_type
542: AND map.accounting_date = initial_accounting_date
543: AND ps.application_id = 101

Line 550: FROM gl_je_headers jeh, gl_period_statuses ps2

546: AND ps.effective_period_num >= min_eff_period_num
547: AND ps.closing_status IN ('O', 'F')
548: AND NOT EXISTS
549: (SELECT 'not open or future'
550: FROM gl_je_headers jeh, gl_period_statuses ps2
551: WHERE jeh.je_batch_id = batch_id
552: AND ps2.application_id = 101
553: AND ps2.ledger_id = jeh.ledger_id
554: AND ps2.period_name = ps.period_name

Line 572: FROM gl_period_statuses ps

568: SELECT ps.closing_status, ps.start_date, ps.end_date,
569: ps.period_year, ps.period_num
570: INTO period_status, period_start_date, period_end_date,
571: tmp_year, tmp_num
572: FROM gl_period_statuses ps
573: WHERE ps.application_id = 101
574: AND ps.ledger_id = one_ledger_id
575: AND ps.period_name = x_period_name
576: AND ps.effective_period_num >= min_eff_period_num

Line 580: FROM gl_je_headers jeh, gl_period_statuses ps2

576: AND ps.effective_period_num >= min_eff_period_num
577: AND ps.closing_status IN ('O', 'F')
578: AND NOT EXISTS
579: (SELECT 'not open or future'
580: FROM gl_je_headers jeh, gl_period_statuses ps2
581: WHERE jeh.je_batch_id = batch_id
582: AND ps2.application_id = 101
583: AND ps2.ledger_id = jeh.ledger_id
584: AND ps2.period_name = ps.period_name

Line 746: FROM gl_period_statuses ps

742:
743: CURSOR find_period IS
744: SELECT ps.period_name, ps.start_date, ps.end_date, ps.period_num,
745: ps.period_year
746: FROM gl_period_statuses ps
747: WHERE ps.application_id = 101
748: AND ps.ledger_id = lgr_id
749: AND ps.start_date <= trunc(active_date)
750: AND ps.end_date >= trunc(active_date)

Line 761: FROM gl_date_period_map map, gl_period_statuses ps

757: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date,
758: ps.period_num, ps.period_year
759: INTO x_from_period, period_status, x_per_start_date, x_per_end_date,
760: x_per_number, x_per_year
761: FROM gl_date_period_map map, gl_period_statuses ps
762: WHERE map.period_set_name = calendar
763: AND map.period_type = per_type
764: AND map.accounting_date = trunc(active_date)
765: AND ps.application_id = 101