[Home] [Help]
266: where p.project_id in
267: (select to_number(sub_project_id) project_id
268: from pa_fin_structures_links_v
269: start with parent_project_id = l_project_id_from
270: and parent_task_id in (select task_id from pa_tasks where project_id=l_project_id_from
271: and top_task_id=nvl(l_task_id_from,top_task_id) )
272: connect by parent_project_id = prior sub_project_id)
273: union
274: select project_id pid,segment1
288: cursor c_z(x_proj number, x_task number) is /* check is only needed if task is specified as well */
289: select 'x'
290: from pa_fin_structures_links_v
291: start with ((parent_project_id = x_proj ) and parent_task_id in
292: (select task_id from pa_tasks
293: where project_id = x_proj
294: and top_task_id = nvl(x_task, top_task_id)))
295: connect by parent_project_id = prior sub_project_id;
296:
425: x_return_status OUT NOCOPY VARCHAR2
426: ) IS
427:
428: CURSOR l_csr IS
429: SELECT 'x' FROM PA_TASKS
430: WHERE TASK_ID = p_cle_rec.TASK_ID;
431:
432: l_project_id NUMBER := p_cle_rec.project_id;
433: l_parent_line_id NUMBER;
464:
465:
466: CURSOR l_top_task IS
467: SELECT 'x' FROM (
468: select task_id, task_number,task_name,description from pa_tasks
469: where parent_task_id is null
470: and (( project_id <>l_project_id_from and project_id = l_project_id)
471: or
472: ( project_id = l_project_id_from and project_id = l_project_id
539: p_token1_value => 'task_id',
540: p_token2 => g_child_table_token,
541: p_token2_value => G_VIEW,
542: p_token3 => g_parent_table_token,
543: p_token3_value => 'PA_TASKS');
544: -- notify caller of an error
545: x_return_status := OKE_API.G_RET_STS_ERROR;
546: End If;
547: