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 1436: pa_fp_multi_currency_pkg.g_project_id := NULL;

1432: If P_PA_DEBUG_MODE = 'Y' Then
1433: print_msg(' ENTERED Initialize_fp_cur_details calling get_fp_options_data');
1434: End If;
1435: -- initialize --
1436: pa_fp_multi_currency_pkg.g_project_id := NULL;
1437: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;

Line 1437: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;

1433: print_msg(' ENTERED Initialize_fp_cur_details calling get_fp_options_data');
1434: End If;
1435: -- initialize --
1436: pa_fp_multi_currency_pkg.g_project_id := NULL;
1437: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;

Line 1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;

1434: End If;
1435: -- initialize --
1436: pa_fp_multi_currency_pkg.g_project_id := NULL;
1437: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;

Line 1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;

1435: -- initialize --
1436: pa_fp_multi_currency_pkg.g_project_id := NULL;
1437: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;

Line 1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;

1436: pa_fp_multi_currency_pkg.g_project_id := NULL;
1437: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;

Line 1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;

1437: pa_fp_multi_currency_pkg.g_fin_plan_type_id := NULL;
1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;

Line 1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;

1438: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type := NULL;
1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;

Line 1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;

1439: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type := NULL;
1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;

Line 1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;

1440: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date := NULL;
1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1448: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;

Line 1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;

1441: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type := NULL;
1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1448: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1449: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;

Line 1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;

1442: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type := NULL;
1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1448: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1449: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1450:

Line 1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;

1443: pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date := NULL;
1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1448: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1449: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1450:
1451: OPEN get_fp_options_data;

Line 1448: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;

1444: pa_fp_multi_currency_pkg.g_proj_cost_rate_type := NULL;
1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1448: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1449: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1450:
1451: OPEN get_fp_options_data;
1452: FETCH get_fp_options_data INTO

Line 1449: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;

1445: pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type := NULL;
1446: pa_fp_multi_currency_pkg.g_proj_cost_rate_date := NULL;
1447: pa_fp_multi_currency_pkg.g_proj_rev_rate_type := NULL;
1448: pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type := NULL;
1449: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1450:
1451: OPEN get_fp_options_data;
1452: FETCH get_fp_options_data INTO
1453: pa_fp_multi_currency_pkg.g_project_id

Line 1453: pa_fp_multi_currency_pkg.g_project_id

1449: pa_fp_multi_currency_pkg.g_proj_rev_rate_date := NULL;
1450:
1451: OPEN get_fp_options_data;
1452: FETCH get_fp_options_data INTO
1453: pa_fp_multi_currency_pkg.g_project_id
1454: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date

Line 1454: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id

1450:
1451: OPEN get_fp_options_data;
1452: FETCH get_fp_options_data INTO
1453: pa_fp_multi_currency_pkg.g_project_id
1454: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type

Line 1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type

1451: OPEN get_fp_options_data;
1452: FETCH get_fp_options_data INTO
1453: pa_fp_multi_currency_pkg.g_project_id
1454: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type

Line 1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type

1452: FETCH get_fp_options_data INTO
1453: pa_fp_multi_currency_pkg.g_project_id
1454: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date

Line 1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date

1453: pa_fp_multi_currency_pkg.g_project_id
1454: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type

Line 1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type

1454: ,pa_fp_multi_currency_pkg.g_fin_plan_type_id
1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type

Line 1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type

1455: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type
1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date

Line 1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date

1456: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type
1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type

Line 1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type

1457: ,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date
1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1465: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type

Line 1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type

1458: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type
1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1465: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1466: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;

Line 1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date

1459: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type
1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1465: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1466: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1467: CLOSE get_fp_options_data;

Line 1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type

1460: ,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date
1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1465: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1466: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1467: CLOSE get_fp_options_data;
1468: g_stage := 'Initialize_fp_cur_details:101';

Line 1465: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type

1461: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_type
1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1465: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1466: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1467: CLOSE get_fp_options_data;
1468: g_stage := 'Initialize_fp_cur_details:101';
1469:

Line 1466: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;

1462: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type
1463: ,pa_fp_multi_currency_pkg.g_proj_cost_rate_date
1464: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_type
1465: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type
1466: ,pa_fp_multi_currency_pkg.g_proj_rev_rate_date;
1467: CLOSE get_fp_options_data;
1468: g_stage := 'Initialize_fp_cur_details:101';
1469:
1470: print_msg('In Initialize_fp_cur_details Get Project Levle info');

Line 1472: pa_fp_multi_currency_pkg.g_project_number := NULL;

1468: g_stage := 'Initialize_fp_cur_details:101';
1469:
1470: print_msg('In Initialize_fp_cur_details Get Project Levle info');
1471: -- initialize --
1472: pa_fp_multi_currency_pkg.g_project_number := NULL;
1473: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;
1474: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1475:
1476: OPEN get_project_lvl_data;

Line 1473: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;

1469:
1470: print_msg('In Initialize_fp_cur_details Get Project Levle info');
1471: -- initialize --
1472: pa_fp_multi_currency_pkg.g_project_number := NULL;
1473: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;
1474: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1475:
1476: OPEN get_project_lvl_data;
1477: FETCH get_project_lvl_data INTO

Line 1474: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;

1470: print_msg('In Initialize_fp_cur_details Get Project Levle info');
1471: -- initialize --
1472: pa_fp_multi_currency_pkg.g_project_number := NULL;
1473: pa_fp_multi_currency_pkg.g_proj_currency_code := NULL;
1474: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1475:
1476: OPEN get_project_lvl_data;
1477: FETCH get_project_lvl_data INTO
1478: pa_fp_multi_currency_pkg.g_project_number

Line 1478: pa_fp_multi_currency_pkg.g_project_number

1474: pa_fp_multi_currency_pkg.g_projfunc_currency_code := NULL;
1475:
1476: OPEN get_project_lvl_data;
1477: FETCH get_project_lvl_data INTO
1478: pa_fp_multi_currency_pkg.g_project_number
1479: ,pa_fp_multi_currency_pkg.g_proj_currency_code
1480: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;
1481: ClOSE get_project_lvl_data;
1482: g_stage := 'Initialize_fp_cur_details:102';

Line 1479: ,pa_fp_multi_currency_pkg.g_proj_currency_code

1475:
1476: OPEN get_project_lvl_data;
1477: FETCH get_project_lvl_data INTO
1478: pa_fp_multi_currency_pkg.g_project_number
1479: ,pa_fp_multi_currency_pkg.g_proj_currency_code
1480: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;
1481: ClOSE get_project_lvl_data;
1482: g_stage := 'Initialize_fp_cur_details:102';
1483: RETURN;

Line 1480: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;

1476: OPEN get_project_lvl_data;
1477: FETCH get_project_lvl_data INTO
1478: pa_fp_multi_currency_pkg.g_project_number
1479: ,pa_fp_multi_currency_pkg.g_proj_currency_code
1480: ,pa_fp_multi_currency_pkg.g_projfunc_currency_code;
1481: ClOSE get_project_lvl_data;
1482: g_stage := 'Initialize_fp_cur_details:102';
1483: RETURN;
1484:

Line 7229: -- PROCEDURE convert_ra_txn_currency calls PA_FP_MULTI_CURRENCY_PKG.convert_mc_bult

7225: ,p_procedure_name => 'populate_spreadRecs');
7226: RAISE;
7227: END populate_spreadRecs;
7228: /*
7229: -- PROCEDURE convert_ra_txn_currency calls PA_FP_MULTI_CURRENCY_PKG.convert_mc_bult
7230: -- This is called when the Rate API returns Cost and Revenue in 2 different
7231: -- currencies and cost and revenue amounts are held in one budget line.
7232: -- If the budget is an Approved revenue budget, the project functional currency
7233: -- becomes the transaction currency upon return from this API. The transaction

Line 7265: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;

7261: ,x_msg_data OUT NOCOPY VARCHAR2) IS
7262:
7263: -----added global variables from the multi currency pkg
7264: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7265: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;

7262:
7263: -----added global variables from the multi currency pkg
7264: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7265: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7263: -----added global variables from the multi currency pkg
7264: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7265: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7264: /* Bug fix:3801261 l_bl_id_tab SYSTEM.pa_num_tbl_type; */
7265: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

7265: l_bl_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7266: l_resource_assignment_id_tab pa_fp_multi_currency_pkg.number_type_tab;
7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7267: l_start_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

7268: l_end_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

7269: l_txn_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7270: l_txn_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7271: l_txn_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7272: l_txn_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7273: l_projfunc_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7274: l_projfunc_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7275: l_projfunc_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7276: l_projfunc_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7277: l_projfunc_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7278: l_projfunc_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7279: l_projfunc_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

7280: l_projfunc_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

7281: l_projfunc_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;

7282: l_projfunc_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7283: l_projfunc_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7284: l_projfunc_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7285: l_projfunc_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7286: l_proj_currency_code_tab pa_fp_multi_currency_pkg.char240_type_tab;
7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

Line 7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;

7287: l_proj_cost_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;

7288: l_proj_cost_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;

7289: l_proj_cost_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

Line 7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;

7290: l_proj_cost_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

Line 7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7291: l_proj_rev_rate_type_tab pa_fp_multi_currency_pkg.char240_type_tab;
7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7299: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;

7292: l_proj_rev_rate_tab pa_fp_multi_currency_pkg.number_type_tab;
7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7299: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7300: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

Line 7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;

7293: l_proj_rev_rt_dt_typ_tab pa_fp_multi_currency_pkg.char240_type_tab;
7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7299: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7300: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7301:

Line 7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;

7294: l_proj_rev_rate_date_tab pa_fp_multi_currency_pkg.date_type_tab;
7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7299: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7300: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7301:
7302: l_return_status VARCHAR2(240);

Line 7299: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

7295: l_proj_raw_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7299: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7300: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7301:
7302: l_return_status VARCHAR2(240);
7303: l_msg_count NUMBER;

Line 7300: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;

7296: l_proj_burdened_cost_tab pa_fp_multi_currency_pkg.number_type_tab;
7297: l_proj_revenue_tab pa_fp_multi_currency_pkg.number_type_tab;
7298: l_proj_rejection_tab pa_fp_multi_currency_pkg.char30_type_tab;
7299: l_user_validate_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7300: l_status_flag_tab pa_fp_multi_currency_pkg.char240_type_tab;
7301:
7302: l_return_status VARCHAR2(240);
7303: l_msg_count NUMBER;
7304: l_msg_data VARCHAR2(2000);

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

7330: ,p_txn_currency_code
7331: ,nvl(p_txn_raw_cost,0)
7332: ,nvl(p_txn_burdened_cost,0)
7333: ,nvl(p_txn_revenue,0)
7334: ,nvl(r.projfunc_currency_code,pa_fp_multi_currency_pkg.g_projfunc_currency_code)
7335: ,nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type)
7336: ,DECODE(r.projfunc_cost_exchange_rate,null,
7337: DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',
7338: fp_cur_rec.projfunc_cost_exchange_rate,

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

7331: ,nvl(p_txn_raw_cost,0)
7332: ,nvl(p_txn_burdened_cost,0)
7333: ,nvl(p_txn_revenue,0)
7334: ,nvl(r.projfunc_currency_code,pa_fp_multi_currency_pkg.g_projfunc_currency_code)
7335: ,nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type)
7336: ,DECODE(r.projfunc_cost_exchange_rate,null,
7337: DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',
7338: fp_cur_rec.projfunc_cost_exchange_rate,
7339: r.projfunc_cost_exchange_rate),

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

7333: ,nvl(p_txn_revenue,0)
7334: ,nvl(r.projfunc_currency_code,pa_fp_multi_currency_pkg.g_projfunc_currency_code)
7335: ,nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type)
7336: ,DECODE(r.projfunc_cost_exchange_rate,null,
7337: DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',
7338: fp_cur_rec.projfunc_cost_exchange_rate,
7339: r.projfunc_cost_exchange_rate),
7340: r.projfunc_cost_exchange_rate)
7341: projfunc_cost_exchange_rate

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

7338: fp_cur_rec.projfunc_cost_exchange_rate,
7339: r.projfunc_cost_exchange_rate),
7340: r.projfunc_cost_exchange_rate)
7341: projfunc_cost_exchange_rate
7342: ,DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',Null,
7343: nvl(r.projfunc_cost_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type))
7344: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7345: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7346: 'START_DATE',r.start_date,

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

7339: r.projfunc_cost_exchange_rate),
7340: r.projfunc_cost_exchange_rate)
7341: projfunc_cost_exchange_rate
7342: ,DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',Null,
7343: nvl(r.projfunc_cost_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type))
7344: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7345: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7346: 'START_DATE',r.start_date,
7347: 'END_DATE' ,r.end_date,

Line 7345: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),

7341: projfunc_cost_exchange_rate
7342: ,DECODE(nvl(r.projfunc_cost_rate_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_type),'User',Null,
7343: nvl(r.projfunc_cost_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type))
7344: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7345: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7346: 'START_DATE',r.start_date,
7347: 'END_DATE' ,r.end_date,
7348: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7349: projfunc_cost_rate_date

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

7344: ,DECODE(nvl(r.projfunc_cost_rate_date_type,
7345: pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date_type),
7346: 'START_DATE',r.start_date,
7347: 'END_DATE' ,r.end_date,
7348: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7349: projfunc_cost_rate_date
7350: ,nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type)
7351: ,DECODE(r.projfunc_rev_exchange_rate,null,
7352: DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',

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

7346: 'START_DATE',r.start_date,
7347: 'END_DATE' ,r.end_date,
7348: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7349: projfunc_cost_rate_date
7350: ,nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type)
7351: ,DECODE(r.projfunc_rev_exchange_rate,null,
7352: DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',
7353: fp_cur_rec.projfunc_rev_exchange_rate,
7354: r.projfunc_rev_exchange_rate),

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

7348: nvl(r.projfunc_cost_rate_date,pa_fp_multi_currency_pkg.g_projfunc_cost_rate_date))
7349: projfunc_cost_rate_date
7350: ,nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type)
7351: ,DECODE(r.projfunc_rev_exchange_rate,null,
7352: DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',
7353: fp_cur_rec.projfunc_rev_exchange_rate,
7354: r.projfunc_rev_exchange_rate),
7355: r.projfunc_rev_exchange_rate)
7356: projfunc_rev_exchange_rate

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

7353: fp_cur_rec.projfunc_rev_exchange_rate,
7354: r.projfunc_rev_exchange_rate),
7355: r.projfunc_rev_exchange_rate)
7356: projfunc_rev_exchange_rate
7357: ,DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',NULL,
7358: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7359: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7360: 'START_DATE',r.start_date,
7361: 'END_DATE' ,r.end_date,

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

7354: r.projfunc_rev_exchange_rate),
7355: r.projfunc_rev_exchange_rate)
7356: projfunc_rev_exchange_rate
7357: ,DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',NULL,
7358: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7359: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7360: 'START_DATE',r.start_date,
7361: 'END_DATE' ,r.end_date,
7362: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))

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

7355: r.projfunc_rev_exchange_rate)
7356: projfunc_rev_exchange_rate
7357: ,DECODE(nvl(r.projfunc_rev_rate_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_type),'User',NULL,
7358: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7359: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7360: 'START_DATE',r.start_date,
7361: 'END_DATE' ,r.end_date,
7362: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7363: projfunc_rev_rate_date

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

7358: nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type))
7359: ,DECODE(nvl(r.projfunc_rev_rate_date_type,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date_type),
7360: 'START_DATE',r.start_date,
7361: 'END_DATE' ,r.end_date,
7362: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7363: projfunc_rev_rate_date
7364: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7365: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7366: ,DECODE(r.project_cost_exchange_rate,null,

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

7360: 'START_DATE',r.start_date,
7361: 'END_DATE' ,r.end_date,
7362: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7363: projfunc_rev_rate_date
7364: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7365: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7366: ,DECODE(r.project_cost_exchange_rate,null,
7367: DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',
7368: fp_cur_rec.project_cost_exchange_rate,

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

7361: 'END_DATE' ,r.end_date,
7362: nvl(r.projfunc_rev_rate_date,pa_fp_multi_currency_pkg.g_projfunc_rev_rate_date))
7363: projfunc_rev_rate_date
7364: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7365: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7366: ,DECODE(r.project_cost_exchange_rate,null,
7367: DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',
7368: fp_cur_rec.project_cost_exchange_rate,
7369: r.project_cost_exchange_rate),

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

7363: projfunc_rev_rate_date
7364: ,nvl(r.project_currency_code,pa_fp_multi_currency_pkg.g_proj_currency_code)
7365: ,nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type)
7366: ,DECODE(r.project_cost_exchange_rate,null,
7367: DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',
7368: fp_cur_rec.project_cost_exchange_rate,
7369: r.project_cost_exchange_rate),
7370: r.project_cost_exchange_rate)
7371: project_cost_exchange_rate

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

7368: fp_cur_rec.project_cost_exchange_rate,
7369: r.project_cost_exchange_rate),
7370: r.project_cost_exchange_rate)
7371: project_cost_exchange_rate
7372: ,DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',NULL,
7373: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7374: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7375: 'START_DATE',r.start_date,
7376: 'END_DATE' ,r.end_date,

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

7369: r.project_cost_exchange_rate),
7370: r.project_cost_exchange_rate)
7371: project_cost_exchange_rate
7372: ,DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',NULL,
7373: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7374: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7375: 'START_DATE',r.start_date,
7376: 'END_DATE' ,r.end_date,
7377: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))

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

7370: r.project_cost_exchange_rate)
7371: project_cost_exchange_rate
7372: ,DECODE(nvl(r.project_cost_rate_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_type),'User',NULL,
7373: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7374: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7375: 'START_DATE',r.start_date,
7376: 'END_DATE' ,r.end_date,
7377: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7378: project_cost_rate_date

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

7373: nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type))
7374: ,DECODE(nvl(r.project_cost_rate_date_type,pa_fp_multi_currency_pkg.g_proj_cost_rate_date_type),
7375: 'START_DATE',r.start_date,
7376: 'END_DATE' ,r.end_date,
7377: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7378: project_cost_rate_date
7379: ,nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type)
7380: ,DECODE(r.project_rev_exchange_rate,null,
7381: DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',

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

7375: 'START_DATE',r.start_date,
7376: 'END_DATE' ,r.end_date,
7377: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7378: project_cost_rate_date
7379: ,nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type)
7380: ,DECODE(r.project_rev_exchange_rate,null,
7381: DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',
7382: fp_cur_rec.project_rev_exchange_rate,
7383: r.project_rev_exchange_rate),

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

7377: nvl(r.project_cost_rate_date,pa_fp_multi_currency_pkg.g_proj_cost_rate_date))
7378: project_cost_rate_date
7379: ,nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type)
7380: ,DECODE(r.project_rev_exchange_rate,null,
7381: DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',
7382: fp_cur_rec.project_rev_exchange_rate,
7383: r.project_rev_exchange_rate),
7384: r.project_rev_exchange_rate)
7385: project_rev_exchange_rate

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

7382: fp_cur_rec.project_rev_exchange_rate,
7383: r.project_rev_exchange_rate),
7384: r.project_rev_exchange_rate)
7385: project_rev_exchange_rate
7386: ,DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',NULL,
7387: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7388: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7389: 'START_DATE',r.start_date,
7390: 'END_DATE' ,r.end_date,

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

7383: r.project_rev_exchange_rate),
7384: r.project_rev_exchange_rate)
7385: project_rev_exchange_rate
7386: ,DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',NULL,
7387: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7388: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7389: 'START_DATE',r.start_date,
7390: 'END_DATE' ,r.end_date,
7391: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))

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

7384: r.project_rev_exchange_rate)
7385: project_rev_exchange_rate
7386: ,DECODE(nvl(r.project_rev_rate_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_type),'User',NULL,
7387: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7388: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7389: 'START_DATE',r.start_date,
7390: 'END_DATE' ,r.end_date,
7391: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))
7392: project_rev_rate_date

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

7387: nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type))
7388: ,DECODE(nvl(r.project_rev_rate_date_type,pa_fp_multi_currency_pkg.g_proj_rev_rate_date_type),
7389: 'START_DATE',r.start_date,
7390: 'END_DATE' ,r.end_date,
7391: nvl(r.project_rev_rate_date,pa_fp_multi_currency_pkg.g_proj_rev_rate_date))
7392: project_rev_rate_date
7393: from pa_fp_rollup_tmp r
7394: where nvl(r.delete_flag,'N') = 'N'
7395: and r.budget_line_id = p_budget_line_id

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

7421: END IF;
7422: CLOSE cur_fp_cur_details;
7423:
7424: /*
7425: print_msg('ProjectCurr=> '||pa_fp_multi_currency_pkg.g_proj_currency_code);
7426: print_msg('ProjFuncCurr=> '||pa_fp_multi_currency_pkg.g_projfunc_currency_code);
7427: */
7428: l_stage := 6560;
7429: --print_msg(to_char(l_stage)||' In convert_ra_txn_currency');

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

7422: CLOSE cur_fp_cur_details;
7423:
7424: /*
7425: print_msg('ProjectCurr=> '||pa_fp_multi_currency_pkg.g_proj_currency_code);
7426: print_msg('ProjFuncCurr=> '||pa_fp_multi_currency_pkg.g_projfunc_currency_code);
7427: */
7428: l_stage := 6560;
7429: --print_msg(to_char(l_stage)||' In convert_ra_txn_currency');
7430: --Reset PL/SQL Tables.

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

7502: L_ROWCOUNT := l_bl_id_tab.count;
7503: --print_msg(to_char(l_stage)||' Number of rows fetched into tab['||L_ROWCOUNT||']');
7504: IF l_rowcount > 0 THEN
7505: l_stage := 6590;
7506: --print_msg(to_char(l_stage)||' Calling pa_fp_multi_currency_pkg.conv_mc_bulk');
7507: pa_fp_multi_currency_pkg.conv_mc_bulk (
7508: p_resource_assignment_id_tab => l_resource_assignment_id_tab
7509: ,p_start_date_tab => l_start_date_tab
7510: ,p_end_date_tab => l_end_date_tab

Line 7507: pa_fp_multi_currency_pkg.conv_mc_bulk (

7503: --print_msg(to_char(l_stage)||' Number of rows fetched into tab['||L_ROWCOUNT||']');
7504: IF l_rowcount > 0 THEN
7505: l_stage := 6590;
7506: --print_msg(to_char(l_stage)||' Calling pa_fp_multi_currency_pkg.conv_mc_bulk');
7507: pa_fp_multi_currency_pkg.conv_mc_bulk (
7508: p_resource_assignment_id_tab => l_resource_assignment_id_tab
7509: ,p_start_date_tab => l_start_date_tab
7510: ,p_end_date_tab => l_end_date_tab
7511: ,p_txn_currency_code_tab => l_txn_currency_code_tab

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

7540: ,x_msg_data => l_msg_data);
7541:
7542: l_entire_msg_count := nvl(l_entire_msg_count,0) + nvl(l_msg_count,0);
7543: l_entire_msg_data := l_msg_data;
7544: --print_msg('After calling pa_fp_multi_currency_pkg.conv_mc_bulk msgData['||l_msg_data||'RetSts['||l_return_status||']msgCt['||l_msg_count||']');
7545:
7546: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7547: l_stage := 6600;
7548: print_msg(to_char(l_stage)||' Errored In convert_ra_txn_currency');

Line 10979: pa_fp_multi_currency_pkg.convert_txn_currency

10975: print_msg(to_char(l_stage)||'Calling convert_txn_currency with the following parameters:');
10976: End if;
10977: l_pls_start_time := dbms_utility.get_time;
10978: --print_plsql_time('Start of Currency Conversion['||l_pls_start_time);
10979: pa_fp_multi_currency_pkg.convert_txn_currency
10980: ( p_budget_version_id => g_budget_version_id
10981: ,p_entire_version => 'N'
10982: ,p_calling_module => l_calling_module -- Added for Bug#5395732
10983: ,x_return_status => l_return_status