[Home] [Help]
44: l_api_name CONSTANT VARCHAR2(30) := 'Create_product_task';
45: l_api_version_number CONSTANT NUMBER := 1.0;
46: l_pvt_PROD_TASK_rec CSP_PRODUCT_TASK_PVT.PROD_TASK_Rec_Type;
47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT CREATE_PRODUCT_TASK_PUB;
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
52: p_api_version_number,
46: l_pvt_PROD_TASK_rec CSP_PRODUCT_TASK_PVT.PROD_TASK_Rec_Type;
47: BEGIN
48: -- Standard Start of API savepoint
49: SAVEPOINT CREATE_PRODUCT_TASK_PUB;
50: -- Standard call to check for call compatibility.
51: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
52: p_api_version_number,
53: l_api_name,
54: G_PKG_NAME)
66: -- API body
67: --
68: -- Un-comment the following statements when user hooks is ready.
69: /*
70: -- USER HOOKS standard : customer pre-processing section - mandatory
71: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Create_product_task','B','C'))
72: THEN
73: AS_product_task_CUHK.Create_product_task_Pre(
74: p_api_version_number => 1.0,
89: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
90: RAISE fnd_api.g_exc_unexpected_error;
91: END IF;
92: END IF;
93: -- USER HOOKS standard : vertical industry pre-processing section - mandatory
94: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Create_product_task','B','V'))
95: THEN
96: AS_product_task_VUHK.Create_product_task_Pre(
97: p_api_version_number => 1.0,
134: END IF;
135: --
136: -- End of API body.
137: --
138: -- Standard check for p_commit
139: IF FND_API.to_Boolean( p_commit )
140: THEN
141: COMMIT WORK;
142: END IF;
139: IF FND_API.to_Boolean( p_commit )
140: THEN
141: COMMIT WORK;
142: END IF;
143: -- Standard call to get message count and if count is 1, get message info.
144: FND_MSG_PUB.Count_And_Get
145: ( p_count => x_msg_count,
146: p_data => x_msg_data
147: );
146: p_data => x_msg_data
147: );
148: -- Un-comment the following statements when user hooks is ready.
149: /*
150: -- USER HOOK standard : vertical industry post-processing section - mandatory
151: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Create_product_task','A','V'))
152: THEN
153: AS_product_task_VUHK.Create_product_task_Post(
154: p_api_version_number => 1.0,
165: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
166: RAISE fnd_api.g_exc_unexpected_error;
167: END IF;
168: END IF;
169: -- USER HOOKS standard : customer pre-processing section - mandatory
170: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Create_product_task','A','C'))
171: THEN
172: AS_product_task_CUHK.Create_product_task_Pre(
173: p_api_version_number => 1.0,
236: l_api_name CONSTANT VARCHAR2(30) := 'Update_product_task';
237: l_api_version_number CONSTANT NUMBER := 1.0;
238: l_pvt_PROD_TASK_rec CSP_PRODUCT_TASK_PVT.PROD_TASK_Rec_Type;
239: BEGIN
240: -- Standard Start of API savepoint
241: SAVEPOINT UPDATE_PRODUCT_TASK_PUB;
242: -- Standard call to check for call compatibility.
243: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
244: p_api_version_number,
238: l_pvt_PROD_TASK_rec CSP_PRODUCT_TASK_PVT.PROD_TASK_Rec_Type;
239: BEGIN
240: -- Standard Start of API savepoint
241: SAVEPOINT UPDATE_PRODUCT_TASK_PUB;
242: -- Standard call to check for call compatibility.
243: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
244: p_api_version_number,
245: l_api_name,
246: G_PKG_NAME)
258: -- API body
259: --
260: -- Un-comment the following statements when user hooks is ready.
261: /*
262: -- USER HOOKS standard : customer pre-processing section - mandatory
263: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Update_product_task','B','C'))
264: THEN
265: AS_product_task_CUHK.Update_product_task_Pre(
266: p_api_version_number => 1.0,
281: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
282: RAISE fnd_api.g_exc_unexpected_error;
283: END IF;
284: END IF;
285: -- USER HOOKS standard : vertical industry pre-processing section - mandatory
286: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Update_product_task','B','V'))
287: THEN
288: AS_product_task_VUHK.Update_product_task_Pre(
289: p_api_version_number => 1.0,
322: END IF;
323: --
324: -- End of API body
325: --
326: -- Standard check for p_commit
327: IF FND_API.to_Boolean( p_commit )
328: THEN
329: COMMIT WORK;
330: END IF;
327: IF FND_API.to_Boolean( p_commit )
328: THEN
329: COMMIT WORK;
330: END IF;
331: -- Standard call to get message count and if count is 1, get message info.
332: FND_MSG_PUB.Count_And_Get
333: ( p_count => x_msg_count,
334: p_data => x_msg_data
335: );
334: p_data => x_msg_data
335: );
336: -- Un-comment the following statements when user hooks is ready.
337: /*
338: -- USER HOOK standard : vertical industry post-processing section - mandatory
339: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Update_product_task','A','V'))
340: THEN
341: AS_product_task_VUHK.Update_product_task_Post(
342: p_api_version_number => 1.0,
357: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
358: RAISE fnd_api.g_exc_unexpected_error;
359: END IF;
360: END IF;
361: -- USER HOOKS standard : customer pre-processing section - mandatory
362: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Update_product_task','A','C'))
363: THEN
364: AS_product_task_CUHK.Update_product_task_Pre(
365: p_api_version_number => 1.0,
429: l_api_name CONSTANT VARCHAR2(30) := 'Delete_product_task';
430: l_api_version_number CONSTANT NUMBER := 1.0;
431: l_pvt_PROD_TASK_rec CSP_PRODUCT_TASK_PVT.PROD_TASK_Rec_Type;
432: BEGIN
433: -- Standard Start of API savepoint
434: SAVEPOINT DELETE_PRODUCT_TASK_PUB;
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
437: p_api_version_number,
431: l_pvt_PROD_TASK_rec CSP_PRODUCT_TASK_PVT.PROD_TASK_Rec_Type;
432: BEGIN
433: -- Standard Start of API savepoint
434: SAVEPOINT DELETE_PRODUCT_TASK_PUB;
435: -- Standard call to check for call compatibility.
436: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
437: p_api_version_number,
438: l_api_name,
439: G_PKG_NAME)
460: X_Msg_Count => x_msg_count,
461: X_Msg_Data => x_msg_data);
462: -- Un-comment the following statements when user hooks is ready.
463: /*
464: -- USER HOOKS standard : customer pre-processing section - mandatory
465: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Delete_product_task','B','C'))
466: THEN
467: AS_product_task_CUHK.Delete_product_task_Pre(
468: p_api_version_number => 1.0,
483: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
484: RAISE fnd_api.g_exc_unexpected_error;
485: END IF;
486: END IF;
487: -- USER HOOKS standard : vertical industry pre-processing section - mandatory
488: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Delete_product_task','B','V'))
489: THEN
490: AS_product_task_VUHK.Delete_product_task_Pre(
491: p_api_version_number => 1.0,
515: END IF;
516: --
517: -- End of API body
518: --
519: -- Standard check for p_commit
520: IF FND_API.to_Boolean( p_commit )
521: THEN
522: COMMIT WORK;
523: END IF;
520: IF FND_API.to_Boolean( p_commit )
521: THEN
522: COMMIT WORK;
523: END IF;
524: -- Standard call to get message count and if count is 1, get message info.
525: FND_MSG_PUB.Count_And_Get
526: ( p_count => x_msg_count,
527: p_data => x_msg_data
528: );
527: p_data => x_msg_data
528: );
529: -- Un-comment the following statements when user hooks is ready.
530: /*
531: -- USER HOOK standard : vertical industry post-processing section - mandatory
532: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Delete_product_task','A','V'))
533: THEN
534: AS_product_task_VUHK.Delete_product_task_Post(
535: p_api_version_number => 1.0,
546: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
547: RAISE fnd_api.g_exc_unexpected_error;
548: END IF;
549: END IF;
550: -- USER HOOKS standard : customer pre-processing section - mandatory
551: IF(JTF_USR_HKS.Ok_to_execute('AS_product_task_PUB', 'Delete_product_task','A','C'))
552: THEN
553: AS_product_task_CUHK.Delete_product_task_Pre(
554: p_api_version_number => 1.0,
626: IS
627: l_api_name CONSTANT VARCHAR2(30) := 'Get_product_task';
628: l_api_version_number CONSTANT NUMBER := 1.0;
629: BEGIN
630: -- Standard Start of API savepoint
631: SAVEPOINT GET_PRODUCT_TASK_PUB;
632: -- Standard call to check for call compatibility.
633: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
634: p_api_version_number,
628: l_api_version_number CONSTANT NUMBER := 1.0;
629: BEGIN
630: -- Standard Start of API savepoint
631: SAVEPOINT GET_PRODUCT_TASK_PUB;
632: -- Standard call to check for call compatibility.
633: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
634: p_api_version_number,
635: l_api_name,
636: G_PKG_NAME)
676: */
677: --
678: -- End of API body
679: --
680: -- Standard call to get message count and if count is 1, get message info.
681: FND_MSG_PUB.Count_And_Get
682: ( p_count => x_msg_count,
683: p_data => x_msg_data
684: );