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_CI_MERGE dependencies on PA_FP_MERGED_CTRL_ITEMS

Line 78: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,

74: p_included_by IN NUMBER,
75: --Added for bug 3550073
76: p_version_type IN pa_budget_versions.version_type%TYPE,
77: p_ci_id IN pa_control_items.ci_id%TYPE,
78: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,

Line 79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,

75: --Added for bug 3550073
76: p_version_type IN pa_budget_versions.version_type%TYPE,
77: p_ci_id IN pa_control_items.ci_id%TYPE,
78: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,

Line 80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,

76: p_version_type IN pa_budget_versions.version_type%TYPE,
77: p_ci_id IN pa_control_items.ci_id%TYPE,
78: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,

Line 81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,

77: p_ci_id IN pa_control_items.ci_id%TYPE,
78: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,

Line 82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,

78: p_cost_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,

Line 83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,

79: p_rev_ppl_qty IN pa_fp_merged_ctrl_items.impl_quantity%TYPE,
80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,
87: p_impl_pc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,

Line 84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,

80: p_cost_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,
87: p_impl_pc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,
88: p_impl_agr_revenue IN pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,

Line 85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,

81: p_rev_equip_qty IN pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE,
82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,
87: p_impl_pc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,
88: p_impl_agr_revenue IN pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,

82: p_impl_pfc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE,
83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,
87: p_impl_pc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,
88: p_impl_agr_revenue IN pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
90: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 87: p_impl_pc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,

83: p_impl_pfc_revenue IN pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE,
84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,
87: p_impl_pc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,
88: p_impl_agr_revenue IN pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
90: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
91: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 88: p_impl_agr_revenue IN pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,

84: p_impl_pfc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE,
85: p_impl_pc_raw_cost IN pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE,
86: p_impl_pc_revenue IN pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE,
87: p_impl_pc_burd_cost IN pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE,
88: p_impl_agr_revenue IN pa_fp_merged_ctrl_items.impl_agr_revenue%TYPE,
89: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
90: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
91: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
92: )

Line 260: INSERT INTO pa_fp_merged_ctrl_items

256: END;
257:
258: -- Insert in the merged control items table
259: IF p_version_type IN ('COST', 'BOTH') THEN
260: INSERT INTO pa_fp_merged_ctrl_items
261: (
262: PROJECT_ID
263: ,PLAN_VERSION_ID
264: ,CI_ID

Line 315: INSERT INTO pa_fp_merged_ctrl_items

311: );
312: END IF;
313:
314: IF p_version_type IN ('REVENUE', 'BOTH') THEN
315: INSERT INTO pa_fp_merged_ctrl_items
316: (
317: PROJECT_ID
318: ,PLAN_VERSION_ID
319: ,CI_ID

Line 1370: FROM pa_fp_merged_ctrl_items

1366:
1367: --Check if record already exists for the merge
1368: SELECT COUNT(*)
1369: INTO l_count_merged_versions
1370: FROM pa_fp_merged_ctrl_items
1371: WHERE
1372: ci_plan_version_id = l_s_version_id
1373: AND plan_version_id = l_t_version_id
1374: AND project_id = p_project_id;

Line 1859: FROM pa_fp_merged_ctrl_items

1855:
1856: --Check if record already exists for the merge
1857: SELECT COUNT(*)
1858: INTO l_count_merged_versions
1859: FROM pa_fp_merged_ctrl_items
1860: WHERE
1861: ci_plan_version_id = l_s_version_id
1862: AND plan_version_id = l_t_version_id
1863: AND project_id = p_project_id;

Line 2404: FROM pa_fp_merged_ctrl_items

2400:
2401: --Check if record already exists for the merge
2402: SELECT COUNT(*)
2403: INTO l_count_merged_versions
2404: FROM pa_fp_merged_ctrl_items
2405: WHERE
2406: ci_plan_version_id = l_s_version_id
2407: AND plan_version_id = l_t_version_id
2408: AND project_id = p_project_id;

Line 2528: - INSERT INTO pa_fp_merged_ctrl_items (

2524:
2525: 08-JAN-2004 jwhite Bug 3362316
2526:
2527: Extensively rewrote copy_merged_ctrl_items
2528: - INSERT INTO pa_fp_merged_ctrl_items (
2529:
2530: ==================================================================*/
2531:
2532: --Bug 4247703. Added the parameter p_calling_context. The valid values are NULL or GENERATION

Line 2615: MERGE INTO pa_fp_merged_ctrl_items target

2611: --target will be deleted before this API is called and hence the check is not required.
2612:
2613: IF p_calling_context ='GENERATION' THEN
2614:
2615: MERGE INTO pa_fp_merged_ctrl_items target
2616: USING
2617: (SELECT
2618: p_project_id project_id
2619: ,p_target_version_id plan_version_id

Line 2640: FROM pa_fp_merged_ctrl_items pmc,

2636: ,pmc.impl_proj_revenue impl_proj_revenue
2637: ,pmc.impl_quantity impl_quantity
2638: ,pmc.impl_equipment_quantity impl_equipment_quantity
2639: ,pmc.impl_agr_revenue impl_agr_revenue
2640: FROM pa_fp_merged_ctrl_items pmc,
2641: pa_budget_versions sourcever,
2642: pa_budget_versions targetver -- Bug 3720445
2643: WHERE plan_version_id = p_source_version_id
2644: AND sourcever.budget_version_id=p_source_version_id

Line 2722: INSERT INTO pa_fp_merged_ctrl_items (

2718: -- Bug 3784823, 29-JUL-2004: It is incorrect not to copy links if ci is partially implemented.
2719: -- Bug 3882920: Links will be copied only if the target version's plan type allows inclusion of CIs. This
2720: -- Bug 4493425: Added another condition in the where clause of select to improve performance.
2721: --check is made only if source/target plan types are different. See bug for details.
2722: INSERT INTO pa_fp_merged_ctrl_items (
2723: project_id
2724: ,plan_version_id
2725: ,ci_id
2726: ,ci_plan_version_id

Line 2769: FROM pa_fp_merged_ctrl_items pmc,

2765: ,pmc.impl_proj_revenue
2766: ,pmc.impl_quantity
2767: ,pmc.impl_equipment_quantity
2768: ,pmc.impl_agr_revenue
2769: FROM pa_fp_merged_ctrl_items pmc,
2770: pa_budget_versions sourcever,
2771: pa_budget_versions targetver -- Bug 3720445
2772: WHERE plan_version_id = p_source_version_id
2773: AND sourcever.budget_version_id=p_source_version_id

Line 2847: --pa_fp_merged_ctrl_items.

2843: Mark As Included button on the page. Included for bug 2681589.
2844: ==================================================================*/
2845: --Changed the API to accept the additional parameters. It now accepts ci version ids for ci id and the version type
2846: --of the target.Based on the version type of target either 1 or 2 records will be created in
2847: --pa_fp_merged_ctrl_items.
2848:
2849: -- bug 3978200 29-0ct-04 Donot throw an error if target version is 'ALL' version and
2850: -- change order has no cost/revenue impact. Create a record in pa_fp_merged_ctrl_items
2851: -- only if there is corresponding impact

Line 2850: -- change order has no cost/revenue impact. Create a record in pa_fp_merged_ctrl_items

2846: --of the target.Based on the version type of target either 1 or 2 records will be created in
2847: --pa_fp_merged_ctrl_items.
2848:
2849: -- bug 3978200 29-0ct-04 Donot throw an error if target version is 'ALL' version and
2850: -- change order has no cost/revenue impact. Create a record in pa_fp_merged_ctrl_items
2851: -- only if there is corresponding impact
2852:
2853: PROCEDURE FP_CI_MANUAL_MERGE
2854: (

Line 2877: l_impl_version_type pa_fp_merged_ctrl_items.version_type%TYPE;

2873: l_update_impact_allowed varchar2(1);
2874:
2875: l_debug_mode varchar2(1);
2876: l_s_ci_id pa_control_items.ci_id%TYPE;
2877: l_impl_version_type pa_fp_merged_ctrl_items.version_type%TYPE;
2878:
2879: --This cursor is introduced for bug 3550073. In manual merge a link will be created which
2880: --indicates that the amounts are copied from the source to the target version. The user has to
2881: CURSOR c_impl_dtls_csr (c_ci_version_id pa_budget_versions.budget_version_id%TYPE)

Line 2901: l_impact_type_implemented pa_fp_merged_ctrl_items.version_type%TYPE;

2897:
2898: l_upd_cost_impact_allowed VARCHAR2(1);
2899: l_upd_rev_impact_allowed VARCHAR2(1);
2900: --Bug 4136386
2901: l_impact_type_implemented pa_fp_merged_ctrl_items.version_type%TYPE;
2902: l_impl_version_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2903:
2904: BEGIN
2905:

Line 2955: FROM pa_fp_merged_ctrl_items

2951: --impact that got implemented should not be manually merged. This block will find that impact and
2952: --initialize the variable l_impact_type_implemented accordingly
2953: SELECT version_type
2954: BULK COLLECT INTO l_impl_version_type_tbl
2955: FROM pa_fp_merged_ctrl_items
2956: WHERE project_id=p_project_id
2957: AND plan_version_id=p_t_fp_version_id
2958: AND ci_id=p_ci_id
2959: AND ci_plan_version_id IN ( NVL(p_ci_cost_version_id,-99),NVL(p_ci_rev_version_id,-99),NVL(p_ci_all_version_id,-99))

Line 3495: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;

3491: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
3492:
3493: l_record_version_number pa_budget_versions.record_version_number%TYPE;
3494: l_partial_factor NUMBER := 1;
3495: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3496: l_total_amt pa_budget_versions.total_project_revenue%TYPE;
3497: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;
3498: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
3499:

Line 3857: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;

3853:
3854:
3855: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS
3856: l_version_type pa_budget_versions.version_type%TYPE;
3857: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;

Line 3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;

3854:
3855: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS
3856: l_version_type pa_budget_versions.version_type%TYPE;
3857: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;

Line 3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;

3855: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS
3856: l_version_type pa_budget_versions.version_type%TYPE;
3857: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;

Line 3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;

3856: l_version_type pa_budget_versions.version_type%TYPE;
3857: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;

Line 3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;

3857: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;

Line 3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;

3858: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;

Line 3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;

3859: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;

Line 3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;

3860: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;
3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;

3861: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;
3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

Line 3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;

3862: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3863: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3864: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3865: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3866: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3867: l_target_version_type pa_budget_versions.version_type%TYPE;
3868: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3869: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3870: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;

Line 3916: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856

3912: l_pc_rev_for_merge pa_budget_lines.project_revenue%TYPE;
3913: l_pfc_rev_for_merge pa_budget_lines.revenue%TYPE;
3914: l_src_dummy1 number;
3915: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3916: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3917: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3920: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

Line 3917: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856

3913: l_pfc_rev_for_merge pa_budget_lines.revenue%TYPE;
3914: l_src_dummy1 number;
3915: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3916: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3917: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3920: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3921: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;

Line 3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856

3914: l_src_dummy1 number;
3915: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3916: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3917: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3918: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3919: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3920: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3921: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;
3922: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;

Line 4405: --will be updated in pa_fp_merged_ctrl_items

4401: --same CO and target version combination for more than once for implementing the same impact.
4402: --In case a CO is getting implemented partially and if a record already exists in pa_fp_mergedc_ctrl_items
4403: --then that existing record should be updated.
4404: --The difference between the amounts existing before merge and the resulting amounts after merge
4405: --will be updated in pa_fp_merged_ctrl_items
4406: IF p_context='PARTIAL_REV' OR
4407: (p_context = 'INCLUDE' AND l_partial_rev_impl_flag = 'R' AND l_impl_type_tbl(j) IN ( 'REVENUE', 'ALL')) THEN
4408:
4409: BEGIN

Line 4419: FROM pa_fp_merged_ctrl_items

4415: INTO l_impl_amt,
4416: l_impl_proj_func_revenue, -- bug 4035856
4417: l_impl_proj_revenue, -- bug 4035856
4418: l_impl_quantity -- bug 4035856
4419: FROM pa_fp_merged_ctrl_items
4420: WHERE project_id=l_project_id
4421: AND plan_version_id=p_budget_version_id
4422: AND ci_id=p_ci_id
4423: AND ci_plan_version_id=l_src_ver_id_tbl(j)

Line 9822: l_pc_rev_merged := l_impl_proj_revenue -- already impl amt from pa_fp_merged_ctrl_items

9818: l_pfc_revenue_delta := 0;
9819:
9820: -- Compute the total implemented amount using already implemented amount and currently
9821: -- implemented amount
9822: l_pc_rev_merged := l_impl_proj_revenue -- already impl amt from pa_fp_merged_ctrl_items
9823: + (l_targ_pc_rev_after_merge - l_targ_pc_rev_before_merge);
9824: l_pfc_rev_merged := l_impl_proj_func_revenue -- already impl amt from pa_fp_merged_ctrl_items
9825: + (l_targ_pfc_rev_after_merge - l_targ_pfc_rev_before_merge);
9826:

Line 9824: l_pfc_rev_merged := l_impl_proj_func_revenue -- already impl amt from pa_fp_merged_ctrl_items

9820: -- Compute the total implemented amount using already implemented amount and currently
9821: -- implemented amount
9822: l_pc_rev_merged := l_impl_proj_revenue -- already impl amt from pa_fp_merged_ctrl_items
9823: + (l_targ_pc_rev_after_merge - l_targ_pc_rev_before_merge);
9824: l_pfc_rev_merged := l_impl_proj_func_revenue -- already impl amt from pa_fp_merged_ctrl_items
9825: + (l_targ_pfc_rev_after_merge - l_targ_pfc_rev_before_merge);
9826:
9827: -- If all the remaining agreement amount is being implemented, make sure that
9828: -- implemeted PC, PFC amounts in pa_fp_merged_ctrl_items tally with ci version totals

Line 9828: -- implemeted PC, PFC amounts in pa_fp_merged_ctrl_items tally with ci version totals

9824: l_pfc_rev_merged := l_impl_proj_func_revenue -- already impl amt from pa_fp_merged_ctrl_items
9825: + (l_targ_pfc_rev_after_merge - l_targ_pfc_rev_before_merge);
9826:
9827: -- If all the remaining agreement amount is being implemented, make sure that
9828: -- implemeted PC, PFC amounts in pa_fp_merged_ctrl_items tally with ci version totals
9829: IF (nvl(l_impl_amt,0) + nvl(l_partial_impl_rev_amt,0) = nvl(l_total_amt,0)) THEN
9830:
9831: l_pfc_revenue_delta := l_total_amt_in_pfc - l_pfc_rev_merged;
9832: l_pc_revenue_delta := l_total_amt_in_pc - l_pc_rev_merged;

Line 10817: UPDATE pa_fp_merged_ctrl_items

10813: ELSE--IF l_impl_earlier='Y'
10814:
10815: IF l_version_type IN ('REVENUE', 'BOTH') THEN
10816:
10817: UPDATE pa_fp_merged_ctrl_items
10818: SET impl_proj_func_revenue =nvl(impl_proj_func_revenue,0)+nvl(l_impl_pfc_revenue,0)
10819: ,impl_proj_revenue =nvl(impl_proj_revenue,0)+nvl(l_impl_pc_revenue,0)
10820: ,impl_quantity =nvl(impl_quantity,0)+nvl(l_rev_ppl_qty,0)
10821: ,impl_equipment_quantity =nvl(impl_equipment_quantity,0)+nvl(l_rev_equip_qty,0)

Line 12234: * i. Copies the CI links of the current working version from the pa_fp_merged_ctrl_items(if there is any

12230:
12231: /*--------------------------------------------------------------------------------------------------------
12232: * Bug 3877815: New procedure introduced, to be called for merge of CIs for auto baseline enabled projects
12233: * This api does the followings:
12234: * i. Copies the CI links of the current working version from the pa_fp_merged_ctrl_items(if there is any
12235: * record present for that version) to temporary nested pl/sql tables.
12236: * ii. Call is made to pa_fp_ci_implement_pkg.create_ci_impact_fund_lines and pa_baseline_funding_pkg.change_management_baseline.
12237: * iii. Insert 2 records into pa_fp_merged_ctrl_items for newly created current working version and the
12238: * baselied version with all the attributes of the record stored in the nested tables except the

Line 12237: * iii. Insert 2 records into pa_fp_merged_ctrl_items for newly created current working version and the

12233: * This api does the followings:
12234: * i. Copies the CI links of the current working version from the pa_fp_merged_ctrl_items(if there is any
12235: * record present for that version) to temporary nested pl/sql tables.
12236: * ii. Call is made to pa_fp_ci_implement_pkg.create_ci_impact_fund_lines and pa_baseline_funding_pkg.change_management_baseline.
12237: * iii. Insert 2 records into pa_fp_merged_ctrl_items for newly created current working version and the
12238: * baselied version with all the attributes of the record stored in the nested tables except the
12239: * inclusion_method_code, which would be 'COPIED' for the current working version and 'AUTOMATIC' for the baselined version.
12240: * iv. Call is made to pa_fp_ci_merge.FP_CI_UPDATE_IMPACT.
12241: *--------------------------------------------------------------------------------------------------------*/

Line 12350: pa_debug.g_err_stage:= 'Copying data from pa_fp_merged_ctrl_items';

12346:
12347: IF l_debug_mode = 'Y' THEN
12348: pa_debug.g_err_stage:= 'Entering impl_ci_into_autobaseline_proj';
12349: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12350: pa_debug.g_err_stage:= 'Copying data from pa_fp_merged_ctrl_items';
12351: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12352: END IF;
12353:
12354: SELECT

Line 12400: FROM pa_fp_merged_ctrl_items

12396: l_impl_proj_revenue_tbl,
12397: l_impl_quantity_tbl,
12398: l_impl_equipment_quant_tbl,
12399: l_impl_agr_revenue_tbl
12400: FROM pa_fp_merged_ctrl_items
12401: WHERE plan_version_id = p_budget_version_id;
12402:
12403: IF l_debug_mode = 'Y' THEN
12404: pa_debug.g_err_stage:= 'Copy from pa_fp_merged_ctrl_items done';

Line 12404: pa_debug.g_err_stage:= 'Copy from pa_fp_merged_ctrl_items done';

12400: FROM pa_fp_merged_ctrl_items
12401: WHERE plan_version_id = p_budget_version_id;
12402:
12403: IF l_debug_mode = 'Y' THEN
12404: pa_debug.g_err_stage:= 'Copy from pa_fp_merged_ctrl_items done';
12405: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12406: pa_debug.g_err_stage:= 'No. of records copied: ' || l_plan_version_id_tbl.COUNT;
12407: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12408: END IF;

Line 12648: pa_debug.g_err_stage:= 'Inserting into pa_fp_merged_ctrl_items with old data';

12644: END IF;
12645:
12646: IF l_plan_version_id_tbl.COUNT > 0 THEN
12647: IF l_debug_mode = 'Y' THEN
12648: pa_debug.g_err_stage:= 'Inserting into pa_fp_merged_ctrl_items with old data';
12649: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12650: END IF;
12651: -- For the current working version
12652: FORALL i IN l_plan_version_id_tbl.FIRST .. l_plan_version_id_tbl.LAST

Line 12653: INSERT INTO pa_fp_merged_ctrl_items

12649: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12650: END IF;
12651: -- For the current working version
12652: FORALL i IN l_plan_version_id_tbl.FIRST .. l_plan_version_id_tbl.LAST
12653: INSERT INTO pa_fp_merged_ctrl_items
12654: (project_id,
12655: plan_version_id,
12656: ci_id,
12657: ci_plan_version_id,

Line 12702: INSERT INTO pa_fp_merged_ctrl_items

12698:
12699: -- For the baseline version
12700:
12701: FORALL i IN l_plan_version_id_tbl.FIRST .. l_plan_version_id_tbl.LAST
12702: INSERT INTO pa_fp_merged_ctrl_items
12703: (project_id,
12704: plan_version_id,
12705: ci_id,
12706: ci_plan_version_id,

Line 12792: UPDATE pa_fp_merged_ctrl_items

12788: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12789: END IF;
12790:
12791: -- For Current working version
12792: UPDATE pa_fp_merged_ctrl_items
12793: SET impl_proj_func_revenue = (Nvl(impl_proj_func_revenue,0) + l_impl_pfc_revenue),
12794: impl_proj_revenue = (Nvl(impl_proj_revenue,0) + l_impl_pc_revenue),
12795: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12796: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),

Line 12808: UPDATE pa_fp_merged_ctrl_items

12804: AND plan_version_id = l_new_cw_version_id
12805: AND version_type = 'REVENUE';
12806:
12807: -- For baselined version
12808: UPDATE pa_fp_merged_ctrl_items
12809: SET impl_proj_func_revenue = (Nvl(impl_proj_func_revenue,0) + l_impl_pfc_revenue),
12810: impl_proj_revenue = (Nvl(impl_proj_revenue,0) + l_impl_pc_revenue),
12811: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12812: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),

Line 12828: ELSE -- There is no record present in pa_fp_merged_ctrl_items for the ci_id

12824: pa_debug.g_err_stage:= 'Updation of record is done for the CI';
12825: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12826: END IF;
12827:
12828: ELSE -- There is no record present in pa_fp_merged_ctrl_items for the ci_id
12829: IF l_debug_mode = 'Y' THEN
12830: pa_debug.g_err_stage:= 'Calling FP_CI_LINK_CONTROL_ITEMS for the CI which has been merged';
12831: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12832: END IF;