DBA Data[Home] [Help]

PACKAGE BODY: APPS.BEN_PDP_SHD

Source


1 Package Body ben_pdp_shd as
2 /* $Header: bepdprhi.pkb 120.10.12010000.4 2008/08/05 15:08:01 ubhat ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |                     Private Global Definitions                           |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package  varchar2(33)	:= '  ben_pdp_shd.';  -- Global package name
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< return_api_dml_status >-------------------------|
12 -- ----------------------------------------------------------------------------
13 Function return_api_dml_status Return Boolean Is
14 --
15   l_proc 	varchar2(72) := g_package||'return_api_dml_status';
16 --
17 Begin
18   hr_utility.set_location('Entering:'||l_proc, 5);
19   --
20   Return (nvl(g_api_dml, false));
21   --
22   hr_utility.set_location(' Leaving:'||l_proc, 10);
23 End return_api_dml_status;
24 --
25 -- ----------------------------------------------------------------------------
26 -- |---------------------------< constraint_error >---------------------------|
27 -- ----------------------------------------------------------------------------
28 Procedure constraint_error
29             (p_constraint_name in all_constraints.constraint_name%TYPE) Is
30 --
31   l_proc 	varchar2(72) := g_package||'constraint_error';
32 --
33 Begin
34   hr_utility.set_location('Entering:'||l_proc, 5);
35   --
36   If (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_PK') Then
37     fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38     fnd_message.set_token('PROCEDURE', l_proc);
39     fnd_message.set_token('STEP','5');
40     fnd_message.raise_error;
41   elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK1') Then
42     fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43     fnd_message.set_token('PROCEDURE', l_proc);
44     fnd_message.set_token('STEP','10');
45     fnd_message.raise_error;
46   elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK2') Then
47     fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
48     fnd_message.set_token('PROCEDURE', l_proc);
49     fnd_message.set_token('STEP','15');
50     fnd_message.raise_error;
51   elsif (p_constraint_name = 'BEN_ELIG_CVRD_DPNT_FK3') Then
52     fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
53     fnd_message.set_token('PROCEDURE', l_proc);
54     fnd_message.set_token('STEP','20');
55     fnd_message.raise_error;
56   Else
57     fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
58     fnd_message.set_token('PROCEDURE', l_proc);
59     fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
60     fnd_message.raise_error;
61   End If;
62   --
63   hr_utility.set_location(' Leaving:'||l_proc, 10);
64 End constraint_error;
65 --
66 -- ----------------------------------------------------------------------------
67 -- |-----------------------------< api_updating >-----------------------------|
68 -- ----------------------------------------------------------------------------
69 Function api_updating
70   (p_effective_date		in date,
71    p_elig_cvrd_dpnt_id		in number,
72    p_object_version_number	in number
73   ) Return Boolean Is
74 --
75   --
76   -- Cursor selects the 'current' row from the HR Schema
77   --
78   Cursor C_Sel1 is
79     select
80 	elig_cvrd_dpnt_id,
81 	effective_start_date,
82 	effective_end_date,
83 	business_group_id,
84 	prtt_enrt_rslt_id,
85 	dpnt_person_id,
86 	cvg_strt_dt,
87 	cvg_thru_dt,
88         cvg_pndg_flag,
89 	pdp_attribute_category,
90 	pdp_attribute1,
91 	pdp_attribute2,
92 	pdp_attribute3,
93 	pdp_attribute4,
94 	pdp_attribute5,
95 	pdp_attribute6,
96 	pdp_attribute7,
97 	pdp_attribute8,
98 	pdp_attribute9,
99 	pdp_attribute10,
100 	pdp_attribute11,
101 	pdp_attribute12,
102 	pdp_attribute13,
103 	pdp_attribute14,
104 	pdp_attribute15,
105 	pdp_attribute16,
106 	pdp_attribute17,
107 	pdp_attribute18,
108 	pdp_attribute19,
109 	pdp_attribute20,
110 	pdp_attribute21,
111 	pdp_attribute22,
112 	pdp_attribute23,
113 	pdp_attribute24,
114 	pdp_attribute25,
115 	pdp_attribute26,
116 	pdp_attribute27,
117 	pdp_attribute28,
118 	pdp_attribute29,
119 	pdp_attribute30,
120       request_id,
121       program_application_id,
122       program_id,
123       program_update_date,
124       object_version_number,
125         ovrdn_flag,
126         per_in_ler_id,
127         ovrdn_thru_dt
128     from	ben_elig_cvrd_dpnt_f
129     where	elig_cvrd_dpnt_id = p_elig_cvrd_dpnt_id
130     and		p_effective_date
131     between	effective_start_date and effective_end_date;
132 --
133   l_proc	varchar2(72)	:= g_package||'api_updating';
134   l_fct_ret	boolean;
135 --
136 Begin
137   hr_utility.set_location('Entering:'||l_proc, 5);
138   --
139   If (p_effective_date is null or
140       p_elig_cvrd_dpnt_id is null or
141       p_object_version_number is null) Then
142     --
143     -- One of the primary key arguments is null therefore we must
144     -- set the returning function value to false
145     --
146     l_fct_ret := false;
147   Else
148     If (p_elig_cvrd_dpnt_id = g_old_rec.elig_cvrd_dpnt_id and
149         p_object_version_number = g_old_rec.object_version_number) Then
150       hr_utility.set_location(l_proc, 10);
151       --
152       -- The g_old_rec is current therefore we must
153       -- set the returning function to true
154       --
155       l_fct_ret := true;
156     Else
157       --
158       -- Select the current row
159       --
160       Open C_Sel1;
161       Fetch C_Sel1 Into g_old_rec;
162       If C_Sel1%notfound Then
163         Close C_Sel1;
164         --
165         -- The primary key is invalid therefore we must error
166         --
167         fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
168         fnd_message.raise_error;
169       End If;
170       Close C_Sel1;
171       If (p_object_version_number <> g_old_rec.object_version_number) Then
172         fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
173         fnd_message.raise_error;
174       End If;
175       hr_utility.set_location(l_proc, 15);
176       l_fct_ret := true;
177     End If;
178   End If;
179   hr_utility.set_location(' Leaving:'||l_proc, 20);
180   Return (l_fct_ret);
181 --
182 End api_updating;
183 --
184 -- ----------------------------------------------------------------------------
185 -- |--------------------------< find_dt_del_modes >---------------------------|
186 -- ----------------------------------------------------------------------------
187 Procedure find_dt_del_modes
188 	(p_effective_date	in  date,
189 	 p_base_key_value	in  number,
190 	 p_zap		 out nocopy boolean,
191 	 p_delete	 out nocopy boolean,
192 	 p_future_change out nocopy boolean,
193 	 p_delete_next_change out nocopy boolean) is
194 --
195   l_proc 		varchar2(72) 	:= g_package||'find_dt_del_modes';
196 --
197   l_parent_key_value1	number;
198   --
199   Cursor C_Sel1 Is
200     select  t.prtt_enrt_rslt_id
201     from    ben_elig_cvrd_dpnt_f t
202     where   t.elig_cvrd_dpnt_id = p_base_key_value
203     and     p_effective_date
204     between t.effective_start_date and t.effective_end_date;
205 --
206 Begin
207   hr_utility.set_location('Entering:'||l_proc, 5);
208   Open  C_Sel1;
209   Fetch C_Sel1 Into l_parent_key_value1;
210   If C_Sel1%notfound then
211     Close C_Sel1;
212     fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
213     fnd_message.set_token('PROCEDURE', l_proc);
214     fnd_message.set_token('STEP','10');
215     fnd_message.raise_error;
216   End If;
217   Close C_Sel1;
218   --
219   -- Call the corresponding datetrack api
220   --
221   dt_api.find_dt_del_modes
222 	(p_effective_date	=> p_effective_date,
223 	 p_base_table_name	=> 'ben_elig_cvrd_dpnt_f',
224 	 p_base_key_column	=> 'elig_cvrd_dpnt_id',
225 	 p_base_key_value	=> p_base_key_value,
226 	 p_parent_table_name1	=> 'ben_prtt_enrt_rslt_f',
227 	 p_parent_key_column1	=> 'prtt_enrt_rslt_id',
228 	 p_parent_key_value1	=> l_parent_key_value1,
229 	 p_zap			=> p_zap,
230 	 p_delete		=> p_delete,
231 	 p_future_change	=> p_future_change,
232 	 p_delete_next_change	=> p_delete_next_change);
233   --
234   hr_utility.set_location(' Leaving:'||l_proc, 10);
235 End find_dt_del_modes;
236 --
237 -- ----------------------------------------------------------------------------
238 -- |--------------------------< find_dt_upd_modes >---------------------------|
239 -- ----------------------------------------------------------------------------
240 Procedure find_dt_upd_modes
241 	(p_effective_date	in  date,
242 	 p_base_key_value	in  number,
243 	 p_correction	 out nocopy boolean,
244 	 p_update	 out nocopy boolean,
245 	 p_update_override out nocopy boolean,
246 	 p_update_change_insert out nocopy boolean) is
247 --
248   l_proc 	varchar2(72) := g_package||'find_dt_upd_modes';
249 --
250 Begin
251   hr_utility.set_location('Entering:'||l_proc, 5);
252   --
253   -- Call the corresponding datetrack api
254   --
255   dt_api.find_dt_upd_modes
256 	(p_effective_date	=> p_effective_date,
257 	 p_base_table_name	=> 'ben_elig_cvrd_dpnt_f',
258 	 p_base_key_column	=> 'elig_cvrd_dpnt_id',
259 	 p_base_key_value	      => p_base_key_value,
260 	 p_correction		=> p_correction,
261 	 p_update		      => p_update,
262 	 p_update_override	=> p_update_override,
263 	 p_update_change_insert	=> p_update_change_insert);
264   --
265   hr_utility.set_location(' Leaving:'||l_proc, 10);
266 End find_dt_upd_modes;
267 --
268 -- ----------------------------------------------------------------------------
269 -- |------------------------< upd_effective_end_date >------------------------|
270 -- ----------------------------------------------------------------------------
271 Procedure upd_effective_end_date
272 	(p_effective_date		in date,
273 	 p_base_key_value		in number,
274 	 p_new_effective_end_date	in date,
275 	 p_validation_start_date	in date,
276 	 p_validation_end_date		in date,
277          p_object_version_number       out nocopy number) is
278 --
279   l_proc 		  varchar2(72) := g_package||'upd_effective_end_date';
280   l_object_version_number number;
281 --
282 Begin
283   hr_utility.set_location('Entering:'||l_proc, 5);
284   --
285   -- Because we are updating a row we must get the next object
286   -- version number.
287   --
288   l_object_version_number :=
289     dt_api.get_object_version_number
290 	(p_base_table_name	=> 'ben_elig_cvrd_dpnt_f',
291 	 p_base_key_column	=> 'elig_cvrd_dpnt_id',
292 	 p_base_key_value	=> p_base_key_value);
293   --
294   hr_utility.set_location(l_proc, 10);
295   g_api_dml := true;  -- Set the api dml status
296   --
297   -- Update the specified datetrack row setting the effective
298   -- end date to the specified new effective end date.
299   --
300   update  ben_elig_cvrd_dpnt_f t
301   set	  t.effective_end_date	  = p_new_effective_end_date,
302 	  t.object_version_number = l_object_version_number
303   where	  t.elig_cvrd_dpnt_id	  = p_base_key_value
304   and	  p_effective_date
305   between t.effective_start_date and t.effective_end_date;
306   --
307   g_api_dml := false;   -- Unset the api dml status
308   p_object_version_number := l_object_version_number;
309   hr_utility.set_location(' Leaving:'||l_proc, 15);
310 --
311 Exception
312   When Others Then
313     g_api_dml := false;   -- Unset the api dml status
314     Raise;
315 End upd_effective_end_date;
316 --
317 -- ----------------------------------------------------------------------------
318 -- |---------------------------------< lck >----------------------------------|
319 -- ----------------------------------------------------------------------------
320 Procedure lck
321 	(p_effective_date	 in  date,
322 	 p_datetrack_mode	 in  varchar2,
323 	 p_elig_cvrd_dpnt_id	 in  number,
324 	 p_object_version_number in  number,
325 	 p_validation_start_date out nocopy date,
326 	 p_validation_end_date	 out nocopy date) is
327 --
328   l_proc		  varchar2(72) := g_package||'lck';
329   l_validation_start_date date;
330   l_validation_end_date	  date;
331   l_object_invalid 	  exception;
332   l_argument		  varchar2(30);
333   --
334   -- Cursor C_Sel1 selects the current locked row as of session date
335   -- ensuring that the object version numbers match.
336   --
337   Cursor C_Sel1 is
338     select
339 	elig_cvrd_dpnt_id,
340 	effective_start_date,
341 	effective_end_date,
342 	business_group_id,
343 	prtt_enrt_rslt_id,
344 	dpnt_person_id,
345 	cvg_strt_dt,
346 	cvg_thru_dt,
347       cvg_pndg_flag,
348 	pdp_attribute_category,
349 	pdp_attribute1,
350 	pdp_attribute2,
351 	pdp_attribute3,
352 	pdp_attribute4,
353 	pdp_attribute5,
354 	pdp_attribute6,
355 	pdp_attribute7,
356 	pdp_attribute8,
357 	pdp_attribute9,
358 	pdp_attribute10,
359 	pdp_attribute11,
360 	pdp_attribute12,
361 	pdp_attribute13,
362 	pdp_attribute14,
363 	pdp_attribute15,
364 	pdp_attribute16,
365 	pdp_attribute17,
366 	pdp_attribute18,
367 	pdp_attribute19,
368 	pdp_attribute20,
369 	pdp_attribute21,
370 	pdp_attribute22,
371 	pdp_attribute23,
372 	pdp_attribute24,
373 	pdp_attribute25,
374 	pdp_attribute26,
375 	pdp_attribute27,
376 	pdp_attribute28,
377 	pdp_attribute29,
378 	pdp_attribute30,
379       request_id,
380       program_application_id,
381       program_id,
382       program_update_date,
383 	object_version_number,
384         ovrdn_flag,
385         per_in_ler_id,
386         ovrdn_thru_dt
387     from    ben_elig_cvrd_dpnt_f
388     where   elig_cvrd_dpnt_id         = p_elig_cvrd_dpnt_id
389     and	    p_effective_date
390     between effective_start_date and effective_end_date
391     for update nowait;
392   --
393   --
394   --
395 Begin
396   hr_utility.set_location('Entering:'||l_proc, 5);
397   --
398   -- Ensure that all the mandatory arguments are not null
399   --
400   hr_api.mandatory_arg_error(p_api_name       => l_proc,
401                              p_argument       => 'effective_date',
402                              p_argument_value => p_effective_date);
403   --
404   hr_api.mandatory_arg_error(p_api_name       => l_proc,
405                              p_argument       => 'datetrack_mode',
406                              p_argument_value => p_datetrack_mode);
407   --
408   hr_api.mandatory_arg_error(p_api_name       => l_proc,
409                              p_argument       => 'elig_cvrd_dpnt_id',
410                              p_argument_value => p_elig_cvrd_dpnt_id);
411   --
412   hr_api.mandatory_arg_error(p_api_name       => l_proc,
413                              p_argument       => 'object_version_number',
414                              p_argument_value => p_object_version_number);
415   --
416   -- Check to ensure the datetrack mode is not INSERT.
417   --
418   If (p_datetrack_mode <> 'INSERT') then
419     --
420     -- We must select and lock the current row.
421     --
422     Open  C_Sel1;
423     Fetch C_Sel1 Into g_old_rec;
427       -- The primary key is invalid therefore we must error
424     If C_Sel1%notfound then
425       Close C_Sel1;
426       --
428       --
429       fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
430       fnd_message.raise_error;
431     End If;
432     Close C_Sel1;
433     If (p_object_version_number <> g_old_rec.object_version_number) Then
434         fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
435         fnd_message.raise_error;
436       End If;
437     hr_utility.set_location(l_proc, 15);
438     --
439     --
440     -- Validate the datetrack mode mode getting the validation start
441     -- and end dates for the specified datetrack operation.
442     --
443     dt_api.validate_dt_mode
444 	(p_effective_date	   => p_effective_date,
445 	 p_datetrack_mode	   => p_datetrack_mode,
446 	 p_base_table_name	   => 'ben_elig_cvrd_dpnt_f',
447 	 p_base_key_column	   => 'elig_cvrd_dpnt_id',
448 	 p_base_key_value 	   => p_elig_cvrd_dpnt_id,
449 	 p_child_table_name1       => 'ben_cvrd_dpnt_ctfn_prvdd_f',
450 	 p_child_key_column1       => 'cvrd_dpnt_ctfn_prvdd_id',
451        p_enforce_foreign_locking => false ,
452 	 p_validation_start_date   => l_validation_start_date,
453  	 p_validation_end_date	   => l_validation_end_date);
454   Else
455     --
456     -- We are doing a datetrack 'INSERT' which is illegal within this
457     -- procedure therefore we must error (note: to lck on insert the
458     -- private procedure ins_lck should be called).
459     --
460     fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
461     fnd_message.set_token('PROCEDURE', l_proc);
462     fnd_message.set_token('STEP','20');
463     fnd_message.raise_error;
464   End If;
465   --
466   -- Set the validation start and end date OUT arguments
467   --
468   p_validation_start_date := l_validation_start_date;
469   p_validation_end_date   := l_validation_end_date;
470   --
471   hr_utility.set_location(' Leaving:'||l_proc, 30);
472 --
473 -- We need to trap the ORA LOCK exception
474 --
475 Exception
476   When HR_Api.Object_Locked then
477     --
478     -- The object is locked therefore we need to supply a meaningful
479     -- error message.
480     --
481     fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
482     fnd_message.set_token('TABLE_NAME', 'ben_elig_cvrd_dpnt_f');
483     fnd_message.raise_error;
484   When l_object_invalid then
485     --
486     -- The object doesn't exist or is invalid
487     --
488     fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
489     fnd_message.set_token('TABLE_NAME', 'ben_elig_cvrd_dpnt_f');
490     fnd_message.raise_error;
491 End lck;
492 --
493 -- ----------------------------------------------------------------------------
494 -- |-----------------------------< convert_args >-----------------------------|
495 -- ----------------------------------------------------------------------------
496 Function convert_args
497 	(
498 	p_elig_cvrd_dpnt_id             in number,
499 	p_effective_start_date          in date,
500 	p_effective_end_date            in date,
501 	p_business_group_id             in number,
502 	p_prtt_enrt_rslt_id             in number,
503 	p_dpnt_person_id                in number,
504 	p_cvg_strt_dt                   in date,
505 	p_cvg_thru_dt                   in date,
506       p_cvg_pndg_flag                 in varchar2,
507 	p_pdp_attribute_category        in varchar2,
508 	p_pdp_attribute1                in varchar2,
509 	p_pdp_attribute2                in varchar2,
510 	p_pdp_attribute3                in varchar2,
511 	p_pdp_attribute4                in varchar2,
512 	p_pdp_attribute5                in varchar2,
513 	p_pdp_attribute6                in varchar2,
514 	p_pdp_attribute7                in varchar2,
515 	p_pdp_attribute8                in varchar2,
516 	p_pdp_attribute9                in varchar2,
517 	p_pdp_attribute10               in varchar2,
518 	p_pdp_attribute11               in varchar2,
519 	p_pdp_attribute12               in varchar2,
520 	p_pdp_attribute13               in varchar2,
521 	p_pdp_attribute14               in varchar2,
522 	p_pdp_attribute15               in varchar2,
523 	p_pdp_attribute16               in varchar2,
524 	p_pdp_attribute17               in varchar2,
525 	p_pdp_attribute18               in varchar2,
526 	p_pdp_attribute19               in varchar2,
527 	p_pdp_attribute20               in varchar2,
528 	p_pdp_attribute21               in varchar2,
529 	p_pdp_attribute22               in varchar2,
530 	p_pdp_attribute23               in varchar2,
531 	p_pdp_attribute24               in varchar2,
532 	p_pdp_attribute25               in varchar2,
533 	p_pdp_attribute26               in varchar2,
534 	p_pdp_attribute27               in varchar2,
535 	p_pdp_attribute28               in varchar2,
536 	p_pdp_attribute29               in varchar2,
537 	p_pdp_attribute30               in varchar2,
538       p_request_id                    in number,
539       p_program_application_id        in number,
540       p_program_id                    in number,
541       p_program_update_date           in date,
542 	p_object_version_number         in number,
543         p_ovrdn_flag                    in varchar2,
544         p_per_in_ler_id                 in number,
548 --
545         p_ovrdn_thru_dt                 in date
546 	)
547 	Return g_rec_type is
549   l_rec	  g_rec_type;
550   l_proc  varchar2(72) := g_package||'convert_args';
551 --
552 Begin
553   --
554   hr_utility.set_location('Entering:'||l_proc, 5);
555   --
556   -- Convert arguments into local l_rec structure.
557   --
558   l_rec.elig_cvrd_dpnt_id                := p_elig_cvrd_dpnt_id;
559   l_rec.effective_start_date             := p_effective_start_date;
560   l_rec.effective_end_date               := p_effective_end_date;
561   l_rec.business_group_id                := p_business_group_id;
562   l_rec.prtt_enrt_rslt_id                := p_prtt_enrt_rslt_id;
563   l_rec.dpnt_person_id                   := p_dpnt_person_id;
564   l_rec.cvg_strt_dt                      := p_cvg_strt_dt;
565   l_rec.cvg_thru_dt                      := p_cvg_thru_dt;
566   l_rec.cvg_pndg_flag                    := p_cvg_pndg_flag;
567   l_rec.pdp_attribute_category           := p_pdp_attribute_category;
568   l_rec.pdp_attribute1                   := p_pdp_attribute1;
569   l_rec.pdp_attribute2                   := p_pdp_attribute2;
570   l_rec.pdp_attribute3                   := p_pdp_attribute3;
571   l_rec.pdp_attribute4                   := p_pdp_attribute4;
572   l_rec.pdp_attribute5                   := p_pdp_attribute5;
573   l_rec.pdp_attribute6                   := p_pdp_attribute6;
574   l_rec.pdp_attribute7                   := p_pdp_attribute7;
575   l_rec.pdp_attribute8                   := p_pdp_attribute8;
576   l_rec.pdp_attribute9                   := p_pdp_attribute9;
577   l_rec.pdp_attribute10                  := p_pdp_attribute10;
578   l_rec.pdp_attribute11                  := p_pdp_attribute11;
579   l_rec.pdp_attribute12                  := p_pdp_attribute12;
580   l_rec.pdp_attribute13                  := p_pdp_attribute13;
581   l_rec.pdp_attribute14                  := p_pdp_attribute14;
582   l_rec.pdp_attribute15                  := p_pdp_attribute15;
583   l_rec.pdp_attribute16                  := p_pdp_attribute16;
584   l_rec.pdp_attribute17                  := p_pdp_attribute17;
585   l_rec.pdp_attribute18                  := p_pdp_attribute18;
586   l_rec.pdp_attribute19                  := p_pdp_attribute19;
587   l_rec.pdp_attribute20                  := p_pdp_attribute20;
588   l_rec.pdp_attribute21                  := p_pdp_attribute21;
589   l_rec.pdp_attribute22                  := p_pdp_attribute22;
590   l_rec.pdp_attribute23                  := p_pdp_attribute23;
591   l_rec.pdp_attribute24                  := p_pdp_attribute24;
592   l_rec.pdp_attribute25                  := p_pdp_attribute25;
593   l_rec.pdp_attribute26                  := p_pdp_attribute26;
594   l_rec.pdp_attribute27                  := p_pdp_attribute27;
595   l_rec.pdp_attribute28                  := p_pdp_attribute28;
596   l_rec.pdp_attribute29                  := p_pdp_attribute29;
597   l_rec.pdp_attribute30                  := p_pdp_attribute30;
598   l_rec.request_id                       := p_request_id;
599   l_rec.program_application_id           := p_program_application_id;
600   l_rec.program_id                       := p_program_id;
601   l_rec.program_update_date              := p_program_update_date;
602   l_rec.object_version_number            := p_object_version_number;
603   l_rec.ovrdn_flag                       := p_ovrdn_flag;
604   l_rec.per_in_ler_id                    := p_per_in_ler_id;
605   l_rec.ovrdn_thru_dt                    := p_ovrdn_thru_dt;
606   --
607   -- Return the plsql record structure.
608   --
609   hr_utility.set_location(' Leaving:'||l_proc, 10);
610   Return(l_rec);
611 --
612 End convert_args;
613 --
614 end ben_pdp_shd;