[Home] [Help]
PACKAGE: APPS.CE_BANK_AND_ACCOUNT_UTIL
Source
1 PACKAGE CE_BANK_AND_ACCOUNT_UTIL AUTHID CURRENT_USER AS
2 /*$Header: cebautls.pls 120.2.12010000.4 2009/07/28 08:30:10 ckansara ship $ */
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 | PUBLIC FUNCTION get_masked_IBAN |
26 | |
27 | DESCRIPTION |
28 | This function takes a bank_account_id and returns the IBAN |
29 | number with the appropriate mask based on the value of the profile |
30 | option 'CE: Mask Internal Bank Account Numbers' |
31 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
32 | |
33 | ARGUMENTS |
34 | IN: |
35 | p_bank_acct_id |
36 +=======================================================================*/
37 FUNCTION get_masked_IBAN(p_bank_acct_id IN NUMBER) RETURN VARCHAR2;
38
39 /*=======================================================================+
40 | PUBLIC FUNCTION get_org_bank_acct_list |
41 | |
42 | DESCRIPTION |
43 | This function takes a org_id and returns the list of bank accounts |
44 | that this org has access |
45 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
46 | |
47 | ARGUMENTS |
48 | IN: |
49 | p_org_id |
50 | RETURN |
51 | '@' deliminated bank_account_id's |
52 +=======================================================================*/
53 FUNCTION get_org_bank_acct_list(p_org_id IN NUMBER) RETURN VARCHAR2;
54
55
56
57 /*=======================================================================+
58 | PUBLIC PRECEDURE sql_error |
59 | |
60 | DESCRIPTION |
61 | This procedure sets the error message and raise an exception |
62 | for unhandled sql errors. |
63 | Called by other routines. |
64 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
65 | |
66 | ARGUMENTS |
67 | IN: |
68 | p_routine |
69 | p_errcode |
70 | p_errmsg |
71 +=======================================================================*/
72 PROCEDURE sql_error(p_routine IN VARCHAR2,
73 p_errcode IN NUMBER,
74 p_errmsg IN VARCHAR2);
75
76
77 /*=======================================================================+
78 | PUBLIC PRECEDURE get_internal_bank_accts |
79 | |
80 | DESCRIPTION |
81 | This procedure returns the list of internal bank accounts given the |
82 | conditions of date, currency, and organization that uses this BA. |
83 | |
84 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
85 | |
86 | ARGUMENTS |
87 | IN: |
88 | p_currency |
89 | p_org_id |
90 | p_date |
91 | IN/OUT: |
92 | OUT: |
93 | x_bank_acct_ids '@' deliminated bank_account_id's |
94 +=======================================================================*/
95 PROCEDURE get_internal_bank_accts (p_currency IN VARCHAR2,
96 p_org_type IN VARCHAR2,
97 p_org_id IN NUMBER,
98 p_date IN DATE,
99 x_bank_acct_ids OUT NOCOPY BankAcctIdTable);
100
101 /*=======================================================================+
102 | PUBLIC PRECEDURE get_internal_bank_accts For bug 8277703 |
103 | |
104 | DESCRIPTION |
105 | This procedure returns the list of internal bank accounts given the |
106 | conditions of date, currency, and organization that uses this BA. |
107 | |
108 | EXTERNAL PROCEDURES/FUNCTIONS ACCESSED |
109 | |
110 | ARGUMENTS |
111 | IN: |
112 | p_currency |
113 | p_org_id |
114 | p_date |
115 | IN/OUT: |
116 | OUT: |
117 | p_internal_bank_account_id |
118 | p_valid_flag |
119 +=======================================================================*/
120 PROCEDURE get_internal_bank_accts (p_currency IN VARCHAR2,
121 p_org_type IN VARCHAR2,
122 p_org_id IN NUMBER,
123 p_date IN DATE,
124 p_internal_bank_account_id IN OUT NOCOPY NUMBER,
125 p_valid_flag OUT NOCOPY BOOLEAN);
126
127 END CE_BANK_AND_ACCOUNT_UTIL;