DBA Data[Home] [Help]

APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_AU_PAYMENT_SUMMARY

Line 1: package body pay_au_payment_summary as

1: package body pay_au_payment_summary as
2: /* $Header: pyaupsp.pkb 120.93.12020000.5 2012/12/07 03:07:55 skshin ship $*/
3: /*
4: *** ------------------------------------------------------------------------+
5: *** Program: pay_au_payment_summary (Package Body)

Line 5: *** Program: pay_au_payment_summary (Package Body)

1: package body pay_au_payment_summary as
2: /* $Header: pyaupsp.pkb 120.93.12020000.5 2012/12/07 03:07:55 skshin ship $*/
3: /*
4: *** ------------------------------------------------------------------------+
5: *** Program: pay_au_payment_summary (Package Body)
6: ***
7: *** Change History
8: ***
9: *** Date Changed By Version Description of Change

Line 290: g_package constant varchar2(30) := 'pay_au_payment_summary';

286: *** -------------------------------------------------------------------------------------------------------+
287: */
288: g_debug boolean;
289: g_business_group_id number;
290: g_package constant varchar2(30) := 'pay_au_payment_summary';
291: g_legislation_code constant varchar2(2) := 'AU';
292: g_dimension_id pay_balance_dimensions.balance_dimension_id%type;
293: g_balance_type_id pay_balance_types.balance_type_id%type; /*Bug#5591993*/
294: g_fbt_threshold ff_globals_f.global_value%TYPE ; /* Bug 5708255 */

Line 322: p_all_dbi_tab pay_au_payment_summary_amend.archive_db_tab ;

318: p_etp_context_table pay_balance_pkg.t_context_tab;
319: p_etp_result_table pay_balance_pkg.t_detailed_bal_out_tab;
320:
321: /* Bug 6470581 - PL/SQL table to hold Archive Items when submitted for Amended payment summary */
322: p_all_dbi_tab pay_au_payment_summary_amend.archive_db_tab ;
323:
324: /* start bug 9147430 */
325: -- Foreign Worker status check global variables
326: g_fw_check varchar2(1);

Line 2528: v_lump_sum_E_ytd := pay_au_payment_summary.get_lumpsumE_value(p_registered_employer, p_assignment_id, p_year_start,

2524:
2525: /* Bug 9190980 - Added argument v_adj_lump_sum_pre_tax in the function call for fetching Retro GT12 Pre Tax deduction after Lump Sum Adjestment */
2526: if v_lump_sum_E_ytd <> 0 then
2527:
2528: v_lump_sum_E_ytd := pay_au_payment_summary.get_lumpsumE_value(p_registered_employer, p_assignment_id, p_year_start,
2529: p_year_end, p_lump_sum_E_ptd_tab, v_lump_sum_E_ytd, v_adj_lump_sum_E_ptd,v_adj_lump_sum_pre_tax);
2530: end if;
2531:
2532: /* The following logic makes sure that more than 400 Lump Sum E values are relfected in Lump Sum E archive */

Line 3634: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id

3630: /* start bug 9950136 */
3631: l_retro_fw_gross := 0;
3632: l_retro_fw_tax := 0;
3633: IF t_fw_gross_type(i_idx) = 'F' THEN
3634: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id
3635: ,p_registered_employer
3636: ,p_year_start
3637: ,p_year_end
3638: ,pay_au_foreign_workers.g_fw_f_type

Line 3642: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id, p_registered_employer, p_year_start, p_year_end, pay_au_foreign_workers.g_fw_j_type,

3638: ,pay_au_foreign_workers.g_fw_f_type
3639: ,l_retro_fw_gross
3640: ,l_retro_fw_tax);
3641: ELSIF t_fw_gross_type(i_idx) = 'J' THEN
3642: n := pay_au_payment_summary.adjust_retro_fw(p_assignment_id, p_registered_employer, p_year_start, p_year_end, pay_au_foreign_workers.g_fw_j_type,
3643: l_retro_fw_gross, l_retro_fw_tax);
3644: END IF;
3645:
3646:

Line 9302: pay_au_payment_summary_amend.modify_and_archive_code

9298:
9299: IF g_payment_summary_type = 'A'
9300: THEN
9301:
9302: pay_au_payment_summary_amend.modify_and_archive_code
9303: (p_assignment_action_id => p_assignment_action_id
9304: ,p_effective_date => p_effective_date
9305: ,p_all_tab_new => p_all_dbi_tab);
9306:

Line 9783: end pay_au_payment_summary;

9779: return 0;
9780:
9781: end adjust_retro_fw;
9782:
9783: end pay_au_payment_summary;