17: FUNCTION find_prev_accounted_id(p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) RETURN NUMBER;
18:
19: PROCEDURE insert_BR_ps(
20: p_trh_rec IN ar_transaction_history%ROWTYPE,
21: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE);
22:
23: PROCEDURE calculate_BR_amounts(
24: p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE,
25: p_amount OUT NOCOPY NUMBER,
65: l_ae_doc_rec ae_doc_rec_type;
66: l_old_trh_rec ar_transaction_history%ROWTYPE;
67: l_old_acctd_trh_rec ar_transaction_history%ROWTYPE;
68: l_prev_acctd_id ar_transaction_history.transaction_history_id%TYPE;
69: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
70: --Bug# 2750340
71: l_xla_ev_rec ARP_XLA_EVENTS.XLA_EVENTS_TYPE;
72:
73: /*Bug 7299779 -- vavenugo */
745: | |
746: +===========================================================================*/
747: PROCEDURE insert_BR_ps(
748: p_trh_rec IN ar_transaction_history%ROWTYPE,
749: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE) IS
750:
751: l_trx_rec ra_customer_trx%ROWTYPE;
752: l_ps_rec ar_payment_schedules%ROWTYPE;
753: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
748: p_trh_rec IN ar_transaction_history%ROWTYPE,
749: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE) IS
750:
751: l_trx_rec ra_customer_trx%ROWTYPE;
752: l_ps_rec ar_payment_schedules%ROWTYPE;
753: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
754:
755: BEGIN
756:
749: p_ps_id OUT NOCOPY ar_payment_schedules.payment_schedule_id%TYPE) IS
750:
751: l_trx_rec ra_customer_trx%ROWTYPE;
752: l_ps_rec ar_payment_schedules%ROWTYPE;
753: l_ps_id ar_payment_schedules.payment_schedule_id%TYPE;
754:
755: BEGIN
756:
757: IF PG_DEBUG in ('Y', 'C') THEN
1019: | MODIFICATION HISTORY |
1020: | 19-JUL-2000 Jani Rautiainen Created |
1021: | |
1022: +===========================================================================*/
1023: procedure create_trh_for_receipt_act(p_old_ps_rec IN ar_payment_schedules%ROWTYPE,
1024: p_app_rec IN ar_receivable_applications%ROWTYPE,
1025: p_called_from IN VARCHAR2) IS
1026:
1027: l_new_ps_rec ar_payment_schedules%ROWTYPE;
1023: procedure create_trh_for_receipt_act(p_old_ps_rec IN ar_payment_schedules%ROWTYPE,
1024: p_app_rec IN ar_receivable_applications%ROWTYPE,
1025: p_called_from IN VARCHAR2) IS
1026:
1027: l_new_ps_rec ar_payment_schedules%ROWTYPE;
1028: l_trh_rec ar_transaction_history%ROWTYPE;
1029: l_transaction_history_id ar_transaction_history.transaction_history_id%TYPE;
1030:
1031: BEGIN