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_UPGRADE_PKG dependencies on PA_PROJ_FP_OPTIONS

Line 106: FROM pa_proj_fp_options ppfo

102: AND bt.budget_type_code = pt.migrated_frm_bdgt_typ_code
103: AND NVL(bt.plan_type,'BUDGET') = 'BUDGET'
104: AND not exists
105: (SELECT 1
106: FROM pa_proj_fp_options ppfo
107: WHERE ppfo.project_id = c_project_id
108: AND ppfo.fin_plan_type_id = pt.fin_plan_type_id
109: AND ppfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE)
110: AND exists

Line 152: FROM pa_proj_fp_options pfo,

148: budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING) )
149: AND c_budget_statuses = 'CWB')
150: AND (c_mode = 'PRE_UPGRADE' OR EXISTS (
151: SELECT 1
152: FROM pa_proj_fp_options pfo,
153: pa_fin_plan_types_b pt /* Bug# 2661650 - Replaced _vl by _b for performance reasons */
154: WHERE pfo.project_id = c_project_id
155: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
156: AND pt.fin_plan_type_id = pfo.fin_plan_type_id

Line 169: p_project_id IN pa_proj_fp_options.project_id%TYPE

165: option changes. The api populates the local variables using the inputs and
166: the business rules for upgrade process.
167: ==============================================================================*/
168: Procedure Populate_Local_Variables(
169: p_project_id IN pa_proj_fp_options.project_id%TYPE
170: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
171: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
172: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
173: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type

Line 171: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

167: ==============================================================================*/
168: Procedure Populate_Local_Variables(
169: p_project_id IN pa_proj_fp_options.project_id%TYPE
170: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
171: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
172: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
173: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 172: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE

168: Procedure Populate_Local_Variables(
169: p_project_id IN pa_proj_fp_options.project_id%TYPE
170: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
171: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
172: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
173: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
175: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
176: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 956: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

952: l_msg_index_out NUMBER;
953: l_debug_mode VARCHAR2(30);
954:
955: l_project_id pa_projects.project_id%TYPE;
956: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
957: l_upgrade_elements_rec upgrade_elements_rec_type;
958:
959: l_proj_validation_status VARCHAR2(30);
960: l_retcode number;

Line 964: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

960: l_retcode number;
961: l_errbuf varchar2(512);
962:
963: /* Bug #2727377 */
964: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
965: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
966:
967: BEGIN
968: x_msg_count := 0;

Line 965: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

961: l_errbuf varchar2(512);
962:
963: /* Bug #2727377 */
964: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
965: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
966:
967: BEGIN
968: x_msg_count := 0;
969: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1094: FROM pa_proj_fp_options

1090:
1091: BEGIN
1092: SELECT proj_fp_options_id
1093: INTO l_proj_fp_options_id
1094: FROM pa_proj_fp_options
1095: WHERE project_id = l_project_id
1096: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
1097:
1098: -- The follwing variable indicates if there are any project level exceptions

Line 1146: retrieved from pa_proj_fp_options_table. */

1142: /* 2727377: Added call to copy_fp_txn_currencies API to populate the currencies
1143: in pa_fp_txn_currencies. The source fp option ID is being passed as NULL as
1144: the source is determined in copy_fp_txn_currencies API in case the source is
1145: not passed. Plan in multi currency flag and the fp_preference_code is
1146: retrieved from pa_proj_fp_options_table. */
1147:
1148: SELECT fin_plan_preference_code, plan_in_multi_curr_flag
1149: INTO l_fp_preference_code, l_multi_curr_flag
1150: FROM pa_proj_fp_options

Line 1150: FROM pa_proj_fp_options

1146: retrieved from pa_proj_fp_options_table. */
1147:
1148: SELECT fin_plan_preference_code, plan_in_multi_curr_flag
1149: INTO l_fp_preference_code, l_multi_curr_flag
1150: FROM pa_proj_fp_options
1151: WHERE proj_fp_options_id = l_proj_fp_options_id;
1152:
1153: IF p_pa_debug_mode = 'Y' THEN
1154: pa_debug.g_err_stage := 'Calling copy_fp_txn_currencies for project';

Line 1563: This process will create record in pa_proj_fp_options table for the project,

1559:
1560: END Upgrade_Budget_Types;
1561:
1562: /*==============================================================================
1563: This process will create record in pa_proj_fp_options table for the project,
1564: plan type and plan version levels. It will create fp option only at the level
1565: for which this api is called.
1566: Bug#2731534: The api has been modified to default MC conversion attributes from
1567: project level(pa_projects_all) for the plan type and plan version fp options if

Line 1571: p_project_id IN pa_proj_fp_options.project_id%TYPE

1567: project level(pa_projects_all) for the plan type and plan version fp options if
1568: Project currency <> Projfunc Currency for the project.
1569: ===============================================================================*/
1570: PROCEDURE Create_fp_options(
1571: p_project_id IN pa_proj_fp_options.project_id%TYPE
1572: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
1573: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
1574: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
1575: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

Line 1573: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE

1569: ===============================================================================*/
1570: PROCEDURE Create_fp_options(
1571: p_project_id IN pa_proj_fp_options.project_id%TYPE
1572: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
1573: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
1574: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
1575: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
1576: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
1577: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1574: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE

1570: PROCEDURE Create_fp_options(
1571: p_project_id IN pa_proj_fp_options.project_id%TYPE
1572: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
1573: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
1574: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
1575: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
1576: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
1577: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1578: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1575: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895

1571: p_project_id IN pa_proj_fp_options.project_id%TYPE
1572: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
1573: ,p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
1574: ,p_fin_plan_option_level IN pa_proj_fp_options.fin_plan_option_level_code%TYPE
1575: ,x_proj_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
1576: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type
1577: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1578: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1579: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895

Line 1588: l_target_proj_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;

1584: l_data VARCHAR2(2000);
1585: l_msg_index_out NUMBER;
1586: l_debug_mode VARCHAR2(30);
1587:
1588: l_target_proj_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1589: l_approved_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
1590: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1591:
1592: l_upgrade_elements_rec upgrade_elements_rec_type;

Line 1589: l_approved_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;

1585: l_msg_index_out NUMBER;
1586: l_debug_mode VARCHAR2(30);
1587:
1588: l_target_proj_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1589: l_approved_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
1590: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1591:
1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:

Line 1590: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;

1586: l_debug_mode VARCHAR2(30);
1587:
1588: l_target_proj_fp_option_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1589: l_approved_cost_plan_type_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
1590: l_approved_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
1591:
1592: l_upgrade_elements_rec upgrade_elements_rec_type;
1593:
1594: l_multi_currency_billing_flag pa_projects_all.multi_currency_billing_flag%TYPE;

Line 1636: pa_debug.g_err_stage := 'Calling Create_FP_Option of PA_PROJ_FP_OPTIONS_PUB';

1632: end if;
1633:
1634: --Calling create_fp_option api to create an option
1635: IF p_pa_debug_mode = 'Y' THEN
1636: pa_debug.g_err_stage := 'Calling Create_FP_Option of PA_PROJ_FP_OPTIONS_PUB';
1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1638: END IF;
1639: PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option (
1640: px_target_proj_fp_option_id => l_target_proj_fp_option_id

Line 1639: PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option (

1635: IF p_pa_debug_mode = 'Y' THEN
1636: pa_debug.g_err_stage := 'Calling Create_FP_Option of PA_PROJ_FP_OPTIONS_PUB';
1637: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
1638: END IF;
1639: PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option (
1640: px_target_proj_fp_option_id => l_target_proj_fp_option_id
1641: ,p_source_proj_fp_option_id => NULL
1642: ,p_target_fp_option_level_code => l_upgrade_elements_rec.curr_option_level_code
1643: ,p_target_fp_preference_code => l_upgrade_elements_rec.curr_option_preference_code

Line 1691: UPDATE PA_PROJ_FP_OPTIONS

1687: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP)
1688: AND (l_upgrade_elements_rec.basis_cost_bem IS NOT NULL)
1689: THEN
1690:
1691: UPDATE PA_PROJ_FP_OPTIONS
1692: SET cost_fin_plan_level_code = l_upgrade_elements_rec.basis_cost_planning_level
1693: ,cost_time_phased_code = l_upgrade_elements_rec.basis_cost_time_phased_code
1694: ,cost_resource_list_id = l_upgrade_elements_rec.basis_cost_res_list_id
1695: ,cost_amount_set_id = l_upgrade_elements_rec.basis_cost_amount_set_id

Line 1710: UPDATE PA_PROJ_FP_OPTIONS

1706: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP)
1707: AND (l_upgrade_elements_rec.basis_rev_bem IS NOT NULL)
1708: THEN
1709:
1710: UPDATE PA_PROJ_FP_OPTIONS
1711: SET revenue_fin_plan_level_code = l_upgrade_elements_rec.basis_rev_planning_level
1712: ,revenue_time_phased_code = l_upgrade_elements_rec.basis_rev_time_phased_code
1713: ,revenue_resource_list_id = l_upgrade_elements_rec.basis_rev_res_list_id
1714: ,revenue_amount_set_id = l_upgrade_elements_rec.basis_rev_amount_Set_id

Line 1752: UPDATE PA_PROJ_FP_OPTIONS

1748: -- Populate the MC conversion attributes for the fp option if MC enabled
1749:
1750: IF l_project_currency_code <> l_projfunc_currency_code THEN
1751:
1752: UPDATE PA_PROJ_FP_OPTIONS
1753: SET projfunc_cost_rate_type = l_projfunc_cost_rate_type
1754: ,projfunc_cost_rate_date_type = PA_FP_CONSTANTS_PKG.G_RATE_DATE_TYPE_START_DATE
1755: ,projfunc_rev_rate_type = l_projfunc_bil_rate_type
1756: ,projfunc_rev_rate_date_type = PA_FP_CONSTANTS_PKG.G_RATE_DATE_TYPE_START_DATE

Line 1838: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

1834: l_data VARCHAR2(2000);
1835: l_msg_index_out NUMBER;
1836: l_debug_mode VARCHAR2(30);
1837:
1838: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1839:
1840: l_upgrade_elements_rec upgrade_elements_rec_type;
1841:
1842: l_validation_status VARCHAR2(30);

Line 1845: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

1841:
1842: l_validation_status VARCHAR2(30);
1843:
1844: /* Bug #2727377 */
1845: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1846: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1847:
1848: BEGIN
1849:

Line 1846: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

1842: l_validation_status VARCHAR2(30);
1843:
1844: /* Bug #2727377 */
1845: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1846: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1847:
1848: BEGIN
1849:
1850: x_msg_count := 0;

Line 1933: retrieved from pa_proj_fp_options_table. */

1929: /* 2727377: Added call to copy_fp_txn_currencies API to populate the currencies
1930: in pa_fp_txn_currencies. The source fp option ID is being passed as NULL as
1931: the source is determined in copy_fp_txn_currencies API in case the source is
1932: not passed. Plan in multi currency flag and the fp_preference_code is
1933: retrieved from pa_proj_fp_options_table. */
1934:
1935: SELECT fin_plan_preference_code, plan_in_multi_curr_flag
1936: INTO l_fp_preference_code, l_multi_curr_flag
1937: FROM pa_proj_fp_options

Line 1937: FROM pa_proj_fp_options

1933: retrieved from pa_proj_fp_options_table. */
1934:
1935: SELECT fin_plan_preference_code, plan_in_multi_curr_flag
1936: INTO l_fp_preference_code, l_multi_curr_flag
1937: FROM pa_proj_fp_options
1938: WHERE proj_fp_options_id = l_proj_fp_options_id;
1939:
1940: IF p_pa_debug_mode = 'Y' THEN
1941: pa_debug.g_err_stage := 'Calling copy_fp_txn_currencies for plan type';

Line 2033: 1.Create record in PA_PROJ_FP_OPTIONS for the budget version.

2029: END Add_Plan_Types;
2030: /*=============================================================================
2031: This api will upgrade all the budget versions eligible for upgrade based upon the
2032: input.This api will do the following:-
2033: 1.Create record in PA_PROJ_FP_OPTIONS for the budget version.
2034: 2.Create fp elements
2035: 3.Update Budget Version in PA_BUDGET_VERSIONS
2036: 4.Create resource assignments
2037: 5.Roll up resource assignments

Line 2077: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

2073: l_approved_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;
2074: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2075: l_prev_budget_type_code pa_budget_versions.budget_type_code%TYPE;
2076:
2077: l_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
2078:
2079: l_upgrade_elements_rec upgrade_elements_rec_type;
2080:
2081: /* Bug #2727377 */

Line 2082: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

2078:
2079: l_upgrade_elements_rec upgrade_elements_rec_type;
2080:
2081: /* Bug #2727377 */
2082: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2083: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2084:
2085: -- Bug 3673111, 07-JUN-04, jwhite -----------------------------------------------
2086:

Line 2083: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

2079: l_upgrade_elements_rec upgrade_elements_rec_type;
2080:
2081: /* Bug #2727377 */
2082: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2083: l_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2084:
2085: -- Bug 3673111, 07-JUN-04, jwhite -----------------------------------------------
2086:
2087:

Line 2112: l_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;

2108: l_upg_raw_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2109: l_upg_burd_cost_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2110: l_upg_bill_rate_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2111: l_upg_non_rb_ra_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
2112: l_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2113:
2114: -- bug 4865563: added the followings
2115: l_fp_cols_rec_var PA_FP_GEN_AMOUNT_UTILS.FP_COLS;
2116:

Line 2209: retrieved from pa_proj_fp_options_table. */

2205: /* 2727377: Added call to copy_fp_txn_currencies API to populate the currencies
2206: in pa_fp_txn_currencies. The source fp option ID is being passed as NULL as
2207: the source is determined in copy_fp_txn_currencies API in case the source is
2208: not passed. Plan in multi currency flag and the fp_preference_code is
2209: retrieved from pa_proj_fp_options_table. */
2210:
2211: SELECT fin_plan_preference_code, plan_in_multi_curr_flag
2212: INTO l_fp_preference_code, l_multi_curr_flag
2213: FROM pa_proj_fp_options

Line 2213: FROM pa_proj_fp_options

2209: retrieved from pa_proj_fp_options_table. */
2210:
2211: SELECT fin_plan_preference_code, plan_in_multi_curr_flag
2212: INTO l_fp_preference_code, l_multi_curr_flag
2213: FROM pa_proj_fp_options
2214: WHERE proj_fp_options_id = l_proj_fp_options_id;
2215:
2216: IF p_pa_debug_mode = 'Y' THEN
2217: pa_debug.g_err_stage := 'Calling copy_fp_txn_currencies for version';

Line 2498: FROM pa_proj_fp_options

2494: IF l_upg_bl_id_tbl.COUNT>0 THEN
2495:
2496: SELECT fin_plan_preference_code
2497: INTO l_pref_code
2498: FROM pa_proj_fp_options
2499: WHERE fin_plan_version_id=l_budget_ver_tbl(m);
2500:
2501:
2502: --Call the API to correct the budget line amounts/rates

Line 2928: FROM pa_proj_fp_options ppfo

2924: WHERE DECODE(c_budget_types,'ALL','Y', bt.upgrade_budget_type_flag) = 'Y'
2925: AND NVL(bt.plan_type,'BUDGET') = 'BUDGET'
2926: AND NOT EXISTS
2927: (SELECT 1
2928: FROM pa_proj_fp_options ppfo
2929: ,pa_fin_plan_types_b pt
2930: WHERE pt.migrated_frm_bdgt_typ_code = bt.budget_type_code
2931: AND ppfo.project_id = c_project_id
2932: AND ppfo.fin_plan_type_id = pt.fin_plan_type_id

Line 3776: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE

3772: --ASSUMPTIONS
3773: --1.Input is ordered by resource assignment id ,quantities with NULLS coming first
3774: --2.0(Zero)s are passed as input for amounts instead of NULL.
3775: PROCEDURE Apply_Calculate_FPM_Rules
3776: ( p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
3777: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
3778: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
3779: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
3780: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type

Line 4353: l_op_id pa_proj_fp_options.proj_fp_options_id%TYPE;

4349: l_project_id pa_projects.project_id%TYPE;
4350: l_bv_id pa_budget_versions.budget_version_id%TYPE;
4351: l_budg_ver_id pa_budget_versions.budget_version_id%TYPE;
4352: l_ci_id pa_control_items.ci_id%TYPE;
4353: l_op_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4354:
4355: /* For bug 5084161 */
4356: l_ci_status_code pa_control_items.status_code%TYPE;
4357: l_process_flag varchar2(1);

Line 4390: pa_proj_fp_options op

4386: FROM pa_projects prj,
4387: pa_budget_versions bv,
4388: pa_fin_plan_types_b fp,
4389: pa_control_items ci,
4390: pa_proj_fp_options op
4391: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)
4392: AND DECODE(c_project_statuses,'ALL','ACTIVE',prj.project_status_code) = 'ACTIVE'
4393: AND bv.project_id = prj.project_id
4394: and bv.fin_plan_type_id = fp.fin_plan_type_id