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_BUDGET_VERSIONS

Line 12: pa_budget_versions.budget_type_code%TYPE INDEX BY BINARY_INTEGER;

8: TYPE res_list_tbl IS TABLE OF
9: pa_resource_lists_all_bg.resource_list_id%TYPE INDEX BY BINARY_INTEGER;
10:
11: TYPE bud_typ_code_tbl IS TABLE OF
12: pa_budget_versions.budget_type_code%TYPE INDEX BY BINARY_INTEGER;
13:
14: TYPE ra_id_tbl_type IS TABLE OF
15: pa_resource_assignments.resource_assignment_id%TYPE INDEX BY BINARY_INTEGER;
16:

Line 112: FROM pa_budget_versions pbv

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
111: (SELECT 1
112: FROM pa_budget_versions pbv
113: WHERE pbv.project_id = c_project_id
114: AND pbv.budget_type_code = bt.budget_type_code);
115:
116: attached_plan_types_rec attached_plan_types_cur%ROWTYPE;

Line 133: FROM pa_budget_versions bv,

129: SELECT budget_version_id
130: , bt.budget_type_code
131: , bv.resource_list_id /* bug 3673111, 07-JUN-4, jwhite: New Column */
132: , bv.budget_status_code -- Bug# 7187487
133: FROM pa_budget_versions bv,
134: pa_budget_types bt
135: WHERE bv.project_id = c_project_id
136: AND bt.budget_type_code = bv.budget_type_code
137: AND bv.budget_type_code IS NOT NULL

Line 170: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

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
174: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 196: c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) IS

192: l_track_as_labor_flag pa_resource_list_members.track_as_labor_flag%TYPE;
193: l_resource_id pa_resource_list_members.resource_id%TYPE;
194:
195: CURSOR budget_version_info_cur(
196: c_budget_version_id IN pa_budget_versions.budget_version_id%TYPE) IS
197: SELECT pbv.budget_entry_method_code budget_entry_method_code
198: ,resource_list_id
199: ,entry_level_code
200: ,time_phased_type_code

Line 206: FROM pa_budget_versions pbv,

202: ,raw_cost_flag
203: ,burdened_cost_flag
204: ,rev_quantity_flag
205: ,revenue_flag
206: FROM pa_budget_versions pbv,
207: pa_budget_entry_methods pbem
208: WHERE pbv.budget_version_id = c_budget_version_id
209: AND pbem.budget_entry_method_code = pbv.budget_entry_method_code;
210:

Line 1572: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

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
1576: ,x_upgrade_elements_rec OUT NOCOPY pa_fp_upgrade_pkg.upgrade_elements_rec_type

Line 2035: 3.Update Budget Version in PA_BUDGET_VERSIONS

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
2038: 6.Create period denorm records for the budget.
2039:

Line 2071: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2067: l_data VARCHAR2(2000);
2068: l_msg_index_out NUMBER;
2069: l_debug_mode VARCHAR2(30);
2070:
2071: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2072: l_version_type pa_budget_versions.version_type%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;

Line 2072: l_version_type pa_budget_versions.version_type%TYPE;

2068: l_msg_index_out NUMBER;
2069: l_debug_mode VARCHAR2(30);
2070:
2071: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2072: l_version_type pa_budget_versions.version_type%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:

Line 2073: l_approved_cost_plan_type_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE;

2069: l_debug_mode VARCHAR2(30);
2070:
2071: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2072: l_version_type pa_budget_versions.version_type%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;

Line 2074: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

2070:
2071: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2072: l_version_type pa_budget_versions.version_type%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:

Line 2075: l_prev_budget_type_code pa_budget_versions.budget_type_code%TYPE;

2071: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2072: l_version_type pa_budget_versions.version_type%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;

Line 2268: UPDATE PA_BUDGET_VERSIONS

2264: END IF;
2265:
2266: /* FP M related columns upgrade is done by pa_budget_attr_upgr_pkg.budget_attr_upgrd later in the api. */
2267:
2268: UPDATE PA_BUDGET_VERSIONS
2269: SET budget_type_code = NULL,
2270: version_name = nvl(version_name,to_char(version_number)),-- Added for Bug 6722317
2271: fin_plan_type_id = l_upgrade_elements_rec.curr_option_plan_type_id,
2272: version_type = l_version_type,

Line 2937: FROM pa_budget_versions pbv

2933: AND ppfo.fin_plan_type_id = pt.fin_plan_type_id
2934: AND ppfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE)
2935: AND EXISTS
2936: (SELECT 1
2937: FROM pa_budget_versions pbv
2938: WHERE pbv.project_id = c_project_id
2939: AND pbv.budget_type_code = bt.budget_type_code);
2940:
2941: attached_budget_types_rec attached_budget_types_cur%ROWTYPE;

Line 3233: p_project_id IN pa_budget_versions.project_id%TYPE

3229: we do not find them there then raise exception for the project.
3230: ==================================================================*/
3231:
3232: PROCEDURE VALIDATE_PROJECT (
3233: p_project_id IN pa_budget_versions.project_id%TYPE
3234: ,x_validation_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3235: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3236: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3237: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3406: p_project_id IN pa_budget_versions.project_id%TYPE

3402: done at the budget type level.
3403: ==================================================================*/
3404:
3405: PROCEDURE VALIDATE_PROJECT_PLAN_TYPE (
3406: p_project_id IN pa_budget_versions.project_id%TYPE
3407: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
3408: ,x_validation_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3409: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3410: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 3407: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

3403: ==================================================================*/
3404:
3405: PROCEDURE VALIDATE_PROJECT_PLAN_TYPE (
3406: p_project_id IN pa_budget_versions.project_id%TYPE
3407: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
3408: ,x_validation_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3409: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3410: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3411: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3424: l_draft_version_id pa_budget_versions.budget_version_id%TYPE;

3420: l_err_code NUMBER;
3421: l_err_stage VARCHAR2(2000);
3422: l_err_stack VARCHAR2(2000);
3423:
3424: l_draft_version_id pa_budget_versions.budget_version_id%TYPE;
3425: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
3426:
3427: ---------- Variables Used for get_budget_ctrl_options api --------------
3428: l_fck_req_flag VARCHAR2(1);

Line 3425: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

3421: l_err_stage VARCHAR2(2000);
3422: l_err_stack VARCHAR2(2000);
3423:
3424: l_draft_version_id pa_budget_versions.budget_version_id%TYPE;
3425: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
3426:
3427: ---------- Variables Used for get_budget_ctrl_options api --------------
3428: l_fck_req_flag VARCHAR2(1);
3429: l_bdgt_intg_flag VARCHAR2(1);

Line 3430: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE;

3426:
3427: ---------- Variables Used for get_budget_ctrl_options api --------------
3428: l_fck_req_flag VARCHAR2(1);
3429: l_bdgt_intg_flag VARCHAR2(1);
3430: l_bdgt_ver_id pa_budget_versions.budget_version_id%TYPE;
3431: l_encum_type_id pa_budgetary_control_options.encumbrance_type_id%TYPE;
3432: l_balance_type pa_budgetary_control_options.balance_type%TYPE ;
3433: ---------- Variables Used for get_budget_ctrl_options api --------------
3434:

Line 3553: FROM pa_budget_versions

3549:
3550: BEGIN
3551: SELECT budget_status_code
3552: INTO l_budget_status_code
3553: FROM pa_budget_versions
3554: WHERE budget_version_id = l_draft_version_id;
3555: EXCEPTION
3556: WHEN OTHERS THEN
3557: IF attached_plan_types_cur%ISOPEN THEN

Line 3658: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

3654: ii)else we flush the plsql tables and move to next task.
3655: ====================================================================*/
3656:
3657: PROCEDURE VALIDATE_BUDGET_VERSION
3658: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
3659: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3660: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
3661: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3662: AS

Line 3674: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS

3670:
3671: l_task_id pa_tasks.task_id%TYPE;
3672:
3673: CURSOR budget_version_info_cur
3674: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
3675: SELECT project_id,
3676: budget_type_code,
3677: resource_list_id
3678: FROM pa_budget_versions

Line 3678: FROM pa_budget_versions

3674: (c_budget_version_id pa_budget_versions.budget_version_id%TYPE) IS
3675: SELECT project_id,
3676: budget_type_code,
3677: resource_list_id
3678: FROM pa_budget_versions
3679: WHERE budget_Version_id = c_budget_version_id;
3680:
3681: budget_version_info_rec budget_version_info_cur%ROWTYPE;
3682:

Line 4351: l_bv_id pa_budget_versions.budget_version_id%TYPE;

4347: l_debug_mode VARCHAR2(30);
4348: l_error_msg_code VARCHAR2(2000);
4349:
4350: l_project_id pa_projects.project_id%TYPE;
4351: l_bv_id pa_budget_versions.budget_version_id%TYPE;
4352: l_budg_ver_id pa_budget_versions.budget_version_id%TYPE;
4353: l_ci_id pa_control_items.ci_id%TYPE;
4354: l_op_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4355:

Line 4352: l_budg_ver_id pa_budget_versions.budget_version_id%TYPE;

4348: l_error_msg_code VARCHAR2(2000);
4349:
4350: l_project_id pa_projects.project_id%TYPE;
4351: l_bv_id pa_budget_versions.budget_version_id%TYPE;
4352: l_budg_ver_id pa_budget_versions.budget_version_id%TYPE;
4353: l_ci_id pa_control_items.ci_id%TYPE;
4354: l_op_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4355:
4356: /* For bug 5084161 */

Line 4388: pa_budget_versions bv,

4384: bv.ci_id,
4385: op.proj_fp_options_id,
4386: ci.status_code
4387: FROM pa_projects prj,
4388: pa_budget_versions bv,
4389: pa_fin_plan_types_b fp,
4390: pa_control_items ci,
4391: pa_proj_fp_options op
4392: WHERE segment1 BETWEEN NVL(c_from_project_number,segment1) AND NVL(c_to_project_number,segment1)

Line 4555: FROM pa_budget_versions bv

4551: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
4552: END IF;
4553:
4554: SELECT bv.budget_version_id INTO l_budg_ver_id
4555: FROM pa_budget_versions bv
4556: WHERE bv.budget_version_id = l_bv_id
4557: FOR UPDATE OF bv.budget_version_id NOWAIT;
4558:
4559: IF p_pa_debug_mode = 'Y' THEN