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 305: Select 1 from dual where exists

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: -- Bug 9634573 modified below cursor to fetch src name from table rather than hard coded value
304: cursor c_open_int_ar(l_prd_name in Varchar2) is
305: Select 1 from dual where exists
306: (Select 'X' from
307: ra_interface_lines_all ri,
308: fun_period_statuses fps
309: where ri.batch_source_name = (SELECT name FROM

Line 316: Select 1 from dual where exists

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

Line 329: Select 1 from dual where exists

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

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

874: l_running_total_dr := 0;
875: l_running_total_cr := 0;
876:
877: --Fecthing the New Batch_id
878: SELECT FUN_TRX_BATCHES_S.nextval INTO l_batch_id FROM DUAL;
879:
880: --Fetching the New Batch Number
881: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
882: 'LOCAL',

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

987: FOR l_trx_id in c_trx_id(l_partial_batch.BATCH_ID)
988: LOOP
989: l_header_trx_id := 0;
990: l_line_id := 0;
991: SELECT FUN_TRX_HEADERS_S.nextval INTO l_header_trx_id FROM DUAL;
992: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;
993:
994: INSERT INTO FUN_TRX_HEADERS
995: (TRX_ID,

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

988: LOOP
989: l_header_trx_id := 0;
990: l_line_id := 0;
991: SELECT FUN_TRX_HEADERS_S.nextval INTO l_header_trx_id FROM DUAL;
992: SELECT FUN_TRX_LINES_S.nextval INTO l_line_id FROM DUAL;
993:
994: INSERT INTO FUN_TRX_HEADERS
995: (TRX_ID,
996: BATCH_ID,

Line 1452: select FND_ATTACHED_DOCUMENTS_S.nextval into l_batch_ATTACHED_DOCUMENT_ID from dual;

1448: LOOP
1449: FETCH c_batch_attm INTO l_batch_attchmt_rec_type;
1450: EXIT WHEN c_batch_attm%NOTFOUND;
1451:
1452: select FND_ATTACHED_DOCUMENTS_S.nextval into l_batch_ATTACHED_DOCUMENT_ID from dual;
1453: l_batch_DOCUMENT_ID := NULL;
1454:
1455: fnd_attached_documents_pkg.Insert_Row(
1456: X_Rowid => l_batch_attchmt_rec_type.ROWID,

Line 1557: FROM DUAL

1553:
1554: -- Update status of old batch to complete
1555: UPDATE FUN_TRX_BATCHES
1556: SET STATUS = DECODE ((SELECT 1
1557: FROM DUAL
1558: WHERE EXISTS (SELECT 'X' FROM FUN_TRX_HEADERS
1559: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1560: AND STATUS NOT IN ('COMPLETE', 'REJECTED'))), 1, 'SENT', 'COMPLETE'),
1561: LAST_UPDATED_BY = fnd_global.user_id,

Line 1589: Select 1 from dual where exists

1585: p_close IN VARCHAR2
1586: ) IS
1587: cursor c_chk_open1(l_trx_type_id in Number)
1588: is
1589: Select 1 from dual where exists
1590: (Select 'X' from
1591: fun_period_statuses fps,fun_system_options fso where p_sweep_GL_date
1592: >= fps.start_date and p_sweep_GL_date <= fps.end_date and
1593: status = 'O' and trx_type_id = l_trx_type_id

Line 1598: Select 1 from dual where exists

1594: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1595: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
1596: cursor c_chk_prd_open1(l_prd_name in Varchar2,l_trx_type_id in
1597: Number) is
1598: Select 1 from dual where exists
1599: (Select 'X' from
1600: fun_period_statuses fps,fun_system_options fso where period_name = l_prd_name and
1601: trx_type_id = l_trx_type_id and status IN ('O','S')
1602: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')

Line 1605: Select 1 from dual where exists

1601: trx_type_id = l_trx_type_id and status IN ('O','S')
1602: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1603: AND fps.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
1604: cursor c_chk_open2(l_prd_name in Varchar2) is
1605: Select 1 from dual where exists
1606: (Select 'X'
1607: from
1608: fun_period_statuses
1609: fps1, fun_period_statuses fps2,fun_system_options fso where p_sweep_GL_date

Line 1618: Select 1 from dual where exists

1614: AND fps1.inteco_period_type=nvl(fso.inteco_period_type,'~~')
1615: AND fps2.inteco_calendar=nvl(fso.inteco_calendar,'~~')
1616: AND fps2.inteco_period_type=nvl(fso.inteco_period_type,'~~'));
1617: cursor c_chk_prd_open2(l_prd_name in Varchar2) is
1618: Select 1 from dual where exists
1619: (Select 'X'
1620: from
1621: fun_period_statuses fps,fun_system_options fso where period_name = l_prd_name and status = 'O'
1622: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')