1 PACKAGE PAY_KW_PIFSS_REPORT AS
2 /* $Header: pykwpifn.pkh 120.0.12000000.1 2007/01/17 22:29:51 appldev noship $ */
3 --
4 TYPE NEWRec IS RECORD(person_id number);
5 TYPE tTable IS TABLE OF NEWRec INDEX BY BINARY_INTEGER;
6 vNEWTable tTable;
7 vTERMTable tTable;
8 vTOTTable tTable;
9 vCHANGETable tTable;
10 vCHANGE_FINALTable tTable;
11 vNEWCtr NUMBER;
12 vTERMCtr NUMBER;
13 vCHANGECtr NUMBER;
14 vTOTCtr NUMBER;
15 --
16 /*PROCEDURE populate_pifss_bank_report
17 ( p_employer_id number
18 ,p_month number
19 ,p_year number);*/
20 --
21 FUNCTION get_parameter (
22 p_parameter_string in varchar2
23 ,p_token in varchar2
24 ,p_segment_number in number default null) RETURN varchar2;
25 --
26 FUNCTION get_total_count (
27 p_employer in number
28 ,p_month in varchar2
29 ,p_year in varchar2
30 ,p_nationality in varchar2) RETURN number;
31 --
32 FUNCTION get_change_count (
33 p_employer in number
34 ,p_month in varchar2
35 ,p_year in varchar2
36 ,p_nationality in varchar2) RETURN number;
37 --
38 FUNCTION get_term_count (
39 p_employer in number
40 ,p_month in varchar2
41 ,p_year in varchar2
42 ,p_nationality in varchar2) RETURN number;
43 --
44 FUNCTION get_new_count(
45 p_employer in number
46 ,p_month in varchar2
47 ,p_year in varchar2
48 ,p_nationality in varchar2) RETURN number;
49 --
50 FUNCTION get_def_bal_id (p_bal_name in varchar2 ) RETURN number;
51 --
52 FUNCTION get_change_indicator( p_person_id in number) RETURN varchar2;
53 --
54 FUNCTION get_deduction_detail( p_report_type in varchar2,
55 p_assignment_action_id in number,
56 p_assignment_id in number,
57 p_date in date) RETURN varchar2;
58 --
59 FUNCTION get_amount_cont (p_employer_id number,
60 p_assact_cur_id number ,
61 p_person_id number ,
62 p_effective_date date) return varchar2;
63 --
64 END PAY_KW_PIFSS_REPORT;