[Home] [Help]
28: l_funding_allocation_id NUMBER;
29:
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);
160: cursor c_allocation is
161: select project_id,
162: task_id,
163: start_date_active
164: from oke_k_fund_allocations
165: where fund_allocation_id = p_fund_allocation_id;
166:
167: l_allocation c_allocation%ROWTYPE;
168: l_field VARCHAR2(30);
380: p_version OUT NOCOPY NUMBER
381: ) is
382: cursor c_fund_allocation_id is
383: select rowid, nvl(agreement_version, 0)
384: from oke_k_fund_allocations
385: where fund_allocation_id = p_fund_allocation_id;
386:
387: BEGIN
388:
622: where k_line_id = p_k_line_id;
623:
624: cursor c_header is
625: select pa_flag
626: from oke_k_fund_allocations
627: where fund_allocation_id = p_fund_allocation_id;
628:
629: cursor c_line_project is
630: select project_id, task_id
1537: ) is
1538:
1539: cursor c_allocation_row is
1540: select *
1541: from oke_k_fund_allocations
1542: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id
1543: FOR UPDATE OF fund_allocation_id NOWAIT;
1544:
1545: cursor c_version is
2421:
2422: --
2423: -- Procedure add_allocation
2424: --
2425: -- Description: This procedure is used to insert record in OKE_K_FUND_ALLOCATIONS table
2426: --
2427: -- Calling subprograms: OKE_API.start_activity
2428: -- OKE_API.end_activity
2429: -- OKE_FUNDINGALLOCATION_PVT.insert_row
2623:
2624: --
2625: -- Procedure update_allocation
2626: --
2627: -- Description: This procedure is used to update record in OKE_K_FUND_ALLOCATIONS table
2628: --
2629: -- Calling subprograms: OKE_API.start_activity
2630: -- OKE_API.end_activity
2631: -- allowable_changes
2867:
2868: --
2869: -- Procedure delete_allocation
2870: --
2871: -- Description: This procedure is used to delete record in OKE_K_FUND_ALLOCATIONS table
2872: --
2873: -- Calling subprograms: OKE_FUNDINGALLOCATION_PVT.delete_row
2874: -- OKE_API.start_activity
2875: -- OKE_API.end_activity
2902: /*
2903: cursor c_org is
2904: select org_id
2905: from pa_projects_all p,
2906: oke_k_fund_allocations f
2907: where f.project_id = p.project_id
2908: and fund_allocation_id = p_fund_allocation_id;
2909: */
2910:
2911: cursor c_ver is
2912: select major_version + 1,
2913: nvl(created_in_version, -99)
2914: from okc_k_vers_numbers b,
2915: oke_k_fund_allocations a
2916: where b.chr_id = a.object_id
2917: and a.fund_allocation_id = p_fund_allocation_id;
2918:
2919: cursor c_proj_funding(x_length number) is