47: +===========================================================================*/
48:
49:
50: Procedure insert_ps_rec_cash(
51: p_cr_rec IN ar_cash_receipts%ROWTYPE,
52: p_gl_date IN DATE,
53: p_maturity_date IN DATE,
54: p_acctd_amount IN
55: ar_payment_schedules.acctd_amount_due_remaining%TYPE,
143: | |
144: +===========================================================================*/
145:
146: PROCEDURE insert_crh_rec(
147: p_cr_rec IN ar_cash_receipts%ROWTYPE,
148: p_crh_amount IN ar_cash_receipt_history.amount%TYPE,
149: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
150: p_factor_discount_amount IN
151: ar_cash_receipt_history.factor_discount_amount%TYPE,
293: | |
294: +===========================================================================*/
295:
296: PROCEDURE insert_ra_rec_cash(
297: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
298: p_amount IN ar_cash_receipts.amount%TYPE,
299: p_apply_date IN DATE,
300: p_status IN ar_cash_receipts.status%TYPE,
301: p_acctd_amount IN
294: +===========================================================================*/
295:
296: PROCEDURE insert_ra_rec_cash(
297: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
298: p_amount IN ar_cash_receipts.amount%TYPE,
299: p_apply_date IN DATE,
300: p_status IN ar_cash_receipts.status%TYPE,
301: p_acctd_amount IN
302: ar_receivable_applications.acctd_amount_applied_from%TYPE,
296: PROCEDURE insert_ra_rec_cash(
297: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
298: p_amount IN ar_cash_receipts.amount%TYPE,
299: p_apply_date IN DATE,
300: p_status IN ar_cash_receipts.status%TYPE,
301: p_acctd_amount IN
302: ar_receivable_applications.acctd_amount_applied_from%TYPE,
303: p_gl_date IN DATE,
304: p_ccid IN
431: | |
432: +===========================================================================*/
433:
434: PROCEDURE insert_dist_rec(
435: p_amount IN ar_cash_receipts.amount%TYPE,
436: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
437: p_crh_id IN
438: ar_cash_receipt_history.cash_receipt_history_id%TYPE,
439: p_source_type IN ar_distributions.source_type%TYPE,
444: l_dist_rec ar_distributions%ROWTYPE;
445: l_source_type ar_distributions.source_type%TYPE;
446: l_ccid ar_distributions.code_combination_id%TYPE;
447: l_dummy ar_distributions.line_id%TYPE;
448: l_cr_rec ar_cash_receipts%ROWTYPE;
449: l_crh_rec ar_cash_receipt_history%ROWTYPE;
450: --bug#2750340
451: l_xla_ev_rec arp_xla_events.xla_events_type;
452:
556: | |
557: +===========================================================================*/
558:
559: PROCEDURE round_mcd_recs(
560: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE
561: ) IS
562:
563: l_rounding_diff NUMBER;
564: l_misc_cash_key_value_list gl_ca_utility_pkg.r_key_value_arr; /* MRC */
667: +===========================================================================*/
668:
669:
670: PROCEDURE insert_misc_dist(
671: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
672: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
673: p_amount IN ar_cash_receipts.amount%TYPE,
674: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
675: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
669:
670: PROCEDURE insert_misc_dist(
671: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
672: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
673: p_amount IN ar_cash_receipts.amount%TYPE,
674: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
675: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
676: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
677: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
670: PROCEDURE insert_misc_dist(
671: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
672: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
673: p_amount IN ar_cash_receipts.amount%TYPE,
674: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
675: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
676: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
677: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
678: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
671: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
672: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
673: p_amount IN ar_cash_receipts.amount%TYPE,
674: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
675: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
676: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
677: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
678: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
679: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
673: p_amount IN ar_cash_receipts.amount%TYPE,
674: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
675: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
676: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
677: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
678: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
679: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
680: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
681: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
674: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
675: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
676: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
677: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
678: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
679: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
680: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
681: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
682: ) IS
675: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
676: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
677: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
678: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
679: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
680: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
681: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
682: ) IS
683:
676: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
677: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
678: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
679: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE default NULL,
680: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE default NULL,
681: p_created_from IN ar_misc_cash_distributions.created_from%TYPE default 'ARRERCT'
682: ) IS
683:
684: l_trx_code_combination_id ar_receivables_trx.code_combination_id%TYPE;
915: | |
916: +===========================================================================*/
917:
918: PROCEDURE update_misc_dist(
919: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
920: p_amount IN ar_cash_receipts.amount%TYPE,
921: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
922: p_amount_changed_flag IN BOOLEAN,
923: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
916: +===========================================================================*/
917:
918: PROCEDURE update_misc_dist(
919: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
920: p_amount IN ar_cash_receipts.amount%TYPE,
921: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
922: p_amount_changed_flag IN BOOLEAN,
923: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
924: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
919: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
920: p_amount IN ar_cash_receipts.amount%TYPE,
921: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
922: p_amount_changed_flag IN BOOLEAN,
923: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
924: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
925: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
926: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
927: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
920: p_amount IN ar_cash_receipts.amount%TYPE,
921: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
922: p_amount_changed_flag IN BOOLEAN,
923: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
924: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
925: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
926: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
927: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
928: p_gl_date_changed_flag IN BOOLEAN,
921: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
922: p_amount_changed_flag IN BOOLEAN,
923: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
924: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
925: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
926: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
927: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
928: p_gl_date_changed_flag IN BOOLEAN,
929: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
922: p_amount_changed_flag IN BOOLEAN,
923: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
924: p_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
925: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
926: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
927: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
928: p_gl_date_changed_flag IN BOOLEAN,
929: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
930: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
925: p_old_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
926: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
927: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
928: p_gl_date_changed_flag IN BOOLEAN,
929: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
930: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
931: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
932: p_receipt_date_changed_flag IN BOOLEAN,
933: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
926: p_old_receivables_trx_id IN ar_cash_receipts.receivables_trx_id%TYPE,
927: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
928: p_gl_date_changed_flag IN BOOLEAN,
929: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
930: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
931: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
932: p_receipt_date_changed_flag IN BOOLEAN,
933: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
934: ) IS
927: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
928: p_gl_date_changed_flag IN BOOLEAN,
929: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
930: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
931: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
932: p_receipt_date_changed_flag IN BOOLEAN,
933: p_gl_tax_acct IN ar_distributions.code_combination_id%TYPE
934: ) IS
935:
1527: +===========================================================================*/
1528:
1529:
1530: PROCEDURE create_mcd_recs(
1531: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1532: p_amount IN ar_cash_receipts.amount%TYPE,
1533: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1534: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1535: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1528:
1529:
1530: PROCEDURE create_mcd_recs(
1531: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1532: p_amount IN ar_cash_receipts.amount%TYPE,
1533: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1534: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1535: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1536: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1530: PROCEDURE create_mcd_recs(
1531: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1532: p_amount IN ar_cash_receipts.amount%TYPE,
1533: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1534: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1535: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1536: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1537: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1538: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
1531: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1532: p_amount IN ar_cash_receipts.amount%TYPE,
1533: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1534: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1535: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1536: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1537: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1538: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
1539: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1533: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1534: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1535: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1536: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1537: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1538: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
1539: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1540: ) IS
1541:
1534: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1535: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1536: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1537: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1538: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
1539: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1540: ) IS
1541:
1542: l_min_unit NUMBER;
1535: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1536: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1537: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE,
1538: p_distribution_set_id IN ar_cash_receipts.distribution_set_id%TYPE,
1539: p_ussgl_trx_code IN ar_cash_receipts.ussgl_transaction_code%TYPE
1540: ) IS
1541:
1542: l_min_unit NUMBER;
1543: l_precision NUMBER;
1809: | |
1810: +===========================================================================*/
1811:
1812: PROCEDURE update_manual_dist(
1813: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1814: p_amount IN ar_cash_receipts.amount%TYPE,
1815: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1816: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1817: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1810: +===========================================================================*/
1811:
1812: PROCEDURE update_manual_dist(
1813: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1814: p_amount IN ar_cash_receipts.amount%TYPE,
1815: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1816: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1817: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1818: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1812: PROCEDURE update_manual_dist(
1813: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1814: p_amount IN ar_cash_receipts.amount%TYPE,
1815: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1816: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1817: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1818: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1819: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
1820: ) IS
1813: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1814: p_amount IN ar_cash_receipts.amount%TYPE,
1815: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1816: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1817: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1818: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1819: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
1820: ) IS
1821:
1815: p_acctd_amount IN ar_cash_receipt_history.acctd_amount%TYPE,
1816: p_exchange_rate IN ar_cash_receipts.exchange_rate%TYPE,
1817: p_currency_code IN ar_cash_receipts.currency_code%TYPE,
1818: p_gl_date IN ar_cash_receipt_history.gl_date%TYPE,
1819: p_receipt_date IN ar_cash_receipts.receipt_date%TYPE
1820: ) IS
1821:
1822: l_min_unit NUMBER;
1823: l_precision NUMBER;
1990: | |
1991: +===========================================================================*/
1992:
1993: PROCEDURE rate_adjust(
1994: p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
1995: p_rate_adjust_gl_date IN DATE,
1996: p_new_exchange_date IN DATE,
1997: p_new_exchange_rate IN ar_rate_adjustments.new_exchange_rate%TYPE,
1998: p_new_exchange_rate_type IN ar_rate_adjustments.new_exchange_rate_type%TYPE,