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.

[Home] [Help]

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 AS
2: /* | $Header: xtrbbals.pls 120.4 2005/07/25 09:53:52 eaggarwa noship $ | */
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: FUNCTION CHK_REVAL ( p_company_code IN xtr_bank_balances.company_code%TYPE
88: , p_account_number IN xtr_bank_balances.account_number%TYPE

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

83: p_field_name IN VARCHAR2 default null,
84: p_balance_date IN xtr_bank_balances.balance_date%type DEFAULT NULL
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

Line 88: , p_account_number IN xtr_bank_balances.account_number%TYPE

84: p_balance_date IN xtr_bank_balances.balance_date%type DEFAULT NULL
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

Line 90: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

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
94: , p_val_type IN VARCHAR2 )

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

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
94: , p_val_type IN VARCHAR2 )
95: RETURN VARCHAR2;

Line 92: , p_balance_cflow IN xtr_bank_balances.balance_cflow%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
94: , p_val_type IN VARCHAR2 )
95: RETURN VARCHAR2;
96:

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

94: , p_val_type IN VARCHAR2 )
95: RETURN VARCHAR2;
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

Line 99: , p_account_number IN xtr_bank_balances.account_number%TYPE

95: RETURN VARCHAR2;
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

Line 101: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

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
105: , p_val_type IN VARCHAR2)

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

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
105: , p_val_type IN VARCHAR2)
106: RETURN VARCHAR2;

Line 109: ( p_company_code IN xtr_bank_balances.company_code%TYPE

105: , p_val_type IN VARCHAR2)
106: RETURN VARCHAR2;
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;

Line 110: , p_account_number IN xtr_bank_balances.account_number%TYPE

106: RETURN VARCHAR2;
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:

Line 112: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

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:
116: FUNCTION CHK_REVAL_ON_RENDER

Line 117: ( p_company_code IN xtr_bank_balances.company_code%TYPE

113: )return boolean;
114:
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;

Line 118: , p_account_number IN xtr_bank_balances.account_number%TYPE

114:
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:

Line 120: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

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:
124: FUNCTION CHK_ACCRUAL_ON_RENDER

Line 126: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

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:
130:

Line 133: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

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:
137:

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

135:
136:
137:
138:
139: FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_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 (

Line 140: p_account_number IN xtr_bank_balances.account_number%TYPE,

136:
137:
138:
139: FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_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

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

137:
138:
139: FUNCTION CHK_ROUNDING_CHANGE ( p_company_code IN xtr_bank_balances.company_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

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

161: );
162:
163:
164: PROCEDURE UPDATE_BANK_ACCOUNT
165: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
166: p_account_number IN xtr_bank_balances.account_number%TYPE,
167: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
168: p_action_flag IN VARCHAR2,
169: x_return_status OUT NOCOPY VARCHAR2

Line 166: p_account_number IN xtr_bank_balances.account_number%TYPE,

162:
163:
164: PROCEDURE UPDATE_BANK_ACCOUNT
165: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
166: p_account_number IN xtr_bank_balances.account_number%TYPE,
167: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
168: p_action_flag IN VARCHAR2,
169: x_return_status OUT NOCOPY VARCHAR2
170: );

Line 167: p_balance_date IN xtr_bank_balances.balance_date%TYPE,

163:
164: PROCEDURE UPDATE_BANK_ACCOUNT
165: ( p_company_code IN xtr_bank_balances.company_code%TYPE,
166: p_account_number IN xtr_bank_balances.account_number%TYPE,
167: p_balance_date IN xtr_bank_balances.balance_date%TYPE,
168: p_action_flag IN VARCHAR2,
169: x_return_status OUT NOCOPY VARCHAR2
170: );
171:

Line 176: , p_balance_date IN xtr_bank_balances.balance_date%TYPE

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
180: (p_ce_bank_account_id IN xtr_bank_accounts.ce_bank_account_id%TYPE

Line 181: ,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
185: ,p_action_flag IN VARCHAR2

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

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
185: ,p_action_flag IN VARCHAR2
186: ,x_return_status OUT NOCOPY VARCHAR2

Line 184: ,p_balance_cflow IN xtr_bank_balances.balance_cflow%TYPE

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
185: ,p_action_flag IN VARCHAR2
186: ,x_return_status OUT NOCOPY VARCHAR2
187: ,x_msg_count OUT NOCOPY NUMBER
188: ,x_msg_data OUT NOCOPY VARCHAR2 );