[Home] [Help]
30: BEGIN
31:
32: select oke_k_fund_allocations_s.nextval
33: into l_funding_allocation_id
34: from dual;
35:
36: return(l_funding_allocation_id);
37:
38: END get_fund_allocation_id;
632: where k_line_id = p_k_line_id;
633:
634: cursor c_valid_line (x_project_id number) is
635: select 'x'
636: from dual
637: where p_project_id in
638: (select to_number(sub_project_id)
639: from pa_fin_structures_links_v
640: start with parent_project_id = x_project_id
642: );
643:
644: cursor c_valid_line2 (x_task_id number,x_project_id number) is
645: select 'x'
646: from dual
647: where p_project_id in
648: ( select to_number(sub_project_id)
649: from pa_fin_structures_links_v
650: START WITH (parent_project_id, parent_task_id)
813: where k_header_id = p_object_id;
814:
815: cursor c_project_h (x_project_id number) is
816: select 'x'
817: from dual
818: where p_project_id in
819: (select to_number(sub_project_id)
820: from pa_fin_structures_links_v
821: start with parent_project_id = x_project_id
821: start with parent_project_id = x_project_id
822: connect by parent_project_id = prior sub_project_id
823: union all
824: select x_project_id
825: from dual
826: );
827:
828: cursor c_project_h2 (x_task_id number, x_project_id number) is
829: select 'x'
826: );
827:
828: cursor c_project_h2 (x_task_id number, x_project_id number) is
829: select 'x'
830: from dual
831: where p_project_id in
832: ( select to_number(sub_project_id)
833: from pa_fin_structures_links_v
834: start with parent_project_id = x_project_id
835: and parent_task_id = x_task_id
836: connect by parent_project_id = prior sub_project_id
837: union all
838: select x_project_id
839: from dual
840: );
841:
842: cursor c_intent is
843: select buy_or_sell