[Home] [Help]
PACKAGE: APPS.PER_JP_CTR_UTILITY_PKG
Source
1 package per_jp_ctr_utility_pkg AUTHID CURRENT_USER as
2 /* $Header: pejpctru.pkh 115.1 2002/12/12 11:36:28 ytohya noship $ */
3 --
4 -- Type Definitions
5 --
6 type t_varchar2_tbl is table of varchar2(255) index by binary_integer;
7 type t_itax_dpnt_rec is record(
8 assignment_id number,
9 itax_type hr_lookups.lookup_code%TYPE,
10 effective_date date,
11 spouse_type hr_lookups.lookup_code%TYPE := '0',
12 dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',
13 dpnts number := 0,
14 aged_dpnts number := 0,
15 aged_dpnt_parents_lt number := 0,
16 young_dpnts number := 0,
17 minor_dpnts number := 0,
18 dsbl_dpnts number := 0,
19 svr_dsbl_dpnts number := 0,
20 svr_dsbl_dpnts_lt number := 0,
21 /*
22 dpnt_spouse_type hr_lookups.lookup_code%TYPE := '0',
23 dpnt_spouse_dsbl_type hr_lookups.lookup_code%TYPE := '0',
24 dpnts number := 0,
25 aged_dpnts number := 0,
26 cohab_aged_asc_dpnts number := 0,
27 major_dpnts number := 0,
28 minor_dpnts number := 0,
29 dsbl_dpnts number := 0,
30 svr_dsbl_dpnts number := 0,
31 */
32 cohab_svr_dsbl_dpnts number := 0,
33 multiple_spouses_warning boolean := false,
34 contact_type_tbl t_varchar2_tbl,
35 d_contact_type_kanji_tbl t_varchar2_tbl,
36 d_contact_type_kana_tbl t_varchar2_tbl,
37 last_name_kanji_tbl t_varchar2_tbl,
38 first_name_kanji_tbl t_varchar2_tbl,
39 last_name_kana_tbl t_varchar2_tbl,
40 first_name_kana_tbl t_varchar2_tbl);
41 -- ----------------------------------------------------------------------------
42 -- |------------------------< bg_itax_dpnt_ref_type >-------------------------|
43 -- ----------------------------------------------------------------------------
44 function bg_itax_dpnt_ref_type(p_business_group_id in number) return varchar2;
45 -- ----------------------------------------------------------------------------
46 -- |--------------------------< get_itax_dpnt_info >--------------------------|
47 -- ----------------------------------------------------------------------------
48 procedure get_itax_dpnt_info(
49 p_assignment_id in number,
50 p_itax_type in varchar2,
51 p_effective_date in date,
52 p_itax_dpnt_rec out nocopy t_itax_dpnt_rec,
53 p_use_cache in boolean default TRUE);
54 -------------------------------------------------------------------------------
55 procedure get_itax_dpnt_info(
56 p_assignment_id in number,
57 p_itax_type in varchar2,
58 p_effective_date in date,
59 p_spouse_type out nocopy varchar2,
60 p_dpnt_spouse_dsbl_type out nocopy varchar2,
61 p_dpnts out nocopy number,
62 p_aged_dpnts out nocopy number,
63 p_aged_dpnt_parents_lt out nocopy number,
64 p_young_dpnts out nocopy number,
65 p_minor_dpnts out nocopy number,
66 p_dsbl_dpnts out nocopy number,
67 p_svr_dsbl_dpnts out nocopy number,
68 p_svr_dsbl_dpnts_lt out nocopy number,
69 p_multiple_spouses_warning out nocopy boolean,
70 p_use_cache in boolean default TRUE);
71 -------------------------------------------------------------------------------
72 procedure get_itax_dpnt_info(
73 p_assignment_id in number,
74 p_itax_type in varchar2,
75 p_effective_date in date,
76 p_dpnt_spouse_type out nocopy varchar2,
77 p_dpnt_spouse_dsbl_type out nocopy varchar2,
78 p_dpnts out nocopy number,
79 p_aged_dpnts out nocopy number,
80 p_cohab_aged_asc_dpnts out nocopy number,
81 p_major_dpnts out nocopy number,
82 p_minor_dpnts out nocopy number,
83 p_dsbl_dpnts out nocopy number,
84 p_svr_dsbl_dpnts out nocopy number,
85 p_cohab_svr_dsbl_dpnts out nocopy number,
86 p_multiple_spouses_warning out nocopy boolean,
87 p_use_cache in boolean default TRUE);
88 -------------------------------------------------------------------------------
89 function get_itax_spouse_type(
90 p_assignment_id in number,
91 p_itax_type in varchar2,
92 p_effective_date in date default null) return varchar2;
93 -------------------------------------------------------------------------------
94 function get_itax_dpnt_spouse_type(
95 p_assignment_id in number,
96 p_itax_type in varchar2,
97 p_effective_date in date default null) return varchar2;
98 -------------------------------------------------------------------------------
99 function get_itax_dpnt_spouse_dsbl_type(
100 p_assignment_id in number,
101 p_itax_type in varchar2,
102 p_effective_date in date default null) return varchar2;
103 -------------------------------------------------------------------------------
104 function get_itax_dpnts(
105 p_assignment_id in number,
106 p_itax_type in varchar2,
107 p_effective_date in date default null) return varchar2;
108 -------------------------------------------------------------------------------
109 function get_itax_aged_dpnts(
110 p_assignment_id in number,
111 p_itax_type in varchar2,
112 p_effective_date in date default null) return varchar2;
113 -------------------------------------------------------------------------------
114 function get_itax_aged_dpnt_parents_lt(
115 p_assignment_id in number,
116 p_itax_type in varchar2,
117 p_effective_date in date default null) return varchar2;
118 -------------------------------------------------------------------------------
119 function get_itax_cohab_aged_asc_dpnts(
120 p_assignment_id in number,
121 p_itax_type in varchar2,
122 p_effective_date in date default null) return varchar2;
123 -------------------------------------------------------------------------------
124 function get_itax_young_dpnts(
125 p_assignment_id in number,
126 p_itax_type in varchar2,
127 p_effective_date in date default null) return varchar2;
128 -------------------------------------------------------------------------------
129 function get_itax_major_dpnts(
130 p_assignment_id in number,
131 p_itax_type in varchar2,
132 p_effective_date in date default null) return varchar2;
133 -------------------------------------------------------------------------------
134 function get_itax_minor_dpnts(
135 p_assignment_id in number,
136 p_itax_type in varchar2,
137 p_effective_date in date default null) return varchar2;
138 -------------------------------------------------------------------------------
139 function get_itax_dsbl_dpnts(
140 p_assignment_id in number,
141 p_itax_type in varchar2,
142 p_effective_date in date default null) return varchar2;
143 -------------------------------------------------------------------------------
144 function get_itax_svr_dsbl_dpnts(
145 p_assignment_id in number,
146 p_itax_type in varchar2,
147 p_effective_date in date default null) return varchar2;
148 -------------------------------------------------------------------------------
149 function get_itax_svr_dsbl_dpnts_lt(
150 p_assignment_id in number,
151 p_itax_type in varchar2,
152 p_effective_date in date default null) return varchar2;
153 -------------------------------------------------------------------------------
154 function get_itax_cohab_svr_dsbl_dpnts(
155 p_assignment_id in number,
156 p_itax_type in varchar2,
157 p_effective_date in date default null) return varchar2;
158 --
159 end per_jp_ctr_utility_pkg;