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 107: TYPE batch_number IS TABLE OF fun_trx_batches.batch_number%TYPE INDEX BY BINARY_INTEGER;

103: TYPE party_type_flag IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
104: TYPE error_mesg IS TABLE OF fnd_new_messages.message_name%TYPE INDEX BY BINARY_INTEGER;
105: TYPE trx_id IS TABLE OF fun_trx_headers.trx_id%TYPE INDEX BY BINARY_INTEGER;
106: TYPE trx_number IS TABLE OF fun_trx_headers.trx_number%TYPE INDEX BY BINARY_INTEGER;
107: TYPE batch_number IS TABLE OF fun_trx_batches.batch_number%TYPE INDEX BY BINARY_INTEGER;
108: TYPE batch_id IS TABLE OF fun_trx_batches.batch_id%TYPE INDEX BY BINARY_INTEGER; -- Bug 6797385.
109:
110:
111: l_status_tbl status;

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

104: TYPE error_mesg IS TABLE OF fnd_new_messages.message_name%TYPE INDEX BY BINARY_INTEGER;
105: TYPE trx_id IS TABLE OF fun_trx_headers.trx_id%TYPE INDEX BY BINARY_INTEGER;
106: TYPE trx_number IS TABLE OF fun_trx_headers.trx_number%TYPE INDEX BY BINARY_INTEGER;
107: TYPE batch_number IS TABLE OF fun_trx_batches.batch_number%TYPE INDEX BY BINARY_INTEGER;
108: TYPE batch_id IS TABLE OF fun_trx_batches.batch_id%TYPE INDEX BY BINARY_INTEGER; -- Bug 6797385.
109:
110:
111: l_status_tbl status;
112: l_party_type_flag_tbl party_type_flag;

Line 165: fun_trx_batches trxB,

161: trxH.trx_number trx_number,
162: trxB.batch_number batch_number,
163: trxB.batch_id batch_id
164: from
165: fun_trx_batches trxB,
166: fun_trx_headers trxH,
167: gl_periods periods,
168: gl_ledgers ledgers,
169: gl_period_statuses glps,

Line 211: from fun_trx_batches trxb, gl_ledgers ledgers,

207: select gt.BATCH_ID, gt.TRX_ID, P.PARTY_NAME,
208: GT.PARTY_ID, GT.LE_ID, gt.LEDGER_ID, gt.party_type_flag,
209: gt.p_request_id,
210: gt.STATUS, gt.description
211: from fun_trx_batches trxb, gl_ledgers ledgers,
212: HZ_PARTIES P,
213: (
214: SELECT TB.BATCH_ID , TH.INITIATOR_ID party_id, TH.TRX_ID, ''I''
215: party_type_flag, '''||p_request_id||''' p_request_id, tB.description Description,

Line 217: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB

213: (
214: SELECT TB.BATCH_ID , TH.INITIATOR_ID party_id, TH.TRX_ID, ''I''
215: party_type_flag, '''||p_request_id||''' p_request_id, tB.description Description,
216: TB.FROM_LE_ID LE_ID, TH.STATUS, tB.from_ledger_id LEDGER_ID
217: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB
218: WHERE TH.INVOICE_FLAG = ''N''
219: AND NOT EXISTS ( SELECT TRX_ID FROM
220: FUN_TRANSFERS FT WHERE FT.TRX_ID = TH.TRX_ID AND
221: FT.PARTY_TYPE_FLAG = ''I'')

Line 228: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB

224: UNION ALL
225: SELECT TB.BATCH_ID, TH.RECIPIENT_ID party_id, TH.TRX_ID, ''R''
226: party_type_flag, '''||p_request_id||''' p_request_id, tH.description Description,
227: TH.TO_LE_ID LE_ID, TH.STATUS, TH.TO_LEDGER_ID LEDGER_ID
228: FROM FUN_TRX_HEADERS TH, FUN_TRX_BATCHES TB
229: WHERE TH.INVOICE_FLAG = ''N''
230: AND NOT EXISTS ( SELECT TRX_ID FROM
231: FUN_TRANSFERS FT WHERE FT.TRX_ID = TH.TRX_ID AND
232: FT.PARTY_TYPE_FLAG = ''R'')

Line 371: FUN_TRX_BATCHES TRXB,

367: FROM
368: GL_LEDGERS LEDGERS,
369: GL_PERIOD_STATUSES GLPS,
370: GL_PERIODS PERIODS,
371: FUN_TRX_BATCHES TRXB,
372: FUN_TRX_LINES T,
373: FUN_DIST_LINES D,
374: fun_transfers gt
375: WHERE TRXB.BATCH_ID = GT.BATCH_ID

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

505: 'XFER_INI_GL', 'COMPLETE'))
506: WHERE trx_id = l_trx_id_tbl(l_index)
507: AND l_error_mesg_tbl(l_index) = 'FUN_API_TRX_TRANSFERRED';
508: END IF;
509: -- Bug 6797385. Update the status in fun_trx_batches starts here.
510: IF l_batch_id_tbl.COUNT > 0
511: THEN
512: FORALL l_index IN l_batch_id_tbl.FIRST .. l_batch_id_tbl.LAST
513: UPDATE fun_trx_batches b

Line 513: UPDATE fun_trx_batches b

509: -- Bug 6797385. Update the status in fun_trx_batches starts here.
510: IF l_batch_id_tbl.COUNT > 0
511: THEN
512: FORALL l_index IN l_batch_id_tbl.FIRST .. l_batch_id_tbl.LAST
513: UPDATE fun_trx_batches b
514: SET b.status = 'COMPLETE'
515: WHERE NOT EXISTS ( SELECT trx_id
516: FROM fun_trx_headers
517: WHERE fun_trx_headers.batch_id = b.batch_id

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

518: AND status NOT IN ('COMPLETE', 'REJECTED'))
519: AND b.batch_id = l_batch_id_tbl(l_index)
520: AND b.status <> 'COMPLETE';
521: END IF;
522: -- Bug 6797385. Update the status in fun_trx_batches Ends here.
523: IF l_trx_id_tbl.COUNT > 0 THEN
524: FOR l_index IN l_trx_id_tbl.FIRST .. l_trx_id_tbl.LAST
525: LOOP
526: IF (l_error_mesg_tbl(l_index) like 'GL_PERIOD_NOT_OPEN%') THEN

Line 545: UPDATE fun_trx_batches

541: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,' *****No Data Found*****');
542: END IF;
543:
544: /* Bug 6797385.
545: UPDATE fun_trx_batches
546: SET status = 'COMPLETE'
547: WHERE status <> 'COMPLETE'
548: AND NOT EXISTS ( SELECT trx_id
549: FROM fun_trx_headers

Line 550: WHERE fun_trx_headers.batch_id = fun_trx_batches.batch_id

546: SET status = 'COMPLETE'
547: WHERE status <> 'COMPLETE'
548: AND NOT EXISTS ( SELECT trx_id
549: FROM fun_trx_headers
550: WHERE fun_trx_headers.batch_id = fun_trx_batches.batch_id
551: AND status NOT IN ('COMPLETE', 'REJECTED'));
552: */
553: DELETE fun_transfers
554: WHERE REQUEST_ID = P_REQUEST_ID;