DBA Data[Home] [Help]

APPS.CN_RATE_DIMENSIONS_PVT dependencies on STANDARD

Line 189: -- Standard Start of API savepoint

185: l_note_msg VARCHAR2(240);
186: l_note_id NUMBER;
187:
188: BEGIN
189: -- Standard Start of API savepoint
190: SAVEPOINT Create_Dimension;
191: -- Standard call to check for call compatibility.
192: IF NOT FND_API.Compatible_API_Call
193: (l_api_version ,

Line 191: -- Standard call to check for call compatibility.

187:
188: BEGIN
189: -- Standard Start of API savepoint
190: SAVEPOINT Create_Dimension;
191: -- Standard call to check for call compatibility.
192: IF NOT FND_API.Compatible_API_Call
193: (l_api_version ,
194: p_api_version ,
195: l_api_name ,

Line 295: -- Standard check of p_commit.

291: -- ************ End - This code is not required in R12 *****************
292: -- *********************************************************************
293: -- End of API body.
294:
295: -- Standard check of p_commit.
296: IF FND_API.To_Boolean( p_commit ) THEN
297: COMMIT WORK;
298: END IF;
299: -- Standard call to get message count and if count is 1, get message info.

Line 299: -- Standard call to get message count and if count is 1, get message info.

295: -- Standard check of p_commit.
296: IF FND_API.To_Boolean( p_commit ) THEN
297: COMMIT WORK;
298: END IF;
299: -- Standard call to get message count and if count is 1, get message info.
300: FND_MSG_PUB.Count_And_Get
301: (p_count => x_msg_count ,
302: p_data => x_msg_data ,
303: p_encoded => FND_API.G_FALSE );

Line 400: -- Standard Start of API savepoint

396: SELECT rate_dim_tier_id
397: FROM cn_rate_dim_tiers
398: WHERE rate_dimension_id = p_rate_dimension_id;
399: BEGIN
400: -- Standard Start of API savepoint
401: SAVEPOINT Update_Dimension;
402: -- Standard call to check for call compatibility.
403: IF NOT FND_API.Compatible_API_Call
404: (l_api_version ,

Line 402: -- Standard call to check for call compatibility.

398: WHERE rate_dimension_id = p_rate_dimension_id;
399: BEGIN
400: -- Standard Start of API savepoint
401: SAVEPOINT Update_Dimension;
402: -- Standard call to check for call compatibility.
403: IF NOT FND_API.Compatible_API_Call
404: (l_api_version ,
405: p_api_version ,
406: l_api_name ,

Line 632: -- Standard check of p_commit.

628: -- *********************************************************************
629:
630: -- End of API body.
631:
632: -- Standard check of p_commit.
633: IF FND_API.To_Boolean( p_commit ) THEN
634: COMMIT WORK;
635: END IF;
636: -- Standard call to get message count and if count is 1, get message info.

Line 636: -- Standard call to get message count and if count is 1, get message info.

632: -- Standard check of p_commit.
633: IF FND_API.To_Boolean( p_commit ) THEN
634: COMMIT WORK;
635: END IF;
636: -- Standard call to get message count and if count is 1, get message info.
637: FND_MSG_PUB.count_and_get
638: (p_count => x_msg_count ,
639: p_data => x_msg_data ,
640: p_encoded => FND_API.G_FALSE );

Line 704: -- Standard Start of API savepoint

700: WHERE exists (SELECT 1
701: FROM cn_rate_sch_dims
702: WHERE rate_dimension_id = p_rate_dimension_id);
703: BEGIN
704: -- Standard Start of API savepoint
705: SAVEPOINT Delete_Dimension;
706: -- Standard call to check for call compatibility.
707: IF NOT FND_API.Compatible_API_Call
708: (l_api_version ,

Line 706: -- Standard call to check for call compatibility.

702: WHERE rate_dimension_id = p_rate_dimension_id);
703: BEGIN
704: -- Standard Start of API savepoint
705: SAVEPOINT Delete_Dimension;
706: -- Standard call to check for call compatibility.
707: IF NOT FND_API.Compatible_API_Call
708: (l_api_version ,
709: p_api_version ,
710: l_api_name ,

Line 777: -- Standard check of p_commit.

773: -- ************ End - R12 Notes History ********************************
774: -- *********************************************************************
775: -- End of API body.
776:
777: -- Standard check of p_commit.
778: IF FND_API.To_Boolean( p_commit ) THEN
779: COMMIT WORK;
780: END IF;
781: -- Standard call to get message count and if count is 1, get message info.

Line 781: -- Standard call to get message count and if count is 1, get message info.

777: -- Standard check of p_commit.
778: IF FND_API.To_Boolean( p_commit ) THEN
779: COMMIT WORK;
780: END IF;
781: -- Standard call to get message count and if count is 1, get message info.
782: FND_MSG_PUB.count_and_get
783: (p_count => x_msg_count ,
784: p_data => x_msg_data ,
785: p_encoded => FND_API.G_FALSE );

Line 876: -- Standard Start of API savepoint

872:
873: l_old_rec get_old_rec%ROWTYPE;
874:
875: BEGIN
876: -- Standard Start of API savepoint
877: SAVEPOINT Delete_Tier;
878: -- Standard call to check for call compatibility.
879: IF NOT FND_API.Compatible_API_Call
880: (l_api_version ,

Line 878: -- Standard call to check for call compatibility.

874:
875: BEGIN
876: -- Standard Start of API savepoint
877: SAVEPOINT Delete_Tier;
878: -- Standard call to check for call compatibility.
879: IF NOT FND_API.Compatible_API_Call
880: (l_api_version ,
881: p_api_version ,
882: l_api_name ,

Line 1008: -- Standard check of p_commit.

1004: WHERE rate_dimension_id = l_rate_dimension_id;
1005:
1006: -- End of API body.
1007:
1008: -- Standard check of p_commit.
1009: IF FND_API.To_Boolean( p_commit ) THEN
1010: COMMIT WORK;
1011: END IF;
1012: -- Standard call to get message count and if count is 1, get message info.

Line 1012: -- Standard call to get message count and if count is 1, get message info.

1008: -- Standard check of p_commit.
1009: IF FND_API.To_Boolean( p_commit ) THEN
1010: COMMIT WORK;
1011: END IF;
1012: -- Standard call to get message count and if count is 1, get message info.
1013: FND_MSG_PUB.Count_And_Get
1014: (p_count => x_msg_count ,
1015: p_data => x_msg_data ,
1016: p_encoded => FND_API.G_FALSE );

Line 1091: -- Standard Start of API savepoint

1087: l_old_rec get_old_rec%ROWTYPE;
1088:
1089:
1090: BEGIN
1091: -- Standard Start of API savepoint
1092: SAVEPOINT Update_tier;
1093: -- Standard call to check for call compatibility.
1094: IF NOT FND_API.Compatible_API_Call
1095: (l_api_version ,

Line 1093: -- Standard call to check for call compatibility.

1089:
1090: BEGIN
1091: -- Standard Start of API savepoint
1092: SAVEPOINT Update_tier;
1093: -- Standard call to check for call compatibility.
1094: IF NOT FND_API.Compatible_API_Call
1095: (l_api_version ,
1096: p_api_version ,
1097: l_api_name ,

Line 1221: -- Standard check of p_commit.

1217: -- *********************************************************************
1218:
1219: -- End of API body.
1220:
1221: -- Standard check of p_commit.
1222: IF FND_API.To_Boolean( p_commit ) THEN
1223: COMMIT WORK;
1224: END IF;
1225: -- Standard call to get message count and if count is 1, get message info.

Line 1225: -- Standard call to get message count and if count is 1, get message info.

1221: -- Standard check of p_commit.
1222: IF FND_API.To_Boolean( p_commit ) THEN
1223: COMMIT WORK;
1224: END IF;
1225: -- Standard call to get message count and if count is 1, get message info.
1226: FND_MSG_PUB.Count_And_Get
1227: (p_count => x_msg_count ,
1228: p_data => x_msg_data ,
1229: p_encoded => FND_API.G_FALSE );

Line 1309: -- Standard Start of API savepoint

1305: SELECT rate_schedule_id
1306: FROM cn_rate_sch_dims
1307: WHERE rate_dimension_id = p_rate_dimension_id;
1308: BEGIN
1309: -- Standard Start of API savepoint
1310: SAVEPOINT Create_tier;
1311: -- Standard call to check for call compatibility.
1312: IF NOT FND_API.Compatible_API_Call
1313: (l_api_version ,

Line 1311: -- Standard call to check for call compatibility.

1307: WHERE rate_dimension_id = p_rate_dimension_id;
1308: BEGIN
1309: -- Standard Start of API savepoint
1310: SAVEPOINT Create_tier;
1311: -- Standard call to check for call compatibility.
1312: IF NOT FND_API.Compatible_API_Call
1313: (l_api_version ,
1314: p_api_version ,
1315: l_api_name ,

Line 1442: -- Standard check of p_commit.

1438: WHERE rate_dimension_id = p_rate_dimension_id;
1439:
1440: -- End of API body.
1441:
1442: -- Standard check of p_commit.
1443: IF FND_API.To_Boolean( p_commit ) THEN
1444: COMMIT WORK;
1445: END IF;
1446: -- Standard call to get message count and if count is 1, get message info.

Line 1446: -- Standard call to get message count and if count is 1, get message info.

1442: -- Standard check of p_commit.
1443: IF FND_API.To_Boolean( p_commit ) THEN
1444: COMMIT WORK;
1445: END IF;
1446: -- Standard call to get message count and if count is 1, get message info.
1447: FND_MSG_PUB.Count_And_Get
1448: (p_count => x_msg_count ,
1449: p_data => x_msg_data ,
1450: p_encoded => FND_API.G_FALSE );