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

Line 208: FROM fun_trx_batches

204: ) IS
205: l_count NUMBER;
206: CURSOR batch_num_csr IS
207: SELECT COUNT(*)
208: FROM fun_trx_batches
209: WHERE initiator_id = p_initiator_id
210: AND batch_number = p_batch_number;
211: BEGIN
212: Debug('IS_BATCH_NUM_UNIQUE(+)');

Line 2362: FROM fun_trx_batches

2358: --Bug: 15962294. Validate period status for GL date.
2359:
2360: SELECT from_le_id, trx_type_id
2361: INTO l_from_le_id, l_trx_type_id
2362: FROM fun_trx_batches
2363: WHERE batch_id = p_batch_id;
2364:
2365: Is_Init_GL_Date_Valid(x_return_status => l_return_status,
2366: p_from_le_id => l_from_le_id,

Line 2385: FROM fun_trx_batches batches

2381: -- and the batch is not a reversed batch itself
2382: -- Verify the status of the batch
2383: --Bug: 6625360.
2384: /* SELECT count(initiator_id) INTO l_initiator_id
2385: FROM fun_trx_batches batches
2386: WHERE batch_id = p_batch_id
2387: AND original_batch_id IS NULL
2388: AND reversed_batch_id IS NULL
2389: AND status = 'COMPLETE'

Line 2397: FROM fun_trx_batches batches

2393: AND (hdrs.original_trx_id IS NOT NULL
2394: OR
2395: hdrs.reversed_trx_id IS NOT NULL));*/
2396: SELECT count(initiator_id) INTO l_initiator_id
2397: FROM fun_trx_batches batches
2398: WHERE batch_id = p_batch_id
2399: AND original_batch_id IS NULL
2400: AND reversed_batch_id IS NULL
2401: AND(

Line 2448: 'FUN_TRX_BATCHES',

2444: l_control_date_tbl(0) := l_control_date_rec;
2445: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
2446: 'LOCAL',
2447: 435,
2448: 'FUN_TRX_BATCHES',
2449: 'CREATION',
2450: null,
2451: l_control_date_tbl,
2452: 'N',

Line 2462: FROM fun_trx_batches

2458:
2459: -- Bug: 16198634. Added Select Stmt
2460: SELECT initiator_id
2461: INTO l_initiator_id
2462: FROM fun_trx_batches
2463: WHERE batch_id = p_batch_id;
2464:
2465: -- Check uniqueness of the batch_number provided
2466: Is_Batch_Num_Unique(l_return_status,l_reversed_batch_number,l_initiator_id);

Line 2478: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;

2474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2476: END IF;
2477: -- Get the next sequence for fun_batch_id
2478: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;
2479: -- Update original batch with reversed_batch_id
2480: UPDATE fun_trx_batches
2481: SET reversed_batch_id = l_reversed_batch_id
2482: WHERE batch_id = p_batch_id;

Line 2480: UPDATE fun_trx_batches

2476: END IF;
2477: -- Get the next sequence for fun_batch_id
2478: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;
2479: -- Update original batch with reversed_batch_id
2480: UPDATE fun_trx_batches
2481: SET reversed_batch_id = l_reversed_batch_id
2482: WHERE batch_id = p_batch_id;
2483: -- Insert into batch with orig_batch_id
2484: INSERT INTO fun_trx_batches(BATCH_ID,

Line 2484: INSERT INTO fun_trx_batches(BATCH_ID,

2480: UPDATE fun_trx_batches
2481: SET reversed_batch_id = l_reversed_batch_id
2482: WHERE batch_id = p_batch_id;
2483: -- Insert into batch with orig_batch_id
2484: INSERT INTO fun_trx_batches(BATCH_ID,
2485: BATCH_NUMBER,
2486: INITIATOR_ID,
2487: FROM_LE_ID,
2488: FROM_LEDGER_ID,

Line 2574: FROM fun_trx_batches

2570: fnd_global.user_id,
2571: sysdate,
2572: fnd_global.user_id,
2573: auto_proration_flag
2574: FROM fun_trx_batches
2575: WHERE batch_id = p_batch_id;
2576: -- Insert into transaction with status sent, ignore the rejected ones
2577: INSERT INTO fun_trx_headers(TRX_ID,
2578: TRX_NUMBER,

Line 2912: FROM fun_trx_batches txb, fun_trx_headers txh

2908:
2909: --Bug: 15962294. Validate period status for GL date.
2910: SELECT from_le_id, trx_type_id
2911: INTO l_from_le_id, l_trx_type_id
2912: FROM fun_trx_batches txb, fun_trx_headers txh
2913: WHERE txb.batch_id = txh.batch_id
2914: AND txh.trx_id = p_trx_tbl_id(1);
2915:
2916: Is_Init_GL_Date_Valid(x_return_status => l_return_status,

Line 2971: 'FUN_TRX_BATCHES',

2967: l_control_date_tbl(0) := l_control_date_rec;
2968: FUN_SEQ.GET_SEQUENCE_NUMBER('INTERCOMPANY_BATCH_SOURCE',
2969: 'LOCAL',
2970: 435,
2971: 'FUN_TRX_BATCHES',
2972: 'CREATION',
2973: null,
2974: l_control_date_tbl,
2975: 'N',

Line 2987: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;

2983: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2985: END IF;
2986: -- Get the next sequence for fun_batch_id
2987: SELECT fun_trx_batches_s.nextval INTO l_reversed_batch_id FROM dual;
2988:
2989: -- Loop the trx_id table to get sum of debits and credits for txns to be reversed
2990: FOR i IN 1..p_trx_tbl_id.COUNT LOOP
2991:

Line 3004: INSERT INTO fun_trx_batches(BATCH_ID,

3000: END LOOP;
3001: -- end of loop to get sum of debits and credits for txns to be reversed
3002:
3003: -- Insert into batch with orig_batch_id
3004: INSERT INTO fun_trx_batches(BATCH_ID,
3005: BATCH_NUMBER,
3006: INITIATOR_ID,
3007: FROM_LE_ID,
3008: FROM_LEDGER_ID,

Line 3094: FROM fun_trx_batches batches, fun_trx_headers headers

3090: fnd_global.user_id,
3091: sysdate,
3092: fnd_global.user_id,
3093: batches.auto_proration_flag
3094: FROM fun_trx_batches batches, fun_trx_headers headers
3095: WHERE batches.batch_id = headers.batch_id
3096: AND headers.trx_id = p_trx_tbl_id(1);
3097:
3098: -- Loop the trx_id table and insert reversed txns

Line 3211: UPDATE fun_trx_batches

3207:
3208: END LOOP;
3209: --End loop; which is looping trx_id table and inserting reversed txns
3210:
3211: UPDATE fun_trx_batches
3212: SET RUNNING_TOTAL_CR=(Select SUM(nvl(INIT_AMOUNT_CR,0))
3213: from fun_trx_headers
3214: where batch_id=l_reversed_batch_id
3215: ),

Line 3448: UPDATE fun_trx_batches

3444: IF (p_update_status_to = 'ERROR')
3445: THEN
3446: -- Update batch to ERROR if all
3447: -- transactions are at status ERROR
3448: UPDATE fun_trx_batches
3449: SET status = 'ERROR'
3450: WHERE batch_id = l_batch_id
3451: AND NOT EXISTS (SELECT 'X'
3452: FROM fun_trx_headers

Line 3460: UPDATE fun_trx_batches

3456: ELSIF (p_update_status_to IN ('COMPLETE', 'REJECTED'))
3457: THEN
3458: -- Update batch to COMPLETE if all
3459: -- transactions are at status COMPLETE or REJECTTED
3460: UPDATE fun_trx_batches
3461: SET status = 'COMPLETE'
3462: WHERE batch_id = l_batch_id
3463: AND NOT EXISTS (SELECT 'X'
3464: FROM fun_trx_headers

Line 4218: FROM fun_trx_batches

4214: batch_date,
4215: reject_allow_flag,
4216: from_recurring_batch_id,
4217: auto_proration_flag
4218: FROM fun_trx_batches
4219: WHERE batch_id = p_batch_id;
4220: l_trx_tbl TRX_TBL_TYPE;
4221: CURSOR l_trx_cursor IS SELECT trx_id,
4222: initiator_id,

Line 4696: FROM fun_trx_batches

4692:
4693: -- Retrieve initiator, transaction type
4694: SELECT initiator_id, trx_type_id, batch_date, from_ledger_id
4695: INTO l_initiator_id, l_trx_type_id, l_trx_date, l_from_ledger_id
4696: FROM fun_trx_batches
4697: WHERE batch_id = p_batch_id;
4698:
4699: SELECT recipient_id, to_le_id, init_amount_dr, init_amount_cr
4700: INTO l_recipient_id, l_to_le_id, l_init_amount_dr, l_init_amount_cr