[Home] [Help]
45: l_cr_rec ar_cash_receipts%ROWTYPE;
46: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
47: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
48: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
49: l_dist_rec ar_distributions%ROWTYPE;
50: l_radj_rec ar_rate_adjustments%ROWTYPE;
51: l_acctd_receipt_amt_new ar_cash_receipt_history.acctd_amount%TYPE;
52: l_acctd_receipt_amt_old ar_cash_receipt_history.acctd_amount%TYPE;
53: l_cash_amt ar_cash_receipt_history.amount%TYPE;
350: l_event_rec.xla_mode := 'O';
351: l_event_rec.xla_call := 'B';
352: arp_xla_events.Create_Events(p_xla_ev_rec => l_event_rec );
353:
354: -- Insert the cash account ar_distributions record
355: ------------------------------------------------------------------------------------
356: -- Removed the following 'if' as part of bug fix 868448
357: -- because we should be able to create zero dollar misc receipts and later clear them.
358: -- Because of this if, records are never created in ar_distributions and as a result
354: -- Insert the cash account ar_distributions record
355: ------------------------------------------------------------------------------------
356: -- Removed the following 'if' as part of bug fix 868448
357: -- because we should be able to create zero dollar misc receipts and later clear them.
358: -- Because of this if, records are never created in ar_distributions and as a result
359: -- gl_transfer does'nt pick up these records to post
360: -----------------------------------------------------------------------------------
361: --IF ( l_crh_rec_new.amount <>0 ) OR
362: -- ( l_crh_rec_new.acctd_amount <> 0 )
413: mrc engine */
414: /*
415: ar_mrc_engine2.maintain_mrc_data2(
416: p_event_mode => 'INSERT',
417: p_table_name => 'AR_DISTRIBUTIONS',
418: p_mode => 'SINGLE',
419: p_key_value => l_dist_rec.line_id,
420: p_row_info => l_dist_rec);
421: */
425: l_dist_rec.source_id_secondary := NULL;
426:
427: --END IF;
428:
429: -- insert the remittance account ar_distributions record
430:
431: /* Bug No. 3644849 JVARKEY */
432: -- For Remittance Row The exchange parameters must be as that of its history
433: IF ( l_crh_rec_old.status = 'REMITTED' )
481: mrc engine */
482: /*
483: ar_mrc_engine2.maintain_mrc_data2(
484: p_event_mode => 'INSERT',
485: p_table_name => 'AR_DISTRIBUTIONS',
486: p_mode => 'SINGLE',
487: p_key_value => l_dist_rec.line_id,
488: p_row_info => l_dist_rec);
489: */
497: l_dist_rec.currency_conversion_date := l_crh_rec_new.exchange_date;
498:
499: END IF;
500:
501: -- insert the short term debt account ar_distributions record
502: IF ( l_crh_rec_old.status = 'REMITTED' ) AND
503: ( l_crh_rec_old.factor_flag ='Y' ) -- AND
504: /* skoukunt: comment to Fix bug 1198295
505: (( l_crh_rec_old.amount <>0 ) OR
540: mrc engine */
541:
542: ar_mrc_engine2.maintain_mrc_data2(
543: p_event_mode => 'INSERT',
544: p_table_name => 'AR_DISTRIBUTIONS',
545: p_mode => 'SINGLE',
546: p_key_value => l_dist_rec.line_id,
547: p_row_info => l_dist_rec);
548:
547: p_row_info => l_dist_rec);
548:
549: END IF;
550:
551: -- insert the factor account ar_distributions record if it's
552: -- factor='Y' and there's a rate adj involved
553: IF ( l_crh_rec_old.factor_flag = 'Y' ) AND
554: ( l_crh_rec_old.exchange_rate <> l_crh_rec_new.exchange_rate ) AND
555: ( (l_acctd_receipt_amt_new - l_acctd_receipt_amt_old) <> 0 )
590: mrc engine */
591:
592: ar_mrc_engine2.maintain_mrc_data2(
593: p_event_mode => 'INSERT',
594: p_table_name => 'AR_DISTRIBUTIONS',
595: p_mode => 'SINGLE',
596: p_key_value => l_dist_rec.line_id,
597: p_row_info => l_dist_rec);
598:
597: p_row_info => l_dist_rec);
598:
599: END IF;
600:
601: -- insert the short term debt ar_distributions record if it's
602: -- factor='Y' and there's a rate adj involved and it's
603: -- prior history record is 'CLEARED'
604: IF ( l_crh_rec_old.factor_flag = 'Y' ) AND
605: ( l_crh_rec_old.status = 'CLEARED' ) AND
642: mrc engine */
643:
644: ar_mrc_engine2.maintain_mrc_data2(
645: p_event_mode => 'INSERT',
646: p_table_name => 'AR_DISTRIBUTIONS',
647: p_mode => 'SINGLE',
648: p_key_value => l_dist_rec.line_id,
649: p_row_info => l_dist_rec);
650:
649: p_row_info => l_dist_rec);
650:
651: END IF;
652:
653: -- insert the bank charge account ar_distributions record
654: IF ( l_crh_rec_new.factor_discount_amount <>0 ) OR
655: ( l_crh_rec_new.acctd_factor_discount_amount <> 0 )
656: THEN
657: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
700: mrc engine */
701:
702: ar_mrc_engine2.maintain_mrc_data2(
703: p_event_mode => 'INSERT',
704: p_table_name => 'AR_DISTRIBUTIONS',
705: p_mode => 'SINGLE',
706: p_key_value => l_dist_rec.line_id,
707: p_row_info => l_dist_rec);
708:
792: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
793: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
794: l_rma_rec ar_receipt_method_accounts%ROWTYPE;
795: l_radj_rec ar_rate_adjustments%ROWTYPE;
796: l_dist_rec ar_distributions%ROWTYPE;
797: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
798: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
799: l_new_crh_id_fr_radj ar_cash_receipt_history.cash_receipt_history_id%TYPE;
800:
954: ARP_XLA_EVENTS.create_events(p_xla_ev_rec => l_xla_ev_rec);
955:
956:
957:
958: -- Insert the remittance/short_term_debt account ar_distributions record
959: /* skoukunt: comment to Fix bug 1198295
960: IF ( l_receipt_amt <>0 ) OR
961: ( l_acctd_receipt_amt <> 0 )
962: THEN
1002: arp_distributions_pkg.insert_p( l_dist_rec,l_dist_rec.line_id );
1003:
1004: -- END IF;
1005:
1006: -- Insert the cash account ar_distributions record
1007: /* skoukunt: comment to Fix bug 1198295
1008: IF ( l_crh_rec_old.amount <>0 ) OR
1009: ( l_crh_rec_old.acctd_amount <> 0 )
1010: THEN
1042:
1043:
1044: -- END IF;
1045:
1046: -- Insert the bank charge account ar_distributions record
1047: IF ( l_crh_rec_old.factor_discount_amount <>0 ) OR
1048: ( l_crh_rec_old.acctd_factor_discount_amount <> 0 )
1049: THEN
1050: l_dist_rec.source_id := l_crh_rec_new.cash_receipt_history_id;
1169: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1170: --
1171: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1172: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1173: l_dist_rec ar_distributions%ROWTYPE;
1174: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1175: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1176: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1177: l_cr_rec ar_cash_receipts%ROWTYPE;
1262: l_risk_event_rec.xla_mode := 'O';
1263: l_risk_event_rec.xla_call := 'B';
1264: arp_xla_events.Create_Events(p_xla_ev_rec => l_risk_event_rec );
1265:
1266: -- Insert the short_term_debt account ar_distributions record
1267: /* skoukunt: comment to Fix bug 1198295
1268: IF ( l_receipt_amt <>0 ) OR
1269: ( l_acctd_receipt_amt <> 0 )
1270: THEN
1304: mrc engine */
1305:
1306: ar_mrc_engine2.maintain_mrc_data2(
1307: p_event_mode => 'INSERT',
1308: p_table_name => 'AR_DISTRIBUTIONS',
1309: p_mode => 'SINGLE',
1310: p_key_value => l_dist_rec.line_id,
1311: p_row_info => l_dist_rec);
1312:
1311: p_row_info => l_dist_rec);
1312:
1313: -- END IF;
1314:
1315: -- Insert the factor account ar_distributions record
1316: /* skoukunt: comment to Fix bug 1198295
1317: IF ( l_crh_rec_old.amount <>0 ) OR
1318: ( l_crh_rec_old.acctd_amount <> 0 )
1319: THEN
1353: mrc engine */
1354:
1355: ar_mrc_engine2.maintain_mrc_data2(
1356: p_event_mode => 'INSERT',
1357: p_table_name => 'AR_DISTRIBUTIONS',
1358: p_mode => 'SINGLE',
1359: p_key_value => l_dist_rec.line_id,
1360: p_row_info => l_dist_rec);
1361:
1385: p_crh_id OUT NOCOPY ar_cash_receipt_history.cash_receipt_history_id%TYPE ) IS
1386: --
1387: l_crh_rec_old ar_cash_receipt_history%ROWTYPE;
1388: l_crh_rec_new ar_cash_receipt_history%ROWTYPE;
1389: l_dist_rec ar_distributions%ROWTYPE;
1390: l_receipt_amt ar_cash_receipt_history.amount%TYPE;
1391: l_acctd_receipt_amt ar_cash_receipt_history.acctd_amount%TYPE;
1392: NULL_VAR ar_receipt_method_accounts%ROWTYPE;
1393: l_cr_rec ar_cash_receipts%ROWTYPE;
1470: l_crh_rec_old.reversal_posting_control_id := -3;
1471: l_crh_rec_old.reversal_created_from := substrb(p_module_name||'ARP_CASHBOOK.UNDO_RISK_ELIMINATE',1,30);
1472: arp_cr_history_pkg.update_p( l_crh_rec_old );
1473:
1474: -- Insert the short_term_debt account ar_distributions record
1475: /* skoukunt: comment to Fix bug 1198295
1476: IF ( l_receipt_amt <>0 ) OR
1477: ( l_acctd_receipt_amt <> 0 )
1478: THEN
1512: mrc engine */
1513:
1514: ar_mrc_engine2.maintain_mrc_data2(
1515: p_event_mode => 'INSERT',
1516: p_table_name => 'AR_DISTRIBUTIONS',
1517: p_mode => 'SINGLE',
1518: p_key_value => l_dist_rec.line_id,
1519: p_row_info => l_dist_rec);
1520:
1520:
1521:
1522: -- END IF;
1523:
1524: -- Insert the factor account ar_distributions record
1525: /* skoukunt: comment to Fix bug 1198295
1526: IF ( l_crh_rec_old.amount <>0 ) OR
1527: ( l_crh_rec_old.acctd_amount <> 0 )
1528: THEN
1562: mrc engine */
1563:
1564: ar_mrc_engine2.maintain_mrc_data2(
1565: p_event_mode => 'INSERT',
1566: p_table_name => 'AR_DISTRIBUTIONS',
1567: p_mode => 'SINGLE',
1568: p_key_value => l_dist_rec.line_id,
1569: p_row_info => l_dist_rec);
1570:
1660: p_row_id VARCHAR2(30);
1661: l_cr_id ar_cash_Receipts.cash_receipt_id%TYPE;
1662: l_dis_set_id ar_cash_receipts.distribution_set_id%TYPE;
1663: /* Bug fix 2300268 */
1664: l_tax_account_id ar_distributions.code_combination_id%TYPE;
1665: /* Bug fix 2742388 */
1666: l_crh_id ar_cash_receipt_history.cash_receipt_history_id%TYPE;
1667: BEGIN
1668: