APPS.FUN_GL_BATCH_TRANSFER dependencies on FUN_TRANSFERS

Line 170: fun_transfers gt';

166: fun_trx_headers trxH,
167: gl_periods periods,
168: gl_ledgers ledgers,
169: gl_period_statuses glps,
170: fun_transfers gt';
171:
172: l_cur_where := ' WHERE trxH.trx_id = gt.trx_id AND
173: trxB.batch_id = gt.batch_id AND
174: GT.request_id = '''||p_request_id||''' AND

Line 204: gt_insert_clause :='INSERT INTO fun_transfers(BATCH_ID, trx_id, org_name, org_id, le_id,

200: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
201:
202: /* Insert data into temp table */
203: begin
204: gt_insert_clause :='INSERT INTO fun_transfers(BATCH_ID, trx_id, org_name, org_id, le_id,
205: ledger_id, party_type_flag,
206: request_id, trx_status, description)
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,

Line 220: FUN_TRANSFERS FT WHERE FT.TRX_ID = TH.TRX_ID AND

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'')
222: AND TH.STATUS IN (''APPROVED'',''XFER_RECI_GL'')
223: AND TH.BATCH_ID = TB.BATCH_ID
224: UNION ALL

Line 231: FUN_TRANSFERS FT WHERE FT.TRX_ID = TH.TRX_ID AND

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'')
233: AND TH.STATUS IN (''APPROVED'',''XFER_INI_GL'')
234: AND TH.BATCH_ID = TB.BATCH_ID
235: )gt

Line 374: fun_transfers gt

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
376: AND GT.request_id = '''||p_request_id||'''
377: AND LEDGERS.LEDGER_ID = gt.LEDGER_ID
378: AND PERIODS.PERIOD_SET_NAME = LEDGERS.PERIOD_SET_NAME

Line 553: DELETE fun_transfers

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;
555: commit;
556:
557: EXCEPTION

Line 564: DELETE fun_transfers

560: -- Bug # 6842245
561: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');
562: rollback;
563:
564: DELETE fun_transfers
565: WHERE REQUEST_ID = P_REQUEST_ID;
566: commit;
567:
568: WHEN OTHERS THEN

Line 575: DELETE fun_transfers

571: -- Bug # 6842245
572: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');
573: rollback;
574:
575: DELETE fun_transfers
576: WHERE REQUEST_ID = P_REQUEST_ID;
577: commit;
578:
579: END GL_BATCH_TRANSFER;