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_REPLICATE_BANK_BALANCES dependencies on XTR_BANK_BALANCES

Line 4: -- To replicate the data from CE tables to xtr_bank_balances table

1: PACKAGE XTR_REPLICATE_BANK_BALANCES AUTHID CURRENT_USER AS
2: /* | $Header: xtrbbals.pls 120.4.12020000.2 2013/01/18 11:28:05 rtumati ship $ | */
3: --
4: -- To replicate the data from CE tables to xtr_bank_balances table
5: --
6: --
7: -- Purpose: This package will insert/delete/update the bank balances
8: -- from CE tables to the xtr_bank_balances table.

Line 8: -- from CE tables to the xtr_bank_balances table.

4: -- To replicate the data from CE tables to xtr_bank_balances table
5: --
6: --
7: -- Purpose: This package will insert/delete/update the bank balances
8: -- from CE tables to the xtr_bank_balances table.
9:
10: -- replicate_bank_account is the main procedure through which the
11: -- insert/delete/update procedures will be called.
12: --

Line 20: ( p_balance_rec IN xtr_bank_balances%rowtype,

16: -- --------- ------ ----------------------------------
17:
18:
19: PROCEDURE REPLICATE_BANK_BALANCE
20: ( p_balance_rec IN xtr_bank_balances%rowtype,
21: p_action_flag IN varchar2,
22: x_return_status OUT NOCOPY VARCHAR2,
23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2);

Line 27: ( p_ce_bank_account_balance_id IN XTR_BANK_BALANCES.ce_bank_account_balance_id%TYPE,

23: x_msg_count OUT NOCOPY NUMBER,
24: x_msg_data OUT NOCOPY VARCHAR2);
25:
26: PROCEDURE REPLICATE_BANK_BALANCE
27: ( p_ce_bank_account_balance_id IN XTR_BANK_BALANCES.ce_bank_account_balance_id%TYPE,
28: p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,
29: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
30: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
31: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,

Line 28: p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,

24: x_msg_data OUT NOCOPY VARCHAR2);
25:
26: PROCEDURE REPLICATE_BANK_BALANCE
27: ( p_ce_bank_account_balance_id IN XTR_BANK_BALANCES.ce_bank_account_balance_id%TYPE,
28: p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,
29: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
30: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
31: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
32: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,

Line 29: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,

25:
26: PROCEDURE REPLICATE_BANK_BALANCE
27: ( p_ce_bank_account_balance_id IN XTR_BANK_BALANCES.ce_bank_account_balance_id%TYPE,
28: p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,
29: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
30: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
31: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
32: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
33: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,

Line 30: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,

26: PROCEDURE REPLICATE_BANK_BALANCE
27: ( p_ce_bank_account_balance_id IN XTR_BANK_BALANCES.ce_bank_account_balance_id%TYPE,
28: p_company_code IN XTR_BANK_BALANCES.company_code%TYPE,
29: p_account_number IN XTR_BANK_BALANCES.account_number%TYPE,
30: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
31: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
32: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
33: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,
34: p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,

Line 34: p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,

30: p_balance_date IN XTR_BANK_BALANCES.balance_date%TYPE,
31: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
32: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
33: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,
34: p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,
35: p_two_day_float IN XTR_BANK_BALANCES.two_day_float%TYPE,
36: p_action_flag IN varchar2,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,

Line 35: p_two_day_float IN XTR_BANK_BALANCES.two_day_float%TYPE,

31: p_ledger_balance IN CE_BANK_ACCT_BALANCES.ledger_balance%TYPE,
32: p_available_balance IN CE_BANK_ACCT_BALANCES.available_balance%TYPE,
33: p_interest_calculated_balance IN CE_BANK_ACCT_BALANCES.value_dated_balance%TYPE,
34: p_one_day_float IN XTR_BANK_BALANCES.one_day_float%TYPE,
35: p_two_day_float IN XTR_BANK_BALANCES.two_day_float%TYPE,
36: p_action_flag IN varchar2,
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_msg_count OUT NOCOPY NUMBER,
39: x_msg_data OUT NOCOPY VARCHAR2);

Line 43: ( p_balance_rec IN xtr_bank_balances%rowtype,

39: x_msg_data OUT NOCOPY VARCHAR2);
40:
41:
42: PROCEDURE INSERT_BANK_BALANCE
43: ( p_balance_rec IN xtr_bank_balances%rowtype,
44: x_return_status In OUT NOCOPY VARCHAR2
45: );
46:
47: PROCEDURE UPDATE_BANK_BALANCE

Line 48: ( p_balance_rec IN xtr_bank_balances%rowtype,

44: x_return_status In OUT NOCOPY VARCHAR2
45: );
46:
47: PROCEDURE UPDATE_BANK_BALANCE
48: ( p_balance_rec IN xtr_bank_balances%rowtype,
49: x_return_status IN OUT NOCOPY VARCHAR2
50: );
51:
52: PROCEDURE DELETE_BANK_BALANCE

Line 53: ( p_balance_rec IN xtr_bank_balances%rowtype,

49: x_return_status IN OUT NOCOPY VARCHAR2
50: );
51:
52: PROCEDURE DELETE_BANK_BALANCE
53: ( p_balance_rec IN xtr_bank_balances%rowtype,
54: x_return_status IN OUT NOCOPY VARCHAR2
55: );
56:
57:

Line 59: ( p_company_code IN xtr_bank_balances.company_code%TYPE,

55: );
56:
57:
58: PROCEDURE VALIDATE_BANK_BALANCE
59: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
60: p_account_number IN xtr_bank_balances.account_number%TYPE,
61: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
62: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
63: p_interest_calc_balance IN NUMBER,

Line 60: p_account_number IN xtr_bank_balances.account_number%TYPE,

56:
57:
58: PROCEDURE VALIDATE_BANK_BALANCE
59: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
60: p_account_number IN xtr_bank_balances.account_number%TYPE,
61: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
62: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
63: p_interest_calc_balance IN NUMBER,
64: p_available_balance in NUMBER,

Line 61: p_balance_date IN xtr_bank_balances.balance_date%TYPE,

57:
58: PROCEDURE VALIDATE_BANK_BALANCE
59: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
60: p_account_number IN xtr_bank_balances.account_number%TYPE,
61: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
62: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
63: p_interest_calc_balance IN NUMBER,
64: p_available_balance in NUMBER,
65: p_action_flag IN VARCHAR2,

Line 62: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,

58: PROCEDURE VALIDATE_BANK_BALANCE
59: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
60: p_account_number IN xtr_bank_balances.account_number%TYPE,
61: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
62: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
63: p_interest_calc_balance IN NUMBER,
64: p_available_balance in NUMBER,
65: p_action_flag IN VARCHAR2,
66: x_return_status OUT NOCOPY VARCHAR2

Line 70: ( p_company_code IN xtr_bank_balances.company_code%TYPE,

66: x_return_status OUT NOCOPY VARCHAR2
67: );
68:
69: PROCEDURE VALIDATE_BANK_BALANCE
70: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
71: p_account_number IN xtr_bank_balances.account_number%TYPE,
72: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
73: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
74: p_interest_calc_balance IN NUMBER,

Line 71: p_account_number IN xtr_bank_balances.account_number%TYPE,

67: );
68:
69: PROCEDURE VALIDATE_BANK_BALANCE
70: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
71: p_account_number IN xtr_bank_balances.account_number%TYPE,
72: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
73: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
74: p_interest_calc_balance IN NUMBER,
75: p_available_balance in NUMBER,

Line 72: p_balance_date IN xtr_bank_balances.balance_date%TYPE,

68:
69: PROCEDURE VALIDATE_BANK_BALANCE
70: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
71: p_account_number IN xtr_bank_balances.account_number%TYPE,
72: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
73: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
74: p_interest_calc_balance IN NUMBER,
75: p_available_balance in NUMBER,
76: p_action_flag IN VARCHAR2,

Line 73: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,

69: PROCEDURE VALIDATE_BANK_BALANCE
70: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
71: p_account_number IN xtr_bank_balances.account_number%TYPE,
72: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
73: p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null,
74: p_interest_calc_balance IN NUMBER,
75: p_available_balance in NUMBER,
76: p_action_flag IN VARCHAR2,
77: x_return_status OUT NOCOPY VARCHAR2,

Line 84: p_balance_date IN xtr_bank_balances.balance_date%type DEFAULT NULL

80:
81: PROCEDURE LOG_ERR_MSG
82: ( p_error_code IN VARCHAR2,
83: p_field_name IN VARCHAR2 default null,
84: p_balance_date IN xtr_bank_balances.balance_date%type DEFAULT NULL
85: );
86:
87:
88: -- bug 9742850 starts

Line 90: ( p_company_code IN xtr_bank_balances.company_code%TYPE,

86:
87:
88: -- bug 9742850 starts
89: PROCEDURE VALIDATE_OD_LIMIT_BALANCE
90: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
91: p_branch_id IN NUMBER,
92: p_bank_accont_id IN NUMBER,
93: p_ledger_balance IN NUMBER,
94: x_return_status OUT NOCOPY VARCHAR2,

Line 101: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE

97: );
98:
99: -- bug 9742850 ends
100:
101: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
102: , p_account_number IN xtr_bank_balances.account_number%TYPE
103: , p_currency IN xtr_bank_accounts.currency%TYPE
104: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
105: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null

Line 102: , p_account_number IN xtr_bank_balances.account_number%TYPE

98:
99: -- bug 9742850 ends
100:
101: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
102: , p_account_number IN xtr_bank_balances.account_number%TYPE
103: , p_currency IN xtr_bank_accounts.currency%TYPE
104: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
105: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
106: , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE

Line 104: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

100:
101: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
102: , p_account_number IN xtr_bank_balances.account_number%TYPE
103: , p_currency IN xtr_bank_accounts.currency%TYPE
104: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
105: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
106: , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
107: , p_action_flag IN VARCHAR2
108: , p_val_type IN VARCHAR2 )

Line 105: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null

101: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
102: , p_account_number IN xtr_bank_balances.account_number%TYPE
103: , p_currency IN xtr_bank_accounts.currency%TYPE
104: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
105: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
106: , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
107: , p_action_flag IN VARCHAR2
108: , p_val_type IN VARCHAR2 )
109: RETURN VARCHAR2;

Line 106: , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE

102: , p_account_number IN xtr_bank_balances.account_number%TYPE
103: , p_currency IN xtr_bank_accounts.currency%TYPE
104: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
105: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
106: , p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
107: , p_action_flag IN VARCHAR2
108: , p_val_type IN VARCHAR2 )
109: RETURN VARCHAR2;
110:

Line 112: FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE

108: , p_val_type IN VARCHAR2 )
109: RETURN VARCHAR2;
110:
111:
112: FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
113: , p_account_number IN xtr_bank_balances.account_number%TYPE
114: , p_currency IN xtr_bank_accounts.currency%TYPE
115: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
116: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null

Line 113: , p_account_number IN xtr_bank_balances.account_number%TYPE

109: RETURN VARCHAR2;
110:
111:
112: FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
113: , p_account_number IN xtr_bank_balances.account_number%TYPE
114: , p_currency IN xtr_bank_accounts.currency%TYPE
115: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
116: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
117: , p_interest_calc_balance IN NUMBER

Line 115: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

111:
112: FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
113: , p_account_number IN xtr_bank_balances.account_number%TYPE
114: , p_currency IN xtr_bank_accounts.currency%TYPE
115: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
116: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
117: , p_interest_calc_balance IN NUMBER
118: , p_action_flag IN VARCHAR2
119: , p_val_type IN VARCHAR2)

Line 116: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null

112: FUNCTION CHK_ACCRUAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
113: , p_account_number IN xtr_bank_balances.account_number%TYPE
114: , p_currency IN xtr_bank_accounts.currency%TYPE
115: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
116: , p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
117: , p_interest_calc_balance IN NUMBER
118: , p_action_flag IN VARCHAR2
119: , p_val_type IN VARCHAR2)
120: RETURN VARCHAR2;

Line 123: ( p_company_code IN xtr_bank_balances.company_code%TYPE

119: , p_val_type IN VARCHAR2)
120: RETURN VARCHAR2;
121:
122: FUNCTION CHK_ACCRUAL_ON_RENDER
123: ( p_company_code IN xtr_bank_balances.company_code%TYPE
124: , p_account_number IN xtr_bank_balances.account_number%TYPE
125: , p_currency IN xtr_bank_accounts.currency%TYPE
126: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
127: )return boolean;

Line 124: , p_account_number IN xtr_bank_balances.account_number%TYPE

120: RETURN VARCHAR2;
121:
122: FUNCTION CHK_ACCRUAL_ON_RENDER
123: ( p_company_code IN xtr_bank_balances.company_code%TYPE
124: , p_account_number IN xtr_bank_balances.account_number%TYPE
125: , p_currency IN xtr_bank_accounts.currency%TYPE
126: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
127: )return boolean;
128:

Line 126: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

122: FUNCTION CHK_ACCRUAL_ON_RENDER
123: ( p_company_code IN xtr_bank_balances.company_code%TYPE
124: , p_account_number IN xtr_bank_balances.account_number%TYPE
125: , p_currency IN xtr_bank_accounts.currency%TYPE
126: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
127: )return boolean;
128:
129:
130: FUNCTION CHK_REVAL_ON_RENDER

Line 131: ( p_company_code IN xtr_bank_balances.company_code%TYPE

127: )return boolean;
128:
129:
130: FUNCTION CHK_REVAL_ON_RENDER
131: ( p_company_code IN xtr_bank_balances.company_code%TYPE
132: , p_account_number IN xtr_bank_balances.account_number%TYPE
133: , p_currency IN xtr_bank_accounts.currency%TYPE
134: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
135: )return boolean;

Line 132: , p_account_number IN xtr_bank_balances.account_number%TYPE

128:
129:
130: FUNCTION CHK_REVAL_ON_RENDER
131: ( p_company_code IN xtr_bank_balances.company_code%TYPE
132: , p_account_number IN xtr_bank_balances.account_number%TYPE
133: , p_currency IN xtr_bank_accounts.currency%TYPE
134: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
135: )return boolean;
136:

Line 134: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

130: FUNCTION CHK_REVAL_ON_RENDER
131: ( p_company_code IN xtr_bank_balances.company_code%TYPE
132: , p_account_number IN xtr_bank_balances.account_number%TYPE
133: , p_currency IN xtr_bank_accounts.currency%TYPE
134: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
135: )return boolean;
136:
137:
138: FUNCTION CHK_ACCRUAL_ON_RENDER

Line 140: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

136:
137:
138: FUNCTION CHK_ACCRUAL_ON_RENDER
139: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
140: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
141: )return VARCHAR2;
142:
143:
144:

Line 147: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

143:
144:
145: FUNCTION CHK_REVAL_ON_RENDER
146: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
147: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
148: )return VARCHAR2;
149:
150:
151:

Line 153: FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_code%TYPE,

149:
150:
151:
152:
153: FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_code%TYPE,
154: p_account_number IN xtr_bank_balances.account_number%TYPE,
155: p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;
156:
157: FUNCTION CHK_ACCRUAL_INT (

Line 154: p_account_number IN xtr_bank_balances.account_number%TYPE,

150:
151:
152:
153: FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_code%TYPE,
154: p_account_number IN xtr_bank_balances.account_number%TYPE,
155: p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;
156:
157: FUNCTION CHK_ACCRUAL_INT (
158: p_party_code xtr_bank_accounts.party_code%type

Line 155: p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;

151:
152:
153: FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_code%TYPE,
154: p_account_number IN xtr_bank_balances.account_number%TYPE,
155: p_balance_date IN xtr_bank_balances.balance_date%TYPE) RETURN BOOLEAN ;
156:
157: FUNCTION CHK_ACCRUAL_INT (
158: p_party_code xtr_bank_accounts.party_code%type
159: ,p_account_number xtr_bank_accounts.account_number%type

Line 179: ( p_company_code IN xtr_bank_balances.company_code%TYPE,

175: );
176:
177:
178: PROCEDURE UPDATE_BANK_ACCOUNT
179: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
180: p_account_number IN xtr_bank_balances.account_number%TYPE,
181: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
182: p_action_flag IN VARCHAR2,
183: x_return_status OUT NOCOPY VARCHAR2

Line 180: p_account_number IN xtr_bank_balances.account_number%TYPE,

176:
177:
178: PROCEDURE UPDATE_BANK_ACCOUNT
179: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
180: p_account_number IN xtr_bank_balances.account_number%TYPE,
181: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
182: p_action_flag IN VARCHAR2,
183: x_return_status OUT NOCOPY VARCHAR2
184: );

Line 181: p_balance_date IN xtr_bank_balances.balance_date%TYPE,

177:
178: PROCEDURE UPDATE_BANK_ACCOUNT
179: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
180: p_account_number IN xtr_bank_balances.account_number%TYPE,
181: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
182: p_action_flag IN VARCHAR2,
183: x_return_status OUT NOCOPY VARCHAR2
184: );
185:

Line 190: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

186:
187:
188: FUNCTION CHK_INTEREST_SETTLED
189: ( p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
190: , p_balance_date IN xtr_bank_balances.balance_date%TYPE
191: )return VARCHAR2;
192:
193: PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS
194: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

Line 195: ,p_balance_date IN xtr_bank_balances.balance_date%TYPE

191: )return VARCHAR2;
192:
193: PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS
194: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
195: ,p_balance_date IN xtr_bank_balances.balance_date%TYPE
196: ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
197: ,p_interest_calc_balance IN NUMBER
198: ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
199: ,p_action_flag IN VARCHAR2

Line 196: ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null

192:
193: PROCEDURE CHK_ACCRUAL_REVAL_WARNINGS
194: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
195: ,p_balance_date IN xtr_bank_balances.balance_date%TYPE
196: ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
197: ,p_interest_calc_balance IN NUMBER
198: ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
199: ,p_action_flag IN VARCHAR2
200: ,x_return_status OUT NOCOPY VARCHAR2

Line 198: ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE

194: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE
195: ,p_balance_date IN xtr_bank_balances.balance_date%TYPE
196: ,p_ce_bank_account_balance_id IN xtr_bank_balances.ce_bank_account_balance_id%TYPE default null
197: ,p_interest_calc_balance IN NUMBER
198: ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE
199: ,p_action_flag IN VARCHAR2
200: ,x_return_status OUT NOCOPY VARCHAR2
201: ,x_msg_count OUT NOCOPY NUMBER
202: ,x_msg_data OUT NOCOPY VARCHAR2 );