1 PACKAGE XTR_UPDATE_SETTLEMENT_ACCOUNTS as
2 /* $Header: xtrupacs.pls 120.1 2005/07/29 17:11:40 rjose noship $ */
3
4 --------------------------------------
5 -- global variables
6 --------------------------------------
7 G_user_id NUMBER;
8 G_create_date DATE;
9
10 --------------------------------------
11 -- declaration of public procedures and functions
12 --------------------------------------
13
14 /**
15 * PROCEDURE process_settlement_accounts
16 *
17 * DESCRIPTION
18 * This procedure updates XTR_DEAL_DATE_AMOUNTS table and sets the
19 * company account or counterparty account specified as the
20 * account_number_from to the account specified as account_number_to.
21 *
22 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
23 *
24 * ARGUMENTS
25 * IN:
26 * p_party_code Party Code of the party for whom the
27 * accounts are to be updated.
28 * p_current_bank_account Bank Account Number from
29 * XTR_BANK_ACCOUNTS for the above party.
30 * All cashflow records that use this
31 * account are to be updated.
32 * p_new_bank_account Bank Account Number from
33 * XTR_BANK_ACCOUNTS for the above party.
34 * All cashflow records that use the
35 * above account will be updated with this
36 * account.
37 * p_start_date All records with an amount_date greater
38 * than or equal to this date will be
39 * considered for update.
40 * p_end_date All records with an amount_date lesser
41 * than or equal to this date will be
42 * considered for update.
43 * p_deal_type Only those deals with the specified
44 * Deal Type will be updated.
45 * p_deal_number_from Only those deals with a deal number
46 * greater than or equal to this
47 * parameter will be updated.
48 * p_deal_number_to Only those deals with a deal number
49 * lesser than or equal to this
50 * parameter will be updated.
51 * p_include_journalized Flag to indicate whether cashflows
52 * that have already been journalized
53 * should be updated.
54 * IN/OUT:
55 * OUT:
56 * p_error_buf Standard Error Buffer
57 * p_retcode
58 *
59 * NOTES
60 *
61 * MODIFICATION HISTORY
62 *
63 * 06-Jun-2005 Rajesh Jose o Created.
64 *
65 */
66 PROCEDURE Process_Settlement_Accounts(
67 p_error_buf OUT NOCOPY VARCHAR2,
68 p_retcode OUT NOCOPY NUMBER,
69 p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
70 p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
71 p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
72 p_start_date IN VARCHAR2,
73 p_end_date IN VARCHAR2,
74 p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
75 p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,
76 p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,
77 p_include_journalized IN
78 XTR_CFLOW_REQUEST_DETAILS.INCLUDE_JOURNALIZED_FLAG%TYPE);
79
80
81 /**
82 * PROCEDURE insert_request_details
83 *
84 * DESCRIPTION
85 * Inserts request details into XTR_CFLOW_REQUEST_DETAILS table so that
86 * the execution report can be run at any time.
87 *
88 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
89 *
90 * ARGUMENTS
91 * IN:
92 * p_cashflow_request_details_id The identifier for the record.
93 * p_request_id The Request ID of the Concurrent
94 * Request that was run to update the
95 * Settlement Accounts.
96 * p_party_code Party Code Parameter from the request.
97 * p_current_bank_account Current Bank Account Number Parameter
98 * from the request.
99 * p_new_bank_account New Bank Account Number Parameter
100 * from request.
101 * p_start_date Start Date Parameter from the request.
102 * p_end_date End Date Parameter from the request.
103 * p_deal_type Deal Type Parameter from the request.
104 * p_deal_number_from Deal Number From Parameter from the
105 * request.
106 * p_deal_number_to Deal Number To Parameter from the
107 * request.
108 * p_inc_journalized Include Journalized Transactions
109 * Parameter from the request.
110 * IN/OUT:
111 * OUT:
112 *
113 * NOTES
114 *
115 * MODIFICATION HISTORY
116 *
117 * 06-Jun-2005 Rajesh Jose o Created.
118 */
119 PROCEDURE Insert_Request_Details(
120 p_cashflow_request_details_id IN
121 XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
122 p_request_id IN NUMBER,
123 p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
124 p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
125 p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
126 p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
127 p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,
128 p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,
129 p_start_date IN DATE,
130 p_end_date IN DATE,
131 p_inc_journalized IN
132 XTR_CFLOW_REQUEST_DETAILS.INCLUDE_JOURNALIZED_FLAG%TYPE);
133
134
135 /**
136 * PROCEDURE insert_transaction_details
137 *
138 * DESCRIPTION
139 * Inserts details of transactions updated by the concurrent request
140 * so that the Execution Report shows accurate data at any point of time.
141 *
142 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
143 *
144 * ARGUMENTS
145 * IN:
146 * p_cashflow_request_details_id Foreign key reference from
147 * XTR_CFLOW_REQUEST_DETAILS.
148 * p_amount_date The amount date of the cashflow.
149 * p_amount_type The type of cashflow.
150 * p_cashflow_amount The amount of cash flow.
151 * p_deal_type The Deal Type for the record.
152 * p_deal_number The Deal Number for the record.
153 * p_transaction_number The Transaction Number for the record.
154 * p_updated_flag Flag indicating whether the record was
155 * updated or not.
156 * p_message_name Message to be shown if record was not
157 * updated. Conveys the reason why the
158 * record was not updated.
159 * IN/OUT:
160 * OUT:
161 *
162 * NOTES
163 *
164 * MODIFICATION HISTORY
165 * 06-Jun-2005 Rajesh Jose o Created.
166 *
167 */
168
169 PROCEDURE Insert_Transaction_Details(
170 p_cashflow_request_details_id IN
171 XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
172 p_amount_date IN DATE,
173 p_amount_type IN XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE,
174 p_cashflow_amount IN
175 XTR_DEAL_DATE_AMOUNTS.CASHFLOW_AMOUNT%TYPE,
176 p_deal_type IN XTR_DEAL_DATE_AMOUNTS.DEAL_TYPE%TYPE,
177 p_deal_number IN XTR_DEALS.DEAL_NO%TYPE,
178 p_transaction_number IN
179 XTR_DEAL_DATE_AMOUNTS.TRANSACTION_NUMBER%TYPE,
180 p_updated_flag IN VARCHAR2,
181 p_message_name IN VARCHAR2);
182
183
184 END XTR_UPDATE_SETTLEMENT_ACCOUNTS;
185