755: ELSIF (RTRIM(LTRIM(p_string)) IS NULL) THEN RETURN TRUE;
756: ELSE RETURN FALSE; END IF;
757: END is_trivial;
758:
759: FUNCTION validate_organization(p_org_id IN iby_trxn_summaries_all.org_id%TYPE,
760: p_org_type IN iby_trxn_summaries_all.org_type%TYPE)
761: RETURN VARCHAR2
762: IS
763:
756: ELSE RETURN FALSE; END IF;
757: END is_trivial;
758:
759: FUNCTION validate_organization(p_org_id IN iby_trxn_summaries_all.org_id%TYPE,
760: p_org_type IN iby_trxn_summaries_all.org_type%TYPE)
761: RETURN VARCHAR2
762: IS
763:
764: l_org_id NUMBER;
787: END validate_organization;
788:
789:
790: PROCEDURE validate_pmt_channel_code(p_instrument_type IN iby_creditcard.instrument_type%TYPE,
791: p_payment_channel_code IN OUT NOCOPY iby_trxn_summaries_all.payment_channel_code%TYPE,
792: p_valid OUT NOCOPY VARCHAR2)
793: IS
794: l_payment_channel_code iby_trxn_summaries_all.payment_channel_code%TYPE;
795: l_return_value VARCHAR2(1) := 'N';
790: PROCEDURE validate_pmt_channel_code(p_instrument_type IN iby_creditcard.instrument_type%TYPE,
791: p_payment_channel_code IN OUT NOCOPY iby_trxn_summaries_all.payment_channel_code%TYPE,
792: p_valid OUT NOCOPY VARCHAR2)
793: IS
794: l_payment_channel_code iby_trxn_summaries_all.payment_channel_code%TYPE;
795: l_return_value VARCHAR2(1) := 'N';
796:
797: BEGIN
798: