54: l_accounting_method ar_system_parameters.accounting_method%TYPE;
55: l_create_acct VARCHAR2(1) := 'Y';
56:
57: --Bug#2750340
58: l_xla_ev_rec arp_xla_events.xla_events_type;
59: l_xla_doc_table VARCHAR2(20);
60:
61: BEGIN
62:
251:
252: IF p_ae_doc_rec.source_table = 'MCD' AND p_ae_doc_rec.document_type = 'RECEIPT' THEN
253: l_xla_ev_rec.xla_doc_table := 'MCD';
254: l_xla_ev_rec.xla_call := 'D';
255: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
256: ELSIF p_ae_doc_rec.source_table = 'RA' AND p_ae_doc_rec.document_type = 'RECEIPT' THEN
257: l_xla_ev_rec.xla_doc_table := 'APP';
258: l_xla_ev_rec.xla_from_doc_id := p_ae_doc_rec.source_id;
259: l_xla_ev_rec.xla_to_doc_id := p_ae_doc_rec.source_id;
256: ELSIF p_ae_doc_rec.source_table = 'RA' AND p_ae_doc_rec.document_type = 'RECEIPT' THEN
257: l_xla_ev_rec.xla_doc_table := 'APP';
258: l_xla_ev_rec.xla_from_doc_id := p_ae_doc_rec.source_id;
259: l_xla_ev_rec.xla_to_doc_id := p_ae_doc_rec.source_id;
260: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
261: ELSIF p_ae_doc_rec.source_table = 'RA' AND p_ae_doc_rec.document_type = 'CREDIT_MEMO' THEN
262: l_xla_ev_rec.xla_doc_table := 'CMAPP';
263: l_xla_ev_rec.xla_from_doc_id := p_ae_doc_rec.source_id;
264: l_xla_ev_rec.xla_to_doc_id := p_ae_doc_rec.source_id;
261: ELSIF p_ae_doc_rec.source_table = 'RA' AND p_ae_doc_rec.document_type = 'CREDIT_MEMO' THEN
262: l_xla_ev_rec.xla_doc_table := 'CMAPP';
263: l_xla_ev_rec.xla_from_doc_id := p_ae_doc_rec.source_id;
264: l_xla_ev_rec.xla_to_doc_id := p_ae_doc_rec.source_id;
265: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
266: ELSIF p_ae_doc_rec.source_table = 'ADJ' AND p_ae_doc_rec.document_type = 'ADJUSTMENT' THEN
267: l_xla_ev_rec.xla_doc_table := 'ADJ';
268: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
269: ELSIF p_ae_doc_rec.source_table = 'ADJ' AND p_ae_doc_rec.document_type = 'FINANCE_CHARGES' THEN
264: l_xla_ev_rec.xla_to_doc_id := p_ae_doc_rec.source_id;
265: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
266: ELSIF p_ae_doc_rec.source_table = 'ADJ' AND p_ae_doc_rec.document_type = 'ADJUSTMENT' THEN
267: l_xla_ev_rec.xla_doc_table := 'ADJ';
268: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
269: ELSIF p_ae_doc_rec.source_table = 'ADJ' AND p_ae_doc_rec.document_type = 'FINANCE_CHARGES' THEN
270: l_xla_ev_rec.xla_doc_table := 'ADJ';
271: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
272: ELSIF p_ae_doc_rec.source_table = 'TH' AND p_ae_doc_rec.document_type = 'BILLS_RECEIVABLE' THEN
267: l_xla_ev_rec.xla_doc_table := 'ADJ';
268: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
269: ELSIF p_ae_doc_rec.source_table = 'ADJ' AND p_ae_doc_rec.document_type = 'FINANCE_CHARGES' THEN
270: l_xla_ev_rec.xla_doc_table := 'ADJ';
271: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
272: ELSIF p_ae_doc_rec.source_table = 'TH' AND p_ae_doc_rec.document_type = 'BILLS_RECEIVABLE' THEN
273: l_xla_ev_rec.xla_doc_table := 'TRH';
274: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
275: END IF;
270: l_xla_ev_rec.xla_doc_table := 'ADJ';
271: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
272: ELSIF p_ae_doc_rec.source_table = 'TH' AND p_ae_doc_rec.document_type = 'BILLS_RECEIVABLE' THEN
273: l_xla_ev_rec.xla_doc_table := 'TRH';
274: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
275: END IF;
276:
277: END IF;
278: --}
543: WHERE request_id = p_request_id;
544:
545: old_rec_app_id ar_receivable_applications.receivable_application_id%TYPE;
546: --Bug#2750340
547: l_xla_ev_rec arp_xla_events.xla_events_type;
548: l_xla_doc_table VARCHAR2(20);
549:
550: adj_exist boolean := FALSE;
551: cm_exist boolean := FALSE;
609: l_xla_ev_rec.xla_mode := 'B';
610: l_xla_ev_rec.xla_call := 'B';
611:
612: l_xla_ev_rec.xla_doc_table := 'CR';
613: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
614:
615: l_xla_ev_rec.xla_doc_table := 'APP';
616: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
617: -- }
612: l_xla_ev_rec.xla_doc_table := 'CR';
613: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
614:
615: l_xla_ev_rec.xla_doc_table := 'APP';
616: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
617: -- }
618: */
619: ELSE
620:
661: --
662: IF adj_exist
663: THEN
664: l_xla_ev_rec.xla_doc_table := 'ADJ';
665: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
666: END IF;
667:
668: IF cm_exist
669: THEN
667:
668: IF cm_exist
669: THEN
670: l_xla_ev_rec.xla_doc_table := 'CMAPP';
671: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
672: END IF;
673: --
674: */
675: END IF;