APPS.AS_LEAD_ROUTING_WF dependencies on WF_ENGINE

Line 119: wf_engine.CreateProcess( ItemType => Item_Type,

115: FROM dual;
116:
117: g_user_group_id := p_salesgroup_id;
118:
119: wf_engine.CreateProcess( ItemType => Item_Type,
120: ItemKey => Item_Key,
121: process => Workflowprocess);
122:
123: -- Initialize workflow item attributes

Line 125: wf_engine.SetItemAttrNumber(itemtype => Item_Type,

121: process => Workflowprocess);
122:
123: -- Initialize workflow item attributes
124: --
125: wf_engine.SetItemAttrNumber(itemtype => Item_Type,
126: itemkey => Item_Key,
127: aname => 'SALES_LEAD_ID',
128: avalue => p_sales_lead_id);
129:

Line 130: wf_engine.AddItemAttr(itemtype => Item_Type,

126: itemkey => Item_Key,
127: aname => 'SALES_LEAD_ID',
128: avalue => p_sales_lead_id);
129:
130: wf_engine.AddItemAttr(itemtype => Item_Type,
131: itemkey => Item_Key,
132: aname => 'ORIG_RESOURCE_ID',
133: number_value => NULL);
134:

Line 135: wf_engine.AddItemAttr(itemtype => Item_Type,

131: itemkey => Item_Key,
132: aname => 'ORIG_RESOURCE_ID',
133: number_value => NULL);
134:
135: wf_engine.AddItemAttr(itemtype => Item_Type,
136: itemkey => Item_Key,
137: aname => 'RESOURCE_ID',
138: number_value => 0);
139:

Line 140: wf_engine.AddItemAttr(itemtype => Item_Type,

136: itemkey => Item_Key,
137: aname => 'RESOURCE_ID',
138: number_value => 0);
139:
140: wf_engine.AddItemAttr(itemtype => Item_Type,
141: itemkey => Item_Key,
142: aname => 'GROUP_ID',
143: number_value => 0);
144:

Line 145: wf_engine.AddItemAttr(itemtype => Item_Type,

141: itemkey => Item_Key,
142: aname => 'GROUP_ID',
143: number_value => 0);
144:
145: wf_engine.AddItemAttr(itemtype => Item_Type,
146: itemkey => Item_Key,
147: aname => 'PERSON_ID',
148: number_value => 0);
149:

Line 150: wf_engine.AddItemAttr(itemtype => Item_Type,

146: itemkey => Item_Key,
147: aname => 'PERSON_ID',
148: number_value => 0);
149:
150: wf_engine.AddItemAttr(itemtype => Item_Type,
151: Itemkey => Item_Key,
152: aname => 'BUSINESS_GROUP_ID',
153: number_value => 0);
154:

Line 155: wf_engine.AddItemAttr(itemtype => Item_Type,

151: Itemkey => Item_Key,
152: aname => 'BUSINESS_GROUP_ID',
153: number_value => 0);
154:
155: wf_engine.AddItemAttr(itemtype => Item_Type,
156: Itemkey => Item_Key,
157: aname => 'REJECT_REASON_CODE',
158: text_value => p_reject_reason_code);
159:

Line 165: wf_engine.AddItemAttr(itemtype => Item_Type,

161: -- is added item list. This will be populated, once if the resource id
162: -- from profile as_default_resource_id is used.
163: -- Refer: Bug 1613424
164:
165: wf_engine.AddItemAttr(itemtype => Item_Type,
166: Itemkey => Item_Key,
167: aname => 'DEFAULT_RESOURCE_ID',
168: number_value => 0);
169:

Line 170: wf_engine.StartProcess(itemtype => Item_Type,

166: Itemkey => Item_Key,
167: aname => 'DEFAULT_RESOURCE_ID',
168: number_value => 0);
169:
170: wf_engine.StartProcess(itemtype => Item_Type,
171: itemkey => Item_Key );
172:
173: wf_engine.ItemStatus(itemtype => Item_Type,
174: itemkey => Item_Key,

Line 173: wf_engine.ItemStatus(itemtype => Item_Type,

169:
170: wf_engine.StartProcess(itemtype => Item_Type,
171: itemkey => Item_Key );
172:
173: wf_engine.ItemStatus(itemtype => Item_Type,
174: itemkey => Item_Key,
175: status => l_status,
176: result => l_result);
177:

Line 194: l_profile_rs_id := wf_engine.GetItemAttrNumber(

190: -- GetAvailableResource either had used profile or login user's
191: -- resource id. In which case, the start process returns
192: -- 'W'arning to the calling program.
193:
194: l_profile_rs_id := wf_engine.GetItemAttrNumber(
195: itemtype => Item_Type,
196: itemkey => Item_Key,
197: aname => 'DEFAULT_RESOURCE_ID' );
198:

Line 225: wf_engine.SetItemAttrNumber (

221: resource_id IN NUMBER,
222: group_id IN NUMBER,
223: person_id IN NUMBER) IS
224: BEGIN
225: wf_engine.SetItemAttrNumber (
226: itemtype => itemtype,
227: itemkey => itemkey,
228: aname => 'RESOURCE_ID',
229: avalue => resource_id);

Line 231: wf_engine.SetItemAttrNumber (

227: itemkey => itemkey,
228: aname => 'RESOURCE_ID',
229: avalue => resource_id);
230:
231: wf_engine.SetItemAttrNumber (
232: itemtype => itemtype,
233: itemkey => itemkey,
234: aname => 'GROUP_ID',
235: avalue => group_id);

Line 237: wf_engine.SetItemAttrNumber (

233: itemkey => itemkey,
234: aname => 'GROUP_ID',
235: avalue => group_id);
236:
237: wf_engine.SetItemAttrNumber (
238: itemtype => itemtype,
239: itemkey => itemkey,
240: aname => 'PERSON_ID',
241: avalue => person_id);

Line 457: l_sales_lead_id := wf_engine.GetItemAttrNumber(

453: END IF;
454:
455: IF funcmode = 'RUN'
456: THEN
457: l_sales_lead_id := wf_engine.GetItemAttrNumber(
458: itemtype => itemtype,
459: itemkey => itemkey,
460: aname => 'SALES_LEAD_ID');
461:

Line 644: l_sales_lead_id := wf_engine.GetItemAttrNumber(

640: END IF;
641:
642: IF funcmode = 'RUN'
643: THEN
644: l_sales_lead_id := wf_engine.GetItemAttrNumber(
645: itemtype => itemtype,
646: itemkey => itemkey,
647: aname => 'SALES_LEAD_ID');
648:

Line 799: wf_engine.SetItemAttrNumber (

795: IF g_resource_flag_tbl(1) = 'D'
796: THEN
797: -- Set default resource will have return status 'W' in
798: -- StartProcess
799: wf_engine.SetItemAttrNumber (
800: itemtype => itemtype,
801: itemkey => itemkey,
802: aname => 'DEFAULT_RESOURCE_ID',
803: avalue => l_resource_id);

Line 830: wf_engine.SetItemAttrNumber (

826: ELSIF g_resource_flag_tbl(1) = 'L'
827: THEN
828: -- Set default resource will have return status 'W' in
829: -- StartProcess
830: wf_engine.SetItemAttrNumber (
831: itemtype => itemtype,
832: itemkey => itemkey,
833: aname => 'DEFAULT_RESOURCE_ID',
834: avalue => l_resource_id);

Line 928: l_sales_lead_id := wf_engine.GetItemAttrNumber(

924: 'UpdateSalesLeads: Start');
925: END IF;
926: IF funcmode = 'RUN'
927: THEN
928: l_sales_lead_id := wf_engine.GetItemAttrNumber(
929: itemtype => itemtype,
930: itemkey => itemkey,
931: aname => 'SALES_LEAD_ID' );
932:

Line 933: l_resource_id := wf_engine.GetItemAttrNumber(

929: itemtype => itemtype,
930: itemkey => itemkey,
931: aname => 'SALES_LEAD_ID' );
932:
933: l_resource_id := wf_engine.GetItemAttrNumber(
934: itemtype => itemtype,
935: itemkey => itemkey,
936: aname => 'RESOURCE_ID' );
937:

Line 938: l_group_id := wf_engine.GetItemAttrNumber(

934: itemtype => itemtype,
935: itemkey => itemkey,
936: aname => 'RESOURCE_ID' );
937:
938: l_group_id := wf_engine.GetItemAttrNumber(
939: itemtype => itemtype,
940: itemkey => itemkey,
941: aname => 'GROUP_ID' );
942:

Line 943: l_person_id := wf_engine.GetItemAttrNumber(

939: itemtype => itemtype,
940: itemkey => itemkey,
941: aname => 'GROUP_ID' );
942:
943: l_person_id := wf_engine.GetItemAttrNumber(
944: itemtype => itemtype,
945: itemkey => itemkey,
946: aname => 'PERSON_ID' );
947:

Line 1181: l_sales_lead_id := wf_engine.GetItemAttrNumber(

1177: BEGIN
1178:
1179: IF funcmode = 'RUN' THEN
1180:
1181: l_sales_lead_id := wf_engine.GetItemAttrNumber(
1182: itemtype => itemtype,
1183: itemkey => itemkey,
1184: aname => 'SALES_LEAD_ID' );
1185:

Line 1316: l_sales_lead_id := wf_engine.GetItemAttrNumber(

1312: WHERE assign_to_salesforce_id = resource_id_in
1313: and sales_lead_id = sl_id_in;
1314:
1315: BEGIN
1316: l_sales_lead_id := wf_engine.GetItemAttrNumber(
1317: itemtype => itemtype,
1318: itemkey => itemkey,
1319: aname => 'SALES_LEAD_ID' );
1320:

Line 1361: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1357: IF l_never_assigned > 0 THEN
1358: l_selected_id := l_leastwork_resource.resource_id;
1359: l_selected_group_id := l_leastwork_resource.group_id;
1360:
1361: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1362: itemkey => itemkey,
1363: aname => 'RESOURCE_ID',
1364: avalue => l_selected_id);
1365:

Line 1366: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1362: itemkey => itemkey,
1363: aname => 'RESOURCE_ID',
1364: avalue => l_selected_id);
1365:
1366: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1367: itemkey => itemkey,
1368: aname => 'BUSINESS_GROUP_ID',
1369: avalue => l_selected_group_id);
1370: result := 'COMPLETE:S';

Line 1373: wf_engine.SetItemAttrNumber(itemtype => itemtype,

1369: avalue => l_selected_group_id);
1370: result := 'COMPLETE:S';
1371: ELSE
1372: -- Escalate it to the manager of the person with least workload
1373: wf_engine.SetItemAttrNumber(itemtype => itemtype,
1374: itemkey => itemkey,
1375: aname => 'BUSINESS_GROUP_ID',
1376: avalue => l_leastwork_resource.group_id);
1377: result := 'COMPLETE:ESCALATE';

Line 1432: l_group_id := wf_engine.GetItemAttrNumber(

1428:
1429: BEGIN
1430:
1431: IF funcmode = 'RUN' THEN
1432: l_group_id := wf_engine.GetItemAttrNumber(
1433: itemtype => itemtype,
1434: itemkey => itemkey,
1435: aname => 'BUSINESS_GROUP_ID' );
1436:

Line 1438: l_sales_lead_id := wf_engine.GetItemAttrNumber(

1434: itemkey => itemkey,
1435: aname => 'BUSINESS_GROUP_ID' );
1436:
1437:
1438: l_sales_lead_id := wf_engine.GetItemAttrNumber(
1439: itemtype => itemtype,
1440: itemkey => itemkey,
1441: aname => 'SALES_LEAD_ID' );
1442:

Line 1453: l_origowner_id := wf_engine.GetItemAttrNumber(

1449: -- end ffang 110200
1450:
1451: -- assign it to the original owner
1452:
1453: l_origowner_id := wf_engine.GetItemAttrNumber(
1454: itemtype => itemtype,
1455: itemkey => itemkey,
1456: aname => 'ORIG_RESOURCE_ID' );
1457:

Line 1458: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

1454: itemtype => itemtype,
1455: itemkey => itemkey,
1456: aname => 'ORIG_RESOURCE_ID' );
1457:
1458: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1459: itemkey => itemkey,
1460: aname => 'RESOURCE_ID',
1461: avalue => l_origowner_id);
1462: IF l_origowner_id is NULL THEN

Line 1464: wf_engine.SetItemAttrNumber ( itemtype => itemtype,

1460: aname => 'RESOURCE_ID',
1461: avalue => l_origowner_id);
1462: IF l_origowner_id is NULL THEN
1463: l_group_id := NULL;
1464: wf_engine.SetItemAttrNumber ( itemtype => itemtype,
1465: itemkey => itemkey,
1466: aname => 'BUSINESS_GROUP_ID',
1467: avalue => l_group_id);
1468: END IF;