[Home] [Help]
1413: ins_ra_rec.applied_rec_app_id := old_rec_app.applied_rec_app_id;
1414: --BUG#5201086
1415: ins_ra_rec.cash_receipt_history_id := old_reverse_crh_id; --BUG#5201086
1416:
1417: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
1418:
1419: --Bug#2750340
1420: l_xla_ev_rec.xla_from_doc_id := temp_num;
1421: l_xla_ev_rec.xla_to_doc_id := temp_num;
1617: /*---------------------------------------------*
1618: | Update reversed record, setting DISPLAY and |
1619: | REVERSAL_GL_DATE |
1620: *---------------------------------------------*/
1621: arp_app_pkg.fetch_p( old_rec_app.receivable_application_id, upd_ra_rec );
1622:
1623: upd_ra_rec.display := 'N';
1624: upd_ra_rec.reversal_gl_date := GREATEST(old_rec_app.gl_date, new_adj.gl_date);
1625: upd_ra_rec.last_updated_by := new_adj.last_updated_by;
1625: upd_ra_rec.last_updated_by := new_adj.last_updated_by;
1626: upd_ra_rec.last_update_date := new_adj.last_update_date;
1627: upd_ra_rec.last_update_login := new_adj.last_update_login;
1628:
1629: arp_app_pkg.update_p(upd_ra_rec);
1630:
1631: -- keep a running total of the amount of UNID
1632: IF old_rec_app.status = 'UNID' THEN
1633: total_unid := total_unid + old_rec_app.amount_applied;
1853: ins_ra_rec.customer_reason := old_rec_app.customer_reason;
1854: ins_ra_rec.applied_rec_app_id := old_rec_app.applied_rec_app_id;
1855:
1856: temp_num := NULL; --bug6271951
1857: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
1858:
1859: --Bug2750340
1860: l_xla_ev_rec.xla_from_doc_id := temp_num;
1861: l_xla_ev_rec.xla_to_doc_id := temp_num;
1973: /*Bug3505753 */
1974: ins_ra_rec.link_to_customer_trx_id:=NULL;
1975:
1976: temp_num := NULL; --bug6271951
1977: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
1978:
1979: --Bug#2750340
1980: l_xla_ev_rec.xla_from_doc_id := temp_num;
1981: l_xla_ev_rec.xla_to_doc_id := temp_num;
2114: /* Bug 2821139 - if a netting application the opposing
2115: application on the netted receipt is reversed/reapplied */
2116: IF old_rec_app.receivables_trx_id = -16 THEN
2117:
2118: arp_app_pkg.fetch_p (old_rec_app.applied_rec_app_id
2119: , net_ra_rec);
2120:
2121:
2122:
2190: );
2191:
2192: -- Updating both new activity records with each others
2193: -- new rec app id
2194: arp_app_pkg.fetch_p(l_new_rec_app_id, net_ra_rec );
2195: net_ra_rec.applied_rec_app_id := l_new_net_rec_app_id;
2196: arp_app_pkg.update_p( net_ra_rec );
2197:
2198: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2192: -- Updating both new activity records with each others
2193: -- new rec app id
2194: arp_app_pkg.fetch_p(l_new_rec_app_id, net_ra_rec );
2195: net_ra_rec.applied_rec_app_id := l_new_net_rec_app_id;
2196: arp_app_pkg.update_p( net_ra_rec );
2197:
2198: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2199: net_ra_rec.applied_rec_app_id := l_new_rec_app_id;
2200: arp_app_pkg.update_p( net_ra_rec );
2194: arp_app_pkg.fetch_p(l_new_rec_app_id, net_ra_rec );
2195: net_ra_rec.applied_rec_app_id := l_new_net_rec_app_id;
2196: arp_app_pkg.update_p( net_ra_rec );
2197:
2198: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2199: net_ra_rec.applied_rec_app_id := l_new_rec_app_id;
2200: arp_app_pkg.update_p( net_ra_rec );
2201:
2202: END IF;
2196: arp_app_pkg.update_p( net_ra_rec );
2197:
2198: arp_app_pkg.fetch_p (l_new_net_rec_app_id, net_ra_rec);
2199: net_ra_rec.applied_rec_app_id := l_new_rec_app_id;
2200: arp_app_pkg.update_p( net_ra_rec );
2201:
2202: END IF;
2203:
2204: END IF; -- end if status
2273: ins_ra_rec.customer_reference := NULL;
2274: /*Bug3505753 */
2275: ins_ra_rec.link_to_customer_trx_id:=NULL;
2276:
2277: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
2278:
2279:
2280: --Bug#2750340
2281: l_xla_ev_rec.xla_from_doc_id := temp_num;
2357: /*Bug3505753 */
2358: ins_ra_rec.link_to_customer_trx_id:=NULL;
2359:
2360:
2361: arp_app_pkg.insert_p( ins_ra_rec, temp_num );
2362:
2363:
2364: --Bug#2750340
2365: l_xla_ev_rec.xla_from_doc_id := temp_num;