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 102: TYPE status IS TABLE OF fun_trx_headers.status%TYPE INDEX BY BINARY_INTEGER;

98: -- to trunc gl and batch date on all exising records.
99: TYPE c_transfer IS REF CURSOR;
100: c_transfer_obj c_transfer;
101:
102: TYPE status IS TABLE OF fun_trx_headers.status%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;

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

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

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

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

Line 166: fun_trx_headers trxH,

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

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

494:
495: IF l_trx_id_tbl.COUNT > 0
496: THEN
497: FORALL l_index IN l_trx_id_tbl.FIRST .. l_trx_id_tbl.LAST
498: UPDATE fun_trx_headers
499: SET status = DECODE (l_party_type_flag_tbl(l_index),
500: 'I',DECODE (status,
501: 'APPROVED','XFER_INI_GL',
502: 'XFER_RECI_GL', 'COMPLETE'),

Line 516: FROM fun_trx_headers

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

Line 517: WHERE fun_trx_headers.batch_id = b.batch_id

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

Line 549: FROM fun_trx_headers

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
550: WHERE fun_trx_headers.batch_id = fun_trx_batches.batch_id
551: AND status NOT IN ('COMPLETE', 'REJECTED'));
552: */
553: DELETE fun_transfers

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;