[Home] [Help]
PACKAGE: APPS.CE_BANK_AND_ACCOUNT_UTIL
Source
1 PACKAGE CE_BANK_AND_ACCOUNT_UTIL AS
2 /*$Header: cebautls.pls 120.2 2005/05/18 18:26:20 xxwang noship $ */
3
4 /*=======================================================================+
5 | Array of bank_account_id |
6 +=======================================================================*/
7 TYPE BankAcctIdTable IS TABLE OF ce_bank_accounts.bank_account_id%TYPE;
8
9 /*=======================================================================+
10 | PUBLIC FUNCTION get_masked_bank_acct_num |
11 | |
12 | DESCRIPTION |
13 | This function takes a bank_account_id and returns the bank account |
14 | number with the appropriate mask based on the value of the profile |
15 | option 'CE: Mask Internal Bank Account Numbers' |
16 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
17 | |
18 | ARGUMENTS |
19 | IN: |
20 | p_bank_acct_id |
21 +=======================================================================*/
22 FUNCTION get_masked_bank_acct_num(p_bank_acct_id IN NUMBER) RETURN VARCHAR2;
23
24
25 /*=======================================================================+
26 | PUBLIC FUNCTION get_org_bank_acct_list |
27 | |
28 | DESCRIPTION |
29 | This function takes a org_id and returns the list of bank accounts |
30 | that this org has access |
31 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
32 | |
33 | ARGUMENTS |
34 | IN: |
35 | p_org_id |
36 | RETURN |
37 | '@' deliminated bank_account_id's |
38 +=======================================================================*/
39 FUNCTION get_org_bank_acct_list(p_org_id IN NUMBER) RETURN VARCHAR2;
40
41
42
43 /*=======================================================================+
44 | PUBLIC PRECEDURE sql_error |
45 | |
46 | DESCRIPTION |
47 | This procedure sets the error message and raise an exception |
48 | for unhandled sql errors. |
49 | Called by other routines. |
50 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
51 | |
52 | ARGUMENTS |
53 | IN: |
54 | p_routine |
55 | p_errcode |
56 | p_errmsg |
57 +=======================================================================*/
58 PROCEDURE sql_error(p_routine IN VARCHAR2,
59 p_errcode IN NUMBER,
60 p_errmsg IN VARCHAR2);
61
62
63 /*=======================================================================+
64 | PUBLIC PRECEDURE get_internal_bank_accts |
65 | |
66 | DESCRIPTION |
67 | This procedure returns the list of internal bank accounts given the |
68 | conditions of date, currency, and organization that uses this BA. |
69 | |
70 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
71 | |
72 | ARGUMENTS |
73 | IN: |
74 | p_currency |
75 | p_org_id |
76 | p_date |
77 | IN/OUT: |
78 | OUT: |
79 | x_bank_acct_ids '@' deliminated bank_account_id's |
80 +=======================================================================*/
81 PROCEDURE get_internal_bank_accts (p_currency IN VARCHAR2,
82 p_org_type IN VARCHAR2,
83 p_org_id IN NUMBER,
84 p_date IN DATE,
85 x_bank_acct_ids OUT NOCOPY BankAcctIdTable);
86
87 END CE_BANK_AND_ACCOUNT_UTIL;