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_WORKFLOW_SS dependencies on WF_ENGINE

Line 54: l_text_value := wf_engine.GetItemAttrText(itemtype => itemtype,

50: l_text_value wf_activity_attr_values.text_value%type;
51: l_trans_ref_table hr_api_transactions.transaction_ref_Table%type;
52: begin
53: --
54: l_text_value := wf_engine.GetItemAttrText(itemtype => itemtype,
55: itemkey => itemkey,
56: aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG');
57: if ( l_text_value in ('YES_DYNAMIC', 'YES','Y','YD')) then
58: -- Approval Process is required

Line 68: wf_engine.setItemAttrDate(itemtype => itemtype,

64: from hr_api_transactions
65: where item_type=itemtype and item_key=itemkey;
66:
67: if l_trans_ref_table = 'IRC_OFFERS' then
68: wf_engine.setItemAttrDate(itemtype => itemtype,
69: itemkey => itemkey,
70: aname => 'CURRENT_EFFECTIVE_DATE',
71: avalue => trunc(sysdate)
72: );

Line 110: wf_engine.SetItemAttrText(itemtype => itemtype

106: begin
107: --
108: IF ( funcmode = 'RUN' )
109: THEN
110: wf_engine.SetItemAttrText(itemtype => itemtype
111: ,itemkey => itemkey
112: ,aname => 'HR_REJECTED_BY_PAYROLL'
113: ,avalue => 'Y');
114:

Line 157: lv_prev_payroll_comment := wf_engine.GetItemAttrText

153: IF ( funcmode = 'RUN' )
154: THEN
155: --
156: -- Save the previous comment from Payroll first
157: lv_prev_payroll_comment := wf_engine.GetItemAttrText
158: (itemtype => itemtype,
159: itemkey => itemkey,
160: aname => 'HR_SALBASISCHG_PAYROLL_COMMENT');
161:

Line 168: wf_engine.SetItemAttrText

164: THEN
165: lv_prev_payroll_comment := lv_prev_payroll_comment || '
';
166: END IF;
167:
168: wf_engine.SetItemAttrText
169: (itemtype => itemtype,
170: itemkey => itemkey,
171: aname => 'HR_SALBASISCHG_PAYROLL_COMMENT',
172: avalue => lv_prev_payroll_comment ||

Line 173: wf_engine.GetItemAttrText (itemtype => itemtype,

169: (itemtype => itemtype,
170: itemkey => itemkey,
171: aname => 'HR_SALBASISCHG_PAYROLL_COMMENT',
172: avalue => lv_prev_payroll_comment ||
173: wf_engine.GetItemAttrText (itemtype => itemtype,
174: itemkey => itemkey,
175: aname => 'WF_NOTE'));
176: --
177: resultout := 'COMPLETE:';

Line 294: c_process_name := wf_engine.GetItemAttrText (itemtype => c_item_type ,

290: begin
291:
292: c_item_type := get_item_type(p_transaction_id);
293: c_item_key := get_item_key(p_transaction_id);
294: c_process_name := wf_engine.GetItemAttrText (itemtype => c_item_type ,
295: itemkey => c_item_key,
296: aname => 'PROCESS_NAME',
297: ignore_notfound => TRUE);
298: return c_process_name;

Line 318: c_approval_level := wf_engine.GetItemAttrNumber (itemtype => c_item_type ,

314:
315: c_item_type := get_item_type(p_transaction_id);
316: c_item_key := get_item_key(p_transaction_id);
317:
318: c_approval_level := wf_engine.GetItemAttrNumber (itemtype => c_item_type ,
319: itemkey => c_item_key ,
320: aname => 'APPROVAL_LEVEL');
321: return c_approval_level;
322: EXCEPTION

Line 343: c_effective_date := wf_engine.GetItemAttrDate(itemtype => c_item_type ,

339:
340: c_item_type := get_item_type(p_transaction_id);
341: c_item_key := get_item_key(p_transaction_id);
342:
343: c_effective_date := wf_engine.GetItemAttrDate(itemtype => c_item_type ,
344: itemkey => c_item_key,
345: aname => 'CURRENT_EFFECTIVE_DATE');
346:
347: return c_effective_date;

Line 368: c_assignment_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,

364:
365: c_item_type := get_item_type(p_transaction_id);
366: c_item_key := get_item_key(p_transaction_id);
367:
368: c_assignment_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,
369: itemkey => c_item_key,
370: aname => 'CURRENT_ASSIGNMENT_ID');
371: return c_assignment_id;
372: EXCEPTION

Line 429: nvl(wf_engine.GetItemAttrNumber

425: if ( funmode = 'RUN' ) then
426:
427: -- get the current forward from person
428: l_current_forward_from_id :=
429: nvl(wf_engine.GetItemAttrNumber
430: (itemtype => itemtype
431: ,itemkey => itemkey
432: ,aname => 'FORWARD_FROM_PERSON_ID'),
433: wf_engine.GetItemAttrNumber

Line 433: wf_engine.GetItemAttrNumber

429: nvl(wf_engine.GetItemAttrNumber
430: (itemtype => itemtype
431: ,itemkey => itemkey
432: ,aname => 'FORWARD_FROM_PERSON_ID'),
433: wf_engine.GetItemAttrNumber
434: (itemtype => itemtype
435: ,itemkey => itemkey
436: ,aname => 'CREATOR_PERSON_ID'));
437: -- get the current forward to person

Line 439: nvl(wf_engine.GetItemAttrNumber

435: ,itemkey => itemkey
436: ,aname => 'CREATOR_PERSON_ID'));
437: -- get the current forward to person
438: l_current_forward_to_id :=
439: nvl(wf_engine.GetItemAttrNumber
440: (itemtype => itemtype
441: ,itemkey => itemkey
442: ,aname => 'FORWARD_TO_PERSON_ID'),
443: wf_engine.GetItemAttrNumber

Line 443: wf_engine.GetItemAttrNumber

439: nvl(wf_engine.GetItemAttrNumber
440: (itemtype => itemtype
441: ,itemkey => itemkey
442: ,aname => 'FORWARD_TO_PERSON_ID'),
443: wf_engine.GetItemAttrNumber
444: (itemtype => itemtype
445: ,itemkey => itemkey
446: ,aname => 'CREATOR_PERSON_ID'));
447:

Line 452: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype ,

448:
449:
450:
451:
452: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype ,
453: itemkey => itemkey,
454: aname => 'HR_AME_APP_ID_ATTR');
455:
456: c_application_id := nvl(c_application_id,800);

Line 460: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype ,

456: c_application_id := nvl(c_application_id,800);
457:
458:
459:
460: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype ,
461: itemkey => itemkey,
462: aname => 'TRANSACTION_ID');
463:
464:

Line 466: c_transaction_type := wf_engine.GetItemAttrText(itemtype => itemtype ,

462: aname => 'TRANSACTION_ID');
463:
464:
465:
466: c_transaction_type := wf_engine.GetItemAttrText(itemtype => itemtype ,
467: itemkey => itemkey,
468: aname => 'HR_AME_TRAN_TYPE_ATTR');
469:
470:

Line 503: wf_engine.SetItemAttrNumber

499: ,p_orig_system_id => l_forward_to_person_id
500: ,p_name => l_forward_to_username
501: ,p_display_name => l_forward_to_disp_name);
502: --
503: wf_engine.SetItemAttrNumber
504: (itemtype => itemtype
505: ,itemkey => itemkey
506: ,aname => 'FORWARD_TO_PERSON_ID'
507: ,avalue => l_forward_to_person_id);

Line 509: wf_engine.SetItemAttrText

505: ,itemkey => itemkey
506: ,aname => 'FORWARD_TO_PERSON_ID'
507: ,avalue => l_forward_to_person_id);
508: --
509: wf_engine.SetItemAttrText
510: (itemtype => itemtype
511: ,itemkey => itemkey
512: ,aname => 'FORWARD_TO_USERNAME'
513: ,avalue => l_forward_to_username);

Line 515: Wf_engine.SetItemAttrText

511: ,itemkey => itemkey
512: ,aname => 'FORWARD_TO_USERNAME'
513: ,avalue => l_forward_to_username);
514: --
515: Wf_engine.SetItemAttrText
516: (itemtype => itemtype
517: ,itemkey => itemkey
518: ,aname => 'FORWARD_TO_DISPLAY_NAME'
519: ,avalue => l_forward_to_disp_name);

Line 524: wf_engine.SetItemAttrNumber

520: --
521: -- set forward from to old forward to
522: --
523:
524: wf_engine.SetItemAttrNumber
525: (itemtype => itemtype
526: ,itemkey => itemkey
527: ,aname => 'FORWARD_FROM_PERSON_ID'
528: ,avalue => l_current_forward_to_id);

Line 539: wf_engine.SetItemAttrText

535: ,p_orig_system_id => l_current_forward_to_id
536: ,p_name => l_forward_from_username
537: ,p_display_name => l_forward_from_disp_name);
538: --
539: wf_engine.SetItemAttrText
540: (itemtype => itemtype
541: ,itemkey => itemkey
542: ,aname => 'FORWARD_FROM_USERNAME'
543: ,avalue => l_forward_from_username);

Line 545: wf_engine.SetItemAttrText

541: ,itemkey => itemkey
542: ,aname => 'FORWARD_FROM_USERNAME'
543: ,avalue => l_forward_from_username);
544: --
545: wf_engine.SetItemAttrText
546: (itemtype => itemtype
547: ,itemkey => itemkey
548: ,aname => 'FORWARD_FROM_DISPLAY_NAME'
549: ,avalue => l_forward_from_disp_name);

Line 605: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype ,

601: --
602:
603: if ( funmode = 'RUN' ) then
604:
605: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => itemtype ,
606: itemkey => itemkey,
607: aname => 'HR_AME_APP_ID_ATTR');
608:
609: c_application_id := nvl(c_application_id,800);

Line 611: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype ,

607: aname => 'HR_AME_APP_ID_ATTR');
608:
609: c_application_id := nvl(c_application_id,800);
610:
611: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => itemtype ,
612: itemkey => itemkey,
613: aname => 'TRANSACTION_ID');
614:
615:

Line 617: c_transaction_type := wf_engine.GetItemAttrText(itemtype => itemtype ,

613: aname => 'TRANSACTION_ID');
614:
615:
616:
617: c_transaction_type := wf_engine.GetItemAttrText(itemtype => itemtype ,
618: itemkey => itemkey,
619: aname => 'HR_AME_TRAN_TYPE_ATTR');
620:
621:

Line 622: l_forward_to_person_id := wf_engine.GetItemAttrNumber

618: itemkey => itemkey,
619: aname => 'HR_AME_TRAN_TYPE_ATTR');
620:
621:
622: l_forward_to_person_id := wf_engine.GetItemAttrNumber
623: (itemtype => itemtype,
624: itemkey => itemkey,
625: aname => 'FORWARD_TO_PERSON_ID');
626: /*

Line 636: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => itemtype

632: transactionTypeIn =>c_transaction_type,
633: forwardeeIn =>null); */
634:
635:
636: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => itemtype
637: ,itemkey => itemkey
638: ,aname => 'FORWARD_TO_USERNAME');
639:
640: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => itemtype ,

Line 640: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => itemtype ,

636: l_current_forward_to_username:= Wf_engine.GetItemAttrText(itemtype => itemtype
637: ,itemkey => itemkey
638: ,aname => 'FORWARD_TO_USERNAME');
639:
640: l_current_forward_to_username := nvl(l_current_forward_to_username,wf_engine.GetItemAttrText(itemtype => itemtype ,
641: itemkey => itemkey,
642: aname => 'RETURN_TO_USERNAME'));
643:
644: ame_api2.updateApprovalStatus2(applicationIdIn=>c_application_id,

Line 697: /*c_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,

693: hr_approval_custom.g_itemtype := c_item_type;
694: hr_approval_custom.g_itemkey := c_item_key;
695: -- bug 4333335 ends
696:
697: /*c_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,
698: itemkey => c_item_key,
699: aname => 'CREATOR_PERSON_ID');
700: */
701: c_creator_person_id := getApprStartingPointPersonId(p_transaction_id);

Line 744: /*c_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,

740:
741: c_item_type := get_item_type(p_transaction_id);
742: c_item_key := get_item_key(p_transaction_id);
743: c_final_approver := get_final_approver(p_transaction_id);
744: /*c_creator_person_id := wf_engine.GetItemAttrNumber(itemtype => c_item_type ,
745: itemkey => c_item_key,
746: aname => 'CREATOR_PERSON_ID');
747: */
748: c_creator_person_id := getApprStartingPointPersonId(p_transaction_id);

Line 893: wf_engine.setItemAttrText

889: CLOSE csr_check_mid_pay_period;
890: -- Need to set the item attribute to 'N' because this may be
891: -- a Return For Correction and the value of the item attribute
892: -- was set to 'Y' previously.
893: wf_engine.setItemAttrText
894: (itemtype => p_item_type
895: ,itemkey => p_item_key
896: ,aname => g_mid_pay_period_change
897: ,avalue => 'N');

Line 907: wf_engine.setItemAttrText

903: -- pay_basis_id. If that is null, then this is the first time
904: -- salary basis was entered. We don't need to perform the check
905: -- because there is no element type changed.
906: CLOSE csr_check_mid_pay_period;
907: wf_engine.setItemAttrText
908: (itemtype => p_item_type
909: ,itemkey => p_item_key
910: ,aname => g_mid_pay_period_change
911: ,avalue => 'Y');

Line 956: IF (p_funcmode = 'RUN' and wf_engine.GetItemAttrText(itemtype =>p_itemtype,

952: l_session_user_id varchar2(100);
953: l_session_resp_id NUMBER;
954: BEGIN
955:
956: IF (p_funcmode = 'RUN' and wf_engine.GetItemAttrText(itemtype =>p_itemtype,
957: itemkey =>p_itemkey,
958: aname =>'HR_DEFER_COMMIT_ATTR',
959: ignore_notfound=>true)='Y'
960: ) THEN

Line 966: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,

962: -- with the work item context required to execute
963: -- the workflow safely
964: l_session_user_id := FND_GLOBAL.USER_ID;
965: l_session_resp_id := FND_GLOBAL.RESP_ID;
966: l_fnd_user_id := wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,
967: itemkey =>p_itemkey,
968: aname =>'HR_USER_ID_ATTR',
969: ignore_notfound=>true);
970:

Line 971: l_resp_id :=wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,

967: itemkey =>p_itemkey,
968: aname =>'HR_USER_ID_ATTR',
969: ignore_notfound=>true);
970:
971: l_resp_id :=wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,
972: itemkey =>p_itemkey,
973: aname =>'HR_RESP_ID_ATTR',
974: ignore_notfound=>true);
975:

Line 981: l_resp_id :=wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,

977: -- session already has proper values ignore reset
978: p_result := 'COMPLETE';
979: else
980: -- HR_RESP_ID_ATTR
981: l_resp_id :=wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,
982: itemkey =>p_itemkey,
983: aname =>'HR_RESP_ID_ATTR',
984: ignore_notfound=>true);
985: -- HR_RESP_APPL_ID_ATTR

Line 986: l_resp_appl_id := wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,

982: itemkey =>p_itemkey,
983: aname =>'HR_RESP_ID_ATTR',
984: ignore_notfound=>true);
985: -- HR_RESP_APPL_ID_ATTR
986: l_resp_appl_id := wf_engine.GetItemAttrNumber(itemtype =>p_itemtype,
987: itemkey =>p_itemkey,
988: aname =>'HR_RESP_APPL_ID_ATTR',
989: ignore_notfound=>true);
990:

Line 1040: wf_engine.SetItemAttrText(itemtype =>p_item_type,

1036: (p_item_type => p_item_type
1037: ,p_item_key => p_item_key
1038: ,p_name => 'HR_DEFER_COMMIT_ATTR');
1039:
1040: wf_engine.SetItemAttrText(itemtype =>p_item_type,
1041: itemkey =>p_item_key,
1042: aname =>'HR_DEFER_COMMIT_ATTR',
1043: avalue => 'N' );
1044: result := 'COMPLETE:'|| 'N';

Line 1053: wf_engine.SetItemAttrNumber (itemtype => p_item_type,

1049: hr_approval_wf.create_item_attrib_if_notexist
1050: (p_item_type => p_item_type
1051: ,p_item_key => p_item_key
1052: ,p_name => 'HR_USER_ID_ATTR');
1053: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
1054: itemkey => p_item_key,
1055: aname => 'HR_USER_ID_ATTR',
1056: avalue => FND_GLOBAL.USER_ID ) ;
1057: -- get the resp_id, FND_GLOBAL.RESP_ID

Line 1062: wf_engine.SetItemAttrNumber (itemtype => p_item_type,

1058: hr_approval_wf.create_item_attrib_if_notexist
1059: (p_item_type => p_item_type
1060: ,p_item_key => p_item_key
1061: ,p_name => 'HR_RESP_ID_ATTR');
1062: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
1063: itemkey => p_item_key,
1064: aname => 'HR_RESP_ID_ATTR',
1065: avalue => FND_GLOBAL.RESP_ID ) ;
1066:

Line 1072: wf_engine.SetItemAttrNumber (itemtype => p_item_type,

1068: hr_approval_wf.create_item_attrib_if_notexist
1069: (p_item_type => p_item_type
1070: ,p_item_key => p_item_key
1071: ,p_name => 'HR_RESP_APPL_ID_ATTR');
1072: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
1073: itemkey => p_item_key,
1074: aname => 'HR_RESP_APPL_ID_ATTR',
1075: avalue => FND_GLOBAL.RESP_APPL_ID ) ;
1076: hr_approval_wf.create_item_attrib_if_notexist

Line 1081: wf_engine.SetItemAttrText(itemtype =>p_item_type,

1077: (p_item_type => p_item_type
1078: ,p_item_key => p_item_key
1079: ,p_name => 'HR_DEFER_COMMIT_ATTR');
1080:
1081: wf_engine.SetItemAttrText(itemtype =>p_item_type,
1082: itemkey =>p_item_key,
1083: aname =>'HR_DEFER_COMMIT_ATTR',
1084: avalue => 'Y' );
1085: result := 'COMPLETE:'|| 'Y';

Line 1099: Methods added to provide java wrapper to WF_ENGINE API's, may be obsoleted

1095: END defer_commit;
1096:
1097:
1098: /*
1099: Methods added to provide java wrapper to WF_ENGINE API's, may be obsoleted
1100: once the Java interface for them is provided. These new procedures are with
1101: new signature adding the boolean parameter ignore_notfound.
1102:
1103: */

Line 1124: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);

1120:
1121:
1122: if(ignore_notfound='TRUE') then
1123: if g_debug then
1124: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);
1125: end if;
1126: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,
1127: itemkey=>itemkey,
1128: actid=>actid,

Line 1126: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,

1122: if(ignore_notfound='TRUE') then
1123: if g_debug then
1124: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);
1125: end if;
1126: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,
1127: itemkey=>itemkey,
1128: actid=>actid,
1129: aname=>aname,
1130: ignore_notfound=>TRUE);

Line 1133: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);

1129: aname=>aname,
1130: ignore_notfound=>TRUE);
1131: elsif (ignore_notfound='FALSE') then
1132: if g_debug then
1133: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);
1134: end if;
1135:
1136: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,
1137: itemkey=>itemkey,

Line 1136: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,

1132: if g_debug then
1133: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrText ', 2);
1134: end if;
1135:
1136: return WF_ENGINE.GetActivityAttrText(itemtype=>itemtype,
1137: itemkey=>itemkey,
1138: actid=>actid,
1139: aname=>aname,
1140: ignore_notfound=>FALSE);

Line 1169: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);

1165: end if;
1166:
1167: if(ignore_notfound='TRUE') then
1168: if g_debug then
1169: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);
1170: end if;
1171: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,
1172: itemkey=>itemkey,
1173: actid=>actid,

Line 1171: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,

1167: if(ignore_notfound='TRUE') then
1168: if g_debug then
1169: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);
1170: end if;
1171: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,
1172: itemkey=>itemkey,
1173: actid=>actid,
1174: aname=>aname,
1175: ignore_notfound=>TRUE);

Line 1178: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);

1174: aname=>aname,
1175: ignore_notfound=>TRUE);
1176: elsif (ignore_notfound='FALSE') then
1177: if g_debug then
1178: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);
1179: end if;
1180: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,
1181: itemkey=>itemkey,
1182: actid=>actid,

Line 1180: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,

1176: elsif (ignore_notfound='FALSE') then
1177: if g_debug then
1178: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrDate ', 2);
1179: end if;
1180: return WF_ENGINE.GetActivityAttrDate(itemtype=>itemtype,
1181: itemkey=>itemkey,
1182: actid=>actid,
1183: aname=>aname,
1184: ignore_notfound=>FALSE);

Line 1215: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);

1211: end if;
1212:
1213: if(ignore_notfound='TRUE') then
1214: if g_debug then
1215: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);
1216: end if;
1217: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,
1218: itemkey=>itemkey,
1219: actid=>actid,

Line 1217: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,

1213: if(ignore_notfound='TRUE') then
1214: if g_debug then
1215: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);
1216: end if;
1217: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,
1218: itemkey=>itemkey,
1219: actid=>actid,
1220: aname=>aname,
1221: ignore_notfound=>TRUE);

Line 1224: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);

1220: aname=>aname,
1221: ignore_notfound=>TRUE);
1222: elsif (ignore_notfound='FALSE') then
1223: if g_debug then
1224: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);
1225: end if;
1226:
1227: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,
1228: itemkey=>itemkey,

Line 1227: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,

1223: if g_debug then
1224: hr_utility.set_location('calling WF_ENGINE.GetActivityAttrNumber ', 2);
1225: end if;
1226:
1227: return WF_ENGINE.GetActivityAttrNumber(itemtype=>itemtype,
1228: itemkey=>itemkey,
1229: actid=>actid,
1230: aname=>aname,
1231: ignore_notfound=>FALSE);

Line 1323: lv_page := wf_engine.GetActivityAttrText(

1319: if(hr_utility.debug_enabled) then
1320: -- write debug statements
1321: hr_utility.set_location('getting activity attributes for activity id:'||ln_activityId ||', itemtype:'|| p_item_type||' and item key:'||p_item_key, 5);
1322: end if;
1323: lv_page := wf_engine.GetActivityAttrText(
1324: itemtype => p_item_type
1325: ,itemkey => p_item_key
1326: ,actid => ln_activityId
1327: ,aname => 'HR_ACTIVITY_TYPE_VALUE' );

Line 1328: lv_page_type := wf_engine.GetActivityAttrText(

1324: itemtype => p_item_type
1325: ,itemkey => p_item_key
1326: ,actid => ln_activityId
1327: ,aname => 'HR_ACTIVITY_TYPE_VALUE' );
1328: lv_page_type := wf_engine.GetActivityAttrText(
1329: itemtype => p_item_type
1330: ,itemkey => p_item_key
1331: ,actid => ln_activityId
1332: ,aname => 'HR_ACTIVITY_TYPE' );

Line 1334: ln_page_applicationId :=nvl( wf_engine.GetActivityAttrText(

1330: ,itemkey => p_item_key
1331: ,actid => ln_activityId
1332: ,aname => 'HR_ACTIVITY_TYPE' );
1333: -- 'APPLICATION_ID'
1334: ln_page_applicationId :=nvl( wf_engine.GetActivityAttrText(
1335: itemtype => p_item_type
1336: ,itemkey => p_item_key
1337: ,actid => ln_activityId
1338: ,aname => 'APPLICATION_ID'

Line 1344: lv_additional_params := wf_engine.getitemattrtext(

1340:
1341:
1342: -- get the additional params
1343: -- 'P_CALLED_FROM' and ???
1344: lv_additional_params := wf_engine.getitemattrtext(
1345: itemtype => p_item_type
1346: ,itemkey => p_item_key
1347: ,aname => 'P_CALLED_FROM' );
1348:

Line 1392: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);

1388:
1389:
1390: if(ignore_notfound='TRUE') then
1391: if g_debug then
1392: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);
1393: end if;
1394: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,
1395: itemkey=>itemkey,
1396: aname=>aname,

Line 1394: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,

1390: if(ignore_notfound='TRUE') then
1391: if g_debug then
1392: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);
1393: end if;
1394: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,
1395: itemkey=>itemkey,
1396: aname=>aname,
1397: ignore_notfound=>TRUE);
1398: elsif (ignore_notfound='FALSE') then

Line 1400: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);

1396: aname=>aname,
1397: ignore_notfound=>TRUE);
1398: elsif (ignore_notfound='FALSE') then
1399: if g_debug then
1400: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);
1401: end if;
1402:
1403: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,
1404: itemkey=>itemkey,

Line 1403: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,

1399: if g_debug then
1400: hr_utility.set_location('calling WF_ENGINE.GetItemAttrText ', 2);
1401: end if;
1402:
1403: return WF_ENGINE.GetItemAttrText(itemtype=>itemtype,
1404: itemkey=>itemkey,
1405: aname=>aname,
1406: ignore_notfound=>FALSE);
1407: else

Line 1516: hr_utility.set_location('querying wf_engine.GetItemAttrText for HR_RESTRICT_EDIT_ATTR with itemtype:itemkey '||lv_item_type||':'||lv_item_key, 2);

1512: -- check if the workflow process has been configured to
1513: --restrict edit to transaction owner/creator
1514: -- HR_RESTRICT_EDIT_ATTR
1515: if g_debug then
1516: hr_utility.set_location('querying wf_engine.GetItemAttrText for HR_RESTRICT_EDIT_ATTR with itemtype:itemkey '||lv_item_type||':'||lv_item_key, 2);
1517: end if;
1518:
1519: lv_restrict_edit_to_owner :=wf_engine.GetItemAttrText(itemtype=>lv_item_type,
1520: itemkey=>lv_item_key,

Line 1519: lv_restrict_edit_to_owner :=wf_engine.GetItemAttrText(itemtype=>lv_item_type,

1515: if g_debug then
1516: hr_utility.set_location('querying wf_engine.GetItemAttrText for HR_RESTRICT_EDIT_ATTR with itemtype:itemkey '||lv_item_type||':'||lv_item_key, 2);
1517: end if;
1518:
1519: lv_restrict_edit_to_owner :=wf_engine.GetItemAttrText(itemtype=>lv_item_type,
1520: itemkey=>lv_item_key,
1521: aname=>'HR_RESTRICT_EDIT_ATTR',
1522: ignore_notfound=>TRUE);
1523: if g_debug then

Line 1530: if(fnd_global.USER_NAME=wf_engine.GetItemAttrText(itemtype=>lv_item_type,

1526:
1527: if(lv_restrict_edit_to_owner='Y') then
1528: hr_utility.set_location('process configured to restrict edit to owner/creator, no edit so returning',4);
1529: -- get the current login user name and compare with the creator user name
1530: if(fnd_global.USER_NAME=wf_engine.GetItemAttrText(itemtype=>lv_item_type,
1531: itemkey=>lv_item_key,
1532: aname=>'CREATOR_PERSON_USERNAME',
1533: ignore_notfound=>TRUE))then
1534: null;

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

1575: -- build the url link
1576: -- get the link details
1577: -- get the item attribute holding the FND function name corresponding
1578: -- to the MDS document.
1579: lv_pageFunc := nvl(wf_engine.GetItemAttrText(lv_item_type,lv_item_key,'HR_OAF_EDIT_URL_ATTR',TRUE),'PQH_SS_EFFDATE');
1580: -- get the web_html_call value and params for this function
1581: begin
1582: select web_html_call,parameters
1583: into lv_web_html_call,lv_params

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

1800: null;
1801: end;
1802:
1803:
1804: if ( funmode = wf_engine.eng_run ) then
1805: -- code to update status and history
1806: if g_debug then
1807: hr_utility.set_location('Calling queryProcedure: '||queryProcedure, 20);
1808: hr_utility.set_location('itemType: '|| itemType, 21);

Line 1831: elsif ( funmode = wf_engine.eng_cancel ) then

1827: end if;
1828:
1829:
1830: --
1831: elsif ( funmode = wf_engine.eng_cancel ) then
1832: --
1833: if g_debug then
1834: hr_utility.set_location(g_package ||'.updateSFLTransaction called in funmode:'||funmode, 50);
1835: hr_utility.set_location('itemType: '|| itemType, 51);

Line 1870: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => itemtype ,

1866: hr_utility.set_location('ItemKey:'||itemkey,13);
1867: end if;
1868:
1869: begin
1870: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => itemtype ,
1871: itemkey => itemkey,
1872: aname => 'HR_NTF_SUB_FND_MSG_ATTR',
1873: ignore_notfound=>true);
1874: if(lv_ntf_sub_msg is null) then

Line 1879: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')

1875: SELECT wrpv.display_name displayName
1876: into getProcessDisplayName.lv_display_name
1877: FROM wf_runnable_processes_v wrpv
1878: WHERE wrpv.item_type = itemtype
1879: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
1880: AND rownum <=1;
1881: else
1882: fnd_message.set_name('PER',lv_ntf_sub_msg);
1883: getProcessDisplayName.lv_display_name := fnd_message.get;

Line 2012: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => lv_item_type ,

2008: hr_utility.set_location('ItemKey:'||lv_item_key,14);
2009: end if;
2010: -- lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2011:
2012: lv_ntf_sub_msg := wf_engine.GetItemAttrText(itemtype => lv_item_type ,
2013: itemkey => lv_item_key,
2014: aname => 'HR_NTF_SUB_FND_MSG_ATTR',
2015: ignore_notfound=>true);
2016:

Line 2025: l_creator_person_id:= wf_engine.GetItemAttrNumber

2021: lv_process_display_name:= fnd_message.get;
2022: end if;
2023:
2024:
2025: l_creator_person_id:= wf_engine.GetItemAttrNumber
2026: (itemtype => lv_item_type
2027: ,itemkey => lv_item_key
2028: ,aname => 'CREATOR_PERSON_ID');
2029:

Line 2031: l_current_person_id:= wf_engine.GetItemAttrNumber

2027: ,itemkey => lv_item_key
2028: ,aname => 'CREATOR_PERSON_ID');
2029:
2030:
2031: l_current_person_id:= wf_engine.GetItemAttrNumber
2032: (itemtype => lv_item_type
2033: ,itemkey => lv_item_key
2034: ,aname => 'CURRENT_PERSON_ID');
2035: if g_debug then

Line 2105: l_current_disp_name := wf_engine.GetItemAttrText

2101:
2102: if(l_current_disp_name is null ) then
2103: -- cud still be null if person doesnot exist in per_all_people_f as of now.
2104: -- resort to the existing code of fetching from wf item attribute.
2105: l_current_disp_name := wf_engine.GetItemAttrText
2106: (itemtype => lv_item_type
2107: ,itemkey => lv_item_key
2108: ,aname => 'CURRENT_PERSON_DISPLAY_NAME');
2109: end if;

Line 2188: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

2184: -- no processing return null
2185: return null;
2186: else
2187: -- get the transaction id
2188: ln_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2189: itemkey => p_item_key,
2190: aname => 'TRANSACTION_ID');
2191: -- check if we have transaction id, if not no more iteration
2192: -- will this condition ever meet ???

Line 2200: ln_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

2196: return null;
2197: end if ;
2198:
2199: -- get the AME transaction type and app id
2200: ln_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2201: itemkey => p_item_key,
2202: aname => 'HR_AME_APP_ID_ATTR');
2203: lv_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2204: itemkey => p_item_key,

Line 2203: lv_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

2199: -- get the AME transaction type and app id
2200: ln_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
2201: itemkey => p_item_key,
2202: aname => 'HR_AME_APP_ID_ATTR');
2203: lv_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
2204: itemkey => p_item_key,
2205: aname => 'HR_AME_TRAN_TYPE_ATTR');
2206: -- check if the flow is using AME
2207: if(lv_transaction_type is null) then

Line 2217: ln_addntl_approvers := NVL(wf_engine.GetItemAttrNumber(itemtype => p_item_type

2213: hr_approval_custom.g_itemkey := p_item_key;
2214:
2215: -- process the additional approvers and default approvers
2216: -- get the total number of additional approvers for this transaction
2217: ln_addntl_approvers := NVL(wf_engine.GetItemAttrNumber(itemtype => p_item_type
2218: ,itemkey => p_item_key
2219: ,aname => 'ADDITIONAL_APPROVERS_NUMBER'
2220: ,ignore_notfound=>true), 0);
2221:

Line 2232: wf_engine.SetItemAttrNumber (itemtype => p_item_type,

2228: hr_approval_wf.create_item_attrib_if_notexist(p_item_type => p_item_type
2229: ,p_item_key => p_item_key
2230: ,p_name => 'CURRENT_APPROVER_INDEX');
2231:
2232: wf_engine.SetItemAttrNumber (itemtype => p_item_type,
2233: itemkey => p_item_key,
2234: aname => 'CURRENT_APPROVER_INDEX',
2235: avalue => NULL);
2236:

Line 2245: ln_current_approver_index := NVL(wf_engine.GetItemAttrNumber(itemtype => p_item_type

2241:
2242:
2243:
2244: -- get the current_approver_index
2245: ln_current_approver_index := NVL(wf_engine.GetItemAttrNumber(itemtype => p_item_type
2246: ,itemkey => p_item_key
2247: ,aname => 'CURRENT_APPROVER_INDEX'
2248: ,ignore_notfound=>true), 0);
2249: -- set the item name

Line 2261: lv_isvalid := wf_engine.GetItemAttrText(itemtype => p_item_type,

2257: IF csr_wiav%notfound THEN
2258: lv_exists := 'N';
2259: ELSE
2260: lv_exists := 'Y';
2261: lv_isvalid := wf_engine.GetItemAttrText(itemtype => p_item_type,
2262: itemkey => p_item_key,
2263: aname => lv_item_name
2264: ,ignore_notfound=>true);
2265: lv_isvalid := NVL(lv_isvalid,' ');

Line 2275: ln_nextApprover_person_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type,

2271: END IF;
2272:
2273:
2274: IF lv_exists <>'N' AND lv_isvalid <>'DELETED' THEN
2275: ln_nextApprover_person_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type,
2276: itemkey => p_item_key,
2277: aname => lv_item_name
2278: );
2279:

Line 2283: ln_last_default_approver_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type,

2279:
2280: ELSE
2281: -- get the last default approver index
2282:
2283: ln_last_default_approver_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type,
2284: itemkey => p_item_key,
2285: aname => 'LAST_DEFAULT_APPROVER'
2286: ,ignore_notfound=>true);
2287:

Line 2296: wf_engine.GetItemAttrNumber

2292: -- now the from column will show the last approver approved.
2293: ln_nextApprover_person_id :=
2294: hr_approval_custom.Get_Next_Approver(
2295: p_person_id =>NVL(ln_last_default_approver_id,
2296: wf_engine.GetItemAttrNumber
2297: (itemtype => p_item_type
2298: ,itemkey => p_item_key
2299: ,aname => 'CREATOR_PERSON_ID')));
2300:

Line 2306: ln_currentApprover_person_id := wf_engine.GetItemAttrNumber

2302: end if;
2303: else
2304: -- flow is using AME for approvals
2305: -- get the current approver
2306: ln_currentApprover_person_id := wf_engine.GetItemAttrNumber
2307: (p_item_type,
2308: p_item_key,
2309: 'FORWARD_TO_PERSON_ID',
2310: true);

Line 2498: l_txn_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'TRANSACTION_ID',true);

2494: and api_name = 'HR_TERMINATION_SS.PROCESS_API';
2495: l_term_txn number;
2496:
2497: begin
2498: l_txn_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'TRANSACTION_ID',true);
2499: l_creator_person_id:= wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CREATOR_PERSON_ID',true);
2500: l_current_person_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);
2501: l_process_name := null;
2502:

Line 2499: l_creator_person_id:= wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CREATOR_PERSON_ID',true);

2495: l_term_txn number;
2496:
2497: begin
2498: l_txn_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'TRANSACTION_ID',true);
2499: l_creator_person_id:= wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CREATOR_PERSON_ID',true);
2500: l_current_person_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);
2501: l_process_name := null;
2502:
2503: open is_term_txn;

Line 2500: l_current_person_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);

2496:
2497: begin
2498: l_txn_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'TRANSACTION_ID',true);
2499: l_creator_person_id:= wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CREATOR_PERSON_ID',true);
2500: l_current_person_id := wf_engine.GetItemAttrNumber(p_item_type,p_item_key,'CURRENT_PERSON_ID',true);
2501: l_process_name := null;
2502:
2503: open is_term_txn;
2504: fetch is_term_txn into l_term_txn;

Line 2552: wf_engine.SetItemAttrText

2548: BEGIN
2549:
2550: if getOrganizationManagersubject(itemtype,itemkey) is not null then
2551: l_creator_disp_name := getOrganizationManagersubject(itemtype,itemkey);
2552: wf_engine.SetItemAttrText
2553: (itemtype => itemtype
2554: ,itemkey => itemkey
2555: ,aname => 'CURRENT_PERSON_DISPLAY_NAME'
2556: ,avalue => l_creator_disp_name);

Line 2559: l_details := wf_engine.getitemattrtext(itemtype,

2555: ,aname => 'CURRENT_PERSON_DISPLAY_NAME'
2556: ,avalue => l_creator_disp_name);
2557: end if;
2558:
2559: l_details := wf_engine.getitemattrtext(itemtype,
2560: itemkey,
2561: 'FYI_NTF_DETAILS',true);
2562:
2563: if l_details = 'Y' then