eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_APPRAISAL_WORKFLOW_SS dependencies on WF_ENGINE

Line 71: if (funmode <> wf_engine.eng_run) then

67: ln_appraisal_id number;
68: l_system_params per_appraisals.system_params%type;
69: begin
70: -- Do nothing in cancel or timeout mode
71: if (funmode <> wf_engine.eng_run) then
72: result := wf_engine.eng_null;
73: return;
74: else
75: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);

Line 72: result := wf_engine.eng_null;

68: l_system_params per_appraisals.system_params%type;
69: begin
70: -- Do nothing in cancel or timeout mode
71: if (funmode <> wf_engine.eng_run) then
72: result := wf_engine.eng_null;
73: return;
74: else
75: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
76: if(ln_appraisal_id is null) then

Line 75: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);

71: if (funmode <> wf_engine.eng_run) then
72: result := wf_engine.eng_null;
73: return;
74: else
75: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
76: if(ln_appraisal_id is null) then
77: raise g_invalid_appraisal_id;
78: else
79: -- get the system params from per_appraisals

Line 150: ln_login_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CREATOR_PERSON_ID',true);

146: IF g_debug THEN
147: l_proc := gv_package||'start_transaction';
148: hr_utility.set_location('Entering:'|| l_proc, 5);
149: END IF;
150: ln_login_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CREATOR_PERSON_ID',true);
151: ln_assignment_id := wf_engine.getitemattrnumber(itemtype,itemkey,'ASSIGNMENT_ID',true);
152: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
153: ln_selected_person_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HR_APPRAISEE_PERSON_ID',true);
154: lv_process_name := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PROCESS_NAME',true);

Line 151: ln_assignment_id := wf_engine.getitemattrnumber(itemtype,itemkey,'ASSIGNMENT_ID',true);

147: l_proc := gv_package||'start_transaction';
148: hr_utility.set_location('Entering:'|| l_proc, 5);
149: END IF;
150: ln_login_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CREATOR_PERSON_ID',true);
151: ln_assignment_id := wf_engine.getitemattrnumber(itemtype,itemkey,'ASSIGNMENT_ID',true);
152: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
153: ln_selected_person_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HR_APPRAISEE_PERSON_ID',true);
154: lv_process_name := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PROCESS_NAME',true);
155:

Line 152: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);

148: hr_utility.set_location('Entering:'|| l_proc, 5);
149: END IF;
150: ln_login_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CREATOR_PERSON_ID',true);
151: ln_assignment_id := wf_engine.getitemattrnumber(itemtype,itemkey,'ASSIGNMENT_ID',true);
152: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
153: ln_selected_person_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HR_APPRAISEE_PERSON_ID',true);
154: lv_process_name := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PROCESS_NAME',true);
155:
156: hr_transaction_ss.start_transaction(itemtype=>itemtype

Line 153: ln_selected_person_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HR_APPRAISEE_PERSON_ID',true);

149: END IF;
150: ln_login_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CREATOR_PERSON_ID',true);
151: ln_assignment_id := wf_engine.getitemattrnumber(itemtype,itemkey,'ASSIGNMENT_ID',true);
152: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
153: ln_selected_person_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HR_APPRAISEE_PERSON_ID',true);
154: lv_process_name := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PROCESS_NAME',true);
155:
156: hr_transaction_ss.start_transaction(itemtype=>itemtype
157: ,itemkey=>itemkey

Line 154: lv_process_name := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PROCESS_NAME',true);

150: ln_login_person_id := wf_engine.getitemattrnumber(itemtype,itemkey,'CREATOR_PERSON_ID',true);
151: ln_assignment_id := wf_engine.getitemattrnumber(itemtype,itemkey,'ASSIGNMENT_ID',true);
152: ln_appraisal_id:= wf_engine.GetItemAttrNumber(itemtype,itemkey,'APPRAISAL_ID',true);
153: ln_selected_person_id := wf_engine.GetItemAttrNumber(itemtype,itemkey,'HR_APPRAISEE_PERSON_ID',true);
154: lv_process_name := wf_engine.GetItemAttrNumber(itemtype,itemkey,'PROCESS_NAME',true);
155:
156: hr_transaction_ss.start_transaction(itemtype=>itemtype
157: ,itemkey=>itemkey
158: ,actid=>itemkey

Line 204: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,

200:
201: begin
202: hr_utility.set_location('Entered:'|| gv_package || '.create_hr_transaction', 1);
203: -- get the appraisal_id from the item attribute , APPRAISAL_ID
204: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
205: itemkey => p_itemkey ,
206: aname => 'APPRAISAL_ID',
207: ignore_notfound=>true);
208: -- query the other details from per_appraisals for the given l_appraisal_id

Line 240: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR',l_appraisee_user_name);

236: -- get the role for the Appraisee
237: wf_directory.getrolename(g_orig_system,l_appraisee_person_id,l_appraisee_user_name,l_display_name);
238:
239: if(item_attribute_exists(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR')) then
240: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR',l_appraisee_user_name);
241: else
242: wf_engine.additemattr(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR',l_appraisee_user_name,null,null);
243: end if;
244: --SUPERVISOR_USERNAME

Line 242: wf_engine.additemattr(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR',l_appraisee_user_name,null,null);

238:
239: if(item_attribute_exists(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR')) then
240: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR',l_appraisee_user_name);
241: else
242: wf_engine.additemattr(p_itemtype,p_itemkey,'HR_APPRAISEE_USER_NAME_ATTR',l_appraisee_user_name,null,null);
243: end if;
244: --SUPERVISOR_USERNAME
245: -- get the role for appraisee supervisor
246: wf_directory.getrolename(g_orig_system,l_main_appraiser_id,l_supervisor_user_name,l_display_name);

Line 248: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME',l_supervisor_user_name);

244: --SUPERVISOR_USERNAME
245: -- get the role for appraisee supervisor
246: wf_directory.getrolename(g_orig_system,l_main_appraiser_id,l_supervisor_user_name,l_display_name);
247: if(item_attribute_exists(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME')) then
248: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME',l_supervisor_user_name);
249: else
250: wf_engine.additemattr(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME',l_supervisor_user_name,null,null);
251: end if;
252:

Line 250: wf_engine.additemattr(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME',l_supervisor_user_name,null,null);

246: wf_directory.getrolename(g_orig_system,l_main_appraiser_id,l_supervisor_user_name,l_display_name);
247: if(item_attribute_exists(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME')) then
248: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME',l_supervisor_user_name);
249: else
250: wf_engine.additemattr(p_itemtype,p_itemkey,'SUPERVISOR_USERNAME',l_supervisor_user_name,null,null);
251: end if;
252:
253:
254: --

Line 257: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR','hr_appraisal_workflow_ss.set_appraisal_rfc_status');

253:
254: --
255: --set the RFC call back function
256: if(item_attribute_exists(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR')) then
257: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR','hr_appraisal_workflow_ss.set_appraisal_rfc_status');
258: else
259: wf_engine.additemattr(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR','hr_appraisal_workflow_ss.set_appraisal_rfc_status',null,null);
260: end if;
261:

Line 259: wf_engine.additemattr(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR','hr_appraisal_workflow_ss.set_appraisal_rfc_status',null,null);

255: --set the RFC call back function
256: if(item_attribute_exists(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR')) then
257: wf_engine.setitemattrtext(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR','hr_appraisal_workflow_ss.set_appraisal_rfc_status');
258: else
259: wf_engine.additemattr(p_itemtype,p_itemkey,'HR_RFC_CB_ATTR','hr_appraisal_workflow_ss.set_appraisal_rfc_status',null,null);
260: end if;
261:
262: -- 06/02/03
263: -- 06/15/03

Line 269: p_result:= wf_engine.eng_trans_default;

265:
266: -- 07/10/03
267: -- set the item key to the system params
268: setAppraisalSystemParams(p_itemtype,p_itemkey, p_actid, p_funcmode, p_result );
269: p_result:= wf_engine.eng_trans_default;
270:
271:
272: hr_utility.set_location('Leaving:'|| gv_package || '.create_hr_transaction', 10);
273:

Line 326: lv_pageFunc := nvl(wf_engine.GetItemAttrText(lv_item_type,lv_item_key,'HR_OAF_EDIT_URL_ATTR',TRUE),'PQH_SS_EFFDATE');

322: -- build the url link
323: -- get the link details
324: -- get the item attribute holding the FND function name corresponding
325: -- to the MDS document.
326: lv_pageFunc := nvl(wf_engine.GetItemAttrText(lv_item_type,lv_item_key,'HR_OAF_EDIT_URL_ATTR',TRUE),'PQH_SS_EFFDATE');
327: -- get the web_html_call value and params for this function
328: begin
329: select web_html_call,parameters
330: into lv_web_html_call,lv_params

Line 403: if (funcmode <> wf_engine.eng_run) then

399: document_type varchar2(240);
400:
401: begin
402: -- Do nothing in cancel or timeout mode
403: if (funcmode <> wf_engine.eng_run) then
404: resultout := wf_engine.eng_null;
405: return;
406: end if;
407:

Line 404: resultout := wf_engine.eng_null;

400:
401: begin
402: -- Do nothing in cancel or timeout mode
403: if (funcmode <> wf_engine.eng_run) then
404: resultout := wf_engine.eng_null;
405: return;
406: end if;
407:
408:

Line 410: prole := wf_engine.GetActivityAttrText(

406: end if;
407:
408:
409: --PERFORMER
410: prole := wf_engine.GetActivityAttrText(
411: itemtype => itemtype,
412: itemkey => itemkey,
413: actid => actid,
414: aname => 'PERFORMER');

Line 424: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

420: Wf_Core.Raise('WFENG_NOTIFICATION_PERFORMER');
421: end if;
422:
423: -- message name and expand roles will be null. Get these from attributes
424: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
425: actid, 'MESSAGE'));
426:
427: -- let notification_send catch a missing message name.
428: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

Line 428: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,

424: avalue := upper(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
425: actid, 'MESSAGE'));
426:
427: -- let notification_send catch a missing message name.
428: expand_role := nvl(Wf_Engine.GetActivityAttrText(itemtype, itemkey,
429: actid, 'EXPANDROLES'),'N');
430:
431: -- parse out the message type if given
432: colon := instr(avalue, ':');

Line 443: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,

439: end if;
440:
441:
442: -- Actually send the notification
443: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,
444: msg, msgtype, prole, expand_role,
445: resultout);
446:
447: notid:= Wf_Engine.g_nid ;

Line 447: notid:= Wf_Engine.g_nid ;

443: Wf_Engine_Util.Notification_Send(itemtype, itemkey, actid,
444: msg, msgtype, prole, expand_role,
445: resultout);
446:
447: notid:= Wf_Engine.g_nid ;
448:
449: exception
450: when others then
451: Wf_Core.Context(gv_package, 'Notify', itemtype,

Line 467: if(funcmode=wf_engine.eng_run) then

463: ignore_notfound boolean default true;
464:
465: begin
466:
467: if(funcmode=wf_engine.eng_run) then
468: --check if we need to notify Main Appraiser,
469: -- this will be the only mode this function will
470: -- run the first time. On all other occassions it is
471: -- in notified state and need to complete using the proper result code

Line 473: if(wf_engine.getitemattrtext(itemtype,itemkey,'HR_BLOCK_ATTR',ignore_notfound)='N') then

469: -- this will be the only mode this function will
470: -- run the first time. On all other occassions it is
471: -- in notified state and need to complete using the proper result code
472: -- get the item attribute value , HR_BLOCK_ATTR
473: if(wf_engine.getitemattrtext(itemtype,itemkey,'HR_BLOCK_ATTR',ignore_notfound)='N') then
474: resultout:='HR_MAIN_APPRAISER';
475: -- now reset item attribute so that next pass will block this activity
476: wf_engine.setitemattrtext(itemtype,itemkey,'HR_BLOCK_ATTR','Y');
477: -- check the item attribute 'HR_MAIN_APPRAISER_USERNAME' exists

Line 476: wf_engine.setitemattrtext(itemtype,itemkey,'HR_BLOCK_ATTR','Y');

472: -- get the item attribute value , HR_BLOCK_ATTR
473: if(wf_engine.getitemattrtext(itemtype,itemkey,'HR_BLOCK_ATTR',ignore_notfound)='N') then
474: resultout:='HR_MAIN_APPRAISER';
475: -- now reset item attribute so that next pass will block this activity
476: wf_engine.setitemattrtext(itemtype,itemkey,'HR_BLOCK_ATTR','Y');
477: -- check the item attribute 'HR_MAIN_APPRAISER_USERNAME' exists
478: -- do we need make the check ???
479: else
480: resultout:=wf_engine.eng_notified;

Line 480: resultout:=wf_engine.eng_notified;

476: wf_engine.setitemattrtext(itemtype,itemkey,'HR_BLOCK_ATTR','Y');
477: -- check the item attribute 'HR_MAIN_APPRAISER_USERNAME' exists
478: -- do we need make the check ???
479: else
480: resultout:=wf_engine.eng_notified;
481: -- update the item attribute with the current activity id to
482: -- be completed from external java or pl/sql program.
483: -- HR_APPRAI_MAIN_BLOCK_ID_ATTR
484: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR',actid);

Line 484: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR',actid);

480: resultout:=wf_engine.eng_notified;
481: -- update the item attribute with the current activity id to
482: -- be completed from external java or pl/sql program.
483: -- HR_APPRAI_MAIN_BLOCK_ID_ATTR
484: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR',actid);
485: end if;
486: end if;
487:
488:

Line 507: if (funcmode <> wf_engine.eng_run) then

503: --local variables
504:
505: begin
506: -- Do nothing in cancel or timeout mode
507: if (funcmode <> wf_engine.eng_run) then
508: resultout := wf_engine.eng_null;
509: return;
510: end if;
511:

Line 508: resultout := wf_engine.eng_null;

504:
505: begin
506: -- Do nothing in cancel or timeout mode
507: if (funcmode <> wf_engine.eng_run) then
508: resultout := wf_engine.eng_null;
509: return;
510: end if;
511:
512:

Line 531: if (funcmode <> wf_engine.eng_run) then

527: --local variables
528:
529: begin
530: -- Do nothing in cancel or timeout mode
531: if (funcmode <> wf_engine.eng_run) then
532: resultout := wf_engine.eng_null;
533: return;
534: end if;
535:

Line 532: resultout := wf_engine.eng_null;

528:
529: begin
530: -- Do nothing in cancel or timeout mode
531: if (funcmode <> wf_engine.eng_run) then
532: resultout := wf_engine.eng_null;
533: return;
534: end if;
535:
536:

Line 562: test := wf_engine.GetItemAttrNumber(itemtype,itemkey,'COUNTER',ignore_notfound);

558: test number;
559:
560: begin
561: -- test mode
562: test := wf_engine.GetItemAttrNumber(itemtype,itemkey,'COUNTER',ignore_notfound);
563: -- update the counter
564: wf_engine.SetItemAttrNumber(itemtype,itemkey,'COUNTER',test+1);
565: if(test >10) then
566: resultout := 'COMPLETE:F';

Line 564: wf_engine.SetItemAttrNumber(itemtype,itemkey,'COUNTER',test+1);

560: begin
561: -- test mode
562: test := wf_engine.GetItemAttrNumber(itemtype,itemkey,'COUNTER',ignore_notfound);
563: -- update the counter
564: wf_engine.SetItemAttrNumber(itemtype,itemkey,'COUNTER',test+1);
565: if(test >10) then
566: resultout := 'COMPLETE:F';
567: return;
568: end if;

Line 572: if (funcmode <> wf_engine.eng_run) then

568: end if;
569:
570: -- end test mode
571: -- Do nothing in cancel or timeout mode
572: if (funcmode <> wf_engine.eng_run) then
573: resultout := wf_engine.eng_null;
574: return;
575: end if;
576:

Line 573: resultout := wf_engine.eng_null;

569:
570: -- end test mode
571: -- Do nothing in cancel or timeout mode
572: if (funcmode <> wf_engine.eng_run) then
573: resultout := wf_engine.eng_null;
574: return;
575: end if;
576:
577: if(funcmode=wf_engine.eng_run) then

Line 577: if(funcmode=wf_engine.eng_run) then

573: resultout := wf_engine.eng_null;
574: return;
575: end if;
576:
577: if(funcmode=wf_engine.eng_run) then
578:
579: -- get the list HR_APPRA_PARTIC_LIST_ID_ATTR
580: lv_participants_list := wf_engine.GetItemAttrText(itemtype,itemkey,'HR_APPRA_PARTIC_LIST_ID_ATTR',ignore_notfound);
581:

Line 580: lv_participants_list := wf_engine.GetItemAttrText(itemtype,itemkey,'HR_APPRA_PARTIC_LIST_ID_ATTR',ignore_notfound);

576:
577: if(funcmode=wf_engine.eng_run) then
578:
579: -- get the list HR_APPRA_PARTIC_LIST_ID_ATTR
580: lv_participants_list := wf_engine.GetItemAttrText(itemtype,itemkey,'HR_APPRA_PARTIC_LIST_ID_ATTR',ignore_notfound);
581:
582:
583: -- check if the list is empty
584: if((lv_participants_list is null) or lv_participants_list='') then

Line 605: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);

601: -- get the role details for the participant and set the item attributes
602: wf_directory.getrolename(g_orig_system,ln_particpant_person_id,lv_particpant_user_name,lv_particpant_display_name);
603: -- set the details to the performer for the participant
604: -- HR_APPRA_PARTIC_USER_NAME_ATTR and HR_APPRA_PARTIC_DISP_NAME_ATTR , HR_APPRA_PARTICP_PER_ID_ATTR
605: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);
606: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);
607: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_particpant_person_id);
608:
609: -- update the lv_participants_list into item attribute HR_APPRA_PARTIC_LIST_ID_ATTR

Line 606: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);

602: wf_directory.getrolename(g_orig_system,ln_particpant_person_id,lv_particpant_user_name,lv_particpant_display_name);
603: -- set the details to the performer for the participant
604: -- HR_APPRA_PARTIC_USER_NAME_ATTR and HR_APPRA_PARTIC_DISP_NAME_ATTR , HR_APPRA_PARTICP_PER_ID_ATTR
605: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);
606: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);
607: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_particpant_person_id);
608:
609: -- update the lv_participants_list into item attribute HR_APPRA_PARTIC_LIST_ID_ATTR
610: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_LIST_ID_ATTR',lv_participants_list);

Line 607: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_particpant_person_id);

603: -- set the details to the performer for the participant
604: -- HR_APPRA_PARTIC_USER_NAME_ATTR and HR_APPRA_PARTIC_DISP_NAME_ATTR , HR_APPRA_PARTICP_PER_ID_ATTR
605: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);
606: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);
607: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_particpant_person_id);
608:
609: -- update the lv_participants_list into item attribute HR_APPRA_PARTIC_LIST_ID_ATTR
610: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_LIST_ID_ATTR',lv_participants_list);
611: resultout := 'COMPLETE:T';

Line 610: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_LIST_ID_ATTR',lv_participants_list);

606: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);
607: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_particpant_person_id);
608:
609: -- update the lv_participants_list into item attribute HR_APPRA_PARTIC_LIST_ID_ATTR
610: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_LIST_ID_ATTR',lv_participants_list);
611: resultout := 'COMPLETE:T';
612:
613: end if;
614: exception

Line 637: if (funcmode <> wf_engine.eng_run) then

633: ln_appraisal_id number;
634: type_value varchar2(30);
635: begin
636: -- Do nothing in cancel or timeout mode
637: if (funcmode <> wf_engine.eng_run) then
638: resultout := wf_engine.eng_null;
639: return;
640: end if;
641:

Line 638: resultout := wf_engine.eng_null;

634: type_value varchar2(30);
635: begin
636: -- Do nothing in cancel or timeout mode
637: if (funcmode <> wf_engine.eng_run) then
638: resultout := wf_engine.eng_null;
639: return;
640: end if;
641:
642: if(funcmode=wf_engine.eng_run) then

Line 642: if(funcmode=wf_engine.eng_run) then

638: resultout := wf_engine.eng_null;
639: return;
640: end if;
641:
642: if(funcmode=wf_engine.eng_run) then
643: -- get the Appraisal id
644: ln_appraisal_id:= wf_engine.getitemattrNumber(itemtype,itemkey,'APPRAISAL_ID');
645: -- get the partcipant id
646: ln_participant_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_ID_ATTR');

Line 644: ln_appraisal_id:= wf_engine.getitemattrNumber(itemtype,itemkey,'APPRAISAL_ID');

640: end if;
641:
642: if(funcmode=wf_engine.eng_run) then
643: -- get the Appraisal id
644: ln_appraisal_id:= wf_engine.getitemattrNumber(itemtype,itemkey,'APPRAISAL_ID');
645: -- get the partcipant id
646: ln_participant_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_ID_ATTR');
647: --ln_participant_person_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR');
648:

Line 646: ln_participant_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_ID_ATTR');

642: if(funcmode=wf_engine.eng_run) then
643: -- get the Appraisal id
644: ln_appraisal_id:= wf_engine.getitemattrNumber(itemtype,itemkey,'APPRAISAL_ID');
645: -- get the partcipant id
646: ln_participant_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_ID_ATTR');
647: --ln_participant_person_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR');
648:
649: if(ln_appraisal_id is null) then
650: raise g_invalid_appraisal_id;

Line 647: --ln_participant_person_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR');

643: -- get the Appraisal id
644: ln_appraisal_id:= wf_engine.getitemattrNumber(itemtype,itemkey,'APPRAISAL_ID');
645: -- get the partcipant id
646: ln_participant_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_ID_ATTR');
647: --ln_participant_person_id := wf_engine.getitemattrNumber(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR');
648:
649: if(ln_appraisal_id is null) then
650: raise g_invalid_appraisal_id;
651: elsif (ln_participant_id is null) then

Line 666: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);

662: -- get the role details for the participant and set the item attributes
663: wf_directory.getrolename(g_orig_system,ln_participant_person_id,lv_particpant_user_name,lv_particpant_display_name);
664: -- set the details to the performer for the participant
665: -- HR_APPRA_PARTIC_USER_NAME_ATTR and HR_APPRA_PARTIC_DISP_NAME_ATTR , HR_APPRA_PARTICP_PER_ID_ATTR
666: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);
667: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);
668: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_participant_person_id);
669:
670: -- HR_APPRA_APPRAISER,HR_APPRA_OTHER_PARTICP,HR_APPRA_REVIEWER

Line 667: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);

663: wf_directory.getrolename(g_orig_system,ln_participant_person_id,lv_particpant_user_name,lv_particpant_display_name);
664: -- set the details to the performer for the participant
665: -- HR_APPRA_PARTIC_USER_NAME_ATTR and HR_APPRA_PARTIC_DISP_NAME_ATTR , HR_APPRA_PARTICP_PER_ID_ATTR
666: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);
667: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);
668: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_participant_person_id);
669:
670: -- HR_APPRA_APPRAISER,HR_APPRA_OTHER_PARTICP,HR_APPRA_REVIEWER
671: -- MAINAP REVIEWER GROUPAPPRAISER OTHERPARTICIPANT

Line 668: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_participant_person_id);

664: -- set the details to the performer for the participant
665: -- HR_APPRA_PARTIC_USER_NAME_ATTR and HR_APPRA_PARTIC_DISP_NAME_ATTR , HR_APPRA_PARTICP_PER_ID_ATTR
666: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_USER_NAME_ATTR',lv_particpant_user_name);
667: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTIC_DISP_NAME_ATTR',lv_particpant_display_name);
668: wf_engine.setitemattrtext(itemtype,itemkey,'HR_APPRA_PARTICP_PER_ID_ATTR',ln_participant_person_id);
669:
670: -- HR_APPRA_APPRAISER,HR_APPRA_OTHER_PARTICP,HR_APPRA_REVIEWER
671: -- MAINAP REVIEWER GROUPAPPRAISER OTHERPARTICIPANT
672:

Line 706: if (funmode <> wf_engine.eng_run) then

702: --local variables
703:
704: begin
705: -- Do nothing in cancel or timeout mode
706: if (funmode <> wf_engine.eng_run) then
707: result := wf_engine.eng_null;
708: return;
709: end if;
710: -- set the item attribute value with the current activity id

Line 707: result := wf_engine.eng_null;

703:
704: begin
705: -- Do nothing in cancel or timeout mode
706: if (funmode <> wf_engine.eng_run) then
707: result := wf_engine.eng_null;
708: return;
709: end if;
710: -- set the item attribute value with the current activity id
711: -- this will be used when the participants notification is sent.

Line 714: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR',actid);

710: -- set the item attribute value with the current activity id
711: -- this will be used when the participants notification is sent.
712: -- and to complete the blocked thread.
713: -- HR_APPRAI_PARTCI_BLOCK_ID_ATTR
714: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR',actid);
715: WF_STANDARD.BLOCK(itemtype,itemkey,actid,funmode,result);
716:
717: --resultout := 'NOTIFIED';
718:

Line 737: if (funmode <> wf_engine.eng_run) then

733: --local variables
734:
735: begin
736: -- Do nothing in cancel or timeout mode
737: if (funmode <> wf_engine.eng_run) then
738: result := wf_engine.eng_null;
739: return;
740: end if;
741: -- set the item attribute value with the current activity id

Line 738: result := wf_engine.eng_null;

734:
735: begin
736: -- Do nothing in cancel or timeout mode
737: if (funmode <> wf_engine.eng_run) then
738: result := wf_engine.eng_null;
739: return;
740: end if;
741: -- set the item attribute value with the current activity id
742: -- this will be used when the participants notification is sent.

Line 751: wf_engine.additemattr

747: (p_item_type => itemtype
748: ,p_item_key => itemkey
749: ,p_name => 'HR_COMPETENCE_ENHANCEMENT_SS') then
750: -- the item attribute does not exist so create it
751: wf_engine.additemattr
752: (itemtype => itemtype
753: ,itemkey => itemkey
754: ,aname => 'HR_COMPETENCE_ENHANCEMENT_SS');
755: end if;

Line 756: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_APPR_BLOCK_ID_ATTR',actid);

752: (itemtype => itemtype
753: ,itemkey => itemkey
754: ,aname => 'HR_COMPETENCE_ENHANCEMENT_SS');
755: end if;
756: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_APPR_BLOCK_ID_ATTR',actid);
757: WF_STANDARD.BLOCK(itemtype,itemkey,actid,funmode,result);
758:
759: --resultout := 'NOTIFIED';
760:

Line 780: if(funmode=wf_engine.eng_run) then

776: ignore_notfound boolean default true;
777:
778: begin
779:
780: if(funmode=wf_engine.eng_run) then
781: result:=wf_engine.eng_notified;
782: -- update the item attribute with the current activity id to
783: -- be completed from external java or pl/sql program.
784: -- HR_APPRAI_MAIN_BLOCK_ID_ATTR

Line 781: result:=wf_engine.eng_notified;

777:
778: begin
779:
780: if(funmode=wf_engine.eng_run) then
781: result:=wf_engine.eng_notified;
782: -- update the item attribute with the current activity id to
783: -- be completed from external java or pl/sql program.
784: -- HR_APPRAI_MAIN_BLOCK_ID_ATTR
785: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR',actid);

Line 785: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR',actid);

781: result:=wf_engine.eng_notified;
782: -- update the item attribute with the current activity id to
783: -- be completed from external java or pl/sql program.
784: -- HR_APPRAI_MAIN_BLOCK_ID_ATTR
785: wf_engine.setitemattrnumber(itemtype,itemkey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR',actid);
786: end if;
787: exception
788: when others then
789: Wf_Core.Context(gv_package, '.appraisee_or_appraiser_block', itemtype,

Line 805: ln_appr_main_block_id := wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR');

801: ln_appr_particp_block_id number;
802: ln_appr_approval_block_id number;
803:
804: begin
805: ln_appr_main_block_id := wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR');
806: ln_appr_particp_block_id:= wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR');
807: begin
808: if(hr_utility.debug_enabled) then
809: -- write debug statements

Line 806: ln_appr_particp_block_id:= wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR');

802: ln_appr_approval_block_id number;
803:
804: begin
805: ln_appr_main_block_id := wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_MAIN_BLOCK_ID_ATTR');
806: ln_appr_particp_block_id:= wf_engine.getitemattrnumber(getApprovalBlockId.p_itemType,getApprovalBlockId.p_itemKey,'HR_APPRAI_PARTCI_BLOCK_ID_ATTR');
807: begin
808: if(hr_utility.debug_enabled) then
809: -- write debug statements
810: hr_utility.set_location('Querying WF_ITEM_ACTIVITY_STATUSES for notified activity:'||lv_procedure_name||'with itemtype:', 3);

Line 878: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,

874:
875: begin
876: hr_utility.set_location('Entered:'|| gv_package || '.reset_main_appraiser', 1);
877: -- get the appraisal_id from the item attribute , APPRAISAL_ID
878: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
879: itemkey => p_itemkey ,
880: aname => 'APPRAISAL_ID',
881: ignore_notfound=>true);
882: -- query the other details from per_appraisals for the given l_appraisal_id

Line 909: wf_engine.setItemOwner(itemtype => p_itemtype

905:
906: -- ---------------------------------------------------
907: -- Set the Item Owner
908: -- ---------------------------------------------------
909: wf_engine.setItemOwner(itemtype => p_itemtype
910: ,itemkey => p_itemkey
911: ,owner => l_role_name);
912: --CREATOR_PERSON
913: hr_workflow_service.create_hr_directory_services

Line 920: p_result := wf_engine.eng_trans_default;

916: ,p_service_name => 'CREATOR_PERSON'
917: ,p_service_person_id => l_main_appraiser_id);
918: --
919:
920: p_result := wf_engine.eng_trans_default;
921:
922:
923:
924: hr_utility.set_location('Leaving:'|| gv_package || '.reset_main_appraiser', 10);

Line 990: hr_utility.set_location('Calling wf_engine.GetItemAttrNumber for APPRAISAL_ID with itemtype:itemkey '||p_itemtype||':'||p_itemkey,2);

986: hr_utility.set_location('Entered:'|| gv_package || '.update_appraisal_system_status', 1);
987: -- get the appraisal_id from the item attribute , APPRAISAL_ID
988: if(hr_utility.debug_enabled) then
989: -- write debug statements
990: hr_utility.set_location('Calling wf_engine.GetItemAttrNumber for APPRAISAL_ID with itemtype:itemkey '||p_itemtype||':'||p_itemkey,2);
991: end if;
992: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
993: itemkey => p_itemkey ,
994: aname => 'APPRAISAL_ID',

Line 992: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,

988: if(hr_utility.debug_enabled) then
989: -- write debug statements
990: hr_utility.set_location('Calling wf_engine.GetItemAttrNumber for APPRAISAL_ID with itemtype:itemkey '||p_itemtype||':'||p_itemkey,2);
991: end if;
992: l_appraisal_id:= wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
993: itemkey => p_itemkey ,
994: aname => 'APPRAISAL_ID',
995: ignore_notfound=>true);
996: begin

Line 1077: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRAN_SUBMIT','N');

1073: -- call the update_appraisal_system_status with proper status
1074: update_appraisal_system_status(p_itemtype=>p_itemtype, p_itemkey=>p_itemkey,p_status=>'ONGOING');
1075: -- set the our param as *
1076: p_result:='COMPLETE:*';
1077: wf_engine.SetItemAttrText(p_itemtype,p_itemkey,'TRAN_SUBMIT','N');
1078:
1079: hr_utility.set_location('Leaving:'|| gv_package || '.set_appraisal_reject_status', 10);
1080:
1081: EXCEPTION

Line 1135: document := wf_engine.GetItemAttrText(lv_item_type,

1131: -- get the itemtype and item key for the notification id
1132: hr_workflow_ss.get_item_type_and_key(document_id,lv_item_type,lv_item_key);
1133: -- build the log message, the log is restricted to 32k
1134: -- assumed the code setting the item attributes has the necessary format.
1135: document := wf_engine.GetItemAttrText(lv_item_type,
1136: lv_item_key,
1137: hr_complete_appraisal_ss.gv_upd_appr_status_log,
1138: true)
1139: ||wf_engine.GetItemAttrText(lv_item_type,

Line 1139: ||wf_engine.GetItemAttrText(lv_item_type,

1135: document := wf_engine.GetItemAttrText(lv_item_type,
1136: lv_item_key,
1137: hr_complete_appraisal_ss.gv_upd_appr_status_log,
1138: true)
1139: ||wf_engine.GetItemAttrText(lv_item_type,
1140: lv_item_key,
1141: hr_complete_appraisal_ss.gv_apply_asses_comps_log,
1142: true)
1143: ||wf_engine.GetItemAttrText(lv_item_type,

Line 1143: ||wf_engine.GetItemAttrText(lv_item_type,

1139: ||wf_engine.GetItemAttrText(lv_item_type,
1140: lv_item_key,
1141: hr_complete_appraisal_ss.gv_apply_asses_comps_log,
1142: true)
1143: ||wf_engine.GetItemAttrText(lv_item_type,
1144: lv_item_key,
1145: hr_complete_appraisal_ss.gv_create_event_log,
1146: true)
1147: || wf_engine.GetItemAttrText(lv_item_type,

Line 1147: || wf_engine.GetItemAttrText(lv_item_type,

1143: ||wf_engine.GetItemAttrText(lv_item_type,
1144: lv_item_key,
1145: hr_complete_appraisal_ss.gv_create_event_log,
1146: true)
1147: || wf_engine.GetItemAttrText(lv_item_type,
1148: lv_item_key,
1149: hr_complete_appraisal_ss.gv_upd_trn_act_status_log ,
1150: true);
1151:

Line 1203: l_appraisal_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,

1199: chg_appr_status varchar2(2);
1200: begin
1201: hr_utility.set_location('Entered:'|| gv_package || '.appraisee_feedback_allowed', 1);
1202:
1203: l_appraisal_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
1204: itemkey => p_itemkey ,
1205: aname => 'APPRAISAL_ID',
1206: ignore_notfound=>true);
1207:

Line 1255: l_appraisal_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,

1251: chg_appr_status varchar2(2);
1252: begin
1253: hr_utility.set_location('Entered:'|| gv_package || '.appraisee_commit_aft_feedback', 1);
1254:
1255: l_appraisal_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype ,
1256: itemkey => p_itemkey ,
1257: aname => 'APPRAISAL_ID',
1258: ignore_notfound=>true);
1259:

Line 1292: if (p_funcmode <> wf_engine.eng_run) then

1288: )
1289: is
1290: begin
1291:
1292: if (p_funcmode <> wf_engine.eng_run) then
1293: p_result := wf_engine.eng_null;
1294: return;
1295: end if;
1296:

Line 1293: p_result := wf_engine.eng_null;

1289: is
1290: begin
1291:
1292: if (p_funcmode <> wf_engine.eng_run) then
1293: p_result := wf_engine.eng_null;
1294: return;
1295: end if;
1296:
1297: Notify(itemtype => p_itemtype,

Line 1309: wf_engine.additemattr

1305: (p_item_type => p_itemtype
1306: ,p_item_key => p_itemkey
1307: ,p_name => 'HR_APPR_NOTIF_BLOCK_ID_ATTR') then
1308: -- the item attribute does not exist so create it
1309: wf_engine.additemattr
1310: (itemtype => p_itemtype
1311: ,itemkey => p_itemkey
1312: ,aname => 'HR_APPR_NOTIF_BLOCK_ID_ATTR');
1313: end if;

Line 1315: wf_engine.setitemattrnumber(p_itemtype,p_itemkey,'HR_APPR_NOTIF_BLOCK_ID_ATTR',p_actid);

1311: ,itemkey => p_itemkey
1312: ,aname => 'HR_APPR_NOTIF_BLOCK_ID_ATTR');
1313: end if;
1314:
1315: wf_engine.setitemattrnumber(p_itemtype,p_itemkey,'HR_APPR_NOTIF_BLOCK_ID_ATTR',p_actid);
1316: WF_STANDARD.BLOCK(p_itemtype,p_itemkey,p_actid,p_funcmode,p_result); --TBD uncomment this line
1317:
1318: exception
1319: when others then