523: AND salesrep_id = p_salesrep_id
524: AND org_id = p_paygroup_assign_rec.org_id;
525:
526: BEGIN
527: -- Standard Start of API savepoint
528:
529: SAVEPOINT Create_Srp_Pay_Group;
530:
531: -- Standard call to check for call compatibility.
527: -- Standard Start of API savepoint
528:
529: SAVEPOINT Create_Srp_Pay_Group;
530:
531: -- Standard call to check for call compatibility.
532:
533: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
534: p_api_version ,
535: l_api_name ,
755: END LOOP;
756:
757: -- End of API body
758:
759: -- Standard check of p_commit.
760:
761: IF FND_API.To_Boolean( p_commit ) THEN
762: COMMIT WORK;
763: END IF;
761: IF FND_API.To_Boolean( p_commit ) THEN
762: COMMIT WORK;
763: END IF;
764:
765: -- Standard call to get message count and if count is 1, get message info
766: FND_MSG_PUB.Count_And_Get
767: (
768: p_count => x_msg_count ,
769: p_data => x_msg_data ,
880:
881:
882:
883: BEGIN
884: -- Standard Start of API savepoint
885:
886: SAVEPOINT Update_Srp_Pay_Group;
887:
888: -- Standard call to check for call compatibility.
884: -- Standard Start of API savepoint
885:
886: SAVEPOINT Update_Srp_Pay_Group;
887:
888: -- Standard call to check for call compatibility.
889:
890: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
891: p_api_version ,
892: l_api_name ,
1310: END LOOP;
1311:
1312: -- End of API body
1313:
1314: -- Standard check of p_commit.
1315:
1316: IF FND_API.To_Boolean( p_commit ) THEN
1317: COMMIT WORK;
1318: END IF;
1316: IF FND_API.To_Boolean( p_commit ) THEN
1317: COMMIT WORK;
1318: END IF;
1319:
1320: -- Standard call to get message count and if count is 1, get message info
1321: FND_MSG_PUB.Count_And_Get
1322: (
1323: p_count => x_msg_count ,
1324: p_data => x_msg_data ,
1623:
1624:
1625:
1626: BEGIN
1627: -- Standard Start of API savepoint
1628:
1629: SAVEPOINT Delete_Srp_Pay_Group;
1630:
1631: -- Standard call to check for call compatibility.
1627: -- Standard Start of API savepoint
1628:
1629: SAVEPOINT Delete_Srp_Pay_Group;
1630:
1631: -- Standard call to check for call compatibility.
1632:
1633: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1634: p_api_version ,
1635: l_api_name ,
1769:
1770:
1771: -- End of API body
1772:
1773: -- Standard check of p_commit.
1774:
1775:
1776: IF FND_API.To_Boolean( p_commit ) THEN
1777: COMMIT WORK;
1777: COMMIT WORK;
1778: END IF;
1779:
1780:
1781: -- Standard call to get message count and if count is 1, get message info.
1782:
1783: FND_MSG_PUB.Count_And_Get
1784: (
1785: p_count => x_msg_count ,