[Home] [Help]
121: l_bg_id number;
122: -- Bug 4755015 Ends
123: begin
124: --
125: hr_utility.set_location('Entering:'|| l_proc, 10);
126: --
127: savepoint quick_hire_applicant;
128: l_hire_date := trunc(p_hire_date);
129: l_per_object_version_number := p_per_object_version_number;
134: fetch csr_future_asg_changes into l_dummy;
135: --
136: if csr_future_asg_changes%FOUND then
137: --
138: hr_utility.set_location(l_proc,30);
139: close csr_future_asg_changes;
140: --
141: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
142: hr_utility.raise_error;
137: --
138: hr_utility.set_location(l_proc,30);
139: close csr_future_asg_changes;
140: --
141: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
142: hr_utility.raise_error;
143: --
144: end if;
145: --
138: hr_utility.set_location(l_proc,30);
139: close csr_future_asg_changes;
140: --
141: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
142: hr_utility.raise_error;
143: --
144: end if;
145: --
146: hr_utility.set_location(l_proc,40);
142: hr_utility.raise_error;
143: --
144: end if;
145: --
146: hr_utility.set_location(l_proc,40);
147: --
148: -- Get the derived details for the person DT instance
149: --
150: open csr_get_per_details(l_hire_date);
154: l_per_object_version_number;
155: if csr_get_per_details%NOTFOUND
156: then
157: --
158: hr_utility.set_location(l_proc,50);
159: --
160: close csr_get_per_details;
161: --
162: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
158: hr_utility.set_location(l_proc,50);
159: --
160: close csr_get_per_details;
161: --
162: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
163: hr_utility.raise_error;
164: --
165: else
166: close csr_get_per_details;
159: --
160: close csr_get_per_details;
161: --
162: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
163: hr_utility.raise_error;
164: --
165: else
166: close csr_get_per_details;
167: end if;
166: close csr_get_per_details;
167: end if;
168: --
169: if l_system_person_type in ('APL','APL_EX_APL','EX_EMP_APL') then
170: hr_utility.set_location(l_proc,50);
171: --
172: -- if we have an applicant then look to see if they are being hired at the start of their records
173: --
174: if l_per_effective_start_date=l_hire_date then
171: --
172: -- if we have an applicant then look to see if they are being hired at the start of their records
173: --
174: if l_per_effective_start_date=l_hire_date then
175: hr_utility.set_location(l_proc,60);
176: --
177: -- the hire date is at the start of their record, so need to do some moving
178: --
179: open csr_get_per_details(l_hire_date-1);
182: l_per_effective_start_date2,
183: l_per_object_version_number2;
184: if csr_get_per_details%NOTFOUND then
185: close csr_get_per_details;
186: hr_utility.set_location(l_proc,70);
187: --
188: -- there is no record on the previous day, so move everything back 1 day
189: --
190: update per_all_people_f
318: and effective_start_date=l_hire_date;
319: --
320: l_moved:=true;
321: --
322: hr_utility.set_location(l_proc,80);
323: --
324: else
325: close csr_get_per_details;
326: hr_utility.set_location(l_proc,90);
322: hr_utility.set_location(l_proc,80);
323: --
324: else
325: close csr_get_per_details;
326: hr_utility.set_location(l_proc,90);
327: --
328: -- the applicant did exist yesterday too, so look to see if we can or need to move their data
329: if (l_per_effective_start_date2 = l_hire_date-1)
330: and l_system_person_type2<>l_system_person_type then
330: and l_system_person_type2<>l_system_person_type then
331: --
332: -- we have an effective start date on the hire date and on the day before.
333: -- and the person was not an applicant yesterday, so we cannot move the records
334: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
335: hr_utility.raise_error;
336: end if;
337: end if;
338: end if;
331: --
332: -- we have an effective start date on the hire date and on the day before.
333: -- and the person was not an applicant yesterday, so we cannot move the records
334: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
335: hr_utility.raise_error;
336: end if;
337: end if;
338: end if;
339: --
340: -- the person is an applicant today and yesterday, so we can hire today,
341: -- but now we must check that the assignment chosen is accepted today, or move it.
342: --
343: if p_assignment_id is not null then
344: hr_utility.set_location(l_proc,100);
345: open csr_asg_status(p_assignment_id,l_hire_date);
346: fetch csr_asg_status into l_per_system_status
347: ,l_asg_object_version_number
348: ,l_asg_effective_start_date;
347: ,l_asg_object_version_number
348: ,l_asg_effective_start_date;
349: if csr_asg_status%notfound then
350: close csr_asg_status;
351: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
352: hr_utility.raise_error;
353: else
354: close csr_asg_status;
355: hr_utility.set_location(l_proc,110);
348: ,l_asg_effective_start_date;
349: if csr_asg_status%notfound then
350: close csr_asg_status;
351: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
352: hr_utility.raise_error;
353: else
354: close csr_asg_status;
355: hr_utility.set_location(l_proc,110);
356: end if;
351: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
352: hr_utility.raise_error;
353: else
354: close csr_asg_status;
355: hr_utility.set_location(l_proc,110);
356: end if;
357: if l_asg_effective_start_date=l_hire_date then
358: hr_utility.set_location(l_proc,120);
359: --
354: close csr_asg_status;
355: hr_utility.set_location(l_proc,110);
356: end if;
357: if l_asg_effective_start_date=l_hire_date then
358: hr_utility.set_location(l_proc,120);
359: --
360: -- the assignment starts today, so we must look to see what the status was yesterday
361: --
362: open csr_asg_status(p_assignment_id,l_hire_date-1);
364: ,l_asg_object_version_number
365: ,l_asg_effective_start_date;
366: if csr_asg_status%notfound then
367: close csr_asg_status;
368: hr_utility.set_location(l_proc,130);
369: --
370: -- the assignment started today, so move it back one day to accept it yesterday
371: --
372: --
387: and assignment_type='A'
388: and effective_start_date=l_hire_date;
389: --
390: l_moved:=true;
391: hr_utility.set_location(l_proc,140);
392: else
393: close csr_asg_status;
394: hr_utility.set_location(l_proc,150);
395: if l_asg_effective_start_date=l_hire_date-1 then
390: l_moved:=true;
391: hr_utility.set_location(l_proc,140);
392: else
393: close csr_asg_status;
394: hr_utility.set_location(l_proc,150);
395: if l_asg_effective_start_date=l_hire_date-1 then
396: --
397: -- there was an assignment change yesterday too, so we cannot move backwards
398: --
395: if l_asg_effective_start_date=l_hire_date-1 then
396: --
397: -- there was an assignment change yesterday too, so we cannot move backwards
398: --
399: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
400: hr_utility.raise_error;
401: else
402: hr_utility.set_location(l_proc,160);
403: --
396: --
397: -- there was an assignment change yesterday too, so we cannot move backwards
398: --
399: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
400: hr_utility.raise_error;
401: else
402: hr_utility.set_location(l_proc,160);
403: --
404: -- the earlier assignment row starts before yesterday, so we can move the
398: --
399: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
400: hr_utility.raise_error;
401: else
402: hr_utility.set_location(l_proc,160);
403: --
404: -- the earlier assignment row starts before yesterday, so we can move the
405: -- recent end date back one day
406: --
428: and effective_end_date=l_hire_date-1;
429: --
430: l_moved:=true;
431: --
432: hr_utility.set_location(l_proc,170);
433: end if;
434: end if; -- there was a previous row
435: end if; -- this row starting today
436: end if;
433: end if;
434: end if; -- there was a previous row
435: end if; -- this row starting today
436: end if;
437: hr_utility.set_location(l_proc,180);
438: --
439: -- we now have a person who was an applicant yesterday or before and
440: -- if an assignment is specified then it started yesterday or before
441: -- now we must accept the assignment if it is not already accepted.
439: -- we now have a person who was an applicant yesterday or before and
440: -- if an assignment is specified then it started yesterday or before
441: -- now we must accept the assignment if it is not already accepted.
442: if p_assignment_id is not null then
443: hr_utility.set_location(l_proc,190);
444: open csr_asg_status(p_assignment_id,l_hire_date-1);
445: fetch csr_asg_status into l_per_system_status
446: ,l_asg_object_version_number
447: ,l_asg_effective_start_date;
445: fetch csr_asg_status into l_per_system_status
446: ,l_asg_object_version_number
447: ,l_asg_effective_start_date;
448: if l_per_system_status<>'ACCEPTED' then
449: hr_utility.set_location(l_proc,200);
450: if l_asg_effective_start_date=l_hire_date-1 then
451: l_datetrack_update_mode:='CORRECTION';
452: else
453: l_datetrack_update_mode:='UPDATE';
451: l_datetrack_update_mode:='CORRECTION';
452: else
453: l_datetrack_update_mode:='UPDATE';
454: end if;
455: hr_utility.set_location(l_proc,210);
456: hr_assignment_api.accept_apl_asg
457: (p_validate => false
458: ,p_effective_date => l_hire_date-1
459: ,p_datetrack_update_mode => l_datetrack_update_mode
465: ,p_effective_end_date => l_asg_effective_end_date
466: );
467: end if; -- is it not accepted
468: end if; -- is it specified
469: hr_utility.set_location(l_proc,220);
470: --
471: -- now that they are moved and accepted, do the hire
472: --
473: hr_applicant_api.hire_applicant
510: --
511: -- Bug 4755015 Ends
512: --
513: elsif l_system_person_type ='EMP_APL' then
514: hr_utility.set_location(l_proc,230);
515: --
516: -- if we have an emp_apl then look to see if they are being hired at the
517: -- start of the current record
518: --
516: -- if we have an emp_apl then look to see if they are being hired at the
517: -- start of the current record
518: --
519: if l_per_effective_start_date=l_hire_date then
520: hr_utility.set_location(l_proc,240);
521: --
522: -- the hire date is at the start of their record, so need to do some moving
523: --
524: open csr_get_per_details(l_hire_date-1);
526: into l_system_person_type2,
527: l_per_effective_start_date2,
528: l_per_object_version_number2;
529: close csr_get_per_details;
530: hr_utility.set_location(l_proc,250);
531: --
532: -- look to see if they were not an emp-apl yesterday
533: --
534: if l_system_person_type2<>'EMP_APL' then
531: --
532: -- look to see if they were not an emp-apl yesterday
533: --
534: if l_system_person_type2<>'EMP_APL' then
535: hr_utility.set_location(l_proc,260);
536: --
537: if (l_per_effective_start_date2 = l_hire_date-1) then
538: --
539: -- we have an effective start date on the hire date and on the day before.
537: if (l_per_effective_start_date2 = l_hire_date-1) then
538: --
539: -- we have an effective start date on the hire date and on the day before.
540: -- and the person was not an emp_apl yesterday, so we cannot move the records
541: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
542: hr_utility.raise_error;
543: end if;
544: hr_utility.set_location(l_proc,270);
545: --
538: --
539: -- we have an effective start date on the hire date and on the day before.
540: -- and the person was not an emp_apl yesterday, so we cannot move the records
541: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
542: hr_utility.raise_error;
543: end if;
544: hr_utility.set_location(l_proc,270);
545: --
546: -- they weren't an emp-apl yesterday, but there is room to move that backwards
540: -- and the person was not an emp_apl yesterday, so we cannot move the records
541: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
542: hr_utility.raise_error;
543: end if;
544: hr_utility.set_location(l_proc,270);
545: --
546: -- they weren't an emp-apl yesterday, but there is room to move that backwards
547: --
548: update per_all_people_f
558: and effective_end_date=l_hire_date-1;
559: --
560: l_moved:=true;
561: --
562: hr_utility.set_location(l_proc,280);
563: end if;
564: end if;
565: hr_utility.set_location(l_proc,290);
566: --
561: --
562: hr_utility.set_location(l_proc,280);
563: end if;
564: end if;
565: hr_utility.set_location(l_proc,290);
566: --
567: -- the person is an emp_apl today and yesterday, so we can hire today,
568: -- but now we must check that the assignment chosen is accepted today, or move it.
569: --
567: -- the person is an emp_apl today and yesterday, so we can hire today,
568: -- but now we must check that the assignment chosen is accepted today, or move it.
569: --
570: if p_assignment_id is not null and p_overwrite_primary='N' then
571: hr_utility.set_location(l_proc,300);
572: open csr_asg_status(p_assignment_id,l_hire_date);
573: fetch csr_asg_status into l_per_system_status
574: ,l_asg_object_version_number
575: ,l_asg_effective_start_date;
574: ,l_asg_object_version_number
575: ,l_asg_effective_start_date;
576: if csr_asg_status%notfound then
577: close csr_asg_status;
578: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
579: hr_utility.raise_error;
580: else
581: close csr_asg_status;
582: hr_utility.set_location(l_proc,310);
575: ,l_asg_effective_start_date;
576: if csr_asg_status%notfound then
577: close csr_asg_status;
578: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
579: hr_utility.raise_error;
580: else
581: close csr_asg_status;
582: hr_utility.set_location(l_proc,310);
583: end if;
578: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
579: hr_utility.raise_error;
580: else
581: close csr_asg_status;
582: hr_utility.set_location(l_proc,310);
583: end if;
584: if l_asg_effective_start_date=l_hire_date then
585: hr_utility.set_location(l_proc,320);
586: --
581: close csr_asg_status;
582: hr_utility.set_location(l_proc,310);
583: end if;
584: if l_asg_effective_start_date=l_hire_date then
585: hr_utility.set_location(l_proc,320);
586: --
587: -- the assignment starts today, so we must look to see what the status was yesterday
588: --
589: open csr_asg_status(p_assignment_id,l_hire_date-1);
591: ,l_asg_object_version_number
592: ,l_asg_effective_start_date;
593: if csr_asg_status%notfound then
594: close csr_asg_status;
595: hr_utility.set_location(l_proc,330);
596: --
597: -- the assignment started today, so move it back one day to accept it yesterday
598: --
599: update per_all_assignments_f
616: raise;
617: end;
618: --
619: l_moved:=true;
620: hr_utility.set_location(l_proc,340);
621: else
622: close csr_asg_status;
623: hr_utility.set_location(l_proc,350);
624: if l_asg_effective_start_date=l_hire_date-1 then
619: l_moved:=true;
620: hr_utility.set_location(l_proc,340);
621: else
622: close csr_asg_status;
623: hr_utility.set_location(l_proc,350);
624: if l_asg_effective_start_date=l_hire_date-1 then
625: --
626: -- there was an assignment change yesterday too, so we cannot move backwards
627: --
624: if l_asg_effective_start_date=l_hire_date-1 then
625: --
626: -- there was an assignment change yesterday too, so we cannot move backwards
627: --
628: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
629: hr_utility.raise_error;
630: else
631: hr_utility.set_location(l_proc,360);
632: --
625: --
626: -- there was an assignment change yesterday too, so we cannot move backwards
627: --
628: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
629: hr_utility.raise_error;
630: else
631: hr_utility.set_location(l_proc,360);
632: --
633: -- the earlier assignment row starts before yesterday, so we can move the
627: --
628: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
629: hr_utility.raise_error;
630: else
631: hr_utility.set_location(l_proc,360);
632: --
633: -- the earlier assignment row starts before yesterday, so we can move the
634: -- recent end date back one day
635: --
646: and effective_end_date=l_hire_date-1;
647: --
648: l_moved:=true;
649: --
650: hr_utility.set_location(l_proc,370);
651: end if;
652: end if; -- there was a previous row
653: end if; -- this row starting today
654: end if;
651: end if;
652: end if; -- there was a previous row
653: end if; -- this row starting today
654: end if;
655: hr_utility.set_location(l_proc,380);
656: --
657: if p_overwrite_primary IN ('Y','V') then
658: hr_utility.set_location(l_proc,385);
659: -- we should make sure that any applications that start on the hire date
654: end if;
655: hr_utility.set_location(l_proc,380);
656: --
657: if p_overwrite_primary IN ('Y','V') then
658: hr_utility.set_location(l_proc,385);
659: -- we should make sure that any applications that start on the hire date
660: -- are moved back one day, along with the application
661: begin
662: update per_all_assignments_f
686: end;
687: --
688: end if;
689: --
690: hr_utility.set_location(l_proc,385);
691: --
692: -- we now have a person who was an emp_apl yesterday or before and
693: -- if an assignment is specified then it started yesterday or before
694: -- now we must accept the assignment if it is not already accepted.
692: -- we now have a person who was an emp_apl yesterday or before and
693: -- if an assignment is specified then it started yesterday or before
694: -- now we must accept the assignment if it is not already accepted.
695: if p_assignment_id is not null then
696: hr_utility.set_location(l_proc,390);
697: open csr_asg_status(p_assignment_id,l_hire_date-1);
698: fetch csr_asg_status into l_per_system_status
699: ,l_asg_object_version_number
700: ,l_asg_effective_start_date;
698: fetch csr_asg_status into l_per_system_status
699: ,l_asg_object_version_number
700: ,l_asg_effective_start_date;
701: if l_per_system_status<>'ACCEPTED' then
702: hr_utility.set_location(l_proc,400);
703: if l_asg_effective_start_date=l_hire_date-1 then
704: l_datetrack_update_mode:='CORRECTION';
705: else
706: l_datetrack_update_mode:='UPDATE';
704: l_datetrack_update_mode:='CORRECTION';
705: else
706: l_datetrack_update_mode:='UPDATE';
707: end if;
708: hr_utility.set_location(l_proc,410);
709: hr_assignment_api.accept_apl_asg
710: (p_validate => false
711: ,p_effective_date => l_hire_date-1
712: ,p_datetrack_update_mode => l_datetrack_update_mode
718: ,p_effective_end_date => l_asg_effective_end_date
719: );
720: end if; -- is it not accepted
721: end if; -- is it specified
722: hr_utility.set_location(l_proc,420);
723: --
724: -- now that they are moved and accepted, do the hire
725: --
726: hr_employee_applicant_api.hire_employee_applicant
739: );
740: --
741: end if;
742: --
743: hr_utility.set_location('Leaving '||l_proc,430);
744:
745: end quick_hire_applicant;
746: --
747:
804: l_proc varchar2(72) := g_package||'set_notification';
805: l_user_name varchar2(50); -- # 3295399
806: begin
807: --
808: hr_utility.set_location('Entering:'||l_proc||'/'||p_wf_Name, 10);
809: --
810: l_nid:=wf_notification.send(p_role
811: ,p_wf_name
812: ,p_notification
815: ,null
816: ,null
817: );
818: --
819: hr_utility.set_location(l_proc, 20);
820: --
821: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
822: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
823: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
848: -- Attributes for CWK seeded WORKFLOW.
849: --
850: IF p_wf_name = 'PECWKNOT' THEN
851: --
852: hr_utility.set_location(l_proc, 25);
853: --
854: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
855: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
856: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
863: -- # 3295399 End
864: --
865: END IF;
866: --
867: hr_utility.set_location(l_proc, 30);
868: --
869: open csr_formula_id(p_notification);
870: fetch csr_formula_id into l_formula_id;
871: if csr_formula_id%found then
869: open csr_formula_id(p_notification);
870: fetch csr_formula_id into l_formula_id;
871: if csr_formula_id%found then
872: --
873: hr_utility.set_location(l_proc, 40);
874: --
875: close csr_formula_id;
876: ff_exec.init_formula(l_formula_id,p_effective_date,l_formula_inputs,l_formula_outputs);
877: l_index_number := l_formula_inputs.FIRST;
886: end if;
887: l_index_number := l_formula_inputs.NEXT(l_index_number);
888: end loop;
889: --
890: hr_utility.set_location(l_proc, 50);
891: --
892: ff_exec.run_formula(l_formula_inputs,l_formula_outputs);
893: l_index_number := l_formula_outputs.FIRST;
894: WHILE (l_index_number IS NOT NULL)
906: end if;
907: l_index_number := l_formula_outputs.NEXT(l_index_number);
908: end loop;
909: --
910: hr_utility.set_location(l_proc, 60);
911: --
912: else
913: --
914: hr_utility.set_location(l_proc, 70);
910: hr_utility.set_location(l_proc, 60);
911: --
912: else
913: --
914: hr_utility.set_location(l_proc, 70);
915: --
916: close csr_formula_id;
917: end if;
918: --
921: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
922: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
923: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
924: --
925: hr_utility.set_location(l_proc, 80);
926: --
927: return l_nid;
928: --
929: hr_utility.set_location('Leaving:'|| l_proc, 90);
925: hr_utility.set_location(l_proc, 80);
926: --
927: return l_nid;
928: --
929: hr_utility.set_location('Leaving:'|| l_proc, 90);
930: --
931: exception
932: when others then
933: hr_utility.set_location('Leaving:'|| l_proc, 100);
929: hr_utility.set_location('Leaving:'|| l_proc, 90);
930: --
931: exception
932: when others then
933: hr_utility.set_location('Leaving:'|| l_proc, 100);
934: l_nid:=null;
935: return l_nid;
936: end set_notification;
937:
974: l_nid number;
975: l_proc varchar2(72) := g_package||'send_notification';
976: begin
977: --
978: hr_utility.set_location('Entering:'|| l_proc, 10);
979: --
980: l_nid:=set_notification
981: (p_notification => p_notification
982: ,p_wf_name => p_wf_name
1011: ,p_supplier_reference => p_supplier_reference
1012: ,p_placement_date_start => p_placement_date_start
1013: ,p_grade_ladder => p_grade_ladder
1014: );
1015: hr_utility.set_location(l_proc, 20);
1016: --
1017: --Added for bug 5586890
1018: WF_NOTIFICATION.Denormalize_Notification(l_nid);
1019: commit;
1017: --Added for bug 5586890
1018: WF_NOTIFICATION.Denormalize_Notification(l_nid);
1019: commit;
1020: --
1021: hr_utility.set_location('Leaving:'|| l_proc, 30);
1022: --
1023: end send_notification;
1024: --
1025: procedure get_notification_preview
1065: l_body varchar2(4000);
1066: l_proc varchar2(72) := g_package||'get_notification_preview';
1067: begin
1068: --
1069: hr_utility.set_location('Entering:'|| l_proc, 10);
1070: --
1071: l_nid:=set_notification
1072: (p_notification => p_notification
1073: ,p_wf_name => p_wf_name
1102: ,p_supplier_reference => p_supplier_reference
1103: ,p_placement_date_start => p_placement_date_start
1104: ,p_grade_ladder => p_grade_ladder
1105: );
1106: hr_utility.set_location(l_proc, 20);
1107: --
1108: if l_nid is not null then
1109: hr_utility.set_location(l_proc, 30);
1110: l_subject:=wf_notification.getSubject(l_nid);
1105: );
1106: hr_utility.set_location(l_proc, 20);
1107: --
1108: if l_nid is not null then
1109: hr_utility.set_location(l_proc, 30);
1110: l_subject:=wf_notification.getSubject(l_nid);
1111: l_body:=wf_notification.getBody(l_nid);
1112: else
1113: hr_utility.set_location(l_proc, 40);
1109: hr_utility.set_location(l_proc, 30);
1110: l_subject:=wf_notification.getSubject(l_nid);
1111: l_body:=wf_notification.getBody(l_nid);
1112: else
1113: hr_utility.set_location(l_proc, 40);
1114: l_subject:=null;
1115: l_body:=null;
1116: end if;
1117: --
1119: --
1120: p_subject:=l_subject;
1121: p_body:=l_body;
1122: --
1123: hr_utility.set_location('Leaving:'|| l_proc, 50);
1124: --
1125: end get_notification_preview;
1126: --
1127: end per_qh_action;