26: l_api_version_number CONSTANT NUMBER := 1.0;
27: l_return_status_full VARCHAR2(1);
28: l_access_flag VARCHAR2(1);
29: BEGIN
30: -- Standard Start of API savepoint
31: SAVEPOINT CREATE_PRODUCT_TASK_PVT;
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
34: p_api_version_number,
28: l_access_flag VARCHAR2(1);
29: BEGIN
30: -- Standard Start of API savepoint
31: SAVEPOINT CREATE_PRODUCT_TASK_PVT;
32: -- Standard call to check for call compatibility.
33: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
34: p_api_version_number,
35: l_api_name,
36: G_PKG_NAME)
108: END IF;
109: --
110: -- End of API body
111: --
112: -- Standard check for p_commit
113: IF FND_API.to_Boolean( p_commit )
114: THEN
115: COMMIT WORK;
116: END IF;
113: IF FND_API.to_Boolean( p_commit )
114: THEN
115: COMMIT WORK;
116: END IF;
117: -- Standard call to get message count and if count is 1, get message info.
118: FND_MSG_PUB.Count_And_Get
119: ( p_count => x_msg_count,
120: p_data => x_msg_data
121: );
203: l_ref_PROD_TASK_rec CSP_product_task_PVT.PROD_TASK_Rec_Type;
204: l_tar_PROD_TASK_rec CSP_product_task_PVT.PROD_TASK_Rec_Type := P_PROD_TASK_Rec;
205: l_rowid ROWID;
206: BEGIN
207: -- Standard Start of API savepoint
208: SAVEPOINT UPDATE_PRODUCT_TASK_PVT;
209: -- Standard call to check for call compatibility.
210: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
211: p_api_version_number,
205: l_rowid ROWID;
206: BEGIN
207: -- Standard Start of API savepoint
208: SAVEPOINT UPDATE_PRODUCT_TASK_PVT;
209: -- Standard call to check for call compatibility.
210: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
211: p_api_version_number,
212: l_api_name,
213: G_PKG_NAME)
340:
341: --
342: -- End of API body.
343: --
344: -- Standard check for p_commit
345: IF FND_API.to_Boolean( p_commit )
346: THEN
347: COMMIT WORK;
348: END IF;
345: IF FND_API.to_Boolean( p_commit )
346: THEN
347: COMMIT WORK;
348: END IF;
349: -- Standard call to get message count and if count is 1, get message info.
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );
397: IS
398: l_api_name CONSTANT VARCHAR2(30) := 'Delete_product_task';
399: l_api_version_number CONSTANT NUMBER := 1.0;
400: BEGIN
401: -- Standard Start of API savepoint
402: SAVEPOINT DELETE_PRODUCT_TASK_PVT;
403: -- Standard call to check for call compatibility.
404: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
405: p_api_version_number,
399: l_api_version_number CONSTANT NUMBER := 1.0;
400: BEGIN
401: -- Standard Start of API savepoint
402: SAVEPOINT DELETE_PRODUCT_TASK_PVT;
403: -- Standard call to check for call compatibility.
404: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
405: p_api_version_number,
406: l_api_name,
407: G_PKG_NAME)
423: p_PRODUCT_TASK_ID => p_PROD_TASK_rec.PRODUCT_TASK_ID);
424: --
425: -- End of API body
426: --
427: -- Standard check for p_commit
428: IF FND_API.to_Boolean( p_commit )
429: THEN
430: COMMIT WORK;
431: END IF;
428: IF FND_API.to_Boolean( p_commit )
429: THEN
430: COMMIT WORK;
431: END IF;
432: -- Standard call to get message count and if count is 1, get message info.
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );
707: -- verify if data is valid
708: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
709: NULL;
710: END IF;
711: -- Standard call to get message count and if count is 1, get message info.
712: FND_MSG_PUB.Count_And_Get
713: ( p_count => x_msg_count,
714: p_data => x_msg_data
715: );
751: -- verify if data is valid
752: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
753: NULL;
754: END IF;
755: -- Standard call to get message count and if count is 1, get message info.
756: FND_MSG_PUB.Count_And_Get
757: ( p_count => x_msg_count,
758: p_data => x_msg_data
759: );
795: -- verify if data is valid
796: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
797: NULL;
798: END IF;
799: -- Standard call to get message count and if count is 1, get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );
839: -- verify if data is valid
840: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
841: NULL;
842: END IF;
843: -- Standard call to get message count and if count is 1, get message info.
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );
878: -- verify if data is valid
879: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
880: NULL;
881: END IF;
882: -- Standard call to get message count and if count is 1, get message info.
883: FND_MSG_PUB.Count_And_Get
884: ( p_count => x_msg_count,
885: p_data => x_msg_data
886: );
917: -- verify if data is valid
918: -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
919: NULL;
920: END IF;
921: -- Standard call to get message count and if count is 1, get message info.
922: FND_MSG_PUB.Count_And_Get
923: ( p_count => x_msg_count,
924: p_data => x_msg_data
925: );
949: -- If data not valid
950: -- THEN
951: -- x_return_status := FND_API.G_RET_STS_ERROR;
952: -- Debug Message
953: -- Standard call to get message count and if count is 1, get message info.
954: FND_MSG_PUB.Count_And_Get
955: ( p_count => x_msg_count,
956: p_data => x_msg_data
957: );