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

Line 46: wf_engine.GetItemAttrNumber

42: IF (command = 'SET_CTX') THEN
43:
44: -- set the context information
45: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
46: wf_engine.GetItemAttrNumber
47: (itemtype => itemtype
48: ,itemkey => itemkey
49: ,aname => 'WORKITEM_INSTANCE_ID'
50: );

Line 53: wf_engine.GetItemAttrNumber

49: ,aname => 'WORKITEM_INSTANCE_ID'
50: );
51:
52: XNP_WF_STANDARD.g_ORDER_ID :=
53: wf_engine.GetItemAttrNumber
54: (itemtype => itemtype
55: ,itemkey => itemkey
56: ,aname => 'ORDER_ID'
57: );

Line 68: wf_engine.GetItemAttrNumber

64:
65: -- set the context information
66:
67: XNP_WF_STANDARD.g_ORDER_ID :=
68: wf_engine.GetItemAttrNumber
69: (itemtype => itemtype
70: ,itemkey => itemkey
71: ,aname => 'ORDER_ID'
72: );

Line 84: wf_engine.GetItemAttrNumber

80:
81: -- set the context information
82:
83: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
84: wf_engine.GetItemAttrNumber
85: (itemtype => itemtype
86: ,itemkey => itemkey
87: ,aname => 'WORKITEM_INSTANCE_ID'
88: );

Line 99: wf_engine.GetItemAttrNumber

95:
96: -- set the context information
97:
98: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
99: wf_engine.GetItemAttrNumber
100: (itemtype => itemtype
101: ,itemkey => itemkey
102: ,aname => 'FA_INSTANCE_ID'
103: );

Line 113: wf_engine.GetItemAttrNumber

109:
110: -- set the context information
111:
112: XNP_WF_STANDARD.g_ORDER_ID :=
113: wf_engine.GetItemAttrNumber
114: (itemtype => itemtype
115: ,itemkey => itemkey
116: ,aname => 'ORDER_ID'
117: );

Line 120: wf_engine.GetItemAttrNumber

116: ,aname => 'ORDER_ID'
117: );
118:
119: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
120: wf_engine.GetItemAttrNumber
121: (itemtype => itemtype
122: ,itemkey => itemkey
123: ,aname => 'WORKITEM_INSTANCE_ID'
124: );

Line 134: wf_engine.GetItemAttrNumber

130:
131: -- set the context information
132:
133: XNP_WF_STANDARD.g_ORDER_ID :=
134: wf_engine.GetItemAttrNumber
135: (itemtype => itemtype
136: ,itemkey => itemkey
137: ,aname => 'ORDER_ID'
138: );

Line 141: wf_engine.GetItemAttrNumber

137: ,aname => 'ORDER_ID'
138: );
139:
140: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
141: wf_engine.GetItemAttrNumber
142: (itemtype => itemtype
143: ,itemkey => itemkey
144: ,aname => 'FA_INSTANCE_ID'
145: );

Line 155: wf_engine.GetItemAttrNumber

151:
152: -- set the context information
153:
154: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
155: wf_engine.GetItemAttrNumber
156: (itemtype => itemtype
157: ,itemkey => itemkey
158: ,aname => 'WORKITEM_INSTANCE_ID'
159: );

Line 162: wf_engine.GetItemAttrNumber

158: ,aname => 'WORKITEM_INSTANCE_ID'
159: );
160:
161: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
162: wf_engine.GetItemAttrNumber
163: (itemtype => itemtype
164: ,itemkey => itemkey
165: ,aname => 'FA_INSTANCE_ID'
166: );

Line 176: wf_engine.GetItemAttrNumber

172:
173: -- set the context information
174:
175: XNP_WF_STANDARD.g_ORDER_ID :=
176: wf_engine.GetItemAttrNumber
177: (itemtype => itemtype
178: ,itemkey => itemkey
179: ,aname => 'ORDER_ID'
180: );

Line 183: wf_engine.GetItemAttrNumber

179: ,aname => 'ORDER_ID'
180: );
181:
182: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
183: wf_engine.GetItemAttrNumber
184: (itemtype => itemtype
185: ,itemkey => itemkey
186: ,aname => 'WORKITEM_INSTANCE_ID'
187: );

Line 190: wf_engine.GetItemAttrNumber

186: ,aname => 'WORKITEM_INSTANCE_ID'
187: );
188:
189: XNP_WF_STANDARD.g_FA_INSTANCE_ID :=
190: wf_engine.GetItemAttrNumber
191: (itemtype => itemtype
192: ,itemkey => itemkey
193: ,aname => 'FA_INSTANCE_ID'
194: );

Line 209: wf_engine.GetItemAttrNumber

205:
206: -- set the context information
207:
208: XNP_WF_STANDARD.g_WORKITEM_INSTANCE_ID :=
209: wf_engine.GetItemAttrNumber
210: (itemtype => itemtype
211: ,itemkey => itemkey
212: ,aname => 'WORKITEM_INSTANCE_ID'
213: );

Line 216: wf_engine.GetItemAttrNumber

212: ,aname => 'WORKITEM_INSTANCE_ID'
213: );
214:
215: XNP_WF_STANDARD.g_ORDER_ID :=
216: wf_engine.GetItemAttrNumber
217: (itemtype => itemtype
218: ,itemkey => itemkey
219: ,aname => 'ORDER_ID'
220: );

Line 515: wf_engine.GetActivityAttrText (itemtype => itemtype,

511: l_ORDER_ID := g_ORDER_ID;
512: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
513:
514: l_CUR_STATUS_TYPE_CODE :=
515: wf_engine.GetActivityAttrText (itemtype => itemtype,
516: itemkey => itemkey,
517: actid => actid,
518: aname => 'CUR_STATUS_TYPE_CODE');
519:

Line 632: wf_engine.GetActivityAttrText (itemtype => itemtype,

628:
629: -- Get the context this workflow is operating in
630: -- i.e. DONOR or RECIPIENT
631: l_SP_ROLE :=
632: wf_engine.GetActivityAttrText (itemtype => itemtype,
633: itemkey => itemkey,
634: actid => actid,
635: aname => 'SP_ROLE');
636: IF (l_sp_role IS NULL) THEN

Line 755: wf_engine.GetActivityAttrText (itemtype => itemtype,

751: l_ORDER_ID := g_ORDER_ID;
752: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
753:
754: l_NEW_STATUS_TYPE_CODE :=
755: wf_engine.GetActivityAttrText (itemtype => itemtype,
756: itemkey => itemkey,
757: actid => actid,
758: aname => 'NEW_STATUS_TYPE_CODE');
759:

Line 761: wf_engine.GetActivityAttrText (itemtype => itemtype,

757: actid => actid,
758: aname => 'NEW_STATUS_TYPE_CODE');
759:
760: l_STATUS_CHANGE_CAUSE_CODE :=
761: wf_engine.GetActivityAttrText (itemtype => itemtype,
762: itemkey => itemkey,
763: actid => actid,
764: aname => 'STATUS_CHANGE_CAUSE_CODE');
765:

Line 1030: wf_engine.GetActivityAttrText

1026: l_callback_ref_id := -1;
1027: end if;
1028:
1029: l_MESSAGE_TYPE :=
1030: wf_engine.GetActivityAttrText
1031: (itemtype => itemtype
1032: ,itemkey => itemkey
1033: ,actid => actid
1034: ,aname => 'EVENT_TYPE'

Line 1037: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);

1033: ,actid => actid
1034: ,aname => 'EVENT_TYPE'
1035: );
1036:
1037: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);
1038: l_PROCESS_REFERENCE :=
1039: itemtype||':'||itemkey||':'||l_activity_name;
1040:
1041: ------------------------------------------------------------------

Line 1191: wf_engine.GetActivityAttrText

1187: l_callback_ref_id := -1;
1188: end if;
1189:
1190: l_EVENT_TYPE :=
1191: wf_engine.GetActivityAttrText
1192: (itemtype => itemtype
1193: ,itemkey => itemkey
1194: ,actid => actid
1195: ,aname => 'EVENT_TYPE'

Line 1198: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);

1194: ,actid => actid
1195: ,aname => 'EVENT_TYPE'
1196: );
1197:
1198: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);
1199: l_PROCESS_REFERENCE :=
1200: itemtype||':'||itemkey||':'||l_activity_name;
1201:
1202:

Line 1296: wf_engine.GetActivityAttrText

1292:
1293: -- The run code
1294:
1295: l_DOC_PROC_NAME :=
1296: wf_engine.GetActivityAttrText
1297: (itemtype => itemtype
1298: ,itemkey => itemkey
1299: ,actid => actid
1300: ,aname => 'DOC_PROC_NAME'

Line 1304: wf_engine.SetItemAttrText

1300: ,aname => 'DOC_PROC_NAME'
1301: );
1302:
1303: -- Modified avalue from FND_RESP534:21690 to FND_RESP535:21704, rnyberg 03/08/2002
1304: wf_engine.SetItemAttrText
1305: (itemtype => itemtype
1306: ,itemkey => itemkey
1307: ,aname => 'CUST_CARE_ADMIN'
1308: ,avalue => 'FND_RESP535:21704'

Line 1313: wf_engine.SetItemAttrText

1309: -- ,avalue => xdp_utilities.get_wf_notifrecipient('NP_CUST_CARE_ADMIN')
1310: );
1311:
1312: -- Modified avalue from FND_RESP534:21690 to FND_RESP535:21704, rnyberg 03/08/2002
1313: wf_engine.SetItemAttrText
1314: (itemtype => itemtype
1315: ,itemkey => itemkey
1316: ,aname => 'SYS_ADMIN'
1317: ,avalue => 'FND_RESP535:21704'

Line 1332: wf_engine.GetItemAttrNumber

1328: OR (l_DOC_PROC_NAME = 'NO_ACK_RECEIVED')
1329: THEN
1330:
1331: l_MESSAGE_ID :=
1332: wf_engine.GetItemAttrNumber
1333: (itemtype => itemtype
1334: ,itemkey => itemkey
1335: ,aname => 'MSG_ID'
1336: );

Line 1338: wf_engine.SetItemAttrText

1334: ,itemkey => itemkey
1335: ,aname => 'MSG_ID'
1336: );
1337:
1338: wf_engine.SetItemAttrText
1339: (itemtype => itemtype
1340: ,itemkey => itemkey
1341: ,aname => 'DOC_REFERENCE'
1342: ,avalue => 'PLSQL:XNP_DOCUMENTS.'||l_DOC_PROC_NAME

Line 1358: wf_engine.SetItemAttrText

1354: );
1355:
1356: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
1357:
1358: wf_engine.SetItemAttrText
1359: (itemtype => itemtype
1360: ,itemkey => itemkey
1361: ,aname => 'DOC_REFERENCE'
1362: ,avalue => 'PLSQL:XNP_DOCUMENTS.'||l_DOC_PROC_NAME

Line 1475: wf_engine.GetActivityAttrText

1471: l_ORDER_ID := g_ORDER_ID ;
1472:
1473:
1474: l_FA_NAME :=
1475: wf_engine.GetActivityAttrText
1476: (itemtype => itemtype
1477: ,itemkey => itemkey
1478: ,actid => actid
1479: ,aname => 'FA_NAME'

Line 1484: wf_engine.GetActivityAttrText

1480: );
1481:
1482: -- Get the FE NAME to provision
1483: l_FE_NAME :=
1484: wf_engine.GetActivityAttrText
1485: (itemtype => itemtype
1486: ,itemkey => itemkey
1487: ,actid => actid
1488: ,aname => 'FE_NAME'

Line 1518: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);

1514: -- SUBSCRIBE for FA_DONE
1515: -- with the FA_INSTANCE_ID
1516: -- and let SFM resume workflow
1517:
1518: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);
1519: l_PROCESS_REFERENCE :=
1520: itemtype||':'||itemkey||':'||l_ACTIVITY_NAME;
1521:
1522: XNP_EVENT.SUBSCRIBE

Line 1621: l_WORKITEM_INSTANCE_ID := wf_engine.getItemAttrNumber (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,

1617: BEGIN
1618:
1619: IF (funcmode = 'RUN') THEN
1620:
1621: l_WORKITEM_INSTANCE_ID := wf_engine.getItemAttrNumber (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,
1622: itemkey => EXECUTE_FA_N_SYNC_WI_PAR.itemkey,
1623: aname => 'WORKITEM_INSTANCE_ID');
1624:
1625: FOR lv_rec in c_get_params( l_WORKITEM_INSTANCE_ID ) LOOP

Line 1631: wf_engine.setItemAttrText(itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,

1627: l_param_val := lv_rec.parameter_value;
1628:
1629: BEGIN
1630: -- Get the data type of the item attribute..
1631: wf_engine.setItemAttrText(itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,
1632: itemkey => EXECUTE_FA_N_SYNC_WI_PAR.itemkey,
1633: aname => l_param_name,
1634: avalue => l_param_val);
1635:

Line 1644: l_ORDER_ID := wf_engine.getItemAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,

1640: -- Kick off Default error process? or send a dynamic notification?
1641: RAISE;
1642: END;
1643: END LOOP;
1644: l_ORDER_ID := wf_engine.getItemAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,
1645: itemkey => EXECUTE_FA_N_SYNC_WI_PAR.itemkey ,
1646: aname => 'ORDER_ID');
1647:
1648: l_FA_NAME := wf_engine.getActivityAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,

Line 1648: l_FA_NAME := wf_engine.getActivityAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,

1644: l_ORDER_ID := wf_engine.getItemAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,
1645: itemkey => EXECUTE_FA_N_SYNC_WI_PAR.itemkey ,
1646: aname => 'ORDER_ID');
1647:
1648: l_FA_NAME := wf_engine.getActivityAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,
1649: itemkey => EXECUTE_FA_N_SYNC_WI_PAR.itemkey ,
1650: actid => actid,
1651: aname => 'FA_NAME');
1652:

Line 1653: l_FE_NAME := wf_engine.getActivityAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,

1649: itemkey => EXECUTE_FA_N_SYNC_WI_PAR.itemkey ,
1650: actid => actid,
1651: aname => 'FA_NAME');
1652:
1653: l_FE_NAME := wf_engine.getActivityAttrText (itemtype => EXECUTE_FA_N_SYNC_WI_PAR.itemtype,
1654: itemkey => EXECUTE_FA_N_SYNC_WI_PAR.itemkey,
1655: actid => actid,
1656: aname => 'FE_NAME');
1657:

Line 1689: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);

1685: -- SUBSCRIBE for FA_DONE
1686: -- with the FA_INSTANCE_ID
1687: -- and let SFM resume workflow
1688:
1689: l_ACTIVITY_NAME := wf_engine.GETACTIVITYLABEL(actid);
1690: l_PROCESS_REFERENCE :=
1691: itemtype||':'||itemkey||':'||l_ACTIVITY_NAME;
1692:
1693: XNP_EVENT.SUBSCRIBE

Line 2032: wf_engine.GetActivityAttrText (itemtype => itemtype,

2028: l_ORDER_ID := g_ORDER_ID;
2029: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
2030:
2031: l_FEATURE_TYPE :=
2032: wf_engine.GetActivityAttrText (itemtype => itemtype,
2033: itemkey => itemkey,
2034: actid => actid,
2035: aname => 'FEATURE_TYPE');
2036:

Line 2381: wf_engine.GetActivityAttrText

2377:
2378: -- Get the event type to publish
2379:
2380: l_EVENT_TYPE :=
2381: wf_engine.GetActivityAttrText
2382: (itemtype => itemtype
2383: ,itemkey => itemkey
2384: ,actid => actid
2385: ,aname => 'EVENT_TYPE'

Line 2391: wf_engine.GetActivityAttrText

2387:
2388: -- Get the names of the parameters for PUBLISH
2389:
2390: l_tmp_param_list :=
2391: wf_engine.GetActivityAttrText
2392: (itemtype => itemtype
2393: ,itemkey => itemkey
2394: ,actid => actid
2395: ,aname => 'PARAM_LIST'

Line 2531: wf_engine.GetActivityAttrText (itemtype => itemtype,

2527:
2528: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
2529:
2530: l_STATUS_TYPE_CODE :=
2531: wf_engine.GetActivityAttrText (itemtype => itemtype,
2532: itemkey => itemkey,
2533: actid => actid,
2534: aname => 'STATUS_TYPE_CODE');
2535:

Line 2898: wf_engine.GetActivityAttrText

2894:
2895:
2896: -- Get the event type to publish
2897: l_EVENT_TYPE :=
2898: wf_engine.GetActivityAttrText
2899: (itemtype => itemtype
2900: ,itemkey => itemkey
2901: ,actid => actid
2902: ,aname => 'EVENT_TYPE'

Line 2907: wf_engine.GetActivityAttrText

2903: );
2904:
2905: -- Get the names of the parameters for SEND_MESSAGE
2906: l_tmp_param_list :=
2907: wf_engine.GetActivityAttrText
2908: (itemtype => itemtype
2909: ,itemkey => itemkey
2910: ,actid => actid
2911: ,aname => 'PARAM_LIST'

Line 2917: wf_engine.GetActivityAttrText

2913:
2914: l_PARAM_LIST := replace(l_tmp_param_list,' ','');
2915:
2916: l_CONSUMER :=
2917: wf_engine.GetActivityAttrText
2918: (itemtype => itemtype
2919: ,itemkey => itemkey
2920: ,actid => actid
2921: ,aname => 'CONSUMER'

Line 2925: wf_engine.GetActivityAttrText

2921: ,aname => 'CONSUMER'
2922: );
2923:
2924: l_RECEIVER :=
2925: wf_engine.GetActivityAttrText
2926: (itemtype => itemtype
2927: ,itemkey => itemkey
2928: ,actid => actid
2929: ,aname => 'RECEIVER'

Line 2932: l_ACTIVITY_LABEL := wf_engine.GETACTIVITYLABEL(actid);

2928: ,actid => actid
2929: ,aname => 'RECEIVER'
2930: );
2931:
2932: l_ACTIVITY_LABEL := wf_engine.GETACTIVITYLABEL(actid);
2933:
2934:
2935: -- Create a name for the version label
2936: l_version_label := l_ACTIVITY_LABEL;

Line 2954: wf_engine.GetItemAttrNumber

2950: -- Check if the version number is present else add
2951: BEGIN
2952:
2953: l_VERSION :=
2954: wf_engine.GetItemAttrNumber
2955: (itemtype => itemtype
2956: ,itemkey => itemkey
2957: ,aname => l_version_label||'_VER'
2958: );

Line 2969: WF_ENGINE.AddItemAttr

2965:
2966: -- Clear the error buffers
2967: wf_core.clear;
2968:
2969: WF_ENGINE.AddItemAttr
2970: (itemtype => itemtype
2971: ,itemkey => itemkey
2972: ,aname => l_version_label||'_VER'
2973: );

Line 2978: wf_engine.SetItemAttrNumber

2974:
2975: l_VERSION := 1; -- Initializing
2976:
2977: -- Set the value
2978: wf_engine.SetItemAttrNumber
2979: (itemtype => itemtype
2980: ,itemkey => itemkey
2981: ,aname => l_version_label||'_VER'
2982: ,avalue => l_VERSION

Line 3028: wf_engine.SetItemAttrNumber

3024: raise e_SEND_MESSAGE;
3025: ELSE
3026: -- Increment the version number and set it
3027: l_VERSION := l_VERSION + 1;
3028: wf_engine.SetItemAttrNumber
3029: (itemtype => itemtype
3030: ,itemkey => itemkey
3031: ,aname => l_version_label||'_VER'
3032: ,avalue => l_VERSION

Line 3158: wf_engine.GetActivityAttrText

3154: l_ORDER_ID := g_ORDER_ID;
3155: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
3156:
3157: l_FEATURE_TYPE :=
3158: wf_engine.GetActivityAttrText
3159: (itemtype => itemtype
3160: ,itemkey => itemkey
3161: ,actid => actid
3162: ,aname => 'FEATURE_TYPE'

Line 3346: wf_engine.GetItemAttrNumber (itemtype => itemtype,

3342:
3343: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
3344:
3345: l_FE_ID :=
3346: wf_engine.GetItemAttrNumber (itemtype => itemtype,
3347: itemkey => itemkey,
3348: aname => 'FE_ID');
3349:
3350: l_FEATURE_TYPE :=

Line 3351: wf_engine.GetActivityAttrText (itemtype => itemtype,

3347: itemkey => itemkey,
3348: aname => 'FE_ID');
3349:
3350: l_FEATURE_TYPE :=
3351: wf_engine.GetActivityAttrText (itemtype => itemtype,
3352: itemkey => itemkey,
3353: actid => actid,
3354: aname => 'FEATURE_TYPE');
3355:

Line 3466: wf_engine.GetActivityAttrText (itemtype => itemtype,

3462:
3463: -- Get the context this workflow is operating in
3464: -- i.e. DONOR or RECIPIENT
3465: l_SP_ROLE :=
3466: wf_engine.GetActivityAttrText (itemtype => itemtype,
3467: itemkey => itemkey,
3468: actid => actid,
3469: aname => 'SP_ROLE');
3470:

Line 3477: wf_engine.GetActivityAttrText

3473: end if;
3474:
3475: -- Get the Phase that the SV should be in
3476: l_PHASE_INDICATOR :=
3477: wf_engine.GetActivityAttrText
3478: (itemtype => itemtype
3479: ,itemkey => itemkey
3480: ,actid => actid
3481: ,aname => 'PHASE'

Line 3608: wf_engine.GetItemAttrNumber

3604: l_ORDER_ID := g_ORDER_ID;
3605: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
3606:
3607: l_FE_ID :=
3608: wf_engine.GetItemAttrNumber
3609: (itemtype => itemtype,
3610: itemkey => itemkey,
3611: aname => 'FE_ID'
3612: );

Line 3615: wf_engine.GetItemAttrText

3611: aname => 'FE_ID'
3612: );
3613:
3614: l_FEATURE_TYPE :=
3615: wf_engine.GetItemAttrText
3616: (itemtype => itemtype,
3617: itemkey => itemkey,
3618: aname => 'FEATURE_TYPE'
3619: );

Line 3622: wf_engine.GetActivityAttrText (itemtype => itemtype,

3618: aname => 'FEATURE_TYPE'
3619: );
3620:
3621: l_PROV_STATUS :=
3622: wf_engine.GetActivityAttrText (itemtype => itemtype,
3623: itemkey => itemkey,
3624: actid => actid,
3625: aname => 'PROV_STATUS');
3626:

Line 3714: wf_engine.GetItemAttrNumber

3710:
3711: -- The run code
3712:
3713: l_MSG_ID :=
3714: wf_engine.GetItemAttrNumber
3715: (itemtype => itemtype,
3716: itemkey => itemkey,
3717: aname => 'MSG_ID'
3718: );

Line 3721: wf_engine.GetItemAttrText

3717: aname => 'MSG_ID'
3718: );
3719:
3720: l_COMMENT :=
3721: wf_engine.GetItemAttrText
3722: (itemtype => itemtype,
3723: itemkey => itemkey,
3724: aname => 'COMMENT'
3725: );

Line 3804: wf_engine.GetItemAttrNumber

3800:
3801: -- The run code
3802:
3803: l_MSG_ID :=
3804: wf_engine.GetItemAttrNumber
3805: (itemtype => itemtype,
3806: itemkey => itemkey,
3807: aname => 'MSG_ID'
3808: );

Line 3875: l_ActLabel := wf_engine.GetActivityLabel(actid);

3871: e_InvalidLabelException EXCEPTION;
3872: BEGIN
3873:
3874: IF funcmode = 'RUN' THEN
3875: l_ActLabel := wf_engine.GetActivityLabel(actid);
3876: l_ColonLoc := INSTR(l_ActLabel,':');
3877: if l_ColonLoc > 0 then
3878: l_ActLabel := SUBSTR(l_ActLabel,l_ColonLoc + 1, LENGTH(l_ActLabel));
3879:

Line 4043: wf_engine.GetActivityAttrText (itemtype => itemtype,

4039: ,'SP_NAME'
4040: );
4041:
4042: l_flag_value :=
4043: wf_engine.GetActivityAttrText (itemtype => itemtype,
4044: itemkey => itemkey,
4045: actid => actid,
4046: aname => 'FLAG_VALUE');
4047:

Line 4291: wf_engine.GetActivityAttrText

4287: ,'PORTING_ID'
4288: );
4289:
4290: l_STATUS_TO_COMPARE_WITH :=
4291: wf_engine.GetActivityAttrText
4292: (itemtype => itemtype
4293: ,itemkey => itemkey
4294: ,actid => actid
4295: ,aname => 'STATUS_TO_COMPARE_WITH'

Line 4557: wf_engine.GetActivityAttrText

4553: l_ORDER_ID := g_ORDER_ID;
4554: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
4555:
4556: l_FEATURE_TYPE :=
4557: wf_engine.GetActivityAttrText
4558: (itemtype => itemtype
4559: ,itemkey => itemkey
4560: ,actid => actid
4561: ,aname => 'FEATURE_TYPE'

Line 5107: wf_engine.GetActivityAttrText

5103:
5104: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5105:
5106: l_STATUS_TO_COMPARE_WITH :=
5107: wf_engine.GetActivityAttrText
5108: (itemtype => itemtype
5109: ,itemkey => itemkey
5110: ,actid => actid
5111: ,aname => 'STATUS_TO_COMPARE_WITH'

Line 5218: wf_engine.GetActivityAttrText

5214:
5215: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
5216:
5217: l_STATUS_TO_COMPARE_WITH :=
5218: wf_engine.GetActivityAttrText
5219: (itemtype => itemtype
5220: ,itemkey => itemkey
5221: ,actid => actid
5222: ,aname => 'STATUS_TO_COMPARE_WITH'

Line 5343: wf_engine.GetActivityAttrText (itemtype => itemtype,

5339: l_ORDER_ID := g_ORDER_ID;
5340: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
5341:
5342: l_NEW_STATUS_TYPE_CODE :=
5343: wf_engine.GetActivityAttrText (itemtype => itemtype,
5344: itemkey => itemkey,
5345: actid => actid,
5346: aname => 'NEW_STATUS_TYPE_CODE');
5347:

Line 5349: wf_engine.GetActivityAttrText (itemtype => itemtype,

5345: actid => actid,
5346: aname => 'NEW_STATUS_TYPE_CODE');
5347:
5348: l_STATUS_CHANGE_CAUSE_CODE :=
5349: wf_engine.GetActivityAttrText (itemtype => itemtype,
5350: itemkey => itemkey,
5351: actid => actid,
5352: aname => 'STATUS_CHANGE_CAUSE_CODE');
5353:

Line 5484: wf_engine.GetActivityAttrText (itemtype => itemtype,

5480: ,'SP_NAME'
5481: );
5482:
5483: l_flag_value :=
5484: wf_engine.GetActivityAttrText (itemtype => itemtype,
5485: itemkey => itemkey,
5486: actid => actid,
5487: aname => 'FLAG_VALUE');
5488:

Line 5490: wf_engine.GetActivityAttrText

5486: actid => actid,
5487: aname => 'FLAG_VALUE');
5488:
5489: l_flag_name :=
5490: wf_engine.GetActivityAttrText
5491: (itemtype => itemtype,
5492: itemkey => itemkey,
5493: actid => actid,
5494: aname => 'FLAG_NAME'

Line 5679: wf_engine.GetActivityAttrText

5675: ,'SP_NAME'
5676: );
5677:
5678: l_flag_name :=
5679: wf_engine.GetActivityAttrText
5680: (itemtype => itemtype,
5681: itemkey => itemkey,
5682: actid => actid,
5683: aname => 'FLAG_NAME'

Line 5856: wf_engine.GetActivityAttrText

5852: ,'SP_NAME'
5853: );
5854:
5855: l_date_name :=
5856: wf_engine.GetActivityAttrText
5857: (itemtype => itemtype,
5858: itemkey => itemkey,
5859: actid => actid,
5860: aname => 'DATE_NAME'

Line 6667: wf_engine.GetActivityAttrText

6663: -- parse to see the tokens in it. Substitute the tokens
6664: -- with the value
6665: ------------------------------------------------------------------
6666: l_notfn_msg_name :=
6667: wf_engine.GetActivityAttrText
6668: (itemtype => itemtype,
6669: itemkey => itemkey,
6670: actid => actid,
6671: aname => 'NOTIFN_MSG_NAME'

Line 6691: wf_engine.SetItemAttrText

6687: ------------------------------------------------------------------
6688: -- Set the item attributes MSG_SUBJECT, MSG_BODY
6689: ------------------------------------------------------------------
6690:
6691: wf_engine.SetItemAttrText
6692: (itemtype => itemtype
6693: ,itemkey => itemkey
6694: ,aname => 'MSG_SUBJECT'
6695: ,avalue => l_subject

Line 6698: wf_engine.SetItemAttrText

6694: ,aname => 'MSG_SUBJECT'
6695: ,avalue => l_subject
6696: );
6697:
6698: wf_engine.SetItemAttrText
6699: (itemtype => itemtype
6700: ,itemkey => itemkey
6701: ,aname => 'MSG_BODY'
6702: ,avalue => l_body

Line 6790: wf_engine.GetActivityAttrText (itemtype => itemtype,

6786: l_ORDER_ID := g_ORDER_ID;
6787: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID ;
6788:
6789: l_CUR_STATUS_TYPE_CODE :=
6790: wf_engine.GetActivityAttrText (itemtype => itemtype,
6791: itemkey => itemkey,
6792: actid => actid,
6793: aname => 'CUR_STATUS_TYPE_CODE');
6794:

Line 6796: wf_engine.GetActivityAttrText (itemtype => itemtype,

6792: actid => actid,
6793: aname => 'CUR_STATUS_TYPE_CODE');
6794:
6795: l_NEW_STATUS_TYPE_CODE :=
6796: wf_engine.GetActivityAttrText (itemtype => itemtype,
6797: itemkey => itemkey,
6798: actid => actid,
6799: aname => 'NEW_STATUS_TYPE_CODE');
6800:

Line 6802: wf_engine.GetActivityAttrText (itemtype => itemtype,

6798: actid => actid,
6799: aname => 'NEW_STATUS_TYPE_CODE');
6800:
6801: l_STATUS_CHANGE_CAUSE_CODE :=
6802: wf_engine.GetActivityAttrText (itemtype => itemtype,
6803: itemkey => itemkey,
6804: actid => actid,
6805: aname => 'STATUS_CHANGE_CAUSE_CODE');
6806:

Line 7028: wf_engine.GetItemAttrNumber (itemtype => itemtype,

7024: l_WORKITEM_INSTANCE_ID := g_WORKITEM_INSTANCE_ID;
7025: l_ORDER_ID := g_ORDER_ID;
7026:
7027: l_LINE_ITEM_ID:=
7028: wf_engine.GetItemAttrNumber (itemtype => itemtype,
7029: itemkey => itemkey,
7030: aname => 'LINE_ITEM_ID');
7031:
7032: XNP_STANDARD.RUNTIME_VALIDATION

Line 7129: l_line_item_id := wf_engine.GetItemAttrNumber(itemtype => SYNC_LI_PARAMETER_VALUES.itemtype,

7125: --
7126: -- RUN mode - normal process execution
7127: --
7128: IF (funcmode = 'RUN') THEN
7129: l_line_item_id := wf_engine.GetItemAttrNumber(itemtype => SYNC_LI_PARAMETER_VALUES.itemtype,
7130: itemkey => SYNC_LI_PARAMETER_VALUES.itemkey,
7131: aname => 'LINE_ITEM_ID');
7132: IF (l_line_item_id IS NOT NULL) THEN
7133: XDP_ENGINE.XDP_SYNC_LINE_ITEM_PV(l_line_item_id,l_rtn_code, l_rtn_status);

Line 7221: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => GET_ORD_FULFILLMENT_STATUS.itemtype,

7217: --
7218: -- RUN mode - normal process execution
7219: --
7220: IF (funcmode = 'RUN') THEN
7221: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => GET_ORD_FULFILLMENT_STATUS.itemtype,
7222: itemkey => GET_ORD_FULFILLMENT_STATUS.itemkey,
7223: aname => 'ORDER_ID');
7224:
7225: XDP_INTERFACES.GET_ORD_FULFILLMENT_STATUS(l_OrderID,l_status,l_result,l_code,l_return_status);

Line 7320: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SET_ORD_FULFILLMENT_STATUS.itemtype,

7316: --
7317: -- RUN mode - normal process execution
7318: --
7319: IF (funcmode = 'RUN') THEN
7320: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => SET_ORD_FULFILLMENT_STATUS.itemtype,
7321: itemkey => SET_ORD_FULFILLMENT_STATUS.itemkey,
7322: aname => 'ORDER_ID');
7323: BEGIN
7324: l_status :=

Line 7325: wf_engine.GetActivityAttrText (itemtype => itemtype,

7321: itemkey => SET_ORD_FULFILLMENT_STATUS.itemkey,
7322: aname => 'ORDER_ID');
7323: BEGIN
7324: l_status :=
7325: wf_engine.GetActivityAttrText (itemtype => itemtype,
7326: itemkey => itemkey,
7327: actid => actid,
7328: aname => 'FULFILLMENT_STATUS');
7329: l_result :=

Line 7330: wf_engine.GetActivityAttrText (itemtype => itemtype,

7326: itemkey => itemkey,
7327: actid => actid,
7328: aname => 'FULFILLMENT_STATUS');
7329: l_result :=
7330: wf_engine.GetActivityAttrText (itemtype => itemtype,
7331: itemkey => itemkey,
7332: actid => actid,
7333: aname => 'FULFILLMENT_RESULT');
7334: EXCEPTION

Line 7420: l_wi_instance_id := wf_engine.GetItemAttrNumber(itemtype => SET_WI_FULFILLMENT_STATUS.itemtype,

7416: --
7417: -- RUN mode - normal process execution
7418: --
7419: IF (funcmode = 'RUN') THEN
7420: l_wi_instance_id := wf_engine.GetItemAttrNumber(itemtype => SET_WI_FULFILLMENT_STATUS.itemtype,
7421: itemkey => SET_WI_FULFILLMENT_STATUS.itemkey,
7422: aname => 'WORKITEM_INSTANCE_ID');
7423:
7424: BEGIN

Line 7426: wf_engine.GetActivityAttrText (itemtype => itemtype,

7422: aname => 'WORKITEM_INSTANCE_ID');
7423:
7424: BEGIN
7425: l_status :=
7426: wf_engine.GetActivityAttrText (itemtype => itemtype,
7427: itemkey => itemkey,
7428: actid => actid,
7429: aname => 'FULFILLMENT_STATUS');
7430: l_result :=

Line 7431: wf_engine.GetActivityAttrText (itemtype => itemtype,

7427: itemkey => itemkey,
7428: actid => actid,
7429: aname => 'FULFILLMENT_STATUS');
7430: l_result :=
7431: wf_engine.GetActivityAttrText (itemtype => itemtype,
7432: itemkey => itemkey,
7433: actid => actid,
7434: aname => 'FULFILLMENT_RESULT');
7435: EXCEPTION

Line 7528: wf_engine.GetItemAttrNumber

7524:
7525: IF (funcmode = 'RUN') THEN
7526:
7527: l_order_id :=
7528: wf_engine.GetItemAttrNumber
7529: (itemtype => itemtype
7530: ,itemkey => itemkey
7531: ,aname => 'ORDER_ID'
7532: );

Line 7622: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => downloadWIParams.itemtype,

7618: l_WIInstanceID number;
7619:
7620: BEGIN
7621:
7622: l_WIInstanceID := wf_engine.GetItemAttrNumber(itemtype => downloadWIParams.itemtype,
7623: itemkey => downloadWIParams.itemkey,
7624: aname => 'WORKITEM_INSTANCE_ID');
7625:
7626: FOR lv_rec in c_get_params( l_WIInstanceID ) LOOP

Line 7630: l_param_val := wf_engine.GetItemAttrText(itemtype => downloadWIParams.itemtype,

7626: FOR lv_rec in c_get_params( l_WIInstanceID ) LOOP
7627: l_param_name := lv_rec.parameter_name;
7628:
7629: BEGIN
7630: l_param_val := wf_engine.GetItemAttrText(itemtype => downloadWIParams.itemtype,
7631: itemkey => downloadWIParams.itemkey,
7632: aname => l_param_name);
7633: UPDATE xdp_worklist_details
7634: SET parameter_value = l_param_val,

Line 7681: l_item_attrib_name := wf_engine.GetActivityAttrText(itemtype => downloadFAParams.itemtype,

7677: --If we allow users to use type CONSTANT for Activity Attribute then we should
7678: --resolve the type(whether CONSTANT or Item Attribute) first before getting the value..
7679:
7680: --get Item attribute name..
7681: l_item_attrib_name := wf_engine.GetActivityAttrText(itemtype => downloadFAParams.itemtype,
7682: itemkey => downloadFAParams.itemkey,
7683: actid => downloadFAParams.actid,
7684: aname => l_param_name);
7685: --get Item attribute value..

Line 7686: l_param_value := wf_engine.GetItemAttrText(itemtype => downloadFAParams.itemtype,

7682: itemkey => downloadFAParams.itemkey,
7683: actid => downloadFAParams.actid,
7684: aname => l_param_name);
7685: --get Item attribute value..
7686: l_param_value := wf_engine.GetItemAttrText(itemtype => downloadFAParams.itemtype,
7687: itemkey => downloadFAParams.itemkey,
7688: aname => l_item_attrib_name);
7689: UPDATE xdp_fa_details
7690: SET parameter_value = l_param_value,

Line 7736: l_item_attrib_name := wf_engine.GetActivityAttrText(itemtype => uploadFAParams.itemtype,

7732: --If we allow users to use type CONSTANT for Activity Attribute then we should
7733: --resolve the type(whether CONSTANT or Item Attribute) first before getting the value..
7734:
7735: --get Item attribute name..
7736: l_item_attrib_name := wf_engine.GetActivityAttrText(itemtype => uploadFAParams.itemtype,
7737: itemkey => uploadFAParams.itemkey,
7738: actid => uploadFAParams.actid,
7739: aname => l_param_name);
7740: l_param_value := lv_rec.parameter_value;

Line 7743: wf_engine.setItemAttrText(itemtype => uploadFAParams.itemtype,

7739: aname => l_param_name);
7740: l_param_value := lv_rec.parameter_value;
7741:
7742: --set Item attribute value..
7743: wf_engine.setItemAttrText(itemtype => uploadFAParams.itemtype,
7744: itemkey => uploadFAParams.itemkey,
7745: aname => l_item_attrib_name,
7746: avalue => l_param_value );
7747: EXCEPTION