[Home] [Help]
1354: ins_ra_rec.applied_rec_app_id := old_rec_app.applied_rec_app_id;
1355: --BUG#5201086
1356: ins_ra_rec.cash_receipt_history_id := old_reverse_crh_id; --BUG#5201086
1357:
1358: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
1359:
1360: --Bug#2750340
1361: l_xla_ev_rec.xla_from_doc_id := temp_num;
1362: l_xla_ev_rec.xla_to_doc_id := temp_num;
1558: /*---------------------------------------------*
1559: | Update reversed record, setting DISPLAY and |
1560: | REVERSAL_GL_DATE |
1561: *---------------------------------------------*/
1562: arp_app_pkg.fetch_p( old_rec_app.receivable_application_id, upd_ra_rec );
1563:
1564: upd_ra_rec.display := 'N';
1565: upd_ra_rec.reversal_gl_date := GREATEST(old_rec_app.gl_date, new_adj.gl_date);
1566: upd_ra_rec.last_updated_by := new_adj.last_updated_by;
1566: upd_ra_rec.last_updated_by := new_adj.last_updated_by;
1567: upd_ra_rec.last_update_date := new_adj.last_update_date;
1568: upd_ra_rec.last_update_login := new_adj.last_update_login;
1569:
1570: arp_app_pkg.update_p(upd_ra_rec);
1571:
1572: -- keep a running total of the amount of UNID
1573: IF old_rec_app.status = 'UNID' THEN
1574: total_unid := total_unid + old_rec_app.amount_applied;
1782: ins_ra_rec.customer_reason := old_rec_app.customer_reason;
1783: ins_ra_rec.applied_rec_app_id := old_rec_app.applied_rec_app_id;
1784:
1785: temp_num := NULL; --bug6271951
1786: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
1787:
1788: --Bug2750340
1789: l_xla_ev_rec.xla_from_doc_id := temp_num;
1790: l_xla_ev_rec.xla_to_doc_id := temp_num;
1897: /*Bug3505753 */
1898: ins_ra_rec.link_to_customer_trx_id:=NULL;
1899:
1900: temp_num := NULL; --bug6271951
1901: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
1902:
1903: --Bug#2750340
1904: l_xla_ev_rec.xla_from_doc_id := temp_num;
1905: l_xla_ev_rec.xla_to_doc_id := temp_num;
2038: /* Bug 2821139 - if a netting application the opposing
2039: application on the netted receipt is reversed/reapplied */
2040: IF old_rec_app.receivables_trx_id = -16 THEN
2041:
2042: arp_app_pkg.fetch_p (old_rec_app.applied_rec_app_id
2043: , net_ra_rec);
2044:
2045:
2046:
2114: );
2115:
2116: -- Updating both new activity records with each others
2117: -- new rec app id
2118: arp_app_pkg.fetch_p(l_new_rec_app_id, net_ra_rec );
2119: net_ra_rec.applied_rec_app_id := l_new_net_rec_app_id;
2120: arp_app_pkg.update_p( net_ra_rec );
2121:
2122: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2116: -- Updating both new activity records with each others
2117: -- new rec app id
2118: arp_app_pkg.fetch_p(l_new_rec_app_id, net_ra_rec );
2119: net_ra_rec.applied_rec_app_id := l_new_net_rec_app_id;
2120: arp_app_pkg.update_p( net_ra_rec );
2121:
2122: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2123: net_ra_rec.applied_rec_app_id := l_new_rec_app_id;
2124: arp_app_pkg.update_p( net_ra_rec );
2118: arp_app_pkg.fetch_p(l_new_rec_app_id, net_ra_rec );
2119: net_ra_rec.applied_rec_app_id := l_new_net_rec_app_id;
2120: arp_app_pkg.update_p( net_ra_rec );
2121:
2122: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2123: net_ra_rec.applied_rec_app_id := l_new_rec_app_id;
2124: arp_app_pkg.update_p( net_ra_rec );
2125:
2126: END IF;
2120: arp_app_pkg.update_p( net_ra_rec );
2121:
2122: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2123: net_ra_rec.applied_rec_app_id := l_new_rec_app_id;
2124: arp_app_pkg.update_p( net_ra_rec );
2125:
2126: END IF;
2127:
2128: END IF; -- end if status
2193: ins_ra_rec.customer_reference := NULL;
2194: /*Bug3505753 */
2195: ins_ra_rec.link_to_customer_trx_id:=NULL;
2196:
2197: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
2198:
2199:
2200: --Bug#2750340
2201: l_xla_ev_rec.xla_from_doc_id := temp_num;
2277: /*Bug3505753 */
2278: ins_ra_rec.link_to_customer_trx_id:=NULL;
2279:
2280:
2281: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
2282:
2283:
2284: --Bug#2750340
2285: l_xla_ev_rec.xla_from_doc_id := temp_num;