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_HEADERS

Line 110: TYPE status IS TABLE OF fun_trx_headers.status%TYPE INDEX BY BINARY_INTEGER;

106: -- to trunc gl and batch date on all exising records.
107: TYPE c_transfer IS REF CURSOR;
108: c_transfer_obj c_transfer;
109:
110: TYPE status IS TABLE OF fun_trx_headers.status%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;

Line 113: TYPE trx_id IS TABLE OF fun_trx_headers.trx_id%TYPE INDEX BY BINARY_INTEGER;

109:
110: TYPE status IS TABLE OF fun_trx_headers.status%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:

Line 114: TYPE trx_number IS TABLE OF fun_trx_headers.trx_number%TYPE INDEX BY BINARY_INTEGER;

110: TYPE status IS TABLE OF fun_trx_headers.status%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:

Line 174: fun_trx_headers trxH,

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,
178: fun_transfers gt';

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 508: UPDATE fun_trx_headers

504:
505: IF l_trx_id_tbl.COUNT > 0
506: THEN
507: FORALL l_index IN l_trx_id_tbl.FIRST .. l_trx_id_tbl.LAST
508: UPDATE fun_trx_headers
509: SET status = DECODE (l_party_type_flag_tbl(l_index),
510: 'I',DECODE (status,
511: 'APPROVED','XFER_INI_GL',
512: 'XFER_RECI_GL', 'COMPLETE'),

Line 526: FROM fun_trx_headers

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
528: AND status NOT IN ('COMPLETE', 'REJECTED'))
529: AND b.batch_id = l_batch_id_tbl(l_index)
530: AND b.status <> 'COMPLETE';

Line 527: WHERE fun_trx_headers.batch_id = b.batch_id

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
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;

Line 559: FROM fun_trx_headers

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
560: WHERE fun_trx_headers.batch_id = fun_trx_batches.batch_id
561: AND status NOT IN ('COMPLETE', 'REJECTED'));
562: */
563: DELETE fun_transfers

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;