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 259: p_agreement_in_rec OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE,

255: --
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_agreement_in_rec OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE,
260: p_agreement_length IN NUMBER
261: ) is
262: l_term_id NUMBER;
263: l_hard_limit VARCHAR2(1);

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

1322: -- Description: This procedure is used to retrieve the existing agreement
1323: --
1324: --
1325:
1326: PROCEDURE retrieve_agreement(p_agreement_in_rec IN PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1327: p_agreement_in_rec_new OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1328: p_agreement_amount OUT NOCOPY NUMBER
1329: ) is
1330: cursor c_agreement is

Line 1327: p_agreement_in_rec_new OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,

1323: --
1324: --
1325:
1326: PROCEDURE retrieve_agreement(p_agreement_in_rec IN PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1327: p_agreement_in_rec_new OUT NOCOPY PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1328: p_agreement_amount OUT NOCOPY NUMBER
1329: ) is
1330: cursor c_agreement is
1331: select *

Line 1457: PROCEDURE upd_insert_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,

1453: -- Description: This procedure is used to update/create agreement
1454: --
1455: --
1456: /*
1457: PROCEDURE upd_insert_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
1458: p_agreement_tbl AGREEMENT_TBL_TYPE ,
1459: p_pa_agreement_tbl AGREEMENT_TBL_TYPE ,
1460: p_funding_source_id NUMBER ,
1461: -- p_insert_flag VARCHAR2 ,

Line 1527: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

1523: where funding_source_id = p_funding_source_id;
1524:
1525: i NUMBER;
1526: l_org_id_vc VARCHAR(10);
1527: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1528: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1529: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1530: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1531: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

Line 1528: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;

1524:
1525: i NUMBER;
1526: l_org_id_vc VARCHAR(10);
1527: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1528: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1529: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1530: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1531: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1532: l_agreement_amount NUMBER;

Line 1529: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

1525: i NUMBER;
1526: l_org_id_vc VARCHAR(10);
1527: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1528: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1529: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1530: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1531: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1532: l_agreement_amount NUMBER;
1533: l_agreement_id NUMBER;

Line 1530: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

1526: l_org_id_vc VARCHAR(10);
1527: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1528: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1529: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1530: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1531: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1532: l_agreement_amount NUMBER;
1533: l_agreement_id NUMBER;
1534: l_amount NUMBER;

Line 1531: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

1527: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
1528: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
1529: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
1530: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
1531: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
1532: l_agreement_amount NUMBER;
1533: l_agreement_id NUMBER;
1534: l_amount NUMBER;
1535: l_diff_amount NUMBER;

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

1706: l_agreement_in_rec_new.agreement_num := l_agreement_in_rec_new.agreement_num || '*';
1707:
1708: END IF;
1709:
1710: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1711: p_commit => OKE_API.G_FALSE ,
1712: p_init_msg_list => OKE_API.G_FALSE ,
1713: p_msg_count => p_msg_count ,
1714: p_msg_data => p_msg_data ,

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

1785: END IF;
1786:
1787: l_agreement_in_rec.amount := 99999999999999999.99999;
1788:
1789: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
1790: p_commit => OKE_API.G_FALSE ,
1791: p_init_msg_list => OKE_API.G_FALSE ,
1792: p_msg_count => p_msg_count ,
1793: p_msg_data => p_msg_data ,

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

1851:
1852:
1853: l_agreement_in_rec_new.amount := 99999999999999999.99999;
1854:
1855: --oke_debug.debug('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1856: --dbms_output.put_line('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1857:
1858: IF (nvl(l_pa_org_id, -99) <> -1000) AND
1859: (i = nvl(l_pa_org_id, -99)) THEN

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

1852:
1853: l_agreement_in_rec_new.amount := 99999999999999999.99999;
1854:
1855: --oke_debug.debug('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1856: --dbms_output.put_line('calling pa_agreement_pub.update_agreement from upd_insert_agreement');
1857:
1858: IF (nvl(l_pa_org_id, -99) <> -1000) AND
1859: (i = nvl(l_pa_org_id, -99)) THEN
1860:

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

1864: l_agreement_in_rec_new.agreement_num := l_agreement_in_rec_new.agreement_num || '*';
1865:
1866: END IF;
1867:
1868: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1869: p_commit => OKE_API.G_FALSE ,
1870: p_init_msg_list => OKE_API.G_FALSE ,
1871: p_msg_count => p_msg_count ,
1872: p_msg_data => p_msg_data ,

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

1948: l_agreement_in_rec_new.pm_agreement_reference := '-Y-' || p_funding_source_id;
1949:
1950: END IF;
1951:
1952: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
1953: p_commit => OKE_API.G_FALSE ,
1954: p_init_msg_list => OKE_API.G_FALSE ,
1955: p_msg_count => p_msg_count ,
1956: p_msg_data => p_msg_data ,

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

2025: fnd_client_info.set_org_context(l_update.org_id);
2026:
2027: END IF;
2028:
2029: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2030: p_commit => OKE_API.G_FALSE ,
2031: p_init_msg_list => OKE_API.G_FALSE ,
2032: p_msg_count => p_msg_count ,
2033: p_msg_data => p_msg_data ,

Line 2068: PROCEDURE update_pa_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,

2064: -- Description: This procedure is used to agreement originally pushed from PA
2065: --
2066: --
2067: /*
2068: PROCEDURE update_pa_agreement(p_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE ,
2069: p_agreement_tbl AGREEMENT_TBL_TYPE ,
2070: p_funding_source_id NUMBER ,
2071: p_funding_amount NUMBER ,
2072: p_agreement_out_tbl OUT NOCOPY PA_AGREEMENT_TBL_TYPE ,

Line 2101: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

2097: where funding_source_id = p_funding_source_id;
2098:
2099: i NUMBER;
2100: l_org_id_vc VARCHAR(10);
2101: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2102: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2103: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2104: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2105: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

Line 2102: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;

2098:
2099: i NUMBER;
2100: l_org_id_vc VARCHAR(10);
2101: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2102: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2103: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2104: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2105: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2106: l_orig_pa_amount NUMBER;

Line 2103: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

2099: i NUMBER;
2100: l_org_id_vc VARCHAR(10);
2101: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2102: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2103: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2104: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2105: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2106: l_orig_pa_amount NUMBER;
2107: l_agreement_count NUMBER := 0;

Line 2104: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

2100: l_org_id_vc VARCHAR(10);
2101: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2102: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2103: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2104: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2105: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2106: l_orig_pa_amount NUMBER;
2107: l_agreement_count NUMBER := 0;
2108: l_sum_flag VARCHAR2(1);

Line 2105: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

2101: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
2102: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE := p_agreement_in_rec;
2103: l_agreement_in_rec_new PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;
2104: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
2105: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
2106: l_orig_pa_amount NUMBER;
2107: l_agreement_count NUMBER := 0;
2108: l_sum_flag VARCHAR2(1);
2109: l_update c_update_agreement%ROWTYPE;

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

2198: fnd_client_info.set_org_context(l_update.org_id);
2199:
2200: END IF;
2201:
2202: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2203: p_commit => OKE_API.G_FALSE ,
2204: p_init_msg_list => OKE_API.G_FALSE ,
2205: p_msg_count => p_msg_count ,
2206: p_msg_data => p_msg_data ,

Line 2357: -- PA_AGREEMENT_PUB.create_agreement

2353: -- OKE_API.end_activity
2354: -- OKE_FUNDING_UTIL_PKG.funding_mode
2355: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
2356: -- OKE_FUNDING_UTIL_PKG.update_source_flag
2357: -- PA_AGREEMENT_PUB.create_agreement
2358: -- add_pa_funding
2359: -- validate_agreement_attributes
2360: -- check_project_null
2361: -- get_term_id

Line 2468: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

2464: l_err_project_number VARCHAR2(25);
2465: l_level VARCHAR2(1);
2466: l_amount NUMBER;
2467: l_org_id_vc VARCHAR(10);
2468: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_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;

Line 2469: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

2465: l_level VARCHAR2(1);
2466: l_amount NUMBER;
2467: l_org_id_vc VARCHAR(10);
2468: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_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;

Line 2471: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

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

Line 2472: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

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

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

2797: p_reference => l_agreement_in_rec.pm_agreement_reference ,
2798: p_agreement_length => l_agreement_length
2799: );
2800:
2801: --oke_debug.debug('calling pa_agreement_pub.create_agreement');
2802:
2803: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2804:
2805: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,

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

2801: --oke_debug.debug('calling pa_agreement_pub.create_agreement');
2802:
2803: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2804:
2805: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
2806: p_commit => OKE_API.G_FALSE ,
2807: p_init_msg_list => OKE_API.G_FALSE ,
2808: p_msg_count => p_msg_count ,
2809: p_msg_data => p_msg_data ,

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

2972: );
2973:
2974: l_agreement_in_rec.agreement_currency_code := l_agreement_tbl(i).agreement_currency_code;
2975:
2976: --oke_debug.debug('calling pa_agreement_pub.update_agreement');
2977: --dbms_output.put_line('calling pa_agreement_pub.update_agreement');
2978:
2979: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2980:

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

2973:
2974: l_agreement_in_rec.agreement_currency_code := l_agreement_tbl(i).agreement_currency_code;
2975:
2976: --oke_debug.debug('calling pa_agreement_pub.update_agreement');
2977: --dbms_output.put_line('calling pa_agreement_pub.update_agreement');
2978:
2979: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2980:
2981: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,

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

2977: --dbms_output.put_line('calling pa_agreement_pub.update_agreement');
2978:
2979: --oke_debug.debug('agreement amount '|| l_agreement_in_rec.amount);
2980:
2981: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
2982: p_commit => OKE_API.G_FALSE ,
2983: p_init_msg_list => OKE_API.G_FALSE ,
2984: p_msg_count => p_msg_count ,
2985: p_msg_data => p_msg_data ,

Line 3291: l_agreement_in_rec PA_AGREEMENT_PUB.AGREEMENT_REC_IN_TYPE;

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

Line 3304: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;

3300: l_task_sum_tbl OKE_FUNDING_UTIL_PKG.TASK_SUM_TBL_TYPE;
3301: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3302: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3303: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3304: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3305: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
3306: l_org_id_vc VARCHAR(10);
3307: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
3308: l_err_project_number VARCHAR2(25);

Line 3305: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;

3301: l_funding_level_tbl OKE_FUNDING_UTIL_PKG.FUNDING_LEVEL_TBL_TYPE;
3302: -- l_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3303: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3304: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3305: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
3306: l_org_id_vc VARCHAR(10);
3307: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
3308: l_err_project_number VARCHAR2(25);
3309: l_level VARCHAR2(1);

Line 3307: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;

3303: --l_orig_pa_agreement_tbl PA_AGREEMENT_TBL_TYPE;
3304: l_funding_in_tbl PA_AGREEMENT_PUB.FUNDING_IN_TBL_TYPE;
3305: l_funding_out_tbl PA_AGREEMENT_PUB.FUNDING_OUT_TBL_TYPE;
3306: l_org_id_vc VARCHAR(10);
3307: l_agreement_out_rec PA_AGREEMENT_PUB.AGREEMENT_REC_OUT_TYPE;
3308: l_err_project_number VARCHAR2(25);
3309: l_level VARCHAR2(1);
3310: l_funding_in_rec OKE_FUNDSOURCE_PVT.FUNDING_REC_IN_TYPE;
3311: l_count NUMBER := 0;

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

3458: mo_global.set_policy_context('S',l_agreement.org_id);
3459:
3460: END IF;
3461:
3462: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
3463: p_commit => OKE_API.G_FALSE ,
3464: p_init_msg_list => OKE_API.G_FALSE ,
3465: p_msg_count => p_msg_count ,
3466: p_msg_data => p_msg_data ,

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

3622: );
3623:
3624: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3625:
3626: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3627: p_commit => OKE_API.G_FALSE ,
3628: p_init_msg_list => OKE_API.G_FALSE ,
3629: p_msg_count => p_msg_count ,
3630: p_msg_data => p_msg_data ,

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

3685: );
3686:
3687: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3688:
3689: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3690: p_commit => OKE_API.G_FALSE ,
3691: p_init_msg_list => OKE_API.G_FALSE ,
3692: p_msg_count => p_msg_count ,
3693: p_msg_data => p_msg_data ,

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

3774: );
3775:
3776: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
3777:
3778: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3779: p_commit => OKE_API.G_FALSE ,
3780: p_init_msg_list => OKE_API.G_FALSE ,
3781: p_msg_count => p_msg_count ,
3782: p_msg_data => p_msg_data ,

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

3934: );
3935:
3936: l_agreement_in_rec.agreement_currency_code := p_funding_in_rec.currency_code;
3937:
3938: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
3939: p_commit => OKE_API.G_FALSE ,
3940: p_init_msg_list => OKE_API.G_FALSE ,
3941: p_msg_count => p_msg_count ,
3942: p_msg_data => p_msg_data ,

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

3997: );
3998:
3999: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4000:
4001: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4002: p_commit => OKE_API.G_FALSE ,
4003: p_init_msg_list => OKE_API.G_FALSE ,
4004: p_msg_count => p_msg_count ,
4005: p_msg_data => p_msg_data ,

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

4086: );
4087:
4088: l_agreement_in_rec.agreement_currency_code := l_allocation.projfunc_currency_code;
4089:
4090: PA_AGREEMENT_PUB.create_agreement(p_api_version_number => p_api_version ,
4091: p_commit => OKE_API.G_FALSE ,
4092: p_init_msg_list => OKE_API.G_FALSE ,
4093: p_msg_count => p_msg_count ,
4094: p_msg_data => p_msg_data ,

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

4194: l_agreement_in_rec.amount := l_agreement.agreement_sum;
4195:
4196: END IF;
4197:
4198: PA_AGREEMENT_PUB.update_agreement(p_api_version_number => p_api_version ,
4199: p_commit => OKE_API.G_FALSE ,
4200: p_init_msg_list => OKE_API.G_FALSE ,
4201: p_msg_count => p_msg_count ,
4202: p_msg_data => p_msg_data ,

Line 4277: -- PA_AGREEMENT_PUB.update_funding

4273: -- Description: This procedure is used to update record in pa project funding table
4274: --
4275: -- Calling subprograms: OKE_API.start_activity
4276: -- OKE_API.end_activity
4277: -- PA_AGREEMENT_PUB.update_funding
4278: -- PA_AGREEMENT_PUB.add_funding
4279: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4280: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4281: -- validate_line_attributes

Line 4278: -- PA_AGREEMENT_PUB.add_funding

4274: --
4275: -- Calling subprograms: OKE_API.start_activity
4276: -- OKE_API.end_activity
4277: -- PA_AGREEMENT_PUB.update_funding
4278: -- PA_AGREEMENT_PUB.add_funding
4279: -- OKE_FUNDING_UTIL_PKG.get_converted_amount
4280: -- OKE_FUNDING_UTIL_PKG.update_alloc_version
4281: -- validate_line_attributes
4282: -- pa_update_or_add

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

4517: IF (l_add_flag = 'Y') THEN -- AND
4518: --(nvl(l_version, 0) <> 0 or p_allocation_in_rec.amount <> 0) THEN
4519:
4520: IF l_diff_amount<>0 THEN
4521: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4523:
4524: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4525: p_commit => OKE_API.G_FALSE ,

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

4518: --(nvl(l_version, 0) <> 0 or p_allocation_in_rec.amount <> 0) THEN
4519:
4520: IF l_diff_amount<>0 THEN
4521: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4523:
4524: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4525: p_commit => OKE_API.G_FALSE ,
4526: p_init_msg_list => OKE_API.G_FALSE ,

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

4520: IF l_diff_amount<>0 THEN
4521: --dbms_output.put_line('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4522: --oke_debug.debug('calling pa_agreement_pub.add_funding from oke_agreement_pvt');
4523:
4524: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4525: p_commit => OKE_API.G_FALSE ,
4526: p_init_msg_list => OKE_API.G_FALSE ,
4527: p_msg_count => p_msg_count ,
4528: p_msg_data => p_msg_data ,

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

4581: p_project_funding => l_project_funding
4582: );
4583:
4584:
4585: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4587:
4588: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4589: p_commit => OKE_API.G_FALSE ,

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

4582: );
4583:
4584:
4585: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4587:
4588: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4589: p_commit => OKE_API.G_FALSE ,
4590: p_init_msg_list => OKE_API.G_FALSE ,

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

4584:
4585: --dbms_output.put_line('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4586: --oke_debug.debug('calling pa_agreement_pub.update_funding from oke_agreement_pvt');
4587:
4588: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4589: p_commit => OKE_API.G_FALSE ,
4590: p_init_msg_list => OKE_API.G_FALSE ,
4591: p_msg_count => p_msg_count ,
4592: p_msg_data => p_msg_data ,

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

4651: -- syho, bug 2328311
4652: -- update the ff of the existing project funding lines
4653: --FOR l_project_funding IN c_project_funding (length(p_allocation_in_rec.fund_allocation_id)) LOOP
4654: /*
4655: PA_AGREEMENT_PUB.update_funding(p_api_version_number => p_api_version ,
4656: p_commit => OKE_API.G_FALSE ,
4657: p_init_msg_list => OKE_API.G_FALSE ,
4658: p_msg_count => p_msg_count ,
4659: p_msg_data => p_msg_data ,

Line 4764: -- PA_AGREEMENT_PUB.add_funding

4760: -- Description: This procedure is used to add pa funding
4761: --
4762: -- Calling subprograms: OKE_API.start_activity
4763: -- OKE_API.end_activity
4764: -- PA_AGREEMENT_PUB.add_funding
4765: -- validate_line_attributes
4766: -- get_converted_amount
4767: -- get_agreement_org
4768: --

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

4864: mo_global.set_policy_context('S',l_org_id_n);
4865:
4866: end if;
4867:
4868: --dbms_output.put_line('calling pa_agreement_pub.add_funding');
4869: --oke_debug.debug('calling pa_agreement_pub.add_funding');
4870:
4871: IF (p_allocation_in_rec.amount <> 0) THEN
4872:

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

4865:
4866: end if;
4867:
4868: --dbms_output.put_line('calling pa_agreement_pub.add_funding');
4869: --oke_debug.debug('calling pa_agreement_pub.add_funding');
4870:
4871: IF (p_allocation_in_rec.amount <> 0) THEN
4872:
4873: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,

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

4869: --oke_debug.debug('calling pa_agreement_pub.add_funding');
4870:
4871: IF (p_allocation_in_rec.amount <> 0) THEN
4872:
4873: PA_AGREEMENT_PUB.add_funding(p_api_version_number => p_api_version ,
4874: p_commit => OKE_API.G_FALSE ,
4875: p_init_msg_list => OKE_API.G_FALSE ,
4876: p_msg_count => p_msg_count ,
4877: p_msg_data => p_msg_data ,

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

4910:
4911: -- fnd_client_info.set_org_context(to_number(l_org_id_vc));
4912: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4913:
4914: --dbms_output.put_line('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4915: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4916:
4917: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4918:

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

4911: -- fnd_client_info.set_org_context(to_number(l_org_id_vc));
4912: mo_global.set_policy_context('S',to_number(l_org_id_vc));
4913:
4914: --dbms_output.put_line('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4915: --oke_debug.debug('finished pa_agreement_pub.add_funding w/ ' || p_return_status);
4916:
4917: IF (p_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) THEN
4918:
4919: RAISE OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;