DBA Data[Home] [Help]

APPS.CN_ATTAIN_TIER_PVT dependencies on STANDARD

Line 53: -- Standard Start of API savepoint

49: l_current_seq NUMBER;
50: l_assign_seq NUMBER;
51: l_temp_count NUMBER;
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT Create_Attain_Tier;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call
57: (l_api_version ,

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

51: l_temp_count NUMBER;
52: BEGIN
53: -- Standard Start of API savepoint
54: SAVEPOINT Create_Attain_Tier;
55: -- Standard call to check for call compatibility.
56: IF NOT FND_API.Compatible_API_Call
57: (l_api_version ,
58: p_api_version ,
59: l_api_name ,

Line 144: -- Standard check of p_commit.

140: X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
141: );
142:
143: -- End of API body.
144: -- Standard check of p_commit.
145: IF FND_API.To_Boolean( p_commit ) THEN
146: COMMIT WORK;
147: END IF;
148: -- Standard call to get message count and if count is 1, get message info.

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

144: -- Standard check of p_commit.
145: IF FND_API.To_Boolean( p_commit ) THEN
146: COMMIT WORK;
147: END IF;
148: -- Standard call to get message count and if count is 1, get message info.
149: FND_MSG_PUB.Count_And_Get
150: (p_count => x_msg_count ,
151: p_data => x_msg_data ,
152: p_encoded => FND_API.G_FALSE );

Line 234: -- Standard Start of API savepoint

230: WHERE attain_tier_id = p_attain_tier.attain_tier_id;
231:
232: l_old_attain_tier l_old_attain_tier_cr%ROWTYPE;
233: BEGIN
234: -- Standard Start of API savepoint
235: SAVEPOINT Update_Attain_Tier;
236: -- Standard call to check for call compatibility.
237: IF NOT FND_API.Compatible_API_Call
238: (l_api_version ,

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

232: l_old_attain_tier l_old_attain_tier_cr%ROWTYPE;
233: BEGIN
234: -- Standard Start of API savepoint
235: SAVEPOINT Update_Attain_Tier;
236: -- Standard call to check for call compatibility.
237: IF NOT FND_API.Compatible_API_Call
238: (l_api_version ,
239: p_api_version ,
240: l_api_name ,

Line 331: -- Standard check of p_commit.

327: X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
328: );
329:
330: -- End of API body.
331: -- Standard check of p_commit.
332: IF FND_API.To_Boolean( p_commit ) THEN
333: COMMIT WORK;
334: END IF;
335: -- Standard call to get message count and if count is 1, get message info.

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

331: -- Standard check of p_commit.
332: IF FND_API.To_Boolean( p_commit ) THEN
333: COMMIT WORK;
334: END IF;
335: -- Standard call to get message count and if count is 1, get message info.
336: FND_MSG_PUB.Count_And_Get
337: (p_count => x_msg_count ,
338: p_data => x_msg_data ,
339: p_encoded => FND_API.G_FALSE );

Line 406: -- Standard Start of API savepoint

402: ) IS
403: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Attain_Tier';
404: l_api_version CONSTANT NUMBER := 1.0;
405: BEGIN
406: -- Standard Start of API savepoint
407: SAVEPOINT Delete_Attain_Tier;
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call
410: (l_api_version ,

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

404: l_api_version CONSTANT NUMBER := 1.0;
405: BEGIN
406: -- Standard Start of API savepoint
407: SAVEPOINT Delete_Attain_Tier;
408: -- Standard call to check for call compatibility.
409: IF NOT FND_API.Compatible_API_Call
410: (l_api_version ,
411: p_api_version ,
412: l_api_name ,

Line 429: -- Standard check of p_commit.

425: CN_ATTAIN_TIERS_PKG.DELETE_ROW(
426: X_ATTAIN_TIER_ID => p_attain_tier.ATTAIN_TIER_ID);
427:
428: -- End of API body.
429: -- Standard check of p_commit.
430: IF FND_API.To_Boolean( p_commit ) THEN
431: COMMIT WORK;
432: END IF;
433: -- Standard call to get message count and if count is 1, get message info.

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

429: -- Standard check of p_commit.
430: IF FND_API.To_Boolean( p_commit ) THEN
431: COMMIT WORK;
432: END IF;
433: -- Standard call to get message count and if count is 1, get message info.
434: FND_MSG_PUB.Count_And_Get
435: (p_count => x_msg_count ,
436: p_data => x_msg_data ,
437: p_encoded => FND_API.G_FALSE );

Line 518: -- Standard Start of API savepoint

514:
515: l_attain_tier l_attain_tier_cr%ROWTYPE;
516:
517: BEGIN
518: -- Standard Start of API savepoint
519: SAVEPOINT Get_Attain_Tier;
520: -- Standard call to check for call compatibility.
521: IF NOT FND_API.Compatible_API_Call
522: (l_api_version ,

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

516:
517: BEGIN
518: -- Standard Start of API savepoint
519: SAVEPOINT Get_Attain_Tier;
520: -- Standard call to check for call compatibility.
521: IF NOT FND_API.Compatible_API_Call
522: (l_api_version ,
523: p_api_version ,
524: l_api_name ,

Line 561: -- Standard check of p_commit.

557:
558: CLOSE l_attain_tier_cr;
559:
560: -- End of API body.
561: -- Standard check of p_commit.
562: IF FND_API.To_Boolean( p_commit ) THEN
563: COMMIT WORK;
564: END IF;
565: -- Standard call to get message count and if count is 1, get message info.

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

561: -- Standard check of p_commit.
562: IF FND_API.To_Boolean( p_commit ) THEN
563: COMMIT WORK;
564: END IF;
565: -- Standard call to get message count and if count is 1, get message info.
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data ,
569: p_encoded => FND_API.G_FALSE );