PACKAGE: APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG

Source

1 package pay_kr_yea_magtape_fun_pkg AUTHID CURRENT_USER as
2 /* $Header: pykryean.pkh 120.5 2011/03/02 11:09:56 pnethaga ship $ */
3 --
4 level_cnt               number;
5 --
6 type t_b_record is record(
7         tax_unit_id     number,
8         c_records       number,
9         taxable         number,
10         annual_itax     number,
11         annual_rtax     number,
12         annual_stax     number,
13         d_records       number);
14 g_b_record              t_b_record;
15 --
16 type t_c_record is record(
17         assignment_id   number,
18         d_records_per_c number);
19 g_c_record              t_c_record;
20 ------------------------------------------------------------------------
21 function b_data(
22         p_bp_number           in varchar2,
23         p_tax_office_code     in varchar2,
24         p_item_name           in varchar2) return varchar2;
25 ------------------------------------------------------------------------
26 function c_data(
27         p_assignment_id in number,
28         p_item_name     in varchar2) return varchar2;
29 ------------------------------------------------------------------------
30 function latest_yea_action(
31 	p_asg_action_id  in  pay_assignment_actions.assignment_action_id%type,
32         p_pact           in  number,
33         p_target_year    in  number
34 )  return varchar2;
35 ------------------------------------------------------------------------
36 function e_record_count(
37         p_ass_id      in varchar2,
38         p_eff_date    in date
39 ) return number;
40 ------------------------------------------------------------------------
41 -- Bug 9213683: Created a new function to fetch the non-taxable earnings
42 --              values for the Previous employer.
43 ------------------------------------------------------------------------
44 function prev_non_tax_values(
45                              p_assignment_id 	in varchar2,
46                              p_bp_number	in varchar2,
47                              p_code		in varchar2,
48                              p_effective_date   in date) return number;
49 ------------------------------------------------------------------------
50 -- Bug 10184055
51 ------------------------------------------------------------------------
52 function f_record_count(
53                p_ass_id      in varchar2,
54         p_eff_date    in date,
55 	 p_assignment_action_id in varchar2
56 ) return number;
57 
58 function get_sep_pen_exem_amount(
59                p_archive in varchar2,
60 	       p_row_count in number) return number;
61 
62 function get_sep_pen_eligible ( p_assignment_id in varchar2, p_assignment_action_id in varchar2,
63                                 p_effective_date in date, p_information_type in varchar2, p_aei_information6 in varchar2 ) return number;
64 end pay_kr_yea_magtape_fun_pkg;