50: g_tot_tax_ded_bal_typ_id pay_balance_types.balance_type_id%type;
51: /* End Bug#3004966 */
52: g_index number:=0; /* Bug#3215982 */
53: /* Bug 3034198 */
54: g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%TYPE :=0;
55: /* End bug 3034189 */
56:
57: /*------- Bug# 3193479 ---------------------------------------------------------------*/
58:
125: --, p_message OUT NOCOPY VARCHAR2); /* bug 7571001 - removed the parameter */
126: );
127:
128: -- TO return the value from plsql table populated by BBR
129: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
130: return number;
131:
132: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
133: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
128: -- TO return the value from plsql table populated by BBR
129: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
130: return number;
131:
132: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
133: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
134: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
129: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
130: return number;
131:
132: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
133: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
134: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
130: return number;
131:
132: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
133: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
134: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
131:
132: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
133: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
134: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
132: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
133: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
134: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
133: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
134: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
134: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
135: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
136: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
137: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
138: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
139: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
140: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
141: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
149: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
142: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
149: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
150: /*Begin 8587013 - Added global variables to hold the values of RESC and Exempt Foreign Employment Income balances*/
143: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
149: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
150: /*Begin 8587013 - Added global variables to hold the values of RESC and Exempt Foreign Employment Income balances*/
151: g_db_id_resc pay_defined_balances.defined_balance_id%TYPE;
144: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
149: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
150: /*Begin 8587013 - Added global variables to hold the values of RESC and Exempt Foreign Employment Income balances*/
151: g_db_id_resc pay_defined_balances.defined_balance_id%TYPE;
152: g_db_id_efei pay_defined_balances.defined_balance_id%TYPE;
145: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
146: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
149: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
150: /*Begin 8587013 - Added global variables to hold the values of RESC and Exempt Foreign Employment Income balances*/
151: g_db_id_resc pay_defined_balances.defined_balance_id%TYPE;
152: g_db_id_efei pay_defined_balances.defined_balance_id%TYPE;
153: /*End 8587013*/
147: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
149: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
150: /*Begin 8587013 - Added global variables to hold the values of RESC and Exempt Foreign Employment Income balances*/
151: g_db_id_resc pay_defined_balances.defined_balance_id%TYPE;
152: g_db_id_efei pay_defined_balances.defined_balance_id%TYPE;
153: /*End 8587013*/
154: /* Start 8769345 */
155: g_db_id_tftn pay_defined_balances.defined_balance_id%TYPE;
148: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
149: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
150: /*Begin 8587013 - Added global variables to hold the values of RESC and Exempt Foreign Employment Income balances*/
151: g_db_id_resc pay_defined_balances.defined_balance_id%TYPE;
152: g_db_id_efei pay_defined_balances.defined_balance_id%TYPE;
153: /*End 8587013*/
154: /* Start 8769345 */
155: g_db_id_tftn pay_defined_balances.defined_balance_id%TYPE;
156: g_db_id_tftp pay_defined_balances.defined_balance_id%TYPE;
151: g_db_id_resc pay_defined_balances.defined_balance_id%TYPE;
152: g_db_id_efei pay_defined_balances.defined_balance_id%TYPE;
153: /*End 8587013*/
154: /* Start 8769345 */
155: g_db_id_tftn pay_defined_balances.defined_balance_id%TYPE;
156: g_db_id_tftp pay_defined_balances.defined_balance_id%TYPE;
157: g_db_id_tfln pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
152: g_db_id_efei pay_defined_balances.defined_balance_id%TYPE;
153: /*End 8587013*/
154: /* Start 8769345 */
155: g_db_id_tftn pay_defined_balances.defined_balance_id%TYPE;
156: g_db_id_tftp pay_defined_balances.defined_balance_id%TYPE;
157: g_db_id_tfln pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
160: g_db_id_ttp pay_defined_balances.defined_balance_id%TYPE;
153: /*End 8587013*/
154: /* Start 8769345 */
155: g_db_id_tftn pay_defined_balances.defined_balance_id%TYPE;
156: g_db_id_tftp pay_defined_balances.defined_balance_id%TYPE;
157: g_db_id_tfln pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
160: g_db_id_ttp pay_defined_balances.defined_balance_id%TYPE;
161: g_db_id_tln pay_defined_balances.defined_balance_id%TYPE;
154: /* Start 8769345 */
155: g_db_id_tftn pay_defined_balances.defined_balance_id%TYPE;
156: g_db_id_tftp pay_defined_balances.defined_balance_id%TYPE;
157: g_db_id_tfln pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
160: g_db_id_ttp pay_defined_balances.defined_balance_id%TYPE;
161: g_db_id_tln pay_defined_balances.defined_balance_id%TYPE;
162: g_db_id_tlp pay_defined_balances.defined_balance_id%TYPE;
155: g_db_id_tftn pay_defined_balances.defined_balance_id%TYPE;
156: g_db_id_tftp pay_defined_balances.defined_balance_id%TYPE;
157: g_db_id_tfln pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
160: g_db_id_ttp pay_defined_balances.defined_balance_id%TYPE;
161: g_db_id_tln pay_defined_balances.defined_balance_id%TYPE;
162: g_db_id_tlp pay_defined_balances.defined_balance_id%TYPE;
163: /* End 8769345 */
156: g_db_id_tftp pay_defined_balances.defined_balance_id%TYPE;
157: g_db_id_tfln pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
160: g_db_id_ttp pay_defined_balances.defined_balance_id%TYPE;
161: g_db_id_tln pay_defined_balances.defined_balance_id%TYPE;
162: g_db_id_tlp pay_defined_balances.defined_balance_id%TYPE;
163: /* End 8769345 */
164: /* Start 8711855 */
157: g_db_id_tfln pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
160: g_db_id_ttp pay_defined_balances.defined_balance_id%TYPE;
161: g_db_id_tln pay_defined_balances.defined_balance_id%TYPE;
162: g_db_id_tlp pay_defined_balances.defined_balance_id%TYPE;
163: /* End 8769345 */
164: /* Start 8711855 */
165: g_db_id_rll pay_defined_balances.defined_balance_id%TYPE;
158: g_db_id_tflp pay_defined_balances.defined_balance_id%TYPE;
159: g_db_id_ttn pay_defined_balances.defined_balance_id%TYPE;
160: g_db_id_ttp pay_defined_balances.defined_balance_id%TYPE;
161: g_db_id_tln pay_defined_balances.defined_balance_id%TYPE;
162: g_db_id_tlp pay_defined_balances.defined_balance_id%TYPE;
163: /* End 8769345 */
164: /* Start 8711855 */
165: g_db_id_rll pay_defined_balances.defined_balance_id%TYPE;
166: g_db_id_res pay_defined_balances.defined_balance_id%TYPE;
161: g_db_id_tln pay_defined_balances.defined_balance_id%TYPE;
162: g_db_id_tlp pay_defined_balances.defined_balance_id%TYPE;
163: /* End 8769345 */
164: /* Start 8711855 */
165: g_db_id_rll pay_defined_balances.defined_balance_id%TYPE;
166: g_db_id_res pay_defined_balances.defined_balance_id%TYPE;
167: g_db_id_rpt pay_defined_balances.defined_balance_id%TYPE;
168: /* End 8711855 */
169:
162: g_db_id_tlp pay_defined_balances.defined_balance_id%TYPE;
163: /* End 8769345 */
164: /* Start 8711855 */
165: g_db_id_rll pay_defined_balances.defined_balance_id%TYPE;
166: g_db_id_res pay_defined_balances.defined_balance_id%TYPE;
167: g_db_id_rpt pay_defined_balances.defined_balance_id%TYPE;
168: /* End 8711855 */
169:
170: /* Start Bug 10331262 */
163: /* End 8769345 */
164: /* Start 8711855 */
165: g_db_id_rll pay_defined_balances.defined_balance_id%TYPE;
166: g_db_id_res pay_defined_balances.defined_balance_id%TYPE;
167: g_db_id_rpt pay_defined_balances.defined_balance_id%TYPE;
168: /* End 8711855 */
169:
170: /* Start Bug 10331262 */
171:
168: /* End 8711855 */
169:
170: /* Start Bug 10331262 */
171:
172: g_db_id_flp pay_defined_balances.defined_balance_id%TYPE;
173: g_db_id_flpm pay_defined_balances.defined_balance_id%TYPE;
174: g_db_id_flsap pay_defined_balances.defined_balance_id%TYPE;
175: g_db_id_flcd pay_defined_balances.defined_balance_id%TYPE;
176: g_db_id_flsad pay_defined_balances.defined_balance_id%TYPE;
169:
170: /* Start Bug 10331262 */
171:
172: g_db_id_flp pay_defined_balances.defined_balance_id%TYPE;
173: g_db_id_flpm pay_defined_balances.defined_balance_id%TYPE;
174: g_db_id_flsap pay_defined_balances.defined_balance_id%TYPE;
175: g_db_id_flcd pay_defined_balances.defined_balance_id%TYPE;
176: g_db_id_flsad pay_defined_balances.defined_balance_id%TYPE;
177:
170: /* Start Bug 10331262 */
171:
172: g_db_id_flp pay_defined_balances.defined_balance_id%TYPE;
173: g_db_id_flpm pay_defined_balances.defined_balance_id%TYPE;
174: g_db_id_flsap pay_defined_balances.defined_balance_id%TYPE;
175: g_db_id_flcd pay_defined_balances.defined_balance_id%TYPE;
176: g_db_id_flsad pay_defined_balances.defined_balance_id%TYPE;
177:
178: /* End Bug 10331262 */
171:
172: g_db_id_flp pay_defined_balances.defined_balance_id%TYPE;
173: g_db_id_flpm pay_defined_balances.defined_balance_id%TYPE;
174: g_db_id_flsap pay_defined_balances.defined_balance_id%TYPE;
175: g_db_id_flcd pay_defined_balances.defined_balance_id%TYPE;
176: g_db_id_flsad pay_defined_balances.defined_balance_id%TYPE;
177:
178: /* End Bug 10331262 */
179:
172: g_db_id_flp pay_defined_balances.defined_balance_id%TYPE;
173: g_db_id_flpm pay_defined_balances.defined_balance_id%TYPE;
174: g_db_id_flsap pay_defined_balances.defined_balance_id%TYPE;
175: g_db_id_flcd pay_defined_balances.defined_balance_id%TYPE;
176: g_db_id_flsad pay_defined_balances.defined_balance_id%TYPE;
177:
178: /* End Bug 10331262 */
179:
180: g_db_id_rea pay_defined_balances.defined_balance_id%TYPE; -- bug 13362286
176: g_db_id_flsad pay_defined_balances.defined_balance_id%TYPE;
177:
178: /* End Bug 10331262 */
179:
180: g_db_id_rea pay_defined_balances.defined_balance_id%TYPE; -- bug 13362286
181:
182: /*--------end of Bug# 3193479---------------------------------------------------------------*/
183:
184: