1 PACKAGE FA_CUA_HR_RETIREMENTS_PKG AS
2 /* $Header: FACHRMRMS.pls 120.2 2005/06/25 01:47:45 bridgway ship $ */
3
4 PROCEDURE generate_retirement_batch(
5 x_event_code IN VARCHAR2
6 , x_book_type_code IN VARCHAR2
7 , x_node_entity_id IN NUMBER
8 , x_retirement_method IN VARCHAR2
9 , x_retirement_type_code IN VARCHAR2
10 , x_proceeds_of_sale IN NUMBER
11 , x_cost_of_removal IN NUMBER
12 , x_retire_date IN DATE
13 , x_prorate_by IN VARCHAR2
14 , x_retire_by IN VARCHAR2
15 , x_retirement_amount IN NUMBER
16 , x_retirement_percent IN NUMBER
17 , x_allow_partial_retire IN VARCHAR2
18 , x_retire_units IN VARCHAR2
19 , x_batch_id IN OUT NOCOPY NUMBER
20 , x_transaction_name IN VARCHAR2 DEFAULT NULL
21 , x_attribute_category IN VARCHAR2 DEFAULT NULL
22 , x_attribute1 IN VARCHAR2 DEFAULT NULL
23 , x_attribute2 IN VARCHAR2 DEFAULT NULL
24 , x_attribute3 IN VARCHAR2 DEFAULT NULL
25 , x_attribute4 IN VARCHAR2 DEFAULT NULL
26 , x_attribute5 IN VARCHAR2 DEFAULT NULL
27 , x_attribute6 IN VARCHAR2 DEFAULT NULL
28 , x_attribute7 IN VARCHAR2 DEFAULT NULL
29 , x_attribute8 IN VARCHAR2 DEFAULT NULL
30 , x_attribute9 IN VARCHAR2 DEFAULT NULL
31 , x_attribute10 IN VARCHAR2 DEFAULT NULL
32 , x_attribute11 IN VARCHAR2 DEFAULT NULL
33 , x_attribute12 IN VARCHAR2 DEFAULT NULL
34 , x_attribute13 IN VARCHAR2 DEFAULT NULL
35 , x_attribute14 IN VARCHAR2 DEFAULT NULL
36 , x_attribute15 IN VARCHAR2 DEFAULT NULL
37 , TH_attribute_category IN VARCHAR2 DEFAULT NULL
38 , TH_attribute1 IN VARCHAR2 DEFAULT NULL
39 , TH_attribute2 IN VARCHAR2 DEFAULT NULL
40 , TH_attribute3 IN VARCHAR2 DEFAULT NULL
41 , TH_attribute4 IN VARCHAR2 DEFAULT NULL
42 , TH_attribute5 IN VARCHAR2 DEFAULT NULL
43 , TH_attribute6 IN VARCHAR2 DEFAULT NULL
44 , TH_attribute7 IN VARCHAR2 DEFAULT NULL
45 , TH_attribute8 IN VARCHAR2 DEFAULT NULL
46 , TH_attribute9 IN VARCHAR2 DEFAULT NULL
47 , TH_attribute10 IN VARCHAR2 DEFAULT NULL
48 , TH_attribute11 IN VARCHAR2 DEFAULT NULL
49 , TH_attribute12 IN VARCHAR2 DEFAULT NULL
50 , TH_attribute13 IN VARCHAR2 DEFAULT NULL
51 , TH_attribute14 IN VARCHAR2 DEFAULT NULL
52 , TH_attribute15 IN VARCHAR2 DEFAULT NULL
53 , x_err_code IN OUT NOCOPY VARCHAR2
54 , x_err_stage IN OUT NOCOPY VARCHAR2
55 , x_err_stack IN OUT NOCOPY VARCHAR2);
56
57 PROCEDURE insert_hr_retirement_hdrs(
58 x_event_code IN VARCHAR2
59 , x_book_type_code IN VARCHAR2
60 , x_status IN VARCHAR2
61 , x_node_entity_id IN NUMBER
62 , x_rejection_reason_code IN VARCHAR2
63 , x_retirement_method IN VARCHAR2
64 , x_retirement_type_code IN VARCHAR2
65 , x_proceeds_of_sale IN NUMBER
66 , x_cost_of_removal IN NUMBER
67 , x_retire_date IN DATE
68 , x_prorate_by IN VARCHAR2
69 , x_retire_by IN VARCHAR2
70 , x_retirement_amount IN NUMBER
71 , x_retirement_percent IN NUMBER
72 , x_allow_partial_retire_flg IN VARCHAR2
73 , x_retire_units_flg IN VARCHAR2
74 , x_created_by IN NUMBER
75 , x_creation_date IN DATE
76 , x_last_updated_by IN NUMBER
77 , x_last_update_date IN DATE
78 , x_last_update_login IN NUMBER
79 , x_concurrent_request_id IN NUMBER
80 , x_batch_id IN OUT NOCOPY NUMBER
81 , x_transaction_name IN VARCHAR2
82 , x_attribute_category IN VARCHAR2
83 , x_attribute1 IN VARCHAR2
84 , x_attribute2 IN VARCHAR2
85 , x_attribute3 IN VARCHAR2
86 , x_attribute4 IN VARCHAR2
87 , x_attribute5 IN VARCHAR2
88 , x_attribute6 IN VARCHAR2
89 , x_attribute7 IN VARCHAR2
90 , x_attribute8 IN VARCHAR2
91 , x_attribute9 IN VARCHAR2
92 , x_attribute10 IN VARCHAR2
93 , x_attribute11 IN VARCHAR2
94 , x_attribute12 IN VARCHAR2
95 , x_attribute13 IN VARCHAR2
96 , x_attribute14 IN VARCHAR2
97 , x_attribute15 IN VARCHAR2
98 , TH_attribute_category IN VARCHAR2
99 , TH_attribute1 IN VARCHAR2
100 , TH_attribute2 IN VARCHAR2
101 , TH_attribute3 IN VARCHAR2
102 , TH_attribute4 IN VARCHAR2
103 , TH_attribute5 IN VARCHAR2
104 , TH_attribute6 IN VARCHAR2
105 , TH_attribute7 IN VARCHAR2
106 , TH_attribute8 IN VARCHAR2
107 , TH_attribute9 IN VARCHAR2
108 , TH_attribute10 IN VARCHAR2
109 , TH_attribute11 IN VARCHAR2
110 , TH_attribute12 IN VARCHAR2
111 , TH_attribute13 IN VARCHAR2
112 , TH_attribute14 IN VARCHAR2
113 , TH_attribute15 IN VARCHAR2
114 , x_err_code IN OUT NOCOPY VARCHAR2
115 , x_err_stage IN OUT NOCOPY VARCHAR2
116 , x_err_stack IN OUT NOCOPY VARCHAR2 );
117
118 PROCEDURE insert_hr_retirement_dtls(
119 x_batch_id IN NUMBER
120 , x_book_type_code IN VARCHAR2
121 , x_asset_id IN NUMBER
122 , x_date_placed_in_service In DATE
123 , x_current_cost IN NUMBER
124 , x_cost_retired IN NUMBER
125 , x_current_units IN NUMBER
126 , x_units_retired IN NUMBER
127 , x_prorate_percent IN NUMBER
128 , x_retirement_convention_code IN VARCHAR2
129 , x_status_code IN VARCHAR2
130 , x_rejection_reason IN VARCHAR2
131 , x_proceeds_of_sale IN NUMBER
132 , x_cost_of_removal IN NUMBER
133 , x_created_by IN NUMBER
134 , x_creation_date IN DATE
135 , x_last_updated_by IN NUMBER
136 , x_last_update_date IN DATE
137 , x_last_update_login IN NUMBER
138 , x_concurrent_request_id IN NUMBER
139 , x_err_code IN OUT NOCOPY VARCHAR2
140 , x_err_stage IN OUT NOCOPY VARCHAR2
141 , x_err_stack IN OUT NOCOPY VARCHAR2 );
142
143 FUNCTION check_pending_batch( x_calling_function IN VARCHAR2,
144 x_book_type_code IN VARCHAR2,
145 x_event_code IN VARCHAR2 DEFAULT NULL,
146 x_asset_id IN NUMBER DEFAULT NULL,
147 x_node_id IN NUMBER DEFAULT NULL,
148 x_category_id IN NUMBER DEFAULT NULL,
149 x_attribute IN VARCHAR2 DEFAULT NULL,
150 x_conc_request_id IN NUMBER DEFAULT NULL,
151 x_status IN OUT NOCOPY VARCHAR2
152 ) RETURN BOOLEAN;
153
154
155 PROCEDURE conc_request( ERRBUF OUT NOCOPY VARCHAR2
156 , RETCODE OUT NOCOPY VARCHAR2
157 , x_from_batch_num IN NUMBER
158 , x_to_batch_num IN NUMBER );
159
160 PROCEDURE post_hr_retirements ( x_batch_id IN NUMBER
161 , x_retire_date IN DATE
162 , x_retirement_type_code IN VARCHAR2
163 , x_transaction_name IN VARCHAR2
164 , x_attribute_category IN VARCHAR2
165 , x_attribute1 IN VARCHAR2
166 , x_attribute2 IN VARCHAR2
167 , x_attribute3 IN VARCHAR2
168 , x_attribute4 IN VARCHAR2
169 , x_attribute5 IN VARCHAR2
170 , x_attribute6 IN VARCHAR2
171 , x_attribute7 IN VARCHAR2
172 , x_attribute8 IN VARCHAR2
173 , x_attribute9 IN VARCHAR2
174 , x_attribute10 IN VARCHAR2
175 , x_attribute11 IN VARCHAR2
176 , x_attribute12 IN VARCHAR2
177 , x_attribute13 IN VARCHAR2
178 , x_attribute14 IN VARCHAR2
179 , x_attribute15 IN VARCHAR2
180 , TH_attribute_category IN VARCHAR2
181 , TH_attribute1 IN VARCHAR2
182 , TH_attribute2 IN VARCHAR2
183 , TH_attribute3 IN VARCHAR2
184 , TH_attribute4 IN VARCHAR2
185 , TH_attribute5 IN VARCHAR2
186 , TH_attribute6 IN VARCHAR2
187 , TH_attribute7 IN VARCHAR2
188 , TH_attribute8 IN VARCHAR2
189 , TH_attribute9 IN VARCHAR2
190 , TH_attribute10 IN VARCHAR2
191 , TH_attribute11 IN VARCHAR2
192 , TH_attribute12 IN VARCHAR2
193 , TH_attribute13 IN VARCHAR2
194 , TH_attribute14 IN VARCHAR2
195 , TH_attribute15 IN VARCHAR2
196 , x_conc_request_id IN NUMBER );
197
198 END FA_CUA_HR_RETIREMENTS_PKG;