[Home] [Help]
PACKAGE: APPS.PAY_JP_BEE_UTILITY_PKG
Source
1 package pay_jp_bee_utility_pkg AUTHID CURRENT_USER as
2 /* $Header: pyjpbeeu.pkh 115.1 2002/12/06 11:52:00 ytohya noship $ */
3 --
4 -- Type Definitions
5 --
6 type t_number_tbl is table of number index by binary_integer;
7 type t_varchar2_tbl is table of varchar2(255) index by binary_integer;
8 type t_date_tbl is table of date index by binary_integer;
9 type t_ee_rec is record(
10 element_entry_id pay_element_entries_f.element_entry_id%TYPE,
11 effective_start_date pay_element_entries_f.effective_start_date%TYPE,
12 effective_end_date pay_element_entries_f.effective_end_date%TYPE,
13 element_link_id pay_element_entries_f.element_link_id%TYPE,
14 cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
15 concatenated_segments pay_cost_allocation_keyflex.concatenated_segments%TYPE,
16 segment1 pay_cost_allocation_keyflex.segment1%TYPE,
17 segment2 pay_cost_allocation_keyflex.segment2%TYPE,
18 segment3 pay_cost_allocation_keyflex.segment3%TYPE,
19 segment4 pay_cost_allocation_keyflex.segment4%TYPE,
20 segment5 pay_cost_allocation_keyflex.segment5%TYPE,
21 segment6 pay_cost_allocation_keyflex.segment6%TYPE,
22 segment7 pay_cost_allocation_keyflex.segment7%TYPE,
23 segment8 pay_cost_allocation_keyflex.segment8%TYPE,
24 segment9 pay_cost_allocation_keyflex.segment9%TYPE,
25 segment10 pay_cost_allocation_keyflex.segment10%TYPE,
26 segment11 pay_cost_allocation_keyflex.segment11%TYPE,
27 segment12 pay_cost_allocation_keyflex.segment12%TYPE,
28 segment13 pay_cost_allocation_keyflex.segment13%TYPE,
29 segment14 pay_cost_allocation_keyflex.segment14%TYPE,
30 segment15 pay_cost_allocation_keyflex.segment15%TYPE,
31 segment16 pay_cost_allocation_keyflex.segment16%TYPE,
32 segment17 pay_cost_allocation_keyflex.segment17%TYPE,
33 segment18 pay_cost_allocation_keyflex.segment18%TYPE,
34 segment19 pay_cost_allocation_keyflex.segment19%TYPE,
35 segment20 pay_cost_allocation_keyflex.segment20%TYPE,
36 segment21 pay_cost_allocation_keyflex.segment21%TYPE,
37 segment22 pay_cost_allocation_keyflex.segment22%TYPE,
38 segment23 pay_cost_allocation_keyflex.segment23%TYPE,
39 segment24 pay_cost_allocation_keyflex.segment24%TYPE,
40 segment25 pay_cost_allocation_keyflex.segment25%TYPE,
41 segment26 pay_cost_allocation_keyflex.segment26%TYPE,
42 segment27 pay_cost_allocation_keyflex.segment27%TYPE,
43 segment28 pay_cost_allocation_keyflex.segment28%TYPE,
44 segment29 pay_cost_allocation_keyflex.segment29%TYPE,
45 segment30 pay_cost_allocation_keyflex.segment30%TYPE,
46 reason pay_element_entries_f.reason%TYPE,
47 attribute_category pay_element_entries_f.attribute_category%TYPE,
48 attribute1 pay_element_entries_f.attribute1%TYPE,
49 attribute2 pay_element_entries_f.attribute2%TYPE,
50 attribute3 pay_element_entries_f.attribute3%TYPE,
51 attribute4 pay_element_entries_f.attribute4%TYPE,
52 attribute5 pay_element_entries_f.attribute5%TYPE,
53 attribute6 pay_element_entries_f.attribute6%TYPE,
54 attribute7 pay_element_entries_f.attribute7%TYPE,
55 attribute8 pay_element_entries_f.attribute8%TYPE,
56 attribute9 pay_element_entries_f.attribute9%TYPE,
57 attribute10 pay_element_entries_f.attribute10%TYPE,
58 attribute11 pay_element_entries_f.attribute11%TYPE,
59 attribute12 pay_element_entries_f.attribute12%TYPE,
60 attribute13 pay_element_entries_f.attribute13%TYPE,
61 attribute14 pay_element_entries_f.attribute14%TYPE,
62 attribute15 pay_element_entries_f.attribute15%TYPE,
63 attribute16 pay_element_entries_f.attribute16%TYPE,
64 attribute17 pay_element_entries_f.attribute17%TYPE,
65 attribute18 pay_element_entries_f.attribute18%TYPE,
66 attribute19 pay_element_entries_f.attribute19%TYPE,
67 attribute20 pay_element_entries_f.attribute20%TYPE,
68 entry_information_category pay_element_entries_f.entry_information_category%TYPE,
69 entry_information1 pay_element_entries_f.entry_information1%TYPE,
70 entry_information2 pay_element_entries_f.entry_information2%TYPE,
71 entry_information3 pay_element_entries_f.entry_information3%TYPE,
72 entry_information4 pay_element_entries_f.entry_information4%TYPE,
73 entry_information5 pay_element_entries_f.entry_information5%TYPE,
74 entry_information6 pay_element_entries_f.entry_information6%TYPE,
75 entry_information7 pay_element_entries_f.entry_information7%TYPE,
76 entry_information8 pay_element_entries_f.entry_information8%TYPE,
77 entry_information9 pay_element_entries_f.entry_information9%TYPE,
78 entry_information10 pay_element_entries_f.entry_information10%TYPE,
79 entry_information11 pay_element_entries_f.entry_information11%TYPE,
80 entry_information12 pay_element_entries_f.entry_information12%TYPE,
81 entry_information13 pay_element_entries_f.entry_information13%TYPE,
82 entry_information14 pay_element_entries_f.entry_information14%TYPE,
83 entry_information15 pay_element_entries_f.entry_information15%TYPE,
84 entry_information16 pay_element_entries_f.entry_information16%TYPE,
85 entry_information17 pay_element_entries_f.entry_information17%TYPE,
86 entry_information18 pay_element_entries_f.entry_information18%TYPE,
87 entry_information19 pay_element_entries_f.entry_information19%TYPE,
88 entry_information20 pay_element_entries_f.entry_information20%TYPE,
89 entry_information21 pay_element_entries_f.entry_information21%TYPE,
90 entry_information22 pay_element_entries_f.entry_information22%TYPE,
91 entry_information23 pay_element_entries_f.entry_information23%TYPE,
92 entry_information24 pay_element_entries_f.entry_information24%TYPE,
93 entry_information25 pay_element_entries_f.entry_information25%TYPE,
94 entry_information26 pay_element_entries_f.entry_information26%TYPE,
95 entry_information27 pay_element_entries_f.entry_information27%TYPE,
96 entry_information28 pay_element_entries_f.entry_information28%TYPE,
97 entry_information29 pay_element_entries_f.entry_information29%TYPE,
98 entry_information30 pay_element_entries_f.entry_information30%TYPE,
99 date_earned pay_element_entries_f.date_earned%TYPE,
100 personal_payment_method_id pay_element_entries_f.personal_payment_method_id%TYPE,
101 subpriority pay_element_entries_f.subpriority%TYPE);
102 type t_eev_rec is record(
103 name_tbl t_varchar2_tbl,
104 mandatory_flag_tbl t_varchar2_tbl,
105 hot_default_flag_tbl t_varchar2_tbl,
106 lookup_type_tbl t_varchar2_tbl,
107 default_value_tbl t_varchar2_tbl,
108 liv_default_value_tbl t_varchar2_tbl,
109 entry_value_tbl t_varchar2_tbl);
110 --
111 -- Global Variables
112 --
113 g_num_of_logs number := 0;
114 g_num_of_outs number := 0;
115 -- ----------------------------------------------------------------------------
116 -- |---------------------------< entry_value_tbl >----------------------------|
117 -- ----------------------------------------------------------------------------
118 function entry_value_tbl(
119 p_value1 varchar2 default hr_api.g_varchar2,
120 p_value2 varchar2 default hr_api.g_varchar2,
121 p_value3 varchar2 default hr_api.g_varchar2,
122 p_value4 varchar2 default hr_api.g_varchar2,
123 p_value5 varchar2 default hr_api.g_varchar2,
124 p_value6 varchar2 default hr_api.g_varchar2,
125 p_value7 varchar2 default hr_api.g_varchar2,
126 p_value8 varchar2 default hr_api.g_varchar2,
127 p_value9 varchar2 default hr_api.g_varchar2,
128 p_value10 varchar2 default hr_api.g_varchar2,
129 p_value11 varchar2 default hr_api.g_varchar2,
130 p_value12 varchar2 default hr_api.g_varchar2,
131 p_value13 varchar2 default hr_api.g_varchar2,
132 p_value14 varchar2 default hr_api.g_varchar2,
133 p_value15 varchar2 default hr_api.g_varchar2) return t_varchar2_tbl;
134 -- ----------------------------------------------------------------------------
135 -- |---------------------------< chk_upload_date >----------------------------|
136 -- ----------------------------------------------------------------------------
137 procedure chk_upload_date(
138 p_time_period_id in number,
139 p_upload_date in date,
140 p_period_start_date out nocopy date,
141 p_period_end_date out nocopy date);
142 -- ----------------------------------------------------------------------------
143 -- |----------------------< chk_date_effective_changes >----------------------|
144 -- ----------------------------------------------------------------------------
145 procedure chk_date_effective_changes(
146 p_action_if_exists in varchar2,
147 p_reject_if_future_changes in varchar2,
148 p_date_effective_changes in out nocopy varchar2);
149 -- ----------------------------------------------------------------------------
150 -- |--------------------------------< get_iv >--------------------------------|
151 -- ----------------------------------------------------------------------------
152 procedure get_iv(
153 p_element_type_id in number,
154 p_effective_date in date,
155 p_eev_rec out nocopy t_eev_rec);
156 -- ----------------------------------------------------------------------------
157 -- |--------------------------------< get_ee >--------------------------------|
158 -- ----------------------------------------------------------------------------
159 procedure get_ee(
160 p_assignment_id in number,
161 p_element_type_id in number,
162 p_effective_date in date,
163 p_ee_rec out nocopy t_ee_rec,
164 p_eev_rec out nocopy t_eev_rec);
165 -- ----------------------------------------------------------------------------
166 -- |-------------------------------< set_eev >--------------------------------|
167 -- ----------------------------------------------------------------------------
168 procedure set_eev(
169 p_ee_rec in t_ee_rec,
170 p_eev_rec in t_eev_rec,
171 p_value_if_null_tbl in t_varchar2_tbl,
172 p_new_value_tbl in out nocopy t_varchar2_tbl,
173 p_is_different out nocopy boolean);
174 -- ----------------------------------------------------------------------------
175 -- |---------------------------------< log >----------------------------------|
176 -- ----------------------------------------------------------------------------
177 procedure log(
178 p_full_name in varchar2,
179 p_assignment_number in varchar2,
180 p_application_short_name in varchar2,
181 p_message_name in varchar2,
182 p_token1 in varchar2 default null,
183 p_value1 in varchar2 default null,
184 p_token2 in varchar2 default null,
185 p_value2 in varchar2 default null,
186 p_token3 in varchar2 default null,
187 p_value3 in varchar2 default null,
188 p_token4 in varchar2 default null,
189 p_value4 in varchar2 default null,
190 p_token5 in varchar2 default null,
191 p_value5 in varchar2 default null);
192 -- ----------------------------------------------------------------------------
193 -- |---------------------------------< out >----------------------------------|
194 -- ----------------------------------------------------------------------------
195 procedure out(
196 p_full_name in varchar2,
197 p_assignment_number in varchar2,
198 p_effective_date in date,
199 p_change_type in varchar2,
200 p_eev_rec in t_eev_rec,
201 p_new_value_tbl in t_varchar2_tbl,
202 p_write_all in boolean);
203 -- ----------------------------------------------------------------------------
204 -- |--------------------------< create_batch_line >---------------------------|
205 -- ----------------------------------------------------------------------------
206 procedure create_batch_line(
207 p_batch_id in number,
208 p_assignment_id in number,
209 p_assignment_number in varchar2,
210 p_element_type_id in number,
211 p_element_name in varchar2,
212 p_effective_date in date,
213 p_ee_rec in t_ee_rec,
214 p_eev_rec in t_eev_rec,
215 p_batch_line_id out nocopy number,
216 p_object_version_number out nocopy number);
217 --
218 end pay_jp_bee_utility_pkg;