DBA Data[Home] [Help]

APPS.XDPCORE dependencies on WF_ENGINE

Line 63: wf_engine.CreateProcess( ItemType => ItemType,

59: IF ( ItemType is NOT NULL ) AND
60: ( ItemKey is NOT NULL ) AND
61: (OrderID is NOT NULL) then
62:
63: wf_engine.CreateProcess( ItemType => ItemType,
64: ItemKey => ItemKey,
65: process => WorkflowProcess);
66: -- *****
67: -- Initialize workflow item attributes below

Line 70: wf_engine.SetItemAttrNumber(ItemType => ItemType,

66: -- *****
67: -- Initialize workflow item attributes below
68: -- *****
69:
70: wf_engine.SetItemAttrNumber(ItemType => ItemType,
71: ItemKey => ItemKey,
72: aname => 'ORDER_ID',
73: avalue => OrderID);
74:

Line 75: wf_engine.StartProcess(itemtype => ItemType,

71: ItemKey => ItemKey,
72: aname => 'ORDER_ID',
73: avalue => OrderID);
74:
75: wf_engine.StartProcess(itemtype => ItemType,
76: itemkey => ItemKey);
77: ELSE
78: /* Set the Error Message */
79: x_ErrMsg := 'Got Null value';

Line 125: wf_engine.CreateProcess( ItemType => ItemType,

121: itemkey := to_char(OrderID) || '-INIT-' || itemkey;
122:
123: process := 'INIT_PROCESS_ORDER';
124:
125: wf_engine.CreateProcess( ItemType => ItemType,
126: ItemKey => ItemKey,
127: process => process);
128: -- *****
129: -- Initialize workflow item attributes below

Line 132: wf_engine.SetItemAttrNumber(ItemType => ItemType,

128: -- *****
129: -- Initialize workflow item attributes below
130: -- *****
131:
132: wf_engine.SetItemAttrNumber(ItemType => ItemType,
133: ItemKey => ItemKey,
134: aname => 'ORDER_ID',
135: avalue => OrderID);
136:

Line 137: wf_engine.StartProcess(itemtype => ItemType,

133: ItemKey => ItemKey,
134: aname => 'ORDER_ID',
135: avalue => OrderID);
136:
137: wf_engine.StartProcess(itemtype => ItemType,
138: itemkey => ItemKey);
139: else
140: /* Set the Error Message */
141: x_Progress := 'Got Null value';

Line 185: wf_engine.CreateProcess( ItemType => ItemType,

181:
182: process := 'ORDER_RESUBMISSION_PROCESS';
183:
184:
185: wf_engine.CreateProcess( ItemType => ItemType,
186: ItemKey => ItemKey,
187: process => process);
188: -- *****
189: -- Initialize workflow item attributes below

Line 204: wf_engine.StartProcess(itemtype => ItemType,

200: x_progress := 'In XDPCORE.StartORUProcess. Error when adding RESUBMISSION_JOB_ID attribute. ';
201: raise e_AddAttributeException;
202: end if;
203:
204: wf_engine.StartProcess(itemtype => ItemType,
205: itemkey => ItemKey);
206: else
207: /* Set the Error Message */
208: x_Progress := 'Got Null value';

Line 244: wf_engine.CreateProcess( ItemType => ItemType,

240: itemkey := to_char(OrderID) || '-OA-' || itemkey;
241:
242: process := 'PROV_PROCESS';
243:
244: wf_engine.CreateProcess( ItemType => ItemType,
245: ItemKey => ItemKey,
246: process => process);
247: -- *****
248: -- Initialize workflow item attributes below

Line 251: wf_engine.SetItemAttrNumber(ItemType => ItemType,

247: -- *****
248: -- Initialize workflow item attributes below
249: -- *****
250:
251: wf_engine.SetItemAttrNumber(ItemType => ItemType,
252: ItemKey => ItemKey,
253: aname => 'ORDER_ID',
254: avalue => OrderID);
255:

Line 256: wf_engine.StartProcess(itemtype => ItemType,

252: ItemKey => ItemKey,
253: aname => 'ORDER_ID',
254: avalue => OrderID);
255:
256: wf_engine.StartProcess(itemtype => ItemType,
257: itemkey => ItemKey);
258: else
259: /* Set the Error Message */
260: x_Progress := 'Got Null value';

Line 295: wf_engine.CreateProcess( ItemType => ItemType,

291:
292: ItemType := 'XDPPROV';
293: itemkey := to_char(OrderID) || '-MAIN-' || itemkey;
294:
295: wf_engine.CreateProcess( ItemType => ItemType,
296: ItemKey => ItemKey,
297: process => 'MAIN_ORDER_PROCESS');
298:
299: -- *****

Line 303: wf_engine.SetItemAttrNumber(ItemType => ItemType,

299: -- *****
300: -- Initialize workflow item attributes below
301: -- *****
302:
303: wf_engine.SetItemAttrNumber(ItemType => ItemType,
304: ItemKey => ItemKey,
305: aname => 'ORDER_ID',
306: avalue => OrderID);
307:

Line 660: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => itemtype,

656: e_EnqueueException EXCEPTION;
657:
658: BEGIN
659:
660: l_OrderID := wf_engine.GetItemAttrNumber(itemtype => itemtype,
661: itemkey => itemkey,
662: aname => 'ORDER_ID');
663:
664: UPDATE xdp_order_headers

Line 730: l_wi_instance_id := wf_engine.GetItemAttrNumber(itemtype => ResumeSDP.itemtype,

726: -- Once the Work Item completes all the waiting Events and Timers must be
727: -- Expired
728: -- Raja 5/30/2001
729:
730: l_wi_instance_id := wf_engine.GetItemAttrNumber(itemtype => ResumeSDP.itemtype,
731: itemkey => ResumeSDP.itemkey,
732: aname => 'WORKITEM_INSTANCE_ID');
733:
734: xnp_timer_standard.deregister_for_workitem(p_workitem_instance_id => l_wi_instance_id,

Line 832: l_OAFlag := wf_engine.GetActivityAttrText(itemtype => IsOANeeded.itemtype,

828: l_OAFlag VARCHAR2(40);
829:
830: BEGIN
831:
832: l_OAFlag := wf_engine.GetActivityAttrText(itemtype => IsOANeeded.itemtype,
833: itemkey => IsOANeeded.itemkey,
834: actid => actid,
835: aname => 'IS_OA_REQUIRED');
836:

Line 897: 'wf_engine.cb',

893: notifID := wf_notification.SEND(role,
894: msg_type,
895: msg_name,
896: due_date,
897: 'wf_engine.cb',
898: l_context,
899: null,
900: priority);
901:

Line 928: l_Dummy := wf_engine.GetItemAttrText (itemtype => CheckNAddItemAttrText.itemtype,

924: ErrStr := null;
925:
926: BEGIN
927:
928: l_Dummy := wf_engine.GetItemAttrText (itemtype => CheckNAddItemAttrText.itemtype,
929: itemkey => CheckNAddItemAttrText.itemkey,
930: aname => AttrName);
931:
932: l_AttrFound := 1;

Line 934: wf_engine.SetItemAttrText(itemtype => CheckNAddItemAttrText.itemtype,

930: aname => AttrName);
931:
932: l_AttrFound := 1;
933:
934: wf_engine.SetItemAttrText(itemtype => CheckNAddItemAttrText.itemtype,
935: itemkey => CheckNAddItemAttrText.itemkey,
936: aname => AttrName,
937: avalue => AttrValue);
938:

Line 955: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrText.itemtype,

951:
952:
953: IF l_AttrFound = 0 THEN
954:
955: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrText.itemtype,
956: itemkey => CheckNAddItemAttrText.itemkey,
957: aname => AttrName);
958:
959: wf_engine.SetItemAttrText(itemtype => CheckNAddItemAttrText.itemtype,

Line 959: wf_engine.SetItemAttrText(itemtype => CheckNAddItemAttrText.itemtype,

955: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrText.itemtype,
956: itemkey => CheckNAddItemAttrText.itemkey,
957: aname => AttrName);
958:
959: wf_engine.SetItemAttrText(itemtype => CheckNAddItemAttrText.itemtype,
960: itemkey => CheckNAddItemAttrText.itemkey,
961: aname => AttrName,
962: avalue => AttrValue);
963: return;

Line 991: l_Dummy := wf_engine.GetItemAttrNumber (itemtype => CheckNAddItemAttrNumber.itemtype,

987: ErrStr := null;
988:
989: BEGIN
990:
991: l_Dummy := wf_engine.GetItemAttrNumber (itemtype => CheckNAddItemAttrNumber.itemtype,
992: itemkey => CheckNAddItemAttrNumber.itemkey,
993: aname => AttrName);
994:
995: l_AttrFound := 1;

Line 997: wf_engine.SetItemAttrNumber(itemtype => CheckNAddItemAttrNumber.itemtype,

993: aname => AttrName);
994:
995: l_AttrFound := 1;
996:
997: wf_engine.SetItemAttrNumber(itemtype => CheckNAddItemAttrNumber.itemtype,
998: itemkey => CheckNAddItemAttrNumber.itemkey,
999: aname => AttrName,
1000: avalue => AttrValue);
1001:

Line 1019: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrNumber.itemtype,

1015:
1016:
1017: If l_AttrFound = 0 then
1018:
1019: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrNumber.itemtype,
1020: itemkey => CheckNAddItemAttrNumber.itemkey,
1021: aname => AttrName);
1022:
1023: wf_engine.SetItemAttrNumber(itemtype => CheckNAddItemAttrNumber.itemtype,

Line 1023: wf_engine.SetItemAttrNumber(itemtype => CheckNAddItemAttrNumber.itemtype,

1019: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrNumber.itemtype,
1020: itemkey => CheckNAddItemAttrNumber.itemkey,
1021: aname => AttrName);
1022:
1023: wf_engine.SetItemAttrNumber(itemtype => CheckNAddItemAttrNumber.itemtype,
1024: itemkey => CheckNAddItemAttrNumber.itemkey,
1025: aname => AttrName,
1026: avalue => AttrValue);
1027: return;

Line 1056: l_Dummy := wf_engine.GetItemAttrDate (itemtype => CheckNAddItemAttrDate.itemtype,

1052: ErrStr := null;
1053:
1054: BEGIN
1055:
1056: l_Dummy := wf_engine.GetItemAttrDate (itemtype => CheckNAddItemAttrDate.itemtype,
1057: itemkey => CheckNAddItemAttrDate.itemkey,
1058: aname => AttrName);
1059:
1060: l_AttrFound := 1;

Line 1062: wf_engine.SetItemAttrDate(itemtype => CheckNAddItemAttrDate.itemtype,

1058: aname => AttrName);
1059:
1060: l_AttrFound := 1;
1061:
1062: wf_engine.SetItemAttrDate(itemtype => CheckNAddItemAttrDate.itemtype,
1063: itemkey => CheckNAddItemAttrDate.itemkey,
1064: aname => AttrName,
1065: avalue => AttrValue);
1066:

Line 1083: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrDate.itemtype,

1079:
1080:
1081: IF l_AttrFound = 0 THEN
1082:
1083: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrDate.itemtype,
1084: itemkey => CheckNAddItemAttrDate.itemkey,
1085: aname => AttrName);
1086:
1087: wf_engine.SetItemAttrDate(itemtype => CheckNAddItemAttrDate.itemtype,

Line 1087: wf_engine.SetItemAttrDate(itemtype => CheckNAddItemAttrDate.itemtype,

1083: wf_engine.AddItemAttr(itemtype => CheckNAddItemAttrDate.itemtype,
1084: itemkey => CheckNAddItemAttrDate.itemkey,
1085: aname => AttrName);
1086:
1087: wf_engine.SetItemAttrDate(itemtype => CheckNAddItemAttrDate.itemtype,
1088: itemkey => CheckNAddItemAttrDate.itemkey,
1089: aname => AttrName,
1090: avalue => AttrValue);
1091: return;

Line 1115: l_NameArray Wf_Engine.NameTabTyp;

1111: WIInstanceID in number,
1112: FAInstanceID in number)
1113: IS
1114:
1115: l_NameArray Wf_Engine.NameTabTyp;
1116: l_ValueNumArray Wf_Engine.NumTabTyp;
1117: l_ErrCode number;
1118: l_ErrDescription varchar2(800);
1119:

Line 1116: l_ValueNumArray Wf_Engine.NumTabTyp;

1112: FAInstanceID in number)
1113: IS
1114:
1115: l_NameArray Wf_Engine.NameTabTyp;
1116: l_ValueNumArray Wf_Engine.NumTabTyp;
1117: l_ErrCode number;
1118: l_ErrDescription varchar2(800);
1119:
1120:

Line 1125: wf_engine.CreateProcess(itemtype => CreateNAddAttrNParentLabel.itemtype,

1121:
1122: l_index number := 1;
1123: begin
1124:
1125: wf_engine.CreateProcess(itemtype => CreateNAddAttrNParentLabel.itemtype,
1126: itemkey => CreateNAddAttrNParentLabel.itemkey,
1127: process => processname);
1128:
1129: -- Only set its parent when it has one

Line 1131: wf_engine.SetItemParent(itemtype => CreateNAddAttrNParentLabel.itemtype,

1127: process => processname);
1128:
1129: -- Only set its parent when it has one
1130: IF CreateNAddAttrNParentLabel.parentitemkey IS NOT NULL THEN
1131: wf_engine.SetItemParent(itemtype => CreateNAddAttrNParentLabel.itemtype,
1132: itemkey => CreateNAddAttrNParentLabel.itemkey,
1133: parent_itemtype => CreateNAddAttrNParentLabel.parentitemtype,
1134: parent_itemkey => CreateNAddAttrNParentLabel.parentitemkey,
1135: parent_context => CreateNAddAttrNParentLabel.waitflowlabel );

Line 1167: wf_engine.SetItemAttrNumberArray

1163:
1164:
1165: if l_index > 1 then
1166: BEGIN
1167: wf_engine.SetItemAttrNumberArray
1168: (itemtype => CreateNAddAttrNParentLabel.itemtype,
1169: itemkey => CreateNAddAttrNParentLabel.itemKey,
1170: aname => l_NameArray,
1171: avalue => l_ValueNumArray);

Line 1236: l_NameArray Wf_Engine.NameTabTyp;

1232: FAInstanceID IN NUMBER)
1233:
1234: IS
1235:
1236: l_NameArray Wf_Engine.NameTabTyp;
1237: l_ValueNumArray Wf_Engine.NumTabTyp;
1238: l_ErrCode number;
1239: l_ErrDescription varchar2(800);
1240:

Line 1237: l_ValueNumArray Wf_Engine.NumTabTyp;

1233:
1234: IS
1235:
1236: l_NameArray Wf_Engine.NameTabTyp;
1237: l_ValueNumArray Wf_Engine.NumTabTyp;
1238: l_ErrCode number;
1239: l_ErrDescription varchar2(800);
1240:
1241:

Line 1246: wf_engine.CreateProcess(itemtype => CreateAndAddAttrNum.itemtype,

1242:
1243: l_index number := 1;
1244: begin
1245:
1246: wf_engine.CreateProcess(itemtype => CreateAndAddAttrNum.itemtype,
1247: itemkey => CreateAndAddAttrNum.itemkey,
1248: process => processname);
1249:
1250: -- Only set its parent when it has one

Line 1252: wf_engine.SetItemParent(itemtype => CreateAndAddAttrNum.itemtype,

1248: process => processname);
1249:
1250: -- Only set its parent when it has one
1251: IF CreateAndAddAttrNum.parentitemkey IS NOT NULL THEN
1252: wf_engine.SetItemParent(itemtype => CreateAndAddAttrNum.itemtype,
1253: itemkey => CreateAndAddAttrNum.itemkey,
1254: parent_itemtype => CreateAndAddAttrNum.parentitemtype,
1255: parent_itemkey => CreateAndAddAttrNum.parentitemkey,
1256: parent_context => null);

Line 1288: wf_engine.SetItemAttrNumberArray

1284:
1285:
1286: if l_index > 1 then
1287: BEGIN
1288: wf_engine.SetItemAttrNumberArray
1289: (itemtype => CreateAndAddAttrNum.itemtype,
1290: itemkey => CreateAndAddAttrNum.itemKey,
1291: aname => l_NameArray,
1292: avalue => l_ValueNumArray);