DBA Data[Home] [Help]

APPS.PAY_GB_RTI_EYU dependencies on PAY_BALANCE_PKG

Line 47: g_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of normal balances

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

Line 48: g_aggr_defined_balance_lst pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of aggregation balances

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:

Line 49: g_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni normal balances

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;

Line 50: g_aggr_defined_balance_lst_ni pay_balance_pkg.t_balance_value_tab; -- used for batch balance retrieval of ni aggregation balances

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;

Line 926: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

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);

Line 927: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

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);

Line 1035: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,

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

Line 1040: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_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
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;

Line 1050: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,

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

Line 1055: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_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
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;

Line 1227: l_context_lst pay_balance_pkg.t_context_tab; -- used for batch balance retrieval

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);

Line 1228: l_output_table pay_balance_pkg.t_detailed_bal_out_tab; -- output of batch balance retrieval

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);

Line 1465: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,

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

Line 1470: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_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
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;

Line 1478: pay_balance_pkg.get_value(p_assignment_action_id => l_last_chld_act_id,

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

Line 1483: pay_balance_pkg.get_value(p_assignment_action_id => p_last_asg_action_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
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;

Line 6163: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);

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);