[Home] [Help]
1: PACKAGE BODY hr_be_validation AS
2: /* $Header: hrbevali.pkb 120.0.12010000.2 2009/12/01 09:34:43 bkeshary ship $ */
3: --
4: --
5: -- This function validates that the bank account no is valid (see comments
9: -- where it is used to drive some cross validation rules.
10: --
11: -- This function returns either:
12: --
13: -- Bank account no is OK - hr_be_validation.success
14: -- Bank account no is invalid - hr_be_validation.failure
15: --
16: FUNCTION bank_account_no
17: (p_bank_acc_no VARCHAR2) RETURN VARCHAR2 AS
10: --
11: -- This function returns either:
12: --
13: -- Bank account no is OK - hr_be_validation.success
14: -- Bank account no is invalid - hr_be_validation.failure
15: --
16: FUNCTION bank_account_no
17: (p_bank_acc_no VARCHAR2) RETURN VARCHAR2 AS
18: --
118: RETURN 3;
119: END if;
120: End validate_account_entered;
121: --
122: END hr_be_validation;