183:
184: if exists_in_other_drivers%NOTFOUND then
185: l_dummy := 'N';
186: if p_validate_only <> FND_API.G_TRUE then
187: DELETE FROM PA_PROJECTS_ERP_EXT_B
188: WHERE PROJECT_ID = p_project_id
189: AND PROJ_ELEMENT_ID is NULL
190: AND ATTR_GROUP_ID = l_attr_group_id;
191:
209: FETCH exists_in_other_task_drivers INTO l_dummy2;
210:
211: if exists_in_other_task_drivers%NOTFOUND then
212: if p_validate_only <> FND_API.G_TRUE then
213: DELETE FROM PA_PROJECTS_ERP_EXT_B
214: WHERE PROJECT_ID = p_project_id
215: AND PROJ_ELEMENT_ID = l_proj_element_id
216: AND ATTR_GROUP_ID = l_attr_group_id;
217:
241:
242: if exists_in_other_drivers%NOTFOUND then
243: l_dummy := 'N';
244: if p_validate_only <> FND_API.G_TRUE then
245: DELETE FROM PA_PROJECTS_ERP_EXT_B
246: WHERE PROJECT_ID = p_project_id
247: AND PROJ_ELEMENT_ID is NULL
248: AND ATTR_GROUP_ID = l_attr_group_id;
249:
267: FETCH exists_in_other_task_drivers INTO l_dummy2;
268:
269: if exists_in_other_task_drivers%NOTFOUND then
270: if p_validate_only <> FND_API.G_TRUE then
271: DELETE FROM PA_PROJECTS_ERP_EXT_B
272: WHERE PROJECT_ID = p_project_id
273: AND PROJ_ELEMENT_ID = l_proj_element_id
274: AND ATTR_GROUP_ID = l_attr_group_id;
275:
299: FETCH exists_in_other_task_drivers INTO l_dummy;
300:
301: if exists_in_other_task_drivers%NOTFOUND then
302: if p_validate_only <> FND_API.G_TRUE then
303: DELETE FROM PA_PROJECTS_ERP_EXT_B
304: WHERE PROJECT_ID = p_project_id
305: AND PROJ_ELEMENT_ID = p_proj_element_id
306: AND ATTR_GROUP_ID = l_attr_group_id;
307:
386: end if;
387:
388: if p_validate_only <> FND_API.G_TRUE then
389: if p_proj_element_id is NULL then
390: DELETE FROM PA_PROJECTS_ERP_EXT_B
391: WHERE PROJECT_ID = p_project_id;
392:
393: DELETE FROM PA_PROJECTS_ERP_EXT_TL
394: WHERE PROJECT_ID = p_project_id;
392:
393: DELETE FROM PA_PROJECTS_ERP_EXT_TL
394: WHERE PROJECT_ID = p_project_id;
395: else
396: DELETE FROM PA_PROJECTS_ERP_EXT_B
397: WHERE PROJECT_ID = p_project_id
398: AND PROJ_ELEMENT_ID = p_proj_element_id;
399:
400: DELETE FROM PA_PROJECTS_ERP_EXT_TL