DBA Data[Home] [Help]

APPS.PV_WORKFLOW_PUB dependencies on WF_ENGINE

Line 56: l_temp := wf_engine.GetItemAttrText( itemtype => itemtype,

52: END IF;
53:
54: if (funcmode = 'RUN') then
55:
56: l_temp := wf_engine.GetItemAttrText( itemtype => itemtype,
57: itemkey => itemkey,
58: aname => g_wf_attr_bypass_cm_approval);
59:
60: if l_temp not in (g_wf_lkup_yes,

Line 187: l_timeout_type := wf_engine.GetActivityAttrText(itemtype => itemtype,

183: END IF;
184:
185: if (funcmode = 'RUN') then
186:
187: l_timeout_type := wf_engine.GetActivityAttrText(itemtype => itemtype,
188: itemkey => itemkey,
189: actid => actid,
190: aname => g_wf_attr_pvt_timeout_type);
191: pv_assignment_pvt.setTimeout (

Line 383: wf_engine.SetItemAttrText (itemtype => itemType,

379:
380: end if;
381: end loop;
382:
383: wf_engine.SetItemAttrText (itemtype => itemType,
384: itemkey => itemKey,
385: aname => g_wf_attr_routing_outcome,
386: avalue => g_wf_lkup_match_timedout);
387:

Line 455: l_match_outcome := wf_engine.GetItemAttrText(itemtype => itemtype,

451: END IF;
452:
453: if (funcmode = 'RUN') then
454:
455: l_match_outcome := wf_engine.GetItemAttrText(itemtype => itemtype,
456: itemkey => itemkey,
457: aname => g_wf_attr_routing_outcome);
458:
459: -- in case salesrep have added access records for partner/partner contact

Line 603: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,

599: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
600: raise FND_API.G_EXC_ERROR;
601: end if;
602:
603: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,
604: itemkey => itemkey,
605: aname => g_wf_attr_assignment_type);
606:
607: if l_assignment_type = g_wf_lkup_single then

Line 667: wf_engine.SetItemAttrNumber (itemtype => itemType,

663: end if;
664:
665: close lc_get_pt_id;
666:
667: wf_engine.SetItemAttrNumber (itemtype => itemType,
668: itemkey => itemKey,
669: aname => g_wf_attr_next_serial_rank,
670: avalue => l_assign_sequence);
671:

Line 820: l_current_seq := wf_engine.GetItemAttrNumber( itemtype => itemtype,

816: END IF;
817:
818: if (funcmode = 'RUN') then
819:
820: l_current_seq := wf_engine.GetItemAttrNumber( itemtype => itemtype,
821: itemkey => itemkey,
822: aname => g_wf_attr_next_serial_rank);
823: if l_current_seq <> -999 then
824:

Line 861: wf_engine.SetItemAttrNumber (itemtype => itemType,

857: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
858: raise FND_API.G_EXC_ERROR;
859: end if;
860:
861: wf_engine.SetItemAttrNumber (itemtype => itemType,
862: itemkey => itemKey,
863: aname => g_wf_attr_current_serial_rank,
864: avalue => l_current_seq);
865:

Line 866: wf_engine.SetItemAttrNumber (itemtype => itemType,

862: itemkey => itemKey,
863: aname => g_wf_attr_current_serial_rank,
864: avalue => l_current_seq);
865:
866: wf_engine.SetItemAttrNumber (itemtype => itemType,
867: itemkey => itemKey,
868: aname => g_wf_attr_next_serial_rank,
869: avalue => nvl(l_next_seq, -999));
870:

Line 993: l_partner_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

989: END IF;
990:
991: if (funcmode = 'RUN') then
992:
993: l_partner_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
994: itemkey => itemkey,
995: aname => g_wf_attr_partner_id);
996: pv_assignment_pvt.send_notification (
997: p_api_version_number => 1.0

Line 1014: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,

1010: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1011: raise FND_API.G_EXC_ERROR;
1012: end if;
1013:
1014: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,
1015: itemkey => itemkey,
1016: aname => g_wf_attr_assignment_type);
1017: if l_assignment_type = g_wf_lkup_joint then
1018:

Line 1019: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1015: itemkey => itemkey,
1016: aname => g_wf_attr_assignment_type);
1017: if l_assignment_type = g_wf_lkup_joint then
1018:
1019: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1020: itemkey => itemkey,
1021: aname => g_wf_attr_opportunity_id);
1022:
1023: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1023: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1019: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1020: itemkey => itemkey,
1021: aname => g_wf_attr_opportunity_id);
1022:
1023: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1024: itemkey => itemkey,
1025: aname => g_wf_attr_customer_id);
1026:
1027: l_address_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1027: l_address_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1023: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1024: itemkey => itemkey,
1025: aname => g_wf_attr_customer_id);
1026:
1027: l_address_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1028: itemkey => itemkey,
1029: aname => g_wf_attr_address_id);
1030:
1031: wf_engine.SetItemAttrNumber (itemtype => itemType,

Line 1031: wf_engine.SetItemAttrNumber (itemtype => itemType,

1027: l_address_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1028: itemkey => itemkey,
1029: aname => g_wf_attr_address_id);
1030:
1031: wf_engine.SetItemAttrNumber (itemtype => itemType,
1032: itemkey => itemKey,
1033: aname => g_wf_attr_wf_activity_id,
1034: avalue => actid);
1035:

Line 1324: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,

1320: END IF;
1321:
1322: if (funcmode = 'RUN') then
1323:
1324: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => g_wf_attr_assignment_type);
1327:
1328: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1328: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1324: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,
1325: itemkey => itemkey,
1326: aname => g_wf_attr_assignment_type);
1327:
1328: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1329: itemkey => itemkey,
1330: aname => g_wf_attr_opportunity_id);
1331:
1332: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1332: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1328: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1329: itemkey => itemkey,
1330: aname => g_wf_attr_opportunity_id);
1331:
1332: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1333: itemkey => itemkey,
1334: aname => g_wf_attr_customer_id);
1335:
1336: l_address_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 1336: l_address_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1332: l_customer_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1333: itemkey => itemkey,
1334: aname => g_wf_attr_customer_id);
1335:
1336: l_address_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1337: itemkey => itemkey,
1338: aname => g_wf_attr_address_id);
1339:
1340: -- check to see if timeout happened

Line 1362: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1358: if l_assignment_type in (g_wf_lkup_single, g_wf_lkup_serial) then
1359:
1360: -- partner_id is set in single and serial assignment
1361:
1362: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1363: itemkey => itemkey,
1364: aname => g_wf_attr_partner_id);
1365:
1366: open lc_get_pt_response(pc_itemtype => itemtype,

Line 1611: l_rank := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1607:
1608: if l_assignment_type = g_wf_lkup_broadcast then
1609: l_rank := -1;
1610: else
1611: l_rank := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1612: itemkey => itemkey,
1613: aname => g_wf_attr_current_serial_rank);
1614: end if;
1615:

Line 1836: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1832: end if; -- end l_offer_outcome = g_wf_lkup_offer_approved
1833:
1834: -- in case of serial, we only want to send notification for current partner
1835:
1836: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1837: itemkey => itemkey,
1838: aname => g_wf_attr_partner_id);
1839:
1840:

Line 1863: wf_engine.SetItemAttrText (itemtype => itemType,

1859: end if;
1860:
1861: end if;
1862:
1863: wf_engine.SetItemAttrText (itemtype => itemType,
1864: itemkey => itemKey,
1865: aname => g_wf_attr_offer_outcome,
1866: avalue => l_offer_outcome);
1867:

Line 1872: wf_engine.SetItemAttrText (itemtype => itemType,

1868: -- this will also work for serial also as the serial process
1869: -- is not exited until all pts have responded or current
1870: -- pt has accepted or the opp is withdrawn
1871:
1872: wf_engine.SetItemAttrText (itemtype => itemType,
1873: itemkey => itemKey,
1874: aname => g_wf_attr_routing_outcome,
1875: avalue => l_offer_outcome);
1876:

Line 1973: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,

1969: END IF;
1970:
1971: if (funcmode = 'RUN') then
1972:
1973: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,
1974: itemkey => itemkey,
1975: aname => g_wf_attr_assignment_type);
1976:
1977: if l_assignment_type in (g_wf_lkup_single, g_wf_lkup_serial) then

Line 1981: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

1977: if l_assignment_type in (g_wf_lkup_single, g_wf_lkup_serial) then
1978:
1979: -- partner_id is set in single and serial assignment
1980:
1981: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
1982: itemkey => itemkey,
1983: aname => g_wf_attr_partner_id);
1984:
1985: open lc_bypass_pt_ok_chk (pc_itemtype => itemtype, pc_itemkey => itemkey, pc_partner_id => l_partner_id);

Line 2118: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,

2114: END IF;
2115:
2116: if (funcmode = 'RUN') then
2117:
2118: l_assignment_type := wf_engine.GetItemAttrText( itemtype => itemtype,
2119: itemkey => itemkey,
2120: aname => g_wf_attr_assignment_type);
2121:
2122: if l_assignment_type in (g_wf_lkup_single, g_wf_lkup_serial, g_wf_lkup_broadcast) then

Line 2246: l_routing_outcome := wf_engine.GetItemAttrText(itemtype => itemtype,

2242: END IF;
2243:
2244: if (funcmode = 'RUN') then
2245:
2246: l_routing_outcome := wf_engine.GetItemAttrText(itemtype => itemtype,
2247: itemkey => itemkey,
2248: aname => g_wf_attr_routing_outcome);
2249:
2250: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

Line 2250: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2246: l_routing_outcome := wf_engine.GetItemAttrText(itemtype => itemtype,
2247: itemkey => itemkey,
2248: aname => g_wf_attr_routing_outcome);
2249:
2250: l_lead_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2251: itemkey => itemkey,
2252: aname => g_wf_attr_opportunity_id);
2253:
2254:

Line 2299: l_assignment_type := wf_engine.GetItemAttrText(itemtype => itemtype,

2295: l_routing_stage := pv_assignment_pub.g_r_status_withdrawn;
2296:
2297: IF l_routing_outcome = pv_workflow_pub.g_wf_lkup_offer_withdrawn THEN
2298:
2299: l_assignment_type := wf_engine.GetItemAttrText(itemtype => itemtype,
2300: itemkey => itemkey,
2301: aname => pv_workflow_pub.g_wf_attr_assignment_type);
2302:
2303: IF l_assignment_type = g_wf_lkup_serial THEN

Line 2304: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2300: itemkey => itemkey,
2301: aname => pv_workflow_pub.g_wf_attr_assignment_type);
2302:
2303: IF l_assignment_type = g_wf_lkup_serial THEN
2304: l_partner_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2305: itemkey => itemkey,
2306: aname => g_wf_attr_partner_id);
2307: fnd_message.Set_Name('PV', 'PV_DEBUG_MESSAGE');
2308: fnd_message.Set_Token('TEXT', 'l_partner_id ' || l_partner_id);

Line 2466: l_partner_id := wf_engine.GetItemAttrText(itemtype => itemType,

2462: END IF;
2463:
2464: if (funcmode = 'RUN') then
2465:
2466: l_partner_id := wf_engine.GetItemAttrText(itemtype => itemType,
2467: itemkey => itemKey,
2468: aname => pv_workflow_pub.g_wf_attr_ext_org_party_id);
2469:
2470: pv_assignment_pvt.send_notification (