DBA Data[Home] [Help]

APPS.XTR_UPDATE_SETTLEMENT_ACCOUNTS dependencies on XTR_BANK_ACCOUNTS

Line 29: * XTR_BANK_ACCOUNTS for the above party.

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.

Line 33: * XTR_BANK_ACCOUNTS for the above party.

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

Line 70: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

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,

Line 71: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

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,

Line 124: p_current_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

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,

Line 125: p_new_bank_account IN XTR_BANK_ACCOUNTS.ACCOUNT_NUMBER%TYPE,

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,