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 FUN_TRX_BATCHES

Line 37: (Select 'X' from fun_trx_batches ftb, fun_trx_headers fth,

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
41: fps.trx_type_id = l_trx_type_id and ftb.trx_type_id = l_trx_type_id and

Line 50: (Select 'X' from fun_trx_batches ftb, fun_trx_headers fth,

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
54: and ftb.trx_type_id = fps.trx_type_id and

Line 271: fun_trx_batches ftb, fun_trx_headers fth,

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
274: ftb.trx_type_id=fps.trx_type_id and
275: ftb.gl_date >= fps.start_date and ftb.gl_date <=

Line 296: fun_trx_batches ftb, fun_trx_headers fth,

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
299: ftb.gl_date >= fps.start_date and ftb.gl_date <=
300: fps.end_date and fps.period_name = l_prd_name and

Line 318: fun_trx_batches ftb, fun_trx_headers fth,

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 <=
321: fps.end_date and
322: ftb.trx_type_id=fps.trx_type_id and

Line 605: l_batch_id FUN_TRX_BATCHES.BATCH_ID%TYPE;

601: l_control_date_rec FUN_SEQ.CONTROL_DATE_REC_TYPE;
602: l_seq_version_id NUMBER;
603: l_assignment_id NUMBER;
604: l_error_code VARCHAR2(1000);
605: l_batch_id FUN_TRX_BATCHES.BATCH_ID%TYPE;
606: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;
607: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;
608: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;
609: l_header_trx_id FUN_TRX_HEADERS.TRX_ID%TYPE;

Line 606: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;

602: l_seq_version_id NUMBER;
603: l_assignment_id NUMBER;
604: l_error_code VARCHAR2(1000);
605: l_batch_id FUN_TRX_BATCHES.BATCH_ID%TYPE;
606: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;
607: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;
608: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;
609: l_header_trx_id FUN_TRX_HEADERS.TRX_ID%TYPE;
610: l_line_id FUN_TRX_LINES.LINE_ID%TYPE;

Line 607: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;

603: l_assignment_id NUMBER;
604: l_error_code VARCHAR2(1000);
605: l_batch_id FUN_TRX_BATCHES.BATCH_ID%TYPE;
606: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;
607: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;
608: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;
609: l_header_trx_id FUN_TRX_HEADERS.TRX_ID%TYPE;
610: l_line_id FUN_TRX_LINES.LINE_ID%TYPE;
611: l_start_date FUN_PERIOD_STATUSES.START_DATE%TYPE;

Line 608: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;

604: l_error_code VARCHAR2(1000);
605: l_batch_id FUN_TRX_BATCHES.BATCH_ID%TYPE;
606: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;
607: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;
608: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;
609: l_header_trx_id FUN_TRX_HEADERS.TRX_ID%TYPE;
610: l_line_id FUN_TRX_LINES.LINE_ID%TYPE;
611: l_start_date FUN_PERIOD_STATUSES.START_DATE%TYPE;
612: l_end_date FUN_PERIOD_STATUSES.END_DATE%TYPE;

Line 618: (BATCH_ID FUN_TRX_BATCHES.BATCH_ID%TYPE,

614:
615: TYPE c_partial_batches_type IS REF CURSOR;
616: -- Bug 7115161. Added Batch Number field
617: TYPE c_partial_batches_rec_type IS RECORD
618: (BATCH_ID FUN_TRX_BATCHES.BATCH_ID%TYPE,
619: BATCH_NUMBER FUN_TRX_BATCHES.BATCH_NUMBER%TYPE);
620:
621: c_partial_batches c_partial_batches_type;
622: l_partial_batch c_partial_batches_rec_type;

Line 619: BATCH_NUMBER FUN_TRX_BATCHES.BATCH_NUMBER%TYPE);

615: TYPE c_partial_batches_type IS REF CURSOR;
616: -- Bug 7115161. Added Batch Number field
617: TYPE c_partial_batches_rec_type IS RECORD
618: (BATCH_ID FUN_TRX_BATCHES.BATCH_ID%TYPE,
619: BATCH_NUMBER FUN_TRX_BATCHES.BATCH_NUMBER%TYPE);
620:
621: c_partial_batches c_partial_batches_type;
622: l_partial_batch c_partial_batches_rec_type;
623:

Line 820: FROM FUN_TRX_BATCHES

816:
817: --Bug 7115161. Changed the Query to fetch the batch number also
818:
819: sqlstmt := 'SELECT BATCH_ID, BATCH_NUMBER
820: FROM FUN_TRX_BATCHES
821: WHERE GL_DATE >= ''' || l_start_date || '''
822: AND GL_DATE <= ''' || l_end_date || '''
823: AND TRX_TYPE_ID = ''' || p_trx_type_id || '''
824: AND BATCH_ID IN

Line 832: FROM FUN_TRX_BATCHES

828: AND STATUS NOT IN (''COMPLETE'', ''NEW'')';
829:
830: ELSE
831: sqlstmt := 'SELECT BATCH_ID, BATCH_NUMBER
832: FROM FUN_TRX_BATCHES
833: WHERE GL_DATE >=
834: (SELECT DISTINCT START_DATE
835: FROM FUN_PERIOD_STATUSES FPS,FUN_SYSTEM_OPTIONS FSO
836: WHERE FPS.PERIOD_NAME = ''' || p_period_name || '''

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 884: 'FUN_TRX_BATCHES',

880: --Fetching the New Batch Number
881: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
882: 'LOCAL',
883: 435,
884: 'FUN_TRX_BATCHES',
885: 'CREATION',
886: null,
887: l_control_date_tbl,
888: 'N',

Line 895: INSERT INTO FUN_TRX_BATCHES

891: l_assignment_id,
892: l_error_code);
893:
894: -- Bug 7115161. Populating the Old Batch number to the Notes field
895: INSERT INTO FUN_TRX_BATCHES
896: (BATCH_ID,
897: BATCH_NUMBER,
898: GL_DATE,
899: STATUS,

Line 984: FROM FUN_TRX_BATCHES

980: ATTRIBUTE14,
981: ATTRIBUTE15,
982: ATTRIBUTE_CATEGORY,
983: AUTO_PRORATION_FLAG
984: FROM FUN_TRX_BATCHES
985: WHERE BATCH_ID = l_partial_batch.BATCH_ID;
986:
987: FOR l_trx_id in c_trx_id(l_partial_batch.BATCH_ID)
988: LOOP

Line 1440: where entity_name = ''FUN_TRX_BATCHES''

1436: from fnd_documents docs,
1437: FND_ATTACHED_DOCUMENTS atth,
1438: fnd_documents_tl tl
1439:
1440: where entity_name = ''FUN_TRX_BATCHES''
1441: and tl.LANGUAGE=''' || icx_language || '''
1442: and pk1_value=''' || l_partial_batch.BATCH_ID || '''
1443: and docs.document_id = atth.document_id
1444: and tl.document_id = atth.document_id';

Line 1539: UPDATE FUN_TRX_BATCHES

1535: INTO l_running_total_dr, l_running_total_cr
1536: FROM FUN_TRX_HEADERS
1537: WHERE BATCH_ID = l_batch_id;
1538:
1539: UPDATE FUN_TRX_BATCHES
1540: SET RUNNING_TOTAL_DR = l_running_total_dr,
1541: RUNNING_TOTAL_CR = l_running_total_cr
1542: WHERE BATCH_ID = l_batch_id;
1543:

Line 1555: UPDATE FUN_TRX_BATCHES

1551: WHERE BATCH_ID = l_partial_batch.BATCH_ID
1552: AND STATUS IN ('SENT','ERROR','RECEIVED');
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

Line 1687: Update fun_trx_batches set gl_date =

1683: End If;
1684: close c_chk_open1;
1685: Print('Sweeping the transactions');
1686: /* Update the Periods */
1687: Update fun_trx_batches set gl_date =
1688: p_sweep_GL_date Where gl_date >= (select start_date from
1689: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1690: fps.trx_type_id = p_trx_type_id
1691: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')

Line 1735: Update fun_trx_batches set gl_date = p_sweep_GL_date

1731: Raise FND_API.G_EXC_ERROR;
1732: End If;
1733: close c_chk_open2;
1734: /* Sweep the transactions */
1735: Update fun_trx_batches set gl_date = p_sweep_GL_date
1736: Where gl_date >= (select distinct start_date from
1737: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1738: fps.trx_type_id = p_trx_type_id
1739: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')