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

Line 155: lv_wi_instance_id := Wf_Engine.GetItemAttrNumber(itemtype => itemtype

151:
152: -- Get the SFM WI Instance ID
153: --
154:
155: lv_wi_instance_id := Wf_Engine.GetItemAttrNumber(itemtype => itemtype
156: ,itemkey => itemkey
157: ,aname => gv_WI_INSTANCE_ID_ATTR);
158:
159: IF (funcmode = 'RUN') THEN

Line 601: l_activity_label := Wf_Engine.GetActivityLabel(pp_actid);

597: END IF;
598:
599: -- Get the current Workflow Activity Label
600:
601: l_activity_label := Wf_Engine.GetActivityLabel(pp_actid);
602:
603: -- Get the SYNC_LABEL from the SFM Order Line Item
604:
605: l_sync_label := Xdp_Engine.Get_Line_Param_Value (

Line 629: l_last := wf_engine.GetItemAttrText(itemtype => pp_itemtype,

625: END IF ;
626:
627: -- retrieve the IS_LAST_SYNC item type attribute
628:
629: l_last := wf_engine.GetItemAttrText(itemtype => pp_itemtype,
630: itemkey => pp_itemkey,
631: aname => 'IS_LAST_SYNC') ;
632:
633: IF (l_last = 'N') THEN

Line 669: wf_engine.GetItemAttrText(itemtype => pp_itemtype,

665:
666: -- get the SDP_RESULT_CODE item attribute
667:
668: l_sdp_result_code :=
669: wf_engine.GetItemAttrText(itemtype => pp_itemtype,
670: itemkey => pp_itemkey,
671: aname => 'SDP_RESULT_CODE') ;
672:
673: IF (l_status = gv_SYNC_ACTIVE_STATUS) THEN

Line 730: wf_engine.SetItemAttrText(itemtype => pp_itemtype

726: SET status = l_status
727: ,parties_not_in_sync = l_parties_not_in_sync
728: WHERE CURRENT OF l_sync_reg_cur;
729:
730: wf_engine.SetItemAttrText(itemtype => pp_itemtype
731: ,itemkey => pp_itemkey
732: ,aname => 'IS_LAST_SYNC'
733: ,avalue => 'N') ;
734:

Line 834: po_order_id := Wf_Engine.GetItemAttrNumber(itemtype => pp_itemtype

830: BEGIN
831:
832: -- SFM Order ID
833: --
834: po_order_id := Wf_Engine.GetItemAttrNumber(itemtype => pp_itemtype
835: ,itemkey => pp_itemkey
836: ,aname => gv_SDP_ORDER_ID_ATTR);
837:
838: IF po_order_id IS NULL THEN

Line 845: po_line_item_id := Wf_Engine.GetItemAttrNumber(itemtype => pp_itemtype

841: END IF;
842:
843: -- SFM Order Line Item ID
844:
845: po_line_item_id := Wf_Engine.GetItemAttrNumber(itemtype => pp_itemtype
846: ,itemkey => pp_itemkey
847: ,aname => gv_LINE_ITEM_ID_ATTR);
848:
849: IF po_line_item_id IS NULL THEN

Line 856: po_wi_instance_id := Wf_Engine.GetItemAttrNumber(itemtype => pp_itemtype

852: END IF;
853:
854: -- SFM Order WI Instance ID
855:
856: po_wi_instance_id := Wf_Engine.GetItemAttrNumber(itemtype => pp_itemtype
857: ,itemkey => pp_itemkey
858: ,aname => gv_WI_INSTANCE_ID_ATTR);
859:
860: IF po_wi_instance_id IS NULL THEN

Line 1062: l_activity_label := Wf_Engine.GetActivityLabel(p_actid);

1058: END IF;
1059:
1060: -- Get the current Workflow Activity Label
1061:
1062: l_activity_label := Wf_Engine.GetActivityLabel(p_actid);
1063:
1064: -- Get the SYNC_LABEL from the SFM Order Line Item
1065:
1066: l_sync_label := Xdp_Engine.Get_Line_Param_Value (

Line 1120: wf_engine.SetItemAttrText(itemtype => p_itemtype

1116:
1117:
1118: END IF;
1119:
1120: wf_engine.SetItemAttrText(itemtype => p_itemtype
1121: ,itemkey => p_itemkey
1122: ,aname => 'SYNC_TMR_REF_ID'
1123: ,avalue => l_sync_label || TO_CHAR(p_actid)) ;
1124:

Line 1144: wf_engine.SetItemAttrText(itemtype => p_itemtype

1140: IF (l_parties_not_in_sync = 0) THEN
1141:
1142: -- set the item type attribute IS_LAST_SYNC to 'Y'
1143:
1144: wf_engine.SetItemAttrText(itemtype => p_itemtype
1145: ,itemkey => p_itemkey
1146: ,aname => 'IS_LAST_SYNC'
1147: ,avalue => 'Y') ;
1148:

Line 1166: wf_engine.SetItemAttrText(itemtype => p_itemtype

1162: );
1163:
1164: ELSE
1165:
1166: wf_engine.SetItemAttrText(itemtype => p_itemtype
1167: ,itemkey => p_itemkey
1168: ,aname => 'IS_LAST_SYNC'
1169: ,avalue => 'N') ;
1170:

Line 1204: wf_engine.SetItemAttrText(itemtype => p_itemtype

1200: )
1201: IS
1202: BEGIN
1203:
1204: wf_engine.SetItemAttrText(itemtype => p_itemtype
1205: ,itemkey => p_itemkey
1206: ,aname => 'SDP_RESULT_CODE'
1207: ,avalue => p_result_value) ;
1208:

Line 1236: WHERE notification_id = WF_ENGINE.context_nid

1232:
1233: SELECT text_value
1234: INTO l_sdp_result_code
1235: FROM WF_NOTIFICATION_ATTRIBUTES
1236: WHERE notification_id = WF_ENGINE.context_nid
1237: AND NAME = 'RESULT';
1238:
1239: EXCEPTION
1240: WHEN NO_DATA_FOUND THEN

Line 1246: result := WF_ENGINE.eng_completed;

1242: END;
1243:
1244: set_result_code (itemtype, itemkey, l_sdp_result_code);
1245:
1246: result := WF_ENGINE.eng_completed;
1247: ELSE
1248:
1249: result := WF_ENGINE.eng_completed;
1250: END IF;

Line 1249: result := WF_ENGINE.eng_completed;

1245:
1246: result := WF_ENGINE.eng_completed;
1247: ELSE
1248:
1249: result := WF_ENGINE.eng_completed;
1250: END IF;
1251:
1252: RETURN;
1253:

Line 1309: l_value := wf_engine.GetItemAttrText(

1305: BEGIN
1306:
1307: BEGIN
1308:
1309: l_value := wf_engine.GetItemAttrText(
1310: itemtype => p_itemtype
1311: ,itemkey => p_itemkey
1312: ,aname => 'IS_LAST_SYNC' );
1313:

Line 1323: wf_engine.additemattr(

1319: IF ( wf_core.error_name = 'WFENG_ITEM_ATTR')
1320: THEN
1321: wf_core.clear;
1322:
1323: wf_engine.additemattr(
1324: itemtype => p_itemtype
1325: ,itemkey => p_itemkey
1326: ,aname => 'IS_LAST_SYNC') ;
1327:

Line 1330: wf_engine.SetItemAttrText(

1326: ,aname => 'IS_LAST_SYNC') ;
1327:
1328: -- Set the value
1329:
1330: wf_engine.SetItemAttrText(
1331: itemtype => p_itemtype
1332: ,itemkey => p_itemkey
1333: ,aname => 'IS_LAST_SYNC'
1334: ,avalue => 'N');

Line 1346: l_value := wf_engine.GetItemAttrText(

1342: -- create SDP_RESULT_CODE if necessary
1343:
1344: BEGIN
1345:
1346: l_value := wf_engine.GetItemAttrText(
1347: itemtype => p_itemtype
1348: ,itemkey => p_itemkey
1349: ,aname => 'SDP_RESULT_CODE' );
1350:

Line 1351: wf_engine.SetItemAttrText(

1347: itemtype => p_itemtype
1348: ,itemkey => p_itemkey
1349: ,aname => 'SDP_RESULT_CODE' );
1350:
1351: wf_engine.SetItemAttrText(
1352: itemtype => p_itemtype
1353: ,itemkey => p_itemkey
1354: ,aname => 'SDP_RESULT_CODE'
1355: ,avalue => NULL);

Line 1366: wf_engine.additemattr(

1362: IF ( wf_core.error_name = 'WFENG_ITEM_ATTR')
1363: THEN
1364: wf_core.clear;
1365:
1366: wf_engine.additemattr(
1367: itemtype => p_itemtype
1368: ,itemkey => p_itemkey
1369: ,aname => 'SDP_RESULT_CODE') ;
1370:

Line 1373: wf_engine.SetItemAttrText(

1369: ,aname => 'SDP_RESULT_CODE') ;
1370:
1371: -- Set the value to NULL
1372:
1373: wf_engine.SetItemAttrText(
1374: itemtype => p_itemtype
1375: ,itemkey => p_itemkey
1376: ,aname => 'SDP_RESULT_CODE'
1377: ,avalue => NULL);

Line 1389: l_value := wf_engine.GetItemAttrText(

1385: -- create SYNC_TMR_REF_ID if necessary
1386:
1387: BEGIN
1388:
1389: l_value := wf_engine.GetItemAttrText(
1390: itemtype => p_itemtype
1391: ,itemkey => p_itemkey
1392: ,aname => 'SYNC_TMR_REF_ID' );
1393:

Line 1394: wf_engine.SetItemAttrText(

1390: itemtype => p_itemtype
1391: ,itemkey => p_itemkey
1392: ,aname => 'SYNC_TMR_REF_ID' );
1393:
1394: wf_engine.SetItemAttrText(
1395: itemtype => p_itemtype
1396: ,itemkey => p_itemkey
1397: ,aname => 'SYNC_TMR_REF_ID'
1398: ,avalue => NULL);

Line 1409: wf_engine.additemattr(

1405: IF ( wf_core.error_name = 'WFENG_ITEM_ATTR')
1406: THEN
1407: wf_core.clear;
1408:
1409: wf_engine.additemattr(
1410: itemtype => p_itemtype
1411: ,itemkey => p_itemkey
1412: ,aname => 'SYNC_TMR_REF_ID') ;
1413:

Line 1416: wf_engine.SetItemAttrText(

1412: ,aname => 'SYNC_TMR_REF_ID') ;
1413:
1414: -- Set the value to NULL
1415:
1416: wf_engine.SetItemAttrText(
1417: itemtype => p_itemtype
1418: ,itemkey => p_itemkey
1419: ,aname => 'SYNC_TMR_REF_ID'
1420: ,avalue => NULL);