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

Line 214: wf_engine.setItemAttrText (

210: p_transaction_id => p_txnId
211: ,p_transaction_effective_date => l_effectiveDate
212: ,p_effective_date_option => NVL(l_dateOption,'E') );
213: --
214: wf_engine.setItemAttrText (
215: itemtype => p_itemType
216: ,itemkey => p_itemKey
217: ,aname => 'P_EFFECTIVE_DATE'
218: ,avalue => TO_CHAR(l_effectiveDate,g_date_format) );

Line 563: l_activity_name := wf_engine.getActivityLabel(l_activity);

559: ELSIF ( p_otherAct = 'THIS') THEN
560: l_activity := p_activity;
561: END IF;
562: --
563: l_activity_name := wf_engine.getActivityLabel(l_activity);
564:
565: begin
566: actdate := Wf_Item.Active_Date(p_itemType, p_itemKey);
567: acttype := Wf_Activity.Instance_Type(l_activity, actdate);

Line 569: if (acttype = wf_engine.eng_notification) then

565: begin
566: actdate := Wf_Item.Active_Date(p_itemType, p_itemKey);
567: acttype := Wf_Activity.Instance_Type(l_activity, actdate);
568:
569: if (acttype = wf_engine.eng_notification) then
570: -- Get notification id
571: Wf_Item_Activity_Status.Notification_Status(p_itemType, p_itemKey, l_activity,
572: notid, user);
573: end if;

Line 603: wf_engine.CompleteActivity(

599: ,null
600: ,fnd_global.user_name
601: ,null);
602: else
603: wf_engine.CompleteActivity(
604: p_itemType
605: , p_itemKey
606: , l_activity_name
607: , p_resultCode) ;

Line 650: IF (funcmode = wf_engine.eng_run) THEN

646:
647:
648: BEGIN
649: --
650: IF (funcmode = wf_engine.eng_run) THEN
651:
652: -- fix for bug 4454439
653: begin
654: -- re-intialize the performer roles

Line 684: ,wf_engine.GetItemAttrText(

680:
681: wf_notification.setattrtext(
682: l_NtfId
683: ,'WF_NOTE'
684: ,wf_engine.GetItemAttrText(
685: itemtype
686: ,itemkey
687: ,'APPROVAL_COMMENT_COPY'));
688: wf_engine.setitemattrtext(

Line 688: wf_engine.setitemattrtext(

684: ,wf_engine.GetItemAttrText(
685: itemtype
686: ,itemkey
687: ,'APPROVAL_COMMENT_COPY'));
688: wf_engine.setitemattrtext(
689: itemtype
690: ,itemkey
691: ,'APPROVAL_COMMENT_COPY'
692: ,null);

Line 703: ,wf_engine.GetItemAttrText(

699: ,'WF_SYSTEM'
700: --,hr_workflow_ss.getNextApproverForHist(itemtype, itemkey)
701: ,'RESUBMIT'
702: ,null
703: ,wf_engine.GetItemAttrText(
704: itemtype
705: ,itemkey
706: ,'APPROVAL_COMMENT_COPY'));
707: END IF;

Line 914: l_rehire_flow := wf_engine.GetItemAttrText(p_itemType,p_itemKey,'HR_FLOW_IDENTIFIER',true);

910:
911: IF ( l_terminationDate IS NOT NULL ) THEN
912:
913: if p_itemType is not null and p_itemKey is not null then
914: l_rehire_flow := wf_engine.GetItemAttrText(p_itemType,p_itemKey,'HR_FLOW_IDENTIFIER',true);
915:
916: end if;
917:
918: --

Line 938: l_rehire_flow := wf_engine.GetItemAttrText(p_itemType,p_itemKey,'HR_FLOW_IDENTIFIER',true);

934: OPEN cur_term_emp(p_personId, TO_DATE(p_effectiveDate, g_date_format ));
935: FETCH cur_term_emp INTO dummy;
936: --
937: if p_itemType is not null and p_itemKey is not null then
938: l_rehire_flow := wf_engine.GetItemAttrText(p_itemType,p_itemKey,'HR_FLOW_IDENTIFIER',true);
939: end if;
940: If nvl(l_rehire_flow,'N') <> 'EX_EMP' AND nvl(l_rehire_flow,'N') <> 'REVERSE_TERMINATION' then
941: IF cur_term_emp%FOUND THEN -- Person is found to be terminated
942: --

Line 1029: p_processName := wf_engine.GetItemAttrText(

1025: CLOSE cur_pay;
1026: END IF;
1027:
1028: IF ( p_processName IS NULL ) THEN
1029: p_processName := wf_engine.GetItemAttrText(
1030: itemtype => p_itemType
1031: ,itemkey => p_itemKey
1032: ,aname => 'PROCESS_NAME');
1033: END IF;

Line 1036: l_flowName := wf_engine.GetItemAttrText(

1032: ,aname => 'PROCESS_NAME');
1033: END IF;
1034: --
1035: BEGIN
1036: l_flowName := wf_engine.GetItemAttrText(
1037: itemtype => p_itemType,
1038: itemkey => p_itemKey,
1039: aname => 'HR_FLOW_NAME_ATTR');
1040: EXCEPTION

Line 1248: l_savedActivityId := wf_engine.GetItemAttrText(

1244: -- if the txn is in sfl status AND if either unsaved changes found that user wanted to revert or txn is in transient state
1245: -- transition back to saved activity
1246: IF ( l_savedStatus AND ( (p_state='T') OR (p_state = 'W' AND p_revertFlag = 'Y') ) )THEN
1247: --
1248: l_savedActivityId := wf_engine.GetItemAttrText(
1249: itemtype => p_itemType,
1250: itemkey => p_itemKey,
1251: aname => 'SAVED_ACTIVITY_ID');
1252: --

Line 1261: l_activityLabel := WF_ENGINE.GetActivityLabel(l_savedActivityId);

1257:
1258: IF (l_savedActivityId <> l_currentActivityId ) THEN
1259:
1260: -- handle error to go back to the saved activity
1261: l_activityLabel := WF_ENGINE.GetActivityLabel(l_savedActivityId);
1262: --
1263: --possibility of the method closing the notification
1264: -- instead of the form activity.
1265: if(l_activityLabel is not null) then

Line 1266: WF_ENGINE.handleError(

1262: --
1263: --possibility of the method closing the notification
1264: -- instead of the form activity.
1265: if(l_activityLabel is not null) then
1266: WF_ENGINE.handleError(
1267: itemType => p_itemType
1268: ,itemKey => p_itemKey
1269: ,activity => l_activityLabel
1270: ,command => 'RETRY' ) ;

Line 1408: l_regionCode := wf_engine.GetActivityAttrText(

1404: p_itemType => p_itemType
1405: ,p_itemKey => p_itemKey);
1406: -- If attribute is not found, means the transaction was submitted and thus current activity is BLOCK
1407: -- Complete this activity with RESULT=REDO and fetch the attribute value from the current activity.
1408: l_regionCode := wf_engine.GetActivityAttrText(
1409: itemtype => p_itemType
1410: ,itemkey => p_itemKey
1411: ,actid => p_activityId
1412: ,aname => 'HR_ACTIVITY_TYPE_VALUE' );

Line 1418: l_applicationId := wf_engine.GetActivityAttrText(

1414: DECLARE
1415: activity_attr_doesnot_exist exception;
1416: pragma exception_init(activity_attr_doesnot_exist, -20002);
1417: BEGIN
1418: l_applicationId := wf_engine.GetActivityAttrText(
1419: itemtype => p_itemType
1420: ,itemkey => p_itemKey
1421: ,actid => p_activityId
1422: ,aname => 'APPLICATION_ID' );

Line 1433: p_functionName := wf_engine.GetItemAttrText(

1429: WHEN OTHERS THEN
1430: raise;
1431: END;
1432: --
1433: p_functionName := wf_engine.GetItemAttrText(
1434: itemtype => p_itemType
1435: ,itemkey => p_itemKey
1436: ,aname => 'P_CALLED_FROM');
1437: --

Line 1537: l_newStatus := wf_engine.eng_null;

1533:
1534:
1535: --
1536: IF (l_status in ('Y','RI','RO')) THEN
1537: l_newStatus := wf_engine.eng_null;
1538: ELSE
1539: l_newStatus := 'SFL';
1540: END IF;
1541: complete_wf_activity (

Line 1572: wf_engine.getitemattrtext(p_itemType,

1568: -- approver edit or rfc edit submit case
1569: hr_trans_history_api.archive_resubmit(l_transactionId,
1570: null,
1571: fnd_global.user_name,
1572: wf_engine.getitemattrtext(p_itemType,
1573: p_itemKey,
1574: 'APPROVAL_COMMENT_COPY')
1575: );
1576:

Line 1622: wf_engine.GetItemAttrText(

1618: ELSIF (p_action = 'RFC' ) THEN
1619: -- Fetch the Return to Username and Creator User Name from WF
1620: BEGIN
1621: l_ReturnToUser :=
1622: wf_engine.GetItemAttrText(
1623: itemtype => p_itemType,
1624: itemkey => p_itemKey,
1625: aname => 'RETURN_TO_USERNAME');
1626: EXCEPTION

Line 1638: wf_engine.SetItemAttrText(

1634: --in pending actions table.
1635: l_newStatus := 'C';
1636: -- Bug 3031918: TRAN_SUBMIT need to be set to C for v4 processes
1637: -- on Return for Correction
1638: wf_engine.SetItemAttrText(
1639: itemtype => p_itemType,
1640: itemkey => p_itemKey,
1641: aname => 'TRAN_SUBMIT',
1642: avalue => l_newStatus );

Line 1646: wf_engine.GetItemAttrText(

1642: avalue => l_newStatus );
1643:
1644: ELSE
1645: l_CreatorUser :=
1646: wf_engine.GetItemAttrText(
1647: itemtype => p_itemType,
1648: itemkey => p_itemKey,
1649: aname => 'CREATOR_PERSON_USERNAME');
1650: --

Line 1674: wf_engine.SetItemAttrText(

1670: /*hr_transaction_api.update_transaction(
1671: p_transaction_id => l_transactionId,
1672: p_status => l_newStatus,
1673: p_transaction_state => l_newState );*/
1674: wf_engine.SetItemAttrText(
1675: itemtype => p_itemType,
1676: itemkey => p_itemKey,
1677: aname => 'TRAN_SUBMIT',
1678: avalue => l_newStatus );

Line 1718: IF (funcmode = wf_engine.eng_run) THEN

1714: result OUT NOCOPY VARCHAR2 ) IS
1715: --
1716: BEGIN
1717: --
1718: IF (funcmode = wf_engine.eng_run) THEN
1719: --
1720: set_transaction_status (
1721: p_itemType => itemType
1722: ,p_itemKey => itemKey

Line 1747: IF (funcmode = wf_engine.eng_run) THEN

1743: result OUT NOCOPY VARCHAR2 ) IS
1744: --
1745: BEGIN
1746: --
1747: IF (funcmode = wf_engine.eng_run) THEN
1748: --
1749: set_transaction_status (
1750: p_itemType => itemType
1751: ,p_itemKey => itemKey

Line 1774: IF (funcmode = wf_engine.eng_run) THEN

1770: result OUT NOCOPY VARCHAR2 ) IS
1771: --
1772: BEGIN
1773: --
1774: IF (funcmode = wf_engine.eng_run) THEN
1775: --
1776: /* Fix for bug# 3389563
1777: The calls will be part of Java calls.
1778: This procedure should not be invoked from with in any Workflow process.

Line 1786: result:= wf_engine.eng_trans_default;

1782: ,p_activityId=> actId
1783: ,p_action => 'SFL'
1784: ,p_result => result );
1785: */
1786: result:= wf_engine.eng_trans_default;
1787: --
1788: END IF;
1789:
1790: EXCEPTION

Line 1902: IF (funcmode <> wf_engine.eng_run) THEN

1898: -- SELECT status
1899: -- FROM hr_api_transactions
1900: -- WHERE transaction_id = l_transactionId;
1901: BEGIN
1902: IF (funcmode <> wf_engine.eng_run) THEN
1903: result := wf_engine.eng_null;
1904: RETURN;
1905: END IF;
1906:

Line 1903: result := wf_engine.eng_null;

1899: -- FROM hr_api_transactions
1900: -- WHERE transaction_id = l_transactionId;
1901: BEGIN
1902: IF (funcmode <> wf_engine.eng_run) THEN
1903: result := wf_engine.eng_null;
1904: RETURN;
1905: END IF;
1906:
1907: l_transactionId := get_transaction_id (

Line 1937: wf_engine.setitemattrnumber

1933: (p_transaction_id => l_transactionId );
1934:
1935: --3099089 change starts
1936: --need to remove transaction_id from wf_item_attribute_values also
1937: wf_engine.setitemattrnumber
1938: (itemtype => itemtype
1939: ,itemkey => itemkey
1940: ,aname => 'TRANSACTION_ID'
1941: ,avalue => null);

Line 2006: IF (funcmode = wf_engine.eng_run ) THEN

2002: l_status VARCHAR2(10);
2003: --
2004: BEGIN
2005: --
2006: IF (funcmode = wf_engine.eng_run ) THEN
2007:
2008: /*
2009: 07-May-2003 ns moved to approval_block
2010: -- Set the Approval process version to distinguish it

Line 2012: wf_engine.SetItemAttrText(

2008: /*
2009: 07-May-2003 ns moved to approval_block
2010: -- Set the Approval process version to distinguish it
2011: -- it from old approval process.
2012: wf_engine.SetItemAttrText(
2013: itemtype => itemType
2014: , itemkey => itemKey
2015: , aname => 'HR_APPROVAL_PRC_VERSION'
2016: , avalue => 'V5' );

Line 2155: l_userName := wf_engine.GetItemAttrText(

2151: null;
2152: end;
2153:
2154:
2155: l_userName := wf_engine.GetItemAttrText(
2156: itemtype => l_itemType
2157: , itemkey => l_itemKey
2158: , aname => 'CREATOR_PERSON_USERNAME');
2159: ELSE

Line 2173: wf_engine.SetItemAttrText(

2169:
2170: END IF;
2171:
2172: -- Set the item attribute for the return to user name.
2173: wf_engine.SetItemAttrText(
2174: itemtype => l_itemType
2175: , itemkey => l_itemKey
2176: , aname => 'RETURN_TO_USERNAME'
2177: , avalue => l_userName );

Line 2184: wf_engine.SetItemAttrText(

2180: p_item_type => l_itemtype
2181: ,p_item_key => l_itemkey
2182: ,p_name => 'RETURN_TO_PERSON_DISPLAY_NAME');
2183:
2184: wf_engine.SetItemAttrText(
2185: itemtype => l_itemType
2186: , itemkey => l_itemKey
2187: , aname => 'RETURN_TO_PERSON_DISPLAY_NAME'
2188: , avalue => p_userDisplayName );

Line 2197: wf_engine.setItemAttrText (

2193: ,p_itemKey => l_itemKey
2194: ,p_ntfId => p_ntfId );
2195: --
2196: -- Set the notes for RFC notification.
2197: wf_engine.setItemAttrText (
2198: itemtype => l_itemType
2199: ,itemkey => l_itemKey
2200: ,aname => 'NOTE_FROM_APPR'
2201: ,avalue => p_note );

Line 2203: wf_engine.setItemAttrText (

2199: ,itemkey => l_itemKey
2200: ,aname => 'NOTE_FROM_APPR'
2201: ,avalue => p_note );
2202:
2203: wf_engine.setItemAttrText (
2204: itemtype => l_itemType
2205: ,itemkey => l_itemKey
2206: ,aname => 'WF_NOTE'
2207: ,avalue => NULL );

Line 2253: IF (wf_engine.GetItemAttrText(itemtype => l_itemType ,

2249: ,aname => '#FROM_ROLE'
2250: ,avalue => fnd_global.user_name );
2251:
2252: -- Set the two workflow attributes for Non-AME approval process
2253: IF (wf_engine.GetItemAttrText(itemtype => l_itemType ,
2254: itemkey => l_itemKey,
2255: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NULL) THEN
2256: -- CURRENT_APPROVER_INDEX
2257: begin

Line 2259: wf_engine.SetItemAttrNumber(

2255: aname => 'HR_AME_TRAN_TYPE_ATTR') IS NULL) THEN
2256: -- CURRENT_APPROVER_INDEX
2257: begin
2258: -- set the attribute value to null
2259: wf_engine.SetItemAttrNumber(
2260: itemtype => l_itemType ,
2261: itemkey => l_itemKey,
2262: aname => 'CURRENT_APPROVER_INDEX',
2263: avalue => p_approverIndex);

Line 2298: wf_engine.SetItemAttrNumber(

2294:
2295: CLOSE cur_add_appr;
2296:
2297: IF ( l_lastDefaultApprover IS NOT NULL ) THEN
2298: wf_engine.SetItemAttrNumber(
2299: itemtype => l_itemType ,
2300: itemkey => l_itemKey,
2301: aname => 'LAST_DEFAULT_APPROVER',
2302: avalue => l_lastDefaultApprover);

Line 2475: wf_engine.setItemAttrText

2471: HR_TRANSACTION_API.update_transaction (
2472: p_transaction_id => l_txnId
2473: ,p_transaction_effective_date => l_effectiveDate );
2474: --
2475: wf_engine.setItemAttrText
2476: (itemtype => itemType
2477: ,itemkey => itemKey
2478: ,aname => 'P_EFFECTIVE_DATE'
2479: ,avalue => TO_CHAR(l_effectiveDate,g_date_format) );

Line 2481: wf_engine.setItemAttrDate

2477: ,itemkey => itemKey
2478: ,aname => 'P_EFFECTIVE_DATE'
2479: ,avalue => TO_CHAR(l_effectiveDate,g_date_format) );
2480: -- Bug 4243314 starts.
2481: wf_engine.setItemAttrDate
2482: (itemtype => itemType
2483: ,itemkey => itemKey
2484: ,aname => 'CURRENT_EFFECTIVE_DATE'
2485: ,avalue =>l_effectiveDate);

Line 2652: IF wf_engine.GetItemAttrText(

2648: -- If non-approval process and final_validation is being performed,
2649: -- then only check for future dated changes.
2650: IF (NVL(p_calledFrom,'X') = 'FINAL_VALIDATION' ) THEN
2651: BEGIN
2652: IF wf_engine.GetItemAttrText(
2653: itemtype => p_itemType,
2654: itemkey => p_itemKey,
2655: aname => 'HR_RUNTIME_APPROVAL_REQ_FLAG')
2656: NOT IN ('YES','YES_DYNAMIC') THEN

Line 2666: l_effectiveDate := NVL( wf_engine.getItemAttrText (

2662: END;
2663: END IF;
2664: --
2665:
2666: l_effectiveDate := NVL( wf_engine.getItemAttrText (
2667: itemtype => p_itemType
2668: ,itemkey => p_itemKey
2669: ,aname => 'P_EFFECTIVE_DATE'),to_char(sysdate,g_date_format));
2670:

Line 2700: l_cpersonId := NVL( wf_engine.getItemAttrText (

2696: ,p_rateMessage => l_rateMsg
2697: ,p_terminateFlag => l_terminateFlag);
2698:
2699: --fix for the bug 7640649
2700: l_cpersonId := NVL( wf_engine.getItemAttrText (
2701: itemtype => p_itemType
2702: ,itemkey => p_itemKey
2703: ,aname => 'CREATOR_PERSON_ID'),-1);
2704:

Line 2949: wf_engine.setitemattrtext

2945: p_status => 'E');
2946:
2947: -- Fix for bug 8334527 :
2948:
2949: wf_engine.setitemattrtext
2950: (itemtype => itemtype
2951: ,itemkey => itemkey
2952: ,aname => 'TRAN_SUBMIT'
2953: ,avalue => 'E');

Line 2956: wf_engine.SetItemAttrText(

2952: ,aname => 'TRAN_SUBMIT'
2953: ,avalue => 'E');
2954:
2955: result := 'COMPLETE:FAILURE';
2956: wf_engine.SetItemAttrText(
2957: itemtype => itemType
2958: , itemkey => itemKey
2959: , aname => 'ERROR_MESSAGE' -- Bug 2962967: changed from ERROR_MESSAGE_TEXT
2960: , avalue => l_errorWarnings );

Line 2964: wf_engine.SetItemAttrText(

2960: , avalue => l_errorWarnings );
2961: END IF;
2962: --
2963: -- Set send to HR rep attribute
2964: wf_engine.SetItemAttrText(
2965: itemtype => itemType
2966: , itemkey => itemKey
2967: , aname => 'SEND_TO_HR_REP'
2968: , avalue => l_sendToHr );

Line 3072: wf_engine.GetItemAttrText(

3068: ,p_itemType => l_itemType
3069: ,p_itemKey => l_itemKey );
3070:
3071: l_isCustomRFC :=
3072: wf_engine.GetItemAttrText(
3073: itemtype => l_itemType
3074: ,itemkey => l_itemKey
3075: ,aname => 'HR_CUSTOM_RETURN_FOR_CORR');
3076:

Line 3163: l_personId := wf_engine.GetItemAttrText(

3159: AND orig_system_id = p_role_id ;
3160:
3161: BEGIN
3162:
3163: l_personId := wf_engine.GetItemAttrText(
3164: itemtype => itemtype,
3165: itemkey => itemkey,
3166: aname => 'CURRENT_PERSON_ID');
3167:

Line 3203: wf_engine.SetItemAttrText(

3199: result := 'COMPLETE:FAILURE';
3200: --
3201: ELSE
3202: --
3203: wf_engine.SetItemAttrText(
3204: itemtype => itemtype,
3205: itemkey => itemkey,
3206: aname => 'HR_REP_ROLE',
3207: avalue => l_roleName);

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

3237: resultout in out nocopy varchar2)
3238: is
3239: begin
3240: -- Do nothing in cancel or timeout mode
3241: if (funcmode <> wf_engine.eng_run) then
3242: resultout := wf_engine.eng_null;
3243: return;
3244: end if;
3245:

Line 3242: resultout := wf_engine.eng_null;

3238: is
3239: begin
3240: -- Do nothing in cancel or timeout mode
3241: if (funcmode <> wf_engine.eng_run) then
3242: resultout := wf_engine.eng_null;
3243: return;
3244: end if;
3245:
3246: -- Set the Approval process version to distinguish it

Line 3248: wf_engine.SetItemAttrText(

3244: end if;
3245:
3246: -- Set the Approval process version to distinguish it
3247: -- it from old approval process.
3248: wf_engine.SetItemAttrText(
3249: itemtype => itemType
3250: , itemkey => itemKey
3251: , aname => 'HR_APPROVAL_PRC_VERSION'
3252: , avalue => 'V5' );

Line 3254: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||

3250: , itemkey => itemKey
3251: , aname => 'HR_APPROVAL_PRC_VERSION'
3252: , avalue => 'V5' );
3253: --
3254: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
3255: ':'||wf_engine.eng_null;
3256: exception
3257: when others then
3258: hr_utility.trace(' exception in '||g_package||'.approval_block : ' || sqlerrm);

Line 3255: ':'||wf_engine.eng_null;

3251: , aname => 'HR_APPROVAL_PRC_VERSION'
3252: , avalue => 'V5' );
3253: --
3254: resultout := wf_engine.eng_notified||':'||wf_engine.eng_null||
3255: ':'||wf_engine.eng_null;
3256: exception
3257: when others then
3258: hr_utility.trace(' exception in '||g_package||'.approval_block : ' || sqlerrm);
3259: Wf_Core.Context(g_package, 'approval_block', itemType, itemKey);

Line 3787: wf_engine.SetItemAttrText(

3783: actid IN NUMBER,
3784: funcmode IN VARCHAR2,
3785: result OUT NOCOPY VARCHAR2 ) IS
3786: BEGIN
3787: wf_engine.SetItemAttrText(
3788: itemtype => itemType
3789: , itemkey => itemKey
3790: , aname => 'HR_PERINFO_PROCESS_SECTION'
3791: , avalue => NULL );

Line 3807: l_viewImage := wf_engine.GetActivityAttrText(

3803: l_rfcImage VARCHAR2(100);
3804: --
3805: BEGIN
3806: --
3807: l_viewImage := wf_engine.GetActivityAttrText(
3808: itemtype => itemType
3809: ,itemkey => itemKey
3810: ,actid => actId
3811: ,aname => 'VIEW_IMAGE_NAME' );

Line 3816: l_rfcImage := wf_engine.GetActivityAttrText(

3812: if ( l_viewImage IS NULL ) then
3813: l_viewImage := 'previewscreen_enabled.gif';
3814: end if;
3815: --
3816: l_rfcImage := wf_engine.GetActivityAttrText(
3817: itemtype => itemType
3818: ,itemkey => itemKey
3819: ,actid => actId
3820: ,aname => 'RFC_IMAGE_NAME' );

Line 3827: wf_engine.SetItemAttrText(

3823: l_rfcImage := 'backarro.gif';
3824: end if;
3825: --
3826: --
3827: wf_engine.SetItemAttrText(
3828: itemtype => itemType
3829: , itemkey => itemKey
3830: , aname => 'IMG_VIEW_ACTION'
3831: , avalue => g_OA_MEDIA||l_viewImage

Line 3835: wf_engine.SetItemAttrText(

3831: , avalue => g_OA_MEDIA||l_viewImage
3832: );
3833: --
3834: --
3835: wf_engine.SetItemAttrText(
3836: itemtype => itemType
3837: , itemkey => itemKey
3838: , aname => 'IMG_RFC_ACTION'
3839: , avalue => g_OA_MEDIA||l_rfcImage

Line 3874: l_ntf_err_text := wf_engine.GetItemAttrText(

3870: NULL;
3871: END;
3872: -- For Commit system errors this item attribute gets populated
3873: BEGIN
3874: l_ntf_err_text := wf_engine.GetItemAttrText(
3875: itemtype => p_itemType,
3876: itemkey => p_itemKey,
3877: aname => 'ERROR_MESSAGE_TEXT');
3878: EXCEPTION

Line 3892: l_sal_basis_change_token := wf_engine.GetItemAttrText(

3888: hr_multi_message.add( p_message_type => hr_multi_message.G_ERROR_MSG);
3889: END IF;
3890: IF (l_ntf_name = 'HR_EMBED_NTF_PAY_CONTACT_MSG')
3891: THEN
3892: l_sal_basis_change_token := wf_engine.GetItemAttrText(
3893: itemtype => p_itemType,
3894: itemkey => p_itemKey,
3895: aname => 'HR_SALARY_BASIS_CHANGE_TOKEN');
3896: l_current_person_display_name := wf_engine.GetItemAttrText(

Line 3896: l_current_person_display_name := wf_engine.GetItemAttrText(

3892: l_sal_basis_change_token := wf_engine.GetItemAttrText(
3893: itemtype => p_itemType,
3894: itemkey => p_itemKey,
3895: aname => 'HR_SALARY_BASIS_CHANGE_TOKEN');
3896: l_current_person_display_name := wf_engine.GetItemAttrText(
3897: itemtype => p_itemType,
3898: itemkey => p_itemKey,
3899: aname => 'CURRENT_PERSON_DISPLAY_NAME');
3900: l_process_display_name := wf_engine.GetItemAttrText(

Line 3900: l_process_display_name := wf_engine.GetItemAttrText(

3896: l_current_person_display_name := wf_engine.GetItemAttrText(
3897: itemtype => p_itemType,
3898: itemkey => p_itemKey,
3899: aname => 'CURRENT_PERSON_DISPLAY_NAME');
3900: l_process_display_name := wf_engine.GetItemAttrText(
3901: itemtype => p_itemType,
3902: itemkey => p_itemKey,
3903: aname => 'PROCESS_DISPLAY_NAME');
3904: l_note_from_requestor := wf_engine.GetItemAttrText(

Line 3904: l_note_from_requestor := wf_engine.GetItemAttrText(

3900: l_process_display_name := wf_engine.GetItemAttrText(
3901: itemtype => p_itemType,
3902: itemkey => p_itemKey,
3903: aname => 'PROCESS_DISPLAY_NAME');
3904: l_note_from_requestor := wf_engine.GetItemAttrText(
3905: itemtype => p_itemType,
3906: itemkey => p_itemKey,
3907: aname => 'APPROVAL_COMMENT_COPY');
3908:

Line 3928: l_note_from_approver := wf_engine.GetItemAttrText(

3924: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3925: l_errors := 'Y';
3926: ELSIF (l_ntf_name = 'HR_EMBED_V5_RFC_OTHER' or l_ntf_name = 'HR_EMBED_V5_RFC_INITIATOR')
3927: THEN
3928: l_note_from_approver := wf_engine.GetItemAttrText(
3929: itemtype => p_itemType,
3930: itemkey => p_itemKey,
3931: aname => 'NOTE_FROM_APPR');
3932: hr_utility.set_message(800, 'HRSSA_NOTE_FROM_APPR');

Line 3938: l_error_message := wf_engine.GetItemAttrText(

3934: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3935: l_errors := 'Y';
3936: ELSIF (l_ntf_name = 'HR_EMBED_TXN_ERROR_MSG')
3937: THEN
3938: l_error_message := wf_engine.GetItemAttrText(
3939: itemtype => p_itemType,
3940: itemkey => p_itemKey,
3941: aname => 'ERROR_MESSAGE');
3942: hr_utility.set_message(800, 'HRSSA_TXN_ERROR_MSG');

Line 3950: hr_approval_ss.checktransactionstate(wf_engine.getitemattrnumber

3946: hr_multi_message.add( p_message_type => hr_multi_message.G_INFORMATION_MSG);
3947: l_errors := 'Y';
3948: END IF;
3949:
3950: hr_approval_ss.checktransactionstate(wf_engine.getitemattrnumber
3951: (itemtype => p_itemType
3952: ,itemkey => p_itemKey
3953: ,aname => 'TRANSACTION_ID'));
3954: