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

Line 41: contextUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_USER_ATTR',true);

37:
38: -- check if we have the context set by the Approver Notification
39: -- call back function; if exists
40: -- HR_CONTEXT_USER_ATTR
41: contextUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_USER_ATTR',true);
42: contextProxyUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_PROXY_ATTR',true);
43:
44: if g_debug then
45: hr_utility.set_location('contextUser value :'|| contextUser,6);

Line 42: contextProxyUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_PROXY_ATTR',true);

38: -- check if we have the context set by the Approver Notification
39: -- call back function; if exists
40: -- HR_CONTEXT_USER_ATTR
41: contextUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_USER_ATTR',true);
42: contextProxyUser := wf_engine.getitemattrtext(p_item_type,p_item_key,'HR_CONTEXT_PROXY_ATTR',true);
43:
44: if g_debug then
45: hr_utility.set_location('contextUser value :'|| contextUser,6);
46: hr_utility.set_location('contextProxyUser value :'|| contextProxyUser,6);

Line 160: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

156: ,p_item_key => p_item_key
157: ,p_name => 'HR_AME_APP_ID_ATTR') then
158: -- get the attribute value
159: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
160: c_application_id :=wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
161: itemkey => p_item_key,
162: aname => 'HR_AME_APP_ID_ATTR');
163:
164: else

Line 177: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,

173: ,p_item_key => p_item_key
174: ,p_name => 'TRANSACTION_ID') then
175: -- get the attribute value
176: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
177: c_transaction_id := wf_engine.GetItemAttrNumber(itemtype => p_item_type ,
178: itemkey => p_item_key,
179: aname => 'TRANSACTION_ID');
180: else
181: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

Line 192: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

188: ,p_item_key => p_item_key
189: ,p_name => 'HR_AME_TRAN_TYPE_ATTR') then
190: -- get the attribute value
191: hr_utility.trace('In : (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
192: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
193: itemkey => p_item_key,
194: aname => 'HR_AME_TRAN_TYPE_ATTR');
195: else
196: hr_utility.trace('In : else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);

Line 204: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,

200:
201:
202:
203:
204: c_transaction_type := wf_engine.GetItemAttrText(itemtype => p_item_type ,
205: itemkey => p_item_key,
206: aname => 'HR_AME_TRAN_TYPE_ATTR');
207:
208: if(c_transaction_type is not null) then

Line 220: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,

216: transactionTypeIn =>c_transaction_type,
217: approversOut=>c_all_approvers);
218:
219: --ns begin
220: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
221: itemkey => p_item_key,
222: aname => 'CREATOR_PERSON_USERNAME');
223: Begin
224: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,

Line 224: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,

220: c_creator_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
221: itemkey => p_item_key,
222: aname => 'CREATOR_PERSON_USERNAME');
223: Begin
224: c_return_user := wf_engine.GetItemAttrText(itemtype => p_item_type ,
225: itemkey => p_item_key,
226: aname => 'RETURN_TO_USERNAME');
227: Exception
228: WHEN others then

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

312: (p_item_type => p_item_type
313: ,p_item_key => p_item_key
314: ,p_name => 'FORWARD_FROM_DISPLAY_NAME') then
315: -- set the attribute value to null
316: wf_engine.SetItemAttrText(itemtype => p_item_type ,
317: itemkey => p_item_key,
318: aname => 'FORWARD_FROM_DISPLAY_NAME',
319: avalue=>null);
320: end if;

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

323: (p_item_type => p_item_type
324: ,p_item_key => p_item_key
325: ,p_name => 'FORWARD_FROM_USERNAME') then
326: -- set the attribute value to null
327: wf_engine.SetItemAttrText(itemtype => p_item_type ,
328: itemkey => p_item_key,
329: aname => 'FORWARD_FROM_USERNAME',
330: avalue=>null);
331: end if;

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

334: (p_item_type => p_item_type
335: ,p_item_key => p_item_key
336: ,p_name => 'FORWARD_FROM_PERSON_ID') then
337: -- set the attribute value to null
338: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
339: itemkey => p_item_key,
340: aname => 'FORWARD_FROM_PERSON_ID',
341: avalue=>null);
342: end if;

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

345: (p_item_type => p_item_type
346: ,p_item_key => p_item_key
347: ,p_name => 'FORWARD_TO_DISPLAY_NAME') then
348: -- set the attribute value to null
349: wf_engine.SetItemAttrText(itemtype => p_item_type ,
350: itemkey => p_item_key,
351: aname => 'FORWARD_TO_DISPLAY_NAME',
352: avalue=>null);
353: end if;

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

356: (p_item_type => p_item_type
357: ,p_item_key => p_item_key
358: ,p_name => 'FORWARD_TO_USERNAME') then
359: -- set the attribute value to null
360: wf_engine.SetItemAttrText(itemtype => p_item_type ,
361: itemkey => p_item_key,
362: aname => 'FORWARD_TO_USERNAME',
363: avalue=>null);
364: end if;

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

367: (p_item_type => p_item_type
368: ,p_item_key => p_item_key
369: ,p_name => 'FORWARD_TO_PERSON_ID') then
370: -- set the attribute value to null
371: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
372: itemkey => p_item_key,
373: aname => 'FORWARD_TO_PERSON_ID',
374: avalue=>null);
375: end if;

Line 384: l_approvalProcessVersion := wf_engine.GetItemAttrText(

380: * CAUTION: IF this procedure is invoked from somewhere else (apart from RFC) then this needs
381: * to be checked for that condition too.
382: */
383: Begin
384: l_approvalProcessVersion := wf_engine.GetItemAttrText(
385: itemtype => p_item_Type,
386: itemkey => p_item_Key,
387: aname => 'HR_APPROVAL_PRC_VERSION');
388: Exception

Line 396: wf_engine.GetItemAttrText(

392:
393: End;
394:
395: IF ( NVL(l_approvalProcessversion,'X') <> 'V5' OR
396: wf_engine.GetItemAttrText(
397: itemtype => p_item_Type, itemkey => p_item_Key,
398: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NOT NULL) THEN
399: -- CURRENT_APPROVER_INDEX
400: hr_utility.trace('In ( IF ( NVL(l_approvalProcessversion,X) <> V5 OR

Line 401: wf_engine.GetItemAttrText(..,..,..,)IS NOT NULL '|| l_proc);

397: itemtype => p_item_Type, itemkey => p_item_Key,
398: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NOT NULL) THEN
399: -- CURRENT_APPROVER_INDEX
400: hr_utility.trace('In ( IF ( NVL(l_approvalProcessversion,X) <> V5 OR
401: wf_engine.GetItemAttrText(..,..,..,)IS NOT NULL '|| l_proc);
402: if hr_workflow_utility.item_attribute_exists
403: (p_item_type => p_item_type
404: ,p_item_key => p_item_key
405: ,p_name => 'CURRENT_APPROVER_INDEX') then

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

403: (p_item_type => p_item_type
404: ,p_item_key => p_item_key
405: ,p_name => 'CURRENT_APPROVER_INDEX') then
406: -- set the attribute value to null
407: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
408: itemkey => p_item_key,
409: aname => 'CURRENT_APPROVER_INDEX',
410: avalue=>null);
411: end if;

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

415: (p_item_type => p_item_type
416: ,p_item_key => p_item_key
417: ,p_name => 'LAST_DEFAULT_APPROVER') then
418: -- set the attribute value to null
419: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
420: itemkey => p_item_key,
421: aname => 'LAST_DEFAULT_APPROVER',
422: avalue=>null);
423: end if;

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

428: (p_item_type => p_item_type
429: ,p_item_key => p_item_key
430: ,p_name => 'CURRENT_DEF_APPR_INDEX') then
431: -- set the attribute value to null
432: wf_engine.SetItemAttrNumber(itemtype => p_item_type ,
433: itemkey => p_item_key,
434: aname => 'CURRENT_DEF_APPR_INDEX',
435: avalue=>null);
436: end if;

Line 477: l_effective_date := wf_engine.getitemattrtext

473: open csr_item_type_key;
474: fetch csr_item_type_key into l_item_type,l_item_key;
475: close csr_item_type_key;
476: if l_item_type is not null and l_item_key is not null then
477: l_effective_date := wf_engine.getitemattrtext
478: (itemtype => l_item_type
479: ,itemkey => l_item_key
480: ,aname => 'P_EFFECTIVE_DATE');
481: else

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

510: hr_utility.set_location('Entering: '|| l_proc,5);
511: If (p_item_type is not null and
512: p_item_key is not null )
513: then
514: wf_engine.SetItemAttrText(itemtype => p_item_type,
515: itemkey => p_item_key,
516: aname => 'TRAN_SUBMIT',
517: avalue => p_status);
518: End If;

Line 727: return(wf_engine.getitemattrnumber

723: l_transaction_id number;
724: begin
725: hr_utility.set_location('Entering: '|| l_proc,5);
726: hr_utility.set_location('Leaving: '|| l_proc,10);
727: return(wf_engine.getitemattrnumber
728: (itemtype => p_item_type
729: ,itemkey => p_item_key
730: ,aname => 'TRANSACTION_ID'));
731: exception

Line 797: ln_selected_person_id := wf_engine.GetItemAttrNumber(p_item_type,

793: end if;
794:
795: If p_selected_person_id is null then
796: If p_item_type is not null and p_item_key is not null then
797: ln_selected_person_id := wf_engine.GetItemAttrNumber(p_item_type,
798: p_item_key,
799: 'CURRENT_PERSON_ID');
800: end if;
801: else

Line 807: lv_process_name := wf_engine.GetItemAttrText(p_item_type

803: end if;
804:
805: If p_process_name is null then
806: If p_item_type is not null and p_item_key is not null then
807: lv_process_name := wf_engine.GetItemAttrText(p_item_type
808: ,p_item_key
809: ,'PROCESS_NAME');
810: end if;
811: else

Line 817: lv_status := wf_engine.GetItemAttrText(p_item_type

813: end if;
814:
815: If p_status is null then
816: If p_item_type is not null and p_item_key is not null then
817: lv_status := wf_engine.GetItemAttrText(p_item_type
818: ,p_item_key
819: ,'TRAN_SUBMIT');
820: end if;
821: else

Line 827: lv_section_display_name := wf_engine.GetItemAttrText( p_item_type

823: end if;
824:
825: If p_section_display_name is null then
826: If p_item_type is not null and p_item_key is not null then
827: lv_section_display_name := wf_engine.GetItemAttrText( p_item_type
828: ,p_item_key
829: ,'HR_SECTION_DISPLAY_NAME');
830: end if;
831: else

Line 837: ln_assignment_id := wf_engine.GetItemAttrText(p_item_type

833: end if;
834:
835: If p_assignment_id is null then
836: If p_item_type is not null and p_item_key is not null then
837: ln_assignment_id := wf_engine.GetItemAttrText(p_item_type
838: ,p_item_key
839: ,'CURRENT_ASSIGNMENT_ID');
840: end if;
841: else

Line 847: ld_trans_effec_date := wf_engine.GetItemAttrText(p_item_type

843: end if;
844:
845: If p_transaction_effective_date is null then
846: If p_item_type is not null and p_item_key is not null then
847: ld_trans_effec_date := wf_engine.GetItemAttrText(p_item_type
848: ,p_item_key
849: ,'CURRENT_EFFECTIVE_DATE');
850: end if;
851: else

Line 961: wf_engine.additemattr

957: end if;
958: else
959: hr_utility.trace('In else of (if hr_workflow_utility.item_attribute_exists) '|| l_proc);
960: -- the TRANSACTION_ID does not exist so create it
961: wf_engine.additemattr
962: (itemtype => itemtype
963: ,itemkey => itemkey
964: ,aname => 'TRANSACTION_ID');
965: end if;

Line 972: wf_engine.additemattr

968: (p_item_type => itemtype
969: ,p_item_key => itemkey
970: ,p_name => 'TRANSACTION_PRIVILEGE') then
971: -- the TRANSACTION_PRIVILEGE does not exist so create it
972: wf_engine.additemattr
973: (itemtype => itemtype
974: ,itemkey => itemkey
975: ,aname => 'TRANSACTION_PRIVILEGE');
976: end if;

Line 979: wf_engine.getitemattrtext

975: ,aname => 'TRANSACTION_PRIVILEGE');
976: end if;
977: -- get the TRANSACTION_PRIVILEGE
978: l_transaction_privilege :=
979: wf_engine.getitemattrtext
980: (itemtype => itemtype
981: ,itemkey => itemkey
982: ,aname => 'TRANSACTION_PRIVILEGE');
983: -- check to see if the TRANSACTION_PRIVILEGE is null

Line 987: wf_engine.setitemattrtext

983: -- check to see if the TRANSACTION_PRIVILEGE is null
984: if l_transaction_privilege is null then
985: -- default the TRANSACTION_PRIVILEGE to PRIVATE
986: l_transaction_privilege := 'PRIVATE';
987: wf_engine.setitemattrtext
988: (itemtype => itemtype
989: ,itemkey => itemkey
990: ,aname => 'TRANSACTION_PRIVILEGE'
991: ,avalue => l_transaction_privilege);

Line 1028: wf_engine.setitemattrnumber

1024: ,p_effective_date_option=>p_effective_date_option
1025: ,p_api_addtnl_info=>p_api_addtnl_info);
1026:
1027: -- set the TRANSACTION_ID
1028: wf_engine.setitemattrnumber
1029: (itemtype => itemtype
1030: ,itemkey => itemkey
1031: ,aname => 'TRANSACTION_ID'
1032: ,avalue => l_transaction_id);

Line 1711: wf_engine.setitemattrtext

1707: if l_error_text is null then
1708: l_error_text := fnd_message.get;
1709: end if;
1710: -- 1903606
1711: wf_engine.setitemattrtext
1712: (itemtype => itemtype
1713: ,itemkey => itemkey
1714: ,aname => 'TRAN_SUBMIT'
1715: ,avalue => 'E');

Line 1718: wf_engine.setitemattrtext

1714: ,aname => 'TRAN_SUBMIT'
1715: ,avalue => 'E');
1716:
1717: -- set the ERROR_MESSAGE_TEXT
1718: wf_engine.setitemattrtext
1719: (itemtype => itemtype
1720: ,itemkey => itemkey
1721: ,aname => 'ERROR_MESSAGE_TEXT'
1722: ,avalue => nvl(l_error_text, l_sqlerrm));

Line 1738: wf_engine.setitemattrtext

1734: hr_utility.set_location('EXCEPTION: '|| l_proc,565);
1735: -- rollback any work
1736: rollback to commit_transaction;
1737: -- 1903606
1738: wf_engine.setitemattrtext
1739: (itemtype => itemtype
1740: ,itemkey => itemkey
1741: ,aname => 'TRAN_SUBMIT'
1742: ,avalue => 'E');

Line 1744: wf_engine.setitemattrtext

1740: ,itemkey => itemkey
1741: ,aname => 'TRAN_SUBMIT'
1742: ,avalue => 'E');
1743: -- set the ERROR_MESSAGE_TEXT
1744: wf_engine.setitemattrtext
1745: (itemtype => itemtype
1746: ,itemkey => itemkey
1747: ,aname => 'ERROR_MESSAGE_TEXT'
1748: ,avalue => l_sqlerrm);

Line 1816: --wf_engine.completeactivity

1812: (p_item_type => p_item_type
1813: ,p_item_key => p_item_key
1814: ,p_actid => p_actid
1815: ,p_result => 'SUCCESS');
1816: --wf_engine.completeactivity
1817: -- (itemtype => p_item_type
1818: -- ,itemkey => p_item_key
1819: -- ,activity => '#'||p_actid
1820: -- ,result => 'SUCCESS');

Line 2080: if ( wf_engine.GetItemAttrText(p_item_type ,p_item_key ,'HR_APPROVAL_PRC_VERSION') = 'V5' ) then

2076:
2077: IF ln_transaction_id IS NOT NULL THEN
2078: hr_utility.trace('In ( I IF ln_transaction_id IS NOT NULL ) '|| l_proc);
2079: Begin
2080: if ( wf_engine.GetItemAttrText(p_item_type ,p_item_key ,'HR_APPROVAL_PRC_VERSION') = 'V5' ) then
2081: lv_status := hr_api.g_varchar2; -- so that the original value is picked from txn table;
2082: end if;
2083: Exception
2084: when Others then -- wf attribute not found