[Home] [Help]
720:
721: BEGIN
722:
723: --6870437
724: ARP_XLA_EVENTS.delete_reverse_revrec_event( p_document_id => p_customer_trx_id,
725: p_doc_table => 'CT');
726:
727: arp_ctlgd_pkg.delete_f_ct_id(p_customer_trx_id,
728: 'N',
825: l_trx_rec ra_customer_trx%rowtype;
826: l_status1 varchar2(100);
827: l_status2 varchar2(100);
828: --Bug# 2750340
829: l_ev_rec arp_xla_events.xla_events_type;
830:
831: /* bug 3609567 */
832: l_error_message VARCHAR2(128) := '';
833: l_dist_count NUMBER;
1028: l_ev_rec.xla_doc_event := NULL;
1029: l_ev_rec.xla_mode := 'O';
1030: l_ev_rec.xla_call := 'B';
1031: l_ev_rec.xla_fetch_size := 999;
1032: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1033:
1034: arp_util.debug('arp_process_header.insert_header()-');
1035:
1036: EXCEPTION
1121: l_status2 varchar2(100);
1122: l_status3 varchar2(100);
1123:
1124: --Bug# 2750340
1125: l_ev_rec arp_xla_events.xla_events_type;
1126:
1127: --BUG#5192414
1128: CURSOR cpost IS
1129: SELECT 'Y'
1701: END IF;
1702:
1703: --Bug# 2750340
1704: ---------------------------------------------------------
1705: -- Call to ARP_XLA_EVENTS for transaction updation in
1706: -- Trx Workbench. Mandatory when user complete a document
1707: ---------------------------------------------------------
1708: l_ev_rec.xla_from_doc_id := p_customer_trx_id;
1709: l_ev_rec.xla_to_doc_id := p_customer_trx_id;
1713: l_ev_rec.xla_doc_event := NULL;
1714: l_ev_rec.xla_mode := 'O';
1715: l_ev_rec.xla_call := 'B';
1716: l_ev_rec.xla_fetch_size := 999;
1717: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1718:
1719: END IF;
1720: CLOSE cpost;
1721:
1867: --Bug # 6450286
1868: --------------------------------
1869: -- Delete the corresponding event in XLA schema
1870: --------------------------------
1871: ARP_XLA_EVENTS.delete_event( p_document_id => p_customer_trx_id,
1872: p_doc_table => 'CT');
1873:
1874: --added for bug 7478499
1875: delete_cont_defer_data(p_customer_trx_id);