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 1586: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1582:
1583: l_fin_plan_option_level_code pa_proj_fp_options.FIN_PLAN_OPTION_LEVEL_CODE%TYPE;
1584: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
1585:
1586: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1587: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1588: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1589:
1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

Line 1587: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1583: l_fin_plan_option_level_code pa_proj_fp_options.FIN_PLAN_OPTION_LEVEL_CODE%TYPE;
1584: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
1585:
1586: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1587: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1588: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1589:
1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1591:

Line 1588: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1584: l_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
1585:
1586: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1587: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1588: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1589:
1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1591:
1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

Line 1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;

1586: l_cost_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1587: l_revenue_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1588: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1589:
1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1591:
1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

Line 1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

1588: l_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1589:
1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1591:
1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;

Line 1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;

1589:
1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1591:
1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;

Line 1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

1590: l_target_all_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
1591:
1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1598:

Line 1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;

1591:
1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1598:
1599: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

Line 1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;

1592: l_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1598:
1599: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1600: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;

Line 1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;

1593: l_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1594: l_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1598:
1599: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1600: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1601: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

Line 1599: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;

1595: l_cost_qty_flag pa_fin_plan_amount_sets.cost_qty_flag%TYPE ;
1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1598:
1599: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1600: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1601: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1602:
1603: -- FP M dev effort Defined new variables

Line 1600: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;

1596: l_revenue_qty_flag pa_fin_plan_amount_sets.revenue_qty_flag%TYPE ;
1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1598:
1599: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1600: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1601: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1602:
1603: -- FP M dev effort Defined new variables
1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;

Line 1601: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;

1597: l_all_qty_flag pa_fin_plan_amount_sets.all_qty_flag%TYPE ;
1598:
1599: l_target_raw_cost_flag pa_fin_plan_amount_sets.raw_cost_flag%TYPE ;
1600: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1601: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1602:
1603: -- FP M dev effort Defined new variables
1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

Line 1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;

1600: l_target_burdened_cost_flag pa_fin_plan_amount_sets.burdened_cost_flag%TYPE;
1601: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1602:
1603: -- FP M dev effort Defined new variables
1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1606: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1607: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1608: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

Line 1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

1601: l_target_revenue_flag pa_fin_plan_amount_sets.revenue_flag%TYPE ;
1602:
1603: -- FP M dev effort Defined new variables
1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1606: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1607: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1608: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1609: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;

Line 1606: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;

1602:
1603: -- FP M dev effort Defined new variables
1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1606: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1607: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1608: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1609: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1610:

Line 1607: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;

1603: -- FP M dev effort Defined new variables
1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1606: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1607: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1608: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1609: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1610:
1611: BEGIN

Line 1608: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;

1604: l_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1606: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1607: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1608: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1609: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1610:
1611: BEGIN
1612: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1609: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;

1605: l_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1606: l_burden_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1607: l_target_bill_rate_flag pa_fin_plan_amount_sets.bill_rate_flag%TYPE ;
1608: l_target_cost_rate_flag pa_fin_plan_amount_sets.cost_rate_flag%TYPE;
1609: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1610:
1611: BEGIN
1612: IF P_PA_DEBUG_MODE = 'Y' THEN
1613: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options');

Line 1727: FROM pa_fin_plan_amount_sets

1723: , l_target_revenue_flag
1724: , l_target_bill_rate_flag
1725: , l_target_cost_rate_flag
1726: , l_target_burd_rate_flag
1727: FROM pa_fin_plan_amount_sets
1728: WHERE fin_plan_amount_set_id = l_target_all_amount_set_id ;
1729: END IF;
1730:
1731: END IF;

Line 1761: FROM pa_fin_plan_amount_sets

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

Line 1783: FROM pa_fin_plan_amount_sets

1779: , l_burdened_cost_flag
1780: , l_bill_rate_flag -- FP M Dev effort
1781: , l_cost_rate_flag -- FP M Dev effort
1782: , l_burden_rate_flag -- FP M Dev effort
1783: FROM pa_fin_plan_amount_sets
1784: WHERE fin_plan_amount_set_id = l_revenue_amount_set_id ;
1785: END IF;
1786:
1787: IF l_all_amount_set_id IS NOT NULL THEN

Line 1805: FROM pa_fin_plan_amount_sets

1801: , l_revenue_flag
1802: , l_bill_rate_flag -- FP M Dev effort
1803: , l_cost_rate_flag -- FP M Dev effort
1804: , l_burden_rate_flag -- FP M Dev effort
1805: FROM pa_fin_plan_amount_sets
1806: WHERE fin_plan_amount_set_id = l_all_amount_set_id ;
1807: END IF;
1808:
1809: /* reset all the amount set ids as their role is over */