eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XTR_UPDATE_SETTLEMENT_ACCOUNTS dependencies on XTR_BANK_ACCOUNTS

Line 23: * XTR_BANK_ACCOUNTS for the above party.

19: * IN:
20: * p_party_code Party Code of the party for whom the
21: * accounts are to be updated.
22: * p_current_bank_account Bank Account Number from
23: * XTR_BANK_ACCOUNTS for the above party.
24: * All cashflow records that use this
25: * account are to be updated.
26: * p_new_bank_account Bank Account Number from
27: * XTR_BANK_ACCOUNTS for the above party.

Line 27: * XTR_BANK_ACCOUNTS for the above party.

23: * XTR_BANK_ACCOUNTS for the above party.
24: * All cashflow records that use this
25: * account are to be updated.
26: * p_new_bank_account Bank Account Number from
27: * XTR_BANK_ACCOUNTS for the above party.
28: * All cashflow records that use the
29: * above account will be updated with this
30: * account.
31: * p_start_date All records with an amount_date greater

Line 62: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

58: PROCEDURE Process_Settlement_Accounts(
59: p_error_buf OUT NOCOPY VARCHAR2,
60: p_retcode OUT NOCOPY NUMBER,
61: p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
62: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
63: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
64: p_start_date IN VARCHAR2,
65: p_end_date IN VARCHAR2,
66: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,

Line 63: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

59: p_error_buf OUT NOCOPY VARCHAR2,
60: p_retcode OUT NOCOPY NUMBER,
61: p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
62: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
63: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
64: p_start_date IN VARCHAR2,
65: p_end_date IN VARCHAR2,
66: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
67: p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,

Line 157: l_current_currency XTR_BANK_ACCOUNTS.currency%TYPE;

153: AND b.batch_id = p_batch_id;
154:
155: l_commit_counter NUMBER;
156: l_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE;
157: l_current_currency XTR_BANK_ACCOUNTS.currency%TYPE;
158: l_current_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
159: l_new_currency XTR_BANK_ACCOUNTS.currency%TYPE;
160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;
161: l_reqid VARCHAR2(30);

Line 158: l_current_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;

154:
155: l_commit_counter NUMBER;
156: l_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE;
157: l_current_currency XTR_BANK_ACCOUNTS.currency%TYPE;
158: l_current_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
159: l_new_currency XTR_BANK_ACCOUNTS.currency%TYPE;
160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;
161: l_reqid VARCHAR2(30);
162: l_request_id NUMBER;

Line 159: l_new_currency XTR_BANK_ACCOUNTS.currency%TYPE;

155: l_commit_counter NUMBER;
156: l_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE;
157: l_current_currency XTR_BANK_ACCOUNTS.currency%TYPE;
158: l_current_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
159: l_new_currency XTR_BANK_ACCOUNTS.currency%TYPE;
160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;
161: l_reqid VARCHAR2(30);
162: l_request_id NUMBER;
163: l_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;

Line 160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;

156: l_company_code XTR_PARTY_INFO.PARTY_CODE%TYPE;
157: l_current_currency XTR_BANK_ACCOUNTS.currency%TYPE;
158: l_current_party_code XTR_BANK_ACCOUNTS.PARTY_CODE%TYPE;
159: l_new_currency XTR_BANK_ACCOUNTS.currency%TYPE;
160: l_new_authorized XTR_BANK_ACCOUNTS.AUTHORISED%TYPE;
161: l_reqid VARCHAR2(30);
162: l_request_id NUMBER;
163: l_amount_type XTR_DEAL_DATE_AMOUNTS.AMOUNT_TYPE%TYPE;
164: l_amount_date XTR_DEAL_DATE_AMOUNTS.AMOUNT_DATE%TYPE;

Line 202: FROM xtr_bank_accounts xban, xtr_parties_v xpv

198: /* for bug 5634804*/
199:
200: SELECT xban.currency, xpv.party_type
201: INTO l_current_currency, l_party_type
202: FROM xtr_bank_accounts xban, xtr_parties_v xpv
203: WHERE xban.account_number = p_current_bank_account
204: AND xban.party_code = p_party_code
205: AND xpv.party_code = xban.party_code;
206:

Line 209: FROM xtr_bank_accounts

205: AND xpv.party_code = xban.party_code;
206:
207: SELECT currency, authorised
208: INTO l_new_currency, l_new_authorized
209: FROM xtr_bank_accounts
210: WHERE account_number = p_new_bank_account
211: AND party_code = p_party_code;
212:
213: IF l_new_authorized <> 'Y' THEN

Line 652: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

648: p_cashflow_request_details_id IN
649: XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
650: p_request_id IN NUMBER,
651: p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
652: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
653: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
654: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
655: p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,
656: p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,

Line 653: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

649: XTR_CFLOW_REQUEST_DETAILS.CASHFLOW_REQUEST_DETAILS_ID%TYPE,
650: p_request_id IN NUMBER,
651: p_party_code IN XTR_PARTY_INFO.PARTY_CODE%TYPE,
652: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
653: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,
654: p_deal_type IN XTR_DEALS.DEAL_TYPE%TYPE,
655: p_deal_number_from IN XTR_DEALS.DEAL_NO%TYPE,
656: p_deal_number_to IN XTR_DEALS.DEAL_NO%TYPE,
657: p_start_date IN DATE,