47:
48: l_attain_schedule_id NUMBER;
49: l_temp_count NUMBER;
50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT Create_Attain_Schedule;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call
55: (l_api_version ,
49: l_temp_count NUMBER;
50: BEGIN
51: -- Standard Start of API savepoint
52: SAVEPOINT Create_Attain_Schedule;
53: -- Standard call to check for call compatibility.
54: IF NOT FND_API.Compatible_API_Call
55: (l_api_version ,
56: p_api_version ,
57: l_api_name ,
127: X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
128: );
129:
130: -- End of API body.
131: -- Standard check of p_commit.
132: IF FND_API.To_Boolean( p_commit ) THEN
133: COMMIT WORK;
134: END IF;
135: -- Standard call to get message count and if count is 1, get message info.
131: -- Standard check of p_commit.
132: IF FND_API.To_Boolean( p_commit ) THEN
133: COMMIT WORK;
134: END IF;
135: -- Standard call to get message count and if count is 1, get message info.
136: FND_MSG_PUB.Count_And_Get
137: (p_count => x_msg_count ,
138: p_data => x_msg_data ,
139: p_encoded => FND_API.G_FALSE );
217: WHERE attain_schedule_id = p_attain_schedule.attain_schedule_id;
218:
219: l_old_attain_schedule l_old_attain_schedule_cr%ROWTYPE;
220: BEGIN
221: -- Standard Start of API savepoint
222: SAVEPOINT Update_Attain_Schedule;
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call
225: (l_api_version ,
219: l_old_attain_schedule l_old_attain_schedule_cr%ROWTYPE;
220: BEGIN
221: -- Standard Start of API savepoint
222: SAVEPOINT Update_Attain_Schedule;
223: -- Standard call to check for call compatibility.
224: IF NOT FND_API.Compatible_API_Call
225: (l_api_version ,
226: p_api_version ,
227: l_api_name ,
303: X_LAST_UPDATE_LOGIN => G_LAST_UPDATE_LOGIN
304: );
305:
306: -- End of API body.
307: -- Standard check of p_commit.
308: IF FND_API.To_Boolean( p_commit ) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
307: -- Standard check of p_commit.
308: IF FND_API.To_Boolean( p_commit ) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard call to get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get
313: (p_count => x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => FND_API.G_FALSE );
388: l_temp_attain_tier CN_ATTAIN_TIER_PVT.attain_tier_rec_type;
389: l_temp_count NUMBER;
390:
391: BEGIN
392: -- Standard Start of API savepoint
393: SAVEPOINT Delete_Attain_Schedule;
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call
396: (l_api_version ,
390:
391: BEGIN
392: -- Standard Start of API savepoint
393: SAVEPOINT Delete_Attain_Schedule;
394: -- Standard call to check for call compatibility.
395: IF NOT FND_API.Compatible_API_Call
396: (l_api_version ,
397: p_api_version ,
398: l_api_name ,
449:
450: END LOOP;
451:
452: -- End of API body.
453: -- Standard check of p_commit.
454: IF FND_API.To_Boolean( p_commit ) THEN
455: COMMIT WORK;
456: END IF;
457: -- Standard call to get message count and if count is 1, get message info.
453: -- Standard check of p_commit.
454: IF FND_API.To_Boolean( p_commit ) THEN
455: COMMIT WORK;
456: END IF;
457: -- Standard call to get message count and if count is 1, get message info.
458: FND_MSG_PUB.Count_And_Get
459: (p_count => x_msg_count ,
460: p_data => x_msg_data ,
461: p_encoded => FND_API.G_FALSE );
535:
536: l_attain_schedule l_attain_schedule_cr%ROWTYPE;
537:
538: BEGIN
539: -- Standard Start of API savepoint
540: SAVEPOINT Get_Attain_Schedule;
541: -- Standard call to check for call compatibility.
542: IF NOT FND_API.Compatible_API_Call
543: (l_api_version ,
537:
538: BEGIN
539: -- Standard Start of API savepoint
540: SAVEPOINT Get_Attain_Schedule;
541: -- Standard call to check for call compatibility.
542: IF NOT FND_API.Compatible_API_Call
543: (l_api_version ,
544: p_api_version ,
545: l_api_name ,
578:
579: CLOSE l_attain_schedule_cr;
580:
581: -- End of API body.
582: -- Standard check of p_commit.
583: IF FND_API.To_Boolean( p_commit ) THEN
584: COMMIT WORK;
585: END IF;
586: -- Standard call to get message count and if count is 1, get message info.
582: -- Standard check of p_commit.
583: IF FND_API.To_Boolean( p_commit ) THEN
584: COMMIT WORK;
585: END IF;
586: -- Standard call to get message count and if count is 1, get message info.
587: FND_MSG_PUB.Count_And_Get
588: (p_count => x_msg_count ,
589: p_data => x_msg_data ,
590: p_encoded => FND_API.G_FALSE );