1 package pay_hk_ir56_report AUTHID CURRENT_USER as
2 /* $Header: pyhk56rp.pkh 115.4 2002/12/02 09:20:43 srrajago ship $ */
3 -----------------------------------------------------------------------------
4 -- Program: pay_hk_ir56_report (Package Specification)
5 --
6 -- Description: Various procedures/functions to submit the HK IR56B Year
7 -- End Report.
8 --
9 -- Change History
10 -- Date Changed By Version Description of Change
11 -- --------- ---------- ------- ------------------------------------------
12 -- 05 Jul 01 S. Russell 115.0 Initial Version
13 -- 08 Aug 01 S. Russell 115.1 Put change history in package.
14 -- 12 Nov 01 J. Lin 115.2 Removed global variable g_error,
15 -- bug 2087384
16 -- Added dbdrv line
17 -- 02 Dec 02 srrajago 115.3 Included 'nocopy' option for the 'OUT'
18 -- parameter of the procedure 'range_code'.
19 -- Included dbdrv,checkfile commands too.
20 -----------------------------------------------------------------------------
21
22 -- Global variable.
23
24 level_cnt number;
25
26 --------------------------------------------------------------------
27 -- These are PUBLIC procedures are required by the report process.
28 -- Their names are stored in PAY_REPORT_FORMAT_MAPPINGS_F so that
29 -- the PAR process knows what code to execute for each step of
30 -- the report.
31 --------------------------------------------------------------------
32 procedure range_code
33 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
34 p_sql out nocopy varchar2);
35
36 procedure assignment_action_code
37 (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type,
38 p_start_person_id in per_all_people_f.person_id%type,
39 p_end_person_id in per_all_people_f.person_id%type,
40 p_chunk in number);
41
42 procedure submit_report;
43
44 function get_archive_value
45 (p_archive_name in ff_user_entities.user_entity_name%type,
46 p_assignment_action_id in pay_assignment_actions.assignment_action_id%type)
47 return ff_archive_items.value%type;
48
49 end pay_hk_ir56_report;