1 package pay_hk_ir56
2 /* $Header: pyhkir56.pkh 120.1 2005/12/13 20:12:41 snimmala noship $
3 **
4 ** Copyright (C) 2001 Oracle Corporation
5 ** All Rights Reserved
6 **
7 ** Change List
8 **
9 ** Date Author Bug Ver Description
10 ** ===============================================================================
11 ** 06-MAR-2001 sclarke N/A 115.0 Created
12 ** 02-DEC-2002 srrajago 2689229 115.1 Included 'nocopy' option in all 'OUT' parameters of the procedure get_emoluments.
13 ** 12-DEC-2003 srrajago 3193217 115.2 Modified the 'get_emoluments' function. Included record type g_emol_details_rec,
14 ** declaration of g_balance_value_tab and a new procedure 'populate_defined_balance_ids'.
15 ** 14-Dec-2005 snimmala 4864213 115.6 Added a new function get_quarters_start_date and AUTHID CURRENT_USER is used in the view
16 ** pay_hk_ir56_quarters_info_v.
17 */
18 as
19
20 TYPE g_emol_details_rec IS RECORD
21 ( balance_name pay_balance_types.balance_name%TYPE
22 , balance_value number
23 , period_dates varchar2(23)
24 , particulars hr_lookups.description%TYPE);
25
26 TYPE g_emol_details_tab IS TABLE OF g_emol_details_rec INDEX BY BINARY_INTEGER;
27
28 g_emol_details g_emol_details_tab;
29
30 FUNCTION get_emoluments
31 ( p_assignment_id in per_assignments_f.assignment_id%TYPE
32 , p_assignment_action_id in pay_assignment_actions.assignment_action_id%TYPE
33 , p_tax_unit_id in pay_assignment_actions.tax_unit_id%TYPE
34 , p_reporting_year in number) RETURN g_emol_details_tab;
35
36 g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
37
38 PROCEDURE populate_defined_balance_ids;
39
40 function get_tax_year_start
41 (p_assignment_id in number
42 ,p_calculation_date in date
43 ) return date;
44
45 /*
46 * Bug 4864213 - Added the following function get_quarters_start_date to return the quaters start date
47 */
48
49 function get_quarters_start_date
50 (p_assignment_id in per_assignments_f.assignment_id%TYPE,
51 p_source_id in pay_hk_ir56_quarters_actions_v.l_source_id%TYPE)
52 return DATE;
53
54 end pay_hk_ir56;