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.FUN_PERIOD_STATUS_PKG dependencies on DUAL

Line 36: Select 1 from dual where exists

32: p_sweep_GL_date IN DATE,
33: x_request_id OUT NOCOPY NUMBER
34: ) IS
35: Cursor c_open_trx1(l_prd_name in Varchar2,l_trx_type_id in Number) is
36: Select 1 from dual where exists
37: (Select 'X' from fun_trx_batches ftb, fun_trx_headers fth,
38: fun_period_statuses fps,fun_system_options fso where ftb.batch_id = fth.batch_id and
39: ftb.gl_date >= fps.start_date and ftb.gl_date <=
40: fps.end_date and fps.period_name = l_prd_name and

Line 49: Select 1 from dual where exists

45: AND h2.batch_id = ftb.batch_id) -- Bug No : 6880343
46: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
47: AND fps.inteco_period_type =nvl(fso.inteco_period_type,'~~'));
48: Cursor c_open_trx2(l_prd_name in Varchar2) is
49: Select 1 from dual where exists
50: (Select 'X' from fun_trx_batches ftb, fun_trx_headers fth,
51: fun_period_statuses fps,fun_system_options fso where ftb.batch_id = fth.batch_id and
52: ftb.gl_date >= fps.start_date and ftb.gl_date <=
53: fps.end_date and fps.period_name = l_prd_name

Line 63: Select 1 from dual where exists

59: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
60: AND fps.inteco_period_type =nvl(fso.inteco_period_type,'~~'));
61: Cursor c_open_prd1(l_prd_name in Varchar2, l_trx_type_id in
62: Number) is
63: Select 1 from dual where exists
64: (Select 'X' from fun_period_statuses fps,fun_system_options fso where fps.status = 'O'
65: and trx_type_id = l_trx_type_id and period_name = l_prd_name
66: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
67: AND fps.inteco_period_type =nvl(fso.inteco_period_type,'~~'));

Line 69: Select 1 from dual where exists

65: and trx_type_id = l_trx_type_id and period_name = l_prd_name
66: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
67: AND fps.inteco_period_type =nvl(fso.inteco_period_type,'~~'));
68: Cursor c_open_prd2(l_prd_name in Varchar2) is
69: Select 1 from dual where exists
70: (Select 'X' from fun_period_statuses fps,fun_system_options fso where fps.status = 'O'
71: and period_name = l_prd_name
72: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
73: AND fps.inteco_period_type =nvl(fso.inteco_period_type,'~~'));

Line 262: Select 1 from dual where exists

258: fun_system_options where inteco_calendar =
259: l_period_set_name and inteco_period_type =
260: l_period_type;
261: Cursor c_ic_prd_open(l_prd_name in Varchar2) is
262: Select 1 from dual where exists
263: (Select 'X' from
264: fun_period_statuses fps,fun_system_options fso where period_name
265: = l_prd_name and status = 'O'
266: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')

Line 269: Select 1 from dual where exists

265: = l_prd_name and status = 'O'
266: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
267: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
268: Cursor c_open_trx_ap(l_prd_name in Varchar2) is
269: Select 1 from dual where exists
270: (Select 'X' from
271: fun_trx_batches ftb, fun_trx_headers fth,
272: fun_period_statuses fps,fun_system_options fso where
273: ftb.batch_id = fth.batch_id and

Line 282: Select 1 from dual where exists

278: and fun_tca_pkg.get_ou_id(fth.recipient_id) = p_org_id
279: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
280: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
281: cursor c_open_int_ap(l_prd_name in Varchar2) is
282: Select 1 from dual where exists
283: (Select 'X' from
284: ap_invoices_interface api,
285: fun_period_statuses fps,fun_system_options fso
286: where api.source = 'GLOBAL_INTERCOMPANY' and

Line 294: Select 1 from dual where exists

290: fps.period_name = l_prd_name
291: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
292: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
293: Cursor c_open_trx_ar(l_prd_name in Varchar2) is
294: Select 1 from dual where exists
295: (Select 'X' from
296: fun_trx_batches ftb, fun_trx_headers fth,
297: fun_period_statuses fps where ftb.batch_id = fth.batch_id and
298: ftb.trx_type_id=fps.trx_type_id and

Line 304: Select 1 from dual where exists

300: fps.end_date and fps.period_name = l_prd_name and
301: fth.status not in ('NEW', 'REJECTED', 'COMPLETE', 'XFER_AR')
302: and fun_tca_pkg.get_ou_id(fth.initiator_id) = p_org_id);
303: cursor c_open_int_ar(l_prd_name in Varchar2) is
304: Select 1 from dual where exists
305: (Select 'X' from
306: ra_interface_lines_all ri,
307: fun_period_statuses fps
308: where ri.batch_source_name = 'Global Intercompany' and

Line 314: Select 1 from dual where exists

310: ri.gl_date >= fps.start_date and ri.gl_date <=
311: fps.end_date and
312: fps.period_name = l_prd_name);
313: Cursor c_open_trx_gl(l_prd_name in Varchar2) is
314: Select 1 from dual where exists
315: (Select 'X' from
316: fun_trx_batches ftb, fun_trx_headers fth,
317: fun_period_statuses fps,fun_system_options fso where ftb.batch_id = fth.batch_id and
318: ftb.gl_date >= fps.start_date and ftb.gl_date <=

Line 327: Select 1 from dual where exists

323: fth.to_ledger_id = p_ledger_id
324: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
325: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
326: cursor c_open_int_gl(l_prd_name in Varchar2) is
327: Select 1 from dual where exists
328: (Select 'X' from
329: gl_interface gi,
330: fun_period_statuses fps,fun_system_options fso
331: where gi.user_je_source_name = 'Global Intercompany' and

Line 709: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;

705: l_running_total_dr := 0;
706: l_running_total_cr := 0;
707:
708: --Fecthing the New Batch_id
709: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;
710:
711: --Fetching the New Batch Number
712: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
713: 'LOCAL',

Line 822: SELECT FUN_TRX_HEADERS_S.nextval INTO l_header_trx_id FROM DUAL;

818: FOR l_trx_id in c_trx_id(l_partial_batch.BATCH_ID)
819: LOOP
820: l_header_trx_id := 0;
821: l_line_id := 0;
822: SELECT FUN_TRX_HEADERS_S.nextval INTO l_header_trx_id FROM DUAL;
823: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;
824:
825: INSERT INTO FUN_TRX_HEADERS
826: (TRX_ID,

Line 823: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;

819: LOOP
820: l_header_trx_id := 0;
821: l_line_id := 0;
822: SELECT FUN_TRX_HEADERS_S.nextval INTO l_header_trx_id FROM DUAL;
823: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;
824:
825: INSERT INTO FUN_TRX_HEADERS
826: (TRX_ID,
827: BATCH_ID,

Line 1052: FROM DUAL

1048:
1049: -- Update status of old batch to complete
1050: UPDATE FUN_TRX_BATCHES
1051: SET STATUS = DECODE ((SELECT 1
1052: FROM DUAL
1053: WHERE EXISTS (SELECT 'X' FROM FUN_TRX_HEADERS
1054: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1055: AND STATUS NOT IN ('COMPLETE', 'REJECTED'))), 1, 'SENT', 'COMPLETE'),
1056: LAST_UPDATED_BY = fnd_global.user_id,

Line 1084: Select 1 from dual where exists

1080: p_close IN VARCHAR2
1081: ) IS
1082: cursor c_chk_open1(l_trx_type_id in Number)
1083: is
1084: Select 1 from dual where exists
1085: (Select 'X' from
1086: fun_period_statuses fps,fun_system_options fso where p_sweep_GL_date
1087: >= fps.start_date and p_sweep_GL_date <= fps.end_date and
1088: status = 'O' and trx_type_id = l_trx_type_id

Line 1093: Select 1 from dual where exists

1089: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1090: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
1091: cursor c_chk_prd_open1(l_prd_name in Varchar2,l_trx_type_id in
1092: Number) is
1093: Select 1 from dual where exists
1094: (Select 'X' from
1095: fun_period_statuses fps,fun_system_options fso where period_name = l_prd_name and
1096: trx_type_id = l_trx_type_id and status IN ('O','S')
1097: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')

Line 1100: Select 1 from dual where exists

1096: trx_type_id = l_trx_type_id and status IN ('O','S')
1097: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1098: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
1099: cursor c_chk_open2(l_prd_name in Varchar2) is
1100: Select 1 from dual where exists
1101: (Select 'X'
1102: from
1103: fun_period_statuses
1104: fps1, fun_period_statuses fps2,fun_system_options fso where p_sweep_GL_date

Line 1113: Select 1 from dual where exists

1109: AND fps1.inteco_period_type=nvl(fso.inteco_period_type,'~~')
1110: AND fps2.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1111: AND fps2.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
1112: cursor c_chk_prd_open2(l_prd_name in Varchar2) is
1113: Select 1 from dual where exists
1114: (Select 'X'
1115: from
1116: fun_period_statuses fps,fun_system_options fso where period_name = l_prd_name and status = 'O'
1117: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')