1 PACKAGE CE_CUSTOM_BANK_VALIDATIONS AUTHID CURRENT_USER AS
2 /* $Header: cecbnkvs.pls 120.2 2009/12/24 06:53:31 vnetan noship $*/
3 /*----------------------------------------------------------------------+
4 | PUBLIC PROCEDURE |
5 | ce_usr_validate_bank |
6 | |
7 | DESCRIPTION |
8 | This will be called when validating a bank from the Bank Setup UI |
9 | |
10 | PARAMETERS |
11 | IN |
12 | Xi_COUNTRY_NAME Country Name (Two-digit ISO Code) |
13 | Xi_BANK_NUMBER Bank Number |
14 | Xi_BANK_NAME Bank Name |
15 | Xi_BANK_NAME_ALT Alt. Bank Name |
16 | Xi_TAX_PAYER_ID Tax Payer ID |
17 | Xi_BANK_ID Bank ID -> CE_BANKS_V.bank_party_id (available |
18 | when updating a bank) |
19 | |
20 | OUT |
21 | Xo_RETURN_STATUS fnd_api.g_ret_sts_success - Validation Successful |
22 | fnd_api.g_ret_sts_error - Validation Failure |
23 | |
24 | Xo_BANK_NUM_OUT Formatted value of bank number to be stored. |
25 +----------------------------------------------------------------------*/
26 PROCEDURE CE_USR_VALIDATE_BANK(
27 Xi_COUNTRY_NAME IN VARCHAR2,
28 Xi_BANK_NUMBER IN VARCHAR2,
29 Xi_BANK_NAME IN VARCHAR2,
30 Xi_BANK_NAME_ALT IN VARCHAR2,
31 Xi_TAX_PAYER_ID IN VARCHAR2,
32 Xi_BANK_ID IN NUMBER,
33 Xo_BANK_NUM_OUT OUT NOCOPY VARCHAR2,
34 Xo_RETURN_STATUS OUT NOCOPY VARCHAR2
35 );
36
37 /*----------------------------------------------------------------------+
38 | PUBLIC PROCEDURE |
39 | ce_usr_validate_branch |
40 | |
41 | DESCRIPTION |
42 | This will be called when validating a bank branch from the Bank |
43 | Branch Setup UI. |
44 | |
45 | PARAMETERS |
46 | IN |
47 | Xi_COUNTRY_NAME Country Name (Two-digit ISO Code) |
48 | Xi_BANK_NUMBER Bank Number |
49 | Xi_BRANCH_NUMBER Bank Branch Number |
50 | Xi_BANK_NAME Bank Name |
51 | Xi_BRANCH_NAME Bank Branch Name |
52 | Xi_BRANCH_NAME_ALT Alt. Bank Branch Name |
53 | Xi_BRANCH_TYPE Bank Branch Type |
54 | Xi_BANK_ID Bank ID -> CE_BANKS_V.bank_party_id |
55 | Xi_BRANCH_ID Bank ID -> CE_BANK_BRANCHES_V.branch_party_id |
56 | (available when updating a bank branch)|
57 | |
58 | OUT |
59 | Xo_RETURN_STATUS fnd_api.g_ret_sts_success - Validation Successful |
60 | fnd_api.g_ret_sts_error - Validation Failure |
61 | |
62 | Xo_BRANCH_NUM_OUT Formatted value of branch number to be stored |
63 +----------------------------------------------------------------------*/
64 PROCEDURE CE_USR_VALIDATE_BRANCH(
65 Xi_COUNTRY_NAME IN VARCHAR2,
66 Xi_BANK_NUMBER IN VARCHAR2,
67 Xi_BRANCH_NUMBER IN VARCHAR2,
68 Xi_BANK_NAME IN VARCHAR2,
69 Xi_BRANCH_NAME IN VARCHAR2,
70 Xi_BRANCH_NAME_ALT IN VARCHAR2,
71 Xi_BRANCH_TYPE IN VARCHAR2,
72 Xi_BANK_ID IN NUMBER,
73 Xi_BRANCH_ID IN NUMBER,
74 Xo_BRANCH_NUM_OUT OUT NOCOPY VARCHAR2,
75 Xo_RETURN_STATUS OUT NOCOPY VARCHAR2
76 );
77
78 /*----------------------------------------------------------------------+
79 | PUBLIC PROCEDURE |
80 | ce_usr_validate_account |
81 | |
82 | DESCRIPTION |
83 | This will be called when validating a bank account from the Bank |
84 | Account Setup UI. |
85 | |
86 | PARAMETERS |
87 | IN |
88 | Xi_COUNTRY_NAME Country Name (Two-digit ISO Code) |
89 | Xi_BANK_NUMBER Bank Number |
90 | Xi_BRANCH_NUMBER Bank Branch Number |
91 | Xi_ACCOUNT_NUMBER Bank Account Number |
92 | Xi_CD Check Digit |
93 | Xi_ACCOUNT_NAME Bank Account Name |
94 | Xi_CURRENCY_CODE Bank Account Currency |
95 | Xi_ACCOUNT_TYPE Bank Account Type |
96 | Xi_ACCOUNT_SUFFIX Account Suffix |
97 | Xi_SECONDARY_ACCT_REF Secondary Account Reference |
98 | Xi_ACCT_CLASSIFICATION Account Classification ('Internal') |
99 | Xi_BANK_ID CE_BANKS_V.bank_party_id |
100 | Xi_BRANCH_ID CE_BANKS_BRANCHES_V.branch_party_id |
101 | Xi_ACCOUNT_ID CE_BANK_ACCOUNTS.bank_account_id |
102 | |
103 | OUT |
104 | Xo_RETURN_STATUS fnd_api.g_ret_sts_success - Validation Successful |
105 | fnd_api.g_ret_sts_error - Validation Failure |
106 | |
107 | Xo_ACCOUNT_NUM_OUT Formatted value of account number to be stored |
108 +----------------------------------------------------------------------*/
109 PROCEDURE CE_USR_VALIDATE_ACCOUNT(
110 Xi_COUNTRY_NAME IN VARCHAR2,
111 Xi_BANK_NUMBER IN VARCHAR2,
112 Xi_BRANCH_NUMBER IN VARCHAR2,
113 Xi_ACCOUNT_NUMBER IN VARCHAR2,
114 Xi_CD IN VARCHAR2,
115 Xi_ACCOUNT_NAME IN VARCHAR2,
116 Xi_CURRENCY_CODE IN VARCHAR2,
117 Xi_ACCOUNT_TYPE IN VARCHAR2,
118 Xi_ACCOUNT_SUFFIX IN VARCHAR2,
119 Xi_SECONDARY_ACCT_REF IN VARCHAR2,
120 Xi_ACCT_CLASSIFICATION IN VARCHAR2,
121 Xi_BANK_ID IN NUMBER,
122 Xi_BRANCH_ID IN NUMBER,
123 Xi_ACCOUNT_ID IN NUMBER,
124 Xo_ACCOUNT_NUM_OUT OUT NOCOPY VARCHAR2,
125 Xo_RETURN_STATUS OUT NOCOPY VARCHAR2
126 );
127
128 END CE_CUSTOM_BANK_VALIDATIONS;