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 676: PROCEDURE validate_line_attributes(p_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE) is

672: -- Description: This procedure is used to validate allocation record
673: --
674: --
675:
676: PROCEDURE validate_line_attributes(p_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE) is
677: l_return_status VARCHAR2(1);
678: BEGIN
679:
680: --

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

799: -- Description: This function is used to calculate the allocated amount
800: --
801: --
802:
803: PROCEDURE get_converted_amount(p_allocation_in_rec IN OUT NOCOPY OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
804: --p_amount OUT NOCOPY NUMBER ,
805: p_org_id OUT NOCOPY NUMBER ,
806: p_return_status OUT NOCOPY VARCHAR2
807: )is

Line 2387: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,

2383: p_msg_count OUT NOCOPY NUMBER ,
2384: p_msg_data OUT NOCOPY VARCHAR2 ,
2385: p_agreement_type IN VARCHAR2 ,
2386: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,
2387: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,
2388: p_return_status OUT NOCOPY VARCHAR2 ,
2389: p_receivables_term_id IN NUMBER DEFAULT null /*skuchima bug14344021 */
2390: ) is
2391:

Line 2489: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

2485: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2486: l_funding_in_rec OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE;
2487: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2488: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2489: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
2490: --l_allocation c_allocation%ROWTYPE;
2491: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
2492: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
2493: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;

Line 3108: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,

3104: p_msg_count OUT NOCOPY NUMBER ,
3105: p_msg_data OUT NOCOPY VARCHAR2 ,
3106: p_agreement_type IN VARCHAR2 ,
3107: p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE ,
3108: -- p_allocation_in_tbl IN OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE ,
3109: p_return_status OUT NOCOPY VARCHAR2 ,
3110: p_receivables_term_id IN NUMBER DEFAULT NULL /*skuchima bug 14344021 */
3111: ) is
3112:

Line 3311: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

3307:
3308: l_api_name VARCHAR2(20) := 'update_agreement';
3309: l_return_status VARCHAR2(1);
3310: i NUMBER := 0;
3311: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
3312: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
3313: l_amount NUMBER;
3314: l_org_id NUMBER;
3315: --l_agreement_tbl AGREEMENT_TBL_TYPE;

Line 3317: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;

3313: l_amount NUMBER;
3314: l_org_id NUMBER;
3315: --l_agreement_tbl AGREEMENT_TBL_TYPE;
3316: -- l_orig_agreement_tbl AGREEMENT_TBL_TYPE;
3317: -- l_allocation_in_tbl OKE_ALLOCATION_PVT.ALLOCATION_IN_TBL_TYPE;
3318: -- l_rate NUMBER;
3319: l_project_number VARCHAR2(25);
3320: l_proj_sum_tbl OKE_FUNDING_UTIL_PKG.PROJ_SUM_TBL_TYPE;
3321: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;

Line 4316: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

4312: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4313: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4314: p_msg_count OUT NOCOPY NUMBER ,
4315: p_msg_data OUT NOCOPY VARCHAR2 ,
4316: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4317: p_return_status OUT NOCOPY VARCHAR2
4318: ) is
4319:
4320: cursor c_allocation is

Line 4390: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

4386: -- l_length NUMBER;
4387: -- l_convert_flag VARCHAR2(1) := 'Y';
4388: l_source_currency VARCHAR2(15);
4389: l_agreement_currency VARCHAR2(15);
4390: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
4391:
4392: BEGIN
4393:
4394: --dbms_output.put_line('entering oke_agreement_pvt.update_pa_funding');

Line 4800: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,

4796: p_init_msg_list IN VARCHAR2 := OKE_API.G_FALSE ,
4797: p_commit IN VARCHAR2 := OKE_API.G_FALSE ,
4798: p_msg_count OUT NOCOPY NUMBER ,
4799: p_msg_data OUT NOCOPY VARCHAR2 ,
4800: p_allocation_in_rec IN OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE ,
4801: p_return_status OUT NOCOPY VARCHAR2
4802: ) is
4803:
4804: l_api_name VARCHAR2(20) := 'add_pa_funding';

Line 4810: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;

4806: l_funding_id NUMBER;
4807: -- l_amount NUMBER;
4808: l_org_id_vc VARCHAR(10);
4809: l_org_id_n NUMBER;
4810: l_allocation_in_rec OKE_ALLOCATION_PVT.ALLOCATION_REC_IN_TYPE;
4811:
4812: BEGIN
4813:
4814: --dbms_output.put_line('entering oke_agreement_pvt.add_pa_funding');