eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKE_ALLOCATION_PVT dependencies on OKE_K_FUND_ALLOCATIONS

Line 32: select oke_k_fund_allocations_s.nextval

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);

Line 164: from oke_k_fund_allocations

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);

Line 384: from oke_k_fund_allocations

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:

Line 626: from oke_k_fund_allocations

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

Line 1576: from oke_k_fund_allocations

1572: ) is
1573:
1574: cursor c_allocation_row is
1575: select *
1576: from oke_k_fund_allocations
1577: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id
1578: FOR UPDATE OF fund_allocation_id NOWAIT;
1579:
1580: cursor c_version is

Line 2460: -- Description: This procedure is used to insert record in OKE_K_FUND_ALLOCATIONS table

2456:
2457: --
2458: -- Procedure add_allocation
2459: --
2460: -- Description: This procedure is used to insert record in OKE_K_FUND_ALLOCATIONS table
2461: --
2462: -- Calling subprograms: OKE_API.start_activity
2463: -- OKE_API.end_activity
2464: -- OKE_FUNDINGALLOCATION_PVT.insert_row

Line 2662: -- Description: This procedure is used to update record in OKE_K_FUND_ALLOCATIONS table

2658:
2659: --
2660: -- Procedure update_allocation
2661: --
2662: -- Description: This procedure is used to update record in OKE_K_FUND_ALLOCATIONS table
2663: --
2664: -- Calling subprograms: OKE_API.start_activity
2665: -- OKE_API.end_activity
2666: -- allowable_changes

Line 2906: -- Description: This procedure is used to delete record in OKE_K_FUND_ALLOCATIONS table

2902:
2903: --
2904: -- Procedure delete_allocation
2905: --
2906: -- Description: This procedure is used to delete record in OKE_K_FUND_ALLOCATIONS table
2907: --
2908: -- Calling subprograms: OKE_FUNDINGALLOCATION_PVT.delete_row
2909: -- OKE_API.start_activity
2910: -- OKE_API.end_activity

Line 2941: oke_k_fund_allocations f

2937: /*
2938: cursor c_org is
2939: select org_id
2940: from pa_projects_all p,
2941: oke_k_fund_allocations f
2942: where f.project_id = p.project_id
2943: and fund_allocation_id = p_fund_allocation_id;
2944: */
2945:

Line 2950: oke_k_fund_allocations a

2946: cursor c_ver is
2947: select major_version + 1,
2948: nvl(created_in_version, -99)
2949: from okc_k_vers_numbers b,
2950: oke_k_fund_allocations a
2951: where b.chr_id = a.object_id
2952: and a.fund_allocation_id = p_fund_allocation_id;
2953:
2954: cursor c_proj_funding(x_length number) is