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

Line 8: G_BUDGET_VERSION_ID pa_budget_versions.budget_version_id%TYPE := -99 ;

4: /*This procedure is called to return the layout code based on */
5: /* p_budget_version_id. */
6: /***************************************************************/
7:
8: G_BUDGET_VERSION_ID pa_budget_versions.budget_version_id%TYPE := -99 ;
9: G_TABLE_POPULATED VARCHAR2(1) := 'N' ;
10: G_TXN_CURRENCY_CODE_TBL PA_FP_WEBADI_PKG.l_txn_currency_code_tbl_typ ;
11:
12:

Line 50: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

46: l_cost_period_mask_id pa_proj_fp_options.cost_period_mask_id%TYPE;
47: l_revenue_period_mask_id pa_proj_fp_options.rev_period_mask_id%TYPE;
48: l_all_period_mask_id pa_proj_fp_options.all_period_mask_id%TYPE;
49: l_no_of_periods NUMBER;
50: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
51: l_layout_meaning bne_layouts_vl.user_name%TYPE;
52: l_plan_class_name pa_lookups.meaning%TYPE;
53: l_layout_code VARCHAR2(300);
54:

Line 72: FROM pa_resource_lists_all_bg a, pa_budget_versions b

68:
69: -- 4497318.Perf Fix: The View name pa_resource_lists is reolaced by Table name pa_resource_lists_all_bg in the FROM clause.
70: SELECT a.GROUP_RESOURCE_TYPE_ID,a.UNCATEGORIZED_FLAG,b.current_working_flag
71: INTO l_group_resource_type_id,l_uncategorized_flag,l_current_working_flag
72: FROM pa_resource_lists_all_bg a, pa_budget_versions b
73: WHERE b.budget_version_id = p_budget_version_id
74: AND a.RESOURCE_LIST_ID = b.resource_list_id;
75:
76: SELECT FIN_PLAN_PREFERENCE_CODE

Line 406: pa_budget_versions pbv,

402: -- 4497315.Perf Fix.SELECT query is changed.
403: CURSOR C1(l_budget_version_id number) IS
404: SELECT pt.start_date,pt.completion_date
405: FROM pa_resource_assignments pra,
406: pa_budget_versions pbv,
407: pa_tasks pt
408: WHERE pra.budget_version_id = pbv.budget_version_id
409: AND pbv.budget_version_id = l_budget_version_id
410: AND pt.task_id = pra.task_id

Line 425: FROM pa_budget_versions

421: SELECT period_profile_id
422: ,project_id
423: INTO l_period_profile_id
424: ,l_project_id
425: FROM pa_budget_versions
426: WHERE budget_version_id = l_budget_version_id;
427:
428: SELECT start_date
429: ,completion_date

Line 557: from pa_proj_fp_options fp, pa_budget_versions bv

553: select fp.PLAN_IN_MULTI_CURR_FLAG,
554: fp.proj_fp_options_id
555: into l_multi_curr_flag,
556: l_proj_fp_options_id
557: from pa_proj_fp_options fp, pa_budget_versions bv
558: where bv.budget_version_id = p_budget_version_id
559: and fp.fin_plan_version_id = p_budget_version_id
560: and fp.fin_plan_type_id = bv.fin_plan_type_id
561: and fp.fin_plan_option_level_code = 'PLAN_VERSION'

Line 620: from pa_budget_versions

616:
617:
618: Select resource_list_id, project_id
619: into l_resource_list_id,l_project_id
620: from pa_budget_versions
621: where budget_version_id = p_budget_version_id;
622:
623: -- 4497318.Perf Fix.The View name pa_resource_lists is replaced by Table name pa_resource_lists_all_bg in the FROM clause.
624: SELECT GROUP_RESOURCE_TYPE_ID,UNCATEGORIZED_FLAG

Line 1059: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

1055: END VALIDATE_CHANGE_REASON_CODE ;
1056: */ -- end of bug 5350437
1057:
1058: PROCEDURE VALIDATE_TXN_CURRENCY_CODE
1059: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1060: ,p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
1061: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
1062: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1063: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1222: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

1218: END VALIDATE_TXN_CURRENCY_CODE ;
1219:
1220: /* Bug 5350437: Commented the below API
1221: PROCEDURE GET_VERSION_PERIODS_INFO
1222: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1223: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895
1224: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895
1225: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895
1226: ,x_number_of_pds OUT NOCOPY pa_proj_period_profiles.number_of_periods%TYPE --File.Sql.39 bug 4440895

Line 1227: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895

1223: ,x_period_name_tbl OUT NOCOPY pa_fp_webadi_pkg.l_period_name_tbl_typ --File.Sql.39 bug 4440895
1224: ,x_start_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_start_date_tbl_typ --File.Sql.39 bug 4440895
1225: ,x_end_date_tbl OUT NOCOPY pa_fp_webadi_pkg.l_end_date_tbl_typ --File.Sql.39 bug 4440895
1226: ,x_number_of_pds OUT NOCOPY pa_proj_period_profiles.number_of_periods%TYPE --File.Sql.39 bug 4440895
1227: ,x_period_profile_id OUT NOCOPY pa_budget_versions.period_profile_id%TYPE --File.Sql.39 bug 4440895
1228: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1229: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1230: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1231: )

Line 1408: , pa_budget_versions pbv

1404: , ppp.number_of_periods
1405: , pbv.period_profile_id
1406: FROM
1407: pa_proj_period_profiles ppp
1408: , pa_budget_versions pbv
1409: WHERE pbv.budget_version_id = p_budget_version_id
1410: AND ppp.period_profile_id = pbv.period_profile_id ;
1411:
1412: BEGIN

Line 1681: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

1677:
1678: /* Bug 3986129: FP.M- Web ADI Dev Changes: The following api is no longer being called from PAFPWAPB.pls
1679: * retaining this just for reference */
1680: PROCEDURE CHECK_OVERLAPPING_DATES
1681: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1682: ,x_rec_failed_validation OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1683: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1684: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1685: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2414: (p_request_id IN pa_budget_versions.request_id%TYPE,

2410: -- This api would be called from a java method when the user wants to delete the data from the excel interface
2411: -- that is downloaded for a session.
2412:
2413: PROCEDURE delete_interface_tbl_data
2414: (p_request_id IN pa_budget_versions.request_id%TYPE,
2415: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2416: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2417: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2418:

Line 2428: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2424: l_msg_data VARCHAR2(2000);
2425: l_msg_index_out NUMBER;
2426:
2427: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;
2428: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2429:
2430: BEGIN
2431: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2432:

Line 2509: pa_debug.g_err_stage:='Updating pa_budget_versions';

2505:
2506: IF l_debug_mode = 'Y' THEN
2507: pa_debug.g_err_stage:='PA_FP_WEBADI_PKG.delete_xface Called';
2508: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2509: pa_debug.g_err_stage:='Updating pa_budget_versions';
2510: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2511: END IF;
2512:
2513: UPDATE pa_budget_versions

Line 2513: UPDATE pa_budget_versions

2509: pa_debug.g_err_stage:='Updating pa_budget_versions';
2510: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2511: END IF;
2512:
2513: UPDATE pa_budget_versions
2514: SET plan_processing_code = null,
2515: request_id = null,
2516: record_version_number = record_version_number + 1
2517: WHERE budget_version_id = l_budget_version_id;

Line 2557: (p_old_request_id IN pa_budget_versions.request_id%TYPE,

2553: -- This api would be called from a java method when the user wants to resubmit the request for the concurrent
2554: -- program, if the upload processing of the plan version fails for some reason.
2555:
2556: PROCEDURE resubmit_conc_request
2557: (p_old_request_id IN pa_budget_versions.request_id%TYPE,
2558: x_new_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
2559: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2560: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2561: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 2558: x_new_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895

2554: -- program, if the upload processing of the plan version fails for some reason.
2555:
2556: PROCEDURE resubmit_conc_request
2557: (p_old_request_id IN pa_budget_versions.request_id%TYPE,
2558: x_new_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE, --File.Sql.39 bug 4440895
2559: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
2560: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2561: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
2562:

Line 2572: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

2568: l_msg_data VARCHAR2(2000);
2569: l_msg_index_out NUMBER;
2570:
2571: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;
2572: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2573: l_new_request_id pa_budget_versions.request_id%TYPE;
2574: -- MOAC changes.
2575: l_org_id pa_projects_all.org_id%TYPE;
2576: BEGIN

Line 2573: l_new_request_id pa_budget_versions.request_id%TYPE;

2569: l_msg_index_out NUMBER;
2570:
2571: l_run_id pa_fp_webadi_upload_inf.run_id%TYPE;
2572: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2573: l_new_request_id pa_budget_versions.request_id%TYPE;
2574: -- MOAC changes.
2575: l_org_id pa_projects_all.org_id%TYPE;
2576: BEGIN
2577: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 2649: pa_budget_versions pbv

2645:
2646: SELECT ppa.org_id
2647: INTO l_org_id
2648: FROM pa_projects_all ppa,
2649: pa_budget_versions pbv
2650: WHERE pbv.project_id = ppa.project_id
2651: AND pbv.budget_version_id = l_budget_version_id;
2652: fnd_request.set_org_id(l_org_id);
2653:

Line 2673: UPDATE pa_budget_versions

2669: END IF;
2670:
2671: x_return_status := FND_API.G_RET_STS_ERROR;
2672:
2673: UPDATE pa_budget_versions
2674: SET plan_processing_code = 'XLUE'
2675: WHERE budget_version_id = l_budget_version_id;
2676:
2677: x_new_request_id := l_new_request_id;

Line 2685: pa_debug.g_err_stage:='Updating pa_budget_versions';

2681: pa_debug.write_file ('PA_FP_WEBADI_UTILS ' || pa_debug.g_err_stage);
2682: END IF;
2683:
2684: IF l_debug_mode = 'Y' THEN
2685: pa_debug.g_err_stage:='Updating pa_budget_versions';
2686: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2687: END IF;
2688:
2689: UPDATE pa_budget_versions

Line 2689: UPDATE pa_budget_versions

2685: pa_debug.g_err_stage:='Updating pa_budget_versions';
2686: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
2687: END IF;
2688:
2689: UPDATE pa_budget_versions
2690: SET plan_processing_code = 'XLUP',
2691: request_id = l_new_request_id
2692: WHERE budget_version_id = l_budget_version_id;
2693:

Line 2789: from pa_budget_versions pbv,

2785: if p_plan_class_code = 'BUDGET' then
2786: begin
2787: select pbv.budget_version_id
2788: into l_curr_bv_id
2789: from pa_budget_versions pbv,
2790: pa_proj_fp_options pfo
2791: where pfo.fin_plan_type_id = p_fin_plan_type_id
2792: and pfo.project_id = p_project_id
2793: and pfo.fin_plan_option_level_code = 'PLAN_VERSION'

Line 2808: pa_budget_versions bv

2804: begin
2805: select bv.budget_version_id
2806: into l_curr_bv_id
2807: from pa_proj_fp_options po,
2808: pa_budget_versions bv
2809: where po.project_id = p_project_id and
2810: po.fin_plan_option_level_code = 'PLAN_VERSION' and
2811: bv.approved_cost_plan_type_flag = 'Y' and
2812: po.fin_plan_version_id = bv.budget_version_id and

Line 2824: pa_budget_versions bv

2820: begin
2821: select bv.budget_version_id
2822: into l_curr_bv_id
2823: from pa_proj_fp_options po,
2824: pa_budget_versions bv
2825: where po.project_id = p_project_id and
2826: po.fin_plan_option_level_code = 'PLAN_VERSION' and
2827: bv.approved_rev_plan_type_flag = 'Y' and
2828: po.fin_plan_version_id = bv.budget_version_id and

Line 2993: from pa_budget_versions pbv,

2989: if p_plan_class_code = 'BUDGET' then
2990: begin
2991: select pbv.budget_version_id
2992: into l_orig_bv_id
2993: from pa_budget_versions pbv,
2994: pa_proj_fp_options pfo
2995: where pfo.fin_plan_type_id = p_fin_plan_type_id
2996: and pfo.project_id = p_project_id
2997: and pfo.fin_plan_option_level_code = 'PLAN_VERSION'

Line 3012: pa_budget_versions bv

3008: begin
3009: select bv.budget_version_id
3010: into l_orig_bv_id
3011: from pa_proj_fp_options po,
3012: pa_budget_versions bv
3013: where po.project_id = p_project_id and
3014: po.fin_plan_option_level_code = 'PLAN_VERSION' and
3015: bv.approved_cost_plan_type_flag = 'Y' and
3016: po.fin_plan_version_id = bv.budget_version_id and

Line 3028: pa_budget_versions bv

3024: begin
3025: select bv.budget_version_id
3026: into l_orig_bv_id
3027: from pa_proj_fp_options po,
3028: pa_budget_versions bv
3029: where po.project_id = p_project_id and
3030: po.fin_plan_option_level_code = 'PLAN_VERSION' and
3031: bv.approved_rev_plan_type_flag = 'Y' and
3032: po.fin_plan_version_id = bv.budget_version_id and

Line 3044: pa_budget_versions bv

3040: begin
3041: select bv.budget_version_id
3042: into l_orig_bv_id
3043: from pa_proj_fp_options po,
3044: pa_budget_versions bv
3045: where po.project_id = p_project_id and
3046: po.fin_plan_option_level_code = 'PLAN_VERSION' and
3047: bv.approved_cost_plan_type_flag = 'Y' and
3048: bv.approved_rev_plan_type_flag = 'Y' and

Line 3184: from pa_budget_versions pbv,

3180: elsif p_plan_class_code = 'FORECAST' then
3181: begin
3182: select pbv.budget_version_id
3183: into l_pf_bv_id
3184: from pa_budget_versions pbv,
3185: pa_proj_fp_options pfo
3186: where pfo.fin_plan_type_id = p_fin_plan_type_id
3187: and pfo.project_id = p_project_id
3188: and pfo.fin_plan_option_level_code = 'PLAN_VERSION'