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_CONTROL_ITEMS

Line 21: ,ci_id pa_control_items.ci_id%TYPE

17: --impl_cost_flag and impl_rev_flag will be either Y or N indicating whether the ci id can be implemented in
18: --the budget version id or not
19: TYPE budget_ci_map_rec IS RECORD
20: (budget_version_id pa_budget_versions.budget_version_id%TYPE
21: ,ci_id pa_control_items.ci_id%TYPE
22: ,impact_type_code VARCHAR2(10)
23: ,impl_cost_flag VARCHAR2(1)
24: ,impl_rev_flag VARCHAR2(1));
25:

Line 77: p_ci_id IN pa_control_items.ci_id%TYPE,

73: p_inclusion_method IN VARCHAR2,
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,

Line 2007: pa_control_items pci

2003: targetver.version_type)
2004: AND (sourcever.fin_plan_type_id=targetver.fin_plan_type_id OR
2005: EXISTS (SELECT 1
2006: FROM pa_pt_co_impl_statuses ptco,
2007: pa_control_items pci
2008: WHERE ptco.fin_plan_type_id=targetver.fin_plan_type_id
2009: AND pci.ci_id=pmc.ci_id
2010: AND ptco.ci_type_id=pci.ci_type_id
2011: AND ptco.version_type=pmc.version_type

Line 2137: pa_control_items pci

2133: targetver.version_type)
2134: AND (sourcever.fin_plan_type_id=targetver.fin_plan_type_id OR
2135: EXISTS (SELECT 1
2136: FROM pa_pt_co_impl_statuses ptco,
2137: pa_control_items pci
2138: WHERE ptco.fin_plan_type_id=targetver.fin_plan_type_id
2139: AND pci.ci_id=pmc.ci_id
2140: AND ptco.ci_type_id=pci.ci_type_id
2141: AND ptco.version_type=pmc.version_type

Line 2232: l_s_ci_id pa_control_items.ci_id%TYPE;

2228:
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

Line 2783: ,P_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented

2779: -- called as part of budget/forecast generation
2780:
2781: PROCEDURE implement_ci_into_single_ver(p_context IN VARCHAR2
2782: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- bug 3934574
2783: ,P_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
2784: ,P_ci_cost_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The cost budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
2785: ,P_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
2786: ,P_ci_all_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The all budget_version_id corresponding to the p_ci_id passed. This will be derived internally if not passed
2787: ,P_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented

Line 10424: l_ci_number pa_control_items.ci_number%TYPE;

10420: l_all_ci_ver_index NUMBER;
10421: l_index NUMBER:=0;
10422: l_implementable_impact VARCHAR2(10);
10423: l_dummy VARCHAR2(1);
10424: l_ci_number pa_control_items.ci_number%TYPE;
10425:
10426: l_cost_impl_flag VARCHAR2(1);
10427: l_rev_impl_flag VARCHAR2(1);
10428: l_cost_impact_impl_flag VARCHAR2(1);

Line 10776: FROM pa_control_items pci,

10772: SELECT pci.ci_number,
10773: pct.ci_type_class_code
10774: INTO l_ci_number,
10775: l_ci_type_class_code
10776: FROM pa_control_items pci,
10777: pa_ci_types_b pct
10778: WHERE pci.ci_id = p_ci_id_tbl(i)
10779: AND pci.ci_type_id=pct.ci_type_id;
10780:

Line 11468: FROM pa_control_items pci, pa_ci_types_tl cit

11464: (p_app_short_name => 'PA',
11465: p_msg_name => 'PA_FP_ALL_CO_REQ_FOR_VER');
11466:
11467: /*SELECT cit.name INTO l_ci_name
11468: FROM pa_control_items pci, pa_ci_types_tl cit
11469: WHERE pci.ci_id= x_ci_id_tbl(i)
11470: AND pci.ci_type_id=cit.ci_type_id
11471: AND cit.language=userenv('LANG');
11472:

Line 11719: PROCEDURE impl_ci_into_autobaseline_proj( p_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented

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: *--------------------------------------------------------------------------------------------------------*/
11718:
11719: PROCEDURE impl_ci_into_autobaseline_proj( p_ci_id IN Pa_control_items.ci_id%TYPE -- The Id of the chg doc that needs to be implemented
11720: ,p_ci_rev_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL -- The rev budget version id corresponding to the p_ci_id passed. This will be derived internally if not passed
11721: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- The Id of the budget version into which the CO needs to be implemented
11722: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
11723: ,p_partial_impl_rev_amt IN NUMBER DEFAULT NULL -- The revenue amount that should be implemented into the target. This will be passed only in the case of partial implementation

Line 13331: from pa_control_items where ci_id=ci_id_t)

13327: select 1 from pa_ci_types_b ci_id_to,
13328: pa_ci_types_b ci_id_from
13329: where ci_id_to.ci_type_id in(
13330: select ci_type_id
13331: from pa_control_items where ci_id=ci_id_t)
13332: and ci_id_from.ci_type_id in (
13333: select ci_type_id
13334: from pa_control_items where ci_id=ci_id_f )
13335: and ci_id_to.supp_cost_reg_flag='Y'

Line 13334: from pa_control_items where ci_id=ci_id_f )

13330: select ci_type_id
13331: from pa_control_items where ci_id=ci_id_t)
13332: and ci_id_from.ci_type_id in (
13333: select ci_type_id
13334: from pa_control_items where ci_id=ci_id_f )
13335: and ci_id_to.supp_cost_reg_flag='Y'
13336: and ci_id_from.supp_cost_reg_flag='Y' ;
13337:
13338: begin

Line 13363: from pa_control_items

13359:
13360:
13361: select ci_type_id
13362: into l_ci_type_id
13363: from pa_control_items
13364: where ci_id=p_ci_id_to ;
13365:
13366: -- Check if new suppler cost region exists in both the control items
13367:

Line 13730: from pa_control_items where ci_id=ci_id_t)

13726: select 1 from pa_ci_types_b ci_id_to,
13727: pa_ci_types_b ci_id_from
13728: where ci_id_to.ci_type_id in(
13729: select ci_type_id
13730: from pa_control_items where ci_id=ci_id_t)
13731: and ci_id_from.ci_type_id in (
13732: select ci_type_id
13733: from pa_control_items where ci_id=ci_id_f )
13734: and ci_id_to.dir_cost_reg_flag='Y'

Line 13733: from pa_control_items where ci_id=ci_id_f )

13729: select ci_type_id
13730: from pa_control_items where ci_id=ci_id_t)
13731: and ci_id_from.ci_type_id in (
13732: select ci_type_id
13733: from pa_control_items where ci_id=ci_id_f )
13734: and ci_id_to.dir_cost_reg_flag='Y'
13735: and ci_id_from.dir_cost_reg_flag='Y' ;
13736:
13737: begin