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 56: -- step must be performed. A call to wf_engine.CompleteActivty

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

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

209: lv_aname varchar2(30);
210:
211: begin
212: -- Do nothing in cancel or timeout mode
213: if (funcmode <> wf_engine.eng_run) then
214: resultout := wf_engine.eng_null;
215: else
216:
217: lv_aname := PAY_WORKFLOW_API_PKG.set_value(itemtype,itemkey,actid);

Line 214: resultout := wf_engine.eng_null;

210:
211: begin
212: -- Do nothing in cancel or timeout mode
213: if (funcmode <> wf_engine.eng_run) then
214: resultout := wf_engine.eng_null;
215: else
216:
217: lv_aname := PAY_WORKFLOW_API_PKG.set_value(itemtype,itemkey,actid);
218: hr_utility.trace('lv_aname = '|| lv_aname);

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

217: lv_aname := PAY_WORKFLOW_API_PKG.set_value(itemtype,itemkey,actid);
218: hr_utility.trace('lv_aname = '|| lv_aname);
219: -- put this activity in wait/notified state
220: if lv_aname is not null then
221: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
222: else
223: resultout := wf_engine.eng_null;
224: end if;
225:

Line 223: resultout := wf_engine.eng_null;

219: -- put this activity in wait/notified state
220: if lv_aname is not null then
221: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
222: else
223: resultout := wf_engine.eng_null;
224: end if;
225:
226: end if;
227: return;

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

241: lv_aname varchar2(30);
242:
243: begin
244: -- Do nothing in cancel or timeout mode
245: if (funcmode <> wf_engine.eng_run) then
246: resultout := wf_engine.eng_null;
247: else
248:
249: lv_aname := PAY_WORKFLOW_API_PKG.get_value(itemtype,itemkey,actid)

Line 246: resultout := wf_engine.eng_null;

242:
243: begin
244: -- Do nothing in cancel or timeout mode
245: if (funcmode <> wf_engine.eng_run) then
246: resultout := wf_engine.eng_null;
247: else
248:
249: lv_aname := PAY_WORKFLOW_API_PKG.get_value(itemtype,itemkey,actid)
250: -- put this activity in wait/notified state

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

248:
249: lv_aname := PAY_WORKFLOW_API_PKG.get_value(itemtype,itemkey,actid)
250: -- put this activity in wait/notified state
251: if lv_aname is not null then
252: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
253: else
254: resultout := wf_engine.eng_null;
255: end if;
256:

Line 254: resultout := wf_engine.eng_null;

250: -- put this activity in wait/notified state
251: if lv_aname is not null then
252: resultout := 'COMPLETE'||':'||wf_engine.eng_null;
253: else
254: resultout := wf_engine.eng_null;
255: end if;
256:
257: end if;
258: return;

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

332:
333: -- From the Runtime Attributes Get the Value of the Attribute for the Workflow
334: -- Item Type, Item Key,Attribute Name.
335:
336: attr_value := WF_Engine.GetItemAttrText(wf_item_type , wf_item_key , attr_name , ignore_notfound);
337:
338: return attr_value;
339:
340: Exception When others then

Line 353: aname Wf_Engine.NameTabTyp;

349: wf_item_type in varchar2 default 'NO_WF_ITEM',
350: wf_item_key in varchar2,
351: wf_actid in number
352: ) RETURN VARCHAR2 IS
353: aname Wf_Engine.NameTabTyp;
354: avalue Wf_Engine.TextTabTyp;
355:
356: lv_attr_name varchar2(30);
357: lv_attr_value varchar2(30);

Line 354: avalue Wf_Engine.TextTabTyp;

350: wf_item_key in varchar2,
351: wf_actid in number
352: ) RETURN VARCHAR2 IS
353: aname Wf_Engine.NameTabTyp;
354: avalue Wf_Engine.TextTabTyp;
355:
356: lv_attr_name varchar2(30);
357: lv_attr_value varchar2(30);
358: Begin

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

359:
360: -- Add an Item Attribute at Runtime and Set the Value of the Attribute
361: -- for the Workflow Item Type, Item Key,Attribute Name.
362:
363: lv_attr_name := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_NAME');
364: lv_attr_value := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_VALUE');
365: -- aname(1) := lv_attr_name;
366: -- avalue(1) := lv_attr_value;
367:

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

360: -- Add an Item Attribute at Runtime and Set the Value of the Attribute
361: -- for the Workflow Item Type, Item Key,Attribute Name.
362:
363: lv_attr_name := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_NAME');
364: lv_attr_value := wf_engine.GetActivityAttrText(wf_item_type,wf_item_key,wf_actid, 'ATTR_VALUE');
365: -- aname(1) := lv_attr_name;
366: -- avalue(1) := lv_attr_value;
367:
368: hr_utility.trace('aname = '|| lv_attr_name);

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

367:
368: hr_utility.trace('aname = '|| lv_attr_name);
369: hr_utility.trace('avalue = '|| lv_attr_value);
370: if aname is not null then
371: --WF_Engine.AddItemAttr(wf_item_type, wf_item_key, aname, avalue);
372: WF_Engine.AddItemAttr(wf_item_type, wf_item_key, lv_attr_name, lv_attr_value);
373: --return aname;
374: return lv_attr_name;
375: else

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

368: hr_utility.trace('aname = '|| lv_attr_name);
369: hr_utility.trace('avalue = '|| lv_attr_value);
370: if aname is not null then
371: --WF_Engine.AddItemAttr(wf_item_type, wf_item_key, aname, avalue);
372: WF_Engine.AddItemAttr(wf_item_type, wf_item_key, lv_attr_name, lv_attr_value);
373: --return aname;
374: return lv_attr_name;
375: else
376: return null;

Line 417: lv_retro_asg_set := Wf_Engine.GetItemAttrText(

413: hr_utility.trace('itemkey = '||itemkey);
414: hr_utility.trace('actid = '||to_char(actid));
415:
416: aname := 'RETRO_ASSIGNMENT_SET_NAME';
417: lv_retro_asg_set := Wf_Engine.GetItemAttrText(
418: itemtype ,
419: itemkey ,
420: aname,
421: ignore_notfound);

Line 425: X_bg_id := Wf_Engine.GetItemAttrNumber(

421: ignore_notfound);
422:
423: aname := 'P_BUSINESS_GROUP_ID';
424:
425: X_bg_id := Wf_Engine.GetItemAttrNumber(
426: itemtype,
427: itemkey,
428: aname,
429: ignore_notfound);

Line 450: Wf_Engine.SetItemAttrNumber

446: end;
447:
448: if ln_retro_asg_set_id is not null then
449:
450: Wf_Engine.SetItemAttrNumber
451: (itemtype,
452: itemkey,
453: 'RETRO_ASSIGNMENT_SET_ID',
454: ln_retro_asg_set_id);

Line 514: X_payroll_id := to_number(Wf_Engine.GetItemAttrText(

510:
511:
512: aname := 'PAYROLL_ID';
513:
514: X_payroll_id := to_number(Wf_Engine.GetItemAttrText(
515: itemtype,
516: itemkey,
517: aname,
518: ignore_notfound));

Line 586: ln_get_retro_asgset_id := Wf_Engine.GetItemAttrNumber(

582: ignore_notfound := FALSE;
583:
584: hr_utility.trace('1. Function Mode = '||funcmode);
585: if ( funcmode = 'RUN' ) then
586: ln_get_retro_asgset_id := Wf_Engine.GetItemAttrNumber(
587: itemtype,
588: itemkey,
589: 'RETRO_ASSIGNMENT_SET_ID');
590:

Line 613: l_notification_id2:= wf_engine.context_nid;

609: --
610: hr_utility.trace('itemtype = '||itemtype);
611: hr_utility.trace('itemkey = '||itemkey);
612: hr_utility.trace('actid = '||to_char(actid));
613: l_notification_id2:= wf_engine.context_nid;
614: hr_utility.trace('2. l_notification_id = '||to_char(l_notification_id2));
615:
616: if (l_notification_id is not null ) then
617: lv_result := WF_NOTIFICATION.GetAttrText( l_notification_id, 'RESULT');

Line 626: lv_retro_asg_set := Wf_Engine.GetItemAttrText(

622: end if;
623:
624: if (lv_result <> 'SKIP') then
625: aname := 'RETRO_ASSIGNMENT_SET_NAME';
626: lv_retro_asg_set := Wf_Engine.GetItemAttrText(
627: itemtype ,
628: itemkey ,
629: aname,
630: ignore_notfound);

Line 634: X_bg_id := Wf_Engine.GetItemAttrNumber(

630: ignore_notfound);
631:
632: aname := 'P_BUSINESS_GROUP_ID';
633:
634: X_bg_id := Wf_Engine.GetItemAttrNumber(
635: itemtype,
636: itemkey,
637: aname,
638: ignore_notfound);

Line 659: Wf_Engine.SetItemAttrNumber

655: end;
656:
657: if ln_retro_asg_set_id is not null then
658:
659: Wf_Engine.SetItemAttrNumber
660: (itemtype,
661: itemkey,
662: 'RETRO_ASSIGNMENT_SET_ID',
663: ln_retro_asg_set_id);

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

747: -- this assumes that they were set as item attribute, probably through
748: -- definition.
749:
750: hr_utility.trace('In set context of ExecuteConcProgram');
751: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
752: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
753: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
754: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
755:

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

748: -- definition.
749:
750: hr_utility.trace('In set context of ExecuteConcProgram');
751: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
752: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
753: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
754: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
755:
756: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

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

749:
750: hr_utility.trace('In set context of ExecuteConcProgram');
751: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
752: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
753: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
754: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
755:
756: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
757: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

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

750: hr_utility.trace('In set context of ExecuteConcProgram');
751: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
752: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
753: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
754: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
755:
756: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
757: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
758: /*

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

752: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
753: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
754: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
755:
756: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
757: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
758: /*
759: l_user_id:= crec.user_id;
760: l_resp_appl_id:= crec.responsibility_application_id;

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

753: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
754: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
755:
756: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
757: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
758: /*
759: l_user_id:= crec.user_id;
760: l_resp_appl_id:= crec.responsibility_application_id;
761: l_resp_id:= crec.responsibility_id;

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

792: -- the workflow safely
793:
794: fnd_profile.get(name=>'ORG_ID',val=>session_org_id);
795:
796: work_item_org_id := wf_engine.GetItemAttrNumber(p_itemtype, p_itemkey, 'ORG_ID');
797:
798: if session_org_id = work_item_org_id then
799:
800: p_result := 'COMPLETE:TRUE';

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

820: -- this assumes that they were set as item attribute, probably through
821: -- definition.
822:
823: hr_utility.trace('In set context of ExecuteConcProgram');
824: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
825: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
826: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
827: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
828:

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

821: -- definition.
822:
823: hr_utility.trace('In set context of ExecuteConcProgram');
824: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
825: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
826: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
827: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
828:
829: /*

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

822:
823: hr_utility.trace('In set context of ExecuteConcProgram');
824: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
825: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
826: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
827: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
828:
829: /*
830: l_user_id:= crec.user_id;

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

823: hr_utility.trace('In set context of ExecuteConcProgram');
824: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
825: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
826: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
827: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
828:
829: /*
830: l_user_id:= crec.user_id;
831: l_resp_appl_id:= crec.responsibility_application_id;

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

833:
834: */
835: -- Set the database session context which also sets the org
836: --Bug 9211154 - Pass l_security_group_id
837: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
838: FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id,l_security_group_id);
839: --FND_GLOBAL.Apps_Initialize(l_user_id, l_resp_id, l_resp_appl_id);
840:
841:

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

888: -- get Item Attributes for user_id, responsibility_id and application_id
889: -- this assumes that they were set as item attribute, probably through
890: -- definition.
891: hr_utility.trace('In set context of ExecuteConcProgram');
892: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
893: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
894: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
895: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
896:

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

889: -- this assumes that they were set as item attribute, probably through
890: -- definition.
891: hr_utility.trace('In set context of ExecuteConcProgram');
892: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
893: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
894: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
895: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
896:
897: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

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

890: -- definition.
891: hr_utility.trace('In set context of ExecuteConcProgram');
892: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
893: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
894: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
895: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
896:
897: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
898: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

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

891: hr_utility.trace('In set context of ExecuteConcProgram');
892: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
893: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
894: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
895: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
896:
897: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
898: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
899:

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

893: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
894: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
895: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
896:
897: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
898: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
899:
900: hr_utility.trace('l_user_id = '|| l_user_id);
901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);

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

894: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
895: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
896:
897: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
898: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
899:
900: hr_utility.trace('l_user_id = '|| l_user_id);
901: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
902: hr_utility.trace('l_resp_id = '|| l_resp_id);

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

969: -- get Item Attributes for user_id, responsibility_id and application_id
970: -- this assumes that they were set as item attribute, probably through
971: -- definition.
972: hr_utility.trace('In set context of ExecuteConcProgram');
973: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
974: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
975: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
976: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
977:

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

970: -- this assumes that they were set as item attribute, probably through
971: -- definition.
972: hr_utility.trace('In set context of ExecuteConcProgram');
973: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
974: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
975: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
976: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
977:
978: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');

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

971: -- definition.
972: hr_utility.trace('In set context of ExecuteConcProgram');
973: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
974: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
975: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
976: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
977:
978: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
979: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');

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

972: hr_utility.trace('In set context of ExecuteConcProgram');
973: l_user_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'USER_ID');
974: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
975: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
976: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
977:
978: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
979: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
980:

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

974: l_resp_appl_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'APPLICATION_ID');
975: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
976: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
977:
978: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
979: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
980:
981: hr_utility.trace('l_user_id = '|| l_user_id);
982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);

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

975: l_resp_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'RESPONSIBILITY_ID');
976: l_org_id:= wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'ORG_ID');
977:
978: l_security_group_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'SECURITY_GROUP_ID');
979: l_per_security_id := wf_engine.GetItemAttrNumber(p_itemtype,p_itemkey,'PER_SECURITY_PROFILE_ID');
980:
981: hr_utility.trace('l_user_id = '|| l_user_id);
982: hr_utility.trace('l_resp_appl_id: = '|| l_resp_appl_id);
983: hr_utility.trace('l_resp_id = '|| l_resp_id);