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.PAY_US_WORKFLOW_API_PKG dependencies on WF_ENGINE

Line 51: -- step must be performed. A call to wf_engine.CompleteActivty

47: -- - DEFERED
48: -- execution should be defered to background
49: -- - NOTIFIED[: 50: -- activity has notified an external entity that this
51: -- step must be performed. A call to wf_engine.CompleteActivty
52: -- will signal when this step is complete. Optional
53: -- return of notification ID and assigned user.
54: -- - ERROR[: 55: -- function encountered an error.

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

203: lv_aname varchar2(30);
204:
205: begin
206: -- Do nothing in cancel or timeout mode
207: if (funcmode <> wf_engine.eng_run) then
208: resultout := wf_engine.eng_null;
209: else
210:
211: lv_aname := PAY_WORKFLOW_API_PKG.set_value(itemtype,itemkey,actid);

Line 208: resultout := wf_engine.eng_null;

204:
205: begin
206: -- Do nothing in cancel or timeout mode
207: if (funcmode <> wf_engine.eng_run) then
208: resultout := wf_engine.eng_null;
209: else
210:
211: lv_aname := PAY_WORKFLOW_API_PKG.set_value(itemtype,itemkey,actid);
212: hr_utility.trace('lv_aname = '|| lv_aname);

Line 215: resultout := 'COMPLETE'||':'||wf_engine.eng_null;

211: lv_aname := PAY_WORKFLOW_API_PKG.set_value(itemtype,itemkey,actid);
212: hr_utility.trace('lv_aname = '|| lv_aname);
213: -- put this activity in wait/notified state
214: if lv_aname is not null then
215: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
216: else
217: resultout := wf_engine.eng_null;
218: end if;
219:

Line 217: resultout := wf_engine.eng_null;

213: -- put this activity in wait/notified state
214: if lv_aname is not null then
215: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
216: else
217: resultout := wf_engine.eng_null;
218: end if;
219:
220: end if;
221: return;

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

235: lv_aname varchar2(30);
236:
237: begin
238: -- Do nothing in cancel or timeout mode
239: if (funcmode <> wf_engine.eng_run) then
240: resultout := wf_engine.eng_null;
241: else
242:
243: lv_aname := PAY_WORKFLOW_API_PKG.get_value(itemtype,itemkey,actid)

Line 240: resultout := wf_engine.eng_null;

236:
237: begin
238: -- Do nothing in cancel or timeout mode
239: if (funcmode <> wf_engine.eng_run) then
240: resultout := wf_engine.eng_null;
241: else
242:
243: lv_aname := PAY_WORKFLOW_API_PKG.get_value(itemtype,itemkey,actid)
244: -- put this activity in wait/notified state

Line 246: resultout := 'COMPLETE'||':'||wf_engine.eng_null;

242:
243: lv_aname := PAY_WORKFLOW_API_PKG.get_value(itemtype,itemkey,actid)
244: -- put this activity in wait/notified state
245: if lv_aname is not null then
246: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
247: else
248: resultout := wf_engine.eng_null;
249: end if;
250:

Line 248: resultout := wf_engine.eng_null;

244: -- put this activity in wait/notified state
245: if lv_aname is not null then
246: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
247: else
248: resultout := wf_engine.eng_null;
249: end if;
250:
251: end if;
252: return;

Line 330: attr_value := WF_Engine.GetItemAttrText(wf_item_type , wf_item_key , attr_name , ignore_notfound);

326:
327: -- From the Runtime Attributes Get the Value of the Attribute for the Workflow
328: -- Item Type, Item Key,Attribute Name.
329:
330: attr_value := WF_Engine.GetItemAttrText(wf_item_type , wf_item_key , attr_name , ignore_notfound);
331:
332: return attr_value;
333:
334: Exception When others then

Line 347: aname Wf_Engine.NameTabTyp;

343: wf_item_type in varchar2 default 'NO_WF_ITEM',
344: wf_item_key in varchar2,
345: wf_actid in number
346: ) RETURN VARCHAR2 IS
347: aname Wf_Engine.NameTabTyp;
348: avalue Wf_Engine.TextTabTyp;
349:
350: lv_attr_name varchar2(30);
351: lv_attr_value varchar2(30);

Line 348: avalue Wf_Engine.TextTabTyp;

344: wf_item_key in varchar2,
345: wf_actid in number
346: ) RETURN VARCHAR2 IS
347: aname Wf_Engine.NameTabTyp;
348: avalue Wf_Engine.TextTabTyp;
349:
350: lv_attr_name varchar2(30);
351: lv_attr_value varchar2(30);
352: Begin

Line 357: lv_attr_name := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_NAME');

353:
354: -- Add an Item Attribute at Runtime and Set the Value of the Attribute
355: -- for the Workflow Item Type, Item Key,Attribute Name.
356:
357: lv_attr_name := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_NAME');
358: lv_attr_value := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_VALUE');
359: -- aname(1) := lv_attr_name;
360: -- avalue(1) := lv_attr_value;
361:

Line 358: lv_attr_value := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_VALUE');

354: -- Add an Item Attribute at Runtime and Set the Value of the Attribute
355: -- for the Workflow Item Type, Item Key,Attribute Name.
356:
357: lv_attr_name := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_NAME');
358: lv_attr_value := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_VALUE');
359: -- aname(1) := lv_attr_name;
360: -- avalue(1) := lv_attr_value;
361:
362: hr_utility.trace('aname = '|| lv_attr_name);

Line 365: --WF_Engine.AddItemAttr(wf_item_type, wf_item_key, aname, avalue);

361:
362: hr_utility.trace('aname = '|| lv_attr_name);
363: hr_utility.trace('avalue = '|| lv_attr_value);
364: if aname is not null then
365: --WF_Engine.AddItemAttr(wf_item_type, wf_item_key, aname, avalue);
366: WF_Engine.AddItemAttr(wf_item_type, wf_item_key, lv_attr_name, lv_attr_value);
367: --return aname;
368: return lv_attr_name;
369: else

Line 366: WF_Engine.AddItemAttr(wf_item_type, wf_item_key, lv_attr_name, lv_attr_value);

362: hr_utility.trace('aname = '|| lv_attr_name);
363: hr_utility.trace('avalue = '|| lv_attr_value);
364: if aname is not null then
365: --WF_Engine.AddItemAttr(wf_item_type, wf_item_key, aname, avalue);
366: WF_Engine.AddItemAttr(wf_item_type, wf_item_key, lv_attr_name, lv_attr_value);
367: --return aname;
368: return lv_attr_name;
369: else
370: return null;

Line 411: lv_retro_asg_set := Wf_Engine.GetItemAttrText(

407: hr_utility.trace('itemkey = '||itemkey);
408: hr_utility.trace('actid = '||to_char(actid));
409:
410: aname := 'RETRO_ASSIGNMENT_SET_NAME';
411: lv_retro_asg_set := Wf_Engine.GetItemAttrText(
412: itemtype ,
413: itemkey ,
414: aname,
415: ignore_notfound);

Line 419: X_bg_id := Wf_Engine.GetItemAttrNumber(

415: ignore_notfound);
416:
417: aname := 'P_BUSINESS_GROUP_ID';
418:
419: X_bg_id := Wf_Engine.GetItemAttrNumber(
420: itemtype,
421: itemkey,
422: aname,
423: ignore_notfound);

Line 444: Wf_Engine.SetItemAttrNumber

440: end;
441:
442: if ln_retro_asg_set_id is not null then
443:
444: Wf_Engine.SetItemAttrNumber
445: (itemtype,
446: itemkey,
447: 'RETRO_ASSIGNMENT_SET_ID',
448: ln_retro_asg_set_id);

Line 501: ln_get_retro_asgset_id := Wf_Engine.GetItemAttrNumber(

497: ignore_notfound := FALSE;
498:
499: hr_utility.trace('1. Function Mode = '||funcmode);
500: if ( funcmode = 'RUN' ) then
501: ln_get_retro_asgset_id := Wf_Engine.GetItemAttrNumber(
502: itemtype,
503: itemkey,
504: 'RETRO_ASSIGNMENT_SET_ID');
505:

Line 528: l_notification_id2:= wf_engine.context_nid;

524: --
525: hr_utility.trace('itemtype = '||itemtype);
526: hr_utility.trace('itemkey = '||itemkey);
527: hr_utility.trace('actid = '||to_char(actid));
528: l_notification_id2:= wf_engine.context_nid;
529: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));
530:
531: if (l_notification_id is not null ) then
532: lv_result := WF_NOTIFICATION.GetAttrText( l_notification_id, 'RESULT');

Line 541: lv_retro_asg_set := Wf_Engine.GetItemAttrText(

537: end if;
538:
539: if (lv_result <> 'SKIP') then
540: aname := 'RETRO_ASSIGNMENT_SET_NAME';
541: lv_retro_asg_set := Wf_Engine.GetItemAttrText(
542: itemtype ,
543: itemkey ,
544: aname,
545: ignore_notfound);

Line 549: X_bg_id := Wf_Engine.GetItemAttrNumber(

545: ignore_notfound);
546:
547: aname := 'P_BUSINESS_GROUP_ID';
548:
549: X_bg_id := Wf_Engine.GetItemAttrNumber(
550: itemtype,
551: itemkey,
552: aname,
553: ignore_notfound);

Line 574: Wf_Engine.SetItemAttrNumber

570: end;
571:
572: if ln_retro_asg_set_id is not null then
573:
574: Wf_Engine.SetItemAttrNumber
575: (itemtype,
576: itemkey,
577: 'RETRO_ASSIGNMENT_SET_ID',
578: ln_retro_asg_set_id);

Line 666: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');

662: -- this assumes that they were set as item attribute, probably through
663: -- definition.
664:
665: hr_utility.trace('In set context of ExecuteConcProgram');
666: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
667: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
668: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
669: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
670:

Line 667: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');

663: -- definition.
664:
665: hr_utility.trace('In set context of ExecuteConcProgram');
666: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
667: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
668: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
669: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
670:
671: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

Line 668: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');

664:
665: hr_utility.trace('In set context of ExecuteConcProgram');
666: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
667: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
668: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
669: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
670:
671: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
672: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

Line 669: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

665: hr_utility.trace('In set context of ExecuteConcProgram');
666: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
667: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
668: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
669: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
670:
671: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
672: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
673: /*

Line 671: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

667: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
668: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
669: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
670:
671: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
672: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
673: /*
674: l_user_id:= crec.user_id;
675: l_resp_appl_id:= crec.responsibility_application_id;

Line 672: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

668: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
669: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
670:
671: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
672: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
673: /*
674: l_user_id:= crec.user_id;
675: l_resp_appl_id:= crec.responsibility_application_id;
676: l_resp_id:= crec.responsibility_id;

Line 710: work_item_org_id := wf_engine.GetItemAttrNumber(p_itemtype, p_itemkey, 'ORG_ID');

706: -- the workflow safely
707:
708: fnd_profile.get(name=>'ORG_ID',val=>session_org_id);
709:
710: work_item_org_id := wf_engine.GetItemAttrNumber(p_itemtype, p_itemkey, 'ORG_ID');
711:
712: if session_org_id = work_item_org_id then
713:
714: p_result := 'COMPLETE:TRUE';

Line 738: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');

734: -- this assumes that they were set as item attribute, probably through
735: -- definition.
736:
737: hr_utility.trace('In set context of ExecuteConcProgram');
738: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
739: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
740: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
741: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
742:

Line 739: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');

735: -- definition.
736:
737: hr_utility.trace('In set context of ExecuteConcProgram');
738: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
739: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
740: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
741: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
742:
743: /*

Line 740: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');

736:
737: hr_utility.trace('In set context of ExecuteConcProgram');
738: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
739: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
740: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
741: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
742:
743: /*
744: l_user_id:= crec.user_id;

Line 741: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

737: hr_utility.trace('In set context of ExecuteConcProgram');
738: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
739: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
740: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
741: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
742:
743: /*
744: l_user_id:= crec.user_id;
745: l_resp_appl_id:= crec.responsibility_application_id;

Line 803: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');

799: -- get Item Attributes for user_id, responsibility_id and application_id
800: -- this assumes that they were set as item attribute, probably through
801: -- definition.
802: hr_utility.trace('In set context of ExecuteConcProgram');
803: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
804: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
805: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
806: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
807:

Line 804: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');

800: -- this assumes that they were set as item attribute, probably through
801: -- definition.
802: hr_utility.trace('In set context of ExecuteConcProgram');
803: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
804: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
805: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
806: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
807:
808: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

Line 805: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');

801: -- definition.
802: hr_utility.trace('In set context of ExecuteConcProgram');
803: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
804: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
805: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
806: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
807:
808: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
809: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

Line 806: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

802: hr_utility.trace('In set context of ExecuteConcProgram');
803: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
804: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
805: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
806: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
807:
808: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
809: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
810:

Line 808: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

804: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
805: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
806: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
807:
808: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
809: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
810:
811: hr_utility.trace('l_user_id = '|| l_user_id);
812: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);

Line 809: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

805: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
806: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
807:
808: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
809: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
810:
811: hr_utility.trace('l_user_id = '|| l_user_id);
812: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
813: hr_utility.trace('l_resp_id = '|| l_resp_id);

Line 883: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');

879: -- get Item Attributes for user_id, responsibility_id and application_id
880: -- this assumes that they were set as item attribute, probably through
881: -- definition.
882: hr_utility.trace('In set context of ExecuteConcProgram');
883: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
884: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
885: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
886: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
887:

Line 884: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');

880: -- this assumes that they were set as item attribute, probably through
881: -- definition.
882: hr_utility.trace('In set context of ExecuteConcProgram');
883: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
884: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
885: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
886: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
887:
888: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

Line 885: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');

881: -- definition.
882: hr_utility.trace('In set context of ExecuteConcProgram');
883: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
884: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
885: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
886: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
887:
888: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
889: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

Line 886: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');

882: hr_utility.trace('In set context of ExecuteConcProgram');
883: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
884: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
885: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
886: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
887:
888: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
889: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
890:

Line 888: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

884: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
885: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
886: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
887:
888: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
889: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
890:
891: hr_utility.trace('l_user_id = '|| l_user_id);
892: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);

Line 889: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

885: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
886: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
887:
888: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
889: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
890:
891: hr_utility.trace('l_user_id = '|| l_user_id);
892: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
893: hr_utility.trace('l_resp_id = '|| l_resp_id);