[Home] [Help]
784:
785: -- Get the next item key from the sequence
786: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
787:
788: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
789:
790: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);
791: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'OBJECT_NAME',p_object_id);
792: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'OBJECT_TYPE' ,p_object_type);
786: select hr_workflow_item_key_s.nextval into l_item_key from sys.dual;
787:
788: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
789:
790: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);
791: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'OBJECT_NAME',p_object_id);
792: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'OBJECT_TYPE' ,p_object_type);
793: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'ERROR_NUMBER',p_error_learners);
794: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'SUCCESS_NUMBER',p_success_learners);
787:
788: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
789:
790: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);
791: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'OBJECT_NAME',p_object_id);
792: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'OBJECT_TYPE' ,p_object_type);
793: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'ERROR_NUMBER',p_error_learners);
794: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'SUCCESS_NUMBER',p_success_learners);
795:
788: WF_ENGINE.CREATEPROCESS(l_item_type, l_item_key, l_process);
789:
790: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);
791: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'OBJECT_NAME',p_object_id);
792: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'OBJECT_TYPE' ,p_object_type);
793: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'ERROR_NUMBER',p_error_learners);
794: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'SUCCESS_NUMBER',p_success_learners);
795:
796: IF p_person_id IS NOT NULL THEN
789:
790: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);
791: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'OBJECT_NAME',p_object_id);
792: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'OBJECT_TYPE' ,p_object_type);
793: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'ERROR_NUMBER',p_error_learners);
794: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'SUCCESS_NUMBER',p_success_learners);
795:
796: IF p_person_id IS NOT NULL THEN
797: OPEN csr_get_person_name(p_person_id);
790: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'CONC_REQUEST_ID',p_conc_program_request_id);
791: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'OBJECT_NAME',p_object_id);
792: WF_ENGINE.setitemattrtext(l_item_type, l_item_key, 'OBJECT_TYPE' ,p_object_type);
793: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'ERROR_NUMBER',p_error_learners);
794: WF_ENGINE.setitemattrnumber(l_item_type,l_item_key,'SUCCESS_NUMBER',p_success_learners);
795:
796: IF p_person_id IS NOT NULL THEN
797: OPEN csr_get_person_name(p_person_id);
798: FETCH csr_get_person_name INTO l_person_full_name;
804:
805: --fnd_file.put_line(FND_FILE.LOG,'Requestor Name ' ||l_person_full_name);
806:
807: IF l_person_full_name IS NOT NULL then
808: WF_ENGINE.setitemattrtext(l_item_type,l_item_key,'EVENT_OWNER',l_user_name);
809: END IF;
810: END IF;
811:
812: -- Get and set owner role
818: p_name =>l_role_name,
819: p_display_name =>l_role_display_name);
820:
821:
822: WF_ENGINE.SetItemOwner(itemtype => l_item_type,
823: itemkey =>l_item_key,
824: owner =>l_role_name);
825:
826: hr_utility.set_location('After Setting Owner'||l_proc, 10);
825:
826: hr_utility.set_location('After Setting Owner'||l_proc, 10);
827:
828:
829: WF_ENGINE.STARTPROCESS(l_item_type,l_item_key);
830:
831: hr_utility.set_location('leaving:'||l_proc, 20);
832:
833: EXCEPTION