1 PACKAGE XTR_NOTIONAL_BANK_ACCOUNTS as
2 /* $Header: xtrnbnks.pls 120.1 2005/07/29 09:32:34 badiredd noship $ */
3
4 --------------------------------------
5 -- declaration of public procedures and functions
6 --------------------------------------
7
8 /**
9 * PROCEDURE modify_xtr_bank_accounts
10 *
11 * DESCRIPTION
12 * This procedure creates a dummy bank account in xtr_bank_accounts
13 * if the cash pool is being created.
14 * If an existing cash pool is being updated, then the corresponding
15 * dummy bank account in xtr_bank_accounts will be updated.
16 *
17 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
18 *
19 * ARGUMENTS
20 * IN:
21 * p_cashpool_id Cashpool ID of the Notional Cash Pool
22 * that is being created or updated.
23 * p_bank_account_id Bank Account ID from CE_BANK_ACCOUNTS
24 * of the Concentration Account of the
25 * Cashpool.
26 * IN/OUT:
27 * x_return_status Return status after the call. The
28 * status can be Y for success or N for
29 * error.
30 * OUT:
31 *
32 * NOTES
33 *
34 * MODIFICATION HISTORY
35 *
36 * 01-26-2005 Rajesh Jose o Created.
37 *
38 */
39
40 PROCEDURE modify_xtr_bank_accounts(
41 p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
42 p_bank_account_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
43 x_return_status IN OUT NOCOPY VARCHAR2);
44
45 /**
46 * PROCEDURE create_xtr_bank_account
47 *
48 * DESCRIPTION
49 * Creates dummy account in XTR_BANK_ACCOUNTS
50 *
51 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
52 *
53 * ARGUMENTS
54 * IN:
55 * p_cashpool_id Cashpool ID of the Notional Cash Pool
56 * that is being created or updated.
57 * p_bank_account_id Bank Account ID from CE_BANK_ACCOUNTS
58 * of the Concentration Account of the
59 * Cashpool.
60 * IN/OUT:
61 * x_return_status Return status after the call. The
62 * status can be Y for success or N for
63 * error.
64 * OUT:
65 *
66 * NOTES
67 *
68 * MODIFICATION HISTORY
69 *
70 * 01-26-2005 Rajesh Jose o Created.
71 */
72
73 PROCEDURE create_xtr_bank_account(
74 p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
75 p_bank_account_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
76 x_return_status IN OUT NOCOPY VARCHAR2);
77
78 /**
79 * PROCEDURE update_xtr_bank_account
80 *
81 * DESCRIPTION
82 * Updates the dummy account in XTR_BANK_ACCOUNTS
83 *
84 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
85 *
86 * ARGUMENTS
87 * IN:
88 * p_cashpool_id Cashpool ID of the Notional Cash Pool
89 * that is being created or updated.
90 * p_bank_account_id Bank Account ID from CE_BANK_ACCOUNTS
91 * of the Concentration Account of the
92 * Cashpool.
93 * IN/OUT:
94 * x_return_status Return status after the call. The
95 * status can be Y for success or N for
96 * error.
97 * OUT:
98 *
99 * NOTES
100 *
101 * MODIFICATION HISTORY
102 *
103 * 01-26-2005 Rajesh Jose o Created.
104 */
105
106 PROCEDURE update_xtr_bank_account(
107 p_cashpool_id IN CE_CASHPOOLS.CASHPOOL_ID%TYPE,
108 p_bank_account_id IN CE_BANK_ACCOUNTS.BANK_ACCOUNT_ID%TYPE,
109 x_return_status IN OUT NOCOPY VARCHAR2);
110
111 END XTR_NOTIONAL_BANK_ACCOUNTS;
112