75: AND inv_dist2.invoice_distribution_id = chrg.item_dist_id
76: AND inv.invoice_id = inv_dist1.invoice_id
77: AND inv.invoice_date BETWEEN start_date AND end_date
78: AND NOT EXISTS
79: ( SELECT 'Y' FROM IGI_RECOVERABLE_LINES WHERE tax_distribution_id = chrg.charge_dist_id);
80:
81: Procedure Writelog(
82: p_mesg IN varchar2
83: )
197: l_processed := true;
198: end if;
199:
200: --------------------------------------------------------------------
201: --insert into IGI_RECOVERABLE_LINES
202: --------------------------------------------------------------------
203:
204: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
205:
202: --------------------------------------------------------------------
203:
204: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
205:
206: insert into IGI_RECOVERABLE_LINES
207:
208: ( Invoice_id,
209: Accounting_date,
210: Invoice_date,
379:
380: -- End(2) bug 2119400 vgadde 23-NOV-2001
381:
382: End loop;
383: WriteLog( '>> IGI_RECOVERABLE_LINES records transferred to GL Interface');
384:
385: l_report_request_id := fnd_request.submit_request
386: ('IGI',
387: 'IGIPRECL',
441: -- update all the rows after inserting to gl_interface table
442: -- so that the lines are not consider when run next time
443: --------------------------------------------------------------------
444: if l_import_request_id = 0 then
445: update IGI_RECOVERABLE_LINES
446: set je_created_flag = 'Y'
447: where request_id =FND_GLOBAL.CONC_REQUEST_ID ;
448: WriteLog( '>> IGI_RECOVERABLE_LINES updated ');
449: end if;
444: if l_import_request_id = 0 then
445: update IGI_RECOVERABLE_LINES
446: set je_created_flag = 'Y'
447: where request_id =FND_GLOBAL.CONC_REQUEST_ID ;
448: WriteLog( '>> IGI_RECOVERABLE_LINES updated ');
449: end if;
450:
451: end;
452: