APPS.PA_FP_WEBADI_UTILS dependencies on PA_PROJECTS_ALL

Line 432: FROM pa_projects_all p

428: SELECT start_date
429: ,completion_date
430: INTO l_project_start_date
431: ,l_project_end_date
432: FROM pa_projects_all p
433: WHERE p.project_id = l_project_id;
434:
435:
436: IF l_time_phased_code IN(PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN

Line 2575: l_org_id pa_projects_all.org_id%TYPE;

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);
2578:
2579: x_msg_count := 0;

Line 2640: -- Getting the org id from pa_projects_all.

2636: END IF;
2637:
2638: -- MOAC changes for release 12.
2639: -- Need to set the org id context before submitting a conc request.
2640: -- Getting the org id from pa_projects_all.
2641: -- Not embedding this sql in a block as this has to get a
2642: -- record/org id no matter what.
2643: -- If it fails let this be an unhandled exception and
2644: -- let it raise or handle at the end of the program.

Line 2648: FROM pa_projects_all ppa,

2644: -- let it raise or handle at the end of the program.
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);