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_AGREEMENT_PVT dependencies on OKE_ALLOCATION_PVT

Line 179: FUNCTION populate_values(p_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE)

175: -- Description: This function is used to populate values for
176: -- pa df
177: --
178:
179: FUNCTION populate_values(p_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE)
180: RETURN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE is
181:
182: cursor c_allocation is
183: select *

Line 180: RETURN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE is

176: -- pa df
177: --
178:
179: FUNCTION populate_values(p_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE)
180: RETURN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE is
181:
182: cursor c_allocation is
183: select *
184: from oke_k_fund_allocations

Line 187: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE := p_allocation_in_rec;

183: select *
184: from oke_k_fund_allocations
185: where fund_allocation_id = p_allocation_in_rec.fund_allocation_id;
186:
187: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE := p_allocation_in_rec;
188: l_allocation_row OKE_K_FUND_ALLOCATIONS%ROWTYPE;
189:
190: BEGIN
191:

Line 661: PROCEDURE validate_line_attributes(p_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE) is

657: -- Description: This procedure is used to validate allocation record
658: --
659: --
660:
661: PROCEDURE validate_line_attributes(p_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE) is
662: l_return_status VARCHAR2(1);
663: BEGIN
664:
665: --

Line 788: PROCEDURE get_converted_amount(p_allocation_in_rec IN OUT NOCOPY OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

784: -- Description: This function is used to calculate the allocated amount
785: --
786: --
787:
788: PROCEDURE get_converted_amount(p_allocation_in_rec IN OUT NOCOPY OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
789: --p_amount OUT NOCOPY NUMBER ,
790: p_org_id OUT NOCOPY NUMBER ,
791: p_return_status OUT NOCOPY VARCHAR2
792: )is

Line 2372: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,

2368: p_msg_count OUT NOCOPY NUMBER ,
2369: p_msg_data OUT NOCOPY VARCHAR2 ,
2370: p_agreement_type IN VARCHAR2 ,
2371: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,
2372: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,
2373: p_return_status OUT NOCOPY VARCHAR2
2374: ) is
2375:
2376: cursor c_ou is

Line 2473: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

2469: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2470: l_funding_in_rec OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE;
2471: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2472: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2473: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2474: --l_allocation c_allocation%ROWTYPE;
2475: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2476: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2477: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;

Line 3088: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,

3084: p_msg_count OUT NOCOPY NUMBER ,
3085: p_msg_data OUT NOCOPY VARCHAR2 ,
3086: p_agreement_type IN VARCHAR2 ,
3087: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,
3088: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,
3089: p_return_status OUT NOCOPY VARCHAR2
3090: ) is
3091:
3092: cursor c_project is

Line 3290: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

3286:
3287: l_api_name VARCHAR2(20) := 'update_agreement';
3288: l_return_status VARCHAR2(1);
3289: i NUMBER := 0;
3290: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
3291: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
3292: l_amount NUMBER;
3293: l_org_id NUMBER;
3294: --l_agreement_tbl AGREEMENT_TBL_TYPE;

Line 3296: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;

3292: l_amount NUMBER;
3293: l_org_id NUMBER;
3294: --l_agreement_tbl AGREEMENT_TBL_TYPE;
3295: -- l_orig_agreement_tbl AGREEMENT_TBL_TYPE;
3296: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;
3297: -- l_rate NUMBER;
3298: l_project_number VARCHAR2(25);
3299: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3300: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;

Line 4291: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

4287: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4288: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4289: p_msg_count OUT NOCOPY NUMBER ,
4290: p_msg_data OUT NOCOPY VARCHAR2 ,
4291: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4292: p_return_status OUT NOCOPY VARCHAR2
4293: ) is
4294:
4295: cursor c_allocation is

Line 4365: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

4361: -- l_length NUMBER;
4362: -- l_convert_flag VARCHAR2(1) := 'Y';
4363: l_source_currency VARCHAR2(15);
4364: l_agreement_currency VARCHAR2(15);
4365: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
4366:
4367: BEGIN
4368:
4369: --dbms_output.put_line('entering oke_agreement_pvt.update_pa_funding');

Line 4775: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

4771: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4772: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4773: p_msg_count OUT NOCOPY NUMBER ,
4774: p_msg_data OUT NOCOPY VARCHAR2 ,
4775: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4776: p_return_status OUT NOCOPY VARCHAR2
4777: ) is
4778:
4779: l_api_name VARCHAR2(20) := 'add_pa_funding';

Line 4785: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

4781: l_funding_id NUMBER;
4782: -- l_amount NUMBER;
4783: l_org_id_vc VARCHAR(10);
4784: l_org_id_n NUMBER;
4785: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
4786:
4787: BEGIN
4788:
4789: --dbms_output.put_line('entering oke_agreement_pvt.add_pa_funding');