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_BUDGET_PVT dependencies on PA_BUDGET_VERSIONS

Line 162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895

158: ,px_resource_list_name IN OUT NOCOPY pa_resource_lists_tl.name%TYPE --File.Sql.39 bug 4440895
159: ,px_resource_list_id IN OUT NOCOPY pa_resource_lists_all_bg.resource_list_id%TYPE --File.Sql.39 bug 4440895
160: ,px_fin_plan_type_id IN OUT NOCOPY pa_fin_plan_types_b.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
161: ,px_fin_plan_type_name IN OUT NOCOPY pa_fin_plan_types_tl.name%TYPE --File.Sql.39 bug 4440895
162: ,px_version_type IN OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
163: ,px_fin_plan_level_code IN OUT NOCOPY pa_proj_fp_options.cost_fin_plan_level_code%TYPE --File.Sql.39 bug 4440895
164: ,px_time_phased_code IN OUT NOCOPY pa_proj_fp_options.cost_time_phased_code%TYPE --File.Sql.39 bug 4440895
165: ,px_plan_in_multi_curr_flag IN OUT NOCOPY pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --File.Sql.39 bug 4440895
166: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

Line 186: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

182: ,px_revenue_qty_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
183: ,px_all_qty_flag IN OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
184: ,p_create_new_curr_working_flag IN VARCHAR2
185: ,p_replace_current_working_flag IN VARCHAR2
186: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
187: ,p_calling_module IN VARCHAR2
188: ,p_using_resource_lists_flag IN VARCHAR2
189: ,x_budget_amount_code OUT NOCOPY pa_budget_types.budget_amount_code%TYPE --Added for bug 4224464. --File.Sql.39 bug 4440895
190: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 299: FROM pa_budget_versions

295: ,c_budget_type_code VARCHAR2 )
296: IS
297: SELECT budget_version_id
298: ,budget_status_code
299: FROM pa_budget_versions
300: WHERE project_id = c_project_id
301: AND budget_type_code = c_budget_type_code
302: AND budget_status_code IN ('W','S')
303: AND ci_id IS NULL; -- Bug # 3507156 --Added an extra clause ci_id IS NULL

Line 316: FROM pa_budget_versions

312: SELECT budget_version_id
313: ,budget_status_code
314: ,record_version_number
315: ,plan_processing_code
316: FROM pa_budget_versions
317: WHERE project_id = c_project_id
318: AND fin_plan_type_id = c_fin_plan_type_id
319: AND current_working_flag='Y'
320: AND version_type = c_version_type

Line 346: FROM pa_budget_versions bv

342: -- Cursor to lock the version
343: CURSOR l_lock_old_budget_csr( c_budget_version_id NUMBER )
344: IS
345: SELECT 'x'
346: FROM pa_budget_versions bv
347: ,pa_resource_assignments ra
348: ,pa_budget_lines bl
349: WHERE bv.budget_version_id = c_budget_version_id
350: AND bv.budget_version_id = ra.budget_version_id (+)

Line 382: l_old_budget_version_id pa_budget_versions.budget_version_id%TYPE;

378: l_editable_flag VARCHAR2(1);
379:
380: l_copy_conv_attr boolean;
381: l_conv_attrs_to_be_validated VARCHAR2(10);
382: l_old_budget_version_id pa_budget_versions.budget_version_id%TYPE;
383: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
384: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
385:
386: l_allow_cost_budget_entry_flag pa_project_types_all.allow_cost_budget_entry_flag%TYPE;

Line 383: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

379:
380: l_copy_conv_attr boolean;
381: l_conv_attrs_to_be_validated VARCHAR2(10);
382: l_old_budget_version_id pa_budget_versions.budget_version_id%TYPE;
383: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
384: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
385:
386: l_allow_cost_budget_entry_flag pa_project_types_all.allow_cost_budget_entry_flag%TYPE;
387: l_allow_rev_budget_entry_flag pa_project_types_all.allow_rev_budget_entry_flag%TYPE;

Line 449: l_targ_request_id pa_budget_versions.request_id%TYPE;

445: l_exists VARCHAR2(1) := NULL;
446:
447: -- for bug 3954329
448: l_res_list_migration_code pa_resource_list_members.migration_code%TYPE := FND_API.G_MISS_CHAR;
449: l_targ_request_id pa_budget_versions.request_id%TYPE;
450: px_pa_project_id_in pa_projects_all.project_id%TYPE;
451: px_resource_list_id_in pa_resource_lists_all_bg.resource_list_id%TYPE;
452: px_fin_plan_type_id_in pa_fin_plan_types_b.fin_plan_type_id%TYPE;
453:

Line 2748: ,c_version_type pa_budget_versions.version_type%TYPE

2744: --Cursor to get the plan type details of the version being created.
2745: CURSOR l_proj_fp_options_csr
2746: ( c_project_id pa_projects.project_id%TYPE
2747: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
2748: ,c_version_type pa_budget_versions.version_type%TYPE
2749: ,c_fin_plan_version_id pa_budget_versions.budget_version_id%TYPE)
2750: IS
2751: SELECT nvl(plan_in_multi_curr_flag,'N') multi_curr_flag
2752: ,decode(c_version_type,

Line 2749: ,c_fin_plan_version_id pa_budget_versions.budget_version_id%TYPE)

2745: CURSOR l_proj_fp_options_csr
2746: ( c_project_id pa_projects.project_id%TYPE
2747: ,c_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE
2748: ,c_version_type pa_budget_versions.version_type%TYPE
2749: ,c_fin_plan_version_id pa_budget_versions.budget_version_id%TYPE)
2750: IS
2751: SELECT nvl(plan_in_multi_curr_flag,'N') multi_curr_flag
2752: ,decode(c_version_type,
2753: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,

Line 2794: FROM pa_budget_versions

2790: IS
2791: SELECT budget_version_id
2792: , budget_entry_method_code
2793: , resource_list_id
2794: FROM pa_budget_versions
2795: WHERE project_id = c_project_id
2796: AND budget_type_code = c_budget_type_code
2797: AND budget_status_code = 'W'
2798: AND ci_id IS NULL;

Line 2808: FROM pa_budget_versions

2804: ,c_version_type VARCHAR2
2805: ,c_version_number NUMBER )
2806: IS
2807: SELECT budget_version_id
2808: FROM pa_budget_versions
2809: WHERE project_id=c_project_id
2810: AND fin_plan_type_id=c_fin_plan_type_id
2811: AND version_type=c_version_type
2812: AND version_number=c_version_number

Line 2830: l_locked_by_persion_id pa_budget_versions.locked_by_person_id%TYPE;

2826: l_debug_level4 CONSTANT NUMBER := 4;
2827: l_debug_level5 CONSTANT NUMBER := 5;
2828: l_pm_product_code VARCHAR2(2) :='Z';
2829: l_result VARCHAR2(30);
2830: l_locked_by_persion_id pa_budget_versions.locked_by_person_id%TYPE;
2831: l_val_err_code VARCHAR2(30);
2832:
2833: -- Following variable will be set when atleast one error
2834: -- is reported while validating the input parameters

Line 2839: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;

2835: -- passed by the user
2836: l_any_error_occurred_flag VARCHAR2(1) :='N';
2837:
2838: l_context_info pa_fin_plan_types_tl.name%TYPE;
2839: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
2840:
2841: --Local variables needed for calling Funds Check API
2842: l_fck_req_flag VARCHAR2(1) := NULL;
2843: l_bdgt_intg_flag VARCHAR2(1) := NULL;

Line 2849: l_targ_request_id pa_budget_versions.request_id%TYPE;

2845: l_encum_type_id NUMBER := NULL;
2846:
2847: l_balance_type VARCHAR2(1) := NULL;
2848:
2849: l_targ_request_id pa_budget_versions.request_id%TYPE;
2850: /*Variables added for bug 6408139*/
2851: l_amount_set_id pa_proj_fp_options.all_amount_set_id%TYPE;
2852: lx_raw_cost_flag VARCHAR2(1) ;
2853: lx_burdened_cost_flag VARCHAR2(1);

Line 4092: -- l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE; --3569883

4088: l_msg_data VARCHAR2(2000);
4089: l_msg_count NUMBER;
4090: l_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
4091: l_module_name VARCHAR2(80) := 'add_budget_line: ' || g_module_name;
4092: -- l_fp_type_id pa_budget_versions.fin_plan_type_id%TYPE; --3569883
4093: -- l_old_model VARCHAR2(1):=null; --3569883
4094:
4095: -- added for bug Bug 3986129: FP.M Web ADI Dev changes
4096: l_mfc_cost_type_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 4511: -- from pa_budget_versions

4507:
4508: --3569883 start
4509: -- select fin_plan_type_id
4510: -- into l_fp_type_id
4511: -- from pa_budget_versions
4512: -- where budget_version_id = p_budget_version_id;
4513: --
4514: -- select DECODE(l_fp_type_id, null, 'Y','N') into l_old_model from dual;
4515: ----3569883 end

Line 5077: FROM pa_projects_all a, pa_budget_versions b, pa_resource_Assignments c

5073:
5074: BEGIN
5075: SELECT projfunc_currency_code
5076: INTO l_txn_currency_code
5077: FROM pa_projects_all a, pa_budget_versions b, pa_resource_Assignments c
5078: WHERE a.project_id = b.project_id
5079: AND b.budget_version_id = c.budget_version_id
5080: AND c.resource_assignment_id = p_resource_assignment_id
5081: AND b.ci_id IS NULL; -- -- Added an extra clause b.ci_id IS NULL --Bug # 3507156

Line 5680: ,p_version_type IN pa_budget_versions.version_type%TYPE

5676: ,p_run_id IN pa_fp_webadi_upload_inf.run_id%TYPE
5677: ,p_pa_project_id IN pa_projects_all.project_id%TYPE
5678: ,p_budget_type_code IN pa_budget_types.budget_type_code%TYPE
5679: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
5680: ,p_version_type IN pa_budget_versions.version_type%TYPE
5681: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE
5682: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE
5683: ,p_budget_entry_method_code IN pa_budget_entry_methods.budget_entry_method_code%TYPE
5684: ,p_entry_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE

Line 5842: FROM pa_budget_versions bv,

5838: CURSOR budget_version_info_cur (c_budget_version_id IN NUMBER)
5839: IS
5840: SELECT pt.plan_class_code
5841: ,bv.etc_start_date
5842: FROM pa_budget_versions bv,
5843: pa_fin_plan_types_b pt
5844: WHERE bv.budget_version_id = c_budget_version_id
5845: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
5846:

Line 5848: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;

5844: WHERE bv.budget_version_id = c_budget_version_id
5845: AND pt.fin_plan_type_id = bv.fin_plan_type_id;
5846:
5847: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
5848: l_etc_start_date pa_budget_versions.etc_start_date%TYPE;
5849: /* Bug 4224464: FP M Changes End */
5850:
5851: l_app_rev_plan_type_flag pa_proj_fp_options.approved_rev_plan_type_flag%TYPE;
5852:

Line 5965: CURSOR check_and_return_ci_version (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)

5961: l_period_plan_end_date DATE;
5962:
5963: -- bug 4462614: add the following cursor to be executed for Web ADI flow
5964: -- to check if the budget lines passed belongs to a CI version
5965: CURSOR check_and_return_ci_version (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)
5966: IS
5967: SELECT pbv.ci_id,
5968: agr.agreement_currency_code
5969: FROM pa_budget_versions pbv,

Line 5969: FROM pa_budget_versions pbv,

5965: CURSOR check_and_return_ci_version (c_budget_version_id pa_budget_versions.budget_version_id%TYPE)
5966: IS
5967: SELECT pbv.ci_id,
5968: agr.agreement_currency_code
5969: FROM pa_budget_versions pbv,
5970: pa_agreements_all agr
5971: WHERE pbv.budget_version_id = c_budget_version_id
5972: AND pbv.agreement_id = agr.agreement_id;
5973:

Line 5975: l_webadi_ci_id pa_budget_versions.ci_id%TYPE;

5971: WHERE pbv.budget_version_id = c_budget_version_id
5972: AND pbv.agreement_id = agr.agreement_id;
5973:
5974: l_webadi_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
5975: l_webadi_ci_id pa_budget_versions.ci_id%TYPE;
5976:
5977: l_period_start_date DATE;
5978: l_period_end_date DATE;
5979: l_plan_start_date pa_resource_assignments.planning_start_date%type;

Line 8526: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

8522:
8523:
8524: PROCEDURE GET_FIN_PLAN_LINES_STATUS
8525: (p_calling_context IN VARCHAR2 DEFAULT NULL
8526: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
8527: ,p_budget_lines_in IN PA_BUDGET_PUB.budget_line_in_tbl_type
8528: ,x_fp_lines_retn_status_tab OUT NOCOPY PA_BUDGET_PUB.budget_line_out_tbl_type
8529: ,x_return_status OUT NOCOPY VARCHAR2
8530: ,x_msg_count OUT NOCOPY NUMBER