PACKAGE: APPS.HR_BE_VALIDATION

Source

1 PACKAGE hr_be_validation AUTHID CURRENT_USER AS
2   /* $Header: hrbevali.pkh 120.0.12010000.2 2009/12/01 09:29:53 bkeshary ship $ */
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 
26   FUNCTION validate_account_entered
27   (p_acc_no        IN VARCHAR2,
28    p_is_iban_acc   IN varchar2) RETURN NUMBER;
29 
30 END hr_be_validation;