APPS.ARI_SELF_REGISTRATION_PKG dependencies on ARI_REG_VERIFICATIONS_GT

Line 644: DELETE FROM ARI_REG_VERIFICATIONS_GT;

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

Line 784: l_expected_answer ari_reg_verifications_gt.expected_answer%type;

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

Line 791: from ari_reg_verifications_gt

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