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_GL_BATCH_TRANSFER dependencies on FUN_TRX_BATCHES

Line 115: TYPE batch_number IS TABLE OF fun_trx_batches.batch_number%TYPE INDEX BY BINARY_INTEGER;

111: TYPE party_type_flag IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
112: TYPE error_mesg IS TABLE OF fnd_new_messages.message_name%TYPE INDEX BY BINARY_INTEGER;
113: TYPE trx_id IS TABLE OF fun_trx_headers.trx_id%TYPE INDEX BY BINARY_INTEGER;
114: TYPE trx_number IS TABLE OF fun_trx_headers.trx_number%TYPE INDEX BY BINARY_INTEGER;
115: TYPE batch_number IS TABLE OF fun_trx_batches.batch_number%TYPE INDEX BY BINARY_INTEGER;
116: TYPE batch_id IS TABLE OF fun_trx_batches.batch_id%TYPE INDEX BY BINARY_INTEGER; -- Bug 6797385.
117:
118:
119: l_status_tbl status;

Line 116: TYPE batch_id IS TABLE OF fun_trx_batches.batch_id%TYPE INDEX BY BINARY_INTEGER; -- Bug 6797385.

112: TYPE error_mesg IS TABLE OF fnd_new_messages.message_name%TYPE INDEX BY BINARY_INTEGER;
113: TYPE trx_id IS TABLE OF fun_trx_headers.trx_id%TYPE INDEX BY BINARY_INTEGER;
114: TYPE trx_number IS TABLE OF fun_trx_headers.trx_number%TYPE INDEX BY BINARY_INTEGER;
115: TYPE batch_number IS TABLE OF fun_trx_batches.batch_number%TYPE INDEX BY BINARY_INTEGER;
116: TYPE batch_id IS TABLE OF fun_trx_batches.batch_id%TYPE INDEX BY BINARY_INTEGER; -- Bug 6797385.
117:
118:
119: l_status_tbl status;
120: l_party_type_flag_tbl party_type_flag;

Line 173: fun_trx_batches trxB,

169: trxH.trx_number trx_number,
170: trxB.batch_number batch_number,
171: trxB.batch_id batch_id
172: from
173: fun_trx_batches trxB,
174: fun_trx_headers trxH,
175: gl_periods periods,
176: gl_ledgers ledgers,
177: gl_period_statuses glps,

Line 219: from fun_trx_batches trxb, gl_ledgers ledgers,

215: select gt.BATCH_ID, gt.TRX_ID, P.PARTY_NAME,
216: GT.PARTY_ID, GT.LE_ID, gt.LEDGER_ID, gt.party_type_flag,
217: gt.p_request_id,
218: gt.STATUS, gt.description
219: from fun_trx_batches trxb, gl_ledgers ledgers,
220: HZ_PARTIES P,
221: (
222: SELECT TB.BATCH_ID , TH.INITIATOR_ID party_id, TH.TRX_ID, ''I''
223: party_type_flag, '''||p_request_id||''' p_request_id, tB.description Description,

Line 225: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB

221: (
222: SELECT TB.BATCH_ID , TH.INITIATOR_ID party_id, TH.TRX_ID, ''I''
223: party_type_flag, '''||p_request_id||''' p_request_id, tB.description Description,
224: TB.FROM_LE_ID LE_ID, TH.STATUS, tB.from_ledger_id LEDGER_ID
225: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB
226: WHERE TH.INVOICE_FLAG = ''N''
227: AND NOT EXISTS ( SELECT TRX_ID FROM
228: FUN_TRANSFERS FT WHERE FT.TRX_ID = TH.TRX_ID AND
229: FT.PARTY_TYPE_FLAG = ''I'')

Line 236: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB

232: UNION ALL
233: SELECT TB.BATCH_ID, TH.RECIPIENT_ID party_id, TH.TRX_ID, ''R''
234: party_type_flag, '''||p_request_id||''' p_request_id, tH.description Description,
235: TH.TO_LE_ID LE_ID, TH.STATUS, TH.TO_LEDGER_ID LEDGER_ID
236: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB
237: WHERE TH.INVOICE_FLAG = ''N''
238: AND NOT EXISTS ( SELECT TRX_ID FROM
239: FUN_TRANSFERS FT WHERE FT.TRX_ID = TH.TRX_ID AND
240: FT.PARTY_TYPE_FLAG = ''R'')

Line 381: FUN_TRX_BATCHES TRXB,

377: FROM
378: GL_LEDGERS LEDGERS,
379: GL_PERIOD_STATUSES GLPS,
380: GL_PERIODS PERIODS,
381: FUN_TRX_BATCHES TRXB,
382: FUN_TRX_LINES T,
383: FUN_DIST_LINES D,
384: fun_transfers gt
385: WHERE TRXB.BATCH_ID = GT.BATCH_ID

Line 519: -- Bug 6797385. Update the status in fun_trx_batches starts here.

515: 'XFER_INI_GL', 'COMPLETE'))
516: WHERE trx_id = l_trx_id_tbl(l_index)
517: AND l_error_mesg_tbl(l_index) = 'FUN_API_TRX_TRANSFERRED';
518: END IF;
519: -- Bug 6797385. Update the status in fun_trx_batches starts here.
520: IF l_batch_id_tbl.COUNT > 0
521: THEN
522: FORALL l_index IN l_batch_id_tbl.FIRST .. l_batch_id_tbl.LAST
523: UPDATE fun_trx_batches b

Line 523: UPDATE fun_trx_batches b

519: -- Bug 6797385. Update the status in fun_trx_batches starts here.
520: IF l_batch_id_tbl.COUNT > 0
521: THEN
522: FORALL l_index IN l_batch_id_tbl.FIRST .. l_batch_id_tbl.LAST
523: UPDATE fun_trx_batches b
524: SET b.status = 'COMPLETE'
525: WHERE NOT EXISTS ( SELECT trx_id
526: FROM fun_trx_headers
527: WHERE fun_trx_headers.batch_id = b.batch_id

Line 532: -- Bug 6797385. Update the status in fun_trx_batches Ends here.

528: AND status NOT IN ('COMPLETE', 'REJECTED'))
529: AND b.batch_id = l_batch_id_tbl(l_index)
530: AND b.status <> 'COMPLETE';
531: END IF;
532: -- Bug 6797385. Update the status in fun_trx_batches Ends here.
533: IF l_trx_id_tbl.COUNT > 0 THEN
534: FOR l_index IN l_trx_id_tbl.FIRST .. l_trx_id_tbl.LAST
535: LOOP
536: IF (l_error_mesg_tbl(l_index) like 'GL_PERIOD_NOT_OPEN%') THEN

Line 555: UPDATE fun_trx_batches

551: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
552: END IF;
553:
554: /* Bug 6797385.
555: UPDATE fun_trx_batches
556: SET status = 'COMPLETE'
557: WHERE status <> 'COMPLETE'
558: AND NOT EXISTS ( SELECT trx_id
559: FROM fun_trx_headers

Line 560: WHERE fun_trx_headers.batch_id = fun_trx_batches.batch_id

556: SET status = 'COMPLETE'
557: WHERE status <> 'COMPLETE'
558: AND NOT EXISTS ( SELECT trx_id
559: FROM fun_trx_headers
560: WHERE fun_trx_headers.batch_id = fun_trx_batches.batch_id
561: AND status NOT IN ('COMPLETE', 'REJECTED'));
562: */
563: DELETE fun_transfers
564: WHERE REQUEST_ID = P_REQUEST_ID;