DBA Data[Home] [Help]

APPS.XTR_REPLICATE_BANK_BALANCES dependencies on XTR_BANK_ACCOUNTS

Line 89: , p_currency IN xtr_bank_accounts.currency%TYPE

85: );
86:
87: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
88: , p_account_number IN xtr_bank_balances.account_number%TYPE
89: , p_currency IN xtr_bank_accounts.currency%TYPE
90: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
91: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
92: , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
93: , p_action_flag IN VARCHAR2

Line 100: , p_currency IN xtr_bank_accounts.currency%TYPE

96:
97:
98: FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
99: , p_account_number IN xtr_bank_balances.account_number%TYPE
100: , p_currency IN xtr_bank_accounts.currency%TYPE
101: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
102: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
103: , p_interest_calc_balance IN NUMBER
104: , p_action_flag IN VARCHAR2

Line 111: , p_currency IN xtr_bank_accounts.currency%TYPE

107:
108: FUNCTION CHK_ACCRUAL_ON_RENDER
109: ( p_company_code IN xtr_bank_balances.company_code%TYPE
110: , p_account_number IN xtr_bank_balances.account_number%TYPE
111: , p_currency IN xtr_bank_accounts.currency%TYPE
112: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
113: )return boolean;
114:
115:

Line 119: , p_currency IN xtr_bank_accounts.currency%TYPE

115:
116: FUNCTION CHK_REVAL_ON_RENDER
117: ( p_company_code IN xtr_bank_balances.company_code%TYPE
118: , p_account_number IN xtr_bank_balances.account_number%TYPE
119: , p_currency IN xtr_bank_accounts.currency%TYPE
120: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
121: )return boolean;
122:
123:

Line 125: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

121: )return boolean;
122:
123:
124: FUNCTION CHK_ACCRUAL_ON_RENDER
125: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
126: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
127: )return VARCHAR2;
128:
129:

Line 132: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

128:
129:
130:
131: FUNCTION CHK_REVAL_ON_RENDER
132: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
133: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
134: )return VARCHAR2;
135:
136:

Line 144: p_party_code xtr_bank_accounts.party_code%type

140: p_account_number IN xtr_bank_balances.account_number%TYPE,
141: p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;
142:
143: FUNCTION CHK_ACCRUAL_INT (
144: p_party_code xtr_bank_accounts.party_code%type
145: ,p_account_number xtr_bank_accounts.account_number%type
146: )RETURN varchar2;
147:
148:

Line 145: ,p_account_number xtr_bank_accounts.account_number%type

141: p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;
142:
143: FUNCTION CHK_ACCRUAL_INT (
144: p_party_code xtr_bank_accounts.party_code%type
145: ,p_account_number xtr_bank_accounts.account_number%type
146: )RETURN varchar2;
147:
148:
149: FUNCTION CHK_INT_OVERRIDE (

Line 150: p_party_code xtr_bank_accounts.party_code%type

146: )RETURN varchar2;
147:
148:
149: FUNCTION CHK_INT_OVERRIDE (
150: p_party_code xtr_bank_accounts.party_code%type
151: ,p_account_number xtr_bank_accounts.account_number%type
152: ,p_oldest_date DATE
153: ) RETURN VARCHAR2;
154:

Line 151: ,p_account_number xtr_bank_accounts.account_number%type

147:
148:
149: FUNCTION CHK_INT_OVERRIDE (
150: p_party_code xtr_bank_accounts.party_code%type
151: ,p_account_number xtr_bank_accounts.account_number%type
152: ,p_oldest_date DATE
153: ) RETURN VARCHAR2;
154:
155:

Line 157: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE

153: ) RETURN VARCHAR2;
154:
155:
156: PROCEDURE UPDATE_ROUNDING_DAYCOUNT
157: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
158: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
159: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2
161: );

Line 158: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE

154:
155:
156: PROCEDURE UPDATE_ROUNDING_DAYCOUNT
157: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
158: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
159: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2
161: );
162:

Line 159: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE

155:
156: PROCEDURE UPDATE_ROUNDING_DAYCOUNT
157: (p_ce_bank_account_id xtr_bank_accounts.ce_bank_account_id%TYPE
158: ,p_rounding_type xtr_bank_accounts.rounding_type%TYPE
159: ,p_day_count_type xtr_bank_accounts.day_count_type%TYPE
160: ,x_return_status OUT NOCOPY VARCHAR2
161: );
162:
163:

Line 175: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

171:
172:
173:
174: FUNCTION CHK_INTEREST_SETTLED
175: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
176: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
177: )return VARCHAR2;
178:
179: PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS

Line 180: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

176: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
177: )return VARCHAR2;
178:
179: PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS
180: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
181: ,p_balance_date IN xtr_bank_balances.balance_date%TYPE
182: ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
183: ,p_interest_calc_balance IN NUMBER
184: ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE