[Home] [Help]
129: l_bg_id number;
130: -- Bug 4755015 Ends
131: begin
132: --
133: hr_utility.set_location('Entering:'|| l_proc, 10);
134: --
135: savepoint quick_hire_applicant;
136: l_hire_date := trunc(p_hire_date);
137: l_per_object_version_number := p_per_object_version_number;
144: fetch fpt_future_asg_changes into l_dummy;
145: --
146: if fpt_future_asg_changes%FOUND then
147: --
148: hr_utility.set_location(l_proc,20);
149: close fpt_future_asg_changes;
150: --
151: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
152: hr_utility.raise_error;
147: --
148: hr_utility.set_location(l_proc,20);
149: close fpt_future_asg_changes;
150: --
151: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
152: hr_utility.raise_error;
153: --
154: end if;
155: else
148: hr_utility.set_location(l_proc,20);
149: close fpt_future_asg_changes;
150: --
151: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
152: hr_utility.raise_error;
153: --
154: end if;
155: else
156: open csr_future_asg_changes;
157: fetch csr_future_asg_changes into l_dummy;
158: --
159: if csr_future_asg_changes%FOUND then
160: --
161: hr_utility.set_location(l_proc,30);
162: close csr_future_asg_changes;
163: --
164: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
165: hr_utility.raise_error;
160: --
161: hr_utility.set_location(l_proc,30);
162: close csr_future_asg_changes;
163: --
164: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
165: hr_utility.raise_error;
166: --
167: end if;
168:
161: hr_utility.set_location(l_proc,30);
162: close csr_future_asg_changes;
163: --
164: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
165: hr_utility.raise_error;
166: --
167: end if;
168:
169: end if;
167: end if;
168:
169: end if;
170: --
171: hr_utility.set_location(l_proc,40);
172: --
173: -- Get the derived details for the person DT instance
174: --
175: open csr_get_per_details(l_hire_date);
179: l_per_object_version_number;
180: if csr_get_per_details%NOTFOUND
181: then
182: --
183: hr_utility.set_location(l_proc,50);
184: --
185: close csr_get_per_details;
186: --
187: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
183: hr_utility.set_location(l_proc,50);
184: --
185: close csr_get_per_details;
186: --
187: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
188: hr_utility.raise_error;
189: --
190: else
191: close csr_get_per_details;
184: --
185: close csr_get_per_details;
186: --
187: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
188: hr_utility.raise_error;
189: --
190: else
191: close csr_get_per_details;
192: end if;
191: close csr_get_per_details;
192: end if;
193: --
194: if l_system_person_type in ('APL','APL_EX_APL','EX_EMP_APL') then
195: hr_utility.set_location(l_proc,50);
196: --
197: -- if we have an applicant then look to see if they are being hired at the start of their records
198: --
199: if l_per_effective_start_date=l_hire_date then
196: --
197: -- if we have an applicant then look to see if they are being hired at the start of their records
198: --
199: if l_per_effective_start_date=l_hire_date then
200: hr_utility.set_location(l_proc,60);
201: --
202: -- the hire date is at the start of their record, so need to do some moving
203: --
204: open csr_get_per_details(l_hire_date-1);
207: l_per_effective_start_date2,
208: l_per_object_version_number2;
209: if csr_get_per_details%NOTFOUND then
210: close csr_get_per_details;
211: hr_utility.set_location(l_proc,70);
212: --
213: -- there is no record on the previous day, so move everything back 1 day
214: --
215: update per_all_people_f
343: and effective_start_date=l_hire_date;
344: --
345: l_moved:=true;
346: --
347: hr_utility.set_location(l_proc,80);
348: --
349: else
350: close csr_get_per_details;
351: hr_utility.set_location(l_proc,90);
347: hr_utility.set_location(l_proc,80);
348: --
349: else
350: close csr_get_per_details;
351: hr_utility.set_location(l_proc,90);
352: --
353: -- the applicant did exist yesterday too, so look to see if we can or need to move their data
354: if (l_per_effective_start_date2 = l_hire_date-1)
355: and l_system_person_type2<>l_system_person_type then
355: and l_system_person_type2<>l_system_person_type then
356: --
357: -- we have an effective start date on the hire date and on the day before.
358: -- and the person was not an applicant yesterday, so we cannot move the records
359: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
360: hr_utility.raise_error;
361: end if;
362: end if;
363: end if;
356: --
357: -- we have an effective start date on the hire date and on the day before.
358: -- and the person was not an applicant yesterday, so we cannot move the records
359: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
360: hr_utility.raise_error;
361: end if;
362: end if;
363: end if;
364: --
365: -- the person is an applicant today and yesterday, so we can hire today,
366: -- but now we must check that the assignment chosen is accepted today, or move it.
367: --
368: if p_assignment_id is not null then
369: hr_utility.set_location(l_proc,100);
370: open csr_asg_status(p_assignment_id,l_hire_date);
371: fetch csr_asg_status into l_per_system_status
372: ,l_asg_object_version_number
373: ,l_asg_effective_start_date;
372: ,l_asg_object_version_number
373: ,l_asg_effective_start_date;
374: if csr_asg_status%notfound then
375: close csr_asg_status;
376: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
377: hr_utility.raise_error;
378: else
379: close csr_asg_status;
380: hr_utility.set_location(l_proc,110);
373: ,l_asg_effective_start_date;
374: if csr_asg_status%notfound then
375: close csr_asg_status;
376: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
377: hr_utility.raise_error;
378: else
379: close csr_asg_status;
380: hr_utility.set_location(l_proc,110);
381: end if;
376: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
377: hr_utility.raise_error;
378: else
379: close csr_asg_status;
380: hr_utility.set_location(l_proc,110);
381: end if;
382: if l_asg_effective_start_date=l_hire_date then
383: hr_utility.set_location(l_proc,120);
384: --
379: close csr_asg_status;
380: hr_utility.set_location(l_proc,110);
381: end if;
382: if l_asg_effective_start_date=l_hire_date then
383: hr_utility.set_location(l_proc,120);
384: --
385: -- the assignment starts today, so we must look to see what the status was yesterday
386: --
387: open csr_asg_status(p_assignment_id,l_hire_date-1);
389: ,l_asg_object_version_number
390: ,l_asg_effective_start_date;
391: if csr_asg_status%notfound then
392: close csr_asg_status;
393: hr_utility.set_location(l_proc,130);
394: --
395: -- the assignment started today, so move it back one day to accept it yesterday
396: --
397: --
412: and assignment_type='A'
413: and effective_start_date=l_hire_date;
414: --
415: l_moved:=true;
416: hr_utility.set_location(l_proc,140);
417: else
418: close csr_asg_status;
419: hr_utility.set_location(l_proc,150);
420: if l_asg_effective_start_date=l_hire_date-1 then
415: l_moved:=true;
416: hr_utility.set_location(l_proc,140);
417: else
418: close csr_asg_status;
419: hr_utility.set_location(l_proc,150);
420: if l_asg_effective_start_date=l_hire_date-1 then
421: --
422: -- there was an assignment change yesterday too, so we cannot move backwards
423: --
420: if l_asg_effective_start_date=l_hire_date-1 then
421: --
422: -- there was an assignment change yesterday too, so we cannot move backwards
423: --
424: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
425: hr_utility.raise_error;
426: else
427: hr_utility.set_location(l_proc,160);
428: --
421: --
422: -- there was an assignment change yesterday too, so we cannot move backwards
423: --
424: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
425: hr_utility.raise_error;
426: else
427: hr_utility.set_location(l_proc,160);
428: --
429: -- the earlier assignment row starts before yesterday, so we can move the
423: --
424: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
425: hr_utility.raise_error;
426: else
427: hr_utility.set_location(l_proc,160);
428: --
429: -- the earlier assignment row starts before yesterday, so we can move the
430: -- recent end date back one day
431: --
453: and effective_end_date=l_hire_date-1;
454: --
455: l_moved:=true;
456: --
457: hr_utility.set_location(l_proc,170);
458: end if;
459: end if; -- there was a previous row
460: end if; -- this row starting today
461: end if;
458: end if;
459: end if; -- there was a previous row
460: end if; -- this row starting today
461: end if;
462: hr_utility.set_location(l_proc,180);
463: --
464: -- we now have a person who was an applicant yesterday or before and
465: -- if an assignment is specified then it started yesterday or before
466: -- now we must accept the assignment if it is not already accepted.
464: -- we now have a person who was an applicant yesterday or before and
465: -- if an assignment is specified then it started yesterday or before
466: -- now we must accept the assignment if it is not already accepted.
467: if p_assignment_id is not null then
468: hr_utility.set_location(l_proc,190);
469: open csr_asg_status(p_assignment_id,l_hire_date-1);
470: fetch csr_asg_status into l_per_system_status
471: ,l_asg_object_version_number
472: ,l_asg_effective_start_date;
470: fetch csr_asg_status into l_per_system_status
471: ,l_asg_object_version_number
472: ,l_asg_effective_start_date;
473: if l_per_system_status<>'ACCEPTED' then
474: hr_utility.set_location(l_proc,200);
475: if l_asg_effective_start_date=l_hire_date-1 then
476: l_datetrack_update_mode:='CORRECTION';
477: else
478: l_datetrack_update_mode:='UPDATE';
476: l_datetrack_update_mode:='CORRECTION';
477: else
478: l_datetrack_update_mode:='UPDATE';
479: end if;
480: hr_utility.set_location(l_proc,210);
481: hr_assignment_api.accept_apl_asg
482: (p_validate => false
483: ,p_effective_date => l_hire_date-1
484: ,p_datetrack_update_mode => l_datetrack_update_mode
490: ,p_effective_end_date => l_asg_effective_end_date
491: );
492: end if; -- is it not accepted
493: end if; -- is it specified
494: hr_utility.set_location(l_proc,220);
495: --
496: -- now that they are moved and accepted, do the hire
497: --
498: hr_applicant_api.hire_applicant
535: --Commented this fix for Bug 8805585
536: -- Bug 4755015 Ends
537: --
538: elsif l_system_person_type ='EMP_APL' then
539: hr_utility.set_location(l_proc,230);
540: --
541: -- if we have an emp_apl then look to see if they are being hired at the
542: -- start of the current record
543: --
541: -- if we have an emp_apl then look to see if they are being hired at the
542: -- start of the current record
543: --
544: if l_per_effective_start_date=l_hire_date then
545: hr_utility.set_location(l_proc,240);
546: --
547: -- the hire date is at the start of their record, so need to do some moving
548: --
549: open csr_get_per_details(l_hire_date-1);
551: into l_system_person_type2,
552: l_per_effective_start_date2,
553: l_per_object_version_number2;
554: close csr_get_per_details;
555: hr_utility.set_location(l_proc,250);
556: --
557: -- look to see if they were not an emp-apl yesterday
558: --
559: if l_system_person_type2<>'EMP_APL' then
556: --
557: -- look to see if they were not an emp-apl yesterday
558: --
559: if l_system_person_type2<>'EMP_APL' then
560: hr_utility.set_location(l_proc,260);
561: --
562: if (l_per_effective_start_date2 = l_hire_date-1) then
563: --
564: -- we have an effective start date on the hire date and on the day before.
562: if (l_per_effective_start_date2 = l_hire_date-1) then
563: --
564: -- we have an effective start date on the hire date and on the day before.
565: -- and the person was not an emp_apl yesterday, so we cannot move the records
566: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
567: hr_utility.raise_error;
568: end if;
569: hr_utility.set_location(l_proc,270);
570: --
563: --
564: -- we have an effective start date on the hire date and on the day before.
565: -- and the person was not an emp_apl yesterday, so we cannot move the records
566: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
567: hr_utility.raise_error;
568: end if;
569: hr_utility.set_location(l_proc,270);
570: --
571: -- they weren't an emp-apl yesterday, but there is room to move that backwards
565: -- and the person was not an emp_apl yesterday, so we cannot move the records
566: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
567: hr_utility.raise_error;
568: end if;
569: hr_utility.set_location(l_proc,270);
570: --
571: -- they weren't an emp-apl yesterday, but there is room to move that backwards
572: --
573: update per_all_people_f
583: and effective_end_date=l_hire_date-1;
584: --
585: l_moved:=true;
586: --
587: hr_utility.set_location(l_proc,280);
588: end if;
589: end if;
590: hr_utility.set_location(l_proc,290);
591: --
586: --
587: hr_utility.set_location(l_proc,280);
588: end if;
589: end if;
590: hr_utility.set_location(l_proc,290);
591: --
592: -- the person is an emp_apl today and yesterday, so we can hire today,
593: -- but now we must check that the assignment chosen is accepted today, or move it.
594: --
592: -- the person is an emp_apl today and yesterday, so we can hire today,
593: -- but now we must check that the assignment chosen is accepted today, or move it.
594: --
595: if p_assignment_id is not null and p_overwrite_primary='N' then
596: hr_utility.set_location(l_proc,300);
597: open csr_asg_status(p_assignment_id,l_hire_date);
598: fetch csr_asg_status into l_per_system_status
599: ,l_asg_object_version_number
600: ,l_asg_effective_start_date;
599: ,l_asg_object_version_number
600: ,l_asg_effective_start_date;
601: if csr_asg_status%notfound then
602: close csr_asg_status;
603: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
604: hr_utility.raise_error;
605: else
606: close csr_asg_status;
607: hr_utility.set_location(l_proc,310);
600: ,l_asg_effective_start_date;
601: if csr_asg_status%notfound then
602: close csr_asg_status;
603: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
604: hr_utility.raise_error;
605: else
606: close csr_asg_status;
607: hr_utility.set_location(l_proc,310);
608: end if;
603: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
604: hr_utility.raise_error;
605: else
606: close csr_asg_status;
607: hr_utility.set_location(l_proc,310);
608: end if;
609: if l_asg_effective_start_date=l_hire_date then
610: hr_utility.set_location(l_proc,320);
611: --
606: close csr_asg_status;
607: hr_utility.set_location(l_proc,310);
608: end if;
609: if l_asg_effective_start_date=l_hire_date then
610: hr_utility.set_location(l_proc,320);
611: --
612: -- the assignment starts today, so we must look to see what the status was yesterday
613: --
614: open csr_asg_status(p_assignment_id,l_hire_date-1);
616: ,l_asg_object_version_number
617: ,l_asg_effective_start_date;
618: if csr_asg_status%notfound then
619: close csr_asg_status;
620: hr_utility.set_location(l_proc,330);
621: --
622: -- the assignment started today, so move it back one day to accept it yesterday
623: --
624: update per_all_assignments_f
641: raise;
642: end;
643: --
644: l_moved:=true;
645: hr_utility.set_location(l_proc,340);
646: else
647: close csr_asg_status;
648: hr_utility.set_location(l_proc,350);
649: if l_asg_effective_start_date=l_hire_date-1 then
644: l_moved:=true;
645: hr_utility.set_location(l_proc,340);
646: else
647: close csr_asg_status;
648: hr_utility.set_location(l_proc,350);
649: if l_asg_effective_start_date=l_hire_date-1 then
650: --
651: -- there was an assignment change yesterday too, so we cannot move backwards
652: --
649: if l_asg_effective_start_date=l_hire_date-1 then
650: --
651: -- there was an assignment change yesterday too, so we cannot move backwards
652: --
653: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
654: hr_utility.raise_error;
655: else
656: hr_utility.set_location(l_proc,360);
657: --
650: --
651: -- there was an assignment change yesterday too, so we cannot move backwards
652: --
653: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
654: hr_utility.raise_error;
655: else
656: hr_utility.set_location(l_proc,360);
657: --
658: -- the earlier assignment row starts before yesterday, so we can move the
652: --
653: hr_utility.set_message(800,'PER_52621_CANNOT_MOVE_DATA');
654: hr_utility.raise_error;
655: else
656: hr_utility.set_location(l_proc,360);
657: --
658: -- the earlier assignment row starts before yesterday, so we can move the
659: -- recent end date back one day
660: --
671: and effective_end_date=l_hire_date-1;
672: --
673: l_moved:=true;
674: --
675: hr_utility.set_location(l_proc,370);
676: end if;
677: end if; -- there was a previous row
678: end if; -- this row starting today
679: end if;
676: end if;
677: end if; -- there was a previous row
678: end if; -- this row starting today
679: end if;
680: hr_utility.set_location(l_proc,380);
681: --
682: if p_overwrite_primary IN ('Y','V') then
683: hr_utility.set_location(l_proc,385);
684: -- we should make sure that any applications that start on the hire date
679: end if;
680: hr_utility.set_location(l_proc,380);
681: --
682: if p_overwrite_primary IN ('Y','V') then
683: hr_utility.set_location(l_proc,385);
684: -- we should make sure that any applications that start on the hire date
685: -- are moved back one day, along with the application
686: begin
687: update per_all_assignments_f
711: end;
712: --
713: end if;
714: --
715: hr_utility.set_location(l_proc,385);
716: --
717: -- we now have a person who was an emp_apl yesterday or before and
718: -- if an assignment is specified then it started yesterday or before
719: -- now we must accept the assignment if it is not already accepted.
717: -- we now have a person who was an emp_apl yesterday or before and
718: -- if an assignment is specified then it started yesterday or before
719: -- now we must accept the assignment if it is not already accepted.
720: if p_assignment_id is not null then
721: hr_utility.set_location(l_proc,390);
722: open csr_asg_status(p_assignment_id,l_hire_date-1);
723: fetch csr_asg_status into l_per_system_status
724: ,l_asg_object_version_number
725: ,l_asg_effective_start_date;
723: fetch csr_asg_status into l_per_system_status
724: ,l_asg_object_version_number
725: ,l_asg_effective_start_date;
726: if l_per_system_status<>'ACCEPTED' then
727: hr_utility.set_location(l_proc,400);
728: if l_asg_effective_start_date=l_hire_date-1 then
729: l_datetrack_update_mode:='CORRECTION';
730: else
731: l_datetrack_update_mode:='UPDATE';
729: l_datetrack_update_mode:='CORRECTION';
730: else
731: l_datetrack_update_mode:='UPDATE';
732: end if;
733: hr_utility.set_location(l_proc,410);
734: hr_assignment_api.accept_apl_asg
735: (p_validate => false
736: ,p_effective_date => l_hire_date-1
737: ,p_datetrack_update_mode => l_datetrack_update_mode
743: ,p_effective_end_date => l_asg_effective_end_date
744: );
745: end if; -- is it not accepted
746: end if; -- is it specified
747: hr_utility.set_location(l_proc,420);
748: --
749: -- now that they are moved and accepted, do the hire
750: --
751: hr_employee_applicant_api.hire_employee_applicant
764: );
765: --
766: end if;
767: --
768: hr_utility.set_location('Leaving '||l_proc,430);
769:
770: end quick_hire_applicant;
771: --
772:
829: l_proc varchar2(72) := g_package||'set_notification';
830: l_user_name varchar2(50); -- # 3295399
831: begin
832: --
833: hr_utility.set_location('Entering:'||l_proc||'/'||p_wf_Name, 10);
834: --
835: l_nid:=wf_notification.send(p_role
836: ,p_wf_name
837: ,p_notification
840: ,null
841: ,null
842: );
843: --
844: hr_utility.set_location(l_proc, 20);
845: --
846: wf_notification.setAttrDate(l_nid,'HIRE_DATE',p_hire_date);
847: wf_notification.setAttrText(l_nid,'FULL_NAME',p_full_name);
848: wf_notification.setAttrDate(l_nid,'PER_EFFECTIVE_START_DATE',p_per_effective_start_date);
873: -- Attributes for CWK seeded WORKFLOW.
874: --
875: IF p_wf_name = 'PECWKNOT' THEN
876: --
877: hr_utility.set_location(l_proc, 25);
878: --
879: wf_notification.setAttrText(l_nid,'NPW_NUMBER',p_npw_number);
880: wf_notification.setAttrText(l_nid,'SUPPLIER_NAME',p_vendor);
881: wf_notification.setAttrText(l_nid,'SUPPLIER_REFERENCE',p_supplier_reference);
888: -- # 3295399 End
889: --
890: END IF;
891: --
892: hr_utility.set_location(l_proc, 30);
893: --
894: open csr_formula_id(p_notification);
895: fetch csr_formula_id into l_formula_id;
896: if csr_formula_id%found then
894: open csr_formula_id(p_notification);
895: fetch csr_formula_id into l_formula_id;
896: if csr_formula_id%found then
897: --
898: hr_utility.set_location(l_proc, 40);
899: --
900: close csr_formula_id;
901: ff_exec.init_formula(l_formula_id,p_effective_date,l_formula_inputs,l_formula_outputs);
902: l_index_number := l_formula_inputs.FIRST;
911: end if;
912: l_index_number := l_formula_inputs.NEXT(l_index_number);
913: end loop;
914: --
915: hr_utility.set_location(l_proc, 50);
916: --
917: ff_exec.run_formula(l_formula_inputs,l_formula_outputs);
918: l_index_number := l_formula_outputs.FIRST;
919: WHILE (l_index_number IS NOT NULL)
931: end if;
932: l_index_number := l_formula_outputs.NEXT(l_index_number);
933: end loop;
934: --
935: hr_utility.set_location(l_proc, 60);
936: --
937: else
938: --
939: hr_utility.set_location(l_proc, 70);
935: hr_utility.set_location(l_proc, 60);
936: --
937: else
938: --
939: hr_utility.set_location(l_proc, 70);
940: --
941: close csr_formula_id;
942: end if;
943: --
946: wf_notification.setAttrText(l_nid,'FF3',l_ff3);
947: wf_notification.setAttrText(l_nid,'FF4',l_ff4);
948: wf_notification.setAttrText(l_nid,'FF5',l_ff5);
949: --
950: hr_utility.set_location(l_proc, 80);
951: --
952: return l_nid;
953: --
954: hr_utility.set_location('Leaving:'|| l_proc, 90);
950: hr_utility.set_location(l_proc, 80);
951: --
952: return l_nid;
953: --
954: hr_utility.set_location('Leaving:'|| l_proc, 90);
955: --
956: exception
957: when others then
958: hr_utility.set_location('Leaving:'|| l_proc, 100);
954: hr_utility.set_location('Leaving:'|| l_proc, 90);
955: --
956: exception
957: when others then
958: hr_utility.set_location('Leaving:'|| l_proc, 100);
959: l_nid:=null;
960: return l_nid;
961: end set_notification;
962:
999: l_nid number;
1000: l_proc varchar2(72) := g_package||'send_notification';
1001: begin
1002: --
1003: hr_utility.set_location('Entering:'|| l_proc, 10);
1004: --
1005: l_nid:=set_notification
1006: (p_notification => p_notification
1007: ,p_wf_name => p_wf_name
1036: ,p_supplier_reference => p_supplier_reference
1037: ,p_placement_date_start => p_placement_date_start
1038: ,p_grade_ladder => p_grade_ladder
1039: );
1040: hr_utility.set_location(l_proc, 20);
1041: --
1042: --Added for bug 5586890
1043: WF_NOTIFICATION.Denormalize_Notification(l_nid);
1044: commit;
1042: --Added for bug 5586890
1043: WF_NOTIFICATION.Denormalize_Notification(l_nid);
1044: commit;
1045: --
1046: hr_utility.set_location('Leaving:'|| l_proc, 30);
1047: --
1048: end send_notification;
1049: --
1050: procedure get_notification_preview
1090: l_body varchar2(4000);
1091: l_proc varchar2(72) := g_package||'get_notification_preview';
1092: begin
1093: --
1094: hr_utility.set_location('Entering:'|| l_proc, 10);
1095: --
1096: l_nid:=set_notification
1097: (p_notification => p_notification
1098: ,p_wf_name => p_wf_name
1127: ,p_supplier_reference => p_supplier_reference
1128: ,p_placement_date_start => p_placement_date_start
1129: ,p_grade_ladder => p_grade_ladder
1130: );
1131: hr_utility.set_location(l_proc, 20);
1132: --
1133: if l_nid is not null then
1134: hr_utility.set_location(l_proc, 30);
1135: l_subject:=wf_notification.getSubject(l_nid);
1130: );
1131: hr_utility.set_location(l_proc, 20);
1132: --
1133: if l_nid is not null then
1134: hr_utility.set_location(l_proc, 30);
1135: l_subject:=wf_notification.getSubject(l_nid);
1136: l_body:=wf_notification.getBody(l_nid);
1137: else
1138: hr_utility.set_location(l_proc, 40);
1134: hr_utility.set_location(l_proc, 30);
1135: l_subject:=wf_notification.getSubject(l_nid);
1136: l_body:=wf_notification.getBody(l_nid);
1137: else
1138: hr_utility.set_location(l_proc, 40);
1139: l_subject:=null;
1140: l_body:=null;
1141: end if;
1142: --
1144: --
1145: p_subject:=l_subject;
1146: p_body:=l_body;
1147: --
1148: hr_utility.set_location('Leaving:'|| l_proc, 50);
1149: --
1150: end get_notification_preview;
1151: --
1152: end per_qh_action;