1 package pay_au_payment_summary AUTHID CURRENT_USER as
2 /* $Header: pyaupsp.pkh 120.7 2010/12/06 14:09:46 avenkatk noship $ */
3
4 level_cnt number;
5 pkg_lump_sum_c_def_bal_id number;
6 g_fbt_defined_balance_id pay_defined_balances.defined_balance_id%type;
7 --
8 type r_allowance_bal is record (balance_name pay_balance_types.balance_name%type, balance_value number);
9 type tab_allownace_balance is table of r_allowance_bal index by binary_integer;
10 t_allowance_balance tab_allownace_balance;
11 t_union_table tab_allownace_balance;
12 --
13
14 /* Bug 6470581 - Added the payment summary type global variable */
15 g_payment_summary_type VARCHAR2(10);
16
17 function adjust_retro_allowances
18 (t_allowance_balance in out nocopy tab_allownace_balance
19 ,p_year_start in date
20 ,p_year_end in date
21 ,p_assignment_id in pay_assignment_actions.assignment_id%type
22 ,p_registered_employer in number --2610141
23 )
24 return number;
25 --
26 --------------------------------------------------------------------
27 -- These are PUBLIC procedures are required by the Archive process.
28 -- There names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
29 -- the archive process knows what code to execute for each step of
30 -- the archive.
31 --------------------------------------------------------------------
32 --
33 --------------------------------------------------------------------
34 -- This procedure returns a sql string to select a range
35 -- of assignments eligible for archival.
36 --------------------------------------------------------------------
37 --
38 procedure range_code
39 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
40 p_sql out nocopy varchar2);
41 --
42 --------------------------------------------------------------------
43 -- This procedure is used to set global contexts
44 -- however in current case it is a dummy procedure. In case this
45 -- procedure is not present then archiver assumes that
46 -- no archival is required.
47 --------------------------------------------------------------------
48 --
49 procedure initialization_code
50 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
51 --
52 --------------------------------------------------------------------
53 -- This procedure further restricts the assignment_id's
54 -- returned by range_code
55 --------------------------------------------------------------------
56 --
57 procedure assignment_action_code
58 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
59 p_start_person_id in per_all_people_f.person_id%type,
60 p_end_person_id in per_all_people_f.person_id%type,
61 p_chunk in number);
62
63
64 --------------------------------------------------------------------
65 -- This procedure is actually used to archive data . It
66 -- internally calls private procedures to archive balances ,
67 -- employee details, employer details and supplier details .
68 --------------------------------------------------------------------
69 procedure archive_code
70 (p_assignment_action_id in pay_assignment_actions.assignment_action_id%type,
71 p_effective_date in date);
72
73
74
75 --------------------------------------------------------------------
76 -- These procedures are used by validation report
77 -- Called from
78 -- PYAUPSVR.rdf
79 -- PYAUPSSP.rdf
80 -- PYAUPSET.rdf
81
82 --------------------------------------------------------------------
83 -- This function is used to get end of year values for archive items
84 --------------------------------------------------------------------
85
86 function get_archive_value(p_user_entity_name in ff_user_entities.user_entity_name%type,
87 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
88 return varchar2;
89
90 procedure spawn_data_file -- (Bug 3132178) Created to call magtape process
91 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type);
92
93 /*bug8711855 - this function returns sum of other lump sum e balances
94 The function is called in pay_au_payment_summary, pay_au_recon_summary, pay_au_rec_det_paysum_mode package*/
95 /*Bug 9190980 - Added argument p_adj_lump_sum_pre_tax to get_lumpsumE_value function */
96 function get_lumpsumE_value
97 (p_registered_employer in NUMBER
98 ,p_assignment_id in pay_assignment_actions.ASSIGNMENT_ID%type
99 ,p_year_start in DATE
100 ,p_year_end in DATE
101 ,p_lump_sum_E_ptd_tab in pay_balance_pkg.t_balance_value_tab
102 ,p_lump_sum_E_ytd in number
103 ,p_adj_lump_sum_E_ptd out nocopy number
104 ,p_adj_lump_sum_pre_tax out nocopy NUMBER) return number;
105
106
107 /* bug10216064 FW retro adjustmnet */
108 function adjust_retro_fw
109 (p_assignment_id IN per_assignments_f.assignment_id%TYPE
110 ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
111 ,p_start_date in date
112 ,p_end_date in date
113 ,p_fw_type in varchar2
114 ,p_retro_fw_gross out nocopy number
115 ,p_retro_fw_tax out nocopy number) return number;
116
117 /* Bug 10331262 Added new procedure */
118 PROCEDURE get_foreign_leave_payments
119 (p_assignment_id IN pay_assignment_actions.assignment_id%TYPE
120 ,p_tax_unit_id IN pay_assignment_actions.tax_unit_id%TYPE
121 ,p_start_date IN DATE
122 ,p_end_date IN DATE
123 ,p_leave_earnings OUT NOCOPY NUMBER
124 ,p_leave_tax OUT NOCOPY NUMBER
125 );
126
127 end pay_au_payment_summary;