[Home] [Help]
74: -----------
75: PL/SQL Tables used :
76: ------------------
77: 1) t_eb_bal_context_tab - This is the pl/sql table that holds the context data that is required
78: to fetch the balance values using the pay_balance_pkg package.
79:
80: 2) t_eb_bal_result_tab - This is the pl/sql table which is passed to the pay_balance_pkg
81: package which will hold the retrieved balance values along with the
82: respective defined balance ids.
76: ------------------
77: 1) t_eb_bal_context_tab - This is the pl/sql table that holds the context data that is required
78: to fetch the balance values using the pay_balance_pkg package.
79:
80: 2) t_eb_bal_result_tab - This is the pl/sql table which is passed to the pay_balance_pkg
81: package which will hold the retrieved balance values along with the
82: respective defined balance ids.
83:
84: 3) t_eb_balance_value_tab - This is the pl/sql table that holds the defined balance ids for
82: respective defined balance ids.
83:
84: 3) t_eb_balance_value_tab - This is the pl/sql table that holds the defined balance ids for
85: which the balance values are to be bulk fetched using the
86: pay_balance_pkg package.
87:
88: 4) t_earnings_tab - This is the pl/sql table that holds the details of the earning type elements
89: along with the primary balance type id for which the balance values are to
90: be fetched.
218: displayed in the Results Region.
219: ********************************************************************************************/
220:
221: l_package VARCHAR2(30) := 'pay_ip_employee_balances.';
222: t_eb_bal_context_tab pay_balance_pkg.t_context_tab;
223: t_eb_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
224: t_eb_balance_value_tab pay_balance_pkg.t_balance_value_tab;
225:
226: t_earnings_tab earn_tbl;
219: ********************************************************************************************/
220:
221: l_package VARCHAR2(30) := 'pay_ip_employee_balances.';
222: t_eb_bal_context_tab pay_balance_pkg.t_context_tab;
223: t_eb_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
224: t_eb_balance_value_tab pay_balance_pkg.t_balance_value_tab;
225:
226: t_earnings_tab earn_tbl;
227: t_deduction_tab dedn_tbl;
220:
221: l_package VARCHAR2(30) := 'pay_ip_employee_balances.';
222: t_eb_bal_context_tab pay_balance_pkg.t_context_tab;
223: t_eb_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
224: t_eb_balance_value_tab pay_balance_pkg.t_balance_value_tab;
225:
226: t_earnings_tab earn_tbl;
227: t_deduction_tab dedn_tbl;
228:
999: hr_utility.set_location(l_package||l_function,120);
1000:
1001: -- set TAX_UNIT_ID context
1002: IF p_tax_unit_id <> -1 THEN
1003: pay_balance_pkg.set_context ('TAX_UNIT_ID', TO_CHAR(p_tax_unit_id));
1004: END IF;
1005:
1006: hr_utility.trace('p_defbal_id: '||to_char(p_defbal_id));
1007: hr_utility.trace('l_temp_assignment_id: '||to_char(l_temp_assignment_id));
1009:
1010: IF l_date <> to_date('31-12-4712','DD-MM-YYYY') THEN
1011: hr_utility.set_location(l_package||l_function, 130);
1012:
1013: l_value := pay_balance_pkg.get_value_lock( p_defined_balance_id => p_defbal_id,
1014: p_assignment_id => l_temp_assignment_id,
1015: p_virtual_date => l_date,
1016: p_asg_lock => 'N' );
1017:
1226: the balance values are supposed to be fetched. These defined balance ids are identified
1227: using the Defined Balance Type stored in t_defbal_details_tab and the dimension option
1228: selected at the SS Page level that are passed to the current package. The selected defined
1229: balance ids are stored in the pl/sql table t_eb_balance_value_tab which is later passed to
1230: the pay_balance_pkg to bulk fetch the balance values.
1231: */
1232:
1233: j:=1;
1234: FOR i IN t_defbal_details_tab.first..t_defbal_details_tab.last
1245: (t_defbal_details_tab(i).defbal_type IN ('_PER_TQTD','_PER_TU_TQTD') AND p_per_qtd = 1) OR
1246: (t_defbal_details_tab(i).defbal_type IN ('_PER_TYTD','_PER_TU_TYTD') AND p_per_ytd = 1)
1247: THEN
1248: t_eb_balance_value_tab(j).defined_balance_id:=t_defbal_details_tab(i).def_bal_id;
1249: hr_utility.trace('Defined Balance id to be sent to pay_balance_pkg is '||to_char(t_eb_balance_value_tab(j).defined_balance_id));
1250: j:=j+1;
1251: END IF;
1252: END IF;
1253: END LOOP;
1251: END IF;
1252: END IF;
1253: END LOOP;
1254:
1255: /*The following is the pay_balance_pkg call to bulk fetch the balance values.
1256: We pass the assignment action id for the current Quick pay or Payroll Run,
1257: t_eb_balance_value_tab pl/sql table with the required defined balance ids,
1258: t_eb_bal_context_tab pl/sql table with the balance context values,
1259: t_eb_bal_result_tab emplty pl/sql table that will hold the balance values
1256: We pass the assignment action id for the current Quick pay or Payroll Run,
1257: t_eb_balance_value_tab pl/sql table with the required defined balance ids,
1258: t_eb_bal_context_tab pl/sql table with the balance context values,
1259: t_eb_bal_result_tab emplty pl/sql table that will hold the balance values
1260: along with the defined balance ids as parameters to the pay_balance_pkg call.
1261: */
1262: hr_utility.set_location(l_package||l_function, 150);
1263: pay_balance_pkg.get_value
1264: (p_assignment_action_id => p_assignment_action_id
1259: t_eb_bal_result_tab emplty pl/sql table that will hold the balance values
1260: along with the defined balance ids as parameters to the pay_balance_pkg call.
1261: */
1262: hr_utility.set_location(l_package||l_function, 150);
1263: pay_balance_pkg.get_value
1264: (p_assignment_action_id => p_assignment_action_id
1265: ,p_defined_balance_lst => t_eb_balance_value_tab
1266: ,p_context_lst => t_eb_bal_context_tab
1267: ,p_output_table => t_eb_bal_result_tab