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 13: PROCEDURE Get_Fin_Plan_Dtls(p_project_id IN Pa_Projects_All.Project_Id%TYPE,

9: l_cvc_app_cost_pt_rev_flag pa_proj_fp_options.approved_cost_plan_type_flag%TYPE;
10: l_cvc_app_cost_pt_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
11: --Bug 5845142
12:
13: PROCEDURE Get_Fin_Plan_Dtls(p_project_id IN Pa_Projects_All.Project_Id%TYPE,
14: p_ci_id IN NUMBER,
15: x_fin_plan_type_id_cost OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
16: x_fin_plan_type_id_rev OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
17: x_fin_plan_type_id_all OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 78: Pa_Projects_All WHERE Project_Id = p_project_id;

74: INTO
75: x_project_currency_code,
76: x_baseline_funding_flag
77: FROM
78: Pa_Projects_All WHERE Project_Id = p_project_id;
79: EXCEPTION
80: WHEN NO_DATA_FOUND THEN
81: x_baseline_funding_flag := 'N';
82: END;

Line 290: Pa_Projects_All p, Pa_Project_Types_All pt WHERE

286: SELECT NVL(Allow_Rev_Budget_Entry_Flag ,'N'),
287: NVL(Allow_Cost_Budget_Entry_Flag,'N') INTO
288: l_rev_budget_flag,
289: l_cost_budget_flag FROM
290: Pa_Projects_All p, Pa_Project_Types_All pt WHERE
291: p.project_id = p_project_id AND
292: p.project_type = pt.project_type AND
293: -- MOAC changes
294: -- removing the nvl from org_id.

Line 326: Pa_Projects_All p,

322: l_fp_allowed_flag VARCHAR2(1) := 'N' ;
323: BEGIN
324: BEGIN
325: SELECT 'Y' INTO l_fp_allowed_flag FROM
326: Pa_Projects_All p,
327: Pa_Project_Types_All pt
328: WHERE
329: p.Project_Id = p_project_id AND
330: p.Project_Type = pt.Project_Type AND

Line 1569: pa_projects_all ppa

1565: 'ALL',all_fin_plan_level_code,null)
1566: from pa_budget_versions bv,
1567: pa_proj_fp_options po,
1568: pa_ci_impacts pci,
1569: pa_projects_all ppa
1570: where bv.project_id = p_project_id
1571: and bv.approved_rev_plan_type_flag = 'Y'
1572: and po.project_id = bv.project_id
1573: and po.fin_plan_type_id = bv.fin_plan_type_id

Line 2304: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

2300: END IsValidAgreement;
2301:
2302: FUNCTION IsFpAutoBaselineEnabled(p_project_id IN NUMBER)
2303: RETURN VARCHAR2 IS
2304: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2305: l_no_of_app_plan_types NUMBER;
2306: l_fp_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
2307:
2308: BEGIN

Line 2311: FROM Pa_Projects_All

2307:
2308: BEGIN
2309: SELECT NVL(Baseline_Funding_Flag,'N') INTO
2310: l_baseline_Funding_flag
2311: FROM Pa_Projects_All
2312: WHERE
2313: Project_Id = p_project_id;
2314: IF l_baseline_funding_flag = 'N' THEN
2315: RETURN l_baseline_funding_flag;

Line 2433: Pa_Projects_All

2429: SELECT project_currency_code
2430: INTO
2431: x_project_currency_code
2432: FROM
2433: Pa_Projects_All
2434: WHERE
2435: project_Id = p_project_id;
2436: EXCEPTION
2437: WHEN NO_DATA_FOUND THEN

Line 2462: p_project_id IN pa_projects_all.project_id%TYPE,

2458: /* the following function is used in the
2459: Impact Implementation page */
2460:
2461: FUNCTION Get_Funindg_Amount(
2462: p_project_id IN pa_projects_all.project_id%TYPE,
2463: p_agreement_id IN pa_agreements_all.agreement_id%TYPE)
2464: RETURN NUMBER IS
2465: l_funding_amount NUMBER := 0;
2466: BEGIN

Line 2490: ( p_project_id IN pa_projects_all.project_id%TYPE

2486: --Please refer to the bug 4283579 for the expected/correct behavior. Code changes for enforcing that
2487: --behavior are targeted for track1 post FP.M
2488:
2489: PROCEDURE CHK_APRV_CUR_WORKING_BV_EXISTS
2490: ( p_project_id IN pa_projects_all.project_id%TYPE
2491: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
2492: ,p_version_type IN pa_budget_versions.version_type%TYPE
2493: ,x_cur_work_bv_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
2494: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2500: l_project_name pa_projects_all.name%TYPE;

2496: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
2497:
2498: l_msg_index_out number;
2499: l_exists varchar2(1) := 'N';
2500: l_project_name pa_projects_all.name%TYPE;
2501: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2502: l_version_type pa_lookups.meaning%TYPE;
2503: l_stage number;
2504: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

Line 2504: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

2500: l_project_name pa_projects_all.name%TYPE;
2501: l_plan_name pa_fin_plan_types_tl.name%TYPE;
2502: l_version_type pa_lookups.meaning%TYPE;
2503: l_stage number;
2504: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
2505: l_msg_name fnd_new_messages.message_name%TYPE;
2506: --Bug 5845142. Exclude COST impacts with cost and revenue together setup.
2507: cursor c1 is
2508: Select budget_version_id

Line 2546: from pa_projects_all

2542: select name,
2543: NVL(Baseline_Funding_Flag,'N')
2544: into l_project_name,
2545: l_baseline_Funding_flag
2546: from pa_projects_all
2547: where project_id = p_project_id;
2548:
2549: l_stage := 200;
2550:

Line 2797: l_baseline_funding_Flag pa_projects_All.baseline_funding_flag%type;

2793:
2794: l_token_ci_id varchar2(150);
2795: l_token_v_type VARCHAR2(30);
2796: l_time_phase_code_flag VARCHAR2(1);
2797: l_baseline_funding_Flag pa_projects_All.baseline_funding_flag%type;
2798: l_s_rev_bv_id pa_budget_versions.budget_version_id%type;
2799: l_count number;
2800: l_s_bv_fp_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
2801: l_ci_number pa_control_items.ci_number%type;

Line 2848: pa_projects_all where

2844: END IF;
2845:
2846: select nvl(baseline_funding_flag ,'N') into
2847: l_baseline_funding_flag from
2848: pa_projects_all where
2849: project_id = p_project_id;
2850:
2851: l_token_ci_id := null;
2852:

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

4505: WHERE LOOKUP_TYPE = 'PA_FP_CI_PLAN_REFERENCE'
4506: ORDER BY to_number(LOOKUP_CODE);
4507:
4508: CURSOR c_get_approved_details
4509: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE) IS
4510: SELECT fin_plan_type_id,
4511: fin_plan_preference_code,
4512: report_labor_hrs_from_code,
4513: approved_cost_plan_type_flag,

Line 4521: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4517: AND (approved_cost_plan_type_flag = 'Y' or approved_rev_plan_type_flag = 'Y')
4518: AND fin_plan_option_level_code = 'PLAN_TYPE';
4519:
4520: CURSOR c_original_baselined
4521: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4522: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4523: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4524: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4525: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS

Line 4551: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4547: --AND (pbv.approved_cost_plan_type_flag = 'Y' or pbv.approved_rev_plan_type_flag = 'Y')
4548: AND pbv.budget_status_code = 'B';
4549:
4550: CURSOR c_current_baselined
4551: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4552: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4553: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4554: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4555: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS

Line 4582: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4578: --AND (pbv.approved_cost_plan_type_flag = 'Y' or pbv.approved_rev_plan_type_flag = 'Y')
4579: AND pbv.budget_status_code = 'B';
4580:
4581: CURSOR c_current_working
4582: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4583: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4584: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4585: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4586: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS

Line 4620: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4616: We should NOT use a 'not exists' clause on change documents that have been already
4617: included in the current baseline version(as it was done earlier).
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 4670: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4666:
4667: -- Bug 5845142. Take the revenue amounts only from revenue impact.Note that cost impacts
4668: -- with ALL version type can have revenue amounts.
4669: CURSOR c_change_documents_current
4670: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4671: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4672: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4673: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4674: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS -- Raja review

Line 4712: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

4708: */
4709: -- Bug 5845142. Take the revenue amounts only from revenue impact.Note that cost impacts
4710: -- with ALL version type can have revenue amounts.
4711: CURSOR c_change_documents_prior
4712: (c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4713: c_ac_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4714: c_ar_fin_plan_type_id PA_PROJ_FP_OPTIONS.FIN_PLAN_TYPE_ID%TYPE,
4715: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4716: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS -- Raja review

Line 4766: (c_project_id pa_projects_all.project_id%TYPE,

4762: /* Bug 3572880 Only those change orders that have not been already merged into the current
4763: working version should be considered. */
4764: /* commented by Raja rewritten the cursor below
4765: CURSOR c_change_documents_status
4766: (c_project_id pa_projects_all.project_id%TYPE,
4767: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4768: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE) IS
4769: SELECT nvl(sum(pfca.people_effort),0),
4770: nvl(sum(pfca.equipment_effort),0),

Line 4787: (c_project_id pa_projects_all.project_id%TYPE,

4783: -- Changed for Bug 3744910
4784: -- Bug 3947153. Modified the inner select for revenue data to show the correct quantity. Please see
4785: -- the bug for details
4786: CURSOR c_change_documents_status
4787: (c_project_id pa_projects_all.project_id%TYPE,
4788: c_system_status_code pa_ci_statuses_v.project_system_status_code%TYPE,
4789: c_margin_derived_from_code PA_PROJ_FP_OPTIONS.margin_derived_from_code%TYPE,
4790: c_report_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE,
4791: c_appr_rev_cw_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE) IS -- Raja review

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

4903: and pbv1.ci_id is null
4904: and pbv1.approved_rev_plan_type_flag = 'Y'))) revenue_query;
4905:
4906: --Bug 5278200Added extra parameter
4907: cursor c_url_original_baseline(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4908: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
4909: c_version_type pa_budget_versions.version_type%TYPE) IS
4910: SELECT BUDGET_VERSION_ID,VERSION_TYPE
4911: FROM PA_BUDGET_VERSIONS

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

4918: --Bug 4089203
4919: --AND (approved_cost_plan_type_flag='Y' or approved_rev_plan_type_flag='Y');
4920:
4921: --Bug 5278200Added extra parameter
4922: cursor c_url_current_baseline(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4923: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
4924: c_version_type pa_budget_versions.version_type%TYPE) IS
4925: SELECT BUDGET_VERSION_ID,VERSION_TYPE
4926: FROM PA_BUDGET_VERSIONS

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

4933: --Bug 4089203
4934: --AND (approved_cost_plan_type_flag='Y' or approved_rev_plan_type_flag='Y');
4935:
4936: --Bug 5278200Added extra parameter
4937: cursor c_url_current_working(c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
4938: c_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE,
4939: c_version_type pa_budget_versions.version_type%TYPE) IS
4940: SELECT BUDGET_VERSION_ID,VERSION_TYPE
4941: FROM PA_BUDGET_VERSIONS

Line 5050: FROM Pa_Projects_All

5046:
5047: BEGIN
5048: SELECT project_currency_code
5049: INTO x_project_currency_code
5050: FROM Pa_Projects_All
5051: WHERE project_Id = p_project_id;
5052:
5053: IF l_debug_mode = 'Y' THEN
5054: pa_debug.g_err_stage:='x_project_currency_code = ' || x_project_currency_code;

Line 7097: c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,

7093:
7094: CURSOR c_change_documents_status(
7095: c_system_status_code PA_CI_STATUSES_V.PROJECT_SYSTEM_STATUS_CODE%TYPE,
7096: c_budget_version_id PA_BUDGET_VERSIONS.BUDGET_VERSION_ID%TYPE,
7097: c_project_id PA_PROJECTS_ALL.PROJECT_ID%TYPE,
7098: c_fin_plan_type_id PA_BUDGET_VERSIONS.FIN_PLAN_TYPE_ID%TYPE,
7099: c_version_type PA_BUDGET_VERSIONS.VERSION_TYPE%TYPE) IS
7100: select nvl(sum(nvl(PA_FP_CONTROL_ITEMS_UTILS.get_labor_qty_partial(
7101: pfca.CI_VERSION_TYPE,

Line 7660: p_project_id IN pa_projects_all.project_id%TYPE)

7656: /* FP.M- This function checks for the particular ci type, the Cost Impact or
7657: * Revenue Impact has been enabled for Financial implementation
7658: */
7659: FUNCTION is_fin_impact_enabled(p_ci_id IN pa_control_items.ci_id%TYPE,
7660: p_project_id IN pa_projects_all.project_id%TYPE)
7661: RETURN VARCHAR2
7662: IS
7663:
7664: l_ci_type_id NUMBER;

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

9282: --that page
9283: --p_budget_version_id is the target version id with which comparision happens in the view fin impact page. If this
9284: --is available its not required to fetch the approved cost/rev current working ids.
9285: PROCEDURE get_dtls_for_view_fin_imp_pg
9286: (p_project_id IN pa_projects_all.project_id%TYPE,
9287: p_ci_id IN pa_control_items.ci_id%TYPE,
9288: p_ci_cost_version_id IN pa_budget_versions.budget_version_id%TYPE,
9289: p_ci_rev_version_id IN pa_budget_versions.budget_version_id%TYPE,
9290: p_ci_all_version_id IN pa_budget_versions.budget_version_id%TYPE,

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

9291: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
9292: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9293: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9294: x_ci_status_code OUT NOCOPY pa_control_items.status_code%TYPE, --File.Sql.39 bug 4440895
9295: x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE, --File.Sql.39 bug 4440895
9296: x_impact_in_mc_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9297: x_targ_version_type OUT NOCOPY pa_budget_Versions.version_type%TYPE, --File.Sql.39 bug 4440895
9298: x_show_resources_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9299: x_plan_class_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 9410: FROM pa_projects_all

9406:
9407: --Get the project currency code
9408: SELECT project_currency_code
9409: INTO x_project_currency_code
9410: FROM pa_projects_all
9411: WHERE project_id=p_project_id;
9412:
9413: IF l_debug_mode = 'Y' THEN
9414: pa_debug.g_err_stage:='Getting ci status code';

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

9699: --If there is only one version which is approved for both cost and revenue and then same version id will be
9700: --populated in both x_app_cost_cw_ver_id and x_app_rev_cw_ver_id
9701: --If the current working versions do not exist then null will be returned
9702: PROCEDURE get_app_cw_ver_ids_for_proj
9703: (p_project_id IN pa_projects_all.project_id%TYPE,
9704: x_app_cost_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9705: x_app_rev_cw_ver_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
9706: x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
9707: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

9844:
9845: /* Bug 3731948- New Function to return the CO amount already implemented
9846: * for REVENUE implementation in agreement currency
9847: */
9848: FUNCTION get_impl_agr_revenue (p_project_id IN pa_projects_all.project_id%TYPE,
9849: p_ci_id IN pa_fp_merged_ctrl_items.ci_id%TYPE)
9850: RETURN NUMBER
9851: IS
9852: l_impl_agr_rev_amt NUMBER := 0;

Line 10042: p_project_id IN pa_projects_all.project_id%TYPE

10038: /* 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
10039: All the lines of a revenue change order version will be in a single currency
10040: */
10041: PROCEDURE get_txn_curr_code_of_ci_ver(
10042: p_project_id IN pa_projects_all.project_id%TYPE
10043: ,p_ci_id IN pa_budget_versions.ci_id%TYPE
10044: ,x_txn_currency_code OUT NOCOPY pa_budget_lines.txn_currency_code%TYPE --File.Sql.39 bug 4440895
10045: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
10046: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895