DBA Data[Home] [Help]

APPS.PV_PRGM_APPROVAL_PVT dependencies on WF_ENGINE

Line 862: wf_engine.getitemattrtext (

858: - 1);
859: l_item_key := SUBSTR (document_id, l_hyphen_pos1
860: + 1);
861: l_activity_type :=
862: wf_engine.getitemattrtext (
863: itemtype=> l_item_type,
864: itemkey=> l_item_key,
865: aname => 'AMS_ACTIVITY_TYPE'
866: );

Line 868: wf_engine.getitemattrtext (

864: itemkey=> l_item_key,
865: aname => 'AMS_ACTIVITY_TYPE'
866: );
867: l_program_id :=
868: wf_engine.getitemattrtext (
869: itemtype=> l_item_type,
870: itemkey=> l_item_key,
871: aname => 'AMS_ACTIVITY_ID'
872: );

Line 875: wf_engine.getitemattrtext (

871: aname => 'AMS_ACTIVITY_ID'
872: );
873:
874: l_note :=
875: wf_engine.getitemattrtext (
876: itemtype=> l_item_type,
877: itemkey=> l_item_key,
878: aname => 'AMS_NOTES_FROM_REQUESTOR'
879: );

Line 881: wf_engine.getitemattrtext (

877: itemkey=> l_item_key,
878: aname => 'AMS_NOTES_FROM_REQUESTOR'
879: );
880: l_approver :=
881: wf_engine.getitemattrtext (
882: itemtype=> l_item_type,
883: itemkey=> l_item_key,
884: aname => 'AMS_APPROVER_DISPLAY_NAME'
885: );

Line 1007: wf_engine.getitemattrtext (

1003: - 1);
1004: l_item_key := SUBSTR (document_id, l_hyphen_pos1
1005: + 1);
1006: l_activity_type :=
1007: wf_engine.getitemattrtext (
1008: itemtype=> l_item_type,
1009: itemkey=> l_item_key,
1010: aname => 'AMS_ACTIVITY_TYPE'
1011: );

Line 1013: wf_engine.getitemattrtext (

1009: itemkey=> l_item_key,
1010: aname => 'AMS_ACTIVITY_TYPE'
1011: );
1012: l_program_id :=
1013: wf_engine.getitemattrtext (
1014: itemtype=> l_item_type,
1015: itemkey=> l_item_key,
1016: aname => 'AMS_ACTIVITY_ID'
1017: );

Line 1020: wf_engine.getitemattrtext (

1016: aname => 'AMS_ACTIVITY_ID'
1017: );
1018:
1019: l_note :=
1020: wf_engine.getitemattrtext (
1021: itemtype=> l_item_type,
1022: itemkey=> l_item_key,
1023: aname => 'AMS_NOTES_FROM_REQUESTOR'
1024: );

Line 1027: wf_engine.getitemattrtext (

1023: aname => 'AMS_NOTES_FROM_REQUESTOR'
1024: );
1025:
1026: l_approver :=
1027: wf_engine.getitemattrtext (
1028: itemtype=> l_item_type,
1029: itemkey=> l_item_key,
1030: aname => 'AMS_APPROVER_DISPLAY_NAME'
1031: );

Line 1034: wf_engine.getitemattrtext (

1030: aname => 'AMS_APPROVER_DISPLAY_NAME'
1031: );
1032:
1033: l_approver_notes :=
1034: wf_engine.getitemattrtext (
1035: itemtype=> l_item_type,
1036: itemkey=> l_item_key,
1037: aname => 'APPROVAL_NOTE'
1038: );

Line 1164: wf_engine.getitemattrtext (

1160: - 1);
1161: l_item_key := SUBSTR (document_id, l_hyphen_pos1
1162: + 1);
1163: l_activity_type :=
1164: wf_engine.getitemattrtext (
1165: itemtype=> l_item_type,
1166: itemkey=> l_item_key,
1167: aname => 'AMS_ACTIVITY_TYPE'
1168: );

Line 1170: wf_engine.getitemattrtext (

1166: itemkey=> l_item_key,
1167: aname => 'AMS_ACTIVITY_TYPE'
1168: );
1169: l_program_id :=
1170: wf_engine.getitemattrtext (
1171: itemtype=> l_item_type,
1172: itemkey=> l_item_key,
1173: aname => 'AMS_ACTIVITY_ID'
1174: );

Line 1177: wf_engine.getitemattrtext (

1173: aname => 'AMS_ACTIVITY_ID'
1174: );
1175:
1176: l_note :=
1177: wf_engine.getitemattrtext (
1178: itemtype=> l_item_type,
1179: itemkey=> l_item_key,
1180: aname => 'AMS_NOTES_FROM_REQUESTOR'
1181: );

Line 1183: wf_engine.getitemattrtext (

1179: itemkey=> l_item_key,
1180: aname => 'AMS_NOTES_FROM_REQUESTOR'
1181: );
1182: l_approver :=
1183: wf_engine.getitemattrtext (
1184: itemtype=> l_item_type,
1185: itemkey=> l_item_key,
1186: aname => 'AMS_APPROVER_DISPLAY_NAME'
1187: );

Line 1190: wf_engine.getitemattrtext (

1186: aname => 'AMS_APPROVER_DISPLAY_NAME'
1187: );
1188:
1189: l_approver_notes :=
1190: wf_engine.getitemattrtext (
1191: itemtype=> l_item_type,
1192: itemkey=> l_item_key,
1193: aname => 'APPROVAL_NOTE'
1194: );

Line 1321: wf_engine.getitemattrtext (

1317: - 1);
1318: l_item_key := SUBSTR (document_id, l_hyphen_pos1
1319: + 1);
1320: l_activity_type :=
1321: wf_engine.getitemattrtext (
1322: itemtype=> l_item_type,
1323: itemkey=> l_item_key,
1324: aname => 'AMS_ACTIVITY_TYPE'
1325: );

Line 1327: wf_engine.getitemattrtext (

1323: itemkey=> l_item_key,
1324: aname => 'AMS_ACTIVITY_TYPE'
1325: );
1326: l_program_id :=
1327: wf_engine.getitemattrtext (
1328: itemtype=> l_item_type,
1329: itemkey=> l_item_key,
1330: aname => 'AMS_ACTIVITY_ID'
1331: );

Line 1334: wf_engine.getitemattrtext (

1330: aname => 'AMS_ACTIVITY_ID'
1331: );
1332:
1333: l_note :=
1334: wf_engine.getitemattrtext (
1335: itemtype=> l_item_type,
1336: itemkey=> l_item_key,
1337: aname => 'AMS_NOTES_FROM_REQUESTOR'
1338: );

Line 1340: wf_engine.getitemattrtext (

1336: itemkey=> l_item_key,
1337: aname => 'AMS_NOTES_FROM_REQUESTOR'
1338: );
1339: l_approver :=
1340: wf_engine.getitemattrtext (
1341: itemtype=> l_item_type,
1342: itemkey=> l_item_key,
1343: aname => 'AMS_APPROVER_DISPLAY_NAME'
1344: );

Line 1470: wf_engine.getitemattrtext (

1466: - 1);
1467: l_item_key := SUBSTR (document_id, l_hyphen_pos1
1468: + 1);
1469: l_activity_type :=
1470: wf_engine.getitemattrtext (
1471: itemtype=> l_item_type,
1472: itemkey=> l_item_key,
1473: aname => 'AMS_ACTIVITY_TYPE'
1474: );

Line 1476: wf_engine.getitemattrtext (

1472: itemkey=> l_item_key,
1473: aname => 'AMS_ACTIVITY_TYPE'
1474: );
1475: l_program_id :=
1476: wf_engine.getitemattrtext (
1477: itemtype=> l_item_type,
1478: itemkey=> l_item_key,
1479: aname => 'AMS_ACTIVITY_ID'
1480: );

Line 1483: wf_engine.getitemattrtext (

1479: aname => 'AMS_ACTIVITY_ID'
1480: );
1481:
1482: l_note :=
1483: wf_engine.getitemattrtext (
1484: itemtype=> l_item_type,
1485: itemkey=> l_item_key,
1486: aname => 'AMS_NOTES_FROM_REQUESTOR'
1487: );

Line 1489: wf_engine.getitemattrtext (

1485: itemkey=> l_item_key,
1486: aname => 'AMS_NOTES_FROM_REQUESTOR'
1487: );
1488: l_approver :=
1489: wf_engine.getitemattrtext (
1490: itemtype=> l_item_type,
1491: itemkey=> l_item_key,
1492: aname => 'AMS_APPROVER_DISPLAY_NAME'
1493: );

Line 1602: wf_engine.getitemattrnumber (

1598:
1599: BEGIN
1600: fnd_msg_pub.initialize;
1601: l_activity_id :=
1602: wf_engine.getitemattrnumber (
1603: itemtype=> itemtype,
1604: itemkey=> itemkey,
1605: aname => 'AMS_ACTIVITY_ID'
1606: );

Line 1625: wf_engine.setitemattrnumber (

1621: );
1622:
1623: IF l_return_status = fnd_api.g_ret_sts_success THEN
1624:
1625: wf_engine.setitemattrnumber (
1626: itemtype=> itemtype,
1627: itemkey=> itemkey,
1628: aname => 'AMS_APPROVAL_DETAIL_ID',
1629: avalue=> l_approval_detail_id

Line 1631: wf_engine.setitemattrnumber (

1627: itemkey=> itemkey,
1628: aname => 'AMS_APPROVAL_DETAIL_ID',
1629: avalue=> l_approval_detail_id
1630: );
1631: wf_engine.setitemattrnumber (
1632: itemtype=> itemtype,
1633: itemkey=> itemkey,
1634: aname => 'AMS_APPROVER_SEQ',
1635: avalue=> l_approver_seq

Line 1648: wf_engine.setitemattrtext (

1644: );
1645:
1646:
1647: l_string := fnd_message.get;
1648: wf_engine.setitemattrtext (
1649: itemtype=> itemtype,
1650: itemkey=> itemkey,
1651: aname => 'FYI_SUBJECT',
1652: avalue=> l_string

Line 1659: wf_engine.setitemattrtext (

1655: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');
1656: fnd_message.set_token ('PROGRAM_NAME', l_object_details.name, FALSE );
1657:
1658: l_string := fnd_message.get;
1659: wf_engine.setitemattrtext (
1660: itemtype=> itemtype,
1661: itemkey=> itemkey,
1662: aname => 'APRV_SUBJECT',
1663: avalue=> l_string

Line 1671: wf_engine.setitemattrtext (

1667: fnd_message.set_token ('PROGRAM_NAME',l_object_details.name,FALSE );
1668:
1669: l_string := fnd_message.get;
1670:
1671: wf_engine.setitemattrtext (
1672: itemtype=> itemtype,
1673: itemkey=> itemkey,
1674: aname => 'REJECT_SUBJECT',
1675: avalue=> l_string

Line 1686: wf_engine.setitemattrtext (

1682: );
1683:
1684: l_string := fnd_message.get;
1685:
1686: wf_engine.setitemattrtext (
1687: itemtype=> itemtype,
1688: itemkey=> itemkey,
1689: aname => 'APP_SUBJECT',
1690: avalue=> l_string

Line 1856: wf_engine.getitemattrtext (

1852: l_check_flag boolean :=false;
1853: BEGIN
1854: IF funcmode = 'RUN' THEN
1855: l_update_status :=
1856: wf_engine.getitemattrtext (
1857: itemtype=> itemtype,
1858: itemkey=> itemkey,
1859: aname => 'UPDATE_GEN_STATUS'
1860: );

Line 1865: wf_engine.getitemattrnumber (

1861:
1862:
1863: IF l_update_status = 'APPROVED' THEN
1864: l_next_status_id :=
1865: wf_engine.getitemattrnumber (
1866: itemtype=> itemtype,
1867: itemkey=> itemkey,
1868: aname => 'AMS_NEW_STAT_ID'
1869: );

Line 1876: wf_engine.getitemattrnumber (

1872: ams_utility_pvt.debug_message ( l_full_name
1873: || l_update_status);
1874: ELSE
1875: l_next_status_id :=
1876: wf_engine.getitemattrnumber (
1877: itemtype=> itemtype,
1878: itemkey=> itemkey,
1879: aname => 'AMS_REJECT_STAT_ID'
1880: );

Line 1886: wf_engine.getitemattrnumber (

1882: END IF;
1883:
1884: /**
1885: l_object_version_number :=
1886: wf_engine.getitemattrnumber (
1887: itemtype=> itemtype,
1888: itemkey=> itemkey,
1889: aname => 'AMS_OBJECT_VERSION_NUMBER'
1890: );

Line 1895: wf_engine.getitemattrnumber (

1891:
1892: */
1893:
1894: l_program_id :=
1895: wf_engine.getitemattrnumber (
1896: itemtype=> itemtype,
1897: itemkey=> itemkey,
1898: aname => 'AMS_ACTIVITY_ID'
1899: );

Line 2098: l_object_id := WF_ENGINE.GetItemAttrNumber(

2094: AND approver_id=p_appr_id
2095: AND arc_appr_for_entity_code='ENRQ';
2096: BEGIN
2097:
2098: l_object_id := WF_ENGINE.GetItemAttrNumber(
2099: itemtype => itemtype
2100: , itemkey => itemkey
2101: , aname => 'OBJECT_ID'
2102: );

Line 2104: l_object_type := WF_ENGINE.GetItemAttrText (

2100: , itemkey => itemkey
2101: , aname => 'OBJECT_ID'
2102: );
2103:
2104: l_object_type := WF_ENGINE.GetItemAttrText (
2105: itemtype => itemtype
2106: , itemkey => itemkey
2107: , aname => 'OBJECT_TYPE'
2108: );

Line 2110: l_approver_id := WF_ENGINE.GetItemAttrNumber (

2106: , itemkey => itemkey
2107: , aname => 'OBJECT_TYPE'
2108: );
2109:
2110: l_approver_id := WF_ENGINE.GetItemAttrNumber (
2111: itemtype => itemtype
2112: , itemkey => itemkey
2113: , aname => 'APPROVER_ID'
2114: );

Line 2263: WF_ENGINE.SetItemAttrNumber

2259: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2260: RAISE FND_API.G_EXC_ERROR;
2261: END IF;
2262:
2263: WF_ENGINE.SetItemAttrNumber
2264: ( itemtype => p_itemtype
2265: , itemkey => p_itemkey
2266: , aname => 'OBJECT_ID'
2267: , avalue => p_object_id

Line 2270: WF_ENGINE.SetItemAttrText

2266: , aname => 'OBJECT_ID'
2267: , avalue => p_object_id
2268: );
2269:
2270: WF_ENGINE.SetItemAttrText
2271: ( itemtype => p_itemtype
2272: , itemkey => p_itemkey
2273: , aname => 'OBJECT_TYPE'
2274: , avalue => p_object_type

Line 2283: WF_ENGINE.SetItemAttrText(

2279: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2280:
2281: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2282:
2283: WF_ENGINE.SetItemAttrText(
2284: itemtype => p_itemtype
2285: , itemkey => p_itemkey
2286: , aname => 'APPR_SUBJECT'
2287: , avalue => l_string_sub

Line 2296: WF_ENGINE.SetItemAttrText(

2292: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2293: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2294: l_string := SUBSTR(fnd_message.get,1,3000);
2295:
2296: WF_ENGINE.SetItemAttrText(
2297: itemtype => p_itemtype
2298: , itemkey => p_itemkey
2299: , aname => 'FYI_BODY'
2300: , avalue => l_string

Line 2308: WF_ENGINE.SetItemAttrText(

2304: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2305: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2306: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2307:
2308: WF_ENGINE.SetItemAttrText(
2309: itemtype => p_itemtype
2310: , itemkey => p_itemkey
2311: , aname => 'REMINDER_SUBJECT'
2312: , avalue => l_string_sub

Line 2321: WF_ENGINE.SetItemAttrText(

2317: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2318: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2319: l_string := SUBSTR(fnd_message.get,1,3000);
2320:
2321: WF_ENGINE.SetItemAttrText(
2322: itemtype => p_itemtype
2323: , itemkey => p_itemkey
2324: , aname => 'REMINDER_BODY'
2325: , avalue => l_string

Line 2329: WF_ENGINE.SetItemAttrNumber(

2325: , avalue => l_string
2326: );
2327:
2328:
2329: WF_ENGINE.SetItemAttrNumber(
2330: itemtype => p_itemtype
2331: , itemkey => p_itemkey
2332: , aname => 'APPROVER_ID'
2333: , avalue => p_approver_id

Line 2350: WF_ENGINE.SetItemAttrNumber(

2346:
2347: -- convert the days to minutes
2348: l_rem:=l_rem*24*60;
2349:
2350: WF_ENGINE.SetItemAttrNumber(
2351: itemtype => p_itemtype
2352: , itemkey => p_itemkey
2353: , aname => 'REMINDER_DURATION'
2354: , avalue => l_rem

Line 2369: WF_ENGINE.SetItemAttrText (

2365: RAISE FND_API.G_EXC_ERROR;
2366: END IF;
2367: */
2368:
2369: WF_ENGINE.SetItemAttrText (
2370: itemtype => p_itemtype
2371: , itemkey => p_itemkey
2372: , aname => 'OWNER_USERNAME'
2373: , avalue => p_role_name );

Line 2411: WF_ENGINE.CreateProcess

2407: BEGIN
2408: -- clear the message buffer
2409: FND_MSG_PUB.initialize;
2410: --write to logs that workflow is getting initiated.
2411: WF_ENGINE.CreateProcess
2412: ( itemtype => l_itemtype
2413: , itemkey => itemkey
2414: , process => processName -- 'PV_APPROVER_NOTIFICATIONS'
2415: );

Line 2435: WF_ENGINE.StartProcess

2431: , p_role_name => p_role_name
2432: , p_display_name => p_display_name
2433: );
2434:
2435: WF_ENGINE.StartProcess
2436: ( itemtype => l_itemtype
2437: , itemkey => itemkey
2438: );
2439: