[Home] [Help]
253: claim_cancel_api_error EXCEPTION;
254: claim_create_api_error EXCEPTION;
255:
256: --Bug#2750340
257: l_xla_ev_rec arp_xla_events.xla_events_type;
258:
259: --BUG#5022786
260: CURSOR c_trx(p_trx_id IN NUMBER) IS
261: SELECT upgrade_method
579: l_xla_ev_rec.xla_to_doc_id := old_crh.cash_receipt_id;
580: l_xla_ev_rec.xla_doc_table := 'CRH';
581: l_xla_ev_rec.xla_mode := 'O';
582: l_xla_ev_rec.xla_call := 'B';
583: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
584: END IF;
585:
586:
587: /*----------------------------------------------------------------*
948: l_xla_ev_rec.xla_to_doc_id := new_adj.cash_receipt_id;
949: l_xla_ev_rec.xla_doc_table := 'CRH';
950: l_xla_ev_rec.xla_mode := 'O';
951: l_xla_ev_rec.xla_call := 'B';
952: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
953: END IF;
954:
955:
956:
1009: l_xla_ev_rec.xla_to_doc_id := new_adj.cash_receipt_id;
1010: l_xla_ev_rec.xla_doc_table := 'MCD';
1011: l_xla_ev_rec.xla_mode := 'O';
1012: l_xla_ev_rec.xla_call := 'D';
1013: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1014:
1015:
1016: /* Bugfix 2753644 */
1017: BEGIN
1108: l_xla_ev_rec.xla_to_doc_id := new_adj.cash_receipt_id;
1109: l_xla_ev_rec.xla_doc_table := 'MCD';
1110: l_xla_ev_rec.xla_mode := 'O';
1111: l_xla_ev_rec.xla_call := 'D';
1112: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1113:
1114: END LOOP;
1115:
1116: --
1421: l_xla_ev_rec.xla_to_doc_id := temp_num;
1422: l_xla_ev_rec.xla_doc_table := 'APP';
1423: l_xla_ev_rec.xla_mode := 'O';
1424: l_xla_ev_rec.xla_call := 'B';
1425: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1426:
1427: --BUG#5022786
1428: IF old_rec_app.applied_customer_trx_id IS NOT NULL AND old_rec_app.status = 'APP' THEN
1429: OPEN c_trx(old_rec_app.applied_customer_trx_id);
1861: l_xla_ev_rec.xla_to_doc_id := temp_num;
1862: l_xla_ev_rec.xla_doc_table := 'APP';
1863: l_xla_ev_rec.xla_mode := 'O';
1864: l_xla_ev_rec.xla_call := 'B';
1865: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1866:
1867: /* Bug No. 3682777 JVARKEY
1868: Update the gl_date_closed of concerned invoice in the payment schedules if the status is closed and
1869: the current gl_date closed is less than gl_date of the reate adjustment */
1981: l_xla_ev_rec.xla_to_doc_id := temp_num;
1982: l_xla_ev_rec.xla_doc_table := 'APP';
1983: l_xla_ev_rec.xla_mode := 'O';
1984: l_xla_ev_rec.xla_call := 'B';
1985: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
1986:
1987:
1988: --{BUG#5022786 Call the creation of APP distribution in LLCA mode if required
1989: IF old_rec_app.status = 'APP' AND l_upgrade_methode IN ('R12','R12_11IMFAR') THEN
2282: l_xla_ev_rec.xla_to_doc_id := temp_num;
2283: l_xla_ev_rec.xla_doc_table := 'APP';
2284: l_xla_ev_rec.xla_mode := 'O';
2285: l_xla_ev_rec.xla_call := 'B';
2286: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
2287:
2288: --
2289: --Release 11.5 VAT changes, create the UNAPP record accounting.
2290: --
2366: l_xla_ev_rec.xla_to_doc_id := temp_num;
2367: l_xla_ev_rec.xla_doc_table := 'APP';
2368: l_xla_ev_rec.xla_mode := 'O';
2369: l_xla_ev_rec.xla_call := 'B';
2370: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
2371:
2372: --
2373: --Release 11.5 VAT changes, create the UNID record accounting.
2374: --