43: g_fps_bal_det_tab t_fps_bal_det_tab;
44: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
45: g_fps_ni_bal_det_tab t_fps_bal_det_tab;
46: g_fps_ni_aggr_bal_det_tab t_fps_bal_det_tab;
47: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
48: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
49: g_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni normal balances
50: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
51: --
44: g_fps_aggr_bal_det_tab t_fps_bal_det_tab;
45: g_fps_ni_bal_det_tab t_fps_bal_det_tab;
46: g_fps_ni_aggr_bal_det_tab t_fps_bal_det_tab;
47: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
48: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
49: g_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni normal balances
50: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
51: --
52:
45: g_fps_ni_bal_det_tab t_fps_bal_det_tab;
46: g_fps_ni_aggr_bal_det_tab t_fps_bal_det_tab;
47: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
48: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
49: g_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni normal balances
50: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
51: --
52:
53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
46: g_fps_ni_aggr_bal_det_tab t_fps_bal_det_tab;
47: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances
48: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances
49: g_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni normal balances
50: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances
51: --
52:
53: g_nia_lel_id pay_defined_balances.defined_balance_id%TYPE;
54: g_nia_et_id pay_defined_balances.defined_balance_id%TYPE;
922: p_effective_date IN DATE,
923: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
924: RETURN BOOLEAN
925: IS
926: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
927: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
928: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_asg_det2';
929:
930: l_asg_primary_flag VARCHAR2(1);
923: p_fps_bal_context_2 IN OUT nocopy act_info_rec )
924: RETURN BOOLEAN
925: IS
926: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
927: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
928: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_asg_det2';
929:
930: l_asg_primary_flag VARCHAR2(1);
931: l_per_agg_flag VARCHAR2(1);
1031:
1032: hr_utility.trace('l_aggr_archive_flag '||l_aggr_archive_flag);
1033:
1034: if l_tax_pay_val = 0 then
1035: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
1036: p_defined_balance_lst => g_aggr_defined_balance_lst ,
1037: p_context_lst => l_context_lst ,
1038: p_output_table => l_output_table );
1039: else
1036: p_defined_balance_lst => g_aggr_defined_balance_lst ,
1037: p_context_lst => l_context_lst ,
1038: p_output_table => l_output_table );
1039: else
1040: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
1041: p_defined_balance_lst => g_aggr_defined_balance_lst ,
1042: p_context_lst => l_context_lst ,
1043: p_output_table => l_output_table );
1044: end if;
1046:
1047: hr_utility.trace('l_aggr_archive_flag '||l_aggr_archive_flag);
1048:
1049: if l_tax_pay_val = 0 then
1050: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
1051: p_defined_balance_lst => g_defined_balance_lst ,
1052: p_context_lst => l_context_lst ,
1053: p_output_table => l_output_table );
1054: else
1051: p_defined_balance_lst => g_defined_balance_lst ,
1052: p_context_lst => l_context_lst ,
1053: p_output_table => l_output_table );
1054: else
1055: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
1056: p_defined_balance_lst => g_defined_balance_lst ,
1057: p_context_lst => l_context_lst ,
1058: p_output_table => l_output_table );
1059: end if;
1223: p_effective_date IN DATE,
1224: l_archive_tab_ni_det OUT nocopy action_info_table )
1225: RETURN BOOLEAN
1226: IS
1227: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
1228: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
1229: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_ni_det';
1230: l_asg_primary_flag VARCHAR2(1);
1231: l_per_agg_flag VARCHAR2(1);
1224: l_archive_tab_ni_det OUT nocopy action_info_table )
1225: RETURN BOOLEAN
1226: IS
1227: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval
1228: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval
1229: l_proc CONSTANT VARCHAR2(50):= g_package||'fetch_ni_det';
1230: l_asg_primary_flag VARCHAR2(1);
1231: l_per_agg_flag VARCHAR2(1);
1232: l_aggr_archive_flag VARCHAR2(1);
1461: end if;
1462:
1463: if NVL(l_aggr_archive_flag,'N') = 'Y' then
1464: if l_tax_pay_val = 0 then
1465: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
1466: p_defined_balance_lst => g_aggr_defined_balance_lst_ni ,
1467: p_context_lst => l_context_lst ,
1468: p_output_table => l_output_table );
1469: else
1466: p_defined_balance_lst => g_aggr_defined_balance_lst_ni ,
1467: p_context_lst => l_context_lst ,
1468: p_output_table => l_output_table );
1469: else
1470: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
1471: p_defined_balance_lst => g_aggr_defined_balance_lst_ni ,
1472: p_context_lst => l_context_lst ,
1473: p_output_table => l_output_table );
1474: end if;
1474: end if;
1475:
1476: else
1477: if l_tax_pay_val = 0 then
1478: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,
1479: p_defined_balance_lst => g_defined_balance_lst_ni ,
1480: p_context_lst => l_context_lst ,
1481: p_output_table => l_output_table );
1482: else
1479: p_defined_balance_lst => g_defined_balance_lst_ni ,
1480: p_context_lst => l_context_lst ,
1481: p_output_table => l_output_table );
1482: else
1483: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_id ,
1484: p_defined_balance_lst => g_defined_balance_lst_ni ,
1485: p_context_lst => l_context_lst ,
1486: p_output_table => l_output_table );
1487: end if;
6159:
6160: --Footer Validations
6161: footer_validations(l_payroll_rec.econ_number,l_flag);
6162:
6163: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
6164: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
6165: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
6166: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
6167: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);