PACKAGE: APPS.HR_BE_VALIDATION

Source

1 PACKAGE hr_be_validation AUTHID CURRENT_USER AS
2   /* $Header: hrbevali.pkh 115.1 2003/08/08 02:55:19 atrivedi noship $ */
3   --
4   --
5   -- Constants representing the success or failure of a particular piece of
6   -- validation.
7   --
8   success CONSTANT VARCHAR2(7) := 'SUCCESS';
9   failure CONSTANT VARCHAR2(7) := 'FAILURE';
10   --
11   --
12   -- This function validates that the bank account no is valid (see comments
13   -- within code for details of correct format and check digit calculation).
14   --
15   -- Its primary usage is within the bank account key flexfield definition
16   -- where it is used to drive some cross validation rules.
17   --
18   -- This function returns either:
19   --
20   -- Bank account no is OK      - hr_be_validation.success
21   -- Bank account no is invalid - hr_be_validation.failure
22   --
23   FUNCTION bank_account_no
24   (p_bank_acc_no VARCHAR2) RETURN VARCHAR2;
25 END hr_be_validation;