DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_TASKS_S

Line 336: select PA_TASKS_S.NEXTVAL into l_proj_element_id from sys.dual;

332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334:
335: --Insert into pa_proj_elements
336: select PA_TASKS_S.NEXTVAL into l_proj_element_id from sys.dual;
337:
338: PA_PROJ_ELEMENTS_PKG.insert_row(
339: X_ROW_ID => l_rowid
340: ,X_PROJ_ELEMENT_ID => l_proj_element_id

Line 8054: select PA_TASKS_S.NEXTVAL into l_task_id from sys.dual;

8050: -- If (l_is_workplan = 'Y') AND (l_is_billing = 'N') AND (l_is_costing = 'N') THEN
8051: l_task_id := NULL;
8052: IF (l_structure_type = 'WORKPLAN') THEN
8053: --get new id
8054: select PA_TASKS_S.NEXTVAL into l_task_id from sys.dual;
8055: ELSE
8056: --id exists in pa_tasks. Need to find matching id by using task_number
8057: OPEN l_get_pa_tasks_csr(p_dest_project_id, l_tasks_rec.PA_TASK_NUMBER);
8058: FETCH l_get_pa_tasks_csr into l_task_id;