42: g_tot_tax_ded_bal_typ_id pay_balance_types.balance_type_id%type;
43: /* End Bug#3004966 */
44: g_index number:=0; /* Bug#3215982 */
45: /* Bug 3034198 */
46: g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%TYPE :=0;
47: /* End bug 3034189 */
48:
49: /*------- Bug# 3193479 ---------------------------------------------------------------*/
50:
91: p_output_tab OUT NOCOPY bal_tab,
92: p_message OUT NOCOPY VARCHAR2 /* Bug#4863149 */
93: );
94: -- TO return the value from plsql table populated by BBR
95: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
94: -- TO return the value from plsql table populated by BBR
95: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
95: function get_bal_value_new(p_defined_balance_id pay_defined_balances.defined_balance_id%TYPE)
96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
96: return number;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
97:
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
98: g_db_id_fbt pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
99: g_db_id_cdep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
100: g_db_id_wgd pay_defined_balances.defined_balance_id%TYPE; /* 4015082 */
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
101: g_db_id_et pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
102: g_db_id_lsad pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
103: g_db_id_lsap pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
104: g_db_id_lsbp pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
105: g_db_id_lsbd pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
106: g_db_id_lsdp pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
107: g_db_id_lsep pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
108: g_db_id_lscp pay_defined_balances.defined_balance_id%TYPE;
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:
109: g_db_id_lscd pay_defined_balances.defined_balance_id%TYPE;
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:
117:
110: g_db_id_ttd pay_defined_balances.defined_balance_id%TYPE;
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:
117:
118:
111: g_db_id_oi pay_defined_balances.defined_balance_id%TYPE;
112: g_db_id_uf pay_defined_balances.defined_balance_id%TYPE;
113: g_db_id_ip pay_defined_balances.defined_balance_id%TYPE;
114: g_db_id_lpm pay_defined_balances.defined_balance_id%TYPE;
115: g_db_id_td pay_defined_balances.defined_balance_id%TYPE;
116:
117:
118:
119: /*--------end of Bug# 3193479---------------------------------------------------------------*/