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 1870: - INSERT INTO pa_fp_merged_ctrl_items (

1866:
1867: 08-JAN-2004 jwhite Bug 3362316
1868:
1869: Extensively rewrote copy_merged_ctrl_items
1870: - INSERT INTO pa_fp_merged_ctrl_items (
1871:
1872: ==================================================================*/
1873:
1874: --Bug 4247703. Added the parameter p_calling_context. The valid values are NULL or GENERATION

Line 1971: MERGE INTO pa_fp_merged_ctrl_items target

1967: RETURN;
1968:
1969: END IF;
1970:
1971: MERGE INTO pa_fp_merged_ctrl_items target
1972: USING
1973: (SELECT
1974: p_project_id project_id
1975: ,p_target_version_id plan_version_id

Line 1996: FROM pa_fp_merged_ctrl_items pmc,

1992: ,pmc.impl_proj_revenue impl_proj_revenue
1993: ,pmc.impl_quantity impl_quantity
1994: ,pmc.impl_equipment_quantity impl_equipment_quantity
1995: ,pmc.impl_agr_revenue impl_agr_revenue
1996: FROM pa_fp_merged_ctrl_items pmc,
1997: pa_budget_versions sourcever,
1998: pa_budget_versions targetver -- Bug 3720445
1999: WHERE plan_version_id = p_source_version_id
2000: AND sourcever.budget_version_id=p_source_version_id

Line 2078: INSERT INTO pa_fp_merged_ctrl_items (

2074: -- Bug 3784823, 29-JUL-2004: It is incorrect not to copy links if ci is partially implemented.
2075: -- Bug 3882920: Links will be copied only if the target version's plan type allows inclusion of CIs. This
2076: -- Bug 4493425: Added another condition in the where clause of select to improve performance.
2077: --check is made only if source/target plan types are different. See bug for details.
2078: INSERT INTO pa_fp_merged_ctrl_items (
2079: project_id
2080: ,plan_version_id
2081: ,ci_id
2082: ,ci_plan_version_id

Line 2125: FROM pa_fp_merged_ctrl_items pmc,

2121: ,pmc.impl_proj_revenue
2122: ,pmc.impl_quantity
2123: ,pmc.impl_equipment_quantity
2124: ,pmc.impl_agr_revenue
2125: FROM pa_fp_merged_ctrl_items pmc,
2126: pa_budget_versions sourcever,
2127: pa_budget_versions targetver -- Bug 3720445
2128: WHERE plan_version_id = p_source_version_id
2129: AND sourcever.budget_version_id=p_source_version_id

Line 2203: --pa_fp_merged_ctrl_items.

2199: Mark As Included button on the page. Included for bug 2681589.
2200: ==================================================================*/
2201: --Changed the API to accept the additional parameters. It now accepts ci version ids for ci id and the version type
2202: --of the target.Based on the version type of target either 1 or 2 records will be created in
2203: --pa_fp_merged_ctrl_items.
2204:
2205: -- bug 3978200 29-0ct-04 Donot throw an error if target version is 'ALL' version and
2206: -- change order has no cost/revenue impact. Create a record in pa_fp_merged_ctrl_items
2207: -- only if there is corresponding impact

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

2202: --of the target.Based on the version type of target either 1 or 2 records will be created in
2203: --pa_fp_merged_ctrl_items.
2204:
2205: -- bug 3978200 29-0ct-04 Donot throw an error if target version is 'ALL' version and
2206: -- change order has no cost/revenue impact. Create a record in pa_fp_merged_ctrl_items
2207: -- only if there is corresponding impact
2208:
2209: PROCEDURE FP_CI_MANUAL_MERGE
2210: (

Line 2233: l_impl_version_type pa_fp_merged_ctrl_items.version_type%TYPE;

2229: l_update_impact_allowed varchar2(1);
2230:
2231: l_debug_mode varchar2(1);
2232: l_s_ci_id pa_control_items.ci_id%TYPE;
2233: l_impl_version_type pa_fp_merged_ctrl_items.version_type%TYPE;
2234:
2235: --This cursor is introduced for bug 3550073. In manual merge a link will be created which
2236: --indicates that the amounts are copied from the source to the target version. The user has to
2237: CURSOR c_impl_dtls_csr (c_ci_version_id pa_budget_versions.budget_version_id%TYPE)

Line 2257: l_impact_type_implemented pa_fp_merged_ctrl_items.version_type%TYPE;

2253:
2254: l_upd_cost_impact_allowed VARCHAR2(1);
2255: l_upd_rev_impact_allowed VARCHAR2(1);
2256: --Bug 4136386
2257: l_impact_type_implemented pa_fp_merged_ctrl_items.version_type%TYPE;
2258: l_impl_version_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
2259:
2260: BEGIN
2261:

Line 2311: FROM pa_fp_merged_ctrl_items

2307: --impact that got implemented should not be manually merged. This block will find that impact and
2308: --initialize the variable l_impact_type_implemented accordingly
2309: SELECT version_type
2310: BULK COLLECT INTO l_impl_version_type_tbl
2311: FROM pa_fp_merged_ctrl_items
2312: WHERE project_id=p_project_id
2313: AND plan_version_id=p_t_fp_version_id
2314: AND ci_id=p_ci_id
2315: 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 2851: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;

2847: l_impact_type_code pa_ci_impacts.impact_type_code%TYPE;
2848:
2849: l_record_version_number pa_budget_versions.record_version_number%TYPE;
2850: l_partial_factor NUMBER := 1;
2851: l_impl_amt pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
2852: l_total_amt pa_budget_versions.total_project_revenue%TYPE;
2853: l_total_amt_in_pfc pa_budget_lines.revenue%TYPE;
2854: l_total_amt_in_pc pa_budget_lines.project_revenue%TYPE;
2855:

Line 3217: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;

3213:
3214:
3215: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS
3216: l_version_type pa_budget_versions.version_type%TYPE;
3217: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3218: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;

Line 3218: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;

3214:
3215: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS
3216: l_version_type pa_budget_versions.version_type%TYPE;
3217: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3218: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;

Line 3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;

3215: -- Variables for calling FP_CI_LINK_CONTROL_ITEMS
3216: l_version_type pa_budget_versions.version_type%TYPE;
3217: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3218: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;

Line 3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;

3216: l_version_type pa_budget_versions.version_type%TYPE;
3217: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3218: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;

Line 3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;

3217: l_cost_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3218: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;

Line 3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;

3218: l_rev_ppl_qty pa_fp_merged_ctrl_items.impl_quantity%TYPE;
3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3226: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;

Line 3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;

3219: l_cost_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3226: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3227: l_target_version_type pa_budget_versions.version_type%TYPE;

Line 3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;

3220: l_rev_equip_qty pa_fp_merged_ctrl_items.impl_equipment_quantity%TYPE;
3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3226: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3227: l_target_version_type pa_budget_versions.version_type%TYPE;
3228: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;

3221: l_impl_pfc_raw_cost pa_fp_merged_ctrl_items.impl_proj_func_raw_cost%TYPE;
3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3226: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3227: l_target_version_type pa_budget_versions.version_type%TYPE;
3228: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3229: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

Line 3226: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;

3222: l_impl_pfc_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;
3223: l_impl_pfc_burd_cost pa_fp_merged_ctrl_items.impl_proj_func_burdened_cost%TYPE;
3224: l_impl_pc_raw_cost pa_fp_merged_ctrl_items.impl_proj_raw_cost%TYPE;
3225: l_impl_pc_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;
3226: l_impl_pc_burd_cost pa_fp_merged_ctrl_items.impl_proj_burdened_cost%TYPE;
3227: l_target_version_type pa_budget_versions.version_type%TYPE;
3228: l_baselined_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3229: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
3230: l_orig_record_version_number pa_budget_versions.record_version_number%TYPE;

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

3272: l_pc_rev_for_merge pa_budget_lines.project_revenue%TYPE;
3273: l_pfc_rev_for_merge pa_budget_lines.revenue%TYPE;
3274: l_src_dummy1 number;
3275: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3276: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3277: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3278: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3279: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3280: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

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

3273: l_pfc_rev_for_merge pa_budget_lines.revenue%TYPE;
3274: l_src_dummy1 number;
3275: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3276: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3277: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3278: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3279: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3280: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3281: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;

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

3274: l_src_dummy1 number;
3275: l_src_dummy2 pa_resource_list_members.alias%TYPE;
3276: l_impl_proj_func_revenue pa_fp_merged_ctrl_items.impl_proj_func_revenue%TYPE;-- bug 4035856
3277: l_impl_proj_revenue pa_fp_merged_ctrl_items.impl_proj_revenue%TYPE;-- bug 4035856
3278: l_impl_quantity pa_fp_merged_ctrl_items.impl_quantity%TYPE;-- bug 4035856
3279: l_agreement_id pa_agreements_all.agreement_id%TYPE;
3280: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
3281: l_rounded_bl_id pa_budget_lines.budget_line_id%TYPE;
3282: l_rounded_bl_rbf pa_resource_assignments.rate_based_flag%TYPE;

Line 3786: --will be updated in pa_fp_merged_ctrl_items

3782: --same CO and target version combination for more than once for implementing the same impact.
3783: --In case a CO is getting implemented partially and if a record already exists in pa_fp_mergedc_ctrl_items
3784: --then that existing record should be updated.
3785: --The difference between the amounts existing before merge and the resulting amounts after merge
3786: --will be updated in pa_fp_merged_ctrl_items
3787: IF p_context='PARTIAL_REV' OR
3788: (p_context = 'INCLUDE' AND l_partial_rev_impl_flag = 'R' AND l_impl_type_tbl(j) IN ( 'REVENUE', 'ALL')) THEN
3789:
3790: BEGIN

Line 3800: FROM pa_fp_merged_ctrl_items

3796: INTO l_impl_amt,
3797: l_impl_proj_func_revenue, -- bug 4035856
3798: l_impl_proj_revenue, -- bug 4035856
3799: l_impl_quantity -- bug 4035856
3800: FROM pa_fp_merged_ctrl_items
3801: WHERE project_id=l_project_id
3802: AND plan_version_id=p_budget_version_id
3803: AND ci_id=p_ci_id
3804: AND ci_plan_version_id=l_src_ver_id_tbl(j)

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

9218: l_pfc_revenue_delta := 0;
9219:
9220: -- Compute the total implemented amount using already implemented amount and currently
9221: -- implemented amount
9222: l_pc_rev_merged := l_impl_proj_revenue -- already impl amt from pa_fp_merged_ctrl_items
9223: + (l_targ_pc_rev_after_merge - l_targ_pc_rev_before_merge);
9224: l_pfc_rev_merged := l_impl_proj_func_revenue -- already impl amt from pa_fp_merged_ctrl_items
9225: + (l_targ_pfc_rev_after_merge - l_targ_pfc_rev_before_merge);
9226:

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

9220: -- Compute the total implemented amount using already implemented amount and currently
9221: -- implemented amount
9222: l_pc_rev_merged := l_impl_proj_revenue -- already impl amt from pa_fp_merged_ctrl_items
9223: + (l_targ_pc_rev_after_merge - l_targ_pc_rev_before_merge);
9224: l_pfc_rev_merged := l_impl_proj_func_revenue -- already impl amt from pa_fp_merged_ctrl_items
9225: + (l_targ_pfc_rev_after_merge - l_targ_pfc_rev_before_merge);
9226:
9227: -- If all the remaining agreement amount is being implemented, make sure that
9228: -- implemeted PC, PFC amounts in pa_fp_merged_ctrl_items tally with ci version totals

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

9224: l_pfc_rev_merged := l_impl_proj_func_revenue -- already impl amt from pa_fp_merged_ctrl_items
9225: + (l_targ_pfc_rev_after_merge - l_targ_pfc_rev_before_merge);
9226:
9227: -- If all the remaining agreement amount is being implemented, make sure that
9228: -- implemeted PC, PFC amounts in pa_fp_merged_ctrl_items tally with ci version totals
9229: IF (nvl(l_impl_amt,0) + nvl(l_partial_impl_rev_amt,0) = nvl(l_total_amt,0)) THEN
9230:
9231: l_pfc_revenue_delta := l_total_amt_in_pfc - l_pfc_rev_merged;
9232: l_pc_revenue_delta := l_total_amt_in_pc - l_pc_rev_merged;

Line 10223: UPDATE pa_fp_merged_ctrl_items

10219: ELSE--IF l_impl_earlier='Y'
10220:
10221: IF l_version_type IN ('REVENUE', 'BOTH') THEN
10222:
10223: UPDATE pa_fp_merged_ctrl_items
10224: SET impl_proj_func_revenue =nvl(impl_proj_func_revenue,0)+nvl(l_impl_pfc_revenue,0)
10225: ,impl_proj_revenue =nvl(impl_proj_revenue,0)+nvl(l_impl_pc_revenue,0)
10226: ,impl_quantity =nvl(impl_quantity,0)+nvl(l_rev_ppl_qty,0)
10227: ,impl_equipment_quantity =nvl(impl_equipment_quantity,0)+nvl(l_rev_equip_qty,0)

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

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

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

11709: * This api does the followings:
11710: * i. Copies the CI links of the current working version from the pa_fp_merged_ctrl_items(if there is any
11711: * record present for that version) to temporary nested pl/sql tables.
11712: * ii. Call is made to pa_fp_ci_implement_pkg.create_ci_impact_fund_lines and pa_baseline_funding_pkg.change_management_baseline.
11713: * iii. Insert 2 records into pa_fp_merged_ctrl_items for newly created current working version and the
11714: * baselied version with all the attributes of the record stored in the nested tables except the
11715: * inclusion_method_code, which would be 'COPIED' for the current working version and 'AUTOMATIC' for the baselined version.
11716: * iv. Call is made to pa_fp_ci_merge.FP_CI_UPDATE_IMPACT.
11717: *--------------------------------------------------------------------------------------------------------*/

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

11822:
11823: IF l_debug_mode = 'Y' THEN
11824: pa_debug.g_err_stage:= 'Entering impl_ci_into_autobaseline_proj';
11825: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11826: pa_debug.g_err_stage:= 'Copying data from pa_fp_merged_ctrl_items';
11827: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11828: END IF;
11829:
11830: SELECT

Line 11876: FROM pa_fp_merged_ctrl_items

11872: l_impl_proj_revenue_tbl,
11873: l_impl_quantity_tbl,
11874: l_impl_equipment_quant_tbl,
11875: l_impl_agr_revenue_tbl
11876: FROM pa_fp_merged_ctrl_items
11877: WHERE plan_version_id = p_budget_version_id;
11878:
11879: IF l_debug_mode = 'Y' THEN
11880: pa_debug.g_err_stage:= 'Copy from pa_fp_merged_ctrl_items done';

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

11876: FROM pa_fp_merged_ctrl_items
11877: WHERE plan_version_id = p_budget_version_id;
11878:
11879: IF l_debug_mode = 'Y' THEN
11880: pa_debug.g_err_stage:= 'Copy from pa_fp_merged_ctrl_items done';
11881: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11882: pa_debug.g_err_stage:= 'No. of records copied: ' || l_plan_version_id_tbl.COUNT;
11883: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
11884: END IF;

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

12120: END IF;
12121:
12122: IF l_plan_version_id_tbl.COUNT > 0 THEN
12123: IF l_debug_mode = 'Y' THEN
12124: pa_debug.g_err_stage:= 'Inserting into pa_fp_merged_ctrl_items with old data';
12125: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12126: END IF;
12127: -- For the current working version
12128: FORALL i IN l_plan_version_id_tbl.FIRST .. l_plan_version_id_tbl.LAST

Line 12129: INSERT INTO pa_fp_merged_ctrl_items

12125: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12126: END IF;
12127: -- For the current working version
12128: FORALL i IN l_plan_version_id_tbl.FIRST .. l_plan_version_id_tbl.LAST
12129: INSERT INTO pa_fp_merged_ctrl_items
12130: (project_id,
12131: plan_version_id,
12132: ci_id,
12133: ci_plan_version_id,

Line 12178: INSERT INTO pa_fp_merged_ctrl_items

12174:
12175: -- For the baseline version
12176:
12177: FORALL i IN l_plan_version_id_tbl.FIRST .. l_plan_version_id_tbl.LAST
12178: INSERT INTO pa_fp_merged_ctrl_items
12179: (project_id,
12180: plan_version_id,
12181: ci_id,
12182: ci_plan_version_id,

Line 12268: UPDATE pa_fp_merged_ctrl_items

12264: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12265: END IF;
12266:
12267: -- For Current working version
12268: UPDATE pa_fp_merged_ctrl_items
12269: SET impl_proj_func_revenue = (Nvl(impl_proj_func_revenue,0) + l_impl_pfc_revenue),
12270: impl_proj_revenue = (Nvl(impl_proj_revenue,0) + l_impl_pc_revenue),
12271: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12272: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),

Line 12284: UPDATE pa_fp_merged_ctrl_items

12280: AND plan_version_id = l_new_cw_version_id
12281: AND version_type = 'REVENUE';
12282:
12283: -- For baselined version
12284: UPDATE pa_fp_merged_ctrl_items
12285: SET impl_proj_func_revenue = (Nvl(impl_proj_func_revenue,0) + l_impl_pfc_revenue),
12286: impl_proj_revenue = (Nvl(impl_proj_revenue,0) + l_impl_pc_revenue),
12287: impl_quantity = (Nvl(impl_quantity,0) + l_rev_ppl_quantity),
12288: impl_equipment_quantity = (Nvl(impl_equipment_quantity,0) + l_rev_equip_quantity),

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

12300: pa_debug.g_err_stage:= 'Updation of record is done for the CI';
12301: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12302: END IF;
12303:
12304: ELSE -- There is no record present in pa_fp_merged_ctrl_items for the ci_id
12305: IF l_debug_mode = 'Y' THEN
12306: pa_debug.g_err_stage:= 'Calling FP_CI_LINK_CONTROL_ITEMS for the CI which has been merged';
12307: pa_debug.write(l_module_name,pa_debug.g_err_stage,3);
12308: END IF;