293:
294:
295: BEGIN
296: /*****************************************************************************
297: ** Standard call to check for call compatibility
298: *****************************************************************************/
299: IF NOT FND_API.Compatible_API_Call( l_api_version
300: , p_api_version
301: , l_api_name
465: );
466:
467:
468: /***************************************************************************
469: ** Standard check of p_commit (WF won't start until commited)
470: ***************************************************************************/
471: IF FND_API.To_Boolean(p_commit)
472: THEN
473: COMMIT WORK;
474: END IF;
475:
476:
477: /*****************************************************************************
478: ** Standard call to get message count and if count is > 1, get message info
479: *****************************************************************************/
480: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
481: , p_data => x_msg_data
482: );
569:
570:
571: BEGIN
572: /*****************************************************************************
573: ** Standard call to check for call compatibility
574: *****************************************************************************/
575: IF NOT FND_API.Compatible_API_Call( l_api_version
576: , p_api_version
577: , l_api_name
709: wf_engine.StartProcess( itemtype => l_item_type
710: , itemkey => l_item_key
711: );
712: /***************************************************************************
713: ** Standard check of p_commit (WF won't start until commited)
714: ***************************************************************************/
715: IF FND_API.To_Boolean(p_commit)
716: THEN
717: COMMIT WORK;
718: END IF;
719:
720:
721: /*****************************************************************************
722: ** Standard call to get message count and if count is > 1, get message info
723: *****************************************************************************/
724: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
725: , p_data => x_msg_data
726: );
956: l_ItemKey VARCHAR2(100);
957:
958: BEGIN
959: /*****************************************************************************
960: ** Standard call to check for call compatibility
961: *****************************************************************************/
962: IF NOT FND_API.Compatible_API_Call( l_api_version
963: , p_api_version
964: , l_api_name
1066: , itemkey => l_ItemKey
1067: );
1068:
1069: /***************************************************************************
1070: ** Standard check of p_commit (WF won't start until commited..)
1071: ***************************************************************************/
1072: IF FND_API.To_Boolean(p_commit)
1073: THEN
1074: COMMIT WORK;
1074: COMMIT WORK;
1075: END IF;
1076:
1077: /*****************************************************************************
1078: ** Standard call to get message count and if count is > 1, get message info
1079: *****************************************************************************/
1080: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1081: , p_data => x_msg_data
1082: );
1260: , X_GROUP_NUMBER => l_GroupNumber
1261: );
1262:
1263: /*************************************************************************
1264: ** Standard call to get message count and if count is 1, get message info
1265: *************************************************************************/
1266: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1267: , p_data => l_msg_data
1268: );
1317: , X_GROUP_USAGE_ID => l_GroupUsageID
1318: );
1319:
1320: /***************************************************************************
1321: ** Standard call to get message count and if count is 1, get message info
1322: ***************************************************************************/
1323: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
1324: , p_data => l_msg_data
1325: );
1494: AND jtb.task_id = b_TaskID;
1495:
1496: BEGIN
1497: /*****************************************************************************
1498: ** Standard call to check for call compatibility
1499: *****************************************************************************/
1500: IF NOT FND_API.Compatible_API_Call( l_api_version
1501: , p_api_version
1502: , l_api_name
1626: );
1627:
1628:
1629: /***************************************************************************
1630: ** Standard check of p_commit (WF won't start until commited)
1631: ***************************************************************************/
1632: IF FND_API.To_Boolean(p_commit)
1633: THEN
1634: COMMIT WORK;
1637:
1638: END LOOP ASSIGNEES;
1639:
1640: /*****************************************************************************
1641: ** Standard call to get message count and if count is > 1, get message info
1642: *****************************************************************************/
1643: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1644: , p_data => x_msg_data
1645: );
1743: AND jta.resource_type_code = b_INVITEE_TYPE ;
1744:
1745: BEGIN
1746: /*****************************************************************************
1747: ** Standard call to check for call compatibility
1748: *****************************************************************************/
1749: IF NOT FND_API.Compatible_API_Call( l_api_version
1750: , p_api_version
1751: , l_api_name
1875: );
1876:
1877:
1878: /***************************************************************************
1879: ** Standard check of p_commit (WF won't start until commited)
1880: ***************************************************************************/
1881: IF FND_API.To_Boolean(p_commit)
1882: THEN
1883: COMMIT WORK;
1886:
1887: END LOOP ASSIGNEES;
1888:
1889: /*****************************************************************************
1890: ** Standard call to get message count and if count is > 1, get message info
1891: *****************************************************************************/
1892: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1893: , p_data => x_msg_data
1894: );
2281: l_AdminWFRole VARCHAR2(30);
2282:
2283: BEGIN
2284: /*****************************************************************************
2285: ** Standard call to check for call compatibility
2286: *****************************************************************************/
2287: IF NOT FND_API.Compatible_API_Call( l_api_version
2288: , p_api_version
2289: , l_api_name
2366: , reminder_wf_item_key = l_ItemKey
2367: WHERE task_id = p_TaskID;
2368:
2369: /***************************************************************************
2370: ** Standard check of p_commit (WF won't start until commited)
2371: ***************************************************************************/
2372: IF FND_API.To_Boolean(p_commit)
2373: THEN
2374: COMMIT WORK;
2374: COMMIT WORK;
2375: END IF;
2376:
2377: /*****************************************************************************
2378: ** Standard call to get message count and if count is > 1, get message info
2379: *****************************************************************************/
2380: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2381: , p_data => x_msg_data
2382: );
2711:
2712:
2713: BEGIN
2714: /*****************************************************************************
2715: ** Standard call to check for call compatibility
2716: *****************************************************************************/
2717: IF NOT FND_API.Compatible_API_Call( l_api_version
2718: , p_api_version
2719: , l_api_name
2779: );
2780: END IF;
2781:
2782: /***************************************************************************
2783: ** Standard check of p_commit (WF won't start until commited)
2784: ***************************************************************************/
2785: IF FND_API.To_Boolean(p_commit)
2786: THEN
2787: COMMIT WORK;
2799:
2800: END LOOP ASSIGNEES;
2801:
2802: /*****************************************************************************
2803: ** Standard call to get message count and if count is > 1, get message info
2804: *****************************************************************************/
2805: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
2806: , p_data => x_msg_data
2807: );