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_PROJ_FP_OPTIONS_PUB dependencies on PA_FIN_PLAN_AMOUNT_SETS

Line 1565: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1561:
1562: l_fin_plan_option_level_code pa_proj_fp_options.FIN_PLAN_OPTION_LEVEL_CODE%TYPE;
1563: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
1564:
1565: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1566: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1567: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1568:
1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 1566: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1562: l_fin_plan_option_level_code pa_proj_fp_options.FIN_PLAN_OPTION_LEVEL_CODE%TYPE;
1563: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
1564:
1565: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1566: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1567: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1568:
1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1570:

Line 1567: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1563: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
1564:
1565: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1566: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1567: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1568:
1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1570:
1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

Line 1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1565: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1566: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1567: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1568:
1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1570:
1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

Line 1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

1567: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1568:
1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1570:
1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;

Line 1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;

1568:
1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1570:
1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;

Line 1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

1569: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1570:
1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1577:

Line 1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;

1570:
1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1577:
1578: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

Line 1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;

1571: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1577:
1578: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1579: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;

Line 1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;

1572: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1573: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1577:
1578: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1579: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1580: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

Line 1578: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

1574: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1577:
1578: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1579: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1580: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1581:
1582: -- FP M dev effort Defined new variables

Line 1579: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;

1575: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1577:
1578: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1579: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1580: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1581:
1582: -- FP M dev effort Defined new variables
1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;

Line 1580: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

1576: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1577:
1578: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1579: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1580: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1581:
1582: -- FP M dev effort Defined new variables
1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

Line 1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;

1579: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1580: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1581:
1582: -- FP M dev effort Defined new variables
1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1585: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1586: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1587: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

Line 1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

1580: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1581:
1582: -- FP M dev effort Defined new variables
1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1585: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1586: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1587: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1588: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;

Line 1585: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;

1581:
1582: -- FP M dev effort Defined new variables
1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1585: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1586: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1587: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1588: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1589:

Line 1586: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;

1582: -- FP M dev effort Defined new variables
1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1585: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1586: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1587: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1588: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1589:
1590: BEGIN

Line 1587: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

1583: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1585: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1586: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1587: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1588: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1589:
1590: BEGIN
1591: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1588: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;

1584: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1585: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1586: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1587: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1588: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1589:
1590: BEGIN
1591: IF P_PA_DEBUG_MODE = 'Y' THEN
1592: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options');

Line 1706: FROM pa_fin_plan_amount_sets

1702: , l_target_revenue_flag
1703: , l_target_bill_rate_flag
1704: , l_target_cost_rate_flag
1705: , l_target_burd_rate_flag
1706: FROM pa_fin_plan_amount_sets
1707: WHERE fin_plan_amount_set_id = l_target_all_amount_set_id ;
1708: END IF;
1709:
1710: END IF;

Line 1740: FROM pa_fin_plan_amount_sets

1736: , l_revenue_flag
1737: , l_bill_rate_flag -- FP M Dev effort
1738: , l_cost_rate_flag -- FP M Dev effort
1739: , l_burden_rate_flag -- FP M Dev effort
1740: FROM pa_fin_plan_amount_sets
1741: WHERE fin_plan_amount_set_id = l_cost_amount_set_id ;
1742: END IF;
1743:
1744: IF l_revenue_amount_set_id IS NOT NULL THEN

Line 1762: FROM pa_fin_plan_amount_sets

1758: , l_burdened_cost_flag
1759: , l_bill_rate_flag -- FP M Dev effort
1760: , l_cost_rate_flag -- FP M Dev effort
1761: , l_burden_rate_flag -- FP M Dev effort
1762: FROM pa_fin_plan_amount_sets
1763: WHERE fin_plan_amount_set_id = l_revenue_amount_set_id ;
1764: END IF;
1765:
1766: IF l_all_amount_set_id IS NOT NULL THEN

Line 1784: FROM pa_fin_plan_amount_sets

1780: , l_revenue_flag
1781: , l_bill_rate_flag -- FP M Dev effort
1782: , l_cost_rate_flag -- FP M Dev effort
1783: , l_burden_rate_flag -- FP M Dev effort
1784: FROM pa_fin_plan_amount_sets
1785: WHERE fin_plan_amount_set_id = l_all_amount_set_id ;
1786: END IF;
1787:
1788: /* reset all the amount set ids as their role is over */