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 316: fun_trx_batches ftb, fun_trx_headers fth,

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

Line 603: l_batch_id FUN_TRX_BATCHES.BATCH_ID%TYPE;

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

Line 604: l_batch_number FUN_TRX_BATCHES.BATCH_NUMBER%TYPE;

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

Line 605: l_running_total_dr FUN_TRX_BATCHES.RUNNING_TOTAL_DR%TYPE;

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

Line 606: l_running_total_cr FUN_TRX_BATCHES.RUNNING_TOTAL_CR%TYPE;

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

Line 616: (BATCH_ID FUN_TRX_BATCHES.BATCH_ID%TYPE,

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

Line 617: BATCH_NUMBER FUN_TRX_BATCHES.BATCH_NUMBER%TYPE);

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

Line 653: FROM FUN_TRX_BATCHES

649:
650: --Bug 7115161. Changed the Query to fetch the batch number also
651:
652: sqlstmt := 'SELECT BATCH_ID, BATCH_NUMBER
653: FROM FUN_TRX_BATCHES
654: WHERE GL_DATE >= ''' || l_start_date || '''
655: AND GL_DATE <= ''' || l_end_date || '''
656: AND TRX_TYPE_ID = ''' || p_trx_type_id || '''
657: AND BATCH_ID IN

Line 665: FROM FUN_TRX_BATCHES

661: AND STATUS NOT IN (''COMPLETE'', ''NEW'')';
662:
663: ELSE
664: sqlstmt := 'SELECT BATCH_ID, BATCH_NUMBER
665: FROM FUN_TRX_BATCHES
666: WHERE GL_DATE >=
667: (SELECT DISTINCT START_DATE
668: FROM FUN_PERIOD_STATUSES FPS,FUN_SYSTEM_OPTIONS FSO
669: WHERE FPS.PERIOD_NAME = ''' || p_period_name || '''

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

711: --Fetching the New Batch Number
712: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
713: 'LOCAL',
714: 435,
715: 'FUN_TRX_BATCHES',
716: 'CREATION',
717: null,
718: l_control_date_tbl,
719: 'N',

Line 726: INSERT INTO FUN_TRX_BATCHES

722: l_assignment_id,
723: l_error_code);
724:
725: -- Bug 7115161. Populating the Old Batch number to the Notes field
726: INSERT INTO FUN_TRX_BATCHES
727: (BATCH_ID,
728: BATCH_NUMBER,
729: GL_DATE,
730: STATUS,

Line 815: FROM FUN_TRX_BATCHES

811: ATTRIBUTE14,
812: ATTRIBUTE15,
813: ATTRIBUTE_CATEGORY,
814: AUTO_PRORATION_FLAG
815: FROM FUN_TRX_BATCHES
816: WHERE BATCH_ID = l_partial_batch.BATCH_ID;
817:
818: FOR l_trx_id in c_trx_id(l_partial_batch.BATCH_ID)
819: LOOP

Line 1034: UPDATE FUN_TRX_BATCHES

1030: INTO l_running_total_dr, l_running_total_cr
1031: FROM FUN_TRX_HEADERS
1032: WHERE BATCH_ID = l_batch_id;
1033:
1034: UPDATE FUN_TRX_BATCHES
1035: SET RUNNING_TOTAL_DR = l_running_total_dr,
1036: RUNNING_TOTAL_CR = l_running_total_cr
1037: WHERE BATCH_ID = l_batch_id;
1038:

Line 1050: UPDATE FUN_TRX_BATCHES

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

Line 1179: Update fun_trx_batches set gl_date =

1175: End If;
1176: close c_chk_open1;
1177: Print('Sweeping the transactions');
1178: /* Update the Periods */
1179: Update fun_trx_batches set gl_date =
1180: p_sweep_GL_date Where gl_date >= (select start_date from
1181: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1182: fps.trx_type_id = p_trx_type_id
1183: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')

Line 1227: Update fun_trx_batches set gl_date = p_sweep_GL_date

1223: Raise FND_API.G_EXC_ERROR;
1224: End If;
1225: close c_chk_open2;
1226: /* Sweep the transactions */
1227: Update fun_trx_batches set gl_date = p_sweep_GL_date
1228: Where gl_date >= (select distinct start_date from
1229: fun_period_statuses fps,fun_system_options fso where fps.period_name = p_period_name and
1230: fps.trx_type_id = p_trx_type_id
1231: AND fps.inteco_calendar=nvl(fso.inteco_calendar,'~~')