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.PA_FP_CALC_PLAN_PKG dependencies on PA_FP_MULTI_CURRENCY_PKG

Line 1406: pa_fp_multi_currency_pkg.g_project_id := NULL;

1402: If P_PA_DEBUG_MODE = 'Y' Then
1403: print_msg(' ENTERED Initialize_fp_cur_details calling get_fp_options_data');
1404: End If;
1405: -- initialize --
1406: pa_fp_multi_currency_pkg.g_project_id := NULL;
1407: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;

Line 1407: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;

1403: print_msg(' ENTERED Initialize_fp_cur_details calling get_fp_options_data');
1404: End If;
1405: -- initialize --
1406: pa_fp_multi_currency_pkg.g_project_id := NULL;
1407: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;

Line 1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;

1404: End If;
1405: -- initialize --
1406: pa_fp_multi_currency_pkg.g_project_id := NULL;
1407: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;

Line 1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;

1405: -- initialize --
1406: pa_fp_multi_currency_pkg.g_project_id := NULL;
1407: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;

Line 1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;

1406: pa_fp_multi_currency_pkg.g_project_id := NULL;
1407: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;

Line 1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;

1407: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;

Line 1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;

1408: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;

Line 1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;

1409: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;

Line 1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;

1410: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1418: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;

Line 1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;

1411: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1418: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1419: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;

Line 1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;

1412: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1418: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1419: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1420:

Line 1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;

1413: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1418: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1419: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1420:
1421: OPEN get_fp_options_data;

Line 1418: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;

1414: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1418: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1419: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1420:
1421: OPEN get_fp_options_data;
1422: FETCH get_fp_options_data INTO

Line 1419: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;

1415: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1416: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1417: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1418: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1419: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1420:
1421: OPEN get_fp_options_data;
1422: FETCH get_fp_options_data INTO
1423: pa_fp_multi_currency_pkg.g_project_id

Line 1423: pa_fp_multi_currency_pkg.g_project_id

1419: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1420:
1421: OPEN get_fp_options_data;
1422: FETCH get_fp_options_data INTO
1423: pa_fp_multi_currency_pkg.g_project_id
1424: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date

Line 1424: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id

1420:
1421: OPEN get_fp_options_data;
1422: FETCH get_fp_options_data INTO
1423: pa_fp_multi_currency_pkg.g_project_id
1424: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type

Line 1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type

1421: OPEN get_fp_options_data;
1422: FETCH get_fp_options_data INTO
1423: pa_fp_multi_currency_pkg.g_project_id
1424: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type

Line 1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type

1422: FETCH get_fp_options_data INTO
1423: pa_fp_multi_currency_pkg.g_project_id
1424: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date

Line 1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date

1423: pa_fp_multi_currency_pkg.g_project_id
1424: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type

Line 1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type

1424: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type

Line 1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type

1425: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date

Line 1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date

1426: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type

Line 1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type

1427: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1435: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type

Line 1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type

1428: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1435: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1436: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;

Line 1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date

1429: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1435: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1436: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1437: CLOSE get_fp_options_data;

Line 1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type

1430: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1435: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1436: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1437: CLOSE get_fp_options_data;
1438: g_stage := 'Initialize_fp_cur_details:101';

Line 1435: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type

1431: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1435: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1436: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1437: CLOSE get_fp_options_data;
1438: g_stage := 'Initialize_fp_cur_details:101';
1439:

Line 1436: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;

1432: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1433: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1434: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1435: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1436: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1437: CLOSE get_fp_options_data;
1438: g_stage := 'Initialize_fp_cur_details:101';
1439:
1440: print_msg('In Initialize_fp_cur_details Get Project Levle info');

Line 1442: pa_fp_multi_currency_pkg.g_project_number := NULL;

1438: g_stage := 'Initialize_fp_cur_details:101';
1439:
1440: print_msg('In Initialize_fp_cur_details Get Project Levle info');
1441: -- initialize --
1442: pa_fp_multi_currency_pkg.g_project_number := NULL;
1443: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;
1444: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1445:
1446: OPEN get_project_lvl_data;

Line 1443: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;

1439:
1440: print_msg('In Initialize_fp_cur_details Get Project Levle info');
1441: -- initialize --
1442: pa_fp_multi_currency_pkg.g_project_number := NULL;
1443: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;
1444: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1445:
1446: OPEN get_project_lvl_data;
1447: FETCH get_project_lvl_data INTO

Line 1444: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;

1440: print_msg('In Initialize_fp_cur_details Get Project Levle info');
1441: -- initialize --
1442: pa_fp_multi_currency_pkg.g_project_number := NULL;
1443: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;
1444: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1445:
1446: OPEN get_project_lvl_data;
1447: FETCH get_project_lvl_data INTO
1448: pa_fp_multi_currency_pkg.g_project_number

Line 1448: pa_fp_multi_currency_pkg.g_project_number

1444: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1445:
1446: OPEN get_project_lvl_data;
1447: FETCH get_project_lvl_data INTO
1448: pa_fp_multi_currency_pkg.g_project_number
1449: ,pa_fp_multi_currency_pkg.g_proj_currency_code
1450: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;
1451: ClOSE get_project_lvl_data;
1452: g_stage := 'Initialize_fp_cur_details:102';

Line 1449: ,pa_fp_multi_currency_pkg.g_proj_currency_code

1445:
1446: OPEN get_project_lvl_data;
1447: FETCH get_project_lvl_data INTO
1448: pa_fp_multi_currency_pkg.g_project_number
1449: ,pa_fp_multi_currency_pkg.g_proj_currency_code
1450: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;
1451: ClOSE get_project_lvl_data;
1452: g_stage := 'Initialize_fp_cur_details:102';
1453: RETURN;

Line 1450: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;

1446: OPEN get_project_lvl_data;
1447: FETCH get_project_lvl_data INTO
1448: pa_fp_multi_currency_pkg.g_project_number
1449: ,pa_fp_multi_currency_pkg.g_proj_currency_code
1450: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;
1451: ClOSE get_project_lvl_data;
1452: g_stage := 'Initialize_fp_cur_details:102';
1453: RETURN;
1454:

Line 7139: -- PROCEDURE convert_ra_txn_currency calls PA_FP_MULTI_CURRENCY_PKG.convert_mc_bult

7135: ,p_procedure_name => 'populate_spreadRecs');
7136: RAISE;
7137: END populate_spreadRecs;
7138: /*
7139: -- PROCEDURE convert_ra_txn_currency calls PA_FP_MULTI_CURRENCY_PKG.convert_mc_bult
7140: -- This is called when the Rate API returns Cost and Revenue in 2 different
7141: -- currencies and cost and revenue amounts are held in one budget line.
7142: -- If the budget is an Approved revenue budget, the project functional currency
7143: -- becomes the transaction currency upon return from this API. The transaction

Line 7175: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;

7171: ,x_msg_data OUT NOCOPY VARCHAR2) IS
7172:
7173: -----added global variables from the multi currency pkg
7174: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7175: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7176: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7176: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;

7172:
7173: -----added global variables from the multi currency pkg
7174: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7175: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7176: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7173: -----added global variables from the multi currency pkg
7174: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7175: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7176: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7174: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7175: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7176: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

7175: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7176: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7176: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7177: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

7178: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

7179: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7180: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7181: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7182: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7183: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7184: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7185: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7186: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7187: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7188: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7189: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

7190: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

7191: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

7192: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7193: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7194: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7195: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7196: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7197: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7198: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7199: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7200: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7201: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7209: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7202: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7209: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7210: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

7203: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7209: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7210: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7211:

Line 7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

7204: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7209: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7210: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7211:
7212: l_return_status VARCHAR2(240);

Line 7209: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

7205: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7209: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7210: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7211:
7212: l_return_status VARCHAR2(240);
7213: l_msg_count NUMBER;

Line 7210: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

7206: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7207: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7208: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7209: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7210: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7211:
7212: l_return_status VARCHAR2(240);
7213: l_msg_count NUMBER;
7214: l_msg_data VARCHAR2(2000);

Line 7244: ,nvl(r.projfunc_currency_code,pa_fp_multi_currency_pkg.g_projfunc_currency_code)

7240: ,p_txn_currency_code
7241: ,nvl(p_txn_raw_cost,0)
7242: ,nvl(p_txn_burdened_cost,0)
7243: ,nvl(p_txn_revenue,0)
7244: ,nvl(r.projfunc_currency_code,pa_fp_multi_currency_pkg.g_projfunc_currency_code)
7245: ,nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type)
7246: ,DECODE(r.projfunc_cost_exchange_rate,null,
7247: DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',
7248: fp_cur_rec.projfunc_cost_exchange_rate,

Line 7245: ,nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type)

7241: ,nvl(p_txn_raw_cost,0)
7242: ,nvl(p_txn_burdened_cost,0)
7243: ,nvl(p_txn_revenue,0)
7244: ,nvl(r.projfunc_currency_code,pa_fp_multi_currency_pkg.g_projfunc_currency_code)
7245: ,nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type)
7246: ,DECODE(r.projfunc_cost_exchange_rate,null,
7247: DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',
7248: fp_cur_rec.projfunc_cost_exchange_rate,
7249: r.projfunc_cost_exchange_rate),

Line 7247: DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',

7243: ,nvl(p_txn_revenue,0)
7244: ,nvl(r.projfunc_currency_code,pa_fp_multi_currency_pkg.g_projfunc_currency_code)
7245: ,nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type)
7246: ,DECODE(r.projfunc_cost_exchange_rate,null,
7247: DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',
7248: fp_cur_rec.projfunc_cost_exchange_rate,
7249: r.projfunc_cost_exchange_rate),
7250: r.projfunc_cost_exchange_rate)
7251: projfunc_cost_exchange_rate

Line 7252: ,DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',Null,

7248: fp_cur_rec.projfunc_cost_exchange_rate,
7249: r.projfunc_cost_exchange_rate),
7250: r.projfunc_cost_exchange_rate)
7251: projfunc_cost_exchange_rate
7252: ,DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',Null,
7253: nvl(r.projfunc_cost_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type))
7254: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7255: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7256: 'START_DATE',r.start_date,

Line 7253: nvl(r.projfunc_cost_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type))

7249: r.projfunc_cost_exchange_rate),
7250: r.projfunc_cost_exchange_rate)
7251: projfunc_cost_exchange_rate
7252: ,DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',Null,
7253: nvl(r.projfunc_cost_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type))
7254: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7255: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7256: 'START_DATE',r.start_date,
7257: 'END_DATE' ,r.end_date,

Line 7255: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),

7251: projfunc_cost_exchange_rate
7252: ,DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',Null,
7253: nvl(r.projfunc_cost_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type))
7254: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7255: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7256: 'START_DATE',r.start_date,
7257: 'END_DATE' ,r.end_date,
7258: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7259: projfunc_cost_rate_date

Line 7258: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))

7254: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7255: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7256: 'START_DATE',r.start_date,
7257: 'END_DATE' ,r.end_date,
7258: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7259: projfunc_cost_rate_date
7260: ,nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type)
7261: ,DECODE(r.projfunc_rev_exchange_rate,null,
7262: DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',

Line 7260: ,nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type)

7256: 'START_DATE',r.start_date,
7257: 'END_DATE' ,r.end_date,
7258: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7259: projfunc_cost_rate_date
7260: ,nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type)
7261: ,DECODE(r.projfunc_rev_exchange_rate,null,
7262: DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',
7263: fp_cur_rec.projfunc_rev_exchange_rate,
7264: r.projfunc_rev_exchange_rate),

Line 7262: DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',

7258: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7259: projfunc_cost_rate_date
7260: ,nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type)
7261: ,DECODE(r.projfunc_rev_exchange_rate,null,
7262: DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',
7263: fp_cur_rec.projfunc_rev_exchange_rate,
7264: r.projfunc_rev_exchange_rate),
7265: r.projfunc_rev_exchange_rate)
7266: projfunc_rev_exchange_rate

Line 7267: ,DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',NULL,

7263: fp_cur_rec.projfunc_rev_exchange_rate,
7264: r.projfunc_rev_exchange_rate),
7265: r.projfunc_rev_exchange_rate)
7266: projfunc_rev_exchange_rate
7267: ,DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',NULL,
7268: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7269: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7270: 'START_DATE',r.start_date,
7271: 'END_DATE' ,r.end_date,

Line 7268: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))

7264: r.projfunc_rev_exchange_rate),
7265: r.projfunc_rev_exchange_rate)
7266: projfunc_rev_exchange_rate
7267: ,DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',NULL,
7268: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7269: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7270: 'START_DATE',r.start_date,
7271: 'END_DATE' ,r.end_date,
7272: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))

Line 7269: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),

7265: r.projfunc_rev_exchange_rate)
7266: projfunc_rev_exchange_rate
7267: ,DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',NULL,
7268: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7269: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7270: 'START_DATE',r.start_date,
7271: 'END_DATE' ,r.end_date,
7272: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7273: projfunc_rev_rate_date

Line 7272: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))

7268: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7269: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7270: 'START_DATE',r.start_date,
7271: 'END_DATE' ,r.end_date,
7272: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7273: projfunc_rev_rate_date
7274: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7275: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7276: ,DECODE(r.project_cost_exchange_rate,null,

Line 7274: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)

7270: 'START_DATE',r.start_date,
7271: 'END_DATE' ,r.end_date,
7272: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7273: projfunc_rev_rate_date
7274: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7275: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7276: ,DECODE(r.project_cost_exchange_rate,null,
7277: DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',
7278: fp_cur_rec.project_cost_exchange_rate,

Line 7275: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)

7271: 'END_DATE' ,r.end_date,
7272: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7273: projfunc_rev_rate_date
7274: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7275: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7276: ,DECODE(r.project_cost_exchange_rate,null,
7277: DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',
7278: fp_cur_rec.project_cost_exchange_rate,
7279: r.project_cost_exchange_rate),

Line 7277: DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',

7273: projfunc_rev_rate_date
7274: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7275: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7276: ,DECODE(r.project_cost_exchange_rate,null,
7277: DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',
7278: fp_cur_rec.project_cost_exchange_rate,
7279: r.project_cost_exchange_rate),
7280: r.project_cost_exchange_rate)
7281: project_cost_exchange_rate

Line 7282: ,DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',NULL,

7278: fp_cur_rec.project_cost_exchange_rate,
7279: r.project_cost_exchange_rate),
7280: r.project_cost_exchange_rate)
7281: project_cost_exchange_rate
7282: ,DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',NULL,
7283: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7284: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7285: 'START_DATE',r.start_date,
7286: 'END_DATE' ,r.end_date,

Line 7283: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))

7279: r.project_cost_exchange_rate),
7280: r.project_cost_exchange_rate)
7281: project_cost_exchange_rate
7282: ,DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',NULL,
7283: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7284: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7285: 'START_DATE',r.start_date,
7286: 'END_DATE' ,r.end_date,
7287: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))

Line 7284: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),

7280: r.project_cost_exchange_rate)
7281: project_cost_exchange_rate
7282: ,DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',NULL,
7283: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7284: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7285: 'START_DATE',r.start_date,
7286: 'END_DATE' ,r.end_date,
7287: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7288: project_cost_rate_date

Line 7287: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))

7283: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7284: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7285: 'START_DATE',r.start_date,
7286: 'END_DATE' ,r.end_date,
7287: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7288: project_cost_rate_date
7289: ,nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type)
7290: ,DECODE(r.project_rev_exchange_rate,null,
7291: DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',

Line 7289: ,nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type)

7285: 'START_DATE',r.start_date,
7286: 'END_DATE' ,r.end_date,
7287: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7288: project_cost_rate_date
7289: ,nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type)
7290: ,DECODE(r.project_rev_exchange_rate,null,
7291: DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',
7292: fp_cur_rec.project_rev_exchange_rate,
7293: r.project_rev_exchange_rate),

Line 7291: DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',

7287: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7288: project_cost_rate_date
7289: ,nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type)
7290: ,DECODE(r.project_rev_exchange_rate,null,
7291: DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',
7292: fp_cur_rec.project_rev_exchange_rate,
7293: r.project_rev_exchange_rate),
7294: r.project_rev_exchange_rate)
7295: project_rev_exchange_rate

Line 7296: ,DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',NULL,

7292: fp_cur_rec.project_rev_exchange_rate,
7293: r.project_rev_exchange_rate),
7294: r.project_rev_exchange_rate)
7295: project_rev_exchange_rate
7296: ,DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',NULL,
7297: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7298: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7299: 'START_DATE',r.start_date,
7300: 'END_DATE' ,r.end_date,

Line 7297: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))

7293: r.project_rev_exchange_rate),
7294: r.project_rev_exchange_rate)
7295: project_rev_exchange_rate
7296: ,DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',NULL,
7297: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7298: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7299: 'START_DATE',r.start_date,
7300: 'END_DATE' ,r.end_date,
7301: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))

Line 7298: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),

7294: r.project_rev_exchange_rate)
7295: project_rev_exchange_rate
7296: ,DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',NULL,
7297: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7298: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7299: 'START_DATE',r.start_date,
7300: 'END_DATE' ,r.end_date,
7301: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))
7302: project_rev_rate_date

Line 7301: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))

7297: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7298: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7299: 'START_DATE',r.start_date,
7300: 'END_DATE' ,r.end_date,
7301: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))
7302: project_rev_rate_date
7303: from pa_fp_rollup_tmp r
7304: where nvl(r.delete_flag,'N') = 'N'
7305: and r.budget_line_id = p_budget_line_id

Line 7335: print_msg('ProjectCurr=> '||pa_fp_multi_currency_pkg.g_proj_currency_code);

7331: END IF;
7332: CLOSE cur_fp_cur_details;
7333:
7334: /*
7335: print_msg('ProjectCurr=> '||pa_fp_multi_currency_pkg.g_proj_currency_code);
7336: print_msg('ProjFuncCurr=> '||pa_fp_multi_currency_pkg.g_projfunc_currency_code);
7337: */
7338: l_stage := 6560;
7339: --print_msg(to_char(l_stage)||' In convert_ra_txn_currency');

Line 7336: print_msg('ProjFuncCurr=> '||pa_fp_multi_currency_pkg.g_projfunc_currency_code);

7332: CLOSE cur_fp_cur_details;
7333:
7334: /*
7335: print_msg('ProjectCurr=> '||pa_fp_multi_currency_pkg.g_proj_currency_code);
7336: print_msg('ProjFuncCurr=> '||pa_fp_multi_currency_pkg.g_projfunc_currency_code);
7337: */
7338: l_stage := 6560;
7339: --print_msg(to_char(l_stage)||' In convert_ra_txn_currency');
7340: --Reset PL/SQL Tables.

Line 7416: --print_msg(to_char(l_stage)||' Calling pa_fp_multi_currency_pkg.conv_mc_bulk');

7412: L_ROWCOUNT := l_bl_id_tab.count;
7413: --print_msg(to_char(l_stage)||' Number of rows fetched into tab['||L_ROWCOUNT||']');
7414: IF l_rowcount > 0 THEN
7415: l_stage := 6590;
7416: --print_msg(to_char(l_stage)||' Calling pa_fp_multi_currency_pkg.conv_mc_bulk');
7417: pa_fp_multi_currency_pkg.conv_mc_bulk (
7418: p_resource_assignment_id_tab => l_resource_assignment_id_tab
7419: ,p_start_date_tab => l_start_date_tab
7420: ,p_end_date_tab => l_end_date_tab

Line 7417: pa_fp_multi_currency_pkg.conv_mc_bulk (

7413: --print_msg(to_char(l_stage)||' Number of rows fetched into tab['||L_ROWCOUNT||']');
7414: IF l_rowcount > 0 THEN
7415: l_stage := 6590;
7416: --print_msg(to_char(l_stage)||' Calling pa_fp_multi_currency_pkg.conv_mc_bulk');
7417: pa_fp_multi_currency_pkg.conv_mc_bulk (
7418: p_resource_assignment_id_tab => l_resource_assignment_id_tab
7419: ,p_start_date_tab => l_start_date_tab
7420: ,p_end_date_tab => l_end_date_tab
7421: ,p_txn_currency_code_tab => l_txn_currency_code_tab

Line 7454: --print_msg('After calling pa_fp_multi_currency_pkg.conv_mc_bulk msgData['||l_msg_data||'RetSts['||l_return_status||']msgCt['||l_msg_count||']');

7450: ,x_msg_data => l_msg_data);
7451:
7452: l_entire_msg_count := nvl(l_entire_msg_count,0) + nvl(l_msg_count,0);
7453: l_entire_msg_data := l_msg_data;
7454: --print_msg('After calling pa_fp_multi_currency_pkg.conv_mc_bulk msgData['||l_msg_data||'RetSts['||l_return_status||']msgCt['||l_msg_count||']');
7455:
7456: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7457: l_stage := 6600;
7458: print_msg(to_char(l_stage)||' Errored In convert_ra_txn_currency');

Line 10825: pa_fp_multi_currency_pkg.convert_txn_currency

10821: print_msg(to_char(l_stage)||'Calling convert_txn_currency with the following parameters:');
10822: End if;
10823: l_pls_start_time := dbms_utility.get_time;
10824: --print_plsql_time('Start of Currency Conversion['||l_pls_start_time);
10825: pa_fp_multi_currency_pkg.convert_txn_currency
10826: ( p_budget_version_id => g_budget_version_id
10827: ,p_entire_version => 'N'
10828: ,p_calling_module => l_calling_module -- Added for Bug#5395732
10829: ,x_return_status => l_return_status