[Home] [Help]
227:
228: /*--------------------------------------------+
229: | Call MRC logic to create MRC rows |
230: | This needs to be done before accounting |
231: | since the MRC trigger on ar_distributions |
232: | table expects for the MRC row to exists |
233: +--------------------------------------------*/
234:
235: --{BUG#4301323
259:
260:
261: /*----------------------------------------------------------------------+
262: | call accounting engine if needed. Accounting engine creates the |
263: | accounting in ar_distributions table, it also calls auto accounting |
264: | and deferred tax if needed |
265: +----------------------------------------------------------------------*/
266:
267: IF NVL(p_trh_rec.postable_flag,'N') = 'Y' THEN
577: | PROCEDURE |
578: | delete_transaction_history |
579: | |
580: | DESCRIPTION |
581: | Deletes distribution rows from ar_distributions for given transaction |
582: | history record. |
583: | |
584: | SCOPE - PUBLIC |
585: | |
596: | |
597: | MODIFICATION HISTORY |
598: | 28-MAR-2000 Jani Rautiainen Created |
599: | 10-MAY-2000 Debbie Jancis Added call to delete from |
600: | ar_distributions after call to delete |
601: | using table handler since that will |
602: | not be modified to handle MRC ar |
603: | distributions deletes. Added call to |
604: | ar_mrc_engine for processing. |
611: +----------------------------------------*/
612: /* Start FP Bug 5741803 chng the defination to check for source table */
613: CURSOR distribution_cur IS
614: select dist.line_id
615: from ar_distributions dist
616: where source_id = p_transaction_history_id
617: and source_table = 'TH';
618: /* End FP Bug 5741803 SPDIXIT */
619: distribution_rec distribution_cur%ROWTYPE;