APPS.FUN_GL_BATCH_TRANSFER dependencies on FUN_TRANSFERS

Line 178: fun_transfers gt';

174: fun_trx_headers trxH,
175: gl_periods periods,
176: gl_ledgers ledgers,
177: gl_period_statuses glps,
178: fun_transfers gt';
179:
180: l_cur_where := ' WHERE trxH.trx_id = gt.trx_id AND
181: trxB.batch_id = gt.batch_id AND
182: GT.request_id = '''||p_request_id||''' AND

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

208: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'------------ ------------------ ----------------');
209:
210: /* Insert data into temp table */
211: begin
212: gt_insert_clause :='INSERT INTO fun_transfers(BATCH_ID, trx_id, org_name, org_id, le_id,
213: ledger_id, party_type_flag,
214: request_id, trx_status, description)
215: select gt.BATCH_ID, gt.TRX_ID, P.PARTY_NAME,
216: GT.PARTY_ID, GT.LE_ID, gt.LEDGER_ID, gt.party_type_flag,

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

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

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

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

Line 384: fun_transfers gt

380: GL_PERIODS PERIODS,
381: FUN_TRX_BATCHES TRXB,
382: FUN_TRX_LINES T,
383: FUN_DIST_LINES D,
384: fun_transfers gt
385: WHERE TRXB.BATCH_ID = GT.BATCH_ID
386: AND GT.request_id = '''||p_request_id||'''
387: AND LEDGERS.LEDGER_ID = gt.LEDGER_ID
388: AND PERIODS.PERIOD_SET_NAME = LEDGERS.PERIOD_SET_NAME

Line 563: DELETE fun_transfers

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;
565: commit;
566:
567: EXCEPTION

Line 574: DELETE fun_transfers

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

Line 585: DELETE fun_transfers

581: -- Bug # 6842245
582: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rolling Back All The Transactions');
583: rollback;
584:
585: DELETE fun_transfers
586: WHERE REQUEST_ID = P_REQUEST_ID;
587: commit;
588:
589: END GL_BATCH_TRANSFER;