DBA Data[Home] [Help]

APPS.IBY_UTILITY_PVT dependencies on IBY_TRXN_SUMMARIES_ALL

Line 759: FUNCTION validate_organization(p_org_id IN iby_trxn_summaries_all.org_id%TYPE,

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:

Line 760: p_org_type IN iby_trxn_summaries_all.org_type%TYPE)

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;

Line 791: p_payment_channel_code IN OUT NOCOPY iby_trxn_summaries_all.payment_channel_code%TYPE,

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';

Line 794: l_payment_channel_code iby_trxn_summaries_all.payment_channel_code%TYPE;

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: