APPS.ARI_SELF_REGISTRATION_PKG dependencies on ARI_REG_VERIFICATIONS_GT

Line 643: DELETE FROM ARI_REG_VERIFICATIONS_GT;

639: IF (PG_DEBUG = 'Y') THEN
640: arp_standard.debug(l_debug_info);
641: END IF;
642:
643: DELETE FROM ARI_REG_VERIFICATIONS_GT;
644:
645: COMMIT;
646:
647: ----------------------------------------------------------------------------------------

Line 785: l_expected_answer ari_reg_verifications_gt.expected_answer%type;

781: p_reg_access_verify_id IN NUMBER)
782: RETURN VARCHAR2
783: ---------------------------------------------------------------------------
784: IS
785: l_expected_answer ari_reg_verifications_gt.expected_answer%type;
786: l_return VARCHAR2(5);
787: BEGIN
788:
789: BEGIN

Line 792: from ari_reg_verifications_gt

788:
789: BEGIN
790: select expected_answer
791: into l_expected_answer
792: from ari_reg_verifications_gt
793: where reg_access_verify_id = p_reg_access_verify_id;
794: END;
795:
796: IF l_expected_answer = to_char(p_answer) THEN