464: /* Checking for new transaction_date from closed period */
465: BEGIN
466: SELECT actual_transaction_date
467: INTO v_transaction_date
468: FROM fv_rcv_transactions
469: WHERE transaction_id = v_transaction_id_org;
470: EXCEPTION
471: WHEN NO_DATA_FOUND THEN
472: v_transaction_date := v_transaction_date_org;
568: /* Read new transaction date,if any defined on */
569: BEGIN
570: SELECT actual_transaction_date
571: INTO v_rec_transaction_date
572: FROM fv_rcv_transactions
573: WHERE transaction_id = v_parent_transaction_id;
574: EXCEPTION
575: WHEN NO_DATA_FOUND THEN
576: NULL;
646: /* Read new transaction date,if any defined on */
647: BEGIN
648: SELECT actual_transaction_date
649: INTO v_transaction_date
650: FROM fv_rcv_transactions
651: WHERE transaction_id = v_transaction_id;
652: EXCEPTION
653: WHEN NO_DATA_FOUND THEN
654: NULL;