163: WHERE p.project_id = p_pa_project_id;
164:
165: BEGIN
166:
167: -- Standard begin of API savepoint
168:
169: SAVEPOINT add_key_members_pvt;
170:
171:
668:
669: BEGIN
670:
671:
672: -- Standard begin of API savepoint
673:
674: SAVEPOINT add_class_categories_pvt;
675:
676:
1312: SELECT customer_id FROM pa_tasks WHERE task_id=l_p_parent_task_id;
1313:
1314: BEGIN
1315:
1316: -- Standard begin of API savepoint
1317:
1318: SAVEPOINT add_task_round_one_pvt;
1319:
1320:
2726: WHERE p.task_id = p_pa_task_id;
2727:
2728: BEGIN
2729:
2730: -- Standard begin of API savepoint
2731:
2732: SAVEPOINT add_task_round_two_pvt;
2733:
2734:
5426: l_attribute10 VARCHAR2(150);
5427: l_project_type2 VARCHAR2(20);-- for bug 7403227
5428: BEGIN
5429:
5430: -- Standard begin of API savepoint
5431:
5432: SAVEPOINT update_task_pub;
5433:
5434: -- Standard call to check for call compatibility.
5430: -- Standard begin of API savepoint
5431:
5432: SAVEPOINT update_task_pub;
5433:
5434: -- Standard call to check for call compatibility.
5435:
5436: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
5437: p_api_version_number ,
5438: l_api_name ,
9280:
9281: BEGIN
9282:
9283:
9284: -- Standard begin of API savepoint
9285:
9286: SAVEPOINT delete_task_pub;
9287:
9288: -- Standard call to check for call compatibility.
9284: -- Standard begin of API savepoint
9285:
9286: SAVEPOINT delete_task_pub;
9287:
9288: -- Standard call to check for call compatibility.
9289:
9290: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
9291: p_api_version_number ,
9292: l_api_name ,
9948: l_module_name VARCHAR2(80);
9949:
9950: BEGIN
9951:
9952: -- Standard begin of API savepoint
9953:
9954: SAVEPOINT delete_project_pub;
9955:
9956: -- Standard call to check for call compatibility.
9952: -- Standard begin of API savepoint
9953:
9954: SAVEPOINT delete_project_pub;
9955:
9956: -- Standard call to check for call compatibility.
9957:
9958: IF NOT FND_API.Compatible_API_Call ( g_api_version_number ,
9959: p_api_version_number ,
9960: l_api_name ,
10393: WHERE p.project_id = p_pa_project_id;
10394:
10395: BEGIN
10396:
10397: -- Standard begin of API savepoint
10398:
10399: SAVEPOINT add_org_roles_pvt;
10400:
10401: