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_CONTROL_ITEMS_UTILS dependencies on PA_PROJECTS_ALL

Line 6: PROCEDURE Get_Fin_Plan_Dtls(p_project_id IN Pa_Projects_All.Project_Id%TYPE,

2: /* $Header: PAFPCIUB.pls 120.6.12010000.2 2008/11/28 12:55:05 vgovvala ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4: g_module_name VARCHAR2(100) := 'pa.plsql.PA_CONTROL_ITEM_UTILS';
5:
6: PROCEDURE Get_Fin_Plan_Dtls(p_project_id IN Pa_Projects_All.Project_Id%TYPE,
7: p_ci_id IN NUMBER,
8: x_fin_plan_type_id_cost OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
9: x_fin_plan_type_id_rev OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
10: x_fin_plan_type_id_all OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 71: Pa_Projects_All WHERE Project_Id = p_project_id;

67: INTO
68: x_project_currency_code,
69: x_baseline_funding_flag
70: FROM
71: Pa_Projects_All WHERE Project_Id = p_project_id;
72: EXCEPTION
73: WHEN NO_DATA_FOUND THEN
74: x_baseline_funding_flag := 'N';
75: END;

Line 266: Pa_Projects_All p, Pa_Project_Types_All pt WHERE

262: SELECT NVL(Allow_Rev_Budget_Entry_Flag ,'N'),
263: NVL(Allow_Cost_Budget_Entry_Flag,'N') INTO
264: l_rev_budget_flag,
265: l_cost_budget_flag FROM
266: Pa_Projects_All p, Pa_Project_Types_All pt WHERE
267: p.project_id = p_project_id AND
268: p.project_type = pt.project_type AND
269: -- MOAC changes
270: -- removing the nvl from org_id.

Line 302: Pa_Projects_All p,

298: l_fp_allowed_flag VARCHAR2(1) := 'N' ;
299: BEGIN
300: BEGIN
301: SELECT 'Y' INTO l_fp_allowed_flag FROM
302: Pa_Projects_All p,
303: Pa_Project_Types_All pt
304: WHERE
305: p.Project_Id = p_project_id AND
306: p.Project_Type = pt.Project_Type AND

Line 1535: pa_projects_all ppa

1531: 'ALL',all_fin_plan_level_code,null)
1532: from pa_budget_versions bv,
1533: pa_proj_fp_options po,
1534: pa_ci_impacts pci,
1535: pa_projects_all ppa
1536: where bv.project_id = p_project_id
1537: and bv.approved_rev_plan_type_flag = 'Y'
1538: and po.project_id = bv.project_id
1539: and po.fin_plan_type_id = bv.fin_plan_type_id

Line 2270: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

2266: END IsValidAgreement;
2267:
2268: FUNCTION IsFpAutoBaselineEnabled(p_project_id IN NUMBER)
2269: RETURN VARCHAR2 IS
2270: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2271: l_no_of_app_plan_types NUMBER;
2272: l_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2273:
2274: BEGIN

Line 2277: FROM Pa_Projects_All

2273:
2274: BEGIN
2275: SELECT NVL(Baseline_Funding_Flag,'N') INTO
2276: l_baseline_Funding_flag
2277: FROM Pa_Projects_All
2278: WHERE
2279: Project_Id = p_project_id;
2280: IF l_baseline_funding_flag = 'N' THEN
2281: RETURN l_baseline_funding_flag;

Line 2399: Pa_Projects_All

2395: SELECT project_currency_code
2396: INTO
2397: x_project_currency_code
2398: FROM
2399: Pa_Projects_All
2400: WHERE
2401: project_Id = p_project_id;
2402: EXCEPTION
2403: WHEN NO_DATA_FOUND THEN

Line 2428: p_project_id IN pa_projects_all.project_id%TYPE,

2424: /* the following function is used in the
2425: Impact Implementation page */
2426:
2427: FUNCTION Get_Funindg_Amount(
2428: p_project_id IN pa_projects_all.project_id%TYPE,
2429: p_agreement_id IN pa_agreements_all.agreement_id%TYPE)
2430: RETURN NUMBER IS
2431: l_funding_amount NUMBER := 0;
2432: BEGIN

Line 2456: ( p_project_id IN pa_projects_all.project_id%TYPE

2452: --Please refer to the bug 4283579 for the expected/correct behavior. Code changes for enforcing that
2453: --behavior are targeted for track1 post FP.M
2454:
2455: PROCEDURE CHK_APRV_CUR_WORKING_BV_EXISTS
2456: ( p_project_id IN pa_projects_all.project_id%TYPE
2457: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
2458: ,p_version_type IN pa_budget_versions.version_type%TYPE
2459: ,x_cur_work_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
2460: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2466: l_project_name pa_projects_all.name%TYPE;

2462: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2463:
2464: l_msg_index_out number;
2465: l_exists varchar2(1) := 'N';
2466: l_project_name pa_projects_all.name%TYPE;
2467: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2468: l_version_type pa_lookups.meaning%TYPE;
2469: l_stage number;
2470: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

Line 2470: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

2466: l_project_name pa_projects_all.name%TYPE;
2467: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2468: l_version_type pa_lookups.meaning%TYPE;
2469: l_stage number;
2470: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2471: l_msg_name fnd_new_messages.message_name%TYPE;
2472: cursor c1 is
2473: Select budget_version_id
2474: from pa_budget_versions bv

Line 2497: from pa_projects_all

2493: select name,
2494: NVL(Baseline_Funding_Flag,'N')
2495: into l_project_name,
2496: l_baseline_Funding_flag
2497: from pa_projects_all
2498: where project_id = p_project_id;
2499:
2500: l_stage := 200;
2501:

Line 2748: l_baseline_funding_Flag pa_projects_All.baseline_funding_flag%type;

2744:
2745: l_token_ci_id varchar2(150);
2746: l_token_v_type VARCHAR2(30);
2747: l_time_phase_code_flag VARCHAR2(1);
2748: l_baseline_funding_Flag pa_projects_All.baseline_funding_flag%type;
2749: l_s_rev_bv_id pa_budget_versions.budget_version_id%type;
2750: l_count number;
2751: l_s_bv_fp_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2752: l_ci_number pa_control_items.ci_number%type;

Line 2799: pa_projects_all where

2795: END IF;
2796:
2797: select nvl(baseline_funding_flag ,'N') into
2798: l_baseline_funding_flag from
2799: pa_projects_all where
2800: project_id = p_project_id;
2801:
2802: l_token_ci_id := null;
2803:

Line 4460: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS

4456: WHERE LOOKUP_TYPE = 'PA_FP_CI_PLAN_REFERENCE'
4457: ORDER BY to_number(LOOKUP_CODE);
4458:
4459: CURSOR c_get_approved_details
4460: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
4461: SELECT fin_plan_type_id,
4462: fin_plan_preference_code,
4463: report_labor_hrs_from_code,
4464: approved_cost_plan_type_flag,

Line 4472: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4468: AND (approved_cost_plan_type_flag = 'Y' or approved_rev_plan_type_flag = 'Y')
4469: AND fin_plan_option_level_code = 'PLAN_TYPE';
4470:
4471: CURSOR c_original_baselined
4472: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4473: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4474: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4475: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4476: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS

Line 4502: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4498: --AND (pbv.approved_cost_plan_type_flag = 'Y' or pbv.approved_rev_plan_type_flag = 'Y')
4499: AND pbv.budget_status_code = 'B';
4500:
4501: CURSOR c_current_baselined
4502: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4503: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4504: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4505: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4506: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS

Line 4533: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4529: --AND (pbv.approved_cost_plan_type_flag = 'Y' or pbv.approved_rev_plan_type_flag = 'Y')
4530: AND pbv.budget_status_code = 'B';
4531:
4532: CURSOR c_current_working
4533: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4534: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4535: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4536: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4537: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS

Line 4571: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4567: We should NOT use a 'not exists' clause on change documents that have been already
4568: included in the current baseline version(as it was done earlier).
4569: */
4570: /* CURSOR c_change_documents_current
4571: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4572: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4573: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4574: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4575: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS -- Raja review

Line 4620: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4616: */
4617:
4618:
4619: CURSOR c_change_documents_current
4620: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4621: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4622: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4623: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4624: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS -- Raja review

Line 4658: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4654: Basically All records having inclusion_method_code as (COPIED - for Current Baseline) should
4655: be considered while deriving Amounts/Quantities for the Prior Baselined Versions
4656: */
4657: CURSOR c_change_documents_prior
4658: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4659: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4660: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4661: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4662: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS -- Raja review

Line 4710: (c_project_id pa_projects_all.project_id%TYPE,

4706: /* Bug 3572880 Only those change orders that have not been already merged into the current
4707: working version should be considered. */
4708: /* commented by Raja rewritten the cursor below
4709: CURSOR c_change_documents_status
4710: (c_project_id pa_projects_all.project_id%TYPE,
4711: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4712: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE) IS
4713: SELECT nvl(sum(pfca.people_effort),0),
4714: nvl(sum(pfca.equipment_effort),0),

Line 4731: (c_project_id pa_projects_all.project_id%TYPE,

4727: -- Changed for Bug 3744910
4728: -- Bug 3947153. Modified the inner select for revenue data to show the correct quantity. Please see
4729: -- the bug for details
4730: CURSOR c_change_documents_status
4731: (c_project_id pa_projects_all.project_id%TYPE,
4732: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4733: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4734: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
4735: c_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS -- Raja review

Line 4851: cursor c_url_original_baseline(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4847: and pbv1.ci_id is null
4848: and pbv1.approved_rev_plan_type_flag = 'Y'))) revenue_query;
4849:
4850: --Bug 5278200Added extra parameter
4851: cursor c_url_original_baseline(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4852: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
4853: c_version_type pa_budget_versions.version_type%TYPE) IS
4854: SELECT BUDGET_VERSION_ID,VERSION_TYPE
4855: FROM PA_BUDGET_VERSIONS

Line 4866: cursor c_url_current_baseline(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4862: --Bug 4089203
4863: --AND (approved_cost_plan_type_flag='Y' or approved_rev_plan_type_flag='Y');
4864:
4865: --Bug 5278200Added extra parameter
4866: cursor c_url_current_baseline(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4867: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
4868: c_version_type pa_budget_versions.version_type%TYPE) IS
4869: SELECT BUDGET_VERSION_ID,VERSION_TYPE
4870: FROM PA_BUDGET_VERSIONS

Line 4881: cursor c_url_current_working(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4877: --Bug 4089203
4878: --AND (approved_cost_plan_type_flag='Y' or approved_rev_plan_type_flag='Y');
4879:
4880: --Bug 5278200Added extra parameter
4881: cursor c_url_current_working(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4882: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
4883: c_version_type pa_budget_versions.version_type%TYPE) IS
4884: SELECT BUDGET_VERSION_ID,VERSION_TYPE
4885: FROM PA_BUDGET_VERSIONS

Line 4994: FROM Pa_Projects_All

4990:
4991: BEGIN
4992: SELECT project_currency_code
4993: INTO x_project_currency_code
4994: FROM Pa_Projects_All
4995: WHERE project_Id = p_project_id;
4996:
4997: IF l_debug_mode = 'Y' THEN
4998: pa_debug.g_err_stage:='x_project_currency_code = ' || x_project_currency_code;

Line 7025: c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

7021:
7022: CURSOR c_change_documents_status(
7023: c_system_status_code PA_CI_STATUSES_V.PROJECT_SYSTEM_STATUS_CODE%TYPE,
7024: c_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7025: c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
7026: c_fin_plan_type_id PA_BUDGET_VERSIONS.FIN_PLAN_TYPE_ID%TYPE,
7027: c_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS
7028: select nvl(sum(nvl(PA_FP_CONTROL_ITEMS_UTILS.get_labor_qty_partial(
7029: pfca.CI_VERSION_TYPE,

Line 7588: p_project_id IN pa_projects_all.project_id%TYPE)

7584: /* FP.M- This function checks for the particular ci type, the Cost Impact or
7585: * Revenue Impact has been enabled for Financial implementation
7586: */
7587: FUNCTION is_fin_impact_enabled(p_ci_id IN pa_control_items.ci_id%TYPE,
7588: p_project_id IN pa_projects_all.project_id%TYPE)
7589: RETURN VARCHAR2
7590: IS
7591:
7592: l_ci_type_id NUMBER;

Line 9128: (p_project_id IN pa_projects_all.project_id%TYPE,

9124: --that page
9125: --p_budget_version_id is the target version id with which comparision happens in the view fin impact page. If this
9126: --is available its not required to fetch the approved cost/rev current working ids.
9127: PROCEDURE get_dtls_for_view_fin_imp_pg
9128: (p_project_id IN pa_projects_all.project_id%TYPE,
9129: p_ci_id IN pa_control_items.ci_id%TYPE,
9130: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
9131: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
9132: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,

Line 9137: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895

9133: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
9134: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9135: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9136: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
9137: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
9138: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9139: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895
9140: x_show_resources_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9141: x_plan_class_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 9252: FROM pa_projects_all

9248:
9249: --Get the project currency code
9250: SELECT project_currency_code
9251: INTO x_project_currency_code
9252: FROM pa_projects_all
9253: WHERE project_id=p_project_id;
9254:
9255: IF l_debug_mode = 'Y' THEN
9256: pa_debug.g_err_stage:='Getting ci status code';

Line 9545: (p_project_id IN pa_projects_all.project_id%TYPE,

9541: --If there is only one version which is approved for both cost and revenue and then same version id will be
9542: --populated in both x_app_cost_cw_ver_id and x_app_rev_cw_ver_id
9543: --If the current working versions do not exist then null will be returned
9544: PROCEDURE get_app_cw_ver_ids_for_proj
9545: (p_project_id IN pa_projects_all.project_id%TYPE,
9546: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9547: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9548: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9549: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 9690: FUNCTION get_impl_agr_revenue (p_project_id IN pa_projects_all.project_id%TYPE,

9686:
9687: /* Bug 3731948- New Function to return the CO amount already implemented
9688: * for REVENUE implementation in agreement currency
9689: */
9690: FUNCTION get_impl_agr_revenue (p_project_id IN pa_projects_all.project_id%TYPE,
9691: p_ci_id IN pa_fp_merged_ctrl_items.ci_id%TYPE)
9692: RETURN NUMBER
9693: IS
9694: l_impl_agr_rev_amt NUMBER := 0;

Line 9858: p_project_id IN pa_projects_all.project_id%TYPE

9854: /* This API returns the txn_currency_code and the ci version id of the budget lines of a REVENUE or ALL ci version, if lines exist. Else it returns NULL
9855: All the lines of a revenue change order version will be in a single currency
9856: */
9857: PROCEDURE get_txn_curr_code_of_ci_ver(
9858: p_project_id IN pa_projects_all.project_id%TYPE
9859: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
9860: ,x_txn_currency_code OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
9861: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
9862: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895