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 PA_AGREEMENT_PUB

Line 260: p_agreement_in_rec OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE,

256:
257: PROCEDURE prepare_agreement_record(p_funding_in_rec IN OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE,
258: p_agreement_type IN VARCHAR2 ,
259: p_receivables_term_id IN NUMBER, --skuchima bug 14344021
260: p_agreement_in_rec OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE,
261: p_agreement_length IN NUMBER
262: ) is
263: l_term_id NUMBER;
264: l_hard_limit VARCHAR2(1);

Line 1341: PROCEDURE retrieve_agreement(p_agreement_in_rec IN PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,

1337: -- Description: This procedure is used to retrieve the existing agreement
1338: --
1339: --
1340:
1341: PROCEDURE retrieve_agreement(p_agreement_in_rec IN PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1342: p_agreement_in_rec_new OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1343: p_agreement_amount OUT NOCOPY NUMBER
1344: ) is
1345: cursor c_agreement is

Line 1342: p_agreement_in_rec_new OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,

1338: --
1339: --
1340:
1341: PROCEDURE retrieve_agreement(p_agreement_in_rec IN PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1342: p_agreement_in_rec_new OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1343: p_agreement_amount OUT NOCOPY NUMBER
1344: ) is
1345: cursor c_agreement is
1346: select *

Line 1472: PROCEDURE upd_insert_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,

1468: -- Description: This procedure is used to update/create agreement
1469: --
1470: --
1471: /*
1472: PROCEDURE upd_insert_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1473: p_agreement_tbl AGREEMENT_TBL_TYPE ,
1474: p_pa_agreement_tbl AGREEMENT_TBL_TYPE ,
1475: p_funding_source_id NUMBER ,
1476: -- p_insert_flag VARCHAR2 ,

Line 1542: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

1538: where funding_source_id = p_funding_source_id;
1539:
1540: i NUMBER;
1541: l_org_id_vc VARCHAR(10);
1542: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1543: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1544: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1545: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1546: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

Line 1543: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;

1539:
1540: i NUMBER;
1541: l_org_id_vc VARCHAR(10);
1542: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1543: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1544: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1545: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1546: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1547: l_agreement_amount NUMBER;

Line 1544: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

1540: i NUMBER;
1541: l_org_id_vc VARCHAR(10);
1542: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1543: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1544: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1545: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1546: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1547: l_agreement_amount NUMBER;
1548: l_agreement_id NUMBER;

Line 1545: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

1541: l_org_id_vc VARCHAR(10);
1542: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1543: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1544: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1545: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1546: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1547: l_agreement_amount NUMBER;
1548: l_agreement_id NUMBER;
1549: l_amount NUMBER;

Line 1546: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

1542: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1543: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1544: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1545: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1546: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1547: l_agreement_amount NUMBER;
1548: l_agreement_id NUMBER;
1549: l_amount NUMBER;
1550: l_diff_amount NUMBER;

Line 1725: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

1721: l_agreement_in_rec_new.agreement_num := l_agreement_in_rec_new.agreement_num || '*';
1722:
1723: END IF;
1724:
1725: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1726: p_commit => OKE_API.G_FALSE ,
1727: p_init_msg_list => OKE_API.G_FALSE ,
1728: p_msg_count => p_msg_count ,
1729: p_msg_data => p_msg_data ,

Line 1804: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

1800: END IF;
1801:
1802: l_agreement_in_rec.amount := 99999999999999999.99999;
1803:
1804: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
1805: p_commit => OKE_API.G_FALSE ,
1806: p_init_msg_list => OKE_API.G_FALSE ,
1807: p_msg_count => p_msg_count ,
1808: p_msg_data => p_msg_data ,

Line 1870: --oke_debug.debug('calling pa_agreement_pub.update_agreement from upd_insert_agreement');

1866:
1867:
1868: l_agreement_in_rec_new.amount := 99999999999999999.99999;
1869:
1870: --oke_debug.debug('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1871: --dbms_output.put_line('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1872:
1873: IF (nvl(l_pa_org_id, -99) <> -1000) AND
1874: (i = nvl(l_pa_org_id, -99)) THEN

Line 1871: --dbms_output.put_line('calling pa_agreement_pub.update_agreement from upd_insert_agreement');

1867:
1868: l_agreement_in_rec_new.amount := 99999999999999999.99999;
1869:
1870: --oke_debug.debug('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1871: --dbms_output.put_line('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1872:
1873: IF (nvl(l_pa_org_id, -99) <> -1000) AND
1874: (i = nvl(l_pa_org_id, -99)) THEN
1875:

Line 1883: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

1879: l_agreement_in_rec_new.agreement_num := l_agreement_in_rec_new.agreement_num || '*';
1880:
1881: END IF;
1882:
1883: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1884: p_commit => OKE_API.G_FALSE ,
1885: p_init_msg_list => OKE_API.G_FALSE ,
1886: p_msg_count => p_msg_count ,
1887: p_msg_data => p_msg_data ,

Line 1967: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

1963: l_agreement_in_rec_new.pm_agreement_reference := '-Y-' || p_funding_source_id;
1964:
1965: END IF;
1966:
1967: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1968: p_commit => OKE_API.G_FALSE ,
1969: p_init_msg_list => OKE_API.G_FALSE ,
1970: p_msg_count => p_msg_count ,
1971: p_msg_data => p_msg_data ,

Line 2044: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

2040: fnd_client_info.set_org_context(l_update.org_id);
2041:
2042: END IF;
2043:
2044: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2045: p_commit => OKE_API.G_FALSE ,
2046: p_init_msg_list => OKE_API.G_FALSE ,
2047: p_msg_count => p_msg_count ,
2048: p_msg_data => p_msg_data ,

Line 2083: PROCEDURE update_pa_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,

2079: -- Description: This procedure is used to agreement originally pushed from PA
2080: --
2081: --
2082: /*
2083: PROCEDURE update_pa_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
2084: p_agreement_tbl AGREEMENT_TBL_TYPE ,
2085: p_funding_source_id NUMBER ,
2086: p_funding_amount NUMBER ,
2087: p_agreement_out_tbl OUT NOCOPY PA_AGREEMENT_TBL_TYPE ,

Line 2116: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

2112: where funding_source_id = p_funding_source_id;
2113:
2114: i NUMBER;
2115: l_org_id_vc VARCHAR(10);
2116: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2117: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2118: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2119: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2120: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

Line 2117: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;

2113:
2114: i NUMBER;
2115: l_org_id_vc VARCHAR(10);
2116: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2117: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2118: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2119: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2120: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2121: l_orig_pa_amount NUMBER;

Line 2118: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

2114: i NUMBER;
2115: l_org_id_vc VARCHAR(10);
2116: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2117: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2118: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2119: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2120: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2121: l_orig_pa_amount NUMBER;
2122: l_agreement_count NUMBER := 0;

Line 2119: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

2115: l_org_id_vc VARCHAR(10);
2116: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2117: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2118: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2119: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2120: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2121: l_orig_pa_amount NUMBER;
2122: l_agreement_count NUMBER := 0;
2123: l_sum_flag VARCHAR2(1);

Line 2120: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

2116: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2117: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2118: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2119: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2120: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2121: l_orig_pa_amount NUMBER;
2122: l_agreement_count NUMBER := 0;
2123: l_sum_flag VARCHAR2(1);
2124: l_update c_update_agreement%ROWTYPE;

Line 2217: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

2213: fnd_client_info.set_org_context(l_update.org_id);
2214:
2215: END IF;
2216:
2217: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2218: p_commit => OKE_API.G_FALSE ,
2219: p_init_msg_list => OKE_API.G_FALSE ,
2220: p_msg_count => p_msg_count ,
2221: p_msg_data => p_msg_data ,

Line 2372: -- PA_AGREEMENT_PUB.create_agreement

2368: -- OKE_API.end_activity
2369: -- OKE_FUNDING_UTIL_PKG.funding_mode
2370: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2371: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2372: -- PA_AGREEMENT_PUB.create_agreement
2373: -- add_pa_funding
2374: -- validate_agreement_attributes
2375: -- check_project_null
2376: -- get_term_id

Line 2484: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

2480: l_err_project_number VARCHAR2(25);
2481: l_level VARCHAR2(1);
2482: l_amount NUMBER;
2483: l_org_id_vc VARCHAR(10);
2484: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_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;

Line 2485: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

2481: l_level VARCHAR2(1);
2482: l_amount NUMBER;
2483: l_org_id_vc VARCHAR(10);
2484: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_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;

Line 2487: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

2483: l_org_id_vc VARCHAR(10);
2484: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_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;

Line 2488: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

2484: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_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;

Line 2821: --oke_debug.debug('calling pa_agreement_pub.create_agreement');

2817: p_reference => l_agreement_in_rec.pm_agreement_reference ,
2818: p_agreement_length => l_agreement_length
2819: );
2820:
2821: --oke_debug.debug('calling pa_agreement_pub.create_agreement');
2822:
2823: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2824:
2825: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

Line 2825: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

2821: --oke_debug.debug('calling pa_agreement_pub.create_agreement');
2822:
2823: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2824:
2825: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
2826: p_commit => OKE_API.G_FALSE ,
2827: p_init_msg_list => OKE_API.G_FALSE ,
2828: p_msg_count => p_msg_count ,
2829: p_msg_data => p_msg_data ,

Line 2996: --oke_debug.debug('calling pa_agreement_pub.update_agreement');

2992: );
2993:
2994: l_agreement_in_rec.agreement_currency_code := l_agreement_tbl(i).agreement_currency_code;
2995:
2996: --oke_debug.debug('calling pa_agreement_pub.update_agreement');
2997: --dbms_output.put_line('calling pa_agreement_pub.update_agreement');
2998:
2999: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
3000:

Line 2997: --dbms_output.put_line('calling pa_agreement_pub.update_agreement');

2993:
2994: l_agreement_in_rec.agreement_currency_code := l_agreement_tbl(i).agreement_currency_code;
2995:
2996: --oke_debug.debug('calling pa_agreement_pub.update_agreement');
2997: --dbms_output.put_line('calling pa_agreement_pub.update_agreement');
2998:
2999: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
3000:
3001: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

Line 3001: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

2997: --dbms_output.put_line('calling pa_agreement_pub.update_agreement');
2998:
2999: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
3000:
3001: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3002: p_commit => OKE_API.G_FALSE ,
3003: p_init_msg_list => OKE_API.G_FALSE ,
3004: p_msg_count => p_msg_count ,
3005: p_msg_data => p_msg_data ,

Line 3312: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

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;
3316: -- l_orig_agreement_tbl AGREEMENT_TBL_TYPE;

Line 3325: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

3321: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3322: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3323: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3324: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3325: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3326: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
3327: l_org_id_vc VARCHAR(10);
3328: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
3329: l_err_project_number VARCHAR2(25);

Line 3326: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

3322: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3323: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3324: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3325: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3326: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
3327: l_org_id_vc VARCHAR(10);
3328: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
3329: l_err_project_number VARCHAR2(25);
3330: l_level VARCHAR2(1);

Line 3328: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

3324: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3325: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3326: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
3327: l_org_id_vc VARCHAR(10);
3328: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
3329: l_err_project_number VARCHAR2(25);
3330: l_level VARCHAR2(1);
3331: l_funding_in_rec OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE;
3332: l_count NUMBER := 0;

Line 3487: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

3483: mo_global.set_policy_context('S',l_agreement.org_id);
3484:
3485: END IF;
3486:
3487: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3488: p_commit => OKE_API.G_FALSE ,
3489: p_init_msg_list => OKE_API.G_FALSE ,
3490: p_msg_count => p_msg_count ,
3491: p_msg_data => p_msg_data ,

Line 3651: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

3647: );
3648:
3649: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3650:
3651: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3652: p_commit => OKE_API.G_FALSE ,
3653: p_init_msg_list => OKE_API.G_FALSE ,
3654: p_msg_count => p_msg_count ,
3655: p_msg_data => p_msg_data ,

Line 3714: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

3710: );
3711:
3712: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3713:
3714: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3715: p_commit => OKE_API.G_FALSE ,
3716: p_init_msg_list => OKE_API.G_FALSE ,
3717: p_msg_count => p_msg_count ,
3718: p_msg_data => p_msg_data ,

Line 3803: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

3799: );
3800:
3801: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3802:
3803: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3804: p_commit => OKE_API.G_FALSE ,
3805: p_init_msg_list => OKE_API.G_FALSE ,
3806: p_msg_count => p_msg_count ,
3807: p_msg_data => p_msg_data ,

Line 3963: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

3959: );
3960:
3961: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3962:
3963: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3964: p_commit => OKE_API.G_FALSE ,
3965: p_init_msg_list => OKE_API.G_FALSE ,
3966: p_msg_count => p_msg_count ,
3967: p_msg_data => p_msg_data ,

Line 4026: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

4022: );
4023:
4024: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4025:
4026: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4027: p_commit => OKE_API.G_FALSE ,
4028: p_init_msg_list => OKE_API.G_FALSE ,
4029: p_msg_count => p_msg_count ,
4030: p_msg_data => p_msg_data ,

Line 4115: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

4111: );
4112:
4113: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4114:
4115: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4116: p_commit => OKE_API.G_FALSE ,
4117: p_init_msg_list => OKE_API.G_FALSE ,
4118: p_msg_count => p_msg_count ,
4119: p_msg_data => p_msg_data ,

Line 4223: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

4219: l_agreement_in_rec.amount := l_agreement.agreement_sum;
4220:
4221: END IF;
4222:
4223: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
4224: p_commit => OKE_API.G_FALSE ,
4225: p_init_msg_list => OKE_API.G_FALSE ,
4226: p_msg_count => p_msg_count ,
4227: p_msg_data => p_msg_data ,

Line 4302: -- PA_AGREEMENT_PUB.update_funding

4298: -- Description: This procedure is used to update record in pa project funding table
4299: --
4300: -- Calling subprograms: OKE_API.start_activity
4301: -- OKE_API.end_activity
4302: -- PA_AGREEMENT_PUB.update_funding
4303: -- PA_AGREEMENT_PUB.add_funding
4304: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4305: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4306: -- validate_line_attributes

Line 4303: -- PA_AGREEMENT_PUB.add_funding

4299: --
4300: -- Calling subprograms: OKE_API.start_activity
4301: -- OKE_API.end_activity
4302: -- PA_AGREEMENT_PUB.update_funding
4303: -- PA_AGREEMENT_PUB.add_funding
4304: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4305: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4306: -- validate_line_attributes
4307: -- pa_update_or_add

Line 4546: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');

4542: IF (l_add_flag = 'Y') THEN -- AND
4543: --(nvl(l_version, 0) <> 0 or p_allocation_in_rec.amount <> 0) THEN
4544:
4545: IF l_diff_amount<>0 THEN
4546: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4547: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4548:
4549: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4550: p_commit => OKE_API.G_FALSE ,

Line 4547: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');

4543: --(nvl(l_version, 0) <> 0 or p_allocation_in_rec.amount <> 0) THEN
4544:
4545: IF l_diff_amount<>0 THEN
4546: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4547: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4548:
4549: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4550: p_commit => OKE_API.G_FALSE ,
4551: p_init_msg_list => OKE_API.G_FALSE ,

Line 4549: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,

4545: IF l_diff_amount<>0 THEN
4546: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4547: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4548:
4549: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4550: p_commit => OKE_API.G_FALSE ,
4551: p_init_msg_list => OKE_API.G_FALSE ,
4552: p_msg_count => p_msg_count ,
4553: p_msg_data => p_msg_data ,

Line 4610: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');

4606: p_project_funding => l_project_funding
4607: );
4608:
4609:
4610: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4611: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4612:
4613: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4614: p_commit => OKE_API.G_FALSE ,

Line 4611: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');

4607: );
4608:
4609:
4610: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4611: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4612:
4613: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4614: p_commit => OKE_API.G_FALSE ,
4615: p_init_msg_list => OKE_API.G_FALSE ,

Line 4613: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,

4609:
4610: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4611: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4612:
4613: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4614: p_commit => OKE_API.G_FALSE ,
4615: p_init_msg_list => OKE_API.G_FALSE ,
4616: p_msg_count => p_msg_count ,
4617: p_msg_data => p_msg_data ,

Line 4680: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,

4676: -- syho, bug 2328311
4677: -- update the ff of the existing project funding lines
4678: --FOR l_project_funding IN c_project_funding (length(p_allocation_in_rec.fund_allocation_id)) LOOP
4679: /*
4680: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4681: p_commit => OKE_API.G_FALSE ,
4682: p_init_msg_list => OKE_API.G_FALSE ,
4683: p_msg_count => p_msg_count ,
4684: p_msg_data => p_msg_data ,

Line 4789: -- PA_AGREEMENT_PUB.add_funding

4785: -- Description: This procedure is used to add pa funding
4786: --
4787: -- Calling subprograms: OKE_API.start_activity
4788: -- OKE_API.end_activity
4789: -- PA_AGREEMENT_PUB.add_funding
4790: -- validate_line_attributes
4791: -- get_converted_amount
4792: -- get_agreement_org
4793: --

Line 4893: --dbms_output.put_line('calling pa_agreement_pub.add_funding');

4889: mo_global.set_policy_context('S',l_org_id_n);
4890:
4891: end if;
4892:
4893: --dbms_output.put_line('calling pa_agreement_pub.add_funding');
4894: --oke_debug.debug('calling pa_agreement_pub.add_funding');
4895:
4896: IF (p_allocation_in_rec.amount <> 0) THEN
4897:

Line 4894: --oke_debug.debug('calling pa_agreement_pub.add_funding');

4890:
4891: end if;
4892:
4893: --dbms_output.put_line('calling pa_agreement_pub.add_funding');
4894: --oke_debug.debug('calling pa_agreement_pub.add_funding');
4895:
4896: IF (p_allocation_in_rec.amount <> 0) THEN
4897:
4898: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,

Line 4898: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,

4894: --oke_debug.debug('calling pa_agreement_pub.add_funding');
4895:
4896: IF (p_allocation_in_rec.amount <> 0) THEN
4897:
4898: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4899: p_commit => OKE_API.G_FALSE ,
4900: p_init_msg_list => OKE_API.G_FALSE ,
4901: p_msg_count => p_msg_count ,
4902: p_msg_data => p_msg_data ,

Line 4939: --dbms_output.put_line('finished pa_agreement_pub.add_funding w/ ' || p_return_status);

4935:
4936: -- fnd_client_info.set_org_context(to_number(l_org_id_vc));
4937: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4938:
4939: --dbms_output.put_line('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4940: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4941:
4942: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4943:

Line 4940: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);

4936: -- fnd_client_info.set_org_context(to_number(l_org_id_vc));
4937: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4938:
4939: --dbms_output.put_line('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4940: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4941:
4942: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4943:
4944: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;