[Home] [Help]
54:
55: -- Get the period information
56: IF ( (form_mode IN ('A', 'E'))
57: AND (default_ledger_id IS NOT NULL)) THEN
58: default_period_name := gl_period_statuses_pkg.default_actual_period(
59: acc_id, default_ledger_id);
60: IF (default_period_name IS NOT NULL) THEN
61: gl_period_statuses_pkg.select_columns(
62: 101,
57: AND (default_ledger_id IS NOT NULL)) THEN
58: default_period_name := gl_period_statuses_pkg.default_actual_period(
59: acc_id, default_ledger_id);
60: IF (default_period_name IS NOT NULL) THEN
61: gl_period_statuses_pkg.select_columns(
62: 101,
63: default_ledger_id,
64: default_period_name,
65: period_status,
98: X_Reversal_Period => default_reversal_period,
99: X_Reversal_Date => default_reversal_date);
100:
101: IF (default_reversal_period IS NOT NULL) THEN
102: gl_period_statuses_pkg.select_columns(
103: x_application_id => 101,
104: x_ledger_id => default_ledger_id,
105: x_period_name => default_reversal_period,
106: x_closing_status => period_status,
143: user_fixed_conversion_type);
144:
145: -- Get the range of valid dates
146: IF (default_ledger_id IS NOT NULL) THEN
147: gl_period_statuses_pkg.get_journal_range(
148: default_ledger_id,
149: start_active_date,
150: end_active_date);
151: END IF;
170: WHERE ledger_id = x_lgr_id;
171:
172: SELECT ps.period_name, ps.closing_status, ps.start_date, ps.end_date
173: INTO x_period_name, x_period_status, x_start_date, x_end_date
174: FROM gl_date_period_map map, gl_period_statuses ps
175: WHERE map.period_set_name = acct_cal_name
176: AND map.period_type = acc_period_type
177: AND map.accounting_date = x_accounting_date
178: AND ps.application_id = 101
189: IF (x_arg_type = 'L') THEN
190: BEGIN
191: SELECT 1
192: INTO dummy
193: FROM gl_period_statuses ps1
194: WHERE ps1.application_id = 101
195: AND ps1.ledger_id = x_arg_id
196: AND ps1.period_name = x_period_name
197: AND EXISTS
195: AND ps1.ledger_id = x_arg_id
196: AND ps1.period_name = x_period_name
197: AND EXISTS
198: (SELECT 'later open'
199: FROM gl_period_statuses ps2
200: WHERE ps2.application_id = 101
201: AND ps2.ledger_id = ps1.ledger_id
202: AND ps2.effective_period_num > ps1.effective_period_num
203: AND ps2.closing_status IN ('O', 'C', 'P'));
213: INTO dummy
214: FROM dual
215: WHERE EXISTS
216: (SELECT 'not latest'
217: FROM gl_period_statuses ps1, gl_period_statuses ps2
218: WHERE ps1.application_id = 101
219: AND ps1.ledger_id IN (SELECT ledger_id
220: FROM gl_je_headers
221: WHERE je_batch_id = x_arg_id)
241: dummy VARCHAR2(100);
242: BEGIN
243: SELECT 'default good'
244: INTO dummy
245: FROM gl_ledgers lgr, gl_period_statuses ps, gl_access_set_ledgers acc
246: WHERE lgr.ledger_id = x_ledger_id
247: AND ( (x_average_journal_flag = 'N')
248: OR (lgr.consolidation_ledger_flag = 'Y'))
249: AND ps.application_id = 101
278: AND period_type = x_period_type
279: AND NOT EXISTS
280: (SELECT 'unopened ledger'
281: FROM gl_je_headers jeh,
282: gl_period_statuses ps
283: WHERE jeh.je_batch_id = x_je_batch_id
284: AND (jeh.display_alc_journal_flag IS NULL
285: or jeh.display_alc_journal_flag = 'Y')
286: AND ps.application_id = 101
296: AND period_type = x_period_type
297: AND NOT EXISTS
298: (SELECT 'unopened ledger'
299: FROM gl_je_headers jeh,
300: gl_period_statuses ps
301: WHERE jeh.je_batch_id = x_je_batch_id
302: AND (jeh.display_alc_journal_flag IS NULL
303: or jeh.display_alc_journal_flag = 'Y')
304: AND ps.application_id = 101
336: RAISE;
337: WHEN OTHERS THEN
338: fnd_message.set_name('SQLGL', 'GL_UNHANDLED_EXCEPTION');
339: fnd_message.set_token('PROCEDURE',
340: 'gl_period_statuses_pkg.default_actual_period');
341: RAISE;
342: END default_actual_period;
343:
344: PROCEDURE set_find_window_state(w_state VARCHAR2) IS