[Home] [Help]
507: l_quota_csr c_quota_csr%ROWTYPE;
508: l_srp_plan_assign_id cn_srp_plan_assigns.srp_plan_assign_id%TYPE;
509:
510: BEGIN
511: -- Standard Start of API savepoint
512: SAVEPOINT Create_Srp_Periods;
513: -- Standard call to check for call compatibility.
514: IF NOT FND_API.compatible_api_call
515: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
509:
510: BEGIN
511: -- Standard Start of API savepoint
512: SAVEPOINT Create_Srp_Periods;
513: -- Standard call to check for call compatibility.
514: IF NOT FND_API.compatible_api_call
515: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
516: RAISE FND_API.g_exc_unexpected_error;
517: END IF ;
688: END IF;
689: end loop; -- credit types
690:
691: -- End of API body.
692: -- Standard check of p_commit.
693: IF FND_API.To_Boolean( p_commit ) THEN
694: COMMIT WORK;
695: END IF;
696: -- Standard call to get message count and if count is 1, get message info.
692: -- Standard check of p_commit.
693: IF FND_API.To_Boolean( p_commit ) THEN
694: COMMIT WORK;
695: END IF;
696: -- Standard call to get message count and if count is 1, get message info.
697: FND_MSG_PUB.Count_And_Get
698: (
699: p_count => x_msg_count ,
700: p_data => x_msg_data ,
780: l_api_name CONSTANT VARCHAR2(30) := 'Update_Delta_Srp_Pds_No_Sync';
781: l_api_version CONSTANT NUMBER := 1.0;
782:
783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT Update_Delta_Srp_Pds_No_Sync;
786: -- Standard call to check for call compatibility.
787: IF NOT FND_API.compatible_api_call
788: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
782:
783: BEGIN
784: -- Standard Start of API savepoint
785: SAVEPOINT Update_Delta_Srp_Pds_No_Sync;
786: -- Standard call to check for call compatibility.
787: IF NOT FND_API.compatible_api_call
788: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
789: RAISE FND_API.g_exc_unexpected_error;
790: END IF ;
822: Nvl(p_del_srp_prd_rec.del_balance5_dtd,0))
823: WHERE srp_period_id = p_del_srp_prd_rec.srp_period_id;
824:
825: -- End of API body.
826: -- Standard check of p_commit.
827: IF FND_API.To_Boolean( p_commit ) THEN
828: COMMIT WORK;
829: END IF;
830: -- Standard call to get message count and if count is 1, get message info.
826: -- Standard check of p_commit.
827: IF FND_API.To_Boolean( p_commit ) THEN
828: COMMIT WORK;
829: END IF;
830: -- Standard call to get message count and if count is 1, get message info.
831: FND_MSG_PUB.Count_And_Get
832: (
833: p_count => x_msg_count ,
834: p_data => x_msg_data ,
897: l_credit_type_id NUMBER;
898: l_org_id NUMBER;
899:
900: BEGIN
901: -- Standard Start of API savepoint
902: SAVEPOINT Update_Delta_Srp_Periods;
903: -- Standard call to check for call compatibility.
904: IF NOT FND_API.compatible_api_call
905: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
899:
900: BEGIN
901: -- Standard Start of API savepoint
902: SAVEPOINT Update_Delta_Srp_Periods;
903: -- Standard call to check for call compatibility.
904: IF NOT FND_API.compatible_api_call
905: (l_api_version,p_api_version,l_api_name,g_pkg_name) THEN
906: RAISE FND_API.g_exc_unexpected_error;
907: END IF ;
947: -- populate begin balance columns and summary records
948: Sync_Accum_Balances(l_salesrep_id, l_org_id, l_credit_type_id, l_role_id);
949:
950: -- End of API body.
951: -- Standard check of p_commit.
952: IF FND_API.To_Boolean( p_commit ) THEN
953: COMMIT WORK;
954: END IF;
955: -- Standard call to get message count and if count is 1, get message info.
951: -- Standard check of p_commit.
952: IF FND_API.To_Boolean( p_commit ) THEN
953: COMMIT WORK;
954: END IF;
955: -- Standard call to get message count and if count is 1, get message info.
956: FND_MSG_PUB.Count_And_Get
957: (
958: p_count => x_msg_count ,
959: p_data => x_msg_data ,