[Home] [Help]
548: | Validates that the latest receipt for the BR has been cleared |
549: | |
550: +==============================================================================*/
551:
552: FUNCTION Is_Receipt_Cleared (p_customer_trx_id IN ra_customer_trx.customer_trx_id%TYPE) RETURN BOOLEAN
553: IS
554:
555: l_cr_id ar_receivable_applications.cash_receipt_id%TYPE;
556: l_crh_rec ar_cash_receipt_history%ROWTYPE;
613: FUNCTION Is_BR_Paid_In_One_Time (p_trh_rec IN ar_transaction_history%ROWTYPE ,
614: p_ps_rec IN ar_payment_schedules%ROWTYPE ) RETURN BOOLEAN
615: IS
616:
617: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
618: l_ra_id AR_RECEIVABLE_APPLICATIONS.receivable_application_id%TYPE;
619: l_ra_rec AR_RECEIVABLE_APPLICATIONS%ROWTYPE;
620: l_prev_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;
621:
840: | This function determines if the BR requires acceptance or not |
841: | |
842: +===========================================================================*/
843:
844: FUNCTION Is_Acceptance_Required (p_cust_trx_type_id IN ra_customer_trx.cust_trx_type_id%TYPE) RETURN BOOLEAN
845: IS
846:
847: l_signed_flag VARCHAR2(1);
848: l_drawee_issued_flag VARCHAR2(1);
920: END IF;
921:
922: SELECT count(*)
923: INTO l_count
924: FROM RA_CUSTOMER_TRX_LINES
925: WHERE customer_trx_id = p_customer_trx_id;
926:
927: IF (l_count > 0)
928: THEN
982: IS
983:
984: l_trh_rec AR_TRANSACTION_HISTORY%ROWTYPE;
985: l_ps_rec AR_PAYMENT_SCHEDULES%ROWTYPE;
986: l_trx_rec RA_CUSTOMER_TRX%ROWTYPE;
987: l_ps_id NUMBER;
988:
989: BEGIN
990:
1268: | |
1269: +==============================================================================*/
1270:
1271:
1272: PROCEDURE New_Status_Event ( p_trx_rec IN ra_customer_trx%ROWTYPE ,
1273: p_action IN VARCHAR2 ,
1274: p_new_status OUT NOCOPY VARCHAR2 ,
1275: p_new_event OUT NOCOPY VARCHAR2 )
1276: IS